160 likes | 347 Views
Using QGIS, GRASS and PostGIS to answer some difficult questions . How Open Source GIS can help make your life easier and help you find beer on a Sunday. A simple spatial query. Vector data types available through OGR. Where's the beer?. Geocode Query. QGIS and the GRASS Plugin.
E N D
Using QGIS, GRASS and PostGISto answer some difficult questions How Open Source GIS can help make your life easier and help you find beer on a Sunday
SELECT Round(Sum(c.pop10*(ST_Area(ST_Intersection(c.geom, z.the_geom))) / c.totarea)) FROM (SELECT ST_Union(ST_Buffer(b.geom,8046.72)) as the_geom FROM breweries.brewery b) as z, indiana.block_popc WHERE ST_Intersects(z.the_geom, c.geom); Counting all Hoosiers Who Live Within Five Miles of a Microbrewery
Current OSGeo Limitations • Cartography / Layout • Editing • Versioned Editing • Mr Sid support • File Geodatabase support
PostGIS: Refractions Research http://refractions.net QGIS: QGIS Foundation http://qgis.org PostGIS In Action By Leo Hsu & Regina Obe http://postgis.us GIS StackExchange http://gis.stackexchange.com Philip Bernard Mapping & Spatial Solutions pb@mappingandspatial.com Where to go for help