Topic:
How to export Well Symbol code from GeoFrame. 

Description:
The Well Symbol code cannot be output using the Wells and Boreholes Manager. SQL
can be used instead.

Solution:
The SQL script below will output the Borehole Name, Symbol No., Surface X and
Surface Y information to a file called 'well_symbol.txt'.  This will be written
to the default directory (geoframe37_sun or geoframe37_sgi in the user's home
directory) if run from a GF Xterm.

The script file must be created prior to using the run script command.
1)  Type out the sql script sequence (including the spooling) in the GeoFrame
	xterm.  The script can be saved by typing: save file_name.sql after it
	is run.
2)  Create the script file in an editor window and save with an sql extension,
	eg. symbol.sql
Once the file is saved, the script can be run by using the run script command:
	@file_name.sql

First login to SQLPLUS via a GF Xterm.
1)  Type sqlplus, .

2) At the prompt, type: project_name/project_password@database_server

At the SQL prompt type:
@symbol.sql  (This will run the SQL script if it exists in the default
	directory.) OR
Type out the full script with header as displayed below.

Type "exit" to disconnect from SQL.

View the file 'well_symbol.txt' at the unix level in the default directory.

Below are the contents of the script "symbol.sql":



/* Designed For:        GeoFrame 2.5x/3.x Oracle
   Function:            Extracts borehole well_symbols
                        and surface x and y locations
                        and writes to file named
                        well_symbol.txt
*/
spool well_symbol.txt
column name heading "Borehole Name" format a25
column well_symbol heading "Symbol No." format 9999999999
column storage_coord1 heading "Surface X" format 9999999999.99
column storage_coord2 heading "Surface Y" format 9999999999.99
--
--
SELECT distinct b.name,
                b.WELL_SYMBOL,
                p.storage_coord1,
                p.storage_coord2
--
FROM            borehole b,
                position p,
                well w
--
WHERE           b.container_id = w.id
        AND     p.container_id = w.id;
--
spool off



Note : Symbol codes are documented in the Online Help :

Open GeoFrame Bookshelf
Geonet > GeoFrame 3.7 > GeoFrame Bookshelf
Select Data > Data Managers > Appendix A Well Symbols





Last Modified on: 13-JUN-00