Name: RealEstateTable

Display Field: street_name

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)
• PID (type: esriFieldTypeInteger, alias: PID, SQL Type: sqlTypeOther, nullable: false, editable: true)
• tax_map_number (type: esriFieldTypeString, alias: tax_map_number, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• street_number (type: esriFieldTypeString, alias: street_number, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• street_suffix (type: esriFieldTypeString, alias: street_suffix, SQL Type: sqlTypeOther, length: 5, nullable: false, editable: true)
• street_name (type: esriFieldTypeString, alias: street_name, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• zip_code (type: esriFieldTypeString, alias: zip_code, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• year_built (type: esriFieldTypeString, alias: year_built, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true)
• residential (type: esriFieldTypeString, alias: residential, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• commercial (type: esriFieldTypeString, alias: commercial, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• property_desc (type: esriFieldTypeString, alias: property_desc, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• stories (type: esriFieldTypeString, alias: stories, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• rooms (type: esriFieldTypeString, alias: rooms, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• bedrooms (type: esriFieldTypeString, alias: bedrooms, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• baths (type: esriFieldTypeString, alias: baths, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• fireplaces (type: esriFieldTypeString, alias: fireplaces, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• split_level (type: esriFieldTypeString, alias: split_level, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• split_foyer (type: esriFieldTypeString, alias: split_foyer, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• central_heat (type: esriFieldTypeString, alias: central_heat, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• central_air (type: esriFieldTypeString, alias: central_air, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• type_of_roof (type: esriFieldTypeString, alias: type_of_roof, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• type_of_exterior (type: esriFieldTypeString, alias: type_of_exterior, SQL Type: sqlTypeOther, length: 122, nullable: true, editable: true)
• type_of_basement (type: esriFieldTypeString, alias: type_of_basement, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• type_of_floors (type: esriFieldTypeString, alias: type_of_floors, SQL Type: sqlTypeOther, length: 122, nullable: false, editable: true)
• type_of_walls (type: esriFieldTypeString, alias: type_of_walls, SQL Type: sqlTypeOther, length: 81, nullable: false, editable: true)
• type_of_heat (type: esriFieldTypeString, alias: type_of_heat, SQL Type: sqlTypeOther, length: 81, nullable: true, editable: true)
• class_code (type: esriFieldTypeString, alias: class_code, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• zoning (type: esriFieldTypeString, alias: zoning, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• neighborhood (type: esriFieldTypeString, alias: neighborhood, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• property_use (type: esriFieldTypeString, alias: property_use, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true)
• sqft_of_main (type: esriFieldTypeInteger, alias: sqft_of_main, SQL Type: sqlTypeOther, nullable: true, editable: true)
• desc_of_main_land (type: esriFieldTypeString, alias: desc_of_main_land, SQL Type: sqlTypeOther, length: 53, nullable: true, editable: true)
• size_of_main_land (type: esriFieldTypeDouble, alias: size_of_main_land, SQL Type: sqlTypeOther, nullable: false, editable: true)
• public_water (type: esriFieldTypeString, alias: public_water, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• public_sewer (type: esriFieldTypeString, alias: public_sewer, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• flood_plain (type: esriFieldTypeString, alias: flood_plain, SQL Type: sqlTypeOther, length: 1, nullable: false, editable: true)
• owner (type: esriFieldTypeString, alias: owner, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• owner_address1 (type: esriFieldTypeString, alias: owner_address1, SQL Type: sqlTypeOther, length: 85, nullable: false, editable: true)
• owner_address2 (type: esriFieldTypeString, alias: owner_address2, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• owner_city_state (type: esriFieldTypeString, alias: owner_city_state, SQL Type: sqlTypeOther, length: 52, nullable: true, editable: true)
• owner_zip (type: esriFieldTypeString, alias: owner_zip, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• deed_book_ref (type: esriFieldTypeString, alias: deed_book_ref, SQL Type: sqlTypeOther, length: 15, nullable: false, editable: true)
• sale_price (type: esriFieldTypeString, alias: sale_price, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• date_of_transfer (type: esriFieldTypeString, alias: date_of_transfer, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true)
• prev_owner (type: esriFieldTypeString, alias: prev_owner, SQL Type: sqlTypeOther, length: 1000, nullable: false, editable: true)
• prev_deed_book (type: esriFieldTypeString, alias: prev_deed_book, SQL Type: sqlTypeOther, length: 15, nullable: false, editable: true)
• prev_consideration (type: esriFieldTypeString, alias: prev_consideration, SQL Type: sqlTypeOther, length: 30, nullable: false, editable: true)
• prev_date_of_transfer (type: esriFieldTypeString, alias: prev_date_of_transfer, SQL Type: sqlTypeOther, length: 20, nullable: false, editable: true)
• improvement_assessment (type: esriFieldTypeDouble, alias: improvement_assessment, SQL Type: sqlTypeOther, nullable: true, editable: true)
• land_assessment (type: esriFieldTypeDouble, alias: land_assessment, SQL Type: sqlTypeOther, nullable: true, editable: true)
• total_assessment (type: esriFieldTypeDouble, alias: total_assessment, SQL Type: sqlTypeOther, nullable: true, editable: true)
• legal_description (type: esriFieldTypeString, alias: legal_description, SQL Type: sqlTypeOther, length: 3500, nullable: true, editable: true)
• FullAddress (type: esriFieldTypeString, alias: FullAddress, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• RIM_FILE_PATH (type: esriFieldTypeString, alias: RIM_FILE_PATH, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• RIM_FILE_NAME (type: esriFieldTypeString, alias: RIM_FILE_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)

Templates:

Name: RealEstateTable
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

• PID: 0
• street_suffix:
• year_built:
• residential:
• commercial:
• split_level:
• split_foyer:
• central_heat:
• central_air:
• type_of_floors:
• type_of_walls:
• size_of_main_land: 0
• public_water:
• public_sewer:
• flood_plain:
• owner_address1:
• deed_book_ref:
• sale_price:
• date_of_transfer:
• prev_owner:
• prev_deed_book:
• prev_consideration:
• prev_date_of_transfer:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/8/2023 1:33:47 PM

Schema Last Edit Date: 6/8/2023 1:33:47 PM

Data Last Edit Date: 6/8/2023 1:33:47 PM

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