Data within Columbus can either be imported or entered directly using the Data Grids. This document describes the format of Station and Observation data records used when creating a Columbus input file. The format has changed slightly from the 3.X version of Columbus; however, you can still import the 3.X format. All record fields are separated by the semi-colon character (;). Linear and Angular values should be entered based on the units defined near the top of the file. Always enter latitude and longitude in DD.MMSSsss format. N 37-41-58.12345 is entered as 37.415812345 S 37-41-58.12345 is entered as -37.415812345 E 120-30-40.12345 is entered as 120.304012345 W 120-30-40.12345 is entered as -120.304012345 DATUM Record ! Datum Name; Semi-Major Axis; 1.0 / Flattening _DATUM; NAD 83; 6378137.000000; 298.257222101 UNITS Record ! M - meters, U - US Feet, I - International Feet, C - Chains ! D - DMS, DD - Decimal Degrees, G - Grads (Gons), ! Note: Lat and Lon must always be in DMS format (e.g., 100-30-40.1234 is entered as 100.30401234) _UNITS; M; D STATION Record We have simplified the station data input format. All coordinate data for each station can be entered in one record. This record contains fields for Lat/Lon, Heights, North/East and Deflection data. It also supports coordinate standard deviations and correlations. Coordinate standard deviations and correlations are not used in network adjustment. Use coordinate observations if you want to use known weighted coordinates that can move during adjustment. _STA_COORD ! Name; Lat; Lon; OrthoHgt; EllipHgt; North; East; NorthSD; EastSD; HgtSD; CorrNE; CorrNH; CorrEH; DeflNS; DeflEW _STA_COORD; MINERS; 40.0; -90.20; 1033.07584; 1000.000; 0; 0; 0.001; 0.001; 0.001; 0; 0; 0; 0; 0 There is only one set of standard deviations for both the Lat/Lon and North/East coordinate types: NorthSd and EastSD. Deflections of the vertical should be entered in the active angular units (in seconds). If you are creating a file for Grid Adjustment, Lat and Lon can be set to zero. In most scenarios, the standard deviation and correlation fields can be set to zero, since they are not used. ---------- _STA_DESC Use the _STA_DESC record to provide a description for this station. It can be defined before or after the _STA_COORD record. _STA_DESC; MINERS; Top Of Cliff OBSERVATION SET Records These records allow you to define a complete set of observations (e.g., Hor Angle, Slope Distance and Zenith Angle). With any observation set, if an observation was not measured or you don't want it used, simply enter the text "NOOBS" in the field for that observation. ---------- _OBS_DESC Use the _OBS_DESC record to provide a description for this observation set. It must be defined immediately above the applicable observation set record. _OBS_DESC; Unstable location with high winds ---------- ! AZIMUTH OBSERVATION SET ! At Name; To Name; Azimuth; Az SD; Zenith; Zenith SD; Chord (Slope); Chord SD; Instr Hgt; Targ Hgt _OBS_AZ_SET; A; D; 0.0; 0.001; 93.0; 25.0; 106.25; 0.05; 0; 0 _OBS_AZ_SET; Temp1; AA; NOOBS; NOOBS; 85.4930; 15.0; 1100.10; 0.015; 0; 0 ! NOOBS is used to indicate no azimuth observation in 2nd obs set. ---------- ! DIRECTION OBSERVATION SET ! At Name; To Name; Direction; Dir SD; Zenith; Zenith SD; Chord (Slope); Chord SD; Instr Hgt; Targ Hgt SetNum _OBS_DIR_SET; FALLS; MINERS; 322.2940; 3.0; NOOBS; NOOBS; NOOBS; NOOBS; 1.5; 1.2; 1 ! NOOBS is used to indicate no zenith or chord observations. ! Use the same SetNum value to group measurement sets from the AT station. ---------- ! BEARING OBSERVATION SET ! At Name; To Name; Bearing; Bearing SD; Quadrant; Hor Dist; Hor Dist SD _OBS_BEAR_SET; A; F; 18.0637; 0.001; SE; 195.4385; 0.015 ! Quadrant values: NE, SE, SW, NW ---------- ! HORIZONTAL ANGLE OBSERVATION SET (ANGLE RIGHT) ! At Name; To Name; Bs Name; HorAng; HorAng SD; Zenith; Zenith SD; Chord (Slope); Chord SD; Instr Hgt; Targ Hgt _OBS_HA_SET; A; B; D; 90.0000; 20.0; 88.0000; 25.0; 93.7500; 0.050; 0.0; 0.0 ---------- ! HORIZONTAL ANGLE OBSERVATION SET (ANGLE LEFT) ! At Name; To Name; Bs Name; HorAng; HorAng SD; Zenith; Zenith SD; Chord (Slope); Chord SD; Instr Hgt; Targ Hgt _OBS_HA_LEFT_SET; A; B; D; 270.0000; 20.0; 88.0000; 25.0; 93.7500; 0.050; 0.0; 0.0 ---------- ! GPS VECTOR OBSERVATION SET ! At Name; To Name; dX; dY; dZ; XX; XY; YY; XZ; YZ; ZZ (upper diag column order) _OBS_GPS_SET; MINERS; RIDGE; 71330.; -18079.2; -20986.6; 0.1225; 0; 0.18; 0; 0; 0.245 ---------- ! GEODESIC OBSERVATION SET ! At Name; To Name; Geodesic Az; Az SD; Geodesic Dist; Dist SD _OBS_GEODESIC_SET; AAA; DDD; 318.1809000; 0.001; 250411.70000; 0.003 ---------- ! DELTA NORTH, EAST, UP OBSERVATION SET ! At Name; To Name; Del North; North SD; Del East; East SD; Del Up; Up SD _OBS_NEU_SET; AJAX; CASTLE; -247.44; 0.02; 556.59; 0.025; 502.11; 0.035 ---------- ! LAT, LON, HGT COORDINATE OBSERVATION SET (covariance in NEU order) ! At Name; Lat; Lon; Hgt; NN; NE; EE; NU; EU; UU _OBS_LLH_NEU_SET; FOBART; 39.4459997270; -89.2959989290; 1499.37250; 0.02; 0; 0.033; 0; 0; 0.044 ---------- ! LAT, LON, HGT COORDINATE OBSERVATION SET (covariance in ENU order) ! At Name; Lat; Lon; Hgt; EE; EN; NN; EU; NU; UU _OBS_LLH_ENU_SET; FOBART; 39.4459997270; -89.2959989290; 1499.37250; 0.033; 0; 0.02; 0; 0; 0.044 ---------- ! NORTH, EAST, HGT COORDINATE OBSERVATION SET (covariance in NEU order) ! At Name; North; East; Hgt; NN; NE; EE; NU; EU; UU; _OBS_NEH_NEU_SET; CCC; 10106.856; 10093.689; 985.14; 0.003; 0; 0.002; 0; 0; 0.007 ---------- ! NORTH, EAST, HGT COORDINATE OBSERVATION SET (covariance in ENU order) ! At Name; North; East; Hgt; EE; EN; NN; EU; NU; UU _OBS_NEH_ENU_SET; CCC; 10106.856; 10093.689; 985.14; 0.002; 0; 0.003; 0; 0; 0.007 INDIVIDUAL OBSERVATION Records ! AZIMUTH OBSERVATION ! At Name; To Name; Azimuth; Az SD; Instr Hgt; Targ Hgt _OBS_AZ; FALLS; MINERS; 326.2935; 3.0; 0.6; 1.4; ---------- ! DIRECTION OBSERVATION ! At Name; To Name; Direction; Dir SD; Instr Hgt; Targ Hgt; SetNum _OBS_DIR; FALLS; MINERS; 326.2935; 3.0; 0.6; 1.4; 2 ---------- ! BEARING OBSERVATION ! At Name; To Name; Bearing; Bearing SD; Quadrant _OBS_BEAR; 1; 2; 0.2400; 15.0; NE ---------- ! HORIZONTAL ANGLE OBSERVATION (Angle Right) ! At Name; To Name; Bs Name; Hor Angle; Hor Angle SD; Instr Hgt; Targ Hgt _OBS_HA; 101; 102; 27; 208.0901; 5.0; 0; 0 ---------- ! HORIZONTAL ANGLE OBSERVATION (Angle Left) ! At Name; To Name; Bs Name; Hor Angle; Hor Angle SD; Instr Hgt; Targ Hgt _OBS_HA_LEFT; 101; 102; 27; 151.5059; 5.0; 0; 0 ---------- ! ZENITH OBSERVATION ! At Name; To Name; Zenith; Zenith SD; Instr Hgt; Targ Hgt _OBS_ZEN; 101; 102; 91.0731; 8.0; 0; 0 ---------- ! CHORD (SLOPE DIST) OBSERVATION ! At Name; To Name; Chord (Slope Dist); Chord SD; Instr Hgt; Targ Hgt _OBS_CHORD; 101; 102; 3780.260; 0.025; 0; 0 ---------- ! HORIZONTAL DISTANCE OBSERVATION ! At Name; To Name; Hor Dist; Hor Dist SD _OBS_HORDIST; 1; 2; 810.10520; 0.20120 ---------- ! HEIGHT DIFFERENCE OBSERVATION ! At Name; To Name; Hgt Diff; Hgt Diff SD (SD, Num Setups or Distance) _OBS_HGTDIFF; BOON; COOP; 2.56916; 0.005 ---------- ! GEODESIC AZIMUTH OBSERVATION ! At Name; To Name; Az; Az SD _OBS_GEODESIC_AZ; AAA; DDD; 318.1809; 0.5 ---------- ! GEODESIC DISTANCE OBSERVATION ! At Name; To Name; Dist; Dist SD _OBS_GEODESIC; AAA; DDD; 250411.70; 0.001 ---------- ! DELTA NORTH OBSERVATION ! At Name; To Name; dNorth; dNorth SD _OBS_DNORTH; AJAX; CASTLE; -247.44; 0.02 ---------- ! DELTA EAST OBSERVATION ! At Name; To Name; dEast; dEast SD _OBS_DEAST; AJAX; CASTLE; 556.59; 0.025 ---------- ! DELTA UP OBSERVATION ! At Name; To Name; dUp; dUp SD _OBS_DUP; AJAX; CASTLE; 12.11; 0.035 ---------- ! LATITUDE COORDINATE OBSERVATION ! At Name; Lat; Lat SD _OBS_LAT; FOBART; 39.4459997270; 0.01 ---------- ! LONGITUDE COORDINATE OBSERVATION ! At Name; Lon; Lon SD _OBS_LON; FOBART; -108.4459970; 0.003 ---------- ! HEIGHT COORDINATE OBSERVATION ! At Name; Hgt; Hgt SD _OBS_HGT; FOBART; 1499.372; 0.015 ---------- ! NORTH COORDINATE OBSERVATION ! At Name; North; North SD _OBS_NORTH; FOBART; 15006.034; 0.004 ---------- ! EAST COORDINATE OBSERVATION ! At Name; East; East SD _OBS_EAST; FOBART; 5607.021; 0.003