Airphoto Centroids

201 views (9 recent)

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

A set of points representing the centre points of all individual air photo frames catalogued in the provincial collection, dating back to 1963.

Data and Resources

Dataset Extent

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

Additional Information

Data Quality
Lineage Statement

Contact Information

NameAngus Christian (pointOfContact)
OrganizationMinistry of Forests, Lands, Natural Resource Operations and Rural Development

Access & Security

Who can view this dataset? Public
Who can download this dataset?Public

Metadata Information

Record Published 2017-11-15
Record Last Modified 2019-05-10
Resource Status onGoing

Object Description


Short Name: PHOTO_CENT
Comments: Annual layers of photo centre points and associated metadata representing air photos in the Provincial air photo imagery inventory.

Column Name Short Name Data Type Data Precision Comments
AIRP_ID AIRP_ID NUMBER 10 AIRP_ID is the unique photo frame identifier, generated by the source APS system.
FLYING_HEIGHT HEIGHT NUMBER 5 FLYING_HEIGHT is the flying height above mean sea level in metres.
PHOTO_YEAR YEAR NUMBER 4 PHOTO_YEAR is the operational year to which this photograph is assigned.
PHOTO_DATE DATE DATE 7 PHOTO_DATE is the date (year, month, and day) of exposure of the photograph.
PHOTO_TIME TIME VARCHAR2 20 PHOTO_TIME is the time of exposure (hours, minutes, seconds), expressed in Pacific Standard Time, e.g., 9:43:09 AM.
LATITUDE LATITUDE NUMBER 8 LATITUDE is the geographic coordinate, in decimal degrees (dd.dddddd), of the location of the feature as measured from the equator, e.g., 55.323653.
LONGITUDE LONGITUDE NUMBER 9 LONGITUDE is the geographic coordinate, in decimal degrees (dd.dddddd), of the location of the feature as measured from the prime meridian, e.g., -123.093544.
FILM_ROLL FILM_ROLL VARCHAR2 20 FILM_ROLL is a BC Government film roll identifier, e.g., bc5624.
FRAME_NUMBER FRAME NUMBER 10 FRAME_NUMBER is the sequential frame number of this photograph within a film roll.
GEOREF_METADATA_IND REFERENCED VARCHAR2 1 GEOREF_METADATA_IND indicates if georeferencing metadata exists for this photograph, i.e., Y, N.
PUBLISHED_IND PUBLISHED VARCHAR2 1 PUBLISHED_IND indicates if this photograph's geometry and metadata should be exposed for viewing, i.e., Y,N.
MEDIA MEDIA VARCHAR2 100 MEDIA describes the photographic medium on which this photograph was recorded, e.g. Film - BW.
PHOTO_TAG PHOTO_TAG VARCHAR2 100 PHOTO_TAG is a combination of film roll identifier and frame number that uniquely identifies an air photo, e.g., bcc09012_035.
BCGS_TILE BCGS_TILE VARCHAR2 10 BCGS_TILE identifies the BCGS mapsheet within which the centre of this photograph is contained. The BCGW mapsheet could be 1:20,000, 1:10,000 or 1:5,000, e.g., 104a01414.
NTS_TILE NTS_TILE VARCHAR2 10 NTS_TILE identifies the NTS 1:50,000 mapsheet tile within which the centre of this photograph is contained, e.g., 104A03.
SCALE SCALE VARCHAR2 10 SCALE of the photo with respect to ground based on a 9-inch square hardcopy print, e.g., 1:18,000.
GROUND_SAMPLE_DISTANCE GSD NUMBER 5 GROUND_SAMPLE_DISTANCE indicates the distance on the ground in centimetres represented by a single pixel in the scanned or original digital version of this photograph.
OPERATION_TAG OPER_TAG VARCHAR2 20 OPERATION_TAG is an alpha numeric shorthand operation identifier representing photographic medium, operation number, requesting agency and operational year of photography, e.g., D003FI15.
FOCAL_LENGTH FOC_LEN NUMBER 10 FOCAL_LENGTH is the focal length of the lens, in millimetres, used to capture this photograph.
THUMBNAIL_IMAGE_URL THMBNL_MGL VARCHAR2 500 THUMBNAIL_IMAGE_URL is a hyperlink to the 1/16th resolution thumbnail version of this image.
FLIGHT_LOG_URL LOG_URL VARCHAR2 500 FLIGHT_LOG_URL is a hyperlink to the scanned version of the original handwritten flight log page (film record) for this image.
CAMERA_CALIBRATION_URL CALIB_URL VARCHAR2 500 CAMERA_CALIBRATION_URL is a hyperlink to the camera calibration report file for this image.
PATB_GEOREF_URL PATB_URL VARCHAR2 500 PATB_GEOREF_URL is a hyperlink to the PatB geo-referencing file for this image.
FLIGHT_LINE_SEGMENT_ID FLGHT_L_ID NUMBER 10 FLIGHT_LINE_SEGMENT_ID identifies the section of flight line to which this photograph belongs.
OPERATION_ID OPER_ID NUMBER 10 OPERATION_ID is a unique identifier for the operation to which this photograph belongs. It may be used by the data custodian to diagnose positional errors.
FILM_RECORD_ID FIRE_ID NUMBER 10 FILM_RECORD_ID is a unique identifier for the film record to which this photograph belongs. It may be used by the data custodian to diagnose positional errors.
SHAPE SHAPE SDO_GEOMETRY 1 SHAPE is the column used to reference the spatial coordinates defining the feature.
OBJECTID OBJECTID NUMBER 38 OBJECTID is a column required by spatial layers that interact with ESRI ArcSDE. It is populated with unique values automatically by SDE.
SE_ANNO_CAD_DATA ANNO_CAD 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.


No comments have been posted yet.