{"guid":"a8fbf537-cbe1-5f17-aa73-97d64132f660","title":"3.6 million points to polygons – lessons learned while generating voting districts with QGIS, PostGIS and OpenJUMP?","subtitle":null,"slug":"bucharest-189-3-6-million-points-to-polygons-lessons-learned-while-generating-voting-districts-with-qgis-postgis-and-openjump-","link":"https://talks.2019.foss4g.org/bucharest/talk/KXWQEV/","description":"Parliamentary elections were held in Finland in April 2019 and to better visualize the results, I went on a quest to generate polygons for each of the 1937 voting districts. Voting district polygons are not open data except for few major cities, but address points for buildings are open data in Finland and they also have information about which voting district each address belongs to. The talk aims to give examples and tips of how to work with bigger datasets with OSGeo tools and how to deal with errors and uncertainties in your data analysis.\n\nNone","original_language":"eng","persons":["Topi Tjukanov"],"tags":["bucharest","189","2019","General"],"view_count":160,"promoted":false,"date":"2019-08-29T00:00:00.000+02:00","release_date":"2019-08-30T02:00:00.000+02:00","updated_at":"2025-11-11T23:30:06.516+01:00","length":1341,"duration":1341,"thumb_url":"https://static.media.ccc.de/media/conferences/foss4g2019/189-hd.jpg","poster_url":"https://static.media.ccc.de/media/conferences/foss4g2019/189-hd_preview.jpg","timeline_url":"https://static.media.ccc.de/media/conferences/foss4g2019/189-hd.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/conferences/foss4g2019/189-hd.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/bucharest-189-3-6-million-points-to-polygons-lessons-learned-while-generating-voting-districts-with-qgis-postgis-and-openjump-","url":"https://api.media.ccc.de/public/events/a8fbf537-cbe1-5f17-aa73-97d64132f660","conference_title":"FOSS4G 2019","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019","related":[{"event_id":7465,"event_guid":"d2b2bdd0-36fa-5ae1-aba0-a38960010e3b","weight":4},{"event_id":7466,"event_guid":"98c0417b-cdfd-57b3-9411-14f9f465f5b9","weight":4},{"event_id":7467,"event_guid":"df17d333-e410-5e1f-a31c-42805b52b53c","weight":7},{"event_id":7473,"event_guid":"feda735f-5467-56f0-9ddf-55cefdf60199","weight":3},{"event_id":7487,"event_guid":"6f1b8b15-b44a-592c-b3e9-96bd9e0fbce3","weight":8},{"event_id":7488,"event_guid":"0a3e23aa-d593-58cd-a3a1-7991e3a3a064","weight":3},{"event_id":7504,"event_guid":"c54aa667-78de-55fb-85e7-60f2eaffd2a4","weight":6},{"event_id":7522,"event_guid":"74922ed0-86dd-5568-98fb-6fc812852441","weight":20},{"event_id":7526,"event_guid":"fd5614a8-535f-5069-8f69-3a9983d37830","weight":5},{"event_id":7552,"event_guid":"4c2f4b81-1316-502d-870c-dc39567b782e","weight":8},{"event_id":7579,"event_guid":"0112454d-62b2-5132-8971-73c7fdb972d0","weight":11},{"event_id":7607,"event_guid":"d0794cae-d707-584c-8879-6c438a603486","weight":6},{"event_id":7624,"event_guid":"69079f64-448d-55b5-9cb3-7089547c370d","weight":7},{"event_id":7629,"event_guid":"43e2163d-d0f7-5b45-945b-25dd8c57118b","weight":5},{"event_id":7652,"event_guid":"e04c27d0-8ff8-5bf4-b932-34db4e4fdf5b","weight":7},{"event_id":7663,"event_guid":"1b265f5f-a622-52e0-a2a4-88105aa09aba","weight":2},{"event_id":7667,"event_guid":"4bc8bbe5-cb04-5a2b-b441-a696be055948","weight":7},{"event_id":7681,"event_guid":"a1326956-88be-5af4-b747-5cefc95e8232","weight":6},{"event_id":7692,"event_guid":"3c0ea464-ce0e-5676-a977-075148d7bbdd","weight":5},{"event_id":7733,"event_guid":"0ba5c644-2353-5225-972e-6e3958f74f3e","weight":6},{"event_id":7756,"event_guid":"c4299de5-e39e-576d-93bb-7ae47fee42af","weight":5}],"recordings":[{"size":129,"length":1341,"mime_type":"video/mp4","language":"eng","filename":"bucharest-189-eng-36_million_points_to_polygons_-_lessons_learned_while_generating_voting_districts_with_QGIS_PostGIS_and_OpenJUMP_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2019-08-30T14:26:45.999+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/h264-hd/bucharest-189-eng-36_million_points_to_polygons_-_lessons_learned_while_generating_voting_districts_with_QGIS_PostGIS_and_OpenJUMP_hd.mp4","url":"https://api.media.ccc.de/public/recordings/39047","event_url":"https://api.media.ccc.de/public/events/a8fbf537-cbe1-5f17-aa73-97d64132f660","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":20,"length":1341,"mime_type":"audio/mpeg","language":"eng","filename":"bucharest-189-eng-36_million_points_to_polygons_-_lessons_learned_while_generating_voting_districts_with_QGIS_PostGIS_and_OpenJUMP_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2019-08-30T14:35:47.053+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/mp3/bucharest-189-eng-36_million_points_to_polygons_-_lessons_learned_while_generating_voting_districts_with_QGIS_PostGIS_and_OpenJUMP_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/39077","event_url":"https://api.media.ccc.de/public/events/a8fbf537-cbe1-5f17-aa73-97d64132f660","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":12,"length":1341,"mime_type":"audio/opus","language":"eng","filename":"bucharest-189-eng-36_million_points_to_polygons_-_lessons_learned_while_generating_voting_districts_with_QGIS_PostGIS_and_OpenJUMP_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2019-08-30T14:36:39.757+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/opus/bucharest-189-eng-36_million_points_to_polygons_-_lessons_learned_while_generating_voting_districts_with_QGIS_PostGIS_and_OpenJUMP_opus.opus","url":"https://api.media.ccc.de/public/recordings/39079","event_url":"https://api.media.ccc.de/public/events/a8fbf537-cbe1-5f17-aa73-97d64132f660","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":44,"length":1341,"mime_type":"video/mp4","language":"eng","filename":"bucharest-189-eng-36_million_points_to_polygons_-_lessons_learned_while_generating_voting_districts_with_QGIS_PostGIS_and_OpenJUMP_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2019-08-30T14:39:21.619+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/h264-sd/bucharest-189-eng-36_million_points_to_polygons_-_lessons_learned_while_generating_voting_districts_with_QGIS_PostGIS_and_OpenJUMP_sd.mp4","url":"https://api.media.ccc.de/public/recordings/39086","event_url":"https://api.media.ccc.de/public/events/a8fbf537-cbe1-5f17-aa73-97d64132f660","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":61,"length":1341,"mime_type":"video/webm","language":"eng","filename":"bucharest-189-eng-36_million_points_to_polygons_-_lessons_learned_while_generating_voting_districts_with_QGIS_PostGIS_and_OpenJUMP_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2019-08-30T14:43:10.844+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/webm-sd/bucharest-189-eng-36_million_points_to_polygons_-_lessons_learned_while_generating_voting_districts_with_QGIS_PostGIS_and_OpenJUMP_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/39096","event_url":"https://api.media.ccc.de/public/events/a8fbf537-cbe1-5f17-aa73-97d64132f660","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":169,"length":1341,"mime_type":"video/webm","language":"eng","filename":"bucharest-189-eng-36_million_points_to_polygons_-_lessons_learned_while_generating_voting_districts_with_QGIS_PostGIS_and_OpenJUMP_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2019-08-30T14:55:11.211+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/webm-hd/bucharest-189-eng-36_million_points_to_polygons_-_lessons_learned_while_generating_voting_districts_with_QGIS_PostGIS_and_OpenJUMP_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/39118","event_url":"https://api.media.ccc.de/public/events/a8fbf537-cbe1-5f17-aa73-97d64132f660","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"}]}