Importing Spatial Data

Chris Dant did a nice job of presenting this chapter. See Ch05.pptx.

Problems:

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%')

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.