GIS-type databases using PostgreSQL

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/&lt;http://www.sopac.org/&gt;
Support FMaps: http://fmaps.sourceforge.net/ <http://fmaps.sourceforge.net/&gt;

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>:

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/&#39; 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>:

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/&gt; Support FMaps: http://fmaps.sourceforge.net/
<http://fmaps.sourceforge.net/&gt;

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>:

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/&gt; Support FMaps: http://fmaps.sourceforge.net/
<http://fmaps.sourceforge.net/&gt;

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/&lt;http://www.sopac.org/&gt;
Support FMaps: http://fmaps.sourceforge.net/
<http://fmaps.sourceforge.net/&gt;

--
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/&gt; Support FMaps: http://fmaps.sourceforge.net/
<http://fmaps.sourceforge.net/&gt;

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/&gt; Support FMaps: http://fmaps.sourceforge.net/
<http://fmaps.sourceforge.net/&gt;

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/&lt;http://www.sopac.org/&gt;
Support FMaps: http://fmaps.sourceforge.net/
<http://fmaps.sourceforge.net/&gt;

--
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/