sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
31416 198059 2 37 820 Illinois St 7 9 1 1     2 Width 9ft   6016002.244 2105125.97833 37.7611733325983 -122.387748922377 (37.7611733325983, -122.387748922377)
33100 198058 2 37 820 Illinois St 6 9 1 1     2 Width 9ft   6016003.50284 2105138.76714 37.7612085176665 -122.387745460881 (37.7612085176665, -122.387745460881)
72093 198060 2 37 820 Illinois St 8 9 1 1     3 Width 9ft   6016003.71174 2105110.97053 37.761132205694295 -122.387742798886 (37.7611322056943, -122.387742798886)
133930 198057 2 37 820 Illinois St 5 9 1 1     2 Width 9ft   6015999.46733 2105182.54146 37.7613284890375 -122.38776247247499 (37.7613284890375, -122.387762472475)
156731 198053 2 37 820 Illinois St 1 9 1 1     3 Width 9ft   6015994.50717 2105252.5943299998 37.761520564453896 -122.387784515751 (37.7615205644539, -122.387784515751)
159393 198054 2 37 820 Illinois St 2 9 1 1     2 Width 9ft   6015996.1825 2105236.6253 37.7614768097219 -122.387777607167 (37.7614768097219, -122.387777607167)
161939 198055 2 37 820 Illinois St 3 9 1 1     2 Width 9ft   6015997.74921 2105213.0549 37.7614121772375 -122.387770543876 (37.7614121772375, -122.387770543876)
180161 198056 2 37 820 Illinois St 4 9 1 1     2 Width 9ft   6015997.12564 2105199.4171 37.761374696215704 -122.38777174897699 (37.7613746962157, -122.387771748977)
2953 192045 2 37 405 Townsend St 1 9 1 1   08/14/2017 12:00:00 AM 3 Width 8ft Permit Number 780033 6013178.04643 2110099.77457 37.7746734191738 -122.39786558493401 (37.7746734191738, -122.397865584934)
2963 192048 2 37 405 Townsend St 4 9 1 1   08/14/2017 12:00:00 AM 3 Width 8ft Permit Number 780033 6013251.73009 2110171.5616599997 37.7748746334969 -122.39761573260401 (37.7748746334969, -122.397615732604)
2964 192047 2 37 405 Townsend St 3 9 1 1   08/14/2017 12:00:00 AM 3 Width 8ft Permit Number 780033 6013240.399669999 2110155.0455099996 37.7748286529654 -122.397653768512 (37.7748286529654, -122.397653768512)
2979 192049 2 37 405 Townsend St 5 9 1 1   08/14/2017 12:00:00 AM 3 Width 8ft Permit Number 780033 6013269.505969999 2110186.9808900002 37.77491796101779 -122.397555323332 (37.7749179610178, -122.397555323332)
2980 192046 2 37 405 Townsend St 2 9 1 1   08/14/2017 12:00:00 AM 3 Width 8ft Permit Number 780033 6013200.03931 2110117.49199 37.774723291973096 -122.39779074965 (37.7747232919731, -122.39779074965)
3009 192050 2 37 405 Townsend St 6 9 1 1   08/14/2017 12:00:00 AM 3 Width 8ft Permit Number 780033 6013285.99525 2110202.74852 37.774962173497 -122.39749938908501 (37.774962173497, -122.397499389085)
4433 180628 2 37 339 Cordova St 1 1 1 1   10/11/2017 11:40:00 AM 3 Width 8ft   6001976.18123 2086917.49182 37.710390087913794 -122.43495675757299 (37.7103900879138, -122.434956757573)
24059 180255 2 37 2 Still St 5 9 1 1     1 Width 8ft   6003484.65095 2094730.37892 37.73192808471529 -122.4303002173 (37.7319280847153, -122.4303002173)
25789 180259 2 37 2 Still St 9 9 1 1     1 Width 8ft   6003405.48601 2094728.1839700001 37.7319175734374 -122.430573750589 (37.7319175734374, -122.430573750589)
32316 180260 2 37 2 Still St 12 9 1 1     1 Width 8ft   6003350.60066 2094725.0139900001 37.731905759936204 -122.43076327462299 (37.7319057599362, -122.430763274623)
37137 180253 2 37 2 Still St 3 9 1 1     1 Width 8ft   6003528.91801 2094729.13365 37.7319271727957 -122.430147087941 (37.7319271727957, -122.430147087941)
40388 180264 2 37 4 Still St 2 9 1 1     1 Width 8ft   6003250.762019999 2094715.77972 37.731874747719296 -122.43110777880699 (37.7318747477193, -122.431107778807)
52006 180261 2 37 81 Rotteck St 1 9 1 1     1 Width 8ft   6003329.74924 2094722.2171 37.7318968989209 -122.43083516281601 (37.7318968989209, -122.430835162816)
52806 180320 2 37 817 Cayuga Ave 1 9 1 1     9 Width 8ft   6001210.40568 2092189.73212 37.7248229683925 -122.43798083136801 (37.7248229683925, -122.437980831368)
53016 180001 2 37 62 Tomaso Ct 6 7 1 1     22 Width 8ft   6009181.15123 2086279.38185 37.709044431429604 -122.41000974567899 (37.7090444314296, -122.410009745679)
59741 180263 2 37 4 Still St 1 9 1 1     1 Width 8ft   6003281.3255900005 2094718.1068900002 37.7318828694844 -122.431002280233 (37.7318828694844, -122.431002280233)
74370 180257 2 37 2 Still St 7 9 1 1     1 Width 8ft   6003441.65592 2094728.25721 37.7319198235266 -122.430448708839 (37.7319198235266, -122.430448708839)
136973 180258 2 37 2 Still St 8 9 1 1     1 Width 8ft   6003421.15336 2094728.39885 37.7319190510051 -122.43051960059799 (37.7319190510051, -122.430519600598)
148487 180262 2 37 76 Rotteck St 1 9 1 1     1 Width 8ft   6003305.93949 2094720.0194 37.7318895154806 -122.43091732130199 (37.7318895154806, -122.430917321302)
153804 180256 2 37 2 Still St 6 9 1 1     1 Width 8ft   6003464.1171 2094730.21395 37.7319264686289 -122.430371195377 (37.7319264686289, -122.430371195377)
166436 241422 2 37 687 28th St 1 9 1 1     3 Width 8ft   6001495.68949 2099380.02037 37.7445820558098 -122.437509311417 (37.7445820558098, -122.437509311417)
179681 180254 2 37 2 Still St 4 9 1 1     1 Width 8ft   6003505.97344 2094729.60695 37.7319271728025 -122.43022644590599 (37.7319271728025, -122.430226445906)
181102 180251 2 37 2 Still St 1 9 1 1     1 Width 8ft   6003572.96144 2094730.3764 37.7319330795535 -122.42999490913799 (37.7319330795535, -122.429994909138)
184848 180252 2 37 2 Still St 2 9 1 1     1 Width 8ft   6003553.26198 2094731.05162 37.7319338178795 -122.43006306247801 (37.7319338178795, -122.430063062478)
187661 242298 2 37 297 Addison St 7 9 1 1     1 Width 8ft   6002506.63703 2097692.2502 37.740005256637204 -122.433893045753 (37.7400052566372, -122.433893045753)
28793 198050 2 37 1410 Indiana St 11 9 1 1     11 Width 7ft   6015069.990669999 2101754.6780000003 37.7518647765405 -122.39073761146001 (37.7518647765405, -122.39073761146)
43636 198046 2 37 1410 Indiana St 5 9 1 1     10 Width 7ft   6015063.38208 2101850.3789 37.7521271843206 -122.39076715240299 (37.7521271843206, -122.390767152403)
49735 198045 2 37 1410 Indiana St 4 9 1 1     13 Width 7ft   6015062.9459 2101861.12211 37.752156658702795 -122.39076941150299 (37.7521566587028, -122.390769411503)
55861 198051 2 37 1410 Indiana St 13 9 1 1     10 Width 7ft   6015071.52893 2101713.75148 37.75175248631 -122.390729432117 (37.75175248631, -122.390729432117)
56508 198049 2 37 1410 Indiana St 10 9 1 1     10 Width 7ft   6015069.63855 2101758.53914 37.751875358878706 -122.39073909895201 (37.7518753588787, -122.390739098952)
60681 198052 2 37 1410 Indiana St 14 9 1 1     10 Width 7ft   6015072.05685 2101707.95994 37.7517366132545 -122.390727201795 (37.7517366132545, -122.390727201795)
153806 198047 2 37 1410 Indiana St 7 9 1 1     12 Width 7ft   6015066.24104 2101813.8486200003 37.75202703851829 -122.390754712971 (37.7520270385183, -122.390754712971)
156215 202208 2 37 1978 Armstrong Ave 1 9 1 1     6 Width 7ft   6012988.24456 2093553.53748 37.7292304495144 -122.397361556292 (37.7292304495144, -122.397361556292)
157246 198048 2 37 1410 Indiana St 8 9 1 1     11 Width 7ft   6015066.1545400005 2101809.56795 37.7520152799043 -122.390754712983 (37.7520152799043, -122.390754712983)
182094 202209 2 37 1988 Armstrong Ave 1 9 1 1     3 Width 7ft   6012983.51399 2093557.8365599997 37.7292419905249 -122.39737821176 (37.7292419905249, -122.39737821176)
3423 251752 2 37 128 South Hill Blvd 2 2 1 1       Width 6ft   6003064.16129 2086909.24662 37.7104291634552 -122.431195883608 (37.7104291634552, -122.431195883608)
3432 180655 2 37 128 South Hill Blvd 1 2 1 1     31 Width 6ft   6003064.16129 2086909.24662 37.7104291634552 -122.431195883608 (37.7104291634552, -122.431195883608)
3488 251753 2 37 128 South Hill Blvd 3 2 1 1       Width 6ft   6003064.16129 2086909.24662 37.7104291634552 -122.431195883608 (37.7104291634552, -122.431195883608)
28332 120358 2 37 2350 Lake St 3 2 1 1     2 Width 6ft   5988092.81378 2114686.07827 37.785837168438604 -122.48497592142598 (37.7858371684386, -122.484975921426)
30355 180399 2 37 349 Chicago Way 1 2 1 1     2 Width 6ft   6002410.48398 2086459.29818 37.7091566380421 -122.433422996175 (37.7091566380421, -122.433422996175)
58332 241490 2 37 2115 Castro St 1 10 1 1     8 Width 6ft   6002706.79399 2099384.51572 37.744663180953495 -122.433321879096 (37.7446631809535, -122.433321879096)
136105 241643 2 37 599 Buchanan St 2 2 1 1     3 Width 6ft   6004545.6184 2110424.56888 37.7750806969521 -122.42775004393499 (37.7750806969521, -122.427750043935)
156844 214904 2 37 556 Dewey Blvd 3 1 1 1     6 Width 6ft   5994175.9863599995 2099523.30765 37.744556613096 -122.462829586019 (37.744556613096, -122.462829586019)
158849 214903 2 37 556 Dewey Blvd 1 1 1 1     7 Width 6ft   5994195.751619999 2099539.59753 37.744602479411604 -122.46276242374901 (37.7446024794116, -122.462762423749)
161813 241662 2 37 176 Duncan St 1 1 1 1     13 Width 6ft   6005437.24469 2099940.9896 37.7463456551373 -122.42392006786801 (37.7463456551373, -122.423920067868)
164072 180400 2 37 511 Cordova St 1 1 1 1     1 Width 6ft   6002102.27199 2086536.9163099998 37.709352269366995 -122.434493768575 (37.709352269367, -122.434493768575)
168833 241663 2 37 176 Duncan St 2 1 1 1     13 Width 6ft   6005417.963819999 2099937.74161 37.74633564837 -122.42398650799 (37.74633564837, -122.42398650799)
177841 241660 2 37 82 Tiffany Ave 1 1 1 1     7 Width 6ft   6006235.840480001 2099584.03625 37.7454105949184 -122.421133271198 (37.7454105949184, -122.421133271198)
182096 118080 2 37 7230 Geary Blvd 1 2 1 1     4 Width 6ft   5984526.23316 2112508.36467 37.77964941454 -122.49715429910201 (37.77964941454, -122.497154299102)
22983 241570 2 37 172 Carl St 1 1 1 1     10 Width 5ft   5997494.28086 2107124.8182599996 37.765619029516294 -122.451903941019 (37.7656190295163, -122.451903941019)
24003 180323 2 37 1682 Alemany Blvd 2 1 1 1     2 Width 5ft   6001502.91955 2092324.6782 37.7252101301195 -122.436979304073 (37.7252101301195, -122.436979304073)
24030 136773 2 37 3700 Clay St 1 2 1 1     1 Width 5ft   5997087.63405 2115382.9814299997 37.7882704886466 -122.453906871501 (37.7882704886466, -122.453906871501)
24590 180142 2 37 1118 Russia Ave 2 9 1 1     3 Width 5ft   6004028.1507 2089329.0394599999 37.7171279723626 -122.42803645642599 (37.7171279723626, -122.428036456426)
25905 242135 2 37 134 Collingwood St 6 1 1 1     6 Width 5ft   6002035.55784 2104758.56511 37.7593809360961 -122.43602735368201 (37.7593809360961, -122.436027353682)
28033 242140 2 37 570 Noe St 2 1 1 1     3 Width 5ft   6002975.949630001 2104907.04383 37.7598420023198 -122.432785628653 (37.7598420023198, -122.432785628653)
29196 242139 2 37 570 Noe St 1 1 1 1     3 Width 5ft   6002975.33839 2104919.63759 37.7598765470916 -122.432788642302 (37.7598765470916, -122.432788642302)
29425 218603 2 37 1355 04th Ave 1 1 1 1     7 Width 5ft   5994857.52335 2106307.45764 37.7632233929651 -122.460964592666 (37.7632233929651, -122.460964592666)
33619 242117 2 37 3862 23rd St 1 1 1 1     5 Width 5ft   6004018.60502 2102491.85861 37.7532695544679 -122.429007395984 (37.7532695544679, -122.429007395984)
33930 179988 2 37 765 Morse St 3 10 1 1     2 Width 5ft   5998318.043769999 2087022.65362 37.7104704522241 -122.447607562158 (37.7104704522241, -122.447607562158)
33953 247763 2 37 55 Alpine Ter 1 4 1 1     1 Width 5ft   6001651.1462 2108480.6901700003 37.769579132108205 -122.43762339851101 (37.7695791321082, -122.437623398511)
41263 218719 3 37 99x San Marcos Ave 1 11 1 2     5 Width 5ft   5993701.46816 2100309.93296 37.7466891448909 -122.464527467374 (37.7466891448909, -122.464527467374)
43977 179983 2 37 23 Whittier St 3 1 1 1     1 Width 5ft   5998155.09065 2086884.2051799998 37.710080990013296 -122.448160798105 (37.7100809900133, -122.448160798105)
45268 136830 2 37 2333 Buchanan St 10 1 1 1     4 Width 5ft   6003766.78319 2116019.8084299997 37.7903997379064 -122.430843596649 (37.7903997379064, -122.430843596649)
52249 242116 2 37 11 Vicksburg St 2 1 1 1     2 Width 5ft   6004100.79809 2102964.07193 37.7545707934166 -122.428756816079 (37.7545707934166, -122.428756816079)
55160 241567 2 37 184 Carl St 1 1 1 1     10 Width 5ft   5997406.333880001 2107112.14294 37.7655791886465 -122.45220721399299 (37.7655791886465, -122.452207213993)
55189 136906 2 37 471 Vallejo St 1 1 1 1     1 Width 5ft   6011241.0783400005 2118988.5084700002 37.7989717177149 -122.405192033407 (37.7989717177149, -122.405192033407)
58030 241836 2 37 585 Buena Vista Ave West 1 1 1 1     6 Width 5ft   5999889.428069999 2107459.27885 37.76667426883821 -122.443643711196 (37.7666742688382, -122.443643711196)
58259 241644 2 37 415 Oak St 1 4 1 1     5 Width 5ft   6004982.83626 2110199.4621900003 37.774487331444895 -122.426221580476 (37.7744873314449, -122.426221580476)
60120 241884 3 37 387x Holly Park Cir 1 11 1 2     2 Width 5ft   6006329.1092300005 2096869.11862 37.737961298159796 -122.420618072992 (37.7379612981598, -122.420618072992)
60449 241783 2 37 209 Day St 8 1 1 1     12 Width 5ft   6004329.75023 2098662.66645 37.7427730875169 -122.427658592787 (37.7427730875169, -122.427658592787)
65467 242169 2 37 495 Douglass St 1 1 1 1     4 Width 5ft   6001204.17131 2103411.5478 37.7556350870992 -122.438806161672 (37.7556350870992, -122.438806161672)
67528 241654 2 37 141 Albion St 4 1 1 1     6 Width 5ft   6005916.78459 2106427.17738 37.7641822834171 -122.42272273568899 (37.7641822834171, -122.422722735689)
68479 179981 2 37 23 Whittier St 1 1 1 1     1 Width 5ft   5998169.97204 2086845.49283 37.7099755454025 -122.448106579751 (37.7099755454025, -122.448106579751)
69338 179989 2 37 765 Morse St 4 1 1 1     2 Width 5ft   5998350.145880001 2087034.76993 37.7105055554714 -122.447497482426 (37.7105055554714, -122.447497482426)
69697 242136 2 37 4244 19th St 1 1 1 1     5 Width 5ft   6002010.12095 2104720.80627 37.759275814344896 -122.43611262471701 (37.7592758143449, -122.436112624717)
70711 241571 2 37 170 Carl St 1 1 1 1     12 Width 5ft   5997509.15419 2107127.05359 37.7656260190416 -122.45185265898701 (37.7656260190416, -122.451852658987)
72783 179985 2 37 23 Whittier St 5 1 1 1     1 Width 5ft   5998139.51533 2086920.9795799998 37.7101810737559 -122.448217275509 (37.7101810737559, -122.448217275509)
74481 218721 3 37 99x San Marcos Ave 3 11 1 2     7 Width 5ft   5993716.07745 2100297.78462 37.746656630797794 -122.464476068412 (37.7466566307978, -122.464476068412)
130312 198009 2 37 275 Shipley St 1 4 1 1     1 Width 5ft   6011338.42729 2111564.35079 37.778592185327604 -122.404332338179 (37.7785921853276, -122.404332338179)
132703 136829 2 37 2333 Buchanan St 9 1 1 1     4 Width 5ft   6003763.28449 2116038.9116 37.7904519921279 -122.430857065799 (37.7904519921279, -122.430857065799)
147824 218720 3 37 99x San Marcos Ave 2 11 1 2     5 Width 5ft   5993709.38363 2100297.55504 37.746655614559295 -122.464499198102 (37.7466556145593, -122.464499198102)
149191 136901 2 37 2333 Leavenworth St 5 1 1 1     1 Width 5ft   6007536.47447 2120305.57509 37.8023802472184 -122.41810464953001 (37.8023802472184, -122.41810464953)
149766 241883 3 37 387x Holly Park Cir 2 11 1 2     2 Width 5ft   6006344.8052900005 2096881.18885 37.7379953249194 -122.420564660452 (37.7379953249194, -122.420564660452)
150104 180141 2 37 1118 Russia Ave 1 9 1 1     3 Width 5ft   6004021.0387699995 2089333.04789 37.717138576267 -122.42806132447201 (37.717138576267, -122.428061324472)
151362 198044 2 37 551 Utah St 8 1 1 1     6 Width 5ft   6010697.74849 2105726.3577 37.7625265739605 -122.406137295513 (37.7625265739605, -122.406137295513)
152094 241568 2 37 180 Carl St 1 1 1 1     13 Width 5ft   5997429.42135 2107115.9889700003 37.7655910714086 -122.452127637501 (37.7655910714086, -122.452127637501)
155724 241572 2 37 160 Carl St 1 1 1 1     19 Width 5ft   5997589.92507 2107138.86061 37.765663063919604 -122.45157414343399 (37.7656630639196, -122.451574143434)
156486 242290 2 37 411 30th St 1 1 1 1     9 Width 5ft   6003806.71849 2098340.54293 37.7418590111824 -122.429444121165 (37.7418590111824, -122.429444121165)
159416 241569 2 37 176 Carl St 1 1 1 1     9 Width 5ft   5997468.43063 2107123.32124 37.7656134384409 -122.451993242792 (37.7656134384409, -122.451993242792)
163828 241574 2 37 243 Grattan St 1 1 1 1     1 Width 5ft   5997516.68274 2106421.75232 37.7636898722165 -122.451775735471 (37.7636898722165, -122.451775735471)
164477 180380 2 37 4208 Mission St 1 1 1 1     7 Width 5ft   6003442.645819999 2093953.48682 37.729792534794 -122.430390028073 (37.729792534794, -122.430390028073)
168162 241782 2 37 209 Day St 6 1 1 1     15 Width 5ft   6004251.25881 2098661.7812200002 37.7427662166839 -122.42792993083201 (37.7427662166839, -122.427929930832)
169989 179984 2 37 23 Whittier St 4 1 1 1     1 Width 5ft   5998143.81112 2086907.5465900002 37.710144435400295 -122.44820146183201 (37.7101444354003, -122.448201461832)
Powered by Datasette · Query took 21.165ms · Data source: data.sfgov.org