{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,27]],"date-time":"2026-06-27T08:06:59Z","timestamp":1782547619182,"version":"3.54.5"},"publisher-location":"New York, NY, USA","reference-count":34,"publisher":"ACM","license":[{"start":{"date-parts":[[2024,6,9]],"date-time":"2024-06-09T00:00:00Z","timestamp":1717891200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by-nc-sa\/4.0\/"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2024,6,9]]},"DOI":"10.1145\/3662165.3662761","type":"proceedings-article","created":{"date-parts":[[2024,5,17]],"date-time":"2024-05-17T10:10:57Z","timestamp":1715940657000},"page":"36-42","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":2,"title":["Analysis of Geospatial Data Loading"],"prefix":"10.1145","author":[{"ORCID":"https:\/\/orcid.org\/0009-0009-8924-0871","authenticated-orcid":false,"given":"Aske","family":"Wachs","sequence":"first","affiliation":[{"name":"IT University of Copenhagen, Denmark"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"ORCID":"https:\/\/orcid.org\/0000-0001-8873-5455","authenticated-orcid":false,"given":"Eleni Tzirita","family":"Zacharatou","sequence":"additional","affiliation":[{"name":"IT University of Copenhagen, Denmark"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2024,6,9]]},"reference":[{"key":"e_1_3_2_1_1_1","doi-asserted-by":"publisher","DOI":"10.14778\/3554821.3554865"},{"key":"e_1_3_2_1_3_1","unstructured":"GeoParquet Community. 2023. GeoParquet. https:\/\/geoparquet.org\/. Accessed on March 5 2024."},{"key":"e_1_3_2_1_4_1","volume-title":"ADMS (Lecture Notes in Computer Science","volume":"117","author":"Dziedzic Adam","year":"2016","unstructured":"Adam Dziedzic, Manos Karpathiotakis, Ioannis Alagiannis, Raja Appuswamy, and Anastasia Ailamaki. 2016. DBMS Data Loading: An Analysis on Modern Hardware. In ADMS (Lecture Notes in Computer Science, Vol. 10195). Springer, 95--117."},{"key":"e_1_3_2_1_5_1","volume-title":"ShapeFiles - ArcGIS Online Reference Manual. Esri. https:\/\/doc.arcgis.com\/en\/arcgis-online\/reference\/shapefiles.htm Accessed on","author":"Esri","year":"2024","unstructured":"Esri 2023. ShapeFiles - ArcGIS Online Reference Manual. Esri. https:\/\/doc.arcgis.com\/en\/arcgis-online\/reference\/shapefiles.htm Accessed on March 5, 2024."},{"key":"e_1_3_2_1_6_1","unstructured":"Martin Fleischmann. 2022. Dask-GeoPandas vs PostGIS vs GPU: Performance and Spatial Joins. https:\/\/martinfleischmann.net\/dask-geopandas-vs-postgis-vs-gpu-performance-and-spatial-joins\/. Accessed on March 5 2024."},{"key":"e_1_3_2_1_7_1","volume-title":"https:\/\/duckdb.org\/2023\/04\/28\/spatial.html Accessed on","author":"Gabrielsson Max","year":"2024","unstructured":"Max Gabrielsson. 2023. PostGEESE? Introducing The DuckDB Spatial Extension. DuckDB Foundation. https:\/\/duckdb.org\/2023\/04\/28\/spatial.html Accessed on March 5, 2024."},{"key":"e_1_3_2_1_8_1","doi-asserted-by":"publisher","unstructured":"GDAL\/OGR contributors. 2023. GDAL\/OGR Geospatial Data Abstraction software Library. Open Source Geospatial Foundation. https:\/\/doi.org\/10.5281\/zenodo.5884351","DOI":"10.5281\/zenodo.5884351"},{"key":"e_1_3_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.5281\/zenodo.10671398"},{"key":"e_1_3_2_1_10_1","volume-title":"Accessed","year":"2023","unstructured":"GISGeography. 2023. The Ultimate List of GIS Formats and Geospatial File Extensions. https:\/\/gisgeography.com\/gis-formats\/ Last updated: March 9, 2024, Accessed: March 14, 2024."},{"key":"e_1_3_2_1_11_1","volume-title":"Performance Explorations of GeoParquet (and DuckDB)","author":"Holmes Chris","year":"2023","unstructured":"Chris Holmes. 2023. Performance Explorations of GeoParquet (and DuckDB). Cloud-Native Geospatial Foundation. https:\/\/cloudnativegeo.org\/blog\/2023\/08\/performance-explorations-of-geoparquet-and-duckdb\/ Accessed on March 5, 2024."},{"key":"e_1_3_2_1_12_1","unstructured":"Kelsey Jordahl Joris Van den Bossche Martin Fleischmann Jacob Wasserman James McBride Jeffrey Gerard Jeff Tratner Matthew Perry Adrian Garcia Badaracco Carson Farmer Geir Arne Hjelle Alan D. Snow Micah Cochran Sean Gillies Lucas Culbertson Matt Bartos Nick Eubank maxalbert Aleksey Bilogur Sergio Rey Christopher Ren Dani Arribas-Bel Leah Wasser Levi John Wolf Martin Journois Joshua Wilson Adam Greenhall Chris Holdgraf Filipe and Fran\u00e7ois Leblanc. 2020. geopandas\/geopandas: v0.8.1."},{"key":"e_1_3_2_1_13_1","volume-title":"SIGSPATIAL","author":"Katiyar Puloma","unstructured":"Puloma Katiyar, Tin Vu, Ahmed Eldawy, Sara Migliorini, and Alberto Belussi. 2020. SpiderWeb: A Spatial Data Generator on the Web. In SIGSPATIAL. ACM, New York, NY, USA, 465--468."},{"key":"e_1_3_2_1_14_1","volume-title":"Big Data","author":"Kim Suneuy","unstructured":"Suneuy Kim and Yuvraj Singh Kanwar. 2019. GeoYCSB: A Benchmark Framework for the Performance and Scalability Evaluation of NoSQL Databases for Geospatial Workloads. In Big Data. IEEE, 3666--3675."},{"key":"e_1_3_2_1_15_1","volume-title":"Data Structures for Statistical Computing in Python. In Python in Science Conference, St\u00e9fan van der Walt and Jarrod Millman (Eds.). 51 - 56","author":"McKinney Wes","year":"2010","unstructured":"Wes McKinney. 2010. Data Structures for Statistical Computing in Python. In Python in Science Conference, St\u00e9fan van der Walt and Jarrod Millman (Eds.). 51 - 56."},{"key":"e_1_3_2_1_16_1","unstructured":"OpenStreetMap. 2024. https:\/\/www.openstreetmap.org."},{"key":"e_1_3_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.14778\/3236187.3236213"},{"key":"e_1_3_2_1_18_1","first-page":"192","article-title":"How Good Are Modern Spatial Libraries? Data Sci","volume":"6","author":"Pandey Varun","year":"2021","unstructured":"Varun Pandey, Alexander van Renen, Andreas Kipf, and Alfons Kemper. 2021. How Good Are Modern Spatial Libraries? Data Sci. Eng. 6, 2 (2021), 192--208.","journal-title":"Eng."},{"key":"e_1_3_2_1_19_1","volume-title":"Andreas Kipf, Ibrahim Sabek, Jialin Ding, Volker Markl, and Alfons Kemper.","author":"Pandey Varun","year":"2023","unstructured":"Varun Pandey, Alexander van Renen, Eleni Tzirita Zacharatou, Andreas Kipf, Ibrahim Sabek, Jialin Ding, Volker Markl, and Alfons Kemper. 2023. Enhancing In-Memory Spatial Indexing with Learned Search. arXiv:2309.06354 [cs.DB]"},{"key":"e_1_3_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.1145\/3299869.3320212"},{"key":"e_1_3_2_1_21_1","volume-title":"Jackpine: A benchmark to evaluate spatial database performance","author":"Ray Suprio","year":"2011","unstructured":"Suprio Ray, Bogdan Simion, and Angela Demke Brown. 2011. Jackpine: A benchmark to evaluate spatial database performance. In ICDE. IEEE, 1139--1150."},{"key":"e_1_3_2_1_22_1","volume-title":"DAMON","author":"Sen Rathijit","unstructured":"Rathijit Sen and Yuanyuan Tian. 2023. Microarchitectural Analysis of Graph BI Queries on RDBMS. In DAMON. ACM, New York, NY, USA, 102--106."},{"key":"e_1_3_2_1_23_1","doi-asserted-by":"publisher","unstructured":"Yakov Shafranovich. 2005. Common Format and MIME Type for Comma-Separated Values (CSV) Files. RFC 4180. https:\/\/doi.org\/10.17487\/RFC4180","DOI":"10.17487\/RFC4180"},{"key":"e_1_3_2_1_24_1","doi-asserted-by":"publisher","DOI":"10.14778\/3380750.3380755"},{"key":"e_1_3_2_1_25_1","doi-asserted-by":"crossref","unstructured":"Utku Sirin Pinar T\u00f6z\u00fcn Danica Porobic and Anastasia Ailamaki. 2016. Microarchitectural Analysis of In-memory OLTP. In SIGMOD. ACM 387--402.","DOI":"10.1145\/2882903.2882916"},{"key":"e_1_3_2_1_26_1","unstructured":"Knut Stolze. 2003. SQL\/MM spatial: The standard to manage spatial data in a relational database system. In Datenbanksysteme f\u00fcr Business Technologie und Web (BTW)."},{"key":"e_1_3_2_1_27_1","volume-title":"Tahboub and Tiark Rompf","author":"Ruby","year":"2020","unstructured":"Ruby Y. Tahboub and Tiark Rompf. 2020. Architecting a Query Compiler for Spatial Workloads. In SIGMOD. 2103--2118."},{"key":"e_1_3_2_1_28_1","doi-asserted-by":"crossref","unstructured":"Pinar T\u00f6z\u00fcn Ippokratis Pandis Cansu Kaynak Djordje Jevdjic and Anastasia Ailamaki. 2013. From A to E: analyzing TPC's OLTP benchmarks: the obsolete the ubiquitous the unexplored. In EDBT. ACM 17--28.","DOI":"10.1145\/2452376.2452380"},{"key":"e_1_3_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.14778\/3157794.3157803"},{"key":"e_1_3_2_1_30_1","volume-title":"The Case for Distance-Bounded Spatial Approximations. In Conference on Innovative Data Systems Research, CIDR, Virtual Event, Online Proceedings. http:\/\/cidrdb.org\/cidr2021\/papers\/cidr2021_paper19","author":"Zacharatou Eleni Tzirita","year":"2021","unstructured":"Eleni Tzirita Zacharatou, Andreas Kipf, Ibrahim Sabek, Varun Pandey, Harish Doraiswamy, and Volker Markl. 2021. The Case for Distance-Bounded Spatial Approximations. In Conference on Innovative Data Systems Research, CIDR, Virtual Event, Online Proceedings. http:\/\/cidrdb.org\/cidr2021\/papers\/cidr2021_paper19.pdf"},{"key":"e_1_3_2_1_31_1","doi-asserted-by":"publisher","unstructured":"Eleni Tzirita Zacharatou Darius Sidlauskas Farhan Tauheed Thomas Heinis and Anastasia Ailamaki. 2019. Efficient Bundled Spatial Range Queries. In ACM SIGSPATIAL. 139--148. https:\/\/doi.org\/10.1145\/3347146.3359077","DOI":"10.1145\/3347146.3359077"},{"key":"e_1_3_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.14778\/3494124.3494150"},{"key":"e_1_3_2_1_33_1","unstructured":"Brendan C. Ward. 2024. https:\/\/pypi.org\/project\/pyogrio\/"},{"key":"e_1_3_2_1_34_1","unstructured":"Jeff Whitaker. 2024. https:\/\/pypi.org\/project\/pyproj\/"},{"key":"e_1_3_2_1_35_1","volume-title":"GeoRich. ACM","author":"Zhang Yaming","unstructured":"Yaming Zhang and Ahmed Eldawy. 2020. Evaluating computational geometry libraries for big spatial data exploration. In GeoRich. ACM, New York, NY, USA, Article 3."}],"event":{"name":"SIGMOD\/PODS '24: International Conference on Management of Data","location":"Santiago AA Chile","acronym":"SIGMOD\/PODS '24","sponsor":["SIGMOD ACM Special Interest Group on Management of Data"]},"container-title":["Proceedings of the Tenth International Workshop on Testing Database Systems"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3662165.3662761","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/3662165.3662761","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T23:57:10Z","timestamp":1750291030000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/3662165.3662761"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2024,6,9]]},"references-count":34,"alternative-id":["10.1145\/3662165.3662761","10.1145\/3662165"],"URL":"https:\/\/doi.org\/10.1145\/3662165.3662761","relation":{},"subject":[],"published":{"date-parts":[[2024,6,9]]},"assertion":[{"value":"2024-06-09","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}