[BUG] schademelding on UAT - bucket not in raw data
Closed this issue · 1 comments
SanderDevisscher commented
Describe the bug
When l look at 'Schadegevallen voor wild zwijn per schadetype (2021)' & 'Gerapporteerd aantal schadegevallen van wild zwijn in 2021' I see a schademelding van wild zwijn in Gent while I don't find it in the raw data (prior to processing by createRawData()
)
To Reproduce
Steps to reproduce the behavior:
- Go to 'faunabeheer-dev.inbo.be'
- Click on 'wildschade'
- Scroll down to 'Schadegevallen voor wild zwijn per schadetype' & 'Gerapporteerd aantal schadegevallen van wild zwijn'
- filter year to '2021'
- See error
Expected behavior
No wild zwijn in Gent
Additional context
WildSchade_georef.zip
Git SHA (after 0.3.1)
d6d14c6037ed6b3462988acbc0e282f4b8f0ae0f
mvarewyck commented
@SanderDevisscher I found it in the zip file you shared.
It is the record on line 26016 with UUID = ea1f6adb-113d-42e3-a78f-f05b74abe4e7
:
> as.data.frame(schadeData[schadeData$dataSource == "E_Loket" & schadeData$afschotjaar == 2021 & schadeData$gemeente_afschot_locatie == "Gent" & schadeData$wildsoort == "Wild zwijn",])
ID caseID dataSource afschotjaar
1 ea1f6adb-113d-42e3-a78f-f05b74abe4e7 NA E_Loket 2021
schadeBasisCode schadeCode SoortNaam wildsoort afschot_datum provincie
1 ANDERE ANDERE <NA> Wild zwijn 2021-11-30 Oost-Vlaanderen
FaunabeheerZone fbdz NISCODE gemeente_afschot_locatie UTM5 KboNummer
1 2 2 44021 Gent ES45B NA
WBE_Naam_Toek PartijNummer
1 <NA> NA
perceelPolygon
1 POLYGON ((103531.35364313 194147.1671768, 103505.57124311 194191.51277683, 103477.9841711 194239.33895287, 103466.25322708 194232.89338486, 103449.49469908 194222.96724086, 103447.04529107 194221.67815285, 103425.90378706 194210.84948085, 103413.91505105 194203.50151284, 103391.48445904 194191.77056883, 103329.99351499 194157.73792881, 103388.26167504 194059.37837674, 103391.35556304 194060.40967274, 103397.54327504 194061.95655274, 103410.17668305 194067.37082475, 103419.58711506 194071.88269675, 103428.09540306 194076.91028075, 103437.37693907 194083.74266476, 103444.20932307 194089.41472876, 103463.03050709 194108.23584877, 103471.53866709 194115.06810478, 103476.82397909 194118.41991278, 103483.0118191 194122.02938478, 103490.74641111 194125.89677679, 103502.60631511 194130.92436079, 103513.30589912 194134.66272879, 103522.58762713 194139.8192088, 103531.35364313 194147.1671768))
x y schadeBedrag typeMelding postcode season
1 103430.553667404 194149.501375395 150 andere 9000 herfst
fbz_gemeente
1 2_Gent