[postgis-users] RE: Get a Summary Statistics of Geometry Table
Rueben Schulz
r_j_schulz at yahoo.ca
Fri Oct 18 22:54:49 PDT 2002
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
More information about the postgis-users
mailing list