[postgis-users] Using PostGIS for latitude & longitude

[Jo]

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 <nevillekb at gmail.com>

> 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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20121228/857870fd/attachment.html>