Socrata Help

Provided here are helpful tips on how to use the features on the State of Hawaii’s open data portal site, data.hawaii.gov, which is currently powered by Socrata.

Below is how the dataset will look on data.hawaii.gov after it is opened.  Use the horizontal scroll bars to scroll left and right to view all fields in a record, and use the vertical scroll bars to scroll up and down to view all records in the dataset.

Fullpage

There are many data manipulation tools that you can use on the data.hawaii.gov site. For example, you can create your own filtered views, geocoded maps, pie charts, etc. Your options are only limited to your creativity.  You can create things for your temporary use or you can save them for the public to view.  Before you are allowed to save, you must first create a Socrata account which is free and easy to do.  Click on ‘Sign In’ below the top blue bar and follow the instructions to create your own personal account.  All original datasets on this site are read-only so there is no risk in damaging them.

Icons What it does
RSS

Sign-up here to be informed of updates to this dataset via RSS feeds or email.
share2

Allows you to share the dataset through Facebook, Twitter or Email.
list

Click any of these options to view the dataset in different formats: table, rich list or single row.
find

Allows you to search all fields within the dataset. Type in search term and press enter.
manage

Allows you to show or hide columns in the dataset. You can also rearrange the columns in the order you prefer.
views

Provides a list of filtered views, charts or maps that are associated with this dataset. In this example, there are 39 views associated with this dataset.
filter

Allows you to sort and filter the data in the dataset according to your preference:

  • Sort & Roll-up: Group rows together and summarize data with a roll-up or a drill-down. Also, you can sort the dataset by one or more columns.
  • Filter: Filter the dataset based on contents.


    filterby

Filter the dataset by selecting a column, choosing a condition, and entering a parameter.
visualize

Provides you with four (4) options to compile and organize the data into a graphical representation:

  • Customize: Conditional Formatting allows you to change the background color of rows based on a custom criteria. Each row will be assigned the color of the first matching condition.
  • Calendar: Views with dates can be displayed in a monthly calendar format.
  • Map: Views with locations can be displayed as points on a map. You have a choice of various map formats. Socrata will geocode your locations to the points on the map.
  • Chart: View data in a variety of chart formats such as a pie chart, column chart, area chart, etc.
export

Provides you with three (3) options to export the dataset to your computer:

  • API: Access the dataset via Socrata Open Data API (SODA). This allows software developers to access data hosted in Socrata data sites programmatically.
  • Print
  • Download: Download a copy of this dataset in a specific format. Available formats are xls, pdf, csv and more.
discuss

Allows you to view the discussion feed relating to conversation and activity on a dataset. Also, this is where you can leave a comment regarding a dataset for the Commission to see.
embed Allows you access to the Social Data Player which enables you to publish this dataset on the Internet at large. It provides html code that you can add to your website which is a link to the dataset on the Socrata site.
about Provides you with further information related to the dataset.
column By clicking on a column title, then clicking on the red arrow box, you can access functionality that can be done on a column. You can sort the dataset by the selected column, filter the dataset by the column, hide the column, or edit the column’s properties.