Google Sheets; scrape data from a website
Budget
78$
per month
Posted: 5 years ago
Opened
- Description
- Make the following changes to this spreadsheet: https://docs.google.com/spreadsheets/d/1W-EH2Rs3MmP2k9ObSkVnv4hFFXZ2uw2fNX3LsZaZLEo/edit (Please request access and I will allow it).
1) Presently for 'Surface Wind' the spreadsheet creates a link like this automatically: https://earth.nullschool.net/#2019/04/14/1215Z/wind/surface/level/orthographic=-6.20,53.93,3000/loc=-2.3,52.65 from the data in the sheet.
We then click that link, and copy the details into the box on the spreadsheet.
Change this to automatically scrape the wind data from that website and insert it into the spreadsheet.
2) Create a new box to the right of 'Surface Wind', called 'Altitude Wind', and do the same as point 1. Scrape the wind data in, for the wind at the specified altitude. (The altitude is specified in column E).
3) For 'Geozone' (column O) we need to look at this webpage: https://tinyurl.com/y6d993p4 and insert the coordinates in the correct format (example photo here: https://tinyurl.com/yyfxyarf) to see if the location was in a Geozone or not.
The format of the coordinates in column c is no longer correct (since they changed to Mapbox, instead of Google Maps). Convert the coordinates to a format which works with Mapbox (and keep the old ones too).
Is there a way to work out if the coordinates are in a geozone or not programmatically, ie without manual intervention? If so...do that. If not we will have to continue to manually check. If a link can be created that automatically takes us directly to the correct coordinates on the spreadsheet that would be something.
Thanks!
Simon
Skills:
google maps,application programming interface (API),scraping,software development,web
- Category
Source: peopleperhour.com
Drag