HomeMy WebLinkAbout413547 ABB INC - CONTRACT - RFP - P1055 PLANNING STUDY 29568 (2)PROFESSIONAL SERVICES AGREEMENT
THIS AGREEMENT made and entered into the day and year set forth below, by and
between THE CITY OF FORT COLLINS, COLORADO, a Municipal Corporation, hereinafter
referred to as the "City" and ABB, Inc., hereinafter referred to as "Professional'.
WITNESSETH:
In consideration of the mutual covenants and obligations herein expressed, it is agreed
by and between the parties hereto as follows:
Scope of Services. The Professional agrees to provide services in accordance
with the scope of services attached hereto as Exhibit "A", consisting of eleven (11) pages, and
incorporated herein by this reference.
2. Contract Period. This Agreement shall commence within three days of signing,
and shall continue in full force and effect until May 31, 2007, unless sooner terminated as herein
provided.
3. Early Termination by City. Notwithstanding the time periods contained herein,
the City may terminate this Agreement at any time without cause by providing written notice of
termination to the Professional. Such notice shall be delivered at least fifteen (15) days prior to
the termination date contained in said notice unless otherwise agreed in writing by the parties.
All notices provided under this Agreement shall be effective when mailed, postage prepaid and
sent to the following addresses:
Professional: City: With Copy to:
ABB, Inc. Utilities Service Center City of Fort Collins, Purchasing
Attn: Tim Taylor Attn: Rocky Ray PO Box 580
940 Main Campus Drive, Ste 300 700 Wood St. Fort Collins, CO 80522
Raleigh, NC 57606 Fort Collins, CO 80521
In the event of any such early termination by the City, the Professional shall be paid for services
rendered prior to the date of termination, subject only to the satisfactory performance of the
IL
z4
Figure 2 - Sample Parcel/Zoning Data
The load density data by parcel or zoning will be used in the development of load "center of
mass" for the existing substation (Richards) and the future (Timberline) substation. Additionally,
the load center of mass for the remaining areas (not ultimately served by the Richards and
Timberline stations) will be computed to determine the general vicinity of any potential additional
substation sites. The load center of mass will be calculated by combining parcels/zoning areas
based on their individual centers of mass to obtain a new center of mass for the combined
parcel. This process will be repeated to obtain the load center of mass for the ultimate loads
provided by Fort Collins Utilities.
The parcel and zoning data will also be used to support selection of a suitable substation site
meeting size and zoning requirements.
6.0 Substation and Feeder Data
Substation data (parcel identification, ultimate load carrying capability) and existing/planned
mainline feeder locations will be imported from shapefiles provided by Fort Collins Utilities. The
existing substation locations will provide point capacity locations that will need to be balanced
with the new third substation point capacity location relative to the load center of mass
determined from the ultimate load density parcel / zoning data.
The existing/planned feeder data will be used to refine the selected new substation location
based on a relative weighting designed to balance proximity to the point that provides the
greatest "balance' to the load center of mass while also providing an overall least cost for the
based on the following estimated construction costs:
Substation Costs
Distribution Feeder Costs (750kcmil only)
Transmission Costs (to serve new station)
The cost estimates for the above items will be approximate only as this study does not include
exact routing of feeders or transmission lines. However, the above estimates are intended to
provide guidance to the site selection process to prevent siting a substation in a location with
prohibitive feeder or transmission costs.
7.0 Site Selection Process
Potential new site selections will be determined through a four step process based on the
geospatial model. Potential new substation sites will be assessed for both the existing GMA
boundary and a possible extension of the GMA boundary. The steps are outlined below.
Load Center of Mass Determination
The "center of mass" of the ultimate loads (by zoning/parcel as provided by Fort Collins Utilities)
will be determined by combining the individual parcel centers of mass, weighted based on the
load density of the parcels being combined.
Load Assignment to Substations
The load surrounding the existing substations will be assigned up to the capacity of the existing
stations. This process will consider both the proximity of load as well as the areas served by
existing / planned feeders from each of the existing substations. The result of this process will
be to define the area to be served by the new substation.
Potential Site Identification
Up to four potential substation sites will be identified via a relative weighting of three key
parameters in the geospatial model:
1) Location within and near the center of the new substation area identified in the
previous step
2) `Balance" provided by combination of new substation and existing substations
relative to ultimate center of mass
3) Proximity to existing/planned main feeder trunk routes
Several iterations are expected in order to fine tune the weighting parameters for the above
items.
Site Selection
The potential sites identified above will be assessed relative to parcel sizes in the vicinity of the
potential locations, as well as any restrictive features (e.g. hydrography, railroads, cemeteries,
etc.). The potential costs associated with each potential site will be quantified using simple
linear estimates of site acquisition costs, feeder costs to connect to existing / planned mainline
feeders, and substation construction costs. The costs, as well as the restrictive features, will be
used to rank the potential sites and provide a single best site.
8.0 Deliverables
A report summarizing the development of the site selection process will be provided as the
principal deliverable from the project. The report will include:
Summary of Data Sources
Assumptions
Substation Site Alternatives Considered
Evaluation Results (ranked listing of potential stations)
Substation Site Recommendation(s)
The report will include extensive graphics to convey the quantitative geospatial process used to
determine potential sites substation service areas, and parcel / zoning / infrastructure customer
load densities. This report will also include a tabular summary in Excel format of the probable
cost estimates used to determine the site rankings.
The report will be submitted in a single bound hardcopy as well as a MS Word format to allow
Fort Collins Utilities to print additional copies. The report will be supplemented with one full
size, and one reduced size map of each principal site choice. Additionally, a -summary
PowerPoint presentation will be provided that highlights key aspects covered in detail in the
report.
ArcGIS files, including maps, layers, and supporting shapefiles, shall be provided to FCU upon
completion of the report. Maps will include symbol legends and be defined for plotting both at
ANSI B, D, and E sizes.
A summary of the probable cost estimates used in the study will be provided in Excel format.
9.0 Schedule
The project is anticipated to require no more than twelve weeks from receipt of an authorized
purchase order and all data outlined in the RFP and this proposal from FCU to support the
assessment. Additionally, we anticipate that we can provide a preliminary assessment as to
the necessity for an additional substation site to the east of 1-25 within ten business days of
receipt of the purchase order and data mentioned previously.
10. Key Personnel Qualifications
The project team will be Tim Taylor of ABB Inc. and Andy Hanson of PowerComm
Engineering. Both are experienced with spatial load projections and substation siting. A bio
for each is provided on the following pages.
TIM TAYLOR
Director
EDUCATION
MSEE, BSEE
North Carolina State University, Raleigh, NC
Master's Thesis: "Application ojHeuristics to Distribution Feeder
Reconfiguration"
MBA
University of North Carolina — Chapel Hill
PROFESSIONAL ACTIVITIES
Institute of Electrical and Electronic Engineers
— Senior Member, Power Engineering Society
— Chair of the Distribution Working Group, Power System
Planning and Implementation Committee, 2000 - 2002
Licensed Professional Engineer, State of New York
PUBLICATIONS
Mr. Taylor has authored over 15 technical papers on topics in
distribution feeder reconfiguration, generation planning, distribution
planning and reliability, and asset management.
EXPERIENCE
Tim Taylor is a Director with ABB Electric Systems Consulting.,
located in Raleigh, NC. He has been with ABB since 1995, in a
number of roles involving asset management, power system
planning, and economic analysis. Tim is responsible for the
marketing and implementation of ABB's Asset Sentry service for
the power generation, transmission, and distribution markets.
He is also responsible for projects in the areas of distribution
systems planning and engineering. He is particularly
experienced with respect to the cost optimization of electric
distribution systems, and has been involved in projects
throughout the United States and Latin America. Tim is
proficient in load forecasting, power system planning, predictive
reliability analysis, equipment maintenance practices, and
economic analysis.
Prior to his present position, Tim worked for ABB's Electric
system Technology Institute as a Senior Engineer. Tim's
responsibilities included the development of system analysis
tools and capabilities for optimizing the operation of
transmission and distribution systems. He participated in
projects in El Salvador, Guatemala, and Argentina. He was also
the primary contributor on a project which evaluated methods for
limiting fault currents on primary distribution systems.
Prior to joining ABB, Tim worked for GE for 7 years as an
electric utility systems engineer. He was an application
engineer in GE Power System Sales Department for two years.
He was responsible for providing technical assistance to GE's
utility customers located in Pennsylvania, New Jersey, and
Maryland. He particularly focused on assisting utilities with
system studies and on the application of protective relays and
associated equipment.
Tim worked 5 years in Schenectady in GE's Power System
Engineering Department, where he spent two and a half years as an
application engineer in their generation product application
engineering group. His responsibilities included generation planning
studies, as well as projects in generating station auxiliary systems and
generator excitation systems. Tim also spent two and a half years in
their distribution product application engineering group, where he led a
number of projects involving distribution system economics,
distribution voltage control, application of surge arresters, and personal
protective grounding methods.
ANDREW HANSON
PowerComm Engineering, Inc.
EDUCATION
BEE
Georgia Institute of Technology
MEE
Auburn University
Ph.D.
Auburn University
Dissertation: "Unbalanced Radial System State Estimation Using
Generalized Admittance Matrix Segment Models"
PROFESSIONAL ACTIVITIES
IEEE — Power Engineering Society — Senior Member
IEEE Power & Energy Magazine — Editorial Board
EXPERIENCE
Andrew Hanson is with PowerComm Engineering, where he provides
a range of T&D consulting and design services to electric utilities.
Dr. Hanson was an executive consultant with ABB Consulting. From
2001-2004 and in ABB's Power Distribution Solutions business area
from 1998-2001 with broad based expertise in utility and industrial
power distribution systems. His experience includes system planning,
load forecasting, generator interconnection impact assessment,
statistical analysis and industrial system design. At ABB Consulting
and Power Distribution Solutions, he assisted major industrial
customers with interconnection and generator coordination issues,
including petrochemical and potash plants.
In 2001 he worked for Chevron Energy Solutions as a cogeneration
developer, supporting the design and interconnection of cogeneration
facilities to utility systems. He developed conceptual designs for
cogeneration systems for food processing and metals processing
facilities.
Prior to joining ABB, he worked in the Industrial Systems and Service
division of Siemens Energy & Automation where he was responsible
for electrical power system design, cost estimating and technical
proposal preparation for steel mills, paper mills and air separation
plants.
Dr. Hanson was a teaching and research assistant while pursuing the
doctoral degree at Auburn University, teaching courses in circuits,
power system engineering and rotating machinery and performing
sponsored research into unbalanced radial system state and parameter
estimation.
Prior to obtaining his doctorate, he spent five years at Tampa Electric
Company in the Distribution Engineering and System Planning
departments where he was the point technical contact for new
cogeneration interconnections, coordinating the technical aspects and
assessments for new cogeneration facilities.
11. Pricing and Invoicing
This proposal is offered at a total fixed price of $46,500.
This price is valid for sixty days from the date of this proposal.
The invoicing schedule shall be as follows:
Preliminary Report - Substation: 20% of Total Price
Delivery of Draft Final Report: 60% " " "
Delivery of Final Report: 20% " " "
It is anticipated that this project can be completed without any face-to-face meetings, so no
project trips to Fort Collins have been budgeted. Conference calls and individual telephone calls
will be held in order to discuss data requirements, draft results of the project, and for any other
purposes. Development of any testimony or performance of public presentations that may be
requested is not included in this proposal, and would be subject to an additional fee.
EXHIBIT "B"
Special Provisions
1. Acceptance.
Purchaser has 30 days after delivery of the "Service" to accept the "Service". In any
event, acceptance will be deemed to have occurred no later than 30 days after
delivery of "Service".
2. Changes.
Any changes requested by City affecting the ordered scope of work must be accepted
by Professional and resulting adjustments to affected provisions, including price,
schedule, and guarantees mutually agreed in writing prior to implementation of the
change.
3. Warranty.
(a) ABB warrants that the Services shall be performed in accordance with high
professional standards. Unless otherwise agreed in writing, ABB shall choose the
methods and techniques applicable to the Services in accordance with such standards.
Should any error in the Services become apparent within six (6) months from the date
the Services are provided, ABB shall, upon prompt written notification from City, re -
perform the portion of the Services in which any such error was found
(b) The foregoing warranties are exclusive and in lieu of all other warranties of quality
and performance, whether written, oral or implied, and all other warranties including any
implied warranties of merchantability or fitness for particular purpose or usage of trade
are hereby disclaimed. The remedies stated herein constitute City's exclusive remedies
and ABB's entire liability for any breach of warranty.
4. Indemnification and Insurance
Professional agrees to indemnify and hold harmless the City for and only for claims
made by 3rd Parties due to personal injury and/or property damage to the extent that
such damages are caused by Professional's negligence. In no event shall Professional
be held liable for damages to the extent caused by others, including the City.
Professional will, upon request, supply City with its "Standard" Insurance Certificate as
evidence of the coverage that it maintains with respect to the Scope of Services. In the
event that City requires being listed as an additional insured on any coverage evidenced
by such certificate, such additional insured status shall apply only to the extent of
Professional's negligence.
5. Limitation of Liability.
(a) In no event shall Professional, its suppliers or subcontractors be liable for special,
indirect, incidental or consequential damages, whether in contract, warranty, tort,
negligence, strict liability or otherwise, including, but not limited to, loss of profits or
revenue, loss of use of the Equipment or any associated equipment, cost of capital, cost
of substitute equipment, facilities or services, downtime costs, delays, and claims of
customers of the City or other third parties for any damages. Professional's liability for
any claim whether in contract, warranty, tort, negligence, strict liability, or otherwise for
Page 1 of 2
any loss or damage arising out of, connected with, or resulting from this Agreement or
the performance or breach thereof, or from the design, manufacture, sale, delivery,
resale, repair, replacement, installation, technical direction of installation, inspection,
operation or use of any equipment covered by or furnished under this Agreement, or
from any services rendered in connection therewith, shall in no case exceed one-half
(1/2) of the purchase price allocable to the Equipment or part thereof or Services which
gives rise to the claim.
(b) All causes of action against Professional arising out of or relating to this Agreement
or the performance or breach hereof shall expire unless brought within one year of the
time of accrual thereof.
(c) In no event, regardless of cause, shall Professional be liable for penalties or penalty
clauses of any description or for indemnification of City or others for costs, damages, or
expenses arising out of or related to the Equipment and/Services.
6. Inventions and Information.
Unless otherwise agreed in writing by Professional and City, all right, title and interest in
any inventions, developments, improvements or modifications of or for Equipment and
Services shall remain with Professional. Any design, manufacturing drawings or other
information submitted to the City remains the exclusive property of Professional. City
shall not, without Professional's prior written consent, copy or disclose such information
to a third party. Such information shall be used solely for the operation or maintenance
of the Equipment and not for any other purpose, including the duplication thereof in
whole or in part.
7. Force Majeure.
Professional shall neither be liable for loss, damage, detention or delay nor be deemed
to be in default for failure to perform when prevented from doing so by causes beyond
its reasonable control including but not limited to acts of war (declared or undeclared),
Acts of God, fire, strike, labor difficulties, acts or omissions of any governmental
authority or of City, compliance with government regulations, insurrection or riot,
embargo, delays or shortages in transportation or inability to obtain necessary labor,
materials, or manufacturing facilities from usual sources or from defects or delays in the
performance of its suppliers or subcontractors due to any of the foregoing enumerated
causes. In the event of delay due to any such cause, the date of delivery will be
extended by period equal to the delay plus a reasonable time to resume production, and
the price will be adjusted to compensate Professional for such delay.
8. Export Control.
(a) City represents and warrants that the Equipment and Services provided hereunder
and the "direct product" thereof are intended for civil use only and will not be used,
directly or indirectly, for the production of chemical or biological weapons or of precursor
chemicals for such weapons, or for any direct or indirect nuclear end use. City agrees
not to disclose, use, export or re-export, directly or indirectly, any information provided
by Professional or the "direct product" thereof as defined in the Export Control
Regulations of the United States Department of Commerce, except in compliance with
such Regulations.
(b) If applicable, Professional shall file for a U.S. export license, but only after
appropriate documentation for the license application has been provided by City. City
Page 2 of 2
shall furnish such documentation within a reasonable time after order acceptance. Any
delay in obtaining such license shall suspend performance of this Agreement by
Professional. If an export license is not granted or, if once granted, is thereafter
revoked or modified by the appropriate authorities, this Agreement may be canceled by
Professional without liability for damages of any kind resulting from such cancellation.
At Professional's request, City shall provide to Professional a Letter of Assurance and
End -User Statement in a form reasonably satisfactory to Professional.
Page 3 of 2
CONFIDENTIAL and PROPRIETARY - ABB reserves all rights in this document and the
information contained herein. Reproduction, use or disclosure to third parties without
express authority from ABB is strictly forbidden.
Professional's obligations under this Agreement. Such payment shall be the Professional's sole
right and remedy for such termination.
4. Design, Project Indemnity and Insurance Responsibility. The Professional shall
be responsible for the professional quality, technical accuracy, timely completion and the
coordination of all services rendered by the Professional, including but not limited to designs,
plans, reports, specifications, drawings, licenses and permits and shall, without additional
compensation, promptly remedy and correct any errors, omissions, or other deficiencies. The
Professional shall indemnify, save and hold harmless the City, its officers and employees in
accordance with Colorado law, from all damages whatsoever claimed by third parties against
the City; and for the City's costs and reasonable attorneys fees, arising directly or indirectly out
of the Professional's performance of any of the services furnished under this Agreement. The
Professional shall maintain commercial general liability insurance in the amount of $500,000.
5. Compensation. In consideration of the services to be performed pursuant to
this Agreement, the City agrees to pay Professional a fixed fee in the amount of Forty Six
Thousand Five Hundred Dollars ($46,500). Monthly partial payments based upon the
Professional's billings and itemized statements are permissible. The amounts of all such partial
payments shall be based upon the Professional's City -verified progress in completing the
services to be performed pursuant hereto and upon the City's approval of the Professional's
actual reimbursable expenses. The parties acknowledge that PowerComm Engineering, Inc. is
not a party to this agreement. Final payment shall be made following acceptance of the work by
the City. Upon final payment, all designs, plans, reports, specifications, drawings, and other
services rendered by the Professional shall become the sole property of the City.
6. City Representative. The City will designate, prior to commencement of work, its
project representative who shall make, within the scope of his or her authority, all necessary and
proper decisions with reference to the project. All requests for contract interpretations, change
2
f
orders, and other clarification or instruction shall be directed to the City Representative.
7. Project Drawings. Upon conclusion of the project and before final payment, the
Professional shall provide the City with reproducible drawings of the project containing accurate
information on the project as constructed. Drawings shall be of archival, prepared on stable
mylar base material using a non -fading process to provide for long storage and high quality
reproduction. Professional shall also submit to the City in an AutoCAD version no older then
the established city standard the as -built drawings on media selected by the City.
8. Monthly Report. Commencing thirty (30) days after the date of execution of this
Agreement and every thirty (30) days thereafter, Professional is required to provide the City
Representative with a written report of the status of the work with respect to the Scope of
Services, Work Schedule, and other material information. Failure to provide any required
monthly report may, at the option of the City, suspend the processing of any partial payment
request.
9. Independent Contractor. The services to be performed by Professional are those
of an independent contractor and not of an employee of the City of Fort Collins. The City shall
not be responsible for withholding any portion of Professional's compensation hereunder for the
payment of FICA, Workers' Compensation, other taxes or benefits or for any other purpose.
10. Personal Services. It is understood that the City enters into this Agreement
based on the special abilities of the Professional and that this Agreement shall be considered as
an agreement for personal services. Accordingly, the Professional shall neither assign any
responsibilities nor delegate any duties arising under this Agreement without the prior written
consent of the City.
11. Acceptance Not Waiver. The City's approval of drawings, designs, plans,
specifications, reports, and incidental work or materials furnished hereunder shall not in any way
relieve the Professional of responsibility for the quality or technical accuracy of the work. The
3
City's approval or acceptance of, or payment for, any of the services shall not be construed to
operate as a waiver of any rights or benefits provided to the City under this Agreement.
12. Default. Each and every term and condition hereof shall be deemed to be a
material element of this Agreement. In the event either party should fail or refuse to perform
according to the terms of this Agreement, such party may be declared in default.
13. Remedies. In the event a party has been declared in default, such defaulting
party shall be allowed a period of ten (10) days within which to begin cure said default. In the
event the default remains uncorrected, the party declaring default may elect to (a) terminate the
Agreement and seek damages; (b) treat the Agreement as continuing and require specific
performance; or (c) avail himself of any other remedy at law or equity. If the non -defaulting
party commences legal or equitable actions against the defaulting party, the defaulting party
shall be liable to the non -defaulting party for the non -defaulting party's reasonable attorney fees
and costs incurred because of the default.
14. Binding Effect. This writing, together with the exhibits hereto, constitutes the
entire agreement between the parties and shall be binding upon said parties, their officers,
employees, agents and assigns and shall inure to the benefit of the respective survivors, heirs,
personal representatives, successors and assigns of said parties.
15. Law/Severability. The laws of the State of Colorado shall govern the
construction, interpretation, execution and enforcement of this Agreement. In the event any
provision of this Agreement shall be held invalid or unenforceable by any court of competent
jurisdiction, such holding shall not invalidate or render unenforceable any other provision of this
Agreement.
17. Prohibition Against Employing Illegal Aliens. This paragraph shall apply
to all Professionals whose performance of work under this Agreement does not involve the
delivery of a specific end product other than reports that are merely incidental to the
0
performance of said work. Pursuant to Section 8-17.5-101, C.R.S., et. seq., Professional
represents and agrees that:
A. As of the date of this Agreement:
1. Professional does not knowingly employ or contract with an illegal alien;
and
2. Professional has participated or attempted to participate in the basic pilot
employment verification program created in Public Law 208, 104th
Congress, as amended, and expanded in Public Law 156, 108th
Congress, as amended, administered by the United States Department of
Homeland Security (the `Basic Pilot Program") in order to verify that
Professional does not employ any illegal aliens.
B. Professional shall not knowingly employ or contract with an illegal alien to
perform works under this Agreement or enter into a contract with a
subcontractor that fails to certify to Professional that the subcontractor shall
not knowingly employ or contract with an illegal alien to perform work under
this Agreement.
C. Professional shall continue to apply to participate in the Basic Pilot Program
and shall in writing verify same every three (3) calendar months thereafter,
until Professional is accepted or the public contract for services has been
completed, whichever is earlier. The requirements of this section shall not be
required or effective if the Basic Pilot Program is discontinued.
D. Professional is prohibited from using Basic Pilot Program procedures to
undertake pre -employment screening of job applicants while this Agreement is
being performed.
E. If Professional obtains actual knowledge that a subcontractor performing work
under this Agreement knowingly employs or contracts with an illegal alien,
Professional shall:
1. Notify such subcontractor and the City within three days that Professional
has actual knowledge that the subcontractor is employing or contracting
with an illegal alien; and
2. Terminate the subcontract with the subcontractor if within three days of
receiving the notice required pursuant to this section the subcontractor
does not cease employing or contracting with the illegal alien; except that
Professional shall not terminate the contract with the subcontractor if
during such three days the subcontractor provides information to establish
that the subcontractor has not knowingly employed or contracted with an
illegal alien.
F. Professional shall comply with any reasonable request by the Colorado
Department of Labor and Employment (the "Department') made in the course
5
Proposal
Substation Planning
And Siting Study
SUBMITTED TO:
Fort Collins Utilities
Fort Collins, CO
SUBMITTED BY:
ABB Inc.
Electric Systems Consulting
940 Main Campus Drive, Suite 300
Raleigh, NC 27606
Table of Contents
1.0 OVERVIEW
2.0 WORK PLAN
3.0 Data Collection
4.0 Infrastructure Modeling
5.0 Zoning and Parcel Data Modeling
6.0 Substation and Feeder Data
7.0 Site Selection Process
Load Center of Mass Determination
Load Assignment to Substations
Potential Site Identification
Site Selection
8.0 DELIVERABLES
9.0 SCHEDULE
10. KEY PERSONNEL QUALIFICATIONS
11. PRICING AND INVOICING
1
1
1
2
2
3
4
4
4
4
4
4
5
5
8
1.0 Overview
This proposal is submitted to Fort Collins Utilities (Fort Collins) from ABB Inc, (ABB) through
its Grid Systems — North America business unit, with offices at 940 Main Campus Drive, Suite
300, Raleigh, NC 27606. Questions or responses to this proposal can be directed to either of the
following individuals:
Bob Fanslow 303-797-4083 robert.f.fanslow(a)us.abb.com
Tim Taylor 919-856-3884 tim.taylorAus.abb.com
In this project, a land use / infrastructure / load density model will be developed to provide an
analytical basis for selection of a new substation site in the City of Fort Collins. The model will
be used to determine load centers relative to existing and known substation sites and to
determine potential locations for one or more additional substations, if needed.
2.0 Work Plan
A land use / infrastructure / load density model will be developed for the designated area of Fort
Collins. The model will be developed in the ArcGIS environment based on land use, zoning and
infrastructure information as well as other data provided by Fort Collins Utilities. The work plan
below details the individual tasks.
3.0 Data Collection
Fort Collins Utilities is expected to provide the raw data to support the analysis. This data is
expected to include the items listed below.
1. Existing distribution system maps in AutoDesk ACAD showing 750 Al feeders.
2. Less detailed feeder maps available in ESRI ArcGIS file formats.
3. Existing and hypothetical GMA boundaries
4. Existing City land use, zoning, and infrastructure plans available in ESRI ArcGIS file
formats
5. Copy of original 1984 long range planning study (only final report available)
6. Load density values for projected land use classifications and foreseeable development
categories
7. General overview design, construction, and operating standards for substation
transformer loading, feeder loading, substation construction, and feeder construction.
8. Summaries of recent feeder and substation construction costs for recent projects
performed by Fort Collins Utilities or its contractors
Although some data is publicly available on the Fort Collins GIS department web site, all data
required from this effort will be provided by Fort Collins Utilities to provide a clean data
transfer.
4.0 Infrastructure Modeling
Area infrastructure will be imported into the geospatial model from street centerline,
hydrographic, and natural area shapefiles provided by Fort Collins Utilities. (See figure below.)
Figure 1 — Fort Collins Street, Hydrographic, and Natural Area Data
These data will provide geographic references as well as providing areas that should be excluded
during the substation site selection process. For example, it would be unfortunate to site a
substation in the middle of a hydrographic feature.
5.0 Zoning and Parcel Data Modeling
The land use / infrastructure / load density model will also incorporate zoning and parcel data
representations for load density. These shape files will be provided by Fort Collins Utilities and
will be coded with the ultimate load density for each parcel or zoning area. A sample import of
parcel outlines and corresponding zoning data are shown in the figures below.