Air Photo System - Air Photo Polygons.

259 views (6 recent)

Published by the Ministry of Forests, Lands, Natural Resource Operations and Rural Development - GeoBC
Licensed under Access Only

Represents the theoretical spatial location of the perimeter (or extents) of the area of the air photo taken for an AIR PHOTO. This assumes perfectly flat ground with the photos exposed at exactly the correct altitude above the ground. The Air Photo System Database contains information about the aerial photography exposed in BC. This information includes a geographic reference to the centre of the photography as well as the equipment, conditions and personnel employed.

Data and Resources

Dataset Extent

Latitude: 48.0° to 60.0°
Longitude: -139.5° to -113.5°

Additional Information

Purpose

Discovery tool and supplemental data for the Provincial Aerial Photography Images archive.

Lineage Statement

See http://srmwww.gov.bc.ca/bmgs/airphoto/spec s/databasespecs-2000.pdf

Contact Information

NameHarald Steiner (pointOfContact)
EmailHarald.Steiner@gov.bc.ca
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development
Sub-OrganizationGeoBC

Access & Security

Who can view this dataset? Government
Who can download this dataset?Government

Metadata Information

Record Published 2014-12-15
Record Last Modified 2019-09-05
Resource Status onGoing

Object Description

Object Name: WHSE_REFERENCE.APS_PHOTO_POLYGONS_SP

Short Name: PSPHTPLGN2

Column Name Short Name Data Type Data Precision Comments
AIRP_ID AIRP_ID NUMBER 10
FEATURE_CODE FTRCD VARCHAR2 10
ACFL_ID ACFL_ID NUMBER 10
OPER_ID OPER_ID NUMBER 10
OPERATION_TAG PRTNTG VARCHAR2 20
OPERATION_NAME PRTNNM VARCHAR2 25
ROLL_NUMBER RLLNMBR VARCHAR2 12
FRAME_NUMBER FRMNMBR NUMBER 3
DATE_OF_EXPOSURE DTFXPSR VARCHAR2 49
LATITUDE LATITUDE VARCHAR2 21
LONGITUDE LONGITUDE VARCHAR2 21
FLYING_HEIGHT FLNGHGHT VARCHAR2 47
FILM_EMULSION FLMMLSN VARCHAR2 15
NOMINAL_SCALE NMNLSCL NUMBER 7
YEAR YEAR VARCHAR2 4
AIRP_PHOTO_SUBSTANDARD_CODE RPPHTSBSTN VARCHAR2 1
AIRP_EXCESS_CLOUD_SHADOW RPXCSSCLDS VARCHAR2 1
AIRP_EXCESS_BASE_FOG RPXCSSBSFG VARCHAR2 1
AIRP_EXCESS_SMOKE_HAZE RPXCSSSMKH VARCHAR2 1
AIRP_EXCESS_CRAB RPXCSSCRB VARCHAR2 1
AIRP_SHORT_FORWARD_OVERLAP RPSHRTFRWR VARCHAR2 1
AIRP_LOW_SUN_ANGLE RPLWSNNGL VARCHAR2 1
AIRP_VERTICALITY_OFF RPVRTCLTFF VARCHAR2 1
GEOMETRY GEOMETRY SDO_GEOMETRY 1 GEOMETRY is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a required attribute of feature classes and object classes in a geodatabase.
SE_ANNO_CAD_DATA BLOB 4000 SE_ANNO_CAD_DATA is a binary column used by spatial tools to store annotation, curve features and CAD data when using the SDO_GEOMETRY storage data type.
FEATURE_AREA_SQM FEAT_AREA NUMBER 19 FEATURE_AREA_SQM is the system calculated area of a two-dimensional polygon in square meters
FEATURE_LENGTH_M FEAT_LEN NUMBER 19 FEATURE_LENGTH_M is the system calculated length or perimeter of a geometry in meters