View In:   ArcGIS Online Map Viewer

Name: CommercialSales

Display Field: owner1_fullname

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 6da6250d6e65467fb4b07ef49515a8d8

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 1155582.0

Max Scale: 1128.0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -8910761.030833794
YMin: 4287552.435671389
XMax: -8854147.724016555
YMax: 4335618.460895412
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [217, 252, 207, 255]
Outline:
Style: esriSLSSolid
Color: [110, 110, 110, 255]
Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

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: true
Supports Returning Geometry Centroid: true
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid_1 ( nullable: false, editable: false, defaultValue: null, alias: OBJECTID_1, type: esriFieldTypeOID )
• acl_number ( nullable: true, editable: true, defaultValue: null, length: 32, alias: ACL_NUMBER, type: esriFieldTypeString )
• common_area ( nullable: true, editable: true, defaultValue: null, alias: COMMON_AREA, type: esriFieldTypeSmallInteger )
• reid ( nullable: true, editable: true, defaultValue: null, length: 7, alias: REID, type: esriFieldTypeString )
• pin_plus_extension ( nullable: true, editable: true, defaultValue: null, length: 19, alias: PIN_PLUS_EXTENSION, type: esriFieldTypeString )
• property_description ( nullable: true, editable: true, defaultValue: null, length: 150, alias: PROPERTY_DESCRIPTION, type: esriFieldTypeString )
• situs_address ( nullable: true, editable: true, defaultValue: null, length: 400, alias: SITUS_ADDRESS, type: esriFieldTypeString )
• appraisal_neighborhood ( nullable: true, editable: true, defaultValue: null, length: 10, alias: APPRAISAL_NEIGHBORHOOD, type: esriFieldTypeString )
• city ( nullable: true, editable: true, defaultValue: null, length: 30, alias: CITY, type: esriFieldTypeString )
• city_percent ( nullable: true, editable: true, defaultValue: null, length: 8, alias: CITY_PERCENT, type: esriFieldTypeString )
• fire_district ( nullable: true, editable: true, defaultValue: null, length: 50, alias: FIRE_DISTRICT, type: esriFieldTypeString )
• fire_district_percent ( nullable: true, editable: true, defaultValue: null, length: 8, alias: FIRE_DISTRICT_PERCENT, type: esriFieldTypeString )
• special_tax_district_1 ( nullable: true, editable: true, defaultValue: null, length: 50, alias: SPECIAL_TAX_DISTRICT_1, type: esriFieldTypeString )
• special_tax_district_1_percent ( nullable: true, editable: true, defaultValue: null, length: 10, alias: SPECIAL_TAX_DISTRICT_1_PERCENT, type: esriFieldTypeString )
• special_tax_district_2 ( nullable: true, editable: true, defaultValue: null, length: 10, alias: SPECIAL_TAX_DISTRICT_2, type: esriFieldTypeString )
• special_tax_district_2_percent ( nullable: true, editable: true, defaultValue: null, length: 15, alias: SPECIAL_TAX_DISTRICT_2_PERCENT, type: esriFieldTypeString )
• township ( nullable: true, editable: true, defaultValue: null, length: 50, alias: TOWNSHIP, type: esriFieldTypeString )
• land_class ( nullable: true, editable: true, defaultValue: null, length: 50, alias: LAND_CLASS, type: esriFieldTypeString )
• calculated_acreage ( nullable: true, editable: true, defaultValue: null, alias: CALCULATED_ACREAGE, type: esriFieldTypeDouble )
• calculated_acres_1 ( nullable: true, editable: true, defaultValue: null, alias: CALCULATED_ACRES, type: esriFieldTypeDouble )
• deeded_acreage ( nullable: true, editable: true, defaultValue: null, alias: DEEDED_ACREAGE, type: esriFieldTypeDouble )
• zoning ( nullable: true, editable: true, defaultValue: null, length: 150, alias: ZONING, type: esriFieldTypeString )
• etj ( nullable: true, editable: true, defaultValue: null, length: 50, alias: ETJ, type: esriFieldTypeString )
• owner ( nullable: true, editable: true, defaultValue: null, length: 600, alias: OWNER, type: esriFieldTypeString )
• owner_mail_1 ( nullable: true, editable: true, defaultValue: null, length: 50, alias: OWNER_MAIL_1, type: esriFieldTypeString )
• owner_mail_2 ( nullable: true, editable: true, defaultValue: null, length: 50, alias: OWNER_MAIL_2, type: esriFieldTypeString )
• owner_mail_3 ( nullable: true, editable: true, defaultValue: null, length: 50, alias: OWNER_MAIL_3, type: esriFieldTypeString )
• owner_mail_city ( nullable: true, editable: true, defaultValue: null, length: 50, alias: OWNER_MAIL_CITY, type: esriFieldTypeString )
• owner_mail_state ( nullable: true, editable: true, defaultValue: null, length: 20, alias: OWNER_MAIL_STATE, type: esriFieldTypeString )
• owner_mail_zip ( nullable: true, editable: true, defaultValue: null, length: 6, alias: OWNER_MAIL_ZIP, type: esriFieldTypeString )
• situs_street_number ( nullable: true, editable: true, defaultValue: null, length: 6, alias: SITUS_STREET_NUMBER, type: esriFieldTypeString )
• situs_direction_prefix ( nullable: true, editable: true, defaultValue: null, length: 2, alias: SITUS_DIRECTION_PREFIX, type: esriFieldTypeString )
• situs_street ( nullable: true, editable: true, defaultValue: null, length: 25, alias: SITUS_STREET, type: esriFieldTypeString )
• situs_street_type ( nullable: true, editable: true, defaultValue: null, length: 4, alias: SITUS_STREET_TYPE, type: esriFieldTypeString )
• situs_direction_suffix ( nullable: true, editable: true, defaultValue: null, length: 2, alias: SITUS_DIRECTION_SUFFIX, type: esriFieldTypeString )
• situs_city ( nullable: true, editable: true, defaultValue: null, length: 35, alias: SITUS_CITY, type: esriFieldTypeString )
• situs_state ( nullable: true, editable: true, defaultValue: null, length: 2, alias: SITUS_STATE, type: esriFieldTypeString )
• situs_zip ( nullable: true, editable: true, defaultValue: null, length: 5, alias: SITUS_ZIP, type: esriFieldTypeString )
• total_land_value_assessed ( nullable: true, editable: true, defaultValue: null, alias: TOTAL_LAND_VALUE_ASSESSED, type: esriFieldTypeDouble )
• total_building_value_assessed ( nullable: true, editable: true, defaultValue: null, alias: TOTAL_BUILDING_VALUE_ASSESSED, type: esriFieldTypeDouble )
• land_use_value ( nullable: true, editable: true, defaultValue: null, alias: LAND_USE_VALUE, type: esriFieldTypeDouble )
• use_value_deferred ( nullable: true, editable: true, defaultValue: null, alias: USE_VALUE_DEFERRED, type: esriFieldTypeDouble )
• historic_value_deferred ( nullable: true, editable: true, defaultValue: null, alias: HISTORIC_VALUE_DEFERRED, type: esriFieldTypeDouble )
• total_deferred_value ( nullable: true, editable: true, defaultValue: null, alias: TOTAL_DEFERRED_VALUE, type: esriFieldTypeDouble )
• total_property_value ( nullable: true, editable: true, defaultValue: null, alias: TOTAL_PROPERTY_VALUE, type: esriFieldTypeDouble )
• deed_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: DEED_DATE, type: esriFieldTypeDate )
• white_card_url ( nullable: true, editable: true, defaultValue: null, length: 200, alias: WHITE_CARD_URL, type: esriFieldTypeString )
• deed_book_page_number ( nullable: true, editable: true, defaultValue: null, length: 13, alias: DEED_BOOK_PAGE_NUMBER, type: esriFieldTypeString )
• revenue_stamp_value ( nullable: true, editable: true, defaultValue: null, alias: REVENUE_STAMP_VALUE, type: esriFieldTypeDouble )
• package_sale_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: PACKAGE_SALE_DATE, type: esriFieldTypeDate )
• package_sale_price ( nullable: true, editable: true, defaultValue: null, alias: PACKAGE_SALE_PRICE, type: esriFieldTypeDouble )
• land_sale_date ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: LAND_SALE_DATE, type: esriFieldTypeDate )
• land_sale_price ( nullable: true, editable: true, defaultValue: null, alias: LAND_SALE_PRICE, type: esriFieldTypeDouble )
• total_units ( nullable: true, editable: true, defaultValue: null, alias: TOTAL_UNITS, type: esriFieldTypeDouble )
• heated_area ( nullable: true, editable: true, defaultValue: null, alias: HEATED_AREA, type: esriFieldTypeInteger )
• other_exemption ( nullable: true, editable: true, defaultValue: null, alias: OTHER_EXEMPTION, type: esriFieldTypeDouble )
• neighborhood ( nullable: true, editable: true, defaultValue: null, length: 100, alias: NEIGHBORHOOD, type: esriFieldTypeString )
• situs_street_miscellaneous ( nullable: true, editable: true, defaultValue: null, length: 6, alias: SITUS_STREET_MISCELLANEOUS, type: esriFieldTypeString )
• total_outbuilding_value ( nullable: true, editable: true, defaultValue: null, alias: TOTAL_OUTBUILDING_VALUE, type: esriFieldTypeDouble )
• build_count ( nullable: true, editable: true, defaultValue: null, alias: BUILD_COUNT, type: esriFieldTypeInteger )
• plat_book_page_number ( nullable: true, editable: true, defaultValue: null, length: 15, alias: PLAT_BOOK_PAGE_NUMBER, type: esriFieldTypeString )
• condo_book_page_number ( nullable: true, editable: true, defaultValue: null, length: 15, alias: CONDO_BOOK_PAGE_NUMBER, type: esriFieldTypeString )
• owner1_fullname ( nullable: true, editable: true, defaultValue: null, length: 100, alias: OWNER1_FULLNAME, type: esriFieldTypeString )
• owner2_fullname ( nullable: true, editable: true, defaultValue: null, length: 100, alias: OWNER2_FULLNAME, type: esriFieldTypeString )
• year_built ( nullable: true, editable: true, defaultValue: null, alias: YEAR_BUILT, type: esriFieldTypeInteger )
• main_building_heated_area ( nullable: true, editable: true, defaultValue: null, alias: MAIN_BUILDING_HEATED_AREA, type: esriFieldTypeInteger )
• bedrooms ( nullable: true, editable: true, defaultValue: null, alias: BEDROOMS, type: esriFieldTypeInteger )
• bathrooms ( nullable: true, editable: true, defaultValue: null, length: 25, alias: BATHROOMS, type: esriFieldTypeString )
• bath_full ( nullable: true, editable: true, defaultValue: null, alias: BATH_FULL, type: esriFieldTypeInteger )
• bath_half ( nullable: true, editable: true, defaultValue: null, alias: BATH_HALF, type: esriFieldTypeInteger )
• building_description ( nullable: true, editable: true, defaultValue: null, length: 100, alias: BUILDING_DESCRIPTION, type: esriFieldTypeString )
• grade ( nullable: true, editable: true, defaultValue: null, length: 25, alias: GRADE, type: esriFieldTypeString )
• building_grade_code ( nullable: true, editable: true, defaultValue: null, length: 2, alias: BUILDING_GRADE_CODE, type: esriFieldTypeString )
• condition ( nullable: true, editable: true, defaultValue: null, length: 25, alias: CONDITION, type: esriFieldTypeString )
• basement_finish_type ( nullable: true, editable: true, defaultValue: null, length: 25, alias: BASEMENT_FINISH_TYPE, type: esriFieldTypeString )
• sale_price_source ( nullable: true, editable: true, defaultValue: null, length: 17, alias: SALE_PRICE_SOURCE, type: esriFieldTypeString )
• objectid ( nullable: true, editable: true, defaultValue: null, alias: OBJECTID, type: esriFieldTypeInteger )
• reid_1 ( nullable: true, editable: true, defaultValue: null, length: 7, alias: REID, type: esriFieldTypeString )
• propertyaddress ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: propertyaddress, type: esriFieldTypeString )
• land_class_1 ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: land_class, type: esriFieldTypeString )
• grade_1 ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: GRADE, type: esriFieldTypeString )
• condition_1 ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: CONDITION, type: esriFieldTypeString )
• yearbuilt ( nullable: true, editable: true, defaultValue: null, alias: yearbuilt, type: esriFieldTypeInteger )
• size ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: Size, type: esriFieldTypeString )
• effyear ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: EffYear, type: esriFieldTypeDate )
• totalassessedvalue ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: TotalAssessedValue, type: esriFieldTypeString )
• saledate ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: saledate, type: esriFieldTypeString )
• sale_price ( nullable: true, editable: true, defaultValue: null, alias: SALE_PRICE, type: esriFieldTypeInteger )
• bldgtype ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: BldgType, type: esriFieldTypeString )
• vcs ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: VCS, type: esriFieldTypeString )
• bma ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: BMA, type: esriFieldTypeString )
• pin ( nullable: true, editable: true, defaultValue: null, alias: pin, type: esriFieldTypeDouble )
• bathrooms_1 ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: Bathrooms, type: esriFieldTypeString )
• bedrooms_1 ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: BedRooms, type: esriFieldTypeString )
• typeuse ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: TypeUse, type: esriFieldTypeString )
• style ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: STYLE, type: esriFieldTypeString )
• total_acreage ( nullable: true, editable: true, defaultValue: null, alias: TOTAL_ACREAGE, type: esriFieldTypeDouble )
• acreage ( nullable: true, editable: true, defaultValue: null, alias: ACREAGE, type: esriFieldTypeDouble )
• sketch ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: Sketch, type: esriFieldTypeString )
• image ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: Image, type: esriFieldTypeString )
• field24 ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: Field24, type: esriFieldTypeString )
• field25 ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: Field25, type: esriFieldTypeString )
• sqft ( nullable: true, editable: true, defaultValue: null, alias: SqFt, type: esriFieldTypeDouble )
• avpsqft ( nullable: true, editable: true, defaultValue: null, alias: Value per sqft, type: esriFieldTypeDouble )
• test2 ( nullable: true, editable: true, defaultValue: null, alias: test2, type: esriFieldTypeInteger )
• totalassessed ( nullable: true, editable: true, defaultValue: null, alias: AssessedValue, type: esriFieldTypeDouble )

