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                        
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
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
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
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
29 264952 6 17 20X Cleary Ct 2 Front Yard : Yard Tree 2   11/13/2020 12:00:00 AM 3     6004818 2113712 37.7841225773231 -122.427042012496 (37.7841225773231, -122.427042012496) 13 9 11 28858 41
31 264951 6 17 20X Cleary Ct 1 Front Yard : Yard Tree 2   11/13/2020 12:00:00 AM 3     6004818 2113712 37.7841225773231 -122.427042012496 (37.7841225773231, -122.427042012496) 13 9 11 28858 41
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
60 264971 9 31 150 17th Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/25/2020 12:00:00 AM 3     5990555.23468 2114396.47455 37.7851851170506 -122.476435559205 (37.7851851170506, -122.476435559205) 11 6 2 54 26
65 264979 4 35 2450 California St 1 Front Yard : Yard Tree 3           6002592 2115500 37.7889058459562 -122.434871073784 (37.7889058459562, -122.434871073784) 13 9 1 29490 27
67 99921 5 9 1740 Jones St 1 Front Yard : Yard Tree 2   06/01/2015 12:00:00 AM 3   Permit Number 774389 6008331.64636 2118443.68708 37.7973126906849 -122.415221079511 (37.7973126906849, -122.415221079511) 5 1 10 308 21
74 106076 7 17 2500 Arelious Walker Dr 13 Sidewalk: Curb side : Cutout Tree 2         Permit Number 772788 6016510.6 2089868.7 37.7193080887588 -122.384927739753 (37.7193080887588, -122.384927739753) 10 3 8 58 1
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
79 121399 1 28 349X Cargo Way 1 Sidewalk: Curb side : Cutout Tree 1                              
81 46536 7 17 73 Summer St 2 Sidewalk: Curb side : Cutout Tree 2   04/01/2002 12:00:00 AM     Permit Number 44686                    
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                        
84 254457 6 43 1055X Duncan St 2 Side Yard : Yard Tree 2                              
85 259368 1 3 1646 Revere Ave 1 Sidewalk: Curb side : Cutout Tree 1 FUF                            
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                        
99 255073 9 17 173R Glenview Dr   Back Yard : Yard Tree 2                              
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                        
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                        
108 44866 7 17   25 Sidewalk: Curb side : Cutout Tree 2   04/25/2001 12:00:00 AM     Permit Number 43922                    
109 34921 7 17   1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 38517                    
110 45916 7 17   51 Sidewalk: Curb side : Cutout Tree 2   12/06/2001 12:00:00 AM     Permit Number 44451                    
111 97355 7 17   5 Unaccepted Street : Yard Tree 2                              
112 33929 7 17   4 Sidewalk: Curb side : Cutout Tree 2   03/25/1997 12:00:00 AM     Permit Number 37893                    
117 108152 4 53 2232 Webster St 4 Sidewalk: Curb side : Cutout Tree 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
125 92934 4 57 339 West Portal Ave 1 Sidewalk: Curb side : Cutout Tree 2     10     5992211 2096907 37.737259523291 -122.46943364564 (37.737259523291, -122.46943364564) 1 8 4 59 40
127 119777 1 59 204x Octavia St 12 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
128 110722 4 60 1898X 10th Ave 3 Sidewalk: Curb side : Cutout Tree 2           5993137.43282 2102888.05903 37.753735486992 -122.466665198088 (37.753735486992, -122.466665198088) 1 8 4 56 12
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
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
135 99586 7 17 2299 Market St 4 Sidewalk: Curb side : Cutout Tree 2           6002978.6 2106459.9 37.7641059209125 -122.432887400675 (37.7641059209125, -122.432887400675) 15 4 5 28862 3
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
144 108797 4 45 501-599 University St 4 Sidewalk: Curb side : Cutout Tree 2           6008503.45306 2091469.83252 37.7232583218261 -122.412718672961 (37.7232583218261, -122.412718672961) 9 3 7 309 18
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
148 108238 4 17 764x JUNIPERO SERRA BLVD 1 Median : Yard Tree 2           5991289.6 2092496.8 37.7250969308873 -122.472297921456 (37.7250969308873, -122.472297921456) 9 8 4 64 40
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
154 119838 1 31 301x Octavia St 11 Median : Cutout Tree 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
158 100607 7 17 270x 05th St 5 Sidewalk: Curb side : Cutout Tree 2           6011410.5 2112131.8 37.7801542961347 -122.404122955966 (37.7801542961347, -122.404122955966) 14 2 9 28853 34
159 117627 4 15 890x VERMONT ST 4 Unaccepted Street : Yard Tree 2           6011292 2104239 37.7584758425658 -122.403977311201 (37.7584758425658, -122.403977311201) 10 3 8 28856 29
160 107490 1 68 1306x Montgomery St 19 Median : Cutout Tree 1     12     6011447.18476 2119974.76336 37.8016912541172 -122.404548295963 (37.8016912541172, -122.404548295963) 3 1 10 308 23
161 194506 1 15 299x Cashmere St 26 Median : Yard Tree 1     18     6016624.93937 2096021.78221 37.7362095654157 -122.384960961105 (37.7362095654157, -122.384960961105) 10 3 8 58 1
164 116129 4 17 1601X Armstrong Ave 1 Sidewalk: Curb side : Cutout Tree 5           6014258.08027 2092570.23406 37.7266011147526 -122.392902822978 (37.7266011147526, -122.392902822978) 10 3 8 58 1
165 104843 7 45 1320 21st Ave   Sidewalk: Curb side : Cutout Tree 2           5989622 2106334.7 37.7629955389606 -122.479074319647 (37.7629955389606, -122.479074319647) 1 8 3 56 35
168 222969 1 69 1300 San Jose Ave 47 Front Yard : Yard Tree 2     16     6003392.92926 2095549.99469 37.7341733681018 -122.430675784084 (37.7341733681018, -122.430675784084) 2 7 5 63 7
170 108637 8 15 15 TUCKER AVE   Back Yard : Yard Tree 2           6011049.2 2088423.2 37.7150354478954 -122.403704200211 (37.7150354478954, -122.403704200211) 9 7 8 309 39
171 50655 7 17 430 Raymond Ave 1 Sidewalk: Curb side : Cutout Tree 2         Permit Number 47238 6008643.36799877 2088325.11427356 37.7146314352433 -122.412012884014 (37.7146314352433, -122.412012884014) 9 7 8 309 18
174 113728 6 36 1580 Valencia St 5 Front Yard : Yard Tree 2           6006496 2100402 37.747671200831 -122.420291724307 (37.747671200831, -122.420291724307) 2 7 7 28859 2
176 194490 1 15 1501 22nd St 19 Front Yard : Yard Tree 2     29     6013346.63868 2103825.44695 37.7574548949481 -122.396842409144 (37.7574548949481, -122.396842409144) 10 3 8 28856 29
181 14420 1 16 2X Masonic Ave 8 Median : Cutout Tree 1     35     5998841.5976 2113071.3194 37.7820236767836 -122.447671998063 (37.7820236767836, -122.447671998063) 15 5 2 54 16
183 253381 1 71 899 Waller St 3 Side Yard : Yard Tree 2           6001282 2108613 37.7699214264211 -122.438909742148 (37.7699214264211, -122.438909742148) 15 5 5 29492 9
187 112917 1 66 480X BEACON ST 1 Sidewalk: Property side : Yard Tree 1           6002571 2098077 37.7410653426557 -122.433697996676 (37.7410653426557, -122.433697996676) 2 7 5 63 7
189 178694 1 7 184 Mount Vernon Ave 7 Side Yard : Yard Tree 2     9     5998957.82756 2089383.479 37.7169892861082 -122.445565994978 (37.7169892861082, -122.445565994978) 9 7 6 28861 25
193 100595 7 17 401x Clementina St 10 Sidewalk: Curb side : Cutout Tree 2           6011466.9 2112295.6 37.7806072039402 -122.403939371598 (37.7806072039402, -122.403939371598) 14 2 9 28853 34
195 101535 7 17 1X Main St 12 Sidewalk: Curb side : Cutout Tree 2         Permit Number 46305 6014036.2 2116698.9 37.7928408582284 -122.395359428861 (37.7928408582284, -122.395359428861) 12 2 9 28855 6
197 104920 4 72 750 Gonzalez Dr 1 Median : Yard Tree 2           5990385 2090588 37.7198034465129 -122.47528570222 (37.7198034465129, -122.47528570222) 1 8 4 64 14
202 190636 1 73 1 01st St 30 : Yard Tree 2     8     6014391.99798 2105898.86804 37.7632061898228 -122.393372206868 (37.7632061898228, -122.393372206868) 14 3 8 28856 29
203 56596 7 17 536 Laidley St 1 Sidewalk: Curb side : Cutout Tree 2           6003173.97949504 2096124.55404861 37.7357385703685 -122.431473765394 (37.7357385703685, -122.431473765394) 2 7 5 63 7
205 61223 7 17 420 Montgomery St 1 Sidewalk: Curb side : Cutout Tree 2   11/18/1983 12:00:00 AM     Permit Number 21092 6011911.40369591 2116824.99897206 37.793068691891 -122.402720238707 (37.793068691891, -122.402720238707) 4 1 10 28854 6
206 119799 1 31 201x Octavia St 7 Median : Cutout Tree 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
208 107457 4 68 2682 16TH AVE 1 Sidewalk: Curb side : Cutout Tree 2           5991487.4 2097177.7 37.7379609526954 -122.471955163509 (37.7379609526954, -122.471955163509) 1 8 4 29491 40
215 119692 1 59 4x Octavia St 10 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
220 64608 7 17 2449 Folsom St 1 Sidewalk: Curb side : Cutout Tree 2   08/18/1988 12:00:00 AM     Permit Number 25511 6008240.06203716 2104170.72475134 37.75811738928 -122.414527478763 (37.75811738928, -122.414527478763) 2 4 7 28859 19
222 59632 7 17 1726 Grove St 1 Sidewalk: Curb side : Cutout Tree 2   10/07/1982 12:00:00 AM     Permit Number 19874 5999538.23629958 2110533.95574653 37.7750965176114 -122.445079484139 (37.7750965176114, -122.445079484139) 15 5 11 29492 16
223 65500 7 17 5322 Geary Blvd 1 Sidewalk: Curb side : Cutout Tree 2   12/19/1989 12:00:00 AM     Permit Number 28384 5990524.68926015 2112731.41132738 37.7806115451711 -122.47641956102 (37.7806115451711, -122.47641956102) 11 6 2 55 26
225 119839 1 31 301x Octavia St 12 Median : Cutout Tree 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
226 56655 7 17 491 Bright St 1 Sidewalk: Curb side : Cutout Tree 2           5993749.22353597 2090472.28724098 37.7196801529508 -122.463648462413 (37.7196801529508, -122.463648462413) 9 8 6 64 24
227 102275 8 17 267 Topaz Way   Back Yard : Yard Landscaping 2           6001225.6 2097744.2 37.7400751189117 -122.438326054857 (37.7400751189117, -122.438326054857) 2 7 5 63 7
230 114428 4 15 34x HIGUERA AVE 2 Median : Yard Tree 2     56     5987903 2090420 37.7191979850677 -122.483852684784 (37.7191979850677, -122.483852684784) 1 8 4 64 14
231 116978 4 76 111 BAY ST 4 Front Yard : Yard Tree 2           6010550 2121704 37.8063891294227 -122.407774985143 (37.8063891294227, -122.407774985143) 3 1 10 308 23
233 100684 4 17 400 California St 3 Sidewalk: Curb side : Pot Tree 2           6012367 2116823 37.7930886299645 -122.401143699021 (37.7930886299645, -122.401143699021) 4 1 10 28854 6
238 119796 1 31 201x Octavia St 4 Median : Cutout Tree 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
241 57687 7 17 4124 21st St 1 Sidewalk: Curb side : Cutout Tree 2   12/10/1976 12:00:00 AM     Permit Number 16590 6001721.25492757 2103540.26074256 37.7560179062476 -122.437027141607 (37.7560179062476, -122.437027141607) 2 4 5 28862 3
245 251484 1 15 900 Bosworth St 7 Front Yard : Yard Tree 1           6001649 2095572 37.7341348351459 -122.436706663072 (37.7341348351459, -122.436706663072) 9 7 5 63 7
246 136052 1 77 1114 Greenwich St 1 Side Yard : Yard Tree 2     3     6007569.13805 2119905.68389 37.801284085155 -122.417963252702 (37.801284085155, -122.417963252702) 5 1 1 28858 32
247 240348 1 78 1201 San Jose Ave 26 Front Yard : Yard Tree 2     1     6004340.86769 2095971.00866 37.7353830362869 -122.427428442788 (37.7353830362869, -122.427428442788) 2 7 5 28861 2
248 119766 1 59 204x Octavia St 1 Median : Cutout Tree 1           2109391 6005718 47.2699873738681 -138.2836696503 (47.2699873738681, -138.2836696503)          
251 187669 1 41 554 Valley St 1 Median : Yard Tree 2           6002324 2099197 37.7441265828549 -122.434632098307 (37.7441265828549, -122.434632098307) 2 7 5 63 22