Street_Tree_List

Data source: data.sfgov.org

99,669 rows where qLegalStatus = 2

View and edit SQL

Link rowid ▼ TreeID qLegalStatus qSpecies qAddress SiteOrder qSiteInfo PlantType qCaretaker qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location
364 182551 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 2565 Judah St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 0ft   5986541.5452 2105693.4321 37.7610554202125 -122.489681251316 (37.7610554202125, -122.489681251316)
379 122497 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 31X 08th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6008445.21835 2111601.2724900004 37.7785314648928 -122.414343702699 (37.7785314648928, -122.414343702699)
383 181340 Undocumented 2 Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 1360 24th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 0ft   5988678.0351 2106085.8063 37.7622572799997 -122.48232089502501 (37.7622572799997, -122.482320895025)
411 154366 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 411 Valencia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 3ft   6006164.37856 2107202.76015 37.7663258166161 -122.42192147568899 (37.7663258166161, -122.421921475689)
423 109554 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 300x Van Ness Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     4 3x3   6006839.87541 2111919.81075 37.7793157843461 -122.41991981597201 (37.7793157843461, -122.419919815972)
427 251307 Undocumented 2 Tree(s) :: 17 200 Cashmere St 1 Back Yard : Yard 13 Tree 1 Private 1       3x3   6016315.0 2096328.0 37.7370332293639 -122.38605389871 (37.7370332293639, -122.38605389871)
429 142788 Undocumented 2 Pyrus kawakamii :: Evergreen Pear 82 733 POLK ST 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     7 Width 0ft Polk St Scape will replant 6007029.0497 2113497.6534 37.7836588132661 -122.419377346786 (37.7836588132661, -122.419377346786)
433 251301 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 100 Whitney Young Cir 2 Back Yard : Yard 13 Tree 1 Mayor Office of Housing 7       3x3   6016360.0 2096059.0 37.736297099957106 -122.385879567348 (37.7362970999571, -122.385879567348)
434 136390 Undocumented 2 Tree(s) :: 17 3395 Sacramento St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/06/2017 12:00:00 AM 3 Width 5ft Permit Number 779746 5998765.27001 2115243.09553 37.787982442971604 -122.448092477507 (37.7879824429716, -122.448092477507)
439 136984 Undocumented 2 Tree(s) :: 17 454 Walnut St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/06/2017 12:00:00 AM 3 Width 4ft Permit Number 779785 5998641.89853 2115102.68231 37.7875898520492 -122.448509202661 (37.7875898520492, -122.448509202661)
443 251293 Undocumented 2 :: 54 3789 Market St 1 Sidewalk: Property side : Cutout 5 Landscaping 2 Private 1       3x3   6000208.0 2102740.0 37.753734455764 -122.44220302061701 (37.753734455764, -122.442203020617)
448 224849 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 4 Rotteck St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     18 3x3 Permit Number 779889 6003244.1353400005 2095137.54828 37.733032453088704 -122.431160782146 (37.7330324530887, -122.431160782146)
450 142159 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 490X Baker St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     2 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
452 221749 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 275 Grattan St 3 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1     24 Width 4ft   5997432.91763 2106413.5715 37.763662611962 -122.452064861225 (37.763662611962, -122.452064861225)
454 251309 Undocumented 2 Ginkgo biloba :: Maidenhair Tree 44 2111 15th Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5991606.081259999 2101026.68041 37.7485361329461 -122.471825260742 (37.7485361329461, -122.471825260742)
457 142162 Undocumented 2 Prunus spp :: Cherry 84 490X Baker St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
458 221750 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 275 Grattan St 2 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1     11 Width 4ft   5997409.41415 2106414.31665 37.7636633116224 -122.45214620578699 (37.7636633116224, -122.452146205787)
460 142327 Undocumented 2 Liriodendron tulipifera :: Tulip Tree 85 1652 Hayes St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 Width 0ft   5999940.0 2110256.0 37.774356244626205 -122.44366972691601 (37.7743562446262, -122.443669726916)
461 98533 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1805X Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 6x6 Permit Number 779899 5999986.39066 2115181.83206 37.787883958235504 -122.44386322941901 (37.7878839582355, -122.443863229419)
462 187628 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2 Rotteck St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 779889 6003236.0 2095183.0 37.7331567921798 -122.431192151262 (37.7331567921798, -122.431192151262)
470 98535 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1805X Baker St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     12 6x6 Permit Number 779899 5999990.232999999 2115142.7171 37.7877767779168 -122.44384712433799 (37.7877767779168, -122.443847124338)
472 236059 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 601X 14th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     16 Width 3ft   6004719.95486 2107769.51353 37.7678004187701 -122.42695783742799 (37.7678004187701, -122.426957837428)
473 142160 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 490X Baker St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
474 251300 Undocumented 2 Eucalyptus sideroxylon :: Red Ironbark 36 100 Whitney Young Cir 1 Back Yard : Yard 13 Tree 1 Health Dept 8       3x3   6016360.0 2096059.0 37.736297099957106 -122.385879567348 (37.7362970999571, -122.385879567348)
476 174954 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1400x Market St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       4xt Permit Number 779898 6007316.0 2110809.0 37.776292577113104 -122.418193923043 (37.7762925771131, -122.418193923043)
478 142161 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 490X Baker St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
482 142326 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1652 Hayes St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 0ft   5999940.0 2110256.0 37.774356244626205 -122.44366972691601 (37.7743562446262, -122.443669726916)
483 236058 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 601X 14th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     13 Width 3ft   6004683.7857099995 2107762.8709299997 37.767780134560205 -122.427082469082 (37.7677801345602, -122.427082469082)
485 142163 Undocumented 2 Tristaniopsis laurina :: Swamp Myrtle 37 490X Baker St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 0ft   6000657.0 2110488.0 37.7750341257837 -122.44120614609 (37.7750341257837, -122.44120614609)
486 98534 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 1805X Baker St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 3x3 Permit Number 779899 5999986.755609999 2115164.0145 37.787835056676705 -122.443860686142 (37.7878350566767, -122.443860686142)
491 236057 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 601X 14th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   6004642.9908 2107763.18347 37.767778685763 -122.427223596101 (37.767778685763, -122.427223596101)
492 173939 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 570 Pennsylvania Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   02/15/2017 12:00:00 AM 3 5xt Permit Number 779890 6014341.0 2104455.0 37.7592388085315 -122.39344754111201 (37.7592388085315, -122.393447541112)
495 248613 Undocumented 2 Populus nigra 'Italica' :: Lombardy Poplar 86 845 Shrader St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     28 Width 0ft   5997648.1233 2107524.615 37.766725579885 -122.451400674442 (37.766725579885, -122.451400674442)
496 245474 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 275 Grattan St 1 Sidewalk: Curb side : Cutout 1 Landscaping 2 Private 1     19 Width 4ft   5997377.53226 2106405.56262 37.7636374489232 -122.452255843041 (37.7636374489232, -122.452255843041)
511 251164 Undocumented 2 Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 1215 Fairfax Ave 10 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/10/2017 01:46:00 PM 3 3x3   6017471.0 2096747.0 37.738247630240295 -122.382086185189 (37.7382476302403, -122.382086185189)
514 251312 Undocumented 2 :: 54 1499 Noe St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003369.0 2099547.0 37.7451468706327 -122.431043696183 (37.7451468706327, -122.431043696183)
523 247328 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 696X Oak St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     20 Width 0ft   6003691.2873 2110070.3794 37.774059815342795 -122.430680081912 (37.7740598153428, -122.430680081912)
537 195070 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1532 Harrison St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
539 206615 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 198 Vasquez Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     6 Width 3ft Permit Number 779324 5994758.52704 2099346.29484 37.7441041156281 -122.460802465585 (37.7441041156281, -122.460802465585)
541 251317 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 399X 12th St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
545 251322 Undocumented 2 Betula spp :: Birch 95 828 Foerster St 6 Sidewalk: Property side : Yard 9 Tree 1 Private 1       Width 3ft   5998302.82159 2096489.58159 37.7364635618398 -122.448341458403 (37.7364635618398, -122.448341458403)
549 251321 Undocumented 2 Cupressus macrocarpa :: Monterey Cypress 47 100X Monument Way 1 Unaccepted Street : Yard 14 Tree 1 Private 1                    
552 194122 Undocumented 2 Olea europaea :: Olive Tree 41 963 Minna St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
553 206616 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 198 Vasquez Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     5 Width 3ft Permit Number 779324 5994742.56026 2099334.6803900003 37.7440713065495 -122.460856833195 (37.7440713065495, -122.460856833195)
557 194124 Undocumented 2 Olea europaea :: Olive Tree 41 963 Minna St 3 Sidewalk: Curb side : Hanging Pot 15 Tree 1 Private 1     9 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
558 251320 Undocumented 2 Schinus terebinthifolius :: Brazilian Pepper 25 35 Park St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 3ft   6004965.06472 2096463.48809 37.7367705580153 -122.425305393447 (37.7367705580153, -122.425305393447)
560 131782 Undocumented 2 Olea europaea 'Fruitless' :: Fruitless Olive 80 2646 Union St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     11 Width 3ft Permit Number 779549 6000337.27442 2118211.39807 37.7962223607332 -122.442866875924 (37.7962223607332, -122.442866875924)
561 204410 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 450x Lawton St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 3ft   5992920.0 2104601.0 37.7584262276473 -122.46754168203998 (37.7584262276473, -122.46754168204)
565 206617 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 198 Garcia Ave 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft   5994686.63181 2099351.09779 37.7441131663853 -122.461051409618 (37.7441131663853, -122.461051409618)
566 243384 Undocumented 2 Magnolia grandiflora :: Southern Magnolia 21 88 Montcalm St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/11/2017 12:00:00 AM 3 3x3   6010512.94245 2100000.19671 37.746793468955204 -122.406372986245 (37.7467934689552, -122.406372986245)
567 195068 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 1532 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
569 194126 Undocumented 2 Olea europaea :: Olive Tree 41 963 Minna St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
571 206618 Undocumented 2 Crataegus laevigata :: English Hawthorn 66 198 Garcia Ave 2 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     8 Width 3ft Permit Number 779324 5994673.79551 2099409.87557 37.7442738167873 -122.461100053935 (37.7442738167873, -122.461100053935)
572 194125 Undocumented 2 Olea europaea :: Olive Tree 41 963 Minna St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     9 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
573 194127 Undocumented 2 Olea europaea :: Olive Tree 41 963 Minna St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
574 194128 Undocumented 2 Olea europaea :: Olive Tree 41 963 Minna St 7 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     10 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
575 194123 Undocumented 2 Olea europaea :: Olive Tree 41 963 Minna St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     8 Width 3ft   6007973.0 2110046.0 37.77423451911571 -122.41586713001399 (37.7742345191157, -122.415867130014)
587 233050 Undocumented 2 Olea europaea :: Olive Tree 41 3181 23rd St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/12/2011 12:00:00 AM 3 Width 3ft   6007759.16475 2102654.84325 37.7539280965303 -122.416083280221 (37.7539280965303, -122.416083280221)
588 251328 Undocumented 2 Tree(s) :: 17 95x Tompkins Ave 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3 Permit Number 779511 6007651.0 2096616.0 37.7373407014575 -122.416029712695 (37.7373407014575, -122.416029712695)
592 251331 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2232 Webster St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003295.0 2116396.0 37.791405922266996 -122.43250281523301 (37.791405922267, -122.432502815233)
593 140072 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 601X Octavia St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6005402.0 2111410.0 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543)
594 140071 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 601X Octavia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6005402.0 2111410.0 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543)
599 251330 Undocumented 2 Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 2232 Webster St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6003295.0 2116396.0 37.791405922266996 -122.43250281523301 (37.791405922267, -122.432502815233)
606 233049 Undocumented 2 Olea europaea :: Olive Tree 41 3181 23rd St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/12/2011 12:00:00 AM 3 Width 3ft   6007718.49924 2102654.70617 37.753925433618704 -122.416223901805 (37.7539254336187, -122.416223901805)
608 233928 Undocumented 2 Phoenix canariensis :: Canary Island Date Palm 100 8 Octavia St Frontage East 1 Sidewalk: Curb side : Yard 2 Tree 1 Private 1     29 Width 8ft   6005775.18179 2109348.30824 37.77219502161479 -122.423420179704 (37.7721950216148, -122.423420179704)
611 140070 Undocumented 2 Ficus retusa nitida :: Banyan Fig 59 601X Octavia St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     15 Width 0ft   6005402.0 2111410.0 37.7778348570605 -122.424857751543 (37.7778348570605, -122.424857751543)
619 244248 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 200 Octavia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/13/2017 02:55:00 PM 3 Width 0ft   6005671.5367 2110041.0199 37.7740911903854 -122.42382796196699 (37.7740911903854, -122.423827961967)
620 244252 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 200 Octavia St 6 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/13/2017 03:09:00 PM 3 Width 0ft   6005662.3712 2110108.233 37.7742752238868 -122.423864447369 (37.7742752238868, -122.423864447369)
623 192249 Undocumented 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 450 11th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     3 Width 3ft Permit Number 779594 6009343.40252 2108323.7349799997 37.7695825279367 -122.411004969605 (37.7695825279367, -122.411004969605)
624 70356 Undocumented 2 Pyrus calleryana :: Ornamental Pear 9 1912 Polk St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1 FUF 1 05/07/1994 12:00:00 AM 5     6006535.5562 2117410.9094 37.7943758388735 -122.42136264060801 (37.7943758388735, -122.421362640608)
627 192272 Undocumented 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 1490 Harrison St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/13/2017 12:00:00 AM 3 Width 3ft Permit Number 779594 6008997.70519 2108735.1603599996 37.77069281474439 -122.41222981116002 (37.7706928147444, -122.41222981116)
635 251315 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 399X 12th St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
636 244251 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 200 Octavia St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/13/2017 03:04:00 PM 3 Width 0ft   6005664.6626 2110090.6659 37.7742271182357 -122.423855271591 (37.7742271182357, -122.423855271591)
637 192270 Undocumented 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 450 11th St 13 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     6 Width 3ft Permit Number 779594 6009046.84186 2108631.36839 37.770410583217505 -122.41205250981199 (37.7704105832175, -122.412052509812)
640 251141 Undocumented 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 450 10th St 11 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/13/2017 12:00:00 AM 3 3x3 Permit Number 779594 6009467.0 2108781.0 37.7708450017609 -122.410609744119 (37.7708450017609, -122.410609744119)
642 192273 Undocumented 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 1490 Harrison St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/13/2017 12:00:00 AM 3 Width 3ft Permit Number 779594 6009013.0387699995 2108749.12963 37.7707320314935 -122.41217775931001 (37.7707320314935, -122.41217775931)
644 251319 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 399X 12th St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
645 251316 Undocumented 2 Eriobotrya deflexa :: Bronze Loquat 49 399X 12th St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   6008830.0 2108632.0 37.7704001487298 -122.41280261366998 (37.7704001487298, -122.41280261367)
646 192250 Undocumented 2 Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 450 11th St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/13/2017 12:00:00 AM 3 Width 3ft Permit Number 779594 6009332.59975 2108335.89703 37.7696153163206 -122.411043195313 (37.7696153163206, -122.411043195313)
648 244249 Undocumented 2 Lophostemon confertus :: Brisbane Box 11 200 Octavia St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/13/2017 03:00:00 PM 3 Width 0ft   6005669.2453 2110057.8231 37.774137198555 -122.423837083382 (37.774137198555, -122.423837083382)
651 251359 Undocumented 2 Metrosideros excelsa :: New Zealand Xmas Tree 2 4050 Geary Blvd 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5994421.0 2112898.0 37.7812941506761 -122.462952553035 (37.7812941506761, -122.462952553035)
653 144739 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 510 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 Width 3ft   5989096.969740001 2111833.32857 37.7780627562405 -122.481292881664 (37.7780627562405, -122.481292881664)
654 122328 Undocumented 2 Myoporum laetum :: Myoporum 1 3015 Turk Blvd 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/14/2017 12:00:00 AM 3 3x3 Permit Number 779630 5996535.0 2111432.0 37.7773904414434 -122.455533202662 (37.7773904414434, -122.455533202662)
655 251353 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 510 22nd Ave 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       Width 3ft   5989096.969740001 2111833.32857 37.7780627562405 -122.481292881664 (37.7780627562405, -122.481292881664)
658 147406 Undocumented 2 Pittosporum undulatum :: Victorian Box 26 515 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     0 6x10   5989054.53583 2111789.60329 37.7779402316839 -122.48143647103201 (37.7779402316839, -122.481436471032)
659 244390 Undocumented 2 Shrub :: Shrub 98 250 Octavia St 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/15/2017 01:00:00 PM 3 Width 0ft   6005651.6782 2110185.3753 37.774486434317105 -122.423906923072 (37.7744864343171, -122.423906923072)
660 244391 Undocumented 2 Shrub :: Shrub 98 250 Octavia St 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/15/2017 01:16:00 PM 3 Width 0ft   6005650.1507 2110201.4148 37.774530388668 -122.42391334778499 (37.774530388668, -122.423913347785)
662 206411 Undocumented 2 Corymbia ficifolia :: Red Flowering Gum 60 241 Ortega St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1     14 Width 3ft Permit Number 779935 5993240.35303 2102520.36003 37.752731819221 -122.466282559112 (37.752731819221, -122.466282559112)
664 244393 Undocumented 2 Shrub :: Shrub 98 250 Octavia St 5 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/15/2017 01:35:00 PM 3 Width 0ft   6005645.568 2110235.0213 37.774622405266 -122.423931590501 (37.774622405266, -122.423931590501)
667 251356 Undocumented 2 :: 54 519 22nd Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       3x3   5989039.0 2111772.0 37.777890994652296 -122.481488924787 (37.7778909946523, -122.481488924787)
668 244392 Undocumented 2 Shrub :: Shrub 98 250 Octavia St 4 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/15/2017 01:27:00 PM 3 Width 0ft   6005647.8593 2110218.2181 37.774576397101995 -122.42392246931401 (37.774576397102, -122.423922469314)
678 237516 Undocumented 2 Prunus cerasifera :: Cherry Plum 16 1004 Sanchez St 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/17/2017 12:00:00 AM 3 Width 3ft Permit Number 779660 6003758.05774 2102389.1689299997 37.752972841143 -122.429901097271 (37.752972841143, -122.429901097271)
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)
694 120738 Undocumented 2 Myoporum laetum :: Myoporum 1 700x 20th Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/17/2017 12:00:00 AM 3 Width 4ft   5989768.19982 2110516.41697 37.7744858825371 -122.478874537994 (37.7744858825371, -122.478874537994)
697 251362 Undocumented 2 Pinus Spp :: Pine Spp 105 1300X Stanyan St 1 Unaccepted Street : Yard 14 Tree 1 Private 1       3x3   5997565.0 2104877.0 37.7594511396077 -122.451497194349 (37.7594511396077, -122.451497194349)
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)
717 106656 Undocumented 2 Myoporum laetum :: Myoporum 1 700X 20TH AVE 2 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/17/2017 12:00:00 AM 3 3x3 Permit Number 779658 5989753.9107099995 2110247.9151 37.773747820615704 -122.47890432357 (37.7737478206157, -122.47890432357)
720 104746 Undocumented 2 Myoporum laetum :: Myoporum 1 700X 20th Ave 3 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1   04/17/2017 12:00:00 AM 3 3x3 Permit Number 779658 5989767.16587 2110527.4876599996 37.774516219561704 -122.478878924469 (37.7745162195617, -122.478878924469)
752 251380 Undocumented 2 Arbutus 'Marina' :: Hybrid Strawberry Tree 12 731 Huron Ave 1 Sidewalk: Curb side : Cutout 1 Tree 1 Private 1       2x5   5997668.0 2087467.0 37.7116533538928 -122.449886244657 (37.7116533538928, -122.449886244657)
761 195041 Undocumented 2 Platanus x hispanica :: Sycamore: London Plane 15 402 06th St 1 : 4 Tree 1 DPW 2     28 Width 3ft   6011480.36813 2111044.01847 37.777171403968296 -122.40380468436199 (37.7771714039683, -122.403804684362)

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 34.394ms · Data source: data.sfgov.org