[postgis-users] Live PostGIS Edit tool?

[pcreso at pcreso.com]

Hi,

You can open the same table twice, with a query limiting the records plotted to just the one(s) you want to edit, overlaid on the other with as many lines as you need for context. 

Changes are cached until saved, so you can save changes then re-edit if required, but this is simple enough. I'm not aware of any application that edits the underlying data directly, they all apply edits to the in-memory version first.

I have been using it for a similar process recently, but with a smaller line dataset, but some 100,000 background points I'm navigating the lines through. Works for me...

Cheers,

   Brent Wood


--- On Sat, 11/1/08, Sufficool, Stanley <ssufficool at rov.sbcounty.gov> wrote:

> From: Sufficool, Stanley <ssufficool at rov.sbcounty.gov>
> Subject: RE: [postgis-users] Live PostGIS Edit tool?
> To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Date: Saturday, November 1, 2008, 6:49 AM
> 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
> > 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users