Name: Current Data - Commercial Building Information
Display Field: CMCL_PID
Type: Table
Geometry Type: N/A
Description:
Service Item Id: d1a5ba01788a42bea25ed5059fc2b579
Copyright Text:
Default Visibility: false
MaxRecordCount: 2000
Supported Query Formats: JSON, geoJSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Supports ValidateSQL: true
Supports Calculate: true
Extent:
Drawing 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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Type ID Field:
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID
)
-
CMCL_PID
(
type: esriFieldTypeInteger, alias: PID, editable: true, nullable: false, defaultValue: null, modelName: CMCL_PID
)
-
CMCL_BID
(
type: esriFieldTypeInteger, alias: BID, editable: true, nullable: false, defaultValue: null, modelName: CMCL_BID
)
-
Building_Number
(
type: esriFieldTypeInteger, alias: Building Number, editable: true, nullable: true, defaultValue: null, modelName: Building_Number
)
-
CNS_IS_CONDO
(
type: esriFieldTypeInteger, alias: CNS_IS_CONDO, editable: true, nullable: true, defaultValue: null, modelName: CNS_IS_CONDO
)
-
CNS_IS_CONDO_MAIN
(
type: esriFieldTypeInteger, alias: CNS_IS_CONDO_MAIN, editable: true, nullable: true, defaultValue: null, modelName: CNS_IS_CONDO_MAIN
)
-
CNS_IS_CMRCL
(
type: esriFieldTypeInteger, alias: CNS_IS_CMRCL, editable: true, nullable: true, defaultValue: null, modelName: CNS_IS_CMRCL
)
-
Style_Code
(
type: esriFieldTypeString, alias: Style Code, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Style_Code
)
-
Style_Description
(
type: esriFieldTypeString, alias: Style Description, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Style_Description
)
-
Model_Code
(
type: esriFieldTypeString, alias: Model Code, editable: true, nullable: true, length: 4, defaultValue: null, modelName: Model_Code
)
-
Model_Description
(
type: esriFieldTypeString, alias: Model Description, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Model_Description
)
-
Grade_Code
(
type: esriFieldTypeString, alias: Grade Code, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Grade_Code
)
-
Grade_Description
(
type: esriFieldTypeString, alias: Grade Description, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Grade_Description
)
-
OCC_Code
(
type: esriFieldTypeString, alias: OCC Code, editable: true, nullable: true, length: 6, defaultValue: null, modelName: OCC_Code
)
-
OCC_Description
(
type: esriFieldTypeString, alias: OCC Description, editable: true, nullable: true, length: 40, defaultValue: null, modelName: OCC_Description
)
-
Area_Effective
(
type: esriFieldTypeInteger, alias: Effective Area, editable: true, nullable: true, defaultValue: null, modelName: Area_Effective
)
-
Area_Gross
(
type: esriFieldTypeInteger, alias: Gross Area, editable: true, nullable: true, defaultValue: null, modelName: Area_Gross
)
-
Area_Living
(
type: esriFieldTypeInteger, alias: Living Area, editable: true, nullable: true, defaultValue: null, modelName: Area_Living
)
-
Stories
(
type: esriFieldTypeString, alias: Stories, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Stories
)
-
Building_Frame_Type
(
type: esriFieldTypeString, alias: Building Framing Type, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Frame_Type
)
-
Exterior_Wall_Material_1
(
type: esriFieldTypeString, alias: Exterior Wall Material 1, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Exterior_Wall_Material_1
)
-
Exterior_Wall_Material_2
(
type: esriFieldTypeString, alias: Exterior Wall Material 2, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Exterior_Wall_Material_2
)
-
Wall_Height
(
type: esriFieldTypeSingle, alias: Wall Height, editable: true, nullable: true, defaultValue: null, modelName: Wall_Height
)
-
Roof_Structure
(
type: esriFieldTypeString, alias: Roof Structure, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Roof_Structure
)
-
Roofing_Material
(
type: esriFieldTypeString, alias: Roofing Material, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Roofing_Material
)
-
Interior_Wall_1
(
type: esriFieldTypeString, alias: Interior Wall 1, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Interior_Wall_1
)
-
Interior_Wall_2
(
type: esriFieldTypeString, alias: Interior Wall 2, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Interior_Wall_2
)
-
Interior_Floor_1
(
type: esriFieldTypeString, alias: Interior Floor 1, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Interior_Floor_1
)
-
Interior_Floor_2
(
type: esriFieldTypeString, alias: Interior Floor 2, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Interior_Floor_2
)
-
Heating_Fuel
(
type: esriFieldTypeString, alias: Heating Fuel, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Heating_Fuel
)
-
Heating_Type
(
type: esriFieldTypeString, alias: Heating Type, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Heating_Type
)
-
Air_Conditioning_Type
(
type: esriFieldTypeString, alias: Air Conditioning Type, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Air_Conditioning_Type
)
-
Occupancy
(
type: esriFieldTypeDouble, alias: Occupancy, editable: true, nullable: true, defaultValue: null, modelName: Occupancy
)
-
Number_Of_Commercial_Units
(
type: esriFieldTypeString, alias: Number of Commercial Units, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Number_Of_Commercial_Units
)
-
Number_Of_Residential_Units
(
type: esriFieldTypeString, alias: Number of Residential Units, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Number_Of_Residential_Units
)
-
Total_Rooms
(
type: esriFieldTypeString, alias: Total Rooms, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Total_Rooms
)
-
Total_Bedrooms
(
type: esriFieldTypeString, alias: Total Bedrooms, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Total_Bedrooms
)
-
Total_Bathrooms
(
type: esriFieldTypeString, alias: Total Bathrooms, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Total_Bathrooms
)
-
Building_Notes_1
(
type: esriFieldTypeString, alias: Building Notes 1, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_1
)
-
Building_Notes_2
(
type: esriFieldTypeString, alias: Building Notes 2, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_2
)
-
Building_Notes_3
(
type: esriFieldTypeString, alias: Building Notes 3, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_3
)
-
Building_Notes_4
(
type: esriFieldTypeString, alias: Building Notes 4, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_4
)
-
Building_Notes_5
(
type: esriFieldTypeString, alias: Building Notes 5, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_5
)
-
Building_Notes_6
(
type: esriFieldTypeString, alias: Building Notes 6, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_6
)
-
Building_Notes_7
(
type: esriFieldTypeString, alias: Building Notes 7, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_7
)
-
Building_Notes_8
(
type: esriFieldTypeString, alias: Building Notes 8, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_8
)
-
Building_Notes_9
(
type: esriFieldTypeString, alias: Building Notes 9, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_9
)
-
Building_Notes_10
(
type: esriFieldTypeString, alias: Building Notes 10, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_10
)
-
Building_Notes_11
(
type: esriFieldTypeString, alias: Building Notes 11, editable: true, nullable: true, length: 40, defaultValue: null, modelName: Building_Notes_11
)
-
Undepreciated_Value
(
type: esriFieldTypeDouble, alias: Undepreciated Value, editable: true, nullable: true, defaultValue: null, modelName: Undepreciated_Value
)
-
Appraised_Value
(
type: esriFieldTypeDouble, alias: Appraised Value, editable: true, nullable: true, defaultValue: null, modelName: Appraised_Value
)
-
Assessed_Value
(
type: esriFieldTypeDouble, alias: Assessed Value, editable: true, nullable: true, defaultValue: null, modelName: Assessed_Value
)
-
Year_Built
(
type: esriFieldTypeInteger, alias: Year Built, editable: true, nullable: true, defaultValue: null, modelName: Year_Built
)
-
Effective_Year_Built
(
type: esriFieldTypeInteger, alias: Effective Year_Built, editable: true, nullable: true, defaultValue: null, modelName: Effective_Year_Built
)
-
Depreciation_Code
(
type: esriFieldTypeString, alias: Depreciation Code, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Depreciation_Code
)
-
Percent_Good
(
type: esriFieldTypeInteger, alias: Percent Good, editable: true, nullable: true, defaultValue: null, modelName: Percent_Good
)
-
Depreciation_Percent
(
type: esriFieldTypeInteger, alias: Depreciation Percent, editable: true, nullable: true, defaultValue: null, modelName: Depreciation_Percent
)
-
Year_Remodeled
(
type: esriFieldTypeInteger, alias: Year Remodeled, editable: true, nullable: true, defaultValue: null, modelName: Year_Remodeled
)
-
Funcional_Obsol
(
type: esriFieldTypeInteger, alias: Funcional Obsol, editable: true, nullable: true, defaultValue: null, modelName: Funcional_Obsol
)
-
Economic_Obsol
(
type: esriFieldTypeInteger, alias: Economic Obsol, editable: true, nullable: true, defaultValue: null, modelName: Economic_Obsol
)
-
RCNLD
(
type: esriFieldTypeDouble, alias: RCNLD, editable: true, nullable: true, defaultValue: null, modelName: RCNLD
)
-
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID
)
Templates:
-
Name: Current Data - Commercial Building Information
Description:
Prototype:
RCNLD: null
Economic_Obsol: null
CMCL_PID: 0
CMCL_BID: 0
Building_Number: null
CNS_IS_CONDO: null
CNS_IS_CONDO_MAIN: null
CNS_IS_CMRCL: null
Style_Code: null
Style_Description: null
Model_Code: null
Model_Description: null
Grade_Code: null
Grade_Description: null
OCC_Code: null
OCC_Description: null
Area_Effective: null
Area_Gross: null
Area_Living: null
Stories: null
Building_Frame_Type: null
Exterior_Wall_Material_1: null
Exterior_Wall_Material_2: null
Wall_Height: null
Roof_Structure: null
Roofing_Material: null
Interior_Wall_1: null
Interior_Wall_2: null
Interior_Floor_1: null
Interior_Floor_2: null
Heating_Fuel: null
Heating_Type: null
Air_Conditioning_Type: null
Occupancy: null
Number_Of_Commercial_Units: null
Number_Of_Residential_Units: null
Total_Rooms: null
Total_Bedrooms: null
Total_Bathrooms: null
Building_Notes_1: null
Building_Notes_2: null
Building_Notes_3: null
Building_Notes_4: null
Building_Notes_5: null
Building_Notes_6: null
Building_Notes_7: null
Building_Notes_8: null
Building_Notes_9: null
Building_Notes_10: null
Building_Notes_11: null
Undepreciated_Value: null
Appraised_Value: null
Assessed_Value: null
Year_Built: null
Effective_Year_Built: null
Depreciation_Code: null
Percent_Good: null
Depreciation_Percent: null
Year_Remodeled: null
Funcional_Obsol: null
Drawing Tool: esriFeatureEditToolNone
Relationships:
Capabilities: Query,Extract
Sync Can Return Changes: true
Is Data Versioned: true
Supports Rollback On Failure: false
Supports ApplyEdits With Global Ids: false
Supports Query With Historic Moment: false
Supports Coordinates Quantization: false
Child Resources:
Field Groups
  
Contingent Values
Supported Operations:
Query
Query Analytic
Query Related Records
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata
Update Metadata