Spatial Database Tips and Tricks Workshop¶
Mapping APIs are great for data display and capture, but how do you build applications that allow query and geoprocessing of spatial data without becoming a Java or C++ programming guru? How about using the power of SQL, the standard database query language, and the spatial extensions provided by SQL Server, Oracle Spatial and PostGIS.
Getting Started¶
- This workshop uses a software/data bundle
- Download the bundle and unzip it in a convenient location.
Workshop Modules¶
- Introduction
- What are spatial databases? What options do you have? What are the plusses and minuses?
- Architecture
- How do spatial databases fit into web mapping architecture?
- Installation
- Installing our chosen set of packages for the workshop: PostGIS, GeoServer, OpenLayers.
- Base Map with WMS Overlay
- Displaying spatial database layers on a web map.
- Query Spatial Database from Map Click
- Querying the spatial database from a map click.
- Analyze Spatial Data from a Map Click
- Summarizing information from the spatial database with a map click.
- Join Spatial Tables from a Map Click
- Summarizing information from two spatial tables with a map click.
- Union Geometries inside the Spatial Database
- Performing a spatial query and generating the union of all tax lots within particular zoning areas.
- Running Arbitrary Spatial SQL
- Run any SQL spatial query at all and see the results on the map.
- Walk a Sewer Network
- Walk down the storm drain network using database calls.
- Conclusions
- What should you take away from this workshop?
Table Of Contents
About OpenGeo
OpenGeo provides commercial open source software for internet mapping and geospatial application development. We are a social enterprise dedicated to the growth and support of open source software.
License
This work is licensed under a Creative Commons Attribution-Share Alike 3.0 United States License. Feel free to use this material, but we ask that you please retain the OpenGeo branding, logos and style.