Spring 2008 |
||||||||
|
One of the schema's unique features is the assignment of curb ramp data as attributes of the sidewalk line segments. Logically speaking, curb ramps are best represented by points. However, by taking advantage of the from and to street attribution assigned to every sidewalk line segment by the Hansen database, the field teams were able to enter data for each curb ramp by identifying the end of the sidewalk segment that each ramp was on (by looking at the nearest cross street), then assigning each ramp's attributes to the RampFrom, RampTo, or MidRamp attribute fields. Additional curb ramp attribute fields, not necessary given the scope of the project, were optional. This approach to curb ramp attribution sped up data collection considerably because field teams did not need to repeatedly switch between editing the sidewalk segment layer and a separate curb ramp point layer. With this approach, data is easier for the city to maintain because it creates only one layer to maintain rather than two layersanother advantage. Although the data collected for the curb ramps is stored with the lines, the city can still map the ramps as points by running the Feature To Point tool in ArcInfo. Setting Up the Mobile GIS SolutionPodleski advised the team that the field crews could most efficiently and accurately collect data using several key pieces of hardware and software. The final setup was purchased from Wind Environmental Services. This firm was chosen because of its software development work integrating digital cameras with ArcPad and its strong background in mobile GIS. Garet Couch, business manager at Wind Environmental Services, recommended a solution that included the Archer Ultra-Rugged Field PC with an attached CompactFlash GPS receiver, GPS enabled PDA units manufactured by Juniper Systems; ArcPad; rugged Ricoh 500SE digital cameras; and Wind Image software by Wind Environmental. HWA purchased one setup (both hardware and software) and had Perteet prepare it for a pilot test. The setup performed better than expected and had few drawbacks. Curb ramp and sidewalk data could be collected in less than five minutes per block-face. Eventually, once field teams were seasoned, that time was reduced to four minutes or less without sacrificing data collection accuracy. Considerable effort went into the design of the back-end geodatabase that would handle all the inventory data. Perteet implemented the database back end in personal ArcSDE because it was an inexpensive way to implement versioning and database backup procedures that would require little database management overhead. Ultimately the database had to perform several key functions:
The GIS back end also needed to handle multiple geographically and temporally overlapping ArcPad data checkouts and provide an efficient method to run quality assessment analysis. While the ArcPad 7.0 checkout and check-in process leaves out some desirable functionality, it ultimately served its purpose by providing a way to check data out of the database and subsequently check it back in after the field crews finished updating it. Care was taken to ensure that, in most cases, two teams did not accidentally overlap collection efforts. This not only made the collection effort more efficient but also less prone to certain types of data loss that can occur when one team partially updates a block-face that another team already surveyed. Managing Field TeamsPearson from HWA assembled and managed the field crews, hired interns and organized 10 one- and two-person teams, then trained them to use the Archer data logger, Ricoh Camera, ArcPad, and the Wind Image setup. He also met with these teams daily to assign them to new data collection areas and transfer data to and from their handheld units and his field laptop. He also briefed them on the special challenges they might face in each new neighborhood and how to handle them in a standardized way. HWA also led weekly retraining meetings with the crews to further ensure a standardized data collection approach across all teams. City of Seattle's project manager Benjamin Hansen attended several of these sessions. Pearson also maintained regular contact with his teams via cell phone and often performed on-the-fly tech support for the HWA teams. Ongoing technical support was supplied by Couch of Wind Environmental, who helped keep the crews up and running. Many team meetings were held at Seattle's famous Wi-Fi coffeehouses. These were great places for performing data transfers while in the field. Pearson also maintained frequent contact with the Perteet GIS office to ensure that enough data would be available to keep all of the teams occupied and relay desired changes to the ArcPad setup, database design, work area definition, and other parameters of the GIS solution. Data Transfer StrategiesAdditionally, Perteet thoroughly planned the data transfer and management process. ArcPad data packages needed to flow from the GIS office at Perteet to the field crews and back again. This transfer was handled through a secure Web site where new data packages were posted and retrieved as needed. HWA's field crew manager would typically access the site while visiting a WiFi-equipped establishment. While connected, he could download new data packages, upload completed data packages, and transfer data packages to and from each of the handheld units as they came in from the field via a USB connection. The data packages followed a strict naming convention that explicitly stated the work area covered and purpose (i.e., collection or for quality assessment re-collection). All data packages were archived on both ends of the network to provide additional data security using managed redundancy. Ensuring Data QualityHWA and Perteet jointly implemented a quality assessment, reporting, and control program that covered more than 14 percent of the field-collected data. It is essential for a project of this size to include such a program. Without it, there are few meaningful ways to assess how well the field teams are performing or where the team manager needs to focus retraining efforts and stress methods for ensuring the teams collect data uniformly. For instance, the assessment program successfully identified that some teams were collecting data for partially completed block-faces. Since the sidewalk segments defined by the Hansen database cover the entire block-face, the city preferred that the teams mark all partially improved block faces as unimproved. Fortunately, the quality assessment program identified this omission and retraining efforts corrected the problem. The quality assessment program worked by sending a team into the fieldtypically with a blank set of block-face datato re-collect information for a minimum of 10 percent of the block-faces in each neighborhood. This data was then sent back to the Perteet GIS office for processing in ArcInfo using several geoprocessing models run from ArcToolbox. The models compared the re-collected data, record by record, to previously collected data and output tables with a count of each type of difference for each field in the database. Perteet then compiled the differences from each neighborhood into a spreadsheet where additional statistics could be calculated. These statistics included the total number and percentage of conflicting values in the quality assessment areas, by error category, and as a whole. ConclusionHWA and Perteet completed the data collection effort ahead of schedule, within budget, and to a high level of accuracy. Among the many uses for this valuable inventory data, the city is prioritizing maintenance and new construction as well as supporting asset management efforts. The sidewalk and curb ramp inventory will serve as valuable input for the City of Seattle's upcoming pedestrian master plan. A second phase of data collection is planned and will focus on the condition of existing sidewalks. This phase will help the city locate and prioritize the sidewalk repairs on the basis of condition. The Seattle Sidewalk and Ramp Inventory Project is an excellent example of the effectiveness of mobile GIS data collection techniques for accurate inventory of municipal facilities. Mobile GIS data collection is also useful for utility, engineering, and planning inventories of various types such as National Pollutant Discharge Elimination System (NPDES) stormwater inventories. In today's world, knowing which facilities are located where is often critical to decision making across organizations and at many levels of society. Mobile GIS offers one of the best ways to efficiently gather this type of information into useful, effective spatial databases. For additional information, visit the Seattle Department of Transportation (SDOT) Web site at www.seattle.gov/transportation/ or contact Barbara Gray John Green Benjamin Hansen About the AuthorsPete Pearson is a geologist and project manager for HWA GeoSciences Inc. in Lynnwood, Washington. In addition to the 2007 Seattle sidewalk inventory, he has worked on projects ranging from large-scale environmental cleanups to geotechnical exploration programs all over Washington state. Developing field data collection techniques has been a primary focus in his career with a growing interest in GIS and database management applications. Pete Pearson, Project Manager Jeremiah Podleski began using GIS to enhance field data collection projects as early as 1999 while studying for his degrees in urban planning and environmental studies. He has designed and implemented data collection and mapping projects for more than 15 local government and university clients. His projects have involved nonmotorized facilities, transit systems, public water utilities, irrigation systems, tree populations, pavement assessments, and sign inventories. His goal is to deliver effective and creative GIS solutions that solve problems as well as store, manage, and communicate information via a geographic framework. Jeremiah Podleski, GIS Project Manager Garet Couch is the business manager for Wind Environmental Services, LLC, in Bonne Terre, Missouri. He originally became involved in GIS and mapping in the utility industry. Currently Couch oversees all activities at Wind Environmental Services, a full-service GIS company. In addition, he is also an Esri Authorized Instructor and is very active in the GIS community. Couch has been involved in many GIS projects in a wide range of industries and always enjoys creating effective solutions. Garet Couch, Business Manager |