View In:   ArcGIS Online Map Viewer

Name: Sales Analysis

Display Field: lowparcelid

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description:

Service Item Id: 46a893b0e2ea4fc6aa1270f200439e8f

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.800002770279935E7
YMin: -1.2000120992079366E7
XMax: 1.800002770279935E7
YMax: 1.600032826754906E7
Spatial Reference: 102100  (0)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSFSSolid
Color: [225, 225, 225, 255]
Outline:
Style: esriSLSSolid
Color: [156, 156, 156, 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: true

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, length: 4, type: esriFieldTypeOID, alias: OBJECTID )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, alias: GlobalID )
• lowparcelid ( nullable: true, editable: true, defaultValue: null, length: 30, alias: Lowest Parcel Identification Number, type: esriFieldTypeString )
• parcelid ( nullable: true, editable: true, defaultValue: null, length: 30, alias: Parcel Identification Number, type: esriFieldTypeString )
• saleamnt ( nullable: true, editable: true, defaultValue: null, alias: Sale Amount, type: esriFieldTypeDouble )
• cntassdval ( nullable: true, editable: true, defaultValue: null, alias: Assessed Value, type: esriFieldTypeDouble )
• salesratio ( nullable: true, editable: true, defaultValue: null, alias: Sales Ratio, type: esriFieldTypeDouble )
• saletype ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Sale Type, type: esriFieldTypeString , Coded Values: [Valid: Valid] , [Invalid: Invalid] )
• salenonqualifieddscrp ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Non Qaulified Description, type: esriFieldTypeString )
• fulladdr ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Site Address, type: esriFieldTypeString )
• nghbrhdcd ( nullable: true, editable: true, defaultValue: null, length: 10, alias: Assessing Neighborhood Code, type: esriFieldTypeString )
• docname ( nullable: true, editable: true, defaultValue: null, length: 200, alias: Document Name, type: esriFieldTypeString )
• recorddt ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Date Recorded, type: esriFieldTypeDate )
• transdt ( nullable: true, editable: true, defaultValue: null, precision: 1, length: 29, alias: Transaction Date, type: esriFieldTypeDate )
• grantor ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Grantor, type: esriFieldTypeString )
• grantee ( nullable: true, editable: true, defaultValue: null, length: 255, alias: Grantee, type: esriFieldTypeString )
• liber ( nullable: true, editable: true, defaultValue: null, length: 10, alias: Liber, type: esriFieldTypeString )
• page ( nullable: true, editable: true, defaultValue: null, length: 10, alias: Page, type: esriFieldTypeString )
• cvttxcd ( nullable: true, editable: true, defaultValue: null, length: 4, alias: Tax District Code, type: esriFieldTypeString )
• cvttxdscrp ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Tax District Description, type: esriFieldTypeString )
• schltxcd ( nullable: true, editable: true, defaultValue: null, length: 4, alias: School District Code, type: esriFieldTypeString )
• schldscrp ( nullable: true, editable: true, defaultValue: null, length: 100, alias: School District Description, type: esriFieldTypeString )
• usecd ( nullable: true, editable: true, defaultValue: null, length: 4, alias: Assessing Use Code, type: esriFieldTypeString )
• usedscrp ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Assessing Use Description, type: esriFieldTypeString )
• classcd ( nullable: true, editable: true, defaultValue: null, length: 10, alias: Property Class Code, type: esriFieldTypeString )
• classdscrp ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Property Class, type: esriFieldTypeString )
• strclass ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Structure Class, type: esriFieldTypeString )
• classmod ( nullable: true, editable: true, defaultValue: null, length: 5, alias: Structure Class Modifier, type: esriFieldTypeString )
• resstrtype ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Residential Structure Type, type: esriFieldTypeString )
• bldgarea ( nullable: true, editable: true, defaultValue: null, alias: Building Area, type: esriFieldTypeDouble )
• resflrarea ( nullable: true, editable: true, defaultValue: null, alias: Residential Floor Area, type: esriFieldTypeDouble )
• floorcount ( nullable: true, editable: true, defaultValue: null, alias: Number of Floors, type: esriFieldTypeSmallInteger )
• resyrblt ( nullable: true, editable: true, defaultValue: null, alias: Residential Year Built, type: esriFieldTypeDouble )
• parcelsize ( nullable: true, editable: true, defaultValue: null, alias: Parcel Size, type: esriFieldTypeDouble )
• statedarea ( nullable: true, editable: true, defaultValue: null, length: 50, alias: Stated Area, type: esriFieldTypeString )
• imageurl ( nullable: true, editable: true, defaultValue: null, length: 1000, alias: Image URL, type: esriFieldTypeString )
• totalrooms ( nullable: true, editable: true, defaultValue: null, alias: Total Rooms, type: esriFieldTypeDouble )
• bedrooms ( nullable: true, editable: true, defaultValue: null, alias: Bedrooms, type: esriFieldTypeDouble )
• bathrooms ( nullable: true, editable: true, defaultValue: null, alias: Bathrooms, type: esriFieldTypeDouble )
• dom ( nullable: true, editable: true, defaultValue: null, alias: Days on Market, type: esriFieldTypeInteger )
• adjsaleamnt ( nullable: true, editable: true, defaultValue: null, alias: Adjusted Sale Amount, type: esriFieldTypeDouble )
• saleppsqft ( nullable: true, editable: true, defaultValue: null, alias: Sale Price Per Square Foot, type: esriFieldTypeDouble )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• SHAPE__Area ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )

Templates:

• Name: Sales Analysis
  Description:
  Prototype:
  schldscrp: null
  classdscrp: null
  salenonqualifieddscrp: null
  dom: null
  floorcount: null
  nghbrhdcd: null
  grantee: null
  bldgarea: null
  totalrooms: null
  grantor: null
  saleppsqft: null
  salesratio: null
  usecd: null
  parcelid: null
  strclass: null
  classmod: null
  resflrarea: null
  liber: null
  parcelsize: null
  saleamnt: null
  fulladdr: null
  transdt: null
  cntassdval: null
  cvttxdscrp: null
  resyrblt: null
  schltxcd: null
  bathrooms: null
  statedarea: null
  usedscrp: null
  bedrooms: null
  saletype: null
  lowparcelid: null
  imageurl: null
  classcd: null
  adjsaleamnt: null
  page: null
  cvttxcd: null
  docname: null
  resstrtype: null
  recorddt: null
  
  Drawing Tool: esriFeatureEditToolPolygon

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

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