Question: Please help with these awk programs! 3. Awk . Your code for this and the next two question will be graded by a script so

Please help with these awk programs!

3. Awk. Your code for this and the next two question will be graded by a script so be sure that your scripts have the right names and produce the correct output (when run on mlc104).

The csumb.osm file contains data about roads around CSUMB. The file is in XML format, and contains information about "ways" (like stretches of road) and "nodes" points along a road. Write an awk script named make-nodes-table.awk that will extract node information from a .osm file. Your script should do this on the csumb.osm file: $ awk -f make-nodes-table.awk csumb.osm | wc 289 289 9734 $ awk -f make-nodes-table.awk csumb.osm | head -15 node_id,lat,long 1647008557,36.6536840,-121.7938995 421381587,36.6440097,-121.8066305 1646442592,36.6444397,-121.8064060 89819313,36.6461624,-121.8055179 1646442620,36.6446496,-121.8062964 89819334,36.6480528,-121.8067458 2935611310,36.6478826,-121.8060726 2935611314,36.6479609,-121.8058399 2935611315,36.6480277,-121.8063213 89801177,36.6409070,-121.8020990 89821442,36.6439543,-121.8028688 89821444,36.6437400,-121.8028720 89821446,36.6432520,-121.8030660 89821448,36.6428490,-121.8030920 $ awk -f make-nodes-table.awk csumb.osm | tail -15 2342889689,36.6551549,-121.7670867 3727683587,36.6551113,-121.7716948 3727683588,36.6551441,-121.7709472 3727683589,36.6551905,-121.7663836 89880441,36.6595260,-121.7787770 2342889693,36.6552093,-121.7649071 89954271,36.6554350,-121.7584980 89933309,36.6650290,-121.8008020 89933312,36.6649700,-121.8003770 89933314,36.6649210,-121.8001720 89933318,36.6648190,-121.7999010 89933321,36.6646840,-121.7996710 89933323,36.6645870,-121.7995480 89933326,36.6644810,-121.7994380 89933331,36.6642690,-121.7992770 I have provided the complete correct output file csumb-nodes.csv for you to test your code against.

I have provided the complete correct output file csumb-nodes.csv for you to test your code against. csumb.osm, csumb-nodes.csv, queries.sql file found here: (scroll all the way through to see other files) https://docs.google.com/document/d/1ID_GILE61o1EfkY_vqFop2ByqL1r0PYnt4kW_LLz1gQ/edit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Please help with basic 'awk' programming You don't need advanced features of AWK for these scripts. Do not use 'getline' or 'next', and stick to basic AWK programming. Your awk programs will be run...

Please help, this is actually due today and the person who said they would answer this question that was initially due last night. Thank you for the help if possible. I need help with putting the...

This program is to be run in R please help me with question number 3 part D 3. Using the built-in matrix state.x77, create/process the following vectors/dataframes: a. df3a as a data frame create...

*****I already have this M1 part of the answer, but please help me to modify which part of the code is what I need (string.cpp, string.hpp, Makefile) for M1 requirements. string.cpp #include...

ASSEMBLY LANGUAGE HELP!!! Please help create these two programs:) Please Read the problem carefully and understand it!! Thank you for your help:) I'm really confused on this assignment. It's in...

Use the data in Problem 4-26 to develop a multiple linear regression model. How does this compare with each of the models in Problem 4-26? In Problem 4-26, A sample of 20 automobiles was taken, and...

There has been a lot of regulatory and legislative change to accommodate the disruption caused to business by the COVID19 pandemic. In the context of this unit, lets examine the impact on financial...

Recognition of tax benefits in the loss year due to a loss carryforward requires only a note to the financial statements. the establishment of a deferred tax liability. the establishment of an income...

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

Review Figure 16.9, a scannable rsum illustrated in this chapter, and make a list of words that you believe to be keywords related to property management and marketing. (Objective 4)

Ethics. Teamwork. Technology. Read the scenario below; partner with a classmate to discuss the ethical questions following the scenario.Working together, write an e-mail to your instructor explaining...

Technology. Access job opportunities on the Internet for positions related to your career objective. Assess the job opportunities in terms of your interest in them.Write a letter to your instructor...