trees
439 rows where qSpecies_id = 148 sorted by DBH
This data as json, CSV (advanced)
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );