Survey

Schema

Name Data Type Comments Mandatory
geometry geometry
eno NUMBER GA unique internal entity number. Y
survey_id VARCHAR2 This is the alpha numeric identifier for the survey. N
survey_name VARCHAR2 This is the name of the survey. Y
country VARCHAR2 Aggregated list of Countries in which the survey took place. N
state VARCHAR2 Aggregated list of States in which the survey took place. N
onshore_offshore VARCHAR2 Survey was conducted onshore, offshore, or both. Valid values are (On, Off, OnOff). N
survey_type VARCHAR2 The type of survey (eg, air, land, marine, satellite). N
survey_detail VARCHAR2 A term to describe the level of detail of the geophysical survey (eg, detailed, regional, semi-detailed). N
measurement_type VARCHAR2 Aggregated list of terms used to describe the type of measurements collected in a survey (eg, electromagnetic, magnetic, gravity, radiometric). N
owner VARCHAR2 Aggregated list of the owners of the data. May be the same as the client. N
operator VARCHAR2 Aggregated list of the survey organisations that performed the survey. N
contractor VARCHAR2 Aggregated list of the survey organisations that performed the survey. N
processor VARCHAR2 Aggregated list of the organisations or the persons that performed the data processing. N
platform_type VARCHAR2 Aggregated list of the types of vehicles used. N
platform_name VARCHAR2 Aggregated list of the survey platforms or vessel names (eg, Cessna Caravan, Piper Cherokee). N
survey_start_date DATE The date/time that the survey started. N
survey_end_date DATE The date/time that the survey finished. N
min_longitude_wgs84 NUMBER Eastern boundary longitude of this survey. N
max_longitude_wgs84 NUMBER Western boundary longitude of this survey. N
min_latitude_wgs84 NUMBER Northern boundary latitude of this survey. N
max_latitude_wgs84 NUMBER Southern boundary latitude of this survey. N
min_line_spacing_meters NUMBER The minimum spacing between lines, in meters, if applicable. N
max_line_spacing_meters NUMBER The maximum spacing between lines, in meters, if applicable. N
tie_spacing_meters NUMBER If applicable, the distance in metres between tie lines of the survey. N
line_kilometres NUMBER If applicable, the number of data acquisition kilometres flown or sailed in the survey (ie, not including tie lines). N
tie_kilometres NUMBER If applicable, the number of tie line kilometres flown or sailed in the survey. N
total_kilometres NUMBER For surveys conducted along lines, the total number of line kilometres, including tie lines. N
line_azimuth NUMBER If applicable, the azimuth of data acquisition lines in the survey (ie, not tie lines). N
tie_azimuth NUMBER If applicable, the azimuth of tie lines in the survey. N
polygon_extent_wgs84_wkt CLOB Polygon outline of the spatial extent of the geophysical survey in WGS84 Datum. N
gravity_stations NUMBER The number of stations in a survey. N
min_station_spacing_metres NUMBER The minimum spacing between gravity stations, in meters. N
max_station_spacing_metres NUMBER The maximum spacing between gravity stations, in meters. N
polygon_type VARCHAR2 Original Polygon or Calculated Bbox. If the data has bounding coordinates but no polygon data, it will calculate a Bbox to use as the geometric representation. N