Thank you for the informative reply! On Fri, Apr 20, 2012 at 5:46 PM, Alan Smith <gpsanima...@gmail.com> wrote:
> Unless you're hosting your own web server, in which case you could use a > JDB connection to your database,which I guess isn't the case, you'll have > to re-create your database in mySQL or something similar on the server, and > build a system to keep it in sync with your SQLServer database. > And no, I don't think you'll get much joy from SQL Server to KML. > The PHP code to access a mySQL database can be found by googling those > terms - like we all do to learn new techniques. > Displaying the data in a Map interface will achieved by javascript calls > to the Maps API. Ditto my comments above. > Now it's time for you to get your hands dirty by building your own > capability here. > Good luck, it's very rewarding! > > > > On Fri, Apr 20, 2012 at 12:17 AM, Phil Arbeau <parb...@gmail.com> wrote: > >> Thank you for the reply. I'm kind of new to the web-side of things so I'm >> trying to wrap my head around this. Would I upload initially just put my >> database on a webserver (like using a computer as the server, a or hosting >> service?). >> >> Also curious if a tool like SQL Server to KML would be of help at all? >> >> I'm not familiar with PHP, but I am able to code fairly proficiently, >> would you perhaps also be able to point me towards which commands I would >> need to query the data and display it on a map interface? >> >> Thank you very much, >> >> Phil >> >> >> On Tuesday, 17 April 2012 17:38:06 UTC-4, StarTraX wrote: >>> >>> >>> You'll have to get your database onto your web server and write some PHP >>> to query it with parameters supplied by your users from a web page then >>> manipulate the results into calls to Maps to display the features. >>> >>> On Tue, Apr 17, 2012 at 11:55 PM, Phil Arbeau <parb...@gmail.com> wrote: >>> >>>> Hello, >>>> >>>> I currently have a SQL Server database with geographic data, one table >>>> representing area polygons, with the second table representing events as >>>> points. >>>> >>>> I was curious if it would be possible to upload this to a Google Map, >>>> and allow the user to select a polygon and then query the summary stats of >>>> the events that fall within that polygon. >>>> >>>> Thanks in advance, >>>> >>>> Phil >>>> >>>> -- >>>> You received this message because you are subscribed to the Google >>>> Groups "Google Maps JavaScript API v3" group. >>>> To view this discussion on the web visit https://groups.google.com/d/** >>>> msg/google-maps-js-api-v3/-/**KfOdTFHlpOIJ<https://groups.google.com/d/msg/google-maps-js-api-v3/-/KfOdTFHlpOIJ> >>>> . >>>> To post to this group, send email to google-maps-js-api-v3@** >>>> googlegroups.com <google-maps-js-api-v3@googlegroups.com>. >>>> To unsubscribe from this group, send email to google-maps-js-api-v3+** >>>> unsubscr...@googlegroups.com<google-maps-js-api-v3%2bunsubscr...@googlegroups.com> >>>> . >>>> For more options, visit this group at http://groups.google.com/** >>>> group/google-maps-js-api-v3?**hl=en<http://groups.google.com/group/google-maps-js-api-v3?hl=en> >>>> . >>>> >>> >>> -- >> You received this message because you are subscribed to the Google Groups >> "Google Maps JavaScript API v3" group. >> To view this discussion on the web visit >> https://groups.google.com/d/msg/google-maps-js-api-v3/-/nG5ndznfN4AJ. >> >> To post to this group, send email to >> google-maps-js-api-v3@googlegroups.com. >> To unsubscribe from this group, send email to >> google-maps-js-api-v3+unsubscr...@googlegroups.com. >> For more options, visit this group at >> http://groups.google.com/group/google-maps-js-api-v3?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "Google Maps JavaScript API v3" group. > To post to this group, send email to > google-maps-js-api-v3@googlegroups.com. > To unsubscribe from this group, send email to > google-maps-js-api-v3+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/google-maps-js-api-v3?hl=en. > -- You received this message because you are subscribed to the Google Groups "Google Maps JavaScript API v3" group. To post to this group, send email to google-maps-js-api-v3@googlegroups.com. To unsubscribe from this group, send email to google-maps-js-api-v3+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-maps-js-api-v3?hl=en.
