[postgis-users] Shapes to PG

[Luigi Castro Cardeles]

Hi,

you can use phppggis to see your geometry using mapserver (this tool put a
hiperlink on the geom and opens a popup to show an image of your geometry).
But if you want to see if your data is valid or not, use isvalid like paul
said.

best regards.

2009/1/26 Neil.Young <Neil.Young at freenet.de>

> Nicolas Ribot schrieb:
>
>> ?? What kind of "admin" is that? What chance of checking, whether the_geom
>>> is valid or not, do I have?
>>>
>>>
>>>
>>
>> Well, pgAdmin is intended to administrate PostgreSQL, not postGIS and
>> its geometries.
>> To check your geometries for nullity or validity, SQL seems to be your
>> friend:
>>
>> select count(*) from my_table where the_geom is null;
>> select distinct st_isvalid(the_geom) from my_table; -- for OGC validity
>> etc.
>>
>> HTH
>> Nicolas
>>
>>
> The first returns 0 of 5204 records.
> The output of the latter I don't understand (see screenshot)
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>


-- 
Luigi Castro Cardeles
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090126/6c9abe89/attachment.html>