sefa bugra ozen
I am 32 years old. I studied Geomatics Engineering at Yıldız Technical University(2010-2014) in Istanbul. I have been working at geographical information technologies department in the General Directorate of Highways Turkiye for 5 years(2017-...). I like Open Source and I using QGIS, GeoServer, PostgreSQL (PostGIS) and MapProxy in my department for data visualization, analysis, management and publishing and create topographics maps. I started new to Python and Jupyter Notebook for data science.
Sessions
Traffic Safety Application:
In the data preprocessing phase, data quality assessment and dirty data were determined on the accident data by using desktop GIS applications such as QGIS,SAGAGIS,JOSM,GeoDa. OpenSource GIS applications and programming languages such as R language and python were used in data cleaning, exploratory analysis and data processing. Statistics for accident data have been extracted. OpenSource map server such as GeoServer is used for sharing, editing and organizing accident maps and base maps produced in GIS applications.
Python software language was used in the server side of the project. For geospatial data analysis, accident points were verified by using geopandas and shapely libraries. PostgreSQL database was used to store geo-based accident data and the PostGIS extension was used. PostGIS adds spatial capabilities to PostgreSQL so it can store, query, and manipulate spatial data. On the server side scripting, GeoAlchemy(an extension of SQLAlchemy) is used for working with spatial databases and geospatial queries.
For the client side, Turf was used for any spatial operations. It is a geospatial engine, and it includes spatial operations and helper functions. MapboxGL-WebGL-powered library is used for interactive vector maps on the web application. To render more than 100k of accidents with high performance, WebGL powered geospatial visualization framework DeckGL was used. NebulaGL provides geospatial drawing and editing tools for lines, polygons etc. It was added for selecting analysis regions from the map. Osm-Nominatim is a geocoding library. It allows users to find accident locations from an address.
OpenSource GIS Tools:
● GIS software for data visualization, processing and analysis:
QGIS, GRASSGIS, JOSM, SAGAGIS, OrbisGIS
● GIS Servers: GeoServer, MapServer, Mapnik, MapGuide, QGIS Server
● Backend(Python) :Geopandas, Shapely, Postgis
● Client(Javascript) :Turf, DeckGL, osm-nominatim
Asset Management Application:
With the “Image-Based Information Management System” Application, it is work to make an information management system and Digital 3D road inventory map for the 91,126km road network under the responsibility of the General Directorate of Highways. With this project, it is possible ensured that images (approximately 21 million) of the highway are taken and the collection, digitization, storage and presentation of the road information of the objects base and the realization of asset management, maintenance services, planning, project design, measurement and evaluation processes determined by the administration through the image.
OpenSource GIS Tools:
● GIS software for data visualization, processing and analysis: QGIS
● GIS Servers: GeoServer
● Backend :Postgis, Turf, @swimlane/ngx-charts
● Client :OpenLayers
Results:
• Data in semi HD map quality was produced.
• The entire road network can be monitored and analyzed with panoramic images.
• The vertical and horizontal profile of the entire highways network has been created.
• 2.995.845 point inventories and 991.820km line inventories in 42 inventory were produced.
• Detection of inventory deficiencies in the field and maintenance processes can be followed.
• Road inventory data needed can be shared with other public institutions.