{ "currentVersion": 10.91, "cimVersion": "2.9.0", "id": 0, "name": "BuildingRecords", "type": "Feature Layer", "parentLayer": null, "defaultVisibility": true, "minScale": 0, "maxScale": 0, "canScaleSymbols": false, "geometryType": "esriGeometryPolygon", "description": "

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>

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>

https://cio.ubc.ca/data-governance/policies-standards-guidelines/data-standards/record-data-standard<\/SPAN><\/P>

<\/P>

Record Name<\/SPAN><\/P><\/TD>

Name of the Record<\/SPAN><\/P><\/TD><\/TR>

Record ID<\/SPAN><\/P><\/TD>

The identifier for the Record, assigned by the Facilities Information & Inventory System (e.g.: 790,790-1 - as used in archiving of record drawings and manuals and related documents).<\/SPAN><\/P><\/TD><\/TR>

Record UID<\/SPAN><\/P><\/TD>

A unique Record identifier. (auto generated by Archibus system).<\/SPAN><\/P><\/TD><\/TR>

Record Status<\/SPAN><\/P><\/TD>

Description of the state of the Record related to the construction projects timeline \u2013 Under Construction, Existing or Demolished.<\/SPAN><\/P><\/TD><\/TR>

Occupancy Date<\/SPAN><\/P><\/TD>

The date on which Occupancy Permit was issued for the Record (also referred to as Date Built).<\/SPAN><\/P><\/TD><\/TR>

GSM<\/SPAN><\/P><\/TD>

\"Gross Square Meters\" - as defined in the BC Universities Space Manual.<\/SPAN><\/P><\/TD><\/TR>

Parent Building ID<\/SPAN><\/P><\/TD>

BLDG_UID of Parent Building as recorded in Buildings dataset.<\/SPAN><\/P><\/TD><\/TR>

Last Renovation Date<\/SPAN><\/P><\/TD>

Date of occupancy for Record under Major Renovation.<\/SPAN><\/P><\/TD><\/TR>

Demo Year<\/SPAN><\/P><\/TD>

Calendar year of demolished Record.<\/SPAN><\/P><\/TD><\/TR>

Record Usage<\/SPAN><\/P><\/TD>

Record based on its main usage (largest floor area).<\/SPAN><\/P><\/TD><\/TR>

Number or Structures<\/SPAN><\/P><\/TD>

The count of structures relative to the Record.<\/SPAN><\/P><\/TD><\/TR>

Record State<\/SPAN><\/P><\/TD>

Physical state of the occupancy in the Record.<\/SPAN><\/P><\/TD><\/TR>

Record Construction Material<\/SPAN><\/P><\/TD>

Classification of building based on construction material type as specified in the Development Permit.<\/SPAN><\/P><\/TD><\/TR>

Condition Index<\/SPAN><\/P><\/TD>

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>

Number of Floors Above Grade<\/SPAN><\/P><\/TD>

Number floor levels above grade.<\/SPAN><\/P><\/TD><\/TR>

Number of Floors Below Grade<\/SPAN><\/P><\/TD>

Number floor levels below grade.<\/SPAN><\/P><\/TD><\/TR>

Record Type<\/SPAN><\/P><\/TD>

Classifications of a Record that UBC maintains in its Facilities Information & Inventory System.<\/SPAN><\/P><\/TD><\/TR>

Campus Code<\/SPAN><\/P><\/TD>

Short Code for UBC's campuses. (e.g.: UBCV, UBCO, OFFS, or OFFH).<\/SPAN><\/P><\/TD><\/TR><\/TBODY><\/TABLE>

Created: 9/15/2017<\/SPAN><\/P>

Updated: 9/14/2021<\/SPAN><\/P><\/DIV><\/DIV><\/DIV>", "copyrightText": "Campus + Community Planning", "editFieldsInfo": { "creationDateField": "CREATED_DATE", "creatorField": "CREATED_USER", "editDateField": "LAST_EDITED_DATE", "editorField": "LAST_EDITED_USER" }, "ownershipBasedAccessControlForFeatures": null, "syncCanReturnChanges": true, "relationships": [], "isDataVersioned": true, "isDataArchived": false, "infoInEstimates": [ "extent" ], "isDataBranchVersioned": false, "isDataReplicaTracked": false, "isCoGoEnabled": false, "supportsRollbackOnFailureParameter": false, "archivingInfo": { "supportsQueryWithHistoricMoment": false, "startArchivingMoment": -1 }, "supportsStatistics": true, "supportsExceedsLimitStatistics": true, "supportsAdvancedQueries": true, "supportsValidateSQL": true, "supportsCoordinatesQuantization": true, "supportsQuantizationEditMode": true, "supportsCalculate": true, "supportsASyncCalculate": true, "supportsDatumTransformation": true, "advancedQueryCapabilities": { "supportsPagination": true, "supportsTrueCurve": true, "supportsQueryWithDistance": true, "supportsReturningQueryExtent": true, "supportsStatistics": true, "supportsPercentileStatistics": true, "supportsHavingClause": true, "supportsOrderBy": true, "supportsDistinct": true, "supportsCountDistinct": true, "supportsQueryWithResultType": true, "supportsReturningGeometryCentroid": true, "supportsSqlExpression": true, "supportsQueryWithDatumTransformation": true, "supportsLod": false, "supportsQueryWithLodSR": false, "supportsQueryAnalytic": true }, "advancedQueryAnalyticCapabilities": { "supportsLinearRegression": true, "supportsAsync": false, "supportsPercentileAnalytic": true }, "advancedEditingCapabilities": { "supportedSqlFormatsInCalculate": [ "standard" ], "supportsAsyncApplyEdits": true }, "hasGeometryProperties": true, "geometryProperties": { "shapeAreaFieldName": "Shape__Area", "shapeLengthFieldName": "Shape__Length", "units": "esriMeters" }, "hasMetadata": true, "extent": { "xmin": 480978.4299, "ymin": 5454526.1464, "xmax": 483415.5088, "ymax": 5457823.1002, "spatialReference": { "wkid": 26910, "latestWkid": 26910, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": -100000, "zUnits": 10000, "falseM": -100000, "mUnits": 10000 } }, "sourceSpatialReference": { "wkid": 26910, "latestWkid": 26910, "vcsWkid": 115700, "latestVcsWkid": 115700, "xyTolerance": 0.001, "zTolerance": 0.001, "mTolerance": 0.001, "falseX": -5120900, "falseY": -9998100, "xyUnits": 10000, "falseZ": 0, "zUnits": 1, "falseM": 0, "mUnits": 1 }, "sourceHeightModelInfo": { "heightModel": "ellipsoidal", "vertCRS": "WGS_1984", "heightUnit": "meter" }, "drawingInfo": { "renderer": { "type": "simple", "symbol": { "type": "esriSFS", "style": "esriSFSSolid", "color": [ 232, 190, 255, 255 ], "outline": { "type": "esriSLS", "style": "esriSLSSolid", "color": [ 52, 52, 52, 255 ], "width": 1.3 } } }, "scaleSymbols": true, "transparency": 27.710843373493976, "labelingInfo": [ { "labelExpressionInfo": { "expression": "($feature.REC_ID)", "title": "Custom" }, "labelPlacement": "esriServerPolygonPlacementAlwaysHorizontal", "multiPart": "labelLargest", "allowOverrun": true, "deconflictionStrategy": "dynamic", "repeatLabel": false, "stackLabel": true, "stackRowLength": 24, "stackAlignment": "dynamic", "removeDuplicates": "none", "useCodedValues": true, "maxScale": 0, "minScale": 0, "name": "Class 1", "priority": -1, "symbol": { "type": "esriTS", "color": [ 0, 0, 0, 255 ], "backgroundColor": null, "borderLineColor": null, "borderLineSize": null, "verticalAlignment": "bottom", "horizontalAlignment": "left", "rightToLeft": false, "angle": 0, "xoffset": 0, "yoffset": 0, "kerning": true, "haloColor": [ 255, 255, 255, 255 ], "haloSize": 1, "font": { "family": "Whitney Condensed Medium", "size": 12, "style": "normal", "weight": "normal", "decoration": "none" } } } ] }, "hasM": false, "hasZ": false, "allowGeometryUpdates": false, "allowTrueCurvesUpdates": true, "onlyAllowTrueCurveUpdatesByTrueCurveClients": true, "hasAttachments": false, "supportsApplyEditsWithGlobalIds": false, "htmlPopupType": "esriServerHTMLPopupTypeAsHTMLText", "objectIdField": "OBJECTID", "globalIdField": "GLOBALID", "displayField": "NAME", "typeIdField": "", "subtypeField": "", "fields": [ { "name": "OBJECTID", "type": "esriFieldTypeOID", "alias": "OBJECTID", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "OBJECTID" }, { "name": "REC_ID", "type": "esriFieldTypeString", "alias": "REC_ID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "REC_ID" }, { "name": "NAME", "type": "esriFieldTypeString", "alias": "NAME", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "NAME" }, { "name": "BLDG_ID", "type": "esriFieldTypeString", "alias": "BLDG_ID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "BLDG_ID" }, { "name": "REC_STATUS", "type": "esriFieldTypeString", "alias": "REC_STATUS", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "REC_STATUS" }, { "name": "OCCU_DATE", "type": "esriFieldTypeDate", "alias": "OCCU_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "OCCU_DATE" }, { "name": "GSM", "type": "esriFieldTypeInteger", "alias": "GSM", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "GSM" }, { "name": "PARENT_UID", "type": "esriFieldTypeString", "alias": "PARENT_UID", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "PARENT_UID" }, { "name": "LAST_RENO_DATE", "type": "esriFieldTypeDate", "alias": "LAST_RENO_DATE", "domain": null, "editable": true, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_RENO_DATE" }, { "name": "REC_USAGE", "type": "esriFieldTypeString", "alias": "REC_USAGE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "REC_USAGE" }, { "name": "NUM_STRUCTURES", "type": "esriFieldTypeInteger", "alias": "NUM_STRUCTURES", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "NUM_STRUCTURES" }, { "name": "REC_STATE", "type": "esriFieldTypeString", "alias": "REC_STATE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "REC_STATE" }, { "name": "CONSTR_TYPE", "type": "esriFieldTypeString", "alias": "CONSTR_TYPE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "CONSTR_TYPE" }, { "name": "REC_CONDITION", "type": "esriFieldTypeString", "alias": "REC_CONDITION", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "REC_CONDITION" }, { "name": "FLRS_ABOVE", "type": "esriFieldTypeSmallInteger", "alias": "FLRS_ABOVE", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FLRS_ABOVE" }, { "name": "FLRS_BELOW", "type": "esriFieldTypeSmallInteger", "alias": "FLRS_BELOW", "domain": null, "editable": true, "nullable": true, "defaultValue": null, "modelName": "FLRS_BELOW" }, { "name": "REC_TYPE", "type": "esriFieldTypeString", "alias": "REC_TYPE", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "REC_TYPE" }, { "name": "SITE_CODE", "type": "esriFieldTypeString", "alias": "SITE_CODE", "domain": null, "editable": true, "nullable": true, "length": 10, "defaultValue": null, "modelName": "SITE_CODE" }, { "name": "NOTES", "type": "esriFieldTypeString", "alias": "NOTES", "domain": null, "editable": true, "nullable": true, "length": 500, "defaultValue": null, "modelName": "NOTES" }, { "name": "GEOM_SOURCE", "type": "esriFieldTypeString", "alias": "GEOM_SOURCE", "domain": null, "editable": true, "nullable": true, "length": 100, "defaultValue": null, "modelName": "GEOM_SOURCE" }, { "name": "GREEN_STATUS", "type": "esriFieldTypeString", "alias": "GREEN_STATUS", "domain": null, "editable": true, "nullable": true, "length": 20, "defaultValue": null, "modelName": "GREEN_STATUS" }, { "name": "CREATED_USER", "type": "esriFieldTypeString", "alias": "CREATED_USER", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "CREATED_USER" }, { "name": "CREATED_DATE", "type": "esriFieldTypeDate", "alias": "CREATED_DATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "CREATED_DATE" }, { "name": "LAST_EDITED_USER", "type": "esriFieldTypeString", "alias": "LAST_EDITED_USER", "domain": null, "editable": false, "nullable": true, "length": 255, "defaultValue": null, "modelName": "LAST_EDITED_USER" }, { "name": "LAST_EDITED_DATE", "type": "esriFieldTypeDate", "alias": "LAST_EDITED_DATE", "domain": null, "editable": false, "nullable": true, "length": 8, "defaultValue": null, "modelName": "LAST_EDITED_DATE" }, { "name": "GLOBALID", "type": "esriFieldTypeGlobalID", "alias": "GLOBALID", "domain": null, "editable": false, "nullable": false, "length": 38, "defaultValue": null, "modelName": "GLOBALID" }, { "name": "Shape__Area", "type": "esriFieldTypeDouble", "alias": "SHAPE.AREA", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "SHAPE.AREA" }, { "name": "Shape__Length", "type": "esriFieldTypeDouble", "alias": "SHAPE.LEN", "domain": null, "editable": false, "nullable": false, "defaultValue": null, "modelName": "SHAPE.LEN" } ], "geometryField": { "name": "SHAPE", "type": "esriFieldTypeGeometry", "alias": "SHAPE", "domain": null, "editable": false, "nullable": true, "defaultValue": null, "modelName": "SHAPE" }, "indexes": [ { "name": "R218_SDE_ROWID_UK", "fields": "OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_218", "fields": "GLOBALID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "UUID_OID_218", "fields": "GLOBALID,OBJECTID", "isAscending": true, "isUnique": true, "description": "" }, { "name": "A115_IX1", "fields": "SHAPE", "isAscending": true, "isUnique": true, "description": "" } ], "datesInUnknownTimezone": false, "dateFieldsTimeReference": { "timeZone": "UTC", "respectsDaylightSaving": false }, "preferredTimeReference": null, "types": [], "templates": [ { "name": "BuildingRecords", "description": "", "prototype": { "attributes": { "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 } }, "drawingTool": "esriFeatureEditToolPolygon" } ], "maxRecordCount": 2000, "supportedQueryFormats": "JSON, geoJSON, PBF", "supportedExportFormats": "sqlite,filegdb", "capabilities": "Query", "useStandardizedQueries": true, "supportedSpatialRelationships": [ "esriSpatialRelIntersects", "esriSpatialRelContains", "esriSpatialRelCrosses", "esriSpatialRelEnvelopeIntersects", "esriSpatialRelIndexIntersects", "esriSpatialRelOverlaps", "esriSpatialRelTouches", "esriSpatialRelWithin", "esriSpatialRelRelation" ], "standardMaxRecordCount": 4000, "tileMaxRecordCount": 4000, "standardMaxRecordCountNoGeometry": 32000, "maxRecordCountFactor": 1, "serviceItemId": "e1aca8ed679e447785b12697f554d022" }