Have you looked at the Spatial extensions for SQL Server? https://msdn.microsoft.com/en-us/library/bb933790.aspx?f=255&MSPPError=-2147217396
That should take care of all the querying once you get the shape/polygon from Google Maps API. Plat uses lat+lon columns of (iirc) float instead of the proper point type in one column so I ended up adding a point column and populating it from the lat/lon. On Mon, Mar 30, 2015 at 6:06 PM, Sterling Jacobson <sterl...@avative.net> wrote: > I’m sticking it in Microsoft SQL as additional tables to my Platypus SQL > stuff. > > > > > > *From:* Af [mailto:af-boun...@afmug.com] *On Behalf Of *D. Ryan Spott > *Sent:* Monday, March 30, 2015 5:05 PM > *To:* af@afmug.com > *Subject:* Re: [AFMUG] Google Maps > > > > What is your database? I have some PHP code I wrote a while ago that maps > things. > > ryan > > On 3/30/15 3:50 PM, Sterling Jacobson wrote: > > Anyone ever tied in a database to google maps and earth? > > > > I want to define a boundary area on the map and then take address fields from > a database and put them in there, on the map as I'm viewing it. > > > > > > >
