439 rows where qSpecies_id = 148 sorted by DBH

View and edit SQL

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH ▼ PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
2426 100409 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 201 Franklin St 5 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2012 12:00:00 AM     Permit Number 767727 6006409.6 2110870.2 37.7764095571607 -122.421333763494 (37.7764095571607, -122.421333763494) 7 9 11 28852 10
8152 116289 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1901X Powell St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
14266 104341 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 953 Indiana St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/21/2013 12:00:00 AM   3x3 Permit Number 770725 6015057.1 2104275.7 37.7587862506702 -122.390958369803 (37.7587862506702, -122.390958369803) 10 3 8 28856 29
20062 97792 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 150X Broadway 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995458 2088095 37.7132509964384 -122.457569958917 (37.7132509964384, -122.457569958917) 9 8 6 28861 24
23054 104167 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 2000 Ellis St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2013 12:00:00 AM   4x4 Permit Number 768572 6001219.4 2112910.7 37.7817182660666 -122.43943438946 (37.7817182660666, -122.43943438946) 15 5 11 29490 41
27210 111374 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 222 Stanyan St 13 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
27805 49020 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 507 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013774.69039299 2115066.5155164 37.7883441634439 -122.396149816377 (37.7883441634439, -122.396149816377) 6 2 9 28855 6
32661 100407 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 201 Franklin St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2012 12:00:00 AM     Permit Number 767727 6006409.6 2110870.2 37.7764095571607 -122.421333763494 (37.7764095571607, -122.421333763494) 7 9 11 28852 10
32839 91205 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 90 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2009 12:00:00 AM   3x3 Permit Number 52043 6006233.7 2109956.2 37.7738900148236 -122.42187731202 (37.7738900148236, -122.42187731202) 7 9 11 28852 10
33990 91343 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 90 Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2009 12:00:00 AM   3x3 Permit Number 52043 6006233.7 2109956.2 37.7738900148236 -122.42187731202 (37.7738900148236, -122.42187731202) 7 9 11 28852 10
37348 116701 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1450 Divisadero St 6 Sidewalk: Curb side : Cutout Tree Mayor Office of Housing 11       3X3   6001279.3901091 2113342.5749494 37.7829074983832 -122.439257816981 (37.7829074983832, -122.439257816981) 15 5 11 29490 41
37390 41431 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 352-360 06th St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/26/2005 12:00:00 AM     Permit Number 42039 6011197 2111276 37.7777925370097 -122.404801285962 (37.7777925370097, -122.404801285962) 14 2 9 28853 34
39100 92566 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 222 Stanyan St 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52905 5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
39543 70859 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 201 Franklin St 3 Sidewalk: Curb side : Cutout Tree Private 2   01/07/1995 12:00:00 AM     Permit Number 767727 6006431.93006457 2110802.5343302 37.7762250224845 -122.421251711265 (37.7762250224845, -122.421251711265) 7 9 11 28852 10
41853 111371 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 222 Stanyan St 10 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
45892 116291 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1901X Powell St 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
46380 111372 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 222 Stanyan St 11 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
49683 116229 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1699 Steiner St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6002584.4 2114045.3 37.7849111787577 -122.434793299622 (37.7849111787577, -122.434793299622) 13 9 11 29490 13
51107 91344 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 90 Gough St 4 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2009 12:00:00 AM   3x3 Permit Number 52043 6006233.7 2109956.2 37.7738900148236 -122.42187731202 (37.7738900148236, -122.42187731202) 7 9 11 28852 10
51845 116302 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1550 Scott St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6002138.3 2113859.7 37.7843762313587 -122.436323371803 (37.7843762313587, -122.436323371803) 13 6 11 29490 13
55898 111376 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 222 Stanyan St 15 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
56128 116290 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1901X Powell St 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
58720 109763 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 899 VALENCIA ST 2 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM   3x3 Permit Number 772584 6006382.7 2104441.4 37.7587560793788 -122.420970264824 (37.7587560793788, -122.420970264824) 2 4 7 28859 19
59971 116303 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1550 Scott St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6002138.3 2113859.7 37.7843762313587 -122.436323371803 (37.7843762313587, -122.436323371803) 13 6 11 29490 13
60464 116304 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1550 Scott St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6002138.3 2113859.7 37.7843762313587 -122.436323371803 (37.7843762313587, -122.436323371803) 13 6 11 29490 13
68592 116702 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1450 Divisadero St 7 Sidewalk: Curb side : Cutout Tree Mayor Office of Housing 11       3X3   6001279.3901091 2113342.5749494 37.7829074983832 -122.439257816981 (37.7829074983832, -122.439257816981) 15 5 11 29490 41
68754 116286 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1901X Powell St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
75983 91335 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 90 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2009 12:00:00 AM   3x3 Permit Number 52043 6006233.7 2109956.2 37.7738900148236 -122.42187731202 (37.7738900148236, -122.42187731202) 7 9 11 28852 10
81477 86693 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1355 Market St 8 Sidewalk: Curb side : Cutout Tree DPW 1   09/19/2007 12:00:00 AM     Permit Number 49693 6007704.191622 2111021.854521 37.7768988673684 -122.416866141309 (37.7768988673684, -122.416866141309) 8 2 9 28853 34
82500 112842 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 604 12th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   08/24/2015 12:00:00 AM     Permit Number 773221 5992274.9 2111288.5 37.7767510524606 -122.470259695975 (37.7767510524606, -122.470259695975) 11 6 2 54 11
83891 116287 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1901X Powell St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
86603 116285 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1901X Powell St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
87123 91336 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 90 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2009 12:00:00 AM   3x3 Permit Number 52043 6006233.7 2109956.2 37.7738900148236 -122.42187731202 (37.7738900148236, -122.42187731202) 7 9 11 28852 10
96187 116306 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1550 Scott St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6002138.3 2113859.7 37.7843762313587 -122.436323371803 (37.7843762313587, -122.436323371803) 13 6 11 29490 13
98837 111373 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 222 Stanyan St 12 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
105085 91204 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 90 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2009 12:00:00 AM   3x3 Permit Number 52043 6006233.7 2109956.2 37.7738900148236 -122.42187731202 (37.7738900148236, -122.42187731202) 7 9 11 28852 10
105368 116227 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1699 Steiner St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6002584.4 2114045.3 37.7849111787577 -122.434793299622 (37.7849111787577, -122.434793299622) 13 9 11 29490 13
108275 97789 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 150X Broadway 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995458 2088095 37.7132509964384 -122.457569958917 (37.7132509964384, -122.457569958917) 9 8 6 28861 24
109025 105854 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 3440 Sacramento St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/05/2014 12:00:00 AM   3x3 Permit Number 771130 5998402.1 2115236.7 37.7879441154945 -122.449348514051 (37.7879441154945, -122.449348514051) 13 6 1 54 31
114312 111377 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 222 Stanyan St 16 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
114609 101514 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 240X DRUMM ST 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5   11/30/2012 12:00:00 AM   3x3 Permit Number 769442 6013870 2117910 37.796157009088 -122.396019403228 (37.796157009088, -122.396019403228) 3 1 10 28860 6
118778 116293 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1901X Powell St 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
119568 92087 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 710 Powell St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 52197 6010351 2116200 37.7912653498297 -122.408075252992 (37.7912653498297, -122.408075252992) 5 1 10 28857 21
120706 111370 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 222 Stanyan St 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
120828 97790 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 150X Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995458 2088095 37.7132509964384 -122.457569958917 (37.7132509964384, -122.457569958917) 9 8 6 28861 24
125923 94527 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1545 Divisadero St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/01/2010 12:00:00 AM     Permit Number 53714 6001163 2113666 37.7837889169409 -122.439683671841 (37.7837889169409, -122.439683671841) 15 6 11 29490 13
126461 83989 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1765 California St 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/02/2013 12:00:00 AM   3x4   6005922.82997861 2115889.71332947 37.7901644509246 -122.423374556695 (37.7901644509246, -122.423374556695) 13 9 1 28858 41
128801 106964 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 275 Valencia St 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 771536 6006216.68747 2108092.23656 37.7687710576512 -122.421803735394 (37.7687710576512, -122.421803735394) 8 4 7 28853 19
130284 116305 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1550 Scott St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6002138.3 2113859.7 37.7843762313587 -122.436323371803 (37.7843762313587, -122.436323371803) 13 6 11 29490 13
130584 49022 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 507 Howard St 3 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013774.69039299 2115066.5155164 37.7883441634439 -122.396149816377 (37.7883441634439, -122.396149816377) 6 2 9 28855 6
134560 101923 Section 143 10 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1401X California St 7 Sidewalk: Curb side : Cutout Tree Private 2   12/07/2012 12:00:00 AM   3x3 Permit Number 769132 6007402.7 2116063.9 37.7907261358602 -122.418266664095 (37.7907261358602, -122.418266664095) 13 1 10 28858 21
138293 116228 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1699 Steiner St 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6002584.4 2114045.3 37.7849111787577 -122.434793299622 (37.7849111787577, -122.434793299622) 13 9 11 29490 13
138619 100408 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 201 Franklin St 4 Sidewalk: Curb side : Cutout Tree Private 2   08/16/2012 12:00:00 AM     Permit Number 767727 6006409.6 2110870.2 37.7764095571607 -122.421333763494 (37.7764095571607, -122.421333763494) 7 9 11 28852 10
145061 49021 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 507 Howard St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013774.69039299 2115066.5155164 37.7883441634439 -122.396149816377 (37.7883441634439, -122.396149816377) 6 2 9 28855 6
145255 116288 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1901X Powell St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
146391 104166 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 2000 Ellis St 3 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2013 12:00:00 AM   4x4 Permit Number 768572 6001219.4 2112910.7 37.7817182660666 -122.43943438946 (37.7817182660666, -122.43943438946) 15 5 11 29490 41
146745 49019 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 507 Howard St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013774.69039299 2115066.5155164 37.7883441634439 -122.396149816377 (37.7883441634439, -122.396149816377) 6 2 9 28855 6
152875 109765 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 899 VALENCIA ST 4 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM   3x3 Permit Number 772584 6006382.7 2104441.4 37.7587560793788 -122.420970264824 (37.7587560793788, -122.420970264824) 2 4 7 28859 19
159490 104165 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 2000 Ellis St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2013 12:00:00 AM   4x4 Permit Number 768572 6001219.4 2112910.7 37.7817182660666 -122.43943438946 (37.7817182660666, -122.43943438946) 15 5 11 29490 41
165577 100715 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 507 Howard St 5 Sidewalk: Curb side : Cutout Tree Private 2   09/05/2012 12:00:00 AM     Permit Number 768932 6013735 2115044 37.7882801326001 -122.396285560985 (37.7882801326001, -122.396285560985) 6 2 9 28855 6
171013 109764 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 899 VALENCIA ST 3 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM   3x3 Permit Number 772584 6006382.7 2104441.4 37.7587560793788 -122.420970264824 (37.7587560793788, -122.420970264824) 2 4 7 28859 19
174092 116292 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1901X Powell St 8 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
178904 85036 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 977 Oak St 2 Sidewalk: Curb side : Cutout Tree Private 2           6002333 2109831 37.7733254935974 -122.435361498487 (37.7733254935974, -122.435361498487) 15 5 11 29492 9
179065 109766 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 899 VALENCIA ST 5 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM   3x3 Permit Number 772584 6006382.7 2104441.4 37.7587560793788 -122.420970264824 (37.7587560793788, -122.420970264824) 2 4 7 28859 19
182507 53296 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 4124 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2   05/28/2008 12:00:00 AM   3x3 Permit Number 50423 6002335.15488349 2102402.29787451 37.7529282071332 -122.434822699235 (37.7529282071332, -122.434822699235) 2 4 5 28862 22
183121 97791 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 150X Broadway 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5995458 2088095 37.7132509964384 -122.457569958917 (37.7132509964384, -122.457569958917) 9 8 6 28861 24
186043 111375 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 222 Stanyan St 14 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5996693 2111182 37.7767130721687 -122.454968563419 (37.7767130721687, -122.454968563419) 15 6 2 54 16
189664 59740 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 4301 24th St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/27/2012 12:00:00 AM     Permit Number 769743 6001257.45272634 2101704.38356178 37.7509506561918 -122.438499588668 (37.7509506561918, -122.438499588668) 2 4 5 28862 22
192322 104164 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 2000 Ellis St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2013 12:00:00 AM   4x4 Permit Number 768572 6001219.4 2112910.7 37.7817182660666 -122.43943438946 (37.7817182660666, -122.43943438946) 15 5 11 29490 41
159509 109761 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 899 VALENCIA ST 1 Sidewalk: Curb side : Cutout Tree Private 2   12/01/2015 12:00:00 AM 1 3x3 Permit Number 772584 6006382.7 2104441.4 37.7587560793788 -122.420970264824 (37.7587560793788, -122.420970264824) 2 4 7 28859 19
35185 103088 Undocumented 4 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 256 SHIPLEY ST   Sidewalk: Curb side : Cutout Tree Private 2     10 3x3   6011387 2111652 37.7788355638527 -122.404170475964 (37.7788355638527, -122.404170475964) 14 2 9 28856 34
78850 23383 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1451X Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   06/07/1999 12:00:00 AM 10 3X3   6006248.25114 2115440.18145 37.7889485091226 -122.42221667202 (37.7889485091226, -122.42221667202) 13 9 1 28858 41
135328 91841 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 861X HARRISON ST 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 10 3x3   6012389 2112023 37.7799101808503 -122.400730211489 (37.7799101808503, -122.400730211489) 6 2 9 28856 34
158393 91842 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 855 HARRISON ST 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/07/2007 12:00:00 AM 10 3x3   6012443 2111954 37.7797237344479 -122.400538552021 (37.7797237344479, -122.400538552021) 6 2 9 28856 34
75312 28323 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 3100 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/10/2004 12:00:00 AM 11 4x4   6007076.90394 2100561.83623 37.7481427912413 -122.418294317161 (37.7481427912413, -122.418294317161) 2 4 7 28859 2
1742 28048 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 4 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
9221 28049 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 5 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
19974 28151 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
21517 27259 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 690 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006717.7455722 2112795.3484565 37.7817129170403 -122.420404476934 (37.7817129170403, -122.420404476934) 7 9 9 28852 36
26852 23014 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 790 Valencia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006206.16059 2105091.96533 37.7605324270074 -122.421627026238 (37.7605324270074, -122.421627026238) 2 4 5 28859 19
29819 27975 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 12 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
32018 14183 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1844 Market St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/26/2012 12:00:00 AM 12 4X4 Permit Number 769087 6005554.6579568 2109080.5883488 37.7714474783148 -122.424163948162 (37.7714474783148, -122.424163948162) 7 2 5 28852 10
33497 27984 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 21 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
34463 28181 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 199X King St 17 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
35228 28154 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
39073 27258 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 690 Van Ness Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006717.7455722 2112795.3484565 37.7817129170403 -122.420404476934 (37.7817129170403, -122.420404476934) 7 9 9 28852 36
39391 28180 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 199X King St 16 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
39483 28169 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 199X King St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6014965.0656592 2111288.9310025 37.7780379351787 -122.391767040652 (37.7780379351787, -122.391767040652) 6 2 9 28856 20
40360 13581 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 525 Market St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6012787.5365724 2115865.9219292 37.7904841708264 -122.399621379879 (37.7904841708264, -122.399621379879) 12 2 9 28855 6
42580 28156 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
42673 28160 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 13 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
45913 28158 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
47018 27972 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 9 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
52938 28045 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1800 The Embarcadero 1 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
53356 27992 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 29 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
54544 27988 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 25 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6
54616 13948 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 1112X Market St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/13/1994 12:00:00 AM 12 4x4   6008868.4803223 2112239.1730786 37.7803067555436 -122.412924586563 (37.7803067555436, -122.412924586563) 7 2 9 28852 36
55209 28153 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
55995 28163 DPW Maintained 1 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 100X King St 16 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6015580.6531721 2111966.262542 37.7799318892041 -122.38968480475 (37.7799318892041, -122.38968480475) 6 2 9 28856 20
58562 27965 Permitted Site 7 Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 300 The Embarcadero 2 Sidewalk: Curb side : Cutout Tree Port 6   02/05/2001 12:00:00 AM 12 4X4   6013890.7555668 2118454.3638402 37.7976528582722 -122.395985750709 (37.7976528582722, -122.395985750709) 3 1 10 28860 6

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);