sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
188033 226640 2 4 10 Crescent Ave 2 17 1 1     4 Width 3ft   6005282.96903 2095902.7994400002 37.7352489878562 -122.42416639485799 (37.7352489878562, -122.424166394858)
187883 129522 2 4 1240 Lombard St 2 9 1 1     5 Width 2ft   6006403.02216 2120103.20622 37.8017607330441 -122.422012573438 (37.8017607330441, -122.422012573438)
186716 129538 2 4 586 Bush St 2 1 1 1     7 Width 3ft   6010716.07014 2115909.27019 37.7904875090489 -122.406791615267 (37.7904875090489, -122.406791615267)
186226 129526 2 4 2677 Larkin St 1 1 1 1     10 Width 2ft   6006553.85688 2120395.35345 37.8025714008062 -122.421511374958 (37.8025714008062, -122.421511374958)
184962 57852 1 4 44 Montgomery St 1 1 1 1   04/14/1977 12:00:00 AM 10   Permit Number 16793 6012080.13289 2115527.6650900003 37.7895159399674 -122.402045176939 (37.7895159399674, -122.402045176939)
182512 129555 2 4 216 Post St 1 10 1 1     1 Width 3ft   6011031.64459 2115258.30549 37.7887177673445 -122.40565387214599 (37.7887177673445, -122.405653872146)
182054 129505 2 4 2644 Filbert St 2 1 1 1     5 Width 3ft   6000286.7796 2118548.8617700003 37.7971460678835 -122.44306584551501 (37.7971460678835, -122.443065845515)
181690 121987 2 4 524 15th Ave 1 1 1 1     5 Width 3ft   5991287.8185 2111802.50892 37.7781052628966 -122.47371177632799 (37.7781052628966, -122.473711776328)
180697 129556 2 4 216 Post St 2 10 1 1     1 Width 3ft   6011025.30596 2115257.2463 37.7887145046082 -122.405675728365 (37.7887145046082, -122.405675728365)
179072 53853 1 4 586 Bush St 1 1 1 1   03/01/1972 12:00:00 AM 6   Permit Number 9561 6010726.48535 2115910.4479900002 37.790491325756896 -122.40675566215599 (37.7904913257569, -122.406755662156)
178970 118574 2 4 7900 Geary Blvd 4 1 1 1     2 Width 3ft   5982449.98783 2112431.50605 37.779316488746 -122.50433111328199 (37.779316488746, -122.504331113282)
178665 177036 2 4 15 Merrill St 2 9 1 1     17 Width 2ft   6009502.62349 2094943.7258099997 37.7328529276995 -122.409509775682 (37.7328529276995, -122.409509775682)
178419 191431 2 4 9 Sumner St 1 9 1 1     5 Width 2ft   6009550.82105 2110763.25421 37.7762925082147 -122.410459796982 (37.7762925082147, -122.410459796982)
174209 191427 2 4 1627 20th St 1 4 1 1     4 Width 3ft   6013091.09687 2104712.62895 37.7598766756903 -122.39778840962099 (37.7598766756903, -122.397788409621)
173094 191419 2 4 574 Vermont St 1 1 1 1     8 Width 3ft   6011201.13816 2105680.19927 37.762427976796296 -122.404392995652 (37.7624279767963, -122.404392995652)
172460 75304 2 4 240 07th St 2 1 1 1 1 09/10/1994 12:00:00 AM 2     6010043.764880001 2111144.47071 37.7773668617363 -122.408781461497 (37.7773668617363, -122.408781461497)
171149 191423 2 4 872 Rhode Island St 1 4 1 1     4 Width 4ft   6011836.2577599995 2104328.91927 37.758753133763705 -122.402101335126 (37.7587531337637, -122.402101335126)
170844 129512 2 4 3223 Webster St 1 1 1 1     8 Width 3ft   6002763.64169 2119722.26517 37.8005088389808 -122.43457924465 (37.8005088389808, -122.43457924465)
170738 249913 2 4 356 Greenwich St 2 7 1 1     8 Width 0ft   6011242.070719999 2120420.51237 37.802903706599295 -122.40528949653601 (37.8029037065993, -122.405289496536)
170716 218286 2 4 1 Woodacre Dr 10 2 1 1     4     5991335.90639 2095594.8050900002 37.7336059570417 -122.472363586812 (37.7336059570417, -122.472363586812)
170546 129541 2 4 508 Stockton St 1 1 1 1     9 Width 3ft   6010626.2585 2115918.27933 37.7905072203931 -122.40710299472799 (37.7905072203931, -122.407102994728)
170102 207365 2 4 1678 17th Ave 1 1 1 1     5 Width 3ft   5990916.62821 2103981.8612 37.756610367702706 -122.47442498042601 (37.7566103677027, -122.474424980426)
170003 123059 2 4 500 Funston Ave 2 2 1 1     1 Width 4ft   5991916.7341 2111968.89129 37.7785985076866 -122.47154827826901 (37.7785985076866, -122.471548278269)
169559 191421 2 4 785 Rhode Island St 2 9 1 1     7 Width 3ft   6011879.919919999 2104709.23521 37.7597998340098 -122.40197706591002 (37.7597998340098, -122.40197706591)
169044 129539 2 4 586 Bush St 3 1 1 1     8 Width 3ft   6010703.940330001 2115907.6638700003 37.7904824197785 -122.406833470599 (37.7904824197785, -122.406833470599)
168981 123060 2 4 500 Funston Ave 1 2 1 1     1 Width 4ft   5991917.4637 2111957.21563 37.7785664917216 -122.47154490330601 (37.7785664917216, -122.471544903306)
168068 177032 2 4 663 University St 1 9 1 1     6 Width 5ft   6008682.45825 2090982.7781200001 37.7219310184866 -122.41206547985901 (37.7219310184866, -122.412065479859)
167962 129504 2 4 2656 Filbert St 1 1 1 1     10 Width 3ft   6000274.51269 2118548.1954799998 37.7971435390014 -122.44310824405399 (37.7971435390014, -122.443108244054)
166908 129552 2 4 44 Montgomery St 5 10 1 1     4 Width 4ft   6012061.46033 2115633.25932 37.789804834569296 -122.402117209065 (37.7898048345693, -122.402117209065)
166827 226658 2 4 117 Laidley St 2 1 1 1     13 Width 3ft   6003646.084869999 2097679.68219 37.7400353434466 -122.429952409889 (37.7400353434466, -122.429952409889)
166596 207366 2 4 1263 17th Ave 1 1 1 1     4 Width 2ft   5990777.74909 2106795.52344 37.7643278872345 -122.475110663153 (37.7643278872345, -122.475110663153)
165862 129518 2 4 3041 Divisadero St 2 4 1 1     3 Width 2ft   6000446.00148 2118771.96061 37.797767715271796 -122.44253092607 (37.7977677152718, -122.44253092607)
165011 120188 2 4 224 26th Ave 2 1 1 1     6 Width 3ft   5987762.7194300005 2114453.05727 37.785178126956396 -122.486100829584 (37.7851781269564, -122.486100829584)
164863 129537 3 4 1306x Montgomery St 22 3 1 2     1 Width 8ft   6011446.5417 2119990.51434 37.801734466528 -122.404551630663 (37.801734466528, -122.404551630663)
163369 129540 2 4 586 Bush St 4 1 1 1     7 Width 3ft   6010689.62141 2115905.1759099998 37.7904747872294 -122.406882837979 (37.7904747872294, -122.406882837979)
163344 226643 2 4 48 Cumberland St 2 4 1 1     2 Width 2ft   6005334.035069999 2104616.89651 37.75917878378829 -122.42460951781099 (37.7591787837883, -122.424609517811)
161992 129502 2 4 2857 Union St 2 9 1 1     3 Width 1ft   5999324.2861 2118011.40576 37.7956154316639 -122.44635761511499 (37.7956154316639, -122.446357615115)
161949 129517 2 4 3047 Divisadero St 3 4 1 1     3 Width 3ft   6000445.055869999 2118784.6129 37.7978024012088 -122.442535107006 (37.7978024012088, -122.442535107006)
161411 129557 2 4 300 California St 1 10 1 1     4 Width 3ft   6012628.75569 2116888.8810400004 37.7932841227067 -122.40024263249201 (37.7932841227067, -122.400242632492)
160826 129520 2 4 3041 Divisadero St 4 4 1 1     2 Width 2ft   6000447.31564 2118755.2398900003 37.7977218795107 -122.442525177605 (37.7977218795107, -122.442525177605)
159256 249501 2 4 1765 California St 7 10 1 1     1 Width 3ft   6006000.97948 2115886.86804 37.790161048840794 -122.42310396280001 (37.7901610488408, -122.4231039628)
158427 129506 2 4 2644 Filbert St 1 1 1 1     6 Width 3ft   6000302.575 2118552.44748 37.7971568138825 -122.443011447325 (37.7971568138825, -122.443011447325)
157440 129527 2 4 2677 Larkin St 2 1 1 1     9 Width 2ft   6006554.47344 2120382.0459 37.802534896425 -122.421508295689 (37.802534896425, -122.421508295689)
156654 177030 2 4 235 Ottawa Ave 1 9 1 1     6 Width 4ft   5998356.41955 2089266.50528 37.7166337499183 -122.447636347658 (37.7166337499183, -122.447636347658)
154592 117871 2 4 850 40th Ave 1 1 1 1     5 Width 4ft   5983579.8283400005 2110008.29889 37.7727294500776 -122.500243389783 (37.7727294500776, -122.500243389783)
150809 129523 2 4 1109 Chestnut St 4 1 1 1     5 Width 3ft   6006484.20699 2120406.53709 37.802598180831396 -122.42175319366001 (37.8025981808314, -122.42175319366)
150604 177029 2 4 123 Seneca Ave 2 10 1 1     4 Width 0ft   6000050.7624699995 2090072.63848 37.7189438978236 -122.441837691751 (37.7189438978236, -122.441837691751)
148863 191420 2 4 785 Rhode Island St 1 9 1 1     18 Width 3ft   6011880.44844 2104704.93056 37.759788043892996 -122.401974935396 (37.759788043893, -122.401974935396)
148565 129542 2 4 508 Stockton St 2 1 1 1     9 Width 3ft   6010625.70171 2115928.16115 37.7905343223424 -122.407105618041 (37.7905343223424, -122.407105618041)
147994 45642 1 4 557 27th Ave 1 1 1 1   08/14/2001 12:00:00 AM 3   Permit Number 44345 5987489.41692 2112170.49335 37.778894923713395 -122.486878678096 (37.7788949237134, -122.486878678096)
147166 66159 1 4 90 Bay View St 1 1 1 1 1 09/04/1990 12:00:00 AM 6   Permit Number 29230 6013889.68751 2094856.83218 37.732859178908 -122.394336381736 (37.732859178908, -122.394336381736)
147024 226652 2 4 225 Corbett Ave 1 1 1 1     11 Width 2ft   5999964.01354 2105579.20426 37.7615163052595 -122.443250685888 (37.7615163052595, -122.443250685888)
144257 226646 2 4 31 Hidalgo Ter 2 1 1 1     18 Width 2ft   6004999.4002 2107477.2952799997 37.767013854632 -122.425970464583 (37.767013854632, -122.425970464583)
138207 123058 2 4 500 Funston Ave 3 2 1 1     1 Width 4ft   5991916.77661 2111982.4939599996 37.778635859363206 -122.471549122693 (37.7786358593632, -122.471549122693)
135694 129558 2 4 300 California St 4 10 1 1     2 Width 3ft   6012591.8685800005 2116885.11843 37.793271734566005 -122.400370000791 (37.793271734566, -122.400370000791)
134630 226651 2 4 1210 Shrader St 1 1 1 1     8 Width 3ft   5997784.115230001 2106211.6118400004 37.7631281925414 -122.450835621062 (37.7631281925414, -122.450835621062)
134626 129532 2 4 2135 Stockton St 3 1 1 1     5 Width 3ft   6009758.75399 2121832.78165 37.8066984049805 -122.410522343935 (37.8066984049805, -122.410522343935)
134435 226653 2 4 214 Corbett Ave 1 1 1 1     12 Width 3ft   5999974.10738 2105629.30684 37.7616544501161 -122.443219374174 (37.7616544501161, -122.443219374174)
134337 129525 2 4 1109 Chestnut St 6 1 1 1     9 Width 3ft   6006520.95763 2120409.72682 37.8026090113668 -122.42162624447799 (37.8026090113668, -122.421626244478)
133672 249499 2 4 1765 California St 3 10 1 1     1 Width 3ft   6005919.33859 2115875.5653 37.7901254069127 -122.423385630445 (37.7901254069127, -122.423385630445)
133340 226641 2 4 953 Treat Ave 3 9 1 1     3 Width 2ft   6008623.395269999 2103036.69536 37.7550251300303 -122.413121556411 (37.7550251300303, -122.413121556411)
133137 191429 2 4 2399 Lane St 7 17 1 1     4     6013991.75526 2092879.9064599997 37.7274366158882 -122.393845172923 (37.7274366158882, -122.393845172923)
132877 117693 2 4 435 42nd Ave 2 1 1 1     4 Width 2ft   5982808.8484 2112817.53757 37.7803975176735 -122.503118273577 (37.7803975176735, -122.503118273577)
131107 129515 2 4 2730 Lyon St 2 1 1 1     6 Width 2ft   5999181.629430001 2118207.9413900003 37.7961469175038 -122.44686537955 (37.7961469175038, -122.44686537955)
130785 129508 2 4 1714 Filbert St 2 1 1 1     10 Width 3ft   6004680.4249 2119161.32221 37.7990772585711 -122.427906404578 (37.7990772585711, -122.427906404578)
130268 177038 2 4 649 Hamilton St 3 1 1 1     2 Width 3ft   6009808.87936 2091375.19794 37.7230716583033 -122.40819937261801 (37.7230716583033, -122.408199372618)
130118 121971 2 4 106 15th Ave 1 1 1 1     7 Width 2ft   5991185.189040001 2114684.00966 37.7860111230721 -122.474277122949 (37.7860111230721, -122.474277122949)
109480 92778 1 4 2701 Pacific Ave   5 2 1   10/15/2009 12:00:00 AM     Permit Number 52996 6001178.5 2116864.5 37.7925720539586 -122.43985945141 (37.7925720539586, -122.43985945141)
101701 112545 2 4 31 HIDALGO TER 2 1 1 1     15 3x3   6004997.0 2107458.0 37.7669607387675 -122.425977392818 (37.7669607387675, -122.425977392818)
93337 15295 3 4 1625 Mission St 1 1 1 2   03/02/1995 12:00:00 AM 3 3X3   6006990.727390001 2109176.21889 37.771791036290296 -122.41920328508002 (37.7717910362903, -122.41920328508)
92559 92776 1 4 2701 Pacific Ave   5 2 1   10/15/2009 12:00:00 AM     Permit Number 52996 6001178.5 2116864.5 37.7925720539586 -122.43985945141 (37.7925720539586, -122.43985945141)
85596 108938 2 4 431 LOMBARD ST 1 1 1 1     5 3x3   6010275.9 2120590.4 37.8033161117204 -122.408644952554 (37.8033161117204, -122.408644952554)
79224 96951 2 4 798X 24th Ave 3 1 1 1     3 3x3   5988521.53055 2110635.12143 37.7747393420729 -122.48319565729601 (37.7747393420729, -122.483195657296)
78020 112544 2 4 31 HIDALGO TER 1 1 1 1     28 3x3   6004997.0 2107458.0 37.7669607387675 -122.425977392818 (37.7669607387675, -122.425977392818)
76500 129528 2 4 2677 Larkin St 3 1 1 1     9 Width 2ft   6006558.18826 2120353.46017 37.802456616741 -122.4214934092 (37.802456616741, -122.4214934092)
75992 75228 2 4 240 07th St 3 1 1 1 1 09/10/1994 12:00:00 AM 5     6010065.6483 2111120.54922 37.7773024046157 -122.408704071262 (37.7773024046157, -122.408704071262)
75729 129524 2 4 1109 Chestnut St 5 1 1 1     7 Width 3ft   6006507.139280001 2120407.78108 37.802602889666794 -122.421673924708 (37.8026028896668, -122.421673924708)
75267 117692 2 4 435 42nd Ave 1 1 1 1     5 Width 2ft   5982808.33309 2112832.48805 37.780438537012294 -122.50312116344101 (37.7804385370123, -122.503121163441)
73133 177037 2 4 125 Goettingen St 1 9 1 1     17 Width 2ft   6009971.552 2093934.84647 37.7301090233129 -122.407817447612 (37.7301090233129, -122.407817447612)
73064 123375 2 4 757 03rd Ave 2 9 1 1     5     5995016.33653 2110447.72713 37.7746006270727 -122.460715372994 (37.7746006270727, -122.460715372994)
72309 226644 2 4 48 Cumberland St 3 4 1 1     2 Width 2ft   6005321.7767900005 2104616.40188 37.7591767333496 -122.42465187767701 (37.7591767333496, -122.424651877677)
70389 129503 2 4 2656 Filbert St 2 1 1 1     8 Width 3ft   6000257.59997 2118546.4747099997 37.797137849879896 -122.44316664242099 (37.7971378498799, -122.443166642421)
69137 129536 2 4 1440 Montgomery St 1 9 1 1     2 Width 4ft   6011432.08366 2120273.70789 37.8025112388511 -122.40462160961599 (37.8025112388511, -122.404621609616)
68161 40706 1 4 758 Sweeny St 1 1 1 1 1 08/10/1999 12:00:00 AM 6   Permit Number 41685 6006892.85232 2094109.9471200001 37.7304169754587 -122.41847333918999 (37.7304169754587, -122.41847333919)
67745 226648 2 4 1488 Dolores St 2 1 1 1     12 Width 6ft   6005200.770269999 2099715.54685 37.7457132878504 -122.42472173433701 (37.7457132878504, -122.424721734337)
66967 129530 2 4 1040 Greenwich St 2 1 1 1     5 Width 5ft   6007879.71026 2119961.12323 37.8014537818135 -122.416892463243 (37.8014537818135, -122.416892463243)
66325 249500 2 4 1765 California St 5 10 1 1     1 Width 3ft   6005972.54693 2115883.04317 37.7901489421804 -122.42320206534401 (37.7901489421804, -122.423202065344)
65210 226642 2 4 14 Cumberland St 1 10 1 1     2 Width 2ft   6005484.04077 2104618.2918599998 37.759191085608 -122.42409082483101 (37.759191085608, -122.424090824831)
64936 129534 2 4 580 North Point St 12 9 1 1     7 Width 3ft   6007527.54685 2121657.26711 37.8060911485403 -122.41823143323099 (37.8060911485403, -122.418231433231)
64620 207367 2 4 2 Lurline St 1 1 1 1     9 Width 3ft   5992094.1475599995 2104940.13578 37.7593096900047 -122.47042251889401 (37.7593096900047, -122.470422518894)
64468 191428 2 4 22 Robblee Ave 2 9 1 1     2 Width 5ft   6012599.814780001 2095974.63355 37.735856643564404 -122.39887425376001 (37.7358566435644, -122.39887425376)
63854 129545 2 4 10 Miller Pl 1 1 1 1     6 Width 2ft   6010092.54789 2116944.91924 37.7932962437837 -122.409022077819 (37.7932962437837, -122.409022077819)
60497 75390 2 4 240 07th St 1 1 1 1 1 09/10/1994 12:00:00 AM 5     6010035.62368 2111155.67227 37.77739716259529 -122.40881041516501 (37.7773971625953, -122.408810415165)
59980 129511 2 4 3223 Webster St 2 1 1 1     7 Width 3ft   6002767.09508 2119707.46883 37.8004684081385 -122.43456623596799 (37.8004684081385, -122.434566235968)
59600 129529 2 4 2677 Larkin St 4 1 1 1     10 Width 2ft   6006561.352969999 2120334.1919299997 37.802403889494 -122.421481088503 (37.802403889494, -122.421481088503)
58879 129507 2 4 1714 Filbert St 1 1 1 1     11 Width 3ft   6004691.67913 2119164.8681 37.7990876313419 -122.42786771393 (37.7990876313419, -122.42786771393)
58518 42618 1 4 1615 Greenwich St 1 1 1 1 1 06/26/2000 12:00:00 AM 11   Permit Number 42680 6005139.94855 2119525.3007400003 37.800102635872506 -122.426342225416 (37.8001026358725, -122.426342225416)
57229 191425 2 4 798 Wisconsin St 2 4 1 1     9 Width 3ft   6012697.8338 2103815.11788 37.757390399158794 -122.399085525191 (37.7573903991588, -122.399085525191)
56461 120189 2 4 224 26th Ave 1 1 1 1     7 Width 3ft   5987764.6245099995 2114428.11322 37.785109748738996 -122.486092406972 (37.785109748739, -122.486092406972)
55659 129546 2 4 13 Miller Pl 1 1 1 1     3 Width 1ft   6010072.19276 2116933.78445 37.7932645300763 -122.40909172222099 (37.7932645300763, -122.409091722221)
54940 55616 1 4 407 Laurel St 1 1 1 1   01/16/1973 12:00:00 AM 7   Permit Number 11594 5998117.038919999 2115073.6250299998 37.787480044827596 -122.450323009314 (37.7874800448276, -122.450323009314)
Powered by Datasette · Query took 2.173ms · Data source: data.sfgov.org