Once data was identified, its metadata was reviewed and logged for later reference and credits on the report documents. Base map and contaminiated site data was acquired in numerous formats ranging from ESRI shapefiles, geodatabases, and coverages, USGS DLG-3 and SDTS data, Census layers, MicroSoft Excel spreadsheets, MicroSoft Access databases and ASCII flat files. Hundereds of data sets were reviewed, validated and georeferenced to a control base to assure not only did the individual layers fit the base but also fit in relation to each and every other data layer being used. As anticipated there were anomalies found and as needed, those were fixed.
Upon completion of the base map layers and support planimetric data integration, school data sets were acquired and put through a rigorous quality control process and data normalization routine. It was critical that only public schools were being identified and that schools were not being overlooked or counted more than once. Either situation would skew the results of the project. Schools data was also provided in different forms. In one case, very accurate shapefiles with GPS coordinates for the building structures were provided. These were easily integrated into the base map layers. On two occasions, only school address data was acquired so GTRSystems went about the process of geocoding the school data and in certain instances acquired GeoTIFF files of imagery to assure we were seeing structures at correct locations. This was done on a 10% sample of schools and was not required by the project SOW.
The project was completed on schedule and within budget. Working closely with CHEJ, GTRSystems was able to quickly convert the data and adjust work schedules and processes around data availability, government personnel response and research activities. GTRSystems ultimately improved quality, responsiveness and reduced the overall costs associated with this project when compared to similar projects done in previous years.