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

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

----- Original Message -----
From: "Jim Gribbin" <jimgribbin@gmail.com>
To: "aklug" <aklug@aklug.org>
Sent: Wednesday, January 30, 2008 8:28 PM
Subject: [aklug] Desktop GIS for Linux: An Introduction | Linux Journal

> I know that Niel, and a couple of others, have an interest in GIS.
>
> Thought they might find this of interest.
>
> http://www.linuxjournal.com/content/desktop-gis-linux-introduction
>
> Jim G
> ---------
> To unsubscribe, send email to <aklug-request@aklug.org>
> with 'unsubscribe' in the message body.
>
>

---------
To unsubscribe, send email to <aklug-request@aklug.org>
with 'unsubscribe' in the message body.
Received on Wed Jan 30 21:31:45 2008