[Geoserver-users] regionating with 1.7.3

GeoServer GeoServer User
1

newbie question :

is it posssible to regionating shapefile output ?
or do i have to store data in postgis ?
thanks

Sébastien.

2

Regionating does work with shapefiles. However, if your data set is
large enough that it slows down Google Earth without regionating, then
you should consider PostGIS for performance reasons anyway.

Hope this helps.

--
David Winslow
OpenGeo - http://opengeo.org/

On Fri, 2009-03-20 at 15:00 +0100, Sébastien Geindre wrote:

newbie question :

is it posssible to regionating shapefile output ?
or do i have to store data in postgis ?
thanks

Sébastien.

------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

3

Sure it helps ! thanks.

So, i transfered my 10000 points in postgis datastore.
Now, i want to configure regionation strategies...

geometry is for line and polygons..so i forget it.
should i use native-sorting ? or random ?

if i use kml regionating attribute, how ill it be sorted ? ascendant ?

KML feature limit is compatible with regionation ???

i've read that doc : http://geoserver.org/display/GEOSDOC/08-KML+Regionation but it is not so clear..

in fact, i would like regionation strategies that show uniform layer of point.....and more and more points when zooming...but still uniform...random does not seem to do that...

thanks

David Winslow a écrit :

Regionating does work with shapefiles. However, if your data set is
large enough that it slows down Google Earth without regionating, then
you should consider PostGIS for performance reasons anyway.

Hope this helps.

--
David Winslow
OpenGeo - http://opengeo.org/

On Fri, 2009-03-20 at 15:00 +0100, Sébastien Geindre wrote:
  

newbie question :

is it posssible to regionating shapefile output ?
or do i have to store data in postgis ?
thanks

Sébastien.

------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
    

4

You should use external sorting, which means it's done by Postgis. It sorts in descending order.

The KML feature limit is the number of features per "tile".

Random should give you a pretty even distribution. If it does not, you can create a column with random values (generate in Postgres), and sort according to those.

-Arne

ps. make sure you have a spatial index on the geometry column

Sébastien Geindre wrote:

Sure it helps ! thanks.

So, i transfered my 10000 points in postgis datastore.
Now, i want to configure regionation strategies...

geometry is for line and polygons..so i forget it.
should i use native-sorting ? or random ?

if i use kml regionating attribute, how ill it be sorted ? ascendant ?

KML feature limit is compatible with regionation ???

i've read that doc : http://geoserver.org/display/GEOSDOC/08-KML+Regionation but it is not so clear..

in fact, i would like regionation strategies that show uniform layer of point.....and more and more points when zooming...but still uniform...random does not seem to do that...

thanks

David Winslow a écrit :
  

Regionating does work with shapefiles. However, if your data set is
large enough that it slows down Google Earth without regionating, then
you should consider PostGIS for performance reasons anyway.

Hope this helps.

--
David Winslow
OpenGeo - http://opengeo.org/

On Fri, 2009-03-20 at 15:00 +0100, Sébastien Geindre wrote:
  

newbie question :

is it posssible to regionating shapefile output ?
or do i have to store data in postgis ?
thanks

Sébastien.

------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
    
------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
  
--
Arne Kepp
OpenGeo - http://opengeo.org
Expert service straight from the developers

5

Thanks, but i still have pb in distribution. http://sgeindre.ouvaton.org/geoserver/puit.jpg
Random on my 10000 point give me a strange distribution, i will try adding a random column..

I tried with 3260 lines of polygon in postgis, configuration of fetureType :
<featureType datastore = "postgis" >
...
  <cacheinfo enabled = "false" maxage = "" />
  <searchable enabled = "false" />
  <regionateAttribute value = "the_geom" />
  <regionateStrategy value = "geometry" />
  <regionateFeatureLimit value = "20" />
  <maxFeatures>0</maxFeatures>
</featureType>

And the distribution is very weird.. http://sgeindre.ouvaton.org/geoserver/pirl.jpg
it is ditributed along some kind of lines...
should geoserver take the biggest polygon first ?

thanks again.

Arne Kepp a écrit :

You should use external sorting, which means it's done by Postgis. It sorts in descending order.

The KML feature limit is the number of features per "tile".

Random should give you a pretty even distribution. If it does not, you can create a column with random values (generate in Postgres), and sort according to those.

-Arne

