[postgis-users] PostGIS and Google Maps API examples?

[KAM Tin Seong]

Hi Jonathan, I wonder if you could share with me how to get Flash to read data in PostgreSQL directly.
 
Thanks in advance.
 
Tin Seong

________________________________

From: postgis-users-bounces at postgis.refractions.net on behalf of Jonathan Harahush
Sent: Tue 11/17/2009 7:16 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] PostGIS and Google Maps API examples?



Hi,

 

First off, this list is a great resource!  Thank you!

 

I am trying to create a store locator type of app using PostGIS and the Google Maps API for Flash.  Basically, I want the user to be able to search by radius - i.e., "how many stores are within 5 miles of my home?"  I know how to do the Flash portion of this (and I can populate my map by connecting to my PostgreSQL database), like setting up the menu to choose radius and the text box for address input, but I'm not sure how to handle the geoprocessing with PostGIS.  I would like PostGIS to perform the calculation, draw a polygon on my map, and also return all locations that are within the radius.  Any ideas on how I can get started?

 

One other thing I don't understand with regard to PostGIS --  my "stores" table is not really spatial data.  It's just a table of lat/longs, but it's not an imported Shapefile, etc.  I could make a shapefile and import it (and then have geometry data associated with each point), but I'm not sure if this is necessary.  

 

Like I said.. I'm not sure where to start AND I'm new to PostGIS.  If anyone has any good examples to look at or can point me in the right direction, I would really appreciate it.

 

Thanks!

 

 

Jonathan Harahush

GIS Analyst

 

Denver Regional Council of Governments

http://www.drcog.org <http://www.drcog.org/> 

(303) 480-6746

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20091117/fb1c1d92/attachment.html>