dannypage · May 11, 2020 17:26
diff --git a/url.txt b/url.txt
 https://query.wikidata.org/#PREFIX%20wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0APREFIX%20wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0APREFIX%20wikibase%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%0APREFIX%20p%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2F%3E%0APREFIX%20v%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fstatement%2F%3E%0APREFIX%20psv%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fstatement%2Fvalue%2F%3E%0APREFIX%20q%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fqualifier%2F%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0A%0ASELECT%20%3FcountryName%20%3FleagueName%20%3FteamName%20%3FvenueName%20%3Flat%20%3Flong%20WHERE%20%7B%0A%20%20%3Fteam%20wdt%3AP118%20%3Fleague%20.%0A%20%20%3Fteam%20rdfs%3Alabel%20%3FteamName%20FILTER%20(lang(%3FteamName)%20%3D%20'en')%20.%0A%20%20%3Fleague%20wdt%3AP31%20wd%3AQ15991303%20.%0A%20%20%3Fleague%20rdfs%3Alabel%20%3FleagueName%20FILTER%20(lang(%3FleagueName)%20%3D%20'en').%0A%20%20%3Fleague%20wdt%3AP17%20%3Fcountry%20.%0A%20%20%3Fcountry%20rdfs%3Alabel%20%3FcountryName%20FILTER%20(lang(%3FcountryName)%20%3D%20'en').%0A%20%20%20%20%20%20%20%20%20%20%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fteam%20wdt%3AP115%20%3Fvenue%20.%0A%20%20%20%20%3Fvenue%20rdfs%3Alabel%20%3FvenueName%20FILTER%20(lang(%3FvenueName)%20%3D%20'en').%0A%20%20%20%20%3Fvenue%20p%3AP625%20%3Flocation%20.%20%20%0A%20%20%20%20%3Flocation%20psv%3AP625%20%3FlocationValue%20.%20%20%0A%20%20%20%20%3FlocationValue%20wikibase%3AgeoLatitude%20%3Flat%20.%0A%20%20%20%20%3FlocationValue%20wikibase%3AgeoLongitude%20%3Flong%20.%0A%20%20%7D%0A%20%7D%0AORDER%20BY%20%3FcountryName%20%3FleagueName%20%3FteamName
diff --git a/Wikidata_stadium_lat_long.tsv b/Wikidata_stadium_lat_long.tsv
diff --git a/z_get_lat_long.py b/z_get_lat_long.py
 //work in progress

 import simplejson
 import urllib

 //make sure to include proper encoding

 YOUR_API_KEY = 
 ELEVATION_BASE_URL = "https://maps.googleapis.com/maps/api/elevation/json"

 //For Loop Here with every stadium with lat and long

 url = ELEVATION_BASE_URL + "?locations{lat},{long}&key={key}".format(lat=,long=,key=YOUR_API_KEY)
 response = simplejson.load(urllib.urlopen(url))

 //Add to lat long

 //end forloop, output csv
	//work in progress

	import simplejson
	import urllib

	//make sure to include proper encoding

	YOUR_API_KEY =
	ELEVATION_BASE_URL = "https://maps.googleapis.com/maps/api/elevation/json"

	//For Loop Here with every stadium with lat and long

	url = ELEVATION_BASE_URL + "?locations{lat},{long}&key={key}".format(lat=,long=,key=YOUR_API_KEY)
	response = simplejson.load(urllib.urlopen(url))

	//Add to lat long

	//end forloop, output csv