ps. make sure you have a spatial index on the geometry column

Sébastien Geindre wrote:

Sure it helps ! thanks.

So, i transfered my 10000 points in postgis datastore.
Now, i want to configure regionation strategies...

geometry is for line and polygons..so i forget it.
should i use native-sorting ? or random ?

if i use kml regionating attribute, how ill it be sorted ? ascendant ?

KML feature limit is compatible with regionation ???

i've read that doc : http://geoserver.org/display/GEOSDOC/08-KML+Regionation but it is not so clear..

in fact, i would like regionation strategies that show uniform layer of point.....and more and more points when zooming...but still uniform...random does not seem to do that...

thanks

David Winslow a écrit :

Regionating does work with shapefiles. However, if your data set is
large enough that it slows down Google Earth without regionating, then
you should consider PostGIS for performance reasons anyway.

Hope this helps.

--
David Winslow
OpenGeo - http://opengeo.org/

On Fri, 2009-03-20 at 15:00 +0100, Sébastien Geindre wrote:
     

newbie question :

is it posssible to regionating shapefile output ?
or do i have to store data in postgis ?
thanks

Sébastien.

------------------------------------------------------------------------------

Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
          
------------------------------------------------------------------------------

Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
  

6

It seems that the geospatial index did not rely on good statistics.
now it seems to be better...

http://sgeindre.ouvaton.org/geoserver/pirl+puit.jpg

still a bit strange distribution for the point (red icons)...
<featureType datastore = "postgis" >
  <name>puits</name>
  ....
  <styles default = "point" />
  <cacheinfo enabled = "false" maxage = "" />
  <searchable enabled = "false" />
  <regionateAttribute value = "null" />
  <regionateStrategy value = "random" />
  <regionateFeatureLimit value = "20" />
  <maxFeatures>0</maxFeatures>
</featureType>
Sébastien Geindre a écrit :

Thanks, but i still have pb in distribution. http://sgeindre.ouvaton.org/geoserver/puit.jpg
Random on my 10000 point give me a strange distribution, i will try adding a random column..

I tried with 3260 lines of polygon in postgis, configuration of fetureType :
<featureType datastore = "postgis" >
...
  <cacheinfo enabled = "false" maxage = "" />
  <searchable enabled = "false" />
  <regionateAttribute value = "the_geom" />
  <regionateStrategy value = "geometry" />
  <regionateFeatureLimit value = "20" />
  <maxFeatures>0</maxFeatures>
</featureType>

And the distribution is very weird.. http://sgeindre.ouvaton.org/geoserver/pirl.jpg
it is ditributed along some kind of lines...
should geoserver take the biggest polygon first ?

thanks again.

Arne Kepp a écrit :
  

You should use external sorting, which means it's done by Postgis. It sorts in descending order.

The KML feature limit is the number of features per "tile".

Random should give you a pretty even distribution. If it does not, you can create a column with random values (generate in Postgres), and sort according to those.

-Arne

ps. make sure you have a spatial index on the geometry column

Sébastien Geindre wrote:
    

Sure it helps ! thanks.

So, i transfered my 10000 points in postgis datastore.
Now, i want to configure regionation strategies...

geometry is for line and polygons..so i forget it.
should i use native-sorting ? or random ?

if i use kml regionating attribute, how ill it be sorted ? ascendant ?

KML feature limit is compatible with regionation ???

i've read that doc : http://geoserver.org/display/GEOSDOC/08-KML+Regionation but it is not so clear..

in fact, i would like regionation strategies that show uniform layer of point.....and more and more points when zooming...but still uniform...random does not seem to do that...

thanks

David Winslow a écrit :

Regionating does work with shapefiles. However, if your data set is
large enough that it slows down Google Earth without regionating, then
you should consider PostGIS for performance reasons anyway.

Hope this helps.

--
David Winslow
OpenGeo - http://opengeo.org/

On Fri, 2009-03-20 at 15:00 +0100, Sébastien Geindre wrote:
     

newbie question :

is it posssible to regionating shapefile output ?
or do i have to store data in postgis ?
thanks

Sébastien.

------------------------------------------------------------------------------

Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
          

------------------------------------------------------------------------------

Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
  
------------------------------------------------------------------------------
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
  

7

Your configuration says you are sorting on the geometry, in descending size. Maybe the geometries are of similar size, or there are lots of them in that space?

Random is a bit of a misnomer in this case, it really means "without ORDER BY". Your database probably uses the geometry index to output them "randomly", so every tile gets filled up from west to east until its full. Adding a random column will fix that, dont forget to create an index on it.

-Arne

Sébastien Geindre wrote:

Thanks, but i still have pb in distribution. http://sgeindre.ouvaton.org/geoserver/puit.jpg
Random on my 10000 point give me a strange distribution, i will try adding a random column..

I tried with 3260 lines of polygon in postgis, configuration of fetureType :
<featureType datastore = "postgis" >
...
<cacheinfo enabled = "false" maxage = "" />
<searchable enabled = "false" />
<regionateAttribute value = "the_geom" />
<regionateStrategy value = "geometry" />
<regionateFeatureLimit value = "20" />
<maxFeatures>0</maxFeatures>
</featureType>

And the distribution is very weird.. http://sgeindre.ouvaton.org/geoserver/pirl.jpg
it is ditributed along some kind of lines...
should geoserver take the biggest polygon first ?

thanks again.

Arne Kepp a écrit :

You should use external sorting, which means it's done by Postgis. It sorts in descending order.

The KML feature limit is the number of features per "tile".

Random should give you a pretty even distribution. If it does not, you can create a column with random values (generate in Postgres), and sort according to those.

-Arne

ps. make sure you have a spatial index on the geometry column

Sébastien Geindre wrote:

Sure it helps ! thanks.

So, i transfered my 10000 points in postgis datastore.
Now, i want to configure regionation strategies...

geometry is for line and polygons..so i forget it.
should i use native-sorting ? or random ?

if i use kml regionating attribute, how ill it be sorted ? ascendant ?

KML feature limit is compatible with regionation ???

i've read that doc : http://geoserver.org/display/GEOSDOC/08-KML+Regionation but it is not so clear..

in fact, i would like regionation strategies that show uniform layer of point.....and more and more points when zooming...but still uniform...random does not seem to do that...

thanks

David Winslow a écrit :

Regionating does work with shapefiles. However, if your data set is
large enough that it slows down Google Earth without regionating, then
you should consider PostGIS for performance reasons anyway.

Hope this helps.

--
David Winslow
OpenGeo - http://opengeo.org/

On Fri, 2009-03-20 at 15:00 +0100, Sébastien Geindre wrote:
    

newbie question :

is it posssible to regionating shapefile output ?
or do i have to store data in postgis ?
thanks

Sébastien.

------------------------------------------------------------------------------

Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
          
------------------------------------------------------------------------------

Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
  
--
Arne Kepp
OpenGeo - http://opengeo.org
Expert service straight from the developers

8

Arne Kepp a écrit :

Your configuration says you are sorting on the geometry, in descending size. Maybe the geometries are of similar size, or there are lots of them in that space?

descending means from the biggest to the smallest...??
"Maybe the geometries are of similar size" : not really, they are big polygon an small one..

KML feature limit does not seems to work...
should i clean cache ? on GE ? geoserver ?

Random is a bit of a misnomer in this case, it really means "without ORDER BY". Your database probably uses the geometry index to output them "randomly", so every tile gets filled up from west to east until its full. Adding a random column will fix that, dont forget to create an index on it.

-Arne

Sébastien Geindre wrote:

Thanks, but i still have pb in distribution. http://sgeindre.ouvaton.org/geoserver/puit.jpg
Random on my 10000 point give me a strange distribution, i will try adding a random column..

I tried with 3260 lines of polygon in postgis, configuration of fetureType :
<featureType datastore = "postgis" >
...
<cacheinfo enabled = "false" maxage = "" />
<searchable enabled = "false" />
<regionateAttribute value = "the_geom" />
<regionateStrategy value = "geometry" />
<regionateFeatureLimit value = "20" />
<maxFeatures>0</maxFeatures>
</featureType>

And the distribution is very weird.. http://sgeindre.ouvaton.org/geoserver/pirl.jpg
it is ditributed along some kind of lines...
should geoserver take the biggest polygon first ?

thanks again.

Arne Kepp a écrit :

You should use external sorting, which means it's done by Postgis. It sorts in descending order.

The KML feature limit is the number of features per "tile".

Random should give you a pretty even distribution. If it does not, you can create a column with random values (generate in Postgres), and sort according to those.

-Arne

ps. make sure you have a spatial index on the geometry column

