search

inbo / etn

R package to access data from the European Tracking Network
https://inbo.github.io/etn/
MIT License
6 stars 5 forks source link

get_detections #47

Closed PieterjanVerhelst closed 6 years ago

PieterjanVerhelst commented 6 years ago

I think the get_detections() functionality can be improved by adding filters on:

jreubens commented 6 years ago

I agree... btw transmitter is already included (see ?get_detections)

PieterjanVerhelst commented 6 years ago

Indeed, I removed transmitter from the improvement list.

PieterjanVerhelst commented 6 years ago

Since retrieving detections is, to my opinion, the core of the package and results in large datasets, adding the above suggested filters may improve the function get_detections(). For instance, in the project 2015_phd_verhelst two species (i.e. Gadus morhua and Anguilla anguilla). Since we are often interested in one species for analysis, selecting that one species during the 'data call' can reduce the requested data substantially (in this case, for 2017 data: 577570 records for Gadus morhua and 286962 records for Anguilla anguilla). Likewise, it can occurr that one wants to check the efficiency/number of detections for a single receiver. Than it would be more efficient to reduce the extraction on the server level, instead of downloading all data and locally selecting on only a fraction of that data.

PieterjanVerhelst commented 6 years ago

I was trying to download the dataset of the animal network 2013_albertkanaal and apparently we cannot download files larger than 100 Mb. Is it possible to allow download of larger files? Here is the error I got: Error: cannot allocate vector of size 100.0 Mb

JolienGoossens commented 6 years ago

In get_detections I would change the deployment_station_name argument to station_name (is called station_name in the dataframes).

stijnvanhoey commented 6 years ago

@JolienGoossens Actually, both are in...

> colnames(get_detections(con, limit = 10))
 [1] "receiver"                  "transmitter"               "transmitter_name"          "transmitter_serial"       
 [5] "sensor_value"              "sensor_unit"               "sensor2_value"             "sensor2_unit"             
 [9] "station_name"               # STATION_NAME
"datetime"                  "id_pk"                     "qc_flag"                  
[13] "file"                      "latitude"                  "longitude"                 "deployment_fk"            
[17] "scientific_name"           "location_name"             
"deployment_station_name"   # DEPLOYMENT_STATION_NAME
"deploy_date_time"         
[21] "animal_project_name"       "animal_project_code"       "animal_moratorium"         "network_project_name"     
[25] "network_project_code"      "network_moratorium"        "signal_to_noise_ratio"     "detection_file_id"        
[29] "tag_sensor_type"           "tag_intercept"             "tag_slope"                 "sensor_value_depth_meters"
[33] "tag_owner_organization"    "animal_id_pk"              "animal_common_name"        "animal_sex"               
[37] "deployment_lat"            "deployment_long"           "sensor_value_acceleration"

As in the database and the dataframe that is returned, a difference is made in between detections.station_name and deployments.station_name AS deployment_station_name. I took the naming of the latter to populate the data filter, as we actually use the deployment_station_name to filter the records and not the station_name.

stijnvanhoey commented 6 years ago

@PieterjanVerhelst can you make a separate issue for the max size to download (and add the database label to the issue)? This issue can tackle the additional filters for the get_detections function.

PieterjanVerhelst commented 6 years ago

Done

stijnvanhoey commented 6 years ago

@PieterjanVerhelst which column names to use for the filtering?

receiver transmitter datetime
VR2W-127737 A69-1601-14869 2015-12-17 06:53:53
VR2W-127737 A69-1601-14869 2015-12-17 07:02:18
VR2W-127737 A69-1601-14869 2015-12-17 07:06:30
VR2W-127737 A69-1601-14869 2015-12-17 07:10:41
VR2W-127737 A69-1601-14869 2015-12-17 07:14:51
VR2W-127731 A69-1601-14869 2015-12-17 06:51:38
receiver transmitter datetime scientific_name
VR2W-127737 A69-1601-14869 2015-12-17 06:53:53 Gadus morhua
VR2W-127737 A69-1601-14869 2015-12-17 07:02:18 Gadus morhua
VR2W-127737 A69-1601-14869 2015-12-17 07:06:30 Gadus morhua
VR2W-127737 A69-1601-14869 2015-12-17 07:10:41 Gadus morhua
VR2W-127737 A69-1601-14869 2015-12-17 07:14:51 Gadus morhua
VR2W-127731 A69-1601-14869 2015-12-17 06:51:38 Gadus morhua
PieterjanVerhelst commented 6 years ago

@stijnvanhoey those suggestions are correct.

stijnvanhoey commented 6 years ago

see PR #55

PieterjanVerhelst commented 6 years ago

I tried to extract data via the get_detections function, but no data was returned. I did use the function according to the vignette: my_detections <- get_detections(my_con, animal_project = "2015_phd_verhelst")

stijnvanhoey commented 6 years ago

Currently, the package uses the following query (mentioning all possible values of the non-mentioned arguments):

