search

inbo / reporting-rshiny-grofwildjacht

Rshiny app for grofwildjacht
https://grofwildjacht.inbo.be/
MIT License
1 stars 1 forks source link

[BUG] schademelding on UAT - bucket not in raw data #479

Closed SanderDevisscher closed 3 weeks ago

SanderDevisscher commented 2 months ago

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:

  1. Go to 'faunabeheer-dev.inbo.be'
  2. Click on 'wildschade'
  3. Scroll down to 'Schadegevallen voor wild zwijn per schadetype' & 'Gerapporteerd aantal schadegevallen van wild zwijn'
  4. filter year to '2021'
  5. See error

Expected behavior No wild zwijn in Gent

Screenshots image

Additional context WildSchade_georef.zip

Git SHA (after 0.3.1) d6d14c6037ed6b3462988acbc0e282f4b8f0ae0f

mvarewyck commented 2 months ago

@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