Spatial Database
FME’s supported spatial data formats
Format Descriptions for Geospatial Data Formats from Sustainability of Digital Formats: Planning for Library of Congress Collections
Early Geographic/Spatial Data Files
Digital line graph - Wikipedia
6. Digital Line Graph (DLG) | The Nature of Geographic Information
Dual Independent Map Encoding - Wikipedia
Topologically Integrated Geographic Encoding and Referencing - Wikipedia
TIGER GIS Data (Topologically Integrated Geographic Encoding & Referencing) - GIS Geography
2. MAF/TIGER | The Nature of Geographic Information
Autodesk Viewer | Free Online File Viewer
What is CAD data?—Help | ArcGIS Desktop
Spatial Data Files
Data Models for GIS from Essentials of Geographic Information Systems
TYPES OF DATA REPRESENTATION (Kathroju)
Spatial And Topological Data Models
What is a coverage?—Help | ArcGIS Desktop
What is a shapefile?—Help | ArcGIS Desktop
ESRI Shapefile Technical Description
KML Keyhole Markup Language | Google Developers
What is KML?—Help | ArcGIS Desktop
U.S. Geological Survey - Spatial Data Transfer Standard
Database Concepts
Category:Database management systems - Wikipedia
Relational database - Wikipedia
ACID (computer science) - Wikipedia
Distributed database - Wikipedia
Distributed Database Concepts- ORACLE
CAP Theorem simplified – Ravindra Prasad – Medium
DB-Engines Ranking - popularity ranking of database management systems
Create Graph online and find shortest path or use other algorithm
Conceptual design
Entity–relationship model - Wikipedia ER模型 - 維基百科,自由的百科全書
ER Diagram Tutorial | Lucidchart
What is Entity Relationship Diagram (ERD)?
Unified Modeling Language - Wikipedia
What is Unified Modeling Language (UML)?
UML超新手入門(1)UML概論 by Michael | CodeData
Relational Database
Physical Structure
Algorithms Behind Modern Storage Systems - ACM Queue
Software
List of relational database management systems - Wikipedia
Comparison of relational database management systems - Wikipedia
Comparison of object-relational database management systems - Wikipedia
The Gaia-SINS federated project home-page
SpatiaLite SQL functions reference list
spatialite-gui: spatialite-gui
GeoPackage Encoding Standard | OGC
Understanding and Working with the OGC Geopackage
Microsoft SQL Documentation | Microsoft Docs(english) Microsoft SQL 文件 | Microsoft Docs (中文)
Microsoft SQL relational databases - guidance | Microsoft Docs
Spatial Data (SQL Server) | Microsoft Docs
OGC Methods on Geometry Instances - SQL Server | Microsoft Docs
Transact-SQL Reference (Database Engine) | Microsoft Docs
geography (Transact-SQL) | Microsoft Docs
geometry (Transact-SQL) | Microsoft Docs
MySQL :: MySQL Community Downloads
MySQL :: MySQL 8.0 Reference Manual
MySQL :: MySQL 8.0 Reference Manual :: 11.5 Spatial Data Types
PostGIS — Spatial and Geographic Objects for PostgreSQL
Introduction to SQL and Geospatial Data Processing: Reference
Oracle Database Software Downloads
Oracle Database- Oracle Database Documentation -
Oracle Database Technical Architecture
Spatial and Graph Developer's Guide - Contents
IBM Db2 – Data management software – IBM Analytics
IBM Knowledge Center - IBM Db2
IBM Knowledge Center - Spatial Extender
ESRI Geodatabase
What is a Geodatabase? Personal vs File Geodatabase - GIS Geography
Databases and ArcGIS— ArcGIS Desktop
SQL functions used with ST_Geometry— ArcGIS Desktop
Databases and ArcGIS Pro— ArcGIS Desktop
DataSourcesGDB- ArcObjects Help for .NET developers a
The Top Nine Reasons to Use a File Geodatabase
building-a-geodatabase-tutorial.pdf
Getting Started with the Geodatabase
Database data and ArcGIS—Help | ArcGIS Desktop
Building Geodatabases online couse (Cost: $1,815 USD)
Understanding Coordinate Management in the Geodatabase
Deciding between relationship classes, relates, and joins—Help | ArcGIS Desktop (How does ArcGIS supports join without using SQL)
Relationship class properties—Help | ArcGIS Desktop Relationship class properties—| ArcGIS Pro
Docker
Docker - Build, Ship, and Run Any App, Anywhere
GitHub - Bunlong/the-best-docker-books: Free Docker eBooks
Get started with Docker for Windows | Docker Documentation
Windows Containers Documentation | Microsoft Docs
About Windows Containers | Microsoft Docs
Windows Container on Windows 10 | Microsoft Docs
microsoft/mssql-server-linux - Docker Hub
開始使用 Docker 上的 SQL Server 2017 | Microsoft Docs
microsoft/mssql-server - Docker Hub
GitHub - Microsoft/mssql-docker: Official Microsoft repository for SQL Server in Docker resources
Portainer | Simple management UI for Docker
DockerImages - OSGeo provide an overview of OSGeo-related Docker images.
OFFICIAL postgres - Docker Hub object-relational database system
GitHub - appropriate/docker-postgis: Docker image for PostGIS provides a Docker container running Postgres 9 or 10 with PostGIS 2.4 installed
Camptocamp's PostgreSQL Docker container - Docker Hub
GitHub - camptocamp/docker-postgis is deprecated
neowaylabs/postgis - Docker Hub
Set Up a PostGIS Database With Docker · Alex Urquhart
Get started with SQL Server 2017 on Docker | Microsoft Docs
docker-images/OracleDatabase at master · oracle/docker-images · GitHub
Oracle Database Enterprise Edition - Docker Store
sath89/oracle-ee-11g - Docker Hub
SQL (with spatial data type)
SQL/MM Spatial: The Standard to Manage Spatial Data in Relational Database Systems
ISO/IEC JTC 1/SC 32/WG 4 ISO/IEC JTC 1/SC 32/WG 4 SQL/MM-Part 3: Spatial
Spatiotemporal Query Languages | SpringerLink
Simple Feature Access - Part 1: Common Architecture | OGC ISO 19125-1:2004 - Geographic information -- Simple feature access -- Part 1: Common architecture
Simple Feature Access - Part 2: SQL Option | OGC ISO 19125-2:2004 - Geographic information -- Simple feature access -- Part 2: SQL option
Microsoft SQL Documentation | Microsoft Docs
Create, Construct, and Query geometry Instances - SQL Server | Microsoft Docs
Create, Construct, and Query geography Instances - SQL Server | Microsoft Docs
Chapter 4. Using PostGIS: Data Management and Queries
SpatiaLite SQL functions reference list
SQL and enterprise geodatabases—Help | ArcGIS Desktop
SQL online Tutorial
SQL Tutorial w3schools
SQL Online Test | TestDome.com
SQLite Tutorial - An Easy Way to Master SQLite Fast
SQLite Tutorial - An Easy Way to Master SQLite Fast
SQL online editor
Run Sqlite Online- tutorialspoint
sql.js demo: Online SQL interpreter work with sqlite
Online SQL Editor - Tutorial Republic with default sample database
SQL Tryit Editor v1.6 with default sample database
SQL Clients
Comparison of database tools - Wikipedia
DBeaver | Free Universal Database Tool
Falcon SQL Client - Plotly free and open-source SQL client with inline data visualization
Sqlectron - One single DB client for any relational DB
HeidiSQL - MySQL, MSSQL and PostgreSQL made easy
Free Database Software and Developer Tools | Devart
DataGrip: Cross-Platform IDE for Databases & SQL by JetBrains
SQL Server Management Studio (SSMS) | Microsoft Docs
Azure Data Studio | Microsoft Docs
Overview of connecting to (importing) data - Excel
Import data from external data sources (Power Query) - Excel
Connect Excel to SQL Database | Microsoft Docs
DatabaseInterfaces - Python Wiki
SQLAlchemy - The Database Toolkit for Python
GIS Standard
OGC® Standards and Supporting Documents | OGC
ISO/TC 211 - Geographic information/Geomatics
ISO/TC 211 Geographic information/Geomatics - Wikipedia
FGDC Geospatial Standards — Federal Geographic Data Committee
Data Specifications | INSPIRE specify common data models, code lists, map layers and additional metadata
NoSQL
Real-time database - Wikipedia
RethinkDB: the open-source database for the realtime web
Choose a database: Cloud Firestore or Realtime Database | Firebase
Markup Language
Geography Markup Language - Wikipedia
Keyhole Markup Language | Google Developers
Import data from external data sources (Power Query) - Excel
YAML - Wikipedia YAML - 維基百科,自由的百科全書
Google Earth (KML)
Keyhole Markup Language - Wikipedia
Keyhole Markup Language | Google Developers
What is KML?—Help | ArcGIS for Desktop
OpenStreetMap (OSM)
https://wiki.openstreetmap.org/wiki/Main_Page
Planet.osm - OpenStreetMap Wiki
Osm2postgresql - OpenStreetMap Wiki
Semantic Web and Linked Data
W3C Data Activity - Building the Web of Data
W3C Semantic Web Interest Group (SWIG)
W3C Semantic Web Interest Group: Basic Geo (WGS84 lat/long) Vocabulary
Spatial Data on the Web Working Group
W3C Spatial Data on the Web Interest Group
Linking Geospatial Data, 5 - 6 March 2014, London (Home)
ckan – The open source data portal software
CKAN’s Administration Guide — CKAN Data Management System Documentation 1.7.4 documentation
Data Hub LOD Datasets gives an overview of Linked Data sources cataloged on Data Hub
schema.org Schema.org is a collaborative, community activity with a mission to create, maintain, and promote schemas for structured data on the Internet, on wJSONeb pages, in email messages, and beyond.
Light Weight Geographic Data
GeoJSON
Data Models
Dynamic segmentation—Help | ArcGIS for Desktop
What is the ArcGIS Network Analyst extension?—Help | ArcGIS Desktop
Get started with Pipeline Referencing—ArcGIS Pipeline Referencing for Desktop help | ArcGIS Desktop
What is Esri Roads and Highways?—Roads and Highways Desktop | ArcGIS Desktop
Navigation Data Standard - Wikipedia
Books
Kresse and Danko (2012) Springer handbook of geographic information [ntnu]
Wilson (2008) The handbook of geographic information science [ntnu]
Lake and Crowthe (2013 ) Concise guide to databases, Springer [NTNU SpringerLink ]
Foster and Godbole (2016) Database Systems- A Pragmatic Approach, 2nd ed, Springer [NTNU SpringerLink ]
Vohra (2016) Pro Docker, Apress, Berkeley, CA. [NTNU SpringerLink ]
Cook (2017) Docker for Data Science: Building Scalable and Extensible Data Infrastructure Around the Jupyter Notebook Server. Apress, Berkeley, CA. [NTNU SpringerLink ]