Name: OPSDB.DBO.ParcelData_2014
Display Field: st_name
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:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- neighborhood (type: esriFieldTypeString, alias: neighborhood, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- PIN (type: esriFieldTypeString, alias: PIN, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true)
- house_num (type: esriFieldTypeString, alias: house_num, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
- st_dir (type: esriFieldTypeString, alias: st_dir, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- st_name (type: esriFieldTypeString, alias: st_name, SQL Type: sqlTypeOther, length: 22, nullable: true, editable: true)
- apt_num (type: esriFieldTypeString, alias: apt_num, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- st_suffix (type: esriFieldTypeString, alias: st_suffix, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- city (type: esriFieldTypeString, alias: city, SQL Type: sqlTypeOther, length: 28, nullable: true, editable: true)
- taxpayer_address (type: esriFieldTypeString, alias: taxpayer_address, SQL Type: sqlTypeOther, length: 22, nullable: true, editable: true)
- zip_4 (type: esriFieldTypeString, alias: zip_4, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
- taxpayer_city_state (type: esriFieldTypeString, alias: taxpayer_city_state, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
- land_AV (type: esriFieldTypeString, alias: land_AV, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
- taxpayer_zip (type: esriFieldTypeString, alias: taxpayer_zip, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- Imp_Value (type: esriFieldTypeString, alias: Imp_Value, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
- age (type: esriFieldTypeString, alias: age, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- total_Value (type: esriFieldTypeString, alias: total_Value, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
- type_res (type: esriFieldTypeString, alias: type_res, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- no_apt (type: esriFieldTypeString, alias: no_apt, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- use_ (type: esriFieldTypeString, alias: use_, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- ext_wall_const (type: esriFieldTypeString, alias: ext_wall_const, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- garage_const (type: esriFieldTypeString, alias: garage_const, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- garage_size (type: esriFieldTypeString, alias: garage_size, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- num_bed (type: esriFieldTypeString, alias: num_bed, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- rooms (type: esriFieldTypeString, alias: rooms, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- num_full_baths (type: esriFieldTypeString, alias: num_full_baths, SQL Type: sqlTypeOther, length: 2, nullable: true, editable: true)
- base_type (type: esriFieldTypeString, alias: base_type, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- num_half_baths (type: esriFieldTypeString, alias: num_half_baths, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- attic_type (type: esriFieldTypeString, alias: attic_type, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- base_fin (type: esriFieldTypeString, alias: base_fin, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- attic_fin (type: esriFieldTypeString, alias: attic_fin, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- cental_a_c (type: esriFieldTypeString, alias: cental_a_c, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- bldg_sq_ft (type: esriFieldTypeString, alias: bldg_sq_ft, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
- num_fireplaces (type: esriFieldTypeString, alias: num_fireplaces, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
- imp_class (type: esriFieldTypeString, alias: imp_class, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- land_sq_ft (type: esriFieldTypeString, alias: land_sq_ft, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
- multi_imp_code (type: esriFieldTypeString, alias: multi_imp_code, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- overall_class (type: esriFieldTypeString, alias: overall_class, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
- depth (type: esriFieldTypeString, alias: depth, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- front_ft (type: esriFieldTypeString, alias: front_ft, SQL Type: sqlTypeOther, length: 7, nullable: true, editable: true)
- tax_code (type: esriFieldTypeString, alias: tax_code, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- ex_ag_code (type: esriFieldTypeString, alias: ex_ag_code, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
- taxpayer_name (type: esriFieldTypeString, alias: taxpayer_name, SQL Type: sqlTypeOther, length: 22, nullable: true, editable: true)
- exempt_agency_name (type: esriFieldTypeString, alias: exempt_agency_name, SQL Type: sqlTypeOther, length: 22, nullable: true, editable: true)
- landmark_base_yr (type: esriFieldTypeString, alias: landmark_base_yr, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
- PIN10 (type: esriFieldTypeString, alias: PIN10, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
Templates:
Name: OPSDB.DBO.ParcelData_2014
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 5/4/2021 9:49:16 PM
Schema Last Edit Date: 5/4/2021 9:49:16 PM
Data Last Edit Date: 5/4/2021 9:49:16 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat