- Practical GIS
- Gábor Farkas
- 311字
- 2021-07-02 22:49:15
SQL in GIS
SQL is the query language of relational databases. Traditionally, it was developed to help make easy and powerful queries on relational tables. As attribute data can be considered tabular, its power for creating intuitive queries on vector layers is unquestionable. No matter if some modern GIS software uses an object-oriented structure for working with vector data internally, the tradition of using SQL, or near-SQL syntax for creating simple queries has survived. This language is very simple at its core, thus, it is easy to learn and understand. A simple query on a database looks like the following:
SELECT * FROM table WHERE column = value;
It uses the * wildcard for selecting everything from the table named table, where the content of the column named column matches value. In GIS software, like QGIS, this line can be translated to the following:
SELECT * FROM layer WHERE column = value;
Furthermore, as basic queries only allow selecting from one layer at a time, the query can be simplified as the software knows exactly which layer we would like to query. Therefore, this simple query can be formulated in a GIS as follows:
column = value
There is one final thing we have to keep in mind. Based on the software we use, these queries can be turned into real SQL queries used on internal relational tables, or parsed into something entirely different. As a result, GIS software can have their own SQL flavor with their corresponding syntactical conventions. In QGIS, the most important convention is how we differentiate column names from regular strings. Column names are enclosed in double quotation marks, while strings are enclosed in single ones. If we turn the previous query into a QGIS SQL syntax and consider value as a string, we get the following query:
"column" = 'value'
- Learning Scala Programming
- R語言經典實例(原書第2版)
- Hands-On Data Structures and Algorithms with JavaScript
- PostgreSQL技術內幕:事務處理深度探索
- Vue.js 3.0源碼解析(微課視頻版)
- Object-Oriented JavaScript(Second Edition)
- 深入淺出RxJS
- Access 2016數據庫管
- Haxe Game Development Essentials
- WebRTC技術詳解:從0到1構建多人視頻會議系統
- Unity UI Cookbook
- Swift 4從零到精通iOS開發
- Visual Basic程序設計習題與上機實踐
- Python Projects for Kids
- 算法秘籍