nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Creating Speed Profile and daily profile table using HERE Traffic Pattern

AbhishekPandey

Hi,

I am using HERE Traffic Pattern and navstreet data to create a Historical traffic data and network for my analysis, but as mentioned in this guide: Historical traffic—ArcMap | Documentation (arcgis.com) under "How Network Analyst models historical traffic" my daily profile data is not in scale factor and hence I am getting a total green (freeflow) traffic map which is incorrect.

I have the Freeflow Speed (from Navstreet Feature class) and Travel Speed (HERE Traffic Pattern) for given links.

Now my question is How can I convert my daily profile to scale factors or do I need to create a new table? If so How can I do that?

I Have attached Screenshot of my Street Profile, Daily Profile and Spatial Join of navstreet-Street profile for better understanding

Any Help or guidance is appreciated

street profile (HERE Traffic)

Daily profile

StreetProfile_Navstreet Spatial Joined (as used in fgdb)

Thanks,

Abhishek

Find more posts tagged with

Accepted answers

AbhishekPandey

After weeks of searching, I finally settled with Pandas. In order to create the above-mentioned tables, I created inner joins, divided the values by actual speed to get speed-factor, and extracted new values in a different table with only unique values. Finally, I re-populated the existing table (pandas inner join) with the index of the newly created table.

All comments

yenealemaderaw

i have historical traffic data for 5 month form Monday(0time to 1O',1-2,2-3,3-4,4-5,5-6,.....14-15 Each have their own speed factor, Tuesday,..….. ))have to Sunday and it have speed factor to for each day and so how can i rearrange the daily profile table from speedFactor_0000 to SpeedFactor_2300 and how can i copy the data to each attribute or is there any mechanism to generate tables easily. pls pls answer me if you know exactly and steeps too

yenealemaderaw

hello sir i am trying to create daily and street dayilee profile i have the historical speed data and i alrady spatial join to the street feature but in order to incorporate the traffic table those tables are required but. i am confused the steeps to create both tables.

1.for example i have 5 month speed factor data from Monday to Sunday (speed factor) i have it , but how can it arrang it in daily profile from Speed Factor_0000 to SpeedFactor_2300

2. and how to arrange and create street tables too pls show steps clearly

AbhishekPandey

AlanHatakeyama

Hi Abhishek,

Yes, you do need to create a new table that has these scale factor values. You will need to determine what is the maximum speed for each PATTERN_ID and then divide each speed in that PATTERN_ID row by that maximum. Given that this table starts off as a .csv file, you can probably most easily do this in Microsoft Excel with function calculations within the cells, and then re-saving the result back to a .csv file before importing it into your geodatabase to include in the network dataset.

Note that each street references up to seven different PATTERN_ID values (one for each day of the week), so it may be possible that the maximum speed for each PATTERN_ID may not be the same. You'll need to choose which daily maximum speed to use for your Freeflow Speed for that street -- maybe you take the most common maximum, or maybe you average the seven speeds, etc. Usually when these maximum speeds are different, they only differ by ±1km/h, so the shift in travel time would be negligible -- especially since the original data seems to already be rounded to the nearest whole km/h anyway.

Please let me know if you have any further questions. Thanks!

Alan

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.