Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Forestry Tasks

45sb-srb5Environment15 columns
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
View on NYC Open Data↗

Quality

C75.4 / 100

From a 500-row sample across 15 columns.

completeness37/ 25% weight
consistency63/ 20% weight
accuracy99/ 20% weight
timeliness99/ 15% weight
usability95/ 20% weight

Related datasets

  • Forestry Work Orders0.35
    joins onobjectidglobalidcrewglobalid
  • Forestry Tree Points0.34
    joins onobjectidglobalid
  • Watershed Water Quality Data0.33
  • Drinking Water Quality Distribution Monitoring Data0.32
  • DSNY Litter Basket Inventory0.31
    joins onobjectid
  • DSNY Special Waste Drop-off Sites0.31

Sample rows

objectidtasktypeworkorderglobalidglobalidtaskentitycompleteddate
14217796Prune Clear Electric WiresB9F9EC32-1940-4A38-A5AE-7BCA3487363DE666A68E-D182-4C36-91B5-68CB15D3CD8E3.0—
14323350Remove Hanging Limb01556FB6-AA7B-47E9-85B9-F1B8AD8A2F9B93EF0E48-E3BA-411A-BC63-2D8FDCDB820D3.0—
13699959Utility Removal1FDDFCC3-A310-4FAA-A8EC-196635520A7E7522B176-4DBF-47E3-88DC-2C25941A18EE

Columns

15 queryable · 15 profiled

The machine field names SoQL needs, with the publisher's own description of each.

FieldTypeDescriptionNullValues
objectidinteger—0%1061418111125414201395
tasktypetext—0%Remove TreePick-up LimbRemove Hanging Limb
completeddatedatetime—2%2020-08-11T04:00:00.0002020-08-10T04:00:00.0002020-08-08T04:00:00.000
workorderglobalidtext—0%C94228FD-70EE-437A-BB98-…0C1EBB07-1F07-4980-AE2C-…24FE3948-877B-4B04-B2E0-…

Query this from your own app

GET /api/datasets/45sb-srb5
GET /api/datasets/45sb-srb5/quality
GET /api/datasets/45sb-srb5/related
GET /api/columns?dataset=45sb-srb5
joins on
globalid
  • Asset Management Parks System (AMPS) - Work Orders0.31
  • Urban Park Ranger Animal Condition Response0.30
    • 3.0
    —
    14015781Utility Removal86103EC1-BC94-4C3F-9F59-A1096A5120EEFB07D35D-CDBA-47EE-A16C-2A17B4B6D7AE3.0—
    14284034Utility RemovalB1A5B392-DA6F-414C-B273-EECC243C03D9E37CCDC0-1842-4376-9F04-726A9B0BDBF43.0—
    9216185Prune Clear Electric WiresBFB25A6C-6A05-4A9B-B156-93987F0BFC22A73E4736-DD52-4A3A-8484-CEF07D02ACF63.0—
    10180949Prune DeadwoodF9DA1532-77B8-47A5-84B2-F627AEA0EBE7B25FB301-3634-4E65-8CB9-A2E8D3F9B0550.0—
    11534620Prune Deadwood0FAFB2B6-F25F-4E86-96CA-45A7E6D3248CF9A8773D-B9F4-4F7F-ACCE-9E70D7FC73720.0—
    11555613Prune Clear Electric WiresA75F94E1-24E0-4161-B387-3A6B9B61F3B45E8B5471-57F9-4AD8-A19A-6E738D5395273.02024-04-25T05:30:33.000
    11777055Prune Clear Electric WiresAC8B42BC-7DA3-4EAB-98E8-6767B6ABF78878D0F9E0-7DC4-427E-91FE-8736676FC6C03.0—
    globalidtext—0%EE09B6DC-F72E-4385-A5B5-…2E3AB8B0-AD8D-4EA2-B2AD-…8AE88F2D-930D-4126-A4D9-…
    crewglobalidtext—19%A2637397-0208-4AEE-B7C7-…F6B60E6A-DE37-46D9-A96F-…EFAD3CA7-DC7F-4551-9EF7-…
    taskentitycategorical—3%0.016.03.0of 18
    staffcpcccoordinate—78%1.00.02.0of 11
    staffcpcoordinate—78%3.02.01.0of 15
    staffapswcoordinate—78%0.01.02.0of 10
    labortimecoordinate—80%0.250.50.75
    traveltimecoordinate—81%0.250.50.0
    staffcpwcoordinate—82%0.01.02.0of 7
    staffforestercoordinate—82%0.01.02.0of 10
    staffgardenercoordinate—82%0.03.04.0of 7