trees
603 rows where qSpecies_id = 172 sorted by SiteOrder
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | ||||
51341 | 97051 | Property Tree 8 | Quercus agrifolia :: Coast Live Oak 172 | 795 Wisconsin St | Sidewalk: Property side : Yard | Tree | Private 2 | FUF | 08/19/2011 12:00:00 AM | Permit Number 767554 | 6012787.8 | 2103832.3 | 37.7574425906128 | -122.398775590174 | (37.7574425906128, -122.398775590174) | 10 | 3 | 8 | 28856 | 29 | |||
56664 | 97021 | Property Tree 8 | Quercus agrifolia :: Coast Live Oak 172 | 195B Kiska Rd | Sidewalk: Property side : Cutout | Tree | Housing Authority 15 | FUF | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | 10 | 3 | 8 | 58 | 1 | |||||
88123 | 101366 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 1348 Noe St | Unaccepted Street : Yard | Tree | Private 2 | 24 | Owner: Brent Sommer 519-1119 nocmout@gmail.com | 6003163.2 | 2100416 | 37.7475212781449 | -122.43181735246 | (37.7475212781449, -122.43181735246) | 2 | 4 | 5 | 63 | 22 | ||||
109546 | 96484 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
110019 | 96485 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1101 Eucalyptus Dr | Sidewalk: Property side : Cutout | Tree | SFUSD 4 | FUF | In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City | 5988077.2 | 2094728.1 | 37.7310370666678 | -122.483566221845 | (37.7310370666678, -122.483566221845) | 1 | 8 | 4 | 64 | 14 | ||||
149518 | 109194 | Property Tree 8 | Quercus agrifolia :: Coast Live Oak 172 | 4705 03rd St | Back Yard : Yard | Tree | Arts Commission 19 | 45 | 6015121.6 | 2095617 | 37.7350148477359 | -122.390130397219 | (37.7350148477359, -122.390130397219) | 10 | 3 | 8 | 58 | 1 | |||||
153743 | 86758 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 500 Brotherhood Way | unknown : Yard | Tree | Private 2 | Permit Number 49739 | 5992573.4 | 2087955 | 37.7127004679185 | -122.467529866031 | (37.7127004679185, -122.467529866031) | 9 | 8 | 6 | 64 | 24 | |||||
161427 | 92055 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1001 Potrero Ave | Sidewalk: Property side : Yard | Tree | Private 2 | Permit Number 52180 | 6010509.9 | 2103658.3 | 37.7568376430251 | -122.406641253674 | (37.7568376430251, -122.406641253674) | 10 | 4 | 8 | 28859 | 19 | |||||
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 | |||
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 | ||||
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 | |||
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 | |||||
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 | ||||
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | |||
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 | ||||
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 | |||
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 | |||||||||||||
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 | ||||
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 | ||||
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 | ||||
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 | |
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 | |||
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 | |||
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 | |||
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 | |||
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 | |
28932 | 105444 | Landmark tree 11 | Quercus agrifolia :: Coast Live Oak 172 | 20-28 ROSEMONT PL | 1 | Back Yard : Yard | Tree | Private 2 | 6005075.5 | 2108088.5 | 37.7686963767089 | -122.425750755404 | (37.7686963767089, -122.425750755404) | 8 | 4 | 5 | 28853 | 19 | |||||
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 | ||||
30418 | 43375 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 415 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43123 | 6001833.61881402 | 2103424.63951289 | 37.7557068243023 | -122.436630274867 | (37.7557068243023, -122.436630274867) | 2 | 4 | 5 | 28862 | 22 | ||
31022 | 79408 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 322 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/07/2018 12:00:00 AM | 3 | 4x4 | Permit Number 776851 | 6004758.73696772 | 2101857.84943819 | 37.7515705801104 | -122.426402728229 | (37.7515705801104, -122.426402728229) | 2 | 4 | 5 | 28862 | 22 | |
32109 | 256217 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 159X Brewster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010337 | 2099087 | 37.7442761860016 | -122.406917028766 | (37.7442761860016, -122.406917028766) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
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 | |||
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 | |||
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 | |
42061 | 37896 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1500 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 52539 | 5995914.46450113 | 2094101.71045424 | 37.7297702097563 | -122.45642635192 | (37.7297702097563, -122.45642635192) | 9 | 7 | 4 | 28861 | 40 | ||
45286 | 213997 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1500 16th Ave | 1 | Side Yard : Yard | Tree | Private 2 | 23 | 5991180.77064 | 2105068.88436 | 37.7596103459632 | -122.473590780095 | (37.7596103459632, -122.473590780095) | 1 | 8 | 4 | 56 | 12 | ||||
45313 | 59158 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1514 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/06/1980 12:00:00 AM | 22 | 3x3 | Permit Number 18467 | 6003928.31861537 | 2099451.36110973 | 37.7449159459785 | -122.429102851606 | (37.7449159459785, -122.429102851606) | 2 | 7 | 5 | 63 | 22 | |
45804 | 90968 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4149X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/12/2008 12:00:00 AM | 3 | 3x3 | 5982697.48853 | 2110986.30028 | 37.7753629296515 | -122.503367879459 | (37.7753629296515, -122.503367879459) | 11 | 6 | 2 | 55 | 26 | ||
46105 | 240307 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 362 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6001774.63442 | 2103722.50053 | 37.7565213267127 | -122.43685558343 | (37.7565213267127, -122.43685558343) | 2 | 4 | 5 | 28862 | 3 | |||
46599 | 43461 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1000 Cayuga Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/18/2000 12:00:00 AM | Permit Number 43163 | 6000647.65925572 | 2091203.91791776 | 37.722084128815 | -122.439855525614 | (37.722084128815, -122.439855525614) | 9 | 7 | 6 | 28861 | 25 | |||
46764 | 247825 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 96 Banks St | 1 | Front Yard : Yard | Tree | Private 2 | 11 | 6008677.79642 | 2098169.294 | 37.7416633843669 | -122.412589360112 | (37.7416633843669, -122.412589360112) | 10 | 7 | 7 | 28859 | 2 | ||||
50019 | 214004 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 143 Staples Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | Width 10ft | 5999098.84312 | 2093757.73609 | 37.7290080354696 | -122.445392917756 | (37.7290080354696, -122.445392917756) | 9 | 7 | 4 | 28861 | 40 | |||
51002 | 240326 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 343 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6004069.13295 | 2109034.20183 | 37.7712361239812 | -122.429299145951 | (37.7712361239812, -122.429299145951) | 7 | 9 | 11 | 29492 | 10 | |||
53600 | 247634 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 351 Bradford St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6009494.55377 | 2096596.6066 | 37.7373909310424 | -122.409654297605 | (37.7373909310424, -122.409654297605) | 10 | 7 | 7 | 28859 | 2 | ||||
56895 | 43430 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 310 Seneca Ave | 1 | 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 | |||
59515 | 52864 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 100@ HARRY ST Laidley St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/29/2008 12:00:00 AM | 3x3 | Permit Number 50507 | 6003408.66397097 | 2097802.42500626 | 37.7403589183971 | -122.430782070435 | (37.7403589183971, -122.430782070435) | 2 | 7 | 5 | 63 | 7 | ||
62267 | 247823 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 3565 Folsom St | 1 | Side Yard : Yard | Tree | Private 2 | 28 | 6008531.99478 | 2098373.38247 | 37.7422155824781 | -122.413107922691 | (37.7422155824781, -122.413107922691) | 10 | 7 | 7 | 28859 | 2 | ||||
63896 | 247832 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 88 Nevada St | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 6009025.09178 | 2098164.32129 | 37.7416692155576 | -122.411388173425 | (37.7416692155576, -122.411388173425) | 10 | 7 | 7 | 28859 | 2 | ||||
64317 | 240305 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1239 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6003249.69063 | 2101046.30006 | 37.7492568370432 | -122.431563264742 | (37.7492568370432, -122.431563264742) | 2 | 4 | 5 | 28862 | 22 | |||
65505 | 240287 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4300x 21st St | 1 | Median : Yard | Tree | DPW 1 | 10 | Width 10ft | 6000783.43844 | 2103265.50609 | 37.755210146643 | -122.440250712118 | (37.755210146643, -122.440250712118) | 2 | 4 | 5 | 28862 | 22 | |||
67171 | 53858 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 730 Tennessee St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/03/1972 12:00:00 AM | 6 | Permit Number 9568 | 6015422.25071 | 2105620.89151 | 37.762500112301 | -122.389789458021 | (37.762500112301, -122.389789458021) | 10 | 3 | 8 | 28856 | 29 | ||
69456 | 136274 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 5 Dicha Aly | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 2ft | 5998311.91421 | 2113781.70863 | 37.7839439330129 | -122.449555656482 | (37.7839439330129, -122.449555656482) | 15 | 6 | 1 | 54 | 31 | |||
73557 | 103414 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1490X Plymouth Ave | 1 | Median : Cutout | Tree | Private 2 | 04/18/2013 12:00:00 AM | Permit Number 770026 | 5995919.3 | 2094026.5 | 37.7295639775589 | -122.456404198854 | (37.7295639775589, -122.456404198854) | 9 | 7 | 4 | 28861 | 40 | |||
74417 | 240319 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2253 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6002534.36967 | 2107063.18314 | 37.7657371833392 | -122.434466999375 | (37.7657371833392, -122.434466999375) | 15 | 5 | 5 | 28862 | 3 | |||
77708 | 247065 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2401 Castro St | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 6002733.02117 | 2098501.54815 | 37.7422402455053 | -122.433168113944 | (37.7422402455053, -122.433168113944) | 2 | 7 | 5 | 63 | 22 | ||||
80659 | 116197 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 355x BRADFORD ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6009473 | 2096548 | 37.7372562599827 | -122.409725389456 | (37.7372562599827, -122.409725389456) | 10 | 7 | 7 | 28859 | 2 | |||
82944 | 247899 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 353 Mayflower St | 1 | Side Yard : Yard | Tree | Private 2 | 12 | 6010040.64075 | 2098391.36717 | 37.7423495418983 | -122.407892736173 | (37.7423495418983, -122.407892736173) | 10 | 7 | 7 | 28859 | 2 | ||||
83813 | 240215 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1514 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 2ft | 6003929.64255 | 2099425.82291 | 37.7448458989275 | -122.429096453141 | (37.7448458989275, -122.429096453141) | 2 | 7 | 5 | 63 | 22 | |||
92934 | 46623 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1601 Lane St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52363 | 6015139.1019 | 2094428.6857 | 37.7317529479126 | -122.3899869032 | (37.7317529479126, -122.3899869032) | 10 | 3 | 8 | 58 | 1 | |
97861 | 248043 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 37 Rutledge St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 6010549.4244 | 2099412.1414 | 37.7451808379205 | -122.406205410152 | (37.7451808379205, -122.406205410152) | 2 | 7 | 7 | 28859 | 2 | ||||
97911 | 90236 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2900X Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986564.88308 | 2111184.05617 | 37.7761325015309 | -122.49000439126 | (37.7761325015309, -122.49000439126) | 11 | 6 | 2 | 55 | 26 | ||
98190 | 90273 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4138 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/24/2008 12:00:00 AM | 3 | 3x3 | 5982680.48649 | 2111041.10638 | 37.7755124117331 | -122.50343075165 | (37.7755124117331, -122.50343075165) | 11 | 6 | 2 | 55 | 26 | ||
98671 | 256868 | Planning Code 138.1 required 2 | Quercus agrifolia :: Coast Live Oak 172 | 965 Powhattan Ave | 1 | Side Yard : Yard | Tree | Private 2 | 12/20/2018 12:00:00 AM | 3 | 3x3 | Permit Number 776273 | 6009246.49493 | 2098072.65991 | 37.7414299489627 | -122.410616161073 | (37.7414299489627, -122.410616161073) | 10 | 7 | 7 | 28859 | 2 | |
101728 | 247827 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 97 Banks St | 1 | Front Yard : Yard | Tree | Private 2 | 7 | 6008690.10957 | 2098158.02098 | 37.7416331221736 | -122.412545988525 | (37.7416331221736, -122.412545988525) | 10 | 7 | 7 | 28859 | 2 | ||||
102949 | 117130 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2671 24th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5988936.0754 | 2097168.6937 | 37.7377882614801 | -122.480775587362 | (37.7377882614801, -122.480775587362) | 1 | 8 | 3 | 29491 | 35 | |||
103485 | 200173 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1022 Jamestown Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6013894.556 | 2089735.8088 | 37.7187981510491 | -122.393961193506 | (37.7187981510491, -122.393961193506) | 10 | 3 | 8 | 58 | 1 | |||
103496 | 240216 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 39 Chattanooga St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004715.06571 | 2103431.30025 | 37.7558884396031 | -122.426665784406 | (37.7558884396031, -122.426665784406) | 2 | 4 | 5 | 28862 | 22 | |||
105617 | 240306 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 134 Hancock St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003388.16897 | 2105086.9505 | 37.7603593535203 | -122.431372807229 | (37.7603593535203, -122.431372807229) | 2 | 4 | 5 | 28862 | 3 | |||
109691 | 113439 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 401x POWHATTAN AVE | 1 | Unaccepted Street : Yard | Tree | Private 2 | 20 | 3x3 | 6008174 | 2098184 | 37.7416754763214 | -122.414332364983 | (37.7416754763214, -122.414332364983) | 2 | 7 | 7 | 28859 | 2 | |||
111605 | 118668 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 4240 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5982392.89244 | 2111033.85887 | 37.7754756009165 | -122.504425054608 | (37.7754756009165, -122.504425054608) | 11 | 6 | 2 | 55 | 26 | |||
115893 | 82824 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 1 | 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 | ||
120118 | 240265 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 513 Powhattan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 11 | 6008399.8056 | 2098135.45524 | 37.7415548649644 | -122.413548169632 | (37.7415548649644, -122.413548169632) | 2 | 7 | 7 | 28859 | 2 | ||||
122071 | 136275 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 699 Webster St | 1 | : | Tree | Private 2 | 4 | Width 4ft | 6003966.4578 | 2111069.22256 | 37.7768179785099 | -122.429799478365 | (37.7768179785099, -122.429799478365) | 7 | 9 | 11 | 29492 | 10 | |||
126782 | 52156 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1771 Quesada Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/31/2005 12:00:00 AM | 11 | Permit Number 48348 | 6014341.22767 | 2095259.71993 | 37.733990516147 | -122.392803455827 | (37.733990516147, -122.392803455827) | 10 | 3 | 8 | 58 | 1 | |
126888 | 197203 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 88 05th St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 20 | 6010503.85094 | 2113243.76912 | 37.7831568013875 | -122.407337895824 | (37.7831568013875, -122.407337895824) | 14 | 2 | 9 | 28853 | 34 | ||||
129275 | 240262 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 316 Bocana St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006842.705 | 2097236.16728 | 37.7389980645073 | -122.418868340323 | (37.7389980645073, -122.418868340323) | 2 | 7 | 7 | 28859 | 2 | |||
133309 | 240217 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 116 Crescent Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 10ft | 6006077.44236 | 2095815.28321 | 37.73505351389 | -122.421413392023 | (37.73505351389, -122.421413392023) | 2 | 7 | 7 | 28859 | 2 | |||
134429 | 18936 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2721 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6001590.13521 | 2115636.51425 | 37.7892237457171 | -122.438347166582 | (37.7892237457171, -122.438347166582) | 13 | 6 | 1 | 29490 | 27 | |||
135496 | 136280 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 1080 Vallejo St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | 6008340.68232 | 2118631.36541 | 37.797828516615 | -122.415203104753 | (37.797828516615, -122.415203104753) | 5 | 1 | 10 | 308 | 21 | ||||
139340 | 96616 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2943 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2011 12:00:00 AM | 3 | 3x6 | Permit Number 767742 | 6002898.54873 | 2118761.82237 | 37.7978793705859 | -122.434043718143 | (37.7978793705859, -122.434043718143) | 13 | 9 | 1 | 57 | 17 | |
139974 | 30885 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 248 Dublin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/08/1995 12:00:00 AM | 16 | Permit Number 34717 | 6003986.5052 | 2089044.44729 | 37.7163441880118 | -122.428160134779 | (37.7163441880118, -122.428160134779) | 9 | 7 | 6 | 28861 | 5 | ||
140411 | 90246 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 3020 Balboa St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Cleary Bros. Landscape | 04/21/2008 12:00:00 AM | 3 | 3x3 | 5986239.468923 | 2111161.958067 | 37.7760528187899 | -122.491128444049 | (37.7760528187899, -122.491128444049) | 11 | 6 | 2 | 55 | 26 | |
144961 | 240291 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 2854 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009093.93311 | 2103358.72756 | 37.7559357619427 | -122.411517046282 | (37.7559357619427, -122.411517046282) | 2 | 4 | 7 | 28859 | 19 | |||
145588 | 95750 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 260 Madrid St | 1 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 09/07/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767495 | 6003564.18987 | 2092436.84432 | 37.7256350580097 | -122.429861698861 | (37.7256350580097, -122.429861698861) | 9 | 7 | 6 | 28861 | 5 |
146842 | 247840 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 77 Nevada St | 1 | Front Yard : Yard | Tree | Private 2 | 5 | 6009043.26333 | 2098169.73656 | 37.7416851038897 | -122.41132572452 | (37.7416851038897, -122.41132572452) | 10 | 7 | 7 | 28859 | 2 |
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) );