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

[Rueben Schulz]

For 2) and 4) look at the postGIS documentation under OpenGIS Functions.
For 3) you can count the number of records in a table with a SQL count
function such as "select count(*) from table;"

Rueben 

On Thu, 2002-10-17 at 07:33, YC Nyon wrote:
> 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
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users