=== Geocode Ingest Summary ===
Total unique coords in drps_events : 6781
Geocoded (in du_locations)         : 153
Not yet geocoded                   : 6628
Missing road name                  : 2
Missing postal code                : 0
Unique streets stored              : 227
Unique cities stored               : 8
Unique neighbourhoods stored       : 33

=== Last 20 Geocoded Locations ===
Array
(
    [0] => Array
        (
            [id] => 153
            [lat] => 43.9218500
            [lng] => -78.9366000
            [postal_fsa] => L1R
            [postal_ldu] => 2K5
            [geocoded_at] => 2026-04-12 15:52:31
            [road] => Fawcett Avenue
            [neighbourhood] => 
            [city] => Whitby
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [1] => Array
        (
            [id] => 152
            [lat] => 43.9181096
            [lng] => -78.9453423
            [postal_fsa] => L1R
            [postal_ldu] => 3A4
            [geocoded_at] => 2026-04-12 15:52:25
            [road] => Taunton Road East
            [neighbourhood] => 
            [city] => Whitby
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [2] => Array
        (
            [id] => 151
            [lat] => 43.8140069
            [lng] => -79.0996599
            [postal_fsa] => L1W
            [postal_ldu] => 2H7
            [geocoded_at] => 2026-04-12 15:52:19
            [road] => Oklahoma Drive
            [neighbourhood] => Fairport Beach
            [city] => Pickering
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [3] => Array
        (
            [id] => 150
            [lat] => 43.8892349
            [lng] => -78.8597725
            [postal_fsa] => L1H
            [postal_ldu] => 4H5
            [geocoded_at] => 2026-04-12 15:52:12
            [road] => Fairbanks Street
            [neighbourhood] => Central
            [city] => Oshawa
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [4] => Array
        (
            [id] => 149
            [lat] => 43.9709203
            [lng] => -79.2200381
            [postal_fsa] => L4A
            [postal_ldu] => 0V5
            [geocoded_at] => 2026-04-12 15:52:09
            [road] => Uxbridge-Pickering Townline Road
            [neighbourhood] => 
            [city] => Pickering
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [5] => Array
        (
            [id] => 148
            [lat] => 43.8994653
            [lng] => -78.8834045
            [postal_fsa] => L1J
            [postal_ldu] => 5J3
            [geocoded_at] => 2026-04-12 15:52:02
            [road] => Adelaide Avenue West
            [neighbourhood] => McLaughlin
            [city] => Oshawa
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [6] => Array
        (
            [id] => 147
            [lat] => 43.8234162
            [lng] => -79.0106201
            [postal_fsa] => L1S
            [postal_ldu] => 1B4
            [geocoded_at] => 2026-04-12 15:51:56
            [road] => McRae Road
            [neighbourhood] => Clover Ridge
            [city] => Ajax
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [7] => Array
        (
            [id] => 146
            [lat] => 43.9062492
            [lng] => -78.8574374
            [postal_fsa] => L1G
            [postal_ldu] => 1Z7
            [geocoded_at] => 2026-04-12 15:51:52
            [road] => Adelaide Avenue East
            [neighbourhood] => O'Neill
            [city] => Oshawa
            [county] => Durham Region
            [state_district] => Golden Horseshoe
            [state] => Ontario
        )

    [8] => 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
        )

    [9] => 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
        )

    [10] => 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
        )

    [11] => 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
        )

    [12] => 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
        )

    [13] => 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
        )

    [14] => 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
        )

    [15] => 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
        )

    [16] => 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
        )

    [17] => 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
        )

    [18] => 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
        )

    [19] => 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
        )

)
[1] id=153 geocoded=2026-04-12 15:52:31 coords : 43.9218500, -78.9366000 road : Fawcett Avenue cross strs : none neighbourhood: n/a city : Whitby county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1R 2K5 events at coord: 1 [2] id=152 geocoded=2026-04-12 15:52:25 coords : 43.9181096, -78.9453423 road : Taunton Road East cross strs : none neighbourhood: n/a city : Whitby county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1R 3A4 events at coord: 1 [3] id=151 geocoded=2026-04-12 15:52:19 coords : 43.8140069, -79.0996599 road : Oklahoma Drive cross strs : (1) Oklahoma Drive, (2) Yeremi Street, (3) Leaside Street, (4) Mink Street, (5) Chipmunk Street neighbourhood: Fairport Beach city : Pickering county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1W 2H7 events at coord: 1 [4] id=150 geocoded=2026-04-12 15:52:12 coords : 43.8892349, -78.8597725 road : Fairbanks Street cross strs : (1) Fairbanks Street, (2) Royal Street, (3) Celina Street, (4) Maple Street, (5) Simcoe Street South, (6) Olive Avenue, (7) Quebec Street, (8) Gibb Street neighbourhood: Central city : Oshawa county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1H 4H5 events at coord: 1 [5] id=149 geocoded=2026-04-12 15:52:09 coords : 43.9709203, -79.2200381 road : Uxbridge-Pickering Townline Road cross strs : none neighbourhood: n/a city : Pickering county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L4A 0V5 events at coord: 1 [6] id=148 geocoded=2026-04-12 15:52:02 coords : 43.8994653, -78.8834045 road : Adelaide Avenue West cross strs : none neighbourhood: McLaughlin city : Oshawa county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1J 5J3 events at coord: 1 [7] id=147 geocoded=2026-04-12 15:51:56 coords : 43.8234162, -79.0106201 road : McRae Road cross strs : (1) McRae Road, (2) Lake Driveway East, (3) Cowling Crescent, (4) Andrea Road, (5) Ajax Waterfront Field Trail neighbourhood: Clover Ridge city : Ajax county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1S 1B4 events at coord: 1 [8] id=146 geocoded=2026-04-12 15:51:52 coords : 43.9062492, -78.8574374 road : Adelaide Avenue East cross strs : none neighbourhood: O'Neill city : Oshawa county : Durham Region state_district : Golden Horseshoe state : Ontario postal : L1G 1Z7 events at coord: 1 [9] 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 [10] 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 [11] 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 [12] 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 [13] 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 [14] 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 [15] 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 [16] 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 [17] 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 [18] 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 [19] 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 [20] 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 === Spot Checks === drps_events with intersection='unknown' : 20 drps_events with a label : 1099 drps_events still NULL : 17993