- Joined
- Aug 2, 2021
- Messages
- 5
This article will help you expand your first project with attribute-based geometry styles, filters and the possibility to export data to different data formats.
To do add a classification:
![Afbeelding1.png Afbeelding1.png](https://community.geospatialanalysis.online/data/attachments/0/413-1b259e5403deac3c32c4297740b2eed5.jpg)
The classification choices depend on the field types as configured in the business collection.
Here Attribute Lookup is used, follow the following steps:
![Afbeelding2.png Afbeelding2.png](https://community.geospatialanalysis.online/data/attachments/0/414-fe20b96c3da73d263f0c23b4405a22c9.jpg)
On the next screen:
![Afbeelding3.png Afbeelding3.png](https://community.geospatialanalysis.online/data/attachments/0/415-7117b0a183c56fc9d7cdd68889fd0321.jpg)
On this screen you can:
![Afbeelding4.png Afbeelding4.png](https://community.geospatialanalysis.online/data/attachments/0/449-6dd5f726efb19ed39e4192ca5cc75f56.jpg)
Lookup Groups can be configured and styled, with additional groups and values if needed. Additional classifications can also be built upon each other to create a hierarchy style in the style configuration.
To do this you:
![Afbeelding5.png Afbeelding5.png](https://community.geospatialanalysis.online/data/attachments/0/417-dd3c111297694f5cdc4197dcdcf4bd11.jpg)
Next step is to style the municipalities with a transparent colour.
Just follow the steps indicated in the image below.
![Afbeelding6.png Afbeelding6.png](https://community.geospatialanalysis.online/data/attachments/0/418-afbee422415a7ff04565c0d34649b9cb.jpg)
Now we have an overview of the map, looking at the municipality “Zwolle” where the cables are located. Some cables are located outside of Zwolle though.
Explanation of the picture below: the orange lines are the municipal boundaries, the blue lines are the cables and the black ovals indicate where cables are outside the boundary of Zwolle.
![Afbeelding7.png Afbeelding7.png](https://community.geospatialanalysis.online/data/attachments/0/419-d4bec59b032d130bbf7e67fb96b9187c.jpg)
![Afbeelding8.png Afbeelding8.png](https://community.geospatialanalysis.online/data/attachments/0/448-5664cf9fa3ed5d1923085dd0af286c14.jpg)
How to set a filter for Municipality = Zwolle.
![Afbeelding9.png Afbeelding9.png](https://community.geospatialanalysis.online/data/attachments/0/422-51b6bfd64ddafe0e86221f30dae8ff63.jpg)
In the municipality lookup table, a filter is set on Gemeentena equals Zwolle. Only 1 record will be found in the municipality dataset with that value.
In the business collection table, a filter is set on Municipality with the operator Has a value.
Now only cables which have the attribute Zwolle in their municipality table field will be looked up and selected in the business collection.
Cables are no longer shown in the black oval, they are filtered out.
![Afbeelding10.png Afbeelding10.png](https://community.geospatialanalysis.online/data/attachments/0/423-36b9f7d4c322657acfdef626e11d3714.jpg)
Filtered result: only one value in Municipality (in this case Zwolle).
![Afbeelding11.png Afbeelding11.png](https://community.geospatialanalysis.online/data/attachments/0/424-4435275175bb8346ef37f9b2a8aedaac.jpg)
Unfiltered results, more than one value in Municipality.
![Afbeelding12.png Afbeelding12.png](https://community.geospatialanalysis.online/data/attachments/0/425-fa2dee215f48ff7b97103a792483ded7.jpg)
When you browse the collection, you will see only the objects that are passed by the filter.
![Afbeelding13.png Afbeelding13.png](https://community.geospatialanalysis.online/data/attachments/0/447-c7343b7550f77b92e803ba905a3778c7.jpg)
On the map, only cables interacting with the municipality Zwolle will be displayed now.
Likewise, the filters in the business collection can be set to get the opposite selection of cables (only cables outside the municipality ‘Zwolle’)
![Afbeelding15.png Afbeelding15.png](https://community.geospatialanalysis.online/data/attachments/0/427-f9926cb204c2ab8d26e73d61a68bbaa9.jpg)
![Afbeelding14.png Afbeelding14.png](https://community.geospatialanalysis.online/data/attachments/0/451-c86490faedbbcd324b1563b3d9680ab8.jpg)
![Afbeelding16.png Afbeelding16.png](https://community.geospatialanalysis.online/data/attachments/0/431-3902a9d7f46bffb3e49931468c602aa3.jpg)
![Afbeelding17.png Afbeelding17.png](https://community.geospatialanalysis.online/data/attachments/0/432-c021723fbdc5b6f8cf87ad2520531176.jpg)
You can add or edit fields using the editor mode. If you right click on the business collection and use Add field using Expression, the editor mode opens.
![Afbeelding18.png Afbeelding18.png](https://community.geospatialanalysis.online/data/attachments/0/433-e8632fdef46d85edb09864aecf37f656.jpg)
Suggestions and additional expressions will be shown automatically when you start typing, so you don’t need to know exactly what to type in the editor.
![Afbeelding19.png Afbeelding19.png](https://community.geospatialanalysis.online/data/attachments/0/434-cd4c2c660d1e811d0c781a123bf6f1cc.jpg)
For now, we will add a buffer of 1 meter to the cables, which is a multi-polygon type; the field type is decided automatically, based on the output type of the expression. You can also use these newly created polygons for further (spatial) analysis in the business collection.
Create the expression.
![Afbeelding20.png Afbeelding20.png](https://community.geospatialanalysis.online/data/attachments/0/435-7d346dad110eaae59fceb0c3f18a36bd.jpg)
A style is automatically generated, you can edit the style here if you want.
![Afbeelding21.png Afbeelding21.png](https://community.geospatialanalysis.online/data/attachments/0/436-e1c36fdbf2179c2ad017cfb60a9b0937.jpg)
Give the new expression field a name.
![Afbeelding22.png Afbeelding22.png](https://community.geospatialanalysis.online/data/attachments/0/437-8189e9c3254bb47cadf2e961e693fc2e.jpg)
Click Finish.
![Afbeelding23.png Afbeelding23.png](https://community.geospatialanalysis.online/data/attachments/0/438-fe8a6552b0e024e77c8690b94433023b.jpg)
Go to the Map tab, zoomed in you can easily see the difference in appearance. The first image are just the cables, the second image are the cables with the 1-meter buffer.
![Afbeelding25.png Afbeelding25.png](https://community.geospatialanalysis.online/data/attachments/0/440-b53995a78eec56af31d6771eb7f90b3e.jpg)
Just toggle the styles in the Themes tab to get the images above.
![Afbeelding31.png Afbeelding31.png](https://community.geospatialanalysis.online/data/attachments/0/441-162a9c0ca723229380991aa867788d22.jpg)
If you browse a collection, you can immediately export the results, as either the whole result list or only the selection (which is 1, selected in blue, in the example above).
The available formats to export to are shown in the drop-down menu. The choices depend on your business collection and source collections that are added in the project file.
![Afbeelding26.png Afbeelding26.png](https://community.geospatialanalysis.online/data/attachments/0/442-308681c21d5b9f1826c45e53be3951fa.jpg)
For example, a business collection without any geometry, cannot be exported to a shapefile. And you can only export to a SQL Server database, when there is a SQL connection available as feature source.
Exporting from the menu is similar, but there are more options available. You can import and export a project file or generate an activator file, to save the current map extent.
To go to the menu, click in left hand top corner on Project tab.
![Afbeelding29.png Afbeelding29.png](https://community.geospatialanalysis.online/data/attachments/0/443-ae9bf7d34a15f45b372f0430f79ced6f.jpg)
You can choose to export the entire business collection, or only the data shown on the current map extent. More dialog options will appear to further specify the export options.
![Afbeelding28.png Afbeelding28.png](https://community.geospatialanalysis.online/data/attachments/0/450-b9c43cfc63da6a42d3dd2752c9a28096.jpg)
Set the options so the export is to your liking and click Next.
![Afbeelding30.png Afbeelding30.png](https://community.geospatialanalysis.online/data/attachments/0/445-43f072ba2ce49c36bdea64d0646e5b1f.jpg)
Prerequisites:
- Latest version of Professional or Ultimate edition of the desktop product
- Configured location of the project store to save your project file
- File based data sources (GeoPackage and ESRI Shapefile)
- Download the sample project and data
Recommended:
- Completed the first article: Creating your first project
Step 1: Configuring the geometry style based on an attribute
We already gave the E_MV_Map_Cables a solid black colour style, but you can also style objects based on their attributes by adding a classification.To do add a classification:
- Right click on the style
- Click on Add Classification
![Afbeelding1.png Afbeelding1.png](https://community.geospatialanalysis.online/data/attachments/0/413-1b259e5403deac3c32c4297740b2eed5.jpg)
The classification choices depend on the field types as configured in the business collection.
Here Attribute Lookup is used, follow the following steps:
- Select the radio button before Attribute Lookup and select Description from the dropdown list
- Click Get Classes
- Click OK
![Afbeelding2.png Afbeelding2.png](https://community.geospatialanalysis.online/data/attachments/0/414-fe20b96c3da73d263f0c23b4405a22c9.jpg)
On the next screen:
- Click Calculate
- Look at the calculated values of Description
- Click Use
![Afbeelding3.png Afbeelding3.png](https://community.geospatialanalysis.online/data/attachments/0/415-7117b0a183c56fc9d7cdd68889fd0321.jpg)
On this screen you can:
- Adjust the Palette colours, Width and Transparency of the style
- Optionally adjust the Style of the individual Lookup Groups
- Click OK to leave this screen
![Afbeelding4.png Afbeelding4.png](https://community.geospatialanalysis.online/data/attachments/0/449-6dd5f726efb19ed39e4192ca5cc75f56.jpg)
Lookup Groups can be configured and styled, with additional groups and values if needed. Additional classifications can also be built upon each other to create a hierarchy style in the style configuration.
To do this you:
- Right click the classification group that you want to extend
- Click on Add Classification (the next steps are described above)
![Afbeelding5.png Afbeelding5.png](https://community.geospatialanalysis.online/data/attachments/0/417-dd3c111297694f5cdc4197dcdcf4bd11.jpg)
Next step is to style the municipalities with a transparent colour.
Just follow the steps indicated in the image below.
![Afbeelding6.png Afbeelding6.png](https://community.geospatialanalysis.online/data/attachments/0/418-afbee422415a7ff04565c0d34649b9cb.jpg)
Now we have an overview of the map, looking at the municipality “Zwolle” where the cables are located. Some cables are located outside of Zwolle though.
Explanation of the picture below: the orange lines are the municipal boundaries, the blue lines are the cables and the black ovals indicate where cables are outside the boundary of Zwolle.
![Afbeelding7.png Afbeelding7.png](https://community.geospatialanalysis.online/data/attachments/0/419-d4bec59b032d130bbf7e67fb96b9187c.jpg)
Step 2: Adding data filters
To see the number of cables that are in the municipality of Zwolle, you can do a statistics check. You do this as follows:- Select the business collection: E_Mv_Map_Cable
- Click the Collection Statistics button (a pop-up appears)
- Select the Field Value Distribution tab
- Select the Field: Municipality
- Click on Calculate
- See the result for Zwolle in this row
![Afbeelding8.png Afbeelding8.png](https://community.geospatialanalysis.online/data/attachments/0/448-5664cf9fa3ed5d1923085dd0af286c14.jpg)
Builder mode
For further analysis of this collection, you can add filters to the business collection. Or, if you want or have to modify the data, you can add expressions.How to set a filter for Municipality = Zwolle.
- Select the collection E_Mv_Map_Cable
- Click on the Configure button
- Click on Filter in the column Municipalities (municipalities)
- Click on the Builder button
- Click on Add
- Select the field Gemeentena
- Click on Filter in the column E_Mv_Map_Cable
- Click on the Builder button
- Click on Add
- Select the field Municipality, select the operator Has a value
![Afbeelding9.png Afbeelding9.png](https://community.geospatialanalysis.online/data/attachments/0/422-51b6bfd64ddafe0e86221f30dae8ff63.jpg)
In the municipality lookup table, a filter is set on Gemeentena equals Zwolle. Only 1 record will be found in the municipality dataset with that value.
In the business collection table, a filter is set on Municipality with the operator Has a value.
Now only cables which have the attribute Zwolle in their municipality table field will be looked up and selected in the business collection.
Cables are no longer shown in the black oval, they are filtered out.
![Afbeelding10.png Afbeelding10.png](https://community.geospatialanalysis.online/data/attachments/0/423-36b9f7d4c322657acfdef626e11d3714.jpg)
Filtering in Business Collections
Any filters or expressions set in the business collection are only applicable for that specific business collection. The source data is never actually changed.Filtered result: only one value in Municipality (in this case Zwolle).
![Afbeelding11.png Afbeelding11.png](https://community.geospatialanalysis.online/data/attachments/0/424-4435275175bb8346ef37f9b2a8aedaac.jpg)
Unfiltered results, more than one value in Municipality.
![Afbeelding12.png Afbeelding12.png](https://community.geospatialanalysis.online/data/attachments/0/425-fa2dee215f48ff7b97103a792483ded7.jpg)
When you browse the collection, you will see only the objects that are passed by the filter.
![Afbeelding13.png Afbeelding13.png](https://community.geospatialanalysis.online/data/attachments/0/447-c7343b7550f77b92e803ba905a3778c7.jpg)
On the map, only cables interacting with the municipality Zwolle will be displayed now.
Likewise, the filters in the business collection can be set to get the opposite selection of cables (only cables outside the municipality ‘Zwolle’)
![Afbeelding15.png Afbeelding15.png](https://community.geospatialanalysis.online/data/attachments/0/427-f9926cb204c2ab8d26e73d61a68bbaa9.jpg)
![Afbeelding14.png Afbeelding14.png](https://community.geospatialanalysis.online/data/attachments/0/451-c86490faedbbcd324b1563b3d9680ab8.jpg)
Editor Mode
Instead of the builder mode, which is suited for quick lookup selections, the editor mode is shown below. The editor mode allows you to make more advanced filters and calculations. You can also first use the builder mode, and then switch to editor mode to see how the filter has been translated in editor mode.![Afbeelding16.png Afbeelding16.png](https://community.geospatialanalysis.online/data/attachments/0/431-3902a9d7f46bffb3e49931468c602aa3.jpg)
![Afbeelding17.png Afbeelding17.png](https://community.geospatialanalysis.online/data/attachments/0/432-c021723fbdc5b6f8cf87ad2520531176.jpg)
You can add or edit fields using the editor mode. If you right click on the business collection and use Add field using Expression, the editor mode opens.
![Afbeelding18.png Afbeelding18.png](https://community.geospatialanalysis.online/data/attachments/0/433-e8632fdef46d85edb09864aecf37f656.jpg)
Suggestions and additional expressions will be shown automatically when you start typing, so you don’t need to know exactly what to type in the editor.
![Afbeelding19.png Afbeelding19.png](https://community.geospatialanalysis.online/data/attachments/0/434-cd4c2c660d1e811d0c781a123bf6f1cc.jpg)
For now, we will add a buffer of 1 meter to the cables, which is a multi-polygon type; the field type is decided automatically, based on the output type of the expression. You can also use these newly created polygons for further (spatial) analysis in the business collection.
Create the expression.
![Afbeelding20.png Afbeelding20.png](https://community.geospatialanalysis.online/data/attachments/0/435-7d346dad110eaae59fceb0c3f18a36bd.jpg)
A style is automatically generated, you can edit the style here if you want.
![Afbeelding21.png Afbeelding21.png](https://community.geospatialanalysis.online/data/attachments/0/436-e1c36fdbf2179c2ad017cfb60a9b0937.jpg)
Give the new expression field a name.
![Afbeelding22.png Afbeelding22.png](https://community.geospatialanalysis.online/data/attachments/0/437-8189e9c3254bb47cadf2e961e693fc2e.jpg)
Click Finish.
![Afbeelding23.png Afbeelding23.png](https://community.geospatialanalysis.online/data/attachments/0/438-fe8a6552b0e024e77c8690b94433023b.jpg)
Go to the Map tab, zoomed in you can easily see the difference in appearance. The first image are just the cables, the second image are the cables with the 1-meter buffer.
![Afbeelding24.png Afbeelding24.png](https://community.geospatialanalysis.online/data/attachments/0/439-20511859f1a12758f1a017ae5504b459.jpg)
![Afbeelding25.png Afbeelding25.png](https://community.geospatialanalysis.online/data/attachments/0/440-b53995a78eec56af31d6771eb7f90b3e.jpg)
Just toggle the styles in the Themes tab to get the images above.
![Afbeelding31.png Afbeelding31.png](https://community.geospatialanalysis.online/data/attachments/0/441-162a9c0ca723229380991aa867788d22.jpg)
Step 3: Exporting your data
There are multiple ways of exporting your data, either from the result list, or from the export option in the menu.If you browse a collection, you can immediately export the results, as either the whole result list or only the selection (which is 1, selected in blue, in the example above).
The available formats to export to are shown in the drop-down menu. The choices depend on your business collection and source collections that are added in the project file.
![Afbeelding26.png Afbeelding26.png](https://community.geospatialanalysis.online/data/attachments/0/442-308681c21d5b9f1826c45e53be3951fa.jpg)
For example, a business collection without any geometry, cannot be exported to a shapefile. And you can only export to a SQL Server database, when there is a SQL connection available as feature source.
Exporting from the menu is similar, but there are more options available. You can import and export a project file or generate an activator file, to save the current map extent.
To go to the menu, click in left hand top corner on Project tab.
![Afbeelding29.png Afbeelding29.png](https://community.geospatialanalysis.online/data/attachments/0/443-ae9bf7d34a15f45b372f0430f79ced6f.jpg)
You can choose to export the entire business collection, or only the data shown on the current map extent. More dialog options will appear to further specify the export options.
![Afbeelding28.png Afbeelding28.png](https://community.geospatialanalysis.online/data/attachments/0/450-b9c43cfc63da6a42d3dd2752c9a28096.jpg)
Set the options so the export is to your liking and click Next.
![Afbeelding30.png Afbeelding30.png](https://community.geospatialanalysis.online/data/attachments/0/445-43f072ba2ce49c36bdea64d0646e5b1f.jpg)
Last edited by a moderator: