[postgis-devel] [PostGIS] #1106: OpenJump (JTS): Unknown WKB type 48

PostGIS trac at osgeo.org
Tue Jul 5 18:46:40 PDT 2011 

#1106: OpenJump (JTS): Unknown WKB type 48
-----------------------+----------------------------------------------------
 Reporter:  aperi2007  |       Owner:  pramsey      
     Type:  defect     |      Status:  new          
 Priority:  critical   |   Milestone:  PostGIS 2.0.0
Component:  postgis    |     Version:  trunk        
 Keywords:             |  
-----------------------+----------------------------------------------------

Comment(by robe):

 If I compare the estimated extent to actual extent its way off.


 {{{
 select ST_Extent(geom) from tl_2010_25_zcta510;

 yields:
 BOX(-73.508142 41.230015,-69.923562 42.88679)
 }}}


 {{{
  select st_estimated_extent('public','tl_2010_25_zcta510','geom');

 Yields:
 BOX(59157111109.9236 0,0 0)
 }}}

 which also doesn't seem to agree with QGIS

 The other commands it runs is this:


 Just in case I missed an important query -- this is the full log from when
 I started using QGIS:


 {{{
 2011-07-05 21:34:59 EDT LOG:  statement: set client_encoding to 'UNICODE'
 2011-07-05 21:34:59 EDT LOG:  statement: SET application_name='Quantum
 GIS'
 2011-07-05 21:34:59 EDT LOG:  statement: select
 f_table_name,f_table_schema,f_geometry_column,upper(type),pg_class.relkind
 from geometry_columns,pg_class,pg_namespace where relname=f_table_name and
 f_table_schema=nspname and pg_namespace.oid=pg_class.relnamespace and
 has_schema_privilege(pg_namespace.nspname,'usage') and
 has_table_privilege('"'||pg_namespace.nspname||'"."'||pg_class.relname||'"','select')
 order by f_table_schema,f_table_name,f_geometry_column
 2011-07-05 21:34:59 EDT LOG:  statement: select
 f_table_name,f_table_schema,f_geography_column,upper(type),pg_class.relkind
 from geography_columns,pg_class,pg_namespace where relname=f_table_name
 and f_table_schema=nspname and pg_namespace.oid=pg_class.relnamespace and
 has_schema_privilege(pg_namespace.nspname,'usage') and
 has_table_privilege('"'||pg_namespace.nspname||'"."'||pg_class.relname||'"','select')
 order by f_table_schema,f_table_name,f_geography_column
 2011-07-05 21:34:59 EDT LOG:  statement: select
 pg_class.relname,pg_namespace.nspname,pg_attribute.attname,pg_class.relkind
 from pg_attribute,pg_class,pg_namespace where
 pg_namespace.oid=pg_class.relnamespace and pg_attribute.attrelid =
 pg_class.oid and ( exists (select * from pg_type WHERE
 pg_type.oid=pg_attribute.atttypid AND pg_type.typname IN
 ('geometry','geography')) or pg_attribute.atttypid IN (select oid FROM
 pg_type a WHERE EXISTS (SELECT * FROM pg_type b WHERE a.typbasetype=b.oid
 AND b.typname IN ('geometry','geography')))) and has_schema_privilege(
 pg_namespace.nspname, 'usage' ) and has_table_privilege( '"' ||
 pg_namespace.nspname || '"."' || pg_class.relname || '"', 'select' ) and
 not exists (select * from geometry_columns WHERE
 pg_namespace.nspname=f_table_schema AND pg_class.relname=f_table_name) and
 not exists (select * from geography_columns WHERE
 pg_namespace.nspname=f_table_schema AND pg_class.relname=f_table_name) and
 pg_class.relkind in( 'v', 'r' )
 2011-07-05 21:34:59 EDT LOG:  statement: set client_encoding to 'UNICODE'
 2011-07-05 21:34:59 EDT LOG:  statement: SET application_name='Quantum
 GIS'
 2011-07-05 21:34:59 EDT LOG:  statement: select distinct case when
 geometrytype("extent") IN ('POINT','MULTIPOINT') THEN 'POINT' when
 geometrytype("extent") IN ('LINESTRING','MULTILINESTRING') THEN
 'LINESTRING' when geometrytype("extent") IN ('POLYGON','MULTIPOLYGON')
 THEN 'POLYGON' end from "public"."raster_columns"
 2011-07-05 21:35:02 EDT LOG:  statement: set client_encoding to 'UNICODE'
 2011-07-05 21:35:02 EDT LOG:  statement: select postgis_version()
 2011-07-05 21:35:02 EDT LOG:  statement: select
 postgis_geos_version(),postgis_proj_version()
 2011-07-05 21:35:02 EDT LOG:  statement: SET application_name='Quantum
 GIS'
 2011-07-05 21:35:02 EDT LOG:  statement: select postgis_version()
 2011-07-05 21:35:02 EDT LOG:  statement: select
 postgis_geos_version(),postgis_proj_version()
 2011-07-05 21:35:02 EDT LOG:  statement: select * from
 "public"."tl_2010_25_zcta510" limit 1
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT pg_is_in_recovery()
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT
 has_table_privilege('"public"."tl_2010_25_zcta510"','DELETE'),has_any_column_privilege('"public"."tl_2010_25_zcta510"','UPDATE'),has_column_privilege('"public"."tl_2010_25_zcta510"','geom','UPDATE'),has_table_privilege('"public"."tl_2010_25_zcta510"','INSERT'),current_schema()
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT 1 FROM
 pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND
 pg_get_userbyid(relowner)=current_user AND relname='tl_2010_25_zcta510'
 AND nspname='public'
 2011-07-05 21:35:02 EDT LOG:  statement: select type,srid from
 geometry_columns where f_table_name='tl_2010_25_zcta510' and
 f_geometry_column='geom' and f_table_schema='public'
 2011-07-05 21:35:02 EDT LOG:  statement: select
 regclass('"public"."tl_2010_25_zcta510"')::oid
 2011-07-05 21:35:02 EDT LOG:  statement: BEGIN READ ONLY
 2011-07-05 21:35:02 EDT LOG:  statement: declare oidcursor binary cursor
 for select regclass('"public"."tl_2010_25_zcta510"')::oid
 2011-07-05 21:35:02 EDT LOG:  statement: fetch forward 1 from oidcursor
 2011-07-05 21:35:02 EDT LOG:  statement: CLOSE oidcursor
 2011-07-05 21:35:02 EDT LOG:  statement: COMMIT
 2011-07-05 21:35:02 EDT LOG:  statement: select indkey from pg_index where
 indisunique and indrelid=regclass('"public"."tl_2010_25_zcta510"')::oid
 and indpred is null
 2011-07-05 21:35:02 EDT LOG:  statement: select attname,pg_type.typname
 from pg_attribute,pg_type where atttypid=pg_type.oid and attnum=1 and
 attrelid=regclass('"public"."tl_2010_25_zcta510"')
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT column_default FROM
 information_schema.columns WHERE column_default IS NOT NULL AND
 table_schema = 'public' AND table_name = 'tl_2010_25_zcta510' AND
 column_name = 'gid'
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT
 regclass('"public"."tl_2010_25_zcta510"')::oid
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT description FROM
 pg_description WHERE objoid=135250 AND objsubid=0
 2011-07-05 21:35:02 EDT LOG:  statement: select * from
 "public"."tl_2010_25_zcta510" limit 0
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT
 typname,typtype,typelem,typlen FROM pg_type WHERE oid=23
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT attnum FROM pg_attribute
 WHERE attrelid=135250 AND attname='gid'
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT description FROM
 pg_description WHERE objoid=135250 AND objsubid=1
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT
 typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT attnum FROM pg_attribute
 WHERE attrelid=135250 AND attname='statefp10'
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT description FROM
 pg_description WHERE objoid=135250 AND objsubid=2
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT
 typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT attnum FROM pg_attribute
 WHERE attrelid=135250 AND attname='zcta5ce10'
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT description FROM
 pg_description WHERE objoid=135250 AND objsubid=3
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT
 typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT attnum FROM pg_attribute
 WHERE attrelid=135250 AND attname='geoid10'
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT description FROM
 pg_description WHERE objoid=135250 AND objsubid=4
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT
 typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT attnum FROM pg_attribute
 WHERE attrelid=135250 AND attname='classfp10'
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT description FROM
 pg_description WHERE objoid=135250 AND objsubid=5
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT
 typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT attnum FROM pg_attribute
 WHERE attrelid=135250 AND attname='mtfcc10'
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT description FROM
 pg_description WHERE objoid=135250 AND objsubid=6
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT
 typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT attnum FROM pg_attribute
 WHERE attrelid=135250 AND attname='funcstat10'
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT description FROM
 pg_description WHERE objoid=135250 AND objsubid=7
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT
 typname,typtype,typelem,typlen FROM pg_type WHERE oid=701
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT attnum FROM pg_attribute
 WHERE attrelid=135250 AND attname='aland10'
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT description FROM
 pg_description WHERE objoid=135250 AND objsubid=8
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT
 typname,typtype,typelem,typlen FROM pg_type WHERE oid=701
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT attnum FROM pg_attribute
 WHERE attrelid=135250 AND attname='awater10'
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT description FROM
 pg_description WHERE objoid=135250 AND objsubid=9
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT
 typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT attnum FROM pg_attribute
 WHERE attrelid=135250 AND attname='intptlat10'
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT description FROM
 pg_description WHERE objoid=135250 AND objsubid=10
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT
 typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT attnum FROM pg_attribute
 WHERE attrelid=135250 AND attname='intptlon10'
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT description FROM
 pg_description WHERE objoid=135250 AND objsubid=11
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT
 typname,typtype,typelem,typlen FROM pg_type WHERE oid=1043
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT attnum FROM pg_attribute
 WHERE attrelid=135250 AND attname='partflg10'
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT description FROM
 pg_description WHERE objoid=135250 AND objsubid=12
 2011-07-05 21:35:02 EDT LOG:  statement: set client_min_messages to error
 2011-07-05 21:35:02 EDT LOG:  statement: SELECT COUNT(*) FROM pg_stats
 WHERE schemaname='public' AND tablename='tl_2010_25_zcta510' AND
 attname='geom'
 2011-07-05 21:35:02 EDT LOG:  statement: select reltuples::int from
 pg_catalog.pg_class where
 oid=regclass('"public"."tl_2010_25_zcta510"')::oid
 2011-07-05 21:35:02 EDT LOG:  statement: select
 st_estimated_extent('public','tl_2010_25_zcta510','geom')
 2011-07-05 21:35:02 EDT LOG:  statement: BEGIN READ ONLY
 2011-07-05 21:35:02 EDT LOG:  statement: declare qgisf2 binary cursor for
 select "gid",st_asbinary("geom",'NDR') from "public"."tl_2010_25_zcta510"
 where "geom" && st_setsrid('BOX3D(-1.6754578754578755 -1.0000000000000000,
 1.6754578754578755 1.0000000000000000)'::box3d,4269)
 2011-07-05 21:35:02 EDT LOG:  statement: fetch forward 200 from qgisf2
 2011-07-05 21:35:02 EDT LOG:  statement: CLOSE qgisf2
 2011-07-05 21:35:02 EDT LOG:  statement: COMMIT
 }}}

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/1106#comment:9>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.

More information about the postgis-devel mailing list