View In:
ArcGIS Online Map Viewer
Name: SafegraphPlacesSpendSeptember
Display Field: location_name
Type: Feature Layer
Geometry Type: esriGeometryPoint
Description:
Copyright Text:
Default Visibility: true
MaxRecordCount: 1000
Supported Query Formats: JSON, geoJSON
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: false
Supports Datum Transformation: true
Extent:
XMin: 347385.54412196577
YMin: 1.0615726043368816E7
XMax: 478369.4835971296
YMax: 1.0725466991209313E7
Spatial Reference: 102739
(2277)
Drawing Info:
Renderer:
Simple Renderer:
Symbol: Style: esriSMSCircle
Color: [168, 0, 107, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
Label:
Description:
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
HasZ: false
HasM: false
Has Attachments: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Type ID Field:
Fields:
-
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID
)
-
placekey
(
type: esriFieldTypeString, alias: placekey, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: placekey
)
-
parent_placekey
(
type: esriFieldTypeString, alias: parent_placekey, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: parent_placekey
)
-
location_name
(
type: esriFieldTypeString, alias: location_name, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: location_name
)
-
safegraph_brand_ids
(
type: esriFieldTypeString, alias: safegraph_brand_ids, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: safegraph_brand_ids
)
-
brands
(
type: esriFieldTypeString, alias: brands, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: brands
)
-
top_category
(
type: esriFieldTypeString, alias: top_category, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: top_category
)
-
sub_category
(
type: esriFieldTypeString, alias: sub_category, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: sub_category
)
-
naics_code
(
type: esriFieldTypeInteger, alias: naics_code, editable: true, nullable: true, defaultValue: null, modelName: naics_code
)
-
latitude
(
type: esriFieldTypeDouble, alias: latitude, editable: true, nullable: true, defaultValue: null, modelName: latitude
)
-
longitude
(
type: esriFieldTypeDouble, alias: longitude, editable: true, nullable: true, defaultValue: null, modelName: longitude
)
-
street_address
(
type: esriFieldTypeString, alias: street_address, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: street_address
)
-
city
(
type: esriFieldTypeString, alias: city, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: city
)
-
region
(
type: esriFieldTypeString, alias: region, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: region
)
-
postal_code
(
type: esriFieldTypeInteger, alias: postal_code, editable: true, nullable: true, defaultValue: null, modelName: postal_code
)
-
iso_country_code
(
type: esriFieldTypeString, alias: iso_country_code, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: iso_country_code
)
-
phone_number
(
type: esriFieldTypeDouble, alias: phone_number, editable: true, nullable: true, defaultValue: null, modelName: phone_number
)
-
open_hours
(
type: esriFieldTypeString, alias: open_hours, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: open_hours
)
-
category_tags
(
type: esriFieldTypeString, alias: category_tags, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: category_tags
)
-
opened_on
(
type: esriFieldTypeString, alias: opened_on, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: opened_on
)
-
closed_on
(
type: esriFieldTypeString, alias: closed_on, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: closed_on
)
-
tracking_closed_since
(
type: esriFieldTypeString, alias: tracking_closed_since, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: tracking_closed_since
)
-
geometry_type
(
type: esriFieldTypeString, alias: geometry_type, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: geometry_type
)
-
OBJECTID_1
(
type: esriFieldTypeInteger, alias: OBJECTID, editable: true, nullable: true, defaultValue: null, modelName: OBJECTID_1
)
-
placekey_1
(
type: esriFieldTypeString, alias: placekey, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: placekey_1
)
-
safegraph_brand_ids_1
(
type: esriFieldTypeString, alias: safegraph_brand_ids, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: safegraph_brand_ids_1
)
-
brands_1
(
type: esriFieldTypeString, alias: brands, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: brands_1
)
-
spend_date_range_start
(
type: esriFieldTypeString, alias: spend_date_range_start, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: spend_date_range_start
)
-
spend_date_range_end
(
type: esriFieldTypeString, alias: spend_date_range_end, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: spend_date_range_end
)
-
raw_total_spend
(
type: esriFieldTypeDouble, alias: raw_total_spend, editable: true, nullable: true, defaultValue: null, modelName: raw_total_spend
)
-
raw_num_transactions
(
type: esriFieldTypeInteger, alias: raw_num_transactions, editable: true, nullable: true, defaultValue: null, modelName: raw_num_transactions
)
-
raw_num_customers
(
type: esriFieldTypeInteger, alias: raw_num_customers, editable: true, nullable: true, defaultValue: null, modelName: raw_num_customers
)
-
median_spend_per_transaction
(
type: esriFieldTypeDouble, alias: median_spend_per_transaction, editable: true, nullable: true, defaultValue: null, modelName: median_spend_per_transaction
)
-
median_spend_per_customer
(
type: esriFieldTypeDouble, alias: median_spend_per_customer, editable: true, nullable: true, defaultValue: null, modelName: median_spend_per_customer
)
-
spend_per_transaction_percentil
(
type: esriFieldTypeString, alias: spend_per_transaction_percentiles, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: spend_per_transaction_percentil
)
-
spend_by_day
(
type: esriFieldTypeString, alias: spend_by_day, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: spend_by_day
)
-
spend_per_transaction_by_day
(
type: esriFieldTypeString, alias: spend_per_transaction_by_day, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: spend_per_transaction_by_day
)
-
spend_by_day_of_week
(
type: esriFieldTypeString, alias: spend_by_day_of_week, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: spend_by_day_of_week
)
-
day_counts
(
type: esriFieldTypeString, alias: day_counts, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: day_counts
)
-
spend_pct_change_vs_prev_month
(
type: esriFieldTypeInteger, alias: spend_pct_change_vs_prev_month, editable: true, nullable: true, defaultValue: null, modelName: spend_pct_change_vs_prev_month
)
-
spend_pct_change_vs_prev_year
(
type: esriFieldTypeInteger, alias: spend_pct_change_vs_prev_year, editable: true, nullable: true, defaultValue: null, modelName: spend_pct_change_vs_prev_year
)
-
online_transactions
(
type: esriFieldTypeInteger, alias: online_transactions, editable: true, nullable: true, defaultValue: null, modelName: online_transactions
)
-
online_spend
(
type: esriFieldTypeDouble, alias: online_spend, editable: true, nullable: true, defaultValue: null, modelName: online_spend
)
-
transaction_intermediary
(
type: esriFieldTypeString, alias: transaction_intermediary, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: transaction_intermediary
)
-
spend_by_transaction_intermedia
(
type: esriFieldTypeString, alias: spend_by_transaction_intermediary, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: spend_by_transaction_intermedia
)
-
bucketed_customer_frequency
(
type: esriFieldTypeString, alias: bucketed_customer_frequency, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: bucketed_customer_frequency
)
-
mean_spend_per_customer_by_freq
(
type: esriFieldTypeString, alias: mean_spend_per_customer_by_frequency, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: mean_spend_per_customer_by_freq
)
-
bucketed_customer_incomes
(
type: esriFieldTypeString, alias: bucketed_customer_incomes, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: bucketed_customer_incomes
)
-
mean_spend_per_customer_by_inco
(
type: esriFieldTypeString, alias: mean_spend_per_customer_by_income, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: mean_spend_per_customer_by_inco
)
-
customer_home_city
(
type: esriFieldTypeString, alias: customer_home_city, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: customer_home_city
)
-
related_cross_shopping_physical
(
type: esriFieldTypeString, alias: related_cross_shopping_physical_brands_pct, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: related_cross_shopping_physical
)
-
related_cross_shopping_online_m
(
type: esriFieldTypeString, alias: related_cross_shopping_online_merchants_pct, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: related_cross_shopping_online_m
)
-
related_cross_shopping_same_cat
(
type: esriFieldTypeString, alias: related_cross_shopping_same_category_brands_pct, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: related_cross_shopping_same_cat
)
-
related_cross_shopping_local_br
(
type: esriFieldTypeString, alias: related_cross_shopping_local_brands_pct, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: related_cross_shopping_local_br
)
-
related_wireless_carrier_pct
(
type: esriFieldTypeString, alias: related_wireless_carrier_pct, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: related_wireless_carrier_pct
)
-
related_streaming_cable_pct
(
type: esriFieldTypeString, alias: related_streaming_cable_pct, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: related_streaming_cable_pct
)
-
related_delivery_service_pct
(
type: esriFieldTypeString, alias: related_delivery_service_pct, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: related_delivery_service_pct
)
-
related_rideshare_service_pct
(
type: esriFieldTypeString, alias: related_rideshare_service_pct, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: related_rideshare_service_pct
)
-
related_buynowpaylater_service_
(
type: esriFieldTypeString, alias: related_buynowpaylater_service_pct, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: related_buynowpaylater_service_
)
-
related_payment_platform_pct
(
type: esriFieldTypeString, alias: related_payment_platform_pct, editable: true, nullable: true, length: 1073741822, defaultValue: null, modelName: related_payment_platform_pct
)
Templates:
-
Name: SafegraphPlacesSpendSeptember
Description:
Prototype:
related_buynowpaylater_service_: null
related_payment_platform_pct: null
placekey: null
parent_placekey: null
location_name: null
safegraph_brand_ids: null
brands: null
top_category: null
sub_category: null
naics_code: null
latitude: null
longitude: null
street_address: null
city: null
region: null
postal_code: null
iso_country_code: null
phone_number: null
open_hours: null
category_tags: null
opened_on: null
closed_on: null
tracking_closed_since: null
geometry_type: null
OBJECTID_1: null
placekey_1: null
safegraph_brand_ids_1: null
brands_1: null
spend_date_range_start: null
spend_date_range_end: null
raw_total_spend: null
raw_num_transactions: null
raw_num_customers: null
median_spend_per_transaction: null
median_spend_per_customer: null
spend_per_transaction_percentil: null
spend_by_day: null
spend_per_transaction_by_day: null
spend_by_day_of_week: null
day_counts: null
spend_pct_change_vs_prev_month: null
spend_pct_change_vs_prev_year: null
online_transactions: null
online_spend: null
transaction_intermediary: null
spend_by_transaction_intermedia: null
bucketed_customer_frequency: null
mean_spend_per_customer_by_freq: null
bucketed_customer_incomes: null
mean_spend_per_customer_by_inco: null
customer_home_city: null
related_cross_shopping_physical: null
related_cross_shopping_online_m: null
related_cross_shopping_same_cat: null
related_cross_shopping_local_br: null
related_wireless_carrier_pct: null
related_streaming_cable_pct: null
related_delivery_service_pct: null
related_rideshare_service_pct: null
Drawing Tool: esriFeatureEditToolPoint
Capabilities: Query
Sync Can Return Changes: false
Is Data Versioned: true
Supports Rollback On Failure: false
Supports ApplyEdits With Global Ids: false
Supports Query With Historic Moment: false
Supports Coordinates Quantization: true
Supported Operations:
Query
Query Attachments
Validate SQL
Generate Renderer
Return Updates
Iteminfo
Thumbnail
Metadata