home / trees

Street_Tree_List

Data source: data.sfgov.org

191,550 rows

View and edit SQL

Link rowid TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods
101 100096 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11 495 Jefferson St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
102 100097 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11 495 Jefferson St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
103 100098 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11 495 Jefferson St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
104 100099 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11 495 Jefferson St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
105 1001 DPW Maintained 1 Ulmus pumila :: Siberian Elm 31 1731 Alemany Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     27 3X3   6001471.07065 2092002.59485 37.724323951976 -122.437066353202 (37.724323951976, -122.437066353202) 9 7 6 28861 25
106 10010 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 174 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   01/16/2002 12:00:00 AM 6 3x3   6005413.242819999 2107997.40019 37.768465318158704 -122.42457604687401 (37.7684653181587, -122.424576046874) 8 4 5 28853 19
107 100100 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11 495 Jefferson St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
108 100101 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11 495 Jefferson St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
109 100102 Undocumented 3 Ficus carica :: Edible Fig 32 495@ Beach Jefferson St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6006848.2 2122207.6 37.807563959210206 -122.42062152066002 (37.8075639592102, -122.42062152066) 5 1 1 28858 32
110 100103 Undocumented 3 Pittosporum crassifolium :: Karo Tree 33 461 Jefferson St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007004.8 2122229.7 37.807633464576796 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
111 100104 Undocumented 3 Pittosporum crassifolium :: Karo Tree 33 461 Jefferson St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007004.8 2122229.7 37.807633464576796 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
112 100105 Undocumented 3 Pittosporum crassifolium :: Karo Tree 33 461 Jefferson St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007004.8 2122229.7 37.807633464576796 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
113 100106 Undocumented 3 Ficus nitida :: Laurel Fig 18 461 Jefferson St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007004.8 2122229.7 37.807633464576796 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
114 100107 Undocumented 3 Ficus nitida :: Laurel Fig 18 461 Jefferson St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007004.8 2122229.7 37.807633464576796 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
115 100108 Undocumented 3 Ficus nitida :: Laurel Fig 18 461 Jefferson St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007004.8 2122229.7 37.807633464576796 -122.420081138169 (37.8076334645768, -122.420081138169) 5 1 1 308 32
116 100109 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
117 10011 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 198 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     25 2X3   6005417.15338 2107897.14895 37.76819027309789 -122.424555388522 (37.7681902730979, -122.424555388522) 8 4 5 28853 19
118 100110 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
119 100111 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
120 100112 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
121 100113 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
122 100114 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
123 100115 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
124 100116 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
125 100117 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
126 100118 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 10 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
127 100119 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 11 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
128 100120 Undocumented 3 Lophostemon confertus :: Brisbane Box 9 333 Jefferson St 12 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6007662.0 2121967.0 37.8069491634687 -122.41778810344101 (37.8069491634687, -122.417788103441) 5 1 10 308 23
129 100121 Significant Tree 4 Myoporum laetum :: Myoporum 27 690 Miramar Ave 1 Front Yard : Yard 4 Tree 1 Private 2           5995444.4 2093941.6 37.729303587844704 -122.45803982404199 (37.7293035878447, -122.458039824042) 9 7 4 28861 40
130 100123 Undocumented 3 Acacia melanoxylon :: Blackwood Acacia 21 690 Miramar Ave 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2           5995444.4 2093941.6 37.729303587844704 -122.45803982404199 (37.7293035878447, -122.458039824042) 9 7 4 28861 40
131 100124 Significant Tree 4 Radermachera sinica :: China Doll Tree 34 40@ San Ramon Eastwood Dr 1 Front Yard : Yard 4 Tree 1 Private 2           5995635.0 2092781.0 37.7261278087338 -122.457296979484 (37.7261278087338, -122.457296979484) 9 7 4 28861 40
132 100125 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 1800 Washington St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11     6005967.88782 2116944.18436 37.793062307639204 -122.423293649581 (37.7930623076392, -122.423293649581) 13 9 1 28858 27
133 100126 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 1800 Washington St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14     6005948.98718 2116940.10629 37.7930500435754 -122.423358756926 (37.7930500435754, -122.423358756926) 13 9 1 28858 27
134 100127 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 1800 Washington St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     13     6005919.013280001 2116937.33835 37.793040751777895 -122.423462271584 (37.7930407517779, -122.423462271584) 13 9 1 28858 27
135 100128 DPW Maintained 1 Platanus x hispanica :: Sycamore: London Plane 11 1800 Washington St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     12     6005897.30712 2116933.8296 37.7930298924771 -122.42353712664499 (37.7930298924771, -122.423537126645) 13 9 1 28858 27
136 100129 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 155 05th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6011082.10119 2112775.22352 37.7819026320456 -122.40530436681401 (37.7819026320456, -122.405304366814) 12 2 9 28853 34
137 10013 DPW Maintained 1 Ligustrum lucidum :: Glossy Privet 12 215 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     12 3x2   6005495.275 2107715.11687 37.7676948680391 -122.42427222529899 (37.7676948680391, -122.424272225299) 8 4 5 28853 19
138 100130 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 155 05th St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6011065.09249 2112790.5825400003 37.7819438533601 -122.40536429132601 (37.7819438533601, -122.405364291326) 12 2 9 28853 34
139 100131 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 155 05th St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6011051.59118 2112804.91213 37.781982444176705 -122.405412009362 (37.7819824441767, -122.405412009362) 12 2 9 28853 34
140 100132 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 155 05th St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6011001.43438 2112862.15185 37.782136806515496 -122.405589562524 (37.7821368065155, -122.405589562524) 12 2 9 28853 34
141 100133 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 155 05th St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6010986.38868 2112879.38733 37.7821832897709 -122.405642828459 (37.7821832897709, -122.405642828459) 12 2 9 28853 34
142 100134 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 155 05th St 6 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6010970.105930001 2112898.8843900003 37.782235913593 -122.40570053346902 (37.782235913593, -122.405700533469) 12 2 9 28853 34
143 100135 Undocumented 3 Tree(s) :: 13 155 05th St 1 Front Yard : Yard 4 Tree 1 Private 2   11/27/2012 12:00:00 AM 9   Permit Number 769351 6011029.6 2112857.4 37.782125333955705 -122.40549178692301 (37.7821253339557, -122.405491786923) 12 2 9 28853 34
144 100136 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 155 05th St 7 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   10/02/2012 12:00:00 AM 3 3x3 Permit Number 769024 6010957.25903 2112913.8393900003 37.782276258096296 -122.405746031954 (37.7822762580963, -122.405746031954) 12 2 9 28853 34
145 100137 Undocumented 3 Tree(s) :: 13 155 05th St 8 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Permit Number 769024 6011029.6 2112857.4 37.782125333955705 -122.40549178692301 (37.7821253339557, -122.405491786923) 12 2 9 28853 34
146 100138 Undocumented 3 Tree(s) :: 13 155 05th St 9 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3 Permit Number 769024 6011029.6 2112857.4 37.782125333955705 -122.40549178692301 (37.7821253339557, -122.405491786923) 12 2 9 28853 34
147 100139 Property Tree 5 Tree(s) :: 13 155 05th St 2 Front Yard : Yard 4 Tree 1 Private 2         Permit Number 769024 6011029.6 2112857.4 37.782125333955705 -122.40549178692301 (37.7821253339557, -122.405491786923) 12 2 9 28853 34
148 100145 Undocumented 3 Liriodendron tulipifera :: Tulip Tree 35 222X Cumberland St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6004147.2 2104574.7 37.75899582353679 -122.428711154895 (37.7589958235368, -122.428711154895) 2 4 5 28862 3
149 100146 Undocumented 3 Liriodendron tulipifera :: Tulip Tree 35 222X Cumberland St 5 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6004147.2 2104574.7 37.75899582353679 -122.428711154895 (37.7589958235368, -122.428711154895) 2 4 5 28862 3
150 100147 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 3955 18th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6003272.0 2105332.0 37.761025616168396 -122.431792078279 (37.7610256161684, -122.431792078279) 2 4 5 28862 3
151 100148 Property Tree 5 Tree(s) :: 13 209 Vicksburg St   Back Yard : Yard 6 Tree 1 Private 2           6004141.0 2102142.0 37.7523158521071 -122.428559192815 (37.7523158521071, -122.428559192815) 2 4 5 28862 22
152 100149 Undocumented 3 Tree(s) :: 13 3975 18th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3   6003144.0 2105325.0 37.760999139175794 -122.43223427442499 (37.7609991391758, -122.432234274425) 2 4 5 28862 3
153 10015 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 232 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   10/24/2012 12:00:00 AM 1 2x3   6005430.70254 2107623.5907900003 37.7674399129618 -122.424489062615 (37.7674399129618, -122.424489062615) 8 4 5 28853 19
154 100150 Undocumented 3 Pyrus calleryana :: Ornamental Pear 28 4007 18th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3 3x3   6002942.0 2105314.0 37.7609574805046 -122.432932117926 (37.7609574805046, -122.432932117926) 2 4 5 28862 3
155 100151 Undocumented 3 Magnolia spp :: Magnolia 37 4047 18th St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2 5x5 Permit Number 776452 6002690.0 2105300.0 37.760904743288705 -122.433802674054 (37.7609047432887, -122.433802674054) 2 4 5 28862 3
156 100152 Undocumented 3 Callistemon viminalis :: Weeping Bottlebrush 36 500X Noe St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     8 3x3   6002933.4 2105264.1 37.760819979332105 -122.432958296422 (37.7608199793321, -122.432958296422) 2 4 5 28862 3
157 100153 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 590 08th Ave 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     10   Permit Number 780398 5993481.43699 2111479.23814 37.7773444498569 -122.46609982361299 (37.7773444498569, -122.466099823613) 11 6 2 54 11
158 100154 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 39 421 Arguello Blvd 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/09/2012 12:00:00 AM 2 3x3 Permit Number 768665 5995548.20979 2113421.38615 37.7827960924124 -122.459090895565 (37.7827960924124, -122.459090895565) 11 6 2 54 11
159 100155 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 39 421 Arguello Blvd 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/09/2012 12:00:00 AM 1 3x3 Permit Number 768665 5995547.63901 2113410.0857599997 37.782765031751296 -122.459092051698 (37.7827650317513, -122.459092051698) 11 6 2 54 11
160 100156 DPW Maintained 1 Magnolia grandiflora :: Southern Magnolia 39 421 Arguello Blvd 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/09/2012 12:00:00 AM 2 3x3 Permit Number 768665 5995549.3318 2113386.41255 37.782700128760794 -122.45908448070101 (37.7827001287608, -122.459084480701) 11 6 2 54 11
161 100157 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11 14 Broderick St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           6001430.1 2108737.2 37.7702708737839 -122.438406367889 (37.7702708737839, -122.438406367889) 15 5 11 29492 9
162 100158 Permitted Site 2 Platanus x hispanica :: Sycamore: London Plane 11 14 Broderick St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/09/2012 12:00:00 AM     Permit Number 769008 6001430.1 2108737.2 37.7702708737839 -122.438406367889 (37.7702708737839, -122.438406367889) 15 5 11 29492 9
163 100160 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 1699 Vallejo St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11   Permit Number 28164 6005505.58523 2118187.22554 37.7964492830571 -122.424981725648 (37.7964492830571, -122.424981725648) 13 9 1 28858 27
164 100161 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 1699 Vallejo St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     2   Permit Number 28164 6005519.03005 2118189.86695 37.7964572951359 -122.42493539165599 (37.7964572951359, -122.424935391656) 13 9 1 28858 27
165 100162 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 1699 Vallejo St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     3   Permit Number 28164 6005532.34096 2118193.0872400003 37.7964668890905 -122.424889562218 (37.7964668890905, -122.424889562218) 13 9 1 28858 27
166 100163 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 1814 Union St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     18     6004278.90656 2118759.95598 37.797952487273605 -122.429267157958 (37.7979524872736, -122.429267157958) 13 9 1 57 17
167 100164 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 839 Leavenworth St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   6008231.9319 2115379.46118 37.7888934760005 -122.41534908182 (37.7888934760005, -122.41534908182) 13 1 10 28858 21
168 100165 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 839 Leavenworth St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     14 3x3   6008234.89338 2115366.55149 37.7888581955857 -122.415337921201 (37.7888581955857, -122.415337921201) 13 1 10 28858 21
169 100166 Property Tree 5 Salix spp :: Willow 40 2340 Twin Peaks Blvd   Front Yard : Yard 4 Tree 1 Private 2         Permit Number 769026                    
170 100167 Permitted Site 2 Corymbia ficifolia :: Red Flowering Gum 5 710 El Camino Del Mar 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5986405.6 2114870.0 37.7862437457696 -122.49082666767099 (37.7862437457696, -122.490826667671) 11 6 1 55 33
171 100168 Permitted Site 2 Metrosideros excelsa :: New Zealand Xmas Tree 3 710 El Camino Del Mar 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2           5986405.6 2114870.0 37.7862437457696 -122.49082666767099 (37.7862437457696, -122.490826667671) 11 6 1 55 33
172 100169 DPW Maintained 1 Pinus radiata :: Monterey Pine 1 180X Manchester St   Back Yard : Yard 6 Tree 1 DPW 1         Adjacent to rear of property - DPW parcel 6008242.0 2099158.0 37.7443536844995 -122.414166136282 (37.7443536844995, -122.414166136282) 2 7 7 28859 2
173 10017 DPW Maintained 1 Tristaniopsis laurina :: Swamp Myrtle 8 240 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1   10/24/2012 12:00:00 AM 1 3x3   6005435.617430001 2107572.1515 37.7672989505107 -122.42446840339198 (37.7672989505107, -122.424468403392) 8 4 5 28853 19
174 100170 DPW Maintained 1 Tree(s) :: 13 2149 Grove St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/11/2012 12:00:00 AM 4 3x3 Permit Number 769012 5997531.0 2110183.0 37.774018114579896 -122.451997596236 (37.7740181145799, -122.451997596236) 15 5 11 29492 16
175 100171 Significant Tree 4 Quercus suber :: Cork Oak 41 109 Edgewood Ave 1 Front Yard : Yard 4 Tree 1 Private 2           5996563.8 2106359.1 37.763463224843996 -122.455066914463 (37.763463224844, -122.455066914463) 15 5 11 29492 12
176 100174 Undocumented 3 Tree(s) :: 13 50 O'Farrell St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/12/2012 12:00:00 AM 18 3x3 Permit Number 769094 6010932.2 2114627.3 37.7869796149513 -122.405953468587 (37.7869796149513, -122.405953468587) 5 10 10 28857 6
177 100175 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 9 1140 Page St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/12/2012 12:00:00 AM   3x3 Permit Number 768230 6001099.0 2109378.2 37.772012061027006 -122.43959759817301 (37.772012061027, -122.439597598173) 15 5 11 29492 9
178 100177 Permitted Site 2 Pinus radiata :: Monterey Pine 1 252 States St 3 Front Yard : Yard 4 Tree 1 Private 2         Permit Number 768965 6000636.0 2106677.4 37.764569975148895 -122.44100535545 (37.7645699751489, -122.44100535545) 15 5 5 28862 3
179 100178 Permitted Site 2 Olea europaea :: Olive Tree 42 1270 Sanchez St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/06/2012 12:00:00 AM   3x3   6003851.0 2100874.0 37.748817804949496 -122.42947164058 (37.7488178049495, -122.42947164058) 2 4 5 28862 22
180 100179 Permitted Site 2 Olea europaea :: Olive Tree 42 1270 Sanchez St 4 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/06/2012 12:00:00 AM   3x3   6003851.0 2100874.0 37.748817804949496 -122.42947164058 (37.7488178049495, -122.42947164058) 2 4 5 28862 22
181 10018 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 205 Guerrero St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   09/28/1993 12:00:00 AM 6 3x3   6005510.9123943 2107567.8958458 37.767291517220706 -122.42420766586201 (37.7672915172207, -122.424207665862) 8 4 5 28853 19
182 100180 Undocumented 3 Liquidambar styraciflua :: American Sweet Gum 44 100x BELVEDERE ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   5997991.0 2108152.0 37.768467847026294 -122.450259955793 (37.7684678470263, -122.450259955793) 15 5 11 29492 9
183 100181 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 230 Ritch St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     15     6013794.16577 2112184.81721 37.7804327665865 -122.39588042503999 (37.7804327665865, -122.39588042504) 6 2 9 28856 34
184 100182 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 6 230 Ritch St 3 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     20     6013808.29227 2112170.33848 37.7803937971776 -122.39583053966001 (37.7803937971776, -122.39583053966) 6 2 9 28856 34
185 100183 Permitted Site 2 Tree(s) :: 13 956 Noe St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2       3x3   6003075.2 2102641.9 37.7536280862965 -122.432280596021 (37.7536280862965, -122.432280596021) 2 4 5 28862 22
186 100184 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 3 480 Oxford St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     11 3x3   6006818.05082 2091764.69226 37.7239732025834 -122.418565697766 (37.7239732025834, -122.418565697766) 9 7 7 309 28
187 100186 DPW Maintained 1 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 2445 HARRISON ST 3 Sidewalk: Curb side : Cutout 2 Tree 1 DPW 1     8 3x3   6008897.0 2104213.0 37.758270352242796 -122.41225848424999 (37.7582703522428, -122.41225848425) 2 4 7 28859 19
188 100187 Permitted Site 2 Callistemon citrinus :: Lemon Bottlebrush 45 217 Montcalm St 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/18/2012 12:00:00 AM   3x3 Permit Number 768935 6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229) 2 7 7 28859 2
189 100188 Permitted Site 2 Callistemon citrinus :: Lemon Bottlebrush 45 217 Montcalm St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/18/2012 12:00:00 AM   3x3 Permit Number 768935 6009833.3 2099565.6 37.7455621186719 -122.40869248022899 (37.7455621186719, -122.408692480229) 2 7 7 28859 2
190 100189 DPW Maintained 1 Magnolia grandiflora 'Russet' :: Russet Magnolia 46 160 Palm Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     1 3x3 Permit Number 772698 5995944.7835 2113256.71049 37.782366726791295 -122.457707006716 (37.7823667267913, -122.457707006716) 11 6 1 54 31
191 10019 Permitted Site 2 Prunus cerasifera :: Cherry Plum 43 205 Guerrero St 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2     6 3x3   6005510.9123943 2107567.8958458 37.767291517220706 -122.42420766586201 (37.7672915172207, -122.424207665862) 8 4 5 28853 19
192 100190 Undocumented 3 Tree(s) :: 13 404 Noriega St 2 Sidewalk: Property side : Yard 5 Tree 1 Private 2   01/07/2016 12:00:00 AM     Permit Number 776979 5992802.0 2103239.0 37.754679716601 -122.467850713731 (37.754679716601, -122.467850713731) 1 8 4 56 12
193 100191 Significant Tree 4 Pinus radiata :: Monterey Pine 1 1201 Holloway Ave 1 Front Yard : Yard 4 Tree 1 Private 2           5992431.5 2091178.1 37.721542125529396 -122.46825464021099 (37.7215421255294, -122.468254640211) 9 8 6 64 24
194 100192 Undocumented 3 Magnolia grandiflora :: Southern Magnolia 39 62 Nordhoff St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2       3x6   6000448.0 2095531.0 37.7339539318334 -122.440855946438 (37.7339539318334, -122.440855946438) 9 7 5 63 40
195 100193 Significant Tree 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 361 Dellbrook Ave 1 Front Yard : Yard 4 Tree 1 Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
196 100194 Significant Tree 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 361 Dellbrook Ave 2 Front Yard : Yard 4 Tree 1 Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
197 100195 Significant Tree 4 Prunus cerasifera 'Krauter vesuvius' :: Purple Leaf Plum Krauter Vesuvius 30 361 Dellbrook Ave 3 Front Yard : Yard 4 Tree 1 Private 2           5997322.2 2102403.9 37.7526467193673 -122.45215846969 (37.7526467193673, -122.45215846969) 1 5 4 63 38
198 100197 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 81 05th Ave 1 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/18/2012 12:00:00 AM 21   Permit Number 769099 5994240.47669 2115083.18474 37.7872836759267 -122.46373572008301 (37.7872836759267, -122.463735720083) 11 6 1 54 11
199 100198 DPW Maintained 1 Pittosporum undulatum :: Victorian Box 38 81 05th Ave 2 Sidewalk: Curb side : Cutout 2 Tree 1 Private 2   07/18/2012 12:00:00 AM 22   Permit Number 769099 5994239.2285400005 2115068.80691 37.7872441264014 -122.463738994433 (37.7872441264014, -122.463738994433) 11 6 1 54 11
200 100199 Undocumented 3 Platanus x hispanica :: Sycamore: London Plane 11 739 Foerster St 1 Sidewalk: Property side : Yard 5 Tree 1 Private 2           5998111.0 2095813.0 37.7345948616995 -122.44895594133499 (37.7345948616995, -122.448955941335) 9 7 4 59 40

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
  "qLegalStatus" INTEGER,
  "qSpecies" INTEGER,
  "qAddress" TEXT,
  "SiteOrder" INTEGER,
  "qSiteInfo" INTEGER,
  "PlantType" INTEGER,
  "qCaretaker" INTEGER,
  "qCareAssistant" INTEGER,
  "PlantDate" REAL,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" REAL,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT,
  "Fire Prevention Districts" INTEGER,
  "Police Districts" INTEGER,
  "Supervisor Districts" INTEGER,
  "Zip Codes" INTEGER,
  "Neighborhoods" INTEGER
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id))
Powered by Datasette · Query took 10.611ms · Data source: data.sfgov.org