Name: FY2024_Property_Database

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

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:

• PID (type: esriFieldTypeInteger, alias: PID, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• GISID (type: esriFieldTypeString, alias: GISID, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• BldgNum (type: esriFieldTypeInteger, alias: BldgNum, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Unit (type: esriFieldTypeString, alias: Unit, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• StateClassCode (type: esriFieldTypeInteger, alias: StateClassCode, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• PropertyClass (type: esriFieldTypeString, alias: PropertyClass, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Zoning (type: esriFieldTypeString, alias: Zoning, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• MapLot (type: esriFieldTypeString, alias: MapLot, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• LandArea (type: esriFieldTypeInteger, alias: LandArea, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• YearOfAssessment (type: esriFieldTypeInteger, alias: YearOfAssessment, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• TaxDistrict (type: esriFieldTypeString, alias: TaxDistrict, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• ResidentialExemption (type: esriFieldTypeString, alias: ResidentialExemption, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• BuildingValue (type: esriFieldTypeInteger, alias: BuildingValue, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• LandValue (type: esriFieldTypeInteger, alias: LandValue, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• AssessedValue (type: esriFieldTypeInteger, alias: AssessedValue, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• SalePrice (type: esriFieldTypeInteger, alias: SalePrice, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• BookPage (type: esriFieldTypeString, alias: BookPage, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• SaleDate (type: esriFieldTypeString, alias: SaleDate, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• PreviousAssessedValue (type: esriFieldTypeInteger, alias: PreviousAssessedValue, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• PropertyTaxAmount (type: esriFieldTypeDouble, alias: PropertyTaxAmount, SQL Type: sqlTypeFloat, nullable: true, editable: true)
• Owner_Name (type: esriFieldTypeString, alias: Owner_Name, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Owner_CoOwnerName (type: esriFieldTypeString, alias: Owner_CoOwnerName, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Owner_Address (type: esriFieldTypeString, alias: Owner_Address, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Owner_Address2 (type: esriFieldTypeString, alias: Owner_Address2, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Owner_City (type: esriFieldTypeString, alias: Owner_City, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Owner_State (type: esriFieldTypeString, alias: Owner_State, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Owner_Zip (type: esriFieldTypeString, alias: Owner_Zip, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Exterior_Style (type: esriFieldTypeString, alias: Exterior_Style, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Exterior_Occupancy (type: esriFieldTypeString, alias: Exterior_Occupancy, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Exterior_NumStories (type: esriFieldTypeString, alias: Exterior_NumStories, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Exterior_WallType (type: esriFieldTypeString, alias: Exterior_WallType, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Exterior_WallHeight (type: esriFieldTypeInteger, alias: Exterior_WallHeight, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Exterior_RoofType (type: esriFieldTypeString, alias: Exterior_RoofType, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Exterior_RoofMaterial (type: esriFieldTypeString, alias: Exterior_RoofMaterial, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Exterior_FloorLocation (type: esriFieldTypeString, alias: Exterior_FloorLocation, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Exterior_View (type: esriFieldTypeString, alias: Exterior_View, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Interior_LivingArea (type: esriFieldTypeInteger, alias: Interior_LivingArea, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Interior_NumUnits (type: esriFieldTypeInteger, alias: Interior_NumUnits, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Interior_TotalRooms (type: esriFieldTypeInteger, alias: Interior_TotalRooms, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Interior_Bedrooms (type: esriFieldTypeInteger, alias: Interior_Bedrooms, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Interior_Kitchens (type: esriFieldTypeString, alias: Interior_Kitchens, SQL Type: sqlTypeNVarchar, length: 256, nullable: true, editable: true)
• Interior_FullBaths (type: esriFieldTypeInteger, alias: Interior_FullBaths, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Interior_HalfBaths (type: esriFieldTypeInteger, alias: Interior_HalfBaths, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Interior_Fireplaces (type: esriFieldTypeInteger, alias: Interior_Fireplaces, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Interior_Flooring (type: esriFieldTypeString, alias: Interior_Flooring, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Interior_Layout (type: esriFieldTypeString, alias: Interior_Layout, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Interior_LaundryInUnit (type: esriFieldTypeString, alias: Interior_LaundryInUnit, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Systems_HeatType (type: esriFieldTypeString, alias: Systems_HeatType, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Systems_HeatFuel (type: esriFieldTypeString, alias: Systems_HeatFuel, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Systems_CentralAir (type: esriFieldTypeString, alias: Systems_CentralAir, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Systems_Plumbing (type: esriFieldTypeString, alias: Systems_Plumbing, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Condition_YearBuilt (type: esriFieldTypeInteger, alias: Condition_YearBuilt, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Condition_InteriorCondition (type: esriFieldTypeString, alias: Condition_InteriorCondition, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Condition_OverallCondition (type: esriFieldTypeString, alias: Condition_OverallCondition, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Condition_OverallGrade (type: esriFieldTypeString, alias: Condition_OverallGrade, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• Parking_Open (type: esriFieldTypeInteger, alias: Parking_Open, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Parking_Covered (type: esriFieldTypeInteger, alias: Parking_Covered, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• Parking_Garage (type: esriFieldTypeString, alias: Parking_Garage, SQL Type: sqlTypeNVarchar, length: 4000, nullable: true, editable: true)
• UnfinishedBasementGross (type: esriFieldTypeInteger, alias: UnfinishedBasementGross, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• FinishedBasementGross (type: esriFieldTypeInteger, alias: FinishedBasementGross, SQL Type: sqlTypeInteger, nullable: true, editable: true)
• ObjectId (type: esriFieldTypeOID, alias: ObjectId, SQL Type: sqlTypeInteger, length: 0, nullable: false, editable: false)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/1/2023 2:57:49 PM

Schema Last Edit Date: 12/1/2023 2:57:49 PM

Data Last Edit Date: 12/1/2023 2:57:49 PM

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