Convert CMS ID's to District 12 numbering scheme

[jdalbey]

Attached is the data file containing CMS locations used in CPTMS. Currently the CMS ID's shown in CPTMS are those obtained from the  CalTrans CWWP. They need to be converted to a numbering scheme used in District 12. The mapping from current ID to D12 number is provided in an attached file "CMS ID conversion.csv". (The last column is the D12 number). There are about 64 ID's to be converted.

The deliverable is a copy of the original CMS location json file where the ID's have been replaced by their D12 equivalent.

While this task could be performed manually, there is a high chance for data entry error. A better approach is to write a script to automatically perform the conversion. One strategy is to edit the csv file and turn it into a sequence of sed commands.

[jdalbey]

CMS locations file (original)

[jdalbey]

File that maps CMS ID into D12 numbering

[jdalbey]

sed commands to do the conversion (except #52)

[jdalbey]

Fixed in r430.