Name: properties_reported_2023

Display Field: property_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text: City of Philadelphia, Office of Sustainability, Division of Energy and Climate Solutions

Min. Scale: 289000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8379893.28882115
YMin: 4847074.56373539
XMax: -8344484.08929619
YMax: 4886171.87274713
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[243,198,19,255],"size":10,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,0],"width":0}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

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)
• y_lat (type: esriFieldTypeString, alias: Latitude, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• x_lon (type: esriFieldTypeString, alias: Longitude, SQL Type: sqlTypeOther, length: 120, nullable: true, editable: true)
• id (type: esriFieldTypeDouble, alias: id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• portfolio_manager_id (type: esriFieldTypeDouble, alias: portfolio_manager_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• philadelphia_building_id (type: esriFieldTypeDouble, alias: philadelphia_building_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• property_name (type: esriFieldTypeString, alias: property_name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• street_address (type: esriFieldTypeString, alias: street_address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• postal_code (type: esriFieldTypeDouble, alias: postal_code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• num_of_buildings (type: esriFieldTypeString, alias: num_of_buildings, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• year_built (type: esriFieldTypeDouble, alias: year_built, SQL Type: sqlTypeOther, nullable: true, editable: true)
• primary_prop_type_epa_calc (type: esriFieldTypeString, alias: primary_prop_type_epa_calc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• total_floor_area_bld_pk_ft2 (type: esriFieldTypeDouble, alias: total_floor_area_bld_pk_ft2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• electric_use_kbtu (type: esriFieldTypeDouble, alias: electric_use_kbtu, SQL Type: sqlTypeOther, nullable: true, editable: true)
• natural_gas_use_kbtu (type: esriFieldTypeDouble, alias: natural_gas_use_kbtu, SQL Type: sqlTypeOther, nullable: true, editable: true)
• fuel_oil_02_use_kbtu (type: esriFieldTypeString, alias: fuel_oil_02_use_kbtu, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• steam_use_kbtu (type: esriFieldTypeDouble, alias: steam_use_kbtu, SQL Type: sqlTypeOther, nullable: true, editable: true)
• energy_star_score (type: esriFieldTypeDouble, alias: energy_star_score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• site_eui_kbtuft2 (type: esriFieldTypeDouble, alias: site_eui_kbtuft2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• source_eui_kbtuft2 (type: esriFieldTypeDouble, alias: source_eui_kbtuft2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• weather_norm_site_eui_kbtuft2 (type: esriFieldTypeDouble, alias: weather_norm_site_eui_kbtuft2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• weather_norm_source_eui_kbtuf (type: esriFieldTypeDouble, alias: weather_norm_source_eui_kbtuft2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_ghg_emissions_mtco2e (type: esriFieldTypeDouble, alias: total_ghg_emissions_mtco2e, SQL Type: sqlTypeOther, nullable: true, editable: true)
• water_use_all_kgal (type: esriFieldTypeDouble, alias: water_use_all_kgal, SQL Type: sqlTypeOther, nullable: true, editable: true)
• water_score (type: esriFieldTypeDouble, alias: water_score, SQL Type: sqlTypeOther, nullable: true, editable: true)
• estar_certified (type: esriFieldTypeString, alias: estar_certified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• compliance_type (type: esriFieldTypeString, alias: compliance_type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• benchmarking_status (type: esriFieldTypeString, alias: benchmarking_status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• data_year (type: esriFieldTypeDouble, alias: Data Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
• point_x (type: esriFieldTypeDouble, alias: point_x, SQL Type: sqlTypeOther, nullable: true, editable: true)
• point_y (type: esriFieldTypeDouble, alias: point_y, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: properties_reported_2023
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• id: 0
• portfolio_manager_id: 0
• philadelphia_building_id: 0
• property_name:
• street_address:
• postal_code: 0
• num_of_buildings:
• year_built: 0
• primary_prop_type_epa_calc:
• total_floor_area_bld_pk_ft2: 0
• electric_use_kbtu: 0
• natural_gas_use_kbtu: 0
• fuel_oil_02_use_kbtu:
• steam_use_kbtu: 0
• energy_star_score: 0
• site_eui_kbtuft2: 0
• source_eui_kbtuft2: 0
• weather_norm_site_eui_kbtuft2: 0
• weather_norm_source_eui_kbtuf: 0
• total_ghg_emissions_mtco2e: 0
• water_use_all_kgal: 0
• water_score: 0
• estar_certified:
• compliance_type:
• benchmarking_status:
• data_year: 2023

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/3/2025 2:33:50 PM

Schema Last Edit Date: 1/3/2025 2:33:50 PM

Data Last Edit Date: 1/3/2025 2:33:50 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat