[postgis-users] unable to make postgresql 7.2.3: please help

[Paul Ramsey]

On Tuesday, August 26, 2003, at 07:25 PM, Venu Kanaparthy wrote:
>
> Just wondering if there is any API (maybe in java) that can be used to 
> load (specially from ArcGIS) shapefile data to postgresql.

You don't find shp2pgsql sufficient? The postgis data sources from JUMP 
and GeoTools could be repurposed into custom APIs if one so desired.

> Does postgresql support  storing of XML data(GML specifically).

To what end would one store GML? Far more efficient to decompose the 
GML into spatial/relational structures for database storage. Same thing 
can be said about structured XML, though unstructured documents are a 
different story.  There are some early XML tools in contrib and other 
places in PostgreSQL but nothing comprehensive (generally comprehensive 
open source implementations follow standards, and there aren't really 
any in the XML/Database world quite yet (some drafts though)).

P.


      Paul Ramsey
      Refractions Research
      Email: pramsey at refractions.net
      Phone: (250) 885-0632