GIS&IT Story

“Kepler.GL & Jupyter Notebooks: Geospatial Data Visualization with Uber’s opensource Kepler.GL” by Abdishakur https://link.medium.com/3MkAuWSFC1

테이블 목록 조회 SELECT RELNAME AS TABLE_NAME FROM PG_STAT_USER_TABLES 컬럼 목록 조회 SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_CATALOG = '데이터베이스명' AND TABLE_NAME = '테이블명' ORDER BY ORDINAL_POSITION; 기본키 조회 SELECT CC.COLUMN_NAME AS COLUMN_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC ,INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CC WHERE TC.TABLE_CATALOG = '데이터베이스명' AND TC.TABLE_NAME = '테이블명' AND..

“Introducing kepler.gl for Jupyter” by Shan He https://link.medium.com/hIsyKXxYj0

https://link.medium.com/2el3aCt0oXhttps://link.medium.com/2el3aCt0oX

http://www.gislounge.com/introduction-to-geospatial-analysis-in-r-video/

https://www.gislounge.com/introduction-to-postgis/

Easy Processing scripts comeback in QGIS 3.6 https://anitagraser.com/2019/03/02/easy-processing-scripts-comeback-in-qgis-3-6/

https://anitagraser.com/2019/03/03/stand-alone-pyqgis-scripts-with-osgeo4w/

About Layer tree embedded widgets and have your WM(T)S always crispy sharp | www.qgis.nl http://www.qgis.nl/2019/02/14/about-layer-tree-embedded-widgets-and-have-your-wmts-always-crispy-sharp/?lang=en

PyQGIS 101: Loading a vector layer | Free and Open Source GIS Ramblings https://anitagraser.com/pyqgis-101-introduction-to-qgis-python-programming-for-non-programmers/pyqgis-101-loading-a-vector-layer/