HomeMy WebLinkAboutResolutions - 2020.11.19 - 33878MISCELLANEOUS RESOLUTION #20559 November 19, 2020
BY: Commissioner Penny Luebs, Chairperson, Health, Safety and Human Services Committee
IN RE: COUNTY EXECUTIVE/INFORMATION TECHNOLOGY - PUBLIC SAFETY TRANSPARENCY
DASHBOARD PROJECT (CLEMIS)
To the Oakland County Board of Commissioners
Chairperson, Ladies and Gentlemen:
WHEREAS Oakland County desires to be a leader in transparency of public safety data; and
WHEREAS Oakland County Executive David Coulter recommended this transparency in the submission of
the Three -Year County Budget 2021-2023 on July 1, 2020; and
WHEREAS the Information Technology Department CLEMIS Division released a Request for Proposal
(RFP) to select a vendor to offer Oakland County CLEMIS police agencies assistance to design
transparency dashboard websites using CLEMIS and department data so that police statistical data
including citations, arrest and crash incidents are available to the general public; and
WHEREAS the CLEMIS database contains CLEMIS agency member statistical data on individual agency
Citations, Arrests, and Crash Reports; and
WHEREAS the RFP included design and hosting CLEMIS agency Transparency Dashboard websites in a
cloud environment; and
WHEREAS Altovista was selected by the RFP evaluation team to create Public Safety Transparency
Dashboard websites for CLEMIS agencies willing to participate; and
WHEREAS CLEMIS will provide a monthly datafile to Altovista containing Citation, Arrest and Crash
statistical data for those agencies choosing to participate; and
WHEREAS CLEMIS and Altovista will design a standard base Transparency Website based on the data
available in the CLEMIS database for use by all CLEMIS agencies; and
WHEREAS the estimated total start-up project cost is $250,500; and
WHEREAS Oakland County will pay $4,000 each for up to 42 Oakland County CLEMIS agencies for the
first year of service for a total of $168,000; and
WHEREAS CLEMIS Development hours are calculated at $82,500 to assist with project delivery; and
WHEREAS Non -Oakland County CLEMIS agency members will be billed for service directly by Altovista if
they choose to participate; and
WHEREAS Altovista will provide CLEMIS agency members training and documentation at no additional
cost; and
WHEREAS CLEMIS agencies will have the opportunity to customize their standard website with specific
agency data at an additional charge paid directly by the agency to Altovista; and
WHEREAS the Oakland County CLEMIS agencies will determine if they want to continue to provide their
Transparency Dashboard website to the public by paying the annual fee to Altovista directly after this
Oakland County initial funding has expired; and
WHEREAS funding in the amount of $250,500 is available for transfer from the General Fund Assigned
Fund Balance for Technology Replacement/Hardware (GL# 383448) to cover project start-up costs
NOW THEREFORE BE IT RESOLVED that the Oakland County Board of Commissioners authorizes
the appropriation of $250,500 from the General Fund Assigned Fund Balance for Technology
Replacement/Hardware (GL Account #383448)—for the Public Safety Transparency Dashboard
Project.
BE IT FURTHER RESOLVED that the budget be amended as detailed below:
GENERAL FUND #10100 FY 2021
Revenue
9010101-196030-665882 Planned Use of Balance L250,500
Total Revenues $_250,500
Expenditures
9010101-152010-788001-53500 Transfer Out—CLEMIS Fund L250,500
Total Expenditures 1250,500
CLEMIS FUND (#53500)
PUBLIC SAFETY TRANSPARENCY DASHBOARD PROJECT #100000003296
Activitv GLB Analvsis GLB
Revenue
1080301-116020-695500-10100 Transfer In — General Fund
$250,500
Total Revenues
$250,500
Expenses
1080301-116020-730373
Contracted Services
$168,000
1080301-116020-773630
Information Technology Dev
L82,500
Total Expenses
$250,500
Chairperson, on behalf of the Health, Safety and Human Services Committee, I move adoption of the
foregoing resolution.
A'j-" C-
Commission Penny Luebs, District #16
Chairperso , ealth, Safety and Human Services
Committee
HEALTH, SAFETY AND HUMAN SERVICES COMMITTEE VOTE:
Motion carried on a roll call vote with Gingell absent.
FINANCE AND INFRASTRUCTURE COMMITTEE VOTE:
Motion carried unanimously on a roll call vote
Resolution #20559
November 19, 2020
Moved by Long seconded by Luebs the resolutions on the Consent Agenda be adopted.
AYES: Gingell, Hoffman, Jackson, Kochenderfer, Kowall, Kuhn, Long, Luebs, Markham,
McGillivray, Middleton, Miller, Nelson, Powell, Quarles, Spisz, Taub, Weipert, Woodward, Zack,
Gershenson. (21)
NAYS: None. (0)
A sufficient majority having voted in favor, the resolutions on the Consent Agenda were adopted.
4i-,�aL
1 HEREBYAPPROVE THIS RESOLUTION
CHIEF DEPUTY COUNTY EXECUTIVE
ACTING PURSUANT TO MCL 46,s59A (7)
STATE OF MICHIGAN)
COUNTY OF OAKLAND)
I, 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 November 19,
2020, 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 this 191h day of November, 2020. (� �
Lisa Brown, Oakland County