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                    
50641 49773 1 36 991@ HAWES Innes Ave 2 Sidewalk: Curb side : Cutout Tree 2   06/09/2003 12:00:00 AM 5   Permit Number 46560 6018765.60896 2094758.80676 37.7328598551943 -122.377472089671 (37.7328598551943, -122.377472089671) 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
147273 200016 1 36 1015 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 0ft   6018332.7975 2092292.5025 37.7260640079993 -122.37879724133 (37.7260640079993, -122.37879724133) 10 3 8 58 1
171184 199984 1 36 1049 Quesada Ave 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 0ft   6018239.0156 2092359.9798 37.7262441168546 -122.379126127625 (37.7262441168546, -122.379126127625) 10 3 8 58 1
65456 200020 1 36 1018 Revere Ave 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 0ft   6018197.6822 2092123.3004 37.7255919615614 -122.379252584385 (37.7255919615614, -122.379252584385) 10 3 8 58 1
137945 199986 1 36 1036 Revere Ave 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 0ft   6018125.6646 2092187.1055 37.7257631863869 -122.379505976339 (37.7257631863869, -122.379505976339) 10 3 8 58 1
63995 199964 1 36 1235 Griffith St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 0ft   6018047.3207 2092773.5801 37.7273692110952 -122.379817537923 (37.7273692110952, -122.379817537923) 10 3 8 58 1
126942 199963 1 36 1265 Griffith St 2 Sidewalk: Curb side : Cutout Tree 2     5 Width 0ft   6018034.5896 2092755.7565 37.7273195686648 -122.379860311925 (37.7273195686648, -122.379860311925) 10 3 8 58 1
102192 199990 1 36 1062 Revere Ave 1 Sidewalk: Curb side : Cutout Tree 2     4 Width 0ft   6018021.4286 2092264.1769 37.7259690601423 -122.379871668847 (37.7259690601423, -122.379871668847) 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
100313 199959 1 36 1250 Griffith St 3 Sidewalk: Curb side : Cutout Tree 2     7 Width 0ft   6017944.0607 2092712.7775 37.7271965624066 -122.380170287962 (37.7271965624066, -122.380170287962) 10 3 8 58 1
137980 199993 1 36 1082 Revere Ave 1 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   6017934.2494 2092328.6137 37.7261411816642 -122.380177520727 (37.7261411816642, -122.380177520727) 10 3 8 58 1
56726 199994 1 36 1088 Revere Ave 1 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   6017897.6089 2092357.0417 37.7262172178466 -122.380306160969 (37.7262172178466, -122.380306160969) 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
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
64851 49731 7 36 1300@ REVERE Griffith St 3 Sidewalk: Curb side : Cutout Tree 2   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
68240 49725 7 36 1300@ REVERE Griffith St 6 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
91827 49730 7 36 1300@ REVERE Griffith St 2 Sidewalk: Curb side : Cutout Tree 2   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
107431 49722 7 36 1300@ REVERE Griffith St 11 Sidewalk: Curb side : Cutout Tree 2   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
129694 49729 7 36 1300@ REVERE Griffith St 5 Sidewalk: Curb side : Cutout Tree 2   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
134700 49727 7 36 1300@ REVERE Griffith St 9 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
142366 49726 7 36 1300@ REVERE Griffith St 1 Sidewalk: Curb side : Cutout Tree 2   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
182510 49728 7 36 1300@ REVERE Griffith St 10 Sidewalk: Curb side : Cutout Tree 2   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
186041 49724 7 36 1300@ REVERE Griffith St 4 Sidewalk: Curb side : Cutout Tree 2   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
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
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
68692 200012 1 36 1401 Griffith St 1 Sidewalk: Curb side : Cutout Tree 2     6 Width 0ft   6017723.9495 2092325.4436 37.726120872223 -122.380904302696 (37.726120872223, -122.380904302696) 10 3 8 58 1
68689 200022 1 36 1524 Griffith St 2 Sidewalk: Curb side : Cutout Tree 2     4 Width 0ft   6017517.7049 2092135.1129 37.7255868755216 -122.381604054782 (37.7255868755216, -122.381604054782) 10 3 8 58 1
158384 195013 1 36 15 Reuel Ct 10 Sidewalk: Curb side : Cutout Tree 2     5 Width 3ft   6017390.87176 2096051.06951 37.7363323183897 -122.382314828266 (37.7363323183897, -122.382314828266) 10 3 8 58 1
136540 18651 1 36 75 Reuel Ct 2 Sidewalk: Curb side : Cutout Tree 1     12 3X4   6017333.6171273 2096134.4813377 37.7365581880217 -122.382518585342 (37.7365581880217, -122.382518585342) 10 3 8 58 1
60523 18648 7 36 65 Reuel Ct 1 Sidewalk: Curb side : Cutout Tree 2     12 3X4   6017293.8421904 2096150.8170108 37.7366008452399 -122.382657242033 (37.7366008452399, -122.382657242033) 10 3 8 58 1
68019 195012 1 36 15 Reuel Ct 8 Sidewalk: Curb side : Cutout Tree 2     7 Width 3ft   6017279.93049 2096066.80699 37.7363694019213 -122.382699497078 (37.7363694019213, -122.382699497078) 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
41744 18645 7 36 55 Reuel Ct 1 Sidewalk: Curb side : Cutout Tree 2   11/18/2016 12:00:00 AM 3 3X4   6017250.7089795 2096167.8793556 37.7366453120483 -122.382807560554 (37.7366453120483, -122.382807560554) 10 3 8 58 1
169873 195011 1 36 15 Reuel Ct 7 Sidewalk: Curb side : Cutout Tree 2     6 Width 3ft   6017245.52406 2096081.92026 37.7364089990626 -122.382819507108 (37.7364089990626, -122.382819507108) 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
58464 18644 7 36 45 Reuel Ct 2 Sidewalk: Curb side : Cutout Tree 2     6 3X4   6017209.0785081 2096178.6405669 37.7366725600424 -122.382952245184 (37.7366725600424, -122.382952245184) 10 3 8 58 1
147333 195009 1 36 15 Reuel Ct 5 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6017206.74731 2096096.89291 37.7364479684919 -122.382954617674 (37.7364479684919, -122.382954617674) 10 3 8 58 1
126892 195008 1 36 15 Reuel Ct 4 Sidewalk: Curb side : Cutout Tree 2     14 Width 3ft   6017180.41937 2096102.2295 37.736461166953 -122.383046016687 (37.736461166953, -122.383046016687) 10 3 8 58 1
167048 18639 1 36 25 Reuel Ct 3 Sidewalk: Curb side : Cutout Tree 1     6 3X4   6017121.1361855 2096199.8633465 37.7367259740336 -122.383257779638 (37.7367259740336, -122.383257779638) 10 3 8 58 1
163889 194985 1 36 2 Progress St 1 Sidewalk: Curb side : Yard Tree 2     14 Width 4ft   6017047.98136 2094998.67285 37.7334237013335 -122.383427116962 (37.7334237013335, -122.383427116962) 10 3 8 58 1
115789 195007 1 36 15 Reuel Ct 1 Sidewalk: Curb side : Cutout Tree 2     11 Width 3ft   6017052.07909 2096111.26118 37.736478873694 -122.3834903762 (37.736478873694, -122.3834903762) 10 3 8 58 1
151661 199771 1 36 1639 Hawes St 3 Sidewalk: Curb side : Cutout Tree 2     13 Width 0ft   6016879.1133 2092313.6857 37.7260419216039 -122.383824062427 (37.7260419216039, -122.383824062427) 10 3 8 58 1
106551 194763 1 36 1355 Fairfax Ave 2 : Tree 2     7 Width 3ft   6016963.14266 2097148.26194 37.7393213536925 -122.383870053768 (37.7393213536925, -122.383870053768) 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
178544 199772 1 36 1639 Hawes St 2 Sidewalk: Curb side : Cutout Tree 2     9 Width 0ft   6016857.0794 2092287.7958 37.7259696149574 -122.383898431076 (37.7259696149574, -122.383898431076) 10 3 8 58 1
132574 199773 1 36 1639 Hawes St 1 Sidewalk: Curb side : Cutout Tree 2     10 Width 0ft   6016840.0031 2092265.7618 37.7259081698836 -122.383955929707 (37.7259081698836, -122.383955929707) 10 3 8 58 1
78268 199775 1 36 1641 Hawes St 3 Sidewalk: Curb side : Cutout Tree 2     10 Width 0ft   6016825.681 2092249.2364 37.725862002585 -122.384004290492 (37.725862002585, -122.384004290492) 10 3 8 58 1
45030 199779 1 36 1651 Hawes St 1 Sidewalk: Curb side : Cutout Tree 2     5 Width 0ft   6016800.3419 2092212.8803 37.7257607749493 -122.384089356217 (37.7257607749493, -122.384089356217) 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
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
172757 199778 1 36 1699 Hawes St 2 Sidewalk: Curb side : Cutout Tree 2     5 Width 0ft   6016784.3673 2092190.2955 37.7256978783027 -122.38414300766 (37.7256978783027, -122.38414300766) 10 3 8 58 1
186139 194998 1 36 11 Dedman Ct 13 Sidewalk: Curb side : Cutout Tree 2     16 Width 3ft   6016853.52358 2096150.44507 37.7365754887703 -122.384179601306 (37.7365754887703, -122.384179601306) 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
176899 194997 1 36 11 Dedman Ct 12 Sidewalk: Curb side : Cutout Tree 2     1 Width 3ft   6016824.43505 2096171.98497 37.7366330246822 -122.384281673458 (37.7366330246822, -122.384281673458) 10 3 8 58 1
177347 194999 1 36 11 Dedman Ct 14 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6016818.43135 2096263.7409 37.7368846361018 -122.384308819492 (37.7368846361018, -122.384308819492) 10 3 8 58 1
60938 194996 1 36 11 Dedman Ct 11 Sidewalk: Curb side : Cutout Tree 2     10 Width 3ft   6016795.74249 2096197.58252 37.7367017238936 -122.384382659238 (37.7367017238936, -122.384382659238) 10 3 8 58 1
65888 26661 7 36 1355 Fairfax Ave 3 Sidewalk: Curb side : Cutout Tree 2   03/10/2007 12:00:00 AM 6 3x3   6016787.8631263 2097291.0360599 37.7397036915046 -122.384486040227 (37.7397036915046, -122.384486040227) 10 3 8 58 1
77964 195000 1 36 11 Dedman Ct 15 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6016757.63596 2096301.5565 37.7369851083784 -122.384521651269 (37.7369851083784, -122.384521651269) 10 3 8 58 1
79721 195001 1 36 11 Dedman Ct 16 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6016715.85177 2096316.47187 37.7370237522504 -122.384667157956 (37.7370237522504, -122.384667157956) 10 3 8 58 1
66639 194995 1 36 11 Dedman Ct 10 Sidewalk: Curb side : Cutout Tree 2     1 Width 3ft   6016711.28945 2096245.88288 37.736829676747 -122.384678016386 (37.736829676747, -122.384678016386) 10 3 8 58 1
142115 4949 1 36 64 Dedman Ct 1 Sidewalk: Curb side : Cutout Tree 1   11/16/2013 12:00:00 AM 3     6016704.3692816 2096233.9145978 37.7367964315307 -122.38470110922 (37.7367964315307, -122.38470110922) 10 3 8 58 1
107668 194994 1 36 11 Dedman Ct 9 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6016695.66804 2096249.95032 37.7368399811784 -122.384732310246 (37.7368399811784, -122.384732310246) 10 3 8 58 1
185020 4948 1 36 60 Dedman Ct 1 Sidewalk: Curb side : Cutout Tree 1     12 3X4   6016685.2053972 2096242.6447012 37.7368193427664 -122.38476797578 (37.7368193427664, -122.38476797578) 10 3 8 58 1
70962 195002 1 36 11 Dedman Ct 17 Sidewalk: Curb side : Cutout Tree 2     2 Width 3ft   6016680.46739 2096324.02955 37.737042547164 -122.384790025147 (37.737042547164, -122.384790025147) 10 3 8 58 1