Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Write an AWK script called make-road-table.awk that will extract road data from an .osm file called csumb.osm You can get the file from here: https://drive.google.com/file/d/1S_FqQWmD5PYzat1Bd0mGwy_Zmc1H6G6W/view?usp=sharing

Write an AWK script called make-road-table.awk that will extract road data from an .osm file called csumb.osm

You can get the file from here: https://drive.google.com/file/d/1S_FqQWmD5PYzat1Bd0mGwy_Zmc1H6G6W/view?usp=sharing

This is a snipped of the kind of data contained in the file:

When running the awk script with the file from the link you should get the following output. Notice, the sections in the file that do not contain the '' within the tag section were ignored.

image text in transcribed

$ awk f make-road-table.awk csumb.osm | wc 279 662 10251 $ awk f make-road-table.awk csumb.osm| head -15 road,way_id,seq_num, node_id Engineer Road,10459706,1,89705976 Engineer Road,10459706,2,89798118 Engineer Road,10459706,3,89798120 Engineer Road,10459706,4,89798122 Engineer Road,10459706,5,89798124 Engineer Road,10459706,6,89798126 Engineer Road,10459706,7,89798128 Engineer Road,10459706,8,89798130 5th Cutoff Street, 10461171,1,89804458 5th Cutoff Street, 10461171,2,89804460 5th Cutoff Street, 10461171,3,89804463 5th Cutoff Street, 10461171,4,89804464 5th Cutoff Street, 10461171,5,89804466 5th Cutoff Street,10461171,6, 89804468 $ awk f make-road-table.awk csumb.osm | tail -15 Inter-Garrison Road, 205167594,7,2342889683 Inter-Garrison Road, 205167594,8,89994529 Inter-Garrison Road, 205167594,9,89994530 Inter-Garrison Road, 205167594,10, 3727683588 Inter-Garrison Road,205167594,11,3727683587 Inter-Garrison Road, 205167594,12, 3727683584 Inter-Garrison Road,205167594,13,89994533 Inter-Garrison Road, 205167594,14, 89899515 Inter-Garrison Road, 205167594,15, 89917014 Inter-Garrison Road, 205167594,16,373831767 Inter-Garrison Road, 205167594,17,89808878 Light Fighter Drive,441628696,1,2935611310 Light Fighter Drive, 441628696, 2, 2935611307 Light Fighter Drive,441628696, 3,2935611305 Light Fighter Drive, 441628696,4, 89819293

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases Illuminated

Authors: Catherine M. Ricardo

1st Edition

0763733148, 978-0763733148

More Books

Students also viewed these Databases questions