We will continue to practice spatial SQL. Restore nyc backup files in your system. If you haven’t, you can find an instruction on how to do in-class activity SQL IV.
Produce SQL commands to Find a borough name where Broad Station ( ‘Broad St’ )is in. Provide SQL command and output.
Find the streets nearby (within 10 meters of) the Broad subway station. Make one SQL statement using subquery. Provide SQL command and output.
How many subway stations are in Queens? Provide SQL command and output.
Find a neighborhood name where Broad St subway station is. Provide SQL command in one SQL statement using spatial join and output.
Find the closest subway station for Red Line from the location of (-74.7029209 40.7029209). Provide SQL command and output.
Get the distance in meters between South Ferry station and Broad St station.
