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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 96462 | 96462 | 26447 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1899X Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6001375.512630001 | 2112473.63814 | 37.780527088517296 | -122.438862984365 | (37.7805270885173, -122.438862984365) | |||
| 96466 | 96466 | 877 | DPW Maintained 3 | Tree(s) :: 17 | 600X Alemany Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6006086.2852895 | 2094767.6237118 | 37.7321773712618 | -122.421308445577 | (37.7321773712618, -122.421308445577) | |||
| 96468 | 96468 | 87593 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 80X Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/22/2008 12:00:00 AM | 3 | 3x3 | 5991401.185357 | 2095410.335482 | 37.7331032279342 | -122.472124459161 | (37.7331032279342, -122.472124459161) | ||
| 96469 | 96469 | 16330 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 798 Monterey Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2015 12:00:00 AM | 3 | 3X3 | 5996807.5825755 | 2094755.2467478001 | 37.731615896855104 | -122.45338592568199 | (37.7316158968551, -122.453385925682) | ||
| 96472 | 96472 | 89558 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5239 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/27/2008 12:00:00 AM | 3 | 3x3 | 5982363.16543 | 2111656.98924 | 37.77718478612329 | -122.504574063555 | (37.7771847861233, -122.504574063555) | ||
| 96474 | 96474 | 26584 | DPW Maintained 3 | Ulmus 'Prospector' :: Prospector Elm 255 | 1799X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/08/1998 12:00:00 AM | 6 | 3x3 | 6012271.0640199995 | 2090627.3118900002 | 37.721155676338896 | -122.399635553716 | (37.7211556763389, -122.399635553716) | ||
| 96481 | 96481 | 9034 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 5410 Geary Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 5990186.236190001 | 2112722.6445299997 | 37.7805678394327 | -122.477589778145 | (37.7805678394327, -122.477589778145) | |||
| 96482 | 96482 | 8109 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 790X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 4X4 | 6004003.8918437995 | 2111454.7703146 | 37.7778787172016 | -122.429697487702 | (37.7778787172016, -122.429697487702) | |||
| 96484 | 96484 | 6324 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1895X Ellis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6001829.84497 | 2112881.90897 | 37.7816739348974 | -122.437320479018 | (37.7816739348974, -122.437320479018) | |||
| 96493 | 96493 | 25349 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 40X Geneva Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/18/2003 12:00:00 AM | 3 | 3X3 | 5997270.77757 | 2091437.16647 | 37.722531773344706 | -122.45154533174801 | (37.7225317733447, -122.451545331748) | ||
| 96497 | 96497 | 9942 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 601X Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 6x5 | 6010129.67767 | 2119173.05666 | 37.7994162456962 | -122.409050895178 | (37.7994162456962, -122.409050895178) | |||
| 96498 | 96498 | 5928 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1335 Eddy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004029.334559999 | 2112693.29822 | 37.781280848415 | -122.42969783017901 | (37.781280848415, -122.429697830179) | |||
| 96504 | 96504 | 90648 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 3326 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5985315.670548 | 2110447.4548029997 | 37.774036978686105 | -122.494271383414 | (37.7740369786861, -122.494271383414) | |
| 96509 | 96509 | 23192 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 500 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6006809.13674 | 2112310.98108 | 37.7803881115112 | -122.420053921609 | (37.7803881115112, -122.420053921609) | |||
| 96513 | 96513 | 85612 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1160 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6017578.234449 | 2092916.188247 | 37.7277348985577 | -122.381449098373 | (37.7277348985577, -122.381449098373) | ||
| 96515 | 96515 | 12076 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1241X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017245.0743814 | 2094442.9323578998 | 37.7319086387255 | -122.382707045529 | (37.7319086387255, -122.382707045529) | |||
| 96519 | 96519 | 14200 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1901X Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6005370.141556599 | 2108806.2043077 | 37.770683665857796 | -122.42478267708 | (37.7706836658578, -122.42478267708) | |||
| 96523 | 96523 | 2448 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1397X Buchanan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/09/1998 12:00:00 AM | 3 | 3X3 | 6004179.9853375 | 2113057.7494528 | 37.782290070243 | -122.42920264733499 | (37.782290070243, -122.429202647335) | ||
| 96526 | 96526 | 26623 | DPW Maintained 3 | Ulmus 'Prospector' :: Prospector Elm 255 | 1285X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/15/1998 12:00:00 AM | 6 | 3X3 | 6011577.7605432 | 2093254.4735551002 | 37.7283306504833 | -122.402216731645 | (37.7283306504833, -122.402216731645) | ||
| 96527 | 96527 | 27280 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 634 Oak St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/18/1999 12:00:00 AM | 3 | 3X3 | 6003944.74418 | 2110118.79911 | 37.774207119954 | -122.42980678534599 | (37.774207119954, -122.429806785346) | ||
| 96531 | 96531 | 2118 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1100X Bosworth St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/06/2005 12:00:00 AM | 3 | 3X3 | 6001043.628513 | 2095761.867481 | 37.734621744877295 | -122.438813219285 | (37.7346217448773, -122.438813219285) | ||
| 96544 | 96544 | 103840 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1546 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006695.0 | 2116184.4 | 37.7910171377023 | -122.420723832321 | (37.7910171377023, -122.420723832321) | ||
| 96546 | 96546 | 26443 | DPW Maintained 3 | Fraxinus oxycarpa 'Raywood' :: Raywood Ash 101 | 1430 Eddy St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6003606.97335 | 2112834.41067 | 37.7816443828524 | -122.431169066991 | (37.7816443828524, -122.431169066991) | |||
| 96550 | 96550 | 107116 | DPW Maintained 3 | Tree(s) :: 17 | 300X LIBERTY ST | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6004270.1 | 2103982.4 | 37.757376462852704 | -122.42824389606199 | (37.7573764628527, -122.428243896062) | ||||
| 96555 | 96555 | 28490 | DPW Maintained 3 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 233 | 1499X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/08/2003 12:00:00 AM | 12 | 3X3 | 6005277.9300739 | 2099610.0882818 | 37.7454280803333 | -122.42444742702 | (37.7454280803333, -122.42444742702) | ||
| 96559 | 96559 | 16227 | DPW Maintained 3 | Trachycarpus fortunei :: Windmill Palm 31 | 564X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/02/2003 12:00:00 AM | 12 | 5 | 5998342.280841901 | 2094738.2735002 | 37.731657141982204 | -122.44807897208 | (37.7316571419822, -122.44807897208) | ||
| 96565 | 96565 | 20978 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 2002X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 40 | 5984887.616570599 | 2101567.3225095 | 37.7496295616808 | -122.49509712324499 | (37.7496295616808, -122.495097123245) | |||
| 96567 | 96567 | 5805 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 5 Dukes Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6016140.1129447995 | 2096198.2445968003 | 37.73666726663679 | -122.386649521955 | (37.7366672666368, -122.386649521955) | |||
| 96570 | 96570 | 75019 | DPW Maintained 3 | Taxus baccata :: Irish Yew 241 | 151X Palm Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/31/1997 12:00:00 AM | 6 | 3x3 | 5995892.05475 | 2113163.21783 | 37.782106991639 | -122.45788265611701 | (37.782106991639, -122.457882656117) | |
| 96573 | 96573 | 90364 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 537 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2008 12:00:00 AM | 3 | 3x3 | 5993970.172866001 | 2111402.29422 | 37.7771613668446 | -122.46440355258301 | (37.7771613668446, -122.464403552583) | ||
| 96582 | 96582 | 7090 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1892 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 5998388.9236 | 2109693.89838 | 37.7727242707137 | -122.448994665385 | (37.7727242707137, -122.448994665385) | |||
| 96584 | 96584 | 112382 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 3250 CESAR CHAVEZ ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6007972.0 | 2100641.0 | 37.7484105018638 | -122.415204699043 | (37.7484105018638, -122.415204699043) | ||||
| 96593 | 96593 | 90150 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 606 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5993698.31044 | 2111441.63963 | 37.77725372407561 | -122.46534686201001 | (37.7772537240756, -122.46534686201) | ||
| 96597 | 96597 | 42644 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1600X GREEN ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/26/2000 12:00:00 AM | 10 | 3x3 | 6005364.0 | 2118556.0 | 37.7974538454152 | -122.425497899433 | (37.7974538454152, -122.425497899433) | |
| 96598 | 96598 | 23187 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 560X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6006458.921066 | 2112191.041059 | 37.7800390474075 | -122.421256963785 | (37.7800390474075, -122.421256963785) | |||
| 96599 | 96599 | 27395 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2300X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3 | 6007121.016846401 | 2120187.7710471 | 37.802033394640105 | -122.41953397743299 | (37.8020333946401, -122.419533977433) | |||
| 96600 | 96600 | 21065 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2192X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | |||
| 96603 | 96603 | 17627 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1135 Persia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/27/2005 12:00:00 AM | 3 | 3X3 | 6004380.712681401 | 2089954.6929998002 | 37.718865821274 | -122.42686234984801 | (37.718865821274, -122.426862349848) | ||
| 96607 | 96607 | 82282 | DPW Maintained 3 | Pittosporum undulatum :: Victorian Box 26 | 1735 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/26/2005 12:00:00 AM | 10 | 3x3 | 6006758.35477915 | 2108129.92542605 | 37.7689050737926 | -122.419932819268 | (37.7689050737926, -122.419932819268) | ||
| 96614 | 96614 | 11757 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 901X Junipero Serra Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X5 | 5991288.1161497 | 2091224.4470027 | 37.7216032788517 | -122.472210346501 | (37.7216032788517, -122.472210346501) | |||
| 96624 | 96624 | 10823 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 1139X Hudson Ave | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/14/2007 12:00:00 AM | 3 | 3X4 | 6017777.243009999 | 2094650.0030099999 | 37.7325066000949 | -122.38088159725099 | (37.7325066000949, -122.380881597251) | ||
| 96629 | 96629 | 20950 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1992X Sunset Blvd | 27 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984875.945426799 | 2101638.8759791 | 37.7498253446275 | -122.495142757654 | (37.7498253446275, -122.495142757654) | |||
| 96630 | 96630 | 7221 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1000X Fillmore St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003426.09434 | 2111753.60864 | 37.778666518442 | -122.43171763216101 | (37.778666518442, -122.431717632161) | |||
| 96636 | 96636 | 20528 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
| 96639 | 96639 | 111917 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 150X Octavia St Frontage East | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4x4 | 6005692.21728 | 2109889.45005 | 37.7736761836422 | -122.42374564492701 | (37.7736761836422, -122.423745644927) | ||||
| 96646 | 96646 | 89752 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1025 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5995478.0169 | 2112129.57687 | 37.779245093230294 | -122.459240156052 | (37.7792450932303, -122.459240156052) | ||
| 96648 | 96648 | 8376 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1301X Geary Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 6005507.71189 | 2114109.8093 | 37.7852538400076 | -122.42468416339199 | (37.7852538400076, -122.424684163392) | ||||
| 96649 | 96649 | 89665 | DPW Maintained 3 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2801X Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/19/2008 12:00:00 AM | 3 | 3x3 | 5989906.30924 | 2111928.05503 | 37.7783698693417 | -122.478500045616 | (37.7783698693417, -122.478500045616) | ||
| 96651 | 96651 | 10718 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 50X Hollis St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003939.0547033 | 2113373.9919105 | 37.783144751009495 | -122.430058726681 | (37.7831447510095, -122.430058726681) | |||
| 96657 | 96657 | 121361 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 399X Cargo Way | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 3x3 | 6017829.0 | 2098352.0 | 37.7426744040176 | -122.380959936377 | (37.7426744040176, -122.380959936377) | |||
| 96658 | 96658 | 24904 | DPW Maintained 3 | Acer rubrum :: Red Maple 6 | 2840 SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2001 12:00:00 AM | 3 | 3X3 | 6011333.0 | 2092357.0 | 37.725852708866796 | -122.402999785692 | (37.7258527088668, -122.402999785692) | ||
| 96659 | 96659 | 10421 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1219X Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3X3 | 5999421.35342 | 2108678.34127 | 37.7699947998181 | -122.44535035645 | (37.7699947998181, -122.44535035645) | |||
| 96670 | 96670 | 90158 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 900X Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/11/2008 12:00:00 AM | 3 | 3x3 | 5992777.08425 | 2111410.577 | 37.777115263754204 | -122.468531390608 | (37.7771152637542, -122.468531390608) | ||
| 96686 | 96686 | 91289 | DPW Maintained 3 | Acacia stenophylla :: Shoestring Acacia 109 | 1258x Guerrero St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 11/20/2008 12:00:00 AM | 3 | 6005785.088369001 | 2101640.018452 | 37.751030430802395 | -122.422837991942 | (37.7510304308024, -122.422837991942) | |||
| 96688 | 96688 | 96513 | DPW Maintained 3 | Pistacia chinensis :: Chinese Pistache 150 | 2360X Harrison St | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 09/15/2012 12:00:00 AM | 3x3 | 6008639.8 | 2104954.0 | 37.7602905334715 | -122.413200395323 | (37.7602905334715, -122.413200395323) | ||
| 96694 | 96694 | 90591 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2344 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 3x3 | 5988261.3164099995 | 2110567.14875 | 37.774537561634496 | -122.484090794334 | (37.7745375616345, -122.484090794334) | ||
| 96695 | 96695 | 27679 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 350 McAllister St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6007460.0458899 | 2112313.2676776 | 37.780431041784 | -122.417802279395 | (37.780431041784, -122.417802279395) | |||
| 96697 | 96697 | 4629 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 427 Columbus Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3x3 | 6010259.97829 | 2119047.3818 | 37.7990784717377 | -122.40859113666401 | (37.7990784717377, -122.408591136664) | |||
| 96711 | 96711 | 90689 | DPW Maintained 3 | Agonis flexuosa :: Peppermint Willow 7 | 4000X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/07/2008 12:00:00 AM | 3 | 3x3 | 5983112.49812 | 2110376.3769799997 | 37.7737126452226 | -122.501887149528 | (37.7737126452226, -122.501887149528) | ||
| 96713 | 96713 | 17187 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1765X Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6005068.838719999 | 2115071.14757 | 37.7878686389946 | -122.42627099885799 | (37.7878686389946, -122.426270998858) | |||
| 96720 | 96720 | 90205 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 2200 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/27/2008 12:00:00 AM | 3 | 3x3 | 5988707.94917 | 2111263.23177 | 37.776474804910706 | -122.482596841197 | (37.7764748049107, -122.482596841197) | ||
| 96723 | 96723 | 104248 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 8X Octavia St Frontage East | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 10x20 | 6005716.34743 | 2109200.23605 | 37.771785130185 | -122.423613163533 | (37.771785130185, -122.423613163533) | |||
| 96728 | 96728 | 17620 | DPW Maintained 3 | Ulmus parvifolia :: Chinese Elm 46 | 1049X Persia Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6004182.578886599 | 2090079.2106526 | 37.7191965146646 | -122.427556086461 | (37.7191965146646, -122.427556086461) | |||
| 96730 | 96730 | 16821 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 2130 O'Farrell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6001107.6476595 | 2113179.9385941 | 37.782451166007 | -122.439840308676 | (37.782451166007, -122.439840308676) | |||
| 96738 | 96738 | 85598 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1101 Palou Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/08/2014 12:00:00 AM | 3 | 3x3 | 6017523.881587001 | 2093256.0516779998 | 37.728665096277204 | -122.381660625783 | (37.7286650962772, -122.381660625783) | ||
| 96741 | 96741 | 15950 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 5823 MISSION ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/30/2014 12:00:00 AM | 3 | 3X3 | 5997354.0 | 2086632.0 | 37.7093426637375 | -122.450911336997 | (37.7093426637375, -122.450911336997) | ||
| 96746 | 96746 | 27434 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1275 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/03/2015 12:00:00 AM | 70 | 3X3 | 6007539.61625 | 2121483.94928 | 37.8056159411906 | -122.41817736946899 | (37.8056159411906, -122.418177369469) | ||
| 96751 | 96751 | 15614 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 3447 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/11/1995 12:00:00 AM | 12 | 3X3 | 6005863.199659999 | 2098167.06317 | 37.7414988933648 | -122.422321147186 | (37.7414988933648, -122.422321147186) | ||
| 96755 | 96755 | 90870 | DPW Maintained 3 | Pyrus calleryana 'New Bradford' :: New Bradford Pear 223 | 2045 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 02/19/2008 12:00:00 AM | 3 | 3x3 | 5989292.971461 | 2110551.77641 | 37.7745553629802 | -122.48052101423 | (37.7745553629802, -122.48052101423) | |
| 96757 | 96757 | 4535 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 65 Cleary Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/04/1999 12:00:00 AM | 3 | 3X3 | 6004884.4780546 | 2113657.3543136003 | 37.783976292732795 | -122.426808129214 | (37.7839762927328, -122.426808129214) | ||
| 96759 | 96759 | 13551 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 444 Market St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 4x4 | 6013042.633150199 | 2116223.6547442 | 37.7914806373756 | -122.39876387205099 | (37.7914806373756, -122.398763872051) | |||
| 96767 | 96767 | 7061 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1530 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6000097.99876 | 2109903.5315099997 | 37.7733974655741 | -122.443097862671 | (37.7733974655741, -122.443097862671) | |||
| 96774 | 96774 | 25020 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 710X Dolores St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 70 | 20 | 6004949.2547318 | 2104210.5607702998 | 37.758041343361796 | -122.425911349448 | (37.7580413433618, -122.425911349448) | |||
| 96775 | 96775 | 16727 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1085X O'Farrell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 5999231.8174217995 | 2112748.0154497 | 37.781158261997206 | -122.44629875636299 | (37.7811582619972, -122.446298756363) | |||
| 96778 | 96778 | 110017 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 34 Maple St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 5996616.0 | 2116061.2 | 37.7901056424074 | -122.455587678197 | (37.7901056424074, -122.455587678197) | |||||
| 96782 | 96782 | 16520 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | |||
| 96787 | 96787 | 19030 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 3176 SACRAMENTO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | 2x2 | 5999568.0 | 2115477.0 | 37.78867053817721 | -122.44533201 | (37.7886705381772, -122.44533201) | |||
| 96797 | 96797 | 1620 | DPW Maintained 3 | Ulmus pumila :: Siberian Elm 53 | 777 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 125 | 3X3 | 5995637.36215 | 2110958.16718 | 37.776037871937206 | -122.45860409582599 | (37.7760378719372, -122.458604095826) | |||
| 96804 | 96804 | 14891 | DPW Maintained 3 | Quercus suber :: Cork Oak 76 | 151 Mendell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/25/2008 12:00:00 AM | 3 | 3x3 | 6017309.26732 | 2098441.11643 | 37.7428903993232 | -122.382763240232 | (37.7428903993232, -122.382763240232) | ||
| 96805 | 96805 | 21501 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2800X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5985062.8642150005 | 2096221.8871717 | 37.7349626975104 | -122.494097196305 | (37.7349626975104, -122.494097196305) | |||
| 96809 | 96809 | 20818 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1800X Sunset Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 10 | 5984848.2208219 | 2102937.1532922 | 37.7533884340422 | -122.4953343632 | (37.7533884340422, -122.4953343632) | |||
| 96817 | 96817 | 7985 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2111 Franklin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005519.50842 | 2117258.74677 | 37.7939007015449 | -122.42486745909201 | (37.7939007015449, -122.424867459092) | |||
| 96819 | 96819 | 14870 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 1460X McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6016026.3862344 | 2095468.2889327 | 37.734656658788296 | -122.38699183277399 | (37.7346566587883, -122.386991832774) | |||
| 96821 | 96821 | 5907 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1280 Eddy St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6004423.138230001 | 2113018.7769 | 37.7821968232059 | -122.42835866766501 | (37.7821968232059, -122.428358667665) | |||
| 96822 | 96822 | 103745 | DPW Maintained 3 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 1999X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008051.81901 | 2107091.2259400003 | 37.766125834179704 | -122.41538525721201 | (37.7661258341797, -122.415385257212) | ||
| 96832 | 96832 | 9274 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 6800 Geary Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/24/2014 02:02:00 PM | 3 | 8M | 5985760.86534 | 2112510.31266 | 37.779727039932794 | -122.49288337676599 | (37.7797270399328, -122.492883376766) | ||
| 96836 | 96836 | 85833 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 875 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/17/2007 12:00:00 AM | 3 | 3x3 | 6011370.824523999 | 2112775.117387 | 37.7819184786136 | -122.40430550469401 | (37.7819184786136, -122.404305504694) | ||
| 96842 | 96842 | 22775 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 1750 Turk St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6001669.86946 | 2112366.9914599997 | 37.78025100635529 | -122.437837026039 | (37.7802510063553, -122.437837026039) | |||
| 96843 | 96843 | 94302 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 1150X Fillmore St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Rec/Park 7 | 6003451.3 | 2112195.3 | 37.7798807216656 | -122.431661979156 | (37.7798807216656, -122.431661979156) | ||||
| 96850 | 96850 | 113535 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100X CASHMERE ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12/05/2015 12:49:00 PM | 3 | 6017054.0 | 2095889.0 | 37.7358686950692 | -122.38346826685301 | (37.7358686950692, -122.383468266853) | |||
| 96853 | 96853 | 85660 | DPW Maintained 3 | Pyrus kawakamii :: Evergreen Pear 82 | 1615 Quesada Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/30/2007 12:00:00 AM | 3 | 3x3 | 6015165.828644999 | 2094663.285506 | 37.7323985938789 | -122.389910883982 | (37.7323985938789, -122.389910883982) | ||
| 96856 | 96856 | 6163 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1000X Ellis St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/16/1993 12:00:00 AM | 6 | 3X3 | 6006064.53658 | 2113525.24895 | 37.7836802135181 | -122.42271616148199 | (37.7836802135181, -122.422716161482) | ||
| 96860 | 96860 | 22116 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 3795X 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/17/2015 03:08:00 PM | 3 | 3x3 | 6015878.88906 | 2098472.9049400003 | 37.7428985547797 | -122.387711351931 | (37.7428985547797, -122.387711351931) | ||
| 96861 | 96861 | 89397 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1700X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/06/2008 12:00:00 AM | 3 | 3x3 | 5993389.8602599995 | 2112111.32369 | 37.7790747025537 | -122.466462566919 | (37.7790747025537, -122.466462566919) | ||
| 96863 | 96863 | 20540 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1303X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 6O | 5984802.8376111 | 2106327.3646052 | 37.7626943540195 | -122.49574136031299 | (37.7626943540195, -122.495741360313) | |||
| 96864 | 96864 | 16562 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 700X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6015552.29216 | 2097280.01448 | 37.7396050257983 | -122.388757385673 | (37.7396050257983, -122.388757385673) | |||
| 96869 | 96869 | 90309 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 4115 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982775.05183 | 2110989.27027 | 37.7753756437209 | -122.503099794321 | (37.7753756437209, -122.503099794321) | ||
| 96871 | 96871 | 20760 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1692X Sunset Blvd | 15 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | 5984807.486919099 | 2103677.7923597 | 37.755419639160706 | -122.495529849669 | (37.7554196391607, -122.495529849669) | |||
| 96887 | 96887 | 97064 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1599X Newcomb Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 6015231.1 | 2095663.5 | 37.7351486000155 | -122.38975506041099 | (37.7351486000155, -122.389755060411) | ||
| 96888 | 96888 | 89479 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4126 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/26/2008 12:00:00 AM | 3 | 3x3 | 5985825.29894 | 2111837.6521400004 | 37.777883874481894 | -122.492610922239 | (37.7778838744819, -122.492610922239) |
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");