Laserfiche WebLink
Pro <br />Com mercia[/Industrial Inspection and Database <br />Management Consultant Services <br />6.1 Subtask No. 1: Facility Database Maintenance and Management <br />Our project team will manage the City's industrial and commercial web -based application and database in <br />accordance with the specific requirements outlined in Orange County's MS4 permit and will meet the <br />additional record protection practices outlined in the 5`h term draft permit. Our team provides a seamless <br />transition for this contract, based on our extensive experience. During the last contract period, Wood <br />designed the web -based application and database, migrated the data from the City's Microsoft Access <br />Database into a web -based application, and managed the database. Wood hosted the database and supplied <br />tablets that are used for the mobile component of the data -collection for no additional charge. Wood will <br />continue to supply the tablets for our field inspection staff and host the database for no additional charge <br />during the next contract period. <br />The City's web -based application and database was designed by Wood and streamlines the inspection <br />process. The application uses drop down menus to minimize writing in the field for efficiency and provides <br />consistency between inspectors. The web -based application also creates photo logs eliminating effort <br />downloading and managing photos and has automated reports including courtesy letters and quarterly <br />reports as required in Permit Section VI - Legal Authority/Enforcement. Simple queries built into the <br />application are also used to obtain the numbers for the PEA. The web -application is available to the City at <br />any time using a desktop computer or laptop using the City's username and password. <br />Wood will perform the annual updates to the inventory and reprioritize the industrial and commercial <br />businesses annually. New industrial businesses will be added when they are discovered and commercial <br />businesses will be added at least quarterly in accordance with the MS4 permit. Through our prior work with <br />the City's business license department and other City business license departments, our project team has <br />developed efficient procedures to complete the City's inventory updates as specified in the County's MS4 <br />Permit Sections IX and X. Wood is familiar with the City's Business Classification Code (BCC) and has <br />processes developed to select which businesses should be included in the inventory. In the event the City <br />switches from the City's BCC, our project team can quickly adapt our procedures to reprioritize the inventory <br />based on Standard Industrial Classification (SIC) or North American Industrial Classification System (NAICS) <br />codes. We have procedures for those codes as well. <br />With the extensive experience providing inventory update services to various Cities, we are knowledgeable <br />of the common pitfalls that may occur such as inadvertently adding hundreds of new businesses in the <br />inventory that do not require inspection. Our prioritization procedures include the removal of businesses <br />with duplicate business licenses, businesses with multiple business licenses, home-based businesses, <br />businesses with the incorrect BCC codes, and businesses that should not be included based on our past <br />inspections. Our team also has extensive experience with using other online sources required for the <br />inventory prioritization process including SWRCB's Storm Water Multiple Application and Report Tracking <br />System (SMARTS) and Toxic Release Inventory (TRI). The data tables downloaded from these online sources <br />are compared using unique identification numbers and critical data are imported, as necessary. <br />This task also includes periodic meetings and phone calls to provide the City with updates on inspections, <br />discuss enforcement issues, and to provide program recommendations. Our project team will also provide <br />one annual kickoff meeting to be held at the City office for training documentation purposes. Project <br />management hours for the review and submittal of monthly summary status reports with monthly invoices <br />is also included in this task. <br />Proposal No: 18PROPGOVT.01301 March 2018 Page 14 of 18' <br />