trees

Custom SQL query returning 101 rows (hide)

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
1 264847 1 1 109 Felton St 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6010522 2093730 37.729577358437 -122.405900044893 (37.729577358437, -122.405900044893) 10 3 7 309 28
2 262167 1 2 420 Alpha St 2 Sidewalk: Curb side : Cutout Tree 1 FUF 11/16/2020 12:00:00 AM 3                        
4 264831 1 1 230 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3 4x6   6011678 2088870 37.7162973770842 -122.401562170369 (37.7162973770842, -122.401562170369) 10 7 8 309 39
5 264836 1 4 325 Olmstead St 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3 4x6   6010737 2090909 37.7218435009065 -122.404958220137 (37.7218435009065, -122.404958220137) 10 3 7 309 28
6 262166 1 2 420 Alpha St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 11/16/2020 12:00:00 AM 3                        
8 264824 1 6 1x Harkness Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6012032 2089425 37.7178410421308 -122.400377527521 (37.7178410421308, -122.400377527521) 10 7 8 309 39
9 32966 1 7 556 Mississippi St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/17/2020 12:00:00 AM 3   Permit Number 37281 6014072.59224 2104507.52941 37.759368126158 -122.394379509632 (37.759368126158, -122.394379509632) 10 3 8 28856 29
11 264841 1 2 1601 Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6007819 2087884 37.7133739406818 -122.41483104388 (37.7133739406818, -122.41483104388) 9 7 8 309 39
13 264822 1 10 2 Harkness Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3 4x6                      
14 162252 1 11 789 Girard St 1 Sidewalk: Curb side : Cutout Tree 2   11/01/2020 12:00:00 AM 3 Width 0ft   6011428.3902 2091205.22693 37.7226955033817 -122.402589068938 (37.7226955033817, -122.402589068938) 10 3 7 309 28
15 264849 1 12 15 Hale St 2 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6010381 2094903 37.7327902820185 -122.40647012075 (37.7327902820185, -122.40647012075) 10 3 7 309 28
16 264823 1 10 2 Harkness Ave 2 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3 4x6                      
18 50210 1 14 830 27th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/21/2003 12:00:00 AM 8   Permit Number 46918 5987602.00308 2110288.94488 37.7737352840678 -122.486351029235 (37.7737352840678, -122.486351029235) 11 6 2 55 26
19 262168 1 2 420 Alpha St 3 Sidewalk: Curb side : Cutout Tree 1 FUF 11/16/2020 12:00:00 AM 3                        
21 264839 1 2 1601 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6007819 2087884 37.7133739406818 -122.41483104388 (37.7133739406818, -122.41483104388) 9 7 8 309 39
23 50211 1 14 834 27th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/21/2003 12:00:00 AM 9   Permit Number 46919 5987605.33986 2110266.54313 37.7736739696217 -122.486337841964 (37.7736739696217, -122.486337841964) 11 6 2 55 26
24 264941 1 16 100X Portola Dr 12 Median : Cutout Tree 2       3x3   5999749 2101261 37.7496473113918 -122.443684097942 (37.7496473113918, -122.443684097942) 2 5 5 28862 38
25 49783 1 6 130 Wilde Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 11/01/2020 12:00:00 AM 3   Permit Number 46568 6011944.29976 2088937.30454 37.7164970376796 -122.400646428989 (37.7164970376796, -122.400646428989) 10 7 8 309 39
26 259857 1 1 1255 Brussels St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 11/01/2020 12:00:00 AM 3     6011768.59367 2089078.72926 37.7168755602396 -122.401263692233 (37.7168755602396, -122.401263692233) 10 7 8 309 39
28 264848 1 12 15 Hale St 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6010381 2094903 37.7327902820185 -122.40647012075 (37.7327902820185, -122.40647012075) 10 3 7 309 28
32 264850 1 8 172 University St 1 Sidewalk: Curb side : Cutout Tree 1   11/01/2020 12:00:00 AM 3     6007951 2093149 37.7278379340298 -122.414747181337 (37.7278379340298, -122.414747181337) 9 3 7 309 5
35 16620 1 20 125 Noe St 1 Sidewalk: Curb side : Cutout Tree 2   07/09/1999 12:00:00 AM 6 3X3   6002913 2107540 37.7670678918229 -122.433191472284 (37.7670678918229, -122.433191472284) 15 5 5 28862 3
39 210801 1 23 140 Merced Ave 2 Sidewalk: Curb side : Cutout Tree 2   11/24/2020 12:00:00 AM 3 Width 4ft Permit Number 787871 5994480.90157 2099425.24867 37.7443049252384 -122.461768149483 (37.7443049252384, -122.461768149483) 1 8 4 59 40
40 6039 1 24 1822 Eddy St 4 Sidewalk: Curb side : Cutout Tree 2     12 3X3   6001574.3819 2112547.6661 37.7807416628926 -122.438180307395 (37.7807416628926, -122.438180307395) 15 5 11 29490 41
41 159866 1 1 20 Ruth St 3 Sidewalk: Curb side : Cutout Tree 2   11/19/2020 12:00:00 AM 3 4x6   6001590.27181 2091627.71254 37.7233013847479 -122.436627471279 (37.7233013847479, -122.436627471279) 9 7 6 28861 25
42 221891 1 25 180 Bartlett St 3 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6006685.21207 2102724.39469 37.7540586268078 -122.419802203518 (37.7540586268078, -122.419802203518) 2 4 7 28859 19
43 264724 1 26 2901 Broadway 1 Front Yard : Yard Tree 2       3x3   5999656 2116990 37.7928298614365 -122.445136362104 (37.7928298614365, -122.445136362104) 13 6 1 29490 27
44 159867 1 1 20 Ruth St 4 Sidewalk: Curb side : Cutout Tree 2   11/19/2020 12:00:00 AM 3 4x6   6001543.73914 2091652.70256 37.7233673572035 -122.436790113668 (37.7233673572035, -122.436790113668) 9 7 6 28861 25
45 134298 1 27 1948 Pacific Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/23/2020 12:00:00 AM 3 Width 4ft   6004784.56446 2117433.72769 37.7943396156388 -122.427422908337 (37.7943396156388, -122.427422908337) 13 9 1 28858 27
46 6035 1 24 1826 Eddy St 1 Sidewalk: Curb side : Cutout Tree 2     12 3X3   6001552.687 2112546.4084 37.7807369756783 -122.438255270265 (37.7807369756783, -122.438255270265) 15 5 11 29490 41
48 159865 1 1 20 Ruth St 2 Sidewalk: Curb side : Cutout Tree 2   11/19/2020 12:00:00 AM 3 4x6   6001621.37029 2091612.17517 37.7232604898693 -122.436518858358 (37.7232604898693, -122.436518858358) 9 7 6 28861 25
49 261834 1 1 20x Ruth St 1 Sidewalk: Curb side : Cutout Tree 1   11/19/2020 12:00:00 AM 3 4x6   6001536 2091749 37.7236313283612 -122.436823756643 (37.7236313283612, -122.436823756643) 9 7 6 28861 25
51 137691 1 29 2175 GOLDEN GATE AVE 1 Sidewalk: Curb side : Cutout Tree 2   11/23/2020 12:00:00 AM 3 Width 0ft   5999187.5809 2111472.1809 37.7776526229954 -122.44635998308 (37.7776526229954, -122.44635998308) 15 5 11 54 16
54 216739 1 11 11 Brighton Ave 1 Sidewalk: Curb side : Yard Tree 2   11/23/2020 12:00:00 AM 3 Width 3ft   5996185.57101 2089978.26988 37.7184637821573 -122.4551912491 (37.7184637821573, -122.4551912491) 9 8 6 28861 24
55 1166 1 31 2900 Alemany Blvd 1 Sidewalk: Curb side : Cutout Tree 1   11/23/2020 12:00:00 AM 25 3X3   5997012.91474 2087625.16187 37.7120501257788 -122.45216178836 (37.7120501257788, -122.45216178836) 9 7 6 28861 25
57 230549 1 32 39 Crescent Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/25/2020 12:00:00 AM 3 Width 3ft Permit Number 787877 6005359.28388 2095944.60166 37.7353680760624 -122.423905517743 (37.7353680760624, -122.423905517743) 2 7 7 28859 2
58 195132 1 27 825 Minnesota St 1 Sidewalk: Curb side : Cutout Tree 2   11/25/2020 12:00:00 AM 3 Width 3ft   6015253.79115 2104691.52976 37.7599389420381 -122.390307168065 (37.7599389420381, -122.390307168065) 10 3 8 28856 29
59 195131 1 27 851 Minnesota St 7 Sidewalk: Curb side : Cutout Tree 2   11/25/2020 12:00:00 AM 3 Width 3ft   6015252.45033 2104672.28083 37.7598860142382 -122.390310460464 (37.7598860142382, -122.390310460464) 10 3 8 28856 29
61 227151 1 33 48 Fair Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/25/2020 12:00:00 AM 3 Width 3ft Permit Number 787879 6006822.59734 2099508.62809 37.7452366012942 -122.419099008325 (37.7452366012942, -122.419099008325) 2 7 7 28859 2
66 132469 1 36 3135 Pierce St 4 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6001403 2119193 37.7989782820217 -122.43924964791 (37.7989782820217, -122.43924964791) 13 9 1 57 17
71 227799 1 37 1265 Stanyan St 2 Sidewalk: Curb side : Cutout Tree 2   12/01/2020 12:00:00 AM 17 6x6   5997473.24622 2105221.8097 37.760392645519 -122.451839397566 (37.760392645519, -122.451839397566) 15 5 11 29492 12
72 135801 1 7 16 Phoenix Ter 2 Sidewalk: Property side : Yard Tree 2     4 Width 2ft   6008610.92916 2117913.61927 37.7958729471262 -122.414217164494 (37.7958729471262, -122.414217164494) 5 1 10 308 21
73 127010 1 38 1931 Union St 2 Sidewalk: Curb side : Cutout Tree 2     12 Width 3ft   6003752.87677 2118634.51429 37.7975782631807 -122.431078412364 (37.7975782631807, -122.431078412364) 13 9 1 57 17
76 34164 1 19 2500 Broadway 3 Sidewalk: Curb side : Cutout Tree 2   07/22/1997 12:00:00 AM 5   Permit Number 38230 6001594.91074 2117340.13182 37.7939017096586 -122.438452751501 (37.7939017096586, -122.438452751501) 13 9 1 57 27
77 225344 1 38 207 Randall St 1 Sidewalk: Curb side : Cutout Tree 2     12 Width 3ft   6004214.46195 2097518.65353 37.7396253677099 -122.42797572342 (37.7396253677099, -122.42797572342) 2 7 5 63 7
78 237365 1 40 2463 Folsom St 1 Sidewalk: Curb side : Cutout Tree 2     3 Width 4ft   6008244.71386 2104091.00553 37.7578987598438 -122.414505749733 (37.7578987598438, -122.414505749733) 2 4 7 28859 19
79 121399 1 28 349X Cargo Way 1 Sidewalk: Curb side : Cutout Tree 1                              
80 260998 1 41 600X Lake Merced Blvd 1 Sidewalk: Property side : Yard Tree 4       10x10                      
82 251210 1 42 1170 Ingalls St 2 Sidewalk: Curb side : Cutout Tree 1   11/02/1992 12:00:00 AM                          
83 259099 1 11 600 Visitacion Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2019 12:00:00 AM 3                        
85 259368 1 3 1646 Revere Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF                            
86 239818 1 44 219 Moultrie St 1 Sidewalk: Curb side : Cutout Tree 2     8 Width 3ft   6007803 2098062 37.7413196437149 -122.415606526646 (37.7413196437149, -122.415606526646) 2 7 7 28859 2
87 259654 1 45 101x Cora St   Sidewalk: Curb side : Cutout Tree 1 FUF 06/01/2019 12:00:00 AM 3                        
88 259653 1 45 99x Cora St 2 Sidewalk: Curb side : Cutout Tree 1 FUF 06/01/2019 12:00:00 AM 3                        
89 259623 1 45 1498x Visitacion Ave 2 Sidewalk: Curb side : Cutout Tree 1 FUF 06/01/2019 12:00:00 AM 3                        
90 259864 1 1 1398x Brussels St   Sidewalk: Curb side : Cutout Tree 1 FUF 03/30/2019 12:00:00 AM 3                        
91 260225 1 10 2201x 22nd Ave 21 Sidewalk: Curb side : Cutout Tree 1 FUF 10/20/2018 12:00:00 AM 3                        
92 260521 1 46 3519x Kirkham St 3 Sidewalk: Curb side : Cutout Tree 1 FUF 07/27/2019 12:00:00 AM 3                        
93 260525 1 47 3437x Rivera St 1 Sidewalk: Curb side : Cutout Tree 1 FUF 07/27/2019 12:00:00 AM 3                        
95 261359 1 7 3 Bache St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6007238 2095678 37.7347419306018 -122.417391193891 (37.7347419306018, -122.417391193891) 2 7 7 28859 2
96 137041 1 31 1034 Sacramento St 5 Sidewalk: Curb side : Cutout Tree 2   05/28/2020 12:00:00 AM 3 Width 3ft   6009697.84819 2116804.05029 37.7928873337267 -122.410377820179 (37.7928873337267, -122.410377820179) 3 1 10 28857 21
97 261358 1 7 2x Bache St 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6007175 2095707 37.7348180134015 -122.417611061749 (37.7348180134015, -122.417611061749) 2 7 7 28859 2
98 261380 1 48 298x Leavenworth St 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6008523 2113477 37.7836861327236 -122.414207368753 (37.7836861327236, -122.414207368753) 7 10 9 28852 36
100 255131 1 28 401X Brotherhood Way 9 Sidewalk: Property side : Yard Tree 1                              
101 255229 1 11 300X Goettingen St 4 Sidewalk: Curb side : Cutout Tree 1 FUF                            
102 258152 1 49 500X Bryant St 2 Sidewalk: Curb side : Cutout Tree 1 FUF   3                        
103 253831 1 45 699X Polk St 5 Sidewalk: Curb side : Cutout Tree 2 DPW     3x3                      
104 260590 1 50 3099x Jennings St 3 Sidewalk: Curb side : Cutout Tree 1 FUF 08/20/2020 12:00:00 AM 3                        
105 70839 1 11 939 Howard St 1 Sidewalk: Curb side : Cutout Tree 2 FUF   12     6010931.16123 2112337.60471 37.780692593337 -122.405795716794 (37.780692593337, -122.405795716794) 14 2 9 28853 34
106 251438 1 41 2501X Santiago St 1 Median : Yard Tree 1                              
107 264818 1 51 101x Olmstead St 2 Sidewalk: Curb side : Cutout Tree 1   10/23/2020 12:00:00 AM 3                        
113 182915 1 45 2711 47th Ave 2 Sidewalk: Curb side : Cutout Tree 2     0 Width 0ft   5981812.2124 2096648.8938 37.7359443944789 -122.505367292654 (37.7359443944789, -122.505367292654) 1 8 3 29491 35
114 251458 1 50 651 Texas St 1 Sidewalk: Curb side : Cutout Tree 2   05/03/2017 12:00:00 AM 3 3x3                      
118 236256 1 27 151 Valencia St 1 : Tree 2     9 Width 4ft   6006073.15075 2108915.83898 37.7710243776945 -122.422358744984 (37.7710243776945, -122.422358744984) 8 2 9 28853 19
119 184195 1 45 1459 37th Ave 1 Sidewalk: Curb side : Cutout Tree 2     0 Width 0ft   5984624.9154 2105245.6219 37.759713770345 -122.49627690204 (37.759713770345, -122.49627690204) 1 8 3 56 35
120 141225 1 45 3 COMMONWEALTH AVE 1 Sidewalk: Curb side : Yard Tree 2     0 Width 0ft   5996479.075 2114520.1031 37.7858663452689 -122.455949967769 (37.7858663452689, -122.455949967769) 11 6 1 54 31
122 17067 1 54 1355 Oak St 1 Sidewalk: Curb side : Cutout Tree 1     12 3X3   6000506.9486 2109572.2346 37.7725111167076 -122.441659471159 (37.7725111167076, -122.441659471159) 15 5 11 29492 9
123 221263 1 55 1 Church St 1 Sidewalk: Property side : Yard Tree 2     7 Width 6ft   6004132.36771 2108477.00924 37.7697097883113 -122.429040680782 (37.7697097883113, -122.429040680782) 7 9 5 29492 10
124 114040 1 56 95 LINARES AVE 1 Front Yard : Yard Tree 1     40 3x3   5994258 2102054 37.7515099774588 -122.462729551044 (37.7515099774588, -122.462729551044) 1 8 4 29491 40
126 173890 1 58 2593 23rd Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5989209 2097724 37.7393288482101 -122.479872589648 (37.7393288482101, -122.479872589648) 1 8 3 29491 35
127 119777 1 59 204x Octavia St 12 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
129 107934 1 17 3098X Market St 3 Median : Yard Tree 1           5999920 2105144 37.7603188321069 -122.44337164916 (37.7603188321069, -122.44337164916) 2 4 5 28862 3
130 13128 1 61 1714 Lombard St 1 Sidewalk: Curb side : Cutout Tree 1     40 3X3   6004131.2449 2119777.2826 37.8007374433085 -122.429850711739 (37.8007374433085, -122.429850711739) 13 9 1 57 17
132 182257 1 45 1439 35th Ave 1 Sidewalk: Curb side : Yard Tree 2     0 Width 0ft   5985240.365 2105399.9729 37.7601736080068 -122.494159774452 (37.7601736080068, -122.494159774452) 1 8 3 56 35
133 211075 1 63 650x Miramar Ave 6 Median : Yard Tree 1     34     5995390.83549 2093912.64173 37.7292209976493 -122.458222905073 (37.7292209976493, -122.458222905073) 9 7 4 28861 40
134 257900 1 11 5701x 03rd St 7 Sidewalk: Curb side : Cutout Tree 1       3x3   6014158 2092336 37.7259523956068 -122.393232416121 (37.7259523956068, -122.393232416121) 10 3 8 58 1
136 11131 1 9 2400X Hyde St 4 Sidewalk: Curb side : Cutout Tree 1     18 3X3   6007074.9072505 2120528.613771 37.802966665104 -122.419717737051 (37.802966665104, -122.419717737051) 5 1 1 28858 32
137 189330 1 64 1427x Innes Ave 23 Median : Yard Tree 1     15     6016163.75351 2096735.77367 37.7381445215441 -122.386605256348 (37.7381445215441, -122.386605256348) 10 3 8 58 1
138 203559 1 65 145 Lakeview Ave 1 : Tree 2     1 Width 3ft   5997146.51683 2089373.33367 37.7168578537955 -122.45182605794 (37.7168578537955, -122.45182605794) 9 8 6 28861 24
139 106382 1 17 182x Lower Ter 9 Median : Cutout Tree 1       10x10   6000081.12192 2106216.81045 37.7632736910742 -122.442891445737 (37.7632736910742, -122.442891445737) 15 5 5 28862 3
141 254165 1 45 579 39th Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5983759 2111886 37.7778955894485 -122.499762435435 (37.7778955894485, -122.499762435435) 11 6 2 55 26
142 186181 1 45 1700 37th Ave 1 Sidewalk: Curb side : Yard Tree 2     0 Width 0ft   5984741.0761 2103142.2522 37.75394530503 -122.495720014116 (37.75394530503, -122.495720014116) 1 8 3 56 35
143 251305 1 62 1 Cashmere St 4 Back Yard : Yard Tree 2       3x3   6017463 2095772 37.7355700327415 -122.382046041696 (37.7355700327415, -122.382046041696) 10 3 8 58 1
145 193492 1 58 1918 23rd St 1 Front Yard : Yard Tree 2     9     6012632.36685 2102863.5529 37.7547739610597 -122.399245141377 (37.7547739610597, -122.399245141377) 10 3 8 28856 29
146 190658 1 45 1461 Fairfax Ave 4 : Tree 2     7 Width 3ft   6016241.73559 2097685.48667 37.7407565574799 -122.386401828788 (37.7407565574799, -122.386401828788) 10 3 8 58 1
147 198543 1 31 1700 Newcomb Ave 1 : Tree 2     3 Width 0ft   6014375.16951 2096346.21278 37.7369756879815 -122.392762090617 (37.7369756879815, -122.392762090617) 10 3 8 58 1
150 247856 1 64 80 Bradford St 5 Side Yard : Yard Tree 2     32     6009566.84713 2098148.32022 37.7416556510973 -122.409513828008 (37.7416556510973, -122.409513828008) 10 7 7 28859 2
151 233915 1 34 998 York St 9 Sidewalk: Curb side : Yard Tree 2     1 Width 7ft   6009943.01185 2103432.65253 37.7561863328563 -122.408585854469 (37.7561863328563, -122.408585854469) 2 4 7 28859 19
152 235666 1 7 1301 Jessie St 4 : Tree 2     3 Width 2ft   6006462.25734 2109005.38337 37.7712921868165 -122.421019169707 (37.7712921868165, -122.421019169707) 8 2 9 28853 19
153 185313 1 66 2601 Sunset Blvd 38 Sidewalk: Property side : Yard Tree 2     3 Width 0ft   5984983.1747 2097234.3473 37.7377379790483 -122.494447317023 (37.7377379790483, -122.494447317023) 1 8 3 29491 35
154 119838 1 31 301x Octavia St 11 Median : Cutout Tree 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)