View In:   ArcGIS Online Map Viewer

Name: Comps

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 67e931301de14103a09d3b4aeac47215

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 2311163

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -1.2560264129368875E7
YMin: 3832239.4192478857
XMax: -1.2348279620224968E7
YMax: 4025072.6450374266
Spatial Reference: 102100  (3857)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: product_type
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Office
  Label: Office
  Description: N/A
  Symbol:
  
• Value: Industrial
  Label: Industrial
  Description: N/A
  Symbol:
  
• Value: Retail
  Label: Retail
  Description: N/A
  Symbol:
  
• Value: Land
  Label: Land
  Description: N/A
  Symbol:
  
• Value: Multifamily
  Label: Multifamily
  Description: N/A
  Symbol:
  
• Value: Multi-Family
  Label: Multi-Family
  Description: N/A
  Symbol:
  
• Value: Hospitality
  Label: Hospitality
  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: product_type

Fields:

• fid0 ( nullable: false, editable: false, defaultValue: null, length: 4, alias: db_oxv17.hsu_u0j1a.January_Sale_Comps_MASTER_Comps.fid, type: esriFieldTypeOID )
• comp_id ( nullable: true, editable: true, defaultValue: 0, alias: Comp_ID, type: esriFieldTypeInteger )
• product_type ( nullable: true, editable: true, defaultValue: , length: 256, alias: Product_Type, type: esriFieldTypeString )
• sale_date ( nullable: true, editable: true, defaultValue: -2209161600000, precision: 1, length: 29, alias: Sale_Date, type: esriFieldTypeDate )
• type__class ( nullable: true, editable: true, defaultValue: , length: 256, alias: Type__Class, type: esriFieldTypeString )
• name ( nullable: true, editable: true, defaultValue: , length: 256, alias: Name, type: esriFieldTypeString )
• address ( nullable: true, editable: true, defaultValue: , length: 256, alias: Address, type: esriFieldTypeString )
• city ( nullable: true, editable: true, defaultValue: , length: 256, alias: City, type: esriFieldTypeString )
• state ( nullable: true, editable: true, defaultValue: , length: 256, alias: State, type: esriFieldTypeString )
• zip_code ( nullable: true, editable: true, defaultValue: , length: 256, alias: Zip_Code, type: esriFieldTypeString )
• year_built ( nullable: true, editable: true, defaultValue: , length: 256, alias: Year_Built, type: esriFieldTypeString )
• size__sf_units_ ( nullable: true, editable: true, defaultValue: 0, alias: Size__SF_Units_, type: esriFieldTypeInteger )
• actual_cap_rate ( nullable: true, editable: true, defaultValue: , length: 256, alias: Actual_Cap_Rate, type: esriFieldTypeString )
• sale_price ( nullable: true, editable: true, defaultValue: 0, alias: Sale_Price, type: esriFieldTypeInteger )
• price__psf_net___ppu_ ( nullable: true, editable: true, defaultValue: 0, alias: Price__PSF_Net___PPU_, type: esriFieldTypeDouble )
• submarket_cluster ( nullable: true, editable: true, defaultValue: , length: 256, alias: Submarket_Cluster, type: esriFieldTypeString )
• latitude ( nullable: true, editable: true, defaultValue: 0, alias: Latitude, type: esriFieldTypeDouble )
• longitude ( nullable: true, editable: true, defaultValue: 0, alias: Longitude, type: esriFieldTypeDouble )
• column17 ( nullable: true, editable: true, defaultValue: , length: 256, alias: Column17, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )

Types:

ID: Office
Name: Office
Domains:
Templates:
• Name: Office
  Description:
  Prototype:
  size__sf_units_: null
  address: null
  city: null
  latitude: null
  price__psf_net___ppu_: null
  column17: null
  comp_id: null
  sale_price: null
  type__class: null
  zip_code: null
  submarket_cluster: null
  product_type: Office
  sale_date: null
  name: null
  year_built: null
  state: null
  actual_cap_rate: null
  longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Industrial
Name: Industrial
Domains:
Templates:
• Name: Industrial
  Description:
  Prototype:
  size__sf_units_: null
  address: null
  city: null
  latitude: null
  price__psf_net___ppu_: null
  column17: null
  comp_id: null
  sale_price: null
  type__class: null
  zip_code: null
  submarket_cluster: null
  product_type: Industrial
  sale_date: null
  name: null
  year_built: null
  state: null
  actual_cap_rate: null
  longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Retail
Name: Retail
Domains:
Templates:
• Name: Retail
  Description:
  Prototype:
  size__sf_units_: null
  address: null
  city: null
  latitude: null
  price__psf_net___ppu_: null
  column17: null
  comp_id: null
  sale_price: null
  type__class: null
  zip_code: null
  submarket_cluster: null
  product_type: Retail
  sale_date: null
  name: null
  year_built: null
  state: null
  actual_cap_rate: null
  longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Land
Name: Land
Domains:
Templates:
• Name: Land
  Description:
  Prototype:
  size__sf_units_: null
  address: null
  city: null
  latitude: null
  price__psf_net___ppu_: null
  column17: null
  comp_id: null
  sale_price: null
  type__class: null
  zip_code: null
  submarket_cluster: null
  product_type: Land
  sale_date: null
  name: null
  year_built: null
  state: null
  actual_cap_rate: null
  longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Multifamily
Name: Multifamily
Domains:
Templates:
• Name: Multifamily
  Description:
  Prototype:
  size__sf_units_: null
  address: null
  city: null
  latitude: null
  price__psf_net___ppu_: null
  column17: null
  comp_id: null
  sale_price: null
  type__class: null
  zip_code: null
  submarket_cluster: null
  product_type: Multifamily
  sale_date: null
  name: null
  year_built: null
  state: null
  actual_cap_rate: null
  longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Multi-Family
Name: Multi-Family
Domains:
Templates:
• Name: Multi-Family
  Description:
  Prototype:
  size__sf_units_: null
  address: null
  city: null
  latitude: null
  price__psf_net___ppu_: null
  column17: null
  comp_id: null
  sale_price: null
  type__class: null
  zip_code: null
  submarket_cluster: null
  product_type: Multi-Family
  sale_date: null
  name: null
  year_built: null
  state: null
  actual_cap_rate: null
  longitude: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Hospitality
Name: Hospitality
Domains:
Templates:
• Name: Hospitality
  Description:
  Prototype:
  size__sf_units_: null
  address: null
  city: null
  latitude: null
  price__psf_net___ppu_: null
  column17: null
  comp_id: null
  sale_price: null
  type__class: null
  zip_code: null
  submarket_cluster: null
  product_type: Hospitality
  sale_date: null
  name: null
  year_built: null
  state: null
  actual_cap_rate: null
  longitude: 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