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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65440 | 65440 | 177472 | Undocumented 2 | Malus :: Crab Apple 235 | 1 Balhi Ct | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 6000768.0406599995 | 2090886.53495 | 37.721219518940394 | -122.439416658362 | (37.7212195189404, -122.439416658362) | |||
| 160042 | 160042 | 128763 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Grant Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6011215.3339 | 2114610.75087 | 37.7869500059829 | -122.40497271843999 | (37.7869500059829, -122.40497271844) | |||
| 177848 | 177848 | 128762 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1 Grant Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6011213.77667 | 2114631.44944 | 37.787006752307796 | -122.404979564051 | (37.7870067523078, -122.404979564051) | |||
| 61974 | 61974 | 234468 | Undocumented 2 | Picea Spp :: Spruce Spp 357 | 1 Newburg St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6002588.30489 | 2099995.27539 | 37.7463334612324 | -122.433775235453 | (37.7463334612324, -122.433775235453) | |||
| 161495 | 161495 | 226597 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 1 Newburg St | 10 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6002589.21192 | 2100000.55478 | 37.746348008668 | -122.433772476325 | (37.746348008668, -122.433772476325) | |||
| 45848 | 45848 | 129548 | Undocumented 2 | Ligustrum japonicum :: Japanese Privet 4 | 1 Saroyan Pl | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 4ft | 6011012.0164 | 2118485.6729900003 | 37.7975782452004 | -122.405949226574 | (37.7975782452004, -122.405949226574) | |||
| 44279 | 44279 | 248099 | Undocumented 2 | Cornus SPP :: Dogwood 336 | 10 Brewster St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6010433.82285 | 2099780.55401 | 37.7461859517306 | -122.40663109974301 | (37.7461859517306, -122.406631099743) | |||
| 40636 | 40636 | 175683 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Valmar Ter | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 6005492.68833 | 2092982.2771700001 | 37.727241719317796 | -122.42323378171999 | (37.7272417193178, -122.42323378172) | |||
| 168905 | 168905 | 175684 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 10 Valmar Ter | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6005481.57404 | 2092966.57789 | 37.727197985294204 | -122.423271088287 | (37.7271979852942, -122.423271088287) | |||
| 150398 | 150398 | 208602 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 100 Edgewood Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 4ft | 5996618.83287 | 2106426.3084 | 37.7636509189712 | -122.454881430853 | (37.7636509189712, -122.454881430853) | |||
| 106682 | 106682 | 96543 | Permitted Site 1 | Tree(s) :: 17 | 100 Pine St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 143626 | 143626 | 96540 | Permitted Site 1 | Tree(s) :: 17 | 100 Pine St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 73092 | 73092 | 117576 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 100 Waverly Pl | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 3x3 | 6010746.80079 | 2117296.5570099996 | 37.794298384417296 | -122.40678310046499 | (37.7942983844173, -122.406783100465) | |||
| 175864 | 175864 | 200451 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Indiana St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 8ft | 6014956.18254 | 2103836.3549900004 | 37.757574303320204 | -122.391276680392 | (37.7575743033202, -122.391276680392) | |||
| 182544 | 182544 | 200450 | Undocumented 2 | Lophostemon confertus :: Brisbane Box 11 | 1000 Indiana St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 16 | Width 8ft | 6014955.45065 | 2103853.5745099997 | 37.7576215438129 | -122.391280415259 | (37.7576215438129, -122.391280415259) | |||
| 45189 | 45189 | 220002 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1001 Jarboe Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 8ft | 6009383.355930001 | 2096884.0702099998 | 37.7381740121064 | -122.4100590501 | (37.7381740121064, -122.4100590501) | |||
| 178540 | 178540 | 220003 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 1001 Jarboe Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 8ft | 6009365.07591 | 2096886.4272 | 37.738179459299296 | -122.410122419925 | (37.7381794592993, -122.410122419925) | |||
| 66560 | 66560 | 142884 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1001 POLK ST | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 0ft | 6006908.0601 | 2114365.4705 | 37.786034811662795 | -122.41985752560801 | (37.7860348116628, -122.419857525608) | |||
| 150161 | 150161 | 142882 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1001 POLK ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006903.448 | 2114407.3806 | 37.7861496266915 | -122.41987645727801 | (37.7861496266915, -122.419876457278) | |||
| 156999 | 156999 | 142883 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1001 POLK ST | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6006904.8517 | 2114389.9348 | 37.7861018038827 | -122.41987036243799 | (37.7861018038827, -122.419870362438) | |||
| 37006 | 37006 | 113232 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1001 Polk St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | 3x3 | 6006901.77113 | 2114384.86271 | 37.7860877036192 | -122.419880660363 | (37.7860877036192, -122.419880660363) | |||
| 77434 | 77434 | 81367 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1001 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11/08/2003 12:00:00 AM | 3x3 | 6006914.85774282 | 2114314.60875621 | 37.7858955407321 | -122.41983039718201 | (37.7858955407321, -122.419830397182) | |||
| 148838 | 148838 | 113233 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1001 Polk St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | 3x3 | 6006902.650769999 | 2114366.34076 | 37.786036896442496 | -122.41987630224399 | (37.7860368964425, -122.419876302244) | |||
| 159164 | 159164 | 113231 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1001 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | 3x3 | 6006895.89971 | 2114421.0496799997 | 37.7861867333855 | -122.419903542741 | (37.7861867333855, -122.419903542741) | |||
| 176402 | 176402 | 210907 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1009 Kirkham St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 32 | Width 3ft | 5991740.69924 | 2105187.8933900003 | 37.7599695243799 | -122.47166295830499 | (37.7599695243799, -122.471662958305) | |||
| 52680 | 52680 | 96544 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100@ Front St Pine St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | 2 | Permit Number 767720 | 6013029.74558 | 2116576.80835 | 37.7924495959214 | -122.39883325906099 | (37.7924495959214, -122.398833259061) | ||
| 95159 | 95159 | 96547 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 110127 | 110127 | 96546 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 110892 | 110892 | 96548 | Permitted Site 1 | Pyrus calleryana :: Ornamental Pear 9 | 100@ Front St Pine St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | Permit Number 767720 | 6013094.0 | 2116579.0 | 37.7924591936564 | -122.398611089295 | (37.7924591936564, -122.398611089295) | |||
| 167472 | 167472 | 96545 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100@ Front St Pine St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 05/27/2011 12:00:00 AM | 2 | Permit Number 767720 | 6012972.08955 | 2116568.16592 | 37.7924226531442 | -122.399032145021 | (37.7924226531442, -122.399032145021) | ||
| 2811 | 2811 | 115532 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007293.46404 | 2111265.83422 | 37.777545665835596 | -122.41830427922501 | (37.7775456658356, -122.418304279225) | ||
| 6140 | 6140 | 115534 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007259.83389 | 2111260.26588 | 37.777528483399294 | -122.418420222514 | (37.7775284833993, -122.418420222514) | ||
| 6989 | 6989 | 115533 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007275.38703 | 2111262.82601 | 37.7775363884346 | -122.418366600452 | (37.7775363884346, -122.418366600452) | ||
| 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) | ||
| 8494 | 8494 | 115535 | Planning Code 138.1 required 4 | Rhaphiolepis Majestic Beauty :: Indian Hawthorn 'Majestic Beau' 106 | 100X Hayes St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 02/08/2016 12:00:00 AM | 3 | Permit Number 770842 | 6007237.56945 | 2111260.60051 | 37.777528148837796 | -122.41849726655899 | (37.7775281488378, -122.418497266559) | ||
| 39478 | 39478 | 233321 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 101 Glenbrook Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 23 | Width 10ft | 5997911.86978 | 2104120.7437299998 | 37.7573945063633 | -122.450243040706 | (37.7573945063633, -122.450243040706) | |||
| 23717 | 23717 | 190342 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014826.26604 | 2116061.6193 | 37.7911349426626 | -122.39258114252199 | (37.7911349426626, -122.392581142522) | |||
| 71337 | 71337 | 190343 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 9 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014833.65153 | 2116067.9736900004 | 37.7911528005014 | -122.39255603344499 | (37.7911528005014, -122.392556033445) | |||
| 120061 | 120061 | 190337 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014767.49042 | 2116002.10502 | 37.790968265916796 | -122.392780340547 | (37.7909682659168, -122.392780340547) | |||
| 147364 | 147364 | 190341 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014814.94374 | 2116051.9719599998 | 37.7911078245033 | -122.39261964247801 | (37.7911078245033, -122.392619642478) | |||
| 158095 | 158095 | 190339 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014796.07981 | 2116028.26498 | 37.791041682965606 | -122.39268325242399 | (37.7910416829656, -122.392683252424) | |||
| 158248 | 158248 | 190338 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014779.60174 | 2116014.8679 | 37.7910039825033 | -122.39273932876999 | (37.7910039825033, -122.39273932877) | |||
| 167512 | 167512 | 190336 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014755.210530001 | 2115992.9592 | 37.7909424715624 | -122.392822188693 | (37.7909424715624, -122.392822188693) | |||
| 169534 | 169534 | 190335 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014743.61218 | 2115981.63102 | 37.790910722793 | -122.392861525945 | (37.790910722793, -122.392861525945) | |||
| 186228 | 186228 | 190340 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 Howard St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014805.5019 | 2116039.63688 | 37.791073430855796 | -122.392651447929 | (37.7910734308558, -122.392651447929) | |||
| 184579 | 184579 | 131309 | Undocumented 2 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 101 Maple St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 3ft | 5996544.3680300005 | 2115871.17754 | 37.7895797810398 | -122.45582177545401 | (37.7895797810398, -122.455821775454) | |||
| 161265 | 161265 | 127534 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 101 O'Farrell St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6010622.18881 | 2114505.22793 | 37.7866270909228 | -122.40701743500601 | (37.7866270909228, -122.407017435006) | |||
| 54358 | 54358 | 219993 | Undocumented 2 | Acacia baileyana :: Bailey's Acacia 42 | 101 Prospect Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 13 | 6006993.27252 | 2098944.7494 | 37.7436979269164 | -122.418468865069 | (37.7436979269164, -122.418468865069) | ||||
| 156800 | 156800 | 234495 | Undocumented 2 | Pinus muricata :: Bishop Pine 302 | 101 Prospect Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 14 | 6006979.85845 | 2098918.36092 | 37.74362471490279 | -122.418513376991 | (37.7436247149028, -122.418513376991) | ||||
| 188680 | 188680 | 234494 | Undocumented 2 | Pinus muricata :: Bishop Pine 302 | 101 Prospect Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 23 | 6006984.21795 | 2098930.06522 | 37.7436570977129 | -122.41849913263799 | (37.7436570977129, -122.418499132638) | ||||
| 180105 | 180105 | 238990 | Undocumented 2 | Pyrus calleryana :: Ornamental Pear 9 | 1017 Guerrero St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6005766.99533 | 2102918.3127900003 | 37.7545393108464 | -122.422991404546 | (37.7545393108464, -122.422991404546) | |||
| 47236 | 47236 | 225176 | Undocumented 2 | Chamaerops humilis :: Mediterranean Fan Palm 99 | 1020 Alabama St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 6009156.40291 | 2103118.80305 | 37.7552804871291 | -122.411284056222 | (37.7552804871291, -122.411284056222) | |||
| 26132 | 26132 | 136381 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1023 Broadway | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 15 | Width 3ft | 6008695.6423 | 2118278.0740799997 | 37.7968784080765 | -122.413949834731 | (37.7968784080765, -122.413949834731) | |||
| 184430 | 184430 | 136380 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1023 Broadway | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6008680.39017 | 2118276.96424 | 37.7968745041214 | -122.414002532311 | (37.7968745041214, -122.414002532311) | |||
| 137373 | 137373 | 136004 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 1027 Broadway | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 3ft | 6008655.5558400005 | 2118272.73317 | 37.796861491822604 | -122.41408816572999 | (37.7968614918226, -122.41408816573) | |||
| 39973 | 39973 | 131171 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1028 Chestnut St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 4ft | 6006900.3516 | 2120517.59651 | 37.802926579956704 | -122.420321008927 | (37.8029265799567, -122.420321008927) | |||
| 62892 | 62892 | 131172 | Undocumented 2 | Maytenus boaria :: Mayten 22 | 1028 Chestnut St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6006879.14909 | 2120515.3465299997 | 37.8029192073136 | -122.42039422091999 | (37.8029192073136, -122.42039422092) | |||
| 60722 | 60722 | 190333 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 103 Howard St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014709.52276 | 2115946.6699599996 | 37.790812834303004 | -122.39297702767999 | (37.790812834303, -122.39297702768) | |||
| 66053 | 66053 | 190331 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 103 Howard St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014689.7306 | 2115924.90869 | 37.790751983476 | -122.393043984906 | (37.790751983476, -122.393043984906) | |||
| 70352 | 70352 | 190329 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 103 Howard St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014667.05629 | 2115904.1696599997 | 37.7906937793375 | -122.39312098574301 | (37.7906937793375, -122.393120985743) | |||
| 121089 | 121089 | 190328 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 103 Howard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014652.968859999 | 2115892.30233 | 37.7906604118109 | -122.393168897143 | (37.7906604118109, -122.393168897143) | |||
| 136809 | 136809 | 190334 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 103 Howard St | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014720.686319999 | 2115960.41525 | 37.7908511957851 | -122.392939364079 | (37.7908511957851, -122.392939364079) | |||
| 163098 | 163098 | 190330 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 103 Howard St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014677.9098 | 2115914.54896 | 37.7907228814138 | -122.39308415942499 | (37.7907228814138, -122.393084159425) | |||
| 175023 | 175023 | 190332 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 103 Howard St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6014699.62681 | 2115935.78915 | 37.790782408421 | -122.393010505845 | (37.790782408421, -122.393010505845) | |||
| 31725 | 31725 | 127856 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1032 Broadway | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 6008567.79894 | 2118317.2360099996 | 37.7969787562238 | -122.41439497666401 | (37.7969787562238, -122.414394976664) | |||
| 70696 | 70696 | 127857 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1032 Broadway | 7 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 4ft | 6008555.20047 | 2118315.13815 | 37.7969722882858 | -122.414438422015 | (37.7969722882858, -122.414438422015) | |||
| 152712 | 152712 | 175120 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 104 Burrows St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 3ft | 6011145.11517 | 2093506.8744599998 | 37.72899953149621 | -122.40373016652 | (37.7289995314962, -122.40373016652) | |||
| 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) | |||
| 47017 | 47017 | 129614 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1050 Van Ness Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6006528.24106 | 2114177.52587 | 37.7854973571526 | -122.42115824896999 | (37.7854973571526, -122.42115824897) | |||
| 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) | |||
| 32033 | 32033 | 235482 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 106 Chattanooga St | 6 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 4ft | 6004702.50004 | 2102988.75016 | 37.7546725903948 | -122.42667772741699 | (37.7546725903948, -122.426677727417) | |||
| 56215 | 56215 | 221688 | Undocumented 2 | Acer palmatum :: Japanese Maple 175 | 106 Chattanooga St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 6004702.30219 | 2102996.64608 | 37.7546942595564 | -122.426678973882 | (37.7546942595564, -122.426678973882) | |||
| 66131 | 66131 | 244861 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 106 Chattanooga St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6004701.8654 | 2103001.6771 | 37.7547080488647 | -122.42668084266501 | (37.7547080488647, -122.426680842665) | |||
| 148629 | 148629 | 222750 | Undocumented 2 | Cedrus atlantica :: Atlas Cedar 304 | 106 Chattanooga St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 4ft | 6004701.63015 | 2102998.9916 | 37.754700661810396 | -122.426681464997 | (37.7547006618104, -122.426681464997) | |||
| 174334 | 174334 | 241198 | Undocumented 2 | Trachycarpus fortunei :: Windmill Palm 31 | 106 Chattanooga St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004702.81282 | 2102995.20065 | 37.754690319613296 | -122.426677105059 | (37.7546903196133, -122.426677105059) | |||
| 155412 | 155412 | 223726 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 107 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 32 | Width 7ft | 6007259.15325 | 2098682.1985299997 | 37.742991985195104 | -122.41753090725 | (37.7429919851951, -122.41753090725) | |||
| 82513 | 82513 | 136720 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 1074 Vallejo St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004587.59181 | 2118109.43364 | 37.7961837897023 | -122.42815263445699 | (37.7961837897023, -122.428152634457) | |||
| 184259 | 184259 | 136719 | Undocumented 2 | Thuja occidentalis 'Emerald' :: Emerald Arborvitae 321 | 1074 Vallejo St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004612.94283 | 2118113.6441200003 | 37.796196784912404 | -122.42806521496401 | (37.7961967849124, -122.428065214964) | |||
| 74633 | 74633 | 224461 | Undocumented 2 | Ficus Spp. :: 253 | 1079 Hampshire St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 2ft | 6010270.40379 | 2102959.48183 | 37.7549054419377 | -122.40742025933099 | (37.7549054419377, -122.407420259331) | |||
| 99160 | 99160 | 224460 | Undocumented 2 | Ficus Spp. :: 253 | 1079 Hampshire St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 2ft | 6010269.27051 | 2102947.5416099997 | 37.754872593321295 | -122.407423336815 | (37.7548725933213, -122.407423336815) | |||
| 66371 | 66371 | 223725 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 109 Elsie St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 34 | Width 10ft | 6007250.83201 | 2098665.28415 | 37.742945073859794 | -122.417558481357 | (37.7429450738598, -122.417558481357) | |||
| 44046 | 44046 | 197976 | Undocumented 2 | Torreya californica :: California nutmeg 409 | 1098 Mississippi St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 5ft | 6014198.12012 | 2102094.83849 | 37.7527503731308 | -122.393776491693 | (37.7527503731308, -122.393776491693) | |||
| 48645 | 48645 | 196360 | Undocumented 2 | Prunus persica :: Peach 330 | 1098 Mississippi St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6014197.98434 | 2102073.23717 | 37.7526910529733 | -122.39377544938499 | (37.7526910529733, -122.393775449385) | |||
| 61274 | 61274 | 197334 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 1098 Mississippi St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 5ft | 6014199.99182 | 2102083.0983599997 | 37.7527182412529 | -122.39376919728501 | (37.7527182412529, -122.393769197285) | |||
| 25845 | 25845 | 237234 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 110 Carmel St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | Width 3ft | 5998175.72217 | 2105385.27781 | 37.7608816968555 | -122.449421648503 | (37.7608816968555, -122.449421648503) | |||
| 59665 | 59665 | 226580 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 110 Carmel St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 5998192.72104 | 2105385.2518599997 | 37.7608825979841 | -122.44936285530599 | (37.7608825979841, -122.449362855306) | |||
| 133870 | 133870 | 237233 | Undocumented 2 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 110 Carmel St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 3ft | 5998197.90052 | 2105385.6119999997 | 37.760883883112506 | -122.449344967798 | (37.7608838831125, -122.449344967798) | |||
| 168679 | 168679 | 226579 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 110 Carmel St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 5998203.55994 | 2105386.43051 | 37.7608864542601 | -122.44932545342199 | (37.7608864542601, -122.449325453422) | |||
| 131845 | 131845 | 218965 | Undocumented 2 | Fraxinus americana :: American Ash 23 | 110 Edgewood Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 18 | Width 2ft | 5996620.681480001 | 2106396.26972 | 37.7635685464754 | -122.4548728666 | (37.7635685464754, -122.4548728666) | |||
| 40547 | 40547 | 127858 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1108 Broadway | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 3ft | 6008285.2726300005 | 2118276.37484 | 37.796850686473704 | -122.41536969425199 | (37.7968506864737, -122.415369694252) | |||
| 62640 | 62640 | 127859 | Undocumented 2 | Ficus microcarpa nitida 'Green Gem' :: Indian Laurel Fig Tree 'Green Gem' 32 | 1108 Broadway | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 3ft | 6008269.594330001 | 2118274.93987 | 37.7968458652047 | -122.41542384336 | (37.7968458652047, -122.41542384336) | |||
| 185547 | 185547 | 176629 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 1111 Cayuga Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 1ft | 6000425.60449 | 2090663.4815 | 37.7205875707281 | -122.440584368684 | (37.7205875707281, -122.440584368684) | |||
| 153812 | 153812 | 199521 | Undocumented 2 | Yucca gloriosa :: Spanish Dagger 224 | 1112 Tennessee St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 58 | Width 6ft | 6015518.58105 | 2103812.19357 | 37.7575391569355 | -122.389329974622 | (37.7575391569355, -122.389329974622) | |||
| 186559 | 186559 | 197486 | Undocumented 2 | Schinus molle :: California Pepper 138 | 1112 Tennessee St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 19 | Width 6ft | 6015516.35006 | 2103817.5314599997 | 37.757553689956104 | -122.389338063096 | (37.7575536899561, -122.389338063096) | |||
| 187792 | 187792 | 210906 | Undocumented 2 | Phoenix canariensis :: Canary Island Date Palm 100 | 1113 Kirkham St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 5991529.16752 | 2105177.12145 | 37.7599277068135 | -122.47239375186301 | (37.7599277068135, -122.472393751863) | |||
| 125641 | 125641 | 113226 | Undocumented 2 | Magnolia grandiflora 'Little Gem' :: Little Gem Magnolia 88 | 1118 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6006956.0 | 2114756.0 | 37.787109810462 | -122.419719385886 | (37.787109810462, -122.419719385886) | ||||
| 186590 | 186590 | 142889 | Undocumented 2 | Magnolia grandiflora :: Southern Magnolia 21 | 1118 POLK ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 0ft | 6006903.047 | 2114753.8909 | 37.7871010363106 | -122.419902442274 | (37.7871010363106, -122.419902442274) | |||
| 174326 | 174326 | 226846 | Undocumented 2 | Juniperus chinensis :: Juniper 19 | 112 Hoffman Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 1ft | 6000578.445069999 | 2102408.38472 | 37.7528450258792 | -122.44089815384 | (37.7528450258792, -122.44089815384) | |||
| 72785 | 72785 | 136545 | Undocumented 2 | Syagrus romanzoffianum :: Queen Palm 142 | 1127 Polk St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6006847.68823 | 2114784.64257 | 37.78718235392171 | -122.42009615501301 | (37.7871823539217, -122.420096155013) | |||
| 98016 | 98016 | 93915 | Permitted Site 1 | Tree(s) :: 17 | 1131 Polk St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 04/26/2010 12:00:00 AM | Permit Number 53385 | 6006791.4 | 2114889.1 | 37.7874659967155 | -122.42029831720501 | (37.7874659967155, -122.420298317205) |
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");