Groundwater Monitoring Wells (GMW)

Download a GroundwaterMonitoringWell using the class method GroundwaterMonitoringWell.from_bro_id.

import matplotlib.pyplot as plt
import brodata
gmw = brodata.gmw.GroundwaterMonitoringWell.from_bro_id("GMW000000049567")
gmw
GroundwaterMonitoringWell(broId='GMW000000049567', x=117892.6, y=439651.9)

Tube metadata for this GroundwaterMonitoringWell is stored in the monitoringTube attribute as a pandas DataFrame.

gmw.monitoringTube.T
tubeNumber 1 2
tubeType standaardbuis standaardbuis
artesianWellCapPresent onbekend onbekend
sedimentSumpPresent onbekend onbekend
numberOfGeoOhmCables 0 0
tubeTopDiameter NaN NaN
variableDiameter onbekend onbekend
tubeStatus onbekend onbekend
tubeTopPosition -0.15 -0.25
tubeTopPositioningMethod onbekend onbekend
tubePartInserted nee nee
tubeInUse ja ja
tubePackingMaterial onbekend onbekend
tubeMaterial onbekend onbekend
glue onbekend onbekend
screenLength 1.0 1.0
sockMaterial onbekend onbekend
screenTopPosition -1.95 -14.0
screenBottomPosition -2.95 -15.0
plainTubePartLength 1.8 13.75

Use to_dict() to view the remaining data for the GroundwaterMonitoringWell.

gmw_data = gmw.to_dict()
gmw_data.pop("monitoringTube")
gmw_data
{'broId': 'GMW000000049567',
 'constructionStandard': 'onbekend',
 'coordinateTransformation': 'RDNAPTRANS2008',
 'corrected': 'nee',
 'deliveredLocation': <POINT (117892.6 439651.9)>,
 'deliveryAccountableParty': '29010639',
 'deliveryContext': 'WW',
 'deregistered': 'nee',
 'groundLevelPosition': 0.01,
 'groundLevelPositioningMethod': 'onbekend',
 'groundLevelStable': 'onbekend',
 'horizontalPositioningMethod': 'onbekend',
 'id': 'BRO_0003',
 'initialFunction': 'kwaliteitStand',
 'localVerticalReferencePoint': 'NAP',
 'nitgCode': 'B38B0036',
 'numberOfMonitoringTubes': '2',
 'objectRegistrationTime': '2021-06-29T12:31:39+02:00',
 'offset': 0.0,
 'owner': '29010639',
 'qualityRegime': 'IMBRO/A',
 'registrationStatus': 'geregistreerd',
 'removed': 'nee',
 'reregistered': 'nee',
 'standardizedLocation': <POINT (4.848 51.944)>,
 'underReview': 'nee',
 'verticalDatum': 'NAP',
 'wellCode': 'GMW38B000036',
 'wellConstructionDate': Timestamp('1985-03-01 00:00:00'),
 'wellHeadProtector': 'onbekend',
 'wellStability': 'onbekend',
 'withPrehistory': 'ja'}

Groundwater monitoring wells within an extent

Use get_characteristics(extent=...) to download all wells in a bounding box; the result is a GeoDataFrame.

