Shape2SQL is a great product for loading spatial data into Microsoft SQL Server. In fact, we use it all the time. However, it’s intended for ESRI shapefiles only. Chances are, if you work for a business, your spatial data will be in MapInfo tab format.

The process of transferring spatial data from MapInfo Pro up to the SQL Server sometimes can result in unexpected changes to the spatial data. If you plan ahead, you can capture data helpful in identifying the records that underwent a transformation.

Be careful not to repeat my mistake of naïvely assuming Power Map handles “counties” in Puerto Rico and other US territories the same way as it handles counties and county equivalents in the US states.

Why did Power Map plot Lake County, Colorado, in Indiana, adjacent to Lake Michigan? In the Power Map below, the extra tall, beige, bar over Indiana really belongs in Colorado. The tall bars in Alabama and Maryland also are out of place. What’s going on here?

Have you ever produced in Power View or Power Map a USA wide report that includes all ZIP Codes in the US, and wondered why the New England states and New Jersey disappeared?