trees
194,517 rows sorted by PermitNotes
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 264847 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 109 Felton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6010522 | 2093730 | 37.729577358437 | -122.405900044893 | (37.729577358437, -122.405900044893) | 10 | 3 | 7 | 309 | 28 | |||
2 | 262167 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 420 Alpha St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/16/2020 12:00:00 AM | 3 | ||||||||||||
4 | 264831 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 230 Wilde Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 4x6 | 6011678 | 2088870 | 37.7162973770842 | -122.401562170369 | (37.7162973770842, -122.401562170369) | 10 | 7 | 8 | 309 | 39 | ||
5 | 264836 | DPW Maintained 1 | Laurus x 'Saratoga' :: Hybrid Laurel 4 | 325 Olmstead St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 4x6 | 6010737 | 2090909 | 37.7218435009065 | -122.404958220137 | (37.7218435009065, -122.404958220137) | 10 | 3 | 7 | 309 | 28 | ||
6 | 262166 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 420 Alpha St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/16/2020 12:00:00 AM | 3 | ||||||||||||
8 | 264824 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 1x Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6012032 | 2089425 | 37.7178410421308 | -122.400377527521 | (37.7178410421308, -122.400377527521) | 10 | 7 | 8 | 309 | 39 | |||
10 | 264794 | Undocumented 4 | Eriobotrya deflexa :: Bronze Loquat 8 | 31 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | 3x3 | 6011433 | 2091603 | 37.7237879639177 | -122.40260109208 | (37.7237879639177, -122.40260109208) | 10 | 3 | 7 | 309 | 28 | ||
11 | 264841 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1601 Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6007819 | 2087884 | 37.7133739406818 | -122.41483104388 | (37.7133739406818, -122.41483104388) | 9 | 7 | 8 | 309 | 39 | |||
12 | 264792 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 99 Dwight St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 3x3 | 6011432 | 2091645 | 37.7239032314516 | -122.402607501044 | (37.7239032314516, -122.402607501044) | 10 | 3 | 7 | 309 | 28 | ||
13 | 264822 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2 Harkness Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 4x6 | ||||||||||||
14 | 162252 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 789 Girard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/2020 12:00:00 AM | 3 | Width 0ft | 6011428.3902 | 2091205.22693 | 37.7226955033817 | -122.402589068938 | (37.7226955033817, -122.402589068938) | 10 | 3 | 7 | 309 | 28 | ||
15 | 264849 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 15 Hale St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6010381 | 2094903 | 37.7327902820185 | -122.40647012075 | (37.7327902820185, -122.40647012075) | 10 | 3 | 7 | 309 | 28 | |||
16 | 264823 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2 Harkness Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 4x6 | ||||||||||||
19 | 262168 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 420 Alpha St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/16/2020 12:00:00 AM | 3 | ||||||||||||
20 | 264793 | Undocumented 4 | Olea europaea :: Olive Tree 9 | 99 Dwight St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/2020 12:00:00 AM | 3 | 3x3 | 6011432 | 2091645 | 37.7239032314516 | -122.402607501044 | (37.7239032314516, -122.402607501044) | 10 | 3 | 7 | 309 | 28 | ||
21 | 264839 | DPW Maintained 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 2 | 1601 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6007819 | 2087884 | 37.7133739406818 | -122.41483104388 | (37.7133739406818, -122.41483104388) | 9 | 7 | 8 | 309 | 39 | |||
22 | 262394 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 66 Cleary Ct | 1 | Sidewalk: Property side : Cutout | Tree | DPW 1 | 11/13/2020 12:00:00 AM | 3 | 3x3 | 6004824 | 2113713 | 37.7841256623529 | -122.427021325889 | (37.7841256623529, -122.427021325889) | 13 | 9 | 11 | 28858 | 41 | ||
24 | 264941 | DPW Maintained 1 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 100X Portola Dr | 12 | Median : Cutout | Tree | Private 2 | 3x3 | 5999749 | 2101261 | 37.7496473113918 | -122.443684097942 | (37.7496473113918, -122.443684097942) | 2 | 5 | 5 | 28862 | 38 | ||||
26 | 259857 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1255 Brussels St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 11/01/2020 12:00:00 AM | 3 | 6011768.59367 | 2089078.72926 | 37.7168755602396 | -122.401263692233 | (37.7168755602396, -122.401263692233) | 10 | 7 | 8 | 309 | 39 | ||
28 | 264848 | DPW Maintained 1 | Tilia cordata :: Littleleaf Linden 12 | 15 Hale St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6010381 | 2094903 | 37.7327902820185 | -122.40647012075 | (37.7327902820185, -122.40647012075) | 10 | 3 | 7 | 309 | 28 | |||
29 | 264952 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 2 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
31 | 264951 | Significant Tree 6 | Tree(s) :: 17 | 20X Cleary Ct | 1 | Front Yard : Yard | Tree | Private 2 | 11/13/2020 12:00:00 AM | 3 | 6004818 | 2113712 | 37.7841225773231 | -122.427042012496 | (37.7841225773231, -122.427042012496) | 13 | 9 | 11 | 28858 | 41 | |||
32 | 264850 | DPW Maintained 1 | Eriobotrya deflexa :: Bronze Loquat 8 | 172 University St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/01/2020 12:00:00 AM | 3 | 6007951 | 2093149 | 37.7278379340298 | -122.414747181337 | (37.7278379340298, -122.414747181337) | 9 | 3 | 7 | 309 | 5 | |||
34 | 262408 | Property Tree 8 | Pinus radiata :: Monterey Pine 15 | 66X Edgehill Way | 1 | Unaccepted Street : Yard | Tree | Private 2 | 3x3 | 5994840 | 2098758 | 37.7424934921887 | -122.46047813267 | (37.7424934921887, -122.46047813267) | 1 | 8 | 4 | 59 | 40 | ||||
35 | 16620 | DPW Maintained 1 | Magnolia doltsopa :: Himalayan Magnolia 20 | 125 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/09/1999 12:00:00 AM | 6 | 3X3 | 6002913 | 2107540 | 37.7670678918229 | -122.433191472284 | (37.7670678918229, -122.433191472284) | 15 | 5 | 5 | 28862 | 3 | ||
37 | 264963 | Section 806 (d) 5 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 13 | 275 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 3x3 | 6005706 | 2110306 | 37.7748207071365 | -122.423727591769 | (37.7748207071365, -122.423727591769) | 7 | 9 | 11 | 28852 | 10 | ||
40 | 6039 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1822 Eddy St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001574.3819 | 2112547.6661 | 37.7807416628926 | -122.438180307395 | (37.7807416628926, -122.438180307395) | 15 | 5 | 11 | 29490 | 41 | |||
41 | 159866 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Ruth St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001590.27181 | 2091627.71254 | 37.7233013847479 | -122.436627471279 | (37.7233013847479, -122.436627471279) | 9 | 7 | 6 | 28861 | 25 | ||
42 | 221891 | DPW Maintained 1 | Geijera parviflora :: Australian Willow 25 | 180 Bartlett St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006685.21207 | 2102724.39469 | 37.7540586268078 | -122.419802203518 | (37.7540586268078, -122.419802203518) | 2 | 4 | 7 | 28859 | 19 | |||
43 | 264724 | DPW Maintained 1 | Acacia baileyana 'Purpurea' :: Purple-leaf Acacia 26 | 2901 Broadway | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 5999656 | 2116990 | 37.7928298614365 | -122.445136362104 | (37.7928298614365, -122.445136362104) | 13 | 6 | 1 | 29490 | 27 | ||||
44 | 159867 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Ruth St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001543.73914 | 2091652.70256 | 37.7233673572035 | -122.436790113668 | (37.7233673572035, -122.436790113668) | 9 | 7 | 6 | 28861 | 25 | ||
45 | 134298 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 1948 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2020 12:00:00 AM | 3 | Width 4ft | 6004784.56446 | 2117433.72769 | 37.7943396156388 | -122.427422908337 | (37.7943396156388, -122.427422908337) | 13 | 9 | 1 | 28858 | 27 | ||
46 | 6035 | DPW Maintained 1 | Hymenosporum flavum :: Sweetshade 24 | 1826 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6001552.687 | 2112546.4084 | 37.7807369756783 | -122.438255270265 | (37.7807369756783, -122.438255270265) | 15 | 5 | 11 | 29490 | 41 | |||
47 | 264965 | Undocumented 4 | Melaleuca quinquenervia :: Cajeput 10 | 951 Capitol Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5994993 | 2090257 | 37.7191606150529 | -122.45933361899 | (37.7191606150529, -122.45933361899) | 9 | 8 | 6 | 28861 | 24 | ||||
48 | 159865 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20 Ruth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001621.37029 | 2091612.17517 | 37.7232604898693 | -122.436518858358 | (37.7232604898693, -122.436518858358) | 9 | 7 | 6 | 28861 | 25 | ||
49 | 261834 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 20x Ruth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/19/2020 12:00:00 AM | 3 | 4x6 | 6001536 | 2091749 | 37.7236313283612 | -122.436823756643 | (37.7236313283612, -122.436823756643) | 9 | 7 | 6 | 28861 | 25 | ||
50 | 264964 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 3641 California St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3X3 | 5996989 | 2114619 | 37.7861671437011 | -122.454192924446 | (37.7861671437011, -122.454192924446) | 11 | 6 | 1 | 54 | 31 | ||||
51 | 137691 | DPW Maintained 1 | Rhamnus alaternus :: Italian Buckthorn 29 | 2175 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/23/2020 12:00:00 AM | 3 | Width 0ft | 5999187.5809 | 2111472.1809 | 37.7776526229954 | -122.44635998308 | (37.7776526229954, -122.44635998308) | 15 | 5 | 11 | 54 | 16 | ||
52 | 264970 | Undocumented 4 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1026 Ingerson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014048 | 2089990 | 37.7195046364539 | -122.393448574201 | (37.7195046364539, -122.393448574201) | 10 | 3 | 8 | 58 | 1 | ||||
53 | 264969 | Undocumented 4 | Acacia stenophylla :: Shoestring Acacia 30 | 1099X Hollister Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 15x15 | 6014337 | 2089983 | 37.719501468928 | -122.392449109694 | (37.719501468928, -122.392449109694) | 10 | 3 | 8 | 58 | 1 | |||
54 | 216739 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 11 Brighton Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11/23/2020 12:00:00 AM | 3 | Width 3ft | 5996185.57101 | 2089978.26988 | 37.7184637821573 | -122.4551912491 | (37.7184637821573, -122.4551912491) | 9 | 8 | 6 | 28861 | 24 | ||
55 | 1166 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2900 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/23/2020 12:00:00 AM | 25 | 3X3 | 5997012.91474 | 2087625.16187 | 37.7120501257788 | -122.45216178836 | (37.7120501257788, -122.45216178836) | 9 | 7 | 6 | 28861 | 25 | ||
58 | 195132 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 825 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2020 12:00:00 AM | 3 | Width 3ft | 6015253.79115 | 2104691.52976 | 37.7599389420381 | -122.390307168065 | (37.7599389420381, -122.390307168065) | 10 | 3 | 8 | 28856 | 29 | ||
59 | 195131 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 851 Minnesota St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2020 12:00:00 AM | 3 | Width 3ft | 6015252.45033 | 2104672.28083 | 37.7598860142382 | -122.390310460464 | (37.7598860142382, -122.390310460464) | 10 | 3 | 8 | 28856 | 29 | ||
60 | 264971 | Private 9 | Ulmus parvifolia :: Chinese Elm 31 | 150 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/25/2020 12:00:00 AM | 3 | 5990555.23468 | 2114396.47455 | 37.7851851170506 | -122.476435559205 | (37.7851851170506, -122.476435559205) | 11 | 6 | 2 | 54 | 26 | |||
62 | 264980 | Significant Tree 6 | Ginkgo biloba :: Maidenhair Tree 22 | 222 Winfield St | 1 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6006740 | 2098205 | 37.7416524795013 | -122.419292156581 | (37.7416524795013, -122.419292156581) | 2 | 7 | 7 | 28859 | 2 | ||||
63 | 264975 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 445 Ortega St | 1 | Front Yard : Yard | Tree | Private 2 | 10x30 | 5992686 | 2102646 | 37.7530447932571 | -122.468208733714 | (37.7530447932571, -122.468208733714) | 1 | 8 | 4 | 56 | 12 | ||||
64 | 264974 | Significant Tree 6 | Persea americana :: Avocado 34 | 1868 Greenwich St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6003954 | 2119422 | 37.7997518904289 | -122.430438688757 | (37.7997518904289, -122.430438688757) | 13 | 9 | 1 | 57 | 17 | ||||
65 | 264979 | Undocumented 4 | Pinus canariensis :: Canary Island Pine 35 | 2450 California St | 1 | Front Yard : Yard | Tree | MTA 3 | 6002592 | 2115500 | 37.7889058459562 | -122.434871073784 | (37.7889058459562, -122.434871073784) | 13 | 9 | 1 | 29490 | 27 | |||||
66 | 132469 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 3135 Pierce St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6001403 | 2119193 | 37.7989782820217 | -122.43924964791 | (37.7989782820217, -122.43924964791) | 13 | 9 | 1 | 57 | 17 | |||
68 | 264976 | Significant Tree 6 | Pinus radiata :: Monterey Pine 15 | 445 Ortega St | 2 | Front Yard : Yard | Tree | Private 2 | 10x30 | 5992686 | 2102646 | 37.7530447932571 | -122.468208733714 | (37.7530447932571, -122.468208733714) | 1 | 8 | 4 | 56 | 12 | ||||
69 | 126274 | Significant Tree 6 | Corymbia ficifolia :: Red Flowering Gum 28 | 1240 Lombard St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | Width 6ft | 6006421.51674 | 2120105.21307 | 37.8017672864012 | -122.421948716173 | (37.8017672864012, -122.421948716173) | 5 | 9 | 1 | 28858 | 32 | |||
71 | 227799 | DPW Maintained 1 | Liquidambar styraciflua :: American Sweet Gum 37 | 1265 Stanyan St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/01/2020 12:00:00 AM | 17 | 6x6 | 5997473.24622 | 2105221.8097 | 37.760392645519 | -122.451839397566 | (37.760392645519, -122.451839397566) | 15 | 5 | 11 | 29492 | 12 | ||
72 | 135801 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 16 Phoenix Ter | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 2ft | 6008610.92916 | 2117913.61927 | 37.7958729471262 | -122.414217164494 | (37.7958729471262, -122.414217164494) | 5 | 1 | 10 | 308 | 21 | |||
73 | 127010 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 1931 Union St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6003752.87677 | 2118634.51429 | 37.7975782631807 | -122.431078412364 | (37.7975782631807, -122.431078412364) | 13 | 9 | 1 | 57 | 17 | |||
77 | 225344 | DPW Maintained 1 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 | 207 Randall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6004214.46195 | 2097518.65353 | 37.7396253677099 | -122.42797572342 | (37.7396253677099, -122.42797572342) | 2 | 7 | 5 | 63 | 7 | |||
78 | 237365 | DPW Maintained 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 40 | 2463 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008244.71386 | 2104091.00553 | 37.7578987598438 | -122.414505749733 | (37.7578987598438, -122.414505749733) | 2 | 4 | 7 | 28859 | 19 | |||
79 | 121399 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 349X Cargo Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | |||||||||||||||
80 | 260998 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 600X Lake Merced Blvd | 1 | Sidewalk: Property side : Yard | Tree | SFUSD 4 | 10x10 | ||||||||||||||
82 | 251210 | DPW Maintained 1 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 42 | 1170 Ingalls St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/02/1992 12:00:00 AM | ||||||||||||||
83 | 259099 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 600 Visitacion Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | ||||||||||||
84 | 254457 | Significant Tree 6 | Dodonaea viscosa :: Hop Bush 43 | 1055X Duncan St | 2 | Side Yard : Yard | Tree | Private 2 | |||||||||||||||
85 | 259368 | DPW Maintained 1 | Ginkgo biloba 'Autumn Gold' :: Ginkgo: Autumn Gold 3 | 1646 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
86 | 239818 | DPW Maintained 1 | Pyrus calleryana :: Ornamental Pear 44 | 219 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007803 | 2098062 | 37.7413196437149 | -122.415606526646 | (37.7413196437149, -122.415606526646) | 2 | 7 | 7 | 28859 | 2 | |||
87 | 259654 | DPW Maintained 1 | :: 45 | 101x Cora St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | |||||||||||||
88 | 259653 | DPW Maintained 1 | :: 45 | 99x Cora St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
89 | 259623 | DPW Maintained 1 | :: 45 | 1498x Visitacion Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 06/01/2019 12:00:00 AM | 3 | ||||||||||||
90 | 259864 | DPW Maintained 1 | Tristaniopsis laurina :: Swamp Myrtle 1 | 1398x Brussels St | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 03/30/2019 12:00:00 AM | 3 | |||||||||||||
91 | 260225 | DPW Maintained 1 | Melaleuca quinquenervia :: Cajeput 10 | 2201x 22nd Ave | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/20/2018 12:00:00 AM | 3 | ||||||||||||
92 | 260521 | DPW Maintained 1 | Leucodendron argenteum :: Silver Tree 46 | 3519x Kirkham St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | ||||||||||||
93 | 260525 | DPW Maintained 1 | Leptospermum laevigatum :: Australian Tea Tree 47 | 3437x Rivera St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 07/27/2019 12:00:00 AM | 3 | ||||||||||||
94 | 260654 | Permitted Site 7 | :: 45 | 2590 Buchanan St | 1 | Sidewalk: Curb side : Cutout | Landscaping | Private 2 | 10/03/2019 12:00:00 AM | 3 | 3.5x3 | ||||||||||||
95 | 261359 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 3 Bache St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007238 | 2095678 | 37.7347419306018 | -122.417391193891 | (37.7347419306018, -122.417391193891) | 2 | 7 | 7 | 28859 | 2 | ||||
96 | 137041 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1034 Sacramento St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/28/2020 12:00:00 AM | 3 | Width 3ft | 6009697.84819 | 2116804.05029 | 37.7928873337267 | -122.410377820179 | (37.7928873337267, -122.410377820179) | 3 | 1 | 10 | 28857 | 21 | ||
97 | 261358 | DPW Maintained 1 | Prunus cerasifera :: Cherry Plum 7 | 2x Bache St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6007175 | 2095707 | 37.7348180134015 | -122.417611061749 | (37.7348180134015, -122.417611061749) | 2 | 7 | 7 | 28859 | 2 | ||||
98 | 261380 | DPW Maintained 1 | Potential Site :: Potential Site 48 | 298x Leavenworth St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6008523 | 2113477 | 37.7836861327236 | -122.414207368753 | (37.7836861327236, -122.414207368753) | 7 | 10 | 9 | 28852 | 36 | ||||
99 | 255073 | Private 9 | Tree(s) :: 17 | 173R Glenview Dr | Back Yard : Yard | Tree | Private 2 | ||||||||||||||||
100 | 255131 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 401X Brotherhood Way | 9 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
101 | 255229 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 300X Goettingen St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | ||||||||||||||
102 | 258152 | DPW Maintained 1 | Magnolia grandiflora 'Saint Mary' :: Saint Mary Magnolia 49 | 500X Bryant St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 3 | |||||||||||||
103 | 253831 | DPW Maintained 1 | :: 45 | 699X Polk St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | DPW | 3x3 | |||||||||||||
104 | 260590 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 3099x Jennings St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/20/2020 12:00:00 AM | 3 | ||||||||||||
105 | 70839 | DPW Maintained 1 | Lophostemon confertus :: Brisbane Box 11 | 939 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12 | 6010931.16123 | 2112337.60471 | 37.780692593337 | -122.405795716794 | (37.780692593337, -122.405795716794) | 14 | 2 | 9 | 28853 | 34 | |||
106 | 251438 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2501X Santiago St | 1 | Median : Yard | Tree | DPW 1 | |||||||||||||||
107 | 264818 | DPW Maintained 1 | Podocarpus gracilor :: Fern Pine 51 | 101x Olmstead St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/23/2020 12:00:00 AM | 3 | |||||||||||||
111 | 97355 | Permitted Site 7 | Tree(s) :: 17 | 5 | Unaccepted Street : Yard | Tree | Private 2 | ||||||||||||||||
113 | 182915 | DPW Maintained 1 | :: 45 | 2711 47th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5981812.2124 | 2096648.8938 | 37.7359443944789 | -122.505367292654 | (37.7359443944789, -122.505367292654) | 1 | 8 | 3 | 29491 | 35 | |||
114 | 251458 | DPW Maintained 1 | Jacaranda mimosifolia :: Jacaranda 50 | 651 Texas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/03/2017 12:00:00 AM | 3 | 3x3 | ||||||||||||
115 | 121173 | Significant Tree 6 | Tree(s) :: 17 | 950 Duncan St | 2 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6000333 | 2099683 | 37.7453477932295 | -122.441551386161 | (37.7453477932295, -122.441551386161) | 2 | 7 | 5 | 63 | 22 | ||||
116 | 113159 | Undocumented 4 | Eucalyptus Spp :: Eucalyptus 52 | 555 GROVE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6005146 | 2111243 | 37.777361853017 | -122.425731455878 | (37.777361853017, -122.425731455878) | 7 | 9 | 11 | 28852 | 10 | ||||
117 | 108152 | Undocumented 4 | Ficus nitida :: Laurel Fig 53 | 2232 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6003295.44003 | 2116396.66877 | 37.7914077834913 | -122.432501340527 | (37.7914077834913, -122.432501340527) | 13 | 9 | 1 | 29490 | 27 | |||||
118 | 236256 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 151 Valencia St | 1 | : | Tree | Private 2 | 9 | Width 4ft | 6006073.15075 | 2108915.83898 | 37.7710243776945 | -122.422358744984 | (37.7710243776945, -122.422358744984) | 8 | 2 | 9 | 28853 | 19 | |||
119 | 184195 | DPW Maintained 1 | :: 45 | 1459 37th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 0ft | 5984624.9154 | 2105245.6219 | 37.759713770345 | -122.49627690204 | (37.759713770345, -122.49627690204) | 1 | 8 | 3 | 56 | 35 | |||
120 | 141225 | DPW Maintained 1 | :: 45 | 3 COMMONWEALTH AVE | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 0 | Width 0ft | 5996479.075 | 2114520.1031 | 37.7858663452689 | -122.455949967769 | (37.7858663452689, -122.455949967769) | 11 | 6 | 1 | 54 | 31 | |||
122 | 17067 | DPW Maintained 1 | Ficus retusa nitida :: Banyan Fig 54 | 1355 Oak St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000506.9486 | 2109572.2346 | 37.7725111167076 | -122.441659471159 | (37.7725111167076, -122.441659471159) | 15 | 5 | 11 | 29492 | 9 | |||
123 | 221263 | DPW Maintained 1 | Betula spp :: Birch 55 | 1 Church St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | Width 6ft | 6004132.36771 | 2108477.00924 | 37.7697097883113 | -122.429040680782 | (37.7697097883113, -122.429040680782) | 7 | 9 | 5 | 29492 | 10 | |||
124 | 114040 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 95 LINARES AVE | 1 | Front Yard : Yard | Tree | DPW 1 | 40 | 3x3 | 5994258 | 2102054 | 37.7515099774588 | -122.462729551044 | (37.7515099774588, -122.462729551044) | 1 | 8 | 4 | 29491 | 40 | |||
125 | 92934 | Undocumented 4 | Ligustrum lucidum :: Glossy Privet 57 | 339 West Portal Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5992211 | 2096907 | 37.737259523291 | -122.46943364564 | (37.737259523291, -122.46943364564) | 1 | 8 | 4 | 59 | 40 | ||||
126 | 173890 | DPW Maintained 1 | Maytenus boaria :: Mayten 58 | 2593 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5989209 | 2097724 | 37.7393288482101 | -122.479872589648 | (37.7393288482101, -122.479872589648) | 1 | 8 | 3 | 29491 | 35 | ||||
127 | 119777 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) |
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) );