extent = [117700, 118700, 439400, 440400]
gdf = brodata.gmw.get_characteristics(extent=extent)
gdf
id deregistered deliveryAccountableParty qualityRegime objectRegistrationTime underReview standardizedLocation deliveredLocation localVerticalReferencePoint offset ... initialFunction numberOfMonitoringTubes wellHeadProtector wellCode statusOverview smallestTubeTopDiameter largestTubeTopDiameter shallowestScreenTopPosition deepestScreenBottomPosition nitgCode
broId
GMW000000036286 BRO_0002 nee 62251686 IMBRO 2020-09-15T10:17:38+02:00 nee POINT (4.84630647 51.94507673) POINT (117810.325 439763.468) NAP 0.000 ... stand 1 potNietWaterdicht GMW38B125169 gebruiksklaar 63 63 -2.194 -3.194 NaN
GMW000000036287 BRO_0005 nee 62251686 IMBRO 2020-09-15T10:17:39+02:00 nee POINT (4.85343324 51.94514556) POINT (118300.381 439767.501) NAP 0.000 ... stand 1 potNietWaterdicht GMW38B125170 gebruiksklaar 63 63 0.142 -0.858 NaN
GMW000000036308 BRO_0008 nee 62251686 IMBRO 2020-09-15T10:17:55+02:00 nee POINT (4.84975387 51.94724594) POINT (118049.133 440003.042) NAP 0.000 ... stand 1 potNietWaterdicht GMW38B125191 gebruiksklaar 63 63 -1.289 -2.289 NaN
GMW000000036318 BRO_0011 nee 62251686 IMBRO 2020-09-15T10:18:02+02:00 nee POINT (4.85477987 51.94876576) POINT (118395.916 440169.584) NAP 0.000 ... stand 1 potNietWaterdicht GMW38B125201 gebruiksklaar 63 63 -2.029 -3.028 NaN
GMW000000036319 BRO_0014 nee 62251686 IMBRO 2020-09-15T10:18:03+02:00 nee POINT (4.84844683 51.94450022) POINT (117957.01 439698.236) NAP 0.000 ... stand 1 potNietWaterdicht GMW38B125202 gebruiksklaar 63 63 -1.721 -2.721 NaN
GMW000000036327 BRO_0017 nee 62251686 IMBRO 2020-09-15T10:18:08+02:00 nee POINT (4.84999476 51.94542172) POINT (118064.196 439799.968) NAP 0.000 ... stand 1 potNietWaterdicht GMW38B125210 gebruiksklaar 63 63 -0.833 -1.833 NaN
GMW000000036328 BRO_0020 nee 62251686 IMBRO 2020-09-15T10:18:09+02:00 nee POINT (4.85402244 51.94691658) POINT (118342.335 439964.237) NAP 0.000 ... stand 1 potNietWaterdicht GMW38B125211 gebruiksklaar 63 63 0.795 -0.205 NaN
GMW000000036339 BRO_0023 nee 62251686 IMBRO 2020-09-15T10:18:16+02:00 nee POINT (4.8582415 51.94644263) POINT (118632.021 439909.388) NAP 0.000 ... stand 1 potNietWaterdicht GMW38B125222 gebruiksklaar 63 63 -2.695 -3.695 NaN
GMW000000036354 BRO_0026 nee 62251686 IMBRO 2020-09-15T10:18:26+02:00 nee POINT (4.84846165 51.94841901) POINT (117961.258 440134.209) NAP 0.000 ... stand 1 potNietWaterdicht GMW38B125237 gebruiksklaar 63 63 -1.987 -2.987 NaN
GMW000000036365 BRO_0029 nee 62251686 IMBRO 2020-09-15T10:18:34+02:00 nee POINT (4.85092752 51.94437584) POINT (118127.47 439683.136) NAP 0.000 ... stand 1 potNietWaterdicht GMW38B125248 gebruiksklaar 63 63 -0.429 -1.428 NaN
GMW000000036371 BRO_0032 nee 62251686 IMBRO 2020-09-15T10:18:38+02:00 nee POINT (4.84776429 51.94715191) POINT (117912.269 439993.594) NAP 0.000 ... stand 1 potNietWaterdicht GMW38B125254 gebruiksklaar 63 63 -1.200 -2.200 NaN
GMW000000049567 BRO_0035 nee 29010639 IMBRO/A 2021-06-29T12:31:39+02:00 nee POINT (4.84751508 51.94407946) POINT (117892.6 439651.9) NAP 0.000 ... kwaliteitStand 2 onbekend GMW38B000036 onbekend NaN NaN -1.950 -15.000 B38B0036
GMW000000088148 BRO_0038 nee 62251686 IMBRO 2025-01-14T10:55:07+01:00 nee POINT (4.854680138 51.948915273) POINT (118389.181 440186.268) NAP 0.000 ... kwaliteit 1 kokerNietMetaal GMW38B147331 gebruiksklaar 63 63 -2.829 -3.829 NaN
GMW000000088161 BRO_0041 nee 62251686 IMBRO 2025-01-14T11:34:23+01:00 nee POINT (4.849696683 51.949186805) POINT (118046.797 440219) NAP 0.000 ... kwaliteit 1 kokerNietMetaal GMW38B147344 gebruiksklaar 63 63 -1.364 -2.364 NaN
GMW000000088163 BRO_0044 nee 62251686 IMBRO 2025-01-14T11:34:28+01:00 nee POINT (4.851410842 51.944341026) POINT (118160.672 439679.017) NAP 0.000 ... kwaliteit 1 potNietWaterdicht GMW38B147346 gebruiksklaar 40 40 0.473 -0.527 NaN
GMW000000088164 BRO_0047 nee 62251686 IMBRO 2025-01-14T11:34:29+01:00 nee POINT (4.85206629 51.945362545) POINT (118206.574 439792.333) NAP 0.000 ... kwaliteit 1 potNietWaterdicht GMW38B147347 gebruiksklaar 40 40 0.860 -0.140 NaN
GMW000000088166 BRO_0050 nee 62251686 IMBRO 2025-01-14T11:34:32+01:00 nee POINT (4.851341338 51.946466367) POINT (118157.635 439915.505) NAP 0.000 ... kwaliteit 1 potNietWaterdicht GMW38B147349 gebruiksklaar 63 63 0.868 -0.132 NaN
GMW000000088168 BRO_0053 nee 62251686 IMBRO 2025-01-14T11:34:34+01:00 nee POINT (4.847742039 51.947154025) POINT (117910.741 439993.841) NAP 0.000 ... kwaliteit 1 kokerMetaal GMW38B147351 gebruiksklaar 63 63 -1.413 -2.413 NaN
GMW000000088172 BRO_0056 nee 62251686 IMBRO 2025-01-14T11:34:42+01:00 nee POINT (4.848531422 51.948502099) POINT (117966.123 440143.417) NAP 0.000 ... kwaliteit 1 kokerNietMetaal GMW38B147355 gebruiksklaar 63 63 -1.653 -2.653 NaN

19 rows × 27 columns

Since it’s a GeoDataFrame, plotting the well locations is straightforward.

f, ax = plt.subplots()
ax.axis("scaled")
ax.axis(extent)
gdf.plot(ax=ax);
../_images/3d8269067c48deece7b0c5f14ad44e0fc8d3cd514f7790c07a02675c436cf9d9.png

Groundwater monitoring tubes within an extent

To obtain tube metadata (not included in the characteristics), download the GMW objects and use get_tube_gdf_from_characteristics(characteristics_gdf) — it returns a GeoDataFrame with one row per tube.

