{"id":142,"date":"2015-04-30T08:41:31","date_gmt":"2015-04-30T08:41:31","guid":{"rendered":"http:\/\/transnationalhistory.net\/mapping\/?page_id=142"},"modified":"2023-08-29T15:13:38","modified_gmt":"2023-08-29T15:13:38","slug":"performing-queries","status":"publish","type":"page","link":"https:\/\/transnationalhistory.net\/mapping\/tutorials\/performing-queries\/","title":{"rendered":"Performing Queries"},"content":{"rendered":"

Tutorial 6<\/strong><\/em><\/p>\n

 <\/p>\n

So far we have seen ways to depict and show phenomena and trends on a map. As historians, this opens up many opportunities for every researcher’s project. This tutorial is about learning from your map and getting data you didn’t know was already there for you. Layers aren’t just lines and shapes: they contain different types of information that you may find useful. It is something we saw already with CSV lists:\u00a0we\u00a0could add any information\u00a0we wanted in our CSV, but only the lat\/long points would be displayed. Let’s learn how to make the most out of your shapefiles.<\/p>\n

We will use the communes<\/em> (towns)\u00a0and d\u00e9partements<\/em> (districts) of France as a case study.<\/p>\n

STEP 1: GETTING FAMILIAR WITH ATTRIBUTE TABLES<\/strong><\/p>\n

I have added a coastline base layer and downloaded territorial data from the French governmental\u00a0IGN Donn\u00e9es<\/a> website.<\/p>\n

\"\"<\/a><\/p>\n

\"6<\/a>The map which is displayed here features 36,595 towns. As we said before, this layer is not just showing them – it has a detailed list of their names as well as other data. To see this, we need to access the attribute table<\/strong>. To do so, right click on the name of the layer and choose Open Attribute Table<\/strong>.<\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

\"6<\/a><\/p>\n

As you can see, the table precisely lists each town’s name, postcode, lat\/long, area, population, and the d\u00e9partement<\/em> and r\u00e9gion<\/em> it is part of. In other words, this is way more than what the map seemed to show!<\/p>\n

STEP 2: FILTERING\u00a0YOUR LAYER<\/strong><\/p>\n

The attribute table is great to access more information, but this sometimes needs to be filtered in order to only keep what is necessary. You can do so through the attribute table but this tutorial is going to show you a quicker way to filter your layer.<\/p>\n

We want to\u00a0focus on the French Riviera, on the south-eastern coast of France. More precisely I would like to only display the towns located in the d\u00e9partement<\/em> (district) of\u00a0Alpes-Maritimes<\/em>.<\/p>\n

Close your attribute table and right click again on your layer name, and choose Filter<\/strong>.\u00a0This part of the process is a bit tedious. In the window that just opened you will need to insert\u00a0an expression. Expressions are similar to mathematical formulas.<\/p>\n

\"6<\/a><\/p>\n

In the left column, you will find all the fields that you previously saw in the attribute table. Here we want to filter by district name, therefore we are selecting\u00a0NOM_DEPT<\/strong> and by clicking on All<\/strong>\u00a0in the right column, all the different district names appear. You can now easily build your expression by double clicking on each of its elements. Therefore, as you only the towns located in the Alpes-Maritimes<\/em> district to appear, your expression should be as follows:<\/p>\n

\"\"<\/a><\/p>\n

Click on\u00a0OK<\/strong>.\u00a0The map is now only showing the\u00a0communes\u00a0<\/em>of the\u00a0d\u00e9partement\u00a0<\/em>of\u00a0Alpes-Maritimes<\/em>, but you will always have the option of re-adding some other parts of the layer by changing your formula.<\/p>\n

\"\"<\/a><\/p>\n

STEP 3: FILTERING YOUR ATTRIBUTE TABLE BY DATA<\/strong><\/p>\n

Now that we have selected this\u00a0d\u00e9partement<\/em>, we would like to only show the towns which have a population higher than 20,000. This is a choice we are making for this tutorial. Step 2 and Step 3 can of course be done independently from each other.<\/strong><\/p>\n

Back in the Filter<\/strong> option, we are repeating the same process, by operating a new query.\u00a0The previous formula will still be there, you need to add the\u00a0“POPULATION” > 20000<\/strong> one\u00a0afterwards. Both should be separated by AND<\/strong> which is necessary in order to take both conditions under consideration.<\/p>\n

\"6<\/a><\/p>\n

We now have gone from over 36,000 towns to only 10.<\/p>\n

\"6<\/a><\/p>\n

Final result with railways added to the map<\/em><\/p>\n

MORE THAN ONE QUERY ON THE SAME SHAPEFILE?<\/strong><\/p>\n

\"6<\/a>Should\u00a0you want to filter two different elements of one single shapefile (e.g. two groups of French communes<\/em>), and deal with them separately, you may duplicate your layer and perform different queries on each of them. To duplicate a layer, right click on its name and click on duplicate.<\/p>\n

One step further: creating a new layer out of a query<\/a><\/strong><\/p>\n

 <\/p>\n

Last update: 1 June\u00a02015 on QGIS 2.8.1 Wien.<\/p>\n

Next tutorial:<\/a>
\nData Visualisation on your Map<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"

Tutorial 6   So far we have seen ways to depict and show phenomena and trends on a map. As historians, this opens up many opportunities for every researcher’s project. This tutorial is about learning from your map and getting data you didn’t know was already there for you. Layers aren’t just lines and shapes: […]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":8,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-142","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/transnationalhistory.net\/mapping\/wp-json\/wp\/v2\/pages\/142","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/transnationalhistory.net\/mapping\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/transnationalhistory.net\/mapping\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/transnationalhistory.net\/mapping\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/transnationalhistory.net\/mapping\/wp-json\/wp\/v2\/comments?post=142"}],"version-history":[{"count":2,"href":"https:\/\/transnationalhistory.net\/mapping\/wp-json\/wp\/v2\/pages\/142\/revisions"}],"predecessor-version":[{"id":597,"href":"https:\/\/transnationalhistory.net\/mapping\/wp-json\/wp\/v2\/pages\/142\/revisions\/597"}],"up":[{"embeddable":true,"href":"https:\/\/transnationalhistory.net\/mapping\/wp-json\/wp\/v2\/pages\/8"}],"wp:attachment":[{"href":"https:\/\/transnationalhistory.net\/mapping\/wp-json\/wp\/v2\/media?parent=142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}