Open Data Portal Tutorial
OPEN CDTFA was created to promote openness, transparency, and accountability of state government by providing high-value government data.
To access the Data Portal, the user must click on the checkbox to agree to the open data use policy (terms of use can be found by clicking the link labeled "policy"). This displays the data categories below the agreement checkbox.
Data Portal Home Page
Explains OPEN CDTFA and provides links to resources as well as images of default charts.
Help Page
A link to the Help Page is available on each page. Once the Help link is clicked the user has the ability to view the Tutorial or read the Frequently Asked Questions (FAQs).
Survey Form
A link to the Survey Form is available on each page. The Survey Form allows the user to rate their experience of the Data Portal.
Agreement checkbox
To access OPEN CDTFA, the user must click on the checkbox to agree to the CDTFA Data use policy (terms of use can be found by clicking policy). This activates the categories listed below the agreement checkbox.
Search Box and Data Categories Icons
Once the user clicks on the agreement checkbox, they may use search box or click on a data category icon to display the data catalog page with data subcategories of datasets.
Subcategories listed
Inside of catalog page once the user clicks a subcategory to expand it, links to the individual datasets will be listed.
Grid link
The Grid link directs the user to the data grid page where the data grid is displayed and the user has the ability to export, filter, and manage data. (More details are explained below)
Grid view export icons
The Export icons allow the user to save or open the data grid in PDF, EXCEL, CSV, and Word formats.
Grid view context menu icon
The context menu icon is placed in the header of every column. Context menu is displayed with a click of the icon. It allows the user to filter, order, and manage the grid. Some numeric data in the grid may be displayed with non-numeric characters such as commas, dollar signs, or percent signs. To execute a filter correctly, do not include these characters in your filter input values.
Charts link
The Charts link directs the user to a charts page where data is presented graphically in pie, line, and bar charts.
Charts view
Charts pages have three tabs to display pie, line, and bar chart. Each chart has customization options. Customize options allow the user to manipulate data and charts while viewing the charts. The user has the ability to save the custom charts as a .pdf file.
Map link
The Map link directs the user to the map page where California counties or cities are displayed and where the user can hover over those counties or cities and view the data records.
Map view
When user opens the page California map is loaded by default. in order to activate map and display the data the user needs to pick the year from the drop down menu right above the map. Then the user can hover over colored counties or cities on the map to view the data records.
API link
API link opens up the popup window with URL strings to machine-readable code for programmatic access to the dataset in JSON and XML formats.
Navigation & Use Policy
The user can click on the OPEN CDTFA Home link to return to the main page. This link can be found below the Category header. The user's acceptance of the use policy lasts the entire session. Once the user closes the web page, the session is no longer active and the user will have to accept the use policy by clicking the check box if they enter OPEN CDTFA through a new web page/session.
