Importing Spatial Data

Chris Dant did a nice job of presenting this chapter. Note the following problems:

1. Problems with KML export: I haven't solved the problem yet, but it appears that the re-projection is not correct. If you run the following query you will notice 2 things. 1) The visualization is a solid rectangle encompassing the world. 2) Not all polygons are valid and if you retrieve only the ones that are invalid, they look ok in the visualization. Very odd.

SELECT *, geog4326.STIsValid() as geog4326 
FROM precincts_reprojected

--Also try this one:

SELECT *, geog4326.IsValidDetailed() as geog4326 
FROM precincts_reprojected
WHERE NOT (geog4326.IsValidDetailed() LIKE '24400%')

1. Visual Studio 2013 doesn't have any Business Intelligence templates yet so the SSIS package is not something that we did. Further it appears to be quite SQL Server Version specific.