Hi > "user needs to add new features with the neighbouring parcel search" > Why should it duplicate parcels ? > > If you have Feature1 on the layer, zoom to it with some marginal and find > features around it with BBOX query it will find also Feature1 from the > database and then you will have two of thems. Same situation if you do > "distance within" by using Feature1 as reference geometry. "Touches" query > should work without selecting the same feature again from the database but it > is not good in practise because if neighbouring parcel does not touch but it > is only a few meters apart then user should have also that in the project. Sorry, I still can't see what is the use case. The user wants to update a big postgis table containing parcels right ?
We suppose the table contains a unique id. The user queries the table, downloading features included in the region of interest (e.g. select * from from table where ST_DWithin() < 1000) - he can add a feature then commit change to the table with Save as PostGIS table using id (update option). New feature must have an id unique in the full table (uising a database identifier is one of your previous request, right ? It is not yet implemented) - he can modify a feature then commit change to the table with Save as PostGIS table using id (update option) - he CANNOT delete a feature then commit its change as all features outside the region of interest would be deleted from the table ! I canot see any reason to have duplicates though. Does your user work with a single layer or two layers ? With a single layer : Either with DataStoreDataSource (dynamic link) or with DataStoreQueryDataSource (query-on-demand), any refresh operation completely replace the layer content with the one queried from the database. -> he can loose his work if he does not commit (see the video), but I can't see a reason to get duplicates. With two layers (one use as a reference the other to edit features) After an edit operation and until commit, the user will have old feature in the reference layer and new feature in the editing layer. If he uses an id to commit, the new feature should replace the old one in the table and the reference layer should be updated (either dynamically or on-demand depending on the way you have created the reference layer) Not sure if I describe the same use case as you. Let me know. Michaël > -Jukka- > >>> Editing layers which do not fit totally into OJ memory is not simple but it >>> would be very good to make is work because such big datasets are not at all >>> uncommon. >> Yes, it would be very interesting, and there still is much work to do ;-) > Michaël >> -Jukka- >> >> >> ________________________________________ >> Lähettäjä: Michaël Michaud [michael.mich...@free.fr] >> Lähetetty: 18. marraskuuta 2012 23:05 >> Vastaanottaja: jump-pilot-devel@lists.sourceforge.net >> Aihe: Re: [JPP-Devel] Can not read PostGIS projects >> >> Hi >>> 1 - try to link the postgis writer to query-on-demand rather than >>> dynamic query >>> With query-on-demand, there is now the possibility to synchronise the >>> view with >>> the database on user-demand (RefreshDataStoreQueryPlugIn) >> Made some progress with this idea. This is not as user friendly as it >> could be, but >> it is now possible to read/write postgis table from the same datasource. >> >> When a layer is saved in a table, OpenJUMP creates a >> DataStoreQueryDataSource >> on this layer (query on demand) with the following query : >> "select * from table limit 100000" >> >> This way, the layer will be saved in the project with this query, and it >> is possible >> to update the table from the database (refresh) or to update the >> database from >> the layer (save as). >> >> I uploaded a small video to show how PostGIS writer and Datastore table >> work >> together : >> http://geo.michaelm.free.fr/OpenJUMP/resources/video/ >> >> Next on the list is the identifier stuff (how to create a unique >> identifier in the >> database and use it for updates. >> >> Michaël >>> 2 - make editing more dynamic so that each user action >>> (creation/modification/deletion) is immediately and automatically >>> commited in the database 3 - create a more transactional mechanism >>> where edit can be saved in the context of a dynamic layer and >>> committed on demand I think the first one is the only one I'll be able >>> to work on before a final 1.6 release. Second and third one need >>> probably much work. I think kosmo use a transactionnal model. Would be >>> useful to study how they manage that. Thanks for your always valuable >>> inputs. Michaël -Jukka- Michaël >>>>> -Jukka Rahkonen- >>>>> ________________________________________ >>>>> Lähettäjä: Stefan Steiniger [sst...@geo.uzh.ch] >>>>> Lähetetty: 17. marraskuuta 2012 21:11 >>>>> Vastaanottaja: OpenJump develop and use >>>>> Aihe: Re: [JPP-Devel] Can not read PostGIS projects >>>>> >>>>> Hi Michael, >>>>> >>>>> sounds reasonable to me. But we would need to add a comment on that... >>>>> When the project is saved, it would mean to send a message to the user >>>>> at save time? >>>>> >>>>> thanks for working on this - on the weekend! >>>>> stefan >>>>> >>>>> Am 17.11.12 15:17, schrieb Michaël Michaud: >>>>>> Hi Uwe, others, >>>>>> >>>>>> I'd like to have PostGIS users feedback about the following question : >>>>>> Save as PostGIS table can save a layer as a new PostGIS table >>>>>> or update an existing PostGIS table with different options. >>>>>> >>>>>> IMHO, only the first option (create new table) should set the postgis >>>>>> table as the new Datasource for the layer (and save it in the project). >>>>>> >>>>>> In other cases, the layer may contain only a few features and >>>>>> the table we connect to maybe a huge table. Setting this huge table >>>>>> as the new datasource may freeze the application. >>>>>> >>>>>> Any comment ? >>>>>> >>>>>> Michaël >>>>>> >>>>>>> Uwe, Landon, >>>>>>> >>>>>>> I had forgotten Uwe's mail, but I now have added a bug report >>>>>>> and will tackle it before 1.6 final release. >>>>>>> >>>>>>> Michaël >>>>>>>> Hi Landon, >>>>>>>> >>>>>>>> no, I got no response. >>>>>>>> >>>>>>>> I tested it now again with the latest nightbuild >>>>>>>> (Version 20121111 snapshot rev.3073), but I have the >>>>>>>> same problem. >>>>>>>> >>>>>>>> Regards >>>>>>>> >>>>>>>> Uwe >>>>>>>> >>>>>>>> Am 12.11.2012 17:26, schrieb Landon Blake: >>>>>>>>> Uwe: >>>>>>>>> >>>>>>>>> Did you ever get a response or a solution to this problem? >>>>>>>>> >>>>>>>>> Landon >>>>>>>>> >>>>>>>>> On Mon, Sep 24, 2012 at 12:00 AM, Uwe Dalluege >>>>>>>>> <uwe.dallu...@hcu-hamburg.de> wrote: >>>>>>>>>> Hi, >>>>>>>>>> >>>>>>>>>> I can not read projects with PostGIS layer. >>>>>>>>>> OJ Version 20120924 snapshot rev.3004 >>>>>>>>>> OS: W7 (64 bit) and XP (32 bit). >>>>>>>>>> >>>>>>>>>> 1. Add A New Layer. >>>>>>>>>> 2. Draw a geometry. >>>>>>>>>> 3. Save the layer to PostGIS with Save Dataset As. >>>>>>>>>> 4. Save Project As... >>>>>>>>>> >>>>>>>>>> 5. When I open the project again the project is empty >>>>>>>>>> and the category System is deleted. >>>>>>>>>> >>>>>>>>>> Regards >>>>>>>>>> >>>>>>>>>> Uwe >>>>>>>>>> >>>>>>>>>> ------------------------------------------------------------------------------ >>>>>>>>>> Live Security Virtual Conference >>>>>>>>>> Exclusive live event will cover all the ways today's security and >>>>>>>>>> threat landscape has changed and how IT managers can respond. >>>>>>>>>> Discussions >>>>>>>>>> will include endpoint security, mobile security and the latest in >>>>>>>>>> malware >>>>>>>>>> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ >>>>>>>>>> _______________________________________________ >>>>>>>>>> Jump-pilot-devel mailing list >>>>>>>>>> Jump-pilot-devel@lists.sourceforge.net >>>>>>>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>>>>> ------------------------------------------------------------------------------ >>>>>>>> Monitor your physical, virtual and cloud infrastructure from a single >>>>>>>> web console. Get in-depth insight into apps, servers, databases, >>>>>>>> vmware, >>>>>>>> SAP, cloud infrastructure, etc. Download 30-day Free Trial. >>>>>>>> Pricing starts from $795 for 25 servers or applications! >>>>>>>> http://p.sf.net/sfu/zoho_dev2dev_nov >>>>>>>> _______________________________________________ >>>>>>>> Jump-pilot-devel mailing list >>>>>>>> Jump-pilot-devel@lists.sourceforge.net >>>>>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>>>>> >>>>>>>> >>>>>>> ------------------------------------------------------------------------------ >>>>>>> Monitor your physical, virtual and cloud infrastructure from a single >>>>>>> web console. Get in-depth insight into apps, servers, databases, vmware, >>>>>>> SAP, cloud infrastructure, etc. Download 30-day Free Trial. >>>>>>> Pricing starts from $795 for 25 servers or applications! >>>>>>> http://p.sf.net/sfu/zoho_dev2dev_nov >>>>>>> _______________________________________________ >>>>>>> Jump-pilot-devel mailing list >>>>>>> Jump-pilot-devel@lists.sourceforge.net >>>>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>>>> >>>>>>> >>>>>> ------------------------------------------------------------------------------ >>>>>> Monitor your physical, virtual and cloud infrastructure from a single >>>>>> web console. Get in-depth insight into apps, servers, databases, vmware, >>>>>> SAP, cloud infrastructure, etc. Download 30-day Free Trial. >>>>>> Pricing starts from $795 for 25 servers or applications! >>>>>> http://p.sf.net/sfu/zoho_dev2dev_nov >>>>>> _______________________________________________ >>>>>> Jump-pilot-devel mailing list >>>>>> Jump-pilot-devel@lists.sourceforge.net >>>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>>> >>>>> ------------------------------------------------------------------------------ >>>>> Monitor your physical, virtual and cloud infrastructure from a single >>>>> web console. Get in-depth insight into apps, servers, databases, vmware, >>>>> SAP, cloud infrastructure, etc. Download 30-day Free Trial. >>>>> Pricing starts from $795 for 25 servers or applications! >>>>> http://p.sf.net/sfu/zoho_dev2dev_nov >>>>> _______________________________________________ >>>>> Jump-pilot-devel mailing list >>>>> Jump-pilot-devel@lists.sourceforge.net >>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> Monitor your physical, virtual and cloud infrastructure from a single >>>>> web console. Get in-depth insight into apps, servers, databases, vmware, >>>>> SAP, cloud infrastructure, etc. Download 30-day Free Trial. >>>>> Pricing starts from $795 for 25 servers or applications! >>>>> http://p.sf.net/sfu/zoho_dev2dev_nov >>>>> _______________________________________________ >>>>> Jump-pilot-devel mailing list >>>>> Jump-pilot-devel@lists.sourceforge.net >>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>> >>>>> >>>> ------------------------------------------------------------------------------ >>>> Monitor your physical, virtual and cloud infrastructure from a single >>>> web console. Get in-depth insight into apps, servers, databases, vmware, >>>> SAP, cloud infrastructure, etc. Download 30-day Free Trial. >>>> Pricing starts from $795 for 25 servers or applications! >>>> http://p.sf.net/sfu/zoho_dev2dev_nov >>>> _______________________________________________ >>>> Jump-pilot-devel mailing list >>>> Jump-pilot-devel@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>> >>>> ------------------------------------------------------------------------------ >>>> Monitor your physical, virtual and cloud infrastructure from a single >>>> web console. Get in-depth insight into apps, servers, databases, vmware, >>>> SAP, cloud infrastructure, etc. Download 30-day Free Trial. >>>> Pricing starts from $795 for 25 servers or applications! >>>> http://p.sf.net/sfu/zoho_dev2dev_nov >>>> _______________________________________________ >>>> Jump-pilot-devel mailing list >>>> Jump-pilot-devel@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>> >>>> >>> ------------------------------------------------------------------------------ >>> Monitor your physical, virtual and cloud infrastructure from a single >>> web console. Get in-depth insight into apps, servers, databases, vmware, >>> SAP, cloud infrastructure, etc. Download 30-day Free Trial. >>> Pricing starts from $795 for 25 servers or applications! >>> http://p.sf.net/sfu/zoho_dev2dev_nov >>> _______________________________________________ >>> Jump-pilot-devel mailing list >>> Jump-pilot-devel@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>> >>> >> ------------------------------------------------------------------------------ >> Monitor your physical, virtual and cloud infrastructure from a single >> web console. Get in-depth insight into apps, servers, databases, vmware, >> SAP, cloud infrastructure, etc. Download 30-day Free Trial. >> Pricing starts from $795 for 25 servers or applications! >> http://p.sf.net/sfu/zoho_dev2dev_nov >> _______________________________________________ >> Jump-pilot-devel mailing list >> Jump-pilot-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> >> ------------------------------------------------------------------------------ >> Monitor your physical, virtual and cloud infrastructure from a single >> web console. Get in-depth insight into apps, servers, databases, vmware, >> SAP, cloud infrastructure, etc. Download 30-day Free Trial. >> Pricing starts from $795 for 25 servers or applications! >> http://p.sf.net/sfu/zoho_dev2dev_nov >> _______________________________________________ >> Jump-pilot-devel mailing list >> Jump-pilot-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> >> > > ------------------------------------------------------------------------------ > Monitor your physical, virtual and cloud infrastructure from a single > web console. Get in-depth insight into apps, servers, databases, vmware, > SAP, cloud infrastructure, etc. Download 30-day Free Trial. > Pricing starts from $795 for 25 servers or applications! > http://p.sf.net/sfu/zoho_dev2dev_nov > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > ------------------------------------------------------------------------------ > Monitor your physical, virtual and cloud infrastructure from a single > web console. Get in-depth insight into apps, servers, databases, vmware, > SAP, cloud infrastructure, etc. Download 30-day Free Trial. > Pricing starts from $795 for 25 servers or applications! > http://p.sf.net/sfu/zoho_dev2dev_nov > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > > ------------------------------------------------------------------------------ Monitor your physical, virtual and cloud infrastructure from a single web console. Get in-depth insight into apps, servers, databases, vmware, SAP, cloud infrastructure, etc. Download 30-day Free Trial. Pricing starts from $795 for 25 servers or applications! http://p.sf.net/sfu/zoho_dev2dev_nov _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
