trees

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
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
84 254457 6 43 1055X Duncan St 2 Side Yard : Yard Tree 2                              
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
394 119605 6 41 299x Avalon Ave 1 Front Yard : Yard Tree 2                              
803 105089 6 45 344 Fulton St 9 Front Yard : Yard Tree 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
1051 251262 6 41 3630x 19th Ave 1 Sidewalk: Property side : Yard Tree 2         Permit Number 779147                    
1408 260469 6 185 1 Masonic Ave 4 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
1475 80073 6 84 2788 34th Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF   3     5985889.2586 2096432.3825 37.735588983385 -122.491255586179 (37.735588983385, -122.491255586179) 1 8 3 64 35
1875 261661 6 70 741 30th Ave 1 Sidewalk: Curb side : Yard Tree 2 FUF         5986614 2110873 37.7752812973329 -122.489811603249 (37.7752812973329, -122.489811603249) 11 6 2 55 26
2008 106059 6 203 339 FILBERT ST 1 Front Yard : Yard Tree 2     6     6011263.6 2119947.8 37.801606957686 -122.405181687156 (37.801606957686, -122.405181687156) 3 1 10 308 23
2201 107549 6 17 198X Jennings St 2 Front Yard : Yard Tree 1   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018784.70414 2097136.12526 37.7393885572332 -122.377570991407 (37.7393885572332, -122.377570991407) 10 3 8 58 1
2321 48402 6 40 706 Wisconsin St 1 Sidewalk: Property side : Yard Tree 2   11/19/2010 12:00:00 AM     Permit Number 53935 6012689.64928807 2104214.1545054 37.7584856101735 -122.399141839868 (37.7584856101735, -122.399141839868) 10 3 8 28856 29
2352 101748 6 15 700X Panorama Dr 1 Back Yard : Yard Tree 2           5997177.2 2102739.1 37.7535587877907 -122.452684092588 (37.7535587877907, -122.452684092588) 1 5 4 63 38
3054 109568 6 155 95 Nordhoff St 1 Back Yard : Yard Tree 2         Permit Number 777169 6000348.8 2095645.6 37.7342629464917 -122.441207129815 (37.7342629464917, -122.441207129815) 9 7 5 63 40
3096 100121 6 62 690 Miramar Ave 1 Front Yard : Yard Tree 2           5995444.4 2093941.6 37.7293035878447 -122.458039824042 (37.7293035878447, -122.458039824042) 9 7 4 28861 40
3099 104652 6 97 953 Indiana St 1 Front Yard : Cutout Tree 2           6015057.1 2104275.7 37.7587862506702 -122.390958369803 (37.7587862506702, -122.390958369803) 10 3 8 28856 29
3171 119608 6 185 299x Avalon Ave 4 Front Yard : Yard Tree 2                              
3182 261252 6 21 100 Collins St 1 Front Yard : Cutout Tree 2   12/18/2019 12:00:00 AM 3                        
3184 260470 6 185 1 Masonic Ave 5 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
3436 103654 6 17 307X Octavia St 3 Front Yard : Yard Tree 14   06/07/2013 12:00:00 AM     Permit Number 770306 6005538.74006 2110314.20336 37.7748337884081 -122.424306762839 (37.7748337884081, -122.424306762839) 7 9 11 28852 10
3682 261986 6 70 1500 Bancroft Ave 3 Front Yard : Yard Tree 2           6014696 2091834 37.7246038778524 -122.391337493735 (37.7246038778524, -122.391337493735) 10 3 8 58 1
3726 94934 6 265 2451X Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.387194089236 (37.7197277910807, -122.387194089236) 10 3 8 58 1
3910 173844 6 63 2X Crestline Dr 1 Front Yard : Yard Tree 2           5999319 2101169 37.7493701671822 -122.445164434644 (37.7493701671822, -122.445164434644) 2 5 5 63 38
4207 247626 6 138 286 Bradford St 1 Front Yard : Yard Tree 2     8     6009494.96271 2096975.40444 37.7384310509429 -122.409679612625 (37.7384310509429, -122.409679612625) 10 7 7 28859 2
4313 105327 6 17 2051 03rd St 1 Back Yard : Yard Tree 2         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631) 14 3 8 28856 29
4934 103659 6 17 350X Hickory St 3 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
5213 84938 6 52 145 Guerrero St 1 Front Yard : Yard Tree 2         Permit Number 49347 6005480 2108218 37.7690748022624 -122.42436083172 (37.7690748022624, -122.42436083172) 8 4 5 28853 19
5510 104813 6 28 1601X Portola Dr 5 Front Yard : Yard Tree 2                              
5622 251139 6 17 621X Gough St 1 Back Yard : Yard Tree 2   03/10/2017 12:00:00 AM 3   Permit Number 779685                    
5747 94949 6 116 50 Pomona St   : Cutout Tree 4 FUF 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.393495086444 (37.7317422564721, -122.393495086444) 10 3 8 58 1
6097 95161 6 216 2721 Pacific Ave   Front Yard : Yard Tree 2         Permit Number 54078 6001026.7 2116843.3 37.7925052022591 -122.440383162252 (37.7925052022591, -122.440383162252) 13 6 1 29490 27
6178 247627 6 138 286 Bradford St 2 Front Yard : Yard Tree 2     9     6009494.82009 2096968.41626 37.7384118549208 -122.409679612627 (37.7384118549208, -122.409679612627) 10 7 7 28859 2
6334 104866 6 15 411 Holladay Ave 1 Front Yard : Yard Tree 2           6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202) 10 7 7 28859 2
6758 95372 6 15 180 Yukon St   Back Yard : Cutout Tree 2     15   Permit Number 767755 6000174.3 2103956.9 37.7570738455347 -122.442406920559 (37.7570738455347, -122.442406920559) 2 4 5 28862 3
6834 103660 6 17 350X Hickory St 4 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
7000 251607 6 15 52 Amber Dr 2 Back Yard : Yard Tree 2           5999455 2100046 37.7462944425817 -122.444613441074 (37.7462944425817, -122.444613441074) 2 7 5 63 22
7030 260467 6 36 1 Masonic Ave 2 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
7039 119606 6 62 299x Avalon Ave 2 Front Yard : Yard Tree 2                              
7196 251612 6 15 60R Amber Dr 1 Back Yard : Yard Tree 2           5999394 2100048 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752) 2 7 5 63 22
7291 105130 6 17 4045 MORAGA ST   Sidewalk: Property side : Yard Tree 2           5981665.2 2103465.9 37.7546533409301 -122.506380933635 (37.7546533409301, -122.506380933635) 1 8 3 56 35
7310 96412 6 216 185 Chilton Ave   Front Yard : Yard Tree 2   05/18/2011 12:00:00 AM     Permit Number 767805 6001587.1 2095138.7 37.732941575251 -122.436889661497 (37.732941575251, -122.436889661497) 9 7 5 63 40
7373 96567 6 14 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
7389 119599 6 185 4357x Mission St 1 Front Yard : Yard Tree 2         Permit Number 774415                    
7411 103658 6 17 350X Hickory St 2 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
7770 98170 6 3 2324 Sacramento St   Front Yard : Yard Tree 2   12/22/2011 12:00:00 AM 3   Permit Number 768454 6003670.2 2115963.1 37.7902385582714 -122.431173718492 (37.7902385582714, -122.431173718492) 13 9 1 29490 27
7964 105328 6 17 2051 03rd St 2 Back Yard : Yard Tree 2         Permit Number 771015 6015779.9 2106081.5 37.7637846705736 -122.388584622631 (37.7637846705736, -122.388584622631) 14 3 8 28856 29
8007 261753 6 51 127 Edgehill Way 3 Back Yard : Cutout Tree 2   02/25/2020 12:00:00 AM 3     5994849.50332 2098967.43632 37.7430690988325 -122.46046044555 (37.7430690988325, -122.46046044555) 1 8 4 59 40
8163 82435 6 15 51 Peralta Ave 1 Front Yard : Yard Tree 2   04/02/2005 12:00:00 AM 20     6010636.52703341 2100363.58782589 37.7477981742678 -122.405971235802 (37.7477981742678, -122.405971235802) 2 7 7 28859 2
8218 100711 6 17 966-968 Guerrero St 1 Front Yard : Yard Tree 2   09/27/2012 12:00:00 AM 14   Permit Number 769148 6005605.8 2103343.5 37.7556976788024 -122.423579088745 (37.7556976788024, -122.423579088745) 2 4 5 28859 19
8301 114726 6 45 520 Townsend St 2 Front Yard : Yard Tree 2           6012508.1 2109575.3 37.7731959986981 -122.400146236912 (37.7731959986981, -122.400146236912) 14 2 9 28853 34
8454 247630 6 138 286 Bradford St 5 Front Yard : Yard Tree 2     7     6009492.89578 2096949.07994 37.7383586537362 -122.409684901541 (37.7383586537362, -122.409684901541) 10 7 7 28859 2
8456 99698 6 127 1750 Divisadero St 1 Front Yard : Cutout Tree 2           6001124 2114376 37.7857361748448 -122.439869519979 (37.7857361748448, -122.439869519979) 15 6 1 29490 27
8509 103668 6 17 350X Hickory St 6 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
8535 251265 6 41 3630x 19th Ave 4 Sidewalk: Property side : Yard Tree 2         Permit Number 779147                    
9206 114067 6 37 6 Higuera Ave 1 Front Yard : Cutout Tree 2     20     5987898 2090420 37.7191976939958 -122.48386996767 (37.7191976939958, -122.48386996767) 1 8 4 64 14
9218 106080 6 13 188 The Embarcadero 1 Front Yard : Yard Tree 2   03/20/2014 12:00:00 AM     Permit Number 771259 6015087.8131 2116516.98611 37.7923997963133 -122.391708043282 (37.7923997963133, -122.391708043282) 12 2 9 28855 6
9674 97174 6 1 26 Gilbert St   Sidewalk: Property side : Cutout Tree 2 FUF         6011445.1 2110013.2 37.7743390438118 -122.40385413458 (37.7743390438118, -122.40385413458) 14 2 9 28853 34
9862 114526 6 15 1 TIOGA AVE 2 Sidewalk: Curb side : Yard Tree 2           6011351 2088602 37.7155432513192 -122.402673611341 (37.7155432513192, -122.402673611341) 9 7 8 309 39
9889 116075 6 17 88 MONTCALM ST 1 Front Yard : Yard Tree 2           6010492 2099980 37.7467368416425 -122.406443980671 (37.7467368416425, -122.406443980671) 2 7 7 28859 2
9964 262274 6 155 4 Montclair Ter 1 Side Yard : Yard Tree 2           6007298.70359 2120216.09204 37.8021211637502 -122.418921105258 (37.8021211637502, -122.418921105258) 5 1 1 28858 32
9966 251172 6 15 363 Jersey St 2 Front Yard : Yard Tree 2           6002784.74363 2101501.25508 37.750479672211 -122.433203561601 (37.750479672211, -122.433203561601) 2 4 5 28862 22
9997 104935 6 37 835 Gonzalez Dr 1 Front Yard : Yard Tree 2           5990419 2090610 37.7198658237335 -122.475169782631 (37.7198658237335, -122.475169782631) 1 8 4 64 40
10123 257894 6 335 1776 Vallejo St 1 Front Yard : Yard Tree 2   01/27/2020 12:00:00 AM 3     6005064 2118169 37.7963742870274 -122.426508408066 (37.7963742870274, -122.426508408066) 13 9 1 28858 17
10379 95953 6 17 499 Buena Vista East Ave   Front Yard : Yard Tree 2   03/18/2011 12:00:00 AM 21   Permit Number 57015 6000177 2107098 37.7656986843565 -122.442623109531 (37.7656986843565, -122.442623109531) 15 5 5 29492 3
10661 114250 6 28 131 FONT BLVD 1 Front Yard : Yard Tree 2     36     5990844 2088883 37.7151485301311 -122.473574812248 (37.7151485301311, -122.473574812248) 1 8 4 64 14
10900 256098 6 16 1776 Vallejo St 1 Front Yard : Cutout Tree 2           6005064.21519 2118169.93221 37.7963768588038 -122.426507729874 (37.7963768588038, -122.426507729874) 13 9 1 28858 17
10947 94850 6 17 1107 Bowdoin St 1 Front Yard : Yard Tree 2   11/17/2010 12:00:00 AM     Permit Number 53929 6009593 2091048 37.7221611506882 -122.408922553301 (37.7221611506882, -122.408922553301) 10 3 7 309 28
11338 85030 6 17 411 Panama St 1 Sidewalk: Curb side : Cutout Tree 2   06/26/2007 12:00:00 AM     Permit Number 49384                    
11628 261752 6 51 127 Edgehill Way 2 Back Yard : Cutout Tree 2   02/25/2020 12:00:00 AM 3     5994849.50332 2098967.43632 37.7430690988325 -122.46046044555 (37.7430690988325, -122.46046044555) 1 8 4 59 40
12225 102131 6 17 850 Treat Ave 1 Front Yard : Yard Tree 2   12/24/2012 12:00:00 AM     Permit Number 769452 6008548.2 2103592.2 37.7565461982029 -122.413420887965 (37.7565461982029, -122.413420887965) 2 4 7 28859 19
12244 261985 6 93 1500x Bancroft Ave   Front Yard : Yard Tree 2           6014696 2091834 37.7246038778524 -122.391337493735 (37.7246038778524, -122.391337493735) 10 3 8 58 1
12287 95982 6 41 100 Vasquez Ave 1 Back Yard : Yard Tree 2           5995122.4 2099706.3 37.7451135296363 -122.459570350972 (37.7451135296363, -122.459570350972) 1 8 4 59 40
12344 247628 6 138 286 Bradford St 3 Front Yard : Yard Tree 2     9     6009493.85882 2096962.27736 37.7383949449624 -122.409682503062 (37.7383949449624, -122.409682503062) 10 7 7 28859 2
12731 107057 6 36 601X Davis St 2 Front Yard : Yard Tree 2   07/23/2014 12:00:00 AM 9   Permit Number 771755 6013145.32204 2118507.86888 37.7977582696821 -122.398568926718 (37.7977582696821, -122.398568926718) 3 1 10 28860 6
12868 111864 6 67 45 Allston Way 1 Front Yard : Yard Tree 2   06/26/2015 12:00:00 AM 3   Permit Number 775591 5994228.4 2098418 37.7415247340782 -122.462568190827 (37.7415247340782, -122.462568190827) 1 8 4 59 40
13082 96572 6 63 1101 Eucalyptus Dr   Sidewalk: Property side : Cutout Tree 4 FUF       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.7310370666678 -122.483566221845 (37.7310370666678, -122.483566221845) 1 8 4 64 14
13301 114388 6 7 361x ARBALLO DR 1 Front Yard : Yard Tree 2     7     5988379 2090615 37.7197611043299 -122.482221632222 (37.7197611043299, -122.482221632222) 1 8 4 64 14
13617 82366 6 116 51 Princeton St 3 Sidewalk: Curb side : Cutout Tree 2 FUF   9     6007564.92616 2093725.05049 37.7293979446509 -122.416122630059 (37.7293979446509, -122.416122630059) 9 3 7 309 28
13805 119600 6 185 4357x Mission St 2 Front Yard : Yard Tree 2         Permit Number 774415                    
14241 251264 6 41 3630x 19th Ave 3 Sidewalk: Property side : Yard Tree 2         Permit Number 779147                    
14456 103661 6 17 350X Hickory St 5 Front Yard : Yard Tree 14 DPW 06/07/2013 12:00:00 AM     Permit Number 770306                    
14497 251425 6 170 5016 Diamond Heights Blvd 2 Sidewalk: Property side : Yard Tree 2           5999555 2100128 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879) 2 7 5 63 22
14597 106873 6 36 38 08th St 4 Front Yard : Cutout Tree 2         Permit Number 769156 6008506.93846 2111466.36236 37.7781645006636 -122.414120641632 (37.7781645006636, -122.414120641632) 8 2 9 28853 34
14736 92056 6 172 1001 Potrero Ave   Sidewalk: Property side : Yard Tree 2   06/16/2009 12:00:00 AM     Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674) 10 4 8 28859 19
14822 96765 6 7 184 Edgewood Ave 1 Front Yard : Yard Tree 2   07/12/2011 12:00:00 AM     Permit Number 767998 5996632 2105999 37.7624783944866 -122.454805014883 (37.7624783944866, -122.454805014883) 15 5 11 29492 12
15093 119607 6 15 299x Avalon Ave 3 Front Yard : Yard Tree 2                              
15148 260466 6 36 1 Masonic Ave 1 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
15289 119601 6 185 4357x Mission St 3 Front Yard : Yard Tree 2         Permit Number 774415                    
15671 104278 6 105 2 Allston Way 1 Back Yard : Yard Tree 2           5994445.1 2098202.2 37.7409446783355 -122.461803277974 (37.7409446783355, -122.461803277974) 1 8 4 59 40
15795 251263 6 41 3630x 19th Ave 2 Sidewalk: Property side : Yard Tree 2         Permit Number 779147                    
15911 105081 6 45 344 Fulton St 1 Front Yard : Yard Tree 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
15941 85313 6 53 610 Brannan St 1 unknown : Cutout Tree 2         Permit Number 49594 6012704.2 2110820.8 37.7766267904106 -122.399555358584 (37.7766267904106, -122.399555358584) 14 2 9 28856 34
16043 260472 6 185 1 Masonic Ave 7 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
16054 247629 6 138 286 Bradford St 4 Front Yard : Yard Tree 2     12     6009493.3855 2096955.46231 37.7383762057861 -122.409683658684 (37.7383762057861, -122.409683658684) 10 7 7 28859 2
16142 94943 6 364 2525 Griffith St   Sidewalk: Property side : Cutout Tree 15 FUF 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.7196157592662 -122.38561332474 (37.7196157592662, -122.38561332474) 10 3 8 58 1
16147 260471 6 16 1 Masonic Ave 6 Side Yard : Yard Tree 2           5998961 2113697 37.7837484562249 -122.447303968308 (37.7837484562249, -122.447303968308) 15 6 1 54 31
16207 254459 6 17 1055X Duncan St 4 Side Yard : Yard Tree 2   02/15/2018 12:00:00 AM 3   Permit Number 780800                    
16372 96327 6 64 296 Randall St 1 Sidewalk: Property side : Yard Tree 2         Permit Number 767829 6003708 2097940 37.7407536226533 -122.429756895294 (37.7407536226533, -122.429756895294) 2 7 5 63 7
17108 105086 6 45 344 Fulton St 6 Front Yard : Yard Tree 2           6006101.8 2111789.5 37.7789163735632 -122.422463868572 (37.7789163735632, -122.422463868572) 7 9 11 28852 10
17239 32497 6 40 665 Andover St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 10/15/1996 12:00:00 AM 16   Permit Number 37002 6007442.30694 2095863.10154 37.7352616718948 -122.416697941676 (37.7352616718948, -122.416697941676) 2 7 7 28859 2