translations = {
"en": {
"name": "Daycare"
},
"de": {
"name": "Kindertagesstätten"
},
"ar": {
"name": "الرعاية النهارية"
},
"fr": {
"name": "Garderie"
}
}
category_id, category = get_or_create_category("kitas", translations)
entries_to_delete = POI.objects.filter(categories=category).all()
import pdb
pdb.set_trace()
entries_to_delete.delete()
with open("kitas.csv", encoding='latin-1') as csvfile:
with open("kitas_kaputt.csv", "w", encoding="latin-1") as errorfile:
csvreader = csv.reader(csvfile, delimiter=';')
csvwriter = csv.writer(
errorfile,
delimiter=';',
quotechar='"',
)
next(csvreader, None) # skip header
for row in csvreader:
import requests
import random
import csv
from os import sys, path; sys.path.append(path.dirname(path.dirname(path.abspath(__file__))))
import django
django.setup()
from tools import gemeinden, get_or_create_category
from backend.models import POI, POICategory
from backend.serializers import POISerializer
translations = {"en":{"name":"Daycare"},"de":{"name":"Kindertagesstätten"},"ar":{"name":"الرعاية النهارية"},"fr":{"name":"Garderie"}}
category_id, category = get_or_create_category("kitas", translations)
entries_to_delete = POI.objects.filter(categories=category).all()
import pdb;pdb.set_trace()
entries_to_delete.delete()
with open("kitas.csv", encoding='latin-1') as csvfile:
with open("kitas_kaputt.csv", "w", encoding="latin-1") as errorfile:
csvreader = csv.reader(csvfile, delimiter=';')
csvwriter = csv.writer(errorfile, delimiter=';',quotechar='"',)
next(csvreader, None) # skip header
for row in csvreader:
req = requests.get("http://nominatim.germany-says-welcome.de/search/{1}, {2}?format=json&addressdetails=1".format(*row))
data = req.json()
if len(data) > 1:
for item in data:
if item["type"] == "kindergarten":
data = item
break
else:
print("Search for {1}, {2} gave more than one result of which none was a kindergarten.".format(*row))
translations = {
"en": {
"name": "Correspondents of trafficking"
},
"de": {
"name": "Anlaufstellen bei Menschenhandel"
},
"ar": {
"name": "مراسلي الاتجار"
},
"fr": {
"name": "Correspondants de la traite"
}
}
category_id, category = get_or_create_category("erstaufnameeinrichtungen",
translations)
entries_to_delete = POI.objects.filter(categories=category).all()
entries_to_delete.delete()
with open("erstaufnameeinrichtungen.csv", encoding='latin-1') as csvfile:
with open("erstaufnameeinrichtungen_kaputt.csv", "w",
encoding="latin-1") as errorfile:
csvreader = csv.reader(csvfile, delimiter=';')
csvwriter = csv.writer(
errorfile,
delimiter=';',
quotechar='"',
)
next(csvreader, None) # skip header
next(csvreader, None) # skip emptry line
for row in csvreader:
import requests
import random
import csv
from os import sys, path; sys.path.append(path.dirname(path.dirname(path.abspath(__file__))))
import django
django.setup()
from tools import gemeinden, get_or_create_category
from backend.models import POI, POICategory
from backend.serializers import POISerializer
translations = {"en":{"name":"Correspondents of trafficking"},"de":{"name":"Anlaufstellen bei Menschenhandel"},"ar":{"name":"مراسلي الاتجار"},"fr":{"name":"Correspondants de la traite"}}
category_id, category = get_or_create_category("erstaufnameeinrichtungen", translations)
entries_to_delete = POI.objects.filter(categories=category).all()
entries_to_delete.delete()
with open("erstaufnameeinrichtungen.csv", encoding='latin-1') as csvfile:
with open("erstaufnameeinrichtungen_kaputt.csv", "w", encoding="latin-1") as errorfile:
csvreader = csv.reader(csvfile, delimiter=';')
csvwriter = csv.writer(errorfile, delimiter=';',quotechar='"',)
next(csvreader, None) # skip header
next(csvreader, None) # skip emptry line
for row in csvreader:
req = requests.get("http://nominatim.germany-says-welcome.de/search/{1}?format=json&addressdetails=1".format(*row))
data = req.json()
if len(data) < 1:
print("Search for {0}, {1} gave less than one result.".format(*row))
csvwriter.writerow(row)
continue
else:
data = data[0]
if 'county' in data['address'] and data['address']['county'] in gemeinden:
