PostGIS

Import shapefiles using GeoPandas and PsycoPG2.

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 »

Import rasters file to PostGIS database using raster2pgsql

raster2pgsql is GIS command line utility which is installed as a part of PostGIS. To install raster2pgsql, you have to install PostGIS and raster2pgsql will be installed with it. To import raster to postgis, type following command in terminal and replace file name and database details with yours. It will successfully import your raster to …

Import rasters file to PostGIS database using raster2pgsql Read More »

Import Shapefile to PostgreSQL/PostGIS database using GeoPandas/Python

The usage of Python in GeoSpatial field has exponentially grown. Almost every GIS desktop software provide python integration. QGIS, famous open source GIS software, has python interface. Python has many open source GIS libraries for example GDAL, Fiona, GeoPandas, RasterIO, Shapely, Xarray Spatial etc. These libraries can process both raster as well as vector data. …

Import Shapefile to PostgreSQL/PostGIS database using GeoPandas/Python Read More »

%%footer%%