Presentation by Del Robinson, July 2015

An introduction to the basic features of the SQL Server data types of geometry and geography, with numerous examples of use.

Downloads

The powerpoint - SQL Server Geo-Spatial.pptx
The sample data and SQL example scripts - SQLSpatial_Scripts.zip

Simple Examples - ready to run

Example scripts 1a,1b,2,3 should all be ready to run - they are self contained

Setup Data for crash data and StatsNZ areas

There are 2 sql script files starting with SetupData_

• The Area Unit script sets up a boundary for Mt Wellington in Auckland

• The crash data script sets up 8000+ records for Mt Wellington in Auckland and an area in Christchurch

• This data allows you to run the example scripts 4,5,7

Links to demo web sites

• Crash hotspots in New Zealand

• Cycle Crashes on Google Maps Route. Explanation

• Roadworks (TMPs) in Christchurch

Data Sources

• NZTA Crash data

• Stats NZ Geographical Area Metadata