Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▼ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3 | 3 | 119263 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 495X Lakeshore Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 10x30 | |||||||||
| 78 | 78 | 251199 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 900X 14th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3X3 | 6002515.0 | 2107976.0 | 37.768242455454995 | -122.43459927073098 | (37.768242455455, -122.434599270731) | ||||
| 93 | 93 | 251198 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 900X 14th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002515.0 | 2107976.0 | 37.768242455454995 | -122.43459927073098 | (37.768242455455, -122.434599270731) | |||||
| 162 | 162 | 251231 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 164 Serrano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989598.0 | 2090848.0 | 37.7204716934452 | -122.478025052476 | (37.7204716934452, -122.478025052476) | ||||
| 818 | 818 | 251389 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 202x Mangels Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999774.0 | 2095231.0 | 37.7330917931436 | -122.44316462438499 | (37.7330917931436, -122.443164624385) | ||||
| 934 | 934 | 251409 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 95x Andover St | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6007642.0 | 2098274.0 | 37.741892697320296 | -122.41617822056101 | (37.7418926973203, -122.416178220561) | ||||
| 1027 | 1027 | 251426 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 5020 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999455.0 | 2100046.0 | 37.7462944425817 | -122.44461344107401 | (37.7462944425817, -122.444613441074) | |||||
| 1034 | 1034 | 251427 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 5028 Diamond Heights Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x3 | 5999606.0 | 2100130.0 | 37.7465337016449 | -122.44409733772801 | (37.7465337016449, -122.444097337728) | ||||
| 1272 | 1272 | 251489 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 31 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 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) | ||||
| 1282 | 1282 | 251482 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1283 | 1283 | 251493 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 35 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1286 | 1286 | 251492 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 34 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1288 | 1288 | 251487 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 29 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1290 | 1290 | 251486 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 28 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1295 | 1295 | 251491 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 33 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1298 | 1298 | 251490 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 32 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1299 | 1299 | 251494 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 36 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1310 | 1310 | 251480 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 51 Peralta Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6010641.0 | 2100362.0 | 37.747794064611604 | -122.40595565659201 | (37.7477940646116, -122.405955656592) | ||||
| 1316 | 1316 | 251488 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 30 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1322 | 1322 | 251483 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 8 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1332 | 1332 | 251484 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 7 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1338 | 1338 | 251485 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 900 Bosworth St | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6001649.0 | 2095572.0 | 37.734134835145895 | -122.436706663072 | (37.7341348351459, -122.436706663072) | |||||
| 1347 | 1347 | 251504 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 620x Noriega St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5992030.0 | 2103590.0 | 37.7555988620986 | -122.470546036282 | (37.7555988620986, -122.470546036282) | ||||
| 1384 | 1384 | 251515 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99x Mountview Ct | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997620.0 | 2100449.0 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | ||||
| 1409 | 1409 | 251514 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99x Mountview Ct | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997620.0 | 2100449.0 | 37.7472961010623 | -122.450987675073 | (37.7472961010623, -122.450987675073) | ||||
| 1547 | 1547 | 251582 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 691x Ulloa St | 1 | Back Yard : Cutout 16 | Tree 1 | DPW 2 | 3x3 | 5994175.0 | 2098101.0 | 37.7406512558576 | -122.462729837498 | (37.7406512558576, -122.462729837498) | ||||
| 1598 | 1598 | 251612 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 60R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999394.0 | 2100048.0 | 37.7462964530913 | -122.444824514752 | (37.7462964530913, -122.444824514752) | |||||
| 1603 | 1603 | 251636 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 22R Amethyst Way | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999148.0 | 2100052.0 | 37.74629339412971 | -122.44567543770901 | (37.7462933941297, -122.445675437709) | |||||
| 1615 | 1615 | 251604 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 48R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999482.0 | 2100041.0 | 37.7462822544405 | -122.444519719345 | (37.7462822544405, -122.444519719345) | |||||
| 1616 | 1616 | 251607 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 52R Amber Dr | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999455.0 | 2100046.0 | 37.7462944425817 | -122.44461344107401 | (37.7462944425817, -122.444613441074) | |||||
| 1620 | 1620 | 251543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard 17 | Tree 1 | Private 1 | |||||||||||
| 1648 | 1648 | 251606 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 52R Amber Dr | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5999455.0 | 2100046.0 | 37.7462944425817 | -122.44461344107401 | (37.7462944425817, -122.444613441074) | |||||
| 1708 | 1708 | 251660 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1050 North Point St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 1710 | 1710 | 251657 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1050 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 2399 | 2399 | 253072 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1350 46th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5x10 | Permit Number 780489 | 5981849.666569999 | 2105897.22193 | 37.761339917853896 | -122.50592325662 | (37.7613399178539, -122.50592325662) | |||
| 2502 | 2502 | 253119 | Private 5 | Pinus radiata :: Monterey Pine 3 | 185 Belgrave Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | Permit Number 780239 | 5997636.85301 | 2104869.74588 | 37.759435335978296 | -122.45124816933 | (37.7594353359783, -122.45124816933) | ||||
| 2503 | 2503 | 253120 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 815 Buena Vista Ave West | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x100 | 6000071.60031 | 2108311.04493 | 37.769023393565604 | -122.44307478834801 | (37.7690233935656, -122.443074788348) | ||||
| 2859 | 2859 | 253251 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99X Lopez Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 2869 | 2869 | 253250 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99X Lopez Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 2874 | 2874 | 253252 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 99X Lopez Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 3034 | 3034 | 253070 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 132 Sagamore St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 0ft | Permit Number 780451 | 5995539.3842400005 | 2087458.9579900003 | 37.7115092483173 | -122.45724268539699 | (37.7115092483173, -122.457242685397) | |||
| 3138 | 3138 | 253254 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 270 Castenada Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 3537 | 3537 | 102838 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 4553 | 4553 | 253637 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 701 Noe St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | Width 3ft | 6003144.80454 | 2104133.37104 | 37.757727257313704 | -122.43214639144101 | (37.7577272573137, -122.432146391441) | ||||
| 4659 | 4659 | 253652 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 131 Font Blvd | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10x10 | 5990844.0 | 2088883.0 | 37.7151485301311 | -122.473574812248 | (37.7151485301311, -122.473574812248) | ||||
| 5104 | 5104 | 253785 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1675X 15th Ave | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | ||||
| 5106 | 5106 | 253787 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1675X 15th Ave | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3x3 | 5991390.0 | 2103897.0 | 37.7564047756354 | -122.47278171886002 | (37.7564047756354, -122.47278171886) | ||||
| 5112 | 5112 | 253808 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 5120 | 5120 | 253810 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 281 Ralston St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3x6 | 5992187.95019 | 2089731.22021 | 37.7175552771373 | -122.46899127483299 | (37.7175552771373, -122.468991274833) | ||||
| 5161 | 5161 | 253809 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 2 Garfield St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 10x10 | 5993976.0 | 2090624.0 | 37.7201097842726 | -122.462875584037 | (37.7201097842726, -122.462875584037) | ||||
| 5176 | 5176 | 253818 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 219 Concord St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 5999956.6131 | 2087048.59536 | 37.7106351918399 | -122.44194619318 | (37.7106351918399, -122.44194619318) | ||||
| 7810 | 7810 | 119607 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 299x Avalon Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 8128 | 8128 | 87100 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 700 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 3x3 | Permit Number 50056 | ||||||||
| 8592 | 8592 | 121500 | Private 5 | Pinus radiata :: Monterey Pine 3 | 251X Pennsylvania Ave | 1 | Back Yard : Yard 13 | Tree 1 | DPW 2 | ||||||||||
| 9593 | 9593 | 94859 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53932 | |||||||||
| 9663 | 9663 | 114120 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||||
| 9680 | 9680 | 173618 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 36 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||||
| 9694 | 9694 | 173632 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3300X Market St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | ||||||||||
| 9883 | 9883 | 173726 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1101 Connecticut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6013424.0 | 2101939.0 | 37.752279425117294 | -122.396442635345 | (37.7522794251173, -122.396442635345) | |||||
| 9968 | 9968 | 173756 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1X Emil Ln | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 5996276.0 | 2095955.0 | 37.734879644622296 | -122.455310374086 | (37.7348796446223, -122.455310374086) | ||||
| 9970 | 9970 | 173755 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1X Emil Ln | 1 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 5996276.0 | 2095955.0 | 37.734879644622296 | -122.455310374086 | (37.7348796446223, -122.455310374086) | ||||
| 9985 | 9985 | 120925 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 8 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 9994 | 9994 | 120923 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 6 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 9998 | 9998 | 120931 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 14 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 9999 | 9999 | 120922 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 5 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10006 | 10006 | 120927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 10 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10015 | 10015 | 120928 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 11 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10021 | 10021 | 120935 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 18 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |||
| 10099 | 10099 | 173842 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 288X Graystone Ter | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5999483.0 | 2103863.0 | 37.7567765924541 | -122.444790942005 | (37.7567765924541, -122.444790942005) | |||||
| 10146 | 10146 | 173882 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 201x Howth St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997459.0 | 2090748.0 | 37.7206502603184 | -122.450845024895 | (37.7206502603184, -122.450845024895) | |||||
| 10199 | 10199 | 173896 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 326x Dellbrook Ave | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x3 | 5997295.0 | 2102064.0 | 37.7517118802849 | -122.452228008054 | (37.7517118802849, -122.452228008054) | ||||
| 10208 | 10208 | 173903 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 675 Corbett Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5999984.0 | 2103563.0 | 37.7559814441149 | -122.44303676104799 | (37.7559814441149, -122.443036761048) | |||||
| 10214 | 10214 | 173907 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2200 Jerrold Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 6012443.0 | 2099218.0 | 37.7447535037256 | -122.399644080592 | (37.7447535037256, -122.399644080592) | |||||
| 10223 | 10223 | 173927 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 240 States St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6001213.0 | 2106258.0 | 37.7634512529938 | -122.438979613423 | (37.7634512529938, -122.438979613423) | |||||
| 10236 | 10236 | 173928 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 51 Vulcan Stwy | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 6000543.0 | 2106304.0 | 37.763539413759204 | -122.441300222472 | (37.7635394137592, -122.441300222472) | |||||
| 13319 | 13319 | 93075 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 1230 Twin Peaks Blvd | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 02/01/2010 12:00:00 AM | Permit Number 53156 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 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) | ||||
| 14837 | 14837 | 94862 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 53932 | |||||||||
| 18835 | 18835 | 114526 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1 TIOGA AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6011351.0 | 2088602.0 | 37.715543251319204 | -122.402673611341 | (37.7155432513192, -122.402673611341) | |||||
| 19268 | 19268 | 104883 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 132 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990322.1 | 2090011.1 | 37.718215776001294 | -122.475461023549 | (37.7182157760013, -122.475461023549) | |||||
| 19583 | 19583 | 119914 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 400X Brotherhood Way | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 100x100 | |||||||||
| 19656 | 19656 | 101900 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 1100 Ocean Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | Permit Number 769623 | 5996507.7 | 2092470.2 | 37.7253245106519 | -122.454257683967 | (37.7253245106519, -122.454257683967) | ||||
| 20076 | 20076 | 98360 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 807 Francisco St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | Permit Number 768654 | 6007370.5 | 2120864.5 | 37.8039055703948 | -122.418718664572 | (37.8039055703948, -122.418718664572) | ||||
| 20477 | 20477 | 104866 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 411 Holladay Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010309.7 | 2098610.5 | 37.7429662928376 | -122.406977848202 | (37.7429662928376, -122.406977848202) | |||||
| 20864 | 20864 | 112443 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2199x 25TH ST | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 6012503.0 | 2101856.0 | 37.752000229136705 | -122.399621792735 | (37.7520002291367, -122.399621792735) | ||||
| 22919 | 22919 | 251161 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 528 Noriega St | 1 | Median : Cutout 11 | Tree 1 | Private 1 | 3x3 | 5992330.0 | 2103518.0 | 37.7554185113149 | -122.46950331083401 | (37.7554185113149, -122.469503310834) | ||||
| 23001 | 23001 | 251172 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 363 Jersey St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6002784.74363 | 2101501.25508 | 37.750479672211 | -122.433203561601 | (37.750479672211, -122.433203561601) | |||||
| 41816 | 41816 | 104919 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 732 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5990421.0 | 2090607.0 | 37.719857702396 | -122.47516265050699 | (37.719857702396, -122.475162650507) | |||||
| 44573 | 44573 | 112444 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 2199x 25TH ST | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 3x3 | 6012503.0 | 2101856.0 | 37.752000229136705 | -122.399621792735 | (37.7520002291367, -122.399621792735) | ||||
| 47274 | 47274 | 121088 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1X Grand View Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000227.0 | 2103854.0 | 37.7567943109509 | -122.442217277848 | (37.7567943109509, -122.442217277848) | ||||
| 49637 | 49637 | 114270 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 27x ESMERALDA AVE | 2 | Unaccepted Street : Yard 14 | Tree 1 | Private 1 | 3x3 | 6006799.0 | 2098981.0 | 37.743786524331 | -122.41914318493001 | (37.743786524331, -122.41914318493) | ||||
| 50075 | 50075 | 113043 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 500 RAYMOND AVE | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 10/06/2015 12:00:00 AM | 3x3 | 6008527.0 | 2088690.0 | 37.7156268060035 | -122.412440877248 | (37.7156268060035, -122.412440877248) | |||
| 65540 | 65540 | 100177 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 252 States St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 768965 | 6000636.0 | 2106677.4 | 37.764569975148895 | -122.44100535545 | (37.7645699751489, -122.44100535545) | ||||
| 66024 | 66024 | 87113 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 470 West Portal Ave | 4 | unknown : Yard 19 | Tree 1 | Private 1 | 01/03/2008 12:00:00 AM | Permit Number 50062 | 5991694.0 | 2096460.0 | 37.736002282933704 | -122.47118857830601 | (37.7360022829337, -122.471188578306) | |||
| 67566 | 67566 | 87917 | Permitted Site 1 | Pinus radiata :: Monterey Pine 3 | 160 Gardenside Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/18/2008 12:00:00 AM | 3x3 | Permit Number 50940 | 5999367.0 | 2102115.0 | 37.751970392561496 | -122.445066449965 | (37.7519703925615, -122.445066449965) | ||
| 69379 | 69379 | 122419 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2200 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 5998886.0 | 2091075.0 | 37.7216297132481 | -122.44593585753599 | (37.7216297132481, -122.445935857536) | ||||
| 74398 | 74398 | 97290 | Property Tree 7 | Pinus radiata :: Monterey Pine 3 | 55 Hiliritas Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 778896 | 6001461.7 | 2096833.2 | 37.7375871516219 | -122.437444499981 | (37.7375871516219, -122.437444499981) | |||||
| 77320 | 77320 | 122488 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 69x Bonview St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6007716.0 | 2099172.0 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | ||||
| 77674 | 77674 | 116662 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 199x Esmeralda Ave | 15 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 6007213.11808 | 2098808.04206 | 37.7433349329997 | -122.417699002452 | (37.7433349329997, -122.417699002452) |
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");