🔧 Pothole API Test

1. Database Connection Test

✅ Database connection successful!
✅ Table "potholes" exists
📊 Current pothole records in database: 925

Recent Records (Last 5):

Array
(
    [0] => Array
        (
            [id] => 1671
            [latitude] => 52.21489177
            [longitude] => 0.12166117
            [speed] => 6.14
            [direction] => 16.64
            [acceleration_x] => -8.576628
            [acceleration_y] => -9.087790
            [acceleration_z] => -8.870069
            [acceleration_magnitude] => 5.523988
            [threshold_used] => 5.000000
            [timestamp] => 2026-03-13 14:43:11
            [user_agent] => 
            [tripid] => 90
            [submitter] => 
        )

    [1] => Array
        (
            [id] => 1670
            [latitude] => 52.21462209
            [longitude] => 0.12242721
            [speed] => 27.18
            [direction] => 280.29
            [acceleration_x] => 1.095946
            [acceleration_y] => -3.229480
            [acceleration_z] => -16.525079
            [acceleration_magnitude] => 7.073318
            [threshold_used] => 5.000000
            [timestamp] => 2026-03-11 15:11:47
            [user_agent] => 
            [tripid] => 87
            [submitter] => 
        )

    [2] => Array
        (
            [id] => 1669
            [latitude] => 52.22089242
            [longitude] => 0.13438684
            [speed] => 37.75
            [direction] => 207.58
            [acceleration_x] => 3.053804
            [acceleration_y] => -7.659052
            [acceleration_z] => -16.144550
            [acceleration_magnitude] => 8.328246
            [threshold_used] => 5.000000
            [timestamp] => 2026-03-11 15:07:37
            [user_agent] => 
            [tripid] => 86
            [submitter] => 
        )

    [3] => Array
        (
            [id] => 1668
            [latitude] => 52.22890503
            [longitude] => 0.14755821
            [speed] => 39.40
            [direction] => 219.53
            [acceleration_x] => -1.582418
            [acceleration_y] => -1.648109
            [acceleration_z] => -19.146430
            [acceleration_magnitude] => 9.482274
            [threshold_used] => 5.000000
            [timestamp] => 2026-03-11 15:04:27
            [user_agent] => 
            [tripid] => 86
            [submitter] => 
        )

    [4] => Array
        (
            [id] => 1667
            [latitude] => 52.23046216
            [longitude] => 0.14957348
            [speed] => 44.81
            [direction] => 212.56
            [acceleration_x] => 0.787991
            [acceleration_y] => -6.353613
            [acceleration_z] => -13.774740
            [acceleration_magnitude] => 5.389891
            [threshold_used] => 5.000000
            [timestamp] => 2026-03-11 15:04:08
            [user_agent] => 
            [tripid] => 86
            [submitter] => 
        )

)

2. Quick Actions

📩 For data access, contact jono@footiefives.com.

View All Potholes View Recent 10 Open Dashboard Open Detection App