[postgis-users] import large multipolygon

sub3 steve at subwest.com
Fri Jul 4 13:00:53 PDT 2008


Interesting, I run the same query & get your same results... so that shows
the object is there.  So why would astext(the_geom) return nothing?  Maybe
it doesn't return something when the size is too large?

Thanks!


Kevin Neufeld wrote:
> 
> I don't have any problems loading your sql file into my database 
> (running PG8.3.3, PGIS 1.3.3)
> 
> postgis=# \i testtable.sql
> psql:testtable.sql:3: NOTICE:  CREATE TABLE will create implicit 
> sequence "testtable_gid_seq" for serial column "testtable.gid"
> psql:testtable.sql:3: NOTICE:  CREATE TABLE / PRIMARY KEY will create 
> implicit index "testtable_pkey" for table "testtable"
> CREATE TABLE
>                        addgeometrycolumn
> --------------------------------------------------------------
>   kneufeld.testtable.the_geom SRID:-1 TYPE:MULTIPOLYGON DIMS:2
> 
> (1 row)
> 
> 
> postgis=# select ST_GeometryType(the_geom), ST_IsValid(the_geom), 
> ST_NPoints(the_geom) from testtable;
>   st_geometrytype | st_isvalid | st_npoints
> -----------------+------------+------------
>   ST_MultiPolygon | t          |       8655
> (1 row)
> 
> 
> -- Kevin
> 
> sub3 wrote:
>> Hi,
>> 
>> I am having a problem.  I convert a shp file using shp2pgsql.  One of the
>> multipolgons is very large (line is about 277k characters long).  After I
>> import into postgresql, this geometry is empty.
>> No error from postgis.
>> No error from postgresql.
>> 
>> I am only making a guess that it is the line size, I am not sure.  Is
>> there
>> a setting which would fix this?
>> 
>> Thanks for any help.
>> 
>> ---
>> Attached is the .sql script.
>> http://www.nabble.com/file/p18285042/testtable.sql testtable.sql 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> 

-- 
View this message in context: http://www.nabble.com/import-large-multipolygon-tp18285042p18285274.html
Sent from the PostGIS - User mailing list archive at Nabble.com.




More information about the postgis-users mailing list