Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Sample GPKG isn't actually valid #31

Open
jyutzler opened this issue Feb 7, 2017 · 1 comment
Open

Sample GPKG isn't actually valid #31

jyutzler opened this issue Feb 7, 2017 · 1 comment

Comments

@jyutzler
Copy link

jyutzler commented Feb 7, 2017

I pulled open https://github.com/opengeospatial/ets-gpkg10/blob/master/src/test/resources/gpkg/simple_sewer_features.gpkg
It does not pass /opt/features/vector_features/data/feature_table_integer_primary_key
The NOTNULL column for the primary key is supposed to be 1 but it is 0.

@jyutzler
Copy link
Author

jyutzler commented Feb 9, 2017

Another error: Requirement 25 calls for the geometry_type_name in gpkg_geometry_columns to be upper case but in the sample file they are lower case ("point", "multilinestring").

Another error: Requirement 31 calls for the geometry_type_name in gpkg_geometry_columns to match the actual geometry type in the user-defined table. The tables have type GEOMETRY where the rows say either "multilinestring" or "point".

SELECT * FROM 'gpkg_geometry_columns'
geometry_type_name	table_name	m	z	srs_id	column_name
point	s_manhole	2	2	27700	the_geom
multilinestring	foul_sewer	2	2	27700	the_geom
multilinestring	surface_water_sewer	2	2	27700	the_geom
pragma table_info(s_manhole)
cid	name	type	notnull	dflt_value	pk
0	id	INTEGER	0	null	1
1	the_geom	GEOMETRY	0	null	0
2	feature_id	TEXT	0	null	0
3	targetfeat	TEXT	0	null	0
4	function	TEXT	0	null	0
5	date_constructed	INTEGER	0	null	0
6	cover_level	INTEGER	0	null	0
7	conf_factor	TEXT	0	null	0
8	cover_type	TEXT	0	null	0
9	venting	TEXT	0	null	0
10	ipid	INTEGER	0	null	0
11	ownership	TEXT	0	null	0
gpkg_geometry_columns (3 rows)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant