720 rows where qCaretaker_id = 5 sorted by PermitNotes

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
35969 29068 Permitted Site 7 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 162 1091X Turk St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5   12/15/2005 12:00:00 AM 3 3x3   6004816.84954 2112603.0518286 37.7810776154036 -122.426966984587 (37.7810776154036, -122.426966984587) 7 9 11 28852 41
36156 22614 DPW Maintained 1 Acacia melanoxylon :: Blackwood Acacia 70 1001 Turk St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5     24 3x5   6005426.7391 2112695.1691 37.7813650138202 -122.424863625752 (37.7813650138202, -122.424863625752) 7 9 11 28852 41
36237 22616 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 1 1001 Turk St 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5     24 3x5   6005581.297 2112717.6262 37.7814354041528 -122.424330527926 (37.7814354041528, -122.424330527926) 7 9 11 28852 41
37083 8501 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1950X Geary Blvd 12 Sidewalk: Curb side : Cutout Tree Rec/Park 5     18 3X3   6002386.4460269 2113776.6748133 37.7841623615489 -122.435458932616 (37.7841623615489, -122.435458932616) 13 5 11 29490 13
37487 20499 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1204 Sunset Blvd 20 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
37714 120886 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 201 Leland Ave 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5     1 3x3   6009795.1369 2087583.7508 37.7126603570018 -122.407979633406 (37.7126603570018, -122.407979633406) 9 7 8 309 39
37847 26134 DPW Maintained 1 Melaleuca quinquenervia :: Cajeput 10 1506 Oakdale Ave 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5   04/22/1997 12:00:00 AM 6 3x3   6015502.3956 2095169.2882 37.7338066348029 -122.388782595026 (37.7338066348029, -122.388782595026) 10 3 8 58 1
38453 20514 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 1211X Sunset Blvd 10 Sidewalk: Curb side : Cutout Tree Rec/Park 5     48 60   5984783.6901595 2107169.3790132 37.7650051676015 -122.495869700491 (37.7650051676015, -122.495869700491) 11 6 2 55 8
39435 26643 Permitted Site 7 Ginkgo biloba 'Fairmont' :: Fairmont Ginkgo 250 2199X Post St 6 Sidewalk: Curb side : Cutout Tree Rec/Park 5   06/22/1998 12:00:00 AM 3 3X3   6001667.0796215 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313) 13 6 11 29490 13
39568 8500 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1950X Geary Blvd 11 Sidewalk: Curb side : Cutout Tree Rec/Park 5     24 3X3   6002386.4460269 2113776.6748133 37.7841623615489 -122.435458932616 (37.7841623615489, -122.435458932616) 13 5 11 29490 13
39579 5439 DPW Maintained 1 Liquidambar orientalis :: Oriental Sweet Gum 269 500X Dolores St 7 Sidewalk: Curb side : Cutout Tree Rec/Park 5   03/01/1990 12:00:00 AM 45 6   6004897.25501 2105174.42186 37.7606849395651 -122.426159805147 (37.7606849395651, -122.426159805147) 2 4 5 28862 3
39604 116148 Undocumented 4 Tree(s) :: 17 3800X 20th St 9 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6004661.9257 2104258.88373 37.7581577845713 -122.426908497787 (37.7581577845713, -122.426908497787) 2 4 5 28862 3
39830 116130 Undocumented 4 Tree(s) :: 17 1601X Armstrong Ave 2 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
39958 20469 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1203X Sunset Blvd 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5     12 40   5984781.3005655 2107242.2257009 37.7652050441375 -122.495883339617 (37.7652050441375, -122.495883339617) 11 6 2 55 8
40034 116284 Undocumented 4 :: 45 700X Greenwich St 11 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
40222 87642 Permitted Site 7 Callistemon viminalis :: Weeping Bottlebrush 60 1002X Laguna St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5           6004813.344433 2112300.663017 37.7802471321724 -122.426957567511 (37.7802471321724, -122.426957567511) 7 9 11 28852 41

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)
);