Michaël Michaud wrote: >> 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 ? 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. -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
