cityofnewyork-us/forestry-tasks-45sb-srb5
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 18 days ago
Indexed 5 hours ago

Forestry Tasks

Tasks are specific actions that are sub-components of a Work Order. Some work, such as that performed by in-house crews, require at least one task for the purposes of accounting for labor hours. Tasks are typically used to indicate remaining work for jobs that did not get completed in one session (1 day).

User guide: https://docs.google.com/document/d/1PVPWFi-WExkG3rvnagQDoBbqfsGzxCKNmR6n678nUeU/edit?usp=sharing

Data dictionary: https://docs.google.com/spreadsheets/d/1yMfZgcsrvx9M0b3-ZdEQ3WCk2dFxgitCWytTrJSwEAs/edit?usp=sharing

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 \"cityofnewyork-us/forestry-tasks-45sb-srb5\".\"forestry_tasks\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • forestry_tasks
     
     
     
     
     
Upstream Metadata