sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
500 6742 3 88 1300X Fairfax Ave 12 1 1 2   04/10/2017 01:53:00 PM 3 3x3   6016901.500630001 2097278.26947 37.7396749203573 -122.384092237585 (37.7396749203573, -122.384092237585)
505 6741 3 88 1300X Fairfax Ave 11 1 1 2   04/10/2017 01:50:00 PM 3 3x3   6016924.03316 2097256.8815900004 37.739617439282604 -122.38401284003099 (37.7396174392826, -122.384012840031)
528 248942 3 88 1500x Galvez Ave 1 1 1 2 3 03/18/2017 12:56:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
1063 248924 3 88 201x Cashmere St 5 1 1 2 3 04/29/2017 10:39:00 AM 3 3x3   6016272.0 2096170.0 37.7365970133228 -122.38619155869101 (37.7365970133228, -122.386191558691)
1480 251545 3 88 347 Dolores St 1 1 1 2       3x3   6004948.0 2106317.0 37.7638250559684 -122.426065641314 (37.7638250559684, -122.426065641314)
2512 178827 2 88 927 Brazil Ave 3 1 1 1     5 Width 3ft   6004338.08735 2090755.04432 37.7210610008535 -122.427066663506 (37.7210610008535, -122.427066663506)
2517 178826 2 88 927 Brazil Ave 2 1 1 1     4 Width 3ft   6004356.8834 2090741.4764900003 37.7210248094256 -122.427000725205 (37.7210248094256, -122.427000725205)
2537 230348 2 88 280 Arlington St 1 1 1 1     5 3x3   6004547.50076 2096560.5372400002 37.7370134334286 -122.42675600438 (37.7370134334286, -122.42675600438)
3896 253542 3 88 1000 Cayuga Ave 10 13 1 2   10/03/2017 02:42:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3899 253541 3 88 1000 Cayuga Ave 9 13 1 2   10/03/2017 03:59:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3900 253543 3 88 1000 Cayuga Ave 11 13 1 2   10/03/2017 02:35:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3902 253544 3 88 1000 Cayuga Ave 12 13 1 2   10/03/2017 02:38:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3906 253540 3 88 1000 Cayuga Ave 8 13 1 2   10/03/2017 04:11:00 PM 3 3x3   6000652.979169999 2091201.14277 37.7220768117153 -122.43983693715201 (37.7220768117153, -122.439836937152)
3940 179536 2 88 1880 Alemany Blvd 7 1 1 1   10/04/2017 10:42:00 AM 3 Width 3ft   6000969.55481 2091096.3953200001 37.7218072142025 -122.438735113438 (37.7218072142025, -122.438735113438)
4168 13059 3 88 583 Lombard St 2 1 1 2   10/28/2015 07:23:00 AM 3 2x2   6009557.0524 2120495.5376 37.8030153566132 -122.41112585507 (37.8030153566132, -122.41112585507)
4899 109487 2 88 1314 POLK ST 2 10 1 2   10/31/2017 02:27:00 PM 3 3x3   6006825.7 2115468.8 37.7890596427133 -122.420220804515 (37.7890596427133, -122.420220804515)
5133 242839 2 88 1151 Dolores St 1 1 1 1     0 Width 7ft   6005182.8356800005 2101610.74761 37.750916060132106 -122.424918561756 (37.7509160601321, -122.424918561756)
5141 237496 2 88 3927 24th St 1 1 1 1     8 Width 3ft   6003620.49393 2101843.48933 37.751466742003295 -122.430337889878 (37.7514667420033, -122.430337889878)
5246 243453 3 88 73 Elsie St 1 1 1 2     0 4x6   6007416.818030001 2098970.61704 37.74379278831079 -122.41700617529699 (37.7437927883108, -122.417006175297)
6628 17981 3 88 2583 Pine St 1 1 1 2   01/28/2014 12:00:00 AM 3 3x3   6001557.63 2114929.1565 37.7872796746141 -122.438408931359 (37.7872796746141, -122.438408931359)
6833 4378 3 88 2425X Hyde St 1 1 1 2     45 3X3   6006994.61601 2120672.53629 37.803357316535795 -122.42000580642201 (37.8033573165358, -122.420005806422)
9341 116840 1 88 636 POTRERO AVE 2 1 1 1     4 3x3   6010345.0 2105335.0 37.761432257364994 -122.40732973919701 (37.761432257365, -122.407329739197)
9719 173651 4 88 80 Entrada Ct 3 9 1 1   12/21/2016 12:00:00 AM 3 4x10   5992424.456569999 2092194.59394 37.7243327619491 -122.46835290122299 (37.7243327619491, -122.468352901223)
9836 6755 3 88 1215 Fairfax Ave 9 1 1 2   01/03/2017 06:41:00 AM 3 3x3   6017521.099066501 2096743.3718321999 37.7382404347673 -122.381912713319 (37.7382404347673, -122.381912713319)
10311 27188 1 88 258 Silver Ave 1 1 1 1   11/25/2002 12:00:00 AM 5 2X3   6002908.14927 2093727.2885 37.729141154025506 -122.43222169348999 (37.7291411540255, -122.43222169349)
10860 104506 2 88 631 France Ave 1 1 1 1 1   3 3x3   6002582.75614 2089515.1433 37.7175570910528 -122.43304578096 (37.7175570910528, -122.43304578096)
12646 115976 4 88 2x Olmstead St 1 1 1 1     1 3x3   6011653.53869 2091254.58415 37.7228435956385 -122.401814242757 (37.7228435956385, -122.401814242757)
13056 108448 1 88 90-98X Prague St 1 1 1 1 1 12/22/2014 12:00:00 AM 3 3x3   6004670.84101 2090640.5659299998 37.7207654791334 -122.42590828635599 (37.7207654791334, -122.425908286356)
13472 110653 1 88 1189 Tennessee St 2 1 1 1   04/28/2015 12:00:00 AM 3 3x4   6015597.65588 2103555.7138400003 37.7568393018153 -122.38903859247101 (37.7568393018153, -122.389038592471)
13608 116924 2 88 900x 24th St 3 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015542.44799 2102559.60008 37.754101124282606 -122.389159972153 (37.7541011242826, -122.389159972153)
14030 116926 2 88 900x 24th St 5 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015510.15678 2102558.1918900004 37.7540954675573 -122.389271545654 (37.7540954675573, -122.389271545654)
14067 116930 2 88 900x 24th St 9 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015446.80292 2102557.08015 37.7540889024884 -122.389490562948 (37.7540889024884, -122.389490562948)
14797 116925 2 88 900x 24th St 4 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015524.58204 2102559.09611 37.7540987500629 -122.389221722302 (37.7540987500629, -122.389221722302)
15260 116923 2 88 900x 24th St 2 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015559.42731 2102560.4848599997 37.7541044949445 -122.389101314797 (37.7541044949445, -122.389101314797)
15315 116934 2 88 1275 Minnesota St 2 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015367.98495 2102613.01131 37.7542381072096 -122.38976704331999 (37.7542381072096, -122.38976704332)
15996 116935 2 88 1275 Minnesota St 3 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015368.355880001 2102637.50716 37.7543053881926 -122.389767471397 (37.7543053881926, -122.389767471397)
16017 116931 2 88 900x 24th St 10 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015431.47773 2102556.1938099996 37.754085619065705 -122.38954349973301 (37.7540856190657, -122.389543499733)
16512 116928 2 88 900x 24th St 7 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015476.82973 2102557.66932 37.754092185022394 -122.38938676319599 (37.7540921850224, -122.389386763196)
16552 116933 2 88 1275 Minnesota St 1 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015369.147890001 2102590.92817 37.7541775360745 -122.38976147920799 (37.7541775360745, -122.389761479208)
16611 116932 2 88 900x 24th St 11 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015412.75293 2102554.60022 37.7540802051572 -122.38960814389799 (37.7540802051572, -122.389608143898)
16727 116927 2 88 900x 24th St 6 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015494.24319 2102557.91546 37.7540938262957 -122.38932655988899 (37.7540938262957, -122.389326559889)
16892 116929 2 88 900x 24th St 8 1 1 1   11/22/2016 12:00:00 AM 3 5x5   6015461.93425 2102556.8401200003 37.7540890823654 -122.38943821792401 (37.7540890823654, -122.389438217924)
17580 4334 1 88 852 Chenery St 1 1 1 1     18 3X3   6001755.94767 2095865.71194 37.7349473777015 -122.436357925586 (37.7349473777015, -122.436357925586)
17962 5397 3 88 347 Dolores St 6 1 1 2   06/10/2014 12:00:00 AM 30 6x6   6004921.39011 2106378.39566 37.7639921298444 -122.42616204806002 (37.7639921298444, -122.42616204806)
19246 97101 1 88 1096@Jones Pine St 3 1 1 1       3x3   6008668.0 2115966.0 37.7905284677514 -122.41388184826499 (37.7905284677514, -122.413881848265)
21415 136 3 88 1025X 14th St 6 1 1 2     9 3X3   6001971.14414 2107605.72409 37.767194880067294 -122.436453906645 (37.7671948800673, -122.436453906645)
22057 5393 3 88 347 Dolores St 2 1 1 2   06/10/2014 12:00:00 AM 3 6x7   6004928.4905 2106245.9446799997 37.7636288523174 -122.426128059965 (37.7636288523174, -122.426128059965)
22940 103859 3 88 1475 Polk St 3 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006677.0 2115920.4 37.7902912446707 -122.420767361582 (37.7902912446707, -122.420767361582)
22953 103852 3 88 1507 Polk St 1 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006614.6 2116113.6 37.7908182067111 -122.420996984718 (37.7908182067111, -122.420996984718)
22958 103860 3 88 1475 Polk St 4 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006677.0 2115920.4 37.7902912446707 -122.420767361582 (37.7902912446707, -122.420767361582)
22965 103768 3 88 1323 Polk St 2 10 1 2   08/21/2013 12:00:00 AM 3 3x3   6006757.0 2115467.0 37.7890508291132 -122.42045837028401 (37.7890508291132, -122.420458370284)
23545 177395 2 88 715 Madrid St 1 1 1 1     1 Width 2ft   6001937.656140001 2089768.77997 37.718216907458704 -122.435293726344 (37.7182169074587, -122.435293726344)
23594 230297 2 88 1171 Treat Ave 1 1 1 1     8 Width 3ft   6008685.11737 2101744.284 37.7514799242568 -122.412816735721 (37.7514799242568, -122.412816735721)
23977 177421 2 88 0 Santa Ynez Ave 1 1 1 1     1 Width 4ft   6001079.38248 2091791.86287 37.7237230579705 -122.438405269984 (37.7237230579705, -122.438405269984)
24356 123622 2 88 111 02nd Ave 1 1 1 1     7 Width 3ft   5995179.48554 2114830.2995 37.786643385410706 -122.460468639914 (37.7866433854107, -122.460468639914)
24465 95104 1 88 2200 Beach St 3 5 1 1   01/08/2008 12:00:00 AM 5     5999633.730169999 2120895.6152 37.803552367813104 -122.445494383786 (37.8035523678131, -122.445494383786)
24569 230346 2 88 1801 Church St 3 1 1 1     2 Width 3ft   6004582.48938 2098325.9035400003 37.74186270650671 -122.426760715042 (37.7418627065067, -122.426760715042)
25005 177418 2 88 857 Dartmouth St 1 10 1 1     6 Width 4ft   6009516.77243 2090302.7647799999 37.720110619797104 -122.409133494811 (37.7201106197971, -122.409133494811)
25024 208840 2 88 1350 Plymouth Ave 2 1 1 1     3 Width 2ft   5995903.3540199995 2092975.62657 37.7266776159651 -122.456383367909 (37.7266776159651, -122.456383367909)
25560 131008 3 88 150x Drumm St 3 3 1 2     4 Width 7ft   6013685.844769999 2117434.71438 37.7948417395127 -122.396623287539 (37.7948417395127, -122.396623287539)
26519 115980 4 88 2x Olmstead St 5 1 1 1     1 3x3   6011593.71434 2091235.60939 37.722788156028706 -122.402019710862 (37.7227881560287, -122.402019710862)
26535 177420 2 88 121 Cotter St 1 9 1 1     1 Width 3ft   6001985.26237 2093449.7289900002 37.728326668619296 -122.435392337892 (37.7283266686193, -122.435392337892)
27017 230320 2 88 469 28th St 1 1 1 1     6 Width 2ft   6002876.4268 2099458.33871 37.7448755037027 -122.432740595108 (37.7448755037027, -122.432740595108)
27217 230322 2 88 4089 26th St 1 1 1 1     1 Width 5ft   6003345.458190001 2100655.86235 37.7481902141138 -122.43120423378299 (37.7481902141138, -122.431204233783)
27684 208849 2 88 15 Santa Rita Ave 4 2 1 1     24 Width 3ft   5993729.602000001 2100694.18749 37.7477458321253 -122.464458079273 (37.7477458321253, -122.464458079273)
28385 230289 2 88 3798 25th St 4 1 1 1     1 Width 4ft   6005260.07773 2101390.67485 37.750316153870294 -122.424635797817 (37.7503161538703, -122.424635797817)
28727 177449 2 88 324 Cordova St 1 1 1 1     1 Width 3ft   6001907.3749400005 2086972.3844599999 37.7105369040276 -122.43519848992901 (37.7105369040276, -122.435198489929)
28898 250221 2 88 312 Filbert St 2 17 1 1     8 Width 0ft   6011282.00764 2120080.85256 37.8019733165766 -122.405127362244 (37.8019733165766, -122.405127362244)
29022 208856 2 88 331 Joost Ave 1 9 1 1     6 Width 10ft   5999876.46994 2094937.06877 37.732290569037104 -122.44278926080901 (37.7322905690371, -122.442789260809)
29464 230344 2 88 1801 Church St 1 1 1 1     2 Width 3ft   6004583.81865 2098292.85658 37.7417720422523 -122.426753765994 (37.7417720422523, -122.426753765994)
29562 193317 2 88 136 Hawthorne St 3 4 1 1     9 Width 2ft   6013319.34244 2113654.62795 37.7844421016727 -122.397626191699 (37.7844421016727, -122.397626191699)
29718 130970 2 88 2801 Webster St 1 10 1 1     1 Width 2ft   6002945.56276 2118345.7946599997 37.796739734404 -122.433851284829 (37.796739734404, -122.433851284829)
29927 83659 2 88 559 Paris St 1 1 1 1 1 12/03/2005 12:00:00 AM 6     6001685.54257 2090383.4533900002 37.7198903425557 -122.436209138162 (37.7198903425557, -122.436209138162)
30218 208836 2 88 1677 18th Ave 1 2 1 1     1 Width 3ft   5990563.73281 2104000.71919 37.756641694668396 -122.47564678406499 (37.7566416946684, -122.475646784065)
30570 193337 2 88 1270 Minnesota St 2 1 1 1     4 Width 3ft   6015308.479069999 2102559.27559 37.7540872603324 -122.389969077812 (37.7540872603324, -122.389969077812)
30883 119446 2 88 881 32nd Ave 1 9 1 1     2 Width 6ft   5986011.18097 2109924.94508 37.7726429911374 -122.49182705320801 (37.7726429911374, -122.491827053208)
31120 131005 2 88 1109 Sansome St 3 1 1 1     6 Width 3ft   6011966.28047 2119507.31076 37.8004367394276 -122.40271908303001 (37.8004367394276, -122.40271908303)
31130 177416 2 88 538 Madrid St 2 1 1 1     11 Width 3ft   6002518.22292 2090772.4099400002 37.721005605292504 -122.433358634398 (37.7210056052925, -122.433358634398)
32597 130988 2 88 1000 Jones St 1 1 1 1     3 Width 3ft   6008672.99088 2115994.19666 37.7906061691929 -122.41386657548 (37.7906061691929, -122.41386657548)
32841 193369 2 88 262 Mission St 3 1 1 1     2 Width 4ft   6013943.1918 2116180.78279 37.791413056208704 -122.39564492587601 (37.7914130562087, -122.395644925876)
32904 130968 2 88 95 Heather Ave 1 9 1 1     1     5997356.6821800005 2113906.91877 37.7842330344764 -122.45286943159799 (37.7842330344764, -122.452869431598)
32960 124335 2 88 176 Palm Ave 2 10 1 1     2 Width 2ft   5995959.20478 2113110.98096 37.78196742074471 -122.457646568088 (37.7819674207447, -122.457646568088)
33199 193347 2 88 444 Mississippi St 1 4 1 1     10 Width 4ft   6014042.11061 2105043.11718 37.760837039231205 -122.394522434371 (37.7608370392312, -122.394522434371)
33296 110565 2 88 135 Theresa St 4 1 1 1     7 3x9   6002103.512680001 2093689.48997 37.728991712774295 -122.43500068223301 (37.7289917127743, -122.435000682233)
33482 230350 2 88 35 Sussex St 1 1 1 1     7 Width 3ft   6002643.63835 2096299.62877 37.7361892128574 -122.433319865541 (37.7361892128574, -122.433319865541)
33867 70607 2 88 1256 Bush St 1 1 1 1 1 08/13/1994 12:00:00 AM 9     6007485.00571 2115457.39575 37.78906545695621 -122.41793887748301 (37.7890654569562, -122.417938877483)
34070 177396 2 88 650 France Ave 1 1 1 1     4 Width 3ft   6002554.32379 2089489.05378 37.7174838421787 -122.433142195459 (37.7174838421787, -122.433142195459)
34177 177411 2 88 474 Munich St 1 1 1 1     1 Width 2ft   6003775.47727 2089725.4167 37.7182020389599 -122.42893807173 (37.7182020389599, -122.42893807173)
34364 177430 2 88 294 Ney St 1 1 1 1     1 Width 2ft   6005292.64234 2094059.9977799999 37.730189610640004 -122.424001946647 (37.73018961064, -122.424001946647)
34714 177431 2 88 268 Madison St 1 1 1 1     2 Width 2ft   6005673.422730001 2092431.0022599997 37.7257382372047 -122.42256982665 (37.7257382372047, -122.42256982665)
34741 230311 2 88 2901 20th St 1 1 1 1     1 Width 3ft   6009504.69694 2104506.09173 37.7591091969416 -122.41017748630101 (37.7591091969416, -122.410177486301)
34906 120793 2 88 559 21st Ave 1 1 1 1     3 Width 3ft   5989373.68445 2111524.6737 37.7772313596652 -122.48031303988998 (37.7772313596652, -122.48031303989)
35331 193332 2 88 1258 Minnesota St 3 1 1 1     2 Width 3ft   6015304.05705 2102667.26372 37.7543835276007 -122.38999191341999 (37.7543835276007, -122.38999191342)
35817 83433 2 88 760 Paris St 1 1 1 1 1 12/03/2005 12:00:00 AM 4     6000998.571 2089370.50235 37.7170699516967 -122.43851121642099 (37.7170699516967, -122.438511216421)
35821 130973 2 88 2801 Webster St 4 10 1 1     1 Width 2ft   6002952.36205 2118301.89076 37.796619571497104 -122.43382461811501 (37.7966195714971, -122.433824618115)
35824 131007 3 88 150x Drumm St 2 3 1 2     4 Width 7ft   6013687.07221 2117423.5151299997 37.7948110573238 -122.396618254944 (37.7948110573238, -122.396618254944)
36033 177437 2 88 93 Karen Ct 1 1 1 1     1 Width 2ft   6010115.68283 2091447.6223799998 37.72328769526371 -122.407143912081 (37.7232876952637, -122.407143912081)
36370 130994 2 88 800 Lombard St 4 1 1 1     8 Width 3ft   6008432.69085 2120383.1883 37.8026437557674 -122.41500878732401 (37.8026437557674, -122.415008787324)
36589 177408 2 88 638 Edinburgh St 1 1 1 1     3 Width 2ft   6002397.88484 2090069.70643 37.71906931008821 -122.43372440936301 (37.7190693100882, -122.433724409363)
36649 177403 2 88 688 Vienna St 2 1 1 1     6 Width 2ft   6002695.8436900005 2089531.77748 37.7176091789075 -122.432656076817 (37.7176091789075, -122.432656076817)
36826 218387 2 88 50 San Marcos Ave 9 2 1 1     2 Width 0ft   5993857.52408 2100226.90247 37.746470159084396 -122.46398181990101 (37.7464701590844, -122.463981819901)
Powered by Datasette · Query took 12.846ms · Data source: data.sfgov.org