Main Page/LRS measures for TRAC

From phurvitz
< Main Page
Revision as of 22:13, 27 January 2010 by Phil Hurvitz (talk | contribs) (→‎Referencing)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Creating points from LRS measured locations using WSDOT LRS line data and ASCII tables with mileposts

Point source data

Data are stored like so: 

"Name","Alias","Roadway","Location","Milepost","CommStatus"
"002es00068",,"US 2","Homeacres Rd",0.68,"DISABLE"
"002es00504",,"US 2","SR 9",5.04,"DISABLE"
"005es13969","ES-002D","I-5","Pierce Co Line",139.69,"Marginal"
"005es14015","ES-003D","I-5","S 375th St",140.15,"Active"
"005es14016","ES-003M","I-5","S 375th St",140.16,"FAILURE"
"005es14064","ES-005D","I-5","Fed Way WeighStn",140.64,"Active"
"005es14065","ES-005M","I-5","NB Weigh Stn",140.65,"FAILURE"
"005es14126","ES-007D","I-5","Enchanted Pkwy",141.26,"Active"
"005es14127","ES-007M","I-5","Enchanted Pkwy",141.27,"FAILURE"
"005es14176","ES-009D","I-5","SR 18 I/C, South",141.76,"Active"
"005es14221","ES-012D","I-5","SR 18 I/C, North",142.21,"Active"
"005es14277","ES-013D","I-5","S 336th St",142.77,"Active"
"005es14300","ES-014M","I-5","S 333rd St",143,"FAILURE"
"005es14321","ES-015D","I-5","S 325th St",143.21,"Active"
"005es14364","ES-016R","I-5","S 320th St-SB",143.64,"Active"
"005es14398","ES-017R","I-5","S 320th St-NB",143.98,"Active"
"005es14460","ES-019D","I-5","S 308th St",144.6,"Active"
...

Note the Roadway and Milepost fields.

LRS data

  • Data from wsdot
  • Shapefile used: SR24kLRSIncreaseSPS.shp
  • The LRS data have specific fields as well.
  • We added a field called roadway (text, 50)
  • Calculated roadway = [RT_TYPEA] & " " & [DISPLAY]
  • Find-and-replaced "IS " with "I-" (note trailing space after IS)
SR	DISPLAY	RT_TYPEA	RT_TYPEB	SRID	RID	RRT	RRQ	SHAPE_len	roadway
002	2	US	2	002	002			1702571.18167000000	US 2
002COBROWNE	2	US	2	002COBROWNE	002	CO	BROWNE	3342.74767430000	US 2
002CODIVISN	2	US	2	002CODIVISN	002	CO	DIVISN	8083.11974512000	US 2
002CONEWPRT	2	US	2	002CONEWPRT	002	CO	NEWPRT	2544.78025609000	US 2
002LX00239	2	LC	4	002LX00239	002	LX	00239	823.29829249900	LC 2
...

Referencing

  1. Add csv file of points to ArcMap.
  2. Stock LRS method from ArcGIS (Display Route Events) to generate route event points
  3. Export route events to shapefile (the points should inherit projection from the line reference layer)
  4. Project to WGS84 in ArcMap (specifying a new output data set):
    • ArcToolbox: Project
    • Select Geographic > World > WGS84
    • Geometric Transformation choice NAD 1983 to HARN WGS 1984
  5. Calculate XY coordinates:
    • ArcToolbox > AddXY Coordinates
  6. Open the new layer's table (right-click, open table)
  7. Options > Export (to create a csv file)

End up with a table looking like: 

Name	Alias	Roadway	Location	Milepost	CommStatus	POINT_X	POINT_Y	POINT_M
099es03298	ES-R41M	SR 99	Valley St	32.96000000000	FAILURE	-122.34487549000	47.71603899710	32.96000000000
099es03297	ES-R42M	SR 99	Valley St	32.96000000000	FAILURE	-122.34487549000	47.71603899710	32.96000000000
405es01647	ES-708D	I-405	NE 53rd St	16.47000000000	Active	-122.18687972200	47.65577157570	16.47000000000
099es03186	ES-R32M	SR 99	Elliott Ave	31.85000000000	FAILURE	-122.34455189100	47.69987726320	31.85000000000
099es03185	ES-R31M	SR 99	Elliott Ave	31.85000000000	FAILURE	-122.34455189100	47.69987726320	31.85000000000
...
Retrieved from "http://faculty.washington.edu/phurvitz/mediawiki/index.php?title=Main_Page/LRS_measures_for_TRAC&oldid=2119"