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
