sf-trees

Data source: data.sfgov.org

Custom SQL query returning 71 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
170716 218286 2 4 1 Woodacre Dr 10 2 1 1     4     5991335.90639 2095594.8050900002 37.7336059570417 -122.472363586812 (37.7336059570417, -122.472363586812)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
44640 58940 1 4 1360 Rhode Island St 1 1 1 1 1 04/30/2005 12:00:00 AM 2   Permit Number 18218 6011963.90217 2102042.40825 37.7524820001659 -122.40149918233801 (37.7524820001659, -122.401499182338)
36005 59609 1 4 1063 Tennessee St 1 1 1 1   02/26/1981 12:00:00 AM 5   Permit Number 19011 6015560.85054 2104166.3389 37.7585139078159 -122.389208516653 (37.7585139078159, -122.389208516653)
8152 102822 1 4 347 Presidio Ave 2 1 1 1     5 3x3 Permit Number 20638 5999052.21165 2115387.8752099997 37.7883963685539 -122.44711013813401 (37.7883963685539, -122.447110138134)
8977 60858 1 4 347 Presidio Ave 1 1 1 1   04/19/1983 12:00:00 AM 5 3x3 Permit Number 20638 5999049.79752 2115408.40483 37.7884525995602 -122.44711996863701 (37.7884525995602, -122.447119968637)
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)
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)
38963 40933 1 4 516 27th Ave 1 1 1 1   09/27/1999 12:00:00 AM 3   Permit Number 41796 5987525.4413 2112407.46828 37.7795476900895 -122.486771463248 (37.7795476900895, -122.486771463248)
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)
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)
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)
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)
48397 35353 1 4 1023 Kansas St 1 1 1 1 1 06/25/2013 12:00:00 AM 1   Permit Number 770231 6011656.23225 2103580.2473299997 37.7566873964196 -122.40267130024999 (37.7566873964196, -122.40267130025)
43164 53852 1 4 566 Bush St 1 1 1 1   03/01/1972 12:00:00 AM 7   Permit Number 9560 6010756.69045 2115915.59968 37.7905071610361 -122.406651517078 (37.7905071610361, -122.406651517078)
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)
Powered by Datasette · Query took 2.759ms · Data source: data.sfgov.org