Name: dbo.clientdb_property_vw

Display Field: dba_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: prop_id

Unique ID Field:

Name : prop_id

IsSystemMaintained : True

Global ID Field:

Type ID Field:

Fields:

• prop_id (type: esriFieldTypeOID, alias: prop_id, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• prop_val_yr (type: esriFieldTypeSmallInteger, alias: prop_val_yr, SQL Type: sqlTypeOther, nullable: true, editable: true)
• geo_id (type: esriFieldTypeString, alias: geo_id, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• prop_type_cd (type: esriFieldTypeString, alias: prop_type_cd, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• prop_type_desc (type: esriFieldTypeString, alias: prop_type_desc, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• dba_name (type: esriFieldTypeString, alias: dba_name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• legal_desc (type: esriFieldTypeString, alias: legal_desc, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• appraised_val (type: esriFieldTypeDouble, alias: appraised_val, SQL Type: sqlTypeOther, nullable: true, editable: true)
• abs_subdv_cd (type: esriFieldTypeString, alias: abs_subdv_cd, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• mapsco (type: esriFieldTypeString, alias: mapsco, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• map_id (type: esriFieldTypeString, alias: map_id, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• udi_parent_prop_id (type: esriFieldTypeInteger, alias: udi_parent_prop_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• agent_cd (type: esriFieldTypeString, alias: agent_cd, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• situs_display (type: esriFieldTypeString, alias: situs_display, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• situs_num (type: esriFieldTypeString, alias: situs_num, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• situs_street (type: esriFieldTypeString, alias: situs_street, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• street_name (type: esriFieldTypeString, alias: street_name, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true)
• situs_city (type: esriFieldTypeString, alias: situs_city, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• hood_cd (type: esriFieldTypeString, alias: hood_cd, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• hood_name (type: esriFieldTypeString, alias: hood_name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• owner_name (type: esriFieldTypeString, alias: owner_name, SQL Type: sqlTypeOther, length: 70, nullable: true, editable: true)
• addr_line1 (type: esriFieldTypeString, alias: addr_line1, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• addr_line2 (type: esriFieldTypeString, alias: addr_line2, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• addr_line3 (type: esriFieldTypeString, alias: addr_line3, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• addr_city (type: esriFieldTypeString, alias: addr_city, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• addr_state (type: esriFieldTypeString, alias: addr_state, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• addr_zip (type: esriFieldTypeString, alias: addr_zip, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• country_cd (type: esriFieldTypeString, alias: country_cd, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• owner_id (type: esriFieldTypeInteger, alias: owner_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pct_ownership (type: esriFieldTypeDouble, alias: pct_ownership, SQL Type: sqlTypeOther, nullable: true, editable: true)
• udi_child_prop_id (type: esriFieldTypeInteger, alias: udi_child_prop_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• percent_type (type: esriFieldTypeString, alias: percent_type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• exemptions (type: esriFieldTypeString, alias: exemptions, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• state_cd (type: esriFieldTypeString, alias: state_cd, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• jurisdictions (type: esriFieldTypeString, alias: jurisdictions, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• image_path (type: esriFieldTypeString, alias: image_path, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• show_values (type: esriFieldTypeString, alias: show_values, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• tax_area_id (type: esriFieldTypeInteger, alias: tax_area_id, SQL Type: sqlTypeOther, nullable: true, editable: true)
• tax_area (type: esriFieldTypeString, alias: tax_area, SQL Type: sqlTypeOther, length: 300, nullable: true, editable: true)
• dor_use_code (type: esriFieldTypeString, alias: dor_use_code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• open_space (type: esriFieldTypeString, alias: open_space, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• dfl (type: esriFieldTypeString, alias: dfl, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• historic (type: esriFieldTypeString, alias: historic, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• remodel (type: esriFieldTypeString, alias: remodel, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• multi_fam (type: esriFieldTypeString, alias: multi_fam, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• township_code (type: esriFieldTypeString, alias: township_code, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• range_code (type: esriFieldTypeString, alias: range_code, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• township_section (type: esriFieldTypeString, alias: township_section, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• legal_acreage (type: esriFieldTypeDouble, alias: legal_acreage, SQL Type: sqlTypeOther, nullable: true, editable: true)
• non_taxed_mkt_val (type: esriFieldTypeDouble, alias: non_taxed_mkt_val, SQL Type: sqlTypeOther, nullable: true, editable: true)
• is_leased_land_property (type: esriFieldTypeSmallInteger, alias: is_leased_land_property, SQL Type: sqlTypeOther, nullable: true, editable: true)
• property_use_cd (type: esriFieldTypeString, alias: property_use_cd, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• secondary_use_cd (type: esriFieldTypeString, alias: secondary_use_cd, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• web_suppression (type: esriFieldTypeString, alias: web_suppression, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• confidential_flag (type: esriFieldTypeString, alias: confidential_flag, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• certification_dt (type: esriFieldTypeDate, alias: certification_dt, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• all_taxes_paid (type: esriFieldTypeInteger, alias: all_taxes_paid, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sale_date (type: esriFieldTypeDate, alias: sale_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• township (type: esriFieldTypeString, alias: township, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)
• Range (type: esriFieldTypeString, alias: Range, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true)

Templates:

Name: dbo.clientdb_property_vw
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:44:12 PM

Schema Last Edit Date: 1/8/2025 10:44:12 PM

Data Last Edit Date: 1/8/2025 10:44:12 PM

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