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

List:       postgis-users
Subject:    Re: [postgis-users] Documentation lacking & AddGeometryColumn
From:       David TECHER <davidtecher () yahoo ! fr>
Date:       2004-07-22 11:11:19
Message-ID: 20040722111119.62296.qmail () web25207 ! mail ! ukl ! yahoo ! com
[Download RAW message or body]

--- "Boyce, Greg" <GBoyce@NRCan.gc.ca> a écrit : > And
if I might add, the documentation has problems,
> and is skimpy
> in many areas:
> 
> 1 What version of PostGIS does the online docs
> correspond to?
> 

0.8.2 : Paul ramsey made the update few weeks ago
> 
> 2 There's no search function in the online docs
> 

just instal pgadmin III, you will see every functions
that you need but just the function's name

> 3 There are very few or no examples in the "OpenGIS
> Functions"
> and "Other Functions" sections.
> 

Postgis distribution came with few examples at 

postgis-0.8.2/examples/ogc_test_suite that you can see
at http://svg.cc/pg/ogc in SVG done by Klaus Foerster



> 4 The OpenGIS function, SetSRID, is missing the SRID
> in the 
> definition.
> 
> 5 Conflicting information on the AddGeometryColumn
> function.  Is
> it <db_name> or <schema_name>?
> Chapter 4. Creating a spatial table:
> 
> http://postgis.refractions.net/docs/x321.html#AEN391
> says 
> 	AddGeometryColumn(<db_name>, <table_name>,
> <column_name>, ...
> 	SELECT AddGeometryColumn('roads_db', 'roads_geom',
> 'geom', ...
> 
> Yet in Chapter 5. -- OpenGIS Functions:
> 	http://postgis.refractions.net/docs/c673.html
> it says
> 	AddGeometryColumn(<schema_name>, <table_name>,
> <column_name>, ...
> (What do mean by saying that schema_name is a
> table schema?)
> 
> The example given in the recent MUM presentation
> on Mapserver & 
> PostGIS uses [dbname].
> 
> 6 I've a database called "magdb".  I add the
> geometry column:
> 	SELECT AddGeometryColumn('magdb', 'surveys2',
> 'boundary', -1,
> 'POLYGON', 2);
> and it gives an Notice message:
> 	NOTICE:  Invalid schema name - using
> current_schema()
> 	CONTEXT:  PL/pgSQL function "addgeometrycolumn"
> line 4 at select
> into variables
> addgeometrycolumn
> 
> The geometry_columns table contains (note the
> "public" not "magdb"):
> 	 f_table_catalog | f_table_schema | f_table_name |
> f_geometry_column
> > coord_dimension | srid |  type   | attrelid |
> varattnum | stats 
> 
-----------------+----------------+--------------+-------------------+------
> 
-----------+------+---------+----------+-----------+-------
> > public         | surveys2     |
> boundary          |
> 2 |   -1 | POLYGON |   299809 |         3 | 
> 
> A DropGeometryColumn on "magdb" of course doesn't
> work!
> 	SELECT DropGeometryColumn('magdb', 'surveys',
> 'boundary27');
> 
> What's wrong?  (I'm using PostgreSQL 7.4.3 and
> PostGIS 0.8.2)
> 
> 
> Many thanks,
> Greg Boyce
> ___________________________________________________
> Regional Geophysics section    /   Section de la
> géophysique régionale
> Geological Survey of Canada    /   Commission
> Géologique du Canada
> Natural Resources Canada       /   Ressources
> naturelles Canada
> Government of Canada           /   Gouvernement du
> Canada
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> 
http://postgis.refractions.net/mailman/listinfo/postgis-users
> 


	

	
		
Créez gratuitement votre Yahoo! Mail avec 100 Mo de stockage !
Créez votre Yahoo! Mail sur http://fr.benefits.yahoo.com/

Yahoo! Messenger: dialoguez instantanément avec vos amis. Téléchargez GRATUITEMENT \
sur http://fr.messenger.yahoo.com


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