Name: berdo_static_data_23_reporting_map

Display Field: Property_Owner_Name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: Migrated from EGIS.ASG.parcels_21 on vsql22 on February 2023

Copyright Text: (REQUIRED)

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 739808.17418474
YMin: 2908686.77507566
XMax: 803833.649808064
YMax: 2970085.93836632
Spatial Reference: 102686 (2249)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"BERDO_Reporting_Status","defaultSymbol":null,"uniqueValueInfos":[{"value":"7 - berdo accepted","symbol":{"color":[40,139,228,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"7 - berdo accepted"},{"value":"5 - verifier accepted","symbol":{"color":[40,139,228,211],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"5 - verifier accepted"},{"value":"4 verifier rejected","symbol":{"color":[40,139,228,144],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"4 verifier rejected"},{"value":"3 - sent to verifier","symbol":{"color":[40,139,228,93],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"3 - sent to verifier"},{"value":"2 - missing verifier","symbol":{"color":[40,139,228,39],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"2 - missing verifier"},{"value":"1 - no data reported","symbol":{"color":[251,77,66,131],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"1 - no data reported"},{"value":"0 - not claimed","symbol":{"color":[251,77,66,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"0 - not claimed"},{"value":"federal","symbol":{"color":[133,133,133,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"federal"},{"value":"state","symbol":{"color":[133,133,133,255],"outline":{"color":[153,153,153,64],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"state"}]},"transparency":20}

HasZ: false

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)
• OBJECTID_1 (type: esriFieldTypeInteger, alias: OBJECTID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BERDO_ID (type: esriFieldTypeInteger, alias: BERDO ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Tax_Parcel_ID (type: esriFieldTypeDouble, alias: Tax Parcel ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• parcelID_txt (type: esriFieldTypeString, alias: parcelID_txt, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Property_Owner_Name (type: esriFieldTypeString, alias: Property Owner Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Compliance_Status (type: esriFieldTypeString, alias: Compliance Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BERDO_Reporting_Status (type: esriFieldTypeString, alias: BERDO Reporting Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Building_Address (type: esriFieldTypeString, alias: Building Address , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Building_Address_City (type: esriFieldTypeString, alias: Building Address City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Building_Address_Zip_Code (type: esriFieldTypeString, alias: Building Address Zip Code, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Parcel_Address (type: esriFieldTypeString, alias: Parcel Address , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Parcel_Address_City (type: esriFieldTypeString, alias: Parcel Address City, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Parcel_Address_Zip_Code (type: esriFieldTypeInteger, alias: Parcel Address Zip Code, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Reported_Gross_Floor_Area__Sq_F (type: esriFieldTypeDouble, alias: Reported Gross Floor Area (Sq Ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Reported_Enclosed_Parking_Area_ (type: esriFieldTypeString, alias: Reported Enclosed Parking Area (Sq Ft), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Largest_Property_Type (type: esriFieldTypeString, alias: Largest Property Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• All_Property_Types (type: esriFieldTypeString, alias: All Property Types, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Site_EUI__Energy_Use_Intensity_ (type: esriFieldTypeDouble, alias: Site EUI (Energy Use Intensity kBtu/ft²), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Energy_Star_Score (type: esriFieldTypeString, alias: Energy Star Score, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Total_Site_Energy_Usage__kBtu_ (type: esriFieldTypeDouble, alias: Total Site Energy Usage (kBtu), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Natural_Gas_Usage__kBtu_ (type: esriFieldTypeString, alias: Natural Gas Usage (kBtu), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Electricity_Usage__kBtu_ (type: esriFieldTypeDouble, alias: Electricity Usage (kBtu), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Renewable_System_Electricity_Us (type: esriFieldTypeString, alias: Renewable System Electricity Usage Onsite (kBtu) , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• District_Hot_Water_Usage__kBtu_ (type: esriFieldTypeString, alias: District Hot Water Usage (kBtu), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• District_Chilled_Water_Usage__k (type: esriFieldTypeString, alias: District Chilled Water Usage (kBtu), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• District_Steam_Usage__kBtu_ (type: esriFieldTypeString, alias: District Steam Usage (kBtu), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Fuel_Oil_1_Usage__kBtu_ (type: esriFieldTypeString, alias: Fuel Oil 1 Usage (kBtu), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Fuel_Oil_2_Usage__kBtu_ (type: esriFieldTypeString, alias: Fuel Oil 2 Usage (kBtu), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Fuel_Oil_4_Usage__kBtu_ (type: esriFieldTypeString, alias: Fuel Oil 4 Usage (kBtu), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Fuel_Oil_5_and_6_Usage__kBtu_ (type: esriFieldTypeString, alias: Fuel Oil 5 and 6 Usage (kBtu), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Propane_Usage__kBtu_ (type: esriFieldTypeString, alias: Propane Usage (kBtu), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Diesel_Usage__kBtu_ (type: esriFieldTypeString, alias: Diesel Usage (kBtu), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Kerosene_Usage__kBtu_ (type: esriFieldTypeString, alias: Kerosene Usage (kBtu), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Water_Usage_Intensity__Gallons_ (type: esriFieldTypeDouble, alias: Water Usage Intensity (Gallons/ft²), SQL Type: sqlTypeOther, nullable: true, editable: true)
• COL_AG (type: esriFieldTypeString, alias: COL_AG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• COL_AH (type: esriFieldTypeString, alias: COL_AH, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Community_Choice_Electricity_Pa (type: esriFieldTypeString, alias: Community Choice Electricity Participation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Renewable_Energy_Purchased_thro (type: esriFieldTypeString, alias: Renewable Energy Purchased through a Power Purchase Agreement (PPA) , SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Renewable_Energy_Certificate__R (type: esriFieldTypeString, alias: Renewable Energy Certificate (REC) Purchase, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Backup_Generator (type: esriFieldTypeString, alias: Backup Generator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Battery_Storage (type: esriFieldTypeString, alias: Battery Storage, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Electric_Vehicle__EV__Charging (type: esriFieldTypeString, alias: Electric Vehicle (EV) Charging, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Cooresponding_Campus_ID (type: esriFieldTypeInteger, alias: Cooresponding Campus ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• COL_AQ (type: esriFieldTypeString, alias: COL_AQ, SQL Type: sqlTypeOther, length: 255, 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: pub_parcels_21_ExportFeature
Description:
Drawing Tool: esriFeatureEditToolPolygon
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/28/2023 1:47:27 PM

Schema Last Edit Date: 7/28/2023 1:47:27 PM

Data Last Edit Date: 7/6/2023 8:50:52 PM

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