trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
544 259763 1 75 2701 24th St 1 Sidewalk: Curb side : Cutout Tree 1   03/12/2019 12:00:00 AM 3                        
1770 122656 1 75 300x Hickory St 12 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3x3                      
5536 122646 1 75 300x Hickory St 2 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3x3                      
7971 122653 1 75 300x Hickory St 9 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3x3                      
8221 122657 1 75 300x Hickory St 13 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3x3                      
10505 122650 1 75 300x Hickory St 6 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3x3                      
11819 122647 1 75 300x Hickory St 3 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3x3                      
12330 259764 1 75 2701 24th St 2 Sidewalk: Curb side : Cutout Tree 1   03/12/2019 12:00:00 AM 3                        
12580 122655 1 75 300x Hickory St 11 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3x3                      
13152 122648 1 75 300x Hickory St 4 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3x3                      
13368 122658 1 75 300x Hickory St 14 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3x3                      
13486 122649 1 75 300x Hickory St 5 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3x3                      
14226 122645 1 75 300x Hickory St 1 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3x3                      
14390 122652 1 75 300x Hickory St 8 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3x3                      
16082 122660 1 75 300x Hickory St 16 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3x3                      
16448 253390 1 75 2529x Lyon St 2 Sidewalk: Curb side : Cutout Tree 2   08/29/2017 12:00:00 AM 3 3x3                      
17571 122654 1 75 300x Hickory St 10 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3x3                      
17771 122651 1 75 300x Hickory St 7 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3x3                      
17800 122661 1 75 300x Hickory St 17 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3x3                      
18374 122659 1 75 300x Hickory St 15 Sidewalk: Curb side : Cutout Tree 2   11/10/2016 12:00:00 AM 3 3x3                      
710 256206 1 75 800 Broadway 11 Median : Cutout Tree 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
1348 261327 1 75 800 Broadway 12 Median : Cutout Tree 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
1468 261333 1 75 831 Broadway 6 Median : Cutout Tree 1       3x3   6009625 2118347 37.7971198129045 -122.410738895692 (37.7971198129045, -122.410738895692) 3 1 10 308 4
5868 261332 1 75 831 Broadway 5 Median : Cutout Tree 1       3x3   6009625 2118347 37.7971198129045 -122.410738895692 (37.7971198129045, -122.410738895692) 3 1 10 308 4
14316 256204 1 75 800 Broadway 9 Median : Cutout Tree 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
15425 256202 1 75 800 Broadway 7 Median : Cutout Tree 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
15677 255256 4 75 240 Pacific Ave 3 Sidewalk: Curb side : Cutout Tree 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 1 75 831 Broadway 1 Median : Cutout Tree 1       3x3   6009625 2118347 37.7971198129045 -122.410738895692 (37.7971198129045, -122.410738895692) 3 1 10 308 4
17833 261334 1 75 831 Broadway 7 Median : Cutout Tree 1       3x3   6009625 2118347 37.7971198129045 -122.410738895692 (37.7971198129045, -122.410738895692) 3 1 10 308 4
19278 261329 1 75 831 Broadway 2 Median : Cutout Tree 1       3x3   6009625 2118347 37.7971198129045 -122.410738895692 (37.7971198129045, -122.410738895692) 3 1 10 308 4
19606 261330 1 75 831 Broadway 3 Median : Cutout Tree 1       3x3   6009625 2118347 37.7971198129045 -122.410738895692 (37.7971198129045, -122.410738895692) 3 1 10 308 4
19741 256203 1 75 800 Broadway 8 Median : Cutout Tree 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
26828 255255 4 75 240 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree 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 1 75 837 Broadway 7 Median : Cutout Tree 1       3x3   6009431 2118388 37.7972215096833 -122.411413084134 (37.7972215096833, -122.411413084134) 3 1 10 308 4
34523 142929 1 75 591 Vallejo St 1 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   6010700.0761 2118912.2456 37.7987320586367 -122.407058711866 (37.7987320586367, -122.407058711866) 3 1 10 308 23
47368 256212 1 75 837 Broadway 6 Median : Cutout Tree 1       3x3   6009431 2118388 37.7972215096833 -122.411413084134 (37.7972215096833, -122.411413084134) 3 1 10 308 4
50976 256196 1 75 800 Broadway 1 Median : Cutout Tree 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
67000 255258 4 75 720 Battery St 1 Sidewalk: Curb side : Cutout Tree 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 1 75 800 Broadway 4 Median : Cutout Tree 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
75008 255259 4 75 720 Battery St 2 Sidewalk: Curb side : Cutout Tree 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 1 75 837 Broadway 3 Median : Cutout Tree 1       3x3   6009431 2118388 37.7972215096833 -122.411413084134 (37.7972215096833, -122.411413084134) 3 1 10 308 4
107446 256207 1 75 837 Broadway 1 Median : Cutout Tree 1       3x3   6009431 2118388 37.7972215096833 -122.411413084134 (37.7972215096833, -122.411413084134) 3 1 10 308 4
108077 255257 4 75 240 Pacific Ave 4 Sidewalk: Curb side : Cutout Tree 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 1 75 837 Broadway 4 Median : Cutout Tree 1       3x3   6009431 2118388 37.7972215096833 -122.411413084134 (37.7972215096833, -122.411413084134) 3 1 10 308 4
124340 256200 1 75 800 Broadway 5 Median : Cutout Tree 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
136981 256201 1 75 800 Broadway 6 Median : Cutout Tree 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
152887 142930 1 75 581 Vallejo St 2 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   6010719.0959 2118913.2737 37.7987359458828 -122.406992969425 (37.7987359458828, -122.406992969425) 3 1 10 308 23
155975 256208 1 75 837 Broadway 2 Median : Cutout Tree 1       3x3   6009431 2118388 37.7972215096833 -122.411413084134 (37.7972215096833, -122.411413084134) 3 1 10 308 4
157908 255254 4 75 240 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree 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 1 75 800 Broadway 3 Median : Cutout Tree 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
165926 256205 1 75 800 Broadway 10 Median : Cutout Tree 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
172484 256197 1 75 800 Broadway 2 Median : Cutout Tree 1       3x3   6009530 2118420 37.797314926041 -122.411072779375 (37.797314926041, -122.411072779375) 3 1 10 308 4
193594 256211 1 75 837 Broadway 5 Median : Cutout Tree 1       3x3   6009431 2118388 37.7972215096833 -122.411413084134 (37.7972215096833, -122.411413084134) 3 1 10 308 4
24868 71898 1 75 455 Hyde St 1 Sidewalk: Curb side : Cutout Tree 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 1 75 340 Fremont St 7 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6014829.80215 2114536.31276 37.7869469986487 -122.392462171218 (37.7869469986487, -122.392462171218) 6 2 9 28855 6
3170 38792 1 75 655 Bryant St 1 Sidewalk: Curb side : Cutout Tree 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 2 75 340 Fremont St 2 Sidewalk: Curb side : Cutout Tree 2     2 4x6   6014712.48727 2114662.02755 37.7872856671566 -122.392876855803 (37.7872856671566, -122.392876855803) 6 2 9 28855 6
6991 112084 2 75 99X Fremont St 1 Sidewalk: Curb side : Cutout Tree 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 1 75 277 Shipley St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   1     6011311.01378 2111537.1063 37.7785158463684 -122.404425254319 (37.7785158463684, -122.404425254319) 14 2 9 28856 34
9905 187906 1 75 167 Jessie St 4 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   6011990.7752 2114556.67649 37.7868448464448 -122.402286048678 (37.7868448464448, -122.402286048678) 12 2 9 28855 6
11352 73737 1 75 595 Bryant St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   3     6013232.29052 2111907.2745 37.7796394233505 -122.397804754791 (37.7796394233505, -122.397804754791) 6 2 9 28856 34
11492 187952 1 75 340 Fremont St 3 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6014738.2491 2114633.83833 37.7872096969197 -122.392785751786 (37.7872096969197, -122.392785751786) 6 2 9 28855 6
14551 72302 1 75 595 Bryant St 2 Sidewalk: Curb side : Cutout Tree 2 FUF   5     6013261.50947 2111935.00833 37.7797172012305 -122.397705618927 (37.7797172012305, -122.397705618927) 6 2 9 28856 34
16780 85805 2 75 210X Shipley St 1 Sidewalk: Curb side : Cutout Tree 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 1 75 333 Fremont St 1 Sidewalk: Curb side : Cutout Tree 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 1 75 521 Bryant St 3 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   6013735.14278 2112387.07191 37.7809848280366 -122.396098793052 (37.7809848280366, -122.396098793052) 6 2 9 28856 34
17355 258161 1 75 335 08th St 1 Sidewalk: Curb side : Cutout Tree 1 FUF   3     6009797.86626 2110165.76552 37.7746657903123 -122.409563015883 (37.7746657903123, -122.409563015883) 8 2 9 28853 34
17501 251213 2 75 210X Shipley St 6 Sidewalk: Curb side : Cutout Tree 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 1 75 211 Spear St 3 Sidewalk: Curb side : Cutout Tree 2     7 Width 2ft   6015226.56568 2115767.07954 37.7903484270771 -122.391175510261 (37.7903484270771, -122.391175510261) 6 2 9 28855 6
19345 101991 7 75 25 Essex St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6014029.63843 2114247.91899 37.7861106686205 -122.395210367086 (37.7861106686205, -122.395210367086) 6 2 9 28855 6
19613 187949 1 75 302 Main St 2 Sidewalk: Curb side : Yard Tree 2     1     6015269.3196 2115112.5908 37.7885537238177 -122.390981820563 (37.7885537238177, -122.390981820563) 6 2 9 28855 6
20764 108061 1 75 333 Fremont St 3 Sidewalk: Curb side : Cutout Tree 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 1 75 670 08th St 4 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6011103.55748 2108718.67114 37.7707654781809 -122.40494443566 (37.7707654781809, -122.40494443566) 14 2 9 28853 34
21266 187936 1 75 255 Fremont St 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 4ft   6014368.82149 2115126.24847 37.7885412160406 -122.394098386929 (37.7885412160406, -122.394098386929) 6 2 9 28855 6
21732 121544 2 75 318 Main St 5 Sidewalk: Curb side : Cutout Tree 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
22052 115353 2 75 399 Fremont St 6 Sidewalk: Curb side : Cutout Tree 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 1 75 1157 Bryant St 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   6009807.62506 2108635.36026 37.7704641998942 -122.409421229304 (37.7704641998942, -122.409421229304) 8 2 9 28853 34
24322 187931 1 75 211 Spear St 2 Sidewalk: Curb side : Cutout Tree 2     8 Width 2ft   6015237.31948 2115756.16147 37.790319045339 -122.391137539076 (37.790319045339, -122.391137539076) 6 2 9 28855 6
24954 255884 4 75 50 Columbia Square St 5 Sidewalk: Curb side : Cutout Tree 5 Private     3x3   6010942 2111079 37.7772373644855 -122.405669544588 (37.7772373644855, -122.405669544588) 14 2 9 28853 34
26350 115356 2 75 399 Fremont St 9 Sidewalk: Curb side : Cutout Tree 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 1 75 48 Minna St 2 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6013100.51395 2115046.75094 37.7882523600964 -122.398480985606 (37.7882523600964, -122.398480985606) 12 2 9 28855 6
27552 187948 1 75 302 Main St 1 Sidewalk: Curb side : Yard Tree 2     2     6015252.9594 2115128.97629 37.7885978067978 -122.391039570534 (37.7885978067978, -122.391039570534) 6 2 9 28855 6
28512 101993 7 75 25 Essex St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6014029.63843 2114247.91899 37.7861106686205 -122.395210367086 (37.7861106686205, -122.395210367086) 6 2 9 28855 6
28570 187924 1 75 11 Natoma St 1 Sidewalk: Curb side : Cutout Tree 2     7 Width 5ft   6013555.31002 2115180.42433 37.7886447217118 -122.396916831643 (37.7886447217118, -122.396916831643) 12 2 9 28855 6
28605 88152 7 75 300X Clementina St 3 Sidewalk: Curb side : Cutout Tree 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 1 75 43 Lansing St 1 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6014361.38404 2114182.65198 37.7859499041048 -122.394058036143 (37.7859499041048, -122.394058036143) 6 2 9 28855 6
30147 115348 2 75 399 Fremont St 1 Sidewalk: Curb side : Cutout Tree 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 2 75 318 Main St 1 Sidewalk: Curb side : Cutout Tree 2       8x15   6015095 2115307 37.7890778525244 -122.391598542205 (37.7890778525244, -122.391598542205) 6 2 9 28855 6
31665 189088 1 75 693 Minna St 1 Sidewalk: Curb side : Cutout Tree 2     1 Width 3ft   6009010.6716 2111090.12277 37.7771597163869 -122.412351439063 (37.7771597163869, -122.412351439063) 8 2 9 28853 34
32175 187928 1 75 11 Natoma St 5 Sidewalk: Curb side : Cutout Tree 2     6 Width 5ft   6013614.18616 2115234.9562 37.7887977305714 -122.396716951919 (37.7887977305714, -122.396716951919) 12 2 9 28855 6
32270 118379 2 75 340 Fremont St 6 Sidewalk: Curb side : Cutout Tree 2       4x6   6014683 2114666 37.7872949366988 -122.392979154362 (37.7872949366988, -122.392979154362) 6 2 9 28855 6
34271 251211 2 75 210X Shipley St 4 Sidewalk: Curb side : Cutout Tree 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 2 75 300 Main St 3 Sidewalk: Curb side : Yard Tree 2     3     6015080.74918 2115307.92538 37.7890796023783 -122.391647913344 (37.7890796023783, -122.391647913344) 6 2 9 28855 6
34543 187929 1 75 11 Natoma St 6 Sidewalk: Curb side : Cutout Tree 2     7 Width 5ft   6013625.5813 2115247.15828 37.7888318688552 -122.396678381805 (37.7888318688552, -122.396678381805) 12 2 9 28855 6
35800 121504 2 75 299 Fremont St 4 Sidewalk: Property side : Cutout Tree 2     5 10x4   6014396.4001 2115093.29031 37.7884522533286 -122.394000660325 (37.7884522533286, -122.394000660325) 6 2 9 28855 6
35828 48550 7 75 630(REVISED) 08th St 2 Sidewalk: Curb side : Cutout Tree 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 1 75 167 Jessie St 3 Sidewalk: Curb side : Cutout Tree 2     4 Width 3ft   6011979.98788 2114548.14877 37.7868208291727 -122.402322770701 (37.7868208291727, -122.402322770701) 12 2 9 28855 6
37173 187933 1 75 211 Spear St 4 Sidewalk: Curb side : Cutout Tree 2     7 Width 2ft   6015208.90661 2115787.01653 37.7904021894671 -122.391238004144 (37.7904021894671, -122.391238004144) 6 2 9 28855 6
37189 121502 2 75 299 Fremont St 2 Sidewalk: Property side : Cutout Tree 2     4 10x4   6014428.99687 2115060.94265 37.7883652457059 -122.393885614549 (37.7883652457059, -122.393885614549) 6 2 9 28855 6
37618 189085 1 75 350 Tehama St 2 Sidewalk: Curb side : Cutout Tree 2     3 Width 3ft   6011651.36739 2112788.81807 37.7819717701308 -122.403335914547 (37.7819717701308, -122.403335914547) 6 2 9 28853 34
40161 88150 7 75 300X Clementina St 1 Sidewalk: Curb side : Cutout Tree 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