Data Warehouse and Open Data Portal
Mayor Jorge O. Elorza and the Providence City Council are united in their belief that open and transparent government is essential for the citizens to make informed decisions and hold officials accountable for the conduct of the people’s business. Mayor Elorza and the Providence City Council are committed to open government, transparency and establishments of new standards, as well as mechanisms to enact those standards, and will facilitate the expansion of the public’s access to government and information.
In order to meet these goals, the Information Technology Department has developed a series of projects for an internal data warehouse, a web based data input and tracking system, and public facing open data portals.
November, 2012 – Providence issues a Request for Proposals from vendors to design, develop and deploy the data warehouse and portal. Interested vendors should contact the City of Providence Purchasing Department for a copy of the RFP.
January, 2013 – The City of Providence has awarded JD Software, Inc. the contract to develop the Data Warehouse and Open Data Portal project. IT held a series of meetings with the vendor and City staff to kick off the project by the end of the month.
March, 2013 – Work continued on the development of an internal survey application to gather performance metrics from city departments. Additionally, the city has contracted with Socrata to provide hosting services on its Open Data Portal platform. Socrata has deployed a test site, and work began to publish internal production data to the public portal.
June, 2013 – Providence became the first municipality in Rhode Island to launch an Open Data Portal, increasing the transparency, accountability and accessibility of public data. The Providence Open Data Portal was launched with an initial collection of 25 datasets. Work is continuing on the development of the data warehouse, with links to production applications and publication to the data portal. The city will consider additional datasets for publication on a quarterly basis.
March, 2014 – Providence launches its new Open Meetings Portal to publish detailed public meeting agendas, minutes and recordings. Beginning with City Council committees and expanding to include all public boards, the site provides a searchable record of the proceedings of municipal meeting groups.
April, 2015 – The City of Providence launches the new Open Budget Portal, providing an easy to navigate site to explore the complex revenue and operational City budget. The site breaks out expenditures by department, expense type and account, and provides meaningful graphs and lists of budget changes over the years.
January, 2016 – Providence launches a public Open Records Portal, to centralize and streamline the Open Records request process. On this site, public inquiries can be searched and posted, with responsive documents and data visible to all.
June, 2016 – The City of Providence continues to advance its Open Data initiative with the launch of the new Open Checkbook Portal. This informative site provides City employees, vendors and the public with a simple tool to search and detail payments made to City business partners.Open Data Portal