Software Application Portfolio (SB272)

On October 11, 2015, Governor Brown signed SB 272 into law. This bill requires local agencies to publish a list of “enterprise” systems. These are systems that are used across multiple departments or that contain information collected about the public and are systems that serve as original sources of data within an agency.

Certain systems are exempt from disclosure, including:

•Emergency services systems.

•Information technology security.

•Building access.

•Mechanical controls.

This catalog will be reviewed and updated on an annual basis by July 1 of each year. For more information, please visit http://sonomacounty.ca.gov/SB272/.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"sonomacounty-ca-gov/software-application-portfolio-sb272-4juh-m9jm\".\"software_application_portfolio_sb272\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.