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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 820 | 820 | 251223 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 80X Junipero Serra Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/18/2008 12:00:00 AM | Width 3ft | 5991438.54417 | 2088636.90192 | 37.714507218415 | -122.47150190860901 | (37.714507218415, -122.471501908609) | |||
| 828 | 828 | 8634 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 2600 Geary Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 20 | 5999136.363 | 2113194.1665 | 37.7823778250539 | -122.44666108993299 | (37.7823778250539, -122.446661089933) | |||
| 2705 | 2705 | 175366 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1 Brotherhood Way | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 5993316.47827 | 2087783.2739799998 | 37.7122718230516 | -122.464949108223 | (37.7122718230516, -122.464949108223) | |||
| 3148 | 3148 | 253327 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Euclid Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5999085.0 | 2114289.0 | 37.7853810185166 | -122.446917590697 | (37.7853810185166, -122.446917590697) | |||||
| 3937 | 3937 | 253112 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1000 Cayuga Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/04/2017 11:51:00 AM | 3 | Width 0ft | 5999996.87806 | 2090379.50245 | 37.719783405947204 | -122.442045963044 | (37.7197834059472, -122.442045963044) | ||
| 4669 | 4669 | 253646 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1200x La Salle Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 11/09/1992 12:00:00 AM | 3x3 | 6017461.0 | 2094327.0 | 37.731602238049504 | -122.381952476407 | (37.7316022380495, -122.381952476407) | ||
| 4937 | 4937 | 203013 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/07/1996 12:00:00 AM | 2 | Width 3ft | 6017575.06427 | 2098435.51559 | 37.742889701702794 | -122.381843789478 | (37.7428897017028, -122.381843789478) | ||
| 5052 | 5052 | 3586 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/10/2017 10:01:00 AM | 3 | 3X3 | 6018456.23147 | 2097881.24253 | 37.74141639814229 | -122.378758444849 | (37.7414163981423, -122.378758444849) | ||
| 6948 | 6948 | 20002 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 100 STAIRWAY46 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2 | ||||||||
| 7348 | 7348 | 20335 | DPW Maintained 3 | Pinus pinea :: Italian Stone Pine 143 | 101X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 7837 | 7837 | 13454 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 2X Market St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/16/2012 12:00:00 AM | 6 | 4X4 | Permit Number 769284 | 6013880.8635 | 2117062.92899 | 37.7938317558804 | -122.39592242518101 | (37.7938317558804, -122.395922425181) | |
| 8485 | 8485 | 20457 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 495X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 9018 | 9018 | 44539 | Permitted Site 1 | Tree(s) :: 17 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2001 12:00:00 AM | Permit Number 43835 | |||||||||
| 9201 | 9201 | 3819 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 101X Cashmere St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2016 12:00:00 AM | 4 | 3X3 | 6017067.4579304 | 2095837.0108628003 | 37.7357266870687 | -122.383418119044 | (37.7357266870687, -122.383418119044) | ||
| 9231 | 9231 | 6725 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1200X Fairfax Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2008 12:00:00 AM | 3 | 3x3 | 6017621.9936242 | 2096730.3826429 | 37.7382103402349 | -122.381562963191 | (37.7382103402349, -122.381562963191) | ||
| 9673 | 9673 | 114129 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200X JUNIPERO SERRA BLVD | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 11214 | 11214 | 20374 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 12466 | 12466 | 48238 | Permitted Site 1 | Tree(s) :: 17 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/2002 12:00:00 AM | Permit Number 45761 | |||||||||
| 13101 | 13101 | 36633 | Permitted Site 1 | Robinia x ambigua :: Locust 33 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/20/1998 12:00:00 AM | Permit Number 39461 | |||||||||
| 13170 | 13170 | 19599 | DPW Maintained 3 | Cupressocyparis leylandii :: Leyland Cypress 34 | 100 STAIRWAY4 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 14692 | 14692 | 3717 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 401X Cargo Way | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016818.97287 | 2099045.87092 | 37.7445238319196 | -122.384500671891 | (37.7445238319196, -122.384500671891) | |||
| 14858 | 14858 | 6530 | DPW Maintained 3 | Platanus x hispanica :: Sycamore: London Plane 15 | 1200X Evans Ave | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 15 | 6017366.22044 | 2097260.33377 | 37.7396513545281 | -122.38248417152799 | (37.7396513545281, -122.382484171528) | |||
| 15209 | 15209 | 19838 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 100 STAIRWAY25 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
| 15452 | 15452 | 12142 | Permitted Site 1 | Corymbia ficifolia :: Red Flowering Gum 60 | 1400X La Salle Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/17/1996 12:00:00 AM | 3 | 3X3 | 6016364.0707 | 2095472.0382700001 | 37.734685646232 | -122.385824593536 | (37.734685646232, -122.385824593536) | ||
| 15529 | 15529 | 78325 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 50 Pomona St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 07/15/2000 12:00:00 AM | 3 | 3x3 | 6014082.074630001 | 2094268.0058099998 | 37.731253074258596 | -122.393630047885 | (37.7312530742586, -122.393630047885) | |
| 15661 | 15661 | 11532 | DPW Maintained 3 | Eucalyptus sideroxylon :: Red Ironbark 36 | 101X Jennings St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018674.73047 | 2096936.9392900001 | 37.738835572289794 | -122.377937414197 | (37.7388355722898, -122.377937414197) | |||
| 15789 | 15789 | 3512 | DPW Maintained 3 | Aesculus x carnea :: Red Horse Chestnut 194 | 201X Cargo Way | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018049.38641 | 2098082.73153 | 37.741947208609 | -122.380179187546 | (37.741947208609, -122.380179187546) | |||
| 16115 | 16115 | 45902 | Permitted Site 1 | Tree(s) :: 17 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/06/2001 12:00:00 AM | Permit Number 44451 | |||||||||
| 16203 | 16203 | 19623 | DPW Maintained 3 | Eucalyptus Spp :: Eucalyptus 40 | 100 STAIRWAY5 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 16237 | 16237 | 51111 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | Permit Number 47557 | 6013008.01748439 | 2109097.62504611 | 37.7719122726701 | -122.398383421945 | (37.7719122726701, -122.398383421945) | |||
| 16602 | 16602 | 44863 | Permitted Site 1 | Tree(s) :: 17 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/25/2001 12:00:00 AM | Permit Number 43922 | |||||||||
| 16634 | 16634 | 21880 | DPW Maintained 3 | Washingtonia robusta :: Mexican Fan Palm 75 | 1900 03rd St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/25/1995 12:00:00 AM | 3 | 3X3 | 6015651.4577 | 2106526.92513 | 37.765000592730395 | -122.389059971145 | (37.7650005927304, -122.389059971145) | ||
| 17232 | 17232 | 11705 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 700X Junipero Serra Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/09/2013 12:00:00 AM | 3 | 6X6 | 5991287.29739 | 2092772.28865 | 37.7258532209449 | -122.47232595470601 | (37.7258532209449, -122.472325954706) | ||
| 17543 | 17543 | 29278 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 300X Portola Dr | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 10/14/2005 12:00:00 AM | 3 | 3X3 | 5998653.8721 | 2100156.73057 | 37.7465527348295 | -122.447391602559 | (37.7465527348295, -122.447391602559) | ||
| 18024 | 18024 | 28732 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 1795X Evans Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 08/20/2005 12:00:00 AM | 12 | 3X3 | 6014623.837937901 | 2099253.7018787 | 37.7449728593106 | -122.39210559674801 | (37.7449728593106, -122.392105596748) | ||
| 18714 | 18714 | 24844 | Permitted Site 1 | Casurina stricta :: Beefwood: Drooping She-Oak 309 | 200X Alemany Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Dept of Real Estate 5 | 01/12/1996 12:00:00 AM | 20 | 3X3 | 6009416.6826304 | 2095906.0445619 | 37.735490432624104 | -122.409874802768 | (37.7354904326241, -122.409874802768) | ||
| 18734 | 18734 | 94234 | Permitted Site 1 | Pinus canariensis :: Canary Island Pine 71 | 1501@Clearfield Sloat Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 06/28/2010 12:00:00 AM | 14 | Permit Number 53611 | 5986536.9 | 2095861.8 | 37.734060135224205 | -122.488974540344 | (37.7340601352242, -122.488974540344) | ||
| 19640 | 19640 | 41394 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1250 Sunnydale Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/2000 12:00:00 AM | Permit Number 42021 | 6008204.54210993 | 2087109.47599829 | 37.711268913870896 | -122.41344372896201 | (37.7112689138709, -122.413443728962) | ||
| 20890 | 20890 | 29613 | DPW Maintained 3 | Schinus molle :: California Pepper 138 | 900X Junipero Serra Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991166.63654 | 2090933.6499400001 | 37.7207977908582 | -122.47260907386499 | (37.7207977908582, -122.472609073865) | ||
| 24248 | 24248 | 219332 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1025 Junipero Serra Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 5991262.77441 | 2090479.13965 | 37.719555381949206 | -122.47224364333 | (37.7195553819492, -122.47224364333) | |||
| 26081 | 26081 | 249738 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2500 Broderick St | 22 | : 4 | Tree 1 | Private 1 | 17 | Width 3ft | 6000189.3449800005 | 2117178.8516 | 37.7933788258243 | -122.443304539972 | (37.7933788258243, -122.443304539972) | |||
| 26100 | 26100 | 201969 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1651 Carroll Ave | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6013782.624009999 | 2092181.31295 | 37.725506794893896 | -122.394519248986 | (37.7255067948939, -122.394519248986) | |||
| 26618 | 26618 | 217527 | DPW Maintained 3 | Yucca gloriosa :: Spanish Dagger 224 | 1x Minerva St | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5996233.42463 | 2089002.36528 | 37.7157869222112 | -122.454955363219 | (37.7157869222112, -122.454955363219) | |||
| 27043 | 27043 | 194682 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Jack Balestreri Way | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6012380.91774 | 2104784.0825900002 | 37.760033297111704 | -122.400249606728 | (37.7600332971117, -122.400249606728) | ||||
| 27949 | 27949 | 175625 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 10 | Width 0ft | 6009376.03196 | 2090018.08104 | 37.719321051904295 | -122.40959990662701 | (37.7193210519043, -122.409599906627) | |||
| 29614 | 29614 | 210555 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 15x San Marcos Ave | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 5993274.23094 | 2100297.44327 | 37.7466302132305 | -122.466003890675 | (37.7466302132305, -122.466003890675) | |||
| 29679 | 29679 | 121786 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1501x Illinois St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6016255.4069300005 | 2101838.7957200003 | 37.752161444010795 | -122.38664410433998 | (37.7521614440108, -122.38664410434) | |||
| 29899 | 29899 | 192224 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009548.42342 | 2108726.25306 | 37.770699244008895 | -122.410324231382 | (37.7706992440089, -122.410324231382) | |||
| 30995 | 30995 | 240260 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 155 Appleton Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6005682.645959999 | 2097069.8371299999 | 37.7384759711765 | -122.42286747885001 | (37.7384759711765, -122.42286747885) | |||
| 31062 | 31062 | 241106 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 1403 Douglass St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 5ft | 6001402.56706 | 2099659.53106 | 37.745344231248396 | -122.437851325373 | (37.7453442312484, -122.437851325373) | |||
| 32213 | 32213 | 234524 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 671 Church St | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 3ft | 6004318.84944 | 2105025.5422900002 | 37.7602434426069 | -122.4281496397 | (37.7602434426069, -122.4281496397) | |||
| 32412 | 32412 | 21086 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2192X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | 5984923.321673 | 2100279.0596028 | 37.7460944336033 | -122.494878681905 | (37.7460944336033, -122.494878681905) | |||
| 33109 | 33109 | 197147 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 65 Whitney Young Cir | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6017204.67342 | 2094944.70699 | 37.7332841805136 | -122.38288162868099 | (37.7332841805136, -122.382881628681) | |||
| 33570 | 33570 | 179741 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 201 Trumbull St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 4ft | 6004901.636469999 | 2094356.73695 | 37.7309823072691 | -122.42537481481101 | (37.7309823072691, -122.425374814811) | |||
| 33959 | 33959 | 201774 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 724 Jamestown Ave | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 8ft | 6015625.88693 | 2087662.37118 | 37.713200962139794 | -122.38783202245001 | (37.7132009621398, -122.38783202245) | |||
| 34037 | 34037 | 192697 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1 Westbrook Ct | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6017301.9357 | 2095598.4077599999 | 37.7350844865661 | -122.38259083289499 | (37.7350844865661, -122.382590832895) | |||
| 34536 | 34536 | 185170 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 2500 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 0ft | 5985158.5914 | 2097729.8288 | 37.739108703159204 | -122.493877329625 | (37.7391087031592, -122.493877329625) | |||
| 35158 | 35158 | 125513 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 900 Green St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 5ft | 6008593.294869999 | 2119027.33171 | 37.798929935227 | -122.414357023482 | (37.798929935227, -122.414357023482) | |||
| 35248 | 35248 | 187993 | Undocumented 2 | Alnus rhombifolia :: White Alder 204 | 1751 Armstrong Ave | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6013977.11905 | 2092745.6161 | 37.72706706828671 | -122.39388637447901 | (37.7270670682867, -122.393886374479) | |||
| 35367 | 35367 | 197333 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1501 25th St | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6014202.148440001 | 2101967.42619 | 37.7524007500093 | -122.39375364352301 | (37.7524007500093, -122.393753643523) | ||||
| 35633 | 35633 | 185470 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 2400 Sunset Blvd | 22 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985119.081 | 2098414.7854 | 37.7409870981235 | -122.49406440544399 | (37.7409870981235, -122.494064405444) | |||
| 36402 | 36402 | 181462 | Undocumented 2 | Cedrus deodara :: Deodar Cedar 129 | 1400 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984903.9819 | 2105176.5315 | 37.75954041063989 | -122.495306668351 | (37.7595404106399, -122.495306668351) | |||
| 36758 | 36758 | 193478 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1301 Minnesota St | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 7 | 6015377.93979 | 2102408.26653 | 37.7536764734156 | -122.389718317152 | (37.7536764734156, -122.389718317152) | ||||
| 38078 | 38078 | 223907 | Undocumented 2 | Dodonaea viscosa 'Purpurea' :: Purple Hopseed Bush 197 | 1000 Dolores St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005052.86926 | 2102433.4593700003 | 37.7531676936567 | -122.425426540214 | (37.7531676936567, -122.425426540214) | |||
| 38674 | 38674 | 217832 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 Cranleigh Dr | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 7ft | 5991396.48191 | 2095769.3933599999 | 37.7340888381105 | -122.472166883492 | (37.7340888381105, -122.472166883492) | |||
| 38880 | 38880 | 175995 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 500 Geneva Ave | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 5ft | 5998981.8742 | 2090546.54145 | 37.7201841618528 | -122.44556646533 | (37.7201841618528, -122.44556646533) | |||
| 39067 | 39067 | 131360 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 2501 Jackson St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002031.37188 | 2116676.75667 | 37.792105070155294 | -122.436895043878 | (37.7921050701553, -122.436895043878) | |||
| 40343 | 40343 | 186027 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1900 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5985002.2109 | 2101959.4686 | 37.750712995557606 | -122.49472976560301 | (37.7507129955576, -122.494729765603) | |||
| 40421 | 40421 | 196353 | Undocumented 2 | Prunus lyonii :: Catalina Cherry 300 | 1900 19th St | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 6011962.814119999 | 2105133.05123 | 37.7609681648715 | -122.40172016377599 | (37.7609681648715, -122.401720163776) | ||||
| 41461 | 41461 | 212306 | DPW Maintained 3 | Corymbia ficifolia :: Red Flowering Gum 60 | 1000x Junipero Serra Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5991196.13313 | 2090333.39999 | 37.719151359714395 | -122.472463376508 | (37.7191513597144, -122.472463376508) | |||
| 42126 | 42126 | 191788 | Undocumented 2 | Eucalyptus leucoxylon mac 'Rosea' :: Yellow Gum 247 | 210 Channel | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6014523.52915 | 2109561.3593900003 | 37.7732698904311 | -122.39317357090401 | (37.7732698904311, -122.393173570904) | |||
| 45099 | 45099 | 184964 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1990 41st Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5983545.7781 | 2101731.1432 | 37.7500007203614 | -122.499749280915 | (37.7500007203614, -122.499749280915) | |||
| 45346 | 45346 | 121804 | DPW Maintained 3 | Jacaranda mimosifolia :: Jacaranda 52 | 1201x Vermont St | 22 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011405.0 | 2102539.0 | 37.753814330877205 | -122.403466904543 | (37.7538143308772, -122.403466904543) | ||||
| 46337 | 46337 | 185407 | Undocumented 2 | Quercus agrifolia :: Coast Live Oak 180 | 2300 Sunset Blvd | 22 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5985075.6429 | 2099093.4159999997 | 37.742847892869 | -122.49426460522899 | (37.742847892869, -122.494264605229) | |||
| 46925 | 46925 | 180031 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 1800x Alemany Blvd | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | Width 2ft | 6001136.72316 | 2091302.93534 | 37.7223838352188 | -122.438172045228 | (37.7223838352188, -122.438172045228) | |||
| 46953 | 46953 | 214356 | Undocumented 2 | Prunus domestica 'Mariposa' :: Mariposa Plum 72 | 811 Congo St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 6000533.92821 | 2095885.0481 | 37.7349309587854 | -122.44058425268 | (37.7349309587854, -122.44058425268) | ||||
| 47102 | 47102 | 193590 | Undocumented 2 | Melaleuca quinquenervia :: Cajeput 50 | 500 24th St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6016328.74179 | 2102605.6460599997 | 37.7542711141303 | -122.386443962031 | (37.7542711141303, -122.386443962031) | |||
| 47202 | 47202 | 224151 | Undocumented 2 | Eucalyptus camaldulensis :: River Red Gum 340 | 1001 San Jose Ave | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6005242.254269999 | 2097000.5907599998 | 37.738260977451894 | -122.424385217901 | (37.7382609774519, -122.424385217901) | ||||
| 47523 | 47523 | 112220 | DPW Maintained 3 | Fraxinus americana :: American Ash 23 | 2000X Turk Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 3x3 | 5999785.2022 | 2111976.4403 | 37.7790713042385 | -122.444328861929 | (37.7790713042385, -122.444328861929) | |||
| 47872 | 47872 | 250281 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 43 United Nations Plz | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 0ft | 6008344.09456 | 2112135.7661599996 | 37.7799933758261 | -122.414731365385 | (37.7799933758261, -122.414731365385) | |||
| 49177 | 49177 | 185538 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2201 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 56 | Width 0ft | 5984886.3401 | 2100056.9512 | 37.7454824194744 | -122.49499018303801 | (37.7454824194744, -122.494990183038) | |||
| 49345 | 49345 | 192665 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 299 Cashmere St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6016919.8989 | 2095826.92152 | 37.7356908274651 | -122.383927590599 | (37.7356908274651, -122.383927590599) | |||
| 49630 | 49630 | 20735 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1601X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 | 5984865.3499442 | 2104298.7792233997 | 37.7571280850658 | -122.49537554020701 | (37.7571280850658, -122.495375540207) | |||
| 50007 | 50007 | 186756 | Undocumented 2 | Leptospermum laevigatum :: Australian Tea Tree 38 | 1200 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 0ft | 5984857.4742 | 2106702.5322 | 37.7637276584797 | -122.495580067458 | (37.7637276584797, -122.495580067458) | |||
| 50141 | 50141 | 178167 | Undocumented 2 | Pinus canariensis :: Canary Island Pine 71 | 10 Brotherhood Way | 22 | : 4 | Tree 1 | Private 1 | 5 | Width 0ft | 5992858.09731 | 2087851.4953400001 | 37.7124327018762 | -122.466538351485 | (37.7124327018762, -122.466538351485) | |||
| 52059 | 52059 | 187854 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 1670 Owen St | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 6013896.55337 | 2107438.7733400003 | 37.7674068916492 | -122.395193670376 | (37.7674068916492, -122.395193670376) | |||
| 52449 | 52449 | 197294 | Undocumented 2 | Quercus virginiana :: Southern Live Oak 341 | 11 Bridgeview Way | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6016100.76588 | 2108247.57178 | 37.769750011393796 | -122.387625967988 | (37.7697500113938, -122.387625967988) | |||
| 52749 | 52749 | 186137 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1700 Sunset Blvd | 22 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | Width 0ft | 5984959.1326 | 2103197.126 | 37.754108740755 | -122.49496998026501 | (37.754108740755, -122.494969980265) | |||
| 54092 | 54092 | 249690 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 2400 Baker St | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 5999737.36235 | 2117301.9106 | 37.793690929232795 | -122.444877277083 | (37.7936909292328, -122.444877277083) | ||||
| 55869 | 55869 | 191869 | Undocumented 2 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 1196 La Salle Ave | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6017313.47535 | 2094403.8962400001 | 37.731805231916596 | -122.382467851533 | (37.7318052319166, -122.382467851533) | |||
| 55999 | 55999 | 206854 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Junipero Serra Blvd | 22 | : 4 | Tree 1 | Private 1 | 27 | Width 0ft | 5991361.96016 | 2094005.6081400001 | 37.7292439294521 | -122.47215771221902 | (37.7292439294521, -122.472157712219) | |||
| 56490 | 56490 | 196563 | Undocumented 2 | Pyracantha 'Santa Cruz' :: Firethorn Tree 'Santa Cruz' 362 | 1 25th St | 22 | : Yard 23 | Tree 1 | Private 1 | 5 | 6014971.47986 | 2102285.2089 | 37.7533160359259 | -122.391115357305 | (37.7533160359259, -122.391115357305) | ||||
| 56812 | 56812 | 180158 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 579 Madrid St | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 2ft | 6002520.13209 | 2090692.25327 | 37.7207856212475 | -122.433346310091 | (37.7207856212475, -122.433346310091) | |||
| 58074 | 58074 | 211472 | DPW Maintained 3 | Pittosporum tenuifolium :: Tawhiwhi Pittosporum 193 | 200x Terrace Dr | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 5993829.814069999 | 2096532.0459099999 | 37.7363234123842 | -122.463809497222 | (37.7363234123842, -122.463809497222) | ||||
| 58168 | 58168 | 209136 | DPW Maintained 3 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 900x Bosworth St | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6000997.1554 | 2095746.93377 | 37.7345780962937 | -122.438972822257 | (37.7345780962937, -122.438972822257) | ||||
| 58205 | 58205 | 188572 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 101 Pennsylvania Ave | 22 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6014321.6155199995 | 2106524.04213 | 37.764918870439 | -122.39365939726801 | (37.764918870439, -122.393659397268) | ||||
| 58818 | 58818 | 186492 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1400 Lower Great Hwy | 22 | unknown : Yard 19 | Tree 1 | Private 1 | 2 | Width 0ft | 5980885.336 | 2105278.6712 | 37.759584746696 | -122.509212475259 | (37.759584746696, -122.509212475259) | |||
| 59529 | 59529 | 193919 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 151 Berry St | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6015098.7686 | 2111019.91409 | 37.7773066961843 | -122.39128570057501 | (37.7773066961843, -122.391285700575) | |||
| 59769 | 59769 | 239203 | Undocumented 2 | Pyrus calleryana 'Chanticleer' :: Ornamental Pear Tree 'Chanticleer' 147 | 100 Hwy 101 Southbound | 22 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6005946.44181 | 2108844.1649 | 37.7708204294492 | -122.42279194121402 | (37.7708204294492, -122.422791941214) | ||||
| 60010 | 60010 | 189329 | DPW Maintained 3 | Cordyline australis :: Dracena Palm 141 | 1427x Innes Ave | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 22 | 6016170.50674 | 2096734.9149900002 | 37.7381425376441 | -122.386581846976 | (37.7381425376441, -122.386581846976) |
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");