[postgis-users] Shapes to PG

Luigi Castro Cardeles luigi.cardeles at gmail.com
Mon Jan 26 11:29:17 PST 2009


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

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>

More information about the postgis-users mailing list