trees
603 rows where qSpecies_id = 172
This data as json, CSV (advanced)
| rowid ▼ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1132 | 87818 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 85 Mendosa Ave | 1 | Median : Cutout | Tree | Private 2 | 06/04/2008 12:00:00 AM | Permit Number 50680 | 5993356 | 2100787 | 37.747979128324 | -122.465756707117 | (37.747979128324, -122.465756707117) | 1 | 8 | 4 | 29491 | 40 | |||
| 1168 | 39947 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 1286 | 39945 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 1380 | 240268 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 601x Powhattan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6008545.16525 | 2098123.68757 | 37.7415307145772 | -122.413044731843 | (37.7415307145772, -122.413044731843) | 10 | 7 | 7 | 28859 | 2 | ||||
| 2164 | 240263 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 400X Powhattan Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | 6008170.52393 | 2098149.53855 | 37.7415806575183 | -122.414341946344 | (37.7415806575183, -122.414341946344) | 2 | 7 | 7 | 28859 | 2 | ||||
| 2184 | 185987 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Sunset Blvd | 46 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984879.8852 | 2101041.6583 | 37.7481857789236 | -122.495085101033 | (37.7481857789236, -122.495085101033) | 1 | 8 | 3 | 29491 | 35 | |||
| 2307 | 240272 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 99 Prentiss St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6008870 | 2098076 | 37.7414180046723 | -122.41191819098 | (37.7414180046723, -122.41191819098) | 10 | 7 | 7 | 28859 | 2 | ||||
| 2760 | 111440 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 30 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 12 | 5999883.47669 | 2091070.55057 | 37.7216744032298 | -122.442487538293 | (37.7216744032298, -122.442487538293) | 9 | 7 | 6 | 28861 | 25 | |||
| 3112 | 44154 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
| 3221 | 261757 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 394X Mullen Ave | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6010560 | 2099457 | 37.7453046014302 | -122.406172001215 | (37.7453046014302, -122.406172001215) | 2 | 7 | 7 | 28859 | 2 | ||||
| 3335 | 142293 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 475 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000600.6108 | 2110614.5346 | 37.775378345569 | -122.441410289609 | (37.775378345569, -122.441410289609) | 15 | 5 | 11 | 29492 | 16 | |||
| 3382 | 46731 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
| 3558 | 142294 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 465 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6000605.0602 | 2110593.7708 | 37.7753215869011 | -122.441393407901 | (37.7753215869011, -122.441393407901) | 15 | 5 | 11 | 29492 | 16 | |||
| 4150 | 111749 | Landmark tree 11 | Quercus agrifolia :: Coast Live Oak 172 | 4124 23rd St | 1 | Back Yard : Yard | Tree | Private 2 | 6002319.4 | 2102413.2 | 37.752957247271 | -122.434877962118 | (37.752957247271, -122.434877962118) | 2 | 4 | 5 | 28862 | 22 | |||||
| 4654 | 240225 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006210.25986 | 2095801.94104 | 37.7350243668737 | -122.420953246717 | (37.7350243668737, -122.420953246717) | 2 | 7 | 7 | 28859 | 2 | |||
| 4897 | 240251 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 2ft | 6005903.53457 | 2096951.45984 | 37.7381633947238 | -122.422095344327 | (37.7381633947238, -122.422095344327) | 2 | 7 | 7 | 28859 | 2 | |||
| 5010 | 240274 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 801X Powhattan Ave | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6008888.17456 | 2098091.89033 | 37.7414626556745 | -122.411856472021 | (37.7414626556745, -122.411856472021) | 10 | 7 | 7 | 28859 | 2 | ||||
| 5647 | 46732 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
| 6431 | 43420 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 310 Seneca Ave | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | 9 | 7 | 6 | 28861 | 25 | |||
| 6590 | 39944 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 6898 | 43451 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999743.13158 | 2091140.97159 | 37.7218597624867 | -122.442977727254 | (37.7218597624867, -122.442977727254) | 9 | 7 | 6 | 28861 | 25 | |
| 6925 | 43437 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 19 | Permit Number 43162 | 5999381.26407 | 2091328.91122 | 37.7223551630339 | -122.444242104791 | (37.7223551630339, -122.444242104791) | 9 | 7 | 6 | 28861 | 25 | |
| 7288 | 264692 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1500 Plymouth Ave | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5995893.6658 | 2094152.61505 | 37.7299087874515 | -122.456501934539 | (37.7299087874515, -122.456501934539) | 9 | 7 | 4 | 28861 | 40 | ||||
| 7296 | 39946 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 7385 | 240269 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 701X Powhattan Ave | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6008659.36547 | 2098106.42787 | 37.7414897333626 | -122.412648645239 | (37.7414897333626, -122.412648645239) | 10 | 7 | 7 | 28859 | 2 | ||||
| 7421 | 240271 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 99 Banks St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6008711 | 2098131 | 37.741560100881 | -122.412471846631 | (37.741560100881, -122.412471846631) | 10 | 7 | 7 | 28859 | 2 | ||||
| 7953 | 97241 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 260 Madrid St | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003464 | 2092306.9 | 37.7252725856131 | -122.430198780788 | (37.7252725856131, -122.430198780788) | 9 | 7 | 6 | 28861 | 5 |
| 8057 | 185640 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2100 Sunset Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985051.8314 | 2100435.5567 | 37.7465316538612 | -122.494445852676 | (37.7465316538612, -122.494445852676) | 1 | 8 | 3 | 29491 | 35 | |||
| 8107 | 260620 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1510 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 08/24/2019 12:00:00 AM | 3 | 6015860.79811 | 2095596.0425 | 37.7349982739746 | -122.387573242087 | (37.7349982739746, -122.387573242087) | 10 | 3 | 8 | 58 | 1 | ||
| 8236 | 214000 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1500 15th Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 21 | 5991559.56782 | 2105079.2538 | 37.7596607475761 | -122.472281478703 | (37.7596607475761, -122.472281478703) | 1 | 8 | 4 | 56 | 12 | ||||
| 8335 | 240290 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 401x Powhattan Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | Width 3ft | 6008169.50136 | 2098124.42294 | 37.7415116381522 | -122.414343705408 | (37.7415116381522, -122.414343705408) | 2 | 7 | 7 | 28859 | 2 | |||
| 8821 | 44140 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 25 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
| 9758 | 46722 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
| 10284 | 262216 | Landmark tree 11 | Quercus agrifolia :: Coast Live Oak 172 | 4124 23rd St | 1 | Back Yard : Yard | Tree | Private 2 | 3x3 | 6002319 | 2102413 | 37.7529566754079 | -122.43487933109 | (37.7529566754079, -122.43487933109) | 2 | 4 | 5 | 28862 | 22 | ||||
| 10645 | 46730 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
| 11645 | 240229 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 10ft | 6006267.81246 | 2095797.32513 | 37.7350149365947 | -122.420753938963 | (37.7350149365947, -122.420753938963) | 2 | 7 | 7 | 28859 | 2 | |||
| 11781 | 240270 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 98 Banks St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6008655 | 2098137 | 37.7415734327052 | -122.412665900326 | (37.7415734327052, -122.412665900326) | 10 | 7 | 7 | 28859 | 2 | ||||
| 11952 | 39952 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 12507 | 240276 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 801X Powhattan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6008927.20227 | 2098089.49395 | 37.7414582651784 | -122.411721357863 | (37.7414582651784, -122.411721357863) | 10 | 7 | 7 | 28859 | 2 | ||||
| 12633 | 39951 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 13101 | 44145 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 29 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
| 13296 | 240275 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 801X Powhattan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | 6008914.92276 | 2098091.07722 | 37.7414619236323 | -122.411763928179 | (37.7414619236323, -122.411763928179) | 10 | 7 | 7 | 28859 | 2 | ||||
| 13394 | 240273 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 801X Powhattan Ave | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | 6008878.25951 | 2098091.29342 | 37.7414604604356 | -122.411890712802 | (37.7414604604356, -122.411890712802) | 10 | 7 | 7 | 28859 | 2 | ||||
| 13419 | 179345 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 96 Alpha St | 5 | Front Yard : Yard | Tree | Private 2 | 1 | 6011048.99338 | 2088244.36018 | 37.7145443783829 | -122.40369233834 | (37.7145443783829, -122.40369233834) | 9 | 7 | 8 | 309 | 39 | ||||
| 13698 | 179341 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 100x Mansell St | 9 | Median : Cutout | Tree | DPW 1 | 11 | Width 0ft | 6011434.85378 | 2090631.08875 | 37.7211193983363 | -122.402526372706 | (37.7211193983363, -122.402526372706) | 10 | 7 | 8 | 309 | 28 | |||
| 14029 | 117209 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 7X CONGO ST | 1 | Median : Cutout | Tree | DPW 1 | 18 | 30x20 | 6000046 | 2093900 | 37.7294526827424 | -122.442128742048 | (37.7294526827424, -122.442128742048) | 9 | 7 | 4 | 63 | 40 | |||
| 14083 | 247836 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 98 Nevada St | 2 | Front Yard : Yard | Tree | Private 2 | 3 | 6009033.20454 | 2098111.94521 | 37.7415258573291 | -122.411356422868 | (37.7415258573291, -122.411356422868) | 10 | 7 | 7 | 28859 | 2 | ||||
| 14339 | 151836 | Landmark tree 11 | Quercus agrifolia :: Coast Live Oak 172 | 20 Rosemont Pl | 2 | Back Yard : Yard | Tree | Private 2 | 0 | Width 3ft | 6005099.05709 | 2108071.10762 | 37.7686499525699 | -122.425668035147 | (37.7686499525699, -122.425668035147) | 8 | 4 | 5 | 28853 | 19 | |||
| 14514 | 264671 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 941 Vallejo St | 14 | Front Yard : Yard | Tree | Private 2 | 11/12/2020 02:25:00 PM | 3 | 6009001.70233 | 2118702.23978 | 37.798060246745 | -122.412920796267 | (37.798060246745, -122.412920796267) | 3 | 1 | 10 | 308 | 21 | |||
| 14549 | 39950 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 14616 | 39953 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 14733 | 255398 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 637 MASONIC AVE | 3 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 0ft | 5999139.3301 | 2110590.1819 | 37.7752281241925 | -122.446463429304 | (37.7752281241925, -122.446463429304) | 15 | 5 | 11 | 29492 | 16 | ||||
| 14736 | 92056 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1001 Potrero Ave | Sidewalk: Property side : Yard | Tree | Private 2 | 06/16/2009 12:00:00 AM | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | ||||
| 14808 | 43442 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 01/05/2016 12:00:00 AM | 14 | Permit Number 774294 | 5999458.08811 | 2091290.64416 | 37.7222544731451 | -122.443973794765 | (37.7222544731451, -122.443973794765) | 9 | 7 | 6 | 28861 | 25 | |
| 14987 | 122372 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 23 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
| 15042 | 240277 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 877 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007991.30005 | 2102784.81683 | 37.7542980236532 | -122.415289699587 | (37.7542980236532, -122.415289699587) | 2 | 4 | 7 | 28859 | 19 | |||
| 15073 | 264670 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 941 Vallejo St | 13 | Front Yard : Yard | Tree | Private 2 | 11/12/2020 02:23:00 PM | 3 | 6009001.70233 | 2118702.23978 | 37.798060246745 | -122.412920796267 | (37.798060246745, -122.412920796267) | 3 | 1 | 10 | 308 | 21 | |||
| 15094 | 43443 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 6 | Permit Number 43162 | 5999469.30626 | 2091283.8759 | 37.7222365289812 | -122.44393453037 | (37.7222365289812, -122.44393453037) | 9 | 7 | 6 | 28861 | 25 | |
| 15159 | 43425 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 310 Seneca Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2000 12:00:00 AM | Permit Number 43161 | 5999253.52417428 | 2090923.87202653 | 37.7212357299628 | -122.444654572182 | (37.7212357299628, -122.444654572182) | 9 | 7 | 6 | 28861 | 25 | |||
| 15301 | 240264 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 400X Powhattan Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6008183.28194 | 2098148.67915 | 37.741579014462 | -122.414297772542 | (37.741579014462, -122.414297772542) | 2 | 7 | 7 | 28859 | 2 | ||||
| 15472 | 46729 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/24/2002 12:00:00 AM | Permit Number 44843 | ||||||||||||||
| 15924 | 260485 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 79 Nevada St | 2 | Front Yard : Yard | Tree | Private 2 | 6009047.04881 | 2098111.66242 | 37.7415258573221 | -122.411308533958 | (37.7415258573221, -122.411308533958) | 10 | 7 | 7 | 28859 | 2 | |||||
| 15999 | 247969 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 20 Joy St | 1 | Front Yard : Yard | Tree | Private 2 | 17 | 6010279.3453 | 2098938.24575 | 37.7438645128489 | -122.407105904041 | (37.7438645128489, -122.407105904041) | 2 | 7 | 7 | 28859 | 2 | ||||
| 16859 | 197195 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1700x Quesada Ave | 52 | Median : Yard | Tree | DPW 1 | 5 | 6014229.96459 | 2095381.00329 | 37.7343173549634 | -122.393196613328 | (37.7343173549634, -122.393196613328) | 10 | 3 | 8 | 58 | 1 | ||||
| 17495 | 39948 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 18184 | 240293 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2956 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6008497.16322 | 2103323.50605 | 37.7558055598955 | -122.413578388654 | (37.7558055598955, -122.413578388654) | 2 | 4 | 7 | 28859 | 19 | |||
| 18259 | 51502 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1828 Egbert Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/13/2005 12:00:00 AM | 6 | Permit Number 47813 | 6012107.99979 | 2092823.48534 | 37.7271768287335 | -122.400353400198 | (37.7271768287335, -122.400353400198) | 10 | 3 | 8 | 58 | 1 | ||
| 18303 | 39949 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 0 Ervine St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1999 12:00:00 AM | Permit Number 41215 | |||||||||||||
| 18370 | 247631 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1021 Jarboe Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6009422.11073 | 2096880.05562 | 37.7381651609976 | -122.409924771417 | (37.7381651609976, -122.409924771417) | 10 | 7 | 7 | 28859 | 2 | ||||
| 18519 | 260473 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 520 Laurel St | 1 | Side Yard : Cutout | Tree | Private 2 | Width 4ft | 5998188 | 2114710 | 37.7864856873194 | -122.450051281182 | (37.7864856873194, -122.450051281182) | 11 | 6 | 1 | 54 | 31 | ||||
| 18562 | 136282 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 941 Vallejo St | 12 | Front Yard : Yard | Tree | Private 2 | 11/12/2020 09:08:00 AM | 3 | 6009001.70233 | 2118702.23978 | 37.798060246745 | -122.412920796267 | (37.798060246745, -122.412920796267) | 3 | 1 | 10 | 308 | 21 | |||
| 18890 | 240309 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 3962 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/17/2020 12:00:00 AM | 3 | Width 3ft | Permit Number 785447 | 6003941.52222 | 2104241.24585 | 37.7580685950116 | -122.429398706289 | (37.7580685950116, -122.429398706289) | 2 | 4 | 5 | 28862 | 3 | |
| 18899 | 261161 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 2452 Green St | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 6001304 | 2118013 | 37.7957326780501 | -122.439507585878 | (37.7957326780501, -122.439507585878) | 13 | 9 | 1 | 57 | 17 | ||||
| 19403 | 197209 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 91 Kiska Rd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6019354.09765 | 2093629.33991 | 37.7297909609772 | -122.375359249432 | (37.7297909609772, -122.375359249432) | 10 | 3 | 8 | 58 | 1 | ||||
| 19946 | 185718 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2101 Sunset Blvd | 50 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5984903.2589 | 2100385.7239 | 37.7463861302867 | -122.494955918818 | (37.7463861302867, -122.494955918818) | 1 | 8 | 3 | 29491 | 35 | |||
| 20150 | 256573 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 145 Castenada Ave | 1 | Front Yard : Cutout | Tree | Private 2 | 3x3 | 5994569 | 2100949 | 37.74849383418 | -122.461573977381 | (37.74849383418, -122.461573977381) | 1 | 8 | 4 | 29491 | 40 | ||||
| 20588 | 197185 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 651 Missouri St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | 6013630.37789 | 2103829.16713 | 37.7574808988518 | -122.395861379221 | (37.7574808988518, -122.395861379221) | 10 | 3 | 8 | 28856 | 29 | ||||
| 20751 | 247952 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 7 Joy St | 5 | Side Yard : Yard | Tree | Private 2 | 6 | 6010434.68219 | 2098863.51365 | 37.7436680064839 | -122.406563517508 | (37.7436680064839, -122.406563517508) | 2 | 7 | 7 | 28859 | 2 | ||||
| 20981 | 197177 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1900 23rd St | 6 | Front Yard : Yard | Tree | Private 2 | 13 | 6012740.29154 | 2102830.02856 | 37.7546879247201 | -122.398869552986 | (37.7546879247201, -122.398869552986) | 10 | 3 | 8 | 28856 | 29 | ||||
| 21634 | 123489 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 600 Arguello Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/17/2018 12:00:00 AM | 3 | 5995672.03179 | 2111788.60232 | 37.7783200198099 | -122.458544293173 | (37.7783200198099, -122.458544293173) | 11 | 6 | 2 | 54 | 16 | |||
| 21952 | 240259 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 2ft | 6005695.76113 | 2097061.18418 | 37.7384529521271 | -122.422821518092 | (37.7384529521271, -122.422821518092) | 2 | 7 | 7 | 28859 | 2 | |||
| 22077 | 49434 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 4746@ COLE 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 03/11/2006 12:00:00 AM | Permit Number 46372 | 5998472.35815921 | 2105699.24121629 | 37.7617607258811 | -122.448418330414 | (37.7617607258811, -122.448418330414) | 15 | 5 | 11 | 29492 | 9 | ||
| 22365 | 43747 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 271 14th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/26/2000 12:00:00 AM | 4 | Permit Number 43383 | 5991501.55503 | 2113612.76885 | 37.7830881153357 | -122.47310444242 | (37.7830881153357, -122.47310444242) | 11 | 6 | 2 | 54 | 26 | |
| 22734 | 52423 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 300 Seneca Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2005 12:00:00 AM | Permit Number 48542 | 5999289.94205438 | 2090904.87008142 | 37.7211856330713 | -122.444527321415 | (37.7211856330713, -122.444527321415) | 9 | 7 | 6 | 28861 | 25 | |||
| 22747 | 240246 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006060.34827 | 2096863.07989 | 37.7379295664827 | -122.42154688469 | (37.7379295664827, -122.42154688469) | 2 | 7 | 7 | 28859 | 2 | |||
| 22894 | 185174 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2500 Sunset Blvd | 26 | Sidewalk: Property side : Yard | Tree | Private 2 | 2 | Width 0ft | 5985128.7096 | 2097775.6475 | 37.7392327606429 | -122.493984021674 | (37.7392327606429, -122.493984021674) | 1 | 8 | 3 | 29491 | 35 | |||
| 22999 | 84117 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 61 Desmond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/05/2008 12:00:00 AM | 8 | 3x3 | Permit Number 50688 | 6010623.58938 | 2086904.22894 | 37.7108408757682 | -122.405068408079 | (37.7108408757682, -122.405068408079) | 9 | 7 | 8 | 309 | 39 | |
| 23217 | 173610 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 344 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3x3 | 6001093 | 2097562 | 37.7395672975157 | -122.438771477593 | (37.7395672975157, -122.438771477593) | 2 | 7 | 5 | 63 | 7 | |||
| 23725 | 52426 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 300 Seneca Ave | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/22/2005 12:00:00 AM | Permit Number 48542 | 5999289.94205438 | 2090904.87008142 | 37.7211856330713 | -122.444527321415 | (37.7211856330713, -122.444527321415) | 9 | 7 | 6 | 28861 | 25 | |||
| 24009 | 43438 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 5 | Permit Number 43162 | 5999550.19859 | 2091242.74615 | 37.7221282101348 | -122.443651952598 | (37.7221282101348, -122.443651952598) | 9 | 7 | 6 | 28861 | 25 | |
| 25431 | 44160 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992085.5284034 | 2088073.73243086 | 37.7129982990606 | -122.469224726443 | (37.7129982990606, -122.469224726443) | 9 | 8 | 6 | 64 | 24 | |||
| 25708 | 122371 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 22 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
| 25855 | 244078 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1768 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5998103.3126 | 2108943.7673 | 37.7706482646329 | -122.449928548475 | (37.7706482646329, -122.449928548475) | 15 | 5 | 11 | 29492 | 9 | |||
| 26215 | 247066 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2401 Castro St | 2 | Front Yard : Yard | Tree | Private 2 | 8 | 6002738.03181 | 2098489.47143 | 37.742207369874 | -122.433149926022 | (37.742207369874, -122.433149926022) | 2 | 7 | 5 | 63 | 22 | ||||
| 26327 | 82822 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 3x3 | Permit Number 52363 | 6015270.56248864 | 2094599.63855582 | 37.7322296399368 | -122.389544348075 | (37.7322296399368, -122.389544348075) | 10 | 3 | 8 | 58 | 1 | ||
| 26330 | 214002 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 618 Detroit St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 10ft | 5999462.37023 | 2095020.82554 | 37.7324969292853 | -122.444226909863 | (37.7324969292853, -122.444226909863) | 9 | 7 | 4 | 63 | 40 | |||
| 26973 | 186271 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1800 Sunset Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 0ft | 5985012.6813 | 2102437.2405 | 37.7520254389338 | -122.494728778892 | (37.7520254389338, -122.494728778892) | 1 | 8 | 3 | 56 | 35 | |||
| 27055 | 110561 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 401x FRANCONIA ST | 1 | Front Yard : Yard | Tree | Private 2 | 05/05/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777241 | 6009999 | 2098658 | 37.7430793263277 | -122.408055517439 | (37.7430793263277, -122.408055517439) | 10 | 7 | 7 | 28859 | 2 | |
| 27134 | 240314 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 310 Liberty St | 46 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 3ft | 6003848.60579 | 2103923.79505 | 37.7571916894697 | -122.429697409823 | (37.7571916894697, -122.429697409823) | 2 | 4 | 5 | 28862 | 3 | |||
| 27209 | 43436 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 16 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999647.97046 | 2091192.04874 | 37.7219945825726 | -122.443310340608 | (37.7219945825726, -122.443310340608) | 9 | 7 | 6 | 28861 | 25 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );