Skip site navigation (1) Skip section navigation (2)

Postgres && GIS

From: Paul Ramsey <pramsey(at)refractions(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres && GIS
Date: 1998-08-10 02:27:44
Message-ID: 35CE5AA0.531A86BF@refractions.net (view raw or flat)
Thread:
Lists: pgsql-general
I am exploring the possibility of using PostGreSQL for GIS applications
(as I am sure many have before me) and am wondering if there are ready
answers to a few simple questions (the FAQ seems still in it's infancy):

- there are geometric types described in the documentation, is anyone
making substantial use of them and the query tools described also? if
so, for what purpose and using what as an interface layer?

- is the JDBC interface compatible with the geometric types? could it
return a polygon if that was the result of a query, and what would it
look like when returned? conversely, how would one insert a polygon into
a database? it is something I haven't wrapped my head around yet, how
one would insert several hundred vertices of data into a dbase using
standard SQL. Just a great big well formatted text string?

Thanks for your help, I'll try and compile for future generations, of
course.

Paul Ramsey

Responses

pgsql-general by date

Next:From: admDate: 1998-08-10 04:23:13
Subject: HELP all women were raped during the May riots in Jakarta
Previous:From: Dustin SallingsDate: 1998-08-09 19:51:50
Subject: Re: [GENERAL] Postgres CGI Security Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group