sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
28971 192361 2 10 1 25th St 10 23 1 1     10     6015010.08641 2102185.10422 37.7530433120206 -122.390974850809 (37.7530433120206, -122.390974850809)
31965 192372 2 10 1310 Indiana St 11 23 1 1     18     6015021.64054 2102392.08058 37.753612266314796 -122.39094935864401 (37.7536122663148, -122.390949358644)
35549 192359 2 10 1 25th St 3 23 1 1     11     6015007.494080001 2102120.97523 37.7528670835631 -122.390979333923 (37.7528670835631, -122.390979333923)
35640 192367 2 10 1310 Indiana St 6 23 1 1     13     6014979.384930001 2102511.0329 37.75393653934321 -122.39110380282101 (37.7539365393432, -122.391103802821)
36486 192371 2 10 1310 Indiana St 10 23 1 1     11     6015009.21329 2102415.55606 37.7536760354269 -122.390993975811 (37.7536760354269, -122.390993975811)
40383 192366 2 10 1310 Indiana St 20 23 1 1     13     6014913.1297 2102461.68379 37.7537973602844 -122.39132948139 (37.7537973602844, -122.39132948139)
51964 192363 2 10 1310 Indiana St 26 23 1 1     8     6014946.149019999 2102349.52066 37.753491216648705 -122.39120745237899 (37.7534912166487, -122.391207452379)
54292 192358 2 10 1 25th St 2 23 1 1     12     6015008.12096 2102140.25985 37.752920069827 -122.39097851376499 (37.752920069827, -122.390978513765)
60000 192362 2 10 1 25th St 20 23 1 1     9     6014965.98324 2102248.74822 37.7532156176115 -122.391131817592 (37.7532156176115, -122.391131817592)
60677 192360 2 10 1 25th St 8 23 1 1     5     6015020.29565 2102164.4791599996 37.75298724647129 -122.39093810360399 (37.7529872464713, -122.390938103604)
70325 192365 2 10 1310 Indiana St 21 23 1 1     8     6014917.078430001 2102437.6688900003 37.7537316396243 -122.391314147037 (37.7537316396243, -122.391314147037)
74435 192364 2 10 1310 Indiana St 23 23 1 1     8     6014928.1243 2102399.042 37.7536261914184 -122.391273247671 (37.7536261914184, -122.391273247671)
148293 192370 2 10 1310 Indiana St 9 23 1 1     8     6015014.73228 2102443.11605 37.7537520155509 -122.390976815833 (37.7537520155509, -122.390976815833)
171000 192369 2 10 1310 Indiana St 8 23 1 1     7     6014983.64642 2102476.35721 37.7538415637469 -122.391086641939 (37.7538415637469, -122.391086641939)
173611 192357 2 10 1 25th St 1 23 1 1     16     6015039.28391 2102127.23317 37.7528860304727 -122.39086983518801 (37.7528860304727, -122.390869835188)
184577 192373 2 10 1310 Indiana St 18 23 1 1     17     6015020.94183 2102357.50513 37.7535172906979 -122.390949358625 (37.7535172906979, -122.390949358625)
188821 192368 2 10 1310 Indiana St 7 23 1 1     6     6014962.221059999 2102496.55555 37.753895835135104 -122.39116214813801 (37.7538958351351, -122.391162148138)
3257 253379 2 10 899 Waller St 1 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3262 253382 2 10 899 Waller St 4 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3270 253380 2 10 899 Waller St 2 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3271 253381 2 10 899 Waller St 3 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
3279 253383 2 10 899 Waller St 5 17 1 1           6001282.0 2108613.0 37.76992142642111 -122.438909742148 (37.7699214264211, -122.438909742148)
45137 248182 2 10 216 Esmeralda Ave 1 17 1 1     51     6007496.06144 2098688.36246 37.743022237487004 -122.41671217793899 (37.743022237487, -122.416712177939)
47445 248181 2 10 218 Esmeralda Ave 10 17 1 1     32     6007478.19635 2098656.7324200002 37.7429343836221 -122.41677171036999 (37.7429343836221, -122.41677171037)
154669 248242 2 10 296 Esmeralda Ave 2 17 1 1     27     6006789.286590001 2099004.18236 37.7438496308664 -122.419178415757 (37.7438496308664, -122.419178415757)
166798 248247 2 10 296 Esmeralda Ave 7 17 1 1     12     6006821.11352 2098989.33644 37.743810659629204 -122.419067312628 (37.7438106596292, -122.419067312628)
176872 248241 2 10 296 Esmeralda Ave 1 17 1 1     63     6006778.03314 2099006.59157 37.743855612256 -122.419217498503 (37.743855612256, -122.419217498503)
68047 218985 2 10 735 Foerster St 1 13 1 1     15 Width 3ft   5998106.15759 2095768.84675 37.7344733504624 -122.448969503563 (37.7344733504624, -122.448969503563)
5913 23706 3 10 700X Webster St 1 11 1 2     80 8X8   6003994.1877 2111257.6303 37.7773368699173 -122.42971699343799 (37.7773368699173, -122.429716993438)
5918 23710 3 10 700X Webster St 5 11 1 2     20 20   6003962.5277 2111419.0963 37.77777842285779 -122.429838035535 (37.7777784228578, -122.429838035535)
82907 23711 3 10 700X Webster St 6 11 1 2     80 20   6004027.2031566 2111122.3858595 37.776967391502296 -122.42959313438801 (37.7769673915023, -122.429593134388)
23844 192384 2 10 500 Illinois St 14 9 1 1     10 Width 9ft   6015929.33713 2106466.90045 37.7648511775542 -122.38809465775 (37.7648511775542, -122.38809465775)
28136 247011 2 10 500 Valley St 2 9 1 1     9     6002619.5945 2099198.996 37.7441488398068 -122.433610141488 (37.7441488398068, -122.433610141488)
28691 247010 2 10 500 Valley St 1 9 1 1     9     6002631.32186 2099201.86815 37.74415739146121 -122.433569796116 (37.7441573914612, -122.433569796116)
36930 123091 2 10 625 11th Ave 1 9 1 1     8 Width 3ft   5992511.629819999 2111163.49628 37.776421509726795 -122.46943168307301 (37.7764215097268, -122.469431683073)
51030 192383 2 10 500 Illinois St 13 9 1 1     9 Width 9ft   6015928.566269999 2106487.94693 37.7649089239349 -122.38809879283501 (37.7649089239349, -122.388098792835)
57475 192380 2 10 500 Illinois St 10 9 1 1     11 Width 9ft   6015923.02581 2106586.6192099997 37.7651795497335 -122.388124842588 (37.7651795497335, -122.388124842588)
64244 192381 2 10 500 Illinois St 11 9 1 1     16 Width 9ft   6015923.36734 2106564.05052 37.7651175999097 -122.38812208619 (37.7651175999097, -122.38812208619)
71992 192382 2 10 500 Illinois St 12 9 1 1     11 Width 9ft   6015926.910759999 2106504.64628 37.7649546850211 -122.38810568434499 (37.7649546850211, -122.388105684345)
73871 247012 2 10 500 Valley St 4 9 1 1     11     6002599.35575 2099199.8727700002 37.744150098849204 -122.43368018521299 (37.7441500988492, -122.433680185213)
93610 192378 2 10 500 Illinois St 7 9 1 1     14 Width 9ft   6015920.68395 2106620.6403200002 37.765272834597894 -122.388135317012 (37.7652728345979, -122.388135317012)
135950 192385 2 10 500 Illinois St 18 9 1 1     19 Width 9ft   6015934.883119999 2106386.4235799997 37.7646305127095 -122.388069858948 (37.7646305127095, -122.388069858948)
157332 192376 2 10 500 Illinois St 3 9 1 1     10 Width 9ft   6015917.31296 2106690.54623 37.7654645943419 -122.388151855539 (37.7654645943419, -122.388151855539)
160429 192377 2 10 500 Illinois St 6 9 1 1     12 Width 9ft   6015920.48189 2106647.80141 37.7653474018847 -122.38813791154499 (37.7653474018847, -122.388137911545)
162650 192374 2 10 500 Illinois St 1 9 1 1     16 Width 9ft   6015916.946 2106720.28142 37.765546220411295 -122.38815520010901 (37.7655462204113, -122.388155200109)
169571 218978 2 10 635 Joost Ave 1 9 1 1     12     5997875.75574 2094965.1361 37.7322533730829 -122.449708177017 (37.7322533730829, -122.449708177017)
175345 192379 2 10 500 Illinois St 8 9 1 1     8 Width 9ft   6015920.8983 2106611.50942 37.7652477749961 -122.38813393835 (37.7652477749961, -122.38813393835)
180521 192375 2 10 500 Illinois St 2 9 1 1     9 Width 9ft   6015916.65317 2106707.2255 37.765510355454204 -122.38815530173001 (37.7655103554542, -122.38815530173)
36001 247737 2 10 900 Waller St 2 7 1 1     30     6001325.389909999 2108698.90723 37.770159774875005 -122.438765814492 (37.770159774875, -122.438765814492)
52261 247740 2 10 900 Waller St 5 7 1 1     22     6001271.06334 2108691.18463 37.770135479706 -122.43895317566299 (37.770135479706, -122.438953175663)
54831 247742 2 10 900 Waller St 7 7 1 1     33     6001240.13282 2108686.18743 37.7701199987585 -122.43905980557699 (37.7701199987585, -122.439059805577)
57480 247197 2 10 900 Waller St 11 7 1 1     18     6001288.44424 2108651.52945 37.7700275853458 -122.43889021322501 (37.7700275853458, -122.438890213225)
73452 192387 2 10 50 Quint St 1 7 1 1     4 Width 6ft   6015746.952330001 2099779.40581 37.7464786270998 -122.388258719272 (37.7464786270998, -122.388258719272)
103164 109415 6 10 4 GUY PL 2 7 1 1           6014378.1 2114502.6 37.786829336844605 -122.394022608955 (37.7868293368446, -122.394022608955)
146890 192388 2 10 50 Quint St 2 7 1 1     5 Width 6ft   6015744.90256 2099774.65774 37.7464654763079 -122.388265475891 (37.7464654763079, -122.388265475891)
147885 247198 2 10 900 Waller St 12 7 1 1     23     6001308.18443 2108654.86509 37.7700378672708 -122.438822171426 (37.7700378672708, -122.438822171426)
149445 247196 2 10 900 Waller St 10 7 1 1     20     6001271.526330001 2108649.87649 37.7700220841792 -122.438948613411 (37.7700220841792, -122.438948613411)
149635 247736 2 10 900 Waller St 1 7 1 1     26     6001355.82425 2108703.21094 37.770173323178895 -122.438660851038 (37.7701733231789, -122.438660851038)
160176 247741 2 10 900 Waller St 6 7 1 1     22     6001253.60455 2108688.62285 37.77012745234 -122.43901338168101 (37.77012745234, -122.439013381681)
161108 247739 2 10 900 Waller St 4 7 1 1     17     6001290.39565 2108693.08102 37.7701417866389 -122.43888644146799 (37.7701417866389, -122.438886441468)
163451 247200 2 10 900 Waller St 14 7 1 1     23     6001346.7374 2108658.67533 37.7700505225398 -122.438689090625 (37.7700505225398, -122.438689090625)
177512 247199 2 10 900 Waller St 13 7 1 1     16     6001327.32822 2108657.34908 37.770045776808 -122.43875613150699 (37.770045776808, -122.438756131507)
178439 247738 2 10 900 Waller St 3 7 1 1     28     6001307.4111 2108694.6373099997 37.7701470278921 -122.438827696866 (37.7701470278921, -122.438827696866)
78646 107392 2 10 299X Noe St 6 5 1 1           6002910.362819999 2106651.2793799997 37.7646275317101 -122.433137087982 (37.7646275317101, -122.433137087982)
79285 107390 2 10 299X Noe St 4 5 1 1         Permit Number 773951 6002910.362819999 2106651.2793799997 37.7646275317101 -122.433137087982 (37.7646275317101, -122.433137087982)
82530 14583 3 10 1159 Masonic Ave 2 5 1 2     60 4X4   5999386.3171 2108834.4593 37.7704214603588 -122.445482773554 (37.7704214603588, -122.445482773554)
94242 107394 2 10 299X Noe St 8 5 1 1           6002910.362819999 2106651.2793799997 37.7646275317101 -122.433137087982 (37.7646275317101, -122.433137087982)
110122 14584 3 10 1159 Masonic Ave 3 5 1 2     100 4x4   5999323.48045 2108827.83023 37.7703996711999 -122.445699648114 (37.7703996711999, -122.445699648114)
117322 107388 2 10 299X Noe St 2 5 1 1         Permit Number 773951 6002910.362819999 2106651.2793799997 37.7646275317101 -122.433137087982 (37.7646275317101, -122.433137087982)
715 246970 3 10 299 Noe St 2 4 1 2     9 Width 4ft   6002947.4073 2106634.57369 37.764583763244794 -122.43300776749099 (37.7645837632448, -122.433007767491)
719 246969 1 10 299 Noe St 1 4 1 1   09/06/2016 12:00:00 AM 9 Width 4ft Permit Number 778955 6002937.11929 2106633.84457 37.7645811776972 -122.433043298823 (37.7645811776972, -122.433043298823)
31134 246971 2 10 281 Noe St 1 4 1 1     8 Width 4ft   6002932.26985 2106723.06084 37.7648258688387 -122.433066446456 (37.7648258688387, -122.433066446456)
63759 246972 2 10 281 Noe St 2 4 1 1     12 Width 4ft   6002932.11099 2106737.87543 37.764866537093894 -122.433068054458 (37.7648665370939, -122.433068054458)
131504 246974 2 10 255 Noe St 1 4 1 1     22 Width 7ft   6002927.8614 2106813.40847 37.7650736914197 -122.433088149808 (37.7650736914197, -122.433088149808)
149834 246978 2 10 201 Noe St 4 4 1 1     21 Width 8ft   6002919.18964 2107068.61942 37.765773946726604 -122.433136379546 (37.7657739467266, -122.433136379546)
159226 192386 2 10 725 Rhode Island St 2 4 1 1     24 Width 4ft   6011857.61784 2104994.61162 37.7605821695415 -122.40207426103399 (37.7605821695415, -122.402074261034)
162178 246975 2 10 247 Noe St 2 4 1 1     18 Width 7ft   6002924.19309 2106865.87751 37.7652175505697 -122.43310458672899 (37.7652175505697, -122.433104586729)
181235 246973 2 10 281 Noe St 3 4 1 1     14 Width 4ft   6002929.82417 2106784.67092 37.764994896425705 -122.433079307674 (37.7649948964257, -122.433079307674)
184825 246977 2 10 201 Noe St 3 4 1 1     27 Width 8ft   6002905.92105 2107067.14879 37.765769156055704 -122.433182167637 (37.7657691560557, -122.433182167637)
23876 218979 2 10 551 Junipero Serra Blvd 18 2 1 1     8 Width 3ft   5991462.95986 2093729.88952 37.7284927194476 -122.47178846497101 (37.7284927194476, -122.471788464971)
27154 192389 2 10 450 Amador St 3 2 1 1     13 Width 5ft   6018217.012999999 2099612.2395900004 37.746156176965606 -122.37970582128901 (37.7461561769656, -122.379705821289)
27230 218984 2 10 145 Vasquez Ave 1 2 1 1     15 Width 3ft   5994984.805980001 2099511.62786 37.744571095774 -122.46003202358101 (37.744571095774, -122.460032023581)
44535 245182 2 10 101 Baker St 2 2 1 1     21 Width 0ft   6000783.8214 2109356.5198 37.771934589146596 -122.440686267053 (37.7719345891466, -122.440686267053)
55255 218981 2 10 501 Junipero Serra Blvd 4 2 1 1     8 Width 3ft   5991484.23887 2094055.3535200001 37.7293875934485 -122.47173861195 (37.7293875934485, -122.47173861195)
58382 245183 2 10 101 Baker St 3 2 1 1     17 Width 0ft   6000788.1423 2109334.9151 37.77187551412229 -122.44066977084299 (37.7718755141223, -122.440669770843)
61784 124031 2 10 101 Funston Ave 2 2 1 1     13 Width 3ft   5991786.57969 2114495.60147 37.785528628097296 -122.472182755667 (37.7855286280973, -122.472182755667)
131678 218980 2 10 501 Junipero Serra Blvd 2 2 1 1     10 Width 3ft   5991479.42203 2093975.5381 37.729168161565596 -122.47174944968 (37.7291681615656, -122.47174944968)
150110 218983 2 10 145 Vasquez Ave 2 2 1 1     14 Width 3ft   5994996.58862 2099522.38942 37.7446013220014 -122.459992061292 (37.7446013220014, -122.459992061292)
17 145278 2 10 730 11th Ave 1 1 1 1   03/20/2017 12:00:00 AM 0 Width 3ft Permit Number 779614 5992589.961569999 2110455.11477 37.774481011910204 -122.469109146279 (37.7744810119102, -122.469109146279)
696 5946 3 10 1415 Eddy St 3 1 1 2     12 3X3   6003699.8521 2112803.046 37.7815635260957 -122.43084551167601 (37.7815635260957, -122.430845511676)
1161 228132 1 10 236 Grattan St 1 1 1 1   07/31/1973 12:00:00 AM 23 Width 3ft Permit Number 12386 5997539.90606 2106468.8722 37.7638205814857 -122.451698812867 (37.7638205814857, -122.451698812867)
1385 23847 1 10 1370 Webster St 2 1 1 1     20 3X3   6003735.9392 2113413.2165 37.7832409463281 -122.43076422395599 (37.7832409463281, -122.430764223956)
1657 251641 3 10 1785 Webster St 2 1 1 2       3x3   6003432.0 2114811.0 37.787061682920395 -122.43191557230301 (37.7870616829204, -122.431915572303)
1662 251640 3 10 1785 Webster St 1 1 1 2       3x3   6003432.0 2114811.0 37.787061682920395 -122.43191557230301 (37.7870616829204, -122.431915572303)
2038 23713 1 10 709 Webster St 1 1 1 1     25 4X4   6003942.7402 2111225.1787 37.7772448524761 -122.429892651683 (37.7772448524761, -122.429892651683)
2117 5944 3 10 1415 Eddy St 1 1 1 2     12 3X3   6003654.4203 2112794.2785 37.78153687853621 -122.43100205797701 (37.7815368785362, -122.431002057977)
2149 225887 1 10 117 Conrad St 2 1 1 1   06/27/2017 12:00:00 AM 3 Width 2ft Permit Number 42143 6001804.962730001 2096660.33983 37.73713202700829 -122.436245312495 (37.7371320270083, -122.436245312495)
2242 23928 3 10 1715 Webster St 2 1 1 2     70 4X4   6003464.0168 2114669.7894 37.7866757692841 -122.431794715065 (37.7866757692841, -122.431794715065)
2714 141996 3 10 818 WEBSTER ST 6 1 1 2     24 Width 0ft   6003983.1859 2111655.6546 37.7784291232811 -122.42978344870899 (37.7784291232811, -122.429783448709)
2717 141997 3 10 818 WEBSTER ST 7 1 1 2     18 Width 0ft   6003978.0604 2111685.2682 37.7785101446541 -122.42980329253 (37.7785101446541, -122.42980329253)
2718 141991 1 10 818 Webster St 1 1 1 1     9 Width 0ft   6004002.4362 2111527.1662 37.7780774159831 -122.429707688099 (37.7780774159831, -122.429707688099)
Powered by Datasette · Query took 7.636ms · Data source: data.sfgov.org