Transcript
![Page 1: Download data from OSM - bigdata.eestec.hu · test zope.intefface estimate example GoogleApi OSM API OSM API GOOGL... pandas_geopandas sklearn Create Import Featured Notebooks Introduction](https://reader031.vdocuments.us/reader031/viewer/2022040113/5d485ee988c99397108b73e0/html5/thumbnails/1.jpg)
Download data from OSM
http://www.openstreetmap.org/export#map=14/46.9606/17.8917
![Page 2: Download data from OSM - bigdata.eestec.hu · test zope.intefface estimate example GoogleApi OSM API OSM API GOOGL... pandas_geopandas sklearn Create Import Featured Notebooks Introduction](https://reader031.vdocuments.us/reader031/viewer/2022040113/5d485ee988c99397108b73e0/html5/thumbnails/2.jpg)
Open in QGIS
![Page 3: Download data from OSM - bigdata.eestec.hu · test zope.intefface estimate example GoogleApi OSM API OSM API GOOGL... pandas_geopandas sklearn Create Import Featured Notebooks Introduction](https://reader031.vdocuments.us/reader031/viewer/2022040113/5d485ee988c99397108b73e0/html5/thumbnails/3.jpg)
Set the coding to utf-8
Save as shp format, and set the crs to EOV (EPSG:23700 -- HD72)
Double click
![Page 4: Download data from OSM - bigdata.eestec.hu · test zope.intefface estimate example GoogleApi OSM API OSM API GOOGL... pandas_geopandas sklearn Create Import Featured Notebooks Introduction](https://reader031.vdocuments.us/reader031/viewer/2022040113/5d485ee988c99397108b73e0/html5/thumbnails/4.jpg)
Add x, y to the attributes
![Page 5: Download data from OSM - bigdata.eestec.hu · test zope.intefface estimate example GoogleApi OSM API OSM API GOOGL... pandas_geopandas sklearn Create Import Featured Notebooks Introduction](https://reader031.vdocuments.us/reader031/viewer/2022040113/5d485ee988c99397108b73e0/html5/thumbnails/5.jpg)
Save as .csv format
Right click
Save it!!
![Page 6: Download data from OSM - bigdata.eestec.hu · test zope.intefface estimate example GoogleApi OSM API OSM API GOOGL... pandas_geopandas sklearn Create Import Featured Notebooks Introduction](https://reader031.vdocuments.us/reader031/viewer/2022040113/5d485ee988c99397108b73e0/html5/thumbnails/6.jpg)
![Page 7: Download data from OSM - bigdata.eestec.hu · test zope.intefface estimate example GoogleApi OSM API OSM API GOOGL... pandas_geopandas sklearn Create Import Featured Notebooks Introduction](https://reader031.vdocuments.us/reader031/viewer/2022040113/5d485ee988c99397108b73e0/html5/thumbnails/7.jpg)
Open Databricks Community edition and create a New Library
In the new library create a new notebook:
![Page 8: Download data from OSM - bigdata.eestec.hu · test zope.intefface estimate example GoogleApi OSM API OSM API GOOGL... pandas_geopandas sklearn Create Import Featured Notebooks Introduction](https://reader031.vdocuments.us/reader031/viewer/2022040113/5d485ee988c99397108b73e0/html5/thumbnails/8.jpg)
Create a cluster
import pandas as pd //shift +enter
after attach and run
![Page 9: Download data from OSM - bigdata.eestec.hu · test zope.intefface estimate example GoogleApi OSM API OSM API GOOGL... pandas_geopandas sklearn Create Import Featured Notebooks Introduction](https://reader031.vdocuments.us/reader031/viewer/2022040113/5d485ee988c99397108b73e0/html5/thumbnails/9.jpg)
Now upload the csv
![Page 10: Download data from OSM - bigdata.eestec.hu · test zope.intefface estimate example GoogleApi OSM API OSM API GOOGL... pandas_geopandas sklearn Create Import Featured Notebooks Introduction](https://reader031.vdocuments.us/reader031/viewer/2022040113/5d485ee988c99397108b73e0/html5/thumbnails/10.jpg)
Remember that path: /FileStore/tables/gid344kh1505477182944/balatonfured_points.csv
balatonfured
=pd.read_csv("/dbfs/FileStore/tables/gid344kh1505477182944/balatonfured_points.csv")
balatonfured.head()