Hi Ari,
I don't know honestly, but wondering about what snapshot you're
using? Is it from the master branch?
That's where most of the recent MVT changes landed, some of
which were related to ids.
Cheers
Andrea
On Thu, Jan 3, 2019 at 7:05 AM Ari Jolma <[email protected]
<mailto:[email protected]>> wrote:
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
[email protected]
<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/geoserver-users
--
Regards, Andrea Aime == GeoServer Professional Services from the
experts! Visit http://goo.gl/it488V for more information. ==
Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via
di Montramito 3/A 55054 Massarosa (LU) phone: +39 0584 962313
fax: +39 0584 1660272 mob: +39 339 8844549
http://www.geo-solutions.it http://twitter.com/geosolutions_it
------------------------------------------------------- /Con
riferimento alla normativa sul trattamento dei dati personali
(Reg. UE 2016/679 - Regolamento generale sulla protezione dei
dati “GDPR”), si precisa che ogni circostanza inerente alla
presente email (il suo contenuto, gli eventuali allegati, etc.)
è un dato la cui conoscenza è riservata al/i solo/i
destinatario/i indicati dallo scrivente. Se il messaggio Le è
giunto per errore, è tenuta/o a cancellarlo, ogni altra
operazione è illecita. Le sarei comunque grato se potesse
darmene notizia. This email is intended only for the person or
entity to which it is addressed and may contain information that
is privileged, confidential or otherwise protected from
disclosure. We remind that - as provided by European Regulation
2016/679 “GDPR” - copying, dissemination or use of this e-mail
or the information herein by anyone other than the intended
recipient is prohibited. If you have received this email by
mistake, please notify us immediately by telephone or e-mail./