View In:   ArcGIS Online Map Viewer

Name: v_building_Buildings

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 67b8b715170244a296cf88d8e408b311

Copyright Text:

Default Visibility: true

MaxRecordCount: 10000

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: 486330.4019
YMax: 5457826.213
Spatial Reference: 26910  (26910)  VCSWkid(115700)  LatestVCSWkid(115700)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [190, 210, 255, 255]
Outline:
Style: esriSLSSolid
Color: [255, 255, 255, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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 )
• BLDG_UID ( type: esriFieldTypeString, alias: BLDG_UID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BLDG_UID )
• NAME ( type: esriFieldTypeString, alias: NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NAME )
• BLDG_CODE ( type: esriFieldTypeString, alias: BLDG_CODE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BLDG_CODE )
• CONSTR_STATUS ( type: esriFieldTypeString, alias: CONSTR_STATUS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CONSTR_STATUS , Coded Values: [Complete: Complete] , [UnderConstruction: UnderConstruction] , [PreConstruction: PreConstruction] , ...1 more... )
• OCCU_DATE ( type: esriFieldTypeDate, alias: OCCU_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: OCCU_DATE )
• BLDG_USAGE ( type: esriFieldTypeString, alias: BLDG_USAGE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: BLDG_USAGE , Coded Values: [Academic: Academic] , [Administrative: Administrative] , [Athletics: Athletics] , ...9 more... )
• BLDG_SEC_USAGE ( type: esriFieldTypeString, alias: BLDG_SEC_USAGE, editable: true, nullable: true, length: 254, defaultValue: null, modelName: BLDG_SEC_USAGE , Coded Values: [Academic: Academic] , [Administrative: Administrative] , [Athletics: Athletics] , ...9 more... )
• JURISDICTION ( type: esriFieldTypeString, alias: JURISDICTION, editable: true, nullable: true, length: 10, defaultValue: null, modelName: JURISDICTION )
• NEIGHBOURHOOD ( type: esriFieldTypeString, alias: NEIGHBOURHOOD, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NEIGHBOURHOOD , Coded Values: [Academic: Academic] , [Chancellor: Chancellor] , [EastCampus: EastCampus] , ...4 more... )
• MANAGE_ORG ( type: esriFieldTypeString, alias: MANAGE_ORG, editable: true, nullable: true, length: 30, defaultValue: null, modelName: MANAGE_ORG )
• BLDG_STATE ( type: esriFieldTypeString, alias: BLDG_STATE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: BLDG_STATE , Coded Values: [Temporary: Temporary] , [Unoccupied: Unoccupied] , [UnderRenovation: UnderRenovation] , ...1 more... )
• GREEN_STATUS ( type: esriFieldTypeString, alias: GREEN_STATUS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: GREEN_STATUS )
• CONSTR_TYPE ( type: esriFieldTypeString, alias: CONSTR_TYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CONSTR_TYPE , Coded Values: [Concrete: Concrete] , [Wood: Wood] , [Steel: Steel] , ...1 more... )
• MAX_FLOORS ( type: esriFieldTypeSmallInteger, alias: MAX_FLOORS, editable: true, nullable: true, defaultValue: null, modelName: MAX_FLOORS )
• BLDG_HEIGHT ( type: esriFieldTypeDouble, alias: BLDG_HEIGHT, editable: true, nullable: true, defaultValue: null, modelName: BLDG_HEIGHT )
• GBA ( type: esriFieldTypeInteger, alias: GBA, editable: true, nullable: true, defaultValue: null, modelName: GBA )
• REC_IDS ( type: esriFieldTypeString, alias: REC_IDS, editable: true, nullable: true, length: 300, defaultValue: null, modelName: REC_IDS )
• HAS_SUBBLDGS ( type: esriFieldTypeInteger, alias: HAS_SUBBLDGS, editable: true, nullable: true, defaultValue: null, modelName: HAS_SUBBLDGS , Coded Values: [1: Yes] , [0: No] )
• GEOM_SOURCE ( type: esriFieldTypeString, alias: GEOM_SOURCE, editable: true, nullable: true, length: 100, defaultValue: null, modelName: GEOM_SOURCE )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 500, defaultValue: null, modelName: NOTES )
• 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 )
• BLDG_FORM ( type: esriFieldTypeString, alias: BLDG_FORM, editable: true, nullable: true, length: 30, defaultValue: null, modelName: BLDG_FORM , Coded Values: [Apt5StoreyPlus: Apt5StoreyPlus] , [AptLess5Storey: AptLess5Storey] , [Duplex/Townhouse: Duplex/Townhouse] , ...3 more... )
• BLDG_CONDITION ( type: esriFieldTypeString, alias: BLDG_CONDITION, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BLDG_CONDITION , Coded Values: [Good: Good] , [Fair: Fair] , [Poor: Poor] , ...1 more... )
• ACCESSIBILITY_RATING ( type: esriFieldTypeString, alias: ACCESSIBILITY_RATING, editable: true, nullable: true, length: 30, defaultValue: null, modelName: ACCESSIBILITY_RATING , Coded Values: [CertifiedGold: CertifiedGold] , [Certified: Certified] , [NotCertified: NotCertified] )
• BLDG_MAINTENANCE ( type: esriFieldTypeString, alias: BLDG_MAINTENANCE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: BLDG_MAINTENANCE )
• 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 )
• BLDG_CLASS ( type: esriFieldTypeString, alias: BLDG_CLASS, editable: true, nullable: true, length: 15, defaultValue: null, modelName: BLDG_CLASS )
• PROPERTY_TYPE ( type: esriFieldTypeString, alias: PROPERTY_TYPE, editable: true, nullable: true, length: 30, defaultValue: null, modelName: PROPERTY_TYPE , Coded Values: [FeeSimple: FeeSimple] , [LeasedToUBC: LeasedToUBC] , [LeasedFromUBC: LeasedFromUBC] , ...3 more... )
• LABEL_NAME ( type: esriFieldTypeString, alias: LABEL_NAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: LABEL_NAME )
• LABEL_CLASS ( type: esriFieldTypeString, alias: LABEL_CLASS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LABEL_CLASS )
• SHORTNAME ( type: esriFieldTypeString, alias: SHORTNAME, editable: true, nullable: true, length: 100, defaultValue: null, modelName: SHORTNAME )
• CAMPUS_UID ( type: esriFieldTypeString, alias: CAMPUS_UID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CAMPUS_UID )
• BCOM_UID ( type: esriFieldTypeString, alias: BCOM_UID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: BCOM_UID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )
• NAME2 ( type: esriFieldTypeString, alias: NAME2, editable: true, nullable: true, length: 100, defaultValue: null, modelName: NAME2 )
• HOURS ( type: esriFieldTypeString, alias: HOURS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: HOURS )

Templates:

• Name: v_building_Buildings
  Description:
  Prototype:
  NAME2: null
  BLDG_UID: null
  NAME: null
  BLDG_CODE: null
  CONSTR_STATUS: null
  OCCU_DATE: null
  BLDG_USAGE: null
  BLDG_SEC_USAGE: null
  JURISDICTION: null
  NEIGHBOURHOOD: null
  MANAGE_ORG: null
  BLDG_STATE: null
  GREEN_STATUS: null
  CONSTR_TYPE: null
  MAX_FLOORS: null
  BLDG_HEIGHT: null
  GBA: null
  REC_IDS: null
  HAS_SUBBLDGS: null
  GEOM_SOURCE: null
  NOTES: null
  CAMPUS_UID: null
  SHORTNAME: null
  LABEL_CLASS: null
  LABEL_NAME: null
  BLDG_FORM: null
  BLDG_CONDITION: null
  ACCESSIBILITY_RATING: null
  BLDG_MAINTENANCE: null
  HOURS: null
  BCOM_UID: null
  BLDG_CLASS: null
  PROPERTY_TYPE: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Relationships:

• v_address_Addresses (0) -- Related To: v_address_Addresses (0)

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   Query Related Records   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata