View In:   ArcGIS Online Map Viewer

Name: Sheet1

Display Field: property_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 25ea80d6accc40868c309fbf4473f1ff

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 73957191

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.32491154390917E7
YMin: 3472798.899113866
XMax: -1.061655408584932E7
YMax: 4214732.056097615
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: sale_type
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Individual
  Label: Individual
  Description: N/A
  Symbol:
  
• Value: Portfolio
  Label: Portfolio
  Description: N/A
  Symbol:
  
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: false
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: esriServerHTMLPopupTypeNone

Type ID Field: sale_type

Fields:

• fid0 ( nullable: false, editable: false, defaultValue: null, length: 4, alias: db_oxv17.hsu_u0j1a.Transaction_History_Sheet1.fid, type: esriFieldTypeOID )
• property_name ( nullable: true, editable: true, defaultValue: , length: 256, alias: Property Name, type: esriFieldTypeString )
• property_address ( nullable: true, editable: true, defaultValue: , length: 256, alias: Property Address, type: esriFieldTypeString )
• sale_type ( nullable: true, editable: true, defaultValue: , length: 256, alias: Sale Type, type: esriFieldTypeString )
• year_built ( nullable: true, editable: true, defaultValue: , length: 256, alias: Year Built, type: esriFieldTypeString )
• units ( nullable: true, editable: true, defaultValue: 0, alias: Units, type: esriFieldTypeInteger )
• avg_sf_per_unit ( nullable: true, editable: true, defaultValue: 0, alias: Avg SF Per Unit, type: esriFieldTypeInteger )
• sale_date ( nullable: true, editable: true, defaultValue: , length: 256, alias: Sale Date, type: esriFieldTypeString )
• sale_price ( nullable: true, editable: true, defaultValue: , length: 256, alias: Sale Price, type: esriFieldTypeString )
• price_per_unit ( nullable: true, editable: true, defaultValue: , length: 256, alias: Price Per Unit, type: esriFieldTypeString )
• price_per_sf ( nullable: true, editable: true, defaultValue: , length: 256, alias: Price Per SF, type: esriFieldTypeString )
• latitude ( nullable: true, editable: true, defaultValue: 0, alias: Latitude, type: esriFieldTypeDouble )
• longitude ( nullable: true, editable: true, defaultValue: , length: 256, alias: Longitude, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )

Types:

ID: Individual
Name: Individual
Domains:
Templates:
• Name: Individual
  Description:
  Prototype:
  property_address: null
  sale_date: null
  latitude: null
  sale_type: Individual
  year_built: null
  units: null
  price_per_sf: null
  avg_sf_per_unit: null
  price_per_unit: null
  sale_price: null
  longitude: null
  property_name: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Portfolio
Name: Portfolio
Domains:
Templates:
• Name: Portfolio
  Description:
  Prototype:
  property_address: null
  sale_date: null
  latitude: null
  sale_type: Portfolio
  year_built: null
  units: null
  price_per_sf: null
  avg_sf_per_unit: null
  price_per_unit: null
  sale_price: null
  longitude: null
  property_name: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Sync

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:   Field Groups   Contingent Values

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