trees
720 rows where qCaretaker_id = 5
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
164 | 116129 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
380 | 116339 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
466 | 116275 | Undocumented 4 | :: 45 | 700X Greenwich St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6009521.9 | 2120182.3 | 37.8021533125646 | -122.411225360908 | (37.8021533125646, -122.411225360908) | 3 | 1 | 10 | 308 | 23 | |||||
569 | 112652 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 3100X 26TH ST | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008747 | 2100981 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | 2 | 4 | 7 | 28859 | 19 | ||||
633 | 9792 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 36 | 3x3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
770 | 111807 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50X COLUMBIA SQUARE ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
1143 | 29069 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1002X Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 15 | 3x3 | 6004818.3149515 | 2112301.2204093 | 37.7802489436872 | -122.4269404119 | (37.7802489436872, -122.4269404119) | 7 | 9 | 11 | 28852 | 41 | ||
1331 | 25415 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 895X Mansell St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 07/19/1996 12:00:00 AM | 9 | 3X3 | 6009314.2175931 | 2089925.7733477 | 37.719064130172 | -122.409807064317 | (37.719064130172, -122.409807064317) | 9 | 3 | 8 | 309 | 18 | ||
1809 | 120887 | DPW Maintained 1 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 3x3 | 6009811.6249 | 2087578.8489 | 37.7126478205015 | -122.407922299954 | (37.7126478205015, -122.407922299954) | 9 | 7 | 8 | 309 | 39 | |||
1978 | 87100 | Permitted Site 7 | Pinus radiata :: Monterey Pine 15 | 700 Connecticut St | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 3x3 | Permit Number 50056 | |||||||||||||
2220 | 117168 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 299x ALMA ST | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
2745 | 260577 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2301 San Jose Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | MTA | 09/25/2019 12:00:00 AM | 3 | 5x3 | Permit Number 779319 | 5998691.65634515 | 2090728.63648601 | 37.72066757978 | -122.446582741763 | (37.72066757978, -122.446582741763) | 9 | 7 | 6 | 28861 | 25 |
3181 | 103180 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 11 | 3x4 | 5987448.1702 | 2104354.2995 | 37.7574314190685 | -122.486447346513 | (37.7574314190685, -122.486447346513) | 1 | 8 | 3 | 56 | 35 | |||
4249 | 98418 | DPW Maintained 1 | Tree(s) :: 17 | 1501X Steiner St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.434425094313 | (37.7831064505465, -122.434425094313) | 13 | 9 | 11 | 29490 | 41 | |||
5642 | 13071 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 645X Lombard St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 09/27/2006 12:00:00 AM | 3 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | ||
5722 | 255886 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50 Columbia Square St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
6188 | 111792 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
6361 | 116132 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
7104 | 9470 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 26 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | ||
7157 | 260575 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2301 San Jose Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | MTA | 09/25/2019 12:00:00 AM | 3 | 5x3 | Permit Number 779319 | 5998691.65634515 | 2090728.63648601 | 37.72066757978 | -122.446582741763 | (37.72066757978, -122.446582741763) | 9 | 7 | 6 | 28861 | 25 |
7194 | 117622 | Undocumented 4 | Pinus radiata :: Monterey Pine 15 | 890x VERMONT ST | 1 | Front Yard : Yard | Tree | Rec/Park 5 | 6011292 | 2104239 | 37.7584758425658 | -122.403977311201 | (37.7584758425658, -122.403977311201) | 10 | 3 | 8 | 28856 | 29 | |||||
7532 | 9542 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 1100X Golden Gate Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/31/2000 12:00:00 AM | 3 | 3X3 | 6003977.1107 | 2112193.8912 | 37.7799066435706 | -122.429842866574 | (37.7799066435706, -122.429842866574) | 7 | 9 | 11 | 29490 | 41 | ||
7534 | 238616 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 4302 24th St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 23 | Width 4ft | 6001186.94921 | 2101750.3744 | 37.7510729252903 | -122.438746691333 | (37.7510729252903, -122.438746691333) | 2 | 4 | 5 | 28862 | 22 | |||
7553 | 20501 | DPW Maintained 1 | Pinus Spp :: Pine Spp 100 | 1204 Sunset Blvd | 22 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
7597 | 9777 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 30 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
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 | |||||
8356 | 260576 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2301 San Jose Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | MTA | 09/25/2019 12:00:00 AM | 3 | 5x3 | Permit Number 779319 | 5998691.65634515 | 2090728.63648601 | 37.72066757978 | -122.446582741763 | (37.72066757978, -122.446582741763) | 9 | 7 | 6 | 28861 | 25 |
8543 | 20492 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
8986 | 8479 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1900X Geary Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3X3 | 6002632.5922648 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | 13 | 9 | 11 | 29490 | 13 | |||
9505 | 260574 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 2301 San Jose Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | MTA | 09/25/2019 12:00:00 AM | 3 | 5x3 | Permit Number 779319 | 5998691.65634515 | 2090728.63648601 | 37.72066757978 | -122.446582741763 | (37.72066757978, -122.446582741763) | 9 | 7 | 6 | 28861 | 25 |
9629 | 103219 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 3 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 11 | 3x4 | 5987198.2105 | 2103866.2266 | 37.7560767305116 | -122.487275946944 | (37.7560767305116, -122.487275946944) | 1 | 8 | 3 | 56 | 35 | |||
10460 | 258772 | Property Tree 8 | Cupressus spp :: Cypress species 337 | 20 Crestline Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 5999139 | 2101332 | 37.7498074496931 | -122.445798597569 | (37.7498074496931, -122.445798597569) | 2 | 5 | 5 | 63 | 38 | |||
10847 | 17720 | Permitted Site 7 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1300X Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 35 | 3X3 | Permit Number 768629 | 6002290.56024 | 2112983.34935 | 37.7819786446445 | -122.435733884321 | (37.7819786446445, -122.435733884321) | 15 | 5 | 11 | 29490 | 41 | |
11538 | 103186 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 0 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | |||
11977 | 24539 | Landmark tree 11 | Fraxinus ornus :: Flowering Ash 301 | 500X Cortland Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 50 | 3X3 | 6007622.12549 | 2097206.54003 | 37.7389605708788 | -122.41617135712 | (37.7389605708788, -122.41617135712) | 2 | 7 | 7 | 28859 | 2 | |||
12188 | 102373 | DPW Maintained 1 | Ginkgo biloba :: Maidenhair Tree 22 | 870 39th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 1 | 5983890.73069 | 2109977.48147 | 37.7726630776505 | -122.499165683617 | (37.7726630776505, -122.499165683617) | 11 | 6 | 2 | 55 | 26 | ||||
13062 | 6292 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1700X Ellis St | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 01/28/2013 12:00:00 AM | 24 | 3X4 | Permit Number 768629 | 6002728.2699376 | 2113059.4201816 | 37.7822123689276 | -122.434225051326 | (37.7822123689276, -122.434225051326) | 15 | 9 | 11 | 29490 | 41 | |
13314 | 75092 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 288 Eddy St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 16 | 6009056.34359 | 2113588.95965 | 37.7840234906369 | -122.412370111692 | (37.7840234906369, -122.412370111692) | 14 | 10 | 9 | 28852 | 36 | ||||
13392 | 112649 | Undocumented 4 | Magnolia grandiflora :: Southern Magnolia 19 | 3100X 26TH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008747 | 2100981 | 37.749387590387 | -122.41254878695 | (37.749387590387, -122.41254878695) | 2 | 4 | 7 | 28859 | 19 | ||||
14279 | 24540 | Landmark tree 11 | Fraxinus ornus :: Flowering Ash 301 | 500X Cortland Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 50 | 3X3 | 6007652.96823 | 2097201.05938 | 37.7389472564055 | -122.416064328819 | (37.7389472564055, -122.416064328819) | 2 | 7 | 7 | 28859 | 2 | |||
15513 | 9780 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
16407 | 262217 | Landmark tree 11 | Sambucus mexicana :: Blue Elderberry 367 | 3440X Folsom St | 1 | Front Yard : Cutout | Tree | Rec/Park 5 | 3x3 | 6008633 | 2098934 | 37.7437605844193 | -122.412798302433 | (37.7437605844193, -122.412798302433) | 2 | 7 | 7 | 28859 | 2 | ||||
17219 | 25457 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 100 Randolph St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/10/1997 12:00:00 AM | 6 | 3X3 | 5993681.7949 | 2088543.8714 | 37.7143812997511 | -122.463741645146 | (37.7143812997511, -122.463741645146) | 9 | 8 | 6 | 64 | 24 | ||
17315 | 236909 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1180 Stanyan St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | Width 3ft | 5997408.17858 | 2106084.98197 | 37.7627589713618 | -122.452126715679 | (37.7627589713618, -122.452126715679) | 15 | 5 | 11 | 29492 | 9 | |||
17446 | 9465 | Permitted Site 7 | Pistacia chinensis :: Chinese Pistache 32 | 800X Golden Gate Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/10/2007 12:00:00 AM | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | ||
18701 | 4660 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 600X Columbus Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 125 | 5X5 | 6009761.7282 | 2119587.7167 | 37.8005341810425 | -122.410353429867 | (37.8005341810425, -122.410353429867) | 3 | 1 | 10 | 308 | 23 | |||
18894 | 9449 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 800X Golden Gate Ave | 5 | Front Yard : Yard | Tree | Rec/Park 5 | 12 | 3X3 | 6005556.1262 | 2112420.5622 | 37.780618317973 | -122.424396471178 | (37.780618317973, -122.424396471178) | 7 | 9 | 11 | 28852 | 41 | |||
20007 | 9462 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 800X Golden Gate Ave | 18 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | |||
20034 | 255882 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 50 Columbia Square St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
20308 | 103199 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1601X 28th Ave | 19 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||
20492 | 108957 | DPW Maintained 1 | Tree(s) :: 17 | 1401X GREAT HWY | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 02/10/2015 12:00:00 AM | 3 | 4x4 | Permit Number 774900 | 5980823 | 2105507 | 37.7602079965022 | -122.509445018403 | (37.7602079965022, -122.509445018403) | 1 | 8 | 3 | 29491 | 35 | |
20532 | 20482 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 42 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
21289 | 9463 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 800X Golden Gate Ave | 19 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | |||
22185 | 116323 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
22229 | 255887 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 50 Columbia Square St | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
22609 | 116318 | Undocumented 4 | :: 45 | 1451 Hampshire St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010547.7 | 2101110.8 | 37.74984488673 | -122.406331036849 | (37.74984488673, -122.406331036849) | 10 | 4 | 7 | 28859 | 19 | |||||
23390 | 22618 | Permitted Site 7 | Acacia melanoxylon :: Blackwood Acacia 70 | 1001 Turk St | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3x5 | 6005224.1346872 | 2112659.8569034 | 37.7812566094766 | -122.425562024881 | (37.7812566094766, -122.425562024881) | 7 | 9 | 11 | 28852 | 41 | |||
24396 | 13385 | Permitted Site 7 | Arbutus 'Marina' :: Hybrid Strawberry Tree 14 | 1000X Mansell St | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3 | 3X3 | 6008956.7805816 | 2089957.5006014 | 37.7191312087569 | -122.411044830527 | (37.7191312087569, -122.411044830527) | 9 | 7 | 7 | 309 | 18 | |||
24565 | 10586 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1050X Harrison St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 75 | 3X3 | 6011036.2882597 | 2110765.2479161 | 37.7763811461579 | -122.405321269139 | (37.7763811461579, -122.405321269139) | 14 | 2 | 9 | 28853 | 34 | |||
24926 | 254202 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 1180 Stanyan St | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Width 3ft | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
24931 | 98427 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1401X Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | Permit Number 768629 | 6002724.9 | 2113044.1 | 37.7821701122998 | -122.434235614198 | (37.7821701122998, -122.434235614198) | 15 | 9 | 11 | 29490 | 41 | |||
24954 | 255884 | Undocumented 4 | Acer rubrum :: Red Maple 75 | 50 Columbia Square St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | Private | 3x3 | 6010942 | 2111079 | 37.7772373644855 | -122.405669544588 | (37.7772373644855, -122.405669544588) | 14 | 2 | 9 | 28853 | 34 | |||
24958 | 99241 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 560X Ellis St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 10 | 4x4 | 6008235.1228 | 2113825.75072 | 37.7846275436788 | -122.415228013286 | (37.7846275436788, -122.415228013286) | 7 | 10 | 9 | 28858 | 36 | |||
25187 | 116322 | Undocumented 4 | :: 45 | 1400X Potrero Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6010648.28497 | 2101378.43149 | 37.7505853701643 | -122.406002059271 | (37.7505853701643, -122.406002059271) | 10 | 4 | 8 | 28859 | 19 | |||||
25322 | 9783 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 11 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | |||
25623 | 2807 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1070X California St | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 45 | 3X3 | 6009199.566436 | 2116398.3908477 | 37.7917455466199 | -122.412073224415 | (37.7917455466199, -122.412073224415) | 5 | 1 | 10 | 28857 | 21 | |||
25660 | 29071 | Permitted Site 7 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 | 1050X Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3x3 | 6004796.7525631 | 2112456.6816498 | 37.7806745826486 | -122.427026081915 | (37.7806745826486, -122.427026081915) | 7 | 9 | 11 | 28852 | 41 | ||
25869 | 102376 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 851 38th Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 5984157.51207 | 2109978.36457 | 37.7726811489417 | -122.498242937742 | (37.7726811489417, -122.498242937742) | 11 | 6 | 2 | 55 | 26 | ||||
26044 | 9456 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 800X Golden Gate Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12/15/2005 12:00:00 AM | 3 | 3X3 | 6005442.4 | 2112406.4818 | 37.7805732339777 | -122.424788902821 | (37.7805732339777, -122.424788902821) | 7 | 9 | 11 | 28852 | 41 | ||
26375 | 111795 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 12 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
26553 | 103213 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 17 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
27261 | 22398 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 5 | 3X3 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | 10 | 3 | 8 | 58 | 1 | |||
27281 | 103222 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1600X 29th Ave | 8 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 11 | 3x4 | 5987186.3641 | 2104162.3873 | 37.7568892163494 | -122.487338668246 | (37.7568892163494, -122.487338668246) | 1 | 8 | 3 | 56 | 35 | |||
28157 | 98421 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1501X Steiner St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | Permit Number 768629 | 6002677.2 | 2113386.1 | 37.7831064505465 | -122.434425094313 | (37.7831064505465, -122.434425094313) | 13 | 9 | 11 | 29490 | 41 | |||
28941 | 103177 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 2201 Lawton St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||||
29021 | 8524 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1901 Geary Blvd | 6 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 18 | 3X3 | 6001704.22181 | 2113592.17339 | 37.7836169980675 | -122.437805961288 | (37.7836169980675, -122.437805961288) | 15 | 5 | 11 | 29490 | 41 | |||
29082 | 101513 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 240X DRUMM ST | 4 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6013870 | 2117910 | 37.796157009088 | -122.396019403228 | (37.796157009088, -122.396019403228) | 3 | 1 | 10 | 28860 | 6 | ||||
29445 | 26153 | Permitted Site 7 | Ficus nitida :: Laurel Fig 53 | 1500 Oakdale Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 3X3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | |||
30006 | 9774 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 897X Gough St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 05/26/1992 12:00:00 AM | 34 | 3X3 | 6005678.151576 | 2112736.5747486 | 37.7814929008439 | -122.42399680549 | (37.7814929008439, -122.42399680549) | 7 | 9 | 11 | 28852 | 41 | ||
30472 | 100032 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 3x3 | Permit Number 769129 | 6009411 | 2117399.5 | 37.7945062091547 | -122.411412418869 | (37.7945062091547, -122.411412418869) | 3 | 1 | 10 | 28857 | 21 | ||
30529 | 22400 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 5755X 03rd St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 5 | 4X4 | 6013951.2697336 | 2092275.7830743 | 37.7257755649285 | -122.393942861008 | (37.7257755649285, -122.393942861008) | 10 | 3 | 8 | 58 | 1 | |||
30537 | 116151 | Undocumented 4 | Tree(s) :: 17 | 3701 18th St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6004597.25395 | 2105425.85161 | 37.7613583450105 | -122.427215284143 | (37.7613583450105, -122.427215284143) | 8 | 4 | 5 | 28862 | 3 | |||||
30723 | 120885 | Undocumented 4 | Prunus serrulata :: Ornamental Cherry 84 | 201 Leland Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6009830 | 2087548 | 37.7125641444482 | -122.407856615551 | (37.7125641444482, -122.407856615551) | 9 | 7 | 8 | 309 | 39 | ||||
30841 | 87987 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300x Jones St | 5 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 04/23/2015 03:33:00 PM | 3 | 3x3 | Permit Number 51027 | 6008990.567 | 2113714.34992 | 37.7843640908799 | -122.412606542572 | (37.7843640908799, -122.412606542572) | 14 | 10 | 9 | 28852 | 36 | |
31352 | 116135 | Undocumented 4 | Tree(s) :: 17 | 1601X Armstrong Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6014258.08027 | 2092570.23406 | 37.7266011147526 | -122.392902822978 | (37.7266011147526, -122.392902822978) | 10 | 3 | 8 | 58 | 1 | |||||
31421 | 20481 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1204 Sunset Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 48 | 40 | 5984687.7602675 | 2107238.1673169 | 37.7651884221731 | -122.496206568741 | (37.7651884221731, -122.496206568741) | 11 | 6 | 2 | 55 | 8 | |||
31834 | 9468 | Permitted Site 7 | Maytenus boaria :: Mayten 58 | 800X Golden Gate Ave | 24 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 6 | 3X3 | 6005716.3316921 | 2112434.9405022 | 37.7806668426278 | -122.423843265886 | (37.7806668426278, -122.423843265886) | 7 | 9 | 11 | 28852 | 41 | |||
32309 | 88409 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 1199 Mason St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 08/02/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769129 | 6009413.9789 | 2117291.03714 | 37.7942085637169 | -122.41139444529 | (37.7942085637169, -122.41139444529) | 3 | 1 | 10 | 28857 | 21 | |
32372 | 111797 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 55X SHERMAN ST | 14 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6010857 | 2110997 | 37.7770074580074 | -122.405957810357 | (37.7770074580074, -122.405957810357) | 14 | 2 | 9 | 28853 | 34 | ||||
32406 | 113978 | Undocumented 4 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 201 | 1180 STANYAN ST | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
32593 | 23612 | Permitted Site 7 | Pinus canariensis :: Canary Island Pine 35 | 890X Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 12 | 30X30PL | 6011290.8652502 | 2104244.5269478 | 37.7584909549369 | -122.403981624636 | (37.7584909549369, -122.403981624636) | 10 | 3 | 8 | 28856 | 29 | |||
32800 | 117172 | Undocumented 4 | Tree(s) :: 17 | 299x ALMA ST | 9 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 5997407 | 2106053 | 37.7626710894654 | -122.452128484278 | (37.7626710894654, -122.452128484278) | 15 | 5 | 11 | 29492 | 9 | ||||
32831 | 20504 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1203X Sunset Blvd | 13 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/02/1991 12:00:00 AM | 18 | 10 | 5984781.8902056 | 2107224.2505442 | 37.7651557239541 | -122.495879974111 | (37.7651557239541, -122.495879974111) | 11 | 6 | 2 | 55 | 8 | ||
32890 | 9796 | Permitted Site 7 | Lophostemon confertus :: Brisbane Box 11 | 997X Gough St | 7 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 03/08/2006 12:00:00 AM | 3X3 | 6005630.9126204 | 2113075.2727517 | 37.7824202152127 | -122.424184324881 | (37.7824202152127, -122.424184324881) | 7 | 9 | 11 | 28852 | 41 | |||
33267 | 26138 | Permitted Site 7 | Pittosporum undulatum :: Victorian Box 36 | 1500 Oakdale Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 11/05/2005 12:00:00 AM | 3 | 3x3 | 6015586.3934773 | 2095100.209325 | 37.7336216133372 | -122.388487366626 | (37.7336216133372, -122.388487366626) | 10 | 3 | 8 | 58 | 1 | ||
34134 | 103185 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1601X 28th Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 0 | 3x4 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | |||
34675 | 13072 | Permitted Site 7 | Olea europaea 'Fruitless' :: Fruitless Olive 177 | 645X Lombard St | 2 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 09/27/2008 12:00:00 AM | 3 | 3X3 | 6009269.1098284 | 2120449.52185 | 37.8028728569333 | -122.412119036156 | (37.8028728569333, -122.412119036156) | 3 | 1 | 10 | 308 | 23 | ||
34779 | 104448 | Private 9 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2490X Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 3x3 | 6008214.39649 | 2104163.75253 | 37.7580968032353 | -122.41461574816 | (37.7580968032353, -122.41461574816) | 2 | 4 | 7 | 28859 | 19 | ||||
34971 | 103197 | DPW Maintained 1 | Photinia fraseri :: Photinia: Chinese photinia 166 | 1601X 28th Ave | 15 | Sidewalk: Property side : Cutout | Tree | Rec/Park 5 | 03/26/2013 12:00:00 AM | 3x4 | Permit Number 770085 | 5987489 | 2103696 | 37.7556262873159 | -122.486257815902 | (37.7556262873159, -122.486257815902) | 1 | 8 | 3 | 56 | 35 | ||
35154 | 8478 | Permitted Site 7 | Platanus x hispanica :: Sycamore: London Plane 27 | 1900X Geary Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | Rec/Park 5 | 24 | 3X3 | 6002632.5922648 | 2113803.8302726 | 37.7842509000301 | -122.434609297971 | (37.7842509000301, -122.434609297971) | 13 | 9 | 11 | 29490 | 13 |
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) );