State of Oregon Agency Data Inventory

The State of Oregon Agency Data Inventory is an enterprise level inventory that provides a listing of all state agency data inventories, as required in HB 3361(2017), and codified in ORS276A.350-374. This statute requires that state agencies must “create and maintain an inventory of agency information resources,” and include an indication as to whether or not the information or dataset is considered “publishable.” They must then contribute this information to an enterprise level data inventory, maintained by the Chief Data Officer, for display on a centralized open data portal.

For questions about any dataset listed in this inventory, contact the agency directly. For additional information about this inventory or Oregon’s Open Standard, visit Oregon’s Open Data Program. https://data.oregon.gov/stories/s/Oregon-s-Open-Data-Standard/xr2x-d2d7/

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 \"oregon-gov/state-of-oregon-agency-data-inventory-yp9j-pm7w\".\"state_of_oregon_agency_data_inventory\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.