FIPS codes are a standard way for representing counties.
FIPS codes are useful for importing into mapping / GIS software.
The DSHS Health Promotion and Chronic Disease Prevention Section
staff suggested to add FIPS codes to Vitalnet output.
I also asked the DSHS Center for Health Statistics for input about adding FIPS codes.
FIPS codes are like the following:
When FIPS Codes are Displayed
FIPS codes could be shown in the output table if one of the following:
Option AC (Append County) and Option RN (Replace Name) were programmed, since they are useful and feasible.
Option TF (Two Fields) was not programmed,
despite the attractiveness of having two fields.
It is difficult to implement, a one-off so less practical to implement,
and confusing because it cannot be applied to columns.
I am hoping AC and RN will prove adequate.
VitalPro Menu -
The VitalPro Main Menu shows "FIPS in Output", with three possible values:
- "Yes: Append County Name"
- "Yes: Replace County Name"
- "No: County Name Only"
When Menu Options Shown -
VitalPro is configured to only show the FIPS option when area rows / columns are selected.
For example, if year rows and sex columns, the FIPS menu option would be hidden.
Vitalnet Maps -
Vitalnet maps still display the county names, not the FIPS codes.
It is possible (with tedious programming) to include the FIPS codes on maps.
But the point of using FIPS codes on the map is not yet clear or requested.
Manual Method -
Another way to include FIPS codes is as follows:
1) Select "all counties", "area set rows", "rows not sorted".
2) Save VitalPro output in spreadsheet format.
3) Add a column to the spreadsheet output.
4) Autofill column 48001 to 48507, increasing each row by two.