194,517 rows sorted by qCaretaker_id

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)
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
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
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                      
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                        
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
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
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
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
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
79 121399 DPW Maintained 1 Corymbia ficifolia :: Red Flowering Gum 28 349X Cargo Way 1 Sidewalk: Curb side : Cutout Tree DPW 1                              
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                        
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                            
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                        
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
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                        
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                        
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                        
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
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
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)          
129 107934 DPW Maintained 1 Tree(s) :: 17 3098X Market St 3 Median : Yard Tree DPW 1           5999920 2105144 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916) 2 4 5 28862 3
130 13128 DPW Maintained 1 Tristania conferta :: 61 1714 Lombard St 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6004131.2449 2119777.2826 37.8007374433085 -122.429850711739 (37.8007374433085, -122.429850711739) 13 9 1 57 17
133 211075 DPW Maintained 1 Pinus pinea :: Italian Stone Pine 63 650x Miramar Ave 6 Median : Yard Tree DPW 1     34     5995390.83549 2093912.64173 37.7292209976493 -122.458222905073 (37.7292209976493, -122.458222905073) 9 7 4 28861 40
134 257900 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 5701x 03rd St 7 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6014158 2092336 37.7259523956068 -122.393232416121 (37.7259523956068, -122.393232416121) 10 3 8 58 1
136 11131 DPW Maintained 1 Olea europaea :: Olive Tree 9 2400X Hyde St 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6007074.9072505 2120528.613771 37.802966665104 -122.419717737051 (37.802966665104, -122.419717737051) 5 1 1 28858 32
137 189330 DPW Maintained 1 Cordyline australis :: Dracena Palm 64 1427x Innes Ave 23 Median : Yard Tree DPW 1     15     6016163.75351 2096735.77367 37.7381445215441 -122.386605256348 (37.7381445215441, -122.386605256348) 10 3 8 58 1
139 106382 DPW Maintained 1 Tree(s) :: 17 182x Lower Ter 9 Median : Cutout Tree DPW 1       10x10   6000081.12192 2106216.81045 37.7632736910742 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
154 119838 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 11 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
160 107490 DPW Maintained 1 Prunus spp :: Cherry 68 1306x Montgomery St 19 Median : Cutout Tree DPW 1     12     6011447.18476 2119974.76336 37.8016912541172 -122.404548295963 (37.8016912541172, -122.404548295963) 3 1 10 308 23
161 194506 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 299x Cashmere St 26 Median : Yard Tree DPW 1     18     6016624.93937 2096021.78221 37.7362095654157 -122.384960961105 (37.7362095654157, -122.384960961105) 10 3 8 58 1
163 17253 DPW Maintained 1 Eucalyptus Spp :: Eucalyptus 52 15 Osceola Ln 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6017345.102761 2094248.0837329 37.7313791485056 -122.382347671583 (37.7313791485056, -122.382347671583) 10 3 8 58 1
166 8632 DPW Maintained 1 Myoporum laetum :: Myoporum 62 2600 Geary Blvd 20 Median : Cutout Tree DPW 1     12 20   5999387.1761445 2113256.6615953 37.7825637442266 -122.445797886011 (37.7825637442266, -122.445797886011) 15 5 1 29490 31
172 176155 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 900X Brotherhood Way 9 Median : Cutout Tree DPW 1     25 10x10   5988860 2088745 37.7146545182747 -122.480422197946 (37.7146545182747, -122.480422197946) 1 8 4 64 14
173 27068 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 801 Silver Ave 10 Sidewalk: Curb side : Cutout Tree DPW 1     3 4   6006971.0744 2093616.11167 37.7290654140285 -122.418167915919 (37.7290654140285, -122.418167915919) 9 3 7 309 28
181 14420 DPW Maintained 1 Metrosideros excelsa :: New Zealand Xmas Tree 16 2X Masonic Ave 8 Median : Cutout Tree DPW 1     35     5998841.5976 2113071.3194 37.7820236767836 -122.447671998063 (37.7820236767836, -122.447671998063) 15 5 2 54 16
182 20628 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1492X Sunset Blvd 11 Median : Cutout Tree DPW 1     36 60   5984803.7392562 2105036.6950477 37.7591505890295 -122.495643037613 (37.7591505890295, -122.495643037613) 1 8 3 56 35
184 204541 DPW Maintained 1 Callistemon citrinus :: Lemon Bottlebrush 67 400x Marietta Dr 4 Median : Cutout Tree DPW 1     16 Width 3ft   5999538.51913 2097033.8732 37.7380286277303 -122.444108242518 (37.7380286277303, -122.444108242518) 9 7 4 59 40
186 30163 DPW Maintained 1 Shrub :: Shrub 66 410X Mansell St 20 Median : Cutout Tree DPW 1     0 POT   6010678.994322 2090457.626596 37.7206008798567 -122.405126964413 (37.7206008798567, -122.405126964413) 10 3 7 309 28
187 112917 DPW Maintained 1 Shrub :: Shrub 66 480X BEACON ST 1 Sidewalk: Property side : Yard Tree DPW 1           6002571 2098077 37.7410653426557 -122.433697996676 (37.7410653426557, -122.433697996676) 2 7 5 63 7
190 21328 DPW Maintained 1 Cupressus macrocarpa :: Monterey Cypress 41 2501X Sunset Blvd 28 Sidewalk: Curb side : Cutout Tree DPW 1     70 60   5985074.8907349 2098188.1189419 37.740362147215 -122.494200494189 (37.740362147215, -122.494200494189) 1 8 3 29491 35
204 209769 DPW Maintained 1 Maytenus boaria :: Mayten 58 100x Pacheco St 2 Median : Cutout Tree DPW 1     2 Width 3ft   5994792.885 2099741.94773 37.7451924562767 -122.460712331024 (37.7451924562767, -122.460712331024) 1 8 4 59 40
206 119799 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 7 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
210 1023 DPW Maintained 1 Ulmus americana :: American Elm 74 1925 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6000937.4135 2090832.4174 37.7210805620079 -122.438827310136 (37.7210805620079, -122.438827310136) 9 7 6 28861 25
215 119692 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 4x Octavia St 10 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
216 114440 DPW Maintained 1 Acer rubrum :: Red Maple 75 2961 SAN BRUNO AVE 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011605 2091859 37.724500488626 -122.402024501601 (37.724500488626, -122.402024501601) 10 3 7 309 28
225 119839 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 12 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
238 119796 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 4 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
240 26863 DPW Maintained 1 Lophostemon confertus :: Brisbane Box 11 637 Buchanan St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6004510.83387 2110645.31056 37.7756848318303 -122.427886103845 (37.7756848318303, -122.427886103845) 7 9 11 28852 10
243 21365 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 2592X Sunset Blvd 27 Sidewalk: Curb side : Cutout Tree DPW 1     48 60   5985018.1742183 2097562.094386 37.7386399329486 -122.494350460592 (37.7386399329486, -122.494350460592) 1 8 3 29491 35
245 251484 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 900 Bosworth St 7 Front Yard : Yard Tree DPW 1           6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
248 119766 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 204x Octavia St 1 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
249 222839 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 3100x Cesar Chavez St 5 Median : Yard Tree DPW 1     5 Width 10ft   6008877.38377 2100577.11513 37.7482859289696 -122.412069375694 (37.7482859289696, -122.412069375694) 2 4 7 28859 2
263 17585 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 801X Persia Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6003724.8526 2090366.56287 37.71995962001 -122.429158750084 (37.71995962001, -122.429158750084) 9 7 6 28861 5
265 18017 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2713 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6000875.2767 2114835.3915 37.7869833841555 -122.440762994582 (37.7869833841555, -122.440762994582) 13 6 1 29490 27
266 219228 DPW Maintained 1 Ilex spp :: Holly Species 81 200x Terrace Dr 4 Median : Yard Tree DPW 1     10     5993785.97496 2096493.89011 37.736216119669 -122.463958297244 (37.736216119669, -122.463958297244) 1 8 4 59 40
271 107116 DPW Maintained 1 Tree(s) :: 17 300X LIBERTY ST 18 Median : Cutout Tree DPW 1     12     6004270.1 2103982.4 37.7573764628527 -122.428243896062 (37.7573764628527, -122.428243896062) 2 4 5 28862 3
280 8072 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 661 Octavia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6005345.6576 2111619.4154 37.7784066780298 -122.425067563729 (37.7784066780298, -122.425067563729) 7 9 11 28852 10
282 119806 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 251X Octavia St Frontage West 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005545 2110174 37.7744491774234 -122.424275134654 (37.7744491774234, -122.424275134654) 7 9 11 28852 10
285 260625 DPW Maintained 1 Laurus x 'Saratoga' :: Hybrid Laurel 4 1601x Thomas Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1 FUF 08/24/2019 12:00:00 AM 3                        
286 18512 DPW Maintained 1 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 38 626 Powell St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6010135.39241 2115955.1821 37.7905810646201 -122.408803973339 (37.7905810646201, -122.408803973339) 5 1 10 28857 21
289 211158 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 300x Marietta Dr 38 Median : Cutout Tree DPW 1     21 Width 5ft   5999457.51761 2097516.55077 37.7393493243992 -122.444422982731 (37.7393493243992, -122.444422982731) 9 7 4 59 40
300 234411 DPW Maintained 1 Phoenix dactylifera :: Date Palm 87 10x Benton Ave 4 Median : Yard Tree DPW 1     32     6004755.33467 2095032.93123 37.7328307189427 -122.425928720736 (37.7328307189427, -122.425928720736) 2 7 7 28861 2
303 87474 DPW Maintained 1 Tristania conferta :: 61 6290 03rd St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x5   6013182.5276 2090518.895 37.7209087510834 -122.39647726989 (37.7209087510834, -122.39647726989) 10 3 8 58 1
304 132028 DPW Maintained 1 Olea europaea :: Olive Tree 9 33x Battery St 1 Median : Yard Tree DPW 1     27     6012842.61776 2116100.99756 37.7911327033699 -122.399447311639 (37.7911327033699, -122.399447311639) 4 1 10 28854 6
306 20543 DPW Maintained 1 Pinus radiata :: Monterey Pine 15 1303X Sunset Blvd 21 Sidewalk: Curb side : Cutout Tree DPW 1     36 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.495741360313 (37.7626943540195, -122.495741360313) 1 8 3 56 35
313 119729 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104x Octavia St 9 Median : Cutout Tree DPW 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
326 228441 DPW Maintained 1 :: 45 419 Haight St 1 : Tree DPW 1   04/08/2008 12:00:00 AM 6 Width 3ft   6004104.36681 2109385.12417 37.7722016657998 -122.429202297052 (37.7722016657998, -122.429202297052) 7 9 11 29492 10
339 18096 DPW Maintained 1 Prunus serrulata :: Ornamental Cherry 84 3008 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/29/1997 12:00:00 AM 6 3X3   5999424.6928 2114682.6521 37.7864812852303 -122.445770680231 (37.7864812852303, -122.445770680231) 15 6 1 29490 31
342 115652 Property Tree 8 Pinus radiata :: Monterey Pine 15 81x ELSIE ST 18 Back Yard : Cutout Tree DPW 1       3x3   6007403 2098902 37.7436036039275 -122.417049094013 (37.7436036039275, -122.417049094013) 2 7 7 28859 2
343 8621 DPW Maintained 1 Myoporum laetum :: Myoporum 62 2600 Geary Blvd 9 Median : Cutout Tree DPW 1     6 20   5999320.4644 2113213.4566 37.7824413052471 -122.446025570431 (37.7824413052471, -122.446025570431) 15 5 1 54 16
344 119791 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 11 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
345 222831 DPW Maintained 1 Ceiba speciosa :: Silk floss 79 3300x Cesar Chavez St 8 Median : Yard Tree DPW 1     4 Width 10ft   6007377.19749 2100569.29044 37.7481801578885 -122.417256437759 (37.7481801578885, -122.417256437759) 2 4 7 28859 2
353 112597 DPW Maintained 1 Acer rubrum :: Red Maple 75 1200X Divisadero St 7 Median : Cutout Tree DPW 1     3 3x3   6001322.3986 2112740.3429 37.7812563699828 -122.439065850543 (37.7812563699828, -122.439065850543) 15 5 11 29490 41
362 16573 DPW Maintained 1 Myoporum laetum :: Myoporum 62 95X Nido Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   5999200.4791331 2112280.3747819 37.7798724518028 -122.446373519186 (37.7798724518028, -122.446373519186) 15 5 1 54 16
365 184621 DPW Maintained 1 :: 45 3100x Noriega St 1 Median : Cutout Tree DPW 1     0 Width 0ft   5984373.2194 2102928.6488 37.7533372599652 -122.496976365214 (37.7533372599652, -122.496976365214) 1 8 3 56 35
366 141325 DPW Maintained 1 Acer rubrum :: Red Maple 75 600x DIVISADERO ST 2 Median : Cutout Tree DPW 1     3 Width 0ft   6001625.7293 2110577.6985 37.775335548851 -122.437861533023 (37.775335548851, -122.437861533023) 15 5 11 29492 10
371 251215 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 175X Otis St 11 Sidewalk: Curb side : Cutout Tree DPW 1       3X3   6006718.5849914 2108715.6870946 37.7705111956623 -122.420111956743 (37.7705111956623, -122.420111956743) 8 2 9 28853 19
375 115067 DPW Maintained 1 :: 45 70 Coral Rd 7 Sidewalk: Curb side : Cutout Tree DPW 1           6012676.36761 2102522.24683 37.7538392609312 -122.399069018455 (37.7538392609312, -122.399069018455) 10 3 8 28856 29
383 94356 DPW Maintained 1 Tree(s) :: 17 455 Delano Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   5999581.42646 2091332.3229 37.7223759483442 -122.443550437353 (37.7223759483442, -122.443550437353) 9 7 6 28861 25
384 415 DPW Maintained 1 Ulmus pumila :: Siberian Elm 99 3862 19th Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 2X6   5990878.96388 2090116.60552 37.7185377326944 -122.473543893183 (37.7185377326944, -122.473543893183) 9 8 4 64 40
387 106394 DPW Maintained 1 Tree(s) :: 17 182x Lower Ter 21 Median : Cutout Tree DPW 1       10x10   6000081.12192 2106216.81045 37.7632736910742 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3

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