[postgis-users] Spatial database book

[Manuel Weindorf]

In fact it's a good introduction to the concept of postgreSQL
(better for people which don't already know postgreSQL) 

The section has almost 9 pages (same amount as Oracles SDO ;-))

Theres 
- a list of supported geometric types with their string-representations
- a list of operators
- a dicussion of capabilities (rtree indexing, user defined types) and missing 
features ( e.g. sets of polygons, computation of intersection of polygons, 
operators do not allow the contsruction of new geometric objects (e.g. as a 
result of intersection) etc.)

- an example of creating a db-schema with 4 tables using primary keys and 
foreign keys 
- examples of queries with alphanumeric criteria, spatial criteria, spatial 
joins
 
PostGIS is not mentioned yet. 

All in all it's good to read about an open-source product in the direct 
neighbourhood of commercial products (Oracle, ArcSDE, Smallworld, ArcInfo, 
ArcView)

Manuel

> Anyone read this one?
>
> Spatial Databases: With Application to GIS
>  by Philippe Rigaux, Michel O. Scholl, Agnes Voisard
>
> It has a section (like a few pages) on Postgresql specifically. I'm told it
> is really good - what do postgis users think?
>
> Tyler
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
Manuel Weindorf (weindorf at ipf.uni-karlsruhe.de)
Institut fuer Photogrammetrie und Fernerkundung, Universitaet Karlsruhe
Postfach 6980 D-76128 Karlsruhe, Tel. +49 721 608-6010 Fax +49 721 608-8450
http://www-ipf.bau-verm.uni-karlsruhe.de