tube_gdf = brodata.gmw.get_tube_gdf_from_characteristics(gdf)
tube_gdf
constructionStandard coordinateTransformation corrected deliveredLocation deliveryAccountableParty deliveryContext deregistered groundLevelPosition groundLevelPositioningMethod groundLevelStable ... tubePartInserted tubeInUse tubePackingMaterial tubeMaterial glue screenLength sockMaterial screenTopPosition screenBottomPosition plainTubePartLength
groundwaterMonitoringWell tubeNumber
GMW000000036286 1 STOWAgwst RDNAPTRANS2008 nee POINT (117810.325 439763.468) 62251686 publiekeTaak nee -0.265 RTKGPS0tot4cm ja ... nee ja bentoniet peHighDensity geen 1.000 nylon -2.194 -3.194 1.799
GMW000000036287 1 STOWAgwst RDNAPTRANS2008 nee POINT (118300.381 439767.501) 62251686 publiekeTaak nee 1.932 RTKGPS0tot4cm ja ... nee ja bentoniet peHighDensity geen 1.000 nylon 0.142 -0.858 1.660
GMW000000036308 1 STOWAgwst RDNAPTRANS2008 nee POINT (118049.133 440003.042) 62251686 publiekeTaak nee 0.851 RTKGPS0tot4cm ja ... nee ja bentoniet peHighDensity geen 1.000 nylon -1.289 -2.289 2.000
GMW000000036318 1 STOWAgwst RDNAPTRANS2008 nee POINT (118395.916 440169.584) 62251686 publiekeTaak nee -0.499 RTKGPS0tot4cm ja ... nee ja bentoniet peHighDensity geen 0.999 nylon -2.029 -3.028 1.400
GMW000000036319 1 STOWAgwst RDNAPTRANS2008 nee POINT (117957.01 439698.236) 62251686 publiekeTaak nee -0.501 RTKGPS0tot4cm ja ... nee ja bentoniet peHighDensity geen 1.000 nylon -1.721 -2.721 1.100
GMW000000036327 1 STOWAgwst RDNAPTRANS2008 nee POINT (118064.196 439799.968) 62251686 publiekeTaak nee 0.856 RTKGPS0tot4cm ja ... nee ja bentoniet peHighDensity geen 1.000 nylon -0.833 -1.833 1.549
GMW000000036328 1 STOWAgwst RDNAPTRANS2008 nee POINT (118342.335 439964.237) 62251686 publiekeTaak nee 2.215 RTKGPS0tot4cm ja ... nee ja bentoniet peHighDensity geen 1.000 nylon 0.795 -0.205 1.270
GMW000000036339 1 STOWAgwst RDNAPTRANS2008 nee POINT (118632.021 439909.388) 62251686 publiekeTaak nee -0.575 RTKGPS0tot4cm ja ... nee ja bentoniet peHighDensity geen 1.000 nylon -2.695 -3.695 2.000
GMW000000036354 1 STOWAgwst RDNAPTRANS2008 nee POINT (117961.258 440134.209) 62251686 publiekeTaak nee -0.197 RTKGPS0tot4cm ja ... nee ja bentoniet peHighDensity geen 1.000 nylon -1.987 -2.987 1.670
GMW000000036365 1 STOWAgwst RDNAPTRANS2008 nee POINT (118127.47 439683.136) 62251686 publiekeTaak nee 1.371 RTKGPS0tot4cm ja ... nee ja bentoniet peHighDensity geen 0.999 nylon -0.429 -1.428 1.650
GMW000000036371 1 STOWAgwst RDNAPTRANS2008 nee POINT (117912.269 439993.594) 62251686 publiekeTaak nee 0.129 RTKGPS0tot4cm ja ... nee ja bentoniet peHighDensity geen 1.000 nylon -1.200 -2.200 1.180
GMW000000049567 1 onbekend RDNAPTRANS2008 nee POINT (117892.6 439651.9) 29010639 WW nee 0.010 onbekend onbekend ... nee ja onbekend onbekend onbekend 1.000 onbekend -1.950 -2.950 1.800
2 onbekend RDNAPTRANS2008 nee POINT (117892.6 439651.9) 29010639 WW nee 0.010 onbekend onbekend ... nee ja onbekend onbekend onbekend 1.000 onbekend -14.000 -15.000 13.750
GMW000000088148 1 NEN5104 RDNAPTRANS2018 nee POINT (118389.181 440186.268) 62251686 publiekeTaak nee 0.271 RTKGPS0tot4cm ja ... nee onbekend bentoniet pvc ongespecificeerd 1.000 nylon -2.829 -3.829 3.630
GMW000000088161 1 NEN5104 RDNAPTRANS2018 nee POINT (118046.797 440219) 62251686 publiekeTaak nee 0.146 RTKGPS0tot4cm ja ... nee onbekend bentoniet pvc geen 1.000 nylon -1.364 -2.364 2.070
GMW000000088163 1 NEN5104 RDNAPTRANS2018 nee POINT (118160.672 439679.017) 62251686 publiekeTaak nee 2.173 RTKGPS0tot4cm ja ... nee onbekend bentoniet pvc geen 1.000 nylon 0.473 -0.527 1.570
GMW000000088164 1 NEN5104 RDNAPTRANS2018 nee POINT (118206.574 439792.333) 62251686 publiekeTaak nee 2.620 RTKGPS0tot4cm ja ... nee onbekend bentoniet pvc geen 1.000 nylon 0.860 -0.140 1.640
GMW000000088166 1 NEN5104 RDNAPTRANS2018 nee POINT (118157.635 439915.505) 62251686 publiekeTaak nee 2.238 RTKGPS0tot4cm ja ... nee onbekend bentoniet pvc geen 1.000 nylon 0.868 -0.132 1.240
GMW000000088168 1 NEN5104 RDNAPTRANS2018 nee POINT (117910.741 439993.841) 62251686 publiekeTaak nee 0.137 RTKGPS0tot4cm ja ... nee onbekend bentoniet pvc geen 1.000 nylon -1.413 -2.413 2.080
GMW000000088172 1 NEN5104 RDNAPTRANS2018 nee POINT (117966.123 440143.417) 62251686 publiekeTaak nee -0.113 RTKGPS0tot4cm ja ... nee onbekend bentoniet pvc geen 1.000 nylon -1.653 -2.653 2.070

