Forum Discussion
markjohnson952
Helper I
5 years agoShape map duplicate counties
I am using the Shape Map with a TOPOJSON to identify sales by county. In the cases where you have the same county name in multiple states (Jefferson, Orange, Washington) my sales numbers are all the...
- 5 years ago
I figured it out.
You have to create a column concactenating the state fips code and the county fips code and then use that in your location field on visual. You can also just add the list below in the link to your data model.
https://www.nrcs.usda.gov/wps/portal/nrcs/detail/national/home/?cid=nrcs143_013697
markjohnson952
Helper I
5 years agoI figured it out.
You have to create a column concactenating the state fips code and the county fips code and then use that in your location field on visual. You can also just add the list below in the link to your data model.
https://www.nrcs.usda.gov/wps/portal/nrcs/detail/national/home/?cid=nrcs143_013697