search

cityofaustin / atd-data-tech

Austin Transportation Data & Technology Services
17 stars 2 forks source link

The `is_manual_geocode` column is not correct when CRIS values are null #19723

Closed johnclary closed 1 week ago

johnclary commented 1 week ago

The is_manual_geocode column is not correct when CRIS values are null.

E.g., see crash #16318132.

SELECT
    crash.latitude lat_crash,
    crash.longitude lon_crash,
    cris.latitude lat_cris,
    cris.longitude lon_cris,
    crash.is_manual_geocode
FROM
    crashes_list_view crash
    LEFT JOIN crashes_cris cris ON crash.id = cris.id
WHERE
    crash.cris_crash_id = 16318132;