sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
92394 115737 6 6 9x Yerba Buena Ave 1 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 776557 5993642.277480001 2097056.1949900002 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033)
1384 251515 6 3 99x Mountview Ct 1 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1409 251514 6 3 99x Mountview Ct 2 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
49231 114226 6 140 99x FONT BLVD 2 2 1 1     20     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
79797 114240 6 60 99x FONT BLVD 16 2 1 1           5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
80545 114228 6 140 99x FONT BLVD 4 2 1 1     7     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
86013 114235 6 140 99x FONT BLVD 11 2 1 1     13     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
105010 114230 6 140 99x FONT BLVD 6 2 1 1     30     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
105245 114225 6 60 99x FONT BLVD 1 2 1 1     48     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
105541 114227 6 140 99x FONT BLVD 3 2 1 1     16     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
112189 114231 6 140 99x FONT BLVD 7 2 1 1     10     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
117729 114237 6 140 99x FONT BLVD 13 2 1 1     14     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
125709 114234 6 140 99x FONT BLVD 10 2 1 1     20     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
128194 114232 6 140 99x FONT BLVD 8 2 1 1     15     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
128290 114229 6 140 99x FONT BLVD 5 2 1 1     13     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
138891 114238 6 140 99x FONT BLVD 14 2 1 1     13     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
139193 114233 6 140 99x FONT BLVD 9 2 1 1     20     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
139478 114236 6 140 99x FONT BLVD 12 2 1 1     22     5990948.0 2088640.0 37.71448733391829 -122.473197635313 (37.7144873339183, -122.473197635313)
85680 99097 6 5 99X Santa Monica Way 1 2 1 1           5994003.8 2097131.6 37.7379796635799 -122.463251452094 (37.7379796635799, -122.463251452094)
2854 253253 6 5 99X Lopez Ave 4 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2859 253251 6 3 99X Lopez Ave 2 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2869 253250 6 3 99X Lopez Ave 1 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
2874 253252 6 3 99X Lopez Ave 3 7 1 1       10x10   5994049.0 2100330.0 37.746764271907 -122.46332720271201 (37.746764271907, -122.463327202712)
9683 173631 6 47 99X Everglade Dr 1 5 1 1       3x3   5986361.0 2095495.0 37.733042731061104 -122.48955570953301 (37.7330427310611, -122.489555709533)
9987 173779 6 148 99X Cleveland St 2 17 1 1       3x6   6010549.0 2110746.0 37.7763010397716 -122.40700558704799 (37.7763010397716, -122.407005587048)
10000 173780 6 55 99X Cleveland St 3 17 1 1       3x6   6010549.0 2110746.0 37.7763010397716 -122.40700558704799 (37.7763010397716, -122.407005587048)
10010 173778 6 17 99X Cleveland St 1 18 1 1       3x3   6010549.0 2110746.0 37.7763010397716 -122.40700558704799 (37.7763010397716, -122.407005587048)
96595 106311 6 71 99X Clearfield Dr 5 9 1 1   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.4648400003 37.73289581695511 -122.49149816384899 (37.7328958169551, -122.491498163849)
142007 106310 6 71 99X Clearfield Dr 4 9 1 1   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.4648400003 37.73289581695511 -122.49149816384899 (37.7328958169551, -122.491498163849)
4549 226945 6 19 998 Chenery St 4 9 1 1     21 Width 1ft   6001140.61217 2096125.6115299999 37.735626018710896 -122.438503967885 (37.7356260187109, -122.438503967885)
89551 121177 6 176 990x Duncan St 1 7 1 1       3x3 Permit Number 775289 6000056.0 2099639.0 37.7452111944111 -122.442506045398 (37.7452111944111, -122.442506045398)
110611 121178 6 176 990x Duncan St 2 7 1 1       3x3 Permit Number 775289 6000056.0 2099639.0 37.7452111944111 -122.442506045398 (37.7452111944111, -122.442506045398)
143056 121179 6 176 990x Duncan St 3 7 1 1       3x3   6000056.0 2099639.0 37.7452111944111 -122.442506045398 (37.7452111944111, -122.442506045398)
1956 252838 6 114 99 Pond St 1 9 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
127034 114142 6 3 99 Divisadero St   7 1 1           6001906.1 2108188.4 37.7687910682296 -122.436720598265 (37.7687910682296, -122.436720598265)
79584 116089 6 5 98x WOODWARD ST 3 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
103243 116088 6 5 98x WOODWARD ST 2 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
107871 116087 6 5 98x WOODWARD ST 1 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
125535 116090 6 5 98x WOODWARD ST 4 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
22303 248958 6 105 98x Rosewood Dr 1 1 1 1   03/06/2017 12:00:00 AM 3 3x3   5994824.0 2095658.0 37.7339807377795 -122.460308897898 (37.7339807377795, -122.460308897898)
126406 105768 6 3 98X GOLD MINE DR 3 7 1 1     16     6001350.0 2099153.0 37.7439504273559 -122.437996817375 (37.7439504273559, -122.437996817375)
78751 117435 6 182 98X CLIPPER ST 1 13 1 1           6004559.0 2101087.0 37.749442713924296 -122.427038546128 (37.7494427139243, -122.427038546128)
1935 252836 6 114 98 Prosper St 4 5 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
81071 78107 6 129 970 GUERRERO ST 1 7 1 1     15     6005649.9 2103318.5 37.755631523761394 -122.42342479955799 (37.7556315237614, -122.423424799558)
50498 100711 6 17 966-968 Guerrero St 1 7 1 1   09/27/2012 12:00:00 AM 14   Permit Number 769148 6005605.8 2103343.5 37.7556976788024 -122.423579088745 (37.7556976788024, -122.423579088745)
112771 109706 6 47 96 CRESTA VISTA DR   16 1 1           5995602.1 2096103.5 37.7352487002973 -122.45765100803699 (37.7352487002973, -122.457651008037)
144044 115738 6 6 95x Yerba Buena Ave 2 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 776553 5993642.277480001 2097056.1949900002 37.7377517864641 -122.46449593033 (37.7377517864641, -122.46449593033)
56265 104652 6 94 953 Indiana St 1 8 1 1           6015057.1 2104275.7 37.758786250670205 -122.39095836980302 (37.7587862506702, -122.390958369803)
126026 108109 6 17 952 CAPP ST 1 7 1 1   01/06/2015 12:00:00 AM 3 3x3 Permit Number 774355 6007364.7 2101732.3 37.751372815901604 -122.417382061559 (37.7513728159016, -122.417382061559)
17858 121173 6 17 950 Duncan St 2 7 1 1       3x3   6000333.0 2099683.0 37.7453477932295 -122.44155138616101 (37.7453477932295, -122.441551386161)
95972 121174 6 17 950 Duncan St 3 7 1 1       3x3   6000333.0 2099683.0 37.7453477932295 -122.44155138616101 (37.7453477932295, -122.441551386161)
102851 121175 6 17 950 Duncan St 4 7 1 1       3x3   6000333.0 2099683.0 37.7453477932295 -122.44155138616101 (37.7453477932295, -122.441551386161)
113850 121172 6 17 950 Duncan St 1 7 1 1       3x3   6000333.0 2099683.0 37.7453477932295 -122.44155138616101 (37.7453477932295, -122.441551386161)
140418 121176 6 17 950 Duncan St 5 7 1 1       3x3   6000333.0 2099683.0 37.7453477932295 -122.44155138616101 (37.7453477932295, -122.441551386161)
83026 105765 6 3 95 ORA WAY 1 7 1 1     18     6001454.9 2097857.0 37.7403978808149 -122.437541306682 (37.7403978808149, -122.437541306682)
20974 109568 6 116 95 Nordhoff St 1 13 1 1         Permit Number 777169 6000348.8 2095645.6 37.734262946491704 -122.44120712981501 (37.7342629464917, -122.441207129815)
82967 107186 6 3 945 Sacramento St 2 7 1 1         Permit Number 773422 6010352.63458 2116759.0624 37.7928004918921 -122.40810904235501 (37.7928004918921, -122.408109042355)
115648 107187 6 3 945 Sacramento St 3 7 1 1         Permit Number 773422 6010352.63458 2116759.0624 37.7928004918921 -122.40810904235501 (37.7928004918921, -122.408109042355)
145177 107016 6 17 945 SACRAMENTO ST 1 7 1 1   01/24/2015 12:00:00 AM     Permit Number 773422 6010352.6 2116759.1 37.7928005931964 -122.408109164657 (37.7928005931964, -122.408109164657)
88059 88281 6 16 935 Ulloa St 2 7 1 1   07/09/2008 12:00:00 AM   3x3 Permit Number 51275 5993125.0 2098282.0 37.7410877064311 -122.466373457073 (37.7410877064311, -122.466373457073)
96939 113833 6 43 932 SHOTWELL ST 1 1 1 1     30     6007966.0 2102301.0 37.752968150444204 -122.415342945464 (37.7529681504442, -122.415342945464)
114812 100474 6 164 930 Monterey Blvd 2 7 1 1           5995794.4 2094643.4 37.7312506649165 -122.45688058924699 (37.7312506649165, -122.456880589247)
143721 100473 6 164 930 Monterey Blvd 1 7 1 1           5995794.4 2094643.4 37.7312506649165 -122.45688058924699 (37.7312506649165, -122.456880589247)
84791 108196 6 44 930 FLORIDA ST 1 1 1 1           6009368.6 2103733.3 37.7569796561067 -122.410593604092 (37.7569796561067, -122.410593604092)
144015 108197 6 15 930 FLORIDA ST 2 1 1 1           6009368.6 2103733.3 37.7569796561067 -122.410593604092 (37.7569796561067, -122.410593604092)
5478 121205 6 234 930 Chestnut St 1 7 1 1     20 3x3   6007386.5238 2120591.4348299997 37.8031567047665 -122.418643837145 (37.8031567047665, -122.418643837145)
8728 121206 6 12 930 Chestnut St 2 1 1 1   11/22/2016 12:00:00 AM 3 3x3 Permit Number 778903 6007356.48577 2120579.5282099997 37.803122321012296 -122.418746939923 (37.8031223210123, -122.418746939923)
102339 113744 6 141 909 ASHBURY ST 1 8 1 1       3x3   5999156.0 2107025.0 37.7654399906909 -122.44614926226002 (37.7654399906909, -122.44614926226)
101747 113695 6 5 907 FLORIDA ST 1 1 1 1     24 3x3   6009441.0 2103786.0 37.7571284172194 -122.41034693748101 (37.7571284172194, -122.410346937481)
59539 98244 6 241 901 Bay St 1 7 1 1     5     6006420.63185 2121080.7781 37.8044458892203 -122.422021121489 (37.8044458892203, -122.422021121489)
94616 121170 6 17 900x Duncan St 3 7 1 1       3x3   6000584.0 2099647.0 37.745263242779004 -122.44068088983101 (37.745263242779, -122.440680889831)
107216 121169 6 176 900x Duncan St 2 7 1 1       3x3 Permit Number 775289 6000584.0 2099647.0 37.745263242779004 -122.44068088983101 (37.745263242779, -122.440680889831)
107460 121171 6 17 900x Duncan St 4 7 1 1       3x3   6000584.0 2099647.0 37.745263242779004 -122.44068088983101 (37.745263242779, -122.440680889831)
124773 121168 6 17 900x Duncan St 1 7 1 1       3x3   6000584.0 2099647.0 37.745263242779004 -122.44068088983101 (37.745263242779, -122.440680889831)
78 251199 6 3 900X 14th St 4 7 1 1       3X3   6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
93 251198 6 3 900X 14th St 3 7 1 1           6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
95 251197 6 3 900X 14th St 3 7 1 1   03/22/2017 12:00:00 AM 3   Permit Number 779570 6002798.55883 2107703.57748 37.7675105430125 -122.43359899801901 (37.7675105430125, -122.433598998019)
96 251196 6 3 900X 14th St 2 8 1 1   03/22/2017 12:00:00 AM 3     6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
1609 251630 6 47 8R Amethyst Way 2 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1628 251629 6 47 8R Amethyst Way 1 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1629 251631 6 47 8R Amethyst Way 3 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
101996 101236 6 17 895X Church St 1 13 1 1   10/05/2012 12:00:00 AM 13   Permit Number 769299 6004383.5 2103691.7 37.7565846850157 -122.42783100085899 (37.7565846850157, -122.427831000859)
100592 116998 6 36 880x MCALLISTER ST 1 8 1 1           6005306.0 2112177.0 37.779935428414 -122.42524444144199 (37.779935428414, -122.425244441442)
102078 117000 6 36 880x MCALLISTER ST 3 8 1 1           6005306.0 2112177.0 37.779935428414 -122.42524444144199 (37.779935428414, -122.425244441442)
124370 116999 6 36 880x MCALLISTER ST 2 8 1 1           6005306.0 2112177.0 37.779935428414 -122.42524444144199 (37.779935428414, -122.425244441442)
126201 116075 6 17 88 MONTCALM ST 1 7 1 1           6010492.0 2099980.0 37.7467368416425 -122.406443980671 (37.7467368416425, -122.406443980671)
83945 103563 6 19 878 14th St 1 7 1 1     15   Permit Number 770193 6002986.0 2107714.0 37.767549794195205 -122.432951409123 (37.7675497941952, -122.432951409123)
84454 103564 6 19 878 14th St 2 7 1 1     13   Permit Number 770193 6002986.0 2107714.0 37.767549794195205 -122.432951409123 (37.7675497941952, -122.432951409123)
93035 103565 6 19 878 14th St 3 7 1 1     9   Permit Number 770193 6002986.0 2107714.0 37.767549794195205 -122.432951409123 (37.7675497941952, -122.432951409123)
13271 187638 6 47 875 El Camino Del Mar 2 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
13275 187637 6 47 875 El Camino Del Mar 1 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
116206 103477 6 17 875 El Camino Del Mar 1 25 1 1   05/08/2013 12:00:00 AM     Permit Number 770113 5985641.7 2114972.5 37.7864805258078 -122.493477079739 (37.7864805258078, -122.493477079739)
82542 108215 6 3 865 EL CAMINO DEL MAR 1 7 1 1           5985761.0 2114995.0 37.7865492821054 -122.49306599544501 (37.7865492821054, -122.493065995445)
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)
99731 115673 6 183 86 Stanton St   7 1 1           6000281.6 2103909.8 37.7569506357303 -122.442032456595 (37.7569506357303, -122.442032456595)
89880 99852 6 19 86 Nordhoff St 1 7 1 1           6000395.0 2095652.0 37.734283150969794 -122.44104786104499 (37.7342831509698, -122.441047861045)
143961 116345 6 17 85x SANTA CLARA AVE 1 1 1 1   03/24/2016 12:00:00 AM 3 3x3 Permit Number 777165 5993361.0 2096925.0 37.7373753392635 -122.465458906558 (37.7373753392635, -122.465458906558)
99634 99847 6 15 850@14th Ave Judah St 1 1 1 1           5991942.0 2105939.0 37.7620435090796 -122.47102148161501 (37.7620435090796, -122.471021481615)
19018 102131 6 17 850 Treat Ave 1 7 1 1   12/24/2012 12:00:00 AM     Permit Number 769452 6008548.2 2103592.2 37.7565461982029 -122.41342088796499 (37.7565461982029, -122.413420887965)
93506 98151 6 3 850 Rockdale Dr 3 7 1 1         Permit Number 768501 5996729.9 2098301.3 37.7413480470066 -122.453910481227 (37.7413480470066, -122.453910481227)
79722 93222 6 17 85 Santa Rita Ave 2 7 1 1   02/26/2010 12:00:00 AM     Permit Number 53213 5993788.0 2100441.0 37.7470540096767 -122.46423776520399 (37.7470540096767, -122.464237765204)
Powered by Datasette · Query took 7.497ms · Data source: data.sfgov.org