trees

Custom SQL query returning 101 rows (hide)

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
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
34 262408 8 15 66X Edgehill Way 1 Unaccepted Street : Yard Tree 2       3x3   5994840 2098758 37.7424934921887 -122.46047813267 (37.7424934921887, -122.46047813267) 1 8 4 59 40
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
47 264965 4 10 951 Capitol Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5994993 2090257 37.7191606150529 -122.45933361899 (37.7191606150529, -122.45933361899) 9 8 6 28861 24
50 264964 6 28 3641 California St 1 Sidewalk: Curb side : Cutout Tree 2       3X3   5996989 2114619 37.7861671437011 -122.454192924446 (37.7861671437011, -122.454192924446) 11 6 1 54 31
52 264970 4 1 1026 Ingerson Ave 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6014048 2089990 37.7195046364539 -122.393448574201 (37.7195046364539, -122.393448574201) 10 3 8 58 1
53 264969 4 30 1099X Hollister Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF     15x15   6014337 2089983 37.719501468928 -122.392449109694 (37.719501468928, -122.392449109694) 10 3 8 58 1
62 264980 6 22 222 Winfield St 1 Front Yard : Yard Tree 2       3x3   6006740 2098205 37.7416524795013 -122.419292156581 (37.7416524795013, -122.419292156581) 2 7 7 28859 2
63 264975 6 15 445 Ortega St 1 Front Yard : Yard Tree 2       10x30   5992686 2102646 37.7530447932571 -122.468208733714 (37.7530447932571, -122.468208733714) 1 8 4 56 12
64 264974 6 34 1868 Greenwich St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6003954 2119422 37.7997518904289 -122.430438688757 (37.7997518904289, -122.430438688757) 13 9 1 57 17
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
68 264976 6 15 445 Ortega St 2 Front Yard : Yard Tree 2       10x30   5992686 2102646 37.7530447932571 -122.468208733714 (37.7530447932571, -122.468208733714) 1 8 4 56 12
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
75 74661 7 39 165-167 11th St 3 Sidewalk: Curb side : Cutout Tree 2   07/07/2009 12:00:00 AM   3x3 Permit Number 52456 6007907.04639866 2109821.22082045 37.7736136206967 -122.416079354056 (37.7736136206967, -122.416079354056) 8 2 9 28853 34
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                      
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                          
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                            
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
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
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                            
103 253831 1 45 699X Polk St 5 Sidewalk: Curb side : Cutout Tree 2 DPW     3x3                      
106 251438 1 41 2501X Santiago St 1 Median : Yard Tree 1                              
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                    
115 121173 6 17 950 Duncan St 2 Front Yard : Yard Tree 2       3x3   6000333 2099683 37.7453477932295 -122.441551386161 (37.7453477932295, -122.441551386161) 2 7 5 63 22
116 113159 4 52 555 GROVE ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6005146 2111243 37.777361853017 -122.425731455878 (37.777361853017, -122.425731455878) 7 9 11 28852 10
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
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)          
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
131 109387 4 62 300X BAKER ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6000704 2110147 37.7741005029649 -122.441019094263 (37.7741005029649, -122.441019094263) 15 5 11 29492 16
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
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
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
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
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
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
154 119838 1 31 301x Octavia St 11 Median : Cutout Tree 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
157 114186 4 66 2200 HAYES ST 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5997096 2109871 37.7731365175856 -122.453479795748 (37.7731365175856, -122.453479795748) 15 5 2 29492 16
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
162 105806 4 17 1248X ANZA ST   Sidewalk: Curb side : Cutout Tree 2       6x3   5994834 2112130 37.7792092085373 -122.461468091676 (37.7792092085373, -122.461468091676) 11 6 2 54 11
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
169 258020 1 17 1001X San Jose Ave 1 Side Yard : Yard Tree 2       3x3   6004855 2096548 37.7369963898236 -122.425691948858 (37.7369963898236, -122.425691948858) 2 7 5 28859 2
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
177 253253 6 70 99X Lopez Ave 4 Front Yard : Yard Tree 2       10x10   5994049 2100330 37.746764271907 -122.463327202712 (37.746764271907, -122.463327202712) 1 8 4 29491 40
179 113995 1 45 3221 Washington St 1 Sidewalk: Curb side : Cutout Landscaping 2   10/27/2015 12:00:00 AM   39x3   5999265.7 2115942.6 37.789931692457 -122.446411428366 (37.789931692457, -122.446411428366) 13 6 1 29490 31
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
188 112351 4 67 150 WEST PORTAL AVE 1 Sidewalk: Curb side : Cutout Tree 2       3x3   5992711 2097652 37.7393339885882 -122.467759098278 (37.7393339885882, -122.467759098278) 1 8 4 59 40
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
194 112359 4 17 1129 DOUGLASS ST 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6001379 2100423 37.7474391957634 -122.437987492815 (37.7474391957634, -122.437987492815) 2 4 5 63 22
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
196 116631 4 9 5732X GEARY BLVD 12 Front Yard : Cutout Tree 3 DPW     3x3   5989254 2112678 37.780391116482 -122.480811519646 (37.780391116482, -122.480811519646) 11 6 2 55 26
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
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)          
207 251656 1 17 31x Malta Dr 1 unknown : Yard Tree 2       3x3   5999423 2096089 37.7354276387403 -122.44443976141 (37.7354276387403, -122.44443976141) 9 7 4 63 40
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)          
216 114440 1 75 2961 SAN BRUNO AVE 1 Sidewalk: Curb side : Cutout Tree 1       3x3   6011605 2091859 37.724500488626 -122.402024501601 (37.724500488626, -122.402024501601) 10 3 7 309 28
217 105438 4 45 1116 Castro St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6002483 2102334 37.7527490702591 -122.434306541099 (37.7527490702591, -122.434306541099) 2 4 5 28862 22
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
228 256437 4 15 3001 Sunset Blvd 25 Median : Yard Tree 2       10x10   5984960 2094729 37.7308576064943 -122.49434282122 (37.7308576064943, -122.49434282122) 1 8 4 64 35
229 121402 4 45 346X Duncan St 1 Back Yard : Yard Tree 2       3x3   6004011 2099874 37.7460810947058 -122.428847079389 (37.7460810947058, -122.428847079389) 2 7 5 63 22
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
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
256 254254 6 15 45X Everglade Dr 1 Sidewalk: Property side : Yard Tree 2       3x3   5986312 2095495 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139) 1 8 4 64 35
257 115298 7 45 84 Forest Side Ave 1 Sidewalk: Curb side : Cutout Tree 2           5992506.3 2098571.2 37.7418460572185 -122.468533715231 (37.7418460572185, -122.468533715231) 1 8 4 29491 40
260 56449 7 17 1439 43rd Ave 1 Sidewalk: Curb side : Cutout Tree 2           5982754.68200032 2105326.56088651 37.7598262733968 -122.502750996927 (37.7598262733968, -122.502750996927) 1 8 3 56 35
261 119280 4 53 95 Miramar Ave 2 Sidewalk: Curb side : Cutout Tree 2       3x3   5995293 2090512 37.7198780283713 -122.458315087488 (37.7198780283713, -122.458315087488) 9 8 6 28861 24
273 117070 9 17 6 JOY ST 3 Front Yard : Yard Tree 2           6010444 2098901 37.7437714571602 -122.406533939617 (37.7437714571602, -122.406533939617) 2 7 7 28859 2
277 110381 4 62 2235 PALOU AVE 1 Sidewalk: Curb side : Cutout Tree 2       27x18   6011689 2097713 37.740579036374 -122.402145495204 (37.740579036374, -122.402145495204) 10 3 8 58 1
282 119806 1 84 251X Octavia St Frontage West 3 Sidewalk: Curb side : Cutout Tree 1       3x3   6005545 2110174 37.7744491774234 -122.424275134654 (37.7744491774234, -122.424275134654) 7 9 11 28852 10
294 53493 7 17 262 Ralston St 1 Sidewalk: Curb side : Cutout Tree 2   11/04/1969 12:00:00 AM     Permit Number 6403 5992228.28376051 2089608.56362168 37.717220822263 -122.468842940668 (37.717220822263, -122.468842940668) 9 8 6 64 24
297 113036 1 17 242X 07TH AVE 1 Sidewalk: Curb side : Cutout Tree 4       3x3   5993686 2113852 37.7838712122002 -122.46556459896 (37.7838712122002, -122.46556459896) 11 6 2 54 11