#zoo_square_meter.conf file for data stored at URI.
# August 24, 2006.  Change login string.  rcg
# January 22, 2003.  Change password.  Change sql_script to point
#	to ".active".
# August 1, 2001.  Edit password since MC changed it.
# May 15, 2000 Add cache_clean_up, cache_root and debug
# November 9, 1998
datafile=/data/pgarrahan/dbaccess/zoo_square_meter.dat
login=groman/$diamond@orcl
#login=groman/diamond@ORC1
#Two tables needed at level 1 and lower in order to define the where 
#	clause correctly
tables_for_level_0=globec.cruises
tables_for_level_1=globec.cruises, globec.stations
tables_for_level_2=globec.stations, globec.tows
tables_for_level_3=globec.tows, globec.nets
tables_for_level_4=globec.nets, globec.m2_counts
#
sqlplus=/u01/app/oracle/product/8.0.5/bin/sqlplus
sql_script=/data/pgarrahan/dbaccess/scripts/get_oracle_dbms.active
order_by_level_0=cruiseid
order_by_level_1=station, depth_w
order_by_level_2=event
order_by_level_3=net
order_by_level_4=taxon
last_level=4
logfile=/data/pgarrahan/dbaccess/logs/zoo_square_meter.log
where_clause_added_for_level_2=globec.tows.inst in ('MOC1', 'Pump', 'Bongo')
replace_time_utc_begin=to_char(time_utc_begin,'YYYY/MM/DD/HH24:MI')
replace_time_utc_end=to_char(time_utc_end,'YYYY/MM/DD/HH24:MI')
debug=no
cache_root=/data/pgarrahan/dbaccess/cache_square
cache_clean_up=no