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.).<br>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.<br>
<br>Other suggestions? ;-)<br><br>btw thank you Piero for your help.. it reminds me I'm not using the best available tools.. :-(<br><br>alberto<br><br><br><br><div class="gmail_quote">On Tue, Aug 31, 2010 at 4:40 PM, Piero Campa <span dir="ltr"><<a href="mailto:piero.campa@gmail.com">piero.campa@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;"><br>
I've been working on something like 'display georeferenced point', and I did<br>
like that:<br>
<br>
- associate the X/Y coordinates with a geometry in the database (using<br>
PostGIS extension to a PostgreSQL database;<br>
- import the database in an istance of GeoServer (which can reproject your<br>
points in all the SRS you can think of, maybe this can be useful for your<br>
application),<br>
- let OL ask for the points (you can use filters also, e.g. spatial filters)<br>
via WFS protocol to GeoServer.<br>
<br>
Absolutely powerful, and simple.<br>
Piero<br>
<font color="#888888">--<br>
View this message in context: <a href="http://osgeo-org.1803224.n2.nabble.com/which-is-the-best-way-to-display-a-set-of-points-coming-from-database-tp5482933p5482958.html" target="_blank">http://osgeo-org.1803224.n2.nabble.com/which-is-the-best-way-to-display-a-set-of-points-coming-from-database-tp5482933p5482958.html</a><br>
Sent from the OpenLayers Users mailing list archive at Nabble.com.<br>
_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@openlayers.org">Users@openlayers.org</a><br>
<a href="http://openlayers.org/mailman/listinfo/users" target="_blank">http://openlayers.org/mailman/listinfo/users</a><br>
</font></blockquote></div><br>