sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
109026 94201 1 40 1227 Pierce St 2 26 1 1   06/22/2010 12:00:00 AM     Permit Number 53604 6002086.0 2112766.6 37.7813718842821 -122.436426049876 (37.7813718842821, -122.436426049876)
178126 224454 2 40 4090 20th St 6 23 1 1     12 Width 3ft   6003124.6046 2104168.08557 37.7578214298263 -122.432218730236 (37.7578214298263, -122.432218730236)
15790 87061 1 40     19 1 1       3x3 Permit Number 50003          
105735 105666 2 40 317X DORADO TER 3 19 1 1     22     5994307.4 2093021.4 37.7267115488018 -122.461903806308 (37.7267115488018, -122.461903806308)
145561 105665 2 40 317X DORADO TER 2 19 1 1     24     5994307.4 2093021.4 37.7267115488018 -122.461903806308 (37.7267115488018, -122.461903806308)
88629 117549 3 40 24X KEMPTON AVE 3 17 1 2       30x30   5992274.0 2087683.0 37.7119363308651 -122.46854490041599 (37.7119363308651, -122.468544900416)
112585 117548 3 40 24X KEMPTON AVE 2 17 1 2       30x30   5992274.0 2087683.0 37.7119363308651 -122.46854490041599 (37.7119363308651, -122.468544900416)
121639 117546 3 40 24X KEMPTON AVE 1 17 1 2       30x30   5992274.0 2087683.0 37.7119363308651 -122.46854490041599 (37.7119363308651, -122.468544900416)
126638 117550 3 40 24X KEMPTON AVE 4 17 1 2       30x30   5992274.0 2087683.0 37.7119363308651 -122.46854490041599 (37.7119363308651, -122.468544900416)
146070 121081 3 40 24X KEMPTON AVE 5 17 1 2       30x30   5992274.0 2087683.0 37.7119363308651 -122.46854490041599 (37.7119363308651, -122.468544900416)
104967 108502 2 40 2300 33RD AVE 1 13 1 1     32     5986128.8 2099536.7 37.7441266056665 -122.49065574130199 (37.7441266056665, -122.490655741302)
23642 176313 3 40 500x Mansell St 18 11 1 2     38 Width 0ft   6010259.13784 2090270.57035 37.7200637812891 -122.40656510840799 (37.7200637812891, -122.406565108408)
24910 113499 3 40 200x Mansell St 5 11 1 2     19 3x3   6011193.56936 2090563.5306400002 37.7209204242214 -122.403355677147 (37.7209204242214, -122.403355677147)
28478 176327 3 40 700x Mansell St 31 11 1 2     46 Width 0ft   6009212.31958 2089948.46975 37.7191207387124 -122.41016088932699 (37.7191207387124, -122.410160889327)
30294 176308 3 40 300x Mansell St 12 11 1 2     23 Width 0ft   6010842.734619999 2090461.59096 37.7206209176161 -122.404561241708 (37.7206209176161, -122.404561241708)
36490 176307 3 40 300x Mansell St 7 11 1 2     14 Width 0ft   6010889.97096 2090468.7148799999 37.7206431182563 -122.404398460825 (37.7206431182563, -122.404398460825)
36977 186970 3 40 1650x Sloat Blvd 1 11 1 2     10 Width 0ft   5986025.4295 2095869.2083 37.734050611594604 -122.49074337328301 (37.7340506115946, -122.490743373283)
37371 176317 3 40 600x Mansell St 5 11 1 2     20 Width 0ft   6009952.88344 2090194.2340000002 37.7198370388417 -122.40761835123199 (37.7198370388417, -122.407618351232)
40506 176323 3 40 700x Mansell St 23 11 1 2     31 Width 0ft   6009342.20287 2090002.90208 37.719277477945 -122.40971577078399 (37.719277477945, -122.409715770784)
42868 176330 3 40 700x Mansell St 35 11 1 2     7 Width 0ft   6009184.10476 2089961.98667 37.7191562718235 -122.41025937136801 (37.7191562718235, -122.410259371368)
44683 176302 3 40 100x Mansell St 2 11 1 2     18 Width 0ft   6011513.54745 2090660.92357 37.721205711656204 -122.40225644658301 (37.7212057116562, -122.402256446583)
46745 176303 3 40 200x Mansell St 16 11 1 2     23 Width 0ft   6011115.33526 2090539.9745900002 37.7208513742667 -122.40362445389799 (37.7208513742667, -122.403624453898)
53330 186974 3 40 1600x Sloat Blvd 1 11 1 2     9 Width 0ft   5986249.0864 2095869.2083 37.7340636742344 -122.489970132524 (37.7340636742344, -122.489970132524)
58856 185127 3 40 700x Sloat Blvd 2 11 1 2     10 Width 0ft   5989015.4133 2095969.6432 37.734500589899504 -122.480413539116 (37.7345005898995, -122.480413539116)
62350 176309 3 40 300x Mansell St 21 11 1 2     24 Width 0ft   6010760.4946 2090426.07331 37.720518796898 -122.404843021812 (37.720518796898, -122.404843021812)
62801 176326 3 40 700x Mansell St 26 11 1 2     11 Width 0ft   6009300.414580001 2090007.1642099998 37.719286839006706 -122.40986051846701 (37.7192868390067, -122.409860518467)
64522 176312 3 40 500x Mansell St 15 11 1 2     13 Width 0ft   6010340.9019 2090322.69069 37.720211467072296 -122.406286146812 (37.7202114670723, -122.406286146812)
64735 176318 3 40 600x Mansell St 6 11 1 2     24 Width 0ft   6009900.75619 2090162.07565 37.71974582058 -122.40779627129 (37.71974582058, -122.40779627129)
66989 176322 3 40 700x Mansell St 11 11 1 2     11 Width 0ft   6009482.932019999 2090051.6391099999 37.7194191850237 -122.40923275838699 (37.7194191850237, -122.409232758387)
70430 176306 3 40 300x Mansell St 5 11 1 2     17 Width 0ft   6010916.0273400005 2090472.38873 37.7206546619672 -122.40430865004299 (37.7206546619672, -122.404308650043)
72173 176321 3 40 700x Mansell St 10 11 1 2     20 Width 0ft   6009491.13352 2090035.22052 37.7193745624679 -122.409203250746 (37.7193745624679, -122.409203250746)
73572 176297 3 40 10x Mansell St 5 11 1 2     22 Width 0ft   6011769.33402 2090739.1089 37.7214346673524 -122.401377752274 (37.7214346673524, -122.401377752274)
73620 176316 3 40 600x Mansell St 4 11 1 2     20 Width 0ft   6009975.17316 2090196.6271099998 37.7198448575227 -122.40754147176001 (37.7198448575227, -122.40754147176)
75997 176325 3 40 700x Mansell St 25 11 1 2     7 Width 0ft   6009306.38792 2090008.2878700001 37.7192902591068 -122.40983995006701 (37.7192902591068, -122.409839950067)
77295 113498 3 40 200x Mansell St 4 11 1 2     23 3x3   6011210.15679 2090562.2005 37.7209176983622 -122.403298245537 (37.7209176983622, -122.403298245537)
77566 106463 3 40 3500X MISSION ST 3 11 1 2     28     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716)
79746 23414 3 40 1800X VAN NESS AVE 2 11 1 2     30 9   6006192.0 2116736.0 37.7925033310543 -122.422503407712 (37.7925033310543, -122.422503407712)
81628 6104 3 40 500X 08th St 6 11 1 2     12 18   6010526.812454099 2109340.6023904 37.772440902057795 -122.406983260044 (37.7724409020578, -122.406983260044)
84076 6103 3 40 500X 08th St 5 11 1 2     3 18   6010526.812454099 2109340.6023904 37.772440902057795 -122.406983260044 (37.7724409020578, -122.406983260044)
84752 106462 3 40 3500X MISSION ST 2 11 1 2     36     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716)
88594 112580 2 40 274X SAN MARCOS AVE 1 11 1 1       3x20   5993121.0 2100271.0 37.7465487656332 -122.46653182115801 (37.7465487656332, -122.466531821158)
93222 6106 3 40 500X 08th St 8 11 1 2     18 18   6010526.812454099 2109340.6023904 37.772440902057795 -122.406983260044 (37.7724409020578, -122.406983260044)
94353 6101 3 40 500X 08th St 3 11 1 2     3 18   6010526.812454099 2109340.6023904 37.772440902057795 -122.406983260044 (37.7724409020578, -122.406983260044)
106367 1854 3 40 2500 Bay Shore Blvd 1 11 1 2     12 6   6010837.5147418 2086759.4488696998 37.7104552954566 -122.404318844881 (37.7104552954566, -122.404318844881)
111282 6100 3 40 500X 08th St 2 11 1 2     24 18   6010526.812454099 2109340.6023904 37.772440902057795 -122.406983260044 (37.7724409020578, -122.406983260044)
114256 106577 3 40 1001X SAN JOSE AVE 1 11 1 2     10     6004855.0 2096548.0 37.7369963898236 -122.42569194885799 (37.7369963898236, -122.425691948858)
114463 111293 3 40 3500X MISSION ST 1 11 1 2     30     6005565.0 2097823.0 37.7405373480538 -122.42332776776699 (37.7405373480538, -122.423327767767)
115347 106464 3 40 3500X MISSION ST 5 11 1 2     28     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716)
122644 110235 2 40 2346x CASTRO ST 1 11 1 1       3x3   6002664.5 2098664.4 37.742683511585206 -122.43341667357402 (37.7426835115852, -122.433416673574)
128785 106466 3 40 3500X MISSION ST 6 11 1 2     26     6005565.6 2097823.9 37.7405398531137 -122.42332575716001 (37.7405398531137, -122.42332575716)
130335 176324 3 40 700x Mansell St 24 11 1 2     43 Width 0ft   6009336.81226 2089985.3560799998 37.719228998190204 -122.409733166348 (37.7192289981902, -122.409733166348)
131007 176299 3 40 10x Mansell St 7 11 1 2     24 Width 0ft   6011728.48955 2090724.05613 37.7213910565415 -122.40151788376998 (37.7213910565415, -122.40151788377)
132300 185059 3 40 700x Sloat Blvd 3 11 1 2     13 Width 0ft   5988840.8776 2095965.7184 37.7344796690595 -122.481016672562 (37.7344796690595, -122.481016672562)
138313 1855 3 40 2500 Bay Shore Blvd 2 11 1 2     3 6   6010837.5147418 2086759.4488696998 37.7104552954566 -122.404318844881 (37.7104552954566, -122.404318844881)
142725 112581 2 40 274X SAN MARCOS AVE 2 11 1 1       3x20   5993121.0 2100271.0 37.7465487656332 -122.46653182115801 (37.7465487656332, -122.466531821158)
152100 176311 3 40 500x Mansell St 16 11 1 2     15 Width 0ft   6010356.570719999 2090296.4274 37.7201402299675 -122.40623013522499 (37.7201402299675, -122.406230135225)
152213 176314 3 40 500x Mansell St 19 11 1 2     35 Width 0ft   6010185.666130001 2090251.18564 37.720006444117296 -122.406817710885 (37.7200064441173, -122.406817710885)
153553 176310 3 40 500x Mansell St 8 11 1 2     29 Width 0ft   6010469.51848 2090335.25755 37.720253166839704 -122.40584244467199 (37.7202531668397, -122.405842444672)
156596 176329 3 40 700x Mansell St 33 11 1 2     11 Width 0ft   6009197.90265 2089964.9760099999 37.719165253359 -122.41021188808399 (37.719165253359, -122.410211888084)
158228 176328 3 40 700x Mansell St 32 11 1 2     11 Width 0ft   6009200.77281 2089956.05158 37.7191409096134 -122.41020133724899 (37.7191409096134, -122.410201337249)
158945 176305 3 40 300x Mansell St 3 11 1 2     28 Width 0ft   6010925.6651800005 2090483.18833 37.7206848540134 -122.404276094583 (37.7206848540134, -122.404276094583)
161257 176304 3 40 200x Mansell St 17 11 1 2     12 Width 0ft   6011109.46654 2090529.17456 37.7208213917675 -122.403643980895 (37.7208213917675, -122.403643980895)
161444 176333 3 40 12x Canyon Dr 12 11 1 2     12 Width 0ft   6002752.1139 2086168.71447 37.708378134509296 -122.43222153339899 (37.7083781345093, -122.432221533399)
162770 176300 3 40 10x Mansell St 8 11 1 2     22 Width 0ft   6011702.065830001 2090731.87272 37.7214110448664 -122.401609772869 (37.7214110448664, -122.401609772869)
166075 113501 3 40 200x Mansell St 7 11 1 2     17 3x3   6011166.56458 2090559.11661 37.720906795881795 -122.403448714702 (37.7209067958818, -122.403448714702)
166853 176331 3 40 700x Mansell St 36 11 1 2     27 Width 0ft   6009160.31915 2089943.1989099998 37.7191033512163 -122.410340263619 (37.7191033512163, -122.410340263619)
174476 176315 3 40 600x Mansell St 2 11 1 2     36 Width 0ft   6010056.94301 2090202.23729 37.7198648386596 -122.40725921596399 (37.7198648386596, -122.407259215964)
177490 176319 3 40 700x Mansell St 2 11 1 2     18 Width 0ft   6009753.29629 2090123.38013 37.7196313144016 -122.40830326229602 (37.7196313144016, -122.408303262296)
178932 176320 3 40 700x Mansell St 5 11 1 2     15 Width 0ft   6009693.65645 2090109.67926 37.7195903547889 -122.408508450717 (37.7195903547889, -122.408508450717)
183209 176298 3 40 10x Mansell St 6 11 1 2     23 Width 0ft   6011748.91192 2090731.5823400002 37.7214128614948 -122.40144781756399 (37.7214128614948, -122.401447817564)
184493 176301 3 40 10x Mansell St 13 11 1 2     22 Width 0ft   6011617.09806 2090687.60598 37.7212847557703 -122.40190037442899 (37.7212847557703, -122.401900374429)
185034 176332 3 40 700x Mansell St 40 11 1 2     10 Width 0ft   6009122.37089 2089940.9339 37.7190950046208 -122.410471276831 (37.7190950046208, -122.410471276831)
1680 251668 2 40 301x Laguna Honda Blvd 1 9 1 1       3x3   5995349.0 2100852.0 37.7482723626065 -122.458869747183 (37.7482723626065, -122.458869747183)
28658 187032 2 40 2501 Sunset Blvd 51 9 1 1     11 Width 0ft   5984967.607000001 2097835.0603 37.73938646460329 -122.494545412715 (37.7393864646033, -122.494545412715)
41295 187029 2 40 2501 Sunset Blvd 48 9 1 1     38 Width 0ft   5984947.4301 2097843.1311 37.7394074439231 -122.49461576933999 (37.7394074439231, -122.49461576934)
43878 187030 2 40 2501 Sunset Blvd 49 9 1 1     16 Width 0ft   5984957.5185 2097843.1311 37.7394080343891 -122.49458088860901 (37.7394080343891, -122.494580888609)
58693 218793 2 40 616 Joost Ave 2 9 1 1     23 Width 10ft   5998053.08406 2095010.8668400003 37.7323890825862 -122.449098408785 (37.7323890825862, -122.449098408785)
72098 187038 2 40 2501 Sunset Blvd 57 9 1 1     3 Width 0ft   5984961.8902 2097789.6624 37.7392614795793 -122.494561832752 (37.7392614795793, -122.494561832752)
78735 94388 1 40 1001 Potrero Ave 12 9 1 1         Permit Number 53641 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
80719 116576 6 40 2500x OCEAN AVE 1 9 1 6 4   30 10X10   5991377.0 2094742.0 37.7312667472315 -122.472159374256 (37.7312667472315, -122.472159374256)
83515 94380 1 40 1001 Potrero Ave 4 9 1 1         Permit Number 53641 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
84196 94383 1 40 1001 Potrero Ave 7 9 1 1         Permit Number 53641 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
87589 94384 1 40 1001 Potrero Ave 8 9 1 1         Permit Number 53641 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
87626 94379 1 40 1001 Potrero Ave 3 9 1 1         Permit Number 53641 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
95304 94385 1 40 1001 Potrero Ave 9 9 1 1         Permit Number 53641 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
100408 94381 1 40 1001 Potrero Ave 5 9 1 1         Permit Number 53641 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
110217 94377 1 40 1001 Potrero Ave 1 9 1 1         Permit Number 53641 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
116794 94386 1 40 1001 Potrero Ave 10 9 1 1         Permit Number 53641 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
120294 113893 2 40 5x STORRIE ST 5 9 1 2     60     6000722.0 2105303.0 37.76080110933629 -122.440609317727 (37.7608011093363, -122.440609317727)
125326 94378 1 40 1001 Potrero Ave 2 9 1 1         Permit Number 53641 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
127453 94387 1 40 1001 Potrero Ave 11 9 1 1         Permit Number 53641 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
131781 187031 2 40 2501 Sunset Blvd 50 9 1 1     19 Width 0ft   5984966.2618 2097842.7948 37.7394076227298 -122.494550633787 (37.7394076227298, -122.494550633787)
143608 94382 1 40 1001 Potrero Ave 6 9 1 1         Permit Number 53641 6010509.9 2103658.3 37.7568376430251 -122.406641253674 (37.7568376430251, -122.406641253674)
144910 113889 2 40 1x STORRIE ST 2 9 1 2     90     6000722.0 2105303.0 37.76080110933629 -122.440609317727 (37.7608011093363, -122.440609317727)
182619 187037 2 40 2501 Sunset Blvd 56 9 1 1     29 Width 0ft   5984959.5362 2097794.0341 37.7392733453171 -122.49457029390899 (37.7392733453171, -122.494570293909)
80436 87674 1 40 770 Golden Gate Ave 10 8 1 1   05/22/2008 12:00:00 AM   3x3 Permit Number 50396 6005860.1 2112469.5 37.7807698496384 -122.42334835915399 (37.7807698496384, -122.423348359154)
113089 87675 1 40 770 Golden Gate Ave 11 8 1 1   05/22/2008 12:00:00 AM   3x3 Permit Number 50396 6005860.1 2112469.5 37.7807698496384 -122.42334835915399 (37.7807698496384, -122.423348359154)
25099 224199 2 40 1001 San Jose Ave 35 7 1 1     16     6005272.32245 2097108.7115200001 37.738559550591795 -122.42428894459299 (37.7385595505918, -122.424288944593)
31769 224212 2 40 1000 San Jose Ave 2 7 1 1     9     6005187.142969999 2097371.8747799997 37.739277327390795 -122.42460216947501 (37.7392773273908, -122.424602169475)
34116 224214 2 40 1000 San Jose Ave 5 7 1 1     25     6005180.62218 2097351.71746 37.73922161167361 -122.424623281961 (37.7392216116736, -122.424623281961)
39821 224196 2 40 1001 San Jose Ave 16 7 1 1     15     6005192.428069999 2096936.6445 37.73808258165379 -122.424552945066 (37.7380825816538, -122.424552945066)
Powered by Datasette · Query took 7.603ms · Data source: data.sfgov.org