Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantType, qCaretaker, qCareAssistant, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99533 | 99533 | 100242 | Private 5 | Tree(s) :: 17 | 76 Linda St | Sidewalk: Curb side : Pot 10 | Landscaping 2 | Private 1 | 6005815.0 | 2105046.0 | 37.76038415245 | -122.422976606568 | (37.76038415245, -122.422976606568) | ||||||
| 198 | 198 | 103786 | DPW Maintained 3 | Magnolia grandiflora :: Southern Magnolia 21 | 1221 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006804.9894 | 2115120.2532 | 37.7881014522033 | -122.420267712778 | (37.7881014522033, -122.420267712778) | ||
| 1781 | 1781 | 214663 | Undocumented 2 | Tree(s) :: 17 | 427 Kirkham St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 06/01/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779947 | 5993526.84887 | 2105257.2946900004 | 37.7602632600539 | -122.46549062240601 | (37.7602632600539, -122.465490622406) | |
| 4327 | 4327 | 103839 | DPW Maintained 3 | Maytenus boaria :: Mayten 22 | 1552 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006685.2576 | 2116316.1212 | 37.791378262309706 | -122.420766896 | (37.7913782623097, -122.420766896) | ||
| 4390 | 4390 | 175420 | Undocumented 2 | Pyrus kawakamii :: Evergreen Pear 82 | 211 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6003926.56795 | 2092414.35505 | 37.7255938222743 | -122.428607384746 | (37.7255938222743, -122.428607384746) | |||
| 4580 | 4580 | 142832 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1553 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 9 | Width 0ft | 6006643.2439 | 2116275.8765 | 37.791265392276 | -122.420909404242 | (37.791265392276, -122.420909404242) | ||
| 4604 | 4604 | 142833 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1549 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 9 | Width 0ft | 6006645.4552 | 2116252.8795 | 37.7912023728705 | -122.42090011974501 | (37.7912023728705, -122.420900119745) | ||
| 5221 | 5221 | 72132 | Undocumented 2 | Tree(s) :: 17 | 950 Wisconsin St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 12/01/2011 12:00:00 AM | 3 | 3x3 | Permit Number 780813 | 6012748.1522699995 | 2103075.8524599997 | 37.755363341648795 | -122.398859619973 | (37.7553633416488, -122.398859619973) |
| 6300 | 6300 | 103795 | Permitted Site 1 | Magnolia grandiflora :: Southern Magnolia 21 | 1215 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006811.4062 | 2115079.7468 | 37.78799059318229 | -122.42024263571899 | (37.7879905931823, -122.420242635719) | ||
| 7553 | 7553 | 142835 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1515 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | Width 0ft | 6006663.5874 | 2116129.9342 | 37.7908658176323 | -122.42082865045799 | (37.7908658176323, -122.420828650458) | ||||
| 8241 | 8241 | 115531 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007312.7374599995 | 2111269.98589 | 37.777558150214404 | -122.41823790028 | (37.7775581502144, -122.41823790028) | ||
| 8938 | 8938 | 103857 | DPW Maintained 3 | Syagrus romanzoffianum :: Queen Palm 142 | 1475 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 11/01/2009 12:00:00 AM | 3 | 3x3 | 6006690.1878 | 2115953.9432 | 37.7903840892726 | -122.42072411493 | (37.7903840892726, -122.42072411493) | ||
| 18492 | 18492 | 63236 | Permitted Site 1 | Trachycarpus fortunei :: Windmill Palm 31 | 3634 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | FUF 1 | 01/13/1987 12:00:00 AM | 12 | Permit Number 23784 | 6006063.67565171 | 2104362.69748074 | 37.7585219924343 | -122.422068008351 | (37.7585219924343, -122.422068008351) | |
| 22812 | 22812 | 224471 | Undocumented 2 | Ficus carica :: Edible Fig 201 | 627 Precita Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6009784.7997 | 2100421.88863 | 37.7479105825135 | -122.408920592022 | (37.7479105825135, -122.408920592022) | |||
| 22852 | 22852 | 138173 | Undocumented 2 | :: 54 | 1953 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 6000211.2401 | 2111613.6154 | 37.7780993776744 | -122.44282896766 | (37.7780993776744, -122.44282896766) | |||
| 22874 | 22874 | 179489 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 36 Goettingen St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6009813.802999999 | 2094277.0712700002 | 37.7310398674871 | -122.40838693792801 | (37.7310398674871, -122.408386937928) | |||
| 22907 | 22907 | 233756 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 138 Alpine Ter | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6001688.04868 | 2107994.1327400003 | 37.768245263926396 | -122.43746090722 | (37.7682452639264, -122.43746090722) | |||
| 22953 | 22953 | 103852 | DPW Maintained 3 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1507 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | DPW 2 | 08/21/2013 12:00:00 AM | 3 | 3x3 | 6006614.6 | 2116113.6 | 37.7908182067111 | -122.420996984718 | (37.7908182067111, -122.420996984718) | ||
| 23385 | 23385 | 225339 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 3033 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 6002890.27268 | 2096019.3333400001 | 37.73543357459229 | -122.43244713645001 | (37.7354335745923, -122.43244713645) | |||
| 23685 | 23685 | 131311 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3701 Jackson St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 5996479.01622 | 2115904.55519 | 37.7896676762649 | -122.45605029860201 | (37.7896676762649, -122.456050298602) | |||
| 23754 | 23754 | 194580 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 598 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6013513.20546 | 2104325.65158 | 37.758837617875294 | -122.39630140851001 | (37.7588376178753, -122.39630140851) | |||
| 23836 | 23836 | 204823 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1331 09th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 5993302.77838 | 2106404.87542 | 37.7634012905668 | -122.466348974927 | (37.7634012905668, -122.466348974927) | |||
| 24538 | 24538 | 232518 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4518 25th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6000862.85333 | 2101145.4432599996 | 37.749393486316706 | -122.43982407823401 | (37.7493934863167, -122.439824078234) | |||
| 24563 | 24563 | 128713 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 555 Jackson St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6011289.01038 | 2117973.50016 | 37.7961874301503 | -122.404954668136 | (37.7961874301503, -122.404954668136) | |||
| 24769 | 24769 | 244936 | Undocumented 2 | Ulmus parvifolia :: Chinese Elm 46 | 294 Page St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 0ft | 6005165.6636 | 2109931.2421 | 37.7737611964044 | -122.425570051796 | (37.7737611964044, -122.425570051796) | |||
| 24801 | 24801 | 179172 | Undocumented 2 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 766 Brussels St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6011071.2158 | 2091212.4916599998 | 37.7226955033774 | -122.403824260795 | (37.7226955033774, -122.403824260795) | |||
| 25005 | 25005 | 177418 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 857 Dartmouth St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 4ft | 6009516.77243 | 2090302.7647799999 | 37.720110619797104 | -122.409133494811 | (37.7201106197971, -122.409133494811) | |||
| 25089 | 25089 | 224296 | Undocumented 2 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 5 Powhattan Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 43 | Width 3ft | 6007487.03456 | 2098209.30712 | 37.7417063503734 | -122.416709460186 | (37.7417063503734, -122.416709460186) | |||
| 25116 | 25116 | 132137 | Undocumented 2 | Phoenix roebelenii :: Pigmy Date Palm 344 | 576 Sacramento St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6011959.93168 | 2117122.22989 | 37.7938875264289 | -122.40257323908999 | (37.7938875264289, -122.40257323909) | |||
| 25128 | 25128 | 143413 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 599 Kearny St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6011351.7699 | 2116964.7162 | 37.7934210599755 | -122.404666454604 | (37.7934210599755, -122.404666454604) | |||
| 25173 | 25173 | 140670 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 40 COLE ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 5997774.3514 | 2110415.6204 | 37.7746707659902 | -122.451172585534 | (37.7746707659902, -122.451172585534) | |||
| 25630 | 25630 | 194576 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 572 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6013508.15849 | 2104424.13067 | 37.7591077391483 | -122.396325765734 | (37.7591077391483, -122.396325765734) | |||
| 26021 | 26021 | 137509 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 85 Toledo Way | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6001461.48208 | 2119936.52079 | 37.801023121670106 | -122.439100597914 | (37.8010231216701, -122.439100597914) | |||
| 26027 | 26027 | 227311 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 405 Beacon St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6002323.66405 | 2098293.59277 | 37.7416460184529 | -122.434568676724 | (37.7416460184529, -122.434568676724) | |||
| 26143 | 26143 | 245512 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 106 Chattanooga St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 6004701.89686 | 2103004.13948 | 37.754714811762206 | -122.42668090920701 | (37.7547148117622, -122.426680909207) | |||
| 26283 | 26283 | 226595 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 880 Douglass St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 6001269.3073 | 2101283.04072 | 37.749794423884794 | -122.438428410468 | (37.7497944238848, -122.438428410468) | |||
| 26581 | 26581 | 194044 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1542 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 3ft | 6013293.95823 | 2104770.11303 | 37.760045809374205 | -122.39709083697201 | (37.7600458093742, -122.397090836972) | |||
| 26967 | 26967 | 127517 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 330 Geary St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6010076.35722 | 2114778.73619 | 37.7873475198145 | -122.40892519296499 | (37.7873475198145, -122.408925192965) | |||
| 27120 | 27120 | 135723 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 1910 Baker St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 4ft | 5999974.03757 | 2115574.89722 | 37.7889625079578 | -122.44393422098699 | (37.7889625079578, -122.443934220987) | |||
| 27204 | 27204 | 126614 | Undocumented 2 | Ficus Spp. :: 253 | 728 Washington St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6011128.855280001 | 2117659.08548 | 37.7953151696175 | -122.40548668546002 | (37.7953151696175, -122.40548668546) | |||
| 27373 | 27373 | 127889 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1520 Mason St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6009298.57619 | 2118522.06879 | 37.797582201307705 | -122.411880784278 | (37.7975822013077, -122.411880784278) | |||
| 27853 | 27853 | 128263 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 2 Lombard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6012051.14949 | 2120876.60895 | 37.80420123766179 | -122.402521741194 | (37.8042012376618, -122.402521741194) | |||
| 28509 | 28509 | 234021 | Undocumented 2 | Pittosporum tobira :: Japanese Mockorange 243 | 147 Nevada St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 6009064.5456300005 | 2097789.7459400003 | 37.7406429263284 | -122.411225300822 | (37.7406429263284, -122.411225300822) | |||
| 28738 | 28738 | 209878 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 649 Parnassus Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 5994950.47657 | 2106078.83176 | 37.7626009937499 | -122.460626532115 | (37.7626009937499, -122.460626532115) | |||
| 28810 | 28810 | 189783 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1712 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6012852.355219999 | 2104746.67943 | 37.759956872734705 | -122.39861649547501 | (37.7599568727347, -122.398616495475) | |||
| 28966 | 28966 | 242013 | Undocumented 2 | Tristaniopsis laurina :: Swamp Myrtle 37 | 3350 18th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 3ft | 6007139.614130001 | 2105587.52459 | 37.7619457090369 | -122.418433769026 | (37.7619457090369, -122.418433769026) | |||
| 28999 | 28999 | 222600 | Undocumented 2 | Calocedrus decurrens :: Incense Cedar 177 | 41 Roanoke St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 6ft | 6003358.58638 | 2096297.6712 | 37.736224371859606 | -122.430847858561 | (37.7362243718596, -122.430847858561) | |||
| 29106 | 29106 | 229884 | Undocumented 2 | Jacaranda mimosifolia :: Jacaranda 52 | 137 Bradford St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 5ft | 6009563.00843 | 2097787.4840700002 | 37.7406646584401 | -122.409501640412 | (37.7406646584401, -122.409501640412) | |||
| 29119 | 29119 | 220589 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 653 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002332.20411 | 2099716.00641 | 37.7455521185496 | -122.43464083471301 | (37.7455521185496, -122.434640834713) | |||
| 29131 | 29131 | 194397 | Undocumented 2 | Phoenix dactylifera :: Date Palm 65 | 1797 Bancroft Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 1ft | 6013420.92243 | 2092796.80792 | 37.7271767046165 | -122.39581273756501 | (37.7271767046165, -122.395812737565) | |||
| 29394 | 29394 | 228372 | Undocumented 2 | Grevillea spp :: Silkoak species 369 | 3784 20th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 1ft | 6005132.77553 | 2104314.58442 | 37.7583373376056 | -122.425284057905 | (37.7583373376056, -122.425284057905) | |||
| 29521 | 29521 | 231336 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 4864 17th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 5997916.37939 | 2105662.1050400003 | 37.7616269560303 | -122.45033855228998 | (37.7616269560303, -122.45033855229) | |||
| 29639 | 29639 | 220335 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 523 Day St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6002527.73455 | 2098555.81183 | 37.7423775935402 | -122.433881808696 | (37.7423775935402, -122.433881808696) | |||
| 29646 | 29646 | 229482 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1557 Church St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004608.55119 | 2099805.21218 | 37.745926022487104 | -122.426775926168 | (37.7459260224871, -122.426775926168) | |||
| 29718 | 29718 | 130970 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 2801 Webster St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 2ft | 6002945.56276 | 2118345.7946599997 | 37.796739734404 | -122.433851284829 | (37.796739734404, -122.433851284829) | |||
| 29825 | 29825 | 188590 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 762 De Haro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 2ft | 6012084.87947 | 2104884.86073 | 37.7602934997697 | -122.401280549067 | (37.7602934997697, -122.401280549067) | |||
| 30005 | 30005 | 223689 | Undocumented 2 | Cupressocyparis leylandii :: Leyland Cypress 34 | 278 Upper Ter | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | Width 4ft | 5999412.71789 | 2106090.89076 | 37.7628898173431 | -122.445194172985 | (37.7628898173431, -122.445194172985) | |||
| 30172 | 30172 | 176454 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1609 Burrows St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 2ft | 6006663.80662 | 2092086.9978599998 | 37.7248494992863 | -122.41912174768801 | (37.7248494992863, -122.419121747688) | |||
| 30452 | 30452 | 131764 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1492 Pacific Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 3ft | 6007026.74159 | 2117749.85493 | 37.7953341794929 | -122.419687137974 | (37.7953341794929, -122.419687137974) | |||
| 30492 | 30492 | 194157 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 301 Rhode Island St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6011751.61895 | 2106914.05853 | 37.7658466245494 | -122.40257584440701 | (37.7658466245494, -122.402575844407) | |||
| 30789 | 30789 | 236735 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 2235 Castro St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | Width 8ft | 6002728.24168 | 2098985.0046599996 | 37.7435674334864 | -122.433219176525 | (37.7435674334864, -122.433219176525) | |||
| 30862 | 30862 | 179685 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 218 Edinburgh St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6003869.47166 | 2092417.36805 | 37.7255988638766 | -122.42880497658899 | (37.7255988638766, -122.428804976589) | |||
| 31166 | 31166 | 125541 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 65 Heather Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | 5997339.5515 | 2114115.46943 | 37.7848046777406 | -122.45294375606501 | (37.7848046777406, -122.452943756065) | ||||
| 32493 | 32493 | 215383 | Undocumented 2 | Tibochina urvilleana :: Princess Flower 260 | 270 Arch St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 5992739.059780001 | 2088994.50565 | 37.7155642635536 | -122.467032825702 | (37.7155642635536, -122.467032825702) | |||
| 32945 | 32945 | 178518 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 62 Kelloch Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | Width 6ft | 6008249.62715 | 2086262.35093 | 37.708945414261606 | -122.41322803793899 | (37.7089454142616, -122.413228037939) | |||
| 33047 | 33047 | 132295 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 1213 Lombard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6006526.56714 | 2120062.48471 | 37.8016558891581 | -122.421582156104 | (37.8016558891581, -122.421582156104) | |||
| 33287 | 33287 | 118775 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 630 45th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 27 | Width 2ft | 5981986.088380001 | 2111427.82901 | 37.7765333919608 | -122.50586147692101 | (37.7765333919608, -122.505861476921) | |||
| 33419 | 33419 | 218015 | Undocumented 2 | Prunus cerasifera :: Cherry Plum 16 | 645 Santiago St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 5990772.5777900005 | 2099709.35635 | 37.7448708407289 | -122.474611345145 | (37.7448708407289, -122.474611345145) | |||
| 33683 | 33683 | 221802 | Undocumented 2 | Agonis flexuosa :: Peppermint Willow 7 | 325 Day St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 3ft | 6003816.248819999 | 2098634.77002 | 37.7426674306639 | -122.42943214577 | (37.7426674306639, -122.42943214577) | |||
| 33746 | 33746 | 239587 | Undocumented 2 | Schinus molle :: California Pepper 138 | 105 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 5ft | 6007266.87289 | 2098693.35025 | 37.7430230396951 | -122.41750500495701 | (37.7430230396951, -122.417505004957) | |||
| 33859 | 33859 | 220622 | Undocumented 2 | Afrocarpus gracilior :: Fern Pine 70 | 58 Fountain St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6000334.98133 | 2101342.05017 | 37.7499032598351 | -122.441663574927 | (37.7499032598351, -122.441663574927) | |||
| 33890 | 33890 | 231844 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 96 Museum Way | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 3ft | 6000872.22935 | 2106652.07973 | 37.764513903924104 | -122.44018648793501 | (37.7645139039241, -122.440186487935) | |||
| 34064 | 34064 | 126015 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 500 Post St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6009674.03362 | 2115055.86699 | 37.788085909974605 | -122.410336729273 | (37.7880859099746, -122.410336729273) | |||
| 34157 | 34157 | 220325 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 737 Duncan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 6ft | 6001752.60876 | 2099682.61141 | 37.745427503077394 | -122.43664259248999 | (37.7454275030774, -122.43664259249) | |||
| 34297 | 34297 | 220329 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 4489 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 8ft | 6000090.03644 | 2101642.36493 | 37.7507138925428 | -122.44253216264099 | (37.7507138925428, -122.442532162641) | |||
| 34597 | 34597 | 211298 | Undocumented 2 | Pinus thunbergii :: Japanese Black Pine 306 | 401 Orizaba Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 17 | Width 5ft | 5993996.41913 | 2089243.4812200002 | 37.7163203865396 | -122.462704908526 | (37.7163203865396, -122.462704908526) | |||
| 34732 | 34732 | 100681 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 400 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | 6012316.03692 | 2116830.7554099998 | 37.793107081281 | -122.401320580594 | (37.793107081281, -122.401320580594) | ||||
| 34772 | 34772 | 131290 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3878 Clay St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 5ft | 5996291.53313 | 2115272.33104 | 37.7879209958986 | -122.456653226584 | (37.7879209958986, -122.456653226584) | |||
| 34869 | 34869 | 220361 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 3378 18th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6007031.22663 | 2105582.9717 | 37.7619271056612 | -122.418808316877 | (37.7619271056612, -122.418808316877) | |||
| 34911 | 34911 | 176616 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1373 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 5999306.08729 | 2089805.4122099997 | 37.7181676947695 | -122.44439253889601 | (37.7181676947695, -122.444392538896) | |||
| 34983 | 34983 | 127970 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 362 Green St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 2ft | 6011213.49855 | 2119375.68536 | 37.800033269380705 | -122.40531474949199 | (37.8000332693807, -122.405314749492) | |||
| 35252 | 35252 | 221239 | Undocumented 2 | Betula pendula :: European White Birch 146 | 207 Montcalm St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 5ft | 6010023.25186 | 2099680.69535 | 37.745888782448 | -122.40804376831001 | (37.745888782448, -122.40804376831) | |||
| 35731 | 35731 | 200325 | Undocumented 2 | Liquidambar styraciflua 'Rotundiloba' :: Roundleaf sweetgum 328 | 301 Main St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6015214.59398 | 2115265.69066 | 37.788971064105795 | -122.391181870273 | (37.7889710641058, -122.391181870273) | |||
| 35862 | 35862 | 204983 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 770 Myra Way | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 5997269.92545 | 2098069.6489 | 37.7407429372348 | -122.452026562677 | (37.7407429372348, -122.452026562677) | |||
| 36109 | 36109 | 224807 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1468 Sanchez St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | Width 2ft | 6003911.9159 | 2099717.26212 | 37.7456451201217 | -122.42917852528099 | (37.7456451201217, -122.429178525281) | |||
| 36580 | 36580 | 142827 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1714 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006619.3625 | 2116773.8493 | 37.7926313555217 | -122.421027406021 | (37.7926313555217, -122.421027406021) | |||
| 36634 | 36634 | 247287 | Undocumented 2 | :: 54 | 640 Stanyan St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997019.8905 | 2108844.4958 | 37.770313639572 | -122.453668930321 | (37.770313639572, -122.453668930321) | |||
| 36736 | 36736 | 205507 | Undocumented 2 | Corymbia ficifolia :: Red Flowering Gum 60 | 1518 05th Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 24 | 5994641.653519999 | 2105137.30281 | 37.7599980266194 | -122.46162636506 | (37.7599980266194, -122.46162636506) | ||||
| 37175 | 37175 | 126019 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 542 Geary St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 4ft | 6009096.37686 | 2114637.77725 | 37.7869055381056 | -122.412305766101 | (37.7869055381056, -122.412305766101) | |||
| 37254 | 37254 | 140262 | Undocumented 2 | :: 54 | 70 Cole St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 0 | Width 0ft | 5997786.9682 | 2110316.587 | 37.7743995682404 | -122.451121798449 | (37.7743995682404, -122.451121798449) | |||
| 37713 | 37713 | 192997 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1856 Illinois St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 6ft | 6016261.5851 | 2100510.3314 | 37.748514099551 | -122.38653011709499 | (37.748514099551, -122.386530117095) | |||
| 37783 | 37783 | 131938 | Undocumented 2 | Olea europaea :: Olive Tree 41 | 1545 Pacific Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 2ft | 6006702.042119999 | 2117656.1689 | 37.7950586451804 | -122.420803998799 | (37.7950586451804, -122.420803998799) | |||
| 37884 | 37884 | 226699 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 38 Ramona Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 4ft | 6005184.56747 | 2107580.1746400003 | 37.767306799804004 | -122.42533732116001 | (37.767306799804, -122.42533732116) | |||
| 38130 | 38130 | 176461 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 55 University St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 2ft | 6007804.4952 | 2093798.5187099997 | 37.7296131398345 | -122.415299613696 | (37.7296131398345, -122.415299613696) | |||
| 38194 | 38194 | 128461 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 341 California St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6012421.30504 | 2116788.3689900003 | 37.7929965707839 | -122.40095336493 | (37.7929965707839, -122.40095336493) | |||
| 38381 | 38381 | 136611 | Undocumented 2 | Syzygium paniculatum :: Brush Cherry 198 | 1630 Bay St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 1ft | 6002977.377719999 | 2120668.13454 | 37.80311807979739 | -122.433907279317 | (37.8031180797974, -122.433907279317) | |||
| 38458 | 38458 | 118677 | Undocumented 2 | Pittosporum crassifolium :: Karo Tree 108 | 4749 Balboa St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5980875.63021 | 2110909.60557 | 37.7750450801709 | -122.50966429974702 | (37.7750450801709, -122.509664299747) | |||
| 38524 | 38524 | 124392 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 3900 Washington St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 2ft | 5996085.26261 | 2115570.92527 | 37.788729010018294 | -122.45738849109199 | (37.7887290100183, -122.457388491092) | |||
| 38856 | 38856 | 245670 | Undocumented 2 | Cordyline australis :: Dracena Palm 141 | 7 28th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 3ft | 6005859.67566 | 2099629.8615 | 37.745515207653604 | -122.422437245889 | (37.7455152076536, -122.422437245889) | |||
| 39321 | 39321 | 232585 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 1689 Noe St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6003395.282000001 | 2098400.5130000003 | 37.7420003720285 | -122.430871012505 | (37.7420003720285, -122.430871012505) |
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");