Changes between Version 6 and Version 7 of CPTMS


Ignore:
Timestamp:
02/28/2019 10:04:23 AM (7 years ago)
Author:
jdalbey
Comment:

modified some filenames for clarity

Legend:

Unmodified
Added
Removed
Modified

  • CPTMS

    v6 v7  
    1515In the selection boxes at the top specify "Type: Station Metadata" and desired district number, then click Submit. 
    1616 
    17 The report page which appears shows two columns, Field Specification and Available Files.  The former describes what is in each field of the data file. In the Available Files column select the most recently dated file. Download and save to your local computer as `d05_pm_vds_all.csv` (changing the extension from ".txt" to ".csv").  (For this exercise we'll pretend to be working with District 5 and name the files accordingly). 
     17The report page which appears shows two columns, Field Specification and Available Files.  The former describes what is in each field of the data file. In the Available Files column select the most recently dated file. Download and save to your local computer as `d05_vds_meta.csv` (changing the extension from ".txt" to ".csv").  (For this exercise we'll pretend to be working with District 5 and name the files accordingly). 
    1818 
    1919Open the file in Libre Office Calc (or other spreadsheet).  Delete unneeded columns, retaining: Fwy, Dir, State_PM, Latitude, Longitude, and Name.  Save as .csv.  Open in a text editor and remove the first row containing column headers.  Also remove quotation marks. 
    … …  
    2222 
    2323{{{ 
    24 python showDupPostmiles.py d05_pm_vds_all.csv 
     24python showDupPostmiles.py d`05_vds_meta`.csv 
    2525}}} 
    26 The results are saved in "`uniqFile`" which you should rename, to something like: `d05_postmile_uniq.csv` 
     26The results are saved in "`uniqFile`" which you should rename, to something like: `d05_vds_uniq.csv` 
     27 
     28(You can sort this file if you want a version that's easier to inspect or lookup by postmil). 
    2729 
    2830The next step is to preprocess the csv file which creates perpendicular unit vectors for each postmile: 
    … …  
    4042 
    4143{{{ 
    42 python prep_postmiles.py > d12_postmile_prepped.csv 
     44python prep_postmiles.py > d12_vds_uniq_prepped.csv 
    4345}}} 
    4446Run the csv to json converter: 
    4547 
    4648{{{ 
    47 ./convertCSVtoJSON.bash d12_postmile_prepped.csv > highways.json 
     49./convertCSVtoJSON.bash d12_vds_uniq_prepped.csv > highways.json 
    4850}}} 
    4951Edit the json file to remove an extraneous comma after the last feature. The last three lines should appear as: 
    … …  
    6466 
    6567{{{ 
    66 cut -f1-6 -d"," d12_postmile_prepped.csv > postmile_coordinates.txt 
     68cut -f1-6 -d"," d12_vds_uniq_prepped.csv > postmile_coordinates.txt 
    6769}}} 
    68 Move postmile_coords.txt to the TMC config folder. 
     70Move postmile_coordinates.txt to the TMC config folder. 
    6971 
    7072{{{