Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 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) | ||||
| 1620 | 1620 | 251543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0X Bay Shore Blvd Off Ramp | Side Yard : Yard 17 | Tree 1 | Private 1 | |||||||||||
| 1772 | 1772 | 173895 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 326x Dellbrook Ave | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3 | 3x3 | 5997295.0 | 2102064.0 | 37.7517118802849 | -122.452228008054 | (37.7517118802849, -122.452228008054) | |||
| 2100 | 2100 | 178279 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 4 | Width 0ft | 5987917.15522 | 2088760.91322 | 37.714643374877895 | -122.48368218070499 | (37.7146433748779, -122.483682180705) | |||
| 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) | |||
| 2976 | 2976 | 198801 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 150 Executive Park Blvd | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 0 | Width 4ft | 6013745.097 | 2086994.3966599999 | 37.7112624653484 | -122.394285983735 | (37.7112624653484, -122.394285983735) | |||
| 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) | |||
| 3537 | 3537 | 102838 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1101X Portola Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | ||||||||||
| 5057 | 5057 | 123370 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 785 03rd Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 41 | Width 4ft | 5995014.0 | 2110353.0 | 37.7743403969856 | -122.46071658922399 | (37.7743403969856, -122.460716589224) | |||
| 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) | ||||
| 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) | ||||
| 5183 | 5183 | 211164 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 25 Burnside Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001259.23547 | 2095941.97308 | 37.7351285371507 | -122.438080692094 | (37.7351285371507, -122.438080692094) | |||
| 8010 | 8010 | 115555 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3897 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3x3 | 5996212.11985 | 2115219.4068 | 37.7877711202849 | -122.45692415093201 | (37.7877711202849, -122.456924150932) | |||
| 9639 | 9639 | 114121 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9642 | 9642 | 114119 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9645 | 9645 | 114115 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9652 | 9652 | 114118 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9653 | 9653 | 114116 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9659 | 9659 | 114136 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 31 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 32 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 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) | |||||
| 9675 | 9675 | 114114 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 40 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9676 | 9676 | 114117 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9679 | 9679 | 114122 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 15 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 36 | 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 | ||||||||||
| 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) | ||||
| 9983 | 9983 | 173627 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 3x3 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||
| 9989 | 9989 | 173658 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 46 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 9997 | 9997 | 173656 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 44 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10001 | 10001 | 173622 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 40 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10003 | 10003 | 173619 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 37 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10009 | 10009 | 173621 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 39 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10013 | 10013 | 173624 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10017 | 10017 | 173623 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 41 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10018 | 10018 | 173657 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 45 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 10020 | 10020 | 115676 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X Junipero Serra Blvd | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.2 | 2089585.5 | 37.717093588438 | -122.472660975441 | (37.717093588438, -122.472660975441) | |||
| 10022 | 10022 | 173620 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 38 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 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) | ||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | ||||
| 23749 | 23749 | 181585 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1200 Sunset Blvd | 98 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 0ft | 5984843.0144 | 2106607.1528 | 37.7634649266844 | -122.49562304315201 | (37.7634649266844, -122.495623043152) | |||
| 23936 | 23936 | 211142 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 100 Terrace Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 5993344.399119999 | 2096880.05499 | 37.7372509740365 | -122.465513038912 | (37.7372509740365, -122.465513038912) | ||||
| 24072 | 24072 | 246633 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 3320 Harrison St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6009029.84734 | 2099262.75496 | 37.7446855398981 | -122.411449314735 | (37.7446855398981, -122.411449314735) | ||||
| 24653 | 24653 | 178297 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 654 Brotherhood Way | 20 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5989773.99422 | 2088725.52612 | 37.7146541208759 | -122.47726167241001 | (37.7146541208759, -122.47726167241) | |||
| 24680 | 24680 | 187543 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1400 Somerset St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 35 | 6011384.82868 | 2088240.1087599997 | 37.714551459646394 | -122.402531250636 | (37.7145514596464, -122.402531250636) | ||||
| 24719 | 24719 | 247088 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2301 Castro St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6002764.361830001 | 2098589.4854900003 | 37.74248347881979 | -122.43306602918001 | (37.7424834788198, -122.43306602918) | ||||
| 24871 | 24871 | 178331 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Crespi Dr | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5990248.62782 | 2090529.4940400003 | 37.719634898219205 | -122.47575281776001 | (37.7196348982192, -122.47575281776) | ||||
| 25115 | 25115 | 185194 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2500 Sunset Blvd | 47 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 0ft | 5985119.413 | 2097901.151 | 37.739576815599705 | -122.49402541183001 | (37.7395768155997, -122.49402541183) | |||
| 25144 | 25144 | 211274 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 198 Mangels Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 6000155.24688 | 2095249.8649900001 | 37.733165323413296 | -122.441847909861 | (37.7331653234133, -122.441847909861) | ||||
| 25194 | 25194 | 211098 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 129 Merced Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | Width 4ft | 5994586.4001400005 | 2099476.04195 | 37.7444504634195 | -122.46140704199699 | (37.7444504634195, -122.461407041997) | |||
| 25318 | 25318 | 178237 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunnydale Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 53 | Width 10ft | 6007383.79648 | 2087366.7973099998 | 37.7119293468405 | -122.416298653474 | (37.7119293468405, -122.416298653474) | |||
| 25610 | 25610 | 185678 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2101 Sunset Blvd | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5984885.606000001 | 2100736.1658 | 37.7473473148238 | -122.495042795968 | (37.7473473148238, -122.495042795968) | |||
| 25725 | 25725 | 178308 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Font Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 31 | 5990210.12045 | 2089417.27348 | 37.716578783365605 | -122.47580474370501 | (37.7165787833656, -122.475804743705) | ||||
| 25780 | 25780 | 178245 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 62 Tomaso Ct | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 39 | Width 8ft | 6009206.68729 | 2086340.63676 | 37.7092140561483 | -122.409925810128 | (37.7092140561483, -122.409925810128) | |||
| 25827 | 25827 | 178248 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2134 San Jose Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | Width 8ft | 5998978.6210900005 | 2091233.6184200002 | 37.7220705312196 | -122.44562709311899 | (37.7220705312196, -122.445627093119) | |||
| 25935 | 25935 | 181432 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1500 Sunset Blvd | 65 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 26 | Width 0ft | 5984894.5136 | 2104866.8621 | 37.7586895903293 | -122.495316576359 | (37.7586895903293, -122.495316576359) | |||
| 26291 | 26291 | 178180 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 491 La Grande Ave | 4 | : Yard 23 | Tree 1 | Private 1 | 20 | 6004422.927759999 | 2089235.71163 | 37.716894041605 | -122.42666525741001 | (37.716894041605, -122.42666525741) | ||||
| 26474 | 26474 | 250207 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 212 Union St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 0ft | 6011784.78005 | 2119790.75424 | 37.801204871053706 | -122.40336710211399 | (37.8012048710537, -122.403367102114) | |||
| 26532 | 26532 | 187085 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2600 Sunset Blvd | 21 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 0ft | 5985163.4571 | 2097078.2568 | 37.7373199456306 | -122.493812503589 | (37.7373199456306, -122.493812503589) | |||
| 26554 | 26554 | 178310 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Serrano Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 34 | 5989465.34816 | 2090743.3229599998 | 37.7201765760646 | -122.478475931633 | (37.7201765760646, -122.478475931633) | ||||
| 26681 | 26681 | 185032 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2701 Sunset Blvd | 58 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 33 | Width 0ft | 5984996.6786 | 2096302.3729 | 37.7351798168117 | -122.494331950768 | (37.7351798168117, -122.494331950768) | |||
| 26718 | 26718 | 178187 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2 Brookdale Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 37 | Width 6ft | 6006632.31277 | 2087409.6759400002 | 37.712004796352 | -122.418899037766 | (37.712004796352, -122.418899037766) | |||
| 26736 | 26736 | 178228 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1701 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 46 | Width 10ft | 6006676.947980001 | 2087600.4049200001 | 37.7125310112787 | -122.418758283074 | (37.7125310112787, -122.418758283074) | |||
| 26867 | 26867 | 117975 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 428 38th Ave | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 18 | Width 4ft | 5984094.18326 | 2112936.79035 | 37.7808004176611 | -122.49868058079399 | (37.7808004176611, -122.498680580794) | |||
| 26932 | 26932 | 178306 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 777 Brotherhood Way | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 0ft | 5990015.12646 | 2088607.4961599999 | 37.7143440274236 | -122.47641961286999 | (37.7143440274236, -122.47641961287) | |||
| 26938 | 26938 | 211085 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1779 11th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 5ft | 5992762.67578 | 2103271.72487 | 37.754767299776894 | -122.467989086527 | (37.7547672997769, -122.467989086527) | |||
| 27306 | 27306 | 178328 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 0 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 29 | 5990317.34225 | 2090043.8786900002 | 37.718305502374704 | -122.47547986090599 | (37.7183055023747, -122.475479860906) | ||||
| 27323 | 27323 | 211279 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 350 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 28 | Width 10ft | 5999756.13451 | 2094992.8184 | 37.7324367835174 | -122.44320928919201 | (37.7324367835174, -122.443209289192) | |||
| 27356 | 27356 | 211222 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 11 Merced Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 5995310.272999999 | 2100165.7957900004 | 37.746385991539796 | -122.458953986438 | (37.7463859915398, -122.458953986438) | |||
| 27377 | 27377 | 211177 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2 Lobos St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5996889.59605 | 2088696.8686799998 | 37.714985719781 | -122.45266530885799 | (37.714985719781, -122.452665308858) | ||||
| 27414 | 27414 | 186546 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1501 Sunset Blvd | 17 | unknown : Yard 19 | Tree 1 | Private 1 | 3 | Width 0ft | 5984749.2128 | 2104853.9681 | 37.758645678551105 | -122.495818134238 | (37.7586456785511, -122.495818134238) | |||
| 27602 | 27602 | 178277 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 900 Brotherhood Way | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 0ft | 5987671.03855 | 2088779.0413099998 | 37.7146788207357 | -122.484534178617 | (37.7146788207357, -122.484534178617) | |||
| 27682 | 27682 | 233330 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 4053 20th St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 3ft | 6003355.15759 | 2104159.05112 | 37.757809692771204 | -122.431420737491 | (37.7578096927712, -122.431420737491) | |||
| 27688 | 27688 | 194493 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2098 Jerrold Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 8ft | 6012789.47061 | 2098973.3906900003 | 37.744101165829996 | -122.398428883383 | (37.74410116583, -122.398428883383) | |||
| 27896 | 27896 | 132196 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 24 Priest St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 10ft | 6008335.46638 | 2117136.84644 | 37.7937246439237 | -122.415115310227 | (37.7937246439237, -122.415115310227) | |||
| 28008 | 28008 | 211205 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 700 Junipero Serra Blvd | 151 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 5991189.83716 | 2091473.3519099997 | 37.72228102203729 | -122.472568205077 | (37.7222810220373, -122.472568205077) | |||
| 28096 | 28096 | 178240 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 230 Hahn St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 41 | Width 10ft | 6007365.51864 | 2087166.49263 | 37.7113783241319 | -122.416347648527 | (37.7113783241319, -122.416347648527) | |||
| 28218 | 28218 | 185207 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 2500 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 59 | Width 0ft | 5985138.0061 | 2098023.9982 | 37.7399152089238 | -122.493970177095 | (37.7399152089238, -122.493970177095) | |||
| 28252 | 28252 | 218356 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 355 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 28 | Width 0ft | 5993561.70957 | 2100014.8497 | 37.7458708634629 | -122.464989307038 | (37.7458708634629, -122.464989307038) | |||
| 28379 | 28379 | 186454 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1601 Sunset Blvd | 42 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 0ft | 5984732.5685 | 2103876.5622 | 37.755961018818205 | -122.495803598204 | (37.7559610188182, -122.495803598204) | |||
| 28537 | 28537 | 181372 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1500 Sunset Blvd | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 0ft | 5984899.4843 | 2104416.3495 | 37.757452898982 | -122.495266162351 | (37.757452898982, -122.495266162351) | |||
| 28757 | 28757 | 211091 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1995 18th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 10ft | 5990630.75875 | 2101824.33397 | 37.7506697996948 | -122.475256101486 | (37.7506697996948, -122.475256101486) | |||
| 28960 | 28960 | 233298 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1300 San Jose Ave | 62 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | Width 5ft | 6003206.225980001 | 2095448.26546 | 37.733883463556296 | -122.431314016734 | (37.7338834635563, -122.431314016734) | |||
| 29239 | 29239 | 211277 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 232 Edna St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 43 | 5998792.56249 | 2095483.7387400002 | 37.7337297433315 | -122.44657587878599 | (37.7337297433315, -122.446575878786) | ||||
| 29280 | 29280 | 184503 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1963 47th Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | Width 0ft | 5981636.5852 | 2101719.8576 | 37.7498575164936 | -122.506350418514 | (37.7498575164936, -122.506350418514) | |||
| 29301 | 29301 | 250202 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 203 Union St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | Width 0ft | 6011755.5651 | 2119757.15751 | 37.8011109908426 | -122.403465834184 | (37.8011109908426, -122.403465834184) | |||
| 29491 | 29491 | 178184 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1500 Sunnydale Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 6ft | 6007231.9474 | 2087473.93548 | 37.7122149858952 | -122.416831073707 | (37.7122149858952, -122.416831073707) | |||
| 29561 | 29561 | 184074 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1600 Sunset Blvd | 75 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 39 | Width 0ft | 5984940.3178 | 2104029.3211 | 37.756392616978204 | -122.495096407167 | (37.7563926169782, -122.495096407167) | |||
| 29604 | 29604 | 186425 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 1601 Sunset Blvd | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 0ft | 5984770.2537 | 2104099.7419 | 37.756576015315794 | -122.495689733705 | (37.7565760153158, -122.495689733705) | |||
| 29791 | 29791 | 211214 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 160 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 4ft | 5995051.30007 | 2100776.75818 | 37.7480486509365 | -122.45989372850799 | (37.7480486509365, -122.459893728508) | |||
| 29803 | 29803 | 187601 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 748 University St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 6008719.70605 | 2090696.0975099998 | 37.7211459436074 | -122.41191647478998 | (37.7211459436074, -122.41191647479) | ||||
| 29819 | 29819 | 211182 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 300 Junipero Serra Blvd | 19 | : 4 | Tree 1 | Private 1 | 12 | Width 0ft | 5991394.30224 | 2094494.67005 | 37.7305886425487 | -122.47208153692699 | (37.7305886425487, -122.472081536927) |
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");