Name: Property_Improvements_Data

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

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)
• ImprovementKey (type: esriFieldTypeString, alias: ImprovementKey, SQL Type: sqlTypeOther, length: 2147483647, nullable: true, editable: true)
• ACCOUNT_NO (type: esriFieldTypeString, alias: ACCOUNT_NO, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• BUILDING_ID (type: esriFieldTypeInteger, alias: BUILDING_ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STYLE (type: esriFieldTypeString, alias: STYLE, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• OCCUPANCY_CODE (type: esriFieldTypeString, alias: OCCUPANCY_CODE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BUILT_AS_CODE (type: esriFieldTypeString, alias: BUILT_AS_CODE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BUILT_AS (type: esriFieldTypeString, alias: BUILT_AS, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• QUALITY_CODE (type: esriFieldTypeString, alias: QUALITY_CODE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PROPERTY_TYPE_CODE (type: esriFieldTypeString, alias: PROPERTY_TYPE_CODE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• IMPROVEMENT_SF (type: esriFieldTypeDouble, alias: IMPROVEMENT_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COMPLETION_PERCENT (type: esriFieldTypeDouble, alias: COMPLETION_PERCENT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UNIT_TYPE (type: esriFieldTypeString, alias: UNIT_TYPE, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• NO_OF_FIREPLACE (type: esriFieldTypeDouble, alias: NO_OF_FIREPLACE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_GARAGE_SF (type: esriFieldTypeDouble, alias: TOTAL_GARAGE_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WALKOUT_BASEMENT_FLAG (type: esriFieldTypeString, alias: WALKOUT_BASEMENT_FLAG, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• TOTAL_PORCH_SF (type: esriFieldTypeDouble, alias: TOTAL_PORCH_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_FINISHED_BASEMENT_SF (type: esriFieldTypeDouble, alias: TOTAL_FINISHED_BASEMENT_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TOTAL_UNFINISHED_BASEMENT_SF (type: esriFieldTypeDouble, alias: TOTAL_UNFINISHED_BASEMENT_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROOF_CONSTRUCTION_TYPE_CODE (type: esriFieldTypeString, alias: ROOF_CONSTRUCTION_TYPE_CODE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• BUILT_AS_SF (type: esriFieldTypeDouble, alias: BUILT_AS_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• EXTERIOR_CONSTRUCTION_TYPE (type: esriFieldTypeString, alias: EXTERIOR_CONSTRUCTION_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• INTERIOR_FINISH_TYPE (type: esriFieldTypeString, alias: INTERIOR_FINISH_TYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NO_OF_STORY (type: esriFieldTypeInteger, alias: NO_OF_STORY, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ROOF_MATERIAL_CODE (type: esriFieldTypeString, alias: ROOF_MATERIAL_CODE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FLOOR_MATERIAL_TYPE_CODE (type: esriFieldTypeString, alias: FLOOR_MATERIAL_TYPE_CODE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NO_OF_BEDROOM (type: esriFieldTypeInteger, alias: NO_OF_BEDROOM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NO_OF_BATHROOM (type: esriFieldTypeInteger, alias: NO_OF_BATHROOM, SQL Type: sqlTypeOther, nullable: true, editable: true)
• BUILT_YEAR (type: esriFieldTypeString, alias: BUILT_YEAR, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• REMODELED_YEAR (type: esriFieldTypeString, alias: REMODELED_YEAR, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• LENGTH_OF_MOBILE_HOME (type: esriFieldTypeDouble, alias: LENGTH_OF_MOBILE_HOME, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WIDTH_OF_MOBILE_HOME (type: esriFieldTypeDouble, alias: WIDTH_OF_MOBILE_HOME, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AVERAGE_STORY_HEIGHT (type: esriFieldTypeInteger, alias: AVERAGE_STORY_HEIGHT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NO_OF_UNIT (type: esriFieldTypeInteger, alias: NO_OF_UNIT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SPRINKLER_COVERAGE_SF (type: esriFieldTypeDouble, alias: SPRINKLER_COVERAGE_SF, SQL Type: sqlTypeOther, nullable: true, editable: true)
• CONDITION (type: esriFieldTypeString, alias: CONDITION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• HVAC (type: esriFieldTypeString, alias: HVAC, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 32, nullable: true, editable: true)
• etl_write_date (type: esriFieldTypeDate, alias: etl_write_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 10/10/2026 11:03:45 AM

Schema Last Edit Date: 10/10/2026 11:02:37 AM

Data Last Edit Date: 10/10/2026 11:02:37 AM

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