trees
39,840 rows where qLegalStatus_id = 7 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
159178 | 100459 | Permitted Site 7 | Olea europaea :: Olive Tree 9 | 4400 19th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | Permit Number 32872 | 6001426 | 2104682 | 37.7591360587515 | -122.438130013791 | (37.7591360587515, -122.438130013791) | 2 | 4 | 5 | 28862 | 3 | |||
144023 | 100465 | Permitted Site 7 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1140 Potrero Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 6010498.9 | 2102571.5 | 37.7538529165301 | -122.40660271212 | (37.7538529165301, -122.40660271212) | 10 | 4 | 7 | 28859 | 19 | |||
81383 | 10049 | Permitted Site 7 | Callistemon citrinus :: Lemon Bottlebrush 67 | 389 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/09/2003 12:00:00 AM | 3 | 3X3 | 6005557.3779151 | 2106729.2709881 | 37.7649914764619 | -122.42398730533 | (37.7649914764619, -122.42398730533) | 8 | 4 | 5 | 28853 | 19 | ||
39677 | 100514 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1X Treat Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2015 12:00:00 AM | 3 | 18x18 | Permit Number 776854 | 6009122.9 | 2107982.7 | 37.7686337575832 | -122.411743582031 | (37.7686337575832, -122.411743582031) | 8 | 4 | 7 | 28853 | 19 | |
88094 | 100518 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2X FLORIDA ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776854 | 6009099 | 2107996 | 37.7686689355282 | -122.411827190456 | (37.7686689355282, -122.411827190456) | 8 | 4 | 7 | 28853 | 19 | |
101394 | 100519 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 2X FLORIDA ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2015 12:00:00 AM | 3 | 3x3 | Permit Number 776854 | 6009099 | 2107996 | 37.7686689355282 | -122.411827190456 | (37.7686689355282, -122.411827190456) | 8 | 4 | 7 | 28853 | 19 | |
183976 | 10053 | Permitted Site 7 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 149 | 425 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/30/2006 12:00:00 AM | 3 | 3X2 | 6005568.8374122 | 2106507.5213951 | 37.7643832516565 | -122.423931899925 | (37.7643832516565, -122.423931899925) | 8 | 4 | 5 | 28859 | 19 | ||
84980 | 100553 | Permitted Site 7 | Tree(s) :: 17 | 4443 19th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6001193.1 | 2104609.9 | 37.7589248414166 | -122.438930324474 | (37.7589248414166, -122.438930324474) | 2 | 4 | 5 | 28862 | 3 | |||||
133606 | 100571 | Permitted Site 7 | Prunus laurocerasus :: English laurel 371 | 20 Landers St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/31/2014 12:00:00 AM | 3x3 | Permit Number 770316 | 6004449 | 2107658 | 37.7674789047962 | -122.427887091326 | (37.7674789047962, -122.427887091326) | 8 | 4 | 5 | 28862 | 3 | ||
103153 | 100575 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 3020 Washington St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/04/2012 12:00:00 AM | 3x3 | Permit Number 769157 | 6000252 | 2116146 | 37.7905464587755 | -122.443013541289 | (37.7905464587755, -122.443013541289) | 13 | 6 | 1 | 29490 | 27 | ||
42968 | 100580 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
91488 | 100581 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
7295 | 100582 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
145784 | 100586 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
88290 | 100587 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
183977 | 100588 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
20171 | 100589 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
66567 | 100590 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
131160 | 100591 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
130331 | 100592 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
193164 | 100593 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
142915 | 100594 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
193 | 100595 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
76152 | 100596 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
107648 | 100597 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
7539 | 100598 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
155891 | 100599 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
100844 | 100600 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
92101 | 100601 | Permitted Site 7 | Tree(s) :: 17 | 401x Clementina St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
158 | 100607 | Permitted Site 7 | Tree(s) :: 17 | 270x 05th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011410.5 | 2112131.8 | 37.7801542961347 | -122.404122955966 | (37.7801542961347, -122.404122955966) | 14 | 2 | 9 | 28853 | 34 | |||||
69062 | 100608 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
50451 | 100609 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
80857 | 100610 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
12696 | 100611 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
62153 | 100612 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
134931 | 100613 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
159461 | 100614 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
193030 | 100615 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
42477 | 100616 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
164572 | 100617 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
127147 | 100618 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
176695 | 100619 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
33482 | 10062 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 497 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/08/1997 12:00:00 AM | 3 | 3X3 | 6005580.9933972 | 2106078.9124418 | 37.7632070792286 | -122.423859376385 | (37.7632070792286, -122.423859376385) | 8 | 4 | 5 | 28859 | 19 | ||
26498 | 100620 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
129355 | 100621 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
137134 | 100622 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
79816 | 100623 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
193091 | 100624 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
156133 | 100625 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
103199 | 100626 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
185224 | 100627 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 270X 05th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6011410.5 | 2112131.8 | 37.7801542961347 | -122.404122955966 | (37.7801542961347, -122.404122955966) | 14 | 2 | 9 | 28853 | 34 | ||||
36732 | 100628 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 270X 05th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 6011410.5 | 2112131.8 | 37.7801542961347 | -122.404122955966 | (37.7801542961347, -122.404122955966) | 14 | 2 | 9 | 28853 | 34 | ||||
29190 | 100630 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
172227 | 100631 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
30346 | 100632 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
163585 | 100633 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
43213 | 100634 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
117734 | 100635 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
31002 | 100636 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
521 | 100638 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
70050 | 100639 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
25394 | 100640 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
26937 | 100641 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
139959 | 100642 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
181113 | 100643 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
2153 | 100644 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
132073 | 100645 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
36091 | 100646 | Permitted Site 7 | Tree(s) :: 17 | 401X Clementina St | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011466.9 | 2112295.6 | 37.7806072039402 | -122.403939371598 | (37.7806072039402, -122.403939371598) | 14 | 2 | 9 | 28853 | 34 | |||||
138176 | 100651 | Permitted Site 7 | Tree(s) :: 17 | 3047 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/28/2012 12:00:00 AM | 0 | 3x3 | Permit Number 769350 | 5999416 | 2119261 | 37.7990517217573 | -122.446130197749 | (37.7990517217573, -122.446130197749) | 13 | 9 | 1 | 57 | 17 | |
84387 | 100665 | Permitted Site 7 | Tree(s) :: 17 | 63 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 09/04/2012 12:00:00 AM | 3x3 | Permit Number 769258 | 6003201.8 | 2107946.7 | 37.7682009695292 | -122.432221606092 | (37.7682009695292, -122.432221606092) | 15 | 5 | 5 | 28862 | 3 | |
61686 | 100705 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
132195 | 100706 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
105004 | 100707 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
188290 | 100708 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
182718 | 100710 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 220X 01st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 768932 | 6013902 | 2115015 | 37.7882097965006 | -122.395705731652 | (37.7882097965006, -122.395705731652) | 6 | 2 | 9 | 28855 | 6 | ||
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 | |||
118683 | 100743 | Permitted Site 7 | Tree(s) :: 17 | 448 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6001794 | 2103231 | 37.7551728852459 | -122.436753428301 | (37.7551728852459, -122.436753428301) | 2 | 4 | 5 | 28862 | 22 | ||||
149709 | 100744 | Permitted Site 7 | Tree(s) :: 17 | 760 Duboce Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/05/2012 12:00:00 AM | 3x3 | Permit Number 769249 | 6002024.1 | 2108325.5 | 37.7691742163209 | -122.436322258742 | (37.7691742163209, -122.436322258742) | 15 | 5 | 5 | 29492 | 9 | ||
137765 | 100745 | Permitted Site 7 | Pinus Spp :: Pine Spp 100 | 760 Duboce Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6002024.1 | 2108325.5 | 37.7691742163209 | -122.436322258742 | (37.7691742163209, -122.436322258742) | 15 | 5 | 5 | 29492 | 9 | ||||
104491 | 100779 | Permitted Site 7 | Acer rubrum :: Red Maple 75 | 450 Hayes St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | 3x4 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | ||
19756 | 100780 | Permitted Site 7 | Ginkgo biloba :: Maidenhair Tree 22 | 450 Hayes St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/10/2012 12:00:00 AM | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | 7 | 9 | 11 | 28852 | 10 | |||
167918 | 100783 | Permitted Site 7 | Tree(s) :: 17 | 2101X Washington St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | 13 | 9 | 1 | 28858 | 27 | |||||
41196 | 100784 | Permitted Site 7 | Tree(s) :: 17 | 2101 Washington St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | 13 | 9 | 1 | 28858 | 27 | |||||
136224 | 100785 | Permitted Site 7 | Tree(s) :: 17 | 2101 Washington St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | 13 | 9 | 1 | 28858 | 27 | |||||
168525 | 100786 | Permitted Site 7 | Tree(s) :: 17 | 2101 Washington St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004647.8 | 2116722.2 | 37.7923782050701 | -122.42784540593 | (37.7923782050701, -122.42784540593) | 13 | 9 | 1 | 28858 | 27 | |||||
140698 | 100787 | Permitted Site 7 | Tree(s) :: 17 | 2001 Washington St | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6005125.9 | 2116783.4 | 37.792573279433 | -122.426195525639 | (37.792573279433, -122.426195525639) | 13 | 9 | 1 | 28858 | 27 | |||||
45162 | 100793 | Permitted Site 7 | Callistemon viminalis :: Weeping Bottlebrush 60 | 2979 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Recently planted by FUF. | 6008363 | 2103862 | 37.7572766073656 | -122.414080464335 | (37.7572766073656, -122.414080464335) | 2 | 4 | 7 | 28859 | 19 | ||||
76438 | 10080 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 629 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/18/1998 12:00:00 AM | 3 | 2x2 | 6005634.7584694 | 2105309.7909765 | 37.76109828818 | -122.423618734472 | (37.76109828818, -122.423618734472) | 2 | 4 | 5 | 28859 | 19 | ||
108444 | 100836 | Permitted Site 7 | Magnolia grandiflora :: Southern Magnolia 19 | 291 30th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/13/2012 12:00:00 AM | Permit Number 769343 | 5986476 | 2114001.5 | 37.7838632073277 | -122.490519185954 | (37.7838632073277, -122.490519185954) | 11 | 6 | 1 | 55 | 33 | |||
23284 | 100840 | Permitted Site 7 | Tree(s) :: 17 | 55 Merced Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/12/2009 12:00:00 AM | Permit Number 53028 | 5995112.6 | 2099949.4 | 37.74578045796 | -122.459621841542 | (37.74578045796, -122.459621841542) | 1 | 8 | 4 | 59 | 40 | |||
59800 | 100857 | Permitted Site 7 | Tree(s) :: 17 | 70 07th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/18/2012 12:00:00 AM | 3x3 | Permit Number 769158 | 5993689.8 | 2115051.7 | 37.7871654802842 | -122.465638641068 | (37.7871654802842, -122.465638641068) | 11 | 6 | 1 | 54 | 11 | ||
23020 | 100894 | Permitted Site 7 | Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 163 | 1400 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6008828 | 2109520 | 37.7728382767515 | -122.412872323828 | (37.7728382767515, -122.412872323828) | 8 | 2 | 9 | 28853 | 34 | |||
179643 | 100895 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1800 Folsom St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
106986 | 100896 | Permitted Site 7 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1800 Folsom St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
69740 | 100897 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
108059 | 100898 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
134640 | 100899 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
69293 | 100901 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 32 | 4x4 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
139282 | 100902 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 | ||
74775 | 100903 | Permitted Site 7 | Corymbia ficifolia :: Red Flowering Gum 28 | 1800 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | Permit Number 30965 | 6007972 | 2107962 | 37.7685122898352 | -122.415722998498 | (37.7685122898352, -122.415722998498) | 8 | 4 | 7 | 28853 | 19 |
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) );