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: