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
