Hi Michaël, thank you for clarification!
Regards Uwe Am 08.10.2014 um 21:15 schrieb Michael Michaud: > Hi Uwe, > > You're not supposed to use the new driver this way. > Why would you like to upload your table twice ? > > When you upload your layer the first time, gid attribute > is added to the database schema, then the dataset is extracted > with the new attribute. > Now, thanks to the gid, OpenJUMP and you're database are > synchronized and next time you want to work, you're supposed > to connect to the database with open > database (read/write). > Then, you can add new features or modify database features and > commit the changes to the database. > This driver is still experimental. > > If you don't want to work this way, don't add the id when you > upload the layer. > > > Michaël > >> Hi Michaël, >> >> good idea with the variable z-value! >> Thank you, this works fine. >> >> But I see another problem: >> >> I saved the layer with the option >> "Create a primary Key column (gid) for this Table" >> This works the first time and the table has a gid-column. >> But when I try to save the layer again >> without choosing "Create a primary Key ..." I always >> receive the error-message: >> "gid column cannot be created; a gid attribute already exists in the >> layer" >> >> So I can not save the layer again. >> >> Regards >> >> Uwe >> >> >> Am 07.10.2014 um 08:27 schrieb Michael Michaud: >>> Hi Uwe, >>> >>> New option to save a layer to PostGIS with NaN to valid z >>> conversion in r4063, >>> >>> Please let me know if it works for you, and if you have some >>> screen capture or some public bundle of what you're developping, >>> I would be very curious to know more. >>> >>> Michaël >>> >>>> Hi Michaël, >>>> >>>> I am trying to develop a 2d- and 3d-GIS with JOGL >>>> and PostGIS (you can switch between 2d and 3d). >>>> The 3d-geometries are stored in PostGIS. >>>> With OpenJUMP I digitalise some geometries >>>> and stored them to PostGIS with: >>>> Save Dataset As>Write 3d geometries >>>> (PostGIS Table (new)). >>>> My program crashes because there is no valid z-coordinate. >>>> >>>> St_Force_3D ( ) crashes too: >>>> "POLYGON((60 180 1.#QNAN,75 290 1.#QNAN,300 300 1.#QNAN,361 170 >>>> 1.#QNAN,200 60 1.#QNAN,60 180 1.#QNAN))" >>>> >>>> When I save the OpenJUMP layer without >>>> "Write 3d geometries" my program works, >>>> but the table has only 2d geometries. >>>> I can use then St_Force_3D ( ) to receive >>>> 3d coordinates (with z = 0.) but this is >>>> not comfortable. >>>> >>>> I understand your "abdominal pain" to write 0. >>>> instead NaN but I think the geometries I >>>> digitalise with OpenJUMP have always z = 0. >>>> >>>> Thank you for thinking about may problem! >>>> >>>> Greetings from Hamburg >>>> >>>> Uwe >>>> >>>> >>>> Am 02.10.2014 um 08:50 schrieb Michael Michaud: >>>>> Hi Uwe, >>>>> >>>>> I suppose you are refering to the Save to PostGIS table (New) loader >>>>> as the previous one has no 3D option. >>>>> Could you tell me what your use case is ? >>>>> I think it is not too complex to set the z to 0 while saving a dataset >>>>> into postgis, but I'm a bit reluctant as NaN may have a different >>>>> semantic (unknown, unset) which will be lost if the z is set to 0. >>>>> On the other hand, it seems that the posgis st_force3d function >>>>> set the z to 0 (I did not check though). >>>>> >>>>> Michaël >>>>>> Hi, >>>>>> >>>>>> Save Dataset As>Save to PostGIS Table>Write 3d geometries >>>>>> writes NaN for the z-coordinate. >>>>>> Is it possible to write 0.0 (zero) instead NaN >>>>>> for the z-coordinate? >>>>>> >>>>>> I use OJ Version 20140924 snapshot rev.4056 >>>>>> >>>>>> >>>>>> Regards >>>>>> >>>>>> Uwe >>>>>> >>>>>> ------------------------------------------------------------------------------ >>>>>> >>>>>> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer >>>>>> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS >>>>>> Reports >>>>>> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper >>>>>> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer >>>>>> http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk >>>>>> >>>>>> _______________________________________________ >>>>>> Jump-pilot-devel mailing list >>>>>> Jump-pilot-devel@lists.sourceforge.net >>>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>>> >>>>> >>>>> ------------------------------------------------------------------------------ >>>>> >>>>> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer >>>>> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS >>>>> Reports >>>>> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper >>>>> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer >>>>> http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk >>>>> >>>>> _______________________________________________ >>>>> Jump-pilot-devel mailing list >>>>> Jump-pilot-devel@lists.sourceforge.net >>>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>>> >>>> ------------------------------------------------------------------------------ >>>> >>>> Slashdot TV. Videos for Nerds. Stuff that Matters. >>>> http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk >>>> >>>> _______________________________________________ >>>> Jump-pilot-devel mailing list >>>> Jump-pilot-devel@lists.sourceforge.net >>>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>>> >>>> >>> >>> >>> ------------------------------------------------------------------------------ >>> >>> Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer >>> Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports >>> Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper >>> Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer >>> http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk >>> >>> _______________________________________________ >>> Jump-pilot-devel mailing list >>> Jump-pilot-devel@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >>> >> > ------------------------------------------------------------------------------ Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
