topic Re: Can I populate a map with a two digit FIPS county code? in ArcGIS Pro Questions

Can I populate a map with a two digit FIPS county code?

chagithebear — Mon, 07 Feb 2022 08:50:17 GMT

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.

Re: Can I populate a map with a two digit FIPS county code?

chagithebear — Mon, 07 Feb 2022 09:43:43 GMT

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

Re: Can I populate a map with a two digit FIPS county code?

RobBurke — Mon, 07 Feb 2022 21:04:27 GMT

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.

Re: Can I populate a map with a two digit FIPS county code?

chagithebear — Tue, 08 Feb 2022 18:42:01 GMT

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?

Re: Can I populate a map with a two digit FIPS county code?

RobBurke — Mon, 14 Feb 2022 20:21:38 GMT

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