[postgis-users] Live PostGIS Edit tool?

[Sufficool, Stanley]

It comes down to a matter of usability. If I have 60,000 line segments
that I want to arbitrarily realign (i.e. annotation placement) I need to
be able to see the whole picture and move seamlessly from one to another
without having to narrow on one row using queries.

I haven't checked out qGIS in awhile. I will give it another look.

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Pedro Martinez Arbizu
> Sent: Friday, October 31, 2008 10:30 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Live PostGIS Edit tool?
> 
> 
> Hi Stanley,
> I dont know if I got the problem...
> Why you don't just query your database (select from your 
> Postgis table just the row you need), and then edit the 
> geometry only from that record. I am using Qgis to do this. 
> If you limit your layer to just the line/polygon you want to 
> edit, should work quite fast.
> 
> Pedro
> 
> 
> 2008/10/31 Sufficool, Stanley <ssufficool at rov.sbcounty.gov>:
> > So far all the tools I have worked with (OpenJUMP, uDIG) 
> use a check 
> > out, check in process on PostGIS to update geometries. This is 
> > impractical and sometimes impossible with these tools when dealing 
> > with hundreds of thousands of records to re-write the 
> entire table to 
> > update one linestring/polygon.
> >
> > What I am looking for is a live editor that will post the 
> changes to 
> > only the geometry row I am working with instead of caching the 
> > changes. I can record the versions of this data for UNDO at the 
> > database with triggers, so the check-in/check out is 
> irrelevant at the 
> > client since I can roll back any user changes to any point 
> in time at 
> > the db layer.
> >
> > Anyone know of such a tool or am I going to have to roll my own?
> >
> > Stanley Sufficool
> > Systems Analyst
> > San Bernardino County
> > 909-387-2102
> >
> > P  Please consider the environment before printing this 
> e-mail or its
> > attachment(s)
> >
> > _______________________________________________
> > postgis-users mailing list postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> >
> >
> 
> 
> 
> -- 
> Prof. Dr. P. Martinez Arbizu
> DZMB-Forschungsinstitut Senckenberg
> 
> Suedstrand 44
> D-26382 Wilhelmshaven
> Germany
> 
> Tel: +49 (0)4421 9475-100
> Fax: +49 (0)4421 9475-111
> 
> Email: pmartinez at senckenberg.de
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>