1) Highest Flickr photo density Which cell has the highest Flickr photo density? Give the result as the centroid point coordinate in the British National Grid Coordinate system (i.e. the same as the points are stored in). Include...
1) Highest Flickr photo density
Which cell has the highest Flickr photo density? Give the result as the centroid point coordinate in the British National Grid Coordinate system (i.e. the same as the points are stored in). Include the SQL you used to determine the result.
2) Route lengths
Load the following datasets from …… into your PostgreSQL database
• routeb.sql
• routec.sql
(you should have already loaded routea.sql during the lab)
How long is each of the routes - routea, routeb, routec - in metres? (show the SQL you used)
3) Route popularity
Use the flickr photo data to show the popularity of each route according to how many photos have been taken along the route within a 25m buffer. You should normalise this by route length (i.e. photos per metre).
Give the SQL used and show your results in order from most popular route to least popular route. (Preferably do this as a single SQL statement.)
and four question more.
I attach file.
For privacy and security, delivered files are not available for public download. The student who placed this order can sign in to access the delivered work from their dashboard.
Post your assignment and receive offers from verified writers in your subject area.
Post a new assignment Back to latest orders