{"guid":"4ae662a0-789b-56b6-a357-ed2384226e9d","title":"Spatial Support in MySQL","subtitle":null,"slug":"bucharest-132-spatial-support-in-mysql","link":"https://talks.2019.foss4g.org/bucharest/talk/7TF7ZW/","description":"MySQL 8.0 was a huge step in terms of spatial support -- a step up from flat Cartesian coordinate systems to ellipsoidal geography. In this talk we'll go on a quick tour of the spatial support in MySQL. We'll cover data types, functions, indexes, coordinate reference systems and other core topics. We'll look at both the big design decisions and practical use. What can MySQL do? How does it work? What are the limitations? Join us for answers to these questions and more!\n\nNone","original_language":"eng","persons":["Norvald H. Ryeng"],"tags":["bucharest","132","General"],"view_count":99,"promoted":false,"date":"2019-08-30T00:00:00.000+02:00","release_date":"2019-08-30T02:00:00.000+02:00","updated_at":"2025-03-29T18:15:02.491+01:00","length":1364,"duration":1364,"thumb_url":"https://static.media.ccc.de/media/conferences/foss4g2019/132-hd.jpg","poster_url":"https://static.media.ccc.de/media/conferences/foss4g2019/132-hd_preview.jpg","timeline_url":"https://static.media.ccc.de/media/conferences/foss4g2019/132-hd.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/conferences/foss4g2019/132-hd.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/bucharest-132-spatial-support-in-mysql","url":"https://api.media.ccc.de/public/events/4ae662a0-789b-56b6-a357-ed2384226e9d","conference_title":"FOSS4G 2019","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019","related":[{"event_id":6825,"event_guid":"dfb37b89-29a0-5314-9824-03c2689cdeed","weight":1},{"event_id":7358,"event_guid":"b69c19ce-7c89-4afd-9396-ea664f80dba8 ","weight":1},{"event_id":7360,"event_guid":"c9edea6f-1da1-4772-a0a9-6dd4e33f11bb","weight":1},{"event_id":7361,"event_guid":"977957d7-ef42-4ea0-8380-b9a48bd583f0","weight":1},{"event_id":7462,"event_guid":"bc0ea171-a661-56f9-a518-e32c84bbcf8b","weight":1},{"event_id":7463,"event_guid":"b771ce7c-b209-5ad2-a406-de13644ea6de","weight":2},{"event_id":7467,"event_guid":"df17d333-e410-5e1f-a31c-42805b52b53c","weight":2},{"event_id":7469,"event_guid":"c0174aef-c7a6-5d21-8dfe-e592c5a4eff3","weight":1},{"event_id":7471,"event_guid":"3c2d5b68-ca8e-5c4e-9110-59ad868cfc70","weight":1},{"event_id":7479,"event_guid":"5cb82c9e-bc84-54e2-a40d-60b78f35ef46","weight":1},{"event_id":7482,"event_guid":"89395e98-1ee1-5eee-ae26-cbaa54630177","weight":4},{"event_id":7484,"event_guid":"b4d6c8c6-688b-5273-aa8f-a2044128ac13","weight":1},{"event_id":7487,"event_guid":"6f1b8b15-b44a-592c-b3e9-96bd9e0fbce3","weight":2},{"event_id":7488,"event_guid":"0a3e23aa-d593-58cd-a3a1-7991e3a3a064","weight":2},{"event_id":7491,"event_guid":"7ce19c2c-7bc3-5ba7-b454-b383a7c58c6c","weight":2},{"event_id":7497,"event_guid":"ee2c0473-7931-5239-85f0-0385fb68054e","weight":2},{"event_id":7504,"event_guid":"c54aa667-78de-55fb-85e7-60f2eaffd2a4","weight":1},{"event_id":7509,"event_guid":"2ecaf4b8-9654-58a3-afce-5771d68ac94f","weight":2},{"event_id":7512,"event_guid":"88c1d544-049b-5622-b197-03b8894a39f7","weight":2},{"event_id":7527,"event_guid":"b05efa77-03a4-5ff9-a037-06d5aa2a1b6d","weight":1},{"event_id":7531,"event_guid":"eeabc00d-ba6f-58f2-91d9-1bde01e1c643","weight":2},{"event_id":7533,"event_guid":"bff8e480-f2e6-5fb7-a945-fed5e6b06f77","weight":2},{"event_id":7534,"event_guid":"3fc26cc4-962e-5f27-a92b-c01e86d12100","weight":3},{"event_id":7543,"event_guid":"7b40d7a8-7350-54ce-9809-87c5b0ee912f","weight":1},{"event_id":7552,"event_guid":"4c2f4b81-1316-502d-870c-dc39567b782e","weight":2},{"event_id":7555,"event_guid":"a641fc9b-2eb6-5580-8acc-4236e227de4e","weight":1},{"event_id":7574,"event_guid":"b3b2685b-8691-5c3a-bb1c-14d2038338cd","weight":2},{"event_id":7579,"event_guid":"0112454d-62b2-5132-8971-73c7fdb972d0","weight":2},{"event_id":7607,"event_guid":"d0794cae-d707-584c-8879-6c438a603486","weight":1},{"event_id":7610,"event_guid":"08454950-b5fe-59f1-9a94-2f51780aef74","weight":2},{"event_id":7613,"event_guid":"0b7d0b85-cf67-5382-aba4-9035a9e7963a","weight":1},{"event_id":7619,"event_guid":"21ffa487-5dfd-57d3-acce-8fd048ead7cf","weight":2},{"event_id":7623,"event_guid":"d7305220-5dac-5581-bf1b-14e735c39756","weight":1},{"event_id":7629,"event_guid":"43e2163d-d0f7-5b45-945b-25dd8c57118b","weight":1},{"event_id":7637,"event_guid":"37fd6d99-fbed-5c0e-b209-5418299ffce5","weight":2},{"event_id":7665,"event_guid":"f1f4f54c-e816-573f-a05d-7973f9f5d48e","weight":1},{"event_id":7667,"event_guid":"4bc8bbe5-cb04-5a2b-b441-a696be055948","weight":1},{"event_id":7668,"event_guid":"4b718f1b-6e92-5ed0-a0bf-99f09fd5e873","weight":2},{"event_id":7669,"event_guid":"7627a093-69e4-5c72-b8b5-0f05c27ce815","weight":1},{"event_id":7670,"event_guid":"87692512-45dd-5b7b-9456-62d1a04a185e","weight":2},{"event_id":7672,"event_guid":"1c58bd3e-15f6-51a3-af44-9d6a75f31556","weight":1},{"event_id":7673,"event_guid":"89f564bf-e743-5086-a372-478a49b0d7ce","weight":3},{"event_id":7692,"event_guid":"3c0ea464-ce0e-5676-a977-075148d7bbdd","weight":2},{"event_id":7695,"event_guid":"5df0ebe1-cfe2-54c4-a0c8-40e35a6de826","weight":2},{"event_id":7696,"event_guid":"cf0c6d43-7a50-5d88-b6dd-db5aa818aff8","weight":1},{"event_id":7709,"event_guid":"936a0a3d-27d2-5bb7-a59a-336837047e72","weight":2},{"event_id":7710,"event_guid":"9bce8e1a-0dc8-5c82-977c-23dccd115e89","weight":1},{"event_id":7722,"event_guid":"8f2a7b79-eb9b-5eea-9cec-6878c3dc26b0","weight":1},{"event_id":7725,"event_guid":"63a63204-d0dd-57d5-aae3-d766a3be9d23","weight":4},{"event_id":7732,"event_guid":"771fc01c-25ee-5202-abbe-0b993a5e7ace","weight":1},{"event_id":7733,"event_guid":"0ba5c644-2353-5225-972e-6e3958f74f3e","weight":3},{"event_id":7753,"event_guid":"5f917971-56e2-5166-a686-07e384a9228d","weight":1},{"event_id":7754,"event_guid":"a413689b-2102-5eec-93ef-bae111230fd3","weight":1},{"event_id":7758,"event_guid":"d7541c86-83fd-55c3-8843-f64e30b8aa55","weight":1},{"event_id":7759,"event_guid":"2dbbceca-916a-5619-8d57-6bd9f57db57a","weight":1}],"recordings":[{"size":104,"length":1364,"mime_type":"video/mp4","language":"eng","filename":"bucharest-132-eng-Spatial_Support_in_MySQL_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2019-08-30T17:43:27.502+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/h264-hd/bucharest-132-eng-Spatial_Support_in_MySQL_hd.mp4","url":"https://api.media.ccc.de/public/recordings/39351","event_url":"https://api.media.ccc.de/public/events/4ae662a0-789b-56b6-a357-ed2384226e9d","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":20,"length":1364,"mime_type":"audio/mpeg","language":"eng","filename":"bucharest-132-eng-Spatial_Support_in_MySQL_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2019-08-30T17:54:41.813+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/mp3/bucharest-132-eng-Spatial_Support_in_MySQL_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/39382","event_url":"https://api.media.ccc.de/public/events/4ae662a0-789b-56b6-a357-ed2384226e9d","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":13,"length":1364,"mime_type":"audio/opus","language":"eng","filename":"bucharest-132-eng-Spatial_Support_in_MySQL_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2019-08-30T17:55:07.836+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/opus/bucharest-132-eng-Spatial_Support_in_MySQL_opus.opus","url":"https://api.media.ccc.de/public/recordings/39383","event_url":"https://api.media.ccc.de/public/events/4ae662a0-789b-56b6-a357-ed2384226e9d","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":38,"length":1364,"mime_type":"video/mp4","language":"eng","filename":"bucharest-132-eng-Spatial_Support_in_MySQL_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2019-08-30T17:56:34.648+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/h264-sd/bucharest-132-eng-Spatial_Support_in_MySQL_sd.mp4","url":"https://api.media.ccc.de/public/recordings/39384","event_url":"https://api.media.ccc.de/public/events/4ae662a0-789b-56b6-a357-ed2384226e9d","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":58,"length":1364,"mime_type":"video/webm","language":"eng","filename":"bucharest-132-eng-Spatial_Support_in_MySQL_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2019-08-30T18:01:39.335+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/webm-sd/bucharest-132-eng-Spatial_Support_in_MySQL_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/39395","event_url":"https://api.media.ccc.de/public/events/4ae662a0-789b-56b6-a357-ed2384226e9d","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"},{"size":151,"length":1364,"mime_type":"video/webm","language":"eng","filename":"bucharest-132-eng-Spatial_Support_in_MySQL_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2019-08-30T18:11:57.250+02:00","recording_url":"https://cdn.media.ccc.de/events/foss4g2019/webm-hd/bucharest-132-eng-Spatial_Support_in_MySQL_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/39428","event_url":"https://api.media.ccc.de/public/events/4ae662a0-789b-56b6-a357-ed2384226e9d","conference_url":"https://api.media.ccc.de/public/conferences/foss4g2019"}]}