If you get the coordinates in a url, you can extract them with a regular expression.
Instead of using Googlemaps, you could also consider using Openstreetmap data. Investigate the Overpass API. I think it does what you are trying to achieve. You get access to the raw data. The advantage is that if some of your POIs are not present yet, you can easily add them. All you have to do is credit OSM, if you decide to do that. Cheers, Jo 2012/12/28 nevillekb <[email protected]> > Hi Brent, > > So at the moment i am hard-coding sample lat and long values to test the > functionality and it works!!! > > What i wanted to ask is how can i get these values from Google maps and > then > feed them in my DB rather then hard-coding them. Any idea how to go about? > > Thanks, > > Neville. > > > > -- > View this message in context: > http://postgis.17.n6.nabble.com/Using-PostGIS-for-latitude-longitude-tp5002097p5002155.html > Sent from the PostGIS - User mailing list archive at Nabble.com. > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
