Open Data Portal Tutorial
OPEN CDTFA was created to promote openness, transparency, and accountability of state government by providing high-value government data.
Data Portal Home Page
Explains OPEN CDTFA and provides links to resources as well as images of default charts.
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).
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.
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.
Inside of catalog page once the user clicks a subcategory to expand it, links to the individual datasets will be listed.
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.
The Charts link directs the user to a charts page where data is presented graphically in pie, line, and bar charts.
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.
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.
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 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.