This tutorial will guide you through a step-by-step geospatial analysis of bike sharing data using DuckDB. Prerequisites: To setup DuckDB along with spatial extension, please follow this tutorial Setting up DuckDB for GeoSpatial Analysis. Following parquet dataset is used for this TutorialParquet Dataset 1. Load extensions and parquet data: The provided code is loading spatial […]
Geospatial Analysis using DuckDB Read More »
In this tutorial, we will learn how to read raster data from postgis table using python. Python is a powerful tool for raster data analysis due to rich library ecosystem: Python has a large number of libraries specifically designed for geospatial data analysis, such as rasterio, rioxarray, gdal, geopandas, shapely, etc. These libraries provide a
Read raster data from postgis using python Read More »
GeoPandas is great python library to process your vector data. It has direct support for postgis database where you can directly read/write from/to postgis database. GeoPandas internally uses SqlAlchemy API to manage database specific operations like reading from PostGIS, writing to PostGIS etc. SqlAlchemy can be used for almost all the databases out there like
Import shapefiles using GeoPandas and PsycoPG2. Read More »
