Hi, One more thing to think about: user selects all the parcels belonging to a farm with ID=1234 and makes a query layer as "SELECT * from parcels WHERE FARM_ID=1234". However, in real life it is very unsafe to edit geometries in this state (editing attributes is ok) because selected parcels can have neighbours from another farms. Good way to edit is to zoom into one parcel and and make a new query (BBOX or Intersects the selected parcel, or perhaps best, DWithin 100 m from selected parcel). Otherwise users will make overlaps or create gaps between the parcels and ruin the topological quality of the data.
Challange: How to handle query layers if user needs to add new features with the neighbouring parcel search? These additions will also give dublicates as some parcels have already fetched from the database. Dublicates could be filtered out by IDs but it is also possible that user has edited some parcel but it is not saved yet and search for neighbours will give a parcel with the same ID but old geometry or attributes. It means that the system for eliminating dublicates should be designed so that it removes the correct dublicates. 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. -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
