Ministry of Transportation (MOT) Rest Area

698 views (8 recent)

Published by the Ministry of Transportation and Infrastructure - Construction and Maintenance
Licensed under Open Government Licence - British Columbia

A Rest Area is a developed roadside area for the use of the traveling public which must contain a washroom, and often has litter receptacles, picnic tables and other facilities. It is a Point feature

Data and Resources

Dataset Extent

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

Additional Information

Purpose

A Rest Area is a developed roadside area for the use of the traveling public which must contain a washroom, and often has litter receptacles, picnic tables and other facilities.

Data Quality
Lineage Statement

Contact Information

NameJenna Sparks (pointOfContact)
EmailJenna.Sparks@gov.bc.ca
OrganizationMinistry of Transportation and Infrastructure
Sub-OrganizationConstruction and Maintenance

Access & Security

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

Metadata Information

Record Published 2012-03-22
Record Last Modified 2019-05-04
Resource Status onGoing

Object Description

Object Name: WHSE_IMAGERY_AND_BASE_MAPS.MOT_REST_AREAS_SP

Short Name: REST_AREAS
Comments: REST AREA SP represents developed Roadside area for the use of the traveling public which must contain a washroom, and often has litter receptacles, picnic tables and other facilities. It is a Point feature.

Column Name Short Name Data Type Data Precision Comments
REST_AREA_ID RA_ID NUMBER 10 REST AREA ID is a system generated identifier to ensure row uniqueness. This is a primary key field.
CHRIS_REST_AREA_ID ITT_PRIMAR VARCHAR2 50 CHRIS REST AREA ID contains the identifier of the rest area inventory item derived by the CHRIS application. E.g., 2455305
ADMIN_UNIT_CODE ADMIN_CODE VARCHAR2 10 ADMIN UNIT CODE contains the MoT Service Area identifier. There are 28 service areas in MoT's jurisdiction. Each Service Area represents a geographic area within the province. E.g., 13
ADMIN_UNIT_NAME ADMIN_NAME VARCHAR2 80 ADMIN UNIT NAME contains the MoT Service Area Name identifier. There are 28 service areas names in MoT's jurisdiction. Each Service Area Name represents a geographic area within the province. E.g., Lower Mainland
CROSS_SECTION_POSITION X_SECTION VARCHAR2 80 CROSS SECTION POSITION contains the cross sectional position of rest area in relationship to the road. E.g., Right of Way - Left, Division of Travel/End of Road, Shoulder - Left etc.
REST_AREA_NAME RA_NAME VARCHAR2 255 REST AREA NAME indicates the name of the rest area. E.g., 22 Peaceview Rest Area
REST_AREA_NUMBER RA_NUM VARCHAR2 5 REST AREA NUMBER indicates the MoT rest area identification number, utilized for identification by the Ministry Districts or Service areas. E.g., R0147
REST_AREA_CLASS RA_CLASS VARCHAR2 80 REST AREA CLASS contains a physical description of the MoT rest area class type. E.g., Rest Area Maintenance Class(RAM) Class A, RAM Class B, RAM Class C.
ASSOCIATED_NUMBERED_ROUTE ASS_NO_RTE VARCHAR2 3 ASSOCIATED NUMBERED ROUTE is the numbered route on which the Rest Area is directly accessed from. If there is no associated numbered route then the Road Name is displayed in the Distance from Municipality attribute followed by the kilometre distance from the closest Municipality. e.g., 99
DISTANCE_FROM_MUNICIPALITY DIST_TOWN VARCHAR2 75 DISTANCE FROM MUNICIPALITY is the Distance in kilometres from the closest Municipality to the Rest Area. e.g., 28.7km North of Victoria
NUMBER_OF_TOILETS NUM_TOILET NUMBER 11 NUMBER OF TOILETS indicates the number of toilets in the rest area.
TOILET_TYPE TOILET_TYP VARCHAR2 80 TOILET TYPE is a physical description of the type of toilets in the Rest Area. e.g., CH(Chemical), CO(Compost), Flush, Pit, Other
WHEELCHAIR_ACCESS_TOILET_IND WHLCHR_TOI VARCHAR2 3 WHEELCHAIR ACCESS TOILET IND indicates whether a Rest Area has wheelchair accessible toilets or not. e.g., Yes or No
NUMBER_OF_TABLES NUM_TABLE NUMBER 11 NUMBER OF TABLES indicates the number of tables in the rest area.
NUMBER_OF_STANDARD_BARRELS NUM_ST_BAR NUMBER 11 NUMBER OF STANDARD BARRELS indicates the number of standard barrels in the rest area.
NUMBER_OF_BEAR_PROOF_BARRELS NUM_BEAR NUMBER 11 NUMBER OF BEAR PROOF BARRELS indicates the number of bear proof barrels in the rest area.
POWER_TYPE POWER_TYPE VARCHAR2 80 POWER TYPE is a physical description of the power available in a Rest Area. e.g., Battery, Electrical, Generator, Solar or No Power
POWER_RESPONSIBILITY POWER_RESP VARCHAR2 80 POWER RESPONSIBILITY indicates who is responsible for the power in a Rest Area. e.g., Contractor, Province or NA
DIRECTION_OF_TRAFFIC DIRECTION VARCHAR2 80 DIRECTION OF TRAFFIC is the direction the traffic is heading when approaching the Rest Area (i.e., the rest area would be on the passenger side of the vehicle). e.g., NB, SB, EB or WB
ACCESS_RESTRICTION ACCESS_RES VARCHAR2 80 ACCESS RESTRICTION indicates which direction does NOT have access to the Rest Area. e.g., NB, SB, EB, WB or No Restriction
DECELERATION_LANE_IND DECEL_LANE VARCHAR2 3 DECELERATION LANE IND Indicates whether a deceleration lane exists or not for a Rest Area. e.g., Yes or No
ACCELERATION_LANE_IND ACCEL_LANE VARCHAR2 3 ACCELERATION LANE IND Indicates whether an acceleration lane exists or not for a Rest Area. e.g., Yes or No
DIRECT_ACCESS_IND DIRECT_ACC VARCHAR2 3 DIRECT ACCESS IND indicates whether the Rest Area is accessible directly from the Numbered Route (i.e., not down a frontage road or other side road). e.g., Yes or No
ACCOM_COMMERCIAL_TRUCKS_IND COMMERCIAL VARCHAR2 3 ACCOM COMMERCIAL TRUCKS IND indicates whether the Rest Area accommodates commercial trucks or not. e.g., Yes or No
OPEN_YEAR_ROUND_IND YEAR_ROUND VARCHAR2 3 OPEN YEAR ROUND IND indicates whether the Rest Area is open year round or not. e.g., Yes or No
OPEN_DATE OPEN_DATE VARCHAR2 5 ANNUAL OPEN DATE indicates the approximate annual open date (if applicable) in the Spring for the rest area (MM-DD).
CLOSE_DATE CLOSE_DATE VARCHAR2 5 ANNUAL CLOSE DATE indicates the approximate annual closing date (if applicable) in the Fall for the rest area (MM-DD)
CHRIS_ANCHOR_SECTION_ID CHRIS_ANCH NUMBER 9 CHRIS ANCHOR SECTON ID contains the CHRIS application internal unique identifier for the anchor section segment. E.g., 2777363
EVENT_LOCATION LOCATION NUMBER 14 EVENT LOCATION contains the measure for the rest area along the anchor section. Measures are in Kilometer (km). E.g., 42.200 km
HIGHWAY_NUMBER HWY_NUMBER VARCHAR2 80 HIGHWAY NUMBER is the MoT Numbered Route identifier populated when the rest area is located on a MoT Numbered route. E.g., 99
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.

Comments

No comments have been posted yet.