Last modified by Robin Huisman on 2023/03/01 16:34

Show last authors
1 = What is possible with the TerraIndex geoserver in QGIS? =
2
3
4 Some video's and demo's on our YouTube channel;
5
6 **Short demo video;**
7
8 [[https:~~/~~/www.youtube.com/watch?v=tajDDZf7Ths>>https://www.youtube.com/watch?v=tajDDZf7Ths]]
9
10
11 **(Dutch) Inhoudelijke sessie in het webinar:**
12
13 [[https:~~/~~/youtu.be/oBfX5rZLnf8?t=3579>>https://youtu.be/oBfX5rZLnf8?t=3579]]
14
15
16 == A Quick overview ==
17
18 Show pinned projects on the map:
19
20 (% style="text-align:center" %)
21 [[image:image-20211123100500-16.png]]
22
23 Show measurement objects with custom icons on the map:
24
25 [[image:image-20211123100500-17.png]]
26
27 Filter and show measurement objects:
28
29 (% style="text-align:center" %)
30 [[image:image-20211123100500-18.png]]
31
32 Show lab and or assessment results with your measurement points, make contours and be able to filter / search within those results
33
34 (% style="text-align:center" %)
35 [[image:image-20211123100500-19.png]]
36
37 With a print template it's easy to design a borehole map in your own templates:
38
39 (% style="text-align:center" %)
40 [[image:1637658541236-521.png]]
41
42
43 == These layers are availlable in the Geoserver: ==
44
45 (% class="table-hover" %)
46 |**Dataset:**|**All Projects_MeasurementPoints_pnt**|
47 |Goal:|(% colspan="2" %)(((
48 Show all projects of the company, with all measurement objects (20K limit), so the user can find his projects on the map.
49
50 Usefull for finding projects that have been done in the past.
51 )))
52 |Details|(% colspan="2" %)(((
53 Must be clickable to request the data of the project that a user can see on the map. ProjectCode, projectname and Projectguid need to be visible. Alternatively, you can Pin the project to your account in TerraIndex to check the details.
54 )))
55
56 (% class="table-hover" %)
57 |**Dataset:**|**Projects_pnt**|
58 |Goal:|(% colspan="2" %)Show which projects are pinned so a cuser can use it to find his projects on the map. Useful to get a quick and easy oversight of your own projects.
59 Possible to filter with options such as 'Client' or "Startdate / Enddate"
60 |Feedback:|(% colspan="2" %)(((
61 * Fields "opdrachtgever", "adviesbureau", "startdatum", "einddatum" are missing ; dates are in datetime, not just date
62 * A client can get a map with all pinned projects attached to a special username, so only his projects are shown. Sometimes advisor wants to show all projects and not just pinned ones. How to solve this?
63 )))
64 | |(% colspan="2" %)
65 | | |
66 |**Dataset:**|**MeasurementPoints_pnt**|
67 |Goal:|Showing the different kind of measurement objects on the map so it's clear which type of measurement objects have been done at the location. Can create a map with labels and height afterwards for example.|
68 |Feedback:|(((
69 * Is it possible to get an indicator of a watersoil measurementobject, asfalt-core or combinations?
70 * The combinations that are requested are:
71 ** Asbestoshole with borehole
72 ** Asbestoshole with borehole and a filtertube
73 ** borehole with filtertube
74 ** Coredrill met een borehole
75 ** Coredrill with asbestoshole with borehole with filtertube
76 ** etc..
77 )))|coredrill is is not yet a type (used for asalt / concrete cores)
78 | | |
79 |**Dataset:**|**SampleResults_GR_NL_pnt**|
80 |Goal:|(% colspan="2" %)Showing of the assessment results of the samples per analysis sample, so the quality of the soil can be shown on top of the measurement objects. Must be filtered on sample conclusion, depth and assessment result
81 Assessment samples of BBK (T1, T2, T3, T4, T5, T6 en T7) + WBB (T12)
82 | | |
83 |**Dataset:**|**SampleResults_NL_GW_pnt**|
84 |Goal:|(% colspan="2" %)(((
85 (% class="table-hover" %)
86 |(% colspan="2" %)Showing of the assessment results of the watersamples, so the quality of the groundwater can be shown on top of the measurement objects. Must be filtered on sample conclusion, depth and assessment result
87 Assessment samples of WBB (T13)
88 )))
89 | | |
90 |**Dataset:**|**ParameterResults_NL_GR_WBB_T12_pnt**|
91 |Goal:|(% colspan="2" %)(((
92 Per subsample all parameters will all results must be showed so you can see per invidival compound what the pollution is at a specific measurement point. You can filter by depth, parameter and testresult. This way you can search for a specific testresult of a specific parameter.
93 )))
94 | | |
95 |**Dataset:**|**ParameterResults_NL_GW_WBB_T13_pnt**|
96 |Goal:|(% colspan="2" %)(((
97 All parameters with results must be shown per water sample so that per parameter you can see what the exceedance is in the groundwater at the location of a measuring point. There must be filtered at depth, parameter and testresult. As a label you could use parameter with measured value and / or testresult. By giving the parameters per soil tube you can see in the depth where the pollution is.
98 )))
99 | | |
100 |**Dataset:**|**ParameterResults_NL_GR_BBK_T1T2_pnt**|
101 |Goal:|(% colspan="2" %)(((
102 All parameters with results must be shown per sub-sample so that per parameter can be shown what the exceedance is at the location of a measuring point. There must be a filter for depth, parameter and testresult. As a label you could use parameter with measured value and / or judgment. By giving the substances per sub-sample, you can clearly indicate at which measuring points exceeds testresults for lead for example.
103 )))
104 | | |
105 |**Dataset:**|**ParameterResults_NL_GR_BBK_T[3-7]_pnt**|(((
106 TESTSUBFRAMEWORKID:
107
108 T3 = 21, T4 = 22, T5 = 23, T6 = 24, T7 = 25
109 )))
110 |Goal:|(% colspan="2" %)(((
111 All parameters with results must be shown per sub-sample so that per parameter can be shown what the exceedance is at the location of a measuring point. There must be filtered at depth, parameter and testresult. As a label you could use parameter with measured value and / or testresult. By giving the substances per sub-sample, you can clearly indicate at which measuring points exceeds the test from, for example, lead.
112 )))
113 | | |
114 |Dataset:|eigen normen_how_pnt|ONTBREEKT NOG
115 |-|(% colspan="2" %)dataset missing, no showing of testresults (like lowest maximum values) per measurement object possible
116 |-|(% colspan="2" %)setup and fields of dataset "wbb_grond_how_pnt" but with own assessments
117 |-|(% colspan="2" %)field "date", just date (no datetime combination)
118 |-|field with "projectcode"|
119 |-|(% colspan="2" %)Fields "mvhoogte", "refvlak" (To calculate the depth relative to the reference point)
120 | | |
121 |Dataset:|testresults_eigen normen|ONTBREEKT NOG
122 |-|(% colspan="2" %)dataset missing, no showing of testresults (like lowest maximum values) per measurement object possible
123 |-|(% colspan="2" %)setup and fields of dataset "testresults_wbb_grond" but with own assessments
124 |-|(% colspan="2" %)field "date", just date (no datetime combination)
125 |-|field with "projectcode"|
126 |-|(% colspan="2" %)Fields "mvhoogte", "refvlak" (To calculate the depth relative to the reference point)
127 | | |
128 | | |
129 |**Dataset:**|**Fieldresults_GW_pnt**|
130 |Goal:|(% colspan="2" %)Showing watersamples on the map, with other visual oberservations.
131 | | |
132 |**Dataset:**|**Fieldresults_GR_pnt**|
133 |Goal:|(% colspan="2" %)Exchanging depths on the map of, for example, clay layers and other visual observations.
134 | | |
135 |**Dataset:**|**ParameterResults_BE_GR_VLAREBO_pnt**|
136 |Goal:|(% colspan="2" %)All parameters with results must be shown per sub-sample so that per parameter can be shown what the exceedance is at the location of a measuring point. There must be a filter for depth, parameter and testresult. As a label you could use parameter with measured value and / or judgment. By giving the substances per sub-sample, you can clearly indicate at which measuring points exceeds testresults for lead for example.
137 | | |
138 |**Dataset:**|**ParameterResults_BE_GW_VLAREBO_pnt**|
139 |Goal:|(% colspan="2" %)All parameters with results must be shown per water sample so that per parameter you can see what the exceedance is in the groundwater at the location of a measuring point. There must be filtered at depth, parameter and testresult. As a label you could use parameter with measured value and / or testresult. By giving the parameters per soil tube you can see in the depth where the pollution is.
140 | | |
141 |Dataset:|Brussel GR|ONTBREEKT NOG
142 | | |
143 |Dataset:|Waalse GR|ONTBREEKT NOG
144 | | |
145 |Dataset:|Vlarebo Grondverzet|ONTBREEKT NOG
146 | | |
147 |Dataset:|Project locatie|ONTBREEKT NOG  ~*~* HH Delfland zou dit willen met de baggervak lijnen
148 | | |
149 | | |
150
151
TerraIndex
asd