Researching GIS data with PostGIS and adjacent toolset
Nowadays one can make a decent urban research based simply on public datasets, making interesting and unexpected insights. In the presentation, I'll show examples of these calculations in PostGIS, the industry standard de-facto.
But just PostGIS is not enough. You need tools to import, verify and visualize the data. It's critically important to visualize the data live, to debug your calculations and shorten iterations. I'll describe all these steps:
- Collecting the data: public API, OpenStreetMap; direct user input.
- 3rd party APIs for calculations.
- Visualization of GIS and other sorts of data: QGIS, Matplotlib, Zeppelin integrated with PostGIS.
- Debugging the calculations: live visualization (Arc, QGIS, NextGIS Web)
- Scripting and minimizing the chores: Makefile, Gulp
Слайды
Видео
Другие доклады
-
22 мин
Sergey Mirvoda ООО Октоника, УрФУData analysis for all. Developing BI system, working on limited and even shared hardware
Experience we've got after 5 years of developing, deploying and improving BI system http://colibri365.ru used in government. I would talk about government IT reality and our way over it. Postgres performance improvements, using of latest features, overwriting of user generated queries to help query optimizer and other tweaks and hacks to tackle limited hardware problems. These lead us to number of computer science papers and (now committed) patches to Postgres (see Andrey Borodin talks for details).
VIDEO
-
22 мин
Michael Shurutov СтандартПроектAutonomous transactions in Postgres
- What is an autonomous transaction?
- An overview of autonomous transactions in "big" DBMS: Oracle.
- Autonomous transaction logic in Postgres Pro.
- An overview of emulation methods for autonomous transactions in PostgreSQL.
- Comparing performance of the built-in Postgres Pro autonomous transaction mechanism and PostgreSQL emulation methods.
VIDEO
-
45 мин
Dmitry Belyavskiy ТЦИCryptography in RDBMS
Real-word data often need cryptographycal protection. The presentation describes typical problems that can be solved using cryptographycal methods and the right ways to use cryptography with RDBMS. The newest solutions suggested for usage with PostgreSQL are described.
VIDEO
-
45 мин
Darafei Praliaskouski JunoPostGIS for moving targets
PostGIS enables spatial processing in Postgres. Usually PostGIS is used for planar euclidean calculations, but real world adds time, ambiguity and uncertainty. We'll have a look on making a thousand of cars move smoothly in real time on OpenStreetMap base map.
VIDEO