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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 82994 | 82994 | 113610 | Section 143 8 | Olea europaea :: Olive Tree 41 | 595 ALABAMA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009000.0 | 2105472.0 | 37.7617330585457 | -122.41199123457899 | (37.7617330585457, -122.411991234579) | |||
| 88189 | 88189 | 113605 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
| 88888 | 88888 | 113602 | Section 143 8 | Olea europaea :: Olive Tree 41 | 550 FLORIDA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | Permit Number 773946 | 6009233.0 | 2105681.0 | 37.762319994612604 | -122.411200142124 | (37.7623199946126, -122.411200142124) | ||
| 89850 | 89850 | 113613 | Section 143 8 | Olea europaea :: Olive Tree 41 | 595 ALABAMA ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009000.0 | 2105472.0 | 37.7617330585457 | -122.41199123457899 | (37.7617330585457, -122.411991234579) | |||
| 90793 | 90793 | 113600 | Section 143 8 | Olea europaea :: Olive Tree 41 | 550 FLORIDA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 1 | 3x3 | Permit Number 773946 | 6009233.0 | 2105681.0 | 37.762319994612604 | -122.411200142124 | (37.7623199946126, -122.411200142124) | |
| 97450 | 97450 | 113603 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
| 98123 | 98123 | 113611 | Section 143 8 | Olea europaea :: Olive Tree 41 | 595 ALABAMA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009000.0 | 2105472.0 | 37.7617330585457 | -122.41199123457899 | (37.7617330585457, -122.411991234579) | |||
| 106970 | 106970 | 113608 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
| 116007 | 116007 | 113607 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
| 122514 | 122514 | 113604 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
| 122830 | 122830 | 113601 | Section 143 8 | Olea europaea :: Olive Tree 41 | 550 FLORIDA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | Permit Number 773946 | 6009233.0 | 2105681.0 | 37.762319994612604 | -122.411200142124 | (37.7623199946126, -122.411200142124) | ||
| 123789 | 123789 | 113606 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
| 144368 | 144368 | 113609 | Section 143 8 | Olea europaea :: Olive Tree 41 | 2900 18TH ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009122.0 | 2105484.0 | 37.7617728518996 | -122.411570131816 | (37.7617728518996, -122.411570131816) | |||
| 145031 | 145031 | 113612 | Section 143 8 | Olea europaea :: Olive Tree 41 | 595 ALABAMA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2015 12:00:00 AM | 3x3 | 6009000.0 | 2105472.0 | 37.7617330585457 | -122.41199123457899 | (37.7617330585457, -122.411991234579) | |||
| 21199 | 21199 | 97237 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125 Excelsior Ave | Sidewalk: Property side : Yard 9 | Tree 1 | SFUSD 4 | FUF 1 | 09/07/2011 12:00:00 AM | Permit Number 767513 | 6002911.0 | 2092621.3 | 37.7261045201699 | -122.43213288829399 | (37.7261045201699, -122.432132888294) | |||
| 99354 | 99354 | 102249 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125X Powhattan Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606.0 | 2098071.0 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | |||
| 100052 | 100052 | 97238 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125 Excelsior Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | SFUSD 4 | FUF 1 | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767513 | 6002911.0 | 2092621.3 | 37.7261045201699 | -122.43213288829399 | (37.7261045201699, -122.432132888294) |
| 101894 | 101894 | 102250 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125X Powhattan Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606.0 | 2098071.0 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | |||
| 104754 | 104754 | 102248 | Property Tree 7 | Olea europaea :: Olive Tree 41 | 125X Powhattan Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 01/07/2013 12:00:00 AM | Permit Number 768486 | 6007606.0 | 2098071.0 | 37.7413332800665 | -122.416288322592 | (37.7413332800665, -122.416288322592) | |||
| 1693 | 1693 | 251659 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1050 North Point St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 1702 | 1702 | 251658 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1050 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 1717 | 1717 | 251661 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6005628.0 | 2121390.0 | 37.8052501972152 | -122.424786108187 | (37.8052501972152, -122.424786108187) | ||||
| 11662 | 11662 | 102569 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 0 Diaz Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/04/2013 12:00:00 AM | 2 | Permit Number 769785 | 5990053.95839 | 2089992.8197400002 | 37.7181500356804 | -122.476386530439 | (37.7181500356804, -122.476386530439) | ||
| 60806 | 60806 | 96274 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 55@ Alemany Trumbull St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6004001.3006 | 2094332.0064299998 | 37.7308634942567 | -122.428485665086 | (37.7308634942567, -122.428485665086) | ||||
| 81797 | 81797 | 115888 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 811 TREAT AVE | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 20 | 3x3 | 6008597.0 | 2103712.0 | 37.7568778816719 | -122.413260590978 | (37.7568778816719, -122.413260590978) | |||
| 83367 | 83367 | 115940 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 3401x 17TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 20 | 3x3 | 6006069.0 | 2106010.0 | 37.7630453994978 | -122.42216662533801 | (37.7630453994978, -122.422166625338) | |||
| 91973 | 91973 | 106184 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1327 ULLOA ST | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | FUF 1 | 2 | 4x4 | 5991893.8 | 2098371.4 | 37.7412620575898 | -122.470636971077 | (37.7412620575898, -122.470636971077) | ||
| 103074 | 103074 | 97264 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 300 Newhall St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/09/2011 12:00:00 AM | Permit Number 768179 | 6016549.1 | 2098591.6 | 37.743261569489704 | -122.38540219642401 | (37.7432615694897, -122.385402196424) | |||
| 103307 | 103307 | 115942 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 3401x 17TH ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 3x3 | 6006069.0 | 2106010.0 | 37.7630453994978 | -122.42216662533801 | (37.7630453994978, -122.422166625338) | ||||
| 115729 | 115729 | 105234 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 250 STATES ST | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6000595.6 | 2106681.2 | 37.7645781078798 | -122.441145360444 | (37.7645781078798, -122.441145360444) | ||||
| 116414 | 116414 | 98290 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 300 Mangels Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | |||
| 119061 | 119061 | 98288 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 300 Mangels Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | |||
| 120820 | 120820 | 115941 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 3401x 17TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 3x3 | 6006069.0 | 2106010.0 | 37.7630453994978 | -122.42216662533801 | (37.7630453994978, -122.422166625338) | ||||
| 127022 | 127022 | 114430 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 455 EDDY ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3x3 | 6008254.0 | 2113439.0 | 37.783566680449795 | -122.41513531885201 | (37.7835666804498, -122.415135318852) | ||||
| 127682 | 127682 | 98289 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 300 Mangels Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 01/24/2012 12:00:00 AM | Permit Number 768637 | 5999381.8 | 2095276.6 | 37.7331946288913 | -122.444523835506 | (37.7331946288913, -122.444523835506) | |||
| 144632 | 144632 | 114429 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 455 EDDY ST | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 10 | 3x3 | 6008254.0 | 2113439.0 | 37.783566680449795 | -122.41513531885201 | (37.7835666804498, -122.415135318852) | |||
| 154027 | 154027 | 96278 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 55@ Alemany Trumbull St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 2 | 6003898.31997 | 2094328.2986700002 | 37.7308474854131 | -122.42884142159599 | (37.7308474854131, -122.428841421596) | ||||
| 166020 | 166020 | 99921 | Significant Tree 6 | Olea europaea :: Olive Tree 41 | 1740 Jones St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6008331.64636 | 2118443.68708 | 37.7973126906849 | -122.415221079511 | (37.7973126906849, -122.415221079511) | ||||
| 4949 | 4949 | 83043 | Private 5 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/18/2017 02:49:00 PM | 3 | 6018760.2720099995 | 2097656.0724299997 | 37.7408148829885 | -122.377691543139 | (37.7408148829885, -122.377691543139) | |||
| 23209 | 23209 | 83033 | Private 5 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 1 | 6018894.74802 | 2097554.01331 | 37.7405420574702 | -122.377219490814 | (37.7405420574702, -122.377219490814) | |||
| 4790 | 4790 | 158406 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 50 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2017 12:00:00 AM | 3 | 3X3 | Permit Number 770857 | 6001789.37716 | 2096842.5543 | 37.7376314601307 | -122.436312235543 | (37.7376314601307, -122.436312235543) | |
| 13325 | 13325 | 187677 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13326 | 13326 | 187676 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13332 | 13332 | 187674 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13335 | 13335 | 187678 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13336 | 13336 | 187675 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13337 | 13337 | 187679 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2690 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008898.65774693 | 2102801.94608421 | 37.7543960104367 | -122.41215302657 | (37.7543960104367, -122.41215302657) | ||||
| 13498 | 13498 | 60261 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2495 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/08/2015 12:00:00 AM | 12 | 3x3 | Permit Number 776014 | 6008888.61229415 | 2103948.71328851 | 37.7575442102667 | -122.41226881345301 | (37.7575442102667, -122.412268813453) | |
| 13578 | 13578 | 187698 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2880 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008980.17665 | 2103937.78959 | 37.757519353838795 | -122.41195137385 | (37.7575193538388, -122.41195137385) | ||||
| 97171 | 97171 | 60705 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 963 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/05/1983 12:00:00 AM | 1 | 3x3 | Permit Number 20354 | 6009178.18020232 | 2103559.73737881 | 37.7564924147418 | -122.4112398899 | (37.7564924147418, -122.4112398899) | |
| 113628 | 113628 | 116851 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 83 Panorama Dr | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | |||
| 117231 | 117231 | 116850 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 83 Panorama Dr | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/03/2016 12:00:00 AM | 3 | 5997625.8 | 2100317.8 | 37.7469361901044 | -122.450958160054 | (37.7469361901044, -122.450958160054) | |||
| 128502 | 128502 | 66394 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 504 Andover St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2016 12:00:00 AM | 3 | 3x4 | Permit Number 772815 | 6007447.25872729 | 2096493.62336554 | 37.7369932248849 | -122.41672547553001 | (37.7369932248849, -122.41672547553) | |
| 158157 | 158157 | 166259 | Planning Code 138.1 required 4 | Olea europaea :: Olive Tree 41 | 2880 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 0 | 3x3 | 6008980.17665 | 2103937.78959 | 37.757519353838795 | -122.41195137385 | (37.7575193538388, -122.41195137385) | |||
| 123 | 123 | 18916 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2621 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 6x5 | 6002236.03231 | 2115724.70658 | 37.7895026155894 | -122.4361187581 | (37.7895026155894, -122.4361187581) | |||
| 175 | 175 | 17881 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2205 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003346.6048 | 2115178.7939 | 37.7880667103656 | -122.432237297056 | (37.7880667103656, -122.432237297056) | |||
| 399 | 399 | 17856 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2121 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2000 12:00:00 AM | 10 | 3X3 | 6003596.6138 | 2115206.3541 | 37.7881565558045 | -122.431374278321 | (37.7881565558045, -122.431374278321) | ||
| 464 | 464 | 18999 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3039 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 6000252.38525 | 2115449.79519 | 37.7886348840283 | -122.442962190565 | (37.7886348840283, -122.442962190565) | |||
| 949 | 949 | 13070 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 630 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 22 | 3x3 | 6009332.6794 | 2120506.3975 | 37.803032589908106 | -122.4119030734 | (37.8030325899081, -122.4119030734) | |||
| 1289 | 1289 | 131895 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3274 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 16 | Width 4ft | 5999203.0 | 2115426.0 | 37.7885096634197 | -122.446591180632 | (37.7885096634197, -122.446591180632) | |||
| 1294 | 1294 | 6921 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 425 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/09/2010 12:00:00 AM | 3 | 3X3 | 6005385.421 | 2110602.3829 | 37.7756164008395 | -122.424857632506 | (37.7756164008395, -122.424857632506) | ||
| 1656 | 1656 | 9731 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 641 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 2 | 4x4 | 6005777.9079 | 2111995.4394 | 37.7794635560295 | -122.42359898745899 | (37.7794635560295, -122.423598987459) | |||
| 1745 | 1745 | 17972 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2515 Pine St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001748.1253 | 2114954.2725 | 37.7873594702652 | -122.437751658759 | (37.7873594702652, -122.437751658759) | |||
| 1778 | 1778 | 17971 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2515 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6001715.6676 | 2114951.5677 | 37.7873501979521 | -122.437863761621 | (37.7873501979521, -122.437863761621) | |||
| 1926 | 1926 | 11155 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2615 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6006917.28019 | 2121296.80497 | 37.805067041968 | -122.420317765078 | (37.805067041968, -122.420317765078) | |||
| 2237 | 2237 | 17958 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2500 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1992 12:00:00 AM | 6 | 3x3 | 6001912.0842 | 2115029.0126 | 37.7875740088989 | -122.437189749529 | (37.7875740088989, -122.437189749529) | ||
| 3109 | 3109 | 19037 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3235 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 5999309.28069 | 2115314.23141 | 37.788208846394895 | -122.446215424205 | (37.7882088463949, -122.446215424205) | |||
| 3162 | 3162 | 11135 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2454 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007038.94291 | 2120769.9344599997 | 37.8036272444521 | -122.41985932665199 | (37.8036272444521, -122.419859326652) | |||
| 3427 | 3427 | 11134 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2454 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007041.13953 | 2120754.1462 | 37.8035840176492 | -122.41985060413299 | (37.8035840176492, -122.419850604133) | |||
| 3468 | 3468 | 18831 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2001 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005118.6821099995 | 2116122.7244599997 | 37.79075882281 | -122.426173443361 | (37.79075882281, -122.426173443361) | |||
| 3640 | 3640 | 9732 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 645 Gough St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/14/2011 12:00:00 AM | 3 | 4x4 | 6005775.5462 | 2112013.5463 | 37.7795131398465 | -122.423608445305 | (37.7795131398465, -122.423608445305) | ||
| 3680 | 3680 | 9726 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 621 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6005799.3606 | 2111864.1645 | 37.779104318085295 | -122.42351543791099 | (37.7791043180853, -122.423515437911) | |||
| 3750 | 3750 | 253551 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 19 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 04:40:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3758 | 3758 | 253548 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 16 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/22/2017 04:31:00 PM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3837 | 3837 | 253550 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 18 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:43:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3840 | 3840 | 253546 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 14 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:50:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3841 | 3841 | 253549 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 17 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:46:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 3842 | 3842 | 253547 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1000 Cayuga Ave | 15 | Back Yard : Yard 13 | Tree 1 | DPW 2 | 09/27/2017 11:40:00 AM | 3 | 3x3 | 6000652.979169999 | 2091201.14277 | 37.7220768117153 | -122.43983693715201 | (37.7220768117153, -122.439836937152) | ||
| 4341 | 4341 | 13314 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3179X Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999566.13783 | 2115354.5120599996 | 37.7883341120707 | -122.445329642351 | (37.7883341120707, -122.445329642351) | |||
| 4559 | 4559 | 132044 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 444 Washington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/16/2002 12:00:00 AM | 7 | Width 4ft | 6012372.27446 | 2117831.7295 | 37.795858655114 | -122.401196364438 | (37.795858655114, -122.401196364438) | ||
| 4914 | 4914 | 6236 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1250 Ellis St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/12/1995 12:00:00 AM | 12 | 3X3 | 6004877.1927 | 2113359.8717 | 37.78315906739 | -122.42681214119499 | (37.78315906739, -122.426812141195) | ||
| 4990 | 4990 | 3550 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 201X Cargo Way | 60 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1990 12:00:00 AM | 6 | 3X3 | 6018708.52549 | 2097590.55589 | 37.7406321362531 | -122.377865918974 | (37.7406321362531, -122.377865918974) | ||
| 5264 | 5264 | 17885 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2214 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003222.3202 | 2115211.247 | 37.788148770729705 | -122.43266961876499 | (37.7881487707297, -122.432669618765) | |||
| 5320 | 5320 | 19014 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3122 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3X3 | 5999831.14019 | 2115437.85116 | 37.788578063082106 | -122.44441877212401 | (37.7885780630821, -122.444418772124) | |||
| 5347 | 5347 | 18998 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3009 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/01/2011 12:00:00 AM | 3 | 3x3 | 6000320.39642 | 2115456.92187 | 37.788658329372396 | -122.442727394678 | (37.7886583293724, -122.442727394678) | ||
| 5418 | 5418 | 19000 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3042 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6000225.4751699995 | 2115493.68766 | 37.7887538670327 | -122.44305844861401 | (37.7887538670327, -122.443058448614) | |||
| 5480 | 5480 | 87732 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3200X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 05/10/2008 12:00:00 AM | 3 | 4x4 | 6005468.85489 | 2121438.02655 | 37.8053730758726 | -122.425340270033 | (37.8053730758726, -122.425340270033) | ||
| 5539 | 5539 | 17884 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2210 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6003260.8806 | 2115214.139 | 37.7881588981801 | -122.43253641314399 | (37.7881588981801, -122.432536413144) | |||
| 5703 | 5703 | 9727 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 621 Gough St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6005801.3288 | 2111846.4513 | 37.779055793051 | -122.423507369454 | (37.779055793051, -122.423507369454) | |||
| 5831 | 5831 | 18814 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1921 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005353.8734800005 | 2116157.5446599997 | 37.7908677208195 | -122.42536217123501 | (37.7908677208195, -122.425362171235) | |||
| 5839 | 5839 | 9898 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1800X Pine St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6004962.1152 | 2115451.6483 | 37.788907365673204 | -122.42666734903999 | (37.7889073656732, -122.42666734904) | |||
| 5864 | 5864 | 17800 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1855 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | 3x3 | 6005059.342 | 2115410.1523 | 37.788798924352996 | -122.42632800170901 | (37.788798924353, -122.426328001709) | |||
| 5888 | 5888 | 11169 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 2700 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3X3 | 6006924.13035 | 2121583.86925 | 37.8058556331999 | -122.420314446577 | (37.8058556331999, -122.420314446577) | |||
| 5914 | 5914 | 18827 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1911 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005492.837780001 | 2116179.1366 | 37.7909348570073 | -122.424882897351 | (37.7909348570073, -122.424882897351) | |||
| 5944 | 5944 | 96090 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3122 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/04/2011 12:00:00 AM | 3 | 3x3 | 5999797.96737 | 2115433.02091 | 37.7885629076984 | -122.444533197372 | (37.7885629076984, -122.444533197372) | ||
| 5961 | 5961 | 18819 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1850 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6005893.34484 | 2116280.69836 | 37.7912363340264 | -122.423504381436 | (37.7912363340264, -122.423504381436) | |||
| 6026 | 6026 | 13056 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 567 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/06/2016 07:33:00 AM | 3 | 3X3 | 6009638.2249 | 2120505.3867 | 37.8030469515764 | -122.410845650802 | (37.8030469515764, -122.410845650802) | ||
| 6142 | 6142 | 13315 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3179X Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 5999602.752730001 | 2115359.85021 | 37.7883508592612 | -122.445203345153 | (37.7883508592612, -122.445203345153) | |||
| 6218 | 6218 | 19042 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3257 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 5999209.87226 | 2115305.32061 | 37.7881787020404 | -122.44655871793002 | (37.7881787020404, -122.44655871793) | |||
| 6241 | 6241 | 19036 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 3238 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 15 | 3x3 | 5999312.475430001 | 2115365.10303 | 37.7883487089688 | -122.44620803177 | (37.7883487089688, -122.44620803177) |
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");