View In:   ArcGIS Online Map Viewer

Name: BuildingRecords

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: <DIV STYLE="text-align:Left;"><DIV><DIV><P><SPAN>As a result of the development process for new buildings or for large building renovations, a new Record is created. A Record is defined as the data captured for a sub-division of a building or for a building itself as determined through the development process for a new building project. A Record has two main components: a Keyplan and the tabular data associated to it. This standard addresses the tabular data component.</SPAN></P><P><SPAN>This standard aims to achieve consistency around the data collected for major institutional and non-institutional projects (include Buildings and RENEW projects) across the University (Vancouver and Okanagan campuses and regional sites), and the format in which it is collected and stored across the University.</SPAN></P><P><SPAN>https://cio.ubc.ca/data-governance/policies-standards-guidelines/data-standards/record-data-standard</SPAN></P><P><SPAN /></P><TABLE><TBODY><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Record Name</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>Name of the Record</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Record ID</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>The identifier for the Record, assigned by the Facilities Information &amp; Inventory System (e.g.: 790,790-1 - as used in archiving of record drawings and manuals and related documents).</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Record UID</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>A unique Record identifier. (auto generated by Archibus system).</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Record Status</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>Description of the state of the Record related to the construction projects timeline – Under Construction, Existing or Demolished.</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Occupancy Date</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>The date on which Occupancy Permit was issued for the Record (also referred to as Date Built).</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>GSM</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>"Gross Square Meters" - as defined in the BC Universities Space Manual.</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Parent Building ID</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>BLDG_UID of Parent Building as recorded in Buildings dataset.</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Last Renovation Date</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>Date of occupancy for Record under Major Renovation.</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Demo Year</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>Calendar year of demolished Record.</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Record Usage</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>Record based on its main usage (largest floor area).</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Number or Structures</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>The count of structures relative to the Record.</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Record State</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>Physical state of the occupancy in the Record.</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Record Construction Material</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>Classification of building based on construction material type as specified in the Development Permit.</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Condition Index</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>Based on the Facility Condition Index (FCI). The FCI is calculated based on the total cost of building repairs and renewal, divided by the current cost of replacing the building.</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Number of Floors Above Grade</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>Number floor levels above grade.</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Number of Floors Below Grade</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>Number floor levels below grade.</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Record Type</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>Classifications of a Record that UBC maintains in its Facilities Information &amp; Inventory System.</SPAN></P></TD></TR><TR><TD><P STYLE="margin:0 0 11 0;"><SPAN>Campus Code</SPAN></P></TD><TD><P STYLE="margin:0 0 11 0;"><SPAN>Short Code for UBC's campuses. (e.g.: UBCV, UBCO, OFFS, or OFFH).</SPAN></P></TD></TR></TBODY></TABLE><P /><P><SPAN>Created: 9/15/2017</SPAN></P><P><SPAN>Updated: 9/14/2021</SPAN></P></DIV></DIV></DIV>

Service Item Id: e1aca8ed679e447785b12697f554d022

Copyright Text: Campus + Community Planning

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 480978.4299
YMin: 5454526.1464
XMax: 483415.5088
YMax: 5457823.1002
Spatial Reference: 26910  (26910)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [232, 190, 255, 255]
Outline:
Style: esriSLSSolid
Color: [52, 52, 52, 255]
Width: 1
Label: N/A
Description: N/A
Transparency: 27
Labeling Info:
Label Placement: esriServerPolygonPlacementAlwaysHorizontal
Label Expression: N/A
Use Coded Values: true
Symbol:
Color: [0, 0, 0, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: left
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 12
Font Family: Whitney Condensed Medium
Font Style: normal
Font Weight: normal
Font Decoration: none

Min. Scale: 0.0
Max. Scale: 0.0

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• REC_ID ( type: esriFieldTypeString, alias: REC_ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: REC_ID )
• NAME ( type: esriFieldTypeString, alias: NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NAME )
• BLDG_ID ( type: esriFieldTypeString, alias: BLDG_ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BLDG_ID )
• REC_STATUS ( type: esriFieldTypeString, alias: REC_STATUS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: REC_STATUS )
• OCCU_DATE ( type: esriFieldTypeDate, alias: OCCU_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: OCCU_DATE )
• GSM ( type: esriFieldTypeInteger, alias: GSM, editable: true, nullable: true, defaultValue: null, modelName: GSM )
• PARENT_UID ( type: esriFieldTypeString, alias: PARENT_UID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PARENT_UID )
• LAST_RENO_DATE ( type: esriFieldTypeDate, alias: LAST_RENO_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LAST_RENO_DATE )
• REC_USAGE ( type: esriFieldTypeString, alias: REC_USAGE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: REC_USAGE )
• NUM_STRUCTURES ( type: esriFieldTypeInteger, alias: NUM_STRUCTURES, editable: true, nullable: true, defaultValue: null, modelName: NUM_STRUCTURES )
• REC_STATE ( type: esriFieldTypeString, alias: REC_STATE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: REC_STATE )
• CONSTR_TYPE ( type: esriFieldTypeString, alias: CONSTR_TYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CONSTR_TYPE )
• REC_CONDITION ( type: esriFieldTypeString, alias: REC_CONDITION, editable: true, nullable: true, length: 10, defaultValue: null, modelName: REC_CONDITION )
• FLRS_ABOVE ( type: esriFieldTypeSmallInteger, alias: FLRS_ABOVE, editable: true, nullable: true, defaultValue: null, modelName: FLRS_ABOVE )
• FLRS_BELOW ( type: esriFieldTypeSmallInteger, alias: FLRS_BELOW, editable: true, nullable: true, defaultValue: null, modelName: FLRS_BELOW )
• REC_TYPE ( type: esriFieldTypeString, alias: REC_TYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: REC_TYPE )
• SITE_CODE ( type: esriFieldTypeString, alias: SITE_CODE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: SITE_CODE )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 500, defaultValue: null, modelName: NOTES )
• GEOM_SOURCE ( type: esriFieldTypeString, alias: GEOM_SOURCE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: GEOM_SOURCE )
• GREEN_STATUS ( type: esriFieldTypeString, alias: GREEN_STATUS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: GREEN_STATUS )
• CREATED_USER ( type: esriFieldTypeString, alias: CREATED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: CREATED_USER )
• CREATED_DATE ( type: esriFieldTypeDate, alias: CREATED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CREATED_DATE )
• LAST_EDITED_USER ( type: esriFieldTypeString, alias: LAST_EDITED_USER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: LAST_EDITED_USER )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• Shape__Area ( type: esriFieldTypeDouble, alias: SHAPE.AREA, editable: false, nullable: false, defaultValue: null, modelName: SHAPE.AREA )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.LEN, editable: false, nullable: false, defaultValue: null, modelName: SHAPE.LEN )

Templates:

• Name: BuildingRecords
  Description:
  Prototype:
  GEOM_SOURCE: null
  GREEN_STATUS: null
  REC_ID: null
  NAME: null
  BLDG_ID: null
  REC_STATUS: null
  OCCU_DATE: null
  GSM: null
  PARENT_UID: null
  LAST_RENO_DATE: null
  REC_USAGE: null
  NUM_STRUCTURES: null
  REC_STATE: null
  CONSTR_TYPE: null
  REC_CONDITION: null
  FLRS_ABOVE: null
  FLRS_BELOW: null
  REC_TYPE: null
  SITE_CODE: null
  NOTES: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CREATED_DATE
• Creator Field: CREATED_USER
• Edit Date Field: LAST_EDITED_DATE
• Editor Field: LAST_EDITED_USER

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata