id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
165	Convert CMS ID's to District 12 numbering scheme	jdalbey	tanmay	"Attached is the data file containing CMS locations used in CPTMS. Currently the CMS ID's shown in CPTMS are those obtained from the [http://www1.dot.ca.gov/cwwp2/documentation/cms/cms.htm 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.  "	enhancement	closed	High	Sep 2019 Training	CPTMS		Minor	done		jdalbey