[postgis] SFSQL Metadata Views

Dave Blasby dblasby at refractions.net
Tue Jun 26 16:04:19 PDT 2001

>However, currently there is no real support for metadata of any kind.
> The SF-SQL specification includes two "Feature Table Metadata Views":
>  o GEOMETRY_COLUMNS: Associates geometry columns with a spatial reference
>    system id, a geometry type (restricting the columns to lines for instance),
>    and a dimension.
>  o SPATIAL_REFERENCE_SYSTEMS: Associates spatial reference system id with
>    their well known text equivelent.

I've been looking into that today, and we could probably write some
triggers and stored procedures to keep GEOMETRIC_COLUMNS updated.

We'll need to have some way of restricting a GEOMETRY column to be, say,
a LINESTRING.  I dont want to have to read a system table on every
INSERT or UPDATE.  Any ideas?

We'll also have to do something with the Spatial Reference System.  I'm
actually looking at that right now since I want to add a length()
function that works on a ellipsoid.  


To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com


Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 

More information about the postgis-users mailing list