station_number	A six-digit number normally referred to as the "MEDS" station number. Presently "MEDS" station numbers are only 5 digits, the six digit field will allow for future expansion.	NUMBER (6) Primary Key Foreign Key
benchmark_number	A 16-character field to indicate the identification stamped on the physical monument.	VARCHAR2 (16) Primary Key Mandatory
unique_number	An 8 character NRCan style unique identifier for the monument. Note: Although the year identifier in the Unique Number is only 2 digits, the century is covered by the character used to identify the province. i.e. the province identifier will change for BMs installed in the year 2000.	VARCHAR2 (8) Mandatory
account	This field is system set with user account info for update and delete privileges.	VARCHAR2 (16)
DBE_TIME	Database Entry Time - System set.	DATE
DBU_TIME	Database Update Time - System set.	DATE
latitude	The decimal degree latitude of the station position.	NUMBER (11,6) Negative North Mandatory Default value -999.999999
longitude	The decimal degree longitude of the station position.	NUMBER (11,6) Mandatory Default value -999.999999
year_established	A 4 digit number to indicate the year in which the monument was established.	NUMBER (4) Mandatory Default value 9999 to indicate that the date is unknown
monument_type	A descriptor of the type of survey monument.	VARCHAR2 (32) Mandatory Default value Not Known check list
setting	A descriptor to indicate how the survey monument is set. Either "Horizontal" or "Vertical".	VARCHAR2 (32) Mandatory Default value NA check list
agency	The survey agency that established the survey monument.	VARCHAR2 (16) Mandatory Default value Not Known check list
bm_condition	A descriptor indicating the condition of the survey monument.	VARCHAR2 (16) Mandatory Default value Not Known check list
last_inspected	The last year in which the survey monument was inspected.	NUMBER (4) Mandatory Default value 9999 to indicate that the date is unknown
benchmark_description	A 2000 character text field containing the verbal description and location of the benchmark.	VARCHAR2 (2000) Optional

Monument_type Check List: Angle Iron, Bolt, Brass Pin, Brass Rod, Bronze Shaft, Centre of Steel Bollard, Chisel Cut, Chisel Mark

Chiselled Arrow, Copper Coated Rod, Corner of Deck, Cut Cross, Cut Cross in Rock, Cut Triangle, Hasp,

Hole in Center of Aluminum Plate, Iron Bar, Iron Bolt, Iron Pin, Iron Pipe, Iron Post, Iron Spike, Mooring Bollard,

Nail, Not Known, Paint Mark, Painted + on Bollard, Permanent Agency Marker, Square Iron Bar, Stainless Steel Plug,

Steel Bar, Steel Pipe, Steel Rod, T-Bar, Top of Bolt, X Cut in Bolt on Fire Hydrant, X Cut in Top of Fire Hydrant.

Agency Check List: CHS, DOT, DPW, GSC, GeodSC, HEPC, IBC, MTO, Not Known, OHPC, SLSA, TOPO, TS, Toronto, WRB, WSC

Bm_condition Check List: Couldn't Locate, Covered, Damaged, Destroyed, Inaccessible, New, Not Found, Not Known, Poss. Destroyed, Unstable

Tables and Columns