Regaring surveys... I have yet another question: What PostGIS/PostgreSQL admin tools are you using?
I think up to now there have been three possibilities: 1. GIS built in (GUI) 2. psql (CLI) 3. pgAdminIII (GUI) Recently I've found a nice alternative to 3. pgAdminIII, called: 4. "SQL Workbench/J" (www.sql-workbench.net). Stefan NOTE: Download SQL Workbench/J development build 102.8 (2008-12-31) or later! In order to display geometry data as text (i.e. as WKT) in SELECT statements, follow the following instructions (from: http://www.sql-workbench.net/dev-history.txt > Build 102.8, 31.12.2008) > Enh: (102.7) for specific datatypes, data retrieval in the DbExplorer can now > be done by applying expressions to the column when building the SQL > to select the data. So, for every DB there are configurations entries in a file called "workbench.settings" (Windows users look at "C:\Documents and Settings\<user>\.sqlworkbench\"). There, the following line has to be inserted: workbench.db.postgres.selectexpression.geometry=astext(transform(${column},4326)) Now, for SELECT statements in the DbExplorer view of SQL Workbench/J all column values of type geometry get through this function. _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
