891 rows where qSpecies_id = 75 sorted by Police Districts

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)
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                        
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                      
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                      
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                      
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                      
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                      
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                      
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                      
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                      
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                      
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                      
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                      
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                      
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                      
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                      
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
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
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
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
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
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
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
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
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
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
26828 255255 Undocumented 4 Acer rubrum :: Red Maple 75 240 Pacific Ave 2 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
27184 256213 DPW Maintained 1 Acer rubrum :: Red Maple 75 837 Broadway 7 Median : Cutout Tree DPW 1       3x3   6009431 2118388 37.7972215096833 -122.411413084134 (37.7972215096833, -122.411413084134) 3 1 10 308 4
34523 142929 DPW Maintained 1 Acer rubrum :: Red Maple 75 591 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6010700.0761 2118912.2456 37.7987320586367 -122.407058711866 (37.7987320586367, -122.407058711866) 3 1 10 308 23
47368 256212 DPW Maintained 1 Acer rubrum :: Red Maple 75 837 Broadway 6 Median : Cutout Tree DPW 1       3x3   6009431 2118388 37.7972215096833 -122.411413084134 (37.7972215096833, -122.411413084134) 3 1 10 308 4
50976 256196 DPW Maintained 1 Acer rubrum :: Red Maple 75 800 Broadway 1 Median : Cutout Tree DPW 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
67000 255258 Undocumented 4 Acer rubrum :: Red Maple 75 720 Battery St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/27/2018 12:00:00 AM 3 3x3   6012486 2118560 37.7978646555778 -122.400854041686 (37.7978646555778, -122.400854041686) 3 1 10 28860 6
70440 256199 DPW Maintained 1 Acer rubrum :: Red Maple 75 800 Broadway 4 Median : Cutout Tree DPW 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
75008 255259 Undocumented 4 Acer rubrum :: Red Maple 75 720 Battery St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/27/2018 12:00:00 AM 3 3x3   6012486 2118560 37.7978646555778 -122.400854041686 (37.7978646555778, -122.400854041686) 3 1 10 28860 6
80253 256209 DPW Maintained 1 Acer rubrum :: Red Maple 75 837 Broadway 3 Median : Cutout Tree DPW 1       3x3   6009431 2118388 37.7972215096833 -122.411413084134 (37.7972215096833, -122.411413084134) 3 1 10 308 4
107446 256207 DPW Maintained 1 Acer rubrum :: Red Maple 75 837 Broadway 1 Median : Cutout Tree DPW 1       3x3   6009431 2118388 37.7972215096833 -122.411413084134 (37.7972215096833, -122.411413084134) 3 1 10 308 4
108077 255257 Undocumented 4 Acer rubrum :: Red Maple 75 240 Pacific Ave 4 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
122025 256210 DPW Maintained 1 Acer rubrum :: Red Maple 75 837 Broadway 4 Median : Cutout Tree DPW 1       3x3   6009431 2118388 37.7972215096833 -122.411413084134 (37.7972215096833, -122.411413084134) 3 1 10 308 4
124340 256200 DPW Maintained 1 Acer rubrum :: Red Maple 75 800 Broadway 5 Median : Cutout Tree DPW 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
136981 256201 DPW Maintained 1 Acer rubrum :: Red Maple 75 800 Broadway 6 Median : Cutout Tree DPW 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
152887 142930 DPW Maintained 1 Acer rubrum :: Red Maple 75 581 Vallejo St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6010719.0959 2118913.2737 37.7987359458828 -122.406992969425 (37.7987359458828, -122.406992969425) 3 1 10 308 23
155975 256208 DPW Maintained 1 Acer rubrum :: Red Maple 75 837 Broadway 2 Median : Cutout Tree DPW 1       3x3   6009431 2118388 37.7972215096833 -122.411413084134 (37.7972215096833, -122.411413084134) 3 1 10 308 4
157908 255254 Undocumented 4 Acer rubrum :: Red Maple 75 240 Pacific Ave 1 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
158385 256198 DPW Maintained 1 Acer rubrum :: Red Maple 75 800 Broadway 3 Median : Cutout Tree DPW 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
165926 256205 DPW Maintained 1 Acer rubrum :: Red Maple 75 800 Broadway 10 Median : Cutout Tree DPW 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
172484 256197 DPW Maintained 1 Acer rubrum :: Red Maple 75 800 Broadway 2 Median : Cutout Tree DPW 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
193594 256211 DPW Maintained 1 Acer rubrum :: Red Maple 75 837 Broadway 5 Median : Cutout Tree DPW 1       3x3   6009431 2118388 37.7972215096833 -122.411413084134 (37.7972215096833, -122.411413084134) 3 1 10 308 4
24868 71898 DPW Maintained 1 Acer rubrum :: Red Maple 75 455 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/07/2015 12:00:00 AM 3   Permit Number 775644 6007926.40343 2114015.89838 37.7851322881578 -122.416309554165 (37.7851322881578, -122.416309554165) 7 10 9 28858 36
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
23360 189070 DPW Maintained 1 Acer rubrum :: Red Maple 75 1157 Bryant St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6009807.62506 2108635.36026 37.7704641998942 -122.409421229304 (37.7704641998942, -122.409421229304) 8 2 9 28853 34
24322 187931 DPW Maintained 1 Acer rubrum :: Red Maple 75 211 Spear St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6015237.31948 2115756.16147 37.790319045339 -122.391137539076 (37.790319045339, -122.391137539076) 6 2 9 28855 6
24954 255884 Undocumented 4 Acer rubrum :: Red Maple 75 50 Columbia Square St 5 Sidewalk: Curb side : Cutout Tree Rec/Park 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
26350 115356 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 9 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014763.69701 2114705.74438 37.7874085478076 -122.392702738938 (37.7874085478076, -122.392702738938) 6 2 9 28855 6
26680 187919 DPW Maintained 1 Acer rubrum :: Red Maple 75 48 Minna St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6013100.51395 2115046.75094 37.7882523600964 -122.398480985606 (37.7882523600964, -122.398480985606) 12 2 9 28855 6
27552 187948 DPW Maintained 1 Acer rubrum :: Red Maple 75 302 Main St 1 Sidewalk: Curb side : Yard Tree Private 2     2     6015252.9594 2115128.97629 37.7885978067978 -122.391039570534 (37.7885978067978, -122.391039570534) 6 2 9 28855 6
28512 101993 Permitted Site 7 Acer rubrum :: Red Maple 75 25 Essex St 4 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
28570 187924 DPW Maintained 1 Acer rubrum :: Red Maple 75 11 Natoma St 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6013555.31002 2115180.42433 37.7886447217118 -122.396916831643 (37.7886447217118, -122.396916831643) 12 2 9 28855 6
28605 88152 Permitted Site 7 Acer rubrum :: Red Maple 75 300X Clementina St 3 Sidewalk: Curb side : Cutout Tree Private 2   07/08/2008 12:00:00 AM   3x3 Permit Number 770961 6012270 2112782 37.7819875812332 -122.401195237476 (37.7819875812332, -122.401195237476) 6 2 9 28856 34
29533 187958 DPW Maintained 1 Acer rubrum :: Red Maple 75 43 Lansing St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 3ft   6014361.38404 2114182.65198 37.7859499041048 -122.394058036143 (37.7859499041048, -122.394058036143) 6 2 9 28855 6
30147 115348 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 399 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/28/2016 12:00:00 AM 3 4x10 Permit Number 773314 6014915.48611 2114547.78532 37.7869832575075 -122.39216652446 (37.7869832575075, -122.39216652446) 6 2 9 28855 6
30239 121540 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 318 Main St 1 Sidewalk: Curb side : Cutout Tree Private 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
31665 189088 DPW Maintained 1 Acer rubrum :: Red Maple 75 693 Minna St 1 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6009010.6716 2111090.12277 37.7771597163869 -122.412351439063 (37.7771597163869, -122.412351439063) 8 2 9 28853 34
32175 187928 DPW Maintained 1 Acer rubrum :: Red Maple 75 11 Natoma St 5 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6013614.18616 2115234.9562 37.7887977305714 -122.396716951919 (37.7887977305714, -122.396716951919) 12 2 9 28855 6
32270 118379 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 340 Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
34271 251211 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 210X Shipley St 4 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
34491 187942 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 300 Main St 3 Sidewalk: Curb side : Yard Tree Private 2     3     6015080.74918 2115307.92538 37.7890796023783 -122.391647913344 (37.7890796023783, -122.391647913344) 6 2 9 28855 6
34543 187929 DPW Maintained 1 Acer rubrum :: Red Maple 75 11 Natoma St 6 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 5ft   6013625.5813 2115247.15828 37.7888318688552 -122.396678381805 (37.7888318688552, -122.396678381805) 12 2 9 28855 6
35800 121504 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 4 Sidewalk: Property side : Cutout Tree Private 2     5 10x4   6014396.4001 2115093.29031 37.7884522533286 -122.394000660325 (37.7884522533286, -122.394000660325) 6 2 9 28855 6
35828 48550 Permitted Site 7 Acer rubrum :: Red Maple 75 630(REVISED) 08th St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/22/2002 12:00:00 AM     Permit Number 45867 6011089.0530694 2108751.21155661 37.7708540159333 -122.404996898488 (37.7708540159333, -122.404996898488) 14 2 9 28853 34
36599 187905 DPW Maintained 1 Acer rubrum :: Red Maple 75 167 Jessie St 3 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6011979.98788 2114548.14877 37.7868208291727 -122.402322770701 (37.7868208291727, -122.402322770701) 12 2 9 28855 6
37173 187933 DPW Maintained 1 Acer rubrum :: Red Maple 75 211 Spear St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   6015208.90661 2115787.01653 37.7904021894671 -122.391238004144 (37.7904021894671, -122.391238004144) 6 2 9 28855 6
37189 121502 Planning Code 138.1 required 2 Acer rubrum :: Red Maple 75 299 Fremont St 2 Sidewalk: Property side : Cutout Tree Private 2     4 10x4   6014428.99687 2115060.94265 37.7883652457059 -122.393885614549 (37.7883652457059, -122.393885614549) 6 2 9 28855 6
37618 189085 DPW Maintained 1 Acer rubrum :: Red Maple 75 350 Tehama St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6011651.36739 2112788.81807 37.7819717701308 -122.403335914547 (37.7819717701308, -122.403335914547) 6 2 9 28853 34

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