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

This resource contains some files/folders that have non-preferred characters in their name. Show non-conforming files/folders.

This resource contains content types with files that need to be updated to match with metadata changes. Show content type files that need updating.

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

Authors:
Owners:		This resource does not have an owner who is an active HydroShare user. Contact CUAHSI (help@cuahsi.org) for information on this resource.
Type:	Resource
Storage:	The size of this resource is 6.0 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:	1577
Downloads:	107
+1 Votes:	Be the first one to this.
Comments:	No comments (yet)

Abstract

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

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:

Manual https://postgis.net/docs/
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

Deleting all keywords will set the resource sharing status to private.

Coverage

Spatial

Coordinate System/Geographic Projection:

WGS 84 EPSG:4326

Coordinate Units:

Decimal degrees

North Latitude

40.1164°

East Longitude

-88.2089°

South Latitude

40.0981°

West Longitude

-88.2427°

Content

Learn more about the BagIt download

Select a file to see file type metadata.

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.

Web Map Service

https://geoserver.hydroshare.org/geoserver/HS-bb779d4cce564dd6afcf463c8910786f/wms?request=GetCapabilities

Web Feature Service

https://geoserver.hydroshare.org/geoserver/HS-bb779d4cce564dd6afcf463c8910786f/wfs?request=GetCapabilities

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, http://www.hydroshare.org/resource/bb779d4cce564dd6afcf463c8910786f

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

http://creativecommons.org/licenses/by/4.0/

Comments

There are currently no comments