Junction Analytics Tools

Junction Analytics Tools

Monitor traffic flow at intersections with real-time and historical data. These tools let you search your junction inventory, check live congestion metrics, and download historical archives for trend analysis.

• Documentation: Junction Analytics
• Uses TOMTOM_MOVE_PORTAL_KEY

tomtom-junction-search

Search and filter all junctions by name, status, country, or other properties.

Parameters

SQL Tables

junctions: Always available

approaches: Full view only

exits: Full view only

Example SQL Queries

1
-- Find junctions by name
2
SELECT junction_id, name, country_code FROM junctions WHERE name ILIKE '%highway%'
3

4
-- Count junctions by country
5
SELECT country_code, COUNT(*) as count FROM junctions GROUP BY country_code ORDER BY count DESC
6

7
-- Find junctions by road name (full view)
8
SELECT j.junction_id, j.name, a.road_name
9
FROM junctions j
10
JOIN approaches a ON j.junction_id = a.junction_id
11
WHERE a.road_name ILIKE '%Main%'

tomtom-junction-live-data

Access real-time traffic metrics for junctions, including delays, queue lengths, stops, turn ratios, and volume. Supports up to 20 junctions per request for cross-junction comparisons.

Parameters

SQL Tables

approaches: Real-time metrics per approach

turn_ratios: Turn distribution at junction

stops_histogram: Distribution of stop counts

junction_metadata, approach_metadata, exit_metadata: Available when includeGeometry is true. Contains the same columns as the junction search tables plus geometry data.

Example SQL Queries

1
-- Most delayed approaches
2
SELECT junction_id, approach_id, delay_sec, queue_length_meters
3
FROM approaches
4
ORDER BY delay_sec DESC
5
LIMIT 5
6

7
-- Turn ratios for a specific approach
8
SELECT exit_id, ratio_percent
9
FROM turn_ratios
10
WHERE approach_id = 1
11
ORDER BY ratio_percent DESC
12

13
-- Compare junctions by average delay
14
SELECT junction_id, ROUND(AVG(delay_sec), 2) as avg_delay
15
FROM approaches
16
GROUP BY junction_id
17
ORDER BY avg_delay DESC

tomtom-junction-archive

Download minute-by-minute historical traffic data for junctions over a date range (maximum 2 days). Supports up to 20 junctions per request.

Parameters

SQL Tables

approaches: Historical approach metrics with timestamps

turn_ratios: Historical turn ratios with timestamps

Example SQL Queries

1
-- Hourly average delays
2
SELECT date_part('hour', time::TIMESTAMP) as hour,
3
       ROUND(AVG(delay_sec), 2) as avg_delay,
4
       MAX(delay_sec) as max_delay
5
FROM approaches
6
GROUP BY hour
7
ORDER BY hour
8

9
-- Peak congestion periods
10
SELECT time::DATE as day,
11
       date_part('hour', time::TIMESTAMP) as hour,
12
       ROUND(AVG(delay_sec), 2) as avg_delay
13
FROM approaches
14
WHERE delay_sec > 30
15
GROUP BY day, hour
16
ORDER BY avg_delay DESC
17
LIMIT 10