Major Projects Inventory (Economic) - Points

1148 views (9 recent)

Published by the Ministry of Advanced Education, Skills and Training - Labour Market Information
Licensed under Access Only

The Major Projects Inventory (MPI), which is published quarterly, lists all major projects that are proposed, planned or underway in British Columbia. These are projects with a capital cost of at least $20 million each within the Lower Mainland and projects valued at $15 million or more in the rest of B.C. This is a point layer.

To view the Major Projects Inventory in the BC Economic Atlas click here

Data and Resources

Dataset Extent

Latitude: 47.9° to 60.0°
Longitude: -133.8° to -111.6°

Additional Information

Purpose

To provide public access to information related to projects.

Data Quality
Lineage Statement

Consistent with defined data structures.

More Information

Contact Information

NameMan Wang (pointOfContact)
EmailMan.Wang@gov.bc.ca
OrganizationMinistry of Advanced Education, Skills and Training
Sub-OrganizationLabour Market Information

Access & Security

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

Metadata Information

Record Published 2013-08-01
Record Last Modified 2019-05-07
Resource Status onGoing

Object Description

Object Name: WHSE_HUMAN_CULTURAL_ECONOMIC.MPI_ECON_MAJOR_PROJECTS_POINT

Short Name: MPI_ECON
Comments: ECON MAJOR PROJECT POINT is a spatial layer published quarterly that lists all Economic (ECON) major projects that are proposed, planned or underway in British Columbia. These are projects with a capital cost of at least $20 million each within the Lower Mainland and projects valued at $15 million or more apiece in the rest of B.C. This is a point layer.

