trees
603 rows where qSpecies_id = 172 sorted by DBH
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 | |||||||||||||
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 | ||||
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 | ||||||||||||||
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 | |||||
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 | |||||||||||||
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 | |||||||||||||
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 | ||||||||||||||
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 | |||||||||||||
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 | |||
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 | ||||
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 | ||||
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 | |||
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 | |||||
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 | |||||||||||||
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 | ||||
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 | ||
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 | |||
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 | |||
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 | ||||
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 | ||
28236 | 44161 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 4 | 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 | |||
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 | |||||
29969 | 44147 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 22 | 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 | |||
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 | |||||
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 | ||
31036 | 82818 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 7 | 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 | ||
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 | ||||
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 | ||
43750 | 253165 | Significant Tree 6 | Quercus agrifolia :: Coast Live Oak 172 | 1451 Bay St | 3 | Front Yard : Yard | Tree | Private 2 | 3x3 | 6003691 | 2120547 | 37.8028259466608 | -122.431429119577 | (37.8028259466608, -122.431429119577) | 13 | 9 | 1 | 57 | 17 | ||||
43981 | 52425 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 300 Seneca Ave | 4 | 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 | |||
44586 | 122351 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
45451 | 88773 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 461 Baker St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2008 12:00:00 AM | 3x3 | Permit Number 51690 | 6000624 | 2110522 | 37.7751256013752 | -122.441322740074 | (37.7751256013752, -122.441322740074) | 15 | 5 | 11 | 29492 | 16 | ||
46360 | 44142 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 26 | 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 | |||
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 | |||
47338 | 99497 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1400X Plymouth Ave | 4 | Median : Cutout | Tree | Private 2 | 5995903 | 2093347.3 | 37.7276981218086 | -122.45641145576 | (37.7276981218086, -122.45641145576) | 9 | 7 | 4 | 28861 | 40 | |||||
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 | |||
52164 | 122364 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 15 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
53513 | 42689 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 2500 Larkin St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42711 | 6006694.5506046 | 2119774.0082852 | 37.8008732765742 | -122.420980361587 | (37.8008732765742, -122.420980361587) | 5 | 9 | 1 | 28858 | 32 | |||
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 | |||||
56774 | 122370 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 21 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 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 | |||
56944 | 44139 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 21 | 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 | |||
58217 | 44153 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 10 | 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 | |||
58477 | 122359 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||
61391 | 122357 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
61916 | 44157 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 6 | 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 | |||
64134 | 52424 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 300 Seneca Ave | 3 | 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 | |||
65745 | 43431 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 310 Seneca Ave | 2 | 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 | |||
66368 | 82820 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 5 | 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 | ||
67633 | 111097 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 SAINT CHARLES AVE | 32 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5992079 | 2088073 | 37.7129959107362 | -122.469247237289 | (37.7129959107362, -122.469247237289) | 9 | 8 | 6 | 64 | 24 | |||||
69210 | 43463 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1000 Cayuga Ave | 3 | 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 | |||
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 | |||
75706 | 82819 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1595X Quesada Ave | 6 | 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 | ||
79021 | 111446 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 36 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | ||||
83096 | 109209 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 2401x CASTRO ST | 5 | Median : Yard | Tree | DPW 1 | 6002698 | 2098487 | 37.7421983129634 | -122.433288166914 | (37.7421983129634, -122.433288166914) | 2 | 7 | 5 | 63 | 7 | |||||
83216 | 111448 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 241 Oneida Ave | 38 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | SFUSD | 6x7 | 5999776.65760108 | 2091115.95638647 | 37.72179298789 | -122.442860041334 | (37.72179298789, -122.442860041334) | 9 | 7 | 6 | 28861 | 25 | |||
84319 | 254441 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 501X Brotherhood Way | 19 | Median : Yard | Tree | DPW 1 | 10x10 | 5992686 | 2087818 | 37.7123307991194 | -122.467130733446 | (37.7123307991194, -122.467130733446) | 9 | 8 | 4 | 64 | 24 | ||||
84814 | 88772 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 461 Baker St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/26/2008 12:00:00 AM | 3x3 | Permit Number 51690 | 6000624 | 2110522 | 37.7751256013752 | -122.441322740074 | (37.7751256013752, -122.441322740074) | 15 | 5 | 11 | 29492 | 16 | ||
88785 | 42687 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 2500 Larkin St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | 3x3 | Permit Number 42711 | 6006694.5506046 | 2119774.0082852 | 37.8008732765742 | -122.420980361587 | (37.8008732765742, -122.420980361587) | 5 | 9 | 1 | 28858 | 32 | ||
92482 | 44151 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 3 | 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 | |||
93435 | 122493 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 69x Bonview St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6007716 | 2099172 | 37.7443625662885 | -122.415985930063 | (37.7443625662885, -122.415985930063) | 2 | 7 | 7 | 28859 | 2 | ||||
93951 | 44137 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 19 | 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 | |||
94122 | 43422 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 310 Seneca Ave | 10 | 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 | |||
97885 | 122356 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
105791 | 44144 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 28 | 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 | |||
108187 | 43469 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1000 Cayuga Ave | 4 | 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 | |||
109347 | 122352 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | ||||
109566 | 43462 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 1000 Cayuga Ave | 2 | 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 | |||
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 | ||||
110651 | 44146 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 SAINT CHARLES AVE | 30 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/08/2000 12:00:00 AM | Permit Number 43634 | 5992079 | 2088073 | 37.7129959107362 | -122.469247237289 | (37.7129959107362, -122.469247237289) | 9 | 8 | 6 | 64 | 24 | |||
112251 | 44156 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 7 | 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 | |||
115779 | 43423 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 310 Seneca Ave | 9 | 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 | |||
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 | ||
117464 | 43421 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 310 Seneca Ave | 11 | 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 | |||
120359 | 43429 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 310 Seneca Ave | 3 | 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 | |||
122635 | 96583 | DPW Maintained 1 | Quercus agrifolia :: Coast Live Oak 172 | 401x Otsego Ave | 2 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3x3 | 6000208.5 | 2091425.4 | 37.7226672598955 | -122.441389471398 | (37.7226672598955, -122.441389471398) | 9 | 7 | 6 | 28861 | 25 | ||||
127752 | 44138 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 20 | 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 | |||
130307 | 122365 | Undocumented 4 | Quercus agrifolia :: Coast Live Oak 172 | 155 Appleton Ave | 16 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006071 | 2097171 | 37.7387756468895 | -122.421531918974 | (37.7387756468895, -122.421531918974) | 2 | 7 | 7 | 28859 | 2 | ||||
132396 | 44148 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 67 Saint Charles Ave | 23 | 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 | |||
138725 | 42690 | Permitted Site 7 | Quercus agrifolia :: Coast Live Oak 172 | 2500 Larkin St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/26/2000 12:00:00 AM | Permit Number 42711 | 6006694.5506046 | 2119774.0082852 | 37.8008732765742 | -122.420980361587 | (37.8008732765742, -122.420980361587) | 5 | 9 | 1 | 28858 | 32 |
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) );