891 rows where qSpecies_id = 75 sorted by qSpecies_id

View and edit SQL

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)
216 114440 DPW Maintained 1 Acer rubrum :: Red Maple 75 2961 SAN BRUNO AVE 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011605 2091859 37.724500488626 -122.402024501601 (37.724500488626, -122.402024501601) 10 3 7 309 28
353 112597 DPW Maintained 1 Acer rubrum :: Red Maple 75 1200X Divisadero St 7 Median : Cutout Tree DPW 1     3 3x3   6001322.3986 2112740.3429 37.7812563699828 -122.439065850543 (37.7812563699828, -122.439065850543) 15 5 11 29490 41
366 141325 DPW Maintained 1 Acer rubrum :: Red Maple 75 600x DIVISADERO ST 2 Median : Cutout Tree DPW 1     3 Width 0ft   6001625.7293 2110577.6985 37.775335548851 -122.437861533023 (37.775335548851, -122.437861533023) 15 5 11 29492 10
399 137749 DPW Maintained 1 Acer rubrum :: Red Maple 75 1000x DIVISADERO ST 8 Median : Cutout Tree DPW 1     3 Width 0ft   6001417.6643 2112072.2982 37.7794275088949 -122.438688395719 (37.7794275088949, -122.438688395719) 15 5 11 29490 41
409 187885 DPW Maintained 1 Acer rubrum :: Red Maple 75 1600 Indiana St 23 : Tree Private 2     3 Width 3ft   6015152.38977 2100397.43257 37.748142637288 -122.390357841268 (37.748142637288, -122.390357841268) 10 3 8 58 1
456 247507 DPW Maintained 1 Acer rubrum :: Red Maple 75 400x Divisadero St 2 Median : Cutout Tree DPW 1     3 Width 0ft   6001724.6395 2109878.2699 37.7734207168265 -122.437469283257 (37.7734207168265, -122.437469283257) 15 5 11 29492 10
544 259763 DPW Maintained 1 Acer rubrum :: Red Maple 75 2701 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/12/2019 12:00:00 AM 3                        
710 256206 DPW Maintained 1 Acer rubrum :: Red Maple 75 800 Broadway 11 Median : Cutout Tree DPW 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
775 584 DPW Maintained 1 Acer rubrum :: Red Maple 75 3035 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/20/2019 10:48:00 AM 3 4x4   6008750.98529 2102125.48957 37.7525303261177 -122.412615900926 (37.7525303261177, -122.412615900926) 2 4 7 28859 19
1240 860 DPW Maintained 1 Acer rubrum :: Red Maple 75 400X Alemany Blvd 6 Sidewalk: Curb side : Cutout Tree Private 2   11/30/2003 12:00:00 AM 9 3x3   6008061.902 2095033.66744 37.7330190549875 -122.414497094675 (37.7330190549875, -122.414497094675) 2 7 7 28859 2
1348 261327 DPW Maintained 1 Acer rubrum :: Red Maple 75 800 Broadway 12 Median : Cutout Tree DPW 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
1468 261333 DPW Maintained 1 Acer rubrum :: Red Maple 75 831 Broadway 6 Median : Cutout Tree DPW 1       3x3   6009625 2118347 37.7971198129045 -122.410738895692 (37.7971198129045, -122.410738895692) 3 1 10 308 4
1480 81721 DPW Maintained 1 Acer rubrum :: Red Maple 75 998 Indiana St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6014944.54926 2104094.31483 37.7582819600733 -122.391334945673 (37.7582819600733, -122.391334945673) 10 3 8 28856 29
1770 122656 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Hickory St 12 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3x3                      
2135 187956 DPW Maintained 1 Acer rubrum :: Red Maple 75 340 Fremont St 7 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6014829.80215 2114536.31276 37.7869469986487 -122.392462171218 (37.7869469986487, -122.392462171218) 6 2 9 28855 6
2474 256556 Property Tree 8 Acer rubrum :: Red Maple 75 3401X 16th St 5 Side Yard : Yard Tree SFUSD 4   02/08/2019 09:18:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
2867 8251 DPW Maintained 1 Acer rubrum :: Red Maple 75 1515 Galvez Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/12/2014 12:00:00 AM 3 3x3   6016234 2097322 37.7397580688138 -122.386403238688 (37.7397580688138, -122.386403238688) 10 3 8 58 1
3170 38792 DPW Maintained 1 Acer rubrum :: Red Maple 75 655 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/26/2001 12:00:00 AM 3   Permit Number 43810 6012704.44378 2111400.47389 37.7782184558633 -122.399595224034 (37.7782184558633, -122.399595224034) 6 2 9 28856 34
3351 81717 DPW Maintained 1 Acer rubrum :: Red Maple 75 998 Indiana St 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6014951.75745 2104011.46368 37.7580548686454 -122.391304224825 (37.7580548686454, -122.391304224825) 10 3 8 28856 29
3977 262296 Section 806 (d) 5 Acer rubrum :: Red Maple 75 45 Alma St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/26/2020 12:00:00 AM 3 3x3 Permit Number 782635 5998403.0154 2106238.4273 37.7632372305534 -122.448696994498 (37.7632372305534, -122.448696994498) 15 5 11 29492 9
5294 8118 DPW Maintained 1 Acer rubrum :: Red Maple 75 841 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/15/2005 12:00:00 AM 3 3X3   6003718.373 2111409.0283 37.7777369494126 -122.430681932079 (37.7777369494126, -122.430681932079) 7 9 11 29492 10
5375 175141 DPW Maintained 1 Acer rubrum :: Red Maple 75 199 Hamilton St 2 Sidewalk: Property side : Yard Tree Private 2     3 Width 10ft   6009144.52669 2093573.47642 37.7290704439367 -122.410651080984 (37.7290704439367, -122.410651080984) 9 3 7 309 28
5464 66327 DPW Maintained 1 Acer rubrum :: Red Maple 75 1231 29th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/05/1990 12:00:00 AM 4   Permit Number 29446 5987052.1054 2106857.6987 37.7642819711606 -122.488001017639 (37.7642819711606, -122.488001017639) 1 8 3 56 35
5536 122646 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Hickory St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3x3                      
5835 118375 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 4x6   6014712.48727 2114662.02755 37.7872856671566 -122.392876855803 (37.7872856671566, -122.392876855803) 6 2 9 28855 6
5868 261332 DPW Maintained 1 Acer rubrum :: Red Maple 75 831 Broadway 5 Median : Cutout Tree DPW 1       3x3   6009625 2118347 37.7971198129045 -122.410738895692 (37.7971198129045, -122.410738895692) 3 1 10 308 4
6100 141590 DPW Maintained 1 Acer rubrum :: Red Maple 75 700x DIVISADERO ST 6 Median : Cutout Tree DPW 1     2 Width 0ft   6001558.8965 2111018.1096 37.7765410064467 -122.438124278141 (37.7765410064467, -122.438124278141) 15 5 11 29492 10
6429 84888 Permitted Site 7 Acer rubrum :: Red Maple 75 1699X Valencia St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/27/2007 12:00:00 AM 3 3x3 Permit No. 49257 6006643 2099756 37.7459057132351 -122.419737575743 (37.7459057132351, -122.419737575743) 2 7 7 28859 2
6716 208999 DPW Maintained 1 Acer rubrum :: Red Maple 75 10 Yerba Buena Ave 4 Sidewalk: Curb side : Yard Tree Private 2     33 Width 4ft   5993404.32279 2097201.32336 37.7381365526709 -122.465329186907 (37.7381365526709, -122.465329186907) 1 8 4 59 40
6991 112084 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 99X Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/23/2015 12:00:00 AM     Permit Number 775592 6013631.8 2115864.7 37.7905278405438 -122.396700174955 (37.7905278405438, -122.396700174955) 12 2 9 28855 6
7657 261508 DPW Maintained 1 Acer rubrum :: Red Maple 75 2415X San Bruno Ave 1 Sidewalk: Property side : Cutout Tree DPW 1   01/15/2020 12:00:00 AM 3 3x3   6010698 2094549 37.7318360017619 -122.405349245342 (37.7318360017619, -122.405349245342) 10 3 7 309 28
7971 122653 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Hickory St 9 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3x3                      
8221 122657 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Hickory St 13 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3x3                      
8638 116994 Undocumented 4 Acer rubrum :: Red Maple 75 600M Divisadero St 1 Median : Cutout Tree DPW 1     3     6001630.0135 2110553.7073 37.7752699186497 -122.43784499429 (37.7752699186497, -122.43784499429) 15 5 11 29492 10
8771 3468 DPW Maintained 1 Acer rubrum :: Red Maple 75 3231 24th St 1 Sidewalk: Curb side : Cutout Tree DPW 1   03/20/2019 10:37:00 AM 3 4x4   6007477.09692 2102052.55322 37.752258481762 -122.417016067856 (37.752258481762, -122.417016067856) 2 4 7 28859 19
9269 71335 DPW Maintained 1 Acer rubrum :: Red Maple 75 277 Shipley St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   1     6011311.01378 2111537.1063 37.7785158463684 -122.404425254319 (37.7785158463684, -122.404425254319) 14 2 9 28856 34
9298 141986 DPW Maintained 1 Acer rubrum :: Red Maple 75 1067 MCALLISTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6004102.6078 2111812.2185 37.7788657708335 -122.429381491168 (37.7788657708335, -122.429381491168) 7 9 11 29490 41
9549 189101 DPW Maintained 1 Acer rubrum :: Red Maple 75 1444 Galvez Ave 10 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6015952.01721 2097639.00089 37.7406128754775 -122.387400332559 (37.7406128754775, -122.387400332559) 10 3 8 58 1
9905 187906 DPW Maintained 1 Acer rubrum :: Red Maple 75 167 Jessie St 4 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6011990.7752 2114556.67649 37.7868448464448 -122.402286048678 (37.7868448464448, -122.402286048678) 12 2 9 28855 6
10505 122650 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Hickory St 6 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3x3                      
10703 254081 DPW Maintained 1 Acer rubrum :: Red Maple 75 1525 Bryant St 6 Sidewalk: Curb side : Cutout Tree Private 2       Width 3ft   6009448.22373 2107633.16245 37.7676922528232 -122.410593622391 (37.7676922528232, -122.410593622391) 8 4 8 28853 19
11352 73737 DPW Maintained 1 Acer rubrum :: Red Maple 75 595 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   3     6013232.29052 2111907.2745 37.7796394233505 -122.397804754791 (37.7796394233505, -122.397804754791) 6 2 9 28856 34
11468 2384 DPW Maintained 1 Acer rubrum :: Red Maple 75 2603 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/02/2005 12:00:00 AM 3 4X4   6009796.77853 2102081.51983 37.7524682333455 -122.408996251977 (37.7524682333455, -122.408996251977) 2 4 7 28859 19
11492 187952 DPW Maintained 1 Acer rubrum :: Red Maple 75 340 Fremont St 3 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6014738.2491 2114633.83833 37.7872096969197 -122.392785751786 (37.7872096969197, -122.392785751786) 6 2 9 28855 6
11819 122647 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Hickory St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3x3                      
12330 259764 DPW Maintained 1 Acer rubrum :: Red Maple 75 2701 24th St 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/12/2019 12:00:00 AM 3                        
12580 122655 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Hickory St 11 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3x3                      
12995 81719 DPW Maintained 1 Acer rubrum :: Red Maple 75 998 Indiana St 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6014948.61072 2104053.54358 37.7581702363807 -122.391318049186 (37.7581702363807, -122.391318049186) 10 3 8 28856 29
13152 122648 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Hickory St 4 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3x3                      
13200 261509 DPW Maintained 1 Acer rubrum :: Red Maple 75 2706 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/15/2020 12:00:00 AM 3 4x4   6011147 2092931 37.7274184054289 -122.403683147496 (37.7274184054289, -122.403683147496) 10 3 7 309 28
13368 122658 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Hickory St 14 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3x3                      
13427 208966 DPW Maintained 1 Acer rubrum :: Red Maple 75 44 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2   07/17/2018 12:00:00 AM 3 Width 6ft Permit Number 781880 5993637 2097007 37.7376164050624 -122.464510605988 (37.7376164050624, -122.464510605988) 1 8 4 59 40
13486 122649 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Hickory St 5 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3x3                      
13737 81723 DPW Maintained 1 Acer rubrum :: Red Maple 75 998 Indiana St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   4     6014945.42498 2104137.64024 37.7584009709475 -122.391334945662 (37.7584009709475, -122.391334945662) 10 3 8 28856 29
14226 122645 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Hickory St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3x3                      
14297 261510 DPW Maintained 1 Acer rubrum :: Red Maple 75 2706 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   01/15/2020 12:00:00 AM 3 4x4   6011147 2092931 37.7274184054289 -122.403683147496 (37.7274184054289, -122.403683147496) 10 3 7 309 28
14316 256204 DPW Maintained 1 Acer rubrum :: Red Maple 75 800 Broadway 9 Median : Cutout Tree DPW 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
14390 122652 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Hickory St 8 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3x3                      
14551 72302 DPW Maintained 1 Acer rubrum :: Red Maple 75 595 Bryant St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   5     6013261.50947 2111935.00833 37.7797172012305 -122.397705618927 (37.7797172012305, -122.397705618927) 6 2 9 28856 34
15420 220483 DPW Maintained 1 Acer rubrum :: Red Maple 75 3135 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6008148.36276 2102088.69137 37.7523954467163 -122.414697274784 (37.7523954467163, -122.414697274784) 2 4 7 28859 19
15425 256202 DPW Maintained 1 Acer rubrum :: Red Maple 75 800 Broadway 7 Median : Cutout Tree DPW 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
15677 255256 Undocumented 4 Acer rubrum :: Red Maple 75 240 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree Private 2   04/27/2018 12:00:00 AM 3 3x3   6012609 2118531 37.797791888474 -122.400426386373 (37.797791888474, -122.400426386373) 3 1 10 28860 6
15780 220419 DPW Maintained 1 Acer rubrum :: Red Maple 75 1601 Bryant St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009469.46402 2107213.18669 37.7665402869247 -122.410490495353 (37.7665402869247, -122.410490495353) 8 4 8 28853 19
16082 122660 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Hickory St 16 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3x3                      
16448 253390 DPW Maintained 1 Acer rubrum :: Red Maple 75 2529x Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/29/2017 12:00:00 AM 3 3x3                      
16780 85805 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011627 2111882 37.7794804977568 -122.403356401218 (37.7794804977568, -122.403356401218) 14 2 9 28856 34
17021 53357 DPW Maintained 1 Acer rubrum :: Red Maple 75 333 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/19/1969 12:00:00 AM 3   Permit Number 6250 6014738.31742 2114732.62752 37.7874809531407 -122.392792429224 (37.7874809531407, -122.392792429224) 6 2 9 28855 6
17046 189066 DPW Maintained 1 Acer rubrum :: Red Maple 75 521 Bryant St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6013735.14278 2112387.07191 37.7809848280366 -122.396098793052 (37.7809848280366, -122.396098793052) 6 2 9 28856 34
17288 87548 DPW Maintained 1 Acer rubrum :: Red Maple 75 2809 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   11/19/2015 12:00:00 AM 3 3x3   6011363.6591 2092480.1221 37.7261924887101 -122.402902454386 (37.7261924887101, -122.402902454386) 10 3 7 309 28
17345 261328 DPW Maintained 1 Acer rubrum :: Red Maple 75 831 Broadway 1 Median : Cutout Tree DPW 1       3x3   6009625 2118347 37.7971198129045 -122.410738895692 (37.7971198129045, -122.410738895692) 3 1 10 308 4
17355 258161 DPW Maintained 1 Acer rubrum :: Red Maple 75 335 08th St 1 Sidewalk: Curb side : Cutout Tree DPW 1 FUF   3     6009797.86626 2110165.76552 37.7746657903123 -122.409563015883 (37.7746657903123, -122.409563015883) 8 2 9 28853 34
17501 251213 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 6 Sidewalk: Curb side : Cutout Tree Private 2   04/05/2017 12:00:00 AM 3 2.5x6 Permit Number 778048 6011604 2111950 37.7796659253507 -122.403440753721 (37.7796659253507, -122.403440753721) 14 2 9 28856 34
17571 122654 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Hickory St 10 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3x3                      
17628 243500 DPW Maintained 1 Acer rubrum :: Red Maple 75 957 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/14/2017 12:00:00 AM 3 3x3 Permit Number 773003 6009168.25876 2103593.36659 37.7565841965306 -122.411276577455 (37.7565841965306, -122.411276577455) 2 4 7 28859 19
17637 187932 DPW Maintained 1 Acer rubrum :: Red Maple 75 211 Spear St 3 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6015226.56568 2115767.07954 37.7903484270771 -122.391175510261 (37.7903484270771, -122.391175510261) 6 2 9 28855 6
17771 122651 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Hickory St 7 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3x3                      
17800 122661 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Hickory St 17 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3x3                      
17808 114441 DPW Maintained 1 Acer rubrum :: Red Maple 75 2809 SAN BRUNO AVE 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6011711 2091301 37.7229742506471 -122.401618870695 (37.7229742506471, -122.401618870695) 10 3 7 309 28
17833 261334 DPW Maintained 1 Acer rubrum :: Red Maple 75 831 Broadway 7 Median : Cutout Tree DPW 1       3x3   6009625 2118347 37.7971198129045 -122.410738895692 (37.7971198129045, -122.410738895692) 3 1 10 308 4
18211 49144 Permitted Site 7 Acer rubrum :: Red Maple 75 206 Lobos St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/21/2003 12:00:00 AM     Permit Number 46269 5994953.84956095 2088734.37736924 37.7149776031797 -122.459358738579 (37.7149776031797, -122.459358738579) 9 8 6 28861 24
18300 24863 DPW Maintained 1 Acer rubrum :: Red Maple 75 2636 San Bruno Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/11/2015 12:00:00 AM 5 4x4   6011074.2033 2093259.325 37.7283158506885 -122.40395790213 (37.7283158506885, -122.40395790213) 10 3 7 309 28
18374 122659 DPW Maintained 1 Acer rubrum :: Red Maple 75 300x Hickory St 15 Sidewalk: Curb side : Cutout Tree Private 2   11/10/2016 12:00:00 AM 3 3x3                      
18632 141321 DPW Maintained 1 Acer rubrum :: Red Maple 75 600x DIVISADERO ST 7 Median : Cutout Tree DPW 1     3 Width 0ft   6001606.879 2110711.3642 37.7757014893927 -122.437936316665 (37.7757014893927, -122.437936316665) 15 5 11 29492 10
18758 112591 DPW Maintained 1 Acer rubrum :: Red Maple 75 1200X Divisadero St 1 Median : Cutout Tree DPW 1     4 3x3   6001352.6873 2112575.8699 37.7808064923129 -122.438949276348 (37.7808064923129, -122.438949276348) 15 5 11 29490 41
19089 203401 DPW Maintained 1 Acer rubrum :: Red Maple 75 24 Yerba Buena Ave 1 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   5993518.80789 2097119.92672 37.7379196595754 -122.464927448042 (37.7379196595754, -122.464927448042) 1 8 4 59 40
19278 261329 DPW Maintained 1 Acer rubrum :: Red Maple 75 831 Broadway 2 Median : Cutout Tree DPW 1       3x3   6009625 2118347 37.7971198129045 -122.410738895692 (37.7971198129045, -122.410738895692) 3 1 10 308 4
19345 101991 Permitted Site 7 Acer rubrum :: Red Maple 75 25 Essex St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014029.63843 2114247.91899 37.7861106686205 -122.395210367086 (37.7861106686205, -122.395210367086) 6 2 9 28855 6
19606 261330 DPW Maintained 1 Acer rubrum :: Red Maple 75 831 Broadway 3 Median : Cutout Tree DPW 1       3x3   6009625 2118347 37.7971198129045 -122.410738895692 (37.7971198129045, -122.410738895692) 3 1 10 308 4
19613 187949 DPW Maintained 1 Acer rubrum :: Red Maple 75 302 Main St 2 Sidewalk: Curb side : Yard Tree Private 2     1     6015269.3196 2115112.5908 37.7885537238177 -122.390981820563 (37.7885537238177, -122.390981820563) 6 2 9 28855 6
19741 256203 DPW Maintained 1 Acer rubrum :: Red Maple 75 800 Broadway 8 Median : Cutout Tree DPW 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
20249 220440 DPW Maintained 1 Acer rubrum :: Red Maple 75 2831 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009868.71469 2100872.67042 37.7491530301063 -122.408662212302 (37.7491530301063, -122.408662212302) 2 4 7 28859 19
20764 108061 DPW Maintained 1 Acer rubrum :: Red Maple 75 333 Fremont St 3 Sidewalk: Curb side : Cutout Tree Private 2   11/19/2014 12:00:00 AM 3   Permit Number 770030 6014711.31667 2114762.04187 37.7875602184789 -122.392887905777 (37.7875602184789, -122.392887905777) 6 2 9 28855 6
20904 189063 DPW Maintained 1 Acer rubrum :: Red Maple 75 670 08th St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6011103.55748 2108718.67114 37.7707654781809 -122.40494443566 (37.7707654781809, -122.40494443566) 14 2 9 28853 34
21214 87528 DPW Maintained 1 Acer rubrum :: Red Maple 75 2684 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/10/2012 12:00:00 AM 3 4x4   6011133.0386 2093058.8298 37.7277686195559 -122.403740403083 (37.7277686195559, -122.403740403083) 10 3 7 309 28
21266 187936 DPW Maintained 1 Acer rubrum :: Red Maple 75 255 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6014368.82149 2115126.24847 37.7885412160406 -122.394098386929 (37.7885412160406, -122.394098386929) 6 2 9 28855 6
21732 121544 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 5 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
22052 115353 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014819.91687 2114646.31579 37.7872484927813 -122.39250406973 (37.7872484927813, -122.39250406973) 6 2 9 28855 6
22294 112595 DPW Maintained 1 Acer rubrum :: Red Maple 75 1200X Divisadero St 5 Median : Cutout Tree DPW 1     3 3x3   6001326.7981 2112711.2386 37.7811767073085 -122.439048543991 (37.7811767073085, -122.439048543991) 15 5 11 29490 41
22594 137765 DPW Maintained 1 Acer rubrum :: Red Maple 75 900x DIVISADERO ST 8 Median : Cutout Tree DPW 1     3 Width 0ft   6001461.6592 2111740.6449 37.7785193755481 -122.438512430085 (37.7785193755481, -122.438512430085) 15 5 11 29490 41
22984 92756 Permitted Site 7 Acer rubrum :: Red Maple 75 528 Carter St   Front Yard : Yard Tree Private 2   10/09/2009 12:00:00 AM     Permit Number 52985 6005271.9 2086340.9 37.708993467942 -122.423525081608 (37.708993467942, -122.423525081608) 9 7 8 309 5

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

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)
);