<SQL> SELECT * FROM vliz.detections_view
WHERE network_project_code IN ('cpod-lifewatch', 'lifewatch', 'Noordzeekanaal', 'pc4c', 'Deveron', 'MorayFirth', 'Aberdeen', 'Conon', 'Skye', 'maas', 'AZ0', 'Jersey_Coastal', 'MBA_Whitsand', 'MBA_Massmo', 'MBA_Wavehub', 'dijle', 'albert', 'bovenschelde', 'leopold', 'bpns', 'demer', 'saeftinghe', 'DTU-Skjern', 'Limfjord', 'SVNL-FISH-WATCH', 'BECORV', 'Inforbiomares', 'ARAISOLA01', 'ARAISOLA02', 'ARAISOLA03', 'SARTELARAM', 'SARTELZINGARO', 'SARTELTG', 'thornton', 'ws1', 'ws2', 'ws3', 'zeeschelde', 'PTN-Silver-eel-Mondego', 'PTN/PROTECT2012')
  AND animal_project_code IN ('2015_phd_verhelst')
  AND datetime > '1970-01-01'
  AND datetime < '2018-08-08'
  AND deployment_station_name IN (NULL, 'bh-34', 'ak-28', 'Wett', 'S09-2', 'ws-TRAWL', 'PC4C-A5-2', 'ak-7', 'ak-x', 'de-14', 'MS-32', 'Test Rotselaar', 'VLVS12', 'PC4C-C09-3', 'bpns-LST420', 'bpns-vandamme', 'de-1', 'Station 8D', 'MS-21', 'S14', 'ak-39', 'kGenOst', 'IN-6', 'bh-6', 'ws-25', 'bh-21', 'BP-5', 'MS-37', 'zandvlietsluis haven B', 'me-7-2b', 'bpns-ZOKN', 'de-5', 'VLVS1', 'bpns-NHSE', 'bh-35', 'ak-30', 'PC4C-B6-2', 's-12', 'Koog ad Zaan', 'ak-16', 'IN-4', 'Zijkanaal C kom', 'bpns-CNB05', 'bh-17', 'bpns-WK9', 'de-18', 'bpns-RTNZ07', 'PC4C-C05-5', 'ws-15A', 'bh-26', 'ngOudsa', 'MS-33', 'PC4C-C09-5', 'bpns-S7', 'MS-16', 'VLVS13', 'Spaarndam', 'PC4C-C09-4', 's-9a', 'PC4C-F05-1', 'M-5', 'S17', 'MS-27', 'Station 9C', 'Muiden', 'stgOud', 'ma-6', 'SU-3', 'HH1', 'bpns-NIEUWPOORTKUST8', 'ak-48', 'de-22', 's-2', 'PC4C-F05-7', 'SU-5', 'S12', 'R07', 'ws-15', 'bpns-Whitley', 's-4', 'MS-14', 'bh-14', 'bpns-CNB04', 'me-7-2', 'MS-1', 'ak-18', 'PC4C-A5-5', 'ws-2C', 'R02', 'IN-7', 'bpns-WENDUINEBANKW', 'bpns-Trapegeer', 'Station 2', 'Kadoelen 5', 'bpns-C05AR1Belwind', 'bh-25', 'PC4C-F05-3', 'IN-5', 'ws-DL9', 'Nevengeul Oudenaarde (opwaarts)', 'soOud', 'PC4C-A7-5', 'PC4C-C08-1', 'bpns-BelwindReefballs', 'BP-1', 'ak-2', 'bpns-Belwind C05', 'bh-16', 'ak-35', 'bpns-Reefballs-cpower', 'bpns-CNB03', 'Oranjesluis', 'bh-29', 'Spaarne gemaal', 's-4a', 'ak-10', 'ws-PVTSS', 'BP-6', 'bpns-WZ', 'MS-25', 'bpns-oostdyckwest', 'PC4C-A8-1', 'bh-33', 'PC4C-C05-3', 'PC4C-B6-6', 'bpns_CNB01', 'S18', 'PC4C-B08-1', 'HH6', 'bpns-Birkenfels', 'Overtoom 1', '06 MG ponta radares', 'bpns-RTNZ03', 'IN-3', 'HH8', 'Zaangemaal 3', 'SU-7', '07 MG entremontes', 'PC4C-C10-1', 'ak-44', 'bpns-D1', 'S16', 'de-19', 'MS-26', 'PC4C-B10-3', 'ak-29', 'bpns-C05AR2Belwind', 'bh-36', 'C9C8D9D8', 'MS-6', 'bpns-S4', 'A6', 'bpns-CNB09', 'S07', 'ngAspm', 'bpns-BIRKENFELS', 'SU-4', 'S02', 'R04', 'HH11', 'soMrbk', 'CP DC7', 'ma-5', 'MS-35', 'ws-DL7', 'TOEVOERKANAAL', 'D7', 'CPN', 'ak-37', 'ngAspso', 's-8a', 'Vinkeveen sluis', '08 MG doca', 'ak-3', 'IN-2', 'Station 6', 'ws-PPC', 'de-7', 'Station 11', 'ak-14', 'ES-2', 'Overtoom 2', 'Station 9D', 'PC4C-B08-5', 'MS-36', 'ngOudm', 'RingvN', 'bpns-WK12', 'Katwijk 3', 's-Vlassenbroek', 'MOW1', 'RingvWz', 'Nobelwind_Tripod', 'Vinkeveen vaart', 'de-10', 'VLVS8', 'Kadoelen 3', '01 MG pasteleiro', 'FW-1', 's-Wichelen', 'MS-31', 'M-4', 'bh-19', 'ak-15', 'bn-Lier', 'ak-41', 'PC4C-B08-2', 'SU-6', 'de-20', 'BPNS-Belreef1', 'MS-30', 'Vinkeveen gemaal', 's-10', 'bpns-C05BELWIND', 'PC4C-F05-8', 'Willem 1 sluis 1', 'MS-24', 'bpns-Gootebank', 'PC4C-C05-2', 'PC4C-C09-6', 'Berlagerbrug', 'Dend', 'bh-3', 'Kleine sluis NZK', 'stgKer', 'PC4C-A5-6', 'ws-13', 'Halfweg boezemzijde', 'MS-7', '04 MG caldeirinha dentro', 'PC4C-C05-6', 'ws-OGDL', 'HH7', 'ak-47', 'ws-18', 'oostdyckwest', 'bh-8', 'PC4C-C05-9', 'Loosdrecht 3', 'C8C7D8D7', 'Loosdrecht2a sluis', 'S15', 'ak-20', 'bn-Walem', 'Katwijk 1', 'ws-11', 'Kadoelen 1', 'Middensluis NZK', 'Station 5', 'ma-3', 'Station 13', 'bh-37', 'PC4C-A7-3', 'VLVS15', 'bpns-buitenratel', 'Willem 2 sluis 2', 'ak-4', 'Zaangemaal 1', 'ak-11', 'Station 10', 'MS-11', 'bpns-middelkerkebank', 'VLVS9', 'bpns-ZAND4', 'slAsp', 'bpns-OOSTDYCK', 'bh-9', 'PC4C-F05-6', 'ak-42', 'VLVS10', 'Overtoom 3', 'ws-DL12', 'bh-27', 'bh-5', 'sIOud', 'PC4C-B08-6', 'Katwijk 2', 'ak-36', 'bpns-reefballs Belwind', 'bpns-VG2', 'bpns-C05AR3Belwind', 'De Poel', 'R06', 's-Dendermonde', 'bh-13', 'bh-4', 'Lelystad', 'ma-1', 'MS-20', 'bpns-RTNZ06', 'PC4C-C09-1', 'bpns-CNB02', 'PC4C-B08-4', 'HH5', 'PC4C-A7-2', 'bpns-Lottobuoy', 'ws-25A', 'R05', 'ak-32', 'Station 7D', 'ak-12', 'MS-4', 'Boezem Spaarne', 'de-23', 'ak-31', 'ak-45', 'ws-A1', 'bh-18', 'du-Hamveer', 'PC4C-B6-3', 'MS-15', 'bpns-NobelwindG10', 'bpns-A1BIS', 'MS-12', 'RingvZ', 'Station 1', 'ak-34', 'bpns-OH6', 'bpns-CNB12', 'de-11', 'VLVS7', 's-11', 'ak-24', 'Rentel', 'de-15', 'ODW', 'SU-1', 'SOmZwa', 'AspOud', 'R10', 'ma-7', 'PC4C-F05-5', 'PC4C-B6-4', 'MS-9', 'ws-53', 'WK9', 'bpns-Wenduinebank West', 'ws-55', 'bpns-nieuwpoortbank', 'stMel', 'MS-3', 'gn-Lier', 'ak-27', 'ak-26', 'bpns-WKSabrina', 'MerAsp', 'BP-3', 'ws-23', 'ws-SP3', 'ws-4', '', 'S13', 'bh-28', 'bpns-boudewijn', 'C7', 'MS-29', 'PC4C-A5-1', 'ma-4', 'ws-A5', 'ak-21', 's-5', 'de-6', 'bpns-LottoBuoy', '500m', 'ws-OG10', 'VLVS4', 'MS-10', 'PC4C-A7-4', 'GB', 'bpns-B05BELWIND', 'de-2', 'bpns-CPowerReefballs', 'Spaarne sluis', 'PC4C-A5-3', 'Enkhuizen', 'bh-23', 'PC4C-C05-8', 'bh-30', 'VLVS2', 'bpns-CNB13', 'T1', 'R01', 'PC4C-B10-6', 'ws-16', 'HH4', 's-3', 'PC4C-B08-3', 'ak-46', 'de-13', 'bpns-RTNZ02', 'R11', 'Maarkebeek - onder eerste knelpunt', 'ws-K', 'de-16', 'saTBZwa', 's-7', 's-1', 'Kadoelen 4', 'bh-7', '03 MG caldeirinha fora', 'Spuisluis Noordzee', 'Tst', 's-10a', 'ws-WN2', 'PC4C-B10-1', 'bh-22', 'S08', 'ak-25', 'Loosdrecht 1', 'PC4C-C05-7', 'bpns-RTNZ01', 'T0', 'Station 12', 'de-21', 'bpns-Kilmore', 'bh-2', 'R08', 'MS-34', 'de-12', '02 MG almeida', 'ngAspsa', 'Grote sluis NZK', 'PC4C-B6-5', 'SU-2', 'MS-19', 'B9B8C8C9', 'M-6', 'WS-250m', 'bh-31', 'bpns-Wenduinebankw', 'Zwanenburg', 'MS-28', 'Spuisluis NZK', 'ES-1', 'ws-HW6', 'bpns-CNB11', 'PC4C-A7-1', 'S09', 'HH2', 'bh-15', 'PC4C-C05-4', 'stgAsp', 'M-1', 'bpns-KB2', 'ak-1', 'ws-FZ2', 'bpns-CNB06', 'ak-33', 'bpns-WK14', 'ws-12A', '01 MG Pasteleiro', 'MS-38', 'soAsp', 'Bovenschelde - stroomop complex Kerkhove', 'Kadoelen 2', 'VLVS5', 'bpns-RTNZ04', 'PC4C-A5-4', 'RingvWn', 'de-4', 's-8', 'PC4C-B10-4', 'Halfweg NZKzijde', 'Station 14', 'HH10', 's-4c', 'bh-20', 'bpns-CNB08', 'Station 7C', 'bh-10', 'ws-F42', 'ak-40', 'ak-5', 'ws-6', 'MS-5', 'bpns-RYCO', 'ws-W6', 'ws-GVWSP', 'M-7', 'ak-17', 'Middensluis Noordzee', 'bpns-RTNZ05', 'bh-12', 'ws-25B', 'VLVS6', 'Noordzeekanaal', 'PC4C-A6-1', 'bpns-W1', 'MS-39', 'Loosdracht 2b gemaal', 'Gootebank', 'PC4C-F05-4', 'kn-Lier', 'bh-11', 'ak-23', 'Cruquius', 'Belreef 2', 'PC4C-B10-2', 'IN-1', 'bpns-Duc de Normandie', 'HH3', 'ma-9', 'PC4C-B6-1', 'bpns-CNB14', 'MS-8', 'ws-W7', 's-Wetteren', 'ARK Noord', 'MS-22', 'PC4C-B7-1', 'bh-24', 'Station 3', 'MS-17', 'Station 8C', 'MS-40', 'PC4C-C09-2', 'ws-14', 'Grote sluis Noordzee', 'ngOudso', 'VLVS3', 's-9', 's-2a', 'de-3', 'PC4C-B09-1', 'bpns-oostdyck west', 'MS-18', 'ARK Zuid', 'PC4C-B10-5', 'bpns-Middelkerke South', 'MS-13', 's-4b', 'Zaangemaal 2', 'bpns-CNB10', 'bpns-Reefballs Belwind', 'BP-2', 'ma-2', 'R09', 'de-9', 'de-8', 'M-2', 's-6', 'MS-2', 'bpns-WK16', 'Kleine sluis Noordzee', 'Schinkelsluis', 'ak-9', 'MS-23', 'Belwind_Release_2053', 'ws-STEEN', 'ws-A3', 'bpns-GARDENCITY', 'PC4C-C05-10', 'ws-53A', 'PC4C-A7-6', 'VLVS11', 'ma-8', 'HH9', 'ak-6', 'BP-4', 'ak-13', 'S10', 'bh-1', 'BlighBank', 'ak-19', 'ak-8', 'ws-42A', 'ak-43', 'Zult', 'M-3', 'bpns-CNB07', 'VLVS14', 'Tsost', 'PC4C-C05-1', 'ak-38', 'PC4C-F05-2', 'R03', 'bpns-Oostendebank Oost', 'bh-32', 'ws-PPB', 'M-4A', 'ak-22', 'Nautica Ena', 'Station 4', 'Station 15')
  AND transmitter IN ('A69-1601', 'A69-1105', 'A69-1008', 'R64K', 'A69-9002', 'H170-1802', 'A69-1303', 'A69-9006', 'A69-9004', 'A180-1702', 'A69-1602')
  AND receiver IN ('VR2AR-545720', 'VR2W-112291', 'VR2W-108474', 'VR2C-450114', 'VR2W-115432', 'VR2W-112287', 'VR2AR-545588', 'VR2W-123818', 'VR2W-113524', 'VR2W-120885', 'VR2W-123813', 'VR2W-123813', 'VR2W-120881', 'VR2W-113528', 'VR2W-120876', 'VR2W-122348', 'VR2W-123813', 'VR2W-122348', 'VR2W-122350', 'VR2W-112297', 'VR2W-122350', 'VR2W-127732', 'VR2W-129569', 'VR2W-127022', 'VR2W-127024', 'VR2W-127027', 'VR2W-127028', 'VR2W-112287', 'VR2W-127024', 'VR2C-450113', 'VR2W-122364', 'VR2W-122350', 'VR2W-122364', 'VR2W-124070', 'VR2W-112287', 'VR2W-124061', 'VR2W-124064', 'VR2W-115447', 'VR2W-112297', 'VR2W-123821', 'VR2W-122338', 'VR2W-112297', 'VR2W-127733', 'VR2W-123826', 'VR2W-124061', 'VR2W-124061', 'VR2W-124061', 'VR2W-124070', 'VR2W-123833', 'VR2W-110778', 'VR2W-123826', 'VR2W-106251', 'VR2W-123815', 'VR2W-122354', 'VR2W-127023', 'VR2W-123817', 'VR2W-127725', 'VR2W-113528', 'VR2W-113527', 'VR2W-119071', 'VR2W-115432', 'VR2W-112291', 'VR2W-123824', 'VR2W-112289', 'VR2W-123815', 'VR2W-123817', 'VR2W-123819', 'VR2W-123831', 'VR2W-123817', 'VR2W-123816', 'VR2W-120885', 'VR2W-120875', 'VR2W-127732', 'VR2AR-545588', 'VR2W-126195', 'VR2W-120873', 'VR2-4833', 'VR2W-123831', 'VR2W-123815', 'VR2W-123815', 'VR2W-122353', 'VR2W-123817', 'VR2W-123817', 'VR2W-123817', 'VR2W-123817', 'VR2W-123813', 'VR2W-127032', 'VR2W-124071', 'VR2W-122346', 'VR2W-122346', 'VR2W-122346', 'VR2W-124071', 'VR2W-124071', 'VR2W-122346', 'VR2W-120881', 'VR2W-123824', 'VR2-4833', 'VR2W-120883', 'VR2W-120884', 'VR2W-112370', 'VR2W-112370', 'VR2W-120886', 'VR2W-120887', 'VR2W-113525', 'VR2W-124066', 'VR2W-122363', 'VR2W-126201', 'VR2W-120876', 'VR2W-123816', 'VR2W-122347', 'VR2W-123816', 'VR2W-123813', 'VR2W-123813', 'VR2W-120874', 'VR2W-120876', 'VR2W-120876', 'VR2W-127025', 'VR2W-113525', 'VR2W-123832', 'VR2W-115435', 'VR2TX-480424', 'VR2TX-480411', 'VR2W-120873', 'VR2W-120887', 'VR2W-127737', 'VR2W-127734', 'VR2W-127735', 'VR2W-127725', 'VR2W-127731', 'VR2W-127731', 'VR2W-127734', 'VR2W-127725', 'VR2W-127733', 'VR2W-127734', 'VR2W-127735', 'VR2W-127737', 'VR2W-120887', 'VR2W-120885', 'VR2W-106251', 'VR2W-123819', 'VR2W-123821', 'VR2W-123816', 'VR2W-123816', 'VR2W-123814', 'VR2W-123830', 'VR2W-123830', 'VR2W-123830', 'VR2W-123830', 'VR2W-123820', 'VR2W-123815', 'VR2W-123831', 'VR2W-123819', 'VR2W-123819', 'VR2W-123819', 'VR2W-123832', 'VR2W-127025', 'VR2W-127025', 'VR2W-123832', 'VR2W-123831', 'VR2W-123832', 'VR2W-127718', 'VR2W-123820', 'VR2W-127727', 'VR2W-123815', 'VR2W-123814', 'VR2W-112290', 'VR2W-112290', 'VR2W-112290', 'VR2W-112290', 'VR2W-123814', 'VR2W-122348', 'VR2W-112299', 'VR2W-112299', 'VR2W-112299', 'VR2W-112299', 'VR2W-112299', 'VR2W-123818', 'VR2W-126202', 'VR2W-120887', 'VR2W-126202', 'VR2W-122368', 'VR2W-112299', 'VR2W-120885', 'VR2W-120887', 'VR2W-127032', 'VR2TX-480423', 'VR2W-122343', 'VR2W-120885', 'VR2W-120887', 'VR2W-122343', 'VR2W-102053', 'VR2W-131979', 'VR2W-124073', 'VR2W-120885', 'VR2W-122338', 'VR2W-120887', 'VR2W-122343', 'VR2W-115447', 'VR2W-126202', 'VR2W-120881', 'VR2W-122338', 'VR2W-122343', 'VR2W-120882', 'VR2W-120886', 'VR2W-120885', 'VR2W-123818', 'VR2W-123818', 'VR2W-120883', 'VR2W-122329', 'VR2W-124071', 'VR2W-122352', 'VR2W-120874', 'VR2W-115434', 'VR2W-120884', 'VR2W-120880', 'VR2W-127025', 'VR2W-120879', 'VR2W-120881', 'VR2W-127736', 'VR2W-122329', 'VR2W-120873', 'VR2W-120873', 'VR2W-120873', 'VR2W-126196', 'VR2W-120877', 'VR2W-120877', 'VR2W-120877', 'VR2W-120877', 'VR2W-120878', 'VR2W-120878', 'VR2W-120878', 'VR2W-120878', 'VR2W-120882', 'VR2W-120877', 'VR2W-120882', 'VR2W-120882', 'VR2W-120882', 'VR2W-120883', 'VR2W-120883', 'VR2W-120883', 'VR2W-120884', 'VR2W-120884', 'VR2W-120884', 'VR2W-124073', 'VR2W-120886', 'VR2W-120886', 'VR2W-120886', 'VR2W-120873', 'VR2W-122329', 'VR2W-122329', 'VR2W-120881', 'VR2W-120881', 'VR2W-124071', 'VR2W-115434', 'VR2W-120878', 'VR2W-115447', 'VR2W-120883', 'VR2W-120873', 'VR2W-122346', 'VR2W-120878', 'VR2W-124071', 'VR2W-120886', 'VR2W-122343', 'VR2W-122352', 'VR2W-115434', 'VR2W-127736', 'VR2W-115434', 'VR2W-120874', 'VR2W-120876', 'VR2W-120874', 'VR2W-120874', 'VR2W-120884', 'VR2W-120873', 'VR2W-120877', 'VR2W-120878', 'VR2W-120886', 'VR2W-122343', 'VR2W-126202', 'VR2W-112299', 'VR2W-115434', 'VR2W-120884', 'VR2W-120881', 'VR2W-112289', 'VR2W-112289', 'VR2W-112289', 'VR2W-112289', 'VR2W-122352', 'VR2W-112289', 'VR2W-120874', 'VR2W-129566', 'VR2W-120876', 'VR2W-120878', 'VR2W-113523', 'VR2W-120882', 'VR2W-120883', 'VR2W-120884', 'VR2W-120885', 'VR2W-120886', 'VR2W-122329', 'VR2W-122343', 'VR2W-122346', 'VR2W-124071', 'VR2W-129710', 'VR2W-112298', 'VR2W-112298', 'VR2W-112298', 'VR2W-122352', 'VR2W-112298', 'VR2-5936', 'VR2-5936', 'VR2W-122352', 'VR2W-122352', 'VR2W-122352', 'VR2W-122352', 'VR2W-112298', 'VR2W-129709', 'VR2W-122356', 'VR2W-113529', 'VR2W-123820', 'VR2W-113529', 'VR2W-113529', 'VR2W-113522', 'VR2W-122330', 'VR2W-112287', 'VR2W-129570', 'VR2W-115428', 'VR2W-123827', 'VR2W-115428', 'VR2W-110779', 'VR2W-127724', 'VR2W-106251', 'VR2W-127722', 'VR2W-113521', 'VR2W-113521', 'VR2W-113521', 'VR2W-113522', 'VR2W-124078', 'VR2W-110778', 'VR2W-122330', 'VR2W-127720', 'VR2W-115434', 'VR2W-127032', 'VR2W-113525', 'VR2W-113529', 'VR2W-115436', 'VR2W-115439', 'VR2W-122321', 'VR2W-122333', 'VR2W-122349', 'VR2W-122351', 'VR2W-122359', 'VR2AR-546048', 'VR2W-122329', 'VR2W-113527', 'VR2W-113527', 'VR2W-113527', 'VR2W-113527', 'VR2W-113526', 'VR2W-126197', 'VR2W-115438', 'VR2W-122320', 'VR2W-122350', 'VR2W-124061', 'VR2W-124070', 'VR2W-127026', 'VR2W-120874', 'VR2W-123818', 'VR2W-123814', 'VR2W-112370', 'VR2W-115447', 'VR2W-129571', 'VR2W-126194', 'VR2W-126196', 'VR2W-126200', 'VR2W-120877', 'VR2W-123822', 'VR2W-113524', 'VR2W-113526', 'VR2W-115431', 'VR2W-114312', 'VR2W-123823', 'VR2W-114535', 'VR2W-126202', 'VR2W-123813', 'VR2Tx-480876', 'VR2W-123815', 'VR2W-123817', 'VR2W-123819', 'VR2W-123820', 'VR2W-123830', 'VR2W-123831', 'VR2W-127718', 'VR2W-127727', 'VR2W-115447', 'VR2W-129566', 'VR2W-112370', 'VR2W-126202', 'VR2W-120873', 'VR2W-120874', 'VR2W-120882', 'VR2W-120883', 'VR2W-120878', 'VR2W-114258', 'VR2C-450136', 'VR2W-127733', 'VR2W-113524', 'VR2-4231', 'VR2W-123813', 'VR2W-123815', 'VR2W-127731', 'VR2W-113524', 'VR2W-115436', 'VR2W-115436', 'VR2W-127032', 'VR2W-115436', 'VR2W-127032', 'VR2W-115434', 'VR2W-115434', 'VR2W-123820', 'VR2W-122329', 'VR2W-120882', 'VR2W-115434', 'VR2-3054', 'VR2W-123833', 'VR2W-115434', 'VR2W-123824', 'VR2W-123821', 'VR2W-110779', 'VR2W-124071', 'VR2W-120884', 'VR2W-120886', 'VR2W-122343', 'VR2W-129710', 'VR2W-127728', 'VR2W-122350', 'VR2W-115435', 'VR2W-122357', 'VR2W-123820', 'VR2W-127735', 'VR2W-127737', 'VR2W-115435', 'VR2W-127739', 'VR2W-115440', 'VR2W-122322', 'VR2W-106251', 'VR2W-114163', 'VR2W-123821', 'VR2AR-546892', 'VR2W-115444', 'VR2-3054', 'VR2W-123824', 'VR2W-115434', 'VR2W-115434', 'VR2W-115444', 'VR2W-115444', 'VR2W-115444', 'VR2W-115444', 'VR2W-115444', 'VR2Tx-480061', 'VR2W-115443', 'VR2W-115447', 'VR2W-115430', 'VR2W-115430', 'VR2W-106253', 'VR2W-115433', 'VR2W-115433', 'VR2-2914', 'VR2-7328', 'VR2W-129565', 'VR2-3055', 'VR2-3055', 'VR2-3055', 'VR2-3055', 'VR2-3055', 'VR2-2914', 'VR2-2914', 'VR2-5773', 'VR2-5773', 'VR2W-123818', 'VR2W-123818', 'VR2W-123819', 'VR2W-123820', 'VR2W-123830', 'VR2W-123831', 'VR2W-123832', 'VR2W-127718', 'VR2W-127727', 'VR2W-123819', 'VR2W-123820', 'VR2W-123830', 'VR2W-123831', 'VR2W-123832', 'VR2-5326', 'VR2-5326', 'VR2-5326', 'VR2W-115442', 'VR2AR-546893', 'VR2W-122362', 'VR2W-122362', 'VR2W-127726', 'VR2W-122322', 'VR2W-122362', 'VR2W-122362', 'VR2W-124078', 'VR2W-122367', 'VR2W-112286', 'VR2W-122367', 'VR2W-122367', 'VR2W-126194', 'VR2W-110781', 'VR2W-110783', 'VR2C-450136', 'VR2W-114165', 'VR2W-132408', 'VR2W-132409', 'VR2W-124070', 'VR2W-124070', 'VR2W-126194', 'VR2W-126194', 'VR2AR-546047', 'VR2W-126195', 'VR2W-122364', 'VR2W-124076', 'VR2W-124076', 'VR2W-122364', 'VR2W-122362', 'VR2W-124070', 'VR2W-112286', 'VR2W-113529', 'VR2W-126195', 'VR2W-126196', 'VR2W-126197', 'VR2W-124076', 'VR2W-126198', 'VR2W-126199', 'VR2W-126200', 'VR2W-126200', 'VR2W-127026', 'VR2W-127026', 'VR2W-127026', 'VR2W-127026', 'VR2W-127724', 'VR2W-123833', 'VR2AR-545564', 'VR2W-127111', 'VR2W-127726', 'VR2W-112286', 'VR2W-127720', 'VR2W-126198', 'VR2W-112286', 'VR2W-127724', 'VR2W-126196', 'VR2W-126199', 'VR2W-126200', 'VR2W-127026', 'VR2W-122335', 'VR2W-112288', 'VR2AR-545719', 'VR2AR-546046', 'VR2W-123825', 'VR2W-107448', 'VR2W-110781', 'VR2W-115446', 'VR2W-113526', 'VR2W-115430', 'VR2W-127027', 'VR2W-113522', 'VR2W-110784', 'VR2AR-545718', 'VR2W-113526', 'VR2W-123812', 'VR2W-110778', 'VR2W-110779', 'VR2W-110779', 'VR2AR-546048', 'VR2W-115439', 'VR2W-112291', 'VR2W-124065', 'VR2W-127027', 'VR2W-115444', 'VR2W-122350', 'VR2W-122337', 'VR2W-124078', 'VR2W-123827', 'VR2W-127724', 'VR2W-124061', 'VR2W-122335', 'VR2W-124065', 'VR2W-127027', 'VR2W-127027', 'VR2W-115435', 'VR2W-129564', 'VR2W-124064', 'VR2W-122330', 'VR2W-124070', 'VR2W-112291', 'VR2W-112295', 'VR2W-122325', 'VR2W-132411', 'VR2W-132415', 'VR2W-132416', 'VR2W-108474', 'VR2W-127722', 'VR2W-123834', 'VR2W-110778', 'VR2W-122326', 'VR2W-124066', 'VR2W-124063', 'VR2W-124063', 'VR2W-122336', 'VR2W-122336', 'VR2W-122363', 'VR2W-122363', 'VR2W-122367', 'VR2W-126195', 'VR2W-112285', 'VR2W-120092', 'VR2W-124076', 'VR2AR-545718', 'VR2W-126194', 'VR2W-112297', 'VR2W-112287', 'VR2W-122322', 'VR2W-124069', 'VR2W-122363', 'VR2W-127111', 'VR2W-127722', 'VR2AR-545720', 'VR2W-127734', 'VR2W-112296', 'VR2W-113529', 'VR2W-112295', 'VR2W-113523', 'VR2W-115430', 'VR2W-122333', 'VR2W-129569', 'VR2W-129571', 'VR2W-126201', 'VR2W-127732', 'VR2W-115441', 'VR2W-115442', 'VR2W-112295', 'VR2W-112295', 'VR2W-127028', 'VR2W-127029', 'VR2W-122357', 'VR2W-115437', 'VR2W-112295', 'VR2W-113528', 'VR2C-450116', 'VR2W-127738', 'VR2W-127030', 'VR2W-127031', 'VR2W-122334', 'VR2W-131000', 'POD-2421', 'VR2W-127032', 'VR2W-127722', 'VR2W-122320', 'VR2W-115428', 'VR2W-123826', 'VR2Tx-480721', 'VR2W-120876', 'VR2W-127716', 'VR2W-127716', 'VR2W-127719', 'VR2W-120876', 'VR2W-120882', 'VR2W-122339', 'VR2W-122350', 'VR2W-122330', 'VR2AR-546896', 'VR2W-113525', 'VR2W-122362', 'VR2W-122320', 'VR2W-124061', 'VR2AR-545718', 'VR2W-106252', 'VR2W-115428', 'VR2W-115428', 'VR2W-124072', 'VR2W-120092', 'VR2W-122320', 'VR2W-122320', 'VR2W-126197', 'POD-2725', 'VR2W-124070', 'VR2W-126197', 'VR2W-122340', 'VR2W-115439', 'VR2W-115445', 'VR2W-106251', 'VR2W-113526', 'VR2W-126196', 'VR2W-113529', 'VR2W-126199', 'VR2W-127728', 'VR2W-120885', 'VR2W-127110', 'VR2AR-546177', 'VR2AR-546201', 'VR2W-127729', 'VR2W-113523', 'VR2W-115430', 'VR2W-115441', 'VR2W-114312', 'VR2W-113521', 'VR2W-113522', 'VR2W-113528', 'VR2W-127109', 'VR2W-115431', 'VR2W-129568', 'VR2W-115443', 'VR2W-122348', 'VR2W-126198', 'VR2W-126199', 'VR2W-122330', 'VR2W-122320', 'VR2W-110779', 'VR2W-122320', 'VR2W-122320', 'VR2W-122325', 'VR2W-122333', 'VR2W-115445', 'VR2W-115443', 'VR2W-122326', 'VR2W-112299', 'VR2W-113522', 'VR2W-112298', 'VR2W-112290', 'VR2Tx-480061', 'VR2W-110784', 'VR2W-113525', 'VR2W-115441', 'VR2W-112295', 'VR2W-115431', 'VR2W-115442', 'VR2W-115432', 'VR2W-123822', 'VR2Tx-480722', 'VR2W-123823', 'VR2W-123828', 'VR2W-112289', 'VR2-5773', 'VR2W-127730', 'VR2-5936', 'VR2W-123827', 'VR2W-114258', 'VR2W-123828', 'VR2W-122320', 'VR2W-122319', 'VR2W-115436', 'VR2Tx-480062', 'VR2W-115428', 'VR2W-112293', 'VR2W-112298', 'VR2W-110869', 'VR2W-110783', 'VR2W-114312', 'VR2W-124060', 'VR2W-122362', 'VR2W-122323', 'VR2W-122319', 'VR2W-122355', 'VR2W-122349', 'VR2C-450114', 'VR2W-127721', 'VR2W-124072', 'VR2W-106251', 'VR2W-122320', 'VR2W-115430', 'VR2W-113529', 'VR2W-113521', 'VR2W-113527', 'VR2W-115434', 'VR2W-115433', 'VR2W-124076', 'VR2W-122367', 'VR2W-122345', 'VR2W-122344', 'VR2W-122341', 'VR2W-122331', 'VR2W-110784', 'VR2W-127028', 'VR2W-129571', 'VR2W-123827', 'VR2W-127726', 'VR2W-115432', 'VR2W-127738', 'VR2W-127732', 'VR2W-110784', 'VR2W-127719', 'VR2W-112370', 'VR2W-101578', 'VR2W-123835', 'VR2C-450111', 'VR2W-123835', 'VR2W-122348', 'VR2W-122333', 'VR2W-122348', 'VR2W-127720', 'VR2W-115428', 'VR2W-122348', 'VR2W-123829', 'VR2W-115439', 'VR2W-110783', 'VR2W-110783', 'VR2W-115431', 'VR2W-123829', 'VR2W-123829', 'VR2W-123829', 'VR2W-123829', 'VR2W-112285', 'VR2W-122256', 'VR2AR-546202', 'VR2AR-546198', 'VR2AR-545588', 'VR2W-110778', 'VR2W-115443', 'VR2W-113522', 'VR2W-115431', 'VR2W-112293', 'VR2W-123827', 'VR2W-127110', 'VR2W-123827', 'VR2W-112293', 'VR2W-112293', 'VR2W-123822', 'VR2W-123823', 'VR2W-123822', 'VR2W-123822', 'VR2W-123823', 'VR2W-123823', 'VR2W-123823', 'VR2W-123828', 'VR2W-123828', 'VR2W-123828', 'VR2W-123823', 'VR2W-123827', 'VR2W-123828', 'VR2W-115431', 'VR2W-127721', 'VR2W-122337', 'VR2W-127732', 'VR2W-122359', 'VR2W-115442', 'VR2W-110784', 'VR2W-130999', 'VR2W-115439', 'VR2W-122359', 'VR2W-122325', 'VR2W-122363', 'VR2W-115430', 'VR2W-115441', 'VR2W-127728', 'VR2W-115442', 'VR2W-113521', 'VR2W-122325', 'VR2W-122363', 'VR2W-122337', 'VR2W-112296', 'VR2W-122321', 'VR2W-122331', 'VR2W-113521', 'VR2AR-546043', 'VR2AR-546044', 'VR2AR-546045', 'VR2AR-546046', 'VR2AR-546047', 'VR2AR-546048', 'VR2AR-546049', 'VR2W-122352', 'VR2W-123823', 'VR2W-127716', 'VR2W-127717', 'VR2W-123828', 'VR2W-108474', 'VR2W-110780', 'VR2W-106251', 'VR2W-114258', 'VR2W-112286', 'VR2W-123826', 'VR2AR-545718', 'VR2AR-545720', 'VR2W-114312', 'VR2W-129572', 'VR2W-112292', 'VR2W-112297', 'VR2AR-545720', 'VR2Tx-480062', 'VR2AR-546044', 'VR2AR-546046', 'VR2AR-546047', 'VR2W-115438', 'VR2AR-546048', 'VR2W-113526', 'VR2W-115429', 'VR2W-115435', 'VR2AR-546049', 'VR2AR-546050', 'VR2AR-546051', 'VR2AR-546052', 'VR2AR-546045', 'VR2AR-546043', 'VR2W-122357', 'VR2W-112296', 'VR2W-110778', 'VR2W-122348', 'VR2W-115444', 'VR2-2961', 'VR2W-127723', 'VR2W-112295', 'VR2W-113528', 'VR2W-127719', 'VR2-3054', 'VR2W-127738', 'VR2W-122367', 'VR2W-127729', 'VR2-3054', 'VR2W-123826', 'VR2W-123814', 'VR2W-122322', 'VR2W-112286', 'VR2W-110778', 'VR2W-112290', 'VR2W-112290', 'VR2W-113521', 'VR2W-113524', 'VR2W-127028', 'VR2W-129708', 'VR2W-123827', 'VR2W-123827', 'VR2W-124074', 'VR2W-124075', 'VR2W-106251', 'VR2W-110785', 'VR2W-106251', 'VR2W-110784', 'VR2W-122360', 'VR2Tx-480720', 'VR2W-106253', 'VR2W-110778', 'VR2W-110778', 'VR2W-110779', 'VR2W-110779', 'VR2W-110779', 'VR2W-110780', 'VR2W-110781', 'VR2W-110781', 'VR2W-110782', 'VR2W-110782', 'VR2W-110782', 'VR2W-110783', 'VR2W-110783', 'VR2W-110783', 'VR2W-124073', 'VR2W-112294', 'VR2W-115435', 'VR2-2914', 'VR2-2912', 'VR2-2961', 'VR2-2961', 'VR2-2920', 'VR2-2920', 'VR2-2920', 'VR2-2920', 'VR2-2914', 'VR2W-110784', 'VR2W-110784', 'VR2W-110784', 'VR2-2912', 'VR2-2912', 'VR2-2912', 'VR2W-110779', 'VR2W-115445', 'VR2W-113524', 'VR2W-122324', 'VR2W-127736', 'VR2C-450114', 'VR2AR-546052', 'VR2W-122324', 'VR2AR-546052', 'VR2AR-546048', 'VR2W-110779', 'VR2W-110779', 'VR2W-112287', 'VR2W-110784', 'VR2W-122336', 'VR2W-127716', 'VR2W-127738', 'VR2W-112286', 'VR2W-113524', 'VR2W-115435', 'VR2W-113526', 'VR2W-115429', 'VR2W-122357', 'VR2W-126195', 'VR2W-126197', 'VR2W-127728', 'VR2W-115435', 'VR2W-122330', 'VR2W-129711', 'VR2W-112296', 'VR2W-127028', 'VR2W-129711', 'VR2W-112286', 'VR2W-110784', 'VR2Tx-480061', 'VR2W-129709', 'VR2W-127110', 'VR2W-126194', 'VR2W-127028', 'VR2W-127033', 'VR2W-122353', 'VR2W-129711', 'VR2W-122155', 'VR2W-129708', 'VR2W-126200', 'VR2W-120878', 'VR2W-120884', 'POD-2724', 'POD-2423', 'VR2W-127735', 'VR2W-127737', 'VR2W-126195', 'VR2W-123828', 'VR2W-127725', 'VR2W-127731', 'VR2W-127733', 'VR2W-126201', 'VR2W-127729', 'VR2W-127721', 'VR2W-129567', 'VR2W-129569', 'VR2W-129708', 'VR2Tx-480723', 'VR2W-113528', 'VR2W-127738', 'VR2W-127716', 'VR2W-127032', 'VR2W-124060', 'VR2W-126201', 'VR2W-127725', 'VR2W-129570', 'VR2W-129567', 'VR2W-129569', 'VR2W-127734', 'VR2W-127731', 'VR2W-127737', 'VR2W-123813', 'VR2W-106251', 'VR2W-112295', 'VR2W-127719', 'VR2W-115441', 'VR2W-115430', 'VR2W-122336', 'VR2Tx-480723', 'VR2AR-546044', 'VR2W-122339', 'VR2W-122367', 'VR2W-122363', 'VR2W-115444', 'VR2W-112292', 'VR2W-112295', 'VR2W-113521', 'VR2W-122325', 'VR2W-122322', 'VR2W-113521', 'VR2W-115438', 'VR2W-115430', 'VR2W-115442', 'VR2W-115444', 'VR2W-122325', 'VR2W-122363', 'VR2W-127719', 'VR2W-115441', 'VR2W-112297', 'VR2Tx-480063', 'VR2AR-546622', 'VR2W-112288', 'VR2W-112290', 'VR2W-112286', 'VR2W-122334', 'VR2W-113524', 'VR2W-122340', 'VR2W-113526', 'VR2W-115429', 'VR2W-122357', 'VR2Tx-480876', 'VR2W-113523', 'VR2W-122357', 'VR2W-127728', 'VR2W-127732', 'VR2W-115443', 'VR2W-115443', 'VR2W-127720', 'VR2Tx-480876', 'VR2W-113525', 'VR2W-112290', 'VR2W-113524', 'VR2W-127728', 'VR2W-115435', 'POD-2977', 'POD-2729', 'VR2W-126197', 'VR2W-126199', 'VR2W-122349', 'VR2AR-546043', 'VR2W-122351', 'VR2W-122354', 'VR2W-127025', 'VR2W-122358', 'VR2AR-546045', 'VR2W-122351', 'VR2W-126197', 'VR2W-126199', 'VR2AR-546047', 'VR2W-126194', 'VR2W-126195', 'VR2W-126196', 'VR2W-126200', 'VR2W-122358', 'VR2W-127025', 'POD-2728', 'VR2TX-480415', 'VR2TX-480412', 'VR2TX-480413', 'VR2TX-480421', 'VR2TX-480419', 'VR2TX-480427', 'VR2TX-480407', 'VR2TX-480422', 'VR2TX-480428', 'VR2TX-480425', 'VR2TX-480432', 'VR2W-129563', 'VR2Tx-480721', 'VR2W-123835', 'VR2W-112294', 'VR2W-115440', 'VR2W-123826', 'VR2W-122358', 'VR2W-131000', 'VR2W-112287', 'VR2W-112287', 'VR2W-112287', 'VR2W-112287', 'VR2AR-546897', 'VR2W-114258', 'VR2W-112287', 'VR2Tx-480063', 'POD-2728', 'POD-2976', 'POD-2978', 'VR2W-114312', 'VR2W-114312', 'VR2W-123823', 'VR2W-123823', 'VR2W-114258', 'VR2W-123828', 'VR2W-123828', 'VR2W-127729', 'POD-2421', 'VR2W-123827', 'VR2W-131000', 'VR2W-115428', 'VR2W-127029', 'VR2W-123829', 'VR2W-110869', 'VR2W-110869', 'VR2W-110869', 'VR2W-110869', 'VR2W-127721', 'VR2W-127029', 'VR2W-127030', 'VR2W-127033', 'VR2W-127033', 'VR2W-127029', 'VR2W-127721', 'VR2W-113526', 'VR2W-122155', 'VR2W-127732', 'VR2W-123827', 'VR2W-115435', 'VR2W-123815', 'POD-2978', 'VR2W-110869', 'VR2W-112285', 'VR2W-112285', 'VR2W-112285', 'VR2W-112285', 'VR2W-127029', 'VR2W-112285', 'VR2W-127030', 'VR2W-112285', 'VR2W-112288', 'VR2W-112288', 'VR2W-112288', 'VR2W-112287', 'VR2W-112285', 'VR2W-127033', 'VR2W-127722', 'VR2W-122336', 'VR2W-122328', 'VR2C-450113', 'VR2W-123818', 'VR2W-123832', 'VR2W-123830', 'VR2W-123832', 'VR2W-123819', 'VR2W-123817', 'VR2W-123820', 'VR2W-127031', 'VR2W-115434', 'VR2W-112288', 'VR2W-112288', 'VR2W-112288', 'VR2W-112292', 'VR2W-112292', 'VR2W-127029', 'VR2W-112292', 'VR2W-112292', 'VR2W-112294', 'VR2W-112294', 'VR2W-112294', 'VR2W-113528', 'VR2W-113528', 'VR2W-127033', 'VR2W-112288', 'VR2W-113528', 'VR2W-112292', 'VR2W-122339', 'POD-2976', 'VR2W-127727', 'VR2W-127029', 'VR2W-112296', 'VR2W-127724', 'VR2W-122328', 'VR2W-120887', 'VR2W-115434', 'VR2W-127718', 'VR2W-113529', 'VR2W-113529', 'VR2W-113529', 'VR2W-115429', 'VR2W-115429', 'VR2W-115429', 'VR2W-115429', 'VR2W-115436', 'VR2W-115436', 'VR2W-115436', 'VR2W-115436', 'VR2W-115438', 'VR2AR-545720', 'VR2W-112290', 'VR2W-115429', 'VR2W-112297', 'VR2W-127726', 'VR2W-115436', 'VR2W-115436', 'VR2W-127028', 'VR2W-127726', 'VR2AR-546898', 'VR2W-122332', 'VR2W-122346', 'VR2W-115447', 'VR2W-120887', 'VR2W-123813', 'VR2C-450113', 'VR2W-115438', 'VR2W-115438', 'VR2W-115439', 'POD-2723', 'VR2W-115440', 'VR2W-115440', 'VR2W-115445', 'VR2W-115445', 'VR2W-115445', 'VR2W-119047', 'VR2W-119047', 'VR2W-115438', 'VR2W-113523', 'VR2W-119047', 'VR2W-119048', 'VR2W-119048', 'VR2W-119048', 'VR2W-113523', 'VR2W-122351', 'VR2W-126200', 'VR2W-122346', 'VR2W-126197', 'VR2W-126199', 'VR2W-123815', 'VR2W-126196', 'VR2W-127027', 'VR2W-127027', 'VR2W-126195', 'VR2W-122332', 'VR2W-122332', 'VR2W-126194', 'VR2TX-480410', 'VR2W-119049', 'VR2W-119049', 'VR2W-119049', 'VR2W-119052', 'VR2W-119052', 'VR2W-119056', 'VR2W-119056', 'VR2W-119057', 'VR2W-119057', 'VR2W-119057', 'VR2W-122358', 'VR2W-120095', 'VR2W-120095', 'VR2W-122348', 'VR2TX-480414', 'VR2W-127030', 'VR2W-122354', 'VR2W-127023', 'VR2AR-546896', 'VR2W-122364', 'VR2TX-480429', 'VR2TX-480417', 'VR2W-113528', 'VR2W-123820', 'VR2W-123818', 'VR2TX-480431', 'VR2TX-480418', 'VR2TX-480408', 'VR2W-120095', 'VR2W-113529', 'POD-3111', 'VR2W-127735', 'VR2W-127736', 'VR2W-122319', 'VR2AR-546894', 'VR2W-122319', 'VR2W-122348', 'VR2W-122319', 'VR2AR-546900', 'VR2W-122155', 'VR2W-127736', 'VR2W-112292', 'VR2W-127733', 'VR2W-122331', 'VR2W-127024', 'VR2AR-546899', 'VR2W-122155', 'VR2W-122155', 'VR2W-122156', 'VR2W-112292', 'VR2W-124071', 'VR2W-129566', 'VR2W-127030', 'VR2W-122348', 'VR2W-122321', 'VR2W-122321', 'VR2W-122322', 'VR2W-122319', 'VR2W-122321', 'VR2W-122324', 'VR2W-122324', 'VR2W-122326', 'VR2W-122326', 'VR2W-122326', 'VR2W-122326', 'VR2W-122321', 'VR2W-122327', 'VR2W-122327', 'VR2W-122322', 'VR2W-123818', 'VR2W-122324', 'VR2W-122364', 'VR2W-127025', 'VR2W-127022', 'VR2Tx-480723', 'VR2W-129565', 'VR2W-115438', 'VR2W-123819', 'VR2W-123826', 'VR2W-123826', 'POD-2725', 'VR2W-122328', 'VR2W-122328', 'VR2W-122327', 'VR2W-122331', 'VR2W-122331', 'VR2W-122331', 'VR2W-127110', 'VR2W-122333', 'VR2W-122333', 'VR2W-122333', 'VR2W-122330', 'VR2W-122334', 'VR2W-122334', 'VR2W-120877', 'VR2W-122330', 'VR2W-122330', 'VR2W-115442', 'VR2W-122333', 'VR2W-122333', 'VR2W-127030', 'VR2W-122328', 'VR2W-122324', 'VR2W-122331', 'VR2W-127720', 'VR2W-122332', 'VR2W-122332', 'VR2W-122365', 'VR2W-123831', 'VR2W-123831', 'VR2W-123832', 'VR2W-122334', 'VR2W-122334', 'VR2W-122334', 'VR2W-122334', 'VR2W-122334', 'VR2W-122334', 'VR2W-122334', 'VR2W-112287', 'VR2AR-546895', 'VR2W-122339', 'VR2W-122336', 'VR2W-122338', 'VR2W-122340', 'VR2W-122340', 'VR2W-122339', 'VR2W-127033', 'VR2W-122334', 'VR2W-124065', 'VR2W-122365', 'VR2W-112295', 'VR2W-112295', 'VR2W-113528', 'VR2W-112287', 'VR2W-112297', 'VR2W-115443', 'VR2W-112297', 'VR2W-123830', 'VR2W-127727', 'VR2W-122340', 'VR2W-122340', 'VR2W-122340', 'VR2W-122340', 'VR2W-122340', 'VR2W-122340', 'VR2W-122340', 'VR2W-127031', 'VR2W-122347', 'VR2W-122347', 'VR2W-122347', 'VR2W-122347', 'VR2W-122347', 'VR2W-122347', 'VR2W-122347', 'VR2W-122347', 'VR2W-122322', 'VR2W-122347', 'VR2W-122366', 'VR2W-122340', 'VR2W-127031', 'VR2W-124065', 'VR2W-127110', 'VR2W-129568', 'VR2W-113521', 'VR2W-113521', 'VR2W-115430', 'VR2W-115430', 'VR2W-122343', 'VR2W-129710', 'VR2TX-480426', 'VR2TX-480420', 'VR2W-122349', 'VR2W-122349', 'VR2W-122349', 'VR2W-122349', 'VR2W-122349', 'VR2W-122349', 'VR2W-122351', 'VR2W-122353', 'VR2W-122353', 'VR2W-122353', 'VR2W-122353', 'VR2W-122353', 'VR2W-122353', 'VR2W-122349', 'VR2W-127723', 'VR2W-122351', 'VR2W-122351', 'VR2W-122349', 'VR2AR-546052', 'VR2W-127033', 'VR2W-122349', 'VR2W-124066', 'VR2W-122347', 'VR2W-122366', 'VR2AR-546900', 'VR2W-122353', 'VR2W-122353', 'VR2W-122353', 'VR2AR-546051', 'VR2W-122354', 'VR2W-122354', 'VR2W-122354', 'VR2W-122354', 'VR2W-122354', 'VR2W-122354', 'VR2W-122354', 'VR2W-122354', 'VR2W-122354', 'VR2W-122354', 'VR2W-122353', 'VR2W-122358', 'VR2W-122358', 'VR2W-122358', 'VR2W-122360', 'VR2W-124078', 'VR2W-115442', 'VR2W-112290', 'VR2W-112288', 'VR2Tx-480876', 'VR2W-110779', 'VR2W-115444', 'VR2W-115438', 'VR2W-115441', 'VR2W-122358', 'VR2W-122358', 'VR2W-122359', 'VR2W-122359', 'VR2W-122359', 'VR2W-122359', 'VR2W-122360', 'VR2W-122360', 'VR2W-122360', 'VR2W-122360', 'VR2W-122360', 'VR2W-122360', 'VR2W-122360', 'VR2W-122360', 'VR2W-122360', 'VR2W-122360', 'VR2W-122360', 'VR2W-122362', 'VR2W-122362', 'VR2AR-546621', 'VR2W-122362', 'VR2W-120874', 'VR2W-124078', 'VR2W-122157', 'VR2W-122359', 'VR2W-122361', 'VR2W-122361', 'VR2W-113525', 'VR2W-115444', 'VR2W-122322', 'VR2W-122325', 'VR2W-122325', 'VR2W-122362', 'VR2W-122366', 'VR2W-122366', 'VR2W-122367', 'VR2W-122367', 'VR2W-122367', 'VR2W-122366', 'VR2W-122367', 'VR2W-124060', 'VR2W-124060', 'VR2W-124060', 'VR2W-122336', 'VR2W-122367', 'VR2W-115439', 'VR2W-122157', 'VR2W-112288', 'VR2W-122354', 'VR2W-124066', 'VR2W-115436', 'VR2W-124076', 'VR2W-122155', 'VR2W-122155', 'VR2W-122155', 'VR2W-122155', 'VR2W-124060', 'VR2W-122155', 'VR2W-124060', 'VR2W-127719', 'VR2W-124064', 'VR2W-124064', 'VR2W-124064', 'VR2W-124064', 'VR2W-122155', 'VR2W-127023', 'VR2W-127023', 'VR2W-127024', 'VR2W-122156', 'VR2W-127031', 'VR2W-127024', 'VR2W-124060', 'VR2W-127024', 'VR2W-122156', 'VR2W-122155', 'VR2W-122364', 'VR2W-122365', 'VR2W-122365', 'VR2W-122319', 'VR2W-124059', 'VR2W-124059', 'VR2W-124059', 'VR2W-122365', 'POD-2730', 'POD-2422', 'POD-2725', 'VR2W-124067', 'VR2W-124067', 'VR2W-124067', 'VR2W-124068', 'VR2W-124077', 'VR2W-124077', 'VR2W-124077', 'VR2W-124077', 'VR2W-124077', 'VR2W-127022', 'VR2W-127031', 'VR2W-127022', 'VR2W-127022', 'VR2AR-545718', 'VR2W-124068', 'VR2W-127022', 'VR2W-127738', 'VR2W-127022', 'VR2W-127023', 'VR2W-127023', 'VR2W-122321', 'VR2W-124062', 'VR2W-124062', 'VR2W-124062', 'VR2W-124063', 'VR2W-106251', 'VR2W-129572', 'POD-2955', 'VR2Tx-480061', 'VR2W-127023', 'VR2W-127023', 'VR2W-127023', 'VR2W-127023', 'VR2W-127024', 'VR2W-127024', 'VR2AR-546891', 'VR2W-127023', 'VR2W-127031', 'VR2W-120093', 'VR2AR-546620', 'POD-2422', 'POD-2420', 'POD-2750', 'POD-2423', 'VR2W-120873', 'VR2W-120095', 'VR2W-120096', 'VR2W-119064', 'VR2W-119062', 'VR2W-120097', 'VR2W-120098', 'VR2W-130584', 'VR2W-130586', 'VR2W-130587', 'VR2W-130585', 'VR2W-120883', 'VR2W-120886', 'VR2W-110778', 'VR2W-129570', 'VR2W-129563', 'VR2AR-546891', 'VR2AR-546894', 'VR2W-127729', 'VR2W-122329', 'VR2W-127715', 'POD-409', 'POD-2421', 'POD-2730', 'POD-2729', 'POD-2750', 'POD-2724', 'POD-2420', 'POD-2420', 'POD-2723', 'POD-2578', 'POD-2730', 'POD-2578', 'POD-2421', 'POD-2751', 'POD-2422', 'POD-2730', 'POD-2977', 'POD-2578', 'POD-2422', 'POD-2728', 'POD-2750', 'POD-2724', 'VR2Tx-480063', 'POD-2726', 'POD-3110', 'POD-2725', 'POD-2421', 'POD-2729', 'POD-2724', 'VR2AR-546179', 'VR2AR-546183', 'VR2AR-546203', 'VR2AR-546208', 'VR2AR-546189', 'VR2AR-546185', 'VR2AR-546209', 'VR2AR-546206', 'VR2AR-546200', 'VR2AR-546193', 'VR2AR-546187', 'VR2AR-546194', 'VR2AR-546204', 'VR2AR-546210', 'VR2AR-546181', 'VR2AR-546172', 'VR2AR-546195', 'VR2AR-546173', 'VR2AR-546178', 'VR2AR-546176', 'VR2AR-546182', 'VR2AR-546226', 'VR2AR-546207', 'VR2AR-546171', 'VR2AR-546186', 'VR2AR-546174', 'VR2AR-546188', 'VR2AR-546199', 'VR2AR-546205', 'VR2AR-546175', 'VR2AR-546197', 'VR2AR-546192', 'VR2AR-546190', 'VR2AR-546184', 'VR2AR-546180', 'VR2AR-546191', 'VR2AR-546179', 'VR2W-113524', 'VR2W-102053', 'VR2W-102054', 'VR2W-102054', 'VR2W-102056', 'VR2W-102056', 'VR2W-102058', 'VR2W-102058', 'VR2W-102061', 'VR2W-102061', 'VR2W-103670', 'VR2W-103670', 'VR2W-103671', 'VR2W-103671', 'VR2W-103672', 'VR2W-103672', 'VR2W-103673', 'VR2W-103673', 'VR2W-107052', 'VR2W-107052', 'VR2W-114163', 'VR2W-102057', 'VR2W-102057', 'VR2W-114164', 'VR2W-114164', 'VR2W-114164', 'VR2W-114165', 'VR2W-114165', 'VR2W-102063', 'VR2W-102063', 'VR2W-114167', 'VR2W-114167', 'VR2W-114167', 'VR2W-114178', 'VR2W-114178', 'VR2W-114178', 'VR2W-113524', 'VR2W-119048', 'VR2W-119048', 'VR2W-119049', 'VR2W-119049', 'VR2W-119047', 'VR2W-119047', 'VR2W-119059', 'VR2W-119059', 'VR2W-119057', 'VR2W-119057', 'VR2W-119060', 'VR2W-119060', 'VR2W-119055', 'VR2W-119055', 'VR2W-119056', 'VR2W-119056', 'VR2W-119065', 'VR2W-119065', 'VR2W-119066', 'VR2W-119066', 'VR2W-119054', 'VR2W-119054', 'VR2W-119067', 'VR2W-119067', 'VR2W-119069', 'VR2W-119069', 'VR2W-119070', 'VR2W-119070', 'VR2W-120092', 'VR2W-120092', 'VR2W-120094', 'VR2W-120094', 'VR2W-119052', 'VR2W-119052', 'VR2W-120095', 'VR2W-120096', 'VR2W-119064', 'VR2W-119062', 'VR2W-120097', 'VR2W-120098', 'VR2W-129709', 'VR2W-129709', 'VR2W-130584', 'VR2W-130586', 'VR2W-130587', 'VR2W-130998', 'VR2W-130998', 'VR2W-131001', 'VR2W-131001', 'VR2W-131978', 'VR2W-131978', 'VR2W-131980', 'VR2W-131980', 'VR2W-131002', 'VR2W-131002', 'VR2W-132408', 'VR2W-132408', 'VR2W-132409', 'VR2W-132409', 'VR2W-132410', 'VR2W-132410', 'VR2W-132410', 'VR2W-130585', 'VR2W-131979', 'VR2W-132411', 'VR2W-132411', 'VR2W-132412', 'VR2W-132412', 'VR2W-132412', 'VR2W-132413', 'VR2W-132413', 'VR2W-132413', 'VR2W-132414', 'VR2W-132414', 'VR2W-132414', 'VR2W-132415', 'VR2W-132415', 'VR2W-132416', 'VR2W-132416', 'VR2W-132417', 'VR2W-132417', 'VR2W-132417', 'VR2W-123827', 'VR2W-124076', 'VR2W-100482', 'VR2W-125885', 'VR2W-131086', 'VR2W-131092', 'VR2W-131083', 'VR2W-131087', 'VR2W-131091', 'VR2W-131085', 'VR2W-131084', 'VR2W-131089', 'VR2W-131090', 'VR2W-131088', 'VR2W-125884', 'VR2W-125444', 'VR2W-125441', 'VR2W-125446', 'VR2W-125440', 'VR2W-125457', 'VR2W-100482', 'VR2W-131086', 'VR2W-125885', 'VR2W-131083', 'VR2W-131087', 'VR2W-131092', 'VR2W-131085', 'VR2W-131089', 'VR2W-131090', 'VR2W-131088', 'VR2W-125444', 'VR2W-125441', 'VR2W-125446', 'VR2W-125457', 'VR2W-100482', 'VR2W-131086', 'POD-2978', 'POD-2729', 'VR2Tx-481063', 'VR2W-131091', 'VR2W-131084', 'VR2W-125884', 'VR2W-125440', 'VR2W-125885', 'VR2W-125444', 'VR2W-125884', 'VR2W-125440', 'VR2W-131086', 'VR2W-125885', 'VR2W-100482', 'VR2W-125457', 'VR2W-131083', 'VR2W-131091', 'VR2W-131087', 'VR2W-131085', 'VR2W-131092', 'VR2W-131089', 'VR2W-131084', 'VR2W-131090', 'VR2W-131088', 'VR2W-125884', 'VR2W-125444', 'VR2W-125441', 'VR2W-125446', 'VR2W-125440', 'VR2W-125457', 'VR2W-100482', 'VR2W-100482', 'VR2W-131086', 'VR2W-131083', 'VR2W-131091', 'VR2W-131087', 'VR2W-131092', 'VR2W-131089', 'VR2W-131084', 'VR2W-131088', 'VR2W-125884', 'VR2W-125444', 'VR2W-125446', 'VR2W-125440', 'VR2W-125457', 'VR2W-131086', 'VR2W-125885', 'VR2W-131083', 'VR2W-131091', 'VR2W-131087', 'VR2W-131085', 'VR2W-131085', 'VR2W-131092', 'VR2W-131089', 'VR2W-131084', 'VR2W-131090', 'VR2W-131090', 'VR2W-131088', 'VR2W-125444', 'VR2W-125441', 'VR2W-125885', 'VR2W-125885', 'VR2W-125884', 'VR2W-125884', 'VR2W-125444', 'VR2W-125444', 'VR2W-125441', 'VR2W-125441', 'VR2W-125446', 'VR2W-125446', 'VR2W-125440', 'VR2W-127729', 'VR2W-125440', 'VR2W-125440', 'VR2W-125440', 'VR2W-125457', 'VR2W-125457', 'VR2W-115441', 'POD-2728', 'POD-2956', 'POD-2724', 'POD-2976', 'VR2W-131000', 'VR2W-123827', 'POD-2730', 'VR2AR-547652', 'VR2AR-547653', 'VR2AR-547655', 'VR2AR-547654', 'VR2AR-547656', 'POD-2976', 'POD-2578', 'VR2AR-547657', 'VR2AR-547658', 'VR2AR-547659', 'VR2AR-547660', 'VR2AR-547661', 'VR2AR-547662', 'VR2AR-547663', 'VR2AR-547664', 'VR2AR-547668', 'VR2AR-547671', 'VR2AR-547672', 'VR2AR-547669', 'VR2Tx-480722', 'VR2AR-547670', 'VR2AR-547673', 'VR2AR-547674', 'VR2AR-547675', 'VR2W-133321', 'VR2W-127715', 'VR2W-123817', 'VR2W-127718', 'VR2W-127718', 'VR2W-120874', 'VR2W-122329', 'VR2AR-545718', 'VR2C-450114', 'VR2W-127110', 'VR2Tx-480722', 'VR2AR-545720', 'VR2AR-546043', 'VR2AR-546044', 'VR2AR-546045', 'VR2AR-546047', 'VR2AR-546048', 'VR2AR-546052', 'VR2AR-546130', 'VR2AR-546620', 'VR2AR-546621', 'VR2AR-546622', 'VR2AR-546893', 'VR2AR-546894', 'VR2AR-546895', 'VR2AR-546897', 'VR2AR-546898', 'VR2AR-546899', 'VR2AR-546900', 'VR2AR-546891', 'VR2AR-545538', 'VR2W-110778', 'VR2W-133323', 'POD-3112', 'VR2W-127734', 'VR2W-127735', 'VR2W-127731', 'VR2W-127725', 'VR2W-127733', 'VR2W-127737')
  AND scientific_name IN ('Rutilus rutilus', 'Alosa fallax', 'Platichthys flesus', 'Built-in', 'Anguilla anguilla', 'Petromyzon marinus', 'Sentinel', 'Squalius cephalus', 'Cyprinus carpio', 'salmo salar', 'Sync tag', 'Gadus morhua', 'Silurus glanis', 'Lampetra fluviatilis', 'Homarus gammarus', 'Salmo salar')

