Thread: GIS-type databases using PostgreSQL
Hello, Has anyone out there had experience designing/building GIS-related databases using PostgreSQL? As a newbie approaching this topic, I would really appreciate hearing from anyone who has (off-list, unless you think it is of general interest). TIA, Cheers, Laurel tech@clearwater-inst.com
Hi, Me and others are planning to move PG to ISO19100 compliance. ISO19100 is the future standard that is describing GIS systems. If you visit FMaps.sourceforge.net and go in the CVS you will see in the directory /src/geoobj/ procedures to add geographic data types to PG. These procedures need to be rewritten as they are not ISO19100 compliant. But all the concepts are there and working. The work doesn't stop here and include metadata schema, feature schema, but a the moment the crunch is creating a geographic object type in PG and rendering it. Cheers. Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: franck@sopac.org <mailto:franck@sopac.org> Web site: http://www.sopac.org/<http://www.sopac.org/> Support FMaps: http://fmaps.sourceforge.net/ <http://fmaps.sourceforge.net/> This e-mail is intended for its addresses only. Do not forward this e-mail without approval. The views expressed in this e-mail may not be necessarily the views of SOPAC. -----Original Message----- From: Laurel Williams [mailto:tech@clearwater-inst.com] Sent: Thursday, 1 February 2001 8:22 To: pgsql-general@postgresql.org Subject: [GENERAL] GIS-type databases using PostgreSQL Hello, Has anyone out there had experience designing/building GIS-related databases using PostgreSQL? As a newbie approaching this topic, I would really appreciate hearing from anyone who has (off-list, unless you think it is of general interest). TIA, Cheers, Laurel tech@clearwater-inst.com
This would be a great addition to PG. I queried about this many years ago (I think to Tom Lockhart) but I think there were other priorities at that time. I spoke to two groups (PostgreSQL Inc and GreatBridge) at this year's Linux Expo in New York about this topic. I will forward your project's web site to them. My interest is to create open source Java classes that could be used to create fat or thin mapping applications. In particular, the thin apps should be able to connect to geographically enabled servers (ideally PostgreSQL). This would enable organizations to do mapping on a small budget (the commercial vendors are charging way too much). -- Regards, Ken Mort <ken@mort.net> Brooklyn, NY, USA Franck@sopac.org (Franck Martin) wrote in <F12ECEA0435AD211B5280008C7ACBC857FF28A@BIGIRON>: >Hi, > >Me and others are planning to move PG to ISO19100 compliance. >ISO19100 is the future standard that is describing GIS >systems. > >If you visit FMaps.sourceforge.net and go in the CVS you will >see in the directory /src/geoobj/ procedures to add >geographic data types to PG. These procedures need to be >rewritten as they are not ISO19100 compliant. But all the >concepts are there and working. > >The work doesn't stop here and include metadata schema, >feature schema, but a the moment the crunch is creating a >geographic object type in PG and rendering it. > >Cheers. > >Franck Martin >Network and Database Development Officer >SOPAC South Pacific Applied Geoscience Commission >Fiji >E-mail: franck@sopac.org <mailto:franck@sopac.org> >Web site: http://www.sopac.org/<http://www.sopac.org/> >Support FMaps: http://fmaps.sourceforge.net/ ><http://fmaps.sourceforge.net/> >
On Sat, 3 Feb 2001, Ken Mort wrote: > My interest is to create open source Java classes that could be > used to create fat or thin mapping applications. In particular, > the thin apps should be able to connect to geographically > enabled servers (ideally PostgreSQL). This would enable > organizations to do mapping on a small budget (the commercial > vendors are charging way too much). You might look at MapServer 'http://mapserver.gis.umn.edu/' it supports PostgreSQL vi. one of the support scripting langauges. " ... Perl, Python, Tk/Tcl, Guile and even Java." Rod --
Thanks, I saw it awhile ago and I thought that it output GIF
images.
I'm looking to either stream vector data (for a thin client
applet) or work with the vector data locally (fat client
application) or both (in a fat client).
There are a couple of open source Java sources (OpenMap and
GeoTools) that I will investigate before eating the whole
enchilada.
Thanks again,
ken
--
Regards,
Ken Mort <ken@mort.net>
Brooklyn, NY, USA
raanders@tincan.org ("Roderick A. Anderson") wrote in
<Pine.LNX.4.10.10102031642450.23592-100000@tincan.org>:
>You might look at MapServer 'http://mapserver.gis.umn.edu/'
>it supports PostgreSQL vi. one of the support scripting
>langauges. " ... Perl, Python, Tk/Tcl, Guile and even Java."
>
>
>Rod
Well, I'm not much in Java classes, as the main application will be for Gnome. However, it shouldn't stop you to open a branch where you bring some Java library to deal with the data... If PG Inc and Great Bridges wants to provide support I will be happy :-) Especially that I'm working for a regional organisation that works for the development of Pacific Island Countries. A real good deed indeed. Cheers. Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: franck@sopac.org <mailto:franck@sopac.org> Web site: http://www.sopac.org/ <http://www.sopac.org/> Support FMaps: http://fmaps.sourceforge.net/ <http://fmaps.sourceforge.net/> This e-mail is intended for its addresses only. Do not forward this e-mail without approval. The views expressed in this e-mail may not be necessarily the views of SOPAC. -----Original Message----- From: ken@mort.net [mailto:ken@mort.net] Sent: Sunday, 4 February 2001 4:45 To: pgsql-general@postgresql.org Subject: RE: [GENERAL] GIS-type databases using PostgreSQL This would be a great addition to PG. I queried about this many years ago (I think to Tom Lockhart) but I think there were other priorities at that time. I spoke to two groups (PostgreSQL Inc and GreatBridge) at this year's Linux Expo in New York about this topic. I will forward your project's web site to them. My interest is to create open source Java classes that could be used to create fat or thin mapping applications. In particular, the thin apps should be able to connect to geographically enabled servers (ideally PostgreSQL). This would enable organizations to do mapping on a small budget (the commercial vendors are charging way too much). -- Regards, Ken Mort <ken@mort.net> Brooklyn, NY, USA Franck@sopac.org (Franck Martin) wrote in <F12ECEA0435AD211B5280008C7ACBC857FF28A@BIGIRON>: >Hi, > >Me and others are planning to move PG to ISO19100 compliance. >ISO19100 is the future standard that is describing GIS >systems. > >If you visit FMaps.sourceforge.net and go in the CVS you will >see in the directory /src/geoobj/ procedures to add >geographic data types to PG. These procedures need to be >rewritten as they are not ISO19100 compliant. But all the >concepts are there and working. > >The work doesn't stop here and include metadata schema, >feature schema, but a the moment the crunch is creating a >geographic object type in PG and rendering it. > >Cheers. > >Franck Martin >Network and Database Development Officer >SOPAC South Pacific Applied Geoscience Commission >Fiji >E-mail: franck@sopac.org <mailto:franck@sopac.org> >Web site: http://www.sopac.org/<http://www.sopac.org/> >Support FMaps: http://fmaps.sourceforge.net/ ><http://fmaps.sourceforge.net/> >
Quoting Franck Martin <Franck@sopac.org>: Redirecting to the jdbc list... > Well, I'm not much in Java classes, as the main application will be for > Gnome. However, it shouldn't stop you to open a branch where you bring > some Java library to deal with the data... There's plenty of existing libraries out there, and the jdbc driver already has support for the existing standard types in PostgreSQL (point, line etc). A few years ago I did write a simple mapping library that handled things like co-ordinate transforms and display. I was thinking of updating it to Java2 after PostgreSQL 7.1 was out (as I'm doing with a lot of my stuff). Peter > > If PG Inc and Great Bridges wants to provide support I will be happy > :-) > Especially that I'm working for a regional organisation that works for > the > development of Pacific Island Countries. A real good deed indeed. > > Cheers. > > Franck Martin > Network and Database Development Officer > SOPAC South Pacific Applied Geoscience Commission > Fiji > E-mail: franck@sopac.org <mailto:franck@sopac.org> > Web site: http://www.sopac.org/ > <http://www.sopac.org/> Support FMaps: http://fmaps.sourceforge.net/ > <http://fmaps.sourceforge.net/> > > This e-mail is intended for its addresses only. Do not forward this > e-mail > without approval. The views expressed in this e-mail may not be > necessarily > the views of SOPAC. > > > > -----Original Message----- > From: ken@mort.net [mailto:ken@mort.net] > Sent: Sunday, 4 February 2001 4:45 > To: pgsql-general@postgresql.org > Subject: RE: [GENERAL] GIS-type databases using PostgreSQL > > > This would be a great addition to PG. I queried about this many > years ago (I think to Tom Lockhart) but I think there were other > priorities at that time. > > I spoke to two groups (PostgreSQL Inc and GreatBridge) at this > year's Linux Expo in New York about this topic. I will forward > your project's web site to them. > > My interest is to create open source Java classes that could be > used to create fat or thin mapping applications. In particular, > the thin apps should be able to connect to geographically > enabled servers (ideally PostgreSQL). This would enable > organizations to do mapping on a small budget (the commercial > vendors are charging way too much). > > -- > > Regards, > Ken Mort <ken@mort.net> > Brooklyn, NY, USA > > Franck@sopac.org (Franck Martin) wrote in > <F12ECEA0435AD211B5280008C7ACBC857FF28A@BIGIRON>: > > >Hi, > > > >Me and others are planning to move PG to ISO19100 compliance. > >ISO19100 is the future standard that is describing GIS > >systems. > > > >If you visit FMaps.sourceforge.net and go in the CVS you will > >see in the directory /src/geoobj/ procedures to add > >geographic data types to PG. These procedures need to be > >rewritten as they are not ISO19100 compliant. But all the > >concepts are there and working. > > > >The work doesn't stop here and include metadata schema, > >feature schema, but a the moment the crunch is creating a > >geographic object type in PG and rendering it. > > > >Cheers. > > > >Franck Martin > >Network and Database Development Officer > >SOPAC South Pacific Applied Geoscience Commission > >Fiji > >E-mail: franck@sopac.org <mailto:franck@sopac.org> > >Web site: http://www.sopac.org/<http://www.sopac.org/> > >Support FMaps: http://fmaps.sourceforge.net/ > ><http://fmaps.sourceforge.net/> > > > -- Peter Mount peter@retep.org.uk PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
The standard is a little bit more than a new PG type. It includes tables containing metadata features, datums,... As for the new type, it is displayed in ASCII so all usual programs should handle it... Franck Martin Network and Database Development Officer SOPAC South Pacific Applied Geoscience Commission Fiji E-mail: franck@sopac.org <mailto:franck@sopac.org> Web site: http://www.sopac.org/ <http://www.sopac.org/> Support FMaps: http://fmaps.sourceforge.net/ <http://fmaps.sourceforge.net/> This e-mail is intended for its addresses only. Do not forward this e-mail without approval. The views expressed in this e-mail may not be necessarily the views of SOPAC. -----Original Message----- From: Peter T Mount [mailto:peter@retep.org.uk] Sent: Tuesday, 6 February 2001 10:08 To: Franck Martin Cc: 'ken@mort.net'; pgsql-jdbc@postgresql.org; pgsql-general@postgresql.org Subject: RE: [GENERAL] GIS-type databases using PostgreSQL Quoting Franck Martin <Franck@sopac.org>: Redirecting to the jdbc list... > Well, I'm not much in Java classes, as the main application will be for > Gnome. However, it shouldn't stop you to open a branch where you bring > some Java library to deal with the data... There's plenty of existing libraries out there, and the jdbc driver already has support for the existing standard types in PostgreSQL (point, line etc). A few years ago I did write a simple mapping library that handled things like co-ordinate transforms and display. I was thinking of updating it to Java2 after PostgreSQL 7.1 was out (as I'm doing with a lot of my stuff). Peter > > If PG Inc and Great Bridges wants to provide support I will be happy > :-) > Especially that I'm working for a regional organisation that works for > the > development of Pacific Island Countries. A real good deed indeed. > > Cheers. > > Franck Martin > Network and Database Development Officer > SOPAC South Pacific Applied Geoscience Commission > Fiji > E-mail: franck@sopac.org <mailto:franck@sopac.org> > Web site: http://www.sopac.org/ > <http://www.sopac.org/> Support FMaps: http://fmaps.sourceforge.net/ > <http://fmaps.sourceforge.net/> > > This e-mail is intended for its addresses only. Do not forward this > e-mail > without approval. The views expressed in this e-mail may not be > necessarily > the views of SOPAC. > > > > -----Original Message----- > From: ken@mort.net [mailto:ken@mort.net] > Sent: Sunday, 4 February 2001 4:45 > To: pgsql-general@postgresql.org > Subject: RE: [GENERAL] GIS-type databases using PostgreSQL > > > This would be a great addition to PG. I queried about this many > years ago (I think to Tom Lockhart) but I think there were other > priorities at that time. > > I spoke to two groups (PostgreSQL Inc and GreatBridge) at this > year's Linux Expo in New York about this topic. I will forward > your project's web site to them. > > My interest is to create open source Java classes that could be > used to create fat or thin mapping applications. In particular, > the thin apps should be able to connect to geographically > enabled servers (ideally PostgreSQL). This would enable > organizations to do mapping on a small budget (the commercial > vendors are charging way too much). > > -- > > Regards, > Ken Mort <ken@mort.net> > Brooklyn, NY, USA > > Franck@sopac.org (Franck Martin) wrote in > <F12ECEA0435AD211B5280008C7ACBC857FF28A@BIGIRON>: > > >Hi, > > > >Me and others are planning to move PG to ISO19100 compliance. > >ISO19100 is the future standard that is describing GIS > >systems. > > > >If you visit FMaps.sourceforge.net and go in the CVS you will > >see in the directory /src/geoobj/ procedures to add > >geographic data types to PG. These procedures need to be > >rewritten as they are not ISO19100 compliant. But all the > >concepts are there and working. > > > >The work doesn't stop here and include metadata schema, > >feature schema, but a the moment the crunch is creating a > >geographic object type in PG and rendering it. > > > >Cheers. > > > >Franck Martin > >Network and Database Development Officer > >SOPAC South Pacific Applied Geoscience Commission > >Fiji > >E-mail: franck@sopac.org <mailto:franck@sopac.org> > >Web site: http://www.sopac.org/<http://www.sopac.org/> > >Support FMaps: http://fmaps.sourceforge.net/ > ><http://fmaps.sourceforge.net/> > > > -- Peter Mount peter@retep.org.uk PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/