[postgis-users] Shapes to PG

[Neil.Young]

?? What kind of "admin" is that? What chance of checking, whether 
the_geom is valid or not, do I have?



Paul Ramsey schrieb:
> select st_area(the_geom) from onb;
>
> You *cannot* use the visibility/non-visibility of fields in PgAdmin as
> any indicator of the presence/absence of geometry data in the record,
> because PgAdmin tosses things that are too long to display and *many*
> geometries fall into that category.
>
> On Mon, Jan 26, 2009 at 8:28 AM, Neil.Young <Neil.Young at freenet.de> wrote:
>   
>> Nicolas Ribot schrieb:
>>     
>>>> 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.
>>>>
>>>>
>>>>         
>>> To "see" the geometries, or at least to display their coordinates in a
>>> friendly manner, you should convert them to a textual representation:
>>>
>>> select st_astext(the_geom) from onb;
>>>
>>> Nicolas
>>>
>>>       
>> Hi Nicolas,
>>
>> thanks for your patience, but the result is empty for some rows, for others
>> there is the WKT (see screenshot). So, I suppose, it is really not there :)
>>
>> Regards
>>
>> _______________________________________________
>> 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
>