- QGIS 2 Cookbook
- Alex Mandel Víctor Olaya Ferrero Anita Graser Alexander Bruy
- 420字
- 2021-07-16 11:12:40
Configuring relations
In the Joining layer data recipe, we discussed that joins only append additional columns to existing features (1:1 or n:1 relationships). Using joins, it is, therefore, not possible to model 1:n relationships, such as "one zip code area containing n schools". These kinds of relationships can instead be modeled using relations. This recipe introduces the concept of relations and shows how you can put them to use.
Getting ready
To follow this exercise, load zip code areas and schools from zipcodes_wake.shp and schools_wake.shp.
How to do it…
Relations are configured in Project Properties. The dialog is very similar to the join dialog:
- Define the two layers (Referencing/Child and Referenced/Parent), as well as the fields containing the common values/IDs. As you want to model "one zip code area contains n schools," the zip code dataset is the parent layer and the school dataset is the child layer. The connection between both datasets is established based on the zip code fields (ADDRZIPCOD and ZIPNUM), as shown in the following screenshot:
- To verify that the relation is set up and working, you can either check the attribute table in form view (button in the lower-right corner), as shown in the following screenshot, or open an individual feature form. You will find that the relation information has been appended at the end of the form:
As the preceding screenshot shows, setting up this relation enables you to get access to all schools within a certain zip code in a very convenient way. As the edit button suggests, it is even possible to edit the school data from this view. You can simply edit the values in the table view. You can add and delete schools from the dataset using the + and X buttons. The next two buttons enable you to quickly add new entries to the relation or to remove them.
How it works…
In this example, removing a school from the dataset works just fine, but adding a school via this dialog makes less sense because you cannot create a point geometry through this process.
If you press the button to add to the relation, you will get a dialog that allows you to choose which existing school you want to add. In the background, the school's ADDRZIPCOD value is updated to match the zip code we just assigned it to.
Similarly, if you select a school and press the button to remove the relation, what actually happens is that the school's ADDRZIPCOD value is set to NULL.
- R語言經典實例（原書第2版）
- Mastering Yii
- Securing WebLogic Server 12c
- Eclipse Plug-in Development：Beginner's Guide（Second Edition）
- 重學Java設計模式
- 小學生C++創意編程（視頻教學版）
- SQL經典實例（第2版）
- WordPress 4.0 Site Blueprints（Second Edition）
- 零基礎Java學習筆記
- The Professional ScrumMaster’s Handbook
- Raspberry Pi Robotic Blueprints
- 3ds Max印象 電視欄目包裝動畫與特效制作
- RESTful Web Clients：基于超媒體的可復用客戶端
- iOS開發項目化入門教程
- Python Digital Forensics Cookbook