search

coregis / cbf-programs-map-2023

Rebranding and other updates to the Raise Your Hand Texas Programs Map
GNU General Public License v3.0
0 stars 0 forks source link

Stats box undercounts University Partners points #34

Closed eldang closed 8 months ago

eldang commented 8 months ago

If I filter the map to ESC Region 20 and select the year 2023, I see 3 points for the University Partners layer, but the stats box only counts 1. Likewise if I filter to San Antonio ISD, I see 2 points but only 1 in the stats box. Same goes for Houston ISD and ESC Region 4. I'm not yet certain if the problem is limited to that one layer.

eldang commented 8 months ago

@coregis I haven't mentioned this to CBF yet, and I plan to investigate it properly tomorrow.

eldang commented 8 months ago

Aha! The issue was a capitalisation inconsistency. The code in question uses the unique_id field from the spreadsheet to make sure it doesn't double-count points, but the partner universities spreadsheet had unique_ID so every feature had a null value for unique_id. I updated the heading in the spreadsheet and this bug is now fixed.