GIS found 2 new issues as a part of their 2nd QAQC (original issues from 1st QAQC review were already addressed):
1. nysdec_lands
In both 24v1 draft builds, the qaqc report was showing zero nysdec_lands facilities when compared to 88 facilities in 23v2 version. After inspecting the source data, it seems that the csv obtained from the source website had all records with null geometries resulting in zero nysdec_lands records in facdb table:
Solution: instead of downloading a csv from the website, update nysdec_lands recipe to pull data from arcgis server. New data now shows geometries:
The facdb table didn't have a single dot_pedplazas facility. In previous builds, we received a dot_pedplazas file from the DOT. I updated the dot_pedpazas recipe to pull data from Socrata but didn't update the source projection, incorrectly mapping dot_pedplazas facilities in a different state.
Solution: I updated the projection and now the count has been restored:
Related to #461.
GIS found 2 new issues as a part of their 2nd QAQC (original issues from 1st QAQC review were already addressed):
1.
nysdec_landsIn both 24v1 draft builds, the qaqc report was showing zero
nysdec_landsfacilities when compared to 88 facilities in 23v2 version. After inspecting the source data, it seems that the csv obtained from the source website had all records with null geometries resulting in zeronysdec_landsrecords in facdb table:Solution: instead of downloading a csv from the website, update
nysdec_landsrecipe to pull data from arcgis server. New data now shows geometries:Successful pull of updated recipe here.
2.
dot_pedplazasThe facdb table didn't have a single
dot_pedplazasfacility. In previous builds, we received adot_pedplazasfile from the DOT. I updated thedot_pedpazasrecipe to pull data from Socrata but didn't update the source projection, incorrectly mappingdot_pedplazasfacilities in a different state.Solution: I updated the projection and now the count has been restored:
Successful build here.
Note, I plan to remove last commit clipping recipe versions prior to merging to main.