[aklug] Re: Desktop GIS for Linux: An Introduction | Linux Journal

On Wed, 30 Jan 2008 20:59:55 -0900
"Neil Moomey" <neil@neilmoomey.com> wrote:

> Good timing. I was actually playing around with GRASS and Quantum GIS
> when I recieved this email. I would skip ESRI's ArcReader. Quantum
> GIS is more powerful. It lets you work with PostGIS and GRASS data.
> BTW, the next version of ESRI's ArcGIS Server will support PostGIS.
>
> Here's an example of what PostGIS can do:
>
> First I downloaded some Kenai property GIS data and used shp2pgsql to
> convert the ESRI shapefiles to PostGIS.
>
> Now use SQL to query the data.
>
> Example: Find all the parcels in Homer along a Gravel road that are
> less than 100 acres and more than 1000 ft from any bridge
>
> select HomerParcels.* from homerparcels,homerroads,homerbridges where
> homerroads.surface='Gravel' and area(homerparcels.the_geom)<100 and
> intersects(homerparcels.the_geom,homerroads.the_geom) and
> distance(homerparcels.the_geom,homerbridges.the_geom)>1000;
>
> Neil

Thanks for that leg up Neil! I just started playing with GRASS and QGIS
last night doing parcel research in the Mat-Su so this is great!

Tom
 
======================================================================
   "Z-80 system stack overflow. Shut 'er down Scotty, the system's
         sucking mud" - Error message on TRS 80 Model-16B

Tom Simes simestd@netexpress.com
======================================================================
---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
Received on Thu Jan 31 06:39:55 2008