[postgis-users] Who is using PostGIS and how?

Searle Ross Ross.Searle at nrm.qld.gov.au
Tue Mar 26 21:51:10 PST 2002


Sorry about the delay getting back to you.

We are using PostGIS for an application designed to deliver large
amounts of natural resource information via a mapserver interface. In
Queensland our state government has legislation controlling the clearing
of trees. If a landholder wishes to clear trees he/she has to apply for
a permit. A permit will only be issued if the clearing does not cause
environmental degradation. The state government has the role of
assessing these permits. To do this officers need access to a broad
range of datasets all generally held in GIS form. The mapserver/PostGIS
application allows users to quickly search for a parcel of land and
bring up all the relevant information in a standard format.

This application was only made possible thanks to PostGIS. The huge size
of the GIS data sets involved (up to 600 Mb per coverage) meant that a
mapserver application using shapefiles would have been far too slow or
complicated if we had gone down the tiling road. The indexing of both
the spatial and textual data increased response times to very acceptable
levels. Storing the data in a RDBMS also has many advantages for data
management as well as the ability to do powerful, flexible querying on
the fly.

Some background info
Hardware : Sun single 143mHz CPU running Solaris
Database size : approx 2.5 Gig
Cadastral layer contains approx 1.6 million parcels
Typical redraw response time : 5 - 10 secs 
Number of users : approx 40
Number of hits per day : approx 30

Sorry I can't let you have a look at it but it is behind our firewall,
so I have included a couple of piccies to help demonstrate what it does



-----Original Message-----
From: Paul Ramsey [mailto:pramsey at refractions.net]
Sent: Wednesday, 27 March 2002 2:43 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Who is using PostGIS and how?

Wow, no responses at all the first time!

OK, there are over 160 of you, someone must be using PostGIS for a real
application. :) I really do want to hear, since I'll be talking to a
room full of people whose first reaction will be "what kind of lunatic
would entrust their business to a product built by people in their spare
time". I want to be able to say "well, *this* kind of lunatic!"... I
would also be interested to hear your reasons for selecting PostGIS over
one of the commercial alternatives.

I'll go first:

For example, Refractions is using PostGIS to store and manage a very
large and highly relational road network database. The use of a RDBMS
allows us to create different output "snapshots" of the data for
different users of the road network, since each user has very different
data standards. A new view of the data is just a new SQL query away.
Once the data is in a RDBMS, other things become suddenly much easier:
we have prototyped a geocoder which uses the backend database to convert
addresses to coordinate information, and used the Mapserver/PostGIS
connector to visualize the results.

postgis-users mailing list
postgis-users at postgis.refractions.net

The information in this e-mail together with any attachments is
intended only for the person or entity to which it is addressed
and may contain confidential and/or privileged material.

Any form of review, disclosure, modification, distribution
and/or publication of this e-mail message is prohibited.  

If you have received this message in error, you are asked to
inform the sender as quickly as possible and delete this message
and any copies of this message from your computer and/or your
computer system network.  

-------------- next part --------------
A non-text attachment was scrubbed...
Name: Image2.gif
Type: image/gif
Size: 35043 bytes
Desc: Image2.gif
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20020327/065b497f/attachment.gif>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Image3.gif
Type: image/gif
Size: 56772 bytes
Desc: Image3.gif
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20020327/065b497f/attachment-0001.gif>

More information about the postgis-users mailing list