Working with Spatial Data Part II - Plotting Shapes and Storing Geocoded Data

Continuing from Part I of the Spatial Data series we model an in-memory/persistent data repository for storing geocoded data and plot the data.

SQL Server Geography Data Type

We are working on the migration to SQL Server 2008 and have geospatial data that we would like to move over as well. As part of our application we house information on locations across the globe. Which data type should we use?

SQL Server 2008 Spatial Index Performance

The institution I work with has decided to migrate their database system to SQL Server 2008. One of the applications uses geospatial data, which consists of millions of rows. I understand that their are indexes that can be used for geospatial data, but have not worked with them. What's the scoop on them?

Data storage and retrieval for geospatial data in SQL Server 2008

The company I work for has migrated to SQL Server 2008 and we're ready to start planning for the use of geospatial data. One of the applications we want to use geospatial data in will assist order fulfillers in efficiently picking stock for orders. Our warehouse is fairly large, which geospatial data type should we use?

Latitude, Longitude and the nautical Mile

Spatial Concepts

Spatial Reference

Spatial Modeling

Spatial data type

Powerful Geographical Visualisations made easy with SQL 2008 Spatial (Part 1)

This article is part one of a two part series on how to perform data visualisation with SQL Server 2008