官术网_书友最值得收藏!

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'
主站蜘蛛池模板: 西青区| 西畴县| 炉霍县| 阳信县| 自治县| 扶沟县| 苍山县| 桐柏县| 红安县| 茶陵县| 金阳县| 济宁市| 卓资县| 迭部县| 南阳市| 玉田县| 刚察县| 高邮市| 皮山县| 高密市| 元阳县| 汉沽区| 万年县| 陇南市| 宜丰县| 海伦市| 沙湾县| 平乡县| 滁州市| 夏邑县| 耒阳市| 扬州市| 望江县| 福清市| 新干县| 福鼎市| 贺州市| 雷波县| 封开县| 玉林市| 牡丹江市|