Templates:

• Name: CommercialSales
  Description:
  Prototype:
  condition_1: null
  field24: null
  zoning: null
  field25: null
  saledate: null
  total_units: null
  effyear: null
  build_count: null
  total_land_value_assessed: null
  owner_mail_city: null
  typeuse: null
  bathrooms: null
  calculated_acreage: null
  bedrooms: null
  situs_street: null
  size: null
  grade: null
  situs_city: null
  style: null
  propertyaddress: null
  land_sale_price: null
  land_sale_date: null
  city: null
  bath_half: null
  main_building_heated_area: null
  totalassessedvalue: null
  city_percent: null
  calculated_acres_1: null
  land_use_value: null
  bathrooms_1: null
  fire_district_percent: null
  situs_state: null
  pin_plus_extension: null
  bedrooms_1: null
  common_area: null
  total_outbuilding_value: null
  condo_book_page_number: null
  package_sale_date: null
  vcs: null
  situs_street_miscellaneous: null
  sale_price: null
  owner2_fullname: null
  plat_book_page_number: null
  situs_street_type: null
  historic_value_deferred: null
  bma: null
  land_class: null
  grade_1: null
  basement_finish_type: null
  situs_address: null
  special_tax_district_1_percent: null
  building_description: null
  property_description: null
  land_class_1: null
  special_tax_district_2_percent: null
  owner_mail_zip: null
  heated_area: null
  sale_price_source: null
  reid_1: null
  acl_number: null
  revenue_stamp_value: null
  owner_mail_2: null
  deed_book_page_number: null
  other_exemption: null
  pin: null
  owner_mail_3: null
  owner_mail_1: null
  owner1_fullname: null
  owner_mail_state: null
  etj: null
  white_card_url: null
  image: null
  acreage: null
  package_sale_price: null
  condition: null
  building_grade_code: null
  year_built: null
  reid: null
  neighborhood: null
  situs_direction_suffix: null
  situs_zip: null
  total_property_value: null
  deed_date: null
  total_deferred_value: null
  situs_street_number: null
  situs_direction_prefix: null
  bldgtype: null
  owner: null
  bath_full: null
  total_acreage: null
  deeded_acreage: null
  use_value_deferred: null
  yearbuilt: null
  appraisal_neighborhood: null
  total_building_value_assessed: null
  fire_district: null
  special_tax_district_2: null
  sketch: null
  special_tax_district_1: null
  township: null
  objectid: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Capabilities: Query,Extract

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata