Ok,

I'm making a map displaying COVID-19 data for the US at state and county
levels. I was able to get data to render slowly in mapbox using Geoservers
mapbox vt plug in. I'm wondering if there is a better way to do it.

Right now I have daily data stored in a Postgresql database with geometry.
What are the best practices for publishing data of that scale? Should I
just load the JSON and add data to that through an API?

On Sat, May 23, 2020, 11:51 AM Andrea Aime <[email protected]>
wrote:

> If the data is small enough, maybe? But mind, the OGC "Vector Tiles Pilot
> 2" had as one of its central
> focuses, being able to run filters on the OGC API - Tiles. And
> specifically, for vector tiles.
> So, not as odd as you might think, but a controversial topic for sure.
>
> I wrote the engineering report for that, you'll be able to read it soon,
> as it's made publicly available (it's not, yet).
>
> Cheers
> Andrea
>
> On Sat, May 23, 2020 at 6:48 PM Jody Garnett <[email protected]>
> wrote:
>
>> Would it not make more sense to include all the data in the static vector
>> tile, so that the dynamic filtering could be done client side?
>>
>> On Fri, May 22, 2020 at 1:31 PM David Haynes <[email protected]> wrote:
>>
>>> How do you format those CQL parameters
>>>
>>> This is what I used previously for WMS
>>> cql_filter=month=3%20and%20day=3
>>>
>>> If I am using temporal data should I use the time dimension instead?
>>>
>>> On Sat, Apr 18, 2020 at 7:12 AM Andrea Aime <
>>> [email protected]> wrote:
>>>
>>>> Hi David,
>>>> I haven't tried, but believe it's not possible, the vector tile output
>>>> format does not seem to take
>>>> care of that parameter (by a quick check in the code).
>>>> When it was first donated, it did not even account for CQL_FILTER, we
>>>> had to add it later...
>>>>
>>>> Pull requests welcomed to add support for that parameter :-)
>>>>
>>>> Cheers
>>>> Andrea
>>>>
>>>>
>>>> On Fri, Apr 17, 2020 at 10:00 PM David Haynes <[email protected]>
>>>> wrote:
>>>>
>>>>> Thanks,
>>>>>
>>>>> Is it possible to pass parameters to vector tiles? I would like to
>>>>> create a timeseries vector tile layer.
>>>>> viewparams=p1:v1;p2:v
>>>>>
>>>>> On Thu, Apr 16, 2020 at 2:36 AM Andrea Aime <
>>>>> [email protected]> wrote:
>>>>>
>>>>>> HI David,
>>>>>> the GWC preview can show vector tiles, and it's based on OpenLayers,
>>>>>> so you can probably steal some idea there.
>>>>>> You can find it in the "tile layers" menu entry.
>>>>>>
>>>>>> Cheers
>>>>>> Andrea
>>>>>>
>>>>>>
>>>>>> On Thu, Apr 16, 2020 at 5:11 AM David Haynes <[email protected]>
>>>>>> wrote:
>>>>>>
>>>>>>> Hello,
>>>>>>>
>>>>>>> I'm having an issue calling a Vector Tile layer into my map. I went
>>>>>>> through the tutorial here and was able to successfully get a layer on my
>>>>>>> geoserver install to view.
>>>>>>>
>>>>>>> https://docs.geoserver.org/latest/en/user/extensions/vectortiles/tutorial.html
>>>>>>>
>>>>>>>
>>>>>>> Yet when I am trying to do the call in openlayers I can't get it to
>>>>>>> render.
>>>>>>> My layer is in a workspace 'COVID'
>>>>>>>
>>>>>>>     new VectorTileLayer({
>>>>>>> declutter: true,
>>>>>>> source: new VectorTileSource({
>>>>>>> tilePixelRatio: 1, // oversampling when > 1
>>>>>>> tileGrid: createXYZ({ maxZoom: 19 }),
>>>>>>> format: new MVT(),
>>>>>>> url: 'http://XXXXXXX:8080/geoserver/gwc/service/tms/1.0.0/' +
>>>>>>> covidLayer +
>>>>>>>             '@EPSG%3A'+mapProj+'@pbf/{z}/{x}/{-y}.pbf'
>>>>>>>
>>>>>>> _______________________________________________
>>>>>>> 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]
>>>>>>> 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
>>>>>> <https://www.google.com/maps/search/Via+di+Montramito+3%2FA%0D%0A55054++Massarosa?entry=gmail&source=g>
>>>>>> (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
>>>> <https://www.google.com/maps/search/Via+di+Montramito+3%2FA%0D%0A55054++Massarosa?entry=gmail&source=g>
>>>> (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
>>>
>>>
>>> [email protected]
>>> https://lists.sourceforge.net/lists/listinfo/geoserver-users
>>>
>> --
>> --
>> Jody Garnett
>>
>
>
> --
>
> 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


[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to