Collier County MS4 GIS Stormwater Geodatabase
Johnson Engineering was hired by Collier County in November of 2009 to design and implement a stormwater geodatabase to assist the county staff in meeting the requirements of the Environmental Protection Agency (EPA) and its National Pollution Discharge Elimination System (NPDES). The geodatabase is designed to hold, manage and display information related to stormwater facilities constructed with the county’s roadway infrastructure. It has fourteen polygon, line and point feature classes, each with its own group of attribute fields and associated look up tables, to ensure data uniformity and integrity. Data duplication is reduced by use of relationship classes for certain project data common to multiple features. Data was input from a variety of sources including hardcopy plan sets, PDF plan sets and limited digital information. This was overlaid on georeferenced imagery and supplemented with conventional survey GPS data collection, resulting in over 4500 inlets mapped, 1470 junction boxes, 260 control structures, and over 1 million linear feet of associated piping along with numerous related structures. The deliverables included the geodatabase itself, as well as a web based mobile mapping component enabling county staff to view facilities on mobile devices such as iPhones, iPads and Android devices as well as accessible though standard internet browsers.
Johnson Engineering was hired by Atkins, NA, as a sub-consultant for an intersection evaluation project to perform all GIS related tasks, including geodatabase design, testing and implementation, as well as creation of mobile device, tablet based GIS data collection forms, data entry, and report formatting. The overall objective is to have an intersection inventory for approximately 200 locations in Lee County that contains information related to ADA compliance to be used by County staff to evaluate current problem areas and future improvements. The geodatabase is structured to house a variety of roadway intersection inspection information related to compliance with the Americans with Disabilities Act (ADA). The geodatabase is populated via mobile field tablets with GPS and photo capabilities with individual inspection reports transmitted via email and cellular connection for rapid incorporation into the geodatabase. Intersection photos are tagged and linked to the intersections. A web based mapping platform is utilized to allow Lee County staff and consultant team staff to monitor ongoing progress. Inspection reports have been linked to the online mapping as well as a data layer that allows the user to view multiple photos taken at each intersection. The deliverables will include the geodatabase itself, as well as a web based mobile mapping component enabling county staff to view facilities on mobile devices such as iPhones, iPads and Android devices as well as accessible though standard internet browsers. Online maps exist for field data collection crews and for general project management and project progress.
Johnson Engineering was hired by Charlotte County to perform a Stormwater Management Plan Update for a large portion of Charlotte County. This included field data collection and photographs on drainage structures, topography, research on past water management studies, hydraulic modeling of the various streams and flowways, as well as preparation and delivery of a custom GIS tool known as Inter-X. The Inter-X tool combined the GIS graphic capabilities of ArcView 3.1 with the database and re-porting functionality of Microsoft Access. The creation of the custom GIS tool was necessary in order to provide Charlotte County staff with a versatile tool to manage their existing drainage structure dataset and to be able to modify and update that with new information to be developed, and to be able to produce graphics and inventory datasheets for reports and maintenance staff uses. The project was designed and implemented by Johnson Engineering GIS staff and over seen by a Professional Engineer and Professional Land Surveyor licensed to practice in the state of Florida.
Johnson Engineering was hired by Peace River Manasota Regional Water Supply Authority to study siltation processes underway near their water treatment plant intake from the Peace River in south-west DeSoto County, Florida. Historic siltation in the Peace River was depicted in a series of aerial photographs dating back to 1944. These photos were georeferenced to the local coordinate system for use in CAD and GIS. Topographic data was acquired by utilizing and processing existing LIDAR datasets from Southwest Florida Water Management District, then conversion to surfaces and raster datasets, all utilized in depicting above water existing topographic conditions. Terrain in the river bottom was mapped using hydrographic sonar sensors tied to GPS attached to a boat, producing a 3D terrain of the river bottom from bank to bank. This hydrographic data was combined with the LIDAR based data to produce conventional cross sections depicting the river sections and where future dredging activities would be most effective. The project was designed and implemented by Johnson Engineering GIS staff and over seen by a Professional Surveyor and Mapper licensed to practice in the state of Florida with GIS experience dating back to 1997.
Johnson Engineering was hired by The City of Bonita Springs to review the existing data inventory and to evaluate the potential GIS work that was located in a variety of City departments, and make recommendations to City staff related to possible avenues to move forward with to begin to integrate GIS into City operations. The scope of work included interviews with City staff, assessment of city digital and hardcopy data, imagery assessments, recommendations and estimated costs. Johnson Engineering proposed a unique GIS solution that combined the use of existing resources for economic reasons while facilitating the development of an information system that was both powerful and easy to use. It was a phased, segmented solution that is flexible in adjusting to the changing demands of future planning. This solution did not rely on a heavy GIS technical staff, and limited the number of required software license agreements to a minimum. The proposed solution was fully capable of being converted to a more robust, full fledged GIS system, as the need and budget for that developed for that in the future. Contract outsourcing was utilized for GIS needs that are more complex in the immediate future on an as needed basis. The intent was to provide a high level of usefulness, economically, while allowing for future growth to a more sophisticated system as the need develops The deliverables included a bound report titled GIS Needs Assessment Report – City of Bonita Springs, Florida that detailed the results of staff interviews, listings of City data on hand, potential departmental needs relating to NPDES, FEMA and SFWMD requirements, and a variety of maps and exhibits. Also included, with estimated costs, were three options for City staff to consider for integration of GIS into routine workflow activities.
Johnson Engineering was hired by The City of Bonita Springs to create a GIS overlay representing stormwater outfalls within the city limits that met the threshold requirements of the National Pollution Discharge Elimination System (NPDES) regulations being mandated by the US Environmental Agency (EPA). The scope of work included identifying from city information, aerials, field investigations and local knowledge of hydrology in the area, where stormwater outfalls meeting the NPDES minimum requirements were located. This was assembled into a standard ESRI shapefile containing 239 potential NPDES outfalls, each with a number of associated data attributes including GPS positions. The data was symbolized based on category types and a number of map exhibits produced for use by City staff. The deliverables included an ESRI shapefile containing the NPDES outfall structures to be used by City GIS staff for meeting ongoing maintenance, inspection and reporting requirements of the NPDES mandates. This initial dataset has been modified and updated by City GIS staff since delivery and is still in use at this time.
Johnson Engineering was hired by Collier County to recover, create high accuracy GPS points, and create GIS data layers for a group of 84 section corners located in rural Collier County. Certified Corner Records (CCR) were submitted to the Bureau of Survey and Mapping in Tallahassee, Florida. The scope of work included field locating and recovering witness monumentation for verification prior to collecting GPS positioning information. Following the field work, standard ESRI shapefiles were created containing the GPS positions as well as a variety of data attribute information for each corner. In addition to the section corner work, the scope included creation and updating of the county stormwater atlas into standard ESRI datasets, again with a variety of data attributes associated with the stormwater features.