Name: properties_webapp_deduped

Display Field: street_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 34b027c1dda347458d294746b6542c48

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• parcel_id ( type: esriFieldTypeString, alias: parcel_id, editable: true, nullable: true, length: 10, defaultValue: null, modelName: parcel_id )
• condo_main ( type: esriFieldTypeString, alias: condo_main, editable: true, nullable: true, length: 10, defaultValue: null, modelName: condo_main )
• ward_precinct_block ( type: esriFieldTypeString, alias: ward_precinct_block, editable: true, nullable: true, length: 7, defaultValue: null, modelName: ward_precinct_block )
• street_number ( type: esriFieldTypeString, alias: street_number, editable: true, nullable: true, length: 10, defaultValue: null, modelName: street_number )
• street_number_suffix ( type: esriFieldTypeString, alias: street_number_suffix, editable: true, nullable: true, length: 10, defaultValue: null, modelName: street_number_suffix )
• street_name ( type: esriFieldTypeString, alias: street_name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: street_name )
• street_name_only ( type: esriFieldTypeString, alias: street_name_only, editable: true, nullable: true, length: 50, defaultValue: null, modelName: street_name_only )
• street_name_suffix ( type: esriFieldTypeString, alias: street_name_suffix, editable: true, nullable: true, length: 2, defaultValue: null, modelName: street_name_suffix )
• apt_unit ( type: esriFieldTypeString, alias: apt_unit, editable: true, nullable: true, length: 20, defaultValue: null, modelName: apt_unit )
• city ( type: esriFieldTypeString, alias: city, editable: true, nullable: true, length: 50, defaultValue: null, modelName: city )
• location_zip_code ( type: esriFieldTypeString, alias: location_zip_code, editable: true, nullable: true, length: 5, defaultValue: null, modelName: location_zip_code )
• location_zip_code_plus_four ( type: esriFieldTypeString, alias: location_zip_code_plus_four, editable: true, nullable: true, length: 4, defaultValue: null, modelName: location_zip_code_plus_four )
• owner ( type: esriFieldTypeString, alias: owner, editable: true, nullable: true, length: 50, defaultValue: null, modelName: owner )
• mail_addressee ( type: esriFieldTypeString, alias: mail_addressee, editable: true, nullable: true, length: 50, defaultValue: null, modelName: mail_addressee )
• mail_street_address1 ( type: esriFieldTypeString, alias: mail_street_address1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: mail_street_address1 )
• mail_street_address2 ( type: esriFieldTypeString, alias: mail_street_address2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: mail_street_address2 )
• mail_city_and_state ( type: esriFieldTypeString, alias: mail_city_and_state, editable: true, nullable: true, length: 50, defaultValue: null, modelName: mail_city_and_state )
• mail_zip_code ( type: esriFieldTypeString, alias: mail_zip_code, editable: true, nullable: true, length: 5, defaultValue: null, modelName: mail_zip_code )
• mail_zip_code_plus_four ( type: esriFieldTypeString, alias: mail_zip_code_plus_four, editable: true, nullable: true, length: 4, defaultValue: null, modelName: mail_zip_code_plus_four )
• country ( type: esriFieldTypeString, alias: country, editable: true, nullable: true, length: 50, defaultValue: null, modelName: country )
• future_owner ( type: esriFieldTypeString, alias: future_owner, editable: true, nullable: true, length: 50, defaultValue: null, modelName: future_owner )
• future_mail_addressee ( type: esriFieldTypeString, alias: future_mail_addressee, editable: true, nullable: true, length: 50, defaultValue: null, modelName: future_mail_addressee )
• future_owner_mail_street_addres ( type: esriFieldTypeString, alias: future_owner_mail_street_address1, editable: true, nullable: true, length: 50, defaultValue: null, modelName: future_owner_mail_street_addres )
• future_owner_mail_street_addr_1 ( type: esriFieldTypeString, alias: future_owner_mail_street_address2, editable: true, nullable: true, length: 50, defaultValue: null, modelName: future_owner_mail_street_addr_1 )
• future_owner_mail_city_and_stat ( type: esriFieldTypeString, alias: future_owner_mail_city_and_state, editable: true, nullable: true, length: 50, defaultValue: null, modelName: future_owner_mail_city_and_stat )
• future_owner_mail_zip_code ( type: esriFieldTypeString, alias: future_owner_mail_zip_code, editable: true, nullable: true, length: 5, defaultValue: null, modelName: future_owner_mail_zip_code )
• future_owner_mail_zip_code_plus ( type: esriFieldTypeString, alias: future_owner_mail_zip_code_plus_four, editable: true, nullable: true, length: 4, defaultValue: null, modelName: future_owner_mail_zip_code_plus )
• future_owner_country ( type: esriFieldTypeString, alias: future_owner_country, editable: true, nullable: true, length: 50, defaultValue: null, modelName: future_owner_country )
• land_area ( type: esriFieldTypeInteger, alias: land_area, editable: true, nullable: true, defaultValue: null, modelName: land_area )
• land_use ( type: esriFieldTypeString, alias: land_use, editable: true, nullable: true, length: 2, defaultValue: null, modelName: land_use )
• exempt_code ( type: esriFieldTypeString, alias: exempt_code, editable: true, nullable: true, length: 4, defaultValue: null, modelName: exempt_code )
• property_type ( type: esriFieldTypeString, alias: property_type, editable: true, nullable: true, length: 4, defaultValue: null, modelName: property_type )
• state_class_code ( type: esriFieldTypeString, alias: state_class_code, editable: true, nullable: true, length: 1, defaultValue: null, modelName: state_class_code )
• residential_building_value ( type: esriFieldTypeDouble, alias: residential_building_value, editable: true, nullable: true, defaultValue: null, modelName: residential_building_value )
• residential_land_value ( type: esriFieldTypeDouble, alias: residential_land_value, editable: true, nullable: true, defaultValue: null, modelName: residential_land_value )
• residential_air_rights_value ( type: esriFieldTypeDouble, alias: residential_air_rights_value, editable: true, nullable: true, defaultValue: null, modelName: residential_air_rights_value )
• commercial_building_value ( type: esriFieldTypeDouble, alias: commercial_building_value, editable: true, nullable: true, defaultValue: null, modelName: commercial_building_value )
• commercial_land_value ( type: esriFieldTypeDouble, alias: commercial_land_value, editable: true, nullable: true, defaultValue: null, modelName: commercial_land_value )
• commercial_air_rights_value ( type: esriFieldTypeDouble, alias: commercial_air_rights_value, editable: true, nullable: true, defaultValue: null, modelName: commercial_air_rights_value )
• industrial_building_value ( type: esriFieldTypeDouble, alias: industrial_building_value, editable: true, nullable: true, defaultValue: null, modelName: industrial_building_value )
• industrial_land_value ( type: esriFieldTypeDouble, alias: industrial_land_value, editable: true, nullable: true, defaultValue: null, modelName: industrial_land_value )
• industrial_air_rights_value ( type: esriFieldTypeDouble, alias: industrial_air_rights_value, editable: true, nullable: true, defaultValue: null, modelName: industrial_air_rights_value )
• open_space_land_value ( type: esriFieldTypeDouble, alias: open_space_land_value, editable: true, nullable: true, defaultValue: null, modelName: open_space_land_value )
• exempt_building_value ( type: esriFieldTypeDouble, alias: exempt_building_value, editable: true, nullable: true, defaultValue: null, modelName: exempt_building_value )
• exempt_land_value ( type: esriFieldTypeDouble, alias: exempt_land_value, editable: true, nullable: true, defaultValue: null, modelName: exempt_land_value )
• total_building_value ( type: esriFieldTypeDouble, alias: total_building_value, editable: true, nullable: true, defaultValue: null, modelName: total_building_value )
• total_land_value ( type: esriFieldTypeDouble, alias: total_land_value, editable: true, nullable: true, defaultValue: null, modelName: total_land_value )
• total_value ( type: esriFieldTypeDouble, alias: total_value, editable: true, nullable: true, defaultValue: null, modelName: total_value )
• latest_sale_date ( type: esriFieldTypeInteger, alias: latest_sale_date, editable: true, nullable: true, defaultValue: null, modelName: latest_sale_date )
• latest_bkpgcert ( type: esriFieldTypeString, alias: latest_bkpgcert, editable: true, nullable: true, length: 10, defaultValue: null, modelName: latest_bkpgcert )
• residential_exemption_flag ( type: esriFieldTypeSmallInteger, alias: residential_exemption_flag, editable: true, nullable: true, defaultValue: null, modelName: residential_exemption_flag )
• coop_value ( type: esriFieldTypeDouble, alias: coop_value, editable: true, nullable: true, defaultValue: null, modelName: coop_value )
• clause_abatement_type_1 ( type: esriFieldTypeString, alias: clause_abatement_type_1, editable: true, nullable: true, length: 6, defaultValue: null, modelName: clause_abatement_type_1 )
• clause_abt_1_pct_ownership ( type: esriFieldTypeString, alias: clause_abt_1_pct_ownership, editable: true, nullable: true, length: 5, defaultValue: null, modelName: clause_abt_1_pct_ownership )
• clause_abt_1_pct_occupancy ( type: esriFieldTypeString, alias: clause_abt_1_pct_occupancy, editable: true, nullable: true, length: 5, defaultValue: null, modelName: clause_abt_1_pct_occupancy )
• clause_abatement_type_2 ( type: esriFieldTypeString, alias: clause_abatement_type_2, editable: true, nullable: true, length: 6, defaultValue: null, modelName: clause_abatement_type_2 )
• clause_abt_2_pct_ownership ( type: esriFieldTypeString, alias: clause_abt_2_pct_ownership, editable: true, nullable: true, length: 5, defaultValue: null, modelName: clause_abt_2_pct_ownership )
• clause_abt_2_pct_occupancy ( type: esriFieldTypeString, alias: clause_abt_2_pct_occupancy, editable: true, nullable: true, length: 5, defaultValue: null, modelName: clause_abt_2_pct_occupancy )
• paraplegic ( type: esriFieldTypeString, alias: paraplegic, editable: true, nullable: true, length: 6, defaultValue: null, modelName: paraplegic )
• workoff_type ( type: esriFieldTypeString, alias: workoff_type, editable: true, nullable: true, length: 6, defaultValue: null, modelName: workoff_type )
• workoff_credit_amt ( type: esriFieldTypeDouble, alias: workoff_credit_amt, editable: true, nullable: true, defaultValue: null, modelName: workoff_credit_amt )
• sewer_betterment_amt ( type: esriFieldTypeDouble, alias: sewer_betterment_amt, editable: true, nullable: true, defaultValue: null, modelName: sewer_betterment_amt )
• street_betterment_amt ( type: esriFieldTypeDouble, alias: street_betterment_amt, editable: true, nullable: true, defaultValue: null, modelName: street_betterment_amt )
• sidewalk_betterment_amt ( type: esriFieldTypeDouble, alias: sidewalk_betterment_amt, editable: true, nullable: true, defaultValue: null, modelName: sidewalk_betterment_amt )
• penalty1_type ( type: esriFieldTypeString, alias: penalty1_type, editable: true, nullable: true, length: 6, defaultValue: null, modelName: penalty1_type )
• penalty1_amt ( type: esriFieldTypeDouble, alias: penalty1_amt, editable: true, nullable: true, defaultValue: null, modelName: penalty1_amt )
• penalty2_type ( type: esriFieldTypeString, alias: penalty2_type, editable: true, nullable: true, length: 6, defaultValue: null, modelName: penalty2_type )
• penalty2_amt ( type: esriFieldTypeDouble, alias: penalty2_amt, editable: true, nullable: true, defaultValue: null, modelName: penalty2_amt )
• penalty3_type ( type: esriFieldTypeString, alias: penalty3_type, editable: true, nullable: true, length: 6, defaultValue: null, modelName: penalty3_type )
• penalty3_amt ( type: esriFieldTypeDouble, alias: penalty3_amt, editable: true, nullable: true, defaultValue: null, modelName: penalty3_amt )
• fine1_type ( type: esriFieldTypeString, alias: fine1_type, editable: true, nullable: true, length: 6, defaultValue: null, modelName: fine1_type )
• fine1_amt ( type: esriFieldTypeDouble, alias: fine1_amt, editable: true, nullable: true, defaultValue: null, modelName: fine1_amt )
• fine2_type ( type: esriFieldTypeString, alias: fine2_type, editable: true, nullable: true, length: 6, defaultValue: null, modelName: fine2_type )
• fine2_amt ( type: esriFieldTypeDouble, alias: fine2_amt, editable: true, nullable: true, defaultValue: null, modelName: fine2_amt )
• fine3_type ( type: esriFieldTypeString, alias: fine3_type, editable: true, nullable: true, length: 6, defaultValue: null, modelName: fine3_type )
• fine3_amt ( type: esriFieldTypeDouble, alias: fine3_amt, editable: true, nullable: true, defaultValue: null, modelName: fine3_amt )
• BID_type ( type: esriFieldTypeString, alias: BID_type, editable: true, nullable: true, length: 6, defaultValue: null, modelName: BID_type )
• BID_amt ( type: esriFieldTypeDouble, alias: BID_amt, editable: true, nullable: true, defaultValue: null, modelName: BID_amt )
• nontax_collection_type ( type: esriFieldTypeString, alias: nontax_collection_type, editable: true, nullable: true, length: 6, defaultValue: null, modelName: nontax_collection_type )
• nontax_collection_amt ( type: esriFieldTypeDouble, alias: nontax_collection_amt, editable: true, nullable: true, defaultValue: null, modelName: nontax_collection_amt )
• personal_exemption_flag ( type: esriFieldTypeSmallInteger, alias: personal_exemption_flag, editable: true, nullable: true, defaultValue: null, modelName: personal_exemption_flag )
• condo_main_value ( type: esriFieldTypeDouble, alias: condo_main_value, editable: true, nullable: true, defaultValue: null, modelName: condo_main_value )