So probably there is an issue on the requests for all possible values for one of the WHERE clauses...

stijnvanhoey commented 6 years ago

As such, a difference betweentag_full_id and tag_code_space which is used as transmitter column within the detections table... @jreubens or @bwydoogh any chance this recently has been changed?

PieterjanVerhelst commented 6 years ago

According to the query, network_project_code and animal_project_code are required instead of network_project and animal_project. However, the former returns an error and consequently does not work as well. Perhaps this is where it goes wrong?

bwydoogh commented 6 years ago

As such, a difference betweentag_full_id and tag_code_space which is used as transmitter column within the detections table... @jreubens or @bwydoogh any chance this recently has been changed?

ETN release on 2018-06-21 introduced a new field tag_full_id (f.e. A69-1008-001) in the table tags, and it is the concatenation of tag_code_space (f.e. A69-1008) and id_code (001). Before that change, the field tag_code_space (incorrectly) contained the full tag id (f.e. A69-1008-001).

stijnvanhoey commented 6 years ago

I see and I checked the unit-tests which indeed currently fail on the master:

> devtools::test()
Loading etn
Testing etn
✔ | OK F W S | Context
✔ |  3       | check_connection_to_etn
✔ | 17       | test_get_animals [0.5 s]
✔ | 34       | test_get_deployments [0.6 s]
✖ | 13 1     | test_get_detections [1.2 s]
────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────
test_get_detections.R:65: error: (unknown)
Not valid input value(s) for transmitter input argument.
Valid inputs are: A69-1601, A69-1105, A69-1008, R64K, A69-9002, H170-1802, A69-1303, A69-9006, A69-9004, A180-1702 and A69-1602.
1: get_detections(con, animal_project = animal_project, network_project = network_project, start_date = start_date, end_date = end_date, limit = limit, 
       transmitter = transmitter) at /data/home/stijnv/R/etn/tests/testthat/test_get_detections.R:65
