def getLanguages(fetch_rdf=False):
# Languages of a country
languages = ws.querySPARQLtoJSON("""
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dbpedia-owl: <http://dbpedia.org/ontology/>
PREFIX dbpprop: <http://dbpedia.org/property/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT * WHERE {
?country rdf:type dbpedia-owl:Country .
?country dbpedia-owl:language ?language .
?language rdfs:label ?name .
?country rdfs:label ?country_name .
FILTER(LANGMATCHES(LANG(?name), 'EN'))
FILTER(LANGMATCHES(LANG(?country_name), 'EN'))
} LIMIT 1000
""")
for language in languages:
name = language['name']['value']
country_name = language['country_name']['value']
for country in Country.objects.filter(name=country_name):
print 'Saving information for', name, 'in', country_name
language, created = Language.objects.get_or_create(name=name)
if fetch_rdf:
language.rdf = ws.getResource(name)
language.save()
if language not in country.languages.all():
country.languages.add(language)
country.save()
def getCountries(fetch_rdf=False):
# Country
print 'Getting countries information'
countries = ws.querySPARQLtoJSON("""
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dbpedia-owl: <http://dbpedia.org/ontology/>
PREFIX dbpprop: <http://dbpedia.org/property/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT DISTINCT *
WHERE {
?country rdf:type dbpedia-owl:Country .
?country rdfs:label ?name .
?country dbpprop:currencyCode ?currency_code .
?country dbpprop:currency ?currency_name .
?country dbpedia-owl:abstract ?abstract .
FILTER(LANGMATCHES(LANG(?abstract), 'EN'))
FILTER(LANGMATCHES(LANG(?name), 'EN'))
} LIMIT 1000
""")
for c in countries:
name = c['name']['value']
print 'Saving information for country', name
result = Country.objects.filter(name=name)
if result:
country = result[0]
country.description = c['abstract']['value']
currency_code = c['currency_code']['value']
currency, created = Currency.objects.get_or_create(
code=currency_code,
defaults={'name': c['currency_name']['value']})
#language, created = Language.objects.get_or_create(name=name)
country.currency = currency
country.wikipedia_url = 'http://en.wikipedia.org/w/index.php?title=' + name.replace(
" ", "_") + '&printable=yes'
country.wikitravel_url = 'http://wikitravel.org/wiki/en/index.php?title=' + name.replace(
" ", "_") + '&printable=yes'
if fetch_rdf:
country.rdf = ws.getResource(name)
country.save()
def getPlaces(fetch_rdf=False):
for city in City.objects.all():
print 'Querying places for city', city
places = ws.querySPARQLtoJSON("""
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dbpedia-owl: <http://dbpedia.org/ontology/>
PREFIX dbpprop: <http://dbpedia.org/property/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT DISTINCT * WHERE {
?place rdfs:label ?name .
?place geo:lat ?lat .
?place geo:long ?long .
OPTIONAL{?place dbpedia-owl:abstract ?abstract}
FILTER(xsd:double(?lat) - xsd:double(""" + str(city.lat) +
""") <= 0.10 &&
xsd:double(""" + str(city.lat) + """) - xsd:double(?lat) <= 0.10 &&
xsd:double(?long) - xsd:double(""" + str(city.lng) + """) <= 0.10 &&
xsd:double(""" + str(city.lng) + """) - xsd:double(?long) <= 0.10 &&
LANGMATCHES(LANG(?name), 'EN') &&
LANGMATCHES(LANG(?abstract), 'EN')
) } LIMIT 1000
""")
for place in places:
name = place['name']['value']
print 'Saving information for place', name, 'in', city
p, created = Place.objects.get_or_create(name=name,
defaults={'city': city})
p.description = place['abstract']['value']
p.lat = place['lat']['value']
p.lng = place['long']['value']
p.wikipedia_url = 'http://en.wikipedia.org/w/index.php?title=' + name.replace(
" ", "_") + '&printable=yes'
if fetch_rdf:
p.rdf = ws.getResource(name)
p.save()
def getPlaces(fetch_rdf=False):
for city in City.objects.all():
print 'Querying places for city', city
places = ws.querySPARQLtoJSON("""
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dbpedia-owl: <http://dbpedia.org/ontology/>
PREFIX dbpprop: <http://dbpedia.org/property/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT DISTINCT * WHERE {
?place rdfs:label ?name .
?place geo:lat ?lat .
?place geo:long ?long .
OPTIONAL{?place dbpedia-owl:abstract ?abstract}
FILTER(xsd:double(?lat) - xsd:double("""+str(city.lat)+""") <= 0.10 &&
xsd:double("""+str(city.lat)+""") - xsd:double(?lat) <= 0.10 &&
xsd:double(?long) - xsd:double("""+str(city.lng)+""") <= 0.10 &&
xsd:double("""+str(city.lng)+""") - xsd:double(?long) <= 0.10 &&
LANGMATCHES(LANG(?name), 'EN') &&
LANGMATCHES(LANG(?abstract), 'EN')
) } LIMIT 1000
""")
for place in places:
name = place['name']['value']
print 'Saving information for place', name, 'in', city
p, created = Place.objects.get_or_create(name=name, defaults={'city':city})
p.description = place['abstract']['value']
p.lat = place['lat']['value']
p.lng = place['long']['value']
p.wikipedia_url = 'http://en.wikipedia.org/w/index.php?title='+name.replace(" ", "_")+'&printable=yes'
if fetch_rdf:
p.rdf = ws.getResource(name)
p.save()
def getCities(fetch_rdf=False):
# Cities of a country
countries = Country.objects.all().filter(name='Spain')
for country in countries:
print 'Querying cities for country', country.name
cities = ws.querySPARQLtoJSON("""
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dbpedia-owl: <http://dbpedia.org/ontology/>
PREFIX dbpprop: <http://dbpedia.org/property/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT DISTINCT * WHERE {
?city dbpedia-owl:country ?country .
?city rdfs:label ?name .
?country rdfs:label '"""+country.name+"""'@en .
?city geo:lat ?lat .
?city geo:long ?long .
?city dbpprop:populationTotal ?population .
OPTIONAL {?city dbpedia-owl:abstract ?abstract}
OPTIONAL {?city dbpprop:utcOffset ?timezone}
OPTIONAL {?city dbpprop:utcOffsetDst ?timezone_dst}
FILTER(LANGMATCHES(LANG(?abstract), 'EN'))
FILTER(LANGMATCHES(LANG(?name), 'EN'))
} ORDER BY DESC(?population)
LIMIT 100
""")
#?country rdf:type dbpedia-owl:Country .\
#?city rdf:type dbpedia-owl:PopulatedPlace .
#?city rdf:type dbpedia-owl:City .
# OPTIONAL { ?city dbpprop:janHighC ?janHighC .
# ?city dbpprop:janLowC ?janLowC .
# ?city dbpprop:janMeanC ?janMeanC .
# ?city dbpprop:janPrecipitationDays ?janPrecipitationDays .
# ?city dbpprop:janPrecipitationMm ?janPrecipitationMm .
# ?city dbpprop:janSun ?janSun .
#
# ?city dbpprop:febHighC ?febHighC .
# ?city dbpprop:febLowC ?febLowC .
# ?city dbpprop:febMeanC ?febMeanC .
# ?city dbpprop:febPrecipitationDays ?febPrecipitationDays .
# ?city dbpprop:febPrecipitationMm ?febPrecipitationMm .
# ?city dbpprop:febSun ?febSun .
#
# ?city dbpprop:marHighC ?marHighC .
# ?city dbpprop:marLowC ?marLowC .
# ?city dbpprop:marMeanC ?marMeanC .
# ?city dbpprop:marPrecipitationDays ?marPrecipitationDays .
# ?city dbpprop:marPrecipitationMm ?marPrecipitationMm .
# ?city dbpprop:marSun ?marSun .
#
# ?city dbpprop:aprHighC ?aprHighC .
# ?city dbpprop:aprLowC ?aprLowC .
# ?city dbpprop:aprMeanC ?aprMeanC .
# ?city dbpprop:aprPrecipitationDays ?aprPrecipitationDays .
# ?city dbpprop:aprPrecipitationMm ?aprPrecipitationMm .
# ?city dbpprop:aprSun ?aprSun .
#
# ?city dbpprop:mayHighC ?mayHighC .
# ?city dbpprop:mayLowC ?mayLowC .
# ?city dbpprop:mayMeanC ?mayMeanC .
# ?city dbpprop:mayPrecipitationDays ?mayPrecipitationDays .
# ?city dbpprop:mayPrecipitationMm ?mayPrecipitationMm .
# ?city dbpprop:maySun ?maySun .
#
# ?city dbpprop:junHighC ?junHighC .
# ?city dbpprop:junLowC ?junLowC .
# ?city dbpprop:junMeanC ?junMeanC .
# ?city dbpprop:junPrecipitationDays ?junPrecipitationDays .
# ?city dbpprop:junPrecipitationMm ?junPrecipitationMm .
# ?city dbpprop:junSun ?junSun .
#
# ?city dbpprop:julHighC ?julHighC .
# ?city dbpprop:julLowC ?julLowC .
# ?city dbpprop:julMeanC ?julMeanC .
# ?city dbpprop:julPrecipitationDays ?julPrecipitationDays .
# ?city dbpprop:julPrecipitationMm ?julPrecipitationMm .
# ?city dbpprop:julSun ?julSun .
#
# ?city dbpprop:augHighC ?augHighC .
# ?city dbpprop:augLowC ?augLowC .
# ?city dbpprop:augMeanC ?augMeanC .
# ?city dbpprop:augPrecipitationDays ?augPrecipitationDays .
# ?city dbpprop:augPrecipitationMm ?augPrecipitationMm .
# ?city dbpprop:augSun ?augSun .
#
# ?city dbpprop:sepHighC ?sepHighC .
# ?city dbpprop:sepLowC ?sepLowC .
# ?city dbpprop:sepMeanC ?sepMeanC .
# ?city dbpprop:sepPrecipitationDays ?sepPrecipitationDays .
# ?city dbpprop:sepPrecipitationMm ?sepPrecipitationMm .
# ?city dbpprop:sepSun ?sepSun .
#
# ?city dbpprop:octHighC ?octHighC .
# ?city dbpprop:octLowC ?octLowC .
# ?city dbpprop:octMeanC ?octMeanC .
# ?city dbpprop:octPrecipitationDays ?octPrecipitationDays .
# ?city dbpprop:octPrecipitationMm ?octPrecipitationMm .
# ?city dbpprop:octSun ?octSun .
#
# ?city dbpprop:novHighC ?novHighC .
# ?city dbpprop:novLowC ?novLowC .
# ?city dbpprop:novMeanC ?novMeanC .
# ?city dbpprop:novPrecipitationDays ?novPrecipitationDays .
# ?city dbpprop:novPrecipitationMm ?novPrecipitationMm .
# ?city dbpprop:novSun ?novSun .
#
# ?city dbpprop:decHighC ?decHighC .
# ?city dbpprop:decLowC ?decLowC .
# ?city dbpprop:decMeanC ?decMeanC .
# ?city dbpprop:decPrecipitationDays ?decPrecipitationDays .
# ?city dbpprop:decPrecipitationMm ?decPrecipitationMm .
# ?city dbpprop:decSun ?decSun }
for city in cities:
name = city['name']['value']
print 'Saving information for city', name, ',', country.name
c, created = City.objects.get_or_create(name=name, defaults={'country':country})
c.description = city['abstract']['value']
c.population = city['population']['value']
c.lat = city['lat']['value']
c.lng = city['long']['value']
c.wikipedia_url = 'http://en.wikipedia.org/w/index.php?title='+name.replace(" ", "_")+'&printable=yes'
c.wikitravel_url = 'http://wikitravel.org/wiki/en/index.php?title='+name.replace(" ", "_")+'&printable=yes'
c.timezone = getValue(city, 'timezone')
c.timezone_dst = getValue(city, 'timezone_dst')
if fetch_rdf:
c.rdf = ws.getResource(name)
# c.janHighC = getValue(city, 'janHighC')
# c.janLowC = getValue(city, 'janLowC')
# c.janMeanC = getValue(city, 'janMeanC')
# c.janPrecipitationDays = getValue(city, 'janPrecipitationDays')
# c.janPrecipitationMm = getValue(city, 'janPrecipitationMm')
# c.janSun = getValue(city, 'janSun')
#
# c.febHighC = getValue(city, 'febHighC')
# c.febLowC = getValue(city, 'febLowC')
# c.febMeanC = getValue(city, 'febMeanC')
# c.febPrecipitationDays = getValue(city, 'febPrecipitationDays')
# c.febPrecipitationMm = getValue(city, 'febPrecipitationMm')
# c.febSun = getValue(city, 'febSun')
#
# c.marHighC = getValue(city, 'marHighC')
# c.marLowC = getValue(city, 'marLowC')
# c.marMeanC = getValue(city, 'marMeanC')
# c.marPrecipitationDays = getValue(city, 'marPrecipitationDays')
# c.marPrecipitationMm = getValue(city, 'marPrecipitationMm')
# c.marSun = getValue(city, 'marSun')
#
# c.aprHighC = getValue(city, 'aprHighC')
# c.aprLowC = getValue(city, 'aprLowC')
# c.aprMeanC = getValue(city, 'aprMeanC')
# c.aprPrecipitationDays = getValue(city, 'aprPrecipitationDays')
# c.aprPrecipitationMm = getValue(city, 'aprPrecipitationMm')
# c.aprSun = getValue(city, 'aprSun')
#
# c.mayHighC = getValue(city, 'mayHighC')
# c.mayLowC = getValue(city, 'mayLowC')
# c.mayMeanC = getValue(city, 'mayMeanC')
# c.mayPrecipitationDays = getValue(city, 'mayPrecipitationDays')
# c.mayPrecipitationMm = getValue(city, 'mayPrecipitationMm')
# c.maySun = getValue(city, 'maySun')
#
# c.junHighC = getValue(city, 'junHighC')
# c.junLowC = getValue(city, 'junLowC')
# c.junMeanC = getValue(city, 'junMeanC')
# c.junPrecipitationDays = getValue(city, 'junPrecipitationDays')
# c.junPrecipitationMm = getValue(city, 'junPrecipitationMm')
# c.junSun = getValue(city, 'junSun')
#
# c.julHighC = getValue(city, 'julHighC')
# c.julLowC = getValue(city, 'julLowC')
# c.julMeanC = getValue(city, 'julMeanC')
# c.julPrecipitationDays = getValue(city, 'julPrecipitationDays')
# c.julPrecipitationMm = getValue(city, 'julPrecipitationMm')
# c.julSun = getValue(city, 'julSun')
#
# c.augHighC = getValue(city, 'augHighC')
# c.augLowC = getValue(city, 'augLowC')
# c.augMeanC = getValue(city, 'augMeanC')
# c.augPrecipitationDays = getValue(city, 'augPrecipitationDays')
# c.augPrecipitationMm = getValue(city, 'augPrecipitationMm')
# c.augSun = getValue(city, 'augSun')
#
# c.sepHighC = getValue(city, 'sepHighC')
# c.sepLowC = getValue(city, 'sepLowC')
# c.sepMeanC = getValue(city, 'sepMeanC')
# c.sepPrecipitationDays = getValue(city, 'sepPrecipitationDays')
# c.sepPrecipitationMm = getValue(city, 'sepPrecipitationMm')
# c.sepSun = getValue(city, 'sepSun')
#
# c.octHighC = getValue(city, 'octHighC')
# c.octLowC = getValue(city, 'octLowC')
# c.octMeanC = getValue(city, 'octMeanC')
# c.octPrecipitationDays = getValue(city, 'octPrecipitationDays')
# c.octPrecipitationMm = getValue(city, 'octPrecipitationMm')
# c.octSun = getValue(city, 'octSun')
#
# c.novHighC = getValue(city, 'novHighC')
# c.novLowC = getValue(city, 'novLowC')
# c.novMeanC = getValue(city, 'novMeanC')
# c.novPrecipitationDays = getValue(city, 'novPrecipitationDays')
# c.novPrecipitationMm = getValue(city, 'novPrecipitationMm')
# c.novSun = getValue(city, 'novSun')
#
# c.decHighC = getValue(city, 'decHighC')
# c.decLowC = getValue(city, 'decLowC')
# c.decMeanC = getValue(city, 'decMeanC')
# c.decPrecipitationDays = getValue(city, 'decPrecipitationDays')
# c.decPrecipitationMm = getValue(city, 'decPrecipitationMm')
# c.decSun = getValue(city, 'decSun')
c.save()
def getCities(fetch_rdf=False):
# Cities of a country
countries = Country.objects.all().filter(name='Spain')
for country in countries:
print 'Querying cities for country', country.name
cities = ws.querySPARQLtoJSON("""
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dbpedia-owl: <http://dbpedia.org/ontology/>
PREFIX dbpprop: <http://dbpedia.org/property/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
SELECT DISTINCT * WHERE {
?city dbpedia-owl:country ?country .
?city rdfs:label ?name .
?country rdfs:label '""" + country.name + """'@en .
?city geo:lat ?lat .
?city geo:long ?long .
?city dbpprop:populationTotal ?population .
OPTIONAL {?city dbpedia-owl:abstract ?abstract}
OPTIONAL {?city dbpprop:utcOffset ?timezone}
OPTIONAL {?city dbpprop:utcOffsetDst ?timezone_dst}
FILTER(LANGMATCHES(LANG(?abstract), 'EN'))
FILTER(LANGMATCHES(LANG(?name), 'EN'))
} ORDER BY DESC(?population)
LIMIT 100
""")
#?country rdf:type dbpedia-owl:Country .\
#?city rdf:type dbpedia-owl:PopulatedPlace .
#?city rdf:type dbpedia-owl:City .
# OPTIONAL { ?city dbpprop:janHighC ?janHighC .
# ?city dbpprop:janLowC ?janLowC .
# ?city dbpprop:janMeanC ?janMeanC .
# ?city dbpprop:janPrecipitationDays ?janPrecipitationDays .
# ?city dbpprop:janPrecipitationMm ?janPrecipitationMm .
# ?city dbpprop:janSun ?janSun .
#
# ?city dbpprop:febHighC ?febHighC .
# ?city dbpprop:febLowC ?febLowC .
# ?city dbpprop:febMeanC ?febMeanC .
# ?city dbpprop:febPrecipitationDays ?febPrecipitationDays .
# ?city dbpprop:febPrecipitationMm ?febPrecipitationMm .
# ?city dbpprop:febSun ?febSun .
#
# ?city dbpprop:marHighC ?marHighC .
# ?city dbpprop:marLowC ?marLowC .
# ?city dbpprop:marMeanC ?marMeanC .
# ?city dbpprop:marPrecipitationDays ?marPrecipitationDays .
# ?city dbpprop:marPrecipitationMm ?marPrecipitationMm .
# ?city dbpprop:marSun ?marSun .
#
# ?city dbpprop:aprHighC ?aprHighC .
# ?city dbpprop:aprLowC ?aprLowC .
# ?city dbpprop:aprMeanC ?aprMeanC .
# ?city dbpprop:aprPrecipitationDays ?aprPrecipitationDays .
# ?city dbpprop:aprPrecipitationMm ?aprPrecipitationMm .
# ?city dbpprop:aprSun ?aprSun .
#
# ?city dbpprop:mayHighC ?mayHighC .
# ?city dbpprop:mayLowC ?mayLowC .
# ?city dbpprop:mayMeanC ?mayMeanC .
# ?city dbpprop:mayPrecipitationDays ?mayPrecipitationDays .
# ?city dbpprop:mayPrecipitationMm ?mayPrecipitationMm .
# ?city dbpprop:maySun ?maySun .
#
# ?city dbpprop:junHighC ?junHighC .
# ?city dbpprop:junLowC ?junLowC .
# ?city dbpprop:junMeanC ?junMeanC .
# ?city dbpprop:junPrecipitationDays ?junPrecipitationDays .
# ?city dbpprop:junPrecipitationMm ?junPrecipitationMm .
# ?city dbpprop:junSun ?junSun .
#
# ?city dbpprop:julHighC ?julHighC .
# ?city dbpprop:julLowC ?julLowC .
# ?city dbpprop:julMeanC ?julMeanC .
# ?city dbpprop:julPrecipitationDays ?julPrecipitationDays .
# ?city dbpprop:julPrecipitationMm ?julPrecipitationMm .
# ?city dbpprop:julSun ?julSun .
#
# ?city dbpprop:augHighC ?augHighC .
# ?city dbpprop:augLowC ?augLowC .
# ?city dbpprop:augMeanC ?augMeanC .
# ?city dbpprop:augPrecipitationDays ?augPrecipitationDays .
# ?city dbpprop:augPrecipitationMm ?augPrecipitationMm .
# ?city dbpprop:augSun ?augSun .
#
# ?city dbpprop:sepHighC ?sepHighC .
# ?city dbpprop:sepLowC ?sepLowC .
# ?city dbpprop:sepMeanC ?sepMeanC .
# ?city dbpprop:sepPrecipitationDays ?sepPrecipitationDays .
# ?city dbpprop:sepPrecipitationMm ?sepPrecipitationMm .
# ?city dbpprop:sepSun ?sepSun .
#
# ?city dbpprop:octHighC ?octHighC .
# ?city dbpprop:octLowC ?octLowC .
# ?city dbpprop:octMeanC ?octMeanC .
# ?city dbpprop:octPrecipitationDays ?octPrecipitationDays .
# ?city dbpprop:octPrecipitationMm ?octPrecipitationMm .
# ?city dbpprop:octSun ?octSun .
#
# ?city dbpprop:novHighC ?novHighC .
# ?city dbpprop:novLowC ?novLowC .
# ?city dbpprop:novMeanC ?novMeanC .
# ?city dbpprop:novPrecipitationDays ?novPrecipitationDays .
# ?city dbpprop:novPrecipitationMm ?novPrecipitationMm .
# ?city dbpprop:novSun ?novSun .
#
# ?city dbpprop:decHighC ?decHighC .
# ?city dbpprop:decLowC ?decLowC .
# ?city dbpprop:decMeanC ?decMeanC .
# ?city dbpprop:decPrecipitationDays ?decPrecipitationDays .
# ?city dbpprop:decPrecipitationMm ?decPrecipitationMm .
# ?city dbpprop:decSun ?decSun }
for city in cities:
name = city['name']['value']
print 'Saving information for city', name, ',', country.name
c, created = City.objects.get_or_create(
name=name, defaults={'country': country})
c.description = city['abstract']['value']
c.population = city['population']['value']
c.lat = city['lat']['value']
c.lng = city['long']['value']
c.wikipedia_url = 'http://en.wikipedia.org/w/index.php?title=' + name.replace(
" ", "_") + '&printable=yes'
c.wikitravel_url = 'http://wikitravel.org/wiki/en/index.php?title=' + name.replace(
" ", "_") + '&printable=yes'
c.timezone = getValue(city, 'timezone')
c.timezone_dst = getValue(city, 'timezone_dst')
if fetch_rdf:
c.rdf = ws.getResource(name)
# c.janHighC = getValue(city, 'janHighC')
# c.janLowC = getValue(city, 'janLowC')
# c.janMeanC = getValue(city, 'janMeanC')
# c.janPrecipitationDays = getValue(city, 'janPrecipitationDays')
# c.janPrecipitationMm = getValue(city, 'janPrecipitationMm')
# c.janSun = getValue(city, 'janSun')
#
# c.febHighC = getValue(city, 'febHighC')
# c.febLowC = getValue(city, 'febLowC')
# c.febMeanC = getValue(city, 'febMeanC')
# c.febPrecipitationDays = getValue(city, 'febPrecipitationDays')
# c.febPrecipitationMm = getValue(city, 'febPrecipitationMm')
# c.febSun = getValue(city, 'febSun')
#
# c.marHighC = getValue(city, 'marHighC')
# c.marLowC = getValue(city, 'marLowC')
# c.marMeanC = getValue(city, 'marMeanC')
# c.marPrecipitationDays = getValue(city, 'marPrecipitationDays')
# c.marPrecipitationMm = getValue(city, 'marPrecipitationMm')
# c.marSun = getValue(city, 'marSun')
#
# c.aprHighC = getValue(city, 'aprHighC')
# c.aprLowC = getValue(city, 'aprLowC')
# c.aprMeanC = getValue(city, 'aprMeanC')
# c.aprPrecipitationDays = getValue(city, 'aprPrecipitationDays')
# c.aprPrecipitationMm = getValue(city, 'aprPrecipitationMm')
# c.aprSun = getValue(city, 'aprSun')
#
# c.mayHighC = getValue(city, 'mayHighC')
# c.mayLowC = getValue(city, 'mayLowC')
# c.mayMeanC = getValue(city, 'mayMeanC')
# c.mayPrecipitationDays = getValue(city, 'mayPrecipitationDays')
# c.mayPrecipitationMm = getValue(city, 'mayPrecipitationMm')
# c.maySun = getValue(city, 'maySun')
#
# c.junHighC = getValue(city, 'junHighC')
# c.junLowC = getValue(city, 'junLowC')
# c.junMeanC = getValue(city, 'junMeanC')
# c.junPrecipitationDays = getValue(city, 'junPrecipitationDays')
# c.junPrecipitationMm = getValue(city, 'junPrecipitationMm')
# c.junSun = getValue(city, 'junSun')
#
# c.julHighC = getValue(city, 'julHighC')
# c.julLowC = getValue(city, 'julLowC')
# c.julMeanC = getValue(city, 'julMeanC')
# c.julPrecipitationDays = getValue(city, 'julPrecipitationDays')
# c.julPrecipitationMm = getValue(city, 'julPrecipitationMm')
# c.julSun = getValue(city, 'julSun')
#
# c.augHighC = getValue(city, 'augHighC')
# c.augLowC = getValue(city, 'augLowC')
# c.augMeanC = getValue(city, 'augMeanC')
# c.augPrecipitationDays = getValue(city, 'augPrecipitationDays')
# c.augPrecipitationMm = getValue(city, 'augPrecipitationMm')
# c.augSun = getValue(city, 'augSun')
#
# c.sepHighC = getValue(city, 'sepHighC')
# c.sepLowC = getValue(city, 'sepLowC')
# c.sepMeanC = getValue(city, 'sepMeanC')
# c.sepPrecipitationDays = getValue(city, 'sepPrecipitationDays')
# c.sepPrecipitationMm = getValue(city, 'sepPrecipitationMm')
# c.sepSun = getValue(city, 'sepSun')
#
# c.octHighC = getValue(city, 'octHighC')
# c.octLowC = getValue(city, 'octLowC')
# c.octMeanC = getValue(city, 'octMeanC')
# c.octPrecipitationDays = getValue(city, 'octPrecipitationDays')
# c.octPrecipitationMm = getValue(city, 'octPrecipitationMm')
# c.octSun = getValue(city, 'octSun')
#
# c.novHighC = getValue(city, 'novHighC')
# c.novLowC = getValue(city, 'novLowC')
# c.novMeanC = getValue(city, 'novMeanC')
# c.novPrecipitationDays = getValue(city, 'novPrecipitationDays')
# c.novPrecipitationMm = getValue(city, 'novPrecipitationMm')
# c.novSun = getValue(city, 'novSun')
#
# c.decHighC = getValue(city, 'decHighC')
# c.decLowC = getValue(city, 'decLowC')
# c.decMeanC = getValue(city, 'decMeanC')
# c.decPrecipitationDays = getValue(city, 'decPrecipitationDays')
# c.decPrecipitationMm = getValue(city, 'decPrecipitationMm')
# c.decSun = getValue(city, 'decSun')
c.save()