[postgis-users] RE: Get a Summary Statistics of Geometry Table

YC Nyon ycnyon at pd.jaring.my
Thu Oct 17 07:33:52 PDT 2002


I want to generate a summary of stastics of a table which holds the PostGIS
spatial data.
The statistics should include things like
1. Table size (bytes)
2. geographic type (point, line, polygon,etc)
3. Number of features
4. Bounding box

What would be the apppriorate SQL statement?
This query will be via PHP-Postgres connection.

Thanks
Nyon





More information about the postgis-users mailing list