Name: Join_Building_Parcel_Archetype_EnergyValue_Final

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -12722431.5374682
YMin: 6594565.35499021
XMax: -12674837.1705334
YMax: 6658867.75745265
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSFS","style":"esriSFSSolid","color":[153,44,109,255],"outline":{"type":"esriSLS","style":"esriSLSSolid","color":[110,110,110,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Join_Count (type: esriFieldTypeInteger, alias: Join_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TARGET_FID (type: esriFieldTypeInteger, alias: TARGET_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Join_Count_1 (type: esriFieldTypeInteger, alias: Join_Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TARGET_FID_1 (type: esriFieldTypeInteger, alias: TARGET_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• JOIN_FID (type: esriFieldTypeInteger, alias: JOIN_FID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPATIAL_SOURCE (type: esriFieldTypeString, alias: SPATIAL_SOURCE, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• STAGE (type: esriFieldTypeString, alias: STAGE, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• CMNT (type: esriFieldTypeString, alias: CMNT, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• STRUCTURE_ID (type: esriFieldTypeDouble, alias: STRUCTURE_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NAME (type: esriFieldTypeString, alias: NAME, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• SUBCLASS (type: esriFieldTypeString, alias: SUBCLASS, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• RESOLUTION_ACTION (type: esriFieldTypeString, alias: RESOLUTION_ACTION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• UNMATCHED_REASON (type: esriFieldTypeString, alias: UNMATCHED_REASON, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BLDG_ADDR_NUM (type: esriFieldTypeString, alias: BLDG_ADDR_NUM, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• UPDATE_CMNT (type: esriFieldTypeString, alias: UPDATE_CMNT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• XREF_MASK (type: esriFieldTypeInteger, alias: XREF_MASK, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SUBCLASS_SOURCE (type: esriFieldTypeString, alias: SUBCLASS_SOURCE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NUM_FLOORS (type: esriFieldTypeInteger, alias: NUM_FLOORS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GLOBALID_GUID (type: esriFieldTypeString, alias: GLOBALID_GUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• BUILDING_HEIGHT_MIN (type: esriFieldTypeDouble, alias: BUILDING_HEIGHT_MIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BUILDING_HEIGHT_MAX (type: esriFieldTypeDouble, alias: BUILDING_HEIGHT_MAX, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ELEVATION (type: esriFieldTypeDouble, alias: ELEVATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STRUCTURE_ID_1 (type: esriFieldTypeInteger, alias: STRUCTURE_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SOURCE_SYS_TY (type: esriFieldTypeString, alias: SOURCE_SYS_TY, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BUILDING_ID (type: esriFieldTypeInteger, alias: BUILDING_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNIT_ID (type: esriFieldTypeInteger, alias: UNIT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROLLYEAR (type: esriFieldTypeInteger, alias: ROLLYEAR, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPACE_AYOC (type: esriFieldTypeInteger, alias: SPACE_AYOC, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPACE_TYPE (type: esriFieldTypeString, alias: SPACE_TYPE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SPACE_OCCUPANCY_USE (type: esriFieldTypeString, alias: SPACE_OCCUPANCY_USE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SPACE_AREA (type: esriFieldTypeDouble, alias: SPACE_AREA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPACE_PARKING_CONFIG (type: esriFieldTypeString, alias: SPACE_PARKING_CONFIG, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SPACE_NUM_PARKING_STALLS (type: esriFieldTypeString, alias: SPACE_NUM_PARKING_STALLS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• P2_SPACE_AREA_SF (type: esriFieldTypeDouble, alias: P2_SPACE_AREA_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• FLOOR_NUMBER (type: esriFieldTypeString, alias: FLOOR_NUMBER, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TB000_EFFECTIVE_DATE (type: esriFieldTypeString, alias: TB000_EFFECTIVE_DATE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• TB000_EXPIRY_DATE (type: esriFieldTypeString, alias: TB000_EXPIRY_DATE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• SPACE_ID (type: esriFieldTypeInteger, alias: SPACE_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TB000_PART_OID (type: esriFieldTypeString, alias: TB000_PART_OID, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BLDG_OBJECTID (type: esriFieldTypeInteger, alias: BLDG_OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BLDG_STAGE (type: esriFieldTypeString, alias: BLDG_STAGE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BLDG_STRUCTURE_ID (type: esriFieldTypeInteger, alias: BLDG_STRUCTURE_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BLDG_NAME (type: esriFieldTypeString, alias: BLDG_NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BLDG_SUBCLASS (type: esriFieldTypeString, alias: BLDG_SUBCLASS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BLDG_BLDG_ADDR_NUM (type: esriFieldTypeInteger, alias: BLDG_BLDG_ADDR_NUM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BLDG_SUBCLASS_SOURCE (type: esriFieldTypeString, alias: BLDG_SUBCLASS_SOURCE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BLDG_NUM_FLOORS (type: esriFieldTypeString, alias: BLDG_NUM_FLOORS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• BLDG_BUILDING_HEIGHT_MIN (type: esriFieldTypeDouble, alias: BLDG_BUILDING_HEIGHT_MIN, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BLDG_BUILDING_HEIGHT_MAX (type: esriFieldTypeDouble, alias: BLDG_BUILDING_HEIGHT_MAX, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BLDG_ELEVATION (type: esriFieldTypeDouble, alias: BLDG_ELEVATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BLDG_Shape__Length (type: esriFieldTypeDouble, alias: BLDG_SHAPE_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BLDG_Shape__Area (type: esriFieldTypeDouble, alias: BLDG_SHAPE_Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASMT_OBJECTID (type: esriFieldTypeInteger, alias: ASMT_OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASMT_STRUCTURE_ID (type: esriFieldTypeInteger, alias: ASMT_STRUCTURE_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASMT_BUILDING_ID (type: esriFieldTypeInteger, alias: ASMT_BUILDING_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASMT_UNIT_ID (type: esriFieldTypeInteger, alias: ASMT_UNIT_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASMT_UNIT_STRUCTURE_CODE (type: esriFieldTypeString, alias: ASMT_UNIT_STRUCTURE_CODE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ASMT_UNIT_FLOOR_NUMBER (type: esriFieldTypeString, alias: ASMT_UNIT_FLOOR_NUMBER, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ASMT_UNIT_NUMBER_FLOOR_ABOVE_GR (type: esriFieldTypeString, alias: ASMT_UNIT_NUMBER_FLOOR_ABOVE_GRAD_8, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ASMT_UNIT_LIVING_AREA_ABOVE_GRA (type: esriFieldTypeDouble, alias: ASMT_UNIT_LIVING_AREA_ABOVE_GRADE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASMT_UNIT_LIVING_AREA_BELOW_GRA (type: esriFieldTypeInteger, alias: ASMT_UNIT_LIVING_AREA_BELOW_GRADE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASMT_UNIT_NONLIV_AREA_ABOVE_GRA (type: esriFieldTypeInteger, alias: ASMT_UNIT_NONLIV_AREA_ABOVE_GRADE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASMT_UNIT_NONLIV_AREA_BELOW_GRA (type: esriFieldTypeInteger, alias: ASMT_UNIT_NONLIV_AREA_BELOW_GRADE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASMT_UNIT_NUMBER_FLOOR_BELOW_GR (type: esriFieldTypeString, alias: ASMT_UNIT_NUMBER_FLOOR_BELOW_GRAD_13, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ASMT_UNIT_ADDRESS (type: esriFieldTypeString, alias: ASMT_UNIT_ADDRESS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ASMT_CIVIC_ADDRESS (type: esriFieldTypeString, alias: ASMT_CIVIC_ADDRESS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ASMT_CIVIC_ADDRESS_OVERRIDE (type: esriFieldTypeString, alias: ASMT_CIVIC_ADDRESS_OVERRIDE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ASMT_P2_UNIT_TOTAL_SPACE_AREA (type: esriFieldTypeDouble, alias: ASMT_P2_UNIT_TOTAL_SPACE_AREA, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASMT_P2_UNIT_TOTAL_SPACE_AREA_S (type: esriFieldTypeInteger, alias: ASMT_P2_UNIT_TOTAL_SPACE_AREA_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASMT_P2_UNIT_NR_UNIT_TYPE (type: esriFieldTypeString, alias: ASMT_P2_UNIT_NR_UNIT_TYPE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ASMT_P2_UNIT_LIVING_AREA_ABOVE_ (type: esriFieldTypeInteger, alias: ASMT_P2_UNIT_LIVING_AREA_ABOVE_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASMT_P2_UNIT_LIVING_AREA_BELOW_ (type: esriFieldTypeInteger, alias: ASMT_P2_UNIT_LIVING_AREA_BELOW_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASMT_P2_UNIT_NONLIV_AREA_ABOVE_ (type: esriFieldTypeInteger, alias: ASMT_P2_UNIT_NONLIV_AREA_ABOVE_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASMT_P2_UNIT_NONLIV_AREA_BELOW_ (type: esriFieldTypeInteger, alias: ASMT_P2_UNIT_NONLIV_AREA_BELOW_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASMT_ACCOUNT_PROPERTY_TYPE (type: esriFieldTypeString, alias: ASMT_ACCOUNT_PROPERTY_TYPE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ASMT_ASSESSMENT_CLASS (type: esriFieldTypeString, alias: ASMT_ASSESSMENT_CLASS, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ASMT_CIVIC_NUMBER (type: esriFieldTypeString, alias: ASMT_CIVIC_NUMBER, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ASMT_STREET_NAME (type: esriFieldTypeString, alias: ASMT_STREET_NAME, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ASMT_STREET_TYPE (type: esriFieldTypeString, alias: ASMT_STREET_TYPE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ASMT_STREET_DIR (type: esriFieldTypeString, alias: ASMT_STREET_DIR, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ASMT_CIVIC_UNIT (type: esriFieldTypeString, alias: ASMT_CIVIC_UNIT, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ASMT_P2_BUILDING_COUNT (type: esriFieldTypeInteger, alias: ASMT_P2_BUILDING_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASMT_ACCOUNT_COMMUNITY (type: esriFieldTypeString, alias: ASMT_ACCOUNT_COMMUNITY, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ASMT_ACCOUNT_WARD (type: esriFieldTypeInteger, alias: ASMT_ACCOUNT_WARD, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASMT_UNIT_CONDO_UNIT_TYPE (type: esriFieldTypeString, alias: ASMT_UNIT_CONDO_UNIT_TYPE, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• ASMT_Shape__Length (type: esriFieldTypeDouble, alias: ASMT_SHAPE_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ASMT_Shape__Area (type: esriFieldTypeDouble, alias: ASMT_SHAPE_Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CPID (type: esriFieldTypeDouble, alias: CPID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CORPORATE_SECTION_NUMBER (type: esriFieldTypeString, alias: CORPORATE_SECTION_NUMBER, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• PARCEL_TYPE (type: esriFieldTypeString, alias: PARCEL_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• STAGE_CODE (type: esriFieldTypeInteger, alias: STAGE_CODE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STAGE_DSCRN (type: esriFieldTypeString, alias: STAGE_DSCRN, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• GLOBALID (type: esriFieldTypeString, alias: GLOBALID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• Shape__Length_1 (type: esriFieldTypeDouble, alias: SHAPE_Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Shape__Area_1 (type: esriFieldTypeDouble, alias: SHAPE_Area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STRUCTURE_ID_12 (type: esriFieldTypeInteger, alias: STRUCTURE_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NaturalGas (type: esriFieldTypeDouble, alias: NaturalGas, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Electricity (type: esriFieldTypeDouble, alias: Electricity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Archetype (type: esriFieldTypeString, alias: Archetype, SQL Type: sqlTypeOther, length: 8000, nullable: true, editable: true)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Templates:

Name: Join_Building_Parcel_Archetype_EnergyValue_Final
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/21/2020 4:26:12 PM

Schema Last Edit Date: 9/21/2020 4:26:12 PM

Data Last Edit Date: 9/21/2020 4:26:12 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat