|
|
5 Aerial Sightings Tables
The following is a comprehensive listing, including attribute
names, range checks, referentials, indices, and number of records, of
all tables in the aerial sightings database.
5.1 Main Tables
5.1.1 t_flight_group
|
Comment:
|
1st of the five main tables - contains reference
data for a group of flights.
|
|
Attributes:
|
Data Type
|
Null?
|
Comment
|
|
flt_grp
|
integer
|
No
|
link between the five main tables, & with t_flt_days.
|
|
|
Range:> '0'
|
|
|
date
|
date(5)
|
No
|
date of the group of flights.
|
|
|
Range: > '19760621'.
|
|
|
pilot_code
|
smallint
|
No
|
numeric code of pilot (& observers) recording the data.
|
|
|
Range '0' i '99' i.
|
|
|
customer_code
|
smallint
|
|
numeric code for customer requesting the flight.
|
|
|
Range '0' i '99' i.
|
|
|
aircraft_code
|
integer
|
No
|
numeric code for aircraft being flown.
|
|
vessel_code
|
integer
|
|
numeric code for vessel(s) being assisted.
|
|
Creator:
|
pt
|
|
Referential:
|
pilot_code) INSERT t_pilot_code (code)
(aircraft_code) INSERT t_aircraft_code (code)
(customer_code) INSERT t_customer_code (code)
(vessel_code) INSERT t_vessel_code (code)
|
|
Indices:
|
UNIQUE BTREE ON (flt_grp)
NORMAL (2, 15) BTREE ON (date)
NORMAL (2, 15) BTREE ON (pilot_code)
NORMAL (2, 15) BTREE ON (customer_code)
NORMAL (2, 15) BTREE ON (aircraft_code)
NORMAL (2, 15) BTREE ON (vessel_code)
|
5.1.2 t_flight
|
Comment:
|
2nd of the five main tables - contains flight
duration and airfield data for individual flights - "flt_grp"
identifies a group of flights by a pilot on a single day - 10
flights is maximum and usually there are less than five.
|
|
Attributes:
|
Data Type
|
Null?
|
Comment
|
|
flt_grp
|
integer
|
No
|
link between the five main tables & with t_flt_days.
|
|
flt_num
|
smallint
|
No
|
chronological numbering of flights within a group.
|
|
flt_indx
|
longinteger
|
|
concatenation of flt_grp & flt_num (eg. flt_grp = 1,
flt_num = 1, flt_indx = 11) used for simple link with
t_school_sight (t_flight.flt_index =t_school_sight.flt_index).
|
|
up_field
|
integer
|
No
|
airfield used at takeoff.
|
|
up_time
|
integer
|
No
|
time of takeoff.
|
|
dn_field
|
integer
|
No
|
airfield used at landing.
|
|
dn_time
|
integer
|
No
|
time of landing.
|
|
hr_min
|
decimal(4,2)
|
|
duration of flight in hours & minutes ("dn_time"
minus "up_time").
|
|
hr_dec
|
decimal(4,2)
|
|
duration of flight in decimal hours ("dn_time" minus
"up_time").
|
|
Creator:
|
pt
|
|
Referential:
|
(up_field) INSERT t_airfield_code (code)
(dn_field) INSERT t_airfield_code (code)
(flt_grp) INSERT t_flight_group (flt_grp)
|
|
Indices:
|
NORMAL (2, 15) BTREE ON (up_field)
NORMAL (2, 15) BTREE ON (up_time)
NORMAL (2, 15) BTREE ON (dn_field)
NORMAL (2, 15) BTREE ON (dn_time)
NORMAL (2, 15) BTREE ON (flt_grp)
NORMAL (2, 15) BTREE ON (flt_num)
UNIQUE BTREE ON (flt_grp, flt_num)
NORMAL (2, 15) BTREE ON (flt_indx)
|
5.1.3 t_school_sight
|
Comment:
|
3rd of the five main tables - contains data on the
species sighted, estimates of tonnage, location & time of the
sighting, and some environmental data.
|
|
Attributes:
|
Data Type
|
Null?
|
Comment
|
|
flt_grp
|
integer
|
No
|
link between the five main tables & with t_flt_days.
|
|
flt_num
|
smallint
|
No
|
refers to flt_num in t_flight (i.e. Chronological numbering
of flights within a group).Equals 0 when sighting time is null or
is outside the range of flight times or no sightings were made.
|
|
flt_indx
|
longinteger
|
|
concatenation of flt_grp & flt_num (eg. flt_grp = 1,
flt_num = 1, flt_indx = 11) used for simple link with t_flight
(t_school_sight.flt_index = t_flight.flt_index).
|
|
sight_num
|
smallint
|
|
chronological numbering of sightings during a flight. Equals 0
where no sightings were made.
|
|
sgt_indx
|
longinteger
|
|
concatenation of flt_grp, flt_indx, & sight_num.
|
|
species_code
|
smallint
|
|
numeric code of sighted species - decoded using
t_species_code.
|
|
num_of_schools
|
integer
|
|
the number of schools observed in the sighting.
|
|
ton_min
|
integer
|
|
the minimum of the tonnage range of the schools observed.
|
|
ton_max
|
integer
|
|
the maximum of the tonnage range of the schools observed.
|
|
ton_tot_pil
|
integer
|
|
the estimate of the total tonnage present in the sighting
determined by the pilot.
|
|
ton_tot_calc
|
longinteger
|
|
the estimate of the total tonnage calculated using the mean
of ton_min & ton_max times the num_of_schools.
|
|
sighting_time
|
integer
|
|
the time that the sighting is made � time is recorded as
NZDT during periods that it is effective - no adjustment is made
to standardise to NZST.
|
|
Attributes:
|
Data Type
|
Null?
|
Comment
|
|
time_after_takeoff
|
decimal(4,2)
|
|
time in decimal hours after take off that sighting was made.
|
|
sea_cond_code
|
smallint
|
|
numeric code of sea condition - 1 is calm/slight, 2 is
moderate & 3 is rough - decoded using t_sea_cond_code.
|
|
water_temp
|
decimal(3,1)
|
|
sea surface temperature (degrees C).
|
|
location
|
integer
|
|
numeric code of half degree square location of the sighting -
can be referenced according to various statistical &
management areas using t_grid_code or decoded (relative to
landmarks) using t_grid_description.
|
|
Latitude
|
longinteger
|
|
latitude (south) of sighting location in degrees and minutes
to 2 implied decimal places match
'[3-4][0-9][0-5][0-9][0-9][0-9]'.
|
|
longitude
|
longinteger
|
|
longitude of sighting location in degrees and minutes to 2
implied decimal places
|
|
|
match
|
|
1[7-8][0-9][0-5][0-9][0-9][0-9].
|
|
long_ew
|
character(1,1)
|
|
E or W for longitude.
|
|
Creator:
|
pt
|
|
Referential:
|
(species_code) INSERT t_species_code (code)
(location) INSERT t_grid_code (code)
(flt_grp, flt_num) INSERT t_flight (flt_grp, flt_num)
|
|
Indices:
|
NORMAL (2, 15) BTREE ON (species_code)
NORMAL (2, 15) BTREE ON (num_of_schools)
NORMAL (2, 15) BTREE ON (ton_min)
NORMAL (2, 15) BTREE ON (ton_max)
NORMAL (2, 15) BTREE ON (ton_tot_pil)
NORMAL (2, 15) BTREE ON (ton_tot_calc)
NORMAL (2, 15) BTREE ON (sighting_time)
NORMAL (2, 15) BTREE ON (location)
NORMAL (2, 15) BTREE ON (flt_grp)
NORMAL (2, 15) BTREE ON (flt_num)
NORMAL (2, 15) BTREE ON (sight_num)
NORMAL (2, 15) BTREE ON (flt_indx)
NORMAL (2, 15) BTREE ON (sgt_indx)
NORMAL (2, 15) BTREE ON (time_after_takeoff)
UNIQUE BTREE ON (flt_grp, flt_num, sight_num)
|
5.1.4 t_set
|
Comment:
|
4th of the five main tables - contains data on the
sets made on schools by fishing vessels.
|
|
Attributes:
|
Data Type
|
Null?
|
Comment
|
|
flt_grp
|
integer
|
No
|
link between the five main tables & with t_flt_days.
|
|
sighting_time
|
integer
|
|
time sighting was made= t_school_sight.sighting_time.
|
|
|
Range: < '2400'
|
|
|
|
set_time
|
integer
|
|
time set was made.
|
|
|
Range: < '2400'
|
|
|
|
vessel_code
|
integer
|
|
Code of vessel= t_vessel_code.code.
|
|
Rst
|
smallint
|
|
Code defining the outcome of the shot:
|
|
|
|
|
1 = caught (whole school) 2 = some lost some saved 3 = for
skunked
|
|
|
|
|
4 = unknown (pilot left area before shot completed)
|
|
|
|
|
5 = caught unknown amount (unavailable from vessel) 6 = let go
|
|
|
match '[0-7]'
|
|
7 = burst net
|
|
sp_sighting
|
smallint
|
|
Species estimated by pilot at first sighting.
|
|
est_ton_pilot
|
integer
|
|
tonnage estimated by the pilot.
|
|
est_sp_pilot
|
smallint
|
|
Species estimated by the pilot.
|
|
land_ton
|
integer
|
|
tonnage estimated by the vessel after fish brailed.
|
|
land_sp
|
smallint
|
|
Species estimated by vessel after fish brailed.
|
|
Creator:
|
smbms
|
|
Referential:
|
(flt_grp) INSERT t_flight_group (flt_grp)
invalid species code (sp_sighting) INSERT t_species_code
(code)
|
|
i
|
nvalid species set by pilot (est_sp_pilot) INSERT
t_species_code (code)
|
|
i
|
nvalid species landed by vessel (land_sp) INSERT
t_species_code (code)
|
|
Indices:
|
NORMAL (2, 15) TIMESERIES set_ndx ON (flt_grp)
|
5.1.5 t_flightpath
|
Comment:
|
5th
of the five main tables - contains records of the half degree
squares flown during a group of flights (see t_flight) and the
10-15 minute periods spent therein.
|
|
Attributes:
|
Data Type
|
Null?
|
Comment
|
|
flt_grp
|
integer
|
No
|
link between the five main tables & with t_flt_days.
|
|
Grid
|
integer
|
No
|
numeric code of half degree square location of the sighting -
can be referenced according to various statistical &
management areas using t_grid_code or decoded (relative to
landmarks) using t_grid_description.
|
|
Ticks
|
smallint
|
|
number of 10-15 minute periods spent within a half degree
square.
|
|
tic_factor
|
smallint
|
|
similar to "ticks" but NULLs in 'ticks' replaced
with a value of "1" for easy addition - ticks were not
recorded before 1/11/85, only entries into each grid square
during a flight therefore addition of '1's gives approximation
to 'ticks' through less accurate.
|
|
Creator:
|
pt
|
|
Referential:
|
(grid) INSERT t_grid_code (code)
(flt_grp) INSERT t_flight_group (flt_grp)
|
|
Indices:
|
NORMAL (2, 15) BTREE ON (flt_grp)
NORMAL (2, 15) BTREE ON (tic_factor)
NORMAL (2, 15) BTREE ON (grid)
|
5.2 Code Tables
5.2.1 t_pilot_code
|
Comment:
|
reference data for pilot codes.
|
|
Attributes:
|
Data Type
|
Null?
|
Comment
|
|
code
|
smallint
|
No
|
"pilot_code" in t_flight_group
|
|
|
range '0' i '99' i.
|
|
|
|
Pilot
|
character(24,1)
|
No
|
pilot name.
|
|
pil_abr
|
character(3,1)
|
|
abbreviated pilot name.
|
|
pil_start
|
integer
|
|
number of days after 1/1/76 that pilot started spotting.
|
|
Creator:
|
pt
|
|
Indices:
|
UNIQUE BTREE ON (code)
NORMAL (2, 15) BTREE ON (pil_start)
UNIQUE BTREE ON (pilot)
UNIQUE BTREE ON (pil_abr)
|
5.2.2 t_customer_code
|
Comment:
|
reference data for customers of pilots.
|
|
Attributes:
|
Data Type
|
Null?
|
Comment
|
|
code
|
smallint
|
No
|
"customer_code" in t_flight_group.
|
|
|
Range '0' i '99' i.
|
|
|
|
Customer
|
character(40,1)
|
No
|
customer name.
|
|
cust_abr
|
character(3,1)
|
|
abbreviated customer name.
|
|
Creator:
|
pt
|
|
Indices:
|
UNIQUE BTREE ON (code)
UNIQUE BTREE ON (customer)
UNIQUE BTREE ON (cust_abr)
|
5.2.3 t_aircraft_code
|
Comment:
|
reference data for aircraft.
|
|
Attributes:
|
Data Type
|
Null?
|
Comment
|
|
code
|
integer
|
No
|
"aircraft_code" in t_flight_group.
|
|
aircraft_callsign
|
character(9,1)
|
|
registered callsign of from 1 to 3 aircraft concatenated
together.
|
|
Creator:
|
pt
|
|
Indices:
|
UNIQUE BTREE ON (code)
|
|
|
UNIQUE BTREE ON (aircraft_callsign)
|
5.2.4 t_vessel_code
Comment: reference data for vessel codes.
|
Attributes:
|
Data Type
|
Null?
|
Comment:
|
|
code
|
integer
|
No
|
"vessel_code" in t_flight_group.
|
|
vessel_name
|
character(75,1)
|
No
|
name of vessel aggregate.
|
|
num_vess
|
smallint
|
|
no. of vessels in aggregate.
|
|
Creator:
|
pt
|
|
Indices:
|
UNIQUE BTREE ON (code)
|
|
|
UNIQUE BTREE ON (vessel_name)
|
|
|
NORMAL (2, 15) BTREE ON (num_vess)
|
5.2.5 t_airfield_code
|
Comment:
|
reference data for airfields and landing strips
|
|
Attributes:
|
Data Type
|
Null?
|
Comment
|
|
code
|
integer
|
|
"up_field" and "dn_field" in t_flight.
|
|
alpha_code
|
character(10,1)
|
|
Civil Aviation Authority & spotter-pilot-created codes of
airfields & strips.
|
|
Airfield
|
character(40,1)
|
|
name of airfield or strip.
|
|
grid_square
|
integer
|
|
degree grid square location of airfield or strip.
|
|
Creator:
|
pt
|
|
Indices:
|
UNIQUE BTREE ON (code)
|
|
|
NORMAL (2, 15) BTREE ON (alpha_code)
|
|
|
NORMAL (2, 15) BTREE ON (airfield)
|
|
|
NORMAL (2, 15) BTREE ON (grid_square)
|
5.2.6 t_species_code
|
Comment:
|
Reference data for fish species; N.B. These are not the
research species codes.
|
|
Attributes:
|
Data Type
|
Null?
|
Comment:
|
|
code
|
smallint
|
No
|
"species_code" in t_school_sight.
|
|
species_list
|
character(51,1)
|
|
names.
|
|
species_abbrev
|
character(20,1)
|
|
abbreviated species names.
|
|
kah_mix
|
smallint
|
|
flag to group schools of kahawai mixed with any other species
(1 = True).
|
|
jma_mix
|
smallint
|
|
flag to group schools of one to three species of jack mackerel
mixed with any species other than jack mackerels. (1 = True)
|
|
ema_mix
|
smallint
|
|
flag to group schools of blue mackerel mixed with any other
species (1 = True).
|
|
skj_mix
|
smallint
|
|
flag to group schools of skipjack tuna mixed with any other
species (1 = True).
|
|
tre_mix
|
smallint
|
|
flag to group schools of trevally mixed with any other species
(1 = True).
|
|
bma_mix
|
smallint
|
|
flag to group all schools containing blue maomao � pure and
mixed(1 = True).
|
|
jma_grp
|
smallint
|
|
flag to group various jack mackerel species, but not in
schools mixed with any other species. (1 = True)
|
|
Creator:
|
pt
|
|
Indices:
|
UNIQUE BTREE ON (code)
|
|
|
UNIQUE BTREE ON (species_list)
|
|
|
UNIQUE BTREE ON (species_abbrev)
|
|
|
NORMAL (2, 15) BTREE ON (kah_mix)
|
|
|
NORMAL (2, 15) BTREE ON (jma_mix)
|
|
|
NORMAL (2, 15) BTREE ON (ema_mix)
|
|
|
NORMAL (2, 15) BTREE ON (skj_mix)
|
|
|
NORMAL (2, 15) BTREE ON (tre_mix)
|
5.2.7 t_sea_cond_code
|
Comment:
|
Reference data for sea condition including means of
standardizing old system (pre- 1/11/85) with the new.
|
|
Attributes:
|
Data Type
|
Null?
|
Comment:
|
|
code
|
smallint
|
No
|
"sea_cond_code" in t_school_sight.
|
|
|
Range '1' i '4' i.
|
|
|
|
old_sea_cond
|
character(21,1)
|
No
|
codes used in old system.
|
|
new_sea_cond
|
character(21,1)
|
|
codes used in new system.
|
|
old_to_new
|
smallint
|
|
means of standardizing old system with the new.
|
|
Creator:
|
pt
|
|
Indices:
|
UNIQUE BTREE ON (code)
NORMAL (2, 15) BTREE ON (old_sea_cond)
NORMAL (2, 15) BTREE ON (new_sea_cond)
NORMAL (2, 15) BTREE ON (old_to_new)
|
5.2.8 t_grid_code
|
Comment:
|
reference data for the half degree grid used for locating
sightings and sightings effort.
|
|
Attributes:
|
Data Type
|
Null?
|
Comment:
|
|
code
|
integer
|
No
|
"location" in t_school_sight and "grid"
in t_flight_path.
|
|
Qmaarea
|
smallint
|
|
grid squares indexed according to the QMAs.
|
|
local_area
|
smallint
|
|
grid squares indexed as follows: 1 -> Nth Cape to Grt
Barrier, 2 -> BOP, 3-> Rolling Ground/South Taranaki Bight,
4-> Kahurangi-Golden & Tasman Bays, 5-> Brothers to
Kekerengu, 6-> Kaikoura.
|
|
Tod1
|
smallint
|
|
system to sort sightings between 36.30S and 38S as follows: 1
-> West Coast, 2 -> Hauraki Gulf, 3 -> East Coast within
FMA1 and 4 -> FMA2.
|
|
kah_ma
|
smallint
|
|
grid squares indexed according to the kahawai fishstocks.
|
|
jma_ma
|
smallint
|
|
grid squares indexed according to the jack mackerel
fishstocks.
|
|
tre_ma
|
smallint
|
|
grid squares indexed according to the trevally fishstocks.
|
|
Fishery
|
smallint
|
|
northern fishery = 1, southern fishery = 2.
|
|
lat_deg
|
integer
|
|
degrees of latitude at the grid square.
|
|
lat_min
|
smallint
|
|
minutes of latitude at the grid square.
|
|
long_deg
|
integer
|
|
degrees of longtitude at the grid square.
|
|
long_min
|
smallint
|
|
minutes of longtitude at the grid square.
|
|
long_EW
|
character(1,1)
|
|
east or west for lontitude at the centre of grid square.
|
|
Rolgrnd
|
smallint
|
|
flag for grid square comprising the rolling grounds.
|
|
Overlandsq
|
smallint
|
|
flag for square flown when traveling over land.
|
|
Creator:
|
pt
|
|
Indices:
|
UNIQUE BTREE ON (code)
NORMAL (2, 15) BTREE ON (qmaarea)
NORMAL (2, 15) BTREE ON (tod1)
NORMAL (2, 15) BTREE ON (kah_ma)
NORMAL (2, 15) BTREE ON (lat_deg)
NORMAL (2, 15) BTREE ON (lat_min)
NORMAL (2, 15) BTREE ON (long_deg)
NORMAL (2, 15) BTREE ON (long_min)
NORMAL (2, 15) BTREE ON (long_EW)
NORMAL (2, 15) BTREE ON (fishery)
|
5.2.9 t_grid_description
|
Comment:
|
brief descriptions of the half degree squares according to
coastal and island localities and landmarks.
|
|
Attributes:
|
Data Type
|
Null?
|
Comment:
|
|
code
|
integer
|
No
|
"location" in t_school_sight and "grid" in
t_flight_path.
|
|
|
Range '0' i '999' i.
|
|
|
|
Area
|
character(45,1)
|
|
45 character description of half degree square
|
|
area_abbrev
|
character(20,1)
|
|
abbreviated description of half degree square
|
|
Creator:
|
pt
|
|
Referential:
|
(code) INSERT t_grid_code (code)
|
|
Indices:
|
UNIQUE BTREE ON (code)
NORMAL (2, 15) BTREE ON (area)
NORMAL (2, 15) BTREE ON (area_abbrev)
|
5.3 Time tables
5.3.1 t_flt_days
|
Comment:
|
various time period labels for days flown (c/f t_time) since
the beginning of the database - useful in grouping data.
|
|
Attributes:
|
Data Type
|
Null?
|
Comment:
|
|
flt_grp
|
integer
|
No
|
link with five main data tables.
|
|
Date
|
date(5)
|
No
|
calendar date.
|
|
jul_dy
|
longinteger
|
|
Julian calendar day (day 2444606 begins at noon on 1/1/1981).
|
|
dy_of_yr
|
integer
|
No
|
consecutive numbering of days of the year.
|
|
Dy
|
smallint
|
|
day of the month.
|
|
Wk
|
longinteger
|
|
week of the year.
|
|
Yeke
|
longinteger
|
|
composite of year and week of the year.
|
|
Mnth
|
smallint
|
|
month of the year.
|
|
Yeth
|
longinteger
|
|
composite of year and month of the year.
|
|
Yr
|
integer
|
|
year.
|
|
Creator:
|
pt
|
|
Referential:
|
(flt_grp) INSERT t_flight_group (flt_grp)
|
|
Indices:
|
NORMAL (2, 15) BTREE ON (flt_grp)
NORMAL (2, 15) BTREE ON (date)
NORMAL (2, 15) BTREE ON (jul_dy)
NORMAL (2, 15) BTREE ON (dy_of_yr)
NORMAL (2, 15) BTREE ON (dy)
NORMAL (2, 15) BTREE ON (wk)
NORMAL (2, 15) BTREE ON (yeke)
NORMAL (2, 15) BTREE ON (mnth)
NORMAL (2, 15) BTREE ON (yeth)
UNIQUE BTREE ON (flt_grp, date)
NORMAL (2, 15) BTREE ON (yr)
|
5.3.2 Table: t_time
|
Comment:
|
various time
period labels for all days (flown and non-flown) since the
beginning of the database to 31/12/95 � useful source for
updating t_flt_days.
|
|
Attributes:
|
Data Type
|
Null?
|
Comment:
|
|
date
|
date(5)
|
No
|
calendar date - link with t_flight_group.
|
|
dy_of_yr
|
integer
|
No
|
consecutive numbering of days of the year.
|
|
jul_dy
|
longinteger
|
|
Julian calendar day (day 2444606 begins at noon on 1/1/1981).
|
|
dy
|
smallint
|
|
day of the month.
|
|
Wk
|
longinteger
|
|
week of the year.
|
|
Yeke
|
longinteger
|
|
composite of year and week of the year.
|
|
Mnth
|
smallint
|
|
month of the year.
|
|
Yeth
|
longinteger
|
|
composite of year and month of the year.
|
|
Yr
|
integer
|
|
year.
|
|
Fishyr
|
longinteger
|
|
fishing year.
|
|
Fshmnth
|
smallint
|
|
consecutive numbering (1-12) of months in fishing year
(October - September).
|
|
Qter
|
smallint
|
|
consecutive numbering (1-4) of annual quarters (Jan-Mar,
Apr-Jun, Jul-Sept, Oct-Dec).
|
|
Creator:
|
pt
|
|
Indices:
|
UNIQUE BTREE ON (date)
NORMAL (2, 15) BTREE ON (dy_of_yr)
NORMAL (2, 15) BTREE ON (jul_dy)
NORMAL (2, 15) BTREE ON (dy)
NORMAL (2, 15) BTREE ON (wk)
NORMAL (2, 15) BTREE ON (yeke)
NORMAL (2, 15) BTREE ON (mnth)
NORMAL (2, 15) BTREE ON (yeth)
NORMAL (2, 15) BTREE ON (yr)
NORMAL (2, 15) BTREE ON (fishyr)
|
5.4 Environmental tables
5.4.1 t_soi
|
Comment:
|
monthly values of the Southern Oscillation Index (Troup) since
1/1/67, in units of 0.1 standard deviation.
|
|
Attributes:
|
Data Type
|
Null?
|
Comment: yr integer No year.
|
|
Mnth
|
integer
|
|
month - numeric.
|
|
Soi
|
decimal(2,1)
|
|
index value.
|
|
Month1
|
character(3,2)
|
|
month - alphabetical.
|
|
Creator:
|
pt
|
|
Indices:
|
NORMAL (2, 15) BTREE ON (mnth)
NORMAL (2, 15) BTREE ON (yr)
NORMAL (2, 15) BTREE ON (soi)
NORMAL (2, 15) BTREE ON (month1)
|
5.4.2 t_astro_gen
|
Comment:
|
sun and moon astronomical data
|
|
Attributes:
|
Data Type
|
Null?
|
Comment:
|
|
jul_dy
|
longinteger
|
|
Julian calendar day (day 2444606 begins at noon on 1/1/1981).
|
|
yr
|
integer
|
|
year.
|
|
Mnth
|
integer
|
|
month.
|
|
Dy
|
smallint
|
|
day of the month.
|
|
Date
|
date(5)
|
|
calendar date.
|
|
Sr0
|
decimal(5,3)
|
|
sunrise @ the equator time in decimal hours value allows for
atmospheric refraction.
|
|
Sr12
|
decimal(5,3)
|
|
sunrise @ 12 degrees from the equator time in decimal hours
value allows for atmospheric refraction.
|
|
Ss0
|
decimal(5,3)
|
|
sunset @ the equatortime in decimal hours value allows for
atmospheric refraction.
|
|
Ss12
|
decimal(5,3)
|
|
sunset @ 12 degrees from the equator time in decimal hours
value allows for atmospheric refraction.
|
|
Mr
|
decimal(5,3)
|
|
moonrise time in decimal hours.
|
|
Ms
|
decimal(5,3)
|
|
moonset time in decimal hours.
|
|
Durn
|
decimal(5,3)
|
|
duration of the moon above the horizon
|
|
ph
|
decimal(3,2)
|
|
moon phase.
|
|
Inten
|
decimal(5,3)
|
|
intensity of moonlight.
|
|
Semi
|
decimal(5,3)
|
|
semi-diameter (radius) of the moon.
|
|
Decl
|
decimal(5,2)
|
|
declination of the moon.
|
|
Creator:
|
pt
|
|
Indices:
|
UNIQUE BTREE ON (jul_dy)
NORMAL (2, 15) BTREE ON (yr)
NORMAL (2, 15) BTREE ON (mnth)
NORMAL (2, 15) BTREE ON (dy)
NORMAL (2, 15) BTREE ON (date)
NORMAL (2, 15) BTREE ON (sr0)
NORMAL (2, 15) BTREE ON (sr12)
NORMAL (2, 15) BTREE ON (ss0)
NORMAL (2, 15) BTREE ON (ss12)
NORMAL (2, 15) BTREE ON (mr)
NORMAL (2, 15) BTREE ON (ms)
NORMAL (2, 15) BTREE ON (durn)
NORMAL (2, 15) BTREE ON (ph)
NORMAL (2, 15) BTREE ON (inten)
NORMAL (2, 15) BTREE ON (semi)
NORMAL (2, 15) BTREE ON (decl)
|
5.4.3 t_astro_moon
|
Comment:
|
reference data on moon cycle since 19/12/79
|
|
Attributes:
|
Data Type
|
Null?
|
Comment:
|
|
yr
|
integer
|
No
|
year.
|
|
dy_of_yr
|
integer
|
No
|
day of the year.
|
|
days_since_epoch
|
longinteger
|
No
|
consecutive numbering of days since 19/12/79.
|
|
cycle
|
integer
|
No
|
consecutive numbering of moon cycles since 19/12/79.
|
|
pcent_cycle
|
decimal(3,2)
|
No
|
percentage of moon cycle elapsed.
|
|
Quarter
|
smallint
|
|
moon quarter: 1st, 2nd, 3rd,
4th.
|
|
Creator:
|
pt
|
|
Indices:
|
NORMAL (2, 15) BTREE ON (yr)
UNIQUE BTREE ON (days_since_epoch)
NORMAL (2, 15) BTREE ON (dy_of_yr)
NORMAL (2, 15) BTREE ON (cycle)
NORMAL (2, 15) BTREE ON (pcent_cycle)
NORMAL (2, 15) BTREE ON (quarter)
|
5.4.4 t_astro_sun
|
Comment:
|
reference data on features of the sun cycle
|
|
Attributes:
|
Data Type
|
Null?
|
Comment:
|
|
mnth
|
smallint
|
No
|
month.
|
|
Dy
|
smallint
|
No
|
day of the month.
|
|
up_hr
|
smallint
|
|
time of sunrise - hour.
|
|
up_min
|
smallint
|
|
time of sunrise - minute.
|
|
up_dec
|
decimal(5,3)
|
|
time of sunrise - decimal hours and minutes.
|
|
merid_hr
|
smallint
|
|
time reaching zenith - hour.
|
|
merid_min
|
smallint time
|
|
reaching zenith - minute.
|
|
mer_alt_deg
|
smallint angle
|
|
to meridian - degrees.
|
|
mer_alt_min
|
smallint
|
|
angle to meridian - minutes.
|
|
dn_hr
|
smallint
|
|
time of sunset - hour.
|
|
dn_min
|
smallint
|
|
time of sunset - minute.
|
|
dn_dec
|
decimal(5,3)
|
|
time of sunset - decimal hours and minutes.
|
|
azimuth_deg
|
integer
|
|
angle to azimuth.
|
|
Area
|
smallint
|
|
No 5 degree index areas used by Murray & Burgess 1992
(SBFWS/92/1), and Murray, Taylor, & Vignaux, 1992
(SBFWS/92/2).
|
|
dk_hrs
|
decimal(5,3)
|
|
hours of darkness.
|
|
Creator:
|
pt
|
|
Indices:
|
NORMAL (2, 15) BTREE ON (mnth)
NORMAL (2, 15) BTREE ON (dy)
NORMAL (2, 15) BTREE ON (area)
NORMAL (2, 15) BTREE ON (up_hr)
NORMAL (2, 15) BTREE ON (up_min)
NORMAL (2, 15) BTREE ON (up_dec)
NORMAL (2, 15) BTREE ON (merid_hr)
NORMAL (2, 15) BTREE ON (merid_min)
NORMAL (2, 15) BTREE ON (mer_alt_deg)
NORMAL (2, 15) BTREE ON (mer_alt_min)
NORMAL (2, 15) BTREE ON (dn_hr)
NORMAL (2, 15) BTREE ON (dn_min)
NORMAL (2, 15) BTREE ON (dn_dec)
NORMAL (2, 15) BTREE ON (azimuth_deg)
UNIQUE BTREE ON (area, mnth, dy)
NORMAL (2, 15) BTREE ON (dk_hrs)
|
|