Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo, PlantType, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 113280 | 113280 | 105686 | Property Tree 7 | Ficus microcarpa :: Chinese Banyan 94 | 635 08TH ST | 3 | Front Yard : Pot 30 | Tree 1 | Private 1 | 6 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||||
| 124771 | 124771 | 105685 | Property Tree 7 | Ficus microcarpa :: Chinese Banyan 94 | 635 08TH ST | 2 | Front Yard : Pot 30 | Tree 1 | Private 1 | 8 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||||
| 126368 | 126368 | 105684 | Property Tree 7 | Ficus microcarpa :: Chinese Banyan 94 | 635 08TH ST | 1 | Front Yard : Pot 30 | Tree 1 | Private 1 | 10 | 6011418.5 | 2109097.9 | 37.7718243537934 | -122.40388172759701 | (37.7718243537934, -122.403881727597) | ||||
| 85853 | 85853 | 114950 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1X WOODACRE DR | 2 | unknown : Yard 19 | Tree 1 | DPW 2 | 30x100 | 5991187.0 | 2095315.0 | 37.732829063550795 | -122.47285799850201 | (37.7328290635508, -122.472857998502) | ||||
| 111345 | 111345 | 114949 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1X WOODACRE DR | 1 | unknown : Yard 19 | Tree 1 | DPW 2 | 30 | 30x100 | 5991187.0 | 2095315.0 | 37.732829063550795 | -122.47285799850201 | (37.7328290635508, -122.472857998502) | |||
| 126465 | 126465 | 101951 | Property Tree 7 | Tree(s) :: 17 | 21 Lyell St | unknown : Yard 19 | Tree 1 | Private 1 | 6003106.0 | 2094969.0 | 37.7325618289587 | -122.43162632292 | (37.7325618289587, -122.43162632292) | ||||||
| 909 | 909 | 234895 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 3255x 24th St | 6 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 40 | Width 10ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 98218 | 98218 | 122480 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 596X Buckingham Way | 1 | Side Yard : Cutout 18 | Tree 1 | Private 1 | 3x3 | 5990152.0 | 2094375.0 | 37.7301880902761 | -122.476367577616 | (37.7301880902761, -122.476367577616) | ||||
| 3552 | 3552 | 253469 | Property Tree 7 | Eucalyptus nicholii :: Nichol's Willow-Leafed Peppermint 114 | 701 Stanyan St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5997178.0 | 2108423.0 | 37.7691653834469 | -122.45309160151399 | (37.7691653834469, -122.453091601514) | |||||
| 631 | 631 | 251294 | Property Tree 7 | :: 54 | 7126 Geary Blvd | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5984860.0 | 2112552.0 | 37.779788778901796 | -122.49600289252199 | (37.7797887789018, -122.496002892522) | ||||
| 903 | 903 | 225889 | Property Tree 7 | Fraxinus uhdei 'Tomlinson' :: Tomlinson Ash 121 | 3255x 24th St | 7 | Back Yard : Cutout 16 | Tree 1 | MTA 6 | 18 | Width 8ft | 6007298.0 | 2102020.0 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | |||
| 2764 | 2764 | 253207 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 89 Woodhaven Ct | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5996069.0 | 2103645.0 | 37.75598259914371 | -122.45658197288401 | (37.7559825991437, -122.456581972884) | ||||
| 78510 | 78510 | 114817 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 100 RACCOON DR | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 5998725.0 | 2104028.0 | 37.757186355085004 | -122.447424250084 | (37.757186355085, -122.447424250084) | |||||
| 85764 | 85764 | 115641 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 7 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 86412 | 86412 | 115638 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 4 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 7 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | |||
| 90360 | 90360 | 115646 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 12 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 95069 | 95069 | 115635 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 1 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 20 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | |||
| 96699 | 96699 | 115645 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 11 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 97160 | 97160 | 115639 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 5 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 6 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | |||
| 99755 | 99755 | 115644 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 10 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 102527 | 102527 | 115648 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 14 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 102675 | 102675 | 115649 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 15 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 105687 | 105687 | 122518 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 772X Panorama Dr | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x3 | 5996713.0 | 2102901.0 | 37.753976715350106 | -122.45430108189 | (37.7539767153501, -122.45430108189) | ||||
| 108009 | 108009 | 115652 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 18 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 108742 | 108742 | 110939 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 38 SAINT CHARLES AVE | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 30 | 3x3 | 5992046.0 | 2088201.0 | 37.7133454608488 | -122.46937060641001 | (37.7133454608488, -122.46937060641) | |||
| 111875 | 111875 | 115636 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 2 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 16 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | |||
| 113407 | 113407 | 115650 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 16 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 118558 | 118558 | 115640 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 6 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 122253 | 122253 | 115643 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 9 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 124724 | 124724 | 115642 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 8 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 125004 | 125004 | 115653 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 19 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 127152 | 127152 | 115647 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 13 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 139401 | 139401 | 115654 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 20 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 139921 | 139921 | 115637 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 3 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 14 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | |||
| 142076 | 142076 | 115655 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 21 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 144101 | 144101 | 115651 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 81x ELSIE ST | 17 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 6007403.0 | 2098902.0 | 37.7436036039275 | -122.41704909401301 | (37.7436036039275, -122.417049094013) | ||||
| 669 | 669 | 251343 | Property Tree 7 | Eucalyptus polyanthemos :: Silver Dollar Eucalyptus 39 | 934 Brannan St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6010724.0 | 2108745.0 | 37.7708165471861 | -122.40625919407302 | (37.7708165471861, -122.406259194073) | ||||
| 1273 | 1273 | 251481 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 32 Peralta Ave | 1 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 3x3 | 6010779.0 | 2100499.0 | 37.7481779538542 | -122.40548810426901 | (37.7481779538542, -122.405488104269) | ||||
| 1380 | 1380 | 251512 | Property Tree 7 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4116x 18th St | 1 | Back Yard : Yard 13 | Tree 1 | MTA 6 | 3x3 | 6002190.0 | 2105341.0 | 37.760988934022706 | -122.43553488468001 | (37.7609889340227, -122.43553488468) | ||||
| 1996 | 1996 | 252848 | Property Tree 7 | Pinus halepensis :: Allepo Pine 164 | 99 Reposa Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5998022.0 | 2098104.0 | 37.7408803073177 | -122.44942865965 | (37.7408803073177, -122.44942865965) | ||||
| 4447 | 4447 | 253626 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1671 Funston Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5992125.0 | 2104081.0 | 37.756952512450205 | -122.47025325330601 | (37.7569525124502, -122.470253253306) | ||||
| 5096 | 5096 | 253768 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 100 Raccoon Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5998692.0 | 2104165.0 | 37.7575606372552 | -122.44754823773899 | (37.7575606372552, -122.447548237739) | |||||
| 13321 | 13321 | 187670 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 230 Victoria St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5993274.0 | 2088748.0 | 37.7149182807441 | -122.465165952001 | (37.7149182807441, -122.465165952001) | ||||
| 22300 | 22300 | 248974 | Property Tree 7 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 716 Goettingen St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6010713.0 | 2091306.0 | 37.7229322393396 | -122.405069122237 | (37.7229322393396, -122.405069122237) | ||||
| 22826 | 22826 | 251117 | Property Tree 7 | Sequoiadendron giganteum :: Sierra Redwood 212 | 2024 Castro St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6002622.0 | 2099601.0 | 37.7452527853239 | -122.43363054854099 | (37.7452527853239, -122.433630548541) | |||||
| 79011 | 79011 | 108637 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 15 TUCKER AVE | Back Yard : Yard 13 | Tree 1 | Private 1 | 6011049.2 | 2088423.2 | 37.715035447895396 | -122.403704200211 | (37.7150354478954, -122.403704200211) | ||||||
| 79534 | 79534 | 121404 | Property Tree 7 | Sequoia sempervirens :: Coast Redwood 116 | 1900 08th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 10x10 | 5993817.0 | 2102486.0 | 37.7526707300666 | -122.464285931649 | (37.7526707300666, -122.464285931649) | |||
| 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) | ||||||
| 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) | ||||||
| 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) | |||||
| 82794 | 82794 | 110929 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 445 BEACON ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6002243.0 | 2098437.0 | 37.7420352018096 | -122.434857838675 | (37.7420352018096, -122.434857838675) | |||||
| 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) | |||||
| 86843 | 86843 | 109377 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 88993 | 88993 | 121199 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 72 Fountain St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6000322.0 | 2101283.0 | 37.7497403826665 | -122.441704227556 | (37.7497403826665, -122.441704227556) | |||||
| 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) | ||||||
| 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) | |||||
| 92228 | 92228 | 122453 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 217 San Marcos Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10x10 | 5993325.07095 | 2100296.14299 | 37.7466295758311 | -122.465827998209 | (37.7466295758311, -122.465827998209) | ||||
| 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) | ||||||
| 96460 | 96460 | 109375 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 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) | ||||||
| 98644 | 98644 | 106968 | Property Tree 7 | :: 54 | 351 26th Ave | Back Yard : Yard 13 | Tree 1 | Private 1 | 5987720.26121 | 2113604.44601 | 37.7828456076198 | -122.48618540122601 | (37.7828456076198, -122.486185401226) | ||||||
| 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) | ||||||
| 99953 | 99953 | 117254 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 2067 33RD AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5985987.0 | 2101171.0 | 37.7486056682842 | -122.49126630479601 | (37.7486056682842, -122.491266304796) | ||||
| 100855 | 100855 | 114731 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 934 BRANNAN ST | Back Yard : Yard 13 | Tree 1 | Private 1 | Dept of Real Estate 9 | 10x10 | 6010724.0 | 2108745.0 | 37.7708165471861 | -122.40625919407302 | (37.7708165471861, -122.406259194073) | ||||
| 101483 | 101483 | 113482 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 2839 Pierce St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001345.0 | 2118077.0 | 37.7959107386074 | -122.43937030854799 | (37.7959107386074, -122.439370308548) | ||||||
| 101635 | 101635 | 121104 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 477 Myra Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997298.0 | 2097021.0 | 37.7378652095891 | -122.45185385938998 | (37.7378652095891, -122.45185385939) | ||||
| 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) | ||||||
| 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) | ||||||
| 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) | ||||
| 105590 | 105590 | 121144 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 400 Franconia St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | 3x3 | 6010016.0 | 2098808.0 | 37.743492145498294 | -122.40800731166901 | (37.7434921454983, -122.408007311669) | |||
| 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) | |||||
| 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) | ||||||
| 110212 | 110212 | 110320 | Property Tree 7 | :: 54 | 9 Imperial Aly | Back Yard : Yard 13 | Landscaping 2 | Private 1 | 6005040.9 | 2119421.8 | 37.7998128500526 | -122.426677597274 | (37.7998128500526, -122.426677597274) | ||||||
| 110958 | 110958 | 108680 | Property Tree 7 | Juniperus chinensis :: Juniper 19 | 240 SANTA ANA AVE | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5992606.9 | 2095181.7 | 37.73254515275271 | -122.46793939448999 | (37.7325451527527, -122.46793939449) | |||||
| 112237 | 112237 | 109378 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 112387 | 112387 | 109194 | Property Tree 7 | Quercus agrifolia :: Coast Live Oak 180 | 4705 03rd St | Back Yard : Yard 13 | Tree 1 | Arts Commission 19 | 45 | 6015121.6 | 2095617.0 | 37.7350148477359 | -122.39013039721901 | (37.7350148477359, -122.390130397219) | |||||
| 112498 | 112498 | 106458 | Property Tree 7 | Tree(s) :: 17 | 71 HANCOCK ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 6003861.6 | 2105050.0 | 37.7602847161222 | -122.429732794413 | (37.7602847161222, -122.429732794413) | ||||||
| 113071 | 113071 | 108574 | Property Tree 7 | Tree(s) :: 17 | 1891 15th St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7x8 | 6004884.86016 | 2107160.4412599998 | 37.7661373754728 | -122.426344078904 | (37.7661373754728, -122.426344078904) | ||||
| 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) | |||||
| 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) | |||||
| 114948 | 114948 | 113440 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 BEACON ST | Back Yard : Yard 13 | Tree 1 | Private 1 | 32 | 3x3 | 6003193.0 | 2097540.0 | 37.739626138558705 | -122.43150902083299 | (37.7396261385587, -122.431509020833) | ||||
| 115179 | 115179 | 106275 | Property Tree 7 | Eucalyptus globulus :: Blue Gum 103 | 42 Stanford Heights Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997882.5 | 2095834.4 | 37.7346405503947 | -122.449747480555 | (37.7346405503947, -122.449747480555) | |||||
| 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) | |||||
| 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) | ||||||
| 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) | ||||
| 118325 | 118325 | 109374 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 119332 | 119332 | 120526 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1439 47th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 3x3 | 5981489.0 | 2105275.0 | 37.759610238830206 | -122.50712446853998 | (37.7596102388302, -122.50712446854) | |||
| 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) | ||||||
| 119975 | 119975 | 112668 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 129 Henry St | Back Yard : Yard 13 | Tree 1 | Private 1 | 6002668.0 | 2107340.8 | 37.766507036069605 | -122.434024647923 | (37.7665070360696, -122.434024647923) | ||||||
| 120579 | 120579 | 114365 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 2546 28th Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | 5987735.7 | 2097954.4 | 37.739875761389605 | -122.48498344199601 | (37.7398757613896, -122.484983441996) | ||||
| 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) | |||||
| 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) | ||||||
| 124085 | 124085 | 116154 | Property Tree 7 | Pinus Spp :: Pine Spp 105 | 324 POPE ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 6000502.0 | 2087202.0 | 37.711087470467795 | -122.440072212787 | (37.7110874704678, -122.440072212787) | ||||
| 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) | |||||
| 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) | ||||||
| 127758 | 127758 | 109376 | Property Tree 7 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 111 BAY ST | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.40899671325899 | (37.8058617340589, -122.408996713259) | |||||
| 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) | ||||||
| 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) | |||||
| 129004 | 129004 | 108871 | Property Tree 7 | Tree(s) :: 17 | 99x OAKWOOD ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6005305.0 | 2104962.0 | 37.760124716943295 | -122.424734485609 | (37.7601247169433, -122.424734485609) | |||||
| 129259 | 129259 | 122558 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1760 Diamond St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 20 | 3x3 | 6001927.0 | 2098732.0 | 37.7428272563398 | -122.43597156823799 | (37.7428272563398, -122.435971568238) |
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");