Column Name Short Name Data Type Data Precision Comments
ECON_MAJOR_PROJECT_ID ECN_MJR_ID NUMBER 10 ECON MAJOR PROJECT ID is a system generated unique identification number.
PROJECT_ID PRJ_ID NUMBER 10 PROJECT ID is a unique identification number assigned to each project by the MPI database, e.g., 3002
PROJECT_NAME PRJ_NAME VARCHAR2 254 PROJECT_NAME is the name of each project assigned by the project developer or identified by elements of the project description or location, e.g., "Ellsworth Condominium"
PROJECT_DESCRIPTION PRJ_DESC VARCHAR2 2000 PROJECT_DESCRIPTION includes details of a project composition and size, may include information regarding project phases, funding or stakeholders, e.g., "Proposed 93-unit condominium development in a 9 storey building located on Main St."
ESTIMATED_COST ESTMTD_CST NUMBER 10 ESTIMATED COST is the estimated cost of the project in millions of dollars.
UPDATE_ACTIVITY UPDT_CTVTY VARCHAR2 50 UPDATE_ACTIVITY shows information for projects that are proposed or started or completed, have been added or cancelled in the current issue, i.e., "Cancelled-removing next issue", "Completed this quarter-removing next issue", "Construction started this quarter","New proposed project","Project added-under construction","Unknown"
ENVIRONMENTAL_ASSESSMENT_STAGE ENV_ASSESS VARCHAR2 20 ENVIRONMENTAL_ASSESSMENT_STAGE shows the stage of a project undergoing review under the BC Environmental Assessment Act, i.e., "Certified","Expired","Not required","Pre-application","Pre-feasibility","Refused","Review","Withdraw".
CONSTRUCTION_TYPE CNST_TYPE VARCHAR2 20 CONSTRUCTION_TYPE is the project type according to a list of five industry standard construction types, i.e., "Commercial", "Industrial", "Infrastructure", "Institutional".
CONSTRUCTION_SUBTYPE CNST_STYPE VARCHAR2 50 CONSTRUCTION_SUBTYPE is the subtype of construction of a project as it falls within the five industry standard Construction Type classifications, i.e., "Accommodation", "Education", "Government buildings", "Health", "Manufacturing - Petrochemical", "Manufacturing - Wood Products", "Mining", "Mixed Use", "Office", "Oil & Gas", "Other Commercial".
PROJECT_TYPE PRJ_TYPE VARCHAR2 50 PROJECT_TYPE is the type of project selected from a pre-defined list of Major Project Inventory Type classifications as they fall within the respective Construction Type and Construction Subtype classifications, e.g., "Accommodation", "Education", "Health".
REGION REGION VARCHAR2 50 REGION is the name of the development region where the project is located. Projects are listed according to eight development regions. : 1. Vancouver Island/Coast, 2. Mainland/Southwest (Vancouver area), 3. Thompson/Okanagan, 4. Kootenay, 5. Cariboo, 6. North Coast, 7. Nechako, and 8. Northeast
MUNICIPALITY MUNI VARCHAR2 50 MUNICIPALITY is the municipality(s) the project is located in e.g. Tumbler Ridge
DEVELOPER DEVELOPER VARCHAR2 254 DEVELOPER is the organization(s) or individual(s) that are developing the project. There can be multiple developers and those are separated by semi-colon or slash. e.g., Polygon Homes Ltd.
ARCHITECT ARCHITECT VARCHAR2 254 ARCHITECT is the name of the architect or architects involved in the project, e.g., Paul Merrick Architects Ltd.
PROJECT_STATUS PRJ_STATUS VARCHAR2 50 PROJECT_STATUS is the current status of the project. Status is classified in four categories: Proposed, Construction Started, On Hold, Completed.Projects are only moved on hold if they are delayed or postponed by proponent. A project may remain on hold longer than 2 yrs if it is undergoing a lengthy assessment or permitting process. Projects that are cancelled are removed from the Excel, and remain in the database as closed.
PROJECT_STAGE PRJ_STAGE VARCHAR2 50 PROJECT_STAGE is the general phase of a Proposed project, i.e., Preliminary/Feasibility (includes design and planning), Consultation/Approvals (includes public open house, stakeholder engagement, and environmental or rezoning approvals), Permitting (includes development and building permits, mines, and water licenses), Tender/Preconstruction (includes construction tenders and building site preparation such as preloading, demolition, and excavation).
PROJECT_CATEGORY_NAME PRJ_CAT_NM VARCHAR2 50 PROJECT CATEGORY NAME is the name of the industrial category of the project. The projects are listed in seven industrial categories: 1. Residential Commercial, 2. Transportation & Warehousing, 3. Mining & Oil & Gas Extraction, 4. Utilities (incl sewage treatment), 5. Manufacturing, 6. Public Services, 7. Other Services
PUBLIC_FUNDING_IND PUB_FUNDNG VARCHAR2 5 PUBLIC_FUNDING_IND indicates true where funding is designated to a project from a Municipal, Provincial or Federal government or organization. Project may still include private funding. Possible values are true and false.
GREEN_BUILDING_IND GRN_BLDNGD VARCHAR2 5 GREEN_BUILDING_IND indicates true where a project is designed to meet the specifications to be registered and certified under a recognized green building rating system such as LEED® or Green Globes. Possible values are true and false.
CLEAN_ENERGY_IND CLN_ENRGY VARCHAR2 5 CLEAN_ENERGY_IND indicates true where a project can be identified as a clean energy project e.g., hydroelectric or wind power. Possible values are true and false.
FIRST_NATION_IND FN_IND VARCHAR2 5 FIRST_NATION_IND indicates true where a project has FN involvement as a developer, or through land or other agreements. Possible values are true and false.
FIRST_NATION_NAMES FN_NAMES VARCHAR2 200 FIRST_NATION_NAME is a list of First Nations that have any type of affiliation (land related, benefits agreement, etc) to the major project, e.g., Iskut Band Council, Nisga''a Nation.
FIRST_NATION_AGREEMENT FN_AGMNTS VARCHAR2 254 FIRST_NATION_AGREEMENT describes what has been publicly stated in relation to the major project and First Nations, e.g., Benefits agreement.
CONSTRUCTION_JOBS CNST_JOBS NUMBER 10 CONSTRUCTION_JOBS is the number of person years of employment during the construction of a project as estimated by project developer.
OPERATING_JOBS OPER_JOBS NUMBER 10 OPERATING_JOBS is the number of person years of employment during the implementation and operation of a project as estimated by project developer.
START_DATE START_DT VARCHAR2 20 START_DATE is the actual or proposed start date of a project, stored in a variety of formats, e.g., 2018, Late 2016, Fall 2015, 20161007.
STANDARDIZED_START_DATE S_START_DT VARCHAR2 20 STANDARDIZED_START_DATE is the actual or proposed start year and corresponding annual quarter (format: YYYY-Q1), e.g., 2016-Q1.
COMPLETION_DATE CMPLT_DT VARCHAR2 20 COMPLETION_DATE is the actual or proposed completion date of a project, stored in a variety of formats, e.g., 2018, Late 2016, Fall 2015, 20161117.
STANDARDIZED_COMPLETION_DATE S_CMPL_DT VARCHAR2 20 STANDARDIZED_COMPLETION_DATE is the actual or proposed completion year and corresponding annual quarter (format: Jan-Mar or Early YYYY-Q4), e.g., 2016-Q4.
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 (-ddd.dddddd), of the location of the feature as measured from the prime meridian, e.g., -123.093544.
LATITUDE_DMS LAT_DMS VARCHAR2 20 LATITUDE_DMS is the geographic coordinate, in Degrees, Minutes and Seconds, of the location of the feature as measured from the equator, e.g., 49° 7'' 38.55 N.
LONGITUDE_DMS LONG_DMS VARCHAR2 20 LONGITUDE_DMS is the geographic coordinate, in Degrees, Minutes and Seconds, of the location of the feature as measured from the prime meridian, e.g., 123° 11'' 27.72W.
TELEPHONE TELEPHONE VARCHAR2 100 TELEPHONE is the contact number of the project developer or representative may contain multiple numbers.
PROJECT_WEBSITE PRJ_WEBSTE VARCHAR2 254 PROJECT_WEBSITE contains the main website page of the project or developer.
SOURCE_WEBSITE SRC_WBSTE VARCHAR2 254 SOURCE_WEBSITE contains the BC Major Projects Inventory website page.
FIRST_ENTRY_DATE FRST_EN_DT DATE 7 FIRST_ENTRY_DATE indicates the date a project was entered in the Major Projects Inventory database.
LAST_UPDATE LST_PDTE DATE 7 LAST_UPDATE indicates the date of first day of the last annual quarter the project information was updated.
UPDATED_FIELDS UPDTD_FLDS VARCHAR2 254 UPDATED_FIELDS indicates the column headings where a change occurred and the last activity that was identified on the project, e.g., Update Project Name, Construction Type, Subtype.
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 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.

Comments

No comments have been posted yet.