inbo / cr-birding

R code to map data from INBO's colour-ring database to cr-birding.org
https://inbo.github.io/cr-birding/
MIT License
0 stars 0 forks source link

Missing longitude direction (E or W) #121

Closed damianooldoni closed 4 years ago

damianooldoni commented 4 years ago

Two observations have no value in PlaatsLengteRichtingCode even if field PlaatsLengteGraden is not null.

Nummer KleurringNummer Datum PlaatsLengtegraadGraden PlaatsLengtegraadMinuten PlaatsLengtegraadSeconden PlaatsLengtegraadRichtingCode PlaatsGemeente PlaatsToponym
93434 EAAN 2013-02-19 1 47 11 L'ile d' Olonne Réserve de Chanteloup
81413 EAHH 2012-09-21 7 4 45 Termunten Breebaartpolder

Based on google maps

E or W should be added. I can do it while processing the data, but it would be nicer if solved at db level. Can you check it? Thanks in advance.

EricStienen commented 4 years ago

Could you please give the code of the colour and the data of these observations Damiano?

damianooldoni commented 4 years ago

Sure. Table above updated with KlerurringNummer and Datum.

EricStienen commented 4 years ago

In fact Geert's species but I fixed it for him. Should be OK now.

damianooldoni commented 4 years ago

Thanks. Solved.