Hi all,
I have very big layer based on tables with about 10 millions of records. I
am trying to define a great sld to limit the number of record to be queried
at low zoom level, but there isn't a field with a good enough meaning.
I have found a great postgresql feature that was introduced in version 9.5,
it is tablesample that give us the ability to retrieve a percentage of
records in tables.
I would like to use this capabilities to show, for example, the 1% at low
zoom level, 10% at medium and 100% at high zoom level.
SELECT * FROM big_table TABLESAMPLE SYSTEM(10);
I am going mad to figure out how I can use sld with zoom level to set the
percentage.
Anyone could help me?
Matteo Cusmai
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
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
