Name: dbo."_clientdb_sales"

Display Field: owner_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: chg_of_owner_id

Unique ID Field:

Name : chg_of_owner_id

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• chg_of_owner_id (type: esriFieldTypeOID, alias: chg_of_owner_id, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• prop_id (type: esriFieldTypeInteger, alias: prop_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• prop_type_cd (type: esriFieldTypeString, alias: prop_type_cd, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• property_type (type: esriFieldTypeString, alias: property_type, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
• state_cd (type: esriFieldTypeString, alias: state_cd, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• school_id (type: esriFieldTypeInteger, alias: school_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• city_id (type: esriFieldTypeInteger, alias: city_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• imprv_class (type: esriFieldTypeString, alias: imprv_class, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• actual_yr_built (type: esriFieldTypeSmallInteger, alias: actual_yr_built, SQL Type: sqlTypeOther, nullable: true, editable: true)
• living_area_sqft (type: esriFieldTypeDouble, alias: living_area_sqft, SQL Type: sqlTypeOther, nullable: true, editable: true)
• land_type_cd (type: esriFieldTypeString, alias: land_type_cd, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• sale_dt (type: esriFieldTypeDate, alias: sale_dt, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• sl_price (type: esriFieldTypeDouble, alias: sl_price, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sl_adj_price (type: esriFieldTypeDouble, alias: sl_adj_price, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sl_type_cd (type: esriFieldTypeString, alias: sl_type_cd, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• land_only_sale (type: esriFieldTypeSmallInteger, alias: land_only_sale, SQL Type: sqlTypeOther, nullable: true, editable: true)
• include_no_calc (type: esriFieldTypeString, alias: include_no_calc, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• sl_ratio_cd (type: esriFieldTypeString, alias: sl_ratio_cd, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• eff_yr_built (type: esriFieldTypeSmallInteger, alias: eff_yr_built, SQL Type: sqlTypeOther, nullable: true, editable: true)
• include_reason (type: esriFieldTypeString, alias: include_reason, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• geo_id (type: esriFieldTypeString, alias: geo_id, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• simple_geo_id (type: esriFieldTypeString, alias: simple_geo_id, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• sl_adj_reason (type: esriFieldTypeString, alias: sl_adj_reason, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• true_sl_price (type: esriFieldTypeDouble, alias: true_sl_price, SQL Type: sqlTypeOther, nullable: true, editable: true)
• local_dor_code (type: esriFieldTypeString, alias: local_dor_code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• living_area_sqft2 (type: esriFieldTypeDouble, alias: living_area_sqft2, SQL Type: sqlTypeOther, nullable: true, editable: true)
• living_area (type: esriFieldTypeDouble, alias: living_area, SQL Type: sqlTypeOther, nullable: true, editable: true)
• imprv_sub_class (type: esriFieldTypeString, alias: imprv_sub_class, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• condition_cd (type: esriFieldTypeString, alias: condition_cd, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• heat_ac_code (type: esriFieldTypeString, alias: heat_ac_code, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• land_total_sqft (type: esriFieldTypeDouble, alias: land_total_sqft, SQL Type: sqlTypeOther, nullable: true, editable: true)
• land_total_acres (type: esriFieldTypeDouble, alias: land_total_acres, SQL Type: sqlTypeOther, nullable: true, editable: true)
• additive_val (type: esriFieldTypeDouble, alias: additive_val, SQL Type: sqlTypeOther, nullable: true, editable: true)
• percent_complete (type: esriFieldTypeSingle, alias: percent_complete, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sub_market_cd (type: esriFieldTypeString, alias: sub_market_cd, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• imprv_type_cd (type: esriFieldTypeString, alias: imprv_type_cd, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• imprv_det_meth_cd (type: esriFieldTypeString, alias: imprv_det_meth_cd, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• imprv_det_sub_class_cd (type: esriFieldTypeString, alias: imprv_det_sub_class_cd, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• state_dor_code (type: esriFieldTypeString, alias: state_dor_code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• tax_area_number (type: esriFieldTypeString, alias: tax_area_number, SQL Type: sqlTypeOther, length: 23, nullable: true, editable: true)
• tax_area_id (type: esriFieldTypeInteger, alias: tax_area_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• zoning (type: esriFieldTypeString, alias: zoning, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• mh_make (type: esriFieldTypeString, alias: mh_make, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• mh_model (type: esriFieldTypeString, alias: mh_model, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• mh_serial (type: esriFieldTypeString, alias: mh_serial, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• mh_hud (type: esriFieldTypeString, alias: mh_hud, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• mh_title (type: esriFieldTypeString, alias: mh_title, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• multi_prop_sale (type: esriFieldTypeSmallInteger, alias: multi_prop_sale, SQL Type: sqlTypeOther, nullable: true, editable: true)
• market (type: esriFieldTypeDouble, alias: market, SQL Type: sqlTypeOther, nullable: true, editable: true)
• excise_number (type: esriFieldTypeInteger, alias: excise_number, SQL Type: sqlTypeOther, nullable: true, editable: true)
• deed_type_cd (type: esriFieldTypeString, alias: deed_type_cd, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• deed_num (type: esriFieldTypeString, alias: deed_num, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• deed_book_id (type: esriFieldTypeString, alias: deed_book_id, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• deed_book_page (type: esriFieldTypeString, alias: deed_book_page, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• deed_dt (type: esriFieldTypeDate, alias: deed_dt, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• grantor_cv (type: esriFieldTypeString, alias: grantor_cv, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• grantee_cv (type: esriFieldTypeString, alias: grantee_cv, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• seller (type: esriFieldTypeString, alias: seller, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• buyer (type: esriFieldTypeString, alias: buyer, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• current_owner (type: esriFieldTypeString, alias: current_owner, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• prop_type_desc (type: esriFieldTypeString, alias: prop_type_desc, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• situs_display (type: esriFieldTypeString, alias: situs_display, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• legal_desc (type: esriFieldTypeString, alias: legal_desc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• owner_name (type: esriFieldTypeString, alias: owner_name, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• tax_area (type: esriFieldTypeString, alias: tax_area, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• prop_val_yr (type: esriFieldTypeSmallInteger, alias: prop_val_yr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• show_values (type: esriFieldTypeString, alias: show_values, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• abs_subdv_cd (type: esriFieldTypeString, alias: abs_subdv_cd, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)

Templates:

Name: dbo."_clientdb_sales"
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/8/2025 10:43:32 PM

Schema Last Edit Date: 1/8/2025 10:43:32 PM

Data Last Edit Date: 1/8/2025 10:43:32 PM

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