{"guid":"3f476837-4583-53e9-8ddf-eb940720a469","title":"A COG In The Machine - Using Cloud Optimised GeoTiffs to Query 24 Billion Pixels In Real-Time","subtitle":null,"slug":"bucharest-258-a-cog-in-the-machine-using-cloud-optimised-geotiffs-to-query-24-billion-pixels-in-real-time","link":"https://talks.2019.foss4g.org/bucharest/talk/SQF7YK/","description":"How do you find one pixel in a billion? \n\nCloud Optimized GeoTiffs are a new standard for raster data that support file-level access via the internet. Combined with serverless cloud technologies, raster data can now be queried by client-facing applications without the need for a spatial database or specialist server software. \n\nIn this talk I present how we used COGs and serverless to build a fast and scalable application to query large raster data using point and polygon geometries. As well as providing an overview of the solution architecture, I’ll explore the challenges we face with large raster data and why we chose to develop the solution using these open source standards and technologies.\n\nNone","original_language":"eng","persons":["Tomas Holderness"],"tags":["bucharest","258","2019","General"],"view_count":197,"promoted":false,"date":"2019-08-30T00:00:00.000+02:00","release_date":"2019-08-30T02:00:00.000+02:00","updated_at":"2026-01-28T14:30:09.897+01:00","length":1704,"duration":1704,"thumb_url":"https://static.media.ccc.de/media/conferences/foss4g2019/258-hd.jpg","poster_url":"https://static.media.ccc.de/media/conferences/foss4g2019/258-hd_preview.jpg","timeline_url":"https://static.media.ccc.de/media/conferences/foss4g2019/258-hd.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/conferences/foss4g2019/258-hd.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/bucharest-258-a-cog-in-the-machine-using-cloud-optimised-geotiffs-to-query-24-billion-pixels-in-real-time","url":"https://api.media.ccc.de/public/events/3f476837-4583-53e9-8ddf-eb940720a469","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":1},{"event_id":7467,"event_guid":"df17d333-e410-5e1f-a31c-42805b52b53c","weight":4},{"event_id":7473,"event_guid":"feda735f-5467-56f0-9ddf-55cefdf60199","weight":2},{"event_id":7477,"event_guid":"9227fcf3-b7b2-5a7a-b135-3e7a18341a82","weight":2},{"event_id":7492,"event_guid":"f65e1c2f-8bde-5c89-a128-e113b0b9a3f6","weight":5},{"event_id":7514,"event_guid":"0d63b0b4-259d-5114-8c8f-18604b514f7d","weight":1},{"event_id":7515,"event_guid":"b744af16-2f4c-5151-bca1-91449f719965","weight":1},{"event_id":7517,"event_guid":"ef1a3ce2-61bf-53e1-8f97-acb738c219f9","weight":1},{"event_id":7518,"event_guid":"8773035b-d16c-5cf3-902d-43abc7e5dab7","weight":1},{"event_id":7523,"event_guid":"a95cf31f-07d2-5255-bfa2-6fb38923a15f","weight":1},{"event_id":7524,"event_guid":"f58c39cb-2250-51b5-8902-d52f713c934b","weight":2},{"event_id":7526,"event_guid":"fd5614a8-535f-5069-8f69-3a9983d37830","weight":1},{"event_id":7545,"event_guid":"726938bf-af52-5c0e-9198-0053eba64726","weight":1},{"event_id":7552,"event_guid":"4c2f4b81-1316-502d-870c-dc39567b782e","weight":2},{"event_id":7557,"event_guid":"ab693aa0-5ac8-533f-aeca-a8d39a36e86c","weight":1},{"event_id":7561,"event_guid":"1125685c-9fdc-5572-89c0-8bc80c7df3e0","weight":3},{"event_id":7569,"event_guid":"a85d6273-42ec-54fe-b60d-541c068ccc1d","weight":1},{"event_id":7573,"event_guid":"347ab764-8ae3-58fe-87a0-18dca9880c63","weight":3},{"event_id":7586,"event_guid":"a3b80975-a3ab-5bd3-bcb8-b92f03e007c7","weight":1},{"event_id":7590,"event_guid":"0bdb57e7-edb8-50e8-a60e-4ec5480e14b9","weight":5},{"event_id":7598,"event_guid":"1a86892c-4740-5da9-9c01-f6781f3edc22","weight":1},{"event_id":7604,"event_guid":"b0001b70-6e5d-50e1-aaa4-51345e1d7a65","weight":1},{"event_id":7620,"event_guid":"d1d383f0-dca2-5708-8555-bd5f71a542ee","weight":1},{"event_id":7623,"event_guid":"d7305220-5dac-5581-bf1b-14e735c39756","weight":3},{"event_id":7625,"event_guid":"bd14d233-85f2-5064-8f3d-5693392a48e4","weight":1},{"event_id":7627,"event_guid":"1afdcbac-7132-5769-8368-712bf4a8163a","weight":1},{"event_id":7629,"event_guid":"43e2163d-d0f7-5b45-945b-25dd8c57118b","weight":3},{"event_id":7632,"event_guid":"99a39bf7-5c95-5bc3-947a-55e28aa0a042","weight":6},{"event_id":7639,"event_guid":"9b3ad47a-e457-5428-b6ca-170addd9bf22","weight":1},{"event_id":7686,"event_guid":"32b1eb85-fc7e-50f8-9551-94bbb22873cf","weight":1},{"event_id":7692,"event_guid":"3c0ea464-ce0e-5676-a977-075148d7bbdd","weight":3},{"event_id":7694,"event_guid":"05466dda-8c63-57a3-a1ff-ebeff2abaa92","weight":1},{"event_id":7701,"event_guid":"d3a697b4-8bc4-57ba-934c-2747fbec39ab","weight":1},{"event_id":7729,"event_guid":"9d030aa8-27aa-509b-913f-ee9eff97257b","weight":1},{"event_id":7732,"event_guid":"771fc01c-25ee-5202-abbe-0b993a5e7ace","weight":1},{"event_id":7741,"event_guid":"d559c68a-c1f9-57a2-82ff-d699952dbe87","weight":1}],"recordings":[{"size":203,"length":1704,"mime_type":"video/mp4","language":"eng","filename":"bucharest-258-eng-A_COG_In_The_Machine_-_Using_Cloud_Optimised_GeoTiffs_to_Query_24_Billion_Pixels_In_Real-Time_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2019-08-30T18:47:16.395+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/h264-hd/bucharest-258-eng-A_COG_In_The_Machine_-_Using_Cloud_Optimised_GeoTiffs_to_Query_24_Billion_Pixels_In_Real-Time_hd.mp4","url":"https://api.media.ccc.de/public/recordings/39500","event_url":"https://api.media.ccc.de/public/events/3f476837-4583-53e9-8ddf-eb940720a469","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":26,"length":1704,"mime_type":"audio/mpeg","language":"eng","filename":"bucharest-258-eng-A_COG_In_The_Machine_-_Using_Cloud_Optimised_GeoTiffs_to_Query_24_Billion_Pixels_In_Real-Time_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2019-08-30T19:22:33.620+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/mp3/bucharest-258-eng-A_COG_In_The_Machine_-_Using_Cloud_Optimised_GeoTiffs_to_Query_24_Billion_Pixels_In_Real-Time_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/39564","event_url":"https://api.media.ccc.de/public/events/3f476837-4583-53e9-8ddf-eb940720a469","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":16,"length":1704,"mime_type":"audio/opus","language":"eng","filename":"bucharest-258-eng-A_COG_In_The_Machine_-_Using_Cloud_Optimised_GeoTiffs_to_Query_24_Billion_Pixels_In_Real-Time_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2019-08-30T19:22:35.875+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/opus/bucharest-258-eng-A_COG_In_The_Machine_-_Using_Cloud_Optimised_GeoTiffs_to_Query_24_Billion_Pixels_In_Real-Time_opus.opus","url":"https://api.media.ccc.de/public/recordings/39565","event_url":"https://api.media.ccc.de/public/events/3f476837-4583-53e9-8ddf-eb940720a469","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":304,"length":1704,"mime_type":"video/webm","language":"eng","filename":"bucharest-258-eng-A_COG_In_The_Machine_-_Using_Cloud_Optimised_GeoTiffs_to_Query_24_Billion_Pixels_In_Real-Time_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2019-08-30T19:23:16.291+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/webm-hd/bucharest-258-eng-A_COG_In_The_Machine_-_Using_Cloud_Optimised_GeoTiffs_to_Query_24_Billion_Pixels_In_Real-Time_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/39571","event_url":"https://api.media.ccc.de/public/events/3f476837-4583-53e9-8ddf-eb940720a469","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":113,"length":1704,"mime_type":"video/webm","language":"eng","filename":"bucharest-258-eng-A_COG_In_The_Machine_-_Using_Cloud_Optimised_GeoTiffs_to_Query_24_Billion_Pixels_In_Real-Time_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2019-08-30T19:23:25.079+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/webm-sd/bucharest-258-eng-A_COG_In_The_Machine_-_Using_Cloud_Optimised_GeoTiffs_to_Query_24_Billion_Pixels_In_Real-Time_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/39573","event_url":"https://api.media.ccc.de/public/events/3f476837-4583-53e9-8ddf-eb940720a469","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":63,"length":1704,"mime_type":"video/mp4","language":"eng","filename":"bucharest-258-eng-A_COG_In_The_Machine_-_Using_Cloud_Optimised_GeoTiffs_to_Query_24_Billion_Pixels_In_Real-Time_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2019-08-30T19:27:12.371+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/h264-sd/bucharest-258-eng-A_COG_In_The_Machine_-_Using_Cloud_Optimised_GeoTiffs_to_Query_24_Billion_Pixels_In_Real-Time_sd.mp4","url":"https://api.media.ccc.de/public/recordings/39587","event_url":"https://api.media.ccc.de/public/events/3f476837-4583-53e9-8ddf-eb940720a469","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"}]}