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
