Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress ▼ | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 78823 | 78823 | 12380 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/17/2013 12:00:00 AM | 3 | 3x3 | 6004345.46385 | 2113763.0093400003 | 37.7842359045501 | -122.42868045552099 | (37.7842359045501, -122.428680455521) | |||
| 109669 | 109669 | 14676 | DPW Maintained 3 | Acer rubrum 'Red Sunset' :: Red Swamp Maple 254 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/12/2011 12:00:00 AM | 3 | 4x4 | 6005306.03378 | 2112177.46067 | 37.7799366952092 | -122.425244357372 | (37.7799366952092, -122.425244357372) | |||
| 21876 | 21876 | 3876 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6001972.79866 | 2108696.56564 | 37.7701901557853 | -122.43652626967199 | (37.7701901557853, -122.436526269672) | |||
| 13586 | 13586 | 12949 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Lindsay Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016403.18992 | 2095651.77267 | 37.7351813255446 | -122.38570186665501 | (37.7351813255446, -122.385701866655) | |||
| 10396 | 10396 | 9301 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 1 Mansell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6011832.7040800005 | 2090706.21234 | 37.7213478755834 | -122.401156387751 | (37.7213478755834, -122.401156387751) | |||
| 10817 | 10817 | 9300 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Mansell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/10/1992 12:00:00 AM | 12 | 3X3 | 6011786.56982 | 2090691.5636900002 | 37.7213050795375 | -122.40131483301901 | (37.7213050795375, -122.401314833019) | ||
| 11461 | 11461 | 9299 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1 Mansell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6011744.95061 | 2090679.05023 | 37.7212683980005 | -122.401457820749 | (37.7212683980005, -122.401457820749) | |||
| 13384 | 13384 | 13425 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2007 12:00:00 AM | 25 | 4x4 | 6014152.78687 | 2117194.5214299997 | 37.7942082021958 | -122.39499075902599 | (37.7942082021958, -122.394990759026) | ||
| 13475 | 13475 | 13427 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6014172.84776 | 2117212.91542 | 37.7942598232708 | -122.394922634488 | (37.7942598232708, -122.394922634488) | |||
| 13620 | 13620 | 13426 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2003 12:00:00 AM | 8 | 4x4 | 6014161.01916 | 2117188.17749 | 37.7941912409866 | -122.394961829643 | (37.7941912409866, -122.394961829643) | ||
| 14334 | 14334 | 13428 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/29/2003 12:00:00 AM | 6 | 4x4 | 6014180.24954 | 2117205.51401 | 37.7942399123011 | -122.394896504683 | (37.7942399123011, -122.394896504683) | ||
| 14650 | 14650 | 13430 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4x4 | 6014204.722019999 | 2117228.6530400002 | 37.7943048073789 | -122.394813447799 | (37.7943048073789, -122.394813447799) | |||
| 14759 | 14759 | 13420 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/18/1991 12:00:00 AM | 30 | 4x4 | 6014066.39965 | 2117110.5956099997 | 37.7939729575322 | -122.395283788713 | (37.7939729575322, -122.395283788713) | ||
| 15013 | 15013 | 13423 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/12/2002 12:00:00 AM | 20 | 4x4 | 6014116.98151 | 2117144.48589 | 37.7940688252683 | -122.39511114407699 | (37.7940688252683, -122.395111144077) | ||
| 15024 | 15024 | 13424 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/2003 12:00:00 AM | 20 | 4x4 | 6014140.16579 | 2117170.60528 | 37.7941418322359 | -122.395032753763 | (37.7941418322359, -122.395032753763) | ||
| 15548 | 15548 | 13429 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 4x4 | 6014197.04513 | 2117235.7914400003 | 37.7943239809064 | -122.39484051109501 | (37.7943239809064, -122.394840511095) | |||
| 15704 | 15704 | 13419 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/10/1991 12:00:00 AM | 20 | 4x4 | 6014048.53109 | 2117080.6085599996 | 37.7938896263516 | -122.395343514492 | (37.7938896263516, -122.395343514492) | ||
| 15964 | 15964 | 13422 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/10/2007 12:00:00 AM | 3 | 4x4 | 6014092.01898 | 2117123.77404 | 37.7940105671925 | -122.39519606616999 | (37.7940105671925, -122.39519606617) | ||
| 16385 | 16385 | 27316 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 6014028.45913 | 2117061.6774 | 37.7938365294714 | -122.39541163905199 | (37.7938365294714, -122.395411639052) | |||
| 16449 | 16449 | 13418 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 4x4 | 6014042.20206 | 2117087.71971 | 37.7939087999011 | -122.395365912104 | (37.7939087999011, -122.395365912104) | |||
| 16600 | 16600 | 13421 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1 Market St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/02/1991 12:00:00 AM | 30 | 4x4 | 6014072.44813 | 2117102.953 | 37.793952309100206 | -122.395262324595 | (37.7939523091002, -122.395262324595) | ||
| 76817 | 76817 | 90411 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006552.3 | 2109010.7 | 37.771311860318 | -122.420708085152 | (37.771311860318, -122.420708085152) | ||
| 77634 | 77634 | 90408 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006661.144462001 | 2109154.301371 | 37.7717122894321 | -122.420341780693 | (37.7717122894321, -122.420341780693) | ||
| 104896 | 104896 | 90409 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006661.144462001 | 2109154.301371 | 37.7717122894321 | -122.420341780693 | (37.7717122894321, -122.420341780693) | ||
| 109635 | 109635 | 90410 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 McCoppin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/21/2008 12:00:00 AM | 3 | 3x3 | 6006661.144462001 | 2109154.301371 | 37.7717122894321 | -122.420341780693 | (37.7717122894321, -122.420341780693) | ||
| 19459 | 19459 | 15076 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1 Minerva St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 11 | 5995952.59829 | 2089005.6317099999 | 37.7157797770894 | -122.455926258705 | (37.7157797770894, -122.455926258705) | |||
| 21404 | 21404 | 15067 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1 Minerva St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 11 | 5996019.74584 | 2089003.9616 | 37.7157790450506 | -122.455694046564 | (37.7157790450506, -122.455694046564) | |||
| 77416 | 77416 | 107558 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | |
| 81584 | 81584 | 107564 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 8 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 83430 | 83430 | 107562 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 84607 | 84607 | 107559 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | |
| 98961 | 98961 | 107560 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | |
| 103606 | 103606 | 107561 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 12 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 112266 | 112266 | 107554 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | |||
| 120274 | 120274 | 107563 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | ||
| 123339 | 123339 | 107555 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | |
| 125335 | 125335 | 107556 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | |
| 142291 | 142291 | 107557 | DPW Maintained 3 | Tree(s) :: 17 | 1 Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/12/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774049 | 6018726.0 | 2097063.0 | 37.739184535220005 | -122.37776889284599 | (37.73918453522, -122.377768892846) | |
| 2209 | 2209 | 189798 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Potrero Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 17 | Width 3ft | 6010293.93626 | 2108038.50565 | 37.7688526102954 | -122.407696978027 | (37.7688526102954, -122.407696978027) | |||
| 1952 | 1952 | 139587 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1 Saint Joseph's Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 0ft | 6000732.3602 | 2112121.031 | 37.7795223070318 | -122.441062642932 | (37.7795223070318, -122.441062642932) | |||
| 83347 | 83347 | 22801 | DPW Maintained 3 | Tree(s) :: 17 | 1 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/12/1997 12:00:00 AM | 3 | 2x2 | 5998832.3639752995 | 2099992.0164602003 | 37.746110667966704 | -122.446762549602 | (37.7461106679667, -122.446762549602) | ||
| 111961 | 111961 | 1 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 10 10th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 16 | 5992719.40718 | 2114869.71245 | 37.7866097734767 | -122.46898271049601 | (37.7866097734767, -122.468982710496) | |||
| 107859 | 107859 | 1389 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 10 Ardath Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/11/2006 12:00:00 AM | 3 | 3X4 | 6017228.6912616 | 2095462.3520099 | 37.7347068580177 | -122.38283460251301 | (37.7347068580177, -122.382834602513) | ||
| 17205 | 17205 | 26909 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997629.54091 | 2089680.9775599998 | 37.71773022584279 | -122.45017865014299 | (37.7177302258428, -122.450178650143) | |||
| 17237 | 17237 | 26912 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 50 | 10 | 5997598.31865 | 2089637.50605 | 37.7176090763688 | -122.450283439137 | (37.7176090763688, -122.450283439137) | |||
| 19068 | 19068 | 26911 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 10 Caine Ave | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997609.86555 | 2089654.4499099997 | 37.7176562610968 | -122.450244747607 | (37.7176562610968, -122.450244747607) | |||
| 19083 | 19083 | 26913 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 10 | 5997584.35365 | 2089616.43233 | 37.717550413599795 | -122.45033019131 | (37.7175504135998, -122.45033019131) | |||
| 19195 | 19195 | 26910 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5997620.43146 | 2089669.0920400003 | 37.7176970696553 | -122.45020928103399 | (37.7176970696553, -122.450209281034) | |||
| 19203 | 19203 | 26914 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 10 Caine Ave | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5997577.15723 | 2089606.82913 | 37.7175236335794 | -122.45035437405599 | (37.7175236335794, -122.450354374056) | |||
| 19342 | 19342 | 26905 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 10 | 5997683.40035 | 2089758.8108400002 | 37.7179470200262 | -122.449998089654 | (37.7179470200262, -122.449998089654) | |||
| 19833 | 19833 | 26915 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 10 Caine Ave | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 01/26/1999 12:00:00 AM | 3 | 10 | 5997570.4467 | 2089598.1443599998 | 37.7174994031582 | -122.450376943463 | (37.7174994031582, -122.450376943463) | ||
| 20603 | 20603 | 26906 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 10 | 5997668.873459999 | 2089736.17467 | 37.717884035095295 | -122.450046671911 | (37.7178840350953, -122.450046671911) | |||
| 21305 | 21305 | 26908 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997639.65043 | 2089696.09364 | 37.7177723096208 | -122.45014479517 | (37.7177723096208, -122.45014479517) | |||
| 21645 | 21645 | 26907 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Caine Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 10 | 5997653.71656 | 2089718.57825 | 37.717834852078205 | -122.45009779478701 | (37.7178348520782, -122.450097794787) | |||
| 88204 | 88204 | 14623 | DPW Maintained 3 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 10 Matthew Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1998 12:00:00 AM | 6 | 3X4 | 6018016.8978124 | 2094239.2837711999 | 37.7313920698281 | -122.38002451510201 | (37.7313920698281, -122.380024515102) | ||
| 13724 | 13724 | 4898 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Rosie Lee Ln | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017985.0017 | 2094485.55993 | 37.7320665362465 | -122.380151894906 | (37.7320665362465, -122.380151894906) | |||
| 14426 | 14426 | 4895 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 10 Rosie Lee Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1993 12:00:00 AM | 12 | 3X4 | 6018140.882180001 | 2094365.07214 | 37.7317442992597 | -122.379604608867 | (37.7317442992597, -122.379604608867) | ||
| 16623 | 16623 | 4897 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Rosie Lee Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018099.28954 | 2094405.0263599998 | 37.731851711585996 | -122.37975117949 | (37.731851711586, -122.37975117949) | |||
| 23034 | 23034 | 4896 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Rosie Lee Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/11/1999 12:00:00 AM | 6 | 3X4 | 6018106.77773 | 2094390.5453599999 | 37.731812362636205 | -122.37972428526699 | (37.7318123626362, -122.379724285267) | ||
| 110441 | 110441 | 28300 | DPW Maintained 3 | Ficus nitida :: Laurel Fig 43 | 100 Broad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 13 | 3X3 | 5995887.0 | 2088090.0 | 37.713261901345 | -122.45608683538099 | (37.713261901345, -122.456086835381) | |||
| 14267 | 14267 | 3797 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100 Cashmere St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016837.41936 | 2095915.09048 | 37.7359283617946 | -122.384218895383 | (37.7359283617946, -122.384218895383) | |||
| 23210 | 23210 | 3796 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100 Cashmere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 1 | 3X3 | 6016917.42909 | 2095896.09045 | 37.735880614983294 | -122.38394094461901 | (37.7358806149833, -122.383940944619) | |||
| 7160 | 7160 | 4592 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Columbus Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/23/2016 01:42:00 PM | 3 | 3x3 | 6011401.079390001 | 2118088.92644 | 37.796510626729706 | -122.40457501395299 | (37.7965106267297, -122.404575013953) | ||
| 22996 | 22996 | 4591 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100 Columbus Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x2 | 6011425.16703 | 2118064.77563 | 37.796445660597 | -122.40448996415199 | (37.796445660597, -122.404489964152) | |||
| 17252 | 17252 | 24963 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004800.736959999 | 2107633.50365 | 37.7674315357679 | -122.42666873508999 | (37.7674315357679, -122.42666873509) | |||
| 19333 | 19333 | 24968 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004810.58196 | 2107534.1310400004 | 37.767159239034704 | -122.426627605497 | (37.7671592390347, -122.426627605497) | |||
| 19334 | 19334 | 24962 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2005 12:00:00 AM | 30 | 20 | 6004805.8872 | 2107667.07109 | 37.76752399506629 | -122.42665331171999 | (37.7675239950663, -122.42665331172) | ||
| 19826 | 19826 | 24965 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004804.04595 | 2107595.6918 | 37.767327900586 | -122.42665459683799 | (37.767327900586, -122.426654596838) | |||
| 20452 | 20452 | 24966 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 90 | 20 | 6004812.73188 | 2107584.41194 | 37.76729741985871 | -122.426623750096 | (37.7672974198587, -122.426623750096) | |||
| 21578 | 21578 | 5327 | DPW Maintained 3 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 100 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X3 | 6004755.67064 | 2107733.77413 | 37.7677043064343 | -122.426831755188 | (37.7677043064343, -122.426831755188) | |||
| 22009 | 22009 | 24961 | DPW Maintained 3 | Phoenix canariensis :: Canary Island Date Palm 100 | 100 Dolores St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/21/2005 12:00:00 AM | 90 | 20 | 6004800.95891 | 2107734.51921 | 37.76770891277079 | -122.42667516163999 | (37.7677089127708, -122.42667516164) | ||
| 19241 | 19241 | 116677 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 100 Esmeralda Ave | 16 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 78555 | 78555 | 116671 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 100 Esmeralda Ave | 7 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 82247 | 82247 | 116682 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 100 Esmeralda Ave | 21 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 86166 | 86166 | 116675 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 100 Esmeralda Ave | 14 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 14 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | ||||
| 89602 | 89602 | 116672 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Esmeralda Ave | 9 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 92622 | 92622 | 116679 | DPW Maintained 3 | Yucca elephantipes :: Giant Yucca 211 | 100 Esmeralda Ave | 18 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 95944 | 95944 | 116681 | DPW Maintained 3 | Leptospermum laevigatum :: Australian Tea Tree 38 | 100 Esmeralda Ave | 20 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 113837 | 113837 | 116669 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Esmeralda Ave | 6 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 20 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | ||||
| 123800 | 123800 | 116680 | DPW Maintained 3 | Dodonaea viscosa :: Hop Bush 132 | 100 Esmeralda Ave | 19 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 126736 | 126736 | 116670 | DPW Maintained 3 | Quercus agrifolia :: Coast Live Oak 180 | 100 Esmeralda Ave | 8 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 127057 | 127057 | 116678 | DPW Maintained 3 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 100 Esmeralda Ave | 17 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 138825 | 138825 | 116683 | DPW Maintained 3 | Pittosporum crassifolium :: Karo Tree 108 | 100 Esmeralda Ave | 22 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 143384 | 143384 | 116676 | DPW Maintained 3 | Aesculus californica :: California Buckeye 338 | 100 Esmeralda Ave | 15 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6006917.389830001 | 2098966.37493 | 37.7437530336215 | -122.41873278303999 | (37.7437530336215, -122.41873278304) | |||||
| 84722 | 84722 | 8291 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 87594 | 87594 | 8293 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 95088 | 95088 | 8292 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 117295 | 117295 | 8294 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 128632 | 128632 | 8295 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 Garcia Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995006.6013281 | 2099280.197711 | 37.743936899881 | -122.45993989851101 | (37.743936899881, -122.459939898511) | |||
| 4690 | 4690 | 253527 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/2017 09:54:00 AM | 3 | 3X3 | 6005589.149 | 2109643.5092 | 37.7729950707153 | -122.424084680793 | (37.7729950707153, -122.424084680793) | ||
| 20140 | 20140 | 10246 | DPW Maintained 3 | Tristania conferta :: 79 | 100 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6005589.149 | 2109643.5092 | 37.7729950707153 | -122.424084680793 | (37.7729950707153, -122.424084680793) | |||
| 9933 | 9933 | 11201 | DPW Maintained 3 | Taxus baccata :: Irish Yew 241 | 100 Idora Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8 | 5995318.65927 | 2099418.1217 | 37.7443335470614 | -122.458870864793 | (37.7443335470614, -122.458870864793) | |||
| 18799 | 18799 | 11188 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100 Idora Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 5995291.088769999 | 2099424.10153 | 37.7443483813689 | -122.45896663000299 | (37.7443483813689, -122.458966630003) | |||
| 18983 | 18983 | 11186 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 100 Idora Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 5995298.39303 | 2099423.25523 | 37.7443464775133 | -122.458941312315 | (37.7443464775133, -122.458941312315) | |||
| 20854 | 20854 | 11187 | DPW Maintained 3 | Acacia melanoxylon :: Blackwood Acacia 5 | 100 Idora Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 5995309.2253 | 2099420.08132 | 37.7443383854121 | -122.458903627104 | (37.7443383854121, -122.458903627104) | |||
| 21814 | 21814 | 11202 | DPW Maintained 3 | Pinus thunbergii :: Japanese Black Pine 306 | 100 Idora Ave | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 8 | 5995328.17404 | 2099416.28223 | 37.744329043248 | -122.458837831796 | (37.744329043248, -122.458837831796) | |||
| 16854 | 16854 | 11488 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Jennings St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/05/1993 12:00:00 AM | 6 | 4X4 | 6018872.157000001 | 2097296.32677 | 37.7398332567899 | -122.377279727371 | (37.7398332567899, -122.377279727371) | ||
| 16881 | 16881 | 11487 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 100 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6018880.35523 | 2097308.40588 | 37.7398668752499 | -122.37725221891 | (37.7398668752499, -122.37725221891) | |||
| 80072 | 80072 | 11492 | DPW Maintained 3 | Melaleuca quinquenervia :: Cajeput 50 | 100 Jennings St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/13/2000 12:00:00 AM | 3 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) | ||
| 81124 | 81124 | 11506 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100 Jennings St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 4X4 | 6018974.640384 | 2097432.5118216 | 37.7402128389975 | -122.376934824049 | (37.7402128389975, -122.376934824049) |
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");