Templates:

• Name: properties_webapp_deduped
  Description:
  Prototype:
  personal_exemption_flag: null
  condo_main_value: null
  parcel_id: null
  condo_main: null
  ward_precinct_block: null
  street_number: null
  street_number_suffix: null
  street_name: null
  street_name_only: null
  street_name_suffix: null
  apt_unit: null
  city: null
  location_zip_code: null
  location_zip_code_plus_four: null
  owner: null
  mail_addressee: null
  mail_street_address1: null
  mail_street_address2: null
  mail_city_and_state: null
  mail_zip_code: null
  mail_zip_code_plus_four: null
  country: null
  future_owner: null
  future_mail_addressee: null
  future_owner_mail_street_addres: null
  future_owner_mail_street_addr_1: null
  future_owner_mail_city_and_stat: null
  future_owner_mail_zip_code: null
  future_owner_mail_zip_code_plus: null
  future_owner_country: null
  land_area: null
  land_use: null
  exempt_code: null
  property_type: null
  state_class_code: null
  residential_building_value: null
  residential_land_value: null
  residential_air_rights_value: null
  commercial_building_value: null
  commercial_land_value: null
  commercial_air_rights_value: null
  industrial_building_value: null
  industrial_land_value: null
  industrial_air_rights_value: null
  open_space_land_value: null
  exempt_building_value: null
  exempt_land_value: null
  total_building_value: null
  total_land_value: null
  total_value: null
  latest_sale_date: null
  latest_bkpgcert: null
  residential_exemption_flag: null
  coop_value: null
  clause_abatement_type_1: null
  clause_abt_1_pct_ownership: null
  clause_abt_1_pct_occupancy: null
  clause_abatement_type_2: null
  clause_abt_2_pct_ownership: null
  clause_abt_2_pct_occupancy: null
  paraplegic: null
  workoff_type: null
  workoff_credit_amt: null
  sewer_betterment_amt: null
  street_betterment_amt: null
  sidewalk_betterment_amt: null
  penalty1_type: null
  penalty1_amt: null
  penalty2_type: null
  penalty2_amt: null
  penalty3_type: null
  penalty3_amt: null
  fine1_type: null
  fine1_amt: null
  fine2_type: null
  fine2_amt: null
  fine3_type: null
  fine3_amt: null
  BID_type: null
  BID_amt: null
  nontax_collection_type: null
  nontax_collection_amt: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Analytic   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata