Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 461 | 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 | 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 | 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 | 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 | 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) | |||
| 476 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | |||
| 541 | 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) | ||||
| 552 | 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) | |||
| 558 | 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 | 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 | 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) | |||
| 566 | 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 | 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 | 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) | |||
| 572 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | ||
| 611 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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 | 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) | |
| 694 | 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) | ||
| 717 | 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 | 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 | 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) | ||||
| 769 | 769 | 110848 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2668 Vallejo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | Permit Number 778643 | 6000804.34505 | 2117582.1485 | 37.7945212238167 | -122.441205550194 | (37.7945212238167, -122.441205550194) | ||
| 783 | 783 | 251381 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 731 Huron Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2x5 | 5997668.0 | 2087467.0 | 37.7116533538928 | -122.449886244657 | (37.7116533538928, -122.449886244657) | ||||
| 795 | 795 | 140241 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 160 Ashbury St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998775.6798 | 2110202.3294 | 37.7741424035345 | -122.44769344620701 | (37.7741424035345, -122.447693446207) | |||
| 825 | 825 | 244349 | Undocumented 2 | Shrub :: Shrub 98 | 300 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/2017 02:48:00 PM | 3 | Width 0ft | 6005619.6911 | 2110403.6421 | 37.77508393621179 | -122.424033097665 | (37.7750839362118, -122.424033097665) | ||
| 834 | 834 | 140247 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 100 Ashbury St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5998760.3863 | 2110325.7376 | 37.77448037673879 | -122.447755234881 | (37.7744803767388, -122.447755234881) | |||
| 841 | 841 | 241294 | Undocumented 2 | Prunus serrulata 'Amanagawa' :: Flowering Cherry Tree 'Amanagawa' 117 | 1342 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/19/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 779705 | 6011123.6651099995 | 2102080.8508 | 37.7525406359468 | -122.404407584468 | (37.7525406359468, -122.404407584468) | |
| 851 | 851 | 234149 | Undocumented 2 | Eriobotrya deflexa :: Bronze Loquat 49 | 3652 23rd St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6005288.48907 | 2102558.72214 | 37.753524945734 | -122.42462062893601 | (37.753524945734, -122.424620628936) | |||
| 857 | 857 | 240430 | Undocumented 2 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 2637 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/20/2017 12:00:00 AM | 3 | Width 3ft | 6010665.07202 | 2102243.00786 | 37.752960245237105 | -122.406004908126 | (37.7529602452371, -122.406004908126) | ||
| 858 | 858 | 251395 | Undocumented 2 | Cupaniopsis anacardioides :: Carrotwood 118 | 2101 26th St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012226.0 | 2101445.0 | 37.750856267744496 | -122.400550836744 | (37.7508562677445, -122.400550836744) | |||||
| 860 | 860 | 189218 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 72 Whitney Young Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 4ft | 6016946.50299 | 2094945.8896700002 | 37.7332731602285 | -122.38377428587299 | (37.7332731602285, -122.383774285873) | |||
| 861 | 861 | 109545 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 300x Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6006870.4118800005 | 2111707.44564 | 37.778734401395205 | -122.419799104459 | (37.7787344013952, -122.419799104459) | |||
| 865 | 865 | 142552 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 401 FRANCISCO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6009334.5084 | 2121154.0569 | 37.804811003675105 | -122.411942539139 | (37.8048110036751, -122.411942539139) | |||
| 882 | 882 | 187661 | Undocumented 2 | Tree(s) :: 17 | 1155 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/2017 12:00:00 AM | 3 | 3x3 | Permit Number 779411 | 6015039.0 | 2109715.0 | 37.77372037595529 | -122.391401215397 | (37.7737203759553, -122.391401215397) | |
| 895 | 895 | 209148 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 217 Hugo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5995023.415709999 | 2107016.68952 | 37.7651803042563 | -122.46044222322901 | (37.7651803042563, -122.460442223229) | |||
| 900 | 900 | 140947 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 902 | 902 | 140944 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 904 | 904 | 140946 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 907 | 907 | 140952 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 908 | 908 | 206337 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 240 Noriega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 5ft | 5993194.556580001 | 2103260.73418 | 37.7547620531274 | -122.466494737945 | (37.7547620531274, -122.466494737945) | |||
| 912 | 912 | 137817 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 2001 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6004275.6077 | 2115310.8412 | 37.7884819087987 | -122.429032528237 | (37.7884819087987, -122.429032528237) | |||
| 913 | 913 | 107355 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 2001 Grant Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6010310.1611 | 2121354.7321 | 37.8054166971664 | -122.40858034027201 | (37.8054166971664, -122.408580340272) | |||
| 915 | 915 | 140945 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 918 | 918 | 206336 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 240 Noriega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 5ft | 5993226.58531 | 2103261.3034200002 | 37.7547654642635 | -122.46638401611 | (37.7547654642635, -122.46638401611) | |||
| 919 | 919 | 140949 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 2060 Ofarrell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 920 | 920 | 206335 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 240 Noriega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 5993241.59075 | 2103263.0584299997 | 37.7547711488889 | -122.466332251156 | (37.7547711488889, -122.466332251156) | |||
| 922 | 922 | 140943 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 923 | 923 | 210740 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 146 Ramsell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992981.0390099995 | 2088189.5314 | 37.7133679617255 | -122.46613798048901 | (37.7133679617255, -122.466137980489) | |||
| 924 | 924 | 214223 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 207 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5999983.92895 | 2095213.9818900002 | 37.7330570333525 | -122.44243762501199 | (37.7330570333525, -122.442437625012) | |||
| 925 | 925 | 139814 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1652 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6002517.0 | 2112708.0 | 37.7812354643217 | -122.434930809638 | (37.7812354643217, -122.434930809638) | |||
| 929 | 929 | 140950 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2060 Ofarrell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
| 930 | 930 | 206338 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 240 Noriega St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 5993167.1259699995 | 2103261.31068 | 37.7547620531391 | -122.466589641618 | (37.7547620531391, -122.466589641618) |
JSON shape: default, array, newline-delimited
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");