Community infrastructure includes the electric power grid, telephone/communication networks, water and sewer systems, and neighborhood infrastructure such as sidewalks, roads, and parks. In infrastructure mapping, the services offered involve establishing accurate coordinate locations of point features of a network such as electric transfer stations and towers and the lines that connect them in a power grid and creating databases and shapefiles from which reference maps and lookup tables can be produced. Such databases and reference maps are typically produced for:
- Electric power grids showing the location of transfer stations, power towers and poles, transmission lines and property boxes.
- Telephone and communication networks showing the location of cell phone and communication towers; telephone poles; and cable, telephone, and internet lines.
- Water and Sewer Systems showing the location of pumping stations, manholes, street drains, water and sewer lines, transfer points, and treatment plants.
- Pedestrian networks showing the location of sidewalks, bike trails, traffic lights, and crosswalks.
- Natural Gas distribution networks showing the location of pumping stations, shutoff valves, pipelines, and customer points.
After accurate geospatial databases such as these are created ,they can be combined with attribute data on the capacity, size, age, condition, service frequency, etc. of the infrastructure system to produce combined reference and color coded maps that can be used to analyze the system and schedule maintenance, plan and prioritize projects, and seek easements and clearances. Projects where both capacity and condition need to be understood and mapped by segment of the infrastructure network are commonly produced.
I have worked on a number of Infrastructure projects involving the creation of relational databases, combining the accurate geospatial positioning of the infrastructure with the collection and input of descriptive attributes on the system and the preparation of associated maps. These projects include:
- Created a map of storm sewers, structures, current sidewalks, and a future bridge for a Safe Routes to School Grant. (Pictured Below)
- The preparation of an accurate georeferenced database of the sidewalk network of Marion City, Ohio. Assessed all sidewalk segments and produced a color-coded reference map showing each segment’s condition for work planning and funding allocation. (Pictured Below – Maps 2 & 3)
- For a Safe Route to School Grant in Marion, OH, I mapped easements in a specific neighborhood and the location of current signs, signals, and sidewalks for the designated routes.
- Collected the GPS points, georeferenced, and prepared maps to locate signs for a bike trail in Marion, Ohio.
- Assisted in a storm water runoff modeling project by collecting data on and digitizing impervious surfaces and their locations including buildings, sidewalks, curbs, pavement right-of-way for streets and alleys, and parking lots in Marion City.