The aim of this work is to show that it is posible to build an interesting service (at least from my point of view:) ) with open data retrieved from sources of public institutions. This exemplary service facilitates travels and uses public data about countries and cities provided by The United Nations Economic Commission for Europe (UNECE) but it is also enriched with information about restaurants and hostels retrieved from OpenStreetMap . Currently, even when you are no very rich, you can afford traveling the world - there are cheap airlines, you can sleep on someone’s couch for free, find tons of useful tips in the Internet about how to see the world and not being ruined. Nowadays, the problem might be actually where to go for a weekend, for a short trip or for a
gromajus
gromajus
/ hotelsWarsaw.csv
Created
January 31, 2016 18:40
We can make this file beautiful and searchable if this error is corrected: It looks like row 7 should actually have 35 columns, instead of 8. in line 6.
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
| type,id,lat,lon,addr_city,addr_housenumber,addr_street,name,tourism,addr_postcode,contact_email,fax,internet_access,internet_access_fee,operator,phone,smoking,stars,website,wheelchair,building,created_by,email,rooms,amenity,rating,addr_country,source,contact_fax,contact_phone,contact_website,wheelchair_description,source_addr,payment_bitcoin,url | |
| node,179870751,52.2328243,21.0145321,Warszawa,3,Szpitalna,Dipservice,hotel,,,,,,,,,,,,,,,,,,,,,,,,,, | |
| node,179870757,52.2260542,20.9887933,Warszawa,2,Towarowa,Golden Tulip Warsaw Centre,hotel,00-811,info@goldentulipwarsawcentre.com,+48 225827501,yes,no,LOUVRE HOTELS GROUP,+48 225827500,separated,3,http://www.goldentulipwarsawcentre.com,yes,,,,,,,,,,,,,,, | |
| node,262769437,52.1712181,21.0729133,,,,Dipservice,hotel,,,,,,,,,,,,yes,,,,,,,,,,,,,, | |
| node,275037625,52.2552372,21.1057487,,,,Relax,hotel,,,,,,,,,,,,,JOSM,,,,,,,,,,,,, | |
| node,297209705,52.2278522,21.0248477,,,,Sheraton,hotel,,,,,,,,,,,,,,,,,,,,,,,,,, | |
| node,316888381,52.2292219,21.0108941,Warszawa,99a,Marszałkowska,Metropo |
gromajus
/ restaurantsWarsaw.csv
Last active
January 31, 2016 18:18
We can make this file beautiful and searchable if this error is corrected: It looks like row 2 should actually have 86 columns, instead of 5. in line 1.
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
| type,id,lat,lon,addr_city,addr_housenumber,addr_treet,amenity,created_by,name,cuisine,source_addr,old_name,note,loc_name,operator,email,opening_hours,phone,website,source_phone,wheelchair,accor_ticket,addr_postcode,addr_country,fax,url,diet_vegan,diet_vegetarian,contact_phone,contact_website,name_ru,rating,tourism,alt_name,layer,capacity,takeaway,payment_credit_cards,tsmoking,old_cuisine,contact_yelp,payment_bitcoin,diet_gluten_free,source,addr_housename,microbrewery,fixme,note_pl,addr_city_simc,addr_street_sym_ul,internet_access,internet_access_fee,accor_ticket_acceptant,brand,contact_email,posh,FIXME,payment_american_express,payment_contactless,payment_diners_club,payment_iko,payment_maestro,payment_mastercard,payment_visa,payment_visa_electron,gourmet_cheque_acceptant,wifi,contact:fax,designation,sustenance,ele,delivery,name_pl,stars,outdoor_seating,level,ref,official_name,contact_facebook,name_en,addr_district,payment_cash,payment_coins,payment_notes,payment_visa_debit | |
| node,31005854,52.1769081,20.9459496, |
gromajus
/ pubsWarsaw.csv
Last active
January 31, 2016 18:02
We can make this file beautiful and searchable if this error is corrected: It looks like row 6 should actually have 39 columns, instead of 34. in line 5.
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
| type,id,lat,lon,tags/addr:city,tags/addr:housenumber,tags/addr:street,tags/amenity,tags/name,tags/layer,tags/addr:postcode,tags/note,tags/website,tags/wheelchair,tags/opening_hours,tags/phone,tags/addr:country,tags/addr:housename,tags/wifi,tags/cuisine,tags/old_name,tags/internet_access,tags/contact:email,tags/contact:phone,tags/contact:website,tags/smoking,tags/email,tags/fax,tags/source:addr,tags/source,tags/level,tags/note:pl,tags/ref,tags/billard:pool,tags/billard:snooker,tags/sport,tags/opening_hours:url,tags/addr:city:simc,tags/addr:street:sym_ul | |
| node,248569875,52.2100746,21.006417,Warszawa,177,Aleja Niepodległości,pub,Zielona Gęś,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | |
| node,270200245,52.2430734,21.1028844,,,,pub,Dziwny Świat Edwarda M.,1,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | |
| node,271844520,52.2299971,20.9786243,,,,pub,Królewski,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | |
| node,280333661,52.1737068,21.0449539,,,,pub,Szopa-Grill,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, | |
| node,286630380,52.2599408,21.0527167,,,,pub,Ultrafiolet,,,,,,,,,,,,,,,,,,,,,,,,, |
gromajus
/ countries.csv
Created
January 29, 2016 18:36
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
| CountryCode | CountryName | |
|---|---|---|
| ES | Spain | |
| FR | France | |
| IT | Italy | |
| PL | Poland | |
| PT | Portugal | |
| GB | United Kingdom | |
| US | United States |
gromajus
/ cities.csv
Last active
January 29, 2016 20:06
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
| +/- | CountryCode | CityCode | CityName | CityNameNoSpecialChars | RegionCode | Coordinates | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ES | BCN | Barcelona | Barcelona | 12345--- | AI | 9601 | ||||||
| ES | MAD | Madrid | Madrid | ---45--- | AI | 9506 | ||||||
| ES | SVQ | Sevilla | Sevilla | 12345--- | AI | 9601 | ||||||
| ES | BIO | Bilbao | Bilbao | BI | 12345--- | AI | 1307 | 4315N 00258W | ||||
| FR | PAR | Paris | Paris | 75 | 123-5--- | AF | 9501 | |||||
| + | FR | 2JR | Avignon | Avignon | 39 | --3----- | RL | 1507 | 4624N 00550E | |||
| FR | NCE | Nice | Nice | 06 | 12-45--- | AF | 9501 | |||||
| FR | LIO | Lyon | Lyon | 69 | 12345--- | AF | 9506 | LYS | ||||
| FR | MRS | Marseille | Marseille | 13 | 12-45--- | AF | 0212 | 4318N 00524E |
gromajus
/ subdiv.csv
Last active
January 29, 2016 19:31
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
| CountryCode | RegionCode | RegionName | RegionType | |
|---|---|---|---|---|
| ES | BI | Biskaia | Province | |
| FR | 06 | Alpes-Maritimes | Metropolitan department | |
| FR | 13 | Bouches-du-Rhône | Metropolitan department | |
| FR | 39 | Jura | Metropolitan department | |
| FR | 66 | Pyrénées-Orientales | Metropolitan department | |
| FR | 69 | Rhône | Metropolitan department | |
| FR | 75 | Paris | Metropolitan department | |
| GB | CRF | Cardiff [Caerdydd GB-CRD] | Unitary authority | |
| GB | GLG | Glasgow City | Council area |
gromajus
/ travelHelper.adoc
Last active
October 27, 2016 09:16
gromajus
/ books.adoc
Last active
January 17, 2016 18:16
The aim of this graphgist is to order the information about books. The idea can be used by books management systems, content recommendations systems, etc. Firstly, the designed data model is presented. Next, exemplary data is loaded and exemplary cipher queries run to show the applications of this model.
gromajus
/ food_recommendation_system.adoc
Last active
January 11, 2016 15:55