Hi all! I have a CSV file with state-county (California) FIPS codes (two digits). Can ArcGIS Pro populate or recognize state codes? If yes can someone walk me through how to populate data with my specifications? Thank you all so much.
Solved! Go to Solution.
If I open your table in a map in ArcGIS Pro, and then right click the table and click Geocode. The only Locator I can select is the ArcGIS World Geocoding Service. Which doesn't have an option for FIPS codes. Do you have any other locators to choose from? If not you would then have to create your own locator, which isn't all that difficult. Plus if you are using your own locator there are no credit costs involved. (Just noticing that your FIPS above for Alpine county should be 03 - FIPS are odd numbers for counties).
Here is a posting to help create your own locator. https://pro.arcgis.com/en/pro-app/latest/help/data/geocoding/fundamentals-of-creating-a-locator.htm
county | agecat | rate | er1719 | pop1719 | county code |
Alameda | 1-2 years | 277.1 | 343 | 123793.9 | 01 |
Alameda | 10-13 years | 138.7 | 323 | 232862.8 | 01 |
Alameda | 14-17 years | 183.5 | 423 | 230547.5 | 01 |
Alameda | 18-34 years | 559.5 | 6149 | 1099101 | 01 |
Alameda | 3-5 years | 293.9 | 541 | 184077.8 | 01 |
Alameda | 35-64 years | 366.6 | 7172 | 1956263 | 01 |
Alameda | 6-9 years | 268.9 | 620 | 230542.2 | 01 |
Alameda | 65-100 years | 211.7 | 1442 | 681063.4 | 01 |
Alameda | <1 year | 183.4 | 114 | 62147.6 | 01 |
Alameda | All ages | 356.8 | 17127 | 4800400 | 01 |
Alpine | 1-2 years | 0 | 0 | 51.5 | 02 |
Alpine | 10-13 years | 0 | 0 | 243.6 | 02 |
Alpine | 14-17 years | 0 | 0 | 221.1 | 02 |
Alpine | 18-34 years | 837 | 4 | 477.9 | 02 |
Alpine | 3-5 years | 0 | 0 | 79.7 | 02 |
Alpine | 35-64 years | 136.3 | 2 | 1467.4 | 02 |
Alpine | 6-9 years | 0 | 0 | 114 | 02 |
Alpine | 65-100 years | 0 | 0 | 814.3 | 02 |
Are you asking about adding a new field, like stateAndCounty Fips? If you did that you could calculate the values in the new field by taking California's FIPS 060 and concatenating the county fips. So above you would end up with values like 06001 and 06002.
Hey Rob, just to be clear. ArcGIS can only recognize a 5 digit zip code. What I am asking is if I provide the software with only 2-digit county FIPS, would ArcGIS be able to populate the data?
If I open your table in a map in ArcGIS Pro, and then right click the table and click Geocode. The only Locator I can select is the ArcGIS World Geocoding Service. Which doesn't have an option for FIPS codes. Do you have any other locators to choose from? If not you would then have to create your own locator, which isn't all that difficult. Plus if you are using your own locator there are no credit costs involved. (Just noticing that your FIPS above for Alpine county should be 03 - FIPS are odd numbers for counties).
Here is a posting to help create your own locator. https://pro.arcgis.com/en/pro-app/latest/help/data/geocoding/fundamentals-of-creating-a-locator.htm