Reference data
As only Orange and Los Angeles counties data should be loaded into the database, we need to map cities of California with their respective county, in order to filter only Orange and Los Angeles ones.
To do so, we will use a reference file, listing cities that are located in Orange and Los Angeles counties such as:
|
City |
County |
|
Agoura Hills |
Los Angeles |
|
Alhambra |
Los Angeles |
|
Aliso Viejo |
Orange |
|
Anaheim |
Orange |
|
Arcadia |
Los Angeles |
The reference file in this Job is named LosAngelesandOrangeCounties.txt.