Hi Uwe, Try to add spatial index to your test tables and see what happens then. OpenJUMP is doing query as SELECT ST_AsBinary(ST_Estimated_Extent) It is fast and I think the right way to do it in OpenJUMP but I do not believe that it can work work without spatial index. http://postgis.refractions.net/documentation/manual-1.4/ST_Estimated_Extent.html
-Jukka- ________________________________________ Lähettäjä: Uwe Dalluege [uwe.dallu...@hcu-hamburg.de] Lähetetty: 28. maaliskuuta 2013 8:29 Vastaanottaja: OpenJump develop and use Cc: Michaël Michaud Aihe: Re: [JPP-Devel] Unknown WKB type 0 and change coord_dimension Hi Michaël, I see it is not so easy to find this bug. I will make some other tests and let you know. But have you tried my test I have posted at 26.03.2013 (PostGIS Layer invisible; Zoom To Full Extent)? ... I have a problem with Zoom To Full Extent with the new PostGIS reader! Using PostgreSQL 9.2.1 with PostGIS 2.0. I created two tables with SQL. This table (t_line) works fine: drop table if exists t_line; CREATE TABLE t_line ( lnr integer, geom geometry ( LINESTRING, 0 ) ); INSERT INTO t_line VALUES ( 1, ST_GeometryFromText ( 'LINESTRING ( 200.0 200.0, 250.0 230.0, 210.0 250.0 )', 0 ) ); INSERT INTO t_line VALUES ( 2, ST_GeometryFromText ( 'LINESTRING ( 100.0 100.0, 150.0 130.0, 110.0 150.0 )', 0 ) ); SELECT * FROM t_line; This table (t_line_invis) is invisible after Zoom To Full Extent: drop table if exists t_line_invis; CREATE TABLE t_line_invis ( lnr integer, geom geometry ( LINESTRING, 0 ) ); INSERT INTO t_line_invis VALUES ( 1, ST_GeometryFromText ( 'LINESTRING ( 2000.0 2000.0, 2500.0 2300.0, 2100.0 2500.0 )', 0 ) ); INSERT INTO t_line_invis VALUES ( 2, ST_GeometryFromText ( 'LINESTRING ( 1000.0 1000.0, 1500.0 1300.0, 1100.0 1500.0 )', 0 ) ); SELECT * FROM t_line_invis; ... Uwe Am 27.03.2013 19:36, schrieb Michaël Michaud: > Hi, > > I can't see the "WKB type 0" problem in the above sequence. > Is it solved or is it repeatable with another sequence. > >> No, I do not tested it with r3404+ >> but I done the modification inside the source code. >> >> Now I test r3412. >> Do you made the modification in r3412? >> >> I see that the coord_dimension has changed from 2 to 3: >> >> >> 1. I open my project GeoCity with a .jml layer >> Wohngebiet. > Did you change the dataset ? (I used Gebaeudeprivat instead) >> 2. Saving this jml-layer to PostGIS. >> 3. Close OpenJUMP (important)! >> 4. Start OJ again and open the table Wohngebiet >> in PostGIS >> 5. No Such Element Exception >> and I see no geometries > I could not reproduce this today, but I have seen that before. > I have already tried to find a solution but it's a bit tricky. > I think we will have to live with it some time... >> 6. "Zoom To Full Extent" and I see the geometries. > As I told you, full extent of a database layer can contains too > many features for OpenJUMP, and I think it is more safe not > to do it automatically after the first import. If it is not down, > the layer may be empty (probably related to the No such > element exception though) >> 7. Now I load the table again and there is no more >> the error "No Such Element Exception". > And after the first "Zoom to extent", the driver extracts data > in a zone where there IS data. >> 8. Close OJ. >> 9. Start OJ and load the table Wohngebiet. >> 10. The error "No Such Element Exception" appears. >> 11. Set srid to 31467 to the layer Wohngebiet. >> 12. Save the PostGIS layer Wohngebiet under a new name wg31467. >> 13. The coord_dimension of wg31467 is not 2 but 3! > According to my tests and to the code the geometry coord dimension > should be 2, but there may be strange behaviour as the code tests a > few geometries and if it finds a single z, it save as a GeometryZ, otherwise > it should save as Geometry. > Is it possible that you edited a z on a geometry ? >> 14. Load the table wg31467 and there are no geometries! >> No errors and no geometries. > Cannot reproduce that. > Is it possible that you have moved and that your windows do not > intersects data anymore ? > > Michaël >> >> I hope you can reproduce this. >> >> Have a nice day >> >> Uwe >> >> ------------------------------------------------------------------------------ >> Own the Future-Intel® Level Up Game Demo Contest 2013 >> Rise to greatness in Intel's independent game demo contest. >> Compete for recognition, cash, and the chance to get your game >> on Steam. $5K grand prize plus 10 genre and skill prizes. >> Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d >> _______________________________________________ >> Jump-pilot-devel mailing list >> Jump-pilot-devel@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel >> >> > > > ------------------------------------------------------------------------------ > Own the Future-Intel® Level Up Game Demo Contest 2013 > Rise to greatness in Intel's independent game demo contest. > Compete for recognition, cash, and the chance to get your game > on Steam. $5K grand prize plus 10 genre and skill prizes. > Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d > _______________________________________________ > Jump-pilot-devel mailing list > Jump-pilot-devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel > ------------------------------------------------------------------------------ Own the Future-Intel® Level Up Game Demo Contest 2013 Rise to greatness in Intel's independent game demo contest. Compete for recognition, cash, and the chance to get your game on Steam. $5K grand prize plus 10 genre and skill prizes. Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel ------------------------------------------------------------------------------ Own the Future-Intel® Level Up Game Demo Contest 2013 Rise to greatness in Intel's independent game demo contest. Compete for recognition, cash, and the chance to get your game on Steam. $5K grand prize plus 10 genre and skill prizes. Submit your demo by 6/6/13. http://p.sf.net/sfu/intel_levelupd2d _______________________________________________ Jump-pilot-devel mailing list Jump-pilot-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
