Hi Warren, GeoServer 2.1 allows you to set up a datastore that is backed by an arbitrary sql query. So you should be able to use the mysql datastore extension along with this to build a query that turns your lat/lon into a mysql point object.
http://docs.geoserver.org/stable/en/user/data/sqlview.html http://docs.geoserver.org/stable/en/user/data/mysql.html -Justin On Tue, Feb 22, 2011 at 2:32 PM, Warren Lerner <[email protected]> wrote: > List, > > I am attempting to retrieve the latitude/longitude from a MySQL database, > then use that information to display a marker on my map. I am having > difficulty with the PHP script to retrieve the data. I am also unsure of > how to display this on GeoServer. Once this is completed, I believe I will > have the makings of a poor mans GPS. > > Any hints, tips, suggestions, or links are appreciated. > > I would also like to thank the list members for all of their helpful hints > and advice. Ivan is especially helpful, so an extra shout out to him. > > Thank you. > > > ------------------------------------------------------------------------------ > Free Software Download: Index, Search & Analyze Logs and other IT data in > Real-Time with Splunk. Collect, index and harness all the fast moving IT > data > generated by your applications, servers and devices whether physical, > virtual > or in the cloud. Deliver compliance at lower cost and gain new business > insights. http://p.sf.net/sfu/splunk-dev2dev > _______________________________________________ > Geoserver-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/geoserver-users > > -- Justin Deoliveira OpenGeo - http://opengeo.org Enterprise support for open source geospatial.
------------------------------------------------------------------------------ Free Software Download: Index, Search & Analyze Logs and other IT data in Real-Time with Splunk. Collect, index and harness all the fast moving IT data generated by your applications, servers and devices whether physical, virtual or in the cloud. Deliver compliance at lower cost and gain new business insights. http://p.sf.net/sfu/splunk-dev2dev
_______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
