Ensure Federal agencies are only linked to the US National Location

[maxachis]

Currently, we have three agencies whose jurisdiction is listed as "Federal" but which also have more than a location link to the US' national location

select
    ag.name,
    array_agg(link.location_id) as locations
from agencies ag
inner join link_agencies__locations link on ag.id = link.agency_id
where ag.jurisdiction_type = 'federal'
group by ag.id
having array_agg(link.location_id) != '{16056}' -- This is the national US ID

These agencies are:

• 'Transportation Security Administration' - has the state of Oregon (location 40)
• 'Federal Protective Service (FPS)' - has the District of Columbia (State) (location 10)
• 'Federal Bureau of Investigation (FBI)' - has the District of Columbia (locality) (location 14469)

We must do two things!

1. Update the Integrity Monitor to check for any Federal Agencies linked to anything that aren't the National Location
2. Resolve these bad boys

[josh-chamberlain]

@maxachis easy! If it's a federal agency, it should only be linked to the US' national location.