select json_build_object('id', gs.id, 'cid', gs.cid, 'street', gs.street, 'lat', gs.lat, 'lng', gs.lng, 'zip',gc.zip, 'city',gc.city, 'country',gc.country, 'citizen',gc.citizen, 'county',gc.county, 'state',gc.state, 'district',gc.district) from geostreets as gs join geocities as gc on gs.cid = gc.id limit 1;
Open Data Coder p3t3r67x0
p3t3r67x0
/ elasticsearch_settings.json
Last active
November 28, 2018 09:34
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "settings": { | |
| "number_of_shards": 1, | |
| "analysis": { | |
| "filter": { | |
| "ngram_filter": { | |
| "type": "edge_ngram", | |
| "min_gram": 1, | |
| "max_gram": 20 | |
| } |
p3t3r67x0
/ postgressql_queries.md
Created
November 25, 2018 22:53
p3t3r67x0
/ germany_zip_codes.csv
Last active
November 23, 2018 09:12
We can't make this file beautiful and searchable because it's too large.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 01945 Hermsdorf Brandenburg Landkreis Oberspreewald-Lausitz 13.8937 51.4055 | |
| 01945 Schwarzbach Brandenburg Landkreis Oberspreewald-Lausitz 13.9333 51.45 | |
| 01945 Ruhland Brandenburg Landkreis Oberspreewald-Lausitz 13.8664 51.4576 | |
| 01945 Lindenau Brandenburg Landkreis Oberspreewald-Lausitz 13.7333 51.4 | |
| 01945 Hohenbocka Brandenburg Landkreis Oberspreewald-Lausitz 14.0098 51.431 | |
| 01945 Guteborn Brandenburg Landkreis Oberspreewald-Lausitz 13.9333 51.4167 | |
| 01945 Tettau Brandenburg Landkreis Oberspreewald-Lausitz 13.7333 51.4333 | |
| 01945 Kroppen Brandenburg Landkreis Oberspreewald-Lausitz 13.8 51.3833 | |
| 01945 Grünewald Brandenburg Landkreis Oberspreewald-Lausitz 14 51.4 | |
| 01968 Schipkau Brandenburg Landkreis Oberspreewald-Lausitz 13.9121 51.5456 |
p3t3r67x0
/ ort_plz_landkreis_bundesland.csv
Created
November 21, 2018 11:42
We can't make this file beautiful and searchable because it's too large.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Aach,78267,Landkreis Konstanz,Baden-Württemberg | |
| Aach,54298,Landkreis Trier-Saarburg,Rheinland-Pfalz | |
| Aachen,52062,Städteregion Aachen,Nordrhein-Westfalen | |
| Aachen,52064,Städteregion Aachen,Nordrhein-Westfalen | |
| Aachen,52066,Städteregion Aachen,Nordrhein-Westfalen | |
| Aachen,52068,Städteregion Aachen,Nordrhein-Westfalen | |
| Aachen,52070,Städteregion Aachen,Nordrhein-Westfalen | |
| Aachen,52072,Städteregion Aachen,Nordrhein-Westfalen | |
| Aachen,52074,Städteregion Aachen,Nordrhein-Westfalen | |
| Aachen,52076,Städteregion Aachen,Nordrhein-Westfalen |
p3t3r67x0
/ staedte_bevoelkerung_deutschland.csv
Created
November 20, 2018 17:34
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Berlin | 10178 | 3613495 | |
|---|---|---|---|
| Hamburg | 20038 | 1830584 | |
| München | 80313 | 1456039 | |
| Köln | 50667 | 1080394 | |
| Frankfurt am Main | 60311 | 746878 | |
| Stuttgart | 70173 | 632743 | |
| Düsseldorf | 40213 | 617280 | |
| Dortmund | 44135 | 586600 | |
| Essen | 45127 | 583393 | |
| Leipzig | 04109 | 581980 |
p3t3r67x0
/ delmenhorst_strassen.csv
Last active
November 20, 2018 16:21
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| plz | strassenname | |
|---|---|---|
| 27755 | Aarhuser Straße | |
| 27755 | Abernettistraße | |
| 27755 | Achimer Straße | |
| 27751 | Achternweg | |
| 27751 | Ackerstraße | |
| 27753 | Adalbert-Stifter-Straße | |
| 27753 | Adalbert-Stifter-Straße | |
| 27755 | Adelheider Straße | |
| 27755 | Adelheider Straße |
p3t3r67x0
/ german_zip_codes.csv
Created
November 19, 2018 20:25
We can't make this file beautiful and searchable because it's too large.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Baden-Württemberg 64754 Eberbach (Baden) | |
| Baden-Württemberg 68159 Jungbusch | |
| Baden-Württemberg 68159 Mannheim | |
| Baden-Württemberg 68161 Schwetzingerstadt | |
| Baden-Württemberg 68161 Mannheim | |
| Baden-Württemberg 68161 Oststadt | |
| Baden-Württemberg 68163 Neuostheim | |
| Baden-Württemberg 68163 Lindenhof | |
| Baden-Württemberg 68163 Mannheim | |
| Baden-Württemberg 68163 Neuhermsheim |
p3t3r67x0
/ apotheken.txt
Created
November 12, 2018 07:55
This file has been truncated, but you can view the full file.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Gutenberg-Apotheke | |
| Düpheid 24/ Ladenzentrum | |
| 22149 Hamburg | |
| 040/6725758 | |
| Schimmelreiter-Apotheke | |
| Hegeneck 5 | |
| 22149 Hamburg | |
| 040/6723838 |
p3t3r67x0
/ aknr_scraper.py
Last active
November 12, 2018 18:45
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/usr/bin/env python | |
| import sys | |
| import uuid | |
| import requests | |
| from lxml import html | |
| from sqlalchemy import create_engine, Column, Integer, String, UniqueConstraint | |
| from sqlalchemy.ext.declarative import declarative_base | |
| from sqlalchemy.exc import IntegrityError |
p3t3r67x0
/ german_zip_codes.json
Created
November 5, 2018 19:36
This file has been truncated, but you can view the full file.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| [ | |
| { | |
| "boundingbox": [ | |
| "51.0534001144", | |
| "51.0535001144", | |
| "13.726116130257", | |
| "13.726216130257" | |
| ], | |
| "lat": "51.0534501143995", | |
| "lon": "13.7261661302568", |