Street_Tree_List

Data source: data.sfgov.org

863 rows where qSiteInfo = 17

View and edit SQL

Suggested facets: qLegalStatus, SiteOrder, qCaretaker, PlantDate, PlotSize, PermitNotes

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
692 176334 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 287 Hester Ave 7 Side Yard : Yard 17 Tree 1 Private 1     34     6012223.87562 2087782.5469900002 37.713341893097 -122.399599040764 (37.713341893097, -122.399599040764)
701 176335 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 287 Hester Ave 5 Side Yard : Yard 17 Tree 1 Private 1     17     6012233.93602 2087774.2056900002 37.7133195503322 -122.399563683027 (37.7133195503322, -122.399563683027)
1320 251503 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 800X Bosworth St 15 Side Yard : Yard 17 Tree 1 DPW 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1324 251501 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 800X Bosworth St 13 Side Yard : Yard 17 Tree 1 DPW 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1326 251502 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 800X Bosworth St 14 Side Yard : Yard 17 Tree 1 DPW 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1335 251499 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 800X Bosworth St 11 Side Yard : Yard 17 Tree 1 DPW 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1341 251498 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 800X Bosworth St 10 Side Yard : Yard 17 Tree 1 DPW 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1348 251500 DPW Maintained 3 Pinus pinea :: Italian Stone Pine 143 800X Bosworth St 12 Side Yard : Yard 17 Tree 1 DPW 2           6001905.0 2095492.0 37.733929718905394 -122.435815869962 (37.7339297189054, -122.435815869962)
1524 251544 Undocumented 2 Leptospermum scoparium :: New Zealand Tea Tree 27 863X Ocean Ave   Side Yard : Yard 17 Tree 1 Private 1       3x3   5997430.0 2091537.0 37.722815009603295 -122.451002133856 (37.7228150096033, -122.451002133856)
1573 251597 Landmark tree 9 Ficus macrophylla :: Morton Bay Fig 148 1650 Valencia St 1 Side Yard : Yard 17 Tree 1 Private 1           6006336.0 2100501.0 37.747934015176504 -122.42085202386299 (37.7479340151765, -122.420852023863)
1620 251543 Undocumented 2 Pinus radiata :: Monterey Pine 3 0X Bay Shore Blvd Off Ramp   Side Yard : Yard 17 Tree 1 Private 1                    
1817 251719 Significant Tree 6 Sequoia sempervirens :: Coast Redwood 116 1301 Clayton St 1 Side Yard : Yard 17 Tree 1 Private 1           5999055.0 2105304.0 37.7607087868046 -122.446374778866 (37.7607087868046, -122.446374778866)
1875 251783 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 610 Clipper St 5 Side Yard : Yard 17 Tree 1 DPW 2       Width 2ft   6001275.75039 2100902.7174 37.7487505133321 -122.438378885672 (37.7487505133321, -122.438378885672)
1918 251819 DPW Maintained 3 Acer macrophyllum :: Big Leaf Maple 159 298X Corbett Ave 1 Side Yard : Yard 17 Tree 1 DPW 2       3x3 Permit Number 778898 5999572.0 2105342.0 37.7608426398345 -122.444589445505 (37.7608426398345, -122.444589445505)
2610 253145 Significant Tree 6 Pittosporum undulatum :: Victorian Box 26 801X Santiago St 1 Side Yard : Yard 17 Tree 1 Private 1           5990274.0 2099728.0 37.7448931297685 -122.47633667765699 (37.7448931297685, -122.476336677657)
2768 219151 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1500 16th Ave 5 Side Yard : Yard 17 Tree 1 Private 1     15 Width 4ft   5991179.47447 2105124.8493 37.759763935780704 -122.47359934526101 (37.7597639357807, -122.473599345261)
2774 219153 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1500 16th Ave 7 Side Yard : Yard 17 Tree 1 Private 1     8 Width 6ft   5991180.54312 2105148.28148 37.759828336219705 -122.473597358645 (37.7598283362197, -122.473597358645)
2776 219152 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 1500 16th Ave 6 Side Yard : Yard 17 Tree 1 Private 1     15 Width 6ft   5991180.06905 2105137.8500200002 37.759799666743 -122.473598237272 (37.759799666743, -122.473598237272)
3257 253379 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 899 Waller St 1 Side Yard : Yard 17 Tree 1 Private 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3261 253388 Undocumented 2 Cedrus deodara :: Deodar Cedar 129 30 Grand View Ave 1 Side Yard : Yard 17 Tree 1 Private 1       3x3   6000475.0 2103841.0 37.756772747069604 -122.44135867200701 (37.7567727470696, -122.441358672007)
3262 253382 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 899 Waller St 4 Side Yard : Yard 17 Tree 1 Private 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3270 253380 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 899 Waller St 2 Side Yard : Yard 17 Tree 1 Private 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3271 253381 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 899 Waller St 3 Side Yard : Yard 17 Tree 1 Private 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3279 253383 Undocumented 2 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 899 Waller St 5 Side Yard : Yard 17 Tree 1 Private 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3280 253389 Undocumented 2 Sequoia sempervirens :: Coast Redwood 116 30X Grand View Ave 2 Side Yard : Yard 17 Tree 1 Private 1       3x3   6000475.0 2103841.0 37.756772747069604 -122.44135867200701 (37.7567727470696, -122.441358672007)
3399 251598 Undocumented 2 Tree(s) :: 17 900x Moraga St 1 Side Yard : Yard 17 Tree 1 Private 1   09/06/2017 12:00:00 AM 3 3x3 Permit Number 780206 5991390.0 2103897.0 37.7564047756354 -122.47278171886002 (37.7564047756354, -122.47278171886)
3552 253469 Property Tree 7 Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 701 Stanyan St 5 Side Yard : Yard 17 Tree 1 Private 1           5997178.0 2108423.0 37.7691653834469 -122.45309160151399 (37.7691653834469, -122.453091601514)
3586 253468 DPW Maintained 3 Salix lasiolepis :: Arroyo willow 213 801X Alemany Blvd 1 Side Yard : Yard 17 Tree 1 DPW 2                    
3610 115725 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 250X Octavia St 2 Side Yard : Yard 17 Tree 1 Dept of Real Estate 5                    
3743 175363 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 1 Brotherhood Way 8 Side Yard : Yard 17 Tree 1 Private 1     3 Width 5ft   5993226.79298 2087801.79474 37.71231750501779 -122.465260429219 (37.7123175050178, -122.465260429219)
5112 253808 Significant Tree 6 Pinus radiata :: Monterey Pine 3 2 Garfield St 2 Side Yard : Yard 17 Tree 1 Private 1       10x10   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5144 253807 Significant Tree 6 Schinus terebinthifolius :: Brazilian Pepper 25 2 Garfield St 1 Side Yard : Yard 17 Tree 1 Private 1       10x2   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
5161 253809 Significant Tree 6 Pinus radiata :: Monterey Pine 3 2 Garfield St 3 Side Yard : Yard 17 Tree 1 Private 1       10x10   5993976.0 2090624.0 37.7201097842726 -122.462875584037 (37.7201097842726, -122.462875584037)
9694 173632 Undocumented 2 Pinus radiata :: Monterey Pine 3 3300X Market St 1 Side Yard : Yard 17 Tree 1 Private 1                    
9916 173733 DPW Maintained 3 Cupressus macrocarpa :: Monterey Cypress 47 14 Richland Ave 1 Side Yard : Yard 17 Tree 1 DPW 2       3x3   6004601.0 2096122.0 37.7358123337564 -122.426539816145 (37.7358123337564, -122.426539816145)
9987 173779 Significant Tree 6 Ficus macrophylla :: Morton Bay Fig 148 99X Cleveland St 2 Side Yard : Yard 17 Tree 1 Private 1       3x6   6010549.0 2110746.0 37.7763010397716 -122.40700558704799 (37.7763010397716, -122.407005587048)
10000 173780 Significant Tree 6 Ligustrum lucidum :: Glossy Privet 55 99X Cleveland St 3 Side Yard : Yard 17 Tree 1 Private 1       3x6   6010549.0 2110746.0 37.7763010397716 -122.40700558704799 (37.7763010397716, -122.407005587048)
10004 114140 Significant Tree 6 Pinus radiata :: Monterey Pine 3 1200X JUNIPERO SERRA BLVD 5 Side Yard : Yard 17 Tree 1 Private 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
13271 187638 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 875 El Camino Del Mar 2 Side Yard : Yard 17 Tree 1 Private 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
13275 187637 Significant Tree 6 Cupressus macrocarpa :: Monterey Cypress 47 875 El Camino Del Mar 1 Side Yard : Yard 17 Tree 1 Private 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
15743 115724 Undocumented 2 Syzygium paniculatum :: Brush Cherry 198 250x Octavia St 1 Side Yard : Yard 17 Tree 1 Dept of Real Estate 5                    
23489 247849 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 152 Chapman St 1 Side Yard : Yard 17 Tree 1 Private 1     15     6009118.007540001 2098230.0964599997 37.74185503078979 -122.41107154552401 (37.7418550307898, -122.411071545524)
23842 248194 Undocumented 2 Calocedrus decurrens :: Incense Cedar 177 216 Esmeralda Ave 13 Side Yard : Yard 17 Tree 1 Private 1     12     6007325.73728 2098765.61768 37.7432247818956 -122.41730658752199 (37.7432247818956, -122.417306587522)
23934 248050 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 38 Rutledge St 7 Side Yard : Yard 17 Tree 1 Private 1     5     6010496.13368 2099436.61391 37.7452450531093 -122.406391405264 (37.7452450531093, -122.406391405264)
24297 248119 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 108 Brewster St 9 Side Yard : Yard 17 Tree 1 Private 1     18     6010375.35501 2099399.67941 37.7451368817742 -122.40680643699301 (37.7451368817742, -122.406806436993)
24579 247929 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1099 Esmeralda Ave 2 Side Yard : Yard 17 Tree 1 Private 1     37     6010384.7561099995 2098766.60945 37.743399135274295 -122.40672932282301 (37.7433991352743, -122.406729322823)
24649 194268 Undocumented 2 Persea americana :: Avocado 113 900 Quint St 3 Side Yard : Yard 17 Tree 1 Private 1     7 Width 3ft   6014100.1568599995 2097559.70841 37.7402924173605 -122.393797854205 (37.7402924173605, -122.393797854205)
24680 187543 Undocumented 2 Pinus radiata :: Monterey Pine 3 1400 Somerset St 3 Side Yard : Yard 17 Tree 1 Private 1     35     6011384.82868 2088240.1087599997 37.714551459646394 -122.402531250636 (37.7145514596464, -122.402531250636)
24856 248244 Undocumented 2 Pittosporum crassifolium :: Karo Tree 108 296 Esmeralda Ave 4 Side Yard : Yard 17 Tree 1 Private 1     5     6006798.41265 2099004.72131 37.7438516246444 -122.41914689812799 (37.7438516246444, -122.419146898128)
25114 249640 Undocumented 2 Prunus x yedoensis :: Yoshino Cherry 237 2400 Lyon St 6 Side Yard : Yard 17 Tree 1 Private 1     7     5999291.5931400005 2117167.12216 37.79329538582 -122.446409970041 (37.79329538582, -122.446409970041)
25256 238433 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 272 Corbett Ave 8 Side Yard : Yard 17 Tree 1 Private 1     8 Width 3ft   5999629.6727599995 2105348.1757099996 37.7608628875441 -122.444390425487 (37.7608628875441, -122.444390425487)
25273 237871 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 200 Corbin Pl 3 Side Yard : Yard 17 Tree 1 Private 1     4 Width 3ft   6000061.7105 2105723.34521 37.761917651093704 -122.44292314469 (37.7619176510937, -122.44292314469)
25440 237908 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 3911 21st St 4 Side Yard : Yard 17 Tree 1 Private 1     18     6002345.78312 2103531.79558 37.7560301412935 -122.43486671293002 (37.7560301412935, -122.43486671293)
25566 214228 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 714 Detroit St 16 Side Yard : Yard 17 Tree 1 Private 1     5     5999467.5472800005 2095443.9032 37.733658896535 -122.444239403229 (37.733658896535, -122.444239403229)
25663 188593 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 1 20th St 1 Side Yard : Yard 17 Tree 1 Private 1     27     6010961.38996 2104652.9831 37.759594070921004 -122.40514986509899 (37.759594070921, -122.405149865099)
25720 196053 Undocumented 2 Populus trichocarpa :: Black Cottonwood Poplar 258 2399 Lane St 8 Side Yard : Yard 17 Tree 1 Private 1     22     6013983.40604 2092884.07422 37.727447595718395 -122.393874328035 (37.7274475957184, -122.393874328035)
25721 190755 Undocumented 2 Juglans regia :: Walnut: English 348 1999 Revere Ave 1 Side Yard : Yard 17 Tree 1 Private 1     21     6012974.9721800005 2095942.04055 37.7357880468688 -122.397574892566 (37.7357880468688, -122.397574892566)
25897 134510 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 9 Side Yard : Yard 17 Tree 1 Private 1     18 Width 4ft   6008017.687530001 2112101.62184 37.7798812789472 -122.415858138542 (37.7798812789472, -122.415858138542)
25968 249846 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 289 Greenwich St 3 Side Yard : Yard 17 Tree 1 Private 1     14 Width 0ft   6011427.16735 2120382.55668 37.8028098362532 -122.40464628970601 (37.8028098362532, -122.404646289706)
25982 247919 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1098 Esmeralda Ave 4 Side Yard : Yard 17 Tree 1 Private 1     22     6010242.48982 2098715.3752200003 37.743250496220895 -122.40721763491001 (37.7432504962209, -122.40721763491)
26079 134508 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 100 Fulton St 7 Side Yard : Yard 17 Tree 1 Private 1     17 Width 4ft   6008055.00417 2112104.50717 37.7798912991906 -122.41572924771499 (37.7798912991906, -122.415729247715)
26278 249950 Undocumented 2 Afrocarpus gracilior :: Fern Pine 70 303 Filbert St 5 Side Yard : Yard 17 Tree 1 Private 1     9 Width 0ft   6011359.33086 2120056.95578 37.801912024192795 -122.404858102512 (37.8019120241928, -122.404858102512)
26288 247985 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 495 Peralta Ave 1 Side Yard : Yard 17 Tree 1 Private 1     7     6009773.5395 2099699.6998799997 37.7459269802441 -122.40890858338001 (37.7459269802441, -122.40890858338)
26362 196123 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 2300 20th St 1 Side Yard : Yard 17 Tree 1 Private 1     6 Width 4ft   6011242.42693 2104654.95461 37.7596151915071 -122.404178032517 (37.7596151915071, -122.404178032517)
26378 118551 Undocumented 2 Myoporum laetum :: Myoporum 1 8140 Geary Blvd 5 Side Yard : Yard 17 Tree 1 Private 1     18     5981667.59483 2112398.2493 37.7791791285325 -122.50703522193999 (37.7791791285325, -122.50703522194)
26546 191706 Undocumented 2 Eriobotrya japonica :: Edible Loquat 190 1499 Rankin St 7 Side Yard : Yard 17 Tree 1 Private 1     1 Width 3ft   6012685.03055 2096691.5436200001 37.7378298766422 -122.39862992054701 (37.7378298766422, -122.398629920547)
27269 250005 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 232 Filbert St 3 Side Yard : Yard 17 Tree 1 Private 1     8 Width 0ft   6011493.8796 2120090.77159 37.802012393927 -122.404394879735 (37.802012393927, -122.404394879735)
27802 206466 Undocumented 2 Cotoneaster SPP :: Cotoneaster 234 747 Detroit St 1 Side Yard : Yard 17 Tree 1 Private 1     7     5999436.63595 2095454.0058900001 37.733684872551606 -122.444346998137 (37.7336848725516, -122.444346998137)
27912 191009 Undocumented 2 Cupressus sempervirens :: Italian Cypress 136 1350 Rankin St 4 Side Yard : Yard 17 Tree 1 Private 1     5 Width 2ft   6012766.95212 2096886.7999200001 37.7383705733355 -122.398360372158 (37.7383705733355, -122.398360372158)
27927 247528 Undocumented 2 Quercus agrifolia :: Coast Live Oak 180 1101 Waller St 9 Side Yard : Yard 17 Tree 1 Private 1     2     6000060.08033 2108486.82414 37.7695053822964 -122.443127261125 (37.7695053822964, -122.443127261125)
28120 178856 Undocumented 2 Prunus domestica 'Mariposa' :: Mariposa Plum 72 121 Delta St 1 Side Yard : Yard 17 Tree 1 Private 1     18     6009824.00265 2088991.8165400003 37.71652823335621 -122.407979098955 (37.7165282333562, -122.407979098955)
28127 191847 Undocumented 2 Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 2101 Newcomb Ave 1 Side Yard : Yard 17 Tree 1 Private 1     23 Width 10ft   6012411.60288 2097770.43241 37.7407770404189 -122.39965102878901 (37.7407770404189, -122.399651028789)
28161 249840 Undocumented 2 Magnolia x soulangiana :: Saucer Magnolia 92 305 Greenwich St 3 Side Yard : Yard 17 Tree 1 Private 1     5 Width 0ft   6011283.33525 2120383.34662 37.8028039654926 -122.405144080631 (37.8028039654926, -122.405144080631)
28786 214229 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 714 Detroit St 17 Side Yard : Yard 17 Tree 1 Private 1     9     5999467.99685 2095449.76583 37.7336750195872 -122.444238270085 (37.7336750195872, -122.444238270085)
28898 250221 Undocumented 2 Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 312 Filbert St 2 Side Yard : Yard 17 Tree 1 Private 1     8 Width 0ft   6011282.00764 2120080.85256 37.8019733165766 -122.405127362244 (37.8019733165766, -122.405127362244)
28950 132461 Undocumented 2 Pittosporum tobira :: Japanese Mockorange 243 1109 Chestnut St 3 Side Yard : Yard 17 Tree 1 Private 1     12     6006461.025 2120401.5247299997 37.8025831108771 -122.42183305885901 (37.8025831108771, -122.421833058859)
29143 248220 Undocumented 2 Myoporum laetum :: Myoporum 1 70 Fair Ave 1 Side Yard : Yard 17 Tree 1 Private 1     18     6007112.652530001 2099342.90806 37.7447979012027 -122.41808429785499 (37.7447979012027, -122.418084297855)
29144 205629 Undocumented 2 Betula pendula :: European White Birch 146 714 Detroit St 18 Side Yard : Yard 17 Tree 1 Private 1     5     5999458.60233 2095454.85434 37.7336884554611 -122.444271115125 (37.7336884554611, -122.444271115125)
29239 211277 Undocumented 2 Pinus radiata :: Monterey Pine 3 232 Edna St 4 Side Yard : Yard 17 Tree 1 Private 1     43     5998792.56249 2095483.7387400002 37.7337297433315 -122.44657587878599 (37.7337297433315, -122.446575878786)
29301 250202 Undocumented 2 Pinus radiata :: Monterey Pine 3 203 Union St 3 Side Yard : Yard 17 Tree 1 Private 1     12 Width 0ft   6011755.5651 2119757.15751 37.8011109908426 -122.403465834184 (37.8011109908426, -122.403465834184)
29447 206472 Undocumented 2 Cotoneaster SPP :: Cotoneaster 234 714 Detroit St 11 Side Yard : Yard 17 Tree 1 Private 1     7     5999457.34155 2095426.0503099998 37.733609294436796 -122.444273404802 (37.7336092944368, -122.444273404802)
29484 190646 Undocumented 2 Heteromeles arbutifolia :: Toyon 322 230 Middle Point Rd 4 Side Yard : Yard 17 Tree 1 Private 1     8 Width 8ft   6018218.4425 2096359.44868 37.7372247426365 -122.379474956329 (37.7372247426365, -122.379474956329)
29637 247866 Undocumented 2 Cordyline australis :: Dracena Palm 141 398 Mayflower St 1 Side Yard : Yard 17 Tree 1 Private 1     24     6009543.35492 2098406.93767 37.7423644418716 -122.40961330563101 (37.7423644418716, -122.409613305631)
29648 196372 Undocumented 2 Prunus spp :: Cherry 84 1700 Armstrong Ave 7 Side Yard : Yard 17 Tree 1 Private 1     1     6013890.9677099995 2092887.97335 37.7274531643304 -122.394194162931 (37.7274531643304, -122.394194162931)
29739 187574 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 72 Bishop St 1 Side Yard : Yard 17 Tree 1 Private 1     10     6010842.8913900005 2089488.5588 37.71794917929 -122.404492242147 (37.71794917929, -122.404492242147)
29793 247852 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 80 Bradford St 1 Side Yard : Yard 17 Tree 1 Private 1     27     6009577.25002 2098193.0016099997 37.741778919360705 -122.409481010838 (37.7417789193607, -122.409481010838)
29820 187571 Undocumented 2 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 73 Bishop St 2 Side Yard : Yard 17 Tree 1 Private 1     7     6010860.52073 2089475.11103 37.7179132396708 -122.40443035886899 (37.7179132396708, -122.404430358869)
30032 247924 Undocumented 2 Eucalyptus globulus :: Blue Gum 103 1098 Esmeralda Ave 9 Side Yard : Yard 17 Tree 1 Private 1     23     6010297.695230001 2098727.78354 37.7432876562154 -122.40702762254499 (37.7432876562154, -122.407027622545)
30048 132396 Undocumented 2 Pittosporum eugenioides :: Tarata 110 2836 Larkin St 2 Side Yard : Yard 17 Tree 1 Private 1     40     6006504.32212 2120945.10898 37.804078096188704 -122.421721861273 (37.8040780961887, -122.421721861273)
30197 196336 Undocumented 2 Prunus ilicifoia :: Holly-leaved Cherry 353 1750 22nd St 6 Side Yard : Yard 17 Tree 1 Private 1     9     6012821.16046 2103795.98592 37.757344738798 -122.398657667323 (37.757344738798, -122.398657667323)
30408 248049 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 38 Rutledge St 6 Side Yard : Yard 17 Tree 1 Private 1     8     6010499.7614 2099438.0486 37.7452491953942 -122.40637896223 (37.7452491953942, -122.40637896223)
30472 247853 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 80 Bradford St 2 Side Yard : Yard 17 Tree 1 Private 1     25     6009574.28658 2098178.5899099996 37.7417391819242 -122.40949024059401 (37.7417391819242, -122.409490240594)
30481 247913 Undocumented 2 Myoporum laetum :: Myoporum 1 399 Franconia St 4 Side Yard : Yard 17 Tree 1 Private 1     4     6009968.0552900005 2098803.93583 37.743478301698296 -122.40817280665001 (37.7434783016983, -122.40817280665)
30657 220393 Undocumented 2 Acer palmatum :: Japanese Maple 175 20 Deming St 1 Side Yard : Yard 17 Tree 1 Private 1     5 Width 3ft   5999466.4358 2105239.81948 37.7605560532329 -122.44494719845801 (37.7605560532329, -122.444947198458)
30719 249951 Undocumented 2 Brugmansia spp :: Angel trumpet 137 303 Filbert St 4 Side Yard : Yard 17 Tree 1 Private 1     15 Width 0ft   6011370.2265099995 2120056.34585 37.8019109584873 -122.40482035527799 (37.8019109584873, -122.404820355278)
30768 223720 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 10 Crescent Ave 3 Side Yard : Yard 17 Tree 1 Private 1     15 Width 3ft   6005295.72226 2095902.89747 37.7352499770995 -122.424122309196 (37.7352499770995, -122.424122309196)
30996 247856 Undocumented 2 Cordyline australis :: Dracena Palm 141 80 Bradford St 5 Side Yard : Yard 17 Tree 1 Private 1     32     6009566.847130001 2098148.32022 37.7416556510973 -122.409513828008 (37.7416556510973, -122.409513828008)
31185 247857 Undocumented 2 Cordyline australis :: Dracena Palm 141 80 Bradford St 6 Side Yard : Yard 17 Tree 1 Private 1     8     6009575.64001 2098128.64759 37.7416021270253 -122.409482036966 (37.7416021270253, -122.409482036966)
31230 187779 Undocumented 2 Acacia melanoxylon :: Blackwood Acacia 5 230 Middle Point Rd 2 Side Yard : Yard 17 Tree 1 Private 1     5 Width 6ft   6018271.33931 2096490.0449 37.737586251210104 -122.379301134458 (37.7375862512101, -122.379301134458)
31259 201730 Undocumented 2 Pinus radiata :: Monterey Pine 3 1411 Phelps St 5 Side Yard : Yard 17 Tree 1 Private 1     20     6013762.45417 2095926.0507 37.7357879596321 -122.39485111951001 (37.7357879596321, -122.39485111951)

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" TEXT,
  "DBH" INTEGER,
  "PlotSize" TEXT,
  "PermitNotes" TEXT,
  "XCoord" REAL,
  "YCoord" REAL,
  "Latitude" REAL,
  "Longitude" REAL,
  "Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
    FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
    FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
    FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
    FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
    FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");
Powered by Datasette · Query took 479.776ms · Data source: data.sfgov.org