View In:   ArcGIS Online Map Viewer

Name: residential sales

Display Field: propertyId

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 5c37ec87322b4250a3e932a8f65d2941

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 1079458.75
YMin: 182694.75
XMax: 1143403.5
YMax: 232088.75
Spatial Reference: 102749  (2286)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: isValid
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 0
  Label: Invalid
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [122, 41, 49, 255]
  Size: 3.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 0] Width: 0
• Value: 1
  Label: Valid
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [25, 122, 128, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [13, 74, 76, 255] Width: 0
Transparency: 0
Labeling Info:

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: isValid

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• propertyId ( type: esriFieldTypeString, alias: Property ID, editable: true, nullable: false, length: 20, defaultValue: null, modelName: propertyId )
• situs ( type: esriFieldTypeString, alias: Street Address, editable: true, nullable: true, length: 200, defaultValue: null, modelName: situs )
• neighborhood ( type: esriFieldTypeString, alias: Assessor Neighborhood, editable: true, nullable: false, length: 10, defaultValue: null, modelName: neighborhood )
• saleId ( type: esriFieldTypeString, alias: Excise Number, editable: true, nullable: false, length: 10, defaultValue: null, modelName: saleId )
• salePrice ( type: esriFieldTypeDouble, alias: Sale Price, editable: true, nullable: false, defaultValue: null, modelName: salePrice )
• saleDate ( type: esriFieldTypeDate, alias: Sale Date, editable: true, nullable: false, length: 8, defaultValue: null, modelName: saleDate )
• isLandonly ( type: esriFieldTypeSmallInteger, alias: Land-only Sale, editable: true, nullable: false, defaultValue: null, modelName: isLandonly , Coded Values: [0: False] , [1: True] )
• landAcres ( type: esriFieldTypeSingle, alias: Lot Size (Acres), editable: true, nullable: false, defaultValue: null, modelName: landAcres )
• buildingClass ( type: esriFieldTypeString, alias: Construction Quality, editable: true, nullable: true, length: 10, defaultValue: null, modelName: buildingClass )
• buildingArea ( type: esriFieldTypeDouble, alias: Living Area (SqFt), editable: true, nullable: true, defaultValue: null, modelName: buildingArea )
• yearBuilt ( type: esriFieldTypeSmallInteger, alias: Year Built, editable: true, nullable: true, defaultValue: null, modelName: yearBuilt )
• isValid ( type: esriFieldTypeSmallInteger, alias: Valid Sale, editable: true, nullable: true, defaultValue: null, modelName: isValid , Coded Values: [0: False] , [1: True] )
• buildingStyle ( type: esriFieldTypeSmallInteger, alias: Building Style, editable: true, nullable: true, defaultValue: null, modelName: buildingStyle , Coded Values: [1: Ranch] , [3: 1.5 Finished] , [4: Split] , ...2 more... )

Types:

ID: 0
Name: Invalid
Domains:
• isLandonly:
  Inherited
• isValid:
  Inherited
• buildingStyle:
  Inherited
Templates:
• Name: 0
  Description:
  Prototype:
  isValid: 0
  buildingStyle: null
  propertyId:
  situs: null
  neighborhood:
  saleId:
  salePrice: 0
  saleDate: -2209161600000
  isLandonly: 0
  landAcres: 0
  buildingClass: null
  buildingArea: null
  yearBuilt: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 1
Name: Valid
Domains:
• isLandonly:
  Inherited
• isValid:
  Inherited
• buildingStyle:
  Inherited
Templates:
• Name: 1
  Description:
  Prototype:
  isValid: 1
  buildingStyle: null
  propertyId:
  situs: null
  neighborhood:
  saleId:
  salePrice: 0
  saleDate: -2209161600000
  isLandonly: 0
  landAcres: 0
  buildingClass: null
  buildingArea: null
  yearBuilt: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• SalesToNHPairs (0) -- Related To: residentialNHPairs (2)

Capabilities: Query

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: true

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata