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

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'
主站蜘蛛池模板: 阳谷县| 青龙| 萍乡市| 武义县| 宁国市| 大理市| 白山市| 三河市| 隆林| 鄢陵县| 卫辉市| 墨竹工卡县| 仪征市| 开平市| 开原市| 任丘市| 丹阳市| 若尔盖县| 塘沽区| 北票市| 饶平县| 扎兰屯市| 郓城县| 永川市| 广东省| 平阳县| 德安县| 安塞县| 株洲市| 澄江县| 洪泽县| 安西县| 从化市| 沁水县| 乐东| 台北市| 沙雅县| 遂溪县| 芜湖县| 札达县| 景泰县|