As a side-note, I've been testing tilestrata-postgismvt (node/PostGIS ST_AsMVT solution) for this dataset too. It worked well from the beginning except for some problems(*), which were solved in practise by switching to tile resolution of 4096 that Geoserver uses instead of resolution of 256.

Ari

(*) https://trac.osgeo.org/postgis/ticket/4289

Andrea Aime kirjoitti 10.1.2019 klo 10.55:
Thanks for checking, I've made a PR (for a change, it's a one liner!)

https://github.com/geoserver/geoserver/pull/3315

Cheers
Andrea


On Thu, Jan 10, 2019 at 9:17 AM Ari Jolma <ari.jo...@gmail.com <mailto:ari.jo...@gmail.com>> wrote:

    To close this issue. The link below was the solution.
    java-vector-tile must be upgraded to version 1.3.4.

    Thanks Andrea,

    Ari

    Andrea Aime kirjoitti 9.1.2019 klo 19.14:
    Hi,
    if you are looking into it, I'd check both the MVT code in
    GeoServer, which is
    mostly generic and shared among MVT, TopoJSON and GeoJSON tiles
    (had a quick look, cannot see splitting of multipolygon over
    multiple features)
    and the actual MVT encoder, which is an external library:

    https://github.com/ElectronicChartCentre/java-vector-tile

    Hum... wait:
    https://github.com/ElectronicChartCentre/java-vector-tile/issues/18
    GeoServer is using version 1.3.3, so maybe it's just a matter of
    upgrading the dependency. I'd open a Jira ticket.

    Cheers
    Andrea





    On Wed, Jan 9, 2019 at 9:13 AM Ari Jolma <ari.jo...@gmail.com
    <mailto:ari.jo...@gmail.com>> wrote:

        Doh, MVT does support multipolygons. However, the vectortiles
        plugin does in this case split the multipolygons into single
        ring multipolygons. Maybe it is an issue of winding order of
        the rings - which MVT spec says in VERY importabt? I need to
        investigate.

        Ari

        Ari Jolma kirjoitti 9.1.2019 klo 10.05:

        Could the explanation be that while MVT vector tiles support
        only POLYGONs and because these are MULTIPOLYGONs, which
        occasionally split into multiple polygons, then the mvt_id
        is only occasionally set?

        The splitting is done by the vectortiles plugin.

        Ari

        Andrea Aime kirjoitti 8.1.2019 klo 13.41:
        Ah ok,
        so it's the latest. I'd open a bug report then, with a db
        dump (small, enough to reproduce the issue)

        Cheers
        Andrea

        On Tue, Jan 8, 2019 at 12:37 PM Ari Jolma
        <ari.jo...@gmail.com <mailto:ari.jo...@gmail.com>> wrote:

            Hi Andrea,

            The snapshots are downloaded from
            http://geoserver.org/release/dev/ December 26,
            filenames are

            geoserver-2.15-SNAPSHOT-vectortiles-plugin.zip and
            geoserver-master-2018-12-26-bin.zip

            The issue is with using the vector tiles with MapBox
            JS, they work fine with OpenLayers.

            Best,

            Ari

            Andrea Aime kirjoitti 8.1.2019 klo 12.28:
            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
            <ari.jo...@gmail.com <mailto:ari.jo...@gmail.com>> 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


                Geoserver-users@lists.sourceforge.net
                <mailto:Geoserver-users@lists.sourceforge.net>
                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./



--
        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./



--
    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./



--

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./

_______________________________________________
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

Reply via email to