trees
603 rows where qSpecies_id = 172 sorted by qLegalStatus_id
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
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 | |||
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 | |||
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 | ||||
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 | |
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 | |||
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 | ||||
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 | ||||
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 | ||||
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 | |||
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 | |
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 | |
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 | ||||
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 | ||||
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 | ||
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 | ||||
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 | |
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 | |||
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 | |||
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 | |
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 | |||
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 | |
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 | ||||
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 | |||
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 | |
27487 | 90241 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986391.93511 | 2111177.84451 | 37.7761053454235 | -122.490602199432 | (37.7761053454235, -122.490602199432) | 11 | 6 | 2 | 55 | 26 | ||
27628 | 43446 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 1 | Permit Number 43162 | 5999670.6407 | 2091179.60867 | 37.721961717728 | -122.443231082473 | (37.721961717728, -122.443231082473) | 9 | 7 | 6 | 28861 | 25 | |
29268 | 181535 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1300 Sunset Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984891.4503 | 2105792.8068 | 37.7612317968807 | -122.495395459242 | (37.7612317968807, -122.495395459242) | 1 | 8 | 3 | 56 | 35 | |||
29708 | 247953 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 7 Joy St | 6 | Side Yard : Yard | Tree | Private 2 | 10 | 6010438.9217 | 2098856.89307 | 37.7436500649912 | -122.406548391799 | (37.7436500649912, -122.406548391799) | 2 | 7 | 7 | 28859 | 2 | ||||
30190 | 43448 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 21 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 07/18/2000 12:00:00 AM | 9 | Permit Number 43162 | 5999710.3638 | 2091158.16281 | 37.721905097333 | -122.443092230725 | (37.721905097333, -122.443092230725) | 9 | 7 | 6 | 28861 | 25 | |
30203 | 95755 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 260 Madrid St | 6 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003450.90146 | 2092257.04406 | 37.7251349504027 | -122.430240505894 | (37.7251349504027, -122.430240505894) | 9 | 7 | 6 | 28861 | 5 |
30244 | 247948 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 7 Joy St | 1 | Side Yard : Yard | Tree | Private 2 | 13 | 6010393.64964 | 2098873.99577 | 37.7436944924075 | -122.406706137374 | (37.7436944924075, -122.406706137374) | 2 | 7 | 7 | 28859 | 2 | ||||
30357 | 116670 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 100 Esmeralda Ave | 8 | Unaccepted Street : Yard | Tree | DPW 1 | 6006917.38983 | 2098966.37493 | 37.7437530336215 | -122.41873278304 | (37.7437530336215, -122.41873278304) | 2 | 7 | 7 | 28859 | 2 | |||||
30406 | 240234 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 10ft | 6006339.6227 | 2095791.19011 | 37.7350021383438 | -122.420505229653 | (37.7350021383438, -122.420505229653) | 2 | 7 | 7 | 28859 | 2 | |||
31480 | 197172 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 900x Carolina St | 24 | Median : Yard | Tree | DPW 1 | 3 | 6012477.22941 | 2103487.19338 | 37.7564776943092 | -122.39982544149 | (37.7564776943092, -122.39982544149) | 10 | 3 | 8 | 28856 | 29 | ||||
31893 | 240235 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 19 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 10ft | 6006361.75511 | 2095789.26395 | 37.7349980967903 | -122.420428573244 | (37.7349980967903, -122.420428573244) | 2 | 7 | 7 | 28859 | 2 | |||
32249 | 240288 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 3980 22nd St | 2 | : | Tree | Private 2 | 20 | 6001954.91678 | 2102957.6016 | 37.7544313427449 | -122.43617736779 | (37.7544313427449, -122.43617736779) | 2 | 4 | 5 | 28862 | 22 | ||||
32883 | 197205 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 91 Kiska Rd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | 6019275.32859 | 2093678.30312 | 37.7299210694925 | -122.375634959101 | (37.7299210694925, -122.375634959101) | 10 | 3 | 8 | 58 | 1 | ||||
33320 | 186228 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1701 Sunset Blvd | 39 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984813.4188 | 2103368.4703 | 37.7545706737005 | -122.495486523075 | (37.7545706737005, -122.495486523075) | 1 | 8 | 3 | 56 | 35 | |||
33362 | 247610 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 300 Bradford St | 1 | Front Yard : Yard | Tree | Private 2 | 2 | 6009501.25197 | 2096696.3834 | 37.7376652719307 | -122.409638179058 | (37.7376652719307, -122.409638179058) | 10 | 7 | 7 | 28859 | 2 | ||||
33386 | 18939 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2760 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6001611.94448 | 2115686.46462 | 37.7893621369983 | -122.438275289198 | (37.7893621369983, -122.438275289198) | 13 | 6 | 1 | 29490 | 27 | |||
33436 | 179343 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 26 Ervine St | 11 | Front Yard : Yard | Tree | Private 2 | 7 | 6009596.1537 | 2089161.02063 | 37.7169800734552 | -122.408778591782 | (37.7169800734552, -122.408778591782) | 9 | 7 | 8 | 309 | 18 | ||||
33649 | 90242 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986371.9113 | 2111177.50971 | 37.7761032565147 | -122.490671441556 | (37.7761032565147, -122.490671441556) | 11 | 6 | 2 | 55 | 26 | ||
33720 | 184764 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1301 Sunset Blvd | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984675.2613 | 2106104.8671 | 37.7620759662771 | -122.496166178125 | (37.7620759662771, -122.496166178125) | 1 | 8 | 3 | 56 | 35 | |||
34414 | 240245 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6006078.33577 | 2096854.32708 | 37.737906547446 | -122.42148407153 | (37.737906547446, -122.42148407153) | 2 | 7 | 7 | 28859 | 2 | |||
34820 | 240239 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 23 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 10ft | 6006416.61409 | 2095785.43959 | 37.7349906872665 | -122.420238634604 | (37.7349906872665, -122.420238634604) | 2 | 7 | 7 | 28859 | 2 | |||
34942 | 247146 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4100 Cesar Chavez St | 5 | Unaccepted Street : Yard | Tree | Private 2 | 20 | 6003161.19661 | 2100383.74309 | 37.7474325946487 | -122.431821977222 | (37.7474325946487, -122.431821977222) | 2 | 4 | 5 | 63 | 22 | ||||
35171 | 197186 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1800 Illinois St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 4ft | 6016257.1896 | 2100643.95159 | 37.7488807495539 | -122.386554632611 | (37.7488807495539, -122.386554632611) | 10 | 3 | 8 | 58 | 1 | |||
35222 | 248061 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 18 Rutledge St | 3 | Side Yard : Yard | Tree | Private 2 | 9 | 6010675.96291 | 2099385.23379 | 37.7451140326787 | -122.40576596453 | (37.7451140326787, -122.40576596453) | 2 | 7 | 7 | 28859 | 2 | ||||
35806 | 247833 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 88 Nevada St | 2 | Front Yard : Yard | Tree | Private 2 | 7 | 6009033.18663 | 2098163.22314 | 37.7416666542973 | -122.411360106478 | (37.7416666542973, -122.411360106478) | 10 | 7 | 7 | 28859 | 2 | ||||
36046 | 122242 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1628 Lake St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 5ft | 5990370.4799 | 2114772.22238 | 37.7862060986385 | -122.477102214032 | (37.7862060986385, -122.477102214032) | 11 | 6 | 1 | 55 | 33 | |||
36136 | 197192 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 14 | Front Yard : Yard | Tree | Private 2 | 18 | 6015810.17797 | 2099864.72659 | 37.7467164033528 | -122.388046043088 | (37.7467164033528, -122.388046043088) | 3 | 8 | 58 | 1 | |||||
36285 | 95758 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 260 Madrid St | 9 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003422.17585 | 2092210.81209 | 37.7250063806226 | -122.430336510319 | (37.7250063806226, -122.430336510319) | 9 | 7 | 6 | 28861 | 5 |
36291 | 185651 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2100 Sunset Blvd | 32 | Sidewalk: Property side : Yard | Tree | Private 2 | 5 | Width 0ft | 5985060.0587 | 2100520.4285 | 37.7467651702303 | -122.494423659241 | (37.7467651702303, -122.494423659241) | 1 | 8 | 3 | 29491 | 35 | |||
36639 | 197190 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 602 Arthur Ave | 9 | Front Yard : Yard | Tree | Private 2 | 13 | 6015846.29737 | 2099899.92461 | 37.7468150508735 | -122.387923600389 | (37.7468150508735, -122.387923600389) | 3 | 8 | 58 | 1 | |||||
36650 | 197202 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2001 Revere Ave | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | 6012375.40062 | 2096377.97464 | 37.7369516266217 | -122.399678458117 | (37.7369516266217, -122.399678458117) | 10 | 3 | 8 | 58 | 1 | ||||
36674 | 240226 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 10ft | 6006225.25616 | 2095800.40659 | 37.735020998922 | -122.420901290175 | (37.735020998922, -122.420901290175) | 2 | 7 | 7 | 28859 | 2 | |||
37888 | 116374 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 170 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3x3 | 5987438.38703 | 2114824.73848 | 37.7861797499018 | -122.487250214084 | (37.7861797499018, -122.487250214084) | 11 | 6 | 1 | 55 | 33 | |||
38694 | 186265 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1800 Sunset Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5985011.4731 | 2102352.6681 | 37.7517931556361 | -122.494726722368 | (37.7517931556361, -122.494726722368) | 1 | 8 | 3 | 56 | 35 | |||
38698 | 187033 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2501 Sunset Blvd | 52 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984945.4124 | 2097823.2905 | 37.7393528488738 | -122.494621283251 | (37.7393528488738, -122.494621283251) | 1 | 8 | 3 | 29491 | 35 | |||
38894 | 95753 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 260 Madrid St | 4 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003478.85461 | 2092303.36569 | 37.7252637225375 | -122.430147177848 | (37.7252637225375, -122.430147177848) | 9 | 7 | 6 | 28861 | 5 |
39180 | 240303 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4185 25th St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6002751.21968 | 2101207.63188 | 37.7496715504081 | -122.433298511121 | (37.7496715504081, -122.433298511121) | 2 | 4 | 5 | 28862 | 22 | |||
39611 | 46658 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 239 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/19/2002 12:00:00 AM | 12 | Permit Number 44789 | 5988674.72219 | 2113730.06993 | 37.7832461170437 | -122.482892615104 | (37.7832461170437, -122.482892615104) | 11 | 6 | 2 | 55 | 26 |
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) );