Closed dthonon closed 2 years ago
In GitLab by @fred.lpo07 on Apr 13, 2022, 11:41
Bonjour @mgageo,
Pouvez-vous préciser de quel champ json il s'agit?
Merci.
In GitLab by @mgageo on Apr 13, 2022, 11:57
la clé source dans observers[0]
{"date": {"@notime": "1" "@offset": "7200" "@timestamp": "1648764000"} "place": {"@id": "209703" "lat": "48.427185873501" "lon": "-2.6675509919455" "name": "La Ville Davy (Quessoy)" "place_type": "place" "id_universal": "46_209703" "loc_precision": "0"} "species": {"@id": "351" "rarity": "verycommon" "category": "H" "taxonomy": "1"} "observers": [{"@id": "13832" "@uid": "257078" "count": "2" "traid": "13832" "source": "WEB" "timing": {"@notime": "1" "@offset": "7200" "@timestamp": "1648764000"} "comment": "Tourne autour du Lycée les mêmes qu'hier ? Vont nicher içi ?" "details": [{"age": "U" "sex": "U" "count": "2" "condition": "FLY"}] "version": "0" "altitude": "88" "coord_lat": "48.427185873501" "coord_lon": "-2.6675509919455" "precision": "precise" "id_sighting": "5290235" "insert_date": "1648809719" "id_universal": "46_5290235" "coord_x_local": 281083.9295373628 "coord_y_local": 6829140.706561275 "flight_number": "1" "estimation_code": "EXACT_VALUE"}]}
mentioned in commit 59482023cfe637edcb4a82c81381b7321fc15d90
mentioned in commit 84f6613dea53206c844c3ea6bbead892d941a81b
In GitLab by @mgageo on Apr 13, 2022, 10:46
La clé source est présente dans le json mais absente de la table src_vn.observations
Pour les données de formulaire, cela permet de déterminer la validité du champ timing.