FY24 Entellus GIS System #42430
Extracted text (via pymupdf)
27191 characters
42430 GIS Mapping
541-5-7586-418
67,000.00
$
42430-GIS Mapping
42430 GIS Mapping
511-5-7115-418
133,000.00
$
42430-GIS Mapping
62227 Collections System Replacement
541-5-7585-670
125,000.00
$
62227-COLLECTIONS SYSTEM REPLACEMENT
Total Budgeted for Project 42430
$200,000
$49,592 Proposed transfer to project from savings in CIP 62227
Entellus Quote for Project 42430
$249,592
FY24 GIS Mapping Project - El Mirage Utility System
Special Project #42430
Department Name
ACCOUNT ID
Description
FY23 Budget Sub-lines
FY23 Final Budget
FY24 Final Sub-lines
FY24 Final Budget
Water
511-5-7115-221 PIPES, FITTINGS & REPAIRS
$50,000
$50,000
Water
511-5-7115-222 CHEMICALS
$45,000
$60,000
Water
511-5-7115-225 ASPHALT/COAL MATERIAL
$6,000
$8,000
Water
511-5-7115-226 FIRE HYDRANTS/PARTS
$30,000
$30,000
Water
511-5-7115-230 OFFICE SUPPLIES
$1,500
$1,500
Water
511-5-7115-232 COMPUTER/PRINTER SUPPLIES
$500
$500
Water
511-5-7115-233 UNIFORMS
$3,500
$4,500
Water
511-5-7115-237 EQUIPMENT/FURNITURE PURCHASE
$1,500
$1,500
Water
511-5-7115-249 OPERATING MATERIAL & SUPPLIES
$1,000
$1,000
Water
511-5-7115-250 BUILDING MAINTENANCE/REPAIRS
$7,500
$7,500
Water
511-5-7115-251 COMPUTER/PRINTER MAINTENANCE
$500
$500
Water
511-5-7115-253 VEHICLE MAINTENANCE/REPAIRS
$40,000
$40,000
Water
511-5-7115-255 WELL SITE MAINTENANCE/REPAIRS
$181,000
$181,000
Water
511-5-7115-269 OTHER MAINTENANCE/REPAIRS
$2,500
$2,500
Water
511-5-7115-311 PROFESSIONAL SERVICES
$18,500
$25,000
Water
511-5-7115-313 CONTRACTED SERVICES
$112,500
$130,000
Water
511-5-7115-314 LIABILITY INSURANCE
$253,000
$278,500
Water
511-5-7115-325 TECH/SOFTWARE SUPPORT
$32,000
$37,000
Water
511-5-7115-326 LICENSE AND PERMITS
$12,000
$12,000
Water
511-5-7115-328 EQUIPMENT RENT/LEASES
$7,000
$7,000
Water
511-5-7115-333 SAMPLING/TESTING
$35,000
$40,000
Water
511-5-7115-350 TRAVEL AND PER DIEM
$1,000
$1,000
Water
511-5-7115-351 CONFERENCE,SEMINARS & TRAINING
$10,500
$15,500
Water
511-5-7115-360 PRINTING COST
$500
$500
Water
511-5-7115-362 MAILING COST
$500
$500
Water
511-5-7115-370 DUES-MEMBERSHIPS-FEES
$8,000
$8,000
Water
511-5-7115-370
AZ 811 Blue Stake
$1,692
$1,692
Water
511-5-7115-370
AZ Water Association
$65
$65
Water
511-5-7115-370
American Water Association
$242
$242
Water
511-5-7115-370
West Valley Water Association
$3,200
$3,200
Water
511-5-7115-370
AZ STORM
$750
$750
Water
511-5-7115-370
Water Use IT Wisely
$2,000
$2,000
Water
511-5-7115-370
Misc. Adjustment
$51
$51
Water
511-5-7115-381 WIRELESS COMMUNICATIONS
$9,500
$9,500
Water
511-5-7115-383 TRASH SERVICE
$500
$500
Water
511-5-7115-385 BUILDING WATER/SEWER SERVICES
$3,000
$3,000
Water
511-5-7115-385
Sewer
$600
$600
Water
511-5-7115-385
Water
$2,400
$2,400
Water
511-5-7115-386 LANDSCAPING/IRRIGATION
$12,000
$12,000
Water
511-5-7115-386
At wells
$12,000
$12,000
Water
511-5-7115-387 UTILITY ELECTRICITY
$409,000
$934,000
Water
511-5-7115-418 SPECIAL PROJECTS
$273,500
$283,000
Water
511-5-7115-418
Consultant for Lead and Copper Pipes
$0
$50,000
Water
511-5-7115-418
Dietz Crane Arsenic Media Replacment
$0
$100,000
Water
511-5-7115-418
GIS Mapping
$133,000
$133,000
Water
511-5-7115-418
Computer and Monitor Refresh
$5,500
$0
Water
511-5-7115-418
ADWR Water Conservation Education
$135,000
$0
Water
511-5-7115-482 ASSURED WATER SUPPLY
$1,740,000
$1,763,000
Water
511-5-7115-617 CAPITAL EQUIPMENT PURCHASE
$40,000
$0
Water
511-5-7115-617
Vacuum Excavator Trailer
$0
$0
Water
511-5-7115-617
Well Transducer Upgrade
$0
$0
Water
511-5-7115-617
Disinfection System Upgrade
$0
$0
Water
511-5-7115-617
62077 - Well Transducer Upgrade
$40,000
$0
Water
511-5-7115-650 VEHICLES
$48,500
$50,000
Water
511-5-7115-650
Vehicle Replacement Program - Water
$48,500
$50,000
Water
511-5-7115-656 BUILDING/DATA INFRAS. IMPROV.
$1,138,500
$2,228,500
Water
511-5-7115-656
62343 Public Works Facility Carryforward
$0
$55,000
Water
511-5-7115-656
Water Production Facility Rehabilitation
Program
$300,000
$140,000
Water
511-5-7115-656
Well Site AC Unit Replacement
$0
$0
Water
511-5-7115-656
62065 - Water Production Facility
Rehabilitation Program
$0
$400,000
Water
511-5-7115-656
Customer Service Facility
$704,000
$300,000
Water
511-5-7115-656
Public Works Facility
$134,500
$1,333,500
Water
511-5-7115-658 LAND IMPROVEMENTS
$67,000
$0
Water
511-5-7115-658
62212- Drainage Improv. Dysart & Peoria
$37,000
$0
Water
511-5-7115-658
Drainage Improvements at Dysart Road &
Peoria Avenue
$0
$0
Water
511-5-7115-658
Well Site Security Improvement Project
$30,000
$0
Water
511-5-7115-670 SEWER COLLECTION SYSTEM
$0
$0
Water
511-5-7115-673 PRE-CONSTRUCTION DESIGN
$260,000
$1,675,000
Water
511-5-7115-673
Booster Pump Replacement for 127th
Lane Well Site
$0
$100,000
Water
511-5-7115-673
Sunnyvale Well Site Discharge Pipe
Replacement and Flow Meter
$0
$65,000
Water
511-5-7115-673
Water Main Replacement
$0
$1,250,000
22
Department Name
ACCOUNT ID
Description
FY23 Budget Sub-lines
FY23 Final Budget
FY24 Final Sub-lines
FY24 Final Budget
Wastewater
541-5-7581-311 PROFESSIONAL SERVICES
$35,000
$35,000
Wastewater
541-5-7581-313 CONTRACTED SERVICES
$70,000
$70,000
Wastewater
541-5-7581-325 TECH/SOFTWARE SUPPORT
$13,000
$13,000
Wastewater
541-5-7581-328 EQUIPMENT RENT/LEASES
$2,000
$2,000
Wastewater
541-5-7581-334 SLUDGE DISPOSAL
$104,500
$120,000
Wastewater
541-5-7581-351 CONFERENCE,SEMINARS & TRAINING
$6,000
$6,000
Wastewater
541-5-7581-362 MAILING COST
$500
$500
Wastewater
541-5-7581-381 WIRELESS COMMUNICATIONS
$4,500
$4,500
Wastewater
541-5-7581-385 BUILDING WATER/SEWER SERVICES
$6,000
$6,000
Wastewater
541-5-7581-385
five accounts
$6,000
$6,000
Wastewater
541-5-7581-386 LANDSCAPING/IRRIGATION
$2,000
$2,000
Wastewater
541-5-7581-387 UTILITY ELECTRICITY
$280,500
$640,000
Wastewater
541-5-7581-418 SPECIAL PROJECTS
$9,000
$75,000
Wastewater
541-5-7581-418
Wastewater Capacity Study
$0
$75,000
Wastewater
541-5-7581-418
Computer and Monitor Refresh
$9,000
$0
Wastewater
541-5-7581-436 RATE STUDY
$28,000
$6,000
Wastewater
541-5-7581-617 CAPITAL EQUIPMENT PURCHASE
$21,000
$9,000
Wastewater
541-5-7581-617
62207- SCADA Software Server
Replacement
$21,000
$0
Wastewater
541-5-7581-617
Copier for WRF
$0
$9,000
Wastewater
541-5-7581-617
SCADA Software Server Replacement
$0
$0
Wastewater
541-5-7581-650 VEHICLES
$0
$50,000
Wastewater
541-5-7581-717 WIFA - PRINCIPAL
$25,500
$27,000
Wastewater
541-5-7581-750 WIFA - INTEREST
$9,000
$7,500
Wastewater
541-5-7581-773 TRUST/AGENCY FEES
$0
$0
Wastewater
541-5-7581-990 LOSS ON RETIRE/SALE OF ASSETS
$0
$0
Wastewater
541-5-7582-224 LAB SUPPLIES
$7,000
$7,000
Wastewater
541-5-7582-326 LICENSE AND PERMITS
$20,000
$20,000
Wastewater
541-5-7582-333 SAMPLING/TESTING
$25,000
$25,000
Wastewater
541-5-7582-351 CONFERENCE SEMINAR TRAINING
$0
$7,500
Wastewater
541-5-7582-370 DUES-MEMBERSHIPS-FEES
$2,000
$2,000
Wastewater
541-5-7582-370
Storm Membership
$750
$750
Wastewater
541-5-7582-370
AZ Water Membership
$455
$455
Wastewater
541-5-7582-370
Misc. Adjustment
$795
$795
Wastewater
541-5-7585-617 CAPITAL EQUIPMENT PURCHASE
$0
$0
Wastewater
541-5-7585-655 SEWER PLANT
$1,228,500
$200,000
Wastewater
541-5-7585-655
62079- WW Process Equipment
Improvements
$200,000
$200,000
Wastewater
541-5-7585-655
Wastewater Process Equipment
Improvements
$0
$0
Wastewater
541-5-7585-655
62107- Reclamation Facility Design
$1,028,500
$0
Wastewater
541-5-7585-656 BUILDING/DATA INFRAS. IMPROV.
$134,500
$1,453,500
Wastewater
541-5-7585-656
62343 Public Works Facility Carryforward
$0
$120,000
Wastewater
541-5-7585-656
Public Works Facility
$134,500
$1,333,500
Wastewater
541-5-7585-670 PRE-CONSTRUCTION DESIGN
$575,000
$145,000
Wastewater
541-5-7585-670
62227- Collections System Replacement
$125,000
$125,000
Wastewater
541-5-7585-670
Backup Pump for Brisas Lift Station
$0
$20,000
Wastewater
541-5-7585-670
Collections System Replacement Program
$0
$0
Wastewater
541-5-7585-670
Influent Line Replacement at WRF
$450,000
$0
Wastewater
541-5-7585-950 TRANSFER OUT
$2,100,000
$2,100,000
Wastewater
541-5-7585-960 DEPRECIATION
$1,250,000
$1,300,000
Wastewater
541-5-7586-210 SMALL TOOLS/EQUIP/PARTS
$1,000
$1,000
Wastewater
541-5-7586-211 FUEL AND LUBRICANTS
$6,000
$6,000
Wastewater
541-5-7586-213 SAFETY EQUIPMENT/SUPPLIES
$3,000
$3,000
Wastewater
541-5-7586-221 PIPES, FITTINGS & REPAIRS
$1,000
$1,000
Wastewater
541-5-7586-222 CHEMICALS
$4,000
$5,000
Wastewater
541-5-7586-253 VEHICLE MAINTENANCE/REPAIRS
$10,000
$10,000
Wastewater
541-5-7586-256 WWTP MAINTENANCE/REPAIRS
$41,000
$41,000
Wastewater
541-5-7586-311 PROFESSIONAL SERVICES
$2,000
$2,000
Wastewater
541-5-7586-313 CONTRACTED SERVICES
$18,000
$18,000
Wastewater
541-5-7586-334 SLUDGE DISPOSAL
$2,000
$2,000
Wastewater
541-5-7586-418 SPECIAL PROJECTS
$67,000
$67,000
Wastewater
541-5-7586-418
GIS Mapping
$67,000
$67,000
Sanitation
591-4-1141-811 TRASH SERVICE CHARGES
$2,000,000
$2,585,000
Sanitation
591-5-7881-199 LABOR DISTRIBUTION
$30,000
$31,500
Sanitation
591-5-7881-223 GARBAGE CONTAINER/PARTS
$70,000
$72,000
Sanitation
591-5-7881-242 HHW EXPENSES
$20,000
$20,500
Sanitation
591-5-7881-247 RECYCLING SUPPLIES
$1,000
$1,000
Sanitation
591-5-7881-336 TRASH SERVICE CHARGES
$1,559,500
$1,779,000
Sanitation
591-5-7881-337 LANDFILL FEES
$15,000
$15,500
Sanitation
591-5-7881-360 PRINTING COST
$3,000
$3,000
Sanitation
591-5-7881-383 TRASH SERVICE
$16,000
$16,500
Sanitation
591-5-7881-390 RECYCLING BIN TRASH PICKUP
$2,000
$2,000
Sanitation
591-5-7881-394 BULK TRASH
$80,000
$82,000
Sanitation
591-5-7881-950 TRANSFER OUT
$357,000
$357,000
24
GIS Improvement Project Quotes
SAM Geospatial Services
Murray, Utah
Sanitary Sewer Network
Water Utility Network
$ 372,200.00
Entellus
Phoenix, AZ
Sanitary Sewer Network
Water Utility Network
$ 249,592.00
Burgess & Niple
Tempe, AZ
Sanitary Sewer Network
Water Utility Network
$ 371,134.00
Sunrise Engineering
Mesa, AZ
No Response
Intelligent Engineering • Innovative Solutions • Inclusive Culture
3033 N. 44th Street, Suite 250, Phoenix, AZ 85018
(602) 244-2566
www.entellus.com
February 22, 2024
El Mirage – 2022/2023 GIS Data Improvement Project
Entellus Project No. 522.013A
INTRODUCTION AND PROJECT OVERVIEW:
The City of El Mirage owns and operates water systems infrastructure throughout the city including a small area in
the old town of Surprise (OTS). These system assets consist of above and below ground locations that need to be
easily located during emergencies such as watermain breaks, sewer backups and firefighting events. Outdated
technologies and historical records were used previously to document these assets. Overtime employees have retired
along with city growth the El Mirage records need to be updated with accurate GIS locations.
The result of the project will be a complete and accurate dataset of above and below ground utility information. The
final deliverables will include easy to use web applications for field workers, spatially accurate information, and
updated line work to show the location of underground utilities.
Task 1. Meetings and Coordination:
Entellus will attend and participate in all project meetings. Entellus will prepare and distribute attendance sheets,
meeting agenda, and meeting minutes. Meeting minutes will be prepared by Entellus within three business days after
the meeting and sent to the City’s Engineering project manager for review. After approval Entellus will distribute the
meeting minutes to all meeting participants. The City’s Engineering PM will work with the Entellus PM and will
schedule all formal meetings that include the City staff/stakeholders.
1.1. Project Kick-off Meeting
It is anticipated that there will be one (1) project kick-off meeting.
1.2. Coordination Meetings
It is anticipated that there will be twelve (12) coordination meetings throughout the duration of the
project. It is assumed these meetings will be held virtually through Microsoft Teams.
Meeting Type
Number of
Meetings
Project Kick-off
1
Coordination Meetings
12
Total
13
Task 2. Data Collection and Office Operations
Entellus will gather various existing GIS utility data from the City of El Mirage to establish a baseline of information to
begin developing an all-inclusive dataset. Entellus will work with City personnel to compile and review the City’s
standard GIS format such as a File Geodatabase, that includes appropriate metadata schema, so any resulting data
will be delivered in a way that City GIS users will be able to incorporate the data easily back into the City’s system.
Entellus and the City’s GIS department will coordinate with an initial meeting to set up these schema and data delivery
format.
Intelligent Engineering • Innovative Solutions • Inclusive Culture
3033 N. 44th Street, Suite 250, Phoenix, AZ 85018
(602) 244-2566
www.entellus.com
Entellus will perform any data maintenance on data captured as part of Task 3 Field Data Acquisition. It is
anticipated that GIS personnel will bring in data collected in the field to be processed and loaded into the GIS
database and determine if accuracy requirements were met as well as the appropriate fields.
2.1. GIS Database Setup
Entellus will setup the initial GIS database and field GPS equipment to record feature location and
attributes. Entellus will coordinate with City Staff to establish the acceptable format of GIS deliverables.
2.2. Data Processing
This task will include the transfer and post process GPS observations from field data collectors to the
GIS database, verify the positional accuracy, and format the data to meet the City's specified
requirements. Entellus will establish a unique feature identification numbering system to join the field-
verified features to the City’s existing feature attribute data. This process provides a method to verify
that all features have been accounted for, and to retain the connectivity to the City’s existing GIS
database. It is anticipated that this data processing will be performed on a monthly basis.
2.3. Data Review (QA/QC)
Entellus will meet internally and create standards for data collected in the field with the GPS units.
These standards are composed of drop-down lists for fields that will be easily populated and set values
to ensure data consistency, as well as including accurate information for field workers for future
maintenance and inspections.
Entellus will review the field-verified features and compare the location to the existing feature’s data,
ensuring that information collected in the field is correct and consistent with the type of utility found.
This step is imperative as many features and utilities may be in close proximity to one another, and
capturing this is necessary for a successful project. Entellus will set up tools for checking data quality
against previously supplied information, to highlight areas with potential issues if discrepancies are
found between the original GIS data and the field verified data. Quality control may also be done
through automatic checks using built-in Geoprocessing Tools, plugins, or python scripts. Manual quality
control follows checklists created to ascertain data completeness.
2.4. Identification, Coordination, and Resolution of Discrepancies
Entellus will coordinate with the City to determine if there are areas that need further investigation, such
as acquiring as-built information, review with City workers for flow directions, and any other instances
of data collection where a City employee may have the institutional knowledge of the area that can be
translated into the GIS system. This coordination will mostly be through email but may occur through
phone calls, Microsoft Teams meetings or in-person visits.
Task 3. Field Data Acquisition
Entellus will establish a desktop data collection process using ESRI’s ArcGIS Desktop Suite, including ArcGIS Pro
3.2 (or newer) and ArcMap 10.8.2. The data collection will be completed in phases or in natural delimiters in the City,
such as quarter sections or topographic features like major roadways. Entellus will load existing known facility utility
features into a survey collector and collect sub-foot locations of the features in question. This data will then be
reviewed and compiled as described under Task 2: Data Collection and Office Operations.
Intelligent Engineering • Innovative Solutions • Inclusive Culture
3033 N. 44th Street, Suite 250, Phoenix, AZ 85018
(602) 244-2566
www.entellus.com
This GIS data improvement project will contract professional services to perform a field utility asset inventory of
approximately 21,000 features. The following sections list the prioritized asset types to be collected at sub-foot
accuracy.
This list may not be all inclusive of items related to this scope. Entellus and the City’s Project Manager will discuss if
any further items needed will fit into this current scope.
It is anticipated that the acquisition of some waste water and water well site facility data will require the accompanying
of a City employee to obtain. To that end, it is assumed that Entellus field workers will meet with a City employee
once a month in the field to gain access to these secured waste water or water well site locations to obtain the
necessary GPS data.
3.1. Water Valves: El Mirage (Est. 5,000)
3.2. Water Valves: old town Surprise (Est. 1,000)
3.3. Water Main Valves: including 9 well site valves. (Est. 36) [ID SNYVWLV #]
3.4. Water Blow Off Valves: El Mirage and old town Surprise (Est. 10) [ID: OTSBOV #]
3.5. Fire Hydrants: El Mirage (Est. 1,050) [ID numbers to be reused when possible]
3.6. Fire Hydrants: old town Surprise (350) [ID numbers to be reused when possible]
3.7. Fire Service Valves: El Mirage (Est. 400)
3.8. Fire Service Valves: old town Surprise (Est. 150)
3.9. Meters (Residential & Commercial): El Mirage and old town Surprise (Est. 11,163)
3.10. Sample Station Locations: El Mirage and old town Surprise (50 stations)
3.11. Sewer Manholes: El Mirage (Est. 1,500) [ID MH#]
3.12. Sewer Cleanouts: El Mirage (Est. 265) [ID SCO#]
3.13. Vehicles & Equipment
The cost for vehicles and equipment will be charged on a daily basis for field activities.
Task 4. Traffic Control
4.1. Traffic Control Schedule and Coordination
Entellus will coordinate their traffic control needs with the City. It is anticipated that this will be necessary
at four (4) major intersections.
4.2. Provide Traffic Control
When traffic control is necessary, Entellus will have a vehicle on site with a directional beacon to direct
traffic away from work activities. It is assumed that a traffic control plan and permit are not necessary
as part of this project.
Task 5. Develop Feature Line Dataset
Entellus will review any existing GIS data and determine its applicability to the project. The data collected in Task 3
Field Data Acquisition will help develop the items listed in the following sections. It is estimated there are six (6)
project as-built plans (water/wastewater assets) that need to be added to new and existing map layers.
5.1. Water distribution mains
This will include main size and material type (ex: 6”,8”12”, 16”, PVC, DI, AC).
5.2. Water distribution main line valves
This will include valve numbers (ex: EMV#, SV#)
5.3. Fire hydrants and hydrant valves
Intelligent Engineering • Innovative Solutions • Inclusive Culture
3033 N. 44th Street, Suite 250, Phoenix, AZ 85018
(602) 244-2566
www.entellus.com
This will include valve and fire hydrant numbers (ex: EMH #, EMHV #)
5.4. Fire service lines
This will include fire service line valve to buildings
5.5. Sewer collection mains
This will include main size and material and flow direction arrows (ex: 6”8”,12”16, PVC, DI, Clay). The
flow directions will be coordinated with City employees under Task 2.4, if necessary.
5.6. Sewer Lines
This will include manhole to manhole line segments and cleanout to manhole line segments.
5.7. Lift station discharge lines
This will include valves to the receiving manholes for 2 lift stations.
Task 6. Deliverables
6.1. GIS Data Submittal.
Entellus will prepare and deliver a file geodatabase with metadata and schema that matches the City’s
current GIS data specifications. This geodatabase will include the deliverables for the Data Collection
and Office Operations, Field Data Acquisition, and the Develop Feature Lines Dataset tasks.
As part of this project’s delivery Entellus will set up and deliver a standardized Geodatabase in
accordance with the City’s Geospatial metadata and follow QA/QC standards (ISO 19115) or the City
of El Mirage’s preferred metadata standard.
6.2. Progress Reports.
Entellus will prepare monthly progress reports to deliver to the City, outlining any issues that may have
been found and need to be addressed. These reports will also include screenshots of the progression
of the collection in the City on a high-level map.
6.3. Application Development
As part of this task, Entellus will update the existing City of El Mirage ArcGIS online portal web maps
to reflect the updated data performed by this project. This will include updating any maps like the Water
Assets or Wastewater Assets maps. This will help provide City employees with the most up to date
information that can be useful in day-to-day and emergency operations. The maintenance of these
applications is limited to the duration of this project.
2022/23 GIS Data Improvement Project
Project
GIS
GIS
GIS
Survey
Survey
Survey Crew
1-Man Crew
GIS
Total
Total
Direct
TASK
Principal
Manager
Analyst
Tech
Manager
RLS
Chief
Survey
Admin
Technical
Hours
Amount
Expenses
Advisor
231.00
$
117.00
$
100.00
$
74.00
$
208.00
$
188.00
$
104.00
$
84.00
$
93.00
$
188.00
$
1
12
76
28
0
6
0
0
0
12
6
140
17,956.00
$
-
$
1.1
Project Coordination and Administration
6
48
12
66
8,118.00
$
1.2
Kick-off Meeting
2
4
4
2
2
14
2,122.00
$
1.3
Coordination Meetings (12)
4
24
24
4
4
60
7,716.00
$
0
-
$
2
2
54
172
218
4
16
0
0
0
4
470
44,704.00
$
-
$
2.1
GIS Database Setup
8
16
4
4
32
4,120.00
$
2.2
Data Processing
12
48
16
76
9,212.00
$
2.3
Data Review (QA/QC)
2
24
80
160
266
23,110.00
$
2.4
ID, Coordination, and Resolution of Discrepancies
8
16
10
34
3,276.00
$
2.5
Project as-built Plans (6)
2
12
48
62
4,986.00
$
0
-
$
3
0
0
0
0
0
0
0
1059
0
0
1059
88,956.00
$
12,502.00
$
3.1
Water Valves, El Mirage (5,000)
250
250
21,000.00
$
3.2
Water Valves, Old Town Surprise (1,000)
50
50
4,200.00
$
3.3
Water Main Valves / Well Site Valves (36)
16
16
1,344.00
$
3.4
Water Blow Off Valves (10)
4
4
336.00
$
3.5
Fire Hydrants, El Mirage (1,050)
50
50
4,200.00
$
3.6
Fire Hydrants, Old Town Surprise (350)
16
16
1,344.00
$
3.7
Fire Service Valves, El Mirage (400)
20
20
1,680.00
$
3.8
Fire Service Valves, Old Town Surprise (150)
8
8
672.00
$
3.9
Meters, ALL - Residential & Commercial (11,163)
400
400
33,600.00
$
3.10
Sample Station Locations, ALL (50)
25
25
2,100.00
$
3.11
Sewer Manholes, El Mirage (1,500)
190
190
15,960.00
$
3.12
Sewer Cleanouts, El Mirage (265)
30
30
2,520.00
$
3.13
Vehicles & Equipment
-
$
$12,502.00
0
-
$
4
2
4
0
0
2
8
16
0
0
0
32
4,514.00
$
188.00
$
4.1
Traffic Control Schedule and Coordination
2
4
4
10
1,682.00
$
4.2
Provide Traffic Control
2
4
16
22
2,832.00
$
$188.00
0
-
$
5
0
10
82
440
0
0
0
0
0
0
532
41,930.00
$
-
$
5.1
Water Distr, Lines (4200 WM, 9000 SL, 5500 meters, 2500 fittings, 2800 valves)
4
32
200
236
18,468.00
$
5.2
Fire Service Lines
2
20
80
102
8,154.00
$
5.3
Sewer Collection Mains(2700 line, 2100 point features, 346 surprise)
2
24
120
146
11,514.00
$
5.4
Lift Station Discharge Lines
2
6
40
48
3,794.00
$
0
-
$
6
6
32
74
76
0
0
0
0
0
2
190
18,530.00
$
-
$
6.1
GIS Data Submittal
2
4
16
12
2
36
3,794.00
$
6.2
Progress Reports
2
12
18
4
36
3,962.00
$
6.3
Application Development
2
16
40
60
118
10,774.00
$
0
-
$
22
176
356
734
12
24
16
1059
12
12
2423
12,690.00
$
5,082.00
$
20,592.00
$
35,600.00
$
54,316.00
$
2,496.00
$
4,512.00
$
1,664.00
$
88,956.00
$
1,116.00
$
2,256.00
$
$216,590.00
12,690.00
$
$229,280.00
12,690.00
$
February 22, 2024
PROJECT HOURS AND FEES
Entellus
El Mirage Prj. No.
Entellus Prj #522.013A
WORK ITEM
DESCRIPTION
Project Management and Meetings
Data Collection & Office Operations
Field Data Acquisition
Traffic Control
Develop Feature Line Dataset
Deliverables
TOTAL STAFF HOURS BASIC DESIGN SERVICES
DIRECT LABOR COST
TOTAL DIRECT EXPENSES
TOTAL BASE PROJECT COST
3033 N. 44th Street, Suite 250, Phoenix, AZ 85018
(602) 244-2566
www.entellus.com
O:\500 Series\522 (El Mirage)\C_522.013 El Mirage (On-Call GIS Services 2023)\Contract\522.013A - GIS Fee Schedule.xlsx
1 of 2
2022/23 GIS Data Improvement Project
Project
GIS
GIS
GIS
Survey
Survey
Survey Crew
1-Man Crew
GIS
Total
Total
Direct
TASK
Principal
Manager
Analyst
Tech
Manager
RLS
Chief
Survey
Admin
Technical
Hours
Amount
Expenses
Advisor
231.00
$
117.00
$
100.00
$
74.00
$
208.00
$
188.00
$
104.00
$
84.00
$
93.00
$
188.00
$
February 22, 2024
PROJECT HOURS AND FEES
Entellus
El Mirage Prj. No.
Entellus Prj #522.013A
WORK ITEM
DESCRIPTION
3033 N. 44th Street, Suite 250, Phoenix, AZ 85018
(602) 244-2566
www.entellus.com
10
0
24
32
60
0
8
0
90
0
0
214
19,512.00
$
800.00
$
10.1
Additional Services
24
32
60
8
90
214
19,512.00
$
$800.00
0
-
$
0
24
32
60
0
8
0
90
0
0
214
800.00
$
-
$
2,808.00
$
3,200.00
$
4,440.00
$
-
$
1,504.00
$
-
$
7,560.00
$
-
$
-
$
$19,512.00
-
$
2,808.00
$
3,200.00
$
4,440.00
$
-
$
1,504.00
$
-
$
7,560.00
$
-
$
-
$
19,512.00
$
5,082.00
$
23,400.00
$
38,800.00
$
58,756.00
$
2,496.00
$
6,016.00
$
1,664.00
$
96,516.00
$
1,116.00
$
2,256.00
$
249,592.00
$
13,490.00
$
Allowances
TOTAL PROJECT COST
TOTAL STAFF HOURS OPTIONAL DESIGN SERVICES
DIRECT LABOR COST
TOTAL DIRECT EXPENSES
TOTAL ALLOWANCE PROJECT COST
O:\500 Series\522 (El Mirage)\C_522.013 El Mirage (On-Call GIS Services 2023)\Contract\522.013A - GIS Fee Schedule.xlsx
2 of 2