[postgis-users] How are you editing data in PostGIS?

[Nicolas RIBOT]

Hi,

I use 2 approaches to edit data in PostGIS, depending on the size of
data to edit and the edition features required:

1°) With an Internet Client, a Java 1.1 Applet that allows to
create/modify points, polygons, polylines coming from Postgis, or
created from scratch. This applet has a little topological function to
automatically cut overlapping polygons (if this option was choosed, of
course).
It is particulary suitable for little dataset, like, for example,
farmers' fields: They can create/modify their fields directly on the
internet.

This applet should be released as OpenSource software soon.

2°) With a VBA ArcGIS module that lists geographic tables from Postgis
ODBC sources, dumps table into shapefile, and load objects back to
postgis once edition is done.

This module parses the geometries stored in Postgis (WKT) and builds
ArcGIS features for each of them, with their attributes. Features are
then stored localy in shapefiles.

Nicolas Ribot

> Hello:
> 
> I have been working through PostGIS/PostGreSQL as an 
> alternative for clients
> that require solutions without the heavy price tag of ArcSDE. 
> As usual, the
> potential users express their concerns and ask appropriate pointed
> questions. One question was how can one input AutoCAD data 
> into PostGIS? I
> responded that there was no open source direct approach yet, 
> but we could
> convert CAD files to shapefiles, then input the data. Yet, a 
> more important
> question was once the data was in there, how can we edit it? 
> I have only
> been doing read only tests up to this point, but how are you 
> editing your
> data once it is in PostGIS?
>