sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
102548 101898 2 129 99X MacOndray Ln 1 9 1 1           6008233.5 2119097.7 37.7991029311983 -122.415607021356 (37.7991029311983, -122.415607021356)
105468 101899 2 129 99X MacOndray Ln 2 9 1 1           6008233.5 2119097.7 37.7991029311983 -122.415607021356 (37.7991029311983, -122.415607021356)
96595 106311 6 71 99X Clearfield Dr 5 9 1 1   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.4648400003 37.73289581695511 -122.49149816384899 (37.7328958169551, -122.491498163849)
142007 106310 6 71 99X Clearfield Dr 4 9 1 1   04/15/2014 12:00:00 AM     Permit Number 772542 5985798.26078 2095453.4648400003 37.73289581695511 -122.49149816384899 (37.7328958169551, -122.491498163849)
188844 132293 2 108 999 North Point St 1 9 1 1     13 Width 4ft   6005925.58045 2121359.44598 37.805183106669 -122.42375411867799 (37.805183106669, -122.423754118678)
33408 206428 2 298 999 Chenery St 1 9 1 1     4 Width 5ft   6000994.535540001 2096137.9809700001 37.7356516718869 -122.43900989591499 (37.7356516718869, -122.439009895915)
181423 228419 2 322 998 York St 8 9 1 1     4 Width 3ft   6009935.93265 2103433.9763599997 37.7561895713205 -122.408610430245 (37.7561895713205, -122.408610430245)
188722 224463 2 253 998 York St 5 9 1 1     2 Width 3ft   6009934.61987 2103458.53933 37.7562569422093 -122.408616703004 (37.7562569422093, -122.408616703004)
63265 190633 2 145 998 Kansas St 2 9 1 1     17 Width 10ft   6011587.55607 2103749.45298 37.75714816318521 -122.402920709219 (37.7571481631852, -122.402920709219)
134660 194485 2 3 998 Kansas St 1 9 1 1     40 Width 10ft   6011603.18064 2103745.73679 37.7571388318007 -122.40286641177299 (37.7571388318007, -122.402866411773)
175051 129722 2 62 998 Chestnut St 1 9 1 1     13 Width 3ft   6007108.76695 2120556.6740099997 37.8030456187175 -122.419602556719 (37.8030456187175, -122.419602556719)
4549 226945 6 19 998 Chenery St 4 9 1 1     21 Width 1ft   6001140.61217 2096125.6115299999 37.735626018710896 -122.438503967885 (37.7356260187109, -122.438503967885)
65449 226944 2 19 998 Chenery St 3 9 1 1     21 Width 1ft   6001147.55227 2096122.75745 37.735618576845205 -122.43847976892401 (37.7356185768452, -122.438479768924)
53262 238586 2 237 991 San Bruno Ave 1 9 1 1     2 Width 6ft   6011096.081069999 2103736.7001400003 37.7570856908704 -122.40461953036501 (37.7570856908704, -122.404619530365)
4028 216741 2 77 990 Plymouth Ave 1 9 1 1   10/05/2017 07:49:00 AM 3 Width 4ft   5995950.8772 2090428.1380900003 37.719685546243895 -122.456034989421 (37.7196855462439, -122.456034989421)
4068 216743 2 77 990 Plymouth Ave 3 9 1 1   10/05/2017 07:52:00 AM 3 Width 4ft   5995950.66479 2090454.56836 37.7197581053329 -122.45603763343901 (37.7197581053329, -122.456037633439)
70460 129566 2 55 99 Toledo Way 1 9 1 1     4 Width 4ft   6001391.4418 2119925.56535 37.800989055367 -122.439342181017 (37.800989055367, -122.439342181017)
1945 252839 7 114 99 Pond St 2 9 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
1956 252838 6 114 99 Pond St 1 9 1 1           6003330.0 2106021.0 37.7629207320267 -122.43164067381399 (37.7629207320267, -122.431640673814)
35648 132345 2 108 99 North Point St 7 9 1 1     21 Width 4ft   6010293.68664 2121970.09812 37.807105416557995 -122.408680791404 (37.807105416558, -122.408680791404)
44231 132352 2 108 99 North Point St 14 9 1 1     13 Width 4ft   6010400.48539 2121983.74228 37.8071488610029 -122.408312153001 (37.8071488610029, -122.408312153001)
48856 132353 2 108 99 North Point St 16 9 1 1     12 Width 4ft   6010444.3802 2121991.1202599998 37.8071715769765 -122.408160765609 (37.8071715769765, -122.408160765609)
53010 132343 2 108 99 North Point St 5 9 1 1     5 Width 4ft   6010257.55272 2121964.32975 37.8070875542059 -122.40880543381901 (37.8070875542059, -122.408805433819)
57489 132349 2 108 99 North Point St 11 9 1 1     7 Width 4ft   6010357.97788 2121979.4044 37.8071345698829 -122.408458953812 (37.8071345698829, -122.408458953812)
60541 132340 2 108 99 North Point St 2 9 1 1     5 Width 4ft   6010250.3347 2121963.67978 37.807085365256206 -122.408830367525 (37.8070853652562, -122.408830367525)
61903 132347 2 108 99 North Point St 9 9 1 1     12 Width 4ft   6010337.00106 2121976.0282799997 37.8071241251481 -122.40853131058998 (37.8071241251481, -122.40853131059)
61929 132346 2 108 99 North Point St 8 9 1 1     19 Width 4ft   6010313.38408 2121972.38767 37.8071128062815 -122.408612785551 (37.8071128062815, -122.408612785551)
62390 133156 2 26 99 North Point St 17 9 1 1     4 Width 4ft   6010460.75882 2121992.28603 37.8071756949569 -122.408104165883 (37.8071756949569, -122.408104165883)
68687 132348 2 108 99 North Point St 10 9 1 1     6 Width 4ft   6010354.50875 2121976.8725799997 37.8071274238595 -122.40847078082399 (37.8071274238595, -122.408470780824)
77253 132344 2 108 99 North Point St 6 9 1 1     8 Width 4ft   6010271.51992 2121966.31562 37.807093789222705 -122.408757237352 (37.8070937892227, -122.408757237352)
135225 132341 2 108 99 North Point St 3 9 1 1     10 Width 4ft   6010253.820780001 2121967.79388 37.807096856811704 -122.408818593599 (37.8070968568117, -122.408818593599)
149725 136320 2 45 99 North Point St 21 9 1 1     6 Width 4ft   6010568.43745 2122006.8054400003 37.8072215900736 -122.40773254351801 (37.8072215900736, -122.407732543518)
150939 133155 2 26 99 North Point St 15 9 1 1     5 Width 4ft   6010424.25918 2121988.2428099997 37.8071625495686 -122.408230195965 (37.8071625495686, -122.408230195965)
161485 132350 2 108 99 North Point St 12 9 1 1     23 Width 4ft   6010382.56388 2121982.30602 37.8071439138247 -122.40837407312901 (37.8071439138247, -122.408374073129)
165341 136319 2 45 99 North Point St 20 9 1 1     4 Width 4ft   6010537.589980001 2122003.14861 37.8072098224406 -122.40783904035901 (37.8072098224406, -122.407839040359)
166935 132351 2 108 99 North Point St 13 9 1 1     9 Width 4ft   6010391.05696 2121984.73538 37.807151059840606 -122.40834485234 (37.8071510598406, -122.40834485234)
174669 132342 2 108 99 North Point St 4 9 1 1     9 Width 4ft   6010256.82175 2121967.7326599997 37.807096856806105 -122.408808203739 (37.8070968568061, -122.408808203739)
183440 126366 2 234 99 MacOndray Ln 1 9 1 1     56     6008010.57204 2119080.4393700003 37.799043004282204 -122.41637720656401 (37.7990430042822, -122.416377206564)
82365 122756 2 3 99 Fernwood Dr 1 9 1 1     40 3x3   5994769.0 2095318.0 37.7330440171503 -122.46047442029699 (37.7330440171503, -122.460474420297)
23847 226860 2 19 99 Elk St 4 9 1 1     9 Width 2ft   6000812.22961 2096323.57705 37.7361509008315 -122.43965349751801 (37.7361509008315, -122.439653497518)
50650 226858 2 19 99 Elk St 2 9 1 1     13 Width 2ft   6000811.86786 2096313.4540400002 37.736123084819496 -122.43965402273001 (37.7361230848195, -122.43965402273)
70212 226857 2 19 99 Elk St 1 9 1 1     14 Width 2ft   6000811.73315 2096306.95535 37.7361052332666 -122.439654022723 (37.7361052332666, -122.439654022723)
158588 226859 2 19 99 Elk St 3 9 1 1     12 Width 2ft   6000812.12935 2096318.74052 37.7361376151427 -122.439653497529 (37.7361376151427, -122.439653497529)
168169 226862 2 19 99 Elk St 6 9 1 1     6 Width 2ft   6000812.75868 2096333.6910299999 37.7361787015724 -122.439652393167 (37.7361787015724, -122.439652393167)
169062 226863 2 19 99 Elk St 7 9 1 1     13 Width 2ft   6000813.02064 2096338.5481200002 37.7361920529176 -122.43965183556699 (37.7361920529176, -122.439651835567)
182231 226861 2 19 99 Elk St 5 9 1 1     10 Width 2ft   6000812.78199 2096328.25256 37.7361637701303 -122.439651922807 (37.7361637701303, -122.439651922807)
54439 120440 2 129 99 22nd Ave 3 9 1 1     26     5988935.73102 2114756.99709 37.7860809522857 -122.48206489481599 (37.7860809522857, -122.482064894816)
79584 116089 6 5 98x WOODWARD ST 3 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
103243 116088 6 5 98x WOODWARD ST 2 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
107871 116087 6 5 98x WOODWARD ST 1 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
125535 116090 6 5 98x WOODWARD ST 4 9 1 1       3x3   6006422.0 2107919.0 37.7683069672649 -122.421081271108 (37.7683069672649, -122.421081271108)
3544 253465 2 38 98X Marston Ave 4 9 1 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
3561 253462 2 38 98X Marston Ave 1 9 1 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
3567 253463 2 38 98X Marston Ave 2 9 1 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
3577 253466 2 141 98X Marston Ave 5 9 1 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
3585 253464 2 38 98X Marston Ave 3 9 1 1   09/12/2017 12:00:00 AM 3 3x3   5998793.0 2093251.0 37.7275991927727 -122.446413796362 (37.7275991927727, -122.446413796362)
32538 221670 2 175 985 San Bruno Ave 1 9 1 1     12 Width 6ft   6011091.323 2103767.31713 37.7571694924002 -122.40463814095699 (37.7571694924002, -122.404638140957)
75189 176701 2 19 985 Avalon Ave 2 9 1 1     8 Width 6ft   6005395.13627 2092229.7099400002 37.7251698288036 -122.42351753851601 (37.7251698288036, -122.423517538516)
183316 179867 2 241 985 Avalon Ave 1 9 1 1     6 Width 6ft   6005404.976009999 2092232.7341599998 37.7251786880381 -122.423483738408 (37.7251786880381, -122.423483738408)
70006 175852 2 268 981 Delano Ave 1 9 1 1     3 Width 9ft   5998486.05845 2089261.9262299999 37.7166285851125 -122.447187923197 (37.7166285851125, -122.447187923197)
170444 175916 2 141 98 Teddy Ave 1 9 1 1     28     6010863.76059 2087996.01367 37.7138521198643 -122.404315111648 (37.7138521198643, -122.404315111648)
53451 132632 2 26 98 Spruce St 3 9 1 1     13 Width 3ft   5997056.52317 2116093.53652 37.7902196990203 -122.45406584826999 (37.7902196990203, -122.45406584827)
148068 223958 2 39 98 Seward St 2 9 1 1     13 Width 3ft   6000714.90104 2104629.8807900003 37.7589524846915 -122.440585589054 (37.7589524846915, -122.440585589054)
154740 223957 2 39 98 Seward St 1 9 1 1     14 Width 3ft   6000715.72405 2104622.0065599997 37.7589309108477 -122.440582177927 (37.7589309108477, -122.440582177927)
31524 175845 2 99 98 Newton St 2 9 1 1     23 Width 10ft   6000912.9484 2087984.8955700002 37.7132605143345 -122.43870794134399 (37.7132605143345, -122.438707941344)
26776 213745 2 252 98 Lurline St 1 9 1 1     8 Width 3ft   5991840.41055 2105148.54995 37.7598672660797 -122.471315241723 (37.7598672660797, -122.471315241723)
187368 219226 2 163 98 Lurline St 2 9 1 1     12 Width 3ft   5991838.5673400005 2105160.13567 37.759898970787 -122.47132246058399 (37.759898970787, -122.471322460584)
23443 248249 2 2 98 Lundy's Ln 1 9 1 1     15 Width 8ft   6006859.99776 2099020.88579 37.743899476678706 -122.418935096973 (37.7438994766787, -122.418935096973)
27398 205475 2 141 98 Judson Ave 7 9 1 1     23     5999461.68909 2093522.86386 37.7283838376284 -122.444121665807 (37.7283838376284, -122.444121665807)
32592 205476 2 141 98 Judson Ave 8 9 1 1     3     5999461.7393 2093534.4829400002 37.7284157437829 -122.444122326784 (37.7284157437829, -122.444122326784)
41451 205472 2 141 98 Judson Ave 3 9 1 1     28     5999475.13727 2093536.5919400002 37.7284222989294 -122.444076160988 (37.7284222989294, -122.444076160988)
43713 205474 2 141 98 Judson Ave 6 9 1 1     12     5999468.48436 2093527.67559 37.728397437176106 -122.444098519924 (37.7283974371761, -122.444098519924)
59313 205473 2 141 98 Judson Ave 4 9 1 1     7     5999475.64233 2093531.5269999998 37.728408420594704 -122.44407405119 (37.7284084205947, -122.44407405119)
130171 205471 2 141 98 Judson Ave 2 9 1 1     4     5999482.0353 2093535.39464 37.7284194049318 -122.44405222824899 (37.7284194049318, -122.444052228249)
157652 205477 2 141 98 Judson Ave 9 9 1 1     12     5999454.95195 2093530.0519599998 37.7284031901334 -122.444145472637 (37.7284031901334, -122.444145472637)
158480 207525 2 197 98 Judson Ave 5 9 1 1     4     5999467.57051 2093538.93345 37.728428296507104 -122.444102487738 (37.7284282965071, -122.444102487738)
171748 207363 2 27 98 Judson Ave 1 9 1 1     6     5999482.34141 2093540.9124 37.7284345728794 -122.444051566321 (37.7284345728794, -122.444051566321)
35353 234848 2 168 98 Hill St 5 9 1 1     1 Width 2ft   6005792.82845 2103474.22766 37.7560671816819 -122.42294157491999 (37.7560671816819, -122.42294157492)
40541 234849 2 168 98 Hill St 7 9 1 1     1 Width 2ft   6005763.2044 2103470.66995 37.756055741406996 -122.423043772075 (37.756055741407, -122.423043772075)
123303 234847 2 168 98 Hill St 3 9 1 1     1 Width 2ft   6005800.09169 2103473.84487 37.756066540467295 -122.422916428967 (37.7560665404673, -122.422916428967)
136495 234840 2 314 98 Hill St 8 9 1 1     2 Width 2ft   6005749.451780001 2103470.6109700003 37.756054803396296 -122.42309132910101 (37.7560548033963, -122.423091329101)
153225 234846 2 168 98 Hill St 2 9 1 1     1 Width 2ft   6005812.3026 2103474.52838 37.7560691062312 -122.422874248071 (37.7560691062312, -122.422874248071)
134667 220737 2 137 98 Crescent Ave 1 9 1 1     12 Width 2ft   6005788.78972 2095836.9730000002 37.7350967901794 -122.422412909327 (37.7350967901794, -122.422412909327)
176554 136638 2 241 98 Blake St 4 9 1 1     8 Width 3ft   5997852.8228 2113221.0345799997 37.7823781953411 -122.451103490434 (37.7823781953411, -122.451103490434)
47001 122962 2 34 98 09th Ave 7 9 1 1     7 Width 5ft   5993057.14542 2114935.59748 37.786810183441204 -122.46781902207898 (37.7868101834412, -122.467819022079)
43834 205429 2 141 979 Teresita Blvd 2 9 1 1     5 Width 2ft   5998328.88078 2095661.5706 37.7341915308101 -122.448191757267 (37.7341915308101, -122.448191757267)
72917 219419 2 19 979 Teresita Blvd 3 9 1 1     11 Width 2ft   5998332.28309 2095661.19123 37.734190683652 -122.44817996714599 (37.734190683652, -122.448179967146)
146396 206912 2 19 979 Teresita Blvd 4 9 1 1     13 Width 2ft   5998337.2254099995 2095660.3163400001 37.734188563950205 -122.448162817076 (37.7341885639502, -122.448162817076)
27786 243964 2 224 979 San Bruno Ave 1 9 1 1     4 Width 6ft   6011092.59342 2103787.62329 37.7572253196086 -122.40463517678002 (37.7572253196086, -122.40463517678)
44469 215242 2 198 978 Capitol Ave 5 9 1 1     9 Width 1ft   5995069.34707 2090438.49633 37.71966335006721 -122.459082852985 (37.7196633500672, -122.459082852985)
170108 215241 2 198 978 Capitol Ave 4 9 1 1     11 Width 4ft   5995069.40558 2090424.4905400001 37.719624896864204 -122.459081637134 (37.7196248968642, -122.459081637134)
182044 129244 2 19 977 Pacific Ave 1 9 1 1     3 Width 2ft   6009468.5777900005 2118046.06464 37.796284746692294 -122.41125888781201 (37.7962847466923, -122.411258887812)
62406 179179 2 231 976 Avalon Ave 2 9 1 1     7 Width 8ft   6005365.19598 2092163.67204 37.7249868131864 -122.423616346115 (37.7249868131864, -122.423616346115)
68443 179178 2 231 976 Avalon Ave 1 9 1 1     6 Width 8ft   6005358.471390001 2092159.7928099998 37.72497578208579 -122.423639316619 (37.7249757820858, -122.423639316619)
64887 124159 2 197 970 Anza St 5 9 1 1     8 Width 4ft   5995776.57441 2112223.28537 37.7795195518878 -122.45821411290599 (37.7795195518878, -122.458214112906)
147870 124158 2 197 970 Anza St 4 9 1 1     4 Width 4ft   5995788.03534 2112225.31952 37.7795257956775 -122.458174612179 (37.7795257956775, -122.458174612179)
50740 129892 2 11 97 Parker Ave 1 9 1 1     5 Width 3ft   5996812.70207 2113910.24255 37.7842109731914 -122.454751639797 (37.7842109731914, -122.454751639797)
137996 211078 2 143 97 Ashton Ave 1 9 1 1     25 Width 8ft   5994121.912690001 2090532.8785299999 37.7198679898921 -122.46236461134599 (37.7198679898921, -122.462364611346)
60198 205431 2 141 965 Teresita Blvd 3 9 1 1     2 Width 4ft   5998412.37074 2095666.00705 37.7342084848239 -122.447903426526 (37.7342084848239, -122.447903426526)
149415 205430 2 141 965 Teresita Blvd 2 9 1 1     2 Width 4ft   5998406.65668 2095666.5963400002 37.7342097762612 -122.44792322417601 (37.7342097762612, -122.447923224176)
37479 175958 2 141 964 Avalon Ave 2 9 1 1     3 Width 3ft   6005280.1292 2092112.2492799999 37.7248408154316 -122.423906757903 (37.7248408154316, -122.423906757903)
Powered by Datasette · Query took 41.905ms · Data source: data.sfgov.org