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
