![[logo] US EPA](http://www.epa.gov/epafiles/images/logo_epaseal.gif){kind=logo}
Load LRT_BEST_COORDINATE
- For each registry_id of FRS_FACILITY_SITE, obtain the best locational data, best name and address data, and overlapping state-county FIPS code, CATUNIT and postal code.
- Identify all Program ID's from FRS_INTEREST for the registry_id. For each program ID, identify a record from LRT where preferred_flag is 'Y' and add it to a temporary group. Apply the Pick Best Process to the temporary group. Obtain lrt_loc_ref_id, pgm_sys_acrnm, pgm_sys_id, latitude, longitude, geometry, conveyor from LRT for the record returned through the Pick Best Process.
- Obtain primary_name, location_address, city_name, county_name, state_code, postal_code for the registry_id where priority is '0001'. Priority value of '0001' indicates the name and address data is recommended.
- Obtain the state-county FIPS code, CATUNIT and postal code based on spatial relationships to the points value.
- Insert into LRT_BEST_COORDINATE values for registry_id, lrt_loc_ref_id, pgm_sys_acrnm, pgm_sys_id, latitude, longitude, points, conveyor, primary_name, location_address, city_name, county_name, state_code, postal_code, derived_fips_code, derived_catunit, derived_postal_code.