[OpenLayers-Users] which is the best way to display a set of points coming from database?

[Alberto Valente]

I understand.. I'm sure this solution is very good but unfortunately I MUST
(and I'm not happy of this) use an Oracle db and I haven't access to it
(cannot configure extensions, plugins, etc.).
So the only way for getting the coords is querying them with a SELECT
statement from a php page and arrange them in a format suitable by
OpenLayers.

Other suggestions?   ;-)

btw thank you Piero for your help.. it reminds me I'm not using the best
available tools.. :-(

alberto



On Tue, Aug 31, 2010 at 4:40 PM, Piero Campa <piero.campa at gmail.com> wrote:

>
> I've been working on something like 'display georeferenced point', and I
> did
> like that:
>
> - associate the X/Y coordinates with a geometry in the database (using
> PostGIS extension to a PostgreSQL database;
> - import the database in an istance of GeoServer (which can reproject your
> points in all the SRS you can think of, maybe this can be useful for your
> application),
> - let OL ask for the points (you can use filters also, e.g. spatial
> filters)
> via WFS protocol to GeoServer.
>
> Absolutely powerful, and simple.
> Piero
> --
> View this message in context:
> http://osgeo-org.1803224.n2.nabble.com/which-is-the-best-way-to-display-a-set-of-points-coming-from-database-tp5482933p5482958.html
> Sent from the OpenLayers Users mailing list archive at Nabble.com.
> _______________________________________________
> Users mailing list
> Users at openlayers.org
> http://openlayers.org/mailman/listinfo/users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/openlayers-users/attachments/20100901/cc04d7e7/attachment.html