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
/ delmenhorst_strassen.csv
Last active
November 20, 2018 16:21
This file contains hidden or 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
/ staedte_bevoelkerung_deutschland.csv
Created
November 20, 2018 17:34
This file contains hidden or 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
/ 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 hidden or 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
/ 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 hidden or 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
/ postgressql_queries.md
Created
November 25, 2018 22:53
p3t3r67x0
/ elasticsearch_settings.json
Last active
November 28, 2018 09:34
This file contains hidden or 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
/ berlin_city_districts.geojson
Last active
December 4, 2018 22:56
The source can be downloaded from https://www.statistik-berlin-brandenburg.de/produkte/opendata/geometrienOD.asp?Kat=6301
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
p3t3r67x0
/ hamburg_city_districts.geojson
Created
December 4, 2018 23:01
Hamburg Germany multipolygon city districts geojson file.
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
p3t3r67x0
/ duesseldorf_city_districts.geojson
Created
December 5, 2018 15:37
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
p3t3r67x0
/ frankfurt_am_main_city_districts.geojson
Created
December 7, 2018 20:10
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.