Checking for non-preferred file/folder path names (may take a long time depending on the number of files/folders) ...

PostGIS integration in CyberGIS-Jupyter for Water (CJW) platform

Owners: This resource does not have an owner who is an active HydroShare user. Contact CUAHSI ( for information on this resource.
Type: Resource
Storage: The size of this resource is 5.9 MB
Created: May 01, 2020 at 4:55 p.m.
Last updated: May 11, 2020 at 7:50 p.m.
Citation: See how to cite this resource
Content types: Geographic Feature Content 
Sharing Status: Public
Views: 1099
Downloads: 102
+1 Votes: Be the first one to 
Comments: No comments (yet)


This example demonstrates how to use PostGIS capabilities in CyberGIS-Jupyter notebook environment. Modified from notebook by Weiye Chen (

PostGIS is an extension to the PostgreSQL object-relational database system which allows GIS (Geographic Information Systems) objects to be stored in the database. PostGIS includes support for GiST-based R-Tree spatial indices, and functions for analysis and processing of GIS objects.

Resources for PostGIS:

In this demo, we use PostGIS 3.0. Note that significant changes in APIs have been made to PostGIS compared to version 2.x. This demo assumes that you have basic knowledge of SQL.

Subject Keywords



Coordinate System/Geographic Projection:
WGS 84 EPSG:4326
Coordinate Units:
Decimal degrees
North Latitude
East Longitude
South Latitude
West Longitude


Data Services

The following web services are available for data contained in this resource. Geospatial Feature and Raster data are made available via Open Geospatial Consortium Web Services. The provided links can be copied and pasted into GIS software to access these data. Multidimensional NetCDF data are made available via a THREDDS Data Server using remote data access protocols such as OPeNDAP. Other data services may be made available in the future to support additional data types.

Related Resources

This resource belongs to the following collections:
Title Owners Sharing Status My Permission
What's New in CyberGIS-Jupyter for Water (CJW) 2020 Q2 Release Zhiyu/Drew Li · Shaowen Wang · Anand Padmanabhan · Fangzheng Lyu  Public &  Shareable Open Access

How to Cite

Chen, W., S. Wang (2020). PostGIS integration in CyberGIS-Jupyter for Water (CJW) platform, HydroShare,

This resource is shared under the Creative Commons Attribution CC BY.


There are currently no comments

New Comment