mapbox / mapboxgl-powerbi

Mapbox Visual for Power BI - High performance, custom map visuals for Power BI dashboards. This version of Mapbox Visual for Microsoft Power BI is no longer maintained. You can find the live and maintained version of the plugin at: https://github.com/starschema/mapboxgl-powerbi.
MIT License
127 stars 52 forks source link

Surface up traffic data as a data series + provide historical values? #72

Closed otravers closed 1 year ago

otravers commented 6 years ago

Not sure Mapbox sees itself as a data provider, but since you have traffic data to put on your maps, maybe this could be delivered as a data feed for Power BI (and its ilk) to tap?

My understanding is that you're displaying real time congestion, with 4 levels of congestion value: https://www.mapbox.com/vector-tiles/mapbox-traffic-v1/#overview

First, it would be valuable to have an ability to analyze/map that type of data over time to see trends through the day and week, as well as seasonality over the year. That would make much more sense in the context of a BI app, while real time data is more useful to a navigation app (which I'm guessing is the original use case for your traffic layer). TomTom markets something like this, possibly ESRI too.

Second, I'm not sure how the congestion values are computed, but actual vehicle count data over time would be valuable for purposes such as retail location analysis or urban planning.

ryanbaumann commented 6 years ago

Great feature request, @otravers.

My understanding is that you're displaying real time congestion, with 4 levels of congestion value: https://www.mapbox.com/vector-tiles/mapbox-traffic-v1/#overview

Correct, real-time traffic values are served as vectors to the client in 4 levels of congestion buckets.

I'd classify this as a feature request - ability to query values from layers in a vector tileset in a map style, and compare the queried data to your visualization data in Power BI. This feature would work for traffic, and also for any other data layer you have in a Mapbox or Custom style used in Power BI.

We could add things like a buffer filter, to say highlight all points in my Power BI dataset within 500m of a high congestion traffic area. What functionality would be most important to you @otravers if you had access to the vector data geometry and properties in Power BI?

First, it would be valuable to have an ability to analyze/map that type of data over time to see trends through the day and week, as well as seasonality over the year.

Historical traffic ETA functionality is on our roadmap. Would the most useful reference be a visual representation of the traffic at a time of day, or access to specific trip ETAs at a time of day? Check out some of our blog posts for ideas. cc @mtirwin

Second, I'm not sure how the congestion values are computed, but actual vehicle count data over time would be valuable for purposes such as retail location analysis or urban planning.

Agree re: utility for retail and urban planning. Car counts aren't something that's on our near term roadmap, but you could add any traffic data and use it in a custom map style in Power BI by uploading it to your Mapbox account.

otravers commented 6 years ago

Ability to query values from layers in a vector tileset in a map style, and compare the queried data to your visualization data in Power BI. This feature would work for traffic, and also for any other data layer you have in a Mapbox or Custom style used in Power BI

Oh, I see what you're saying, nice abstraction of my feature request! If I understand you correctly, Mapbox data layers would become a pass-through vehicle for data to flow from Mapbox Studio to PBI. But would it work through Get Data so that we can apply Power Query ETL and DAX logic on top of that data?

Would the most useful reference be a visual representation of the traffic at a time of day, or access to specific trip ETAs at a time of day

I guess both! I like your Minneapolis blog post, I would put something like this next to the map to cross-filter back and forth between the map and heatmap table/histograms:

image

you could add any traffic data and use it in a custom map style in Power BI by uploading it to your Mapbox account.

Riiiight, again you're making the data flow through Mapbox first, I have to wrap my head around that workflow as opposed to load everything directly in the PBI data model, which is my Pavlovian approach. In my head, Mapbox = styled tilesets, but then there's also: https://www.mapbox.com/help/define-dataset/

For the record and for comparison purposes, ESRI has 2017 USA traffic count in their Living Atlas available in their PBI visual, based on Kalibrate's TrafficMetrix. However the user experience is poor, as far as I can see it's just a collection of tiny dots that you're supposed to hover over: image

Looks like one of several examples where you only get a subset of the full-fledged ArcGIS experience in PBI, which is frustrating (underlying message: don't do this with your own PBI visual!). Here's the web version, which requires a separate subscription: http://www.arcgis.com/home/item.html?id=07bf63e8238b44e7ba44cdcadcc5a8c2

There's a number of local governments that publish open traffic data, of course one always dreams of finding a global open data repository of everything...

otravers commented 5 years ago

Keeping this up to date for reference:

  1. Mapbox live traffic coverage has been expanding to more countries (with varying degrees of accuracy): https://blog.mapbox.com/traffic-everywhere-5108cb81b403

  2. Mapbox now has an enterprise data series for traffic with "Estimated speeds throughout the week based on historical observations.": https://www.mapbox.com/traffic-data/