State Real Property

This dataset contains information on individual properties owned by the State of Connecticut, which is collected and updated annually in March by the Office of Policy and Management. This inventory is maintained primarily for the purposes of payments in lieu of property taxes (PILOT) to the host municipality.

The column "Reference Number" refers to the unique ID for the parcel (if available) and the "Address" column contains the physical address when assigned by the municipality, otherwise the street name is provided.

This data is updated each March.

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 \"ct-gov/state-real-property-meyk-xprb\".\"state_real_property\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.