Ask NYC Browse All Data Public Safety Transportation Health Buildings

Sidewalk Management Database - All Tree Damage (ATD)

Sidewalk Management System is used to track and organize inspections, violations and the status of New York City sidewalks.
Tracks properties where all sidewalk defects on the tax lot are due to trees/tree roots (All Tree Defects - ATD)
For more information please visit NYC DOT website: www.nyc.gov/sidewalks

Transportation Department of Transportation (DOT) Dataset j6v2-6uxq 13 fields
DOWNLOAD CSV
Dataset fields
Showing 50 real records
7490
Atdid: 7490 • Atd Number: ATD-3-2677 • Bblid: 548401
Atdid
7490
Atd Number
ATD-3-2677
Bblid
548401
Inspectionid
304573
Inspect Date
2019-10-23T00:00:00.000
Atdissuedate
2019-10-23T00:00:00.000
Cb
18
House Num
2056
Onstname
PEARSON ST.
Atddismissed
No
7491
Atdid: 7491 • Atd Number: ATD-4-3479 • Bblid: 765617
Atdid
7491
Atd Number
ATD-4-3479
Bblid
765617
Inspectionid
304608
Inspect Date
2019-10-30T00:00:00.000
Atdissuedate
2019-10-30T00:00:00.000
Cb
11
House Num
53-10
Onstname
MARATHON PKWY.
Atddismissed
No
7492
Atdid: 7492 • Atd Number: ATD-4-3480 • Bblid: 763155
Atdid
7492
Atd Number
ATD-4-3480
Bblid
763155
Inspectionid
304629
Inspect Date
2019-10-19T00:00:00.000
Atdissuedate
2019-10-19T00:00:00.000
Cb
11
House Num
40-10
Onstname
247TH ST.
Atddismissed
No
7493
Atdid: 7493 • Atd Number: ATD-4-3481 • Bblid: 763161
Atdid
7493
Atd Number
ATD-4-3481
Bblid
763161
Inspectionid
304632
Inspect Date
2019-10-19T00:00:00.000
Atdissuedate
2019-10-19T00:00:00.000
Cb
11
House Num
40-16
Onstname
247TH ST.
Atddismissed
No
7494
Atdid: 7494 • Atd Number: ATD-5-469 • Bblid: 1028953
Atdid
7494
Atd Number
ATD-5-469
Bblid
1028953
Inspectionid
304634
Inspect Date
2019-10-30T00:00:00.000
Atdissuedate
2019-10-30T00:00:00.000
Cb
3
House Num
41
Onstname
LORING AVE.
Atddismissed
No
7495
Atdid: 7495 • Atd Number: ATD-5-470 • Bblid: 1044168
Atdid
7495
Atd Number
ATD-5-470
Bblid
1044168
Inspectionid
304637
Inspect Date
2019-10-30T00:00:00.000
Atdissuedate
2019-10-30T00:00:00.000
Cb
3
House Num
64
Onstname
CLEARMONT AVE.
Atddismissed
No
7496
Atdid: 7496 • Atd Number: ATD-3-2678 • Bblid: 257310
Atdid
7496
Atd Number
ATD-3-2678
Bblid
257310
Inspectionid
304679
Inspect Date
2019-10-29T00:00:00.000
Atdissuedate
2019-10-29T00:00:00.000
Cb
6
House Num
25
Onstname
3RD PL.
Atddismissed
No
7497
Atdid: 7497 • Atd Number: ATD-3-2679 • Bblid: 257308
Atdid
7497
Atd Number
ATD-3-2679
Bblid
257308
Inspectionid
304683
Inspect Date
2019-10-23T00:00:00.000
Atdissuedate
2019-10-23T00:00:00.000
Cb
6
House Num
27
Onstname
3RD PL.
Atddismissed
No
7498
Atdid: 7498 • Atd Number: ATD-4-3482 • Bblid: 750084
Atdid
7498
Atd Number
ATD-4-3482
Bblid
750084
Inspectionid
304761
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
11
House Num
204-12
Onstname
45TH RD.
Atddismissed
No
7499
Atdid: 7499 • Atd Number: ATD-4-3483 • Bblid: 750078
Atdid
7499
Atd Number
ATD-4-3483
Bblid
750078
Inspectionid
304783
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
11
House Num
204-04
Onstname
45TH RD.
Atddismissed
No
7500
Atdid: 7500 • Atd Number: ATD-4-3484 • Bblid: 742386
Atdid
7500
Atd Number
ATD-4-3484
Bblid
742386
Inspectionid
304787
Inspect Date
2019-11-02T00:00:00.000
Atdissuedate
2019-11-02T00:00:00.000
Cb
8
House Num
61-29
Onstname
170TH ST.
Atddismissed
No
7501
Atdid: 7501 • Atd Number: ATD-4-3485 • Bblid: 742388
Atdid
7501
Atd Number
ATD-4-3485
Bblid
742388
Inspectionid
304793
Inspect Date
2019-11-02T00:00:00.000
Atdissuedate
2019-11-02T00:00:00.000
Cb
8
House Num
61-27
Onstname
170TH ST.
Atddismissed
No
7502
Atdid: 7502 • Atd Number: ATD-4-3486 • Bblid: 742384
Atdid
7502
Atd Number
ATD-4-3486
Bblid
742384
Inspectionid
304794
Inspect Date
2019-11-02T00:00:00.000
Atdissuedate
2019-11-02T00:00:00.000
Cb
8
House Num
61-31
Onstname
170TH ST.
Atddismissed
No
7503
Atdid: 7503 • Atd Number: ATD-4-3487 • Bblid: 763235
Atdid
7503
Atd Number
ATD-4-3487
Bblid
763235
Inspectionid
304802
Inspect Date
2019-10-12T00:00:00.000
Atdissuedate
2019-10-12T00:00:00.000
Cb
11
House Num
42-36
Onstname
247TH ST.
Atddismissed
No
7504
Atdid: 7504 • Atd Number: ATD-4-3488 • Bblid: 763247
Atdid
7504
Atd Number
ATD-4-3488
Bblid
763247
Inspectionid
304806
Inspect Date
2019-10-12T00:00:00.000
Atdissuedate
2019-10-12T00:00:00.000
Cb
11
House Num
42-62
Onstname
247TH ST.
Atddismissed
No
7505
Atdid: 7505 • Atd Number: ATD-4-3489 • Bblid: 896979
Atdid
7505
Atd Number
ATD-4-3489
Bblid
896979
Inspectionid
304814
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
13
House Num
148-12
Onstname
148 ROAD
Atddismissed
No
7506
Atdid: 7506 • Atd Number: ATD-4-3490 • Bblid: 764833
Atdid
7506
Atd Number
ATD-4-3490
Bblid
764833
Inspectionid
304815
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
11
House Num
48-12
Onstname
OVERBROOK ST.
Atddismissed
No
7507
Atdid: 7507 • Atd Number: ATD-4-3491 • Bblid: 764851
Atdid
7507
Atd Number
ATD-4-3491
Bblid
764851
Inspectionid
304816
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
11
House Num
49-18
Onstname
OVERBROOK ST.
Atddismissed
No
7508
Atdid: 7508 • Atd Number: ATD-4-3492 • Bblid: 764849
Atdid
7508
Atd Number
ATD-4-3492
Bblid
764849
Inspectionid
304819
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
11
House Num
49-14
Onstname
OVERBROOK ST.
Atddismissed
No
7509
Atdid: 7509 • Atd Number: ATD-4-3493 • Bblid: 764843
Atdid
7509
Atd Number
ATD-4-3493
Bblid
764843
Inspectionid
304822
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
11
House Num
49-04
Onstname
OVERBROOK ST.
Atddismissed
No
7510
Atdid: 7510 • Atd Number: ATD-4-3494 • Bblid: 896945
Atdid
7510
Atd Number
ATD-4-3494
Bblid
896945
Inspectionid
304827
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
13
House Num
255-03
Onstname
148TH RD.
Atddismissed
No
7511
Atdid: 7511 • Atd Number: ATD-4-3495 • Bblid: 897003
Atdid
7511
Atd Number
ATD-4-3495
Bblid
897003
Inspectionid
304828
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
13
House Num
255-07
Onstname
148TH RD.
Atddismissed
No
7512
Atdid: 7512 • Atd Number: ATD-4-3496 • Bblid: 897001
Atdid
7512
Atd Number
ATD-4-3496
Bblid
897001
Inspectionid
304829
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
13
House Num
255-11
Onstname
148TH RD.
Atddismissed
No
7513
Atdid: 7513 • Atd Number: ATD-4-3497 • Bblid: 896999
Atdid
7513
Atd Number
ATD-4-3497
Bblid
896999
Inspectionid
304830
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
13
House Num
255-15
Onstname
148TH RD.
Atddismissed
No
7514
Atdid: 7514 • Atd Number: ATD-4-3498 • Bblid: 896997
Atdid
7514
Atd Number
ATD-4-3498
Bblid
896997
Inspectionid
304831
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
13
House Num
255-19
Onstname
148TH RD.
Atddismissed
No
7515
Atdid: 7515 • Atd Number: ATD-4-3499 • Bblid: 896995
Atdid
7515
Atd Number
ATD-4-3499
Bblid
896995
Inspectionid
304832
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
13
House Num
255-23
Onstname
148TH RD.
Atddismissed
No
7516
Atdid: 7516 • Atd Number: ATD-4-3500 • Bblid: 896993
Atdid
7516
Atd Number
ATD-4-3500
Bblid
896993
Inspectionid
304833
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
13
House Num
255-27
Onstname
148TH RD.
Atddismissed
No
7517
Atdid: 7517 • Atd Number: ATD-4-3501 • Bblid: 896991
Atdid
7517
Atd Number
ATD-4-3501
Bblid
896991
Inspectionid
304834
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
13
House Num
255-31
Onstname
148TH RD.
Atddismissed
No
7518
Atdid: 7518 • Atd Number: ATD-4-3502 • Bblid: 896989
Atdid
7518
Atd Number
ATD-4-3502
Bblid
896989
Inspectionid
304835
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
13
House Num
255-35
Onstname
148TH RD.
Atddismissed
No
7519
Atdid: 7519 • Atd Number: ATD-4-3503 • Bblid: 896987
Atdid
7519
Atd Number
ATD-4-3503
Bblid
896987
Inspectionid
304836
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
13
House Num
255-39
Onstname
148TH RD.
Atddismissed
No
7520
Atdid: 7520 • Atd Number: ATD-4-3504 • Bblid: 896985
Atdid
7520
Atd Number
ATD-4-3504
Bblid
896985
Inspectionid
304837
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
13
House Num
255-43
Onstname
148TH RD.
Atddismissed
No
7521
Atdid: 7521 • Atd Number: ATD-4-3505 • Bblid: 896983
Atdid
7521
Atd Number
ATD-4-3505
Bblid
896983
Inspectionid
304838
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
13
House Num
255-47
Onstname
148TH RD.
Atddismissed
No
7522
Atdid: 7522 • Atd Number: ATD-4-3506 • Bblid: 896981
Atdid
7522
Atd Number
ATD-4-3506
Bblid
896981
Inspectionid
304839
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
13
House Num
255-51
Onstname
148TH RD.
Atddismissed
No
7523
Atdid: 7523 • Atd Number: ATD-4-3507 • Bblid: 764821
Atdid
7523
Atd Number
ATD-4-3507
Bblid
764821
Inspectionid
304902
Inspect Date
2019-11-01T00:00:00.000
Atdissuedate
2019-11-01T00:00:00.000
Cb
11
House Num
47-08
Onstname
OVERBROOK ST.
Atddismissed
No
7524
Atdid: 7524 • Atd Number: ATD-4-3508 • Bblid: 763914
Atdid
7524
Atd Number
ATD-4-3508
Bblid
763914
Inspectionid
304920
Inspect Date
2019-11-07T00:00:00.000
Atdissuedate
2019-11-07T00:00:00.000
Cb
11
House Num
41-28
Onstname
MORGAN ST.
Atddismissed
No
7525
Atdid: 7525 • Atd Number: ATD-4-3509 • Bblid: 763922
Atdid
7525
Atd Number
ATD-4-3509
Bblid
763922
Inspectionid
304922
Inspect Date
2019-11-07T00:00:00.000
Atdissuedate
2019-11-07T00:00:00.000
Cb
11
House Num
41-10
Onstname
MORGAN ST.
Atddismissed
No
7526
Atdid: 7526 • Atd Number: ATD-3-2680 • Bblid: 420190
Atdid
7526
Atd Number
ATD-3-2680
Bblid
420190
Inspectionid
305011
Inspect Date
2019-11-06T00:00:00.000
Atdissuedate
2019-11-06T00:00:00.000
Cb
12
House Num
1664
Onstname
43RD ST.
Atddismissed
No
7527
Atdid: 7527 • Atd Number: ATD-4-3510 • Bblid: 866132
Atdid
7527
Atd Number
ATD-4-3510
Bblid
866132
Inspectionid
305311
Inspect Date
2019-11-16T00:00:00.000
Atdissuedate
2019-11-16T00:00:00.000
Cb
12
House Num
156-01
Onstname
110TH AVE.
Atddismissed
No
7528
Atdid: 7528 • Atd Number: ATD-4-3511 • Bblid: 868587
Atdid
7528
Atd Number
ATD-4-3511
Bblid
868587
Inspectionid
305318
Inspect Date
2019-11-16T00:00:00.000
Atdissuedate
2019-11-16T00:00:00.000
Cb
12
House Num
153-31
Onstname
121ST AVE.
Atddismissed
No
7529
Atdid: 7529 • Atd Number: ATD-4-3512 • Bblid: 745664
Atdid
7529
Atd Number
ATD-4-3512
Bblid
745664
Inspectionid
305415
Inspect Date
2019-11-16T00:00:00.000
Atdissuedate
2019-11-16T00:00:00.000
Cb
8
House Num
82-16
Onstname
164TH PL.
Atddismissed
No
7530
Atdid: 7530 • Atd Number: ATD-3-2681 • Bblid: 304384
Atdid
7530
Atd Number
ATD-3-2681
Bblid
304384
Inspectionid
305485
Inspect Date
2019-11-15T00:00:00.000
Atdissuedate
2019-11-15T00:00:00.000
Cb
16
House Num
166A
Onstname
HULL ST.
Atddismissed
No
7531
Atdid: 7531 • Atd Number: ATD-5-471 • Bblid: 946131
Atdid
7531
Atd Number
ATD-5-471
Bblid
946131
Inspectionid
305518
Inspect Date
2019-11-20T00:00:00.000
Atdissuedate
2019-11-20T00:00:00.000
Cb
2
House Num
97
Onstname
HOLDEN BLVD.
Atddismissed
No
7532
Atdid: 7532 • Atd Number: ATD-2-734 • Bblid: 195591
Atdid
7532
Atd Number
ATD-2-734
Bblid
195591
Inspectionid
305547
Inspect Date
2019-11-20T00:00:00.000
Atdissuedate
2019-11-20T00:00:00.000
Cb
11
House Num
1637
Onstname
MELVILLE ST.
Atddismissed
No
7533
Atdid: 7533 • Atd Number: ATD-2-735 • Bblid: 195721
Atdid
7533
Atd Number
ATD-2-735
Bblid
195721
Inspectionid
305549
Inspect Date
2019-11-20T00:00:00.000
Atdissuedate
2019-11-20T00:00:00.000
Cb
11
House Num
1638
Onstname
MELVILLE ST.
Atddismissed
No
7534
Atdid: 7534 • Atd Number: ATD-2-736 • Bblid: 195709
Atdid
7534
Atd Number
ATD-2-736
Bblid
195709
Inspectionid
305555
Inspect Date
2019-11-20T00:00:00.000
Atdissuedate
2019-11-20T00:00:00.000
Cb
11
House Num
1620
Onstname
MELVILLE ST.
Atddismissed
No
7535
Atdid: 7535 • Atd Number: ATD-2-737 • Bblid: 195705
Atdid
7535
Atd Number
ATD-2-737
Bblid
195705
Inspectionid
305556
Inspect Date
2019-11-20T00:00:00.000
Atdissuedate
2019-11-20T00:00:00.000
Cb
11
House Num
1616
Onstname
MELVILLE ST.
Atddismissed
No
7536
Atdid: 7536 • Atd Number: ATD-2-738 • Bblid: 195703
Atdid
7536
Atd Number
ATD-2-738
Bblid
195703
Inspectionid
305557
Inspect Date
2019-11-20T00:00:00.000
Atdissuedate
2019-11-20T00:00:00.000
Cb
11
House Num
1614
Onstname
MELVILLE STREET
Atddismissed
No
7538
Atdid: 7538 • Atd Number: ATD-4-3513 • Bblid: 868597
Atdid
7538
Atd Number
ATD-4-3513
Bblid
868597
Inspectionid
305579
Inspect Date
2019-11-16T00:00:00.000
Atdissuedate
2019-11-16T00:00:00.000
Cb
12
House Num
153-13
Onstname
121ST AVE.
Atddismissed
No
7539
Atdid: 7539 • Atd Number: ATD-4-3514 • Bblid: 763762
Atdid
7539
Atd Number
ATD-4-3514
Bblid
763762
Inspectionid
305711
Inspect Date
2019-11-22T00:00:00.000
Atdissuedate
2019-11-22T00:00:00.000
Cb
11
House Num
40-11
Onstname
247TH ST.
Atddismissed
No
7540
Atdid: 7540 • Atd Number: ATD-4-3515 • Bblid: 763641
Atdid
7540
Atd Number
ATD-4-3515
Bblid
763641
Inspectionid
305714
Inspect Date
2019-11-22T00:00:00.000
Atdissuedate
2019-11-22T00:00:00.000
Cb
11
House Num
247-02
Onstname
41ST AVE.
Atddismissed
No
NYC Data AI • Public-data exploration interface