With over 50 street sweeping routes in the San Francisco area, it is difficult for vehicle owners to keep track of the days and times that neighborhood streets prohibit parking to allow for cleaning. The end result is often a lot of disgruntled San Francisco residents with a fistful of parking citations. Entrepreneur Stan Flouride noticed the increasing frustration from these City residents who were unwittingly parking during scheduled street sweeping and sought Farallon to create a cartographic solution to a common urban inconvenience.
To help avoid unnecessary parking citations, Farallon developed neighborhood-based maps for public use that will display street sweeping schedules by day and time. Starting with San Francisco’s Haight-Ashbury neighborhood, Farallon processed over 1400 shapefiles that contain the integral data from which the maps will be designed. Shapefiles are a specific file type created by ESRI that holds spatial data and its associated attributes in a single file. Each file contains a geographic location (specific streets) and attributes (route days and times).
The primary challenge was to create a process that would be both fast and flexible to edit any maps’ symbols and design. Because of the large volume of shapefiles, manual changes to the maps’ designs would be a very time and labor intensive process. As a solution, using ESRI ArcObjects, Farallon populated a geodatabase with the spatial data from the 1400 shapefiles as well as each of the shapefiles’s associated day and time information. Updates to the day and time information are now applied automatically to the maps. This eliminates labor intensive manual processing; future updates or map symbolization will occur much more rapidly and accurately. The finished products will be a dozen comprehensive maps of street sweeping routes by day and time for specific San Francisco neighborhoods, much to the relief of the City’s residents.