Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, PlantType, qCaretaker, PlotSize
| Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101276 | 101276 | 62912 | Significant Tree 6 | Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 502 | 500 Cortland Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50224 | 6007523.90359428 | 2097218.90762974 | 37.7389890062486 | -122.416511839888 | (37.7389890062486, -122.416511839888) | ||
| 79839 | 79839 | 69895 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 51x PRENTISS ST | 2 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 03/29/2003 12:00:00 AM | 12 | 6008906.8 | 2098323.8 | 37.742100473688396 | -122.41180845469201 | (37.7421004736884, -122.411808454692) | |||
| 88950 | 88950 | 86946 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 495 Pacheco St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11/20/2007 12:00:00 AM | 3x3 | Permit Number 51051 | 5993544.7 | 2101797.8 | 37.750765410178 | -122.465177603148 | (37.750765410178, -122.465177603148) | ||
| 125077 | 125077 | 87149 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 4 Bellair Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010093.0 | 2120950.0 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | |||||
| 86911 | 86911 | 87150 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 4 Bellair Pl | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 50135 | 6010093.0 | 2120950.0 | 37.8042932388788 | -122.409303278994 | (37.8042932388788, -122.409303278994) | ||||
| 91632 | 91632 | 87216 | Significant Tree 6 | Robinia x ambigua 'Idahoensis' :: Idaho Pink Locust 502 | 500 Cortland Ave | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 02/08/2008 12:00:00 AM | 3x3 | Permit Number 50224 | 6007640.7 | 2097187.4 | 37.7389090609704 | -122.416105779709 | (37.7389090609704, -122.416105779709) | ||
| 152183 | 152183 | 87299 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 1 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 4 | Permit Number 50312 | 6011851.38946 | 2100896.5951099996 | 37.7493295679091 | -122.401807737936 | (37.7493295679091, -122.401807737936) | |||
| 28143 | 28143 | 87300 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 2 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 6 | Permit Number 50312 | 6011877.987480001 | 2100898.0514700003 | 37.749335051069004 | -122.401715863223 | (37.749335051069, -122.401715863223) | |||
| 49336 | 49336 | 87301 | DPW Maintained 3 | Ginkgo biloba :: Maidenhair Tree 44 | 2323 Cesar Chavez St | 3 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 5 | Permit Number 50312 | 6011915.6161 | 2100899.61614 | 37.7493414470685 | -122.401585851825 | (37.7493414470685, -122.401585851825) | |||
| 99282 | 99282 | 87387 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 201 Topeka Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | Permit Number 50366 | 6012955.9 | 2095077.8 | 37.7334139596128 | -122.39758023766399 | (37.7334139596128, -122.397580237664) | ||||
| 96761 | 96761 | 87388 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 201 Topeka Ave | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | Permit Number 50366 | 6012955.9 | 2095077.8 | 37.7334139596128 | -122.39758023766399 | (37.7334139596128, -122.397580237664) | |||
| 110484 | 110484 | 87389 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 201 Topeka Ave | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 04/24/2008 12:00:00 AM | Permit Number 50366 | 6012955.9 | 2095077.8 | 37.7334139596128 | -122.39758023766399 | (37.7334139596128, -122.397580237664) | |||
| 113154 | 113154 | 87562 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 140175 | 140175 | 87563 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 91344 | 91344 | 87564 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 114899 | 114899 | 88028 | Permitted Site 1 | Tree(s) :: 17 | 495 Pacheco St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 06/23/2008 12:00:00 AM | Permit Number 51051 | 5993544.7 | 2101797.8 | 37.750765410178 | -122.465177603148 | (37.750765410178, -122.465177603148) | |||
| 88491 | 88491 | 92474 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 85249 | 85249 | 92475 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 85668 | 85668 | 92476 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 104140 | 104140 | 92480 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 128270 | 128270 | 92481 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 12 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 84714 | 84714 | 92484 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 15 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 145573 | 145573 | 92485 | Permitted Site 1 | Tree(s) :: 17 | 155 Greenwich St | 11 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/30/2009 12:00:00 AM | 3x3 | Permit Number 52856 | 6012015.0 | 2120477.0 | 37.803101990704896 | -122.402618721555 | (37.8031019907049, -122.402618721555) | ||
| 119166 | 119166 | 92897 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
| 143929 | 143929 | 92898 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
| 105251 | 105251 | 92899 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
| 128646 | 128646 | 92900 | Significant Tree 6 | Eucalyptus globulus :: Blue Gum 103 | 208 States St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 08/13/2008 12:00:00 AM | 6000833.0 | 2106506.0 | 37.7641105715625 | -122.440311694354 | (37.7641105715625, -122.440311694354) | ||||
| 91679 | 91679 | 94535 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 265 Dorland St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003831.0 | 2105693.0 | 37.7620485075454 | -122.42988449123301 | (37.7620485075454, -122.429884491233) | |||||
| 123752 | 123752 | 95982 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Vasquez Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5995122.4 | 2099706.3 | 37.7451135296363 | -122.459570350972 | (37.7451135296363, -122.459570350972) | |||||
| 143568 | 143568 | 96273 | Significant Tree 6 | Sequoia sempervirens :: Coast Redwood 116 | 55@ Alemany Trumbull St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | |||||
| 60806 | 60806 | 96274 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 55@ Alemany Trumbull St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6004001.3006 | 2094332.0064299998 | 37.7308634942567 | -122.428485665086 | (37.7308634942567, -122.428485665086) | ||||
| 171955 | 171955 | 96275 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 55@ Alemany Trumbull St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 6003967.5577300005 | 2094330.4049099998 | 37.73085718729 | -122.428602205549 | (37.73085718729, -122.428602205549) | ||||
| 168767 | 168767 | 96276 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 55@ Alemany Trumbull St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6003946.78636 | 2094329.77315 | 37.730854277083104 | -122.428673970523 | (37.7308542770831, -122.428673970523) | ||||
| 136002 | 136002 | 96277 | Significant Tree 6 | Prunus serrulata :: Ornamental Cherry 35 | 55@ Alemany Trumbull St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6003933.28624 | 2094328.99121 | 37.7308513660015 | -122.428720586902 | (37.7308513660015, -122.428720586902) | ||||
| 154027 | 154027 | 96278 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 55@ Alemany Trumbull St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6003898.31997 | 2094328.2986700002 | 37.7308474854131 | -122.42884142159599 | (37.7308474854131, -122.428841421596) | ||||
| 100392 | 100392 | 96279 | Significant Tree 6 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 55@ Alemany Trumbull St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6004020.1 | 2094407.4 | 37.7310715719205 | -122.428426044208 | (37.7310715719205, -122.428426044208) | |||||
| 141687 | 141687 | 96779 | Significant Tree 6 | Tree(s) :: 17 | 555 Melrose Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/18/2011 12:00:00 AM | Permit Number 767966 | 5996882.6 | 2095364.1 | 37.7332919614683 | -122.45317051411999 | (37.7332919614683, -122.45317051412) | |||
| 120804 | 120804 | 96938 | Property Tree 7 | Tree(s) :: 17 | 1306 Cole St | Back Yard : Yard 13 | Tree 1 | Private 1 | Backyard tree on private property | 5998246.0 | 2105961.0 | 37.7624665052811 | -122.449220068104 | (37.7624665052811, -122.449220068104) | |||||
| 129485 | 129485 | 97033 | Property Tree 7 | Afrocarpus gracilior :: Fern Pine 70 | 61 Vicksburg St | Back Yard : Yard 13 | Tree 1 | Private 1 | Possible significant tree; Nellie RoW; rear yard | 6004120.0 | 2102703.0 | 37.753855038047 | -122.428671801406 | (37.753855038047, -122.428671801406) | |||||
| 114652 | 114652 | 97162 | Property Tree 7 | Malus :: Crab Apple 235 | 478 10th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | Tree in backyard on private property; not significant. | 5992861.5 | 2112216.7 | 37.7793335349967 | -122.468298031686 | (37.7793335349967, -122.468298031686) | |||||
| 91108 | 91108 | 97177 | Property Tree 7 | Tree(s) :: 17 | 257 Roosevelt Way | Back Yard : Yard 13 | Tree 1 | Private 1 | Monterey cypress tree in backyard on private property; not a Significant tree | 6000848.1 | 2107127.9 | 37.765819014897296 | -122.44030407045099 | (37.7658190148973, -122.440304070451) | |||||
| 122333 | 122333 | 97685 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 84 Coventry Ct | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997084.0 | 2096485.0 | 37.7363812239889 | -122.452555087132 | (37.7363812239889, -122.452555087132) | ||||||
| 142266 | 142266 | 98139 | Property Tree 7 | Robinia x ambigua 'Purple Robe' :: Purple Robe Locust 124 | 556 Laidley St | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6003085.0 | 2096041.0 | 37.7355041065287 | -122.431775438062 | (37.7355041065287, -122.431775438062) | |||||
| 128311 | 128311 | 98265 | Property Tree 7 | Pinus pinea :: Italian Stone Pine 143 | 755 O'Farrell St | Back Yard : Yard 13 | Tree 1 | Private 1 | Backyard tree; not significant | 6007700.0 | 2113968.3 | 37.784988860902295 | -122.417089467607 | (37.7849888609023, -122.417089467607) | |||||
| 103600 | 103600 | 98436 | Property Tree 7 | Tree(s) :: 17 | 238 Glenview Dr | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999035.0 | 2100736.0 | 37.7481650400364 | -122.446115368035 | (37.7481650400364, -122.446115368035) | ||||||
| 82720 | 82720 | 98465 | Property Tree 7 | Tree(s) :: 17 | 190 Portola Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999550.3 | 2100620.3 | 37.7478767693988 | -122.444325170302 | (37.7478767693988, -122.444325170302) | ||||||
| 115357 | 115357 | 98501 | Property Tree 7 | Tree(s) :: 17 | 232 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998998.0 | 2100740.0 | 37.748173910048706 | -122.446243600021 | (37.7481739100487, -122.446243600021) | ||||||
| 80672 | 80672 | 98502 | Property Tree 7 | Tree(s) :: 17 | 244 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999066.0 | 2100737.0 | 37.7481695560511 | -122.44600824337601 | (37.7481695560511, -122.446008243376) | ||||||
| 128066 | 128066 | 98503 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 208 Glenview Dr | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998871.0 | 2100779.0 | 37.74827374071911 | -122.44668556582701 | (37.7482737407191, -122.446685565827) | ||||||
| 81929 | 81929 | 98694 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 191@Clarendon Forest Knolls Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.754391095173794 | -122.455633951336 | (37.7543910951738, -122.455633951336) | |||
| 140306 | 140306 | 98695 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 191@Clarendon Forest Knolls Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.754391095173794 | -122.455633951336 | (37.7543910951738, -122.455633951336) | |||
| 144229 | 144229 | 98696 | Significant Tree 6 | Aesculus californica :: California Buckeye 338 | 191@Clarendon Forest Knolls Dr | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 05/01/2012 12:00:00 AM | Permit Number 768674 | 5996330.9 | 2103059.9 | 37.754391095173794 | -122.455633951336 | (37.7543910951738, -122.455633951336) | |||
| 107492 | 107492 | 98715 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 26 Vernon St | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992459.0 | 2088068.0 | 37.713004133171 | -122.46793347935301 | (37.713004133171, -122.467933479353) | ||||||
| 145716 | 145716 | 98878 | Property Tree 7 | Tree(s) :: 17 | 11 Panorama Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998029.0 | 2100213.0 | 37.7466715093679 | -122.449556386849 | (37.7466715093679, -122.449556386849) | ||||||
| 99802 | 99802 | 98890 | Property Tree 7 | Tree(s) :: 17 | 256 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5999134.0 | 2100748.0 | 37.748203642185395 | -122.44577389345 | (37.7482036421854, -122.44577389345) | ||||||
| 98291 | 98291 | 98892 | Property Tree 7 | Tree(s) :: 17 | 220 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998935.0 | 2100753.0 | 37.7482060067302 | -122.44646238623999 | (37.7482060067302, -122.44646238624) | ||||||
| 94734 | 94734 | 98893 | Property Tree 7 | Tree(s) :: 17 | 216 Glenview Dr | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 5998910.0 | 2100761.0 | 37.7482265448319 | -122.44654941060699 | (37.7482265448319, -122.446549410607) | ||||||
| 102307 | 102307 | 99256 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 1466 York St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010099.0 | 2100741.0 | 37.7488043872035 | -122.407856595429 | (37.7488043872035, -122.407856595429) | ||||||
| 124250 | 124250 | 99374 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 21 Panorama Dr | Back Yard : Yard 13 | Tree 1 | Private 1 | 24 | 5998009.0 | 2100230.0 | 37.7467170430405 | -122.449626769288 | (37.7467170430405, -122.449626769288) | |||||
| 92869 | 92869 | 99821 | Undocumented 2 | Salix spp :: Willow 218 | 1230 Twin Peaks Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Tree closest to sidewalk and retaining wall | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 125346 | 125346 | 100148 | Property Tree 7 | Tree(s) :: 17 | 209 Vicksburg St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6004141.0 | 2102142.0 | 37.7523158521071 | -122.428559192815 | (37.7523158521071, -122.428559192815) | ||||||
| 122667 | 122667 | 100169 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 180X Manchester St | Back Yard : Yard 13 | Tree 1 | DPW 2 | Adjacent to rear of property - DPW parcel | 6008242.0 | 2099158.0 | 37.7443536844995 | -122.414166136282 | (37.7443536844995, -122.414166136282) | |||||
| 115312 | 115312 | 100244 | Property Tree 7 | Persea americana :: Avocado 113 | 71 Sanchez St | Back Yard : Yard 13 | Tree 1 | Private 1 | Interior courtyard | 6003507.0 | 2107903.0 | 37.7680982797144 | -122.431162830878 | (37.7680982797144, -122.431162830878) | |||||
| 119700 | 119700 | 100472 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 70 Stanford Heights Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997872.4 | 2096006.9 | 37.735113616296 | -122.44979482672899 | (37.735113616296, -122.449794826729) | ||||||
| 115663 | 115663 | 100770 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 108 | 450 Hayes St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||||
| 87905 | 87905 | 100771 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 108 | 450 Hayes St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||||
| 101515 | 101515 | 100772 | Significant Tree 6 | Pittosporum crassifolium :: Karo Tree 108 | 450 Hayes St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 768934 | 6005678.7 | 2111113.4 | 37.7770360905223 | -122.423879452899 | (37.7770360905223, -122.423879452899) | ||||
| 101996 | 101996 | 101236 | Significant Tree 6 | Tree(s) :: 17 | 895X Church St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10/05/2012 12:00:00 AM | 13 | Permit Number 769299 | 6004383.5 | 2103691.7 | 37.7565846850157 | -122.42783100085899 | (37.7565846850157, -122.427831000859) | ||
| 103296 | 103296 | 101469 | Undocumented 2 | Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 58 | 1230 Twin Peaks Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||||
| 95481 | 95481 | 101470 | Undocumented 2 | Salix spp :: Willow 218 | 1230 Twin Peaks Blvd | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||||
| 141303 | 141303 | 101748 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 700X Panorama Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997177.2 | 2102739.1 | 37.7535587877907 | -122.452684092588 | (37.7535587877907, -122.452684092588) | |||||
| 145060 | 145060 | 102056 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 332 19th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5990007.7 | 2113121.3 | 37.781652074321705 | -122.47823656971501 | (37.7816520743217, -122.478236569715) | |||||
| 122672 | 122672 | 102060 | Private 5 | Cupressus macrocarpa :: Monterey Cypress 47 | 115 Kensington Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5994908.3 | 2098325.8 | 37.741310707397396 | -122.460210667073 | (37.7413107073974, -122.460210667073) | |||||
| 89166 | 89166 | 102275 | Property Tree 7 | Tree(s) :: 17 | 267 Topaz Way | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6001225.6 | 2097744.2 | 37.740075118911705 | -122.438326054857 | (37.7400751189117, -122.438326054857) | ||||||
| 97106 | 97106 | 102276 | Private 5 | Tree(s) :: 17 | 279 Topaz Way | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6001205.6 | 2097796.6 | 37.7402178594385 | -122.43839895973301 | (37.7402178594385, -122.438398959733) | ||||||
| 141038 | 141038 | 102381 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 258 Molimo Dr | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997615.0 | 2096604.0 | 37.7367383790998 | -122.450727783905 | (37.7367383790998, -122.450727783905) | ||||||
| 113649 | 113649 | 102469 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1021 Kirkham St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5991773.0 | 2105198.0 | 37.7599991432047 | -122.471551983129 | (37.7599991432047, -122.471551983129) | |||||
| 82732 | 82732 | 102470 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1021 Kirkham St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5991773.0 | 2105198.0 | 37.7599991432047 | -122.471551983129 | (37.7599991432047, -122.471551983129) | |||||
| 144179 | 144179 | 102639 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 251 Dorado Ter | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5994312.1 | 2092840.7 | 37.726215661035106 | -122.461874461465 | (37.7262156610351, -122.461874461465) | |||||
| 140844 | 140844 | 102706 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1342 Funston Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992135.4 | 2106294.8 | 37.7630316255695 | -122.470378504645 | (37.7630316255695, -122.470378504645) | |||||
| 142682 | 142682 | 102752 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 2452 Green St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001313.0 | 2117994.0 | 37.7956810212331 | -122.43947508164 | (37.7956810212331, -122.43947508164) | ||||||
| 144713 | 144713 | 103084 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 30X Zircon Pl | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6002309.6 | 2098789.5 | 37.7430068656447 | -122.43465275743601 | (37.7430068656447, -122.434652757436) | |||||
| 88847 | 88847 | 103457 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Bosworth St | 3 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 26 | Located on DPW property next to 84 Lippard Ave | 6001796.5 | 2095573.7 | 37.7341478843848 | -122.436196831648 | (37.7341478843848, -122.436196831648) | |||
| 140030 | 140030 | 103504 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 148 Huntington Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5984515.0 | 2095210.0 | 37.732152252278794 | -122.49591670504999 | (37.7321522522788, -122.49591670505) | |||||
| 84088 | 84088 | 103516 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 980 Green St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6008298.0 | 2118971.0 | 37.7987586699451 | -122.415374854445 | (37.7987586699451, -122.415374854445) | |||||
| 110289 | 110289 | 103566 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 51X Prentiss St | 1 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 12 | DPW property; below Bernal Heights Blvd near this address | 6008906.8 | 2098323.8 | 37.742100473688396 | -122.41180845469201 | (37.7421004736884, -122.411808454692) | |||
| 141787 | 141787 | 103673 | Property Tree 7 | :: 54 | 64 Henry St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003097.0 | 2107420.0 | 37.7667488371496 | -122.432546472662 | (37.7667488371496, -122.432546472662) | ||||||
| 117738 | 117738 | 104008 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 357 Collingwood St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | 6002124.0 | 2103789.0 | 37.7567237682266 | -122.435652112093 | (37.7567237682266, -122.435652112093) | ||||
| 141746 | 141746 | 104027 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 520X Oak Park Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 07/25/2013 12:00:00 AM | Permit Number 770238 | 5995008.5 | 2103700.7 | 37.756074592877496 | -122.46025354267599 | (37.7560745928775, -122.460253542676) | |||
| 53610 | 53610 | 104278 | Significant Tree 6 | Acacia spp :: Acacia Spp 176 | 2 Allston Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5994445.1 | 2098202.2 | 37.7409446783355 | -122.461803277974 | (37.7409446783355, -122.461803277974) | |||||
| 101621 | 101621 | 104406 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 290 Stonecrest Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 36 | Permit Number 770927 | 5990725.0 | 2092655.0 | 37.7254986161427 | -122.474261202586 | (37.7254986161427, -122.474261202586) | |||
| 85994 | 85994 | 104510 | Private 5 | Sequoia sempervirens :: Coast Redwood 116 | 254 ALLISON ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 40 | 6000052.0 | 2087408.0 | 37.7116274717654 | -122.441642291463 | (37.7116274717654, -122.441642291463) | ||||
| 101345 | 101345 | 104689 | Private 5 | Pinus radiata :: Monterey Pine 3 | 657 PALMETTO AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | 5991786.0 | 2087190.1 | 37.7105547448876 | -122.470195680575 | (37.7105547448876, -122.470195680575) | ||||
| 105403 | 105403 | 105236 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 235X STATES ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 30 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | ||||
| 118543 | 118543 | 105327 | Significant Tree 6 | Tree(s) :: 17 | 2051 03rd St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 771015 | 6015779.9 | 2106081.5 | 37.7637846705736 | -122.388584622631 | (37.7637846705736, -122.388584622631) | ||||
| 19360 | 19360 | 105328 | Significant Tree 6 | Tree(s) :: 17 | 2051 03rd St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 771015 | 6015779.9 | 2106081.5 | 37.7637846705736 | -122.388584622631 | (37.7637846705736, -122.388584622631) | ||||
| 122239 | 122239 | 105434 | Significant Tree 6 | Eriobotrya deflexa :: Bronze Loquat 49 | 4355 ANZA ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | 5985110.8 | 2111730.2 | 37.7775470387472 | -122.495074662501 | (37.7775470387472, -122.495074662501) | ||||
| 126137 | 126137 | 105444 | Landmark tree 9 | Quercus agrifolia :: Coast Live Oak 180 | 20-28 ROSEMONT PL | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6005075.5 | 2108088.5 | 37.768696376708895 | -122.425750755404 | (37.7686963767089, -122.425750755404) | |||||
| 143856 | 143856 | 106172 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 46 | 150 CONRAD ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | 6001768.8 | 2096480.0 | 37.7366348009068 | -122.43635744032801 | (37.7366348009068, -122.436357440328) | ||||
| 105598 | 105598 | 106227 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 38 Stanford Heights Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997884.0 | 2095808.5 | 37.7345695210024 | -122.44974042873999 | (37.7345695210024, -122.44974042874) |
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");