- Describe Feature
Creating county level area maps in Sigma currently relies on matching on the text name of the county and the full name of the state. This causes a number of problems:
Relies on the name format in the source data to match the format in Sigma’s JSON file. This is often not true. For example, my source has ST MARY, LOUISIANA, but in the JSON file it is ST. MARY, LOUISIANA. Similarly, in my source counties that are also cities, such as Baltimore, have CITY as part of the name, but that’s not the case in Sigma’s county names
Almost always requires creating a new field to concatenate county name and full state name.
Solution: offer the option to join on the FIPS code, which contains unambiguous state and county designations, and is already part of the Sigma JSON file.
- What is the use case?
Creating county level area maps in the US
- How often would this feature be used?
- What is the impact of this feature on your organization?
Reduced time spent cleaning/reformatting data