Hi,
I'm generating mapbox vector tiles from a multipolygon table with an
integer PK id in PostGIS. The vectortiles plugin is a snapshot from
26-Dec-2018.
The problem is that some features end up as multiple multipolygon
features in the pbf file geoserver sends. See below, the tpteksti and
tunnus fields are unique in the table(*). The integer PK id shows as
mvt_id in the ogrinfo dump.
Any ideas what could be wrong in my setup or is this a bug/feature in
the vector tile generating code?
Best regards,
Ari
(*) For you Finns possibly here, this is a processed estates table, not
the original, which has multiple records with same tpteksti.
piece of ogrinfo dump:
OGRFeature(estates_e):9
ktunnus (String) = 781
tpteksti (String) = 781-403-1-5
tunnus (String) = 78140300010005
MULTIPOLYGON (((1361.90909090909 4096.0,1415 4048,1232 3801,1188
3739,1164 3706,1130 3734,1145 3850,1154 3917,1119 3990,1066
4096,1361.90909090909 4096.0)))
OGRFeature(estates_e):10
ktunnus (String) = 781
tpteksti (String) = 781-403-1-5
tunnus (String) = 78140300010005
MULTIPOLYGON (((932 3454,717 3437,850 3575,976 3516,932 3454)))
OGRFeature(estates_e):11
mvt_id (Integer64) = 865649
ktunnus (String) = 781
tpteksti (String) = 781-403-1-7
tunnus (String) = 78140300010007
MULTIPOLYGON (((976 3516,1130 3734,1164 3706,971 3457,932 3454,976
3516)))
table schema:
Column | Type | Collation | Nullable
| Default
----------+-----------------------+-----------+----------+---------------------------------------
tpteksti | character varying(20) | | not null |
tunnus | character varying(20) | | |
ktunnus | character varying(3) | | |
geom | geometry | | |
id | integer | | not null |
nextval('estates_e_id_seq'::regclass)
the geometry type
ods=# select distinct st_geometrytype(geom)
ods-# from estates_e;
st_geometrytype
-----------------
ST_MultiPolygon
(1 row)
The uniqueness of the original feature:
ods=# select id,tpteksti from estates_e where tpteksti='781-403-1-5';
id | tpteksti
--------+-------------
865648 | 781-403-1-5
(1 row)
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
