[postgis-users] PostGIS Usage Survey

[Düster Horst]

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

---------------------- multipart/mixed attachment
Hi all
=20
- Name of the organization

SO!GIS Koordination of Kanton Solothurn in Switzerland

- Data being managed in the database

Since nearly two years MapServer is our main product to deliver =
geographical
information to the whole government. More than 250'000 maps were =
produced
sinice this time. It's our  aim to offer public geographical =
information. As
the result autumn 2002 we changed from ESRI Shapefile ton manage more =
than
300 geographical themes with postgis.

- How the data is being accessed / manipulated

The data access was made by ArcView (avpgcon), MapServer and other non =
gis
web applications. Direct data access was made by GDAL/OGR. The data
manipulation is done with the classical systems like ArcGIS or ArcView =
or
via import from foreign formats like INTERLIS.=20

- Why you chose to use PostGIS for the application

After al lots of tests we decided to use PostGIS. Three systems were
available: ArcSDE, Oracle Spatial and PostGIS. ArcSDE dropped out of =
lacking
OGC simple features for SQL and the absence of Linux support at the =
time of
testing. So we tested Oracle Spatial and PostGIS. We came to the =
decision of
PostGIS due to the availability of GDAL/OGR connections, the very very =
fast
performance in contrast to Oracle Spatial and the mass of support via
Internet. As the strategic RDBMS of our government is ORACLE we were =
looking
out to find a direct connection from PostgreSQL to ORACLE like the =
ORACLE
DBLINK.

Out strategic aim is to resolve all redundances in our GIS data and
applications. This aim can only be obtained with central data =
coordination
and management and pure SQL. Take a look at the two attached examples.

----------------------------------------------------------------------- =

With best regards

Dr. Horst D=FCster=20
Leiter=20
Abteilung SO!GIS Koordination
R=F6tihof=20
4500 Solothurn=20

Tel.: 032 627 25 32=20
Fax: 032 627 22 14

horst.duester@bd.so.ch <mailto:horst.duester@bd.so.ch> =20
 <http://www.sogis.so.ch/> www.sogis.so.ch


=20

---------------------- multipart/mixed attachment
A non-text attachment was scrubbed...
Name: ms_example.gif
Type: image/gif
Size: 285881 bytes
Desc: not available
Url : http://lists.refractions.net/pipermail/postgis-users/attachments/20030204/cc88378e/ms_example.gif

---------------------- multipart/mixed attachment
A non-text attachment was scrubbed...
Name: postgis_strategie.gif
Type: image/gif
Size: 107107 bytes
Desc: not available
Url : http://lists.refractions.net/pipermail/postgis-users/attachments/20030204/cc88378e/postgis_strategie.gif

---------------------- multipart/mixed attachment--