[postgis-users] Shapes to PG

[Paul Ramsey]

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
>
>