Eminent Domain Project Data

The Project Data table includes all projects that entities claim they have eminent domain authority to undertake. Also included in the table are entity names, report years, and a unique report ID number. The ID number can be used to cross-reference the project data with the Eminent Domain table.

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 \"texas-gov/eminent-domain-project-data-x7n3-dc7h\".\"eminent_domain_project_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.