sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
19027 97174 6 37 26 Gilbert St   5 1 1 1         6011445.1 2110013.2 37.7743390438118 -122.40385413458 (37.7743390438118, -122.40385413458)
19054 94934 6 311 2451X Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
19350 95161 6 175 2721 Pacific Ave   7 1 1         Permit Number 54078 6001026.7 2116843.3 37.7925052022591 -122.440383162252 (37.7925052022591, -122.440383162252)
19781 96412 6 175 185 Chilton Ave   7 1 1   05/18/2011 12:00:00 AM     Permit Number 767805 6001587.1 2095138.7 37.732941575251004 -122.436889661497 (37.732941575251, -122.436889661497)
43173 112929 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
44829 94949 6 31 50 Pomona St   24 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
50102 94943 6 417 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
50166 95953 6 17 499 Buena Vista East Ave   7 1 1   03/18/2011 12:00:00 AM 21   Permit Number 57015 6000177.0 2107098.0 37.7656986843565 -122.442623109531 (37.7656986843565, -122.442623109531)
51543 95372 6 3 180 Yukon St   16 1 1     15   Permit Number 767755 6000174.3 2103956.9 37.7570738455347 -122.44240692055901 (37.7570738455347, -122.442406920559)
54776 95300 6 11 701 Golden Gate Ave   7 1 1   02/08/2011 12:00:00 AM   3x3 Permit Number 767203 6006127.5 2112421.2 37.780652317617005 -122.422419858646 (37.780652317617, -122.422419858646)
58967 96572 6 143 1101 Eucalyptus Dr   5 1 4 1       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.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
77818 108026 6 116 862 Kansas St   7 1 1         Permit Number 774734 6011570.0 2104296.0 37.758647879927395 -122.403019866682 (37.7586478799274, -122.403019866682)
78391 108038 6 3 1 Twin Peaks Blvd   7 1 1           5998985.485719999 2105240.3128 37.760529947122706 -122.446610614338 (37.7605299471227, -122.446610614338)
78522 112919 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
80235 96569 6 12 1101 Eucalyptus Dr   5 1 4 1       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.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
80420 105844 6 17 355 Buena Vista Ave   7 1 1   03/03/2014 12:00:00 AM     Permit Number 771052 6000886.5 2107736.6 37.767492540377 -122.44021490806801 (37.767492540377, -122.440214908068)
81040 112918 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
81078 94935 6 469 2451X Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
81160 96570 6 143 1101 Eucalyptus Dr   5 1 4 1       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.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
81688 93931 6 105     7 1 1   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.5528400003 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841)
81710 104892 6 62 201 Gonzalez Dr   7 1 1           5990435.0 2090585.0 37.7197981072685 -122.47511265272199 (37.7197981072685, -122.475112652722)
82109 105208 6 1 2694 47TH AVE   7 1 1           5981878.3 2096771.8 37.736285749950206 -122.50514791128201 (37.7362857499502, -122.505147911282)
83393 92053 6 36 1001 Potrero Ave   5 1 1         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
85824 112921 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
86498 107113 6 115 2100 MARKET ST   8 1 1           6004034.0 2107672.1 37.767494134010896 -122.429323526179 (37.7674941340109, -122.429323526179)
86822 114840 6 5 2455x HYDE ST   1 1 13     12 3x3   6006980.0 2120877.0 37.803917898432395 -122.42007090461901 (37.8039178984324, -122.420070904619)
86907 96483 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
87949 96848 6 75 1486 Innes Ave   7 1 1           6016133.4 2096820.6 37.7383757570157 -122.386716118251 (37.7383757570157, -122.386716118251)
88058 94937 6 498 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
89530 112922 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
90667 94951 6 31 50 Pomona St   24 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
90772 106612 6 138 1189 TENNESSEE ST   7 1 1     55     6015654.1 2103577.3 37.7569017014681 -122.388844893024 (37.7569017014681, -122.388844893024)
92048 111996 6 17 501 Point Lobos Ave   7 1 1   07/08/2015 12:00:00 AM 3 3x3 Permit Number 775626 5981249.6 2112592.5 37.779687857228296 -122.508495636007 (37.7796878572283, -122.508495636007)
93582 93724 6 62 415 Belvedere St   7 1 1           5998488.0 2106798.0 37.7647785355325 -122.44844336243601 (37.7647785355325, -122.448443362436)
93623 94948 6 18 50 Pomona St   5 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
93720 106927 6 13 4150 24th St   5 1 1       1.5X1.5 Permit Number 772519 6002207.56819 2101805.30097 37.7512817512061 -122.435221219626 (37.7512817512061, -122.435221219626)
93904 118327 6 26 109 ALPINE TER   1 1 1     8 4x7   6001716.4 2108199.1 37.7688096651516 -122.43737752181002 (37.7688096651516, -122.43737752181)
95092 93874 6 150 2614 Sacramento St   25 1 1   04/14/2010 12:00:00 AM     Permit Number 53370 6002291.0 2115777.0 37.789649322620896 -122.43593231943599 (37.7896493226209, -122.435932319436)
96055 107245 6 17 140 CEDRO AVE   7 1 1           5991993.7 2093259.3 37.727231291852604 -122.469919436342 (37.7272312918526, -122.469919436342)
96189 94940 6 112 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
96557 107036 6 17 350 08th St   5 1 1   07/23/2014 12:00:00 AM   7x7 Permit Number 772214 6009826.0 2110084.0 37.774442857676505 -122.409459923405 (37.7744428576765, -122.409459923405)
96813 112924 6 3 2X Noe St   9 1 1           6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
97749 96481 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
97751 110321 6 484 1x SAN PABLO AVE   1 1 1   04/06/2015 12:00:00 AM 3 3x3 Permit Number 774750 5994773.0 2097898.0 37.740128291439 -122.460647489756 (37.740128291439, -122.460647489756)
98130 95234 6 17 7 Almaden Ct   7 1 1   01/25/2011 12:00:00 AM     Permit Number 767129 5995849.0 2112535.0 37.780379598944705 -122.457986127959 (37.7803795989447, -122.457986127959)
99064 93932 6 105     7 1 1   04/28/2010 12:00:00 AM     Permit Number 53387 5990375.96797 2090932.5528400003 37.7207489795508 -122.475342064841 (37.7207489795508, -122.475342064841)
99207 96568 6 12 1101 Eucalyptus Dr   5 1 4 1       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.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
99731 115673 6 183 86 Stanton St   7 1 1           6000281.6 2103909.8 37.7569506357303 -122.442032456595 (37.7569506357303, -122.442032456595)
100331 112930 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
101102 96484 6 180 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
102016 105368 6 2 180 CLIFFORD TER   1 1 1           5999283.1 2106587.2 37.7642451591147 -122.44567816768298 (37.7642451591147, -122.445678167683)
102075 109040 6 19 654 Precita Ave   7 1 1     30     6009911.5 2100416.7 37.7479034320272 -122.408482100152 (37.7479034320272, -122.408482100152)
103034 96485 6 180 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
103824 94947 6 18 50 Pomona St   5 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
103866 87188 6 17 2119 Bush St   7 1 1   01/29/2008 12:00:00 AM     Permit Number 50204 6002998.0 2114831.0 37.787091984974104 -122.433418544226 (37.7870919849741, -122.433418544226)
105112 95242 6 3 2620 Larkin St   7 1 1     37   Permit Number 56959 6006630.0 2120172.0 37.801962421987 -122.421232011572 (37.801962421987, -122.421232011572)
105512 105130 6 17 4045 MORAGA ST   9 1 1           5981665.2 2103465.9 37.7546533409301 -122.506380933635 (37.7546533409301, -122.506380933635)
106619 86895 6 17 321 Haight St   7 1 1   10/26/2007 12:00:00 AM     Permit Number 49844 6004599.9 2109420.1 37.7723257406977 -122.427490696784 (37.7723257406977, -122.427490696784)
107188 94950 6 31 50 Pomona St   24 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
108424 106038 6 75 230 Lakeview Ave   7 1 1         Permit Number 772456 5997013.1 2089546.6 37.7173259605404 -122.452299707743 (37.7173259605404, -122.452299707743)
109217 96482 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
109599 98161 6 71 600 Front St   7 1 1   12/21/2011 12:00:00 AM     Permit Number 768589 6012888.4 2118392.6 37.7974274520849 -122.39944985704099 (37.7974274520849, -122.399449857041)
109838 98274 6 82 766 Anderson St   7 1 1   01/23/2012 12:00:00 AM 18   Permit Number 768445 6007723.0 2095324.0 37.7337971999422 -122.41568932106199 (37.7337971999422, -122.415689321062)
109889 93903 6 75 546 Page St   25 1 1           6003947.0 2109752.0 37.773200107256606 -122.42977281454901 (37.7732001072566, -122.429772814549)
110495 95215 6 175 2203 Divisadero St   7 1 1           6000868.0 2115894.0 37.7898896344174 -122.440864138631 (37.7898896344174, -122.440864138631)
111560 94941 6 112 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
111884 94939 6 112 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
112470 110950 6 3 342 HILL ST   7 1 1     15 3x3 Permit Number 778799 6004048.0 2103384.0 37.755720828524204 -122.42896934322901 (37.7557208285242, -122.428969343229)
112771 109706 6 47 96 CRESTA VISTA DR   16 1 1           5995602.1 2096103.5 37.7352487002973 -122.45765100803699 (37.7352487002973, -122.457651008037)
112975 94938 6 498 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
113578 96571 6 143 1101 Eucalyptus Dr   5 1 4 1       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.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
113676 95299 6 11 701 Golden Gate Ave   7 1 1   02/08/2011 12:00:00 AM   3x3 Permit Number 767203 6006127.5 2112421.2 37.780652317617005 -122.422419858646 (37.780652317617, -122.422419858646)
114698 94946 6 18 50 Pomona St   5 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
115263 97894 6 17 2927 Folsom St   7 1 1   02/29/2012 12:00:00 AM 30   Permit Number 768566 6008395.0 2101384.0 37.7504743768844 -122.413794517972 (37.7504743768844, -122.413794517972)
115520 112925 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
116721 105845 6 3 355 Buena Vista Ave   7 1 1           6000886.5 2107736.6 37.767492540377 -122.44021490806801 (37.767492540377, -122.440214908068)
117221 94066 6 161 548 Page St   25 1 1   06/02/2010 12:00:00 AM     Permit Number 53460 6003937.0 2109751.0 37.7731967952272 -122.429807334526 (37.7731967952272, -122.429807334526)
117865 112928 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
119294 92055 6 180 1001 Potrero Ave   9 1 1         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
120702 97175 6 37 26 Gilbert St   5 1 1 1         6011445.1 2110013.2 37.7743390438118 -122.40385413458 (37.7743390438118, -122.40385413458)
121702 95777 6 518 30 Onondaga Ave   7 1 1   03/11/2011 12:00:00 AM     Permit Number 767524 6001190.6 2091111.6 37.721861535681704 -122.437972107548 (37.7218615356817, -122.437972107548)
122936 107159 6 47 1000 ESMERALDA AVE   7 1 1           6009839.0 2098688.0 37.7431527400861 -122.408610872619 (37.7431527400861, -122.408610872619)
123053 113153 6 408 55 BRONTE ST   8 1 1     12 3x3   6009403.0 2097128.0 37.738844891472894 -122.410008345842 (37.7388448914729, -122.410008345842)
123251 92054 6 36 1001 Potrero Ave   5 1 1         Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
123402 98170 6 134 2324 Sacramento St   7 1 1   12/22/2011 12:00:00 AM 3   Permit Number 768454 6003670.2 2115963.1 37.7902385582714 -122.43117371849199 (37.7902385582714, -122.431173718492)
123605 92056 6 180 1001 Potrero Ave   9 1 1   06/16/2009 12:00:00 AM     Permit Number 52180 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
124197 96567 6 12 1101 Eucalyptus Dr   5 1 4 1       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.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
124228 111770 6 243 707 Douglass St   8 1 1       3x3 Permit Number 775627 6001281.0 2102187.2 37.7522776937422 -122.438452748375 (37.7522776937422, -122.438452748375)
125171 107047 6 17 1933 15TH ST   7 1 1           6004592.7 2107127.1 37.766029309282295 -122.42735222853202 (37.7660293092823, -122.427352228532)
125242 111094 6 3 150x FONT BLVD   1 1 1   06/04/2015 12:00:00 AM 30 3x3 Permit Number 775594 5990976.0 2089133.0 37.715842612516106 -122.473136789074 (37.7158426125161, -122.473136789074)
126422 109061 6 3 36 ARBOR ST   7 1 1         Permit Number 774913 6002094.4 2096943.6 37.7379262346414 -122.435264853151 (37.7379262346414, -122.435264853151)
127034 114142 6 3 99 Divisadero St   7 1 1           6001906.1 2108188.4 37.7687910682296 -122.436720598265 (37.7687910682296, -122.436720598265)
128076 112923 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM     Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
138508 96480 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
139320 94936 6 498 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
139354 106405 6 105 4849X 19th St   7 1 1         Permit Number 772769 5999644.57626 2104777.09851 37.759295701171105 -122.44429784106501 (37.7592957011711, -122.444297841065)
140734 94945 6 338 1820X Palou Ave   24 1 3 1 04/04/2009 12:00:00 AM       6013714.4 2096294.3 37.7367964240349 -122.395043047708 (37.7367964240349, -122.395043047708)
140792 94868 6 31 51 Princeton St   5 1 1 1         6007547.0 2093670.0 37.729245779959 -122.416180705349 (37.729245779959, -122.416180705349)
140824 112927 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
141435 104808 6 277 1665 08th Ave   7 1 1     40     5993673.5 2104163.7 37.7572689897716 -122.46490400670099 (37.7572689897716, -122.464904006701)
141641 112926 6 116 2X Noe St   9 1 1   08/27/2015 12:00:00 AM   3x3 Permit Number 775129 6002836.07968 2107997.59158 37.7683199626551 -122.43349023202299 (37.7683199626551, -122.433490232023)
Powered by Datasette · Query took 14.123ms · Data source: data.sfgov.org