trees
439 rows where qSpecies_id = 148 sorted by TreeID
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
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 | |||
119087 | 101070 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 3018 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2012 12:00:00 AM | 3 | 3x3 | Permit Number 768630 | 5999883.5 | 2115123.7 | 37.7877184733225 | -122.444215032048 | (37.7877184733225, -122.444215032048) | 13 | 6 | 1 | 29490 | 27 | |
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 | ||
131372 | 101526 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 2300X Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6003597.8 | 2116101.6 | 37.7906147410217 | -122.431434108251 | (37.7906147410217, -122.431434108251) | 13 | 9 | 1 | 29490 | 27 | |||
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 | ||
166295 | 102121 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1090X Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) | 2 | 4 | 5 | 28862 | 22 |
111204 | 102122 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1090X Sanchez St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) | 2 | 4 | 5 | 28862 | 22 |
131308 | 102123 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1090X Sanchez St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 5 | 3x3 | Permit Number 769743 | 6003794.9 | 2101928.3 | 37.7517094896741 | -122.429740821201 | (37.7517094896741, -122.429740821201) | 2 | 4 | 5 | 28862 | 22 |
58214 | 102158 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4300X 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769743 | 6001255.1 | 2101750.3 | 37.751076597898 | -122.438511014093 | (37.751076597898, -122.438511014093) | 2 | 4 | 5 | 28862 | 22 |
32478 | 102160 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4300X 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/27/2012 12:00:00 AM | 3 | 3x3 | Permit Number 769743 | 6001255.1 | 2101750.3 | 37.751076597898 | -122.438511014093 | (37.751076597898, -122.438511014093) | 2 | 4 | 5 | 28862 | 22 |
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 | ||||
87721 | 103745 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1999X Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008051.81901 | 2107091.22594 | 37.7661258341797 | -122.415385257212 | (37.7661258341797, -122.415385257212) | 8 | 4 | 7 | 28853 | 19 | ||
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||
162479 | 104530 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1363 Divisadero St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/10/2017 10:11:00 AM | 3 | 3x3 | 6001216 | 2113103 | 37.782246079324 | -122.439459940797 | (37.782246079324, -122.439459940797) | 15 | 5 | 11 | 29490 | 41 | ||
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 | ||
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 | ||||
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 | |
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 | ||
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 | ||
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 | ||
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 | ||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | |||||
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 | ||||
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 | ||||
36837 | 117955 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 855 HARRISON ST | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6012443 | 2111954 | 37.7797237344479 | -122.400538552021 | (37.7797237344479, -122.400538552021) | 6 | 2 | 9 | 28856 | 34 | |||
68393 | 117958 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 851X HARRISON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6012435 | 2111995 | 37.7798358648386 | -122.400569108585 | (37.7798358648386, -122.400569108585) | 6 | 2 | 9 | 28856 | 34 | |||
153578 | 117959 | Permitted Site 7 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 851X HARRISON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6012435 | 2111995 | 37.7798358648386 | -122.400569108585 | (37.7798358648386, -122.400569108585) | 6 | 2 | 9 | 28856 | 34 | |||
173036 | 121025 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1101X South Van Ness Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3x3 | 6007689 | 2103175 | 37.7553523831166 | -122.416362767289 | (37.7553523831166, -122.416362767289) | 2 | 4 | 7 | 28859 | 19 | |||
97736 | 121026 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1101X South Van Ness Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6007689 | 2103175 | 37.7553523831166 | -122.416362767289 | (37.7553523831166, -122.416362767289) | 2 | 4 | 7 | 28859 | 19 | |||
92897 | 121027 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1101X South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6007689 | 2103175 | 37.7553523831166 | -122.416362767289 | (37.7553523831166, -122.416362767289) | 2 | 4 | 7 | 28859 | 19 | |||
185602 | 121028 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1101X South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3x3 | 6007689 | 2103175 | 37.7553523831166 | -122.416362767289 | (37.7553523831166, -122.416362767289) | 2 | 4 | 7 | 28859 | 19 | |||
69655 | 122511 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 715 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 5 | 3x6 | 6006287 | 2105397 | 37.7613745389022 | -122.421369101713 | (37.7613745389022, -122.421369101713) | 2 | 4 | 7 | 28859 | 19 | |||
57956 | 122512 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 721 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3x6 | 6006289 | 2105371 | 37.7613032617497 | -122.421360338097 | (37.7613032617497, -122.421360338097) | 2 | 4 | 7 | 28859 | 19 | |||
97984 | 122513 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 721 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | 3x6 | 6006289 | 2105371 | 37.7613032617497 | -122.421360338097 | (37.7613032617497, -122.421360338097) | 2 | 4 | 7 | 28859 | 19 | |||
124837 | 122515 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 758 Valencia St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x6 | 6006189 | 2105199 | 37.7608253514989 | -122.421693979475 | (37.7608253514989, -122.421693979475) | 2 | 4 | 5 | 28859 | 19 | |||
128877 | 122821 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 777 Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | 3x3 | 6006304 | 2105101 | 37.7605627505881 | -122.421289285481 | (37.7605627505881, -122.421289285481) | 2 | 4 | 7 | 28859 | 19 | |||
159637 | 123676 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 4620 California St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/30/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 782655 | 5993209.68387 | 2114188.73207 | 37.7847683024995 | -122.467236954218 | (37.7847683024995, -122.467236954218) | 11 | 6 | 2 | 54 | 11 | |
166367 | 13463 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 101 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2005 12:00:00 AM | 20 | 4X4 | 6013989.3283097 | 2117008.9290081 | 37.79368951828 | -122.395543339024 | (37.79368951828, -122.395543339024) | 12 | 2 | 9 | 28855 | 6 | ||
112989 | 13466 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 101 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2005 12:00:00 AM | 20 | 4X4 | 6013989.3283097 | 2117008.9290081 | 37.79368951828 | -122.395543339024 | (37.79368951828, -122.395543339024) | 12 | 2 | 9 | 28855 | 6 | ||
176159 | 13468 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 101 Market St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2005 12:00:00 AM | 20 | 4X4 | 6013989.3283097 | 2117008.9290081 | 37.79368951828 | -122.395543339024 | (37.79368951828, -122.395543339024) | 12 | 2 | 9 | 28855 | 6 | ||
127010 | 13469 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 101 Market St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2005 12:00:00 AM | 20 | 4X4 | 6013989.3283097 | 2117008.9290081 | 37.79368951828 | -122.395543339024 | (37.79368951828, -122.395543339024) | 12 | 2 | 9 | 28855 | 6 | ||
82698 | 13471 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 101 Market St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/01/2005 12:00:00 AM | 20 | 4X4 | 6013989.3283097 | 2117008.9290081 | 37.79368951828 | -122.395543339024 | (37.79368951828, -122.395543339024) | 12 | 2 | 9 | 28855 | 6 | ||
42062 | 13492 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 215 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2005 12:00:00 AM | 6 | 4X4 | 6013729.1406446 | 2116782.463481 | 37.7930532214207 | -122.396427736192 | (37.7930532214207, -122.396427736192) | 12 | 2 | 9 | 28855 | 6 | ||
191456 | 13493 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 215 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2005 12:00:00 AM | 6 | 4X4 | 6013729.1406446 | 2116782.463481 | 37.7930532214207 | -122.396427736192 | (37.7930532214207, -122.396427736192) | 12 | 2 | 9 | 28855 | 6 | ||
88844 | 13503 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 245 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2005 12:00:00 AM | 6 | 4X4 | 6013642.6483486 | 2116679.2066582 | 37.7927648888925 | -122.396719764541 | (37.7927648888925, -122.396719764541) | 12 | 2 | 9 | 28855 | 6 | ||
74683 | 13505 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 245 Market St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2005 12:00:00 AM | 6 | 4X4 | 6013642.6483486 | 2116679.2066582 | 37.7927648888925 | -122.396719764541 | (37.7927648888925, -122.396719764541) | 12 | 2 | 9 | 28855 | 6 | ||
93294 | 13520 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 388 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6013190.8445953 | 2116364.9078359 | 37.7918767419323 | -122.3982609742 | (37.7918767419323, -122.3982609742) | 4 | 2 | 10 | 28860 | 6 | |||
97976 | 13567 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 484X Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 6 | 4x4 | 6012939.9788554 | 2116125.819916 | 37.791206285852 | -122.399112186297 | (37.791206285852, -122.399112186297) | 4 | 2 | 10 | 28860 | 6 | ||
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 | |||
120614 | 13586 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 525 Market St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/19/2004 12:00:00 AM | 20 | 4X4 | 6012787.5365724 | 2115865.9219292 | 37.7904841708264 | -122.399621379879 | (37.7904841708264, -122.399621379879) | 12 | 2 | 9 | 28855 | 6 | ||
190865 | 13588 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 525 Market St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6012787.5365724 | 2115865.9219292 | 37.7904841708264 | -122.399621379879 | (37.7904841708264, -122.399621379879) | 12 | 2 | 9 | 28855 | 6 | |||
91931 | 13591 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 525 Market St | 13 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/15/2004 12:00:00 AM | 8 | 4X4 | 6012787.5365724 | 2115865.9219292 | 37.7904841708264 | -122.399621379879 | (37.7904841708264, -122.399621379879) | 12 | 2 | 9 | 28855 | 6 | ||
120690 | 13657 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 619 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6012007.3883744 | 2115123.3531128 | 37.7884017343709 | -122.402268428095 | (37.7884017343709, -122.402268428095) | 12 | 2 | 9 | 28855 | 6 | |||
144167 | 13793 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 929 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/12/2016 06:56:00 AM | 3 | 4X4 | 6010115.5056 | 2113327.9166 | 37.7833661076198 | -122.408687358048 | (37.7833661076198, -122.408687358048) | 14 | 2 | 9 | 28853 | 34 | ||
80899 | 13830 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 965 Market St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 3 | 4X4 | 6009908.9307448 | 2113122.0497873 | 37.7827892741888 | -122.409387495448 | (37.7827892741888, -122.409387495448) | 14 | 2 | 9 | 28853 | 34 | ||
106090 | 13837 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 972 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/28/2005 12:00:00 AM | 3 | 4x4 | 6009828.8708825 | 2113156.6502082 | 37.7828797927495 | -122.409666913005 | (37.7828797927495, -122.409666913005) | 14 | 2 | 9 | 28852 | 36 | ||
166567 | 13851 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 989 Market St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/2004 12:00:00 AM | 6 | 4X4 | 6009747.4153425 | 2112968.1407914 | 37.7823576258181 | -122.409935404775 | (37.7823576258181, -122.409935404775) | 14 | 2 | 9 | 28853 | 34 | ||
21275 | 13852 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 989 Market St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4X4 | 6009747.4153425 | 2112968.1407914 | 37.7823576258181 | -122.409935404775 | (37.7823576258181, -122.409935404775) | 14 | 2 | 9 | 28853 | 34 | |||
68947 | 13857 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 991 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 6 | 4X4 | 6009733.8299349 | 2112955.195175 | 37.7823213188284 | -122.409981490315 | (37.7823213188284, -122.409981490315) | 14 | 2 | 9 | 28853 | 34 | ||
64235 | 13870 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1000 Market St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2007 12:00:00 AM | 8 | 4x4 | 6009621.3575962 | 2112944.5572428 | 37.7822858053101 | -122.410369845025 | (37.7822858053101, -122.410369845025) | 14 | 2 | 9 | 28852 | 36 | ||
155322 | 13906 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1063 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/22/2016 11:38:00 AM | 3 | 4x4 | 6009266.7492 | 2112493.5891 | 37.7810276692866 | -122.411564765047 | (37.7810276692866, -122.411564765047) | 14 | 2 | 9 | 28853 | 34 | ||
43063 | 13918 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1077 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/30/2015 08:31:00 AM | 3 | 4X4 | 6009171.9340081 | 2112419.7611149 | 37.7808196363131 | -122.411887560568 | (37.7808196363131, -122.411887560568) | 14 | 2 | 9 | 28853 | 34 | ||
46114 | 13919 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1077 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | 4X4 | 6009171.9340081 | 2112419.7611149 | 37.7808196363131 | -122.411887560568 | (37.7808196363131, -122.411887560568) | 14 | 2 | 9 | 28853 | 34 | |||
151384 | 13923 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1081 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/18/1997 12:00:00 AM | 20 | 4X4 | 6009147.0816163 | 2112396.0791116 | 37.7807532168626 | -122.411971863376 | (37.7807532168626, -122.411971863376) | 14 | 2 | 9 | 28853 | 34 | ||
125402 | 13924 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1083 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/30/2004 12:00:00 AM | 16 | 4X4 | 6009134.0341107 | 2112383.6460599 | 37.7807183466268 | -122.41201612229 | (37.7807183466268, -122.41201612229) | 14 | 2 | 9 | 28853 | 34 | ||
171182 | 13925 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1083 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/15/2006 12:00:00 AM | 6 | 4X4 | 6009134.0341107 | 2112383.6460599 | 37.7807183466268 | -122.41201612229 | (37.7807183466268, -122.41201612229) | 14 | 2 | 9 | 28853 | 34 | ||
147819 | 13927 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1091 Market St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/30/2015 07:43:00 AM | 3 | 4x4 | 6009083.7080174 | 2112335.6900033 | 37.7805838469879 | -122.412186834853 | (37.7805838469879, -122.412186834853) | 14 | 2 | 9 | 28853 | 34 | ||
26656 | 13928 | DPW Maintained 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 148 | 1091 Market St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/2000 12:00:00 AM | 20 | 4X4 | 6009083.7080174 | 2112335.6900033 | 37.7805838469879 | -122.412186834853 | (37.7805838469879, -122.412186834853) | 14 | 2 | 9 | 28853 | 34 |
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) );