[Geoserver-users] GeoServer & Many Points

GeoServer GeoServer User
1

Hi GeoServer Community,

My Question:
What is the best way to store and serve a large # (> 10000) of point
objects with different properties.

Background:
I am seeking design advice as to how to store and serve these points.
I am using GeoServer 1.6.5 and OpenLayers.
My Point objects are currently stored in a Postgres table.
The table is updated daily.

I have created a layer in OpenLayers using javascript from the result
of a postgres query but this is very slow when there are many points
as you can imagine.

I would also like to attach descriptors to the points so that the user
is able to click on it and get more info.
Another feature would be to change their size and colour based on a
value from the db.
Finally I want to attach different markers to each point based on bearing.

I was thinking of installing PostGis - and create a coverage in
GeoServer pointing to the PostGis db directly.

Any ideas or experiences are welcome.

Best Regards

James

2

Hi James,

So yeah, you definitely want to install postgis, and then store your points as spatial objects. You also want to create a spatial index on the geometry column. With a spatial index you should have no problem storing millions of points and displaying them very quickly.

Its also straight forward to achieve the click and get info functionality with openlayers and GeoServer. If you run Geoserver and check out the openlayers map preview, you will see how this works.

Hope that helps.

-Justin

James Cauchi wrote:

Hi GeoServer Community,

My Question:
What is the best way to store and serve a large # (> 10000) of point
objects with different properties.

Background:
I am seeking design advice as to how to store and serve these points.
I am using GeoServer 1.6.5 and OpenLayers.
My Point objects are currently stored in a Postgres table.
The table is updated daily.

I have created a layer in OpenLayers using javascript from the result
of a postgres query but this is very slow when there are many points
as you can imagine.

I would also like to attach descriptors to the points so that the user
is able to click on it and get more info.
Another feature would be to change their size and colour based on a
value from the db.
Finally I want to attach different markers to each point based on bearing.

I was thinking of installing PostGis - and create a coverage in
GeoServer pointing to the PostGis db directly.

Any ideas or experiences are welcome.

Best Regards

James

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

3

I have loaded up millions of points representing facilities, for multiple
program systems with differing attribute characteristics for each program
into PostGIS and served them through GeoServer, am very happy with the
results - agree, spatial indexing is crucial, you may also want to look at
database clustering.

David G. Smith PE PLS
Synergist Technology Group, Inc.
570.280.6763

- - - - - - - - - - - - - - - - - - - - - - - - -
NOTE: New cell phone number:
570-280-6763
- - - - - - - - - - - - - - - - - - - - - - - - -

-----Original Message-----
From: Justin Deoliveira [mailto:jdeolive@anonymised.com]
Sent: Sunday, October 26, 2008 1:45 PM
To: James Cauchi
Cc: geoserver-users@lists.sourceforge.net
Subject: Re: [Geoserver-users] GeoServer & Many Points

Hi James,

So yeah, you definitely want to install postgis, and then store your
points as spatial objects. You also want to create a spatial index on
the geometry column. With a spatial index you should have no problem
storing millions of points and displaying them very quickly.

Its also straight forward to achieve the click and get info
functionality with openlayers and GeoServer. If you run Geoserver and
check out the openlayers map preview, you will see how this works.

Hope that helps.

-Justin

James Cauchi wrote:

Hi GeoServer Community,

My Question:
What is the best way to store and serve a large # (> 10000) of point
objects with different properties.

Background:
I am seeking design advice as to how to store and serve these points.
I am using GeoServer 1.6.5 and OpenLayers.
My Point objects are currently stored in a Postgres table.
The table is updated daily.

I have created a layer in OpenLayers using javascript from the result
of a postgres query but this is very slow when there are many points
as you can imagine.

I would also like to attach descriptors to the points so that the user
is able to click on it and get more info.
Another feature would be to change their size and colour based on a
value from the db.
Finally I want to attach different markers to each point based on bearing.

I was thinking of installing PostGis - and create a coverage in
GeoServer pointing to the PostGis db directly.

Any ideas or experiences are welcome.

Best Regards

James

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's

challenge

Build the coolest Linux based applications with Moblin SDK & win great

prizes

Grand prize is a trip for two to an Open Source event anywhere in the

world

http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

--
Justin Deoliveira
OpenGeo - http://opengeo.org
Enterprise support for open source geospatial.

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great
prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users

4

James Cauchi ha scritto:

Hi GeoServer Community,

My Question:
What is the best way to store and serve a large # (> 10000) of point
objects with different properties.

Background:
I am seeking design advice as to how to store and serve these points.
I am using GeoServer 1.6.5 and OpenLayers.
My Point objects are currently stored in a Postgres table.
The table is updated daily.

I have created a layer in OpenLayers using javascript from the result
of a postgres query but this is very slow when there are many points
as you can imagine.

If you are using a OL vector layer I'm not surprised, dealing with
vector entities in javascript does not seem to scale that well.
Use WMS to render the data, and GetFeatureInfo to create the popups
instead, that should scale well.

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.

5

Hi Geoserver Community,

thanks so much for the excellent response.

I have used PostGis and the points load up well quick.

Looking at spacial indexing and point and GetFeatureInfo now.

thanks a lot guys!

James

2008/10/27 Andrea Aime <aaime@anonymised.com>:

James Cauchi ha scritto:

Hi GeoServer Community,

My Question:
What is the best way to store and serve a large # (> 10000) of point
objects with different properties.

Background:
I am seeking design advice as to how to store and serve these points.
I am using GeoServer 1.6.5 and OpenLayers.
My Point objects are currently stored in a Postgres table.
The table is updated daily.

I have created a layer in OpenLayers using javascript from the result
of a postgres query but this is very slow when there are many points
as you can imagine.

If you are using a OL vector layer I'm not surprised, dealing with
vector entities in javascript does not seem to scale that well.
Use WMS to render the data, and GetFeatureInfo to create the popups
instead, that should scale well.

Cheers
Andrea

--
Andrea Aime
OpenGeo - http://opengeo.org
Expert service straight from the developers.