postgres and postgis

Поиск
Список
Период
Сортировка
От Hubert Fröhlich
Тема postgres and postgis
Дата
Msg-id 3ECCDF84.90507@bvv.bayern.de
обсуждение исходный текст
Список 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.froehlich@bvv.bayern.de


В списке pgsql-general по дате отправления:

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: SELECT DISTINCT ON bug?
Следующее
От: Arjen van der Meijden
Дата:
Сообщение: Re: Is this a bug? : select '26/10/2003'::date + interval '1