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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | ||||
| 9641 | 9641 | 114157 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 18 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 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) | ||||
| 9643 | 9643 | 114152 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9644 | 9644 | 114150 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 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) | ||||
| 9647 | 9647 | 114149 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9651 | 9651 | 114156 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 17 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 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) | ||||
| 9656 | 9656 | 114151 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | ||||
| 9657 | 9657 | 114153 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200x JUNIPERO SERRA BLVD | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 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) | ||||
| 9661 | 9661 | 114148 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | 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 | ||||||||||
| 9843 | 9843 | 20458 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 495X Sunset Blvd | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 9855 | 9855 | 20400 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 45 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 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) | |||||
| 9890 | 9890 | 3755 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 1050 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 18 | 6012450.5971046 | 2103074.0676917997 | 37.7553418567665 | -122.39988853682199 | (37.7553418567665, -122.399888536822) | |||
| 9909 | 9909 | 173722 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 928 Carolina St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 17 | 3x3 | 6012423.0 | 2103596.0 | 37.7567734300957 | -122.400020627969 | (37.7567734300957, -122.400020627969) | |||
| 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) | ||
| 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) | |||
| 9986 | 9986 | 1263 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 3995X Alemany Blvd | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12/02/1998 12:00:00 AM | 10 | 3X3 | Permit Number 778829 | 5992394.0 | 2087287.0 | 37.7108559409462 | -122.468101362588 | (37.7108559409462, -122.468101362588) | |
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 10004 | 10004 | 114140 | Significant Tree 6 | Pinus radiata :: Monterey Pine 3 | 1200X JUNIPERO SERRA BLVD | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 01/20/2017 12:00:00 AM | 3 | 5991123.0 | 2089585.0 | 37.7170922039834 | -122.47266163030399 | (37.7170922039834, -122.472661630304) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) | |||||
| 10388 | 10388 | 2288 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989397.47374 | 2088680.9253 | 37.714509804868605 | -122.47855980688699 | (37.7145098048686, -122.478559806887) | |
| 10567 | 10567 | 20323 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 10721 | 10721 | 2286 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 08/30/2016 12:00:00 AM | 3 | 14M | Permit Number 777532 | 5989102.32398 | 2088689.12288 | 37.714515172905294 | -122.4795805509 | (37.7145151729053, -122.4795805509) | |
| 10850 | 10850 | 20451 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 495X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 10974 | 10974 | 20418 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 453X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 11124 | 11124 | 20380 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
| 11126 | 11126 | 2292 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5989842.77121 | 2088680.7511900002 | 37.7145351702246 | -122.477020683771 | (37.7145351702246, -122.477020683771) | |||
| 11130 | 11130 | 20306 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 11192 | 11192 | 24264 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 350X Winding Way | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 8 | 6001155.71614 | 2086583.0952599999 | 37.709425288929296 | -122.437768517615 | (37.7094252889293, -122.437768517615) | |||
| 11214 | 11214 | 20374 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 60 | ||||||||
| 11595 | 11595 | 20431 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 485X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 30 | ||||||||
| 11659 | 11659 | 106061 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 12X Canyon Dr | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 40 | 6003256.93175 | 2086330.4794599998 | 37.7088509162175 | -122.430488359046 | (37.7088509162175, -122.430488359046) | ||||
| 11765 | 11765 | 20396 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 41 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
| 12513 | 12513 | 2291 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 14M | 5989707.10535 | 2088681.30853 | 37.714528829127495 | -122.477489635265 | (37.7145288291275, -122.477489635265) | |||
| 12711 | 12711 | 19749 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY15 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 10ST | ||||||||
| 12855 | 12855 | 20286 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 12984 | 12984 | 2293 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 8 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 14M | 5990043.7756199995 | 2088644.1713900003 | 37.71444639007029 | -122.476323268498 | (37.7144463900703, -122.476323268498) | |||
| 13003 | 13003 | 24273 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 350X Winding Way | 11 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 8 | 6000864.27338 | 2086762.8945799998 | 37.7099024017335 | -122.43878866537399 | (37.7099024017335, -122.438788665374) | |||
| 13180 | 13180 | 20069 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY55 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 40ST | ||||||||
| 13202 | 13202 | 20284 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 13213 | 13213 | 2294 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 800X Brotherhood Way | 9 | Median : Cutout 11 | Tree 1 | DPW 2 | 45 | 14M | 5990137.079530001 | 2088614.4864299998 | 37.714370293032204 | -122.475998609661 | (37.7143702930322, -122.475998609661) | |||
| 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) | ||||
| 13357 | 13357 | 20454 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 495X Sunset Blvd | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 13388 | 13388 | 20313 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 13426 | 13426 | 20293 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 60 | ||||||||
| 13476 | 13476 | 20287 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 13681 | 13681 | 19775 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY18 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 50ST | ||||||||
| 13746 | 13746 | 20338 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | ||||||||
| 13748 | 13748 | 20343 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 29 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | ||||||||
| 14111 | 14111 | 20421 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 453X Sunset Blvd | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 14252 | 14252 | 20285 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 14683 | 14683 | 20337 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | ||||||||
| 14835 | 14835 | 20387 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 33 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 60 | ||||||||
| 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 | |||||||||
| 14905 | 14905 | 20283 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 60 | ||||||||
| 15072 | 15072 | 20052 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY53 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 30 | ||||||||
| 15202 | 15202 | 20339 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 101X Sunset Blvd | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 40 | ||||||||
| 15238 | 15238 | 20432 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 485X Sunset Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 30 | ||||||||
| 15347 | 15347 | 20288 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 20X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 15632 | 15632 | 20427 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 453X Sunset Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60 | ||||||||
| 16056 | 16056 | 20402 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 47 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
| 16063 | 16063 | 20307 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 50X Sunset Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 48 | 60 | ||||||||
| 16202 | 16202 | 20435 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 485X Sunset Blvd | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 30 | ||||||||
| 16297 | 16297 | 19969 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 100 STAIRWAY43 | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 15 | ||||||||
| 16394 | 16394 | 20368 | DPW Maintained 3 | Pinus radiata :: Monterey Pine 3 | 262X Sunset Blvd | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 60 |
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");