Thread: Highway Traffic Lights UX With Data

Creating the traffic light data file is quite time consuming, there are probably better ways to do it but I haven't had the time to find out.

For those who would like to do it themselves so i don't have to , here is my method.

This method could also be used for creating other alerts or POI's using data from Open Street Map by changing the 'query'



Create your own traffic light data from Open Street Map.
********************************************************

Spoiler: Required

1/ Overpass Turbo (website) [Only registered and activated users can see links. ]

2/ KML Merger (website) [Only registered and activated users can see links. ]

3/ ITN Converter (software) [Only registered and activated users can see links. ]

4/ Microsoft Excel (software)

Spoiler: Overpass Turbo

Overpass Turbo can not extract a whole country in one go so ,with the help of Wikipedia, you will need to break down the Country in to administrative divisions, States or districts.

Watch out for areas that have the same name as the capital city.
A further search for the area names around the city will be needed to get all the data for that area.



1/ open overpass turbo

2/ Replace all the code in the left hand panel with this code below

Code:

Please Login or Register to see the links

3/ In the code, replace all the words in capitals (REPLACE THIS TEXT WITH THE AREA NAME) with the area name & run. when complete, export the data as a kml file

Spoiler: kml Merger

1/ upload kml files

2/ download merged kml file

Spoiler: ITN Converter

1/ open merged kml file, be patient as it can take a while to load.

2/ export as CSV(*csv)

2a/ settings , latitude column 02, longitude column 01. nothing else is required.

Spoiler: Microsoft Excel

1/ open csv file

2/ add category 30, type 30 in the first box of column C, 'click & hold' the bottom right hand corner of the box (see picture 1).
drag the box down unil you reach the last line of the coordinates, then release your mouse button. The column should then be '30' all the way down. (see picture 2)

3/ repeat the procedure for column D,E & F, using 0

4/ rename line 1 to read X,Y,TYPE,SPEED,DIRTYPE,DIRECTION (see picture 3)

5/ save file as csv.

[Only registered and activated users can see links. ] [Only registered and activated users can see links. ]

Spoiler: On computer

1/ Find the folder where you saved your csv file, make sure you have filename extensions 'ticked' in folder view .


2/ Rename the extension from .csv to .txt, (ignore warnings).

Job done