Eminent Domain Data

The Eminent Domain Data table includes information about the entities that have reported to the Comptroller’s office, their contact information, and whether they have used their eminent domain authority through filing a condemnation petition. Each report includes a unique ID number that can be used to reference data in the Provision Data and Project Data tables. The data included in the reports was submitted by the entities, and entities are required to update the data within 90 days of changes to their information. The Comptroller’s office is not able to guarantee the accuracy of the data.

The table is updated daily and includes entity names, entity types, phone numbers, addresses, email and web addresses, and points of contact. Each report specifies whether the entity used their eminent domain authority by filing a condemnation petition in the preceding year. If the report was filed by a third party, the third party’s name, contact information, and relationship to the entity is also listed.

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-data-cvjb-eurw\".\"eminent_domain_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.