<HTML dir=ltr><HEAD>
<META content="text/html; charset=unicode" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18852">
<STYLE>
<!--
font-face
{font-family:Wingdings;}
font-face
{font-family:Wingdings;}
font-face
{font-family:Calibri;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{
color:purple;
text-decoration:underline;}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle17
{
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{}
div.Section1
{page:Section1;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
-->
</STYLE>
</HEAD>
<BODY lang=EN-US link=blue vLink=purple>
<DIV dir=ltr id=idOWAReplyText721>
<DIV dir=ltr><FONT color=#000000 size=2 face=Arial>Hi Jonathan, I wonder if you could share with me how to get Flash to read data in PostgreSQL directly.</FONT></DIV>
<DIV dir=ltr><FONT size=2 face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT size=2 face=Arial>Thanks in advance.</FONT></DIV>
<DIV dir=ltr><FONT size=2 face=Arial></FONT> </DIV>
<DIV dir=ltr><FONT size=2 face=Arial>Tin Seong</FONT></DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B> postgis-users-bounces@postgis.refractions.net on behalf of Jonathan Harahush<BR><B>Sent:</B> Tue 11/17/2009 7:16 AM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B> [postgis-users] PostGIS and Google Maps API examples?<BR></FONT><BR></DIV>
<DIV>
<DIV class=Section1>
<P class=MsoNormal>Hi,</P>
<P class=MsoNormal> </P>
<P class=MsoNormal>First off, this list is a great resource! Thank you!</P>
<P class=MsoNormal> </P>
<P class=MsoNormal>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?</P>
<P class=MsoNormal> </P>
<P class=MsoNormal>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. </P>
<P class=MsoNormal> </P>
<P class=MsoNormal>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.</P>
<P class=MsoNormal> </P>
<P class=MsoNormal>Thanks!</P>
<P class=MsoNormal> </P>
<P class=MsoNormal> </P>
<P class=MsoNormal><B><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; COLOR: maroon; FONT-SIZE: 10pt">Jonathan Harahush</SPAN></B><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt">GIS Analyst</SPAN><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"></SPAN> </P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt">Denver Regional Council of Governments</SPAN><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt"><A href="http://www.drcog.org/"><SPAN style="COLOR: blue">http://www.drcog.org</SPAN></A></SPAN><SPAN style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"></SPAN></P>
<P class=MsoNormal><SPAN style="FONT-FAMILY: 'Arial','sans-serif'; FONT-SIZE: 10pt">(303) 480-6746</SPAN></P></DIV></DIV></BODY></HTML>