trees
27,746 rows where qCaretaker_id = 1 sorted by PlantDate
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
79 | 121399 | DPW Maintained 1 | Corymbia ficifolia :: Red Flowering Gum 28 | 349X Cargo Way | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | |||||||||||||||
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 | ||||||||||||||
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 | |||||||||||||
106 | 251438 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2501X Santiago St | 1 | Median : Yard | Tree | DPW 1 | |||||||||||||||
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 | ||||
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) | ||||||||||
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 | ||||
395 | 246548 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 20x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 6005741.17746 | 2109432.24964 | 37.7724235852138 | -122.423543772638 | (37.7724235852138, -122.423543772638) | 7 | 9 | 11 | 28852 | 10 | |||
399 | 137749 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 1000x DIVISADERO ST | 8 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001417.6643 | 2112072.2982 | 37.7794275088949 | -122.438688395719 | (37.7794275088949, -122.438688395719) | 15 | 5 | 11 | 29490 | 41 | |||
406 | 119837 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
408 | 109629 | Undocumented 4 | Metrosideros excelsa :: New Zealand Xmas Tree 16 | 200X GELLERT DR | 30 | Median : Cutout | Tree | DPW 1 | 30x200 | 5985380 | 2094516.3 | 37.730298158605 | -122.492875173009 | (37.730298158605, -122.492875173009) | 1 | 8 | 4 | 64 | 35 | ||||
413 | 119686 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
417 | 5101 | DPW Maintained 1 | Myoporum laetum :: Myoporum 62 | 2629 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6002336.13825 | 2096372.73058 | 37.7363724838986 | -122.434388243031 | (37.7363724838986, -122.434388243031) | 2 | 7 | 5 | 63 | 7 | |||
425 | 10157 | DPW Maintained 1 | Lagunaria patersonii :: Primrose Tree 6 | 995 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x7 | 6005745.76106 | 2103227.37374 | 37.7553867222415 | -122.423086804612 | (37.7553867222415, -122.423086804612) | 2 | 4 | 5 | 28859 | 19 | |||
428 | 119830 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2110475 | 6005532 | 47.2700470263222 | -138.279303834774 | (47.2700470263222, -138.279303834774) | ||||||||||
430 | 121151 | DPW Maintained 1 | Pinus radiata :: Monterey Pine 15 | 1X Payson St | 1 | Side Yard : Yard | Tree | DPW 1 | 25 | 3x3 | 5992041 | 2087761 | 37.7121370380572 | -122.469355880776 | (37.7121370380572, -122.469355880776) | 9 | 8 | 4 | 64 | 24 | |||
431 | 119778 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 13 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
433 | 20653 | DPW Maintained 1 | Acacia spp :: Acacia Spp 105 | 1501X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | 5984817.9532367 | 2104951.7766639 | 37.7589182591611 | -122.495587616201 | (37.7589182591611, -122.495587616201) | 1 | 8 | 3 | 56 | 35 | |||
436 | 120628 | DPW Maintained 1 | Pinus canariensis :: Canary Island Pine 35 | 1500 Geary Blvd | 5 | Median : Cutout | Tree | DPW 1 | 6004397 | 2113949 | 37.7847495050096 | -122.428515420401 | (37.7847495050096, -122.428515420401) | 13 | 9 | 11 | 29490 | 41 | |||||
439 | 8729 | DPW Maintained 1 | Callistemon citrinus :: Lemon Bottlebrush 67 | 3200 Geary Blvd | 9 | Median : Cutout | Tree | DPW 1 | 6 | M6 | 5997259.3218258 | 2113018.202003 | 37.7817872731337 | -122.453142084637 | (37.7817872731337, -122.453142084637) | 15 | 6 | 1 | 54 | 31 | |||
442 | 119718 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 11 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
444 | 105900 | DPW Maintained 1 | Eucalyptus globulus :: Blue Gum 56 | 11X ELLIOT ST | 1 | Unaccepted Street : Yard | Tree | DPW 1 | 30 | 6009059 | 2088845 | 37.716082244868 | -122.410612975888 | (37.716082244868, -122.410612975888) | 9 | 7 | 8 | 309 | 18 | ||||
454 | 11293 | DPW Maintained 1 | Eucalyptus Spp :: Eucalyptus 52 | 1199X Ingalls St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6017612.0195749 | 2093925.7037957 | 37.7305086962257 | -122.381402471608 | (37.7305086962257, -122.381402471608) | 10 | 3 | 8 | 58 | 1 | |||
455 | 30164 | DPW Maintained 1 | Shrub :: Shrub 66 | 410X Mansell St | 21 | Median : Cutout | Tree | DPW 1 | 0 | POT | 6010678.994322 | 2090457.626596 | 37.7206008798567 | -122.405126964413 | (37.7206008798567, -122.405126964413) | 10 | 3 | 7 | 309 | 28 | |||
456 | 247507 | DPW Maintained 1 | Acer rubrum :: Red Maple 75 | 400x Divisadero St | 2 | Median : Cutout | Tree | DPW 1 | 3 | Width 0ft | 6001724.6395 | 2109878.2699 | 37.7734207168265 | -122.437469283257 | (37.7734207168265, -122.437469283257) | 15 | 5 | 11 | 29492 | 10 | |||
464 | 173918 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 2160X 09th Ave | 6 | Median : Cutout | Tree | DPW 1 | 6x10 | 5993671 | 2100995 | 37.7485684085064 | -122.464682560698 | (37.7485684085064, -122.464682560698) | 1 | 8 | 4 | 29491 | 40 | ||||
467 | 211626 | DPW Maintained 1 | Pittosporum undulatum :: Victorian Box 36 | 299x Magellan Ave | 6 | Median : Cutout | Tree | DPW 1 | 6 | Width 6ft | 5994442.33797 | 2100102.58449 | 37.7461624991943 | -122.461950600334 | (37.7461624991943, -122.461950600334) | 1 | 8 | 4 | 29491 | 40 | |||
470 | 119711 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 4 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
471 | 205972 | DPW Maintained 1 | Cedrus deodara :: Deodar Cedar 109 | 400x Marietta Dr | 49 | Median : Cutout | Tree | DPW 1 | 2 | Width 3ft | 5998976.04571 | 2096922.6715 | 37.7376911903888 | -122.446044988292 | (37.7376911903888, -122.446044988292) | 9 | 7 | 4 | 59 | 40 | |||
477 | 113497 | DPW Maintained 1 | Tree(s) :: 17 | 200x MANSELL ST | 3 | Median : Cutout | Tree | DPW 1 | 3x3 | 6011136 | 2090597 | 37.7210091086741 | -122.403557031831 | (37.7210091086741, -122.403557031831) | 10 | 3 | 7 | 309 | 28 | ||||
481 | 119782 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 2 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
485 | 251655 | DPW Maintained 1 | Shrub :: Shrub 66 | 300x Chester Ave | 1 | Sidewalk: Property side : Yard | Tree | DPW 1 | 3x3 | 5991691 | 2087193 | 37.7105572148468 | -122.470524229297 | (37.7105572148468, -122.470524229297) | 9 | 8 | 4 | 64 | 24 | ||||
488 | 20353 | DPW Maintained 1 | Acacia decurrens :: Acacia: Silver Wattle 111 | 262X Sunset Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 60 | |||||||||||||
509 | 19905 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 100 STAIRWAY35 | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 120ST | |||||||||||||
537 | 261951 | DPW Maintained 1 | Cupressus macrocarpa :: Monterey Cypress 41 | 1X Portola Dr To Clipper St Connetion | 5 | Sidewalk: Property side : Yard | Tree | DPW 1 | |||||||||||||||
550 | 19742 | DPW Maintained 1 | Melaleuca spp :: Melaleuca spp 117 | 100 STAIRWAY15 | -9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 1OST | |||||||||||||
561 | 19835 | DPW Maintained 1 | Eriobotrya japonica :: Edible Loquat 119 | 100 STAIRWAY25 | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 60X | |||||||||||||
582 | 20409 | DPW Maintained 1 | Platanus x hispanica :: Sycamore: London Plane 27 | 451X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 10 | |||||||||||||
594 | 20063 | DPW Maintained 1 | Acacia baileyana :: Bailey's Acacia 122 | 100 STAIRWAY54 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 15ST |
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) );