20 rows × 50 columns

“Grondwatermonitoring (GM) in samenhang”

Alternatively, request the PDOK “Grondwatermonitoring (GM) in samenhang” web service (available since 2024). It provides key data such as the horizontal and vertical positions of measurement tubes, but not full well or tube metadata.

gdf_gm = brodata.gm.gmw_monitoringtube_items(extent)
gdf_gm
geometry gm_gmw_monitoringtube_pk gm_gmw.href gm_gmw_fk gmw_bro_id tube_number tube_status tube_in_use tube_top_diameter screen_top_position screen_bottom_position electrode_top_position electrode_bottom_position
0 POINT (117810.309 439763.429) 36385 https://api.pdok.nl/tno/bro-grondwatermonitori... 27655 GMW000000036286 1 gebruiksklaar ja 63.0 -2.194 -3.194 None None
1 POINT (118300.365 439767.464) 36386 https://api.pdok.nl/tno/bro-grondwatermonitori... 27656 GMW000000036287 1 gebruiksklaar ja 63.0 0.142 -0.858 None None
2 POINT (118049.119 440003.006) 36407 https://api.pdok.nl/tno/bro-grondwatermonitori... 27677 GMW000000036308 1 gebruiksklaar ja 63.0 -1.289 -2.289 None None
3 POINT (118395.903 440169.549) 36417 https://api.pdok.nl/tno/bro-grondwatermonitori... 27687 GMW000000036318 1 gebruiksklaar ja 63.0 -2.029 -3.028 None None
4 POINT (117956.994 439698.197) 36418 https://api.pdok.nl/tno/bro-grondwatermonitori... 27688 GMW000000036319 1 gebruiksklaar ja 63.0 -1.721 -2.721 None None
5 POINT (118064.181 439799.93) 36426 https://api.pdok.nl/tno/bro-grondwatermonitori... 27696 GMW000000036327 1 gebruiksklaar ja 63.0 -0.833 -1.833 None None
6 POINT (118342.321 439964.201) 36427 https://api.pdok.nl/tno/bro-grondwatermonitori... 27697 GMW000000036328 1 gebruiksklaar ja 63.0 0.795 -0.205 None None
7 POINT (118632.006 439909.352) 36438 https://api.pdok.nl/tno/bro-grondwatermonitori... 27708 GMW000000036339 1 gebruiksklaar ja 63.0 -2.695 -3.695 None None
8 POINT (117961.245 440134.173) 36453 https://api.pdok.nl/tno/bro-grondwatermonitori... 27723 GMW000000036354 1 gebruiksklaar ja 63.0 -1.987 -2.987 None None
9 POINT (118127.453 439683.098) 36464 https://api.pdok.nl/tno/bro-grondwatermonitori... 27734 GMW000000036365 1 gebruiksklaar ja 63.0 -0.429 -1.428 None None
10 POINT (117912.255 439993.558) 36470 https://api.pdok.nl/tno/bro-grondwatermonitori... 27740 GMW000000036371 1 gebruiksklaar ja 63.0 -1.200 -2.200 None None
11 POINT (117892.583 439651.861) 54851 https://api.pdok.nl/tno/bro-grondwatermonitori... 40473 GMW000000049567 1 onbekend onbekend NaN -1.950 -2.950 None None
12 POINT (117892.583 439651.861) 54852 https://api.pdok.nl/tno/bro-grondwatermonitori... 40473 GMW000000049567 2 onbekend onbekend NaN -14.000 -15.000 None None
13 POINT (118389.168 440186.234) 101186 https://api.pdok.nl/tno/bro-grondwatermonitori... 75845 GMW000000088148 1 gebruiksklaar onbekend 63.0 -2.829 -3.829 None None
14 POINT (118046.785 440218.965) 101201 https://api.pdok.nl/tno/bro-grondwatermonitori... 75858 GMW000000088161 1 gebruiksklaar onbekend 63.0 -1.364 -2.364 None None
15 POINT (118160.656 439678.979) 101203 https://api.pdok.nl/tno/bro-grondwatermonitori... 75860 GMW000000088163 1 gebruiksklaar onbekend 40.0 0.473 -0.527 None None
16 POINT (118206.559 439792.296) 101204 https://api.pdok.nl/tno/bro-grondwatermonitori... 75861 GMW000000088164 1 gebruiksklaar onbekend 40.0 0.860 -0.140 None None
17 POINT (118157.621 439915.469) 101206 https://api.pdok.nl/tno/bro-grondwatermonitori... 75863 GMW000000088166 1 gebruiksklaar onbekend 63.0 0.868 -0.132 None None
18 POINT (117910.727 439993.804) 101208 https://api.pdok.nl/tno/bro-grondwatermonitori... 75865 GMW000000088168 1 gebruiksklaar onbekend 63.0 -1.413 -2.413 None None
19 POINT (117966.11 440143.381) 101212 https://api.pdok.nl/tno/bro-grondwatermonitori... 75869 GMW000000088172 1 gebruiksklaar onbekend 63.0 -1.653 -2.653 None None
f, ax = plt.subplots()
ax.axis("scaled")
ax.axis(extent)
gdf_gm.plot(ax=ax);
../_images/c3d72966a3ea807785c781bb5d2b9185ee8eb104fcc1a7cda536542e2595b7eb.png

