|Version 27 (modified by sfkeller, 2 years ago)|
PostGIS Tutorials some complete with data
PostGIS database sandbox and tutorials Provides step by step interactive tutorial for experimenting with PostGIS Spatial SQL in a database sandbox. You can also type in spatial SQL statements you find in the PostGIS manual and see them rendered on a map.
Spatial database tips and tricks Covers PostGIS , SQL server 2008 Spatial and Oracle but focus on PostGIS
PGDay Europe 2010 PostGIS Talks
PostGIS - das Wo? in der Datenbank Talk by Stefan Kellar showing use of OpenStreetMap in a Box and some samplings of PostGIS queries, new PostGIS Raster support, and using PostGIS with GeoServer? and OpenLayers? PostGIS, a PostgreSQL module for spatial data Talk by Vincent Picavet provides some examples of outputting geometries in KML, WKT of different geometry types supported in PostGIS 2.0 including Polyhedral Surfaces, history of PostGIS
Integrating PostGIS in Web Applications (PG Con East 2010 - Leo hsu and Regina Obe)
This covered using OpenLayers, OpenStreetMap Layers, brief intro to GeoExt, setting up Mapserver and GeoServer as OGC WFS/WMS services. Reverse proxy for ASP.NET that can be used for any kind of WMS/WFS server (VB.NET, C#). Roll your own solution using PostGIS ST_AsKML, ST_AsGeoJSON functions.
PGCon 2009 Spatial Analysis PostGIS (2009)