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. Yes, generally speaking editing a PosGIS table from OpenJUMP is very unsafe. However, I think in the example you give, it's up to the user to take care of his data as we cannot know if he is editing a whole dataset, or a partial dataset. > 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. Did not understand fully this use case. What do you mean with "user needs to add new features with the neighbouring parcel search" Why should it duplicate parcels ? > 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