Get bronhouder IDs

Retrieve all GMW IDs for a specific bronhouder (owner) using get_bro_ids_of_bronhouder().

brodata.gmw.get_bro_ids_of_bronhouder(30277172)
['GMW000000059464',
 'GMW000000059465',
 'GMW000000059466',
 'GMW000000059467',
 'GMW000000059468',
 'GMW000000059469',
 'GMW000000059470',
 'GMW000000059471',
 'GMW000000081011',
 'GMW000000088299',
 'GMW000000088300',
 'GMW000000088301',
 'GMW000000088302',
 'GMW000000111791',
 'GMW000000111792',
 'GMW000000111793',
 'GMW000000111794',
 'GMW000000111795',
 'GMW000000111796',
 'GMW000000111797',
 'GMW000000111798',
 'GMW000000111799',
 'GMW000000026223',
 'GMW000000059566',
 'GMW000000059567',
 'GMW000000059568',
 'GMW000000059569',
 'GMW000000059570',
 'GMW000000059571',
 'GMW000000059572',
 'GMW000000059573',
 'GMW000000059574',
 'GMW000000059575',
 'GMW000000059576',
 'GMW000000059577',
 'GMW000000059578',
 'GMW000000059579',
 'GMW000000059580',
 'GMW000000059581',
 'GMW000000059582',
 'GMW000000059583',
 'GMW000000059584',
 'GMW000000059585',
 'GMW000000059586',
 'GMW000000059587',
 'GMW000000059588',
 'GMW000000059589',
 'GMW000000059590',
 'GMW000000059591',
 'GMW000000059592',
 'GMW000000059593',
 'GMW000000059594',
 'GMW000000059595',
 'GMW000000059596',
 'GMW000000059597',
 'GMW000000059598',
 'GMW000000059599',
 'GMW000000059600',
 'GMW000000059601',
 'GMW000000059602',
 'GMW000000059603',
 'GMW000000059604',
 'GMW000000059605',
 'GMW000000074419',
 'GMW000000074420',
 'GMW000000074421',
 'GMW000000074422',
 'GMW000000074423',
 'GMW000000074424',
 'GMW000000074425',
 'GMW000000074426',
 'GMW000000074427',
 'GMW000000074428',
 'GMW000000074429',
 'GMW000000074430',
 'GMW000000074431',
 'GMW000000074432',
 'GMW000000074433',
 'GMW000000074434',
 'GMW000000074435',
 'GMW000000074436',
 'GMW000000082440',
 'GMW000000082441',
 'GMW000000082442',
 'GMW000000082443',
 'GMW000000082444',
 'GMW000000077466',
 'GMW000000077488',
 'GMW000000077489',
 'GMW000000077490',
 'GMW000000077491',
 'GMW000000077492',
 'GMW000000077493',
 'GMW000000077494',
 'GMW000000077495',
 'GMW000000077496',
 'GMW000000077497',
 'GMW000000077498',
 'GMW000000077499',
 'GMW000000077500',
 'GMW000000077501',
 'GMW000000077502',
 'GMW000000077503',
 'GMW000000077504',
 'GMW000000077505',
 'GMW000000077506',
 'GMW000000077507',
 'GMW000000077508',
 'GMW000000077509',
 'GMW000000077510',
 'GMW000000077511',
 'GMW000000077512',
 'GMW000000077513',
 'GMW000000077514',
 'GMW000000077515',
 'GMW000000077516',
 'GMW000000079066',
 'GMW000000079067',
 'GMW000000079068',
 'GMW000000079069',
 'GMW000000079070',
 'GMW000000079071',
 'GMW000000079072',
 'GMW000000079073',
 'GMW000000079074',
 'GMW000000079075',
 'GMW000000079076',
 'GMW000000079077',
 'GMW000000079078',
 'GMW000000079079',
 'GMW000000079080',
 'GMW000000079081',
 'GMW000000111451',
 'GMW000000111452',
 'GMW000000111453',
 'GMW000000003962',
 'GMW000000068627',
 'GMW000000068630',
 'GMW000000017644',
 'GMW000000017655',
 'GMW000000003961',
 'GMW000000003963',
 'GMW000000003964',
 'GMW000000003965',
 'GMW000000003966',
 'GMW000000003967',
 'GMW000000003968',
 'GMW000000003969',
 'GMW000000003970',
 'GMW000000003971',
 'GMW000000003972',
 'GMW000000003973',
 'GMW000000003974',
 'GMW000000003975',
 'GMW000000003976',
 'GMW000000003977',
 'GMW000000003978',
 'GMW000000003979',
 'GMW000000003980',
 'GMW000000003981',
 'GMW000000003982',
 'GMW000000003983',
 'GMW000000003984',
 'GMW000000003985',
 'GMW000000003986',
 'GMW000000003987',
 'GMW000000003988',
 'GMW000000003989',
 'GMW000000003990',
 'GMW000000003991',
 'GMW000000003992',
 'GMW000000003993',
 'GMW000000003994',
 'GMW000000003995',
 'GMW000000003996',
 'GMW000000003997',
 'GMW000000003998',
 'GMW000000003999',
 'GMW000000004000',
 'GMW000000004001',
 'GMW000000004002',
 'GMW000000004003',
 'GMW000000004004',
 'GMW000000004005',
 'GMW000000004006',
 'GMW000000004007',
 'GMW000000004008',
 'GMW000000004009',
 'GMW000000004010',
 'GMW000000004011',
 'GMW000000004012',
 'GMW000000004013',
 'GMW000000004014',
 'GMW000000004015',
 'GMW000000004016',
 'GMW000000004017',
 'GMW000000004018',
 'GMW000000004019',
 'GMW000000004020',
 'GMW000000004021',
 'GMW000000004022',
 'GMW000000004023',
 'GMW000000004024',
 'GMW000000004025',
 'GMW000000004026',
 'GMW000000004027',
 'GMW000000004028',
 'GMW000000004029',
 'GMW000000004030',
 'GMW000000004031',
 'GMW000000004032',
 'GMW000000004033',
 'GMW000000004034',
 'GMW000000004035',
 'GMW000000004036',
 'GMW000000004037',
 'GMW000000004038',
 'GMW000000004039',
 'GMW000000004040',
 'GMW000000004041',
 'GMW000000004042',
 'GMW000000004043',
 'GMW000000004044',
 'GMW000000004045',
 'GMW000000004046',
 'GMW000000004047',
 'GMW000000004048',
 'GMW000000004049',
 'GMW000000004050',
 'GMW000000004051',
 'GMW000000004052',
 'GMW000000004053',
 'GMW000000004054',
 'GMW000000004055',
 'GMW000000004056',
 'GMW000000004057',
 'GMW000000004058',
 'GMW000000004059',
 'GMW000000004060',
 'GMW000000004061',
 'GMW000000004062',
 'GMW000000004063',
 'GMW000000004064',
 'GMW000000004065',
 'GMW000000004066',
 'GMW000000004067',
 'GMW000000004068',
 'GMW000000004069',
 'GMW000000004070',
 'GMW000000004071',
 'GMW000000004072',
 'GMW000000004073',
 'GMW000000004074',
 'GMW000000004075',
 'GMW000000004076',
 'GMW000000004077',
 'GMW000000004078',
 'GMW000000004079',
 'GMW000000004080',
 'GMW000000004081',
 'GMW000000004082',
 'GMW000000004083',
 'GMW000000004084',
 'GMW000000004085',
 'GMW000000004086',
 'GMW000000004087',
 'GMW000000004088',
 'GMW000000004089',
 'GMW000000004090',
 'GMW000000004091',
 'GMW000000004092',
 'GMW000000004093',
 'GMW000000004094',
 'GMW000000004095',
 'GMW000000004096',
 'GMW000000004097',
 'GMW000000004098',
 'GMW000000004099',
 'GMW000000004100',
 'GMW000000004101',
 'GMW000000004102',
 'GMW000000004103',
 'GMW000000004104',
 'GMW000000004105',
 'GMW000000004106',
 'GMW000000004107',
 'GMW000000004108',
 'GMW000000004109',
 'GMW000000004110',
 'GMW000000004111',
 'GMW000000004112',
 'GMW000000023786',
 'GMW000000023787',
 'GMW000000023788',
 'GMW000000023789',
 'GMW000000023790',
 'GMW000000023791',
 'GMW000000023792',
 'GMW000000023793',
 'GMW000000023794',
 'GMW000000023795',
 'GMW000000023796',
 'GMW000000023797',
 'GMW000000023798',
 'GMW000000023799',
 'GMW000000023800',
 'GMW000000023801',
 'GMW000000023802',
 'GMW000000023803',
 'GMW000000023804',
 'GMW000000023805',
 'GMW000000023806',
 'GMW000000023807',
 'GMW000000023808',
 'GMW000000023809',
 'GMW000000023810',
 'GMW000000023811',
 'GMW000000023812',
 'GMW000000023813',
 'GMW000000023814',
 'GMW000000023815',
 'GMW000000023816',
 'GMW000000023817',
 'GMW000000023818',
 'GMW000000023819',
 'GMW000000023820',
 'GMW000000023821',
 'GMW000000023822',
 'GMW000000023823',
 'GMW000000023824',
 'GMW000000023825',
 'GMW000000023826',
 'GMW000000023827',
 'GMW000000023828',
 'GMW000000023829',
 'GMW000000023830',
 'GMW000000023831',
 'GMW000000023832',
 'GMW000000023833',
 'GMW000000023834',
 'GMW000000023835',
 'GMW000000023836',
 'GMW000000023837',
 'GMW000000023838',
 'GMW000000023839',
 'GMW000000023840',
 'GMW000000023841',
 'GMW000000023842',
 'GMW000000023843',
 'GMW000000023844',
 'GMW000000023845',
 'GMW000000023846',
 'GMW000000023847',
 'GMW000000023848',
 'GMW000000023849',
 'GMW000000023850',
 'GMW000000023851',
 'GMW000000023852',
 'GMW000000023853',
 'GMW000000023854',
 'GMW000000023855',
 'GMW000000023856',
 'GMW000000023857',
 'GMW000000023858',
 'GMW000000023859',
 'GMW000000023860',
 'GMW000000023861',
 'GMW000000023862',
 'GMW000000023863',
 'GMW000000023864',
 'GMW000000023865',
 'GMW000000023866',
 'GMW000000023867',
 'GMW000000023868',
 'GMW000000023869',
 'GMW000000023870',
 'GMW000000023871',
 'GMW000000023872',
 'GMW000000023873',
 'GMW000000023874',
 'GMW000000023875',
 'GMW000000023876',
 'GMW000000023877',
 'GMW000000023878',
 'GMW000000023879',
 'GMW000000023880',
 'GMW000000023881',
 'GMW000000023882',
 'GMW000000023883',
 'GMW000000023884',
 'GMW000000023885',
 'GMW000000023886',
 'GMW000000023887',
 'GMW000000023888',
 'GMW000000023889',
 'GMW000000023890',
 'GMW000000023891',
 'GMW000000023892',
 'GMW000000023893',
 'GMW000000023894',
 'GMW000000023895',
 'GMW000000023896',
 'GMW000000023897',
 'GMW000000023898',
 'GMW000000023899',
 'GMW000000023900',
 'GMW000000023901',
 'GMW000000023902',
 'GMW000000023903',
 'GMW000000023904',
 'GMW000000023905',
 'GMW000000023906',
 'GMW000000023907',
 'GMW000000023908',
 'GMW000000023909',
 'GMW000000023910',
 'GMW000000023911',
 'GMW000000023912',
 'GMW000000023913',
 'GMW000000023914',
 'GMW000000023915',
 'GMW000000023916',
 'GMW000000023917',
 'GMW000000023918',
 'GMW000000023919',
 'GMW000000023920',
 'GMW000000023921',
 'GMW000000023922',
 'GMW000000023923',
 'GMW000000023924',
 'GMW000000023925',
 'GMW000000023926',
 'GMW000000023927',
 'GMW000000023928',
 'GMW000000023929',
 'GMW000000023930',
 'GMW000000023931',
 'GMW000000023932',
 'GMW000000023933',
 'GMW000000023934',
 'GMW000000023935',
 'GMW000000023936',
 'GMW000000023937',
 'GMW000000023938',
 'GMW000000023939',
 'GMW000000023940',
 'GMW000000023941',
 'GMW000000023942',
 'GMW000000023943',
 'GMW000000023944',
 'GMW000000023945',
 'GMW000000023946',
 'GMW000000023947',
 'GMW000000023948',
 'GMW000000023949',
 'GMW000000023950',
 'GMW000000023951',
 'GMW000000023952',
 'GMW000000023953',
 'GMW000000023954',
 'GMW000000023955',
 'GMW000000023956',
 'GMW000000023957',
 'GMW000000023958',
 'GMW000000023959',
 'GMW000000023960',
 'GMW000000023961',
 'GMW000000023962',
 'GMW000000023963',
 'GMW000000023964',
 'GMW000000023965',
 'GMW000000023966',
 'GMW000000023967',
 'GMW000000023968',
 'GMW000000023969',
 'GMW000000023970',
 'GMW000000023971',
 'GMW000000023972',
 'GMW000000023973',
 'GMW000000023974',
 'GMW000000023975',
 'GMW000000023976',
 'GMW000000023977',
 'GMW000000023978',
 'GMW000000023979',
 'GMW000000023980',
 'GMW000000023981',
 'GMW000000023982',
 'GMW000000023983',
 'GMW000000023984',
 'GMW000000023985',
 'GMW000000023986',
 'GMW000000023987',
 'GMW000000023988',
 'GMW000000023989',
 'GMW000000023990',
 'GMW000000023991',
 'GMW000000023992',
 'GMW000000023993',
 'GMW000000023994',
 'GMW000000023995',
 'GMW000000023996',
 'GMW000000023997',
 'GMW000000023998',
 'GMW000000023999',
 'GMW000000024000',
 'GMW000000024001',
 'GMW000000024002',
 'GMW000000024003',
 'GMW000000024004',
 'GMW000000024005',
 'GMW000000024006',
 'GMW000000024007',
 'GMW000000024008',
 'GMW000000024009',
 'GMW000000024010',
 'GMW000000024011',
 'GMW000000024012',
 'GMW000000024013',
 'GMW000000024014',
 'GMW000000024015',
 'GMW000000024016',
 'GMW000000024017',
 'GMW000000024018',
 'GMW000000024019',
 'GMW000000024020',
 'GMW000000024021',
 'GMW000000024022',
 'GMW000000024023',
 'GMW000000024024',
 'GMW000000024025',
 'GMW000000024026',
 'GMW000000024027',
 'GMW000000024028',
 'GMW000000024029',
 'GMW000000024030',
 'GMW000000024031',
 'GMW000000024032',
 'GMW000000024033',
 'GMW000000024034',
 'GMW000000024035',
 'GMW000000024036',
 'GMW000000024037',
 'GMW000000024038',
 'GMW000000024039',
 'GMW000000024040',
 'GMW000000024041',
 'GMW000000024042',
 'GMW000000024043',
 'GMW000000024044',
 'GMW000000024045',
 'GMW000000024046',
 'GMW000000024047',
 'GMW000000024048',
 'GMW000000024049',
 'GMW000000024050',
 'GMW000000024051',
 'GMW000000024052',
 'GMW000000024053',
 'GMW000000024054',
 'GMW000000024055',
 'GMW000000024056',
 'GMW000000024057',
 'GMW000000024058',
 'GMW000000024059',
 'GMW000000024060',
 'GMW000000024061',
 'GMW000000024062',
 'GMW000000024063',
 'GMW000000024064',
 'GMW000000024065',
 'GMW000000024066',
 'GMW000000024067',
 'GMW000000024068',
 'GMW000000024069',
 'GMW000000024070',
 'GMW000000024071',
 'GMW000000024072',
 'GMW000000024073',
 'GMW000000024074',
 'GMW000000024075',
 'GMW000000024076',
 'GMW000000024077',
 'GMW000000024078',
 'GMW000000024079',
 'GMW000000024080',
 'GMW000000024081',
 'GMW000000024082',
 'GMW000000024083',
 'GMW000000024084',
 'GMW000000024085',
 'GMW000000024086',
 'GMW000000024087',
 'GMW000000024088',
 'GMW000000024089',
 'GMW000000024090',
 'GMW000000024091',
 'GMW000000024092',
 'GMW000000024093',
 'GMW000000024094',
 'GMW000000024095',
 'GMW000000024096',
 'GMW000000024097',
 'GMW000000024098',
 'GMW000000024099',
 'GMW000000024100',
 'GMW000000024101',
 'GMW000000024102',
 'GMW000000024103',
 'GMW000000024104',
 'GMW000000024105',
 'GMW000000024106',
 'GMW000000024107',
 'GMW000000024108',
 'GMW000000024109',
 'GMW000000024110',
 'GMW000000024111',
 'GMW000000024112',
 'GMW000000024113',
 'GMW000000024114',
 'GMW000000024115',
 'GMW000000024116',
 'GMW000000024117',
 'GMW000000024118',
 'GMW000000024119',
 'GMW000000024120',
 'GMW000000024121',
 'GMW000000024122',
 'GMW000000024123',
 'GMW000000024124',
 'GMW000000024125',
 'GMW000000024126',
 'GMW000000024127',
 'GMW000000024128',
 'GMW000000024129',
 'GMW000000024130',
 'GMW000000024131',
 'GMW000000042610',
 'GMW000000042611',
 'GMW000000042612',
 'GMW000000042613',
 'GMW000000042614',
 'GMW000000042615',
 'GMW000000042616',
 'GMW000000042617',
 'GMW000000042618',
 'GMW000000042619',
 'GMW000000042620',
 'GMW000000042621',
 'GMW000000042622',
 'GMW000000042623',
 'GMW000000042624',
 'GMW000000042625',
 'GMW000000042626',
 'GMW000000042627',
 'GMW000000042628',
 'GMW000000042629',
 'GMW000000042630',
 'GMW000000042631',
 'GMW000000042632',
 'GMW000000042633',
 'GMW000000042634',
 'GMW000000042635',
 'GMW000000042636',
 'GMW000000042637',
 'GMW000000042638',
 'GMW000000042639',
 'GMW000000042640',
 'GMW000000042641',
 'GMW000000042642',
 'GMW000000042643',
 'GMW000000042644',
 'GMW000000042645',
 'GMW000000042646',
 'GMW000000042647',
 'GMW000000042648',
 'GMW000000042649',
 'GMW000000042650',
 'GMW000000042651',
 'GMW000000042652',
 'GMW000000042653',
 'GMW000000042654',
 'GMW000000042655',
 'GMW000000042656',
 'GMW000000042657',
 'GMW000000042734',
 'GMW000000042735',
 'GMW000000042736',
 'GMW000000042737',
 'GMW000000042738',
 'GMW000000042739',
 'GMW000000042740',
 'GMW000000042741',
 'GMW000000042742',
 'GMW000000042743',
 'GMW000000042744',
 'GMW000000042745',
 'GMW000000047136',
 'GMW000000059964',
 'GMW000000059965',
 'GMW000000059966',
 'GMW000000059967',
 'GMW000000059968',
 'GMW000000059969',
 'GMW000000059970',
 'GMW000000059971',
 'GMW000000059972',
 'GMW000000059973',
 'GMW000000059974',
 'GMW000000059975',
 'GMW000000066680',
 'GMW000000066681',
 'GMW000000066685',
 'GMW000000077994',
 'GMW000000077995',
 'GMW000000077996',
 'GMW000000077997',
 'GMW000000077998',
 'GMW000000081095',
 'GMW000000081096',
 'GMW000000081097',
 'GMW000000081098',
 'GMW000000081099',
 'GMW000000085401',
 'GMW000000087937',
 'GMW000000087938',
 'GMW000000087939',
 'GMW000000087940',
 'GMW000000088350',
 'GMW000000088351',
 'GMW000000088352',
 'GMW000000088353',
 'GMW000000088354',
 'GMW000000088355',
 'GMW000000088356',
 'GMW000000088357',
 'GMW000000088358',
 'GMW000000088359',
 'GMW000000088360',
 'GMW000000088361',
 'GMW000000088362',
 'GMW000000088363',
 'GMW000000088364',
 'GMW000000088365',
 'GMW000000088366',
 'GMW000000088367',
 'GMW000000088368',
 'GMW000000088369',
 'GMW000000088370',
 'GMW000000088371',
 'GMW000000088372',
 'GMW000000091111']