2: check_null_or_value(transmitter, valid_transmitters, "transmitter") at /data/home/stijnv/R/etn/R/get_detections.R:111
3: assert_that(all(arg %in% options), msg = glue("Not valid input value(s) for {arg_name} input argument.\n                    Valid inputs are: {options_to_print*}.", 
       .transformer = collapse_transformer(sep = ", ", last = " and "))) at /data/home/stijnv/R/etn/R/zzz.R:64

Hence, I propose to make sure that the tests are rerun when changes are made to etn (in the Rstudio, this is devtools::test() when the project is open) or ask us to check the uni tests. If VLIZ would have a jenkins/... like environment to test builds of the R-package, we can do automatic tests as well, as we do for our other packages, e.g. waterinfo.

stijnvanhoey commented 6 years ago

@PieterjanVerhelst can you re-install the package and try again?

tip, maybe limit the records with more fields, as probably asking for all of them will not be feasible with the current setup. You can also just test by using limit argument:

my_detections <- get_detections(my_con, animal_project = "2015_phd_verhelst", limit = 100)
PieterjanVerhelst commented 6 years ago

@stijnvanhoey apparently Rstudio fails to install the etn package?

stijnvanhoey commented 6 years ago

This error?

object ‘evaluate’ is not exported by 'namespace:glue'
PieterjanVerhelst commented 6 years ago

Yes!

stijnvanhoey commented 6 years ago

ok, apparantly, due to breaking changes in glue package:

The evaluate() function has been removed. Changes elsewhere in glue made the implementation trivial so it was removed for clarities sake. Previous uses can be replaced by eval(parse(text = text), envir).
stijnvanhoey commented 6 years ago

@PieterjanVerhelst should be solved. Please open new issue when you would have other installation issues. Closing this issue, as PR #55 tackled the initial issue theme

PieterjanVerhelst commented 6 years ago

Check! Problem solved, thanks!