720 rows where qCaretaker_id = 5 sorted by PlantDate

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
40310 13074 Permitted Site 7 Prunus cerasifera :: Cherry Plum 7 645X Lombard St 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5     18 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156) 3 1 10 308 23
40573 12056 Permitted Site 7 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 1330X La Salle Ave 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     12 3X3   6016860.8582794 2094712.6673543 37.732628043472 -122.384054150964 (37.732628043472, -122.384054150964) 10 3 8 58 1
40623 2804 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1070X California St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     50 3X3   6009199.566436 2116398.3908477 37.7917455466199 -122.412073224415 (37.7917455466199, -122.412073224415) 5 1 10 28857 21
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
41503 22401 Permitted Site 7 Lophostemon confertus :: Brisbane Box 11 5755X 03rd St 4 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
41809 106281 Undocumented 4 Garrya elliptica 'James Roof' :: James Roof Coast Silktassel Tree 456 399X Elliot St 2 Unaccepted Street : Yard Tree Rec/Park 5         Permit Number 772905 6008798.75873 2088103.62049 37.7140319762934 -122.411460149363 (37.7140319762934, -122.411460149363) 9 7 8 309 39
42048 98424 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1501X Steiner St 8 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6002677.2 2113386.1 37.7831064505465 -122.434425094313 (37.7831064505465, -122.434425094313) 13 9 11 29490 41
42614 13380 Permitted Site 7 Arbutus 'Marina' :: Hybrid Strawberry Tree 14 1000X Mansell St 6 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
44049 26131 DPW Maintained 1 Schinus terebinthifolius :: Brazilian Pepper 93 1500 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     12 3x3   6015558.456 2095125.3192 37.7336890117673 -122.388585707606 (37.7336890117673, -122.388585707606) 10 3 8 58 1
44769 20157 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 36 1100X Steiner St 2 Sidewalk: Curb side : Cutout Tree Rec/Park 5     18 4X4   6002895.0285 2112125.5503 37.7796576600117 -122.433581380876 (37.7796576600117, -122.433581380876) 15 9 11 29490 41
44854 101512 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 240X DRUMM ST 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6013870 2117910 37.796157009088 -122.396019403228 (37.796157009088, -122.396019403228) 3 1 10 28860 6
45125 139199 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 27 1900 GEARY BLVD 27 Sidewalk: Curb side : Cutout Tree Rec/Park 5     19 Width 0ft   6001773.0984 2113703.8723 37.7839276110688 -122.437575676931 (37.7839276110688, -122.437575676931) 13 5 11 29490 13
45374 112650 Undocumented 4 Magnolia grandiflora :: Southern Magnolia 19 3100X 26TH ST 4 Sidewalk: Curb side : Cutout Tree Rec/Park 5       3x3   6008747 2100981 37.749387590387 -122.41254878695 (37.749387590387, -122.41254878695) 2 4 7 28859 19
45542 8492 Permitted Site 7 Platanus x hispanica :: Sycamore: London Plane 27 1950X Geary Blvd 3 Sidewalk: Curb side : Cutout Tree Rec/Park 5     30 3X3   6002386.4460269 2113776.6748133 37.7841623615489 -122.435458932616 (37.7841623615489, -122.435458932616) 13 5 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)
);