720 rows where qCaretaker_id = 5

View and edit SQL

rowid ▼ TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
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

Next page

Advanced export

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

CSV options:

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