View In:   ArcGIS Online Map Viewer

Name: Retail_Transaction_XYTableToPoint

Display Field: property_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 2ea9c04035b1438db2ca835d1fdcfb9f

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 9.192969989999995
YMin: 45.46469103999999
XMax: 9.197819999999979
YMax: 45.46690000000001
Spatial Reference: 4326  (4326)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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: 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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )
• property_usage_type_desc ( modelName: property_usage_type_desc, nullable: true, editable: true, defaultValue: null, length: 8000, alias: PROPERTY_USAGE_TYPE_DESC, type: esriFieldTypeString )
• dim_property_building_skey ( modelName: dim_property_building_skey, nullable: true, editable: true, defaultValue: null, alias: DIM_PROPERTY_BUILDING_SKEY, type: esriFieldTypeInteger )
• dim_property_usage_skey ( modelName: dim_property_usage_skey, nullable: true, editable: true, defaultValue: null, alias: DIM_PROPERTY_USAGE_SKEY, type: esriFieldTypeInteger )
• dim_property_lease_skey ( modelName: dim_property_lease_skey, nullable: true, editable: true, defaultValue: null, alias: DIM_PROPERTY_LEASE_SKEY, type: esriFieldTypeInteger )
• miq_lease_id ( modelName: miq_lease_id, nullable: true, editable: true, defaultValue: null, alias: MIQ_LEASE_ID, type: esriFieldTypeInteger )
• miq_property_id ( modelName: miq_property_id, nullable: true, editable: true, defaultValue: null, alias: MIQ_PROPERTY_ID, type: esriFieldTypeInteger )
• latitude ( modelName: latitude, nullable: true, editable: true, defaultValue: null, alias: LATITUDE, type: esriFieldTypeDouble )
• longitude ( modelName: longitude, nullable: true, editable: true, defaultValue: null, alias: LONGITUDE, type: esriFieldTypeDouble )
• property_name ( modelName: property_name, nullable: true, editable: true, defaultValue: null, length: 8000, alias: PROPERTY_NAME, type: esriFieldTypeString )
• address_line1 ( modelName: address_line1, nullable: true, editable: true, defaultValue: null, length: 8000, alias: ADDRESS_LINE1, type: esriFieldTypeString )
• postal_code ( modelName: postal_code, nullable: true, editable: true, defaultValue: null, alias: POSTAL_CODE, type: esriFieldTypeInteger )
• city_name ( modelName: city_name, nullable: true, editable: true, defaultValue: null, length: 8000, alias: CITY_NAME, type: esriFieldTypeString )
• country_name ( modelName: country_name, nullable: true, editable: true, defaultValue: null, length: 8000, alias: COUNTRY_NAME, type: esriFieldTypeString )
• dim_arrangement_start_date_skey ( modelName: dim_arrangement_start_date_skey, nullable: true, editable: true, defaultValue: null, alias: DIM_ARRANGEMENT_START_DATE_SKEY, type: esriFieldTypeInteger )
• dim_arrangement_end_date_skey ( modelName: dim_arrangement_end_date_skey, nullable: true, editable: true, defaultValue: null, alias: DIM_ARRANGEMENT_END_DATE_SKEY, type: esriFieldTypeInteger )
• dim_country_skey ( modelName: dim_country_skey, nullable: true, editable: true, defaultValue: null, alias: DIM_COUNTRY_SKEY, type: esriFieldTypeInteger )
• property_market_skey ( modelName: property_market_skey, nullable: true, editable: true, defaultValue: null, alias: PROPERTY_MARKET_SKEY, type: esriFieldTypeInteger )
• property_market_desc ( modelName: property_market_desc, nullable: true, editable: true, defaultValue: null, length: 8000, alias: PROPERTY_MARKET_DESC, type: esriFieldTypeString )
• property_sub_market_skey ( modelName: property_sub_market_skey, nullable: true, editable: true, defaultValue: null, alias: PROPERTY_SUB_MARKET_SKEY, type: esriFieldTypeInteger )
• property_sub_market_desc ( modelName: property_sub_market_desc, nullable: true, editable: true, defaultValue: null, length: 8000, alias: PROPERTY_SUB_MARKET_DESC, type: esriFieldTypeString )
• total_leased_space ( modelName: total_leased_space, nullable: true, editable: true, defaultValue: null, alias: TOTAL_LEASED_SPACE, type: esriFieldTypeDouble )
• effective_rent_yearly ( modelName: effective_rent_yearly, nullable: true, editable: true, defaultValue: null, alias: EFFECTIVE_RENT_YEARLY, type: esriFieldTypeDouble )
• base_rent_yearly ( modelName: base_rent_yearly, nullable: true, editable: true, defaultValue: null, alias: BASE_RENT_YEARLY, type: esriFieldTypeDouble )
• lease_activity_type_desc ( modelName: lease_activity_type_desc, nullable: true, editable: true, defaultValue: null, length: 8000, alias: LEASE_ACTIVITY_TYPE_DESC, type: esriFieldTypeString )
• lease_arrangement_type_desc ( modelName: lease_arrangement_type_desc, nullable: true, editable: true, defaultValue: null, length: 8000, alias: LEASE_ARRANGEMENT_TYPE_DESC, type: esriFieldTypeString )
• tenant ( modelName: tenant, nullable: true, editable: true, defaultValue: null, length: 8000, alias: TENANT, type: esriFieldTypeString )
• brand ( modelName: brand, nullable: true, editable: true, defaultValue: null, length: 8000, alias: BRAND, type: esriFieldTypeString )
• tenant_industry ( modelName: tenant_industry, nullable: true, editable: true, defaultValue: null, length: 8000, alias: TENANT_INDUSTRY, type: esriFieldTypeString )
• landlord ( modelName: landlord, nullable: true, editable: true, defaultValue: null, length: 8000, alias: LANDLORD, type: esriFieldTypeString )
• categoria_merceologica ( modelName: categoria_merceologica, nullable: true, editable: true, defaultValue: null, length: 8000, alias: CATEGORIA_MERCEOLOGICA, type: esriFieldTypeString )

Templates:

• Name: Retail_Transaction_XYTableToPoint
  Description:
  Prototype:
  base_rent_yearly: null
  landlord: null
  latitude: null
  miq_property_id: null
  property_name: null
  lease_arrangement_type_desc: null
  dim_arrangement_end_date_skey: null
  city_name: null
  miq_lease_id: null
  address_line1: null
  country_name: null
  dim_arrangement_start_date_skey: null
  property_market_skey: null
  property_market_desc: null
  brand: null
  tenant_industry: null
  tenant: null
  longitude: null
  dim_property_building_skey: null
  property_sub_market_desc: null
  dim_property_usage_skey: null
  dim_property_lease_skey: null
  property_usage_type_desc: null
  property_sub_market_skey: null
  effective_rent_yearly: null
  lease_activity_type_desc: null
  categoria_merceologica: null
  dim_country_skey: null
  total_leased_space: null
  postal_code: null
  
  Drawing Tool: esriFeatureEditToolPoint

Capabilities: Query

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