From a 500-row sample across 30 columns.
updateddatecreateddatetreepointglobalid+10updateddatecreateddatecloseddate+8updateddatecreateddate:@computed_region_efsh_h5xi+9Mappable — Socrata point column `location`.
Open on the map →| objectid | inspectiontype | inspectionstatus | inspectiontpcondition | inspectiontpstructure | treepointdbh | treepointglobalid | plantingspaceglobalid | servicerequestglobalid | geometry | globalid | inspectiondate |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 22814879 | Level 2 | Closed | Fair | Full | 28 | 16863D42-71CD-44E1-9303-0C5A362CF433 | 66DB2F88-E668-41AB-9BD8-089EC86BE6C1 | 2FE4AF95-784A-4145-A9EA-A50C3497CF0C | POINT (1005341.6002085656 175104.972291857) | 1B48DCE4-4EC8-4A09-9A0F-005BF4A3FE0E |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
objectid | integer | Unique identifier for each inspection | 0% | 262249922819729631233042 |
inspectiontype | categorical | Type of inspection | 0% | Level 2Level 1General - Planting Spaceof 5 |
inspectionstatus | categorical | Indicates if inspection has been completed, is awaiting reinspection, or has not been completed | 0% | ClosedReinspectionOpenof 3 |
inspectiontpcondition | categorical | Condition of tree at the time of inspection | 10% |
GET /api/datasets/4pt5-3vv4 GET /api/datasets/4pt5-3vv4/quality GET /api/datasets/4pt5-3vv4/related GET /api/columns?dataset=4pt5-3vv4
createddate:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer+4updateddatecreateddate:@computed_region_efsh_h5xi+8:@computed_region_efsh_h5xi:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer+3:@computed_region_efsh_h5xi:@computed_region_yeji_bk3q:@computed_region_f5dn_yrer+3globalidobjectid| 2024-01-05T18:55:54.000 |
| 24181205 | Level 2 | Closed | Fair | Full | 4 | 401B362A-5B5B-4F1D-803F-D12FFEE5E95B | B99B1475-30D6-4C05-979C-5213E6404204 | — | POINT (997358.65062522888 203584.91104185581) | 376B6A76-DECE-42F0-AB64-01F6C8327F52 | 2024-05-20T14:35:19.000 |
| 6622748 | Level 1 | Closed | Good | Full | 8 | EEB2D030-4C1A-404F-955F-9D9260D71FE7 | 9E690A61-7CB4-47E9-B4E3-6C91AA28083B | — | POINT (946926.91979189217 140263.14645852149) | FB0E24FA-CD3B-4B69-B595-00ACE4248151 | 2017-11-03T10:12:22.000 |
| 18404347 | Level 2 | Closed | Fair | Full | 16 | E538BED5-8DDC-4AB3-8700-3814BDB3D901 | DAFD8FE1-ECAE-4CC4-B429-47D1A8320DFA | — | POINT (994779.23312522471 189915.00500018895) | 4F120CBD-7768-4157-ADDF-012F0AE91B92 | 2022-08-24T04:00:00.000 |
| 11815870 | Level 2 | Closed | Dead | Full | 8 | 29187909-CBFB-418E-AF6C-6F5B4DA438AD | B46784FF-A436-4A54-8967-CE51E36855F2 | 273D20AB-9DCF-4256-A010-9C2D7CC652FD | POINT (984639.23437522352 192017.13208352029) | DFF95D56-BCBF-4EBB-AEA4-01462799BD60 | 2020-10-07T15:01:18.000 |
| 26326787 | Level 1 | Closed | Unknown | Shaft | 3 | DAA28376-3E22-433D-A901-036F36CB222E | 9FDA8EAE-771B-487B-970C-516258C4CBE2 | — | POINT (1002012.6433335692 183722.1231251806) | F51A171A-9E48-4C99-BF18-00DC309B0FA8 | 2025-01-13T17:31:58.000 |
| 17369694 | Level 2 | Closed | Fair | Full | 9 | F9BEDCA2-2C41-444A-A9D1-EC4B304F1CE0 | 72809D6E-B16C-4598-9B89-7952A3549E34 | FF609C30-30ED-41DB-9DC4-C355CE05D4F4 | POINT (997992.57916688919 179151.5341668427) | 4D959AE8-9DF9-4E9D-8FA7-017E223B5E6E | 2022-06-02T17:48:10.000 |
| 22600948 | Level 2 | Closed | Good | Full | 10 | 3B017E39-ABD9-48A9-B0E1-F217D28E2DFB | FAFD8A01-347E-4A49-BB0A-DE63928F8D16 | — | POINT (991223.37291689217 187064.74083352089) | F6EE7955-62B2-49DF-B227-0058B492F4EA | 2023-12-13T21:22:51.000 |
| 5544588 | General - Planting Space | Closed | — | — | — | — | 7716D84B-F085-412B-832B-45E338F8A69D | — | POINT (1047346.2195835561 222146.98354184628) | 9017E95D-CFEC-4F87-BA92-003EFF4FF3EF | 2017-01-30T09:46:24.000 |
| 21028614 | Level 2 | Closed | Fair | Full | 12 | 9B7F2608-79E5-4666-AFAA-3F69F489CE71 | A46CA113-A558-45E8-8E1C-BAB3A560B92F | — | POINT (1021805.5233335644 262903.33875018358) | A5A59F92-7308-4B62-86B8-016F5ED29FFC | 2023-07-12T14:29:57.000 |
Showing 12 of 21 columns. All of them are listed below.
GoodFairDeadinspectiontpstructure | categorical | Structure of tree at the time of inspection | 10% | FullShaftLiability Releaseof 5 |
treepointdbh | text | Diameter at breast height of tree at the time of inspection | 14% | 365 |
swtreeconditionrating | categorical | Condtion of tree during sidewalk inspection | 97% | 431of 16 |
swlocationrating | text | — | 97% | 124 |
swclearancerating | text | — | 97% | 4320 |
swdamagerating | text | — | 97% | 534 |
swdamagedflagstonesrating | categorical | — | 97% | 543of 16 |
swratingtotal | text | — | 97% | 818076 |
treepointglobalid | text | Unique identifier for tree point associated with inspection | 11% | 61BA2037-7323-4FDC-8FF5-…EE8B4ED7-BBFA-4647-98C7-…374CBE69-0CAB-49EE-99BA-… |
plantingspaceglobalid | text | Unique identifier for planting space associated with inspection | 0% | F92C63E0-5A3C-4968-BAE2-…E253FB9E-0965-4FEB-B26F-…6E7BCB93-DF1E-4D90-9324-… |
servicerequestglobalid | text | Unique identifier for service request associated with inspection | 75% | 35103058-D72D-401C-8D34-…1AE19668-DA14-4373-ABED-…327CFF55-8B8D-4BF9-88F9-… |
geometry | text | Geometry for planting space in well known text | 0% | POINT (991497.419583559 …POINT (1026328.013958558…POINT (998075.624166891 … |
globalid | text | Unique identifier for each inspection | 0% | 3663BE72-CE63-4D62-B398-…E4BA597E-3770-4239-A1CA-…835FDC9D-4E83-484A-AE7F-… |
inspectiondate | datetime | Date inspection was performed | 0% | 2020-08-12T16:47:43.0002020-08-12T04:00:00.0002020-02-03T05:00:00.000 |
closeddate | datetime | Date inspection was closed | 1% | 2024-04-16T19:34:52.0002024-12-17T20:37:22.0002020-08-12T16:47:43.000 |
createddate | datetime | Date inspection was created | 0% | 2024-04-16T19:34:52.0002024-12-17T20:37:22.0002020-08-12T16:47:43.000 |
updateddate | datetime | Date of last update to inspection | 33% | 2020-05-26T15:00:00.0002024-12-03T12:00:00.0002024-01-01T16:10:11.000 |
parentinspectionglobalid | text | Unique identifier of inspection that triggered a reinspection | 98% | FF8D425B-247B-4D97-BDAC-…F562AD2A-4805-464D-B66C-…B7C482C6-3A2F-41C2-9539-… |
reinspectiondate | datetime | Date for when reinspection should take place | 98% | 2026-04-15T04:00:00.0002023-11-15T05:00:00.0002018-05-22T09:21:06.000 |
swtotaltrees | categorical | Indicates number of trees at property | 98% | 124of 5 |
location | coordinate | — | 0% | {'coordinates': [-73.973…{'coordinates': [-73.848…{'coordinates': [-73.950… |