Map odkc_data$tracks and related tables to WAStD TurtleNestEncounters and related Observations

[florianm]

Process

• Find target in odkc_as_tsc
• Create a mapping fxn
• Add test for mapping fxn
• Add to odkc_as_tsc
• Add to split_create_update_skip
• Add to upload_odkc_to_tsc

Source odkc$tracks

• Input: odkc_data$tracks (requires #12)
• Output: TSC API TurtleNestEncounters
• Part of #10

Challenges

• resolve WAStD user PK vs reporter via user_mapping
• resolve timezone warning
• add any metadata to comments

Target NestTagObs

Source odkc_data$tracks$nest_tag... https://tsc.dbca.wa.gov.au/api/1/nest-tag-observations/

source, source_id,
"status": "resighted",
"flipper_tag_id": "S1234",
"date_nest_laid": "2017-02-01",
"tag_label": "M1",
"comments": null

Target TurtleNestObservation

Source odkc_data$tracks (egg_count...) https://tsc.dbca.wa.gov.au/api/1/turtle-nest-excavations/

source, source_id,
"nest_position": "in-dune-vegetation",
 "eggs_laid": false,
 "egg_count": null,
 "hatching_success": 100.0,
 "emergence_success": 100.0,
 "no_egg_shells": 10, ## Source fields
 "no_live_hatchlings_neck_of_nest": null,
 "no_live_hatchlings": 0,
 "no_dead_hatchlings": 0,
 "no_undeveloped_eggs": 0,
 "no_unhatched_eggs": 0,
 "no_unhatched_term": 0,
 "no_depredated_eggs": 0,
 "nest_depth_top": 0,
 "nest_depth_bottom": 500,
 "sand_temp": null,
 "air_temp": null,
 "water_temp": null,
 "egg_temp": null,
 "comments": null

Target TurtleNestHatchlingEmergences

Source odkc_data$tracks (fan_angle...) https://tsc.dbca.wa.gov.au/api/1/turtle-nest-hatchling-emergences/

        # "observation_name": "turtlehatchlingemergenceobservation",
        # "latitude": -20.3068016667,
        # "longitude": 118.61307,
        # "bearing_to_water_degrees": null,
        # "bearing_leftmost_track_degrees": null,
        # "bearing_rightmost_track_degrees": null,
        # "no_tracks_main_group": 1,
        # "no_tracks_main_group_min": null,
        # "no_tracks_main_group_max": null,
        # "outlier_tracks_present": "absent",
        # "path_to_sea_comments": "clear None",
        # "hatchling_emergence_time_known": "no",
        # "light_sources_present": "na",
        # "hatchling_emergence_time": null,
        # "hatchling_emergence_time_accuracy": null,
        # "cloud_cover_at_emergence": null

Source odkc_data$tracks_dist

"photo_disturbance"
"disturbance_cause"                                             
"disturbance_cause_confidence"
"disturbance_severity"                                          
"comments"

Target TurtleNestDisturbanceObservations

https://tsc.dbca.wa.gov.au/api/1/turtle-nest-disturbance-observations/

source, source_id,
"disturbance_cause": "dingo",
"disturbance_cause_confidence": "expert-opinion",
"disturbance_severity": "na",
"comments": null

Source odkc_data$tracks_hatch

"straight_carapace_length_mm": 12,
"straight_carapace_width_mm": 13,
"body_weight_g": 14

Target turtle-hatchling-morphometrics

https://tsc.dbca.wa.gov.au/api/1/turtle-hatchling-morphometrics/

"straight_carapace_length_mm": 12,
"straight_carapace_width_mm": 13,
"body_weight_g": 14

Source odkc_data$tracks_fan_outlier

https://tsc.dbca.wa.gov.au/api/1/turtle-nest-hatchling-emergence-outliers/

Target turtle-nest-hatchling-emergence-outliers

source, source_id,
"bearing_outlier_track_degrees": 12.0,
"outlier_group_size": 1,
"outlier_track_comment": null

Source odkc_data$tracks_light

Target turtle-nest-hatchling-emergence-light-sources

https://tsc.dbca.wa.gov.au/api/1/turtle-nest-hatchling-emergence-light-sources/

"bearing_light_degrees": 200.0,
"light_source_type": "artificial",
"light_source_description": "Street lights"

Estimate: 5h remaining

[florianm]

Done, remaining media tracked at #10