Geoquery 2008 Examples & Data Sources

Examples of geospatial data visualization using Geoquery 2008

How to: upload SHP (shape) files to SQL Server 2008 then query them using Geoquery 2008

Querying country statistics such as population

Querying state statistics such as population

World Oil Reserves (2000) (inspired by OffTheMap)

Flight Paths (for Google FlightSim) (thanks to Brian Mayer)

Apollo moon landings

Off-site links

Geometry and Geography examples

'Battleship' game using SQL Server spatial capabilities

Australian voting population density by postcode

Data Sources

GeoNames (from 'how to' by Spatial Ed)

World countries as polygons in kml (requires parsing into WKT for insertion into SQL Server 2008).

cdc.gov

Cartographic Boundary Files from the U.S. Census Bureau

GIS data links by region (from from dotnet solutions blog)

gData (beta) - free geographic data (eg. Australia Administrative areas)

Other Tools

Morten's Spatial Tools: Shape2SQL uploads 'shape' files to SQL Server 2008 & SqlSpatial Query Tool displays Geometry on a WPF interactive map

Codeplex SpatialTools