HomeMy WebLinkAboutResolutions - 2022.07.19 - 37484BOARD OF COMMISSIONERS
July 19, 2022
MISCELLANEOUS RESOLUTION #22-258
Sponsored By: William Miller III
Facilities Planning & Engineering - Resolution - ArcGIS Indoors Software Implementation
Chairperson and Members of the Board:
WHEREAS Facilities Planning & Engineering is responsible for space tracking and reporting for County
owned facilities; and
WHEREAS space allocation documents are developed and updated in multiple applications that require
manual, redundant, and time-consuming operations; and
WHEREAS GIS Indoors is a mapping system designed to centrally organize building data; and
WHEREAS by utilizing GIS Indoors, redundant operations can be eliminated reducing the time required for
space changes; and
WHEREAS the use of GIS Indoors will allow efficiency and cost savings in real-time viewing of space, allow
for asset tracking of building spaces, equipment, and systems aiding in preventative maintenance and repairs;
and improve communication regarding space use with County departments.
NOW THEREFORE BE IT RESOLVED the Oakland County Board of Commissioners approves the transfer
of the amount totalling $250,000 from the General Fund Non -Departmental Transfers (9090101) Technology
Projects -One Time (760180) to the Information Technology Fund (#63600) for the ArcGIS Indoors Software
Implementation Project.
BE IT FURTHER RESOLVED that the Oaklarid County Board of Commissioners approves the following
budget amendment as detailed in the attached Schedule A..
Chairperson, the following Commissioners are sponsoring the foregoing Resolution: William Miller III.
Date: July 19, 2022
David Woodward, Commissioner
au
Date: July 25, 2022
Hilarie Chambers, Deputy County Executive 11
41��
Date: July 26, 2022
Lisa Brown, County Clerk / Register of Deeds
COMMITTEE TRACKING
2022-07-13 Economic Development & Infrastructure - 'recommend to Board
2022-07-19 Full Board
Motioned by Commissioner Kristen Nelson seconded by Commissioner Michael Gingell to adopt the attached
Resolution: - ArcGIS Indoors Software Implementation.
Yes: David Woodward, Michael Gingell, Michael Spisz, Karen Joliat, Kristen Nelson, Eileen Kowall,
Christine Long, Philip Weipert, Gwen Markham, Angela Powell, Thomas Kuhn, Chuck Moss, Marcia
Gershenson, William Miller III, Yolanda Smith Charles, Charles Cavell, Penny Luebs, Janet Jackson, Gary
McGillivray, Robert Hoffman, Adam Kochenderfer (21)
No: None (0)
Abstain: None (0)
Absent: (0)
Passed
ATTACHMENTS
1. GISlndoorsMemo.FMO.7.13.22
2. FPE-ARCGIS Schedule A_updated
3. FPE-ARCGIS Schedule A_updated
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
1, Lisa Brown, Clerk of the County of Oakland, do hereby certify that the foregoing resolution is a true and
accurate copy of a resolution adopted by the Oakland County Board of Commissioners on July 19, 2022, with
the original record thereof now remaining in my office.
In Testimony Whereof, I have hereunto set my hand and affixed the seal of the Circuit Court at Pontiac,
Michigan on Tuesday, July 19, 2022, 1
Lisa Brown, Oakland County Clerk/Register of Deeds
40"AUANDF
CO U NTY MICHIGAN OAKLAND COUNTY EXECUTIVE DAVID COULTER
FACILITIES MANAGEMENT
Jason C. Warner, Manager
Facilities Planning & Engineering
Oakland County, MI
(248) 431-1622
warnerj@oakgov.com
TO: OAKLAND COUNTY BOARD OF COMMISSIONERS
FROM: JASON WARNER, MANAGER FACILITIES PLANNING & ENGINEERING
SUBJECT: ARCGIS INDOORS SOFTWARE IMPLEMENTATION
DATE: S/16/22
Oakland County Facilities Management (FM), Facilities Planning & Engineering (FPE) oversees
and maintains space allocation reporting for county owned and leased facilities. Historically,
space allocation information reports are generated through use of specialized software,
AutoCAD, and several excel worksheets. Updates to building spaces require manual
manipulation of several files which is time consuming. Space verification and reporting to Fiscal
services and county departments is delivered by non -interactive PDF and excel files.
Over the past few years Information Technology (IT) and FPE have entered data into Geographic
Information System (GIS) applications, ArcGIS, to make reporting procedures and updating
more efficient. The use of ArcGIS and its supporting data allows for information sharing by use
of a common system saving time and providing a platform that is easier to use for county
departments.
ArcGIS has provided several benefits, but updates are often repetitive in AutoCAD and ArcGIS.
The ArcGIS Indoors application is designed to link these two applications. ArcGIS Indoors will
allow for updates in one location that will be common through all applications. This will greatly
reduce the time required for updates. Also, ArcGIS Indoors will greatly increase the potential for
creating dashboards for country department use to view space allocation and several other
building attributes such as building finishes and condition.
The ArcGIS Indoors application is also intended to be used as a Building Information Modeling
(BIM) solution for Facilities Management. This will allow for asset tracking of building spaces,
equipment, and systems to aid in preventative maintenance and repairs. Further, ArcGIS Indoors
will provide a wayfinding solution to county departments and the public by creation of dashboards
or maps to aide in navigation throughout the County Campus.
One Public Works Drive I Public Works Building — 95W I Waterford, MI 483281 Fax (248) 452-2250 1 OakGov.com
IT and FPE are planning to complete implementation, training, and application launch by Spring
of 2023.
2100 Pontiac Lake Road I County Executive Building 41W I Waterford, MI 48328 1 Fax (248) 452-9172 1 OakGov.com
Oakland County, Michigan
FACILITIES MANAGEMENT-ARCGISINDOOR SOFTWARE IMPLEMENTATION
Schedule W' DETAIL
Budget
wnd
etlger
Funtl#
ARCISC#
Program#
Pr(jROD)
Region
Affiliate
Account
WE
Fund Name
Division Name
(END)
Cost Gelder lCCNI#
(Rg50)
(PRG)
Grant ID (GRN)#
(PROD)
(REG)
(BEA)
Summary
Account Tilde
E
General Funtl Non Dep:mNmtal Transfers
FN013ID3
CCN9090101
SC755D18D
PRG196D3D
760000
Technology Pm,vON-Oae Time
E
General Fund Non Do, novel.
FNDt0100
CCN9010101
SC788uD1
PRG196D30
EFAB350D
78KOI
Transfer Out—rTFund
Total EvpanCnwee
R
Information Technology ITAdmNistra0on
FNDS3600
CCN1050101
RC695500
PIBFA10100
695500
Transfer In - Gen Fund
R
In formation Technology ITAdmimstrahon
FND53500
CCNIOSO101
RC655552
PRG152000
665882
Planned llse of Balance
Total Revenues
E
Infmmatmn TechnDlogy IT Application services
FND635DO
CCNIO80201
S0731458
PRGi52D1D
730000
Profeermal Services
E
Information Technology IT Application Services
FN063600
CCN1080201
SCnD373
PRG15201D
730000
Contracted Services
E
Inlormotion TechnWt,y IT Application Servcea
FND53600
CCN1080201
sCT31780
PRG152DID
730000
Soflrvare Mamtenanw
Total EVenses
Fr 2322
FY2023
Fy 20M
Fr 2azs
Amendment
Amendment
Amendment
Pmendmerrt
s (25a,000.00)
9 -
$ -
$ -
250.000 00
-
-
-
$
s 230,000.00
S
8
8 -
n40000.Om
120000.00
zO O00.00
zo 000.00
5 110,000.00
$ 12000OXO
s 2a000.00
g 20.000.00
s ss,000.0a
g T0,0000o
s -
35.00000
30 00D 0a
-2a
F12
o00.00
20 0OO 00
20.000 00
DOD 00
$ 1_go03 Do
5 120,000.03
S 20,000.00,00D00