Postgres && GIS - Mailing list pgsql-general

From Paul Ramsey
Subject Postgres && GIS
Date
Msg-id 35CE5AA0.531A86BF@refractions.net
Whole thread Raw
Responses Re: [GENERAL] Postgres && GIS
List 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

pgsql-general by date:

Previous
From: Dustin Sallings
Date:
Subject: Re: [GENERAL] Postgres CGI Security Problem
Next
From: Maarten Boekhold
Date:
Subject: Re: [GENERAL] Postgres CGI Security Problem