I'll try to keep this post both factual and helpful! 1.) SQL Server uses "...a modified view of the GML 3.1.1 schema restricted and adopted to the portions supported by Microsoft SQL Server for geometry types". As you have find out, you can't directly import this into Google Maps. You can view the actual schema used here: http://schemas.microsoft.com/sqlserver/profiles/gml/
2.) There are, however, several ways to take spatial data from SQL Server 2008 and output them on Google Maps (or Virtual Earth, or Google Earth). - You can use XSLT to style GML to KML or GeoRSS, that can be imported by the GGeoXml method. - You can use a PHP / C# / VB handler to manually create the javascript constructor from WKT (or WKB or GML), and then execute them using eval() in an AJAX-style script. - You can use the native SqlGeometryBuilder / SqlGeographyBuilder classes contained in Microsoft.SqlServerTypes.dll in a .NET handler to construct KML/GeoRSS. You can see examples of 1.) and 2.) in my new book "Beginning Spatial with SQL Server 2008" (http://www.apress.com/book/view/9781430218296). And if you want to see an example of 3.), you can check out the associated website: http://www.beginningspatial.com/creating_3d_prism_maps_using_google_earth. This uses a .NET handler to execute a SQL Server 2008 stored procedure, generate KML from the output, and then pass that to a network link in Google Earth (but you could pass that to Google Maps or Virtual Earth just as easily). As previously noted, if you do go use any sort of handler to dynamically create GeoRSS/KML to pass to Google, that handler MUST reside on a publicly-accessible website, since the data must be passed to Google's servers and processed before it is rendered on the map. If you want to use locally-held data, you might want to consider the equivalent VEShapeLayer() method in Virtual Earth instead, which can be processed locally. On Dec 19, 9:09 am, "Neil.Young" <neil.yo...@freenet.de> wrote: > <MultiSurface xmlns="http://www.opengis.net/gml";> > > That's what I get from MS in the first line and this is copied from my first > post. I think the MS people are very explicitly claiming to produce GML. > > Regards > > > > - Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Maps API" group. To post to this group, send email to Google-Maps-API@googlegroups.com To unsubscribe from this group, send email to google-maps-api+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Google-Maps-API?hl=en -~----------~----~----~----~------~----~------~--~---
