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': NaT,
'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);
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. In Grondwatermonitoring (GM) in samenhang we will show this can also be done faster, using less requests.
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 | ja | 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 | ja | 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 | ja | 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 | ja | 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 | ja | 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 | ja | 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 | ja | bentoniet | pvc | geen | 1.000 | nylon | -1.653 | -2.653 | 2.070 |
20 rows × 50 columns
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',
'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',
'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',
'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',
'GMW000000023821',
'GMW000000023822',
'GMW000000023823',
'GMW000000023824',
'GMW000000023825',
'GMW000000023826',
'GMW000000023827',
'GMW000000023828',
'GMW000000023829',
'GMW000000023830',
'GMW000000023831',
'GMW000000023832',
'GMW000000023835',
'GMW000000023836',
'GMW000000023837',
'GMW000000023838',
'GMW000000023839',
'GMW000000023840',
'GMW000000023841',
'GMW000000023842',
'GMW000000023844',
'GMW000000023845',
'GMW000000023846',
'GMW000000023847',
'GMW000000023848',
'GMW000000023849',
'GMW000000023850',
'GMW000000023851',
'GMW000000023852',
'GMW000000023853',
'GMW000000023855',
'GMW000000023856',
'GMW000000023857',
'GMW000000023858',
'GMW000000023859',
'GMW000000023860',
'GMW000000023861',
'GMW000000023862',
'GMW000000023863',
'GMW000000023864',
'GMW000000023865',
'GMW000000023866',
'GMW000000023867',
'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',
'GMW000000023897',
'GMW000000023898',
'GMW000000023899',
'GMW000000023902',
'GMW000000023903',
'GMW000000023904',
'GMW000000023905',
'GMW000000023906',
'GMW000000023908',
'GMW000000023909',
'GMW000000023910',
'GMW000000023911',
'GMW000000023912',
'GMW000000023913',
'GMW000000023914',
'GMW000000023915',
'GMW000000023916',
'GMW000000023917',
'GMW000000023918',
'GMW000000023919',
'GMW000000023920',
'GMW000000023921',
'GMW000000023922',
'GMW000000023923',
'GMW000000023924',
'GMW000000023925',
'GMW000000023926',
'GMW000000023928',
'GMW000000023930',
'GMW000000023931',
'GMW000000023933',
'GMW000000023934',
'GMW000000023936',
'GMW000000023937',
'GMW000000023938',
'GMW000000023939',
'GMW000000023940',
'GMW000000023941',
'GMW000000023942',
'GMW000000023943',
'GMW000000023944',
'GMW000000023945',
'GMW000000023946',
'GMW000000023947',
'GMW000000023948',
'GMW000000023949',
'GMW000000023950',
'GMW000000023951',
'GMW000000023952',
'GMW000000023954',
'GMW000000023955',
'GMW000000023956',
'GMW000000023957',
'GMW000000023958',
'GMW000000023959',
'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',
'GMW000000023988',
'GMW000000023989',
'GMW000000023990',
'GMW000000023991',
'GMW000000023992',
'GMW000000023993',
'GMW000000023994',
'GMW000000023995',
'GMW000000023996',
'GMW000000023997',
'GMW000000023999',
'GMW000000024001',
'GMW000000024002',
'GMW000000024003',
'GMW000000024004',
'GMW000000024005',
'GMW000000024006',
'GMW000000024008',
'GMW000000024009',
'GMW000000024010',
'GMW000000024011',
'GMW000000024012',
'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',
'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',
'GMW000000042639',
'GMW000000042640',
'GMW000000042641',
'GMW000000042642',
'GMW000000042643',
'GMW000000042644',
'GMW000000042645',
'GMW000000042646',
'GMW000000042647',
'GMW000000042648',
'GMW000000042649',
'GMW000000042650',
'GMW000000042651',
'GMW000000042652',
'GMW000000042653',
'GMW000000042654',
'GMW000000042655',
'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',
'GMW000000068627',
'GMW000000068630',
'GMW000000077994',
'GMW000000077995',
'GMW000000077996',
'GMW000000077997',
'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',
'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',
'GMW000000017644',
'GMW000000017655']