[postgis-users] Import geometry problems

Tim Semmelhaack semmelhaack at gmail.com
Sat Feb 27 12:39:03 PST 2010


Thank you Nicklas!

It was just the "problem" with pgAdmin.

Tim

2010/2/27 Nicklas Avén <nicklas.aven at jordogskog.no>:
> Hallo Tim
>
>
> What do you mean by "not working". That the cell seems to be empty is just
> something pgAdmin does for big geometries.
> It still is there.
>
> You can test it by running for example:
> select ST_Length(the_geom) from "infra"."linienverlauf_gis_temp";
>
> If you get a length value for each row there is no problem.
>
> Hope that helps
> Nicklas
>
> 2010-02-27 Tim Semmelhaack wrote:
>
> Hello,
>>
>>I created a sql-file with shp2pgsql from a ArcGIS-Shapefile with
>> linestrings.
>>
>>Some datasets compromises long strings in the geometry field (> 5000
>> characters)
>>After the import the geometry is blank, others fields with a shorter
>>string are filled.
>>
>>I attached the sql-file, (the geometry looks strange but these are bus
>>routes in the rural area !).
>>The first dataset doesn't work, the second one does.
>>
>>I've created the files with windows but also with linux - same result.
>>
>>Any explanations, suggestions?
>>
>>
>>--
>>Tim
>>
>>_______________________________________________
>>postgis-users mailing list
>>postgis-users at postgis.refractions.net
>>http://postgis.refractions.net/mailman/listinfo/postgis-users
>>
>>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>



-- 
Tim Semmelhaack
Kantstr. 2c
28201 Bremen



More information about the postgis-users mailing list