postgres and postgis
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.froehlich@bvv.bayern.de
OK, but there are datatypes (e.g. POINT etc. in Postgres), and I cannot
access them from PostGIS directly, as PostGIS uses similar geometry
types in a *different* way.
How can I use Postgres geometry datatypes in PostGIS directly? Or do I
have to migrate my data (and, eventually, my old apps too) ?
Is there a possibility to unify the development of these different
datatypes?
Regards,
Hubert
P.J. "Josh" Rovero wrote:
PostGIS *is* postgresql, with added datatypes, operators and functions.
Hubert Fr�hlich wrote:
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?
--
-------------------------------------------------------------------------------
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.froehlich@bvv.bayern.de
Import Notes
Reply to msg id not found: 3ECD209E.3020007@sonalysts.com