Adding GeoParquet to a Spatial Data Infrastructure: What, Why and How
12-04, 17:15–17:45 (America/Belem), Room V

GeoParquet (https://geoparquet.org/) is a cloud-native format created to address the geospatial interoperability issues between data warehouses. It is based on the widely supported columnar storage Apache Parquet (https://parquet.apache.org/), extending it to add support for geometry data types (e.g.: points, lines and polygons). Although a relatively recent format, it already has a good ecosystem of tools, and it took Standardisation very seriously by joining the path to become an OGC Standard (https://github.com/opengeospatial/geoparquet).

The eMOTIONAL Cities project (https://emotionalcities-h2020.eu/) aims to understand how the natural and built environment can shape the feelings and emotions of those who experience it. At its core, lies a Spatial Data Infrastructure (SDI), which combines a variety of datasets from the Urban Health domain (https://emotional.byteroad.net/). These datasets should be available to urban planners, neuroscientists and other stakeholders, for analysis, creating data products and eventually making decisions based upon them. To support an efficient analysis, especially of the larger datasets, we have decided to offer GeoParquet as an alternate encoding. In this talk we share our experience, converting and publishing the +90 datasets of the eMOTIONAL Cities SDI using a stack of FOSS/OSGeo software (GDAL, gpq, pygeoapi).

We will show that there is already a set of (FOSS) tools in place (e.g.: readers, writers, validators) to support this task and to encourage others to add a Standards-based cloud-native format to their SDIs.

See also:

I’m a GIS developer and data analyst. I’m passionate about open source, data visualization and knowledge sharing. I love when technologies break down barriers.
In my career, I explored domains like e-government, fintech, GIS, and e-learning.
I’m a freelancer, and I work with Byte Road and Geobeyond.
In the past, I contributed mostly to GeoNetwork, but recently I widened my interest to more projects. I’m interested in the evolution of OGC API standards and how they can improve our dear projects.

Joana is a software engineer with more than fifteen years experience and a strong expertise in the field of geospatial tech and analytics.
After acquiring a PhD in GIS, at UCL, her drive to solve real-world problems has led her to SMEs, an international organisation, a research foundation and a start-up. Joana has been very involved with FOSS, in particular in what concerns geospatial. This has led her to become a charter member of OSGeo. Joana is the founder of ByteRoad, a SME in the field of data engineering and geospatial analytics. She is also a reviewer for the European Commission, and has been involved in education, teaching the next generation of full-stack developers and data analysts. As Developer Relations at OGC, Joana is responsible for connecting the OGC standards with the wider developer community, hopefully increasing their adoption and contributing towards making them more developer-friendly.

This speaker also appears in: