OpenHamilton Transparency Portal
- What is OpenGov? OpenGov is an open data platform which helps government entities display information over a multi-year period. OpenHamilton's default view is of our multi-year adopted budget expenses itemized departmentally.
- Can I select more than one fund or department? Yes. Use the "Filtered By" area in the left-side panel to make specific selections. View our "Tips" tab for navigation information.
- Can I see the data in a different graph? OpenHamilton is customizable on the OpenGov platform. In the upper right-hand corner are options to change the graph to an area graph by percentage, a stacked area graph, a line graph, a pie graph, and a bar graph. View the data in table form below each graph.
- Why am I seeing spikes in one year? Spikes in individual years can be due to unexpected expenses (such as the replacement of failed equipment, a hard winter, a capital project, etc.) or changes in revenue. Drill-down using the menu options to learn more about those changes. View our "Tips" tab for navigation information.
- I'd like to better understand government accounting. Can OpenHamilton help me? Yes. Choose the "Help" drop-down and select "Multi-Fund Accounting 101" to view a user-friendly explanation of multi-fund government accounting.
- How do I select the data I want to see? The OpenGov platform allows users to focus on specific data by Fund, Department, or Type. Use the menu in the left-side panel to show revenues or expenses; break down the data by department, fund, and type; and to filter by the fund, department, and type. View our "Tips" tab for navigation information.
- How do I see the actual numbers within the graph? There are two ways to view actual numbers using the OpenGov platform. First, simply hover over any area of the graph to see the amounts for that period. Second, scroll down to view the table below the graph.
- Am I able to save the data I'm reviewing? Yes. Use the "Share" and "Download" buttons in the upper right-hand corner to share via email or social media and to download as a .csv spreadsheet or .png digital image format.
- How do I contact the City of Hamilton through the OpenHamilton Transparency Portal? Choose the "Help" drop-down and select "Contact the City of Hamilton, OH". Enter your name, phone number, email address, and message, then click the "Send" button. We would like to hear from you!
- What is the City's all-funds 2016 Proposed Budget?
- What is the City's 2016 Proposed all-funds budget compared to prior years?
- What are historical General Fund personnel and benefit costs?
- What has the City received historically in State funding?
- What will Public Safety cost each citizen annually?
- What has the City collected historically for hotel/motel tax revenue?
- What are General Fund Income Tax collections?
- What are the annual revenues for the Hamilton Fire Department?
- What are the annual expenses of the Hamilton Fire Department?
- What are the annual tax collections for the City's Fire Levy's?
Learn how to navigate OpenHamilton's Transparency Portal with OpenGovOpenHamilton gives everyone the opportunity to explore the City's historical data in a simple, graphical user interface. Our landing page consists of a default view of the City's current year Adopted Budget by Department and prior years Actual Budget by Department. Hover over any of the colored bars to reveal each department's budget in dollars, as a percentage of the whole budget, and change from the previous year. Use the legend on the right to show more departments and to see which funds or departments are associated with each color. Drill down further by clicking on one of the colors on the graph. Use the "Back" button in the top-left corner to return to the previous view. To focus on specific data, such as a fund, department, or type, look to the left-side menu panel.
The title of the graph is located along the top of the landing page. To the left of the graph are two menus. The default is the "Views" menu, where the user can select statements and questions to view. The second menu is the "Filters" menu, where the user can customize the information displayed in the graphs and charts. Just above these menus are the City of Hamilton's Annual Budget, Balance Sheet, Check Register, Current Year Budget, and the Actual FTE report. These reports can be downloaded by scrolling down to the "Documents" area below.
There are five different types of visual representations of the City's data: a stacked area graph, an area graph by percentage, a line graph, a pie chart, and a bar chart. You can change your view by type at any point by simply selecting the different type of graph representation. The data will automatically convert. These functions are icons represented as a graph type and are located on the top-right menu.
The legend will often show the top-level expenses and revenues. Click on the "Show More" button below the Chart of Accounts to reveal more departments or funds. Accounts may be sorted alphabetically, by account, from largest to smallest and from smallest to largest by selecting the "Chart of Accounts" drop-down menu in the right-side menu panel.
Utilizing the "Help" and "Share" drop-down menus
Use the Help drop-down in the top right corner to:
- View a short How-To Guide with tips on navigating the platform.
- Recall the Welcome Screen.
- View a short Multi-fund Accounting 101 primer with basic information on multi-fund budgeting (how the accounts relate to each other).
- Contact the City with comments or questions about the site.
Use the Share drop-down in the top right corner to:
- Share your customized graph or chart through social media.
- Send a link to your customized graph or chart through email.
- Download an image of the graph or table as a .png file.
- Download a spreadsheet as a .csv file.
Customizing our data
Because the left-panel menu is defaulted on the "Views" menu, click "Filters" to begin customizing our data. There are three options that help users extract the most out of our data: the "Show" drop-down, the "Broken Down By" drop-down, and the "Filtered By" drop-down. These selectors allow our users to specify exactly what breakdown display is desired.
The "Show" Drop-Down
The "Show" drop-down shows data according to revenues, expenses, or revenues versus expenses. Selecting only this filter will show our expenses and/or revenues for all funds and departments.
The "Broken Down By" Drop-Down
View our expenses and/or revenues by Fund, Department, or Type.
The "Filtered By" Drop-Down
When selecting "Filtered By", the data filter pops up and allows you to turn on or turn off selected filters for that category: funds, departments, and type.
The fiscal year can be also be changed to focus more closely on previous years or just the current year.