Difference between revisions of "Main Page/LRS measures for TRAC"
From phurvitz
Phil Hurvitz (talk | contribs) (→LRS data) |
Phil Hurvitz (talk | contribs) (→Referencing) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 47: | Line 47: | ||
=Referencing= | =Referencing= | ||
# Add csv file of points to ArcMap. | # Add csv file of points to ArcMap. | ||
| − | # Stock LRS method from ArcGIS ('''Display Route Events''') | + | # Stock LRS method from ArcGIS ('''Display Route Events''') to generate route event points |
| − | # | + | # Export route events to shapefile (the points should inherit projection from the line reference layer) |
| − | # | + | # 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''' | ||
| + | # Calculate XY coordinates: | ||
| + | #* ArcToolbox > AddXY Coordinates | ||
| + | # Open the new layer's table (right-click, open table) | ||
| + | # Options > Export (to create a csv file) | ||
End up with a table looking like: | End up with a table looking like: | ||
Latest revision as of 22:13, 27 January 2010
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
- Add csv file of points to ArcMap.
- Stock LRS method from ArcGIS (Display Route Events) to generate route event points
- Export route events to shapefile (the points should inherit projection from the line reference layer)
- 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
- Calculate XY coordinates:
- ArcToolbox > AddXY Coordinates
- Open the new layer's table (right-click, open table)
- 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 ...
