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: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]] Sent: Tuesday, 6 February 2001 10:08 To: Franck Martin Cc: '[EMAIL PROTECTED]'; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [GENERAL] GIS-type databases using PostgreSQL Quoting Franck Martin <[EMAIL PROTECTED]>: 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: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Sunday, 4 February 2001 4:45 > To: [EMAIL PROTECTED] > 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 <[EMAIL PROTECTED]> > Brooklyn, NY, USA > > [EMAIL PROTECTED] (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: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > >Web site: http://www.sopac.org/<http://www.sopac.org/> > >Support FMaps: http://fmaps.sourceforge.net/ > ><http://fmaps.sourceforge.net/> > > > -- Peter Mount [EMAIL PROTECTED] PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/ RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/