Name: properties_webapp_deduped

Display Field: street_name

Type: Table

Geometry Type: N/A

Description: null

Service Item Id: 1ea7dc39a2f44bb2a7b514c5eeaab9b0

Copyright Text: N/A

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
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: true
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: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• parcel_id ( type: esriFieldTypeString, alias: parcel_id, length: 10 )
• condo_main ( type: esriFieldTypeString, alias: condo_main, length: 10 )
• ward_precinct_block ( type: esriFieldTypeString, alias: ward_precinct_block, length: 7 )
• street_number ( type: esriFieldTypeString, alias: street_number, length: 10 )
• street_number_suffix ( type: esriFieldTypeString, alias: street_number_suffix, length: 10 )
• street_name ( type: esriFieldTypeString, alias: street_name, length: 50 )
• street_name_only ( type: esriFieldTypeString, alias: street_name_only, length: 50 )
• street_name_suffix ( type: esriFieldTypeString, alias: street_name_suffix, length: 2 )
• apt_unit ( type: esriFieldTypeString, alias: apt_unit, length: 20 )
• city ( type: esriFieldTypeString, alias: city, length: 50 )
• location_zip_code ( type: esriFieldTypeString, alias: location_zip_code, length: 5 )
• location_zip_code_plus_four ( type: esriFieldTypeString, alias: location_zip_code_plus_four, length: 4 )
• owner ( type: esriFieldTypeString, alias: owner, length: 50 )
• mail_addressee ( type: esriFieldTypeString, alias: mail_addressee, length: 50 )
• mail_street_address1 ( type: esriFieldTypeString, alias: mail_street_address1, length: 50 )
• mail_street_address2 ( type: esriFieldTypeString, alias: mail_street_address2, length: 50 )
• mail_city_and_state ( type: esriFieldTypeString, alias: mail_city_and_state, length: 50 )
• mail_zip_code ( type: esriFieldTypeString, alias: mail_zip_code, length: 5 )
• mail_zip_code_plus_four ( type: esriFieldTypeString, alias: mail_zip_code_plus_four, length: 4 )
• country ( type: esriFieldTypeString, alias: country, length: 50 )
• future_owner ( type: esriFieldTypeString, alias: future_owner, length: 50 )
• future_mail_addressee ( type: esriFieldTypeString, alias: future_mail_addressee, length: 50 )
• future_owner_mail_street_address1 ( type: esriFieldTypeString, alias: future_owner_mail_street_address1, length: 50 )
• future_owner_mail_street_address2 ( type: esriFieldTypeString, alias: future_owner_mail_street_address2, length: 50 )
• future_owner_mail_city_and_state ( type: esriFieldTypeString, alias: future_owner_mail_city_and_state, length: 50 )
• future_owner_mail_zip_code ( type: esriFieldTypeString, alias: future_owner_mail_zip_code, length: 5 )
• future_owner_mail_zip_code_plus_four ( type: esriFieldTypeString, alias: future_owner_mail_zip_code_plus_four, length: 4 )
• future_owner_country ( type: esriFieldTypeString, alias: future_owner_country, length: 50 )
• land_area ( type: esriFieldTypeInteger, alias: land_area )
• land_use ( type: esriFieldTypeString, alias: land_use, length: 2 )
• exempt_code ( type: esriFieldTypeString, alias: exempt_code, length: 4 )
• property_type ( type: esriFieldTypeString, alias: property_type, length: 4 )
• state_class_code ( type: esriFieldTypeString, alias: state_class_code, length: 1 )
• residential_building_value ( type: esriFieldTypeDouble, alias: residential_building_value )
• residential_land_value ( type: esriFieldTypeDouble, alias: residential_land_value )
• residential_air_rights_value ( type: esriFieldTypeDouble, alias: residential_air_rights_value )
• commercial_building_value ( type: esriFieldTypeDouble, alias: commercial_building_value )
• commercial_land_value ( type: esriFieldTypeDouble, alias: commercial_land_value )
• commercial_air_rights_value ( type: esriFieldTypeDouble, alias: commercial_air_rights_value )
• industrial_building_value ( type: esriFieldTypeDouble, alias: industrial_building_value )
• industrial_land_value ( type: esriFieldTypeDouble, alias: industrial_land_value )
• industrial_air_rights_value ( type: esriFieldTypeDouble, alias: industrial_air_rights_value )
• open_space_land_value ( type: esriFieldTypeDouble, alias: open_space_land_value )
• exempt_building_value ( type: esriFieldTypeDouble, alias: exempt_building_value )
• exempt_land_value ( type: esriFieldTypeDouble, alias: exempt_land_value )
• total_building_value ( type: esriFieldTypeDouble, alias: total_building_value )
• total_land_value ( type: esriFieldTypeDouble, alias: total_land_value )
• total_value ( type: esriFieldTypeDouble, alias: total_value )
• latest_sale_date ( type: esriFieldTypeDate, alias: latest_sale_date, length: 8 )
• latest_bkpgcert ( type: esriFieldTypeString, alias: latest_bkpgcert, length: 10 )
• residential_exemption_flag ( type: esriFieldTypeSmallInteger, alias: residential_exemption_flag )
• coop_value ( type: esriFieldTypeDouble, alias: coop_value )
• clause_abatement_type_1 ( type: esriFieldTypeString, alias: clause_abatement_type_1, length: 6 )
• clause_abt_1_pct_ownership ( type: esriFieldTypeString, alias: clause_abt_1_pct_ownership, length: 5 )
• clause_abt_1_pct_occupancy ( type: esriFieldTypeString, alias: clause_abt_1_pct_occupancy, length: 5 )
• clause_abatement_type_2 ( type: esriFieldTypeString, alias: clause_abatement_type_2, length: 6 )
• clause_abt_2_pct_ownership ( type: esriFieldTypeString, alias: clause_abt_2_pct_ownership, length: 5 )
• clause_abt_2_pct_occupancy ( type: esriFieldTypeString, alias: clause_abt_2_pct_occupancy, length: 5 )
• paraplegic ( type: esriFieldTypeString, alias: paraplegic, length: 6 )
• workoff_type ( type: esriFieldTypeString, alias: workoff_type, length: 6 )
• workoff_credit_amt ( type: esriFieldTypeDouble, alias: workoff_credit_amt )
• sewer_betterment_amt ( type: esriFieldTypeDouble, alias: sewer_betterment_amt )
• street_betterment_amt ( type: esriFieldTypeDouble, alias: street_betterment_amt )
• sidewalk_betterment_amt ( type: esriFieldTypeDouble, alias: sidewalk_betterment_amt )
• penalty1_type ( type: esriFieldTypeString, alias: penalty1_type, length: 6 )
• penalty1_amt ( type: esriFieldTypeDouble, alias: penalty1_amt )
• penalty2_type ( type: esriFieldTypeString, alias: penalty2_type, length: 6 )
• penalty2_amt ( type: esriFieldTypeDouble, alias: penalty2_amt )
• penalty3_type ( type: esriFieldTypeString, alias: penalty3_type, length: 6 )
• penalty3_amt ( type: esriFieldTypeDouble, alias: penalty3_amt )
• fine1_type ( type: esriFieldTypeString, alias: fine1_type, length: 6 )
• fine1_amt ( type: esriFieldTypeDouble, alias: fine1_amt )
• fine2_type ( type: esriFieldTypeString, alias: fine2_type, length: 6 )
• fine2_amt ( type: esriFieldTypeDouble, alias: fine2_amt )
• fine3_type ( type: esriFieldTypeString, alias: fine3_type, length: 6 )
• fine3_amt ( type: esriFieldTypeDouble, alias: fine3_amt )
• bid_type ( type: esriFieldTypeString, alias: bid_type, length: 6 )
• bid_amt ( type: esriFieldTypeDouble, alias: bid_amt )
• nontax_collection_type ( type: esriFieldTypeString, alias: nontax_collection_type, length: 6 )
• nontax_collection_amt ( type: esriFieldTypeDouble, alias: nontax_collection_amt )
• personal_exemption_flag ( type: esriFieldTypeSmallInteger, alias: personal_exemption_flag )
• condo_main_value ( type: esriFieldTypeDouble, alias: condo_main_value )
• bill_year ( type: esriFieldTypeSmallInteger, alias: bill_year )
• bill_number ( type: esriFieldTypeInteger, alias: bill_number )
• re_tax_amt ( type: esriFieldTypeDouble, alias: re_tax_amt )
• cpa_amt ( type: esriFieldTypeDouble, alias: cpa_amt )
• downtown_bid_amt ( type: esriFieldTypeDouble, alias: downtown_bid_amt )
• greenway_bid_amt ( type: esriFieldTypeDouble, alias: greenway_bid_amt )
• newmarket_bid_amt ( type: esriFieldTypeDouble, alias: newmarket_bid_amt )
• total_billed_amt ( type: esriFieldTypeDouble, alias: total_billed_amt )
• composite_land_use ( type: esriFieldTypeString, alias: composite_land_use, length: 255 )
• orientation ( type: esriFieldTypeString, alias: orientation, length: 255 )
• corner_unit ( type: esriFieldTypeString, alias: corner_unit, length: 255 )
• floor ( type: esriFieldTypeString, alias: floor, length: 255 )
• rooms ( type: esriFieldTypeString, alias: rooms, length: 255 )
• bedrooms ( type: esriFieldTypeString, alias: bedrooms, length: 255 )
• bedroom_type ( type: esriFieldTypeString, alias: bedroom_type, length: 255 )
• full_bath ( type: esriFieldTypeDouble, alias: full_bath )
• half_bath ( type: esriFieldTypeDouble, alias: half_bath )
• other_fixtures ( type: esriFieldTypeDouble, alias: other_fixtures )
• bath_style_1 ( type: esriFieldTypeString, alias: bath_style_1, length: 255 )
• bath_style_2 ( type: esriFieldTypeString, alias: bath_style_2, length: 255 )
• bath_style_3 ( type: esriFieldTypeString, alias: bath_style_3, length: 255 )
• kitchens ( type: esriFieldTypeDouble, alias: kitchens )
• kitchen_type ( type: esriFieldTypeString, alias: kitchen_type, length: 255 )
• kitchen_style_1 ( type: esriFieldTypeString, alias: kitchen_style_1, length: 255 )
• kitchen_style_2 ( type: esriFieldTypeString, alias: kitchen_style_2, length: 255 )
• kitchen_style_3 ( type: esriFieldTypeString, alias: kitchen_style_3, length: 255 )
• fireplaces ( type: esriFieldTypeDouble, alias: fireplaces )
• penthouse_unit ( type: esriFieldTypeSmallInteger, alias: penthouse_unit )
• ac_type ( type: esriFieldTypeString, alias: ac_type, length: 255 )
• heat_type ( type: esriFieldTypeString, alias: heat_type, length: 255 )
• year_built ( type: esriFieldTypeDouble, alias: year_built )
• interior_condition ( type: esriFieldTypeString, alias: interior_condition, length: 255 )
• interior_finish ( type: esriFieldTypeString, alias: interior_finish, length: 255 )
• view ( type: esriFieldTypeString, alias: view, length: 255 )
• grade ( type: esriFieldTypeString, alias: grade, length: 255 )
• num_parking_spots ( type: esriFieldTypeString, alias: num_parking_spots, length: 255 )
• parking_ownership ( type: esriFieldTypeString, alias: parking_ownership, length: 255 )
• parking_type ( type: esriFieldTypeString, alias: parking_type, length: 255 )
• tandem_parking ( type: esriFieldTypeString, alias: tandem_parking, length: 255 )
• complex ( type: esriFieldTypeString, alias: complex, length: 255 )
• story_height ( type: esriFieldTypeString, alias: story_height, length: 255 )
• roof_cover ( type: esriFieldTypeString, alias: roof_cover, length: 255 )
• roof_structure ( type: esriFieldTypeString, alias: roof_structure, length: 255 )
• exterior_condition ( type: esriFieldTypeString, alias: exterior_condition, length: 255 )
• exterior_finish ( type: esriFieldTypeString, alias: exterior_finish, length: 255 )
• building_style ( type: esriFieldTypeString, alias: building_style, length: 255 )
• foundation ( type: esriFieldTypeString, alias: foundation, length: 255 )
• personal_exemption ( type: esriFieldTypeSmallInteger, alias: personal_exemption )
• residential_exemption ( type: esriFieldTypeString, alias: residential_exemption, length: 1 )
• living_area ( type: esriFieldTypeInteger, alias: living_area )
• gross_area ( type: esriFieldTypeInteger, alias: gross_area )
• year_remodeled ( type: esriFieldTypeSmallInteger, alias: year_remodeled )
• condo_units_residential ( type: esriFieldTypeInteger, alias: condo_units_residential )
• condo_units_commercial ( type: esriFieldTypeInteger, alias: condo_units_commercial )
• condo_units_mixed ( type: esriFieldTypeInteger, alias: condo_units_mixed )
• stories ( type: esriFieldTypeSingle, alias: stories )
• gross_tax ( type: esriFieldTypeDouble, alias: gross_tax )
• net_tax ( type: esriFieldTypeDouble, alias: net_tax )
• persexempt_1 ( type: esriFieldTypeDouble, alias: persexempt_1 )
• persexempt_2 ( type: esriFieldTypeDouble, alias: persexempt_2 )
• persexempt_total ( type: esriFieldTypeDouble, alias: persexempt_total )
• resexempt ( type: esriFieldTypeDouble, alias: resexempt )
• cpa ( type: esriFieldTypeDouble, alias: cpa )
• code_enforcement_tax ( type: esriFieldTypeDouble, alias: code_enforcement_tax )
• 38D_fine ( type: esriFieldTypeDouble, alias: 38D_fine )
• sidewalk_betterment ( type: esriFieldTypeDouble, alias: sidewalk_betterment )
• street_betterment ( type: esriFieldTypeDouble, alias: street_betterment )
• bid_downtown ( type: esriFieldTypeDouble, alias: bid_downtown )
• bid_greenway ( type: esriFieldTypeDouble, alias: bid_greenway )
• bid_newmarket ( type: esriFieldTypeDouble, alias: bid_newmarket )
• description ( type: esriFieldTypeString, alias: description, length: 50 )
• property_code ( type: esriFieldTypeSmallInteger, alias: property_code )
• property_class ( type: esriFieldTypeSmallInteger, alias: property_class )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata