trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
808 19837 1 36 100 STAIRWAY25 21 Sidewalk: Curb side : Cutout Tree 1     6 60X                      
1090 260553 1 36 151x Palm Ave 4 Sidewalk: Curb side : Cutout Tree 1 SFUSD 09/21/2019 12:00:00 AM 3                        
1751 121138 2 36 1388x Minna St 2 Sidewalk: Curb side : Cutout Tree 2   09/08/2016 12:00:00 AM 3 3x3                      
2214 20033 1 36 100 STAIRWAY51 4 Sidewalk: Curb side : Cutout Tree 1     6 ST                      
5450 36847 7 36   1 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
5539 20007 1 36 100 STAIRWAY46 27 Sidewalk: Curb side : Cutout Tree 1     6 2                      
5645 19799 1 36 100 STAIRWAY21 4 Sidewalk: Curb side : Cutout Tree 1     3 40ST                      
6426 36849 7 36   3 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
6811 36853 7 36   7 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
7680 259798 1 36 599x Brussels St 3 Sidewalk: Curb side : Cutout Tree 1 FUF 04/27/2019 12:00:00 AM 3                        
7823 19798 1 36 100 STAIRWAY21 3 Sidewalk: Curb side : Cutout Tree 1     3 40ST                      
8244 20067 1 36 100 STAIRWAY54 14 Sidewalk: Curb side : Cutout Tree 1     6 15ST                      
8526 20030 1 36 100 STAIRWAY51 1 Sidewalk: Curb side : Cutout Tree 1     6 ST                      
8598 121137 2 36 1388x Minna St 1 Sidewalk: Curb side : Cutout Tree 2   09/08/2016 12:00:00 AM 3 3x3                      
9496 36851 7 36   5 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
9583 259871 1 36 901x Rutland St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2019 12:00:00 AM 3                        
9825 259868 1 36 99x Peabody St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2019 12:00:00 AM 3                        
11236 36848 7 36   2 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
11314 36850 7 36   4 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
11320 87812 7 36 4850 Funston Ave 1 Sidewalk: Curb side : Cutout Tree 2   06/03/2008 12:00:00 AM   3x3 Permit Number 50626                    
12111 20037 1 36 100 STAIRWAY51 8 Sidewalk: Curb side : Cutout Tree 1     12 ST                      
12367 20005 1 36 100 STAIRWAY46 25 Sidewalk: Curb side : Cutout Tree 1     6 2                      
12732 36844 7 36   8 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
13476 259858 1 36 200x Wilde Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2019 12:00:00 AM 3                        
14719 20008 1 36 100 STAIRWAY46 28 Sidewalk: Curb side : Cutout Tree 1     3 2                      
14729 259859 1 36 200x Wilde Ave 2 Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2019 12:00:00 AM 3                        
15566 121139 2 36 1388x Minna St 3 Sidewalk: Curb side : Cutout Tree 2   09/08/2016 12:00:00 AM 3 3x3                      
15705 260554 1 36 151x Palm Ave 7 Sidewalk: Curb side : Cutout Tree 1 SFUSD 08/26/2017 12:00:00 AM 3                        
15935 259870 1 36 99x Peabody St 3 Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2019 12:00:00 AM 3                        
17026 259869 1 36 99x Peabody St 2 Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2019 12:00:00 AM 3                        
17331 20381 1 36 262X Sunset Blvd 27 Sidewalk: Curb side : Cutout Tree 1     12 60                      
17894 20031 1 36 100 STAIRWAY51 2 Sidewalk: Curb side : Cutout Tree 1     6 ST                      
18045 36852 7 36   6 Sidewalk: Curb side : Cutout Tree 2   05/26/1998 12:00:00 AM     Permit Number 39538                    
19332 20006 1 36 100 STAIRWAY46 26 Sidewalk: Curb side : Cutout Tree 1     6 2                      
100024 258333 2 36 215X Raccoon Dr 2 Sidewalk: Property side : Yard Tree 2   04/29/2019 12:00:00 AM 3 3X3 Permit Number 776074                    
172077 258332 2 36 215X Raccoon Dr 1 Sidewalk: Property side : Yard Tree 2   04/29/2019 12:00:00 AM 3 3X3 Permit Number 776074                    
1734 262292 1 36 1601 Innes Ave 6 Sidewalk: Curb side : Cutout Tree 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
1976 42727 1 36 1790 Yosemite Ave 6 Sidewalk: Curb side : Cutout Tree 2 FUF 06/26/2000 12:00:00 AM 11   Permit Number 42732 6013660.48405 2093404.57029 37.7288588208724 -122.395027119533 (37.7288588208724, -122.395027119533) 10 3 8 58 1
2787 194758 1 36 750 Phelps St 43 : Tree 2     1 Width 2ft   6015105.78884 2097790.25184 37.740981275571 -122.390336854658 (37.740981275571, -122.390336854658) 10 3 8 58 1
4007 61209 1 36 130 Elmira St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/17/1983 12:00:00 AM 4   Permit Number 21077 6011180.72945 2095956.2501 37.7357269919001 -122.403779325271 (37.7357269919001, -122.403779325271) 10 3 8 58 1
4270 4929 1 36 16 Dedman Ct 1 Sidewalk: Curb side : Cutout Tree 1   11/16/2013 12:00:00 AM 3 3X4   6016491.974751 2096204.2192508 37.7367031453425 -122.385433388359 (37.7367031453425, -122.385433388359) 10 3 8 58 1
5733 83114 1 36 2094 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF   16     6012504.25253 2097415.87207 37.7398086567426 -122.399305795219 (37.7398086567426, -122.399305795219) 10 3 8 58 1
6096 71050 1 36 165 Elmira St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   11     6011229.446 2095779.16104 37.7352434641973 -122.403598436523 (37.7352434641973, -122.403598436523) 10 3 8 58 1
6299 75364 1 36 1335 Griffith St 2 Sidewalk: Curb side : Cutout Tree 2 FUF   4     6017823.2525 2092467.3959 37.7265161261373 -122.380570876773 (37.7265161261373, -122.380570876773) 10 3 8 58 1
6501 194992 1 36 11 Dedman Ct 7 Sidewalk: Curb side : Cutout Tree 2     14 Width 3ft   6016636.86174 2096261.76833 37.7368691785546 -122.384936454554 (37.7368691785546, -122.384936454554) 10 3 8 58 1
6550 194776 1 36 1 Flora St 1 : Tree 2     3 Width 3ft   6013845.42665 2094215.08633 37.731094615529 -122.394444484728 (37.731094615529, -122.394444484728) 10 3 8 58 1
6721 73570 1 36 1500 Palou Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF   8     6015400.1677 2094895.0317 37.7330479153498 -122.389116887561 (37.7330479153498, -122.389116887561) 10 3 8 58 1
6779 60387 1 36 1436 Palou Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/26/1982 12:00:00 AM 15   Permit Number 19967 6015759.6141 2094635.0651 37.7323540184412 -122.387856042206 (37.7323540184412, -122.387856042206) 10 3 8 58 1
6821 61205 1 36 156 Elmira St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/17/1983 12:00:00 AM 11 3x3 Permit Number 21073 6011187.02596 2095815.71279 37.7353414579279 -122.403747670028 (37.7353414579279, -122.403747670028) 10 3 8 58 1
7149 199777 1 36 1699 Hawes St 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 0ft   6016770.5961 2092171.5667 37.7256456912793 -122.384189310378 (37.7256456912793, -122.384189310378) 10 3 8 58 1
7304 259748 1 36 1539 Kirkwood Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF 10/13/2018 12:00:00 AM 3     6015490.3402 2096517.67005 37.7375083497932 -122.388918380926 (37.7375083497932, -122.388918380926) 10 3 8 58 1
7367 262291 1 36 1601 Innes Ave 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
7594 194986 1 36 11 Dedman Ct 1 Sidewalk: Curb side : Cutout Tree 2     19 Width 3ft   6016473.13756 2096210.02869 37.7367180546823 -122.38549892205 (37.7367180546823, -122.38549892205) 10 3 8 58 1
7767 262288 6 36 1601 Innes Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
9119 18646 7 36 55 Reuel Ct 2 Sidewalk: Curb side : Cutout Tree 2     12 3X4   6017250.7089795 2096167.8793556 37.7366453120483 -122.382807560554 (37.7366453120483, -122.382807560554) 10 3 8 58 1
10781 194991 1 36 11 Dedman Ct 6 Sidewalk: Curb side : Cutout Tree 2     1 Width 3ft   6016579.94443 2096258.22378 37.7368562975712 -122.385132997804 (37.7368562975712, -122.385132997804) 10 3 8 58 1
11210 262290 1 36 1601 Innes Ave 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
11546 60372 1 36 1447 Palou Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/26/1982 12:00:00 AM 16   Permit Number 19950 6015678.2715 2094616.9279 37.7322997108216 -122.388135999617 (37.7322997108216, -122.388135999617) 10 3 8 58 1
11867 262287 1 36 1601 Innes Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
12719 49732 7 36 1300@ REVERE Griffith St 8 Sidewalk: Curb side : Cutout Tree 2 FUF 06/04/2003 12:00:00 AM     Permit Number 46533 6017891.63282432 2092647.03396297 37.727013150708 -122.380346965446 (37.727013150708, -122.380346965446) 10 3 8 58 1
12786 261612 1 36 1900x Bay Shore Blvd 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6012644 2089018 37.7167576107691 -122.398233561415 (37.7167576107691, -122.398233561415) 10 3 8 58 1
13413 22337 7 36 5245X 03rd St 3 Sidewalk: Curb side : Cutout Tree 2     12 3x3   6014474 2093834 37.7300831524848 -122.39224473792 (37.7300831524848, -122.39224473792) 10 3 8 58 1
14520 194759 1 36 901 Phelps St 4 Sidewalk: Property side : Yard Tree 2     14 Width 8ft   6014822.60831 2097331.18487 37.7397050602466 -122.391283914518 (37.7397050602466, -122.391283914518) 10 3 8 58 1
14678 96770 1 36 1300X Lane St 6 Sidewalk: Property side : Cutout Tree 4 DPW for City Agency 12/08/2012 12:00:00 AM 3 3x3   6015623.8599 2095148.9526 37.7337575287133 -122.388361234061 (37.7337575287133, -122.388361234061) 10 3 8 58 1
15178 26129 1 36 1411 Oakdale Ave 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6016032.5768 2094704.0708 37.7325586119483 -122.386917149192 (37.7325586119483, -122.386917149192) 10 3 8 58 1
16266 60348 1 36 1404 Palou Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/26/1982 12:00:00 AM 6   Permit Number 19926 6015899.7652 2094527.3411 37.7320659929368 -122.387363991073 (37.7320659929368, -122.387363991073) 10 3 8 58 1
17159 3838 1 36 55X Dedman Ct 6 Sidewalk: Curb side : Cutout Tree 1   11/16/2013 12:00:00 AM 3 3X4   6016670.3231407 2096336.3389693 37.7370757852971 -122.38482595599 (37.7370757852971, -122.38482595599) 10 3 8 58 1
18011 262289 6 36 1601 Innes Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6015383 2097256 37.7395297026764 -122.389341053483 (37.7395297026764, -122.389341053483) 10 3 8 58 1
18121 49353 1 36 1875@ EVANS Marin St 3 Sidewalk: Curb side : Cutout Tree 2   03/07/2003 12:00:00 AM 6   Permit Number 46338 6013883.32752 2100506.62327 37.7483719742819 -122.394753893798 (37.7483719742819, -122.394753893798) 10 3 8 58 1
18285 4930 1 36 17 Dedman Ct 1 Sidewalk: Curb side : Cutout Tree 1   11/16/2013 12:00:00 AM 3 3X4   6016453.9870213 2096275.6260294 37.7368971121848 -122.385569704648 (37.7368971121848, -122.385569704648) 10 3 8 58 1
18552 60416 1 36 1551 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/26/1982 12:00:00 AM 9   Permit Number 19997 6015487.5561 2094405.0524 37.7317073747329 -122.388780566326 (37.7317073747329, -122.388780566326) 10 3 8 58 1
19120 75439 1 36 1335 Griffith St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   8     6017811.7945 2092449.5723 37.7264665536825 -122.380609248682 (37.7264665536825, -122.380609248682) 10 3 8 58 1
19664 93051 1 36 1555X Fairfax Ave 1 Sidewalk: Curb side : Cutout Tree 1   01/09/2010 12:00:00 AM 3 3x3 Planted for DPW by FUF 6015509.3 2098161.9 37.7420241196322 -122.388967590374 (37.7420241196322, -122.388967590374) 10 3 8 58 1
21757 199887 1 36 1501 Keith St 2 Sidewalk: Curb side : Cutout Tree 2     12 Width 0ft   6015922.2993 2094373.9993 37.7316461950184 -122.387275392579 (37.7316461950184, -122.387275392579) 10 3 8 58 1
24311 46249 7 36 1675 Hawes St 2 Sidewalk: Curb side : Cutout Tree 2   01/11/2002 12:00:00 AM     Permit Number 44536 6016787.6752368 2092188.79463336 37.7256939401069 -122.384131467798 (37.7256939401069, -122.384131467798) 10 3 8 58 1
24856 115880 7 36 1125X Newhall St 3 Sidewalk: Curb side : Cutout Tree 2   03/01/2016 12:00:00 AM 3   Permit Number 773046 6015016.8 2096457.8 37.7373176998372 -122.390551463966 (37.7373176998372, -122.390551463966) 10 3 8 58 1
26057 46250 7 36 1675 Hawes St 3 Sidewalk: Curb side : Cutout Tree 2   01/11/2002 12:00:00 AM     Permit Number 44536 6016787.6752368 2092188.79463336 37.7256939401069 -122.384131467798 (37.7256939401069, -122.384131467798) 10 3 8 58 1
26296 200017 1 36 1011 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 0ft   6018377.4011 2092259.3357 37.7259753973207 -122.378640745776 (37.7259753973207, -122.378640745776) 10 3 8 58 1
27266 199992 1 36 1074 Revere Ave 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 0ft   6017970.2582 2092302.0809 37.7260703143434 -122.380051196154 (37.7260703143434, -122.380051196154) 10 3 8 58 1
27890 3833 1 36 55X Dedman Ct 1 Sidewalk: Curb side : Cutout Tree 1     12 3X4   6016670.3231407 2096336.3389693 37.7370757852971 -122.38482595599 (37.7370757852971, -122.38482595599) 10 3 8 58 1
28794 4943 1 36 47 Dedman Ct 1 Sidewalk: Curb side : Cutout Tree 1     12 3X4   6016624.9255784 2096337.2776573 37.7370758517684 -122.384982982724 (37.7370758517684, -122.384982982724) 10 3 8 58 1
28986 97431 4 36 1696@ Newhall St McKinnon Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6014941.5 2096322.6 37.7369422906262 -122.390802367297 (37.7369422906262, -122.390802367297) 10 3 8 58 1
29690 199713 1 36 1510 Wallace Ave 3 Sidewalk: Curb side : Cutout Tree 2     1 Width 0ft   6015204.8816 2092597.8355 37.7267294479999 -122.389631663832 (37.7267294479999, -122.389631663832) 10 3 8 58 1
29958 4939 1 36 36 Dedman Ct 1 Sidewalk: Curb side : Cutout Tree 1   11/16/2013 12:00:00 AM 3 3X4   6016579.870147 2096241.2722059 37.7368097478482 -122.385132073872 (37.7368097478482, -122.385132073872) 10 3 8 58 1
30237 195016 1 36 1355 Fairfax Ave 2 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   6016962.32764 2097150.27135 37.7393268260728 -122.38387301165 (37.7393268260728, -122.38387301165) 10 3 8 58 1
30648 195014 1 36 1409 Keith St 2 Sidewalk: Curb side : Cutout Tree 2     14 Width 3ft   6016094.42849 2094603.13506 37.732284887124 -122.386696274914 (37.732284887124, -122.386696274914) 10 3 8 58 1
30823 96774 1 36 1300X Lane St 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 12/08/2012 12:00:00 AM 3 3x3   6015407.2 2095381.5 37.7343840488548 -122.389126529878 (37.7343840488548, -122.389126529878) 10 3 8 58 1
31112 96772 1 36 1300X Lane St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   2 3x3   6015407.2 2095381.5 37.7343840488548 -122.389126529878 (37.7343840488548, -122.389126529878) 10 3 8 58 1
31388 195010 1 36 15 Reuel Ct 6 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   6017232.0776 2096087.68476 37.7364240843076 -122.382866398677 (37.7364240843076, -122.382866398677) 10 3 8 58 1
31717 194779 1 36 1 Flora St 10 : Tree 2     2 Width 3ft   6013891.08255 2094437.3418 37.7317074216406 -122.394302198511 (37.7317074216406, -122.394302198511) 10 3 8 58 1
31799 11399 1 36 1462 Innes Ave 1 Sidewalk: Curb side : Cutout Tree 1     12 3X4   6016280.69423 2096695.13026 37.7380393961916 -122.386198097279 (37.7380393961916, -122.386198097279) 10 3 8 58 1
32168 97432 4 36 1696@ Newhall St McKinnon Ave 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6014941.5 2096322.6 37.7369422906262 -122.390802367297 (37.7369422906262, -122.390802367297) 10 3 8 58 1
32508 199751 1 36 1555 Yosemite Ave 6 Sidewalk: Curb side : Cutout Tree 2     5 Width 0ft   6014809.6379 2092470.5996 37.7263581596153 -122.390989131746 (37.7263581596153, -122.390989131746) 10 3 8 58 1
32792 49723 7 36 1300@ REVERE Griffith St 7 Sidewalk: Curb side : Cutout Tree 2 FUF 06/04/2003 12:00:00 AM     Permit Number 46533 6017891.63282432 2092647.03396297 37.727013150708 -122.380346965446 (37.727013150708, -122.380346965446) 10 3 8 58 1
33267 26138 7 36 1500 Oakdale Ave 8 Sidewalk: Curb side : Cutout Tree 5   11/05/2005 12:00:00 AM 3 3x3   6015586.3934773 2095100.209325 37.7336216133372 -122.388487366626 (37.7336216133372, -122.388487366626) 10 3 8 58 1
35597 194765 1 36 918 Newhall St 1 : Tree 2     10 Width 3ft   6015266.1428 2096893.13558 37.7385268719238 -122.389719760565 (37.7385268719238, -122.389719760565) 10 3 8 58 1
36107 195006 1 36 50 Dedman Ct 3 Sidewalk: Curb side : Cutout Tree 2     1 Width 3ft   6016468.53452 2096275.29989 37.7368970215793 -122.385519384306 (37.7368970215793, -122.385519384306) 10 3 8 58 1
36859 201928 1 36 118 Elmira St 4 : Tree 2     9 Width 3ft   6011173.64176 2096032.19931 37.7359351363972 -122.403809172877 (37.7359351363972, -122.403809172877) 10 3 8 58 1
37067 55072 1 36 1200X Newhall St 1 Sidewalk: Curb side : Cutout Tree 2   09/14/1972 12:00:00 AM 14   Permit Number 10967 6014810.12698 2096284.78904 37.7368311795103 -122.391253943725 (37.7368311795103, -122.391253943725) 10 3 8 58 1
37523 22335 1 36 5245X 03rd St 1 Sidewalk: Curb side : Cutout Tree 1     10 0   6014507.8049 2093886.8701 37.7302302000907 -122.392131565196 (37.7302302000907, -122.392131565196) 10 3 8 58 1
38414 4947 1 36 56 Dedman Ct 1 Sidewalk: Curb side : Cutout Tree 1   11/16/2013 12:00:00 AM 3 3X4   6016676.7719828 2096248.5036614 37.7368349638651 -122.384797542111 (37.7368349638651, -122.384797542111) 10 3 8 58 1