Summary of grant data with no filters applied
Strategic Priority, Strategic Result, and Grant Type charts
Location and Grant Status charts
Top 5 organizations
Top 10 organizations
Applying three filters
Switching from bar charts to pie charts
Choosing the data to display in the charts
Drilling down on data in the Strategic Priority chart to view more detailed data
Viewing grant data for an organization
Administrators can add a grant
Administrators can import grant data from a CSV or Microsoft Excel file
Administrators can upload grant data to data.hawaii.gov
Uploading data to data.hawaii.gov...
Successfully uploaded data to data.hawaii.gov
To create an online application that makes it easy for the public to view OHA's grant data.
How We Achieved Our Goal
- By looking at the table and charts, the public can find answers to questions such as "How much money did the University of Hawaii receive from 2013 to 2016?" and "How many Native Hawaiians on the island of Oahu were served by grants in 2015?"
- Organizations can make business decisions based on the data. For example, those that are applying for grants that will help improve the quality of education for Native Hawaiians can look at the data for the previous year and see which location needs more funding in the upcoming year.
- By making grant data available on Hawaii's Open Data Portal, we are helping the State of Hawaii achieve its goal of government transparency. After the data is published, it can be used by other developers who also want to help the state government achieve this goal.
- Apply multiple filters to the grant data in the table and charts
- Export filtered or unfiltered grant data in the table to a CSV, Microsoft Excel, or PDF file
- Switch between bar and pie charts
- Choose the data to display in all the charts
- Drilldown in a bar or pie chart to view more detailed data
- Import grant data from a CSV or Microsoft Excel file
- Upload grant data to Hawaii's Open Data Portal manually or automatically every day at midnight
Quick Start Guide
Go to test-ohagrants.ehawaii.gov.
- Select one or more filters in the left panel to filter out all the grants that do not meet the selected conditions.
- Under Chart Settings, pick the chart type and then the data to display in the charts: amount, total number of people served, or number of Native Hawaiians served.
- Click on a bar or pie slice to open a drilldown chart and view more detailed data. Choose the data to display in the drilldown chart from the dropdown menu below the chart.
- Administrators can add a new grant, import grant data from a CSV or Microsoft Excel file, and also upload grant data to Hawaii's Open Data Portal.
If you are interested in helping us develop the application, please make sure you have the following installed on your development machine first:
- Java 8
- Gradle 4.0
- MySQL 5.7
- Tomcat 8
On the command line, execute the command
gradle eclipse to download and install all
the libraries required to develop the application. The command will also generate the
.project files so you will be able to import the application as an
OHA Grants is a very modern, robust application that uses Spring 4.3.11 on the backend, and Bootstrap, jQuery, and Highcharts on the frontend.
Both files below contain the same grant data. Either can be used to populate the database on your development machine.
- CSV File (MD5: f56ab7f4cb648539cff806f913c3c821)
- Microsoft Excel File (MD5: edf383e8a9df1fa7d1644e11f7353014)
- BJ Peter DeLaCruz (Team Captain)
- Christopher Cosner
- Zheng Fang
- Megan Nichols