Sébastien Geindre wrote:

Sure it helps ! thanks.

So, i transfered my 10000 points in postgis datastore.
Now, i want to configure regionation strategies...

geometry is for line and polygons..so i forget it.
should i use native-sorting ? or random ?

if i use kml regionating attribute, how ill it be sorted ? ascendant ?

KML feature limit is compatible with regionation ???

i've read that doc : http://geoserver.org/display/GEOSDOC/08-KML+Regionation but it is not so clear..

in fact, i would like regionation strategies that show uniform layer of point.....and more and more points when zooming...but still uniform...random does not seem to do that...

thanks

David Winslow a écrit :

Regionating does work with shapefiles. However, if your data set is
large enough that it slows down Google Earth without regionating, then
you should consider PostGIS for performance reasons anyway.

Hope this helps.

--
David Winslow
OpenGeo - http://opengeo.org/

On Fri, 2009-03-20 at 15:00 +0100, Sébastien Geindre wrote:
   

newbie question :

is it posssible to regionating shapefile output ?
or do i have to store data in postgis ?
thanks

Sébastien.

------------------------------------------------------------------------------

Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
          
------------------------------------------------------------------------------

Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
  

9

Definitely in GE, if you want to do the same for GS to be sure you can stop GS and delete <data dir>/geosearch

-Arne

Sébastien Geindre wrote:

Arne Kepp a écrit :

Your configuration says you are sorting on the geometry, in descending size. Maybe the geometries are of similar size, or there are lots of them in that space?

descending means from the biggest to the smallest...??
"Maybe the geometries are of similar size" : not really, they are big polygon an small one..

KML feature limit does not seems to work...
should i clean cache ? on GE ? geoserver ?

Random is a bit of a misnomer in this case, it really means "without ORDER BY". Your database probably uses the geometry index to output them "randomly", so every tile gets filled up from west to east until its full. Adding a random column will fix that, dont forget to create an index on it.

-Arne

Sébastien Geindre wrote:

Thanks, but i still have pb in distribution. http://sgeindre.ouvaton.org/geoserver/puit.jpg
Random on my 10000 point give me a strange distribution, i will try adding a random column..

I tried with 3260 lines of polygon in postgis, configuration of fetureType :
<featureType datastore = "postgis" >
...
<cacheinfo enabled = "false" maxage = "" />
<searchable enabled = "false" />
<regionateAttribute value = "the_geom" />
<regionateStrategy value = "geometry" />
<regionateFeatureLimit value = "20" />
<maxFeatures>0</maxFeatures>
</featureType>

And the distribution is very weird.. http://sgeindre.ouvaton.org/geoserver/pirl.jpg
it is ditributed along some kind of lines...
should geoserver take the biggest polygon first ?

thanks again.

Arne Kepp a écrit :

You should use external sorting, which means it's done by Postgis. It sorts in descending order.

The KML feature limit is the number of features per "tile".

Random should give you a pretty even distribution. If it does not, you can create a column with random values (generate in Postgres), and sort according to those.

-Arne

ps. make sure you have a spatial index on the geometry column

Sébastien Geindre wrote:

Sure it helps ! thanks.

So, i transfered my 10000 points in postgis datastore.
Now, i want to configure regionation strategies...

geometry is for line and polygons..so i forget it.
should i use native-sorting ? or random ?

if i use kml regionating attribute, how ill it be sorted ? ascendant ?

KML feature limit is compatible with regionation ???

i've read that doc : http://geoserver.org/display/GEOSDOC/08-KML+Regionation but it is not so clear..

in fact, i would like regionation strategies that show uniform layer of point.....and more and more points when zooming...but still uniform...random does not seem to do that...

thanks

David Winslow a écrit :

Regionating does work with shapefiles. However, if your data set is
large enough that it slows down Google Earth without regionating, then
you should consider PostGIS for performance reasons anyway.

Hope this helps.

--
David Winslow
OpenGeo - http://opengeo.org/

On Fri, 2009-03-20 at 15:00 +0100, Sébastien Geindre wrote:
  

newbie question :

is it posssible to regionating shapefile output ?
or do i have to store data in postgis ?
thanks

Sébastien.

------------------------------------------------------------------------------

Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
          
------------------------------------------------------------------------------

Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
  
--
Arne Kepp
OpenGeo - http://opengeo.org
Expert service straight from the developers