[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] RE: Get a Summary Statistics of Geometry Table
From:       Rueben Schulz <r_j_schulz () yahoo ! ca>
Date:       2002-10-19 5:54:49
Message-ID: 1035006896.17568.96.camel () localhost ! localdomain
[Download RAW message or body]

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@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users




[prev in list] [next in list] [prev in thread] [next in thread]