postgres and postgis

From: Hubert Fröhlich <hubert(dot)froehlich(at)bvv(dot)bayern(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: postgres and postgis
Date: 2003-05-22 14:32:36
Message-ID: 3ECCDF84.90507@bvv.bayern.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
I have georeferenced entries in a Postgres table, mostly with the
"point", "box" and "polygon" datatypes. I used then for queries from
self-written CGI scripts which works very well.

However, for extending geographical uses of my data, e.g. with
MapServer, I consider switching to PostGIS, which, on the other hand
supports similar datatypes (following OpenGIS Simple Feature
Specifications) , but not the same ones. The advantage of OpenGIS Simple
Features is that lots of popular GIS applications (such as UMN
MapServer) support them.

a) How arere the postgis geometries related with postgresql objects? Is
there a connection in the development?
b) Has anybody tested migrating data from postgres to PostGIS? Is this
step useful? What is the best practice? Or does somebody have an idea
how to provide the connection?

Thanks,

Regards, Hubert

--
-------------------------------------------------------------------------------
Dr.-Ing. Hubert Fröhlich
Bezirksfinanzdirektion München
Alexandrastr. 3, D-80538 München, GERMANY
Tel. :+49 (0)89 / 2190 - 2980
Fax :+49 (0)89 / 2190 - 2459
hubert(dot)froehlich(at)bvv(dot)bayern(dot)de

Responses

Browse pgsql-general by date

  From Date Subject
Next Message scott.marlowe 2003-05-22 14:46:01 Re: caching query results
Previous Message Tom Lane 2003-05-22 14:11:17 Re: VACUUM and transaction ID wraparound