[postgis-users] Shapes to PG

[Neil.Young]

Nicolas Ribot schrieb:
>> If I copy&paste this line manually into the pgadmin script window, it looks
>> as whether the spacial data is not present (don't know, whether I can make
>> this clear, so I've attached a screenshot). However, Flensburg and others
>> don't have a the_geometry at all...
>>
>>     
>
> PgAdmin is not the right tool to check if you have spatial data in
> your table, as it fails at representing long lines.
> You should make an sql query to check the data validity, type or
> nullity, something like:
> select distinct geometrytype(the_geom) from onb;
>
>   
OK, my selection was

select * from onb

This comes up with a couple of lines, containing the_geometry and much more, not containing a value in this column.


Regards