=== Geocode Ingest Summary ===
Total unique coords in drps_events : 6781
Geocoded (in du_locations)         : 145
Not yet geocoded                   : 6636
Missing road name                  : 2
Missing postal code                : 0
Unique streets stored              : 210
Unique cities stored               : 8
Unique neighbourhoods stored       : 31

=== Last 20 Geocoded Locations ===
Array
(
    [0] => Array
        (
            [id] => 145
            [lat] => 43.8972121
            [lng] => -78.8947937
            [postal_fsa] => L1J
            [postal_ldu] => 2W3
            [geocoded_at] => 2026-04-12 15:51:42
            [road] => Adelaide Avenue West
            [neighbourhood] => Thornton Woods
            [city] => Oshawa
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [1] => Array
        (
            [id] => 144
            [lat] => 43.9310156
            [lng] => -78.4560961
            [postal_fsa] => L1A
            [postal_ldu] => 3V7
            [geocoded_at] => 2026-04-12 15:51:35
            [road] => Concession Road 1
            [neighbourhood] => 
            [city] => Clarington
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [2] => Array
        (
            [id] => 143
            [lat] => 43.9270500
            [lng] => -78.9235700
            [postal_fsa] => L1R
            [postal_ldu] => 2X0
            [geocoded_at] => 2026-04-12 15:51:27
            [road] => Pebblebrook Crescent
            [neighbourhood] => 
            [city] => Whitby
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [3] => Array
        (
            [id] => 142
            [lat] => 43.8927230
            [lng] => -78.9209064
            [postal_fsa] => L1N
            [postal_ldu] => 3S4
            [geocoded_at] => 2026-04-12 15:51:19
            [road] => Leslie Street
            [neighbourhood] => 
            [city] => Whitby
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [4] => Array
        (
            [id] => 141
            [lat] => 43.8659708
            [lng] => -79.0622376
            [postal_fsa] => L1T
            [postal_ldu] => 4N1
            [geocoded_at] => 2026-04-12 15:51:14
            [road] => Horne Avenue
            [neighbourhood] => Riverside
            [city] => Ajax
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [5] => Array
        (
            [id] => 140
            [lat] => 43.9018592
            [lng] => -78.7031353
            [postal_fsa] => L1C
            [postal_ldu] => 4Y8
            [geocoded_at] => 2026-04-12 15:51:07
            [road] => Bonnycastle Drive
            [neighbourhood] => 
            [city] => Clarington
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [6] => Array
        (
            [id] => 139
            [lat] => 43.8567700
            [lng] => -79.0346477
            [postal_fsa] => L1S
            [postal_ldu] => 6S5
            [geocoded_at] => 2026-04-12 15:51:01
            [road] => Ritchie Avenue
            [neighbourhood] => Midtown
            [city] => Ajax
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [7] => Array
        (
            [id] => 138
            [lat] => 43.8885273
            [lng] => -78.8264411
            [postal_fsa] => L1H
            [postal_ldu] => 8S1
            [geocoded_at] => 2026-04-12 15:50:54
            [road] => Bloor Street East
            [neighbourhood] => Donevan
            [city] => Oshawa
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [8] => Array
        (
            [id] => 137
            [lat] => 43.9401419
            [lng] => -78.8389356
            [postal_fsa] => L1K
            [postal_ldu] => 0G1
            [geocoded_at] => 2026-04-12 15:50:42
            [road] => Grandview Street North
            [neighbourhood] => Pinecrest
            [city] => Oshawa
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [9] => Array
        (
            [id] => 136
            [lat] => 43.9420039
            [lng] => -78.8519856
            [postal_fsa] => L1K
            [postal_ldu] => 7K0
            [geocoded_at] => 2026-04-12 15:50:36
            [road] => Missom Gate
            [neighbourhood] => Taunton
            [city] => Oshawa
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [10] => Array
        (
            [id] => 135
            [lat] => 43.9057813
            [lng] => -78.7090588
            [postal_fsa] => L1C
            [postal_ldu] => 5A4
            [geocoded_at] => 2026-04-12 15:50:30
            [road] => King George Way
            [neighbourhood] => 
            [city] => Clarington
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [11] => Array
        (
            [id] => 134
            [lat] => 43.8945062
            [lng] => -78.9299012
            [postal_fsa] => L1N
            [postal_ldu] => 8M1
            [geocoded_at] => 2026-04-12 15:50:26
            [road] => Manning Road
            [neighbourhood] => 
            [city] => Whitby
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [12] => Array
        (
            [id] => 133
            [lat] => 43.8351819
            [lng] => -79.0903365
            [postal_fsa] => L1V
            [postal_ldu] => 1W2
            [geocoded_at] => 2026-04-12 15:50:21
            [road] => Liverpool Road
            [neighbourhood] => Liverpool
            [city] => Pickering
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [13] => Array
        (
            [id] => 132
            [lat] => 43.8568809
            [lng] => -78.8612689
            [postal_fsa] => L1J
            [postal_ldu] => 3W6
            [geocoded_at] => 2026-04-12 15:50:13
            [road] => Renaissance Drive
            [neighbourhood] => Lakeview
            [city] => Oshawa
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [14] => Array
        (
            [id] => 131
            [lat] => 43.8730741
            [lng] => -78.8556744
            [postal_fsa] => L1J
            [postal_ldu] => 3T9
            [geocoded_at] => 2026-04-12 15:50:07
            [road] => Medina Court
            [neighbourhood] => Lakeview
            [city] => Oshawa
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [15] => Array
        (
            [id] => 130
            [lat] => 43.9362706
            [lng] => -78.8639454
            [postal_fsa] => L1G
            [postal_ldu] => 3V2
            [geocoded_at] => 2026-04-12 15:49:58
            [road] => Taunton Road East
            [neighbourhood] => Centennial
            [city] => Oshawa
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [16] => Array
        (
            [id] => 129
            [lat] => 43.8616827
            [lng] => -79.0167241
            [postal_fsa] => L1S
            [postal_ldu] => 5E3
            [geocoded_at] => 2026-04-12 15:49:52
            [road] => Torr Lane
            [neighbourhood] => Midtown
            [city] => Ajax
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [17] => Array
        (
            [id] => 128
            [lat] => 43.9371919
            [lng] => -78.8599511
            [postal_fsa] => L1K
            [postal_ldu] => 2B8
            [geocoded_at] => 2026-04-12 15:49:40
            [road] => Taunton Road East
            [neighbourhood] => Centennial
            [city] => Oshawa
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [18] => Array
        (
            [id] => 127
            [lat] => 43.9132414
            [lng] => -78.8347177
            [postal_fsa] => L1K
            [postal_ldu] => 1K9
            [geocoded_at] => 2026-04-12 15:49:33
            [road] => Adelaide Avenue East
            [neighbourhood] => Eastdale
            [city] => Oshawa
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [19] => Array
        (
            [id] => 126
            [lat] => 43.8146661
            [lng] => -79.1392162
            [postal_fsa] => L1V
            [postal_ldu] => 1E3
            [geocoded_at] => 2026-04-12 15:49:27
            [road] => Hoover Drive
            [neighbourhood] => 
            [city] => Pickering
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

)
[1] id=145 geocoded=2026-04-12 15:51:42 coords : 43.8972121, -78.8947937 road : Adelaide Avenue West cross strs : none neighbourhood: Thornton Woods city : Oshawa county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1J 2W3 events at coord: 1 [2] id=144 geocoded=2026-04-12 15:51:35 coords : 43.9310156, -78.4560961 road : Concession Road 1 cross strs : none neighbourhood: n/a city : Clarington county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1A 3V7 events at coord: 1 [3] id=143 geocoded=2026-04-12 15:51:27 coords : 43.9270500, -78.9235700 road : Pebblebrook Crescent cross strs : none neighbourhood: n/a city : Whitby county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1R 2X0 events at coord: 1 [4] id=142 geocoded=2026-04-12 15:51:19 coords : 43.8927230, -78.9209064 road : Leslie Street cross strs : none neighbourhood: n/a city : Whitby county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1N 3S4 events at coord: 1 [5] id=141 geocoded=2026-04-12 15:51:14 coords : 43.8659708, -79.0622376 road : Horne Avenue cross strs : none neighbourhood: Riverside city : Ajax county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1T 4N1 events at coord: 1 [6] id=140 geocoded=2026-04-12 15:51:07 coords : 43.9018592, -78.7031353 road : Bonnycastle Drive cross strs : (1) Brodie Court, (2) Landerville Lane, (3) Bonnycastle Drive, (4) Pennington Place, (5) Vail Meadows Crescent neighbourhood: n/a city : Clarington county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1C 4Y8 events at coord: 1 [7] id=139 geocoded=2026-04-12 15:51:01 coords : 43.8567700, -79.0346477 road : Ritchie Avenue cross strs : none neighbourhood: Midtown city : Ajax county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1S 6S5 events at coord: 1 [8] id=138 geocoded=2026-04-12 15:50:54 coords : 43.8885273, -78.8264411 road : Bloor Street East cross strs : none neighbourhood: Donevan city : Oshawa county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1H 8S1 events at coord: 1 [9] id=137 geocoded=2026-04-12 15:50:42 coords : 43.9401419, -78.8389356 road : Grandview Street North cross strs : none neighbourhood: Pinecrest city : Oshawa county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1K 0G1 events at coord: 1 [10] id=136 geocoded=2026-04-12 15:50:36 coords : 43.9420039, -78.8519856 road : Missom Gate cross strs : none neighbourhood: Taunton city : Oshawa county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1K 7K0 events at coord: 1 [11] id=135 geocoded=2026-04-12 15:50:30 coords : 43.9057813, -78.7090588 road : King George Way cross strs : (1) Prince William Boulevard, (2) Clarington Boulevard, (3) Green Road, (4) Boswell Drive, (5) King George Way, (6) Queen Alexandra Lane, (7) Lord Elgin Lane, (8) King William Way neighbourhood: n/a city : Clarington county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1C 5A4 events at coord: 1 [12] id=134 geocoded=2026-04-12 15:50:26 coords : 43.8945062, -78.9299012 road : Manning Road cross strs : none neighbourhood: n/a city : Whitby county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1N 8M1 events at coord: 1 [13] id=133 geocoded=2026-04-12 15:50:21 coords : 43.8351819, -79.0903365 road : Liverpool Road cross strs : none neighbourhood: Liverpool city : Pickering county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1V 1W2 events at coord: 1 [14] id=132 geocoded=2026-04-12 15:50:13 coords : 43.8568809, -78.8612689 road : Renaissance Drive cross strs : none neighbourhood: Lakeview city : Oshawa county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1J 3W6 events at coord: 1 [15] id=131 geocoded=2026-04-12 15:50:07 coords : 43.8730741, -78.8556744 road : Medina Court cross strs : none neighbourhood: Lakeview city : Oshawa county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1J 3T9 events at coord: 31 [16] id=130 geocoded=2026-04-12 15:49:58 coords : 43.9362706, -78.8639454 road : Taunton Road East cross strs : none neighbourhood: Centennial city : Oshawa county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1G 3V2 events at coord: 13 [17] id=129 geocoded=2026-04-12 15:49:52 coords : 43.8616827, -79.0167241 road : Torr Lane cross strs : none neighbourhood: Midtown city : Ajax county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1S 5E3 events at coord: 8 [18] id=128 geocoded=2026-04-12 15:49:40 coords : 43.9371919, -78.8599511 road : Taunton Road East cross strs : none neighbourhood: Centennial city : Oshawa county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1K 2B8 events at coord: 3 [19] id=127 geocoded=2026-04-12 15:49:33 coords : 43.9132414, -78.8347177 road : Adelaide Avenue East cross strs : none neighbourhood: Eastdale city : Oshawa county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1K 1K9 events at coord: 14 [20] id=126 geocoded=2026-04-12 15:49:27 coords : 43.8146661, -79.1392162 road : Hoover Drive cross strs : none neighbourhood: n/a city : Pickering county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1V 1E3 events at coord: 1 === Spot Checks === drps_events with intersection='unknown' : 20 drps_events with a label : 1091 drps_events still NULL : 18001