sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
120471 2028 3 71 600X Bosworth St 5 11 1 2     12 10   6002398.10054 2095366.8333154998 37.733614037905205 -122.43410212847401 (37.7336140379052, -122.434102128474)
93367 2045 3 71 700X Bosworth St 2 11 1 2     24 10   6002154.6210393 2095431.8532492002 37.733778746199796 -122.43494855504801 (37.7337787461998, -122.434948555048)
118805 2266 3 71 700X Brotherhood Way 12 11 1 2   04/04/2014 12:00:00 AM 22 14M Permit Number 772491 5991180.7931196 2088069.9959996997 37.7129357180907 -122.472351488932 (37.7129357180907, -122.472351488932)
107898 2268 3 71 750X Brotherhood Way 2 11 1 2     6 14M   5991074.042616099 2088106.2478104 37.71302907778821 -122.47272309171998 (37.7130290777882, -122.47272309172)
118870 3773 3 71 1098 Carolina St 6 11 1 2     12 18   6012462.6103665 2102859.9036449 37.754754478768 -122.39983195341699 (37.754754478768, -122.399831953417)
20409 4367 3 71 973 Chenery St 1 1 1 2     24 3X3   6001101.12966 2096102.69208 37.7355608412513 -122.438638832041 (37.7355608412513, -122.438638832041)
80484 8339 3 71 1300 Geary Blvd 5 11 1 2   06/08/1994 12:00:00 AM 18 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
92710 8340 3 71 1300 Geary Blvd 6 11 1 2   06/08/1994 12:00:00 AM 24 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
88546 8341 3 71 1300 Geary Blvd 7 11 1 2     24 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
115283 8342 3 71 1300 Geary Blvd 8 11 1 2     24 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
77480 8344 3 71 1300 Geary Blvd 10 11 1 2   06/08/1994 12:00:00 AM 12 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
108857 8348 3 71 1300 Geary Blvd 14 11 1 2   06/08/1994 12:00:00 AM 6 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
80466 8349 3 71 1300 Geary Blvd 15 11 1 2     24 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
117891 8351 3 71 1300 Geary Blvd 17 11 1 2     24 6   6005496.3592183 2114176.6024527 37.785436596276796 -122.424728193484 (37.7854365962768, -122.424728193484)
5271 8390 3 71 1500 Geary Blvd 1 11 1 2     36 8   6004488.7034 2114010.5767 37.784923768316396 -122.428202546761 (37.7849237683164, -122.428202546761)
5273 8391 3 71 1500 Geary Blvd 2 11 1 2     36 8   6004438.3798 2114005.2394 37.784906265949004 -122.428376269712 (37.784906265949, -122.428376269712)
5280 8392 3 71 1500 Geary Blvd 3 11 1 2     36 8   6004378.143999999 2113996.8521 37.784879827842296 -122.428584068109 (37.7848798278423, -122.428584068109)
4472 8393 3 71 1500 Geary Blvd 4 11 1 2     36 8   6004320.9581 2113985.4149 37.7848451877241 -122.428781097193 (37.7848451877241, -122.428781097193)
6395 8394 3 71 1500 Geary Blvd 5 11 1 2     36 8   6004234.0356 2113977.7901 37.784819331933 -122.429081276927 (37.784819331933, -122.429081276927)
5837 8395 3 71 1500 Geary Blvd 6 11 1 2   06/09/1994 12:00:00 AM 6 8   6004192.8617 2113973.9777 37.7848065332396 -122.429223453232 (37.7848065332396, -122.429223453232)
6405 8469 3 71 1900 Geary Blvd 6 11 1 2     48 8   6002244.0904 2113695.2 37.7839305664786 -122.435945599699 (37.7839305664786, -122.435945599699)
3479 8471 3 71 1900 Geary Blvd 8 11 1 2   06/03/1994 12:00:00 AM 6 8   6002124.2891 2113678.9558 37.783879157642104 -122.43635890448 (37.7838791576421, -122.43635890448)
1548 8472 3 71 1900 Geary Blvd 9 11 1 2     6 8   6002074.2026 2113678.2789 37.7838744530021 -122.436532136471 (37.7838744530021, -122.436532136471)
6701 8474 3 71 1900 Geary Blvd 11 11 1 2     6 8   6001879.2717 2113651.8819999998 37.7837908949329 -122.437204633286 (37.7837908949329, -122.437204633286)
7244 8475 3 71 1900 Geary Blvd 12 11 1 2   06/03/1994 12:00:00 AM 6 8   6001831.8926 2113645.1136 37.7837696172579 -122.43736806210899 (37.7837696172579, -122.437368062109)
8796 8530 3 71 2100X Geary Blvd 1 11 1 2   06/10/1994 12:00:00 AM 15     6001630.1932 2113615.3325 37.783676377346794 -122.438063730933 (37.7836763773468, -122.438063730933)
6954 8532 3 71 2100 Geary Blvd 3 11 1 2   06/10/1994 12:00:00 AM 6 6   6001535.4351 2113580.6442 37.783575742772705 -122.438389071264 (37.7835757427727, -122.438389071264)
7257 8535 3 71 2100 Geary Blvd 6 11 1 2     18 6   6001300.5704 2113502.1304 37.7833468021346 -122.439195981768 (37.7833468021346, -122.439195981768)
129015 8536 3 71 2100 Geary Blvd 7 11 1 2   06/10/1994 12:00:00 AM 6 6   6001688.6684406 2113658.1430724 37.7837972495813 -122.43786449651002 (37.7837972495813, -122.43786449651)
140538 8537 3 71 2100 Geary Blvd 8 11 1 2   06/10/1994 12:00:00 AM 3 6   6001688.6684406 2113658.1430724 37.7837972495813 -122.43786449651002 (37.7837972495813, -122.43786449651)
100876 8560 3 71 2200 Geary Blvd 1 1 1 2   06/01/1994 12:00:00 AM 6 3X3   6001214.7912099995 2113518.75863 37.7833875775095 -122.43949393557101 (37.7833875775095, -122.439493935571)
99151 8561 3 71 2200 Geary Blvd 2 1 1 2   06/01/1994 12:00:00 AM 6 3X3   6001214.7912099995 2113518.75863 37.7833875775095 -122.43949393557101 (37.7833875775095, -122.439493935571)
89362 8562 3 71 2200 Geary Blvd 3 1 1 2     48 3X3   6001214.7912099995 2113518.75863 37.7833875775095 -122.43949393557101 (37.7833875775095, -122.439493935571)
88368 8563 3 71 2200 Geary Blvd 4 1 1 2     36 3X3   6001214.7912099995 2113518.75863 37.7833875775095 -122.43949393557101 (37.7833875775095, -122.439493935571)
5263 8574 3 71 2200 Geary Blvd 1 11 1 2     6 6   6001134.4053 2113480.9790000003 37.783279269060294 -122.43976932905301 (37.7832792690603, -122.439769329053)
7070 8575 3 71 2200 Geary Blvd 2 11 1 2     48 6   6001093.7947 2113474.2106 37.7832583731226 -122.439909339764 (37.7832583731226, -122.439909339764)
1116 8576 3 71 2200 Geary Blvd 3 11 1 2     48 6   6001010.5429 2113459.32 37.7832127479531 -122.440196288881 (37.7832127479531, -122.440196288881)
5311 8577 3 71 2200 Geary Blvd 4 11 1 2     36 6   6000958.4259 2113453.9053 37.783194913277796 -122.440376203878 (37.7831949132778, -122.440376203878)
8091 8578 3 71 2200 Geary Blvd 5 11 1 2     18 6   6000905.6321 2113444.4294 37.7831658887746 -122.44055816885599 (37.7831658887746, -122.440558168856)
6394 8581 3 71 2200 Geary Blvd 8 11 1 2     24 6   6000715.1007 2113420.9091 37.7830904567466 -122.441215640748 (37.7830904567466, -122.441215640748)
8635 8582 3 71 2200 Geary Blvd 9 11 1 2     18 6   6000649.7853 2113412.1102 37.7830625764785 -122.441440973241 (37.7830625764785, -122.441440973241)
7700 8586 3 71 2200 Geary Blvd 13 11 1 2     24 6   6000400.7068 2113377.2527 37.782952673809795 -122.442300177437 (37.7829526738098, -122.442300177437)
11841 19663 3 71 100 STAIRWAY5 62 1 1 2     12 60ST            
11943 19664 3 71 100 STAIRWAY5 63 1 1 2     12 60ST            
7433 19666 3 71 100 STAIRWAY5 65 1 1 2     18 60ST            
14276 19667 3 71 100 STAIRWAY5 66 1 1 2     12 60ST            
16176 19976 3 71 100 STAIRWAY45 3 1 1 2     12 30ST            
16885 19980 3 71 100 STAIRWAY45 7 1 1 2     12 30ST            
10919 19986 3 71 100 STAIRWAY46 6 1 1 2     12 40            
11206 20301 3 71 50X Sunset Blvd 3 1 1 2     36 60            
7041 20305 3 71 50X Sunset Blvd 7 1 1 2     24 60            
117137 21429 3 71 2692X Sunset Blvd 26 1 1 2     48 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054)
84253 21431 3 71 2692X Sunset Blvd 28 1 1 2     36 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054)
141886 21459 3 71 2701X Sunset Blvd 12 1 1 2     12 40   5985119.006821499 2096832.7848434 37.73664334454379 -122.49394810120701 (37.7366433445438, -122.493948101207)
79809 21491 3 71 2792X Sunset Blvd 14 1 1 2     48 60   5985060.3629888 2096294.4798015 37.735161871163605 -122.49411119238 (37.7351618711636, -122.49411119238)
126787 23612 1 71 890X Vermont St 1 1 1 3     12 30X30PL   6011290.8652502 2104244.5269478 37.7584909549369 -122.403981624636 (37.7584909549369, -122.403981624636)
123604 23614 3 71 910X Vermont St 1 1 1 2     18 30X30PL   6011300.2113585 2104101.3880723 37.7580984495586 -122.403939228694 (37.7580984495586, -122.403939228694)
117254 24789 3 71 7700 Geary Blvd 1 11 1 2     6 4X4   5983110.07731 2112460.67779 37.779435386439204 -122.50204978501301 (37.7794353864392, -122.502049785013)
125546 27294 1 71 7800X Geary Blvd 1 11 1 11   02/12/2001 12:00:00 AM 6 5X5   5982752.16339 2112399.44122 37.77924621575129 -122.503283404585 (37.7792462157513, -122.503283404585)
92056 27295 1 71 7800X Geary Blvd 2 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982729.47953 2112398.50568 37.779242313567295 -122.50336180684499 (37.7792423135673, -122.503361806845)
114112 27296 1 71 7800X Geary Blvd 3 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982703.46074 2112397.7930900003 37.7792388274313 -122.50345176232 (37.7792388274313, -122.50345176232)
111288 27297 1 71 7800X Geary Blvd 4 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982680.863919999 2112396.64212 37.7792343387449 -122.50352984750401 (37.7792343387449, -122.503529847504)
143978 27298 1 71 7800X Geary Blvd 5 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982658.07107 2112395.9042 37.7792309725957 -122.503608641413 (37.7792309725957, -122.503608641413)
86601 27299 1 71 7800X Geary Blvd 6 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982630.17797 2112395.09735 37.779227117259296 -122.503705073784 (37.7792271172593, -122.503705073784)
128707 27300 3 71 7900X Geary Blvd 1 1 1 2   06/10/1999 12:00:00 AM 6 5x5   5982547.933540001 2112415.51016 37.7792783288562 -122.50399109880101 (37.7792783288562, -122.503991098801)
9904 61559 3 71 1096 Carolina St 1 11 1 2   08/25/1984 12:00:00 AM 16   Permit Number 21519 6012461.11053783 2102868.78681941 37.75477878641421 -122.399837764002 (37.7547787864142, -122.399837764002)
92148 87013 1 71 1184 Oakdale Ave 2 1 1 1   12/05/2007 12:00:00 AM     Permit Number 49946 6017813.5 2093492.6 37.7293305991048 -122.380675823117 (37.7293305991048, -122.380675823117)
122533 87014 1 71 35 Whitfield Ct 1 1 1 1   12/05/2007 12:00:00 AM     Permit Number 49947 6017543.1 2094109.3 37.7310090102049 -122.38165350279101 (37.7310090102049, -122.381653502791)
101397 87015 1 71 35 Whitfield Ct 2 1 1 1   12/05/2007 12:00:00 AM     Permit Number 49947 6017543.1 2094109.3 37.7310090102049 -122.38165350279101 (37.7310090102049, -122.381653502791)
77629 87016 1 71 35 Whitfield Ct 3 1 1 1   12/05/2007 12:00:00 AM     Permit Number 49947 6017543.1 2094109.3 37.7310090102049 -122.38165350279101 (37.7310090102049, -122.381653502791)
120538 87017 1 71 1200 Oakdale Ave 1 1 1 1   12/05/2007 12:00:00 AM     Permit Number 49948 6017188.8 2093995.7 37.7306775177665 -122.382870487304 (37.7306775177665, -122.382870487304)
83316 87018 1 71 1200 Oakdale Ave 2 1 1 1   12/05/2007 12:00:00 AM     Permit Number 49948 6017188.8 2093995.7 37.7306775177665 -122.382870487304 (37.7306775177665, -122.382870487304)
12961 87019 1 71 10 Osceola Dr 1 1 1 1   12/05/2007 12:00:00 AM     Permit Number 49949          
81272 87834 1 71 1501@Ocean Sloat Blvd 10 1 1 1   06/06/2008 12:00:00 AM   3x3 Permit Number 50721 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
114533 87835 1 71 1501@Ocean Sloat Blvd 11 1 1 1   06/06/2008 12:00:00 AM   3x3 Permit Number 50721 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
106088 91502 1 71 1501@Clearfield Sloat Blvd 12 1 1 1   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
86211 91503 1 71 1501@Clearfield Sloat Blvd 15 1 1 1   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
80059 91504 1 71 1501@Clearfield Sloat Blvd 18 1 1 1   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
71190 91505 1 71 1501@Clearfield Sloat Blvd 21 1 1 1   05/04/2009 12:00:00 AM   3x3 Permit Number 52122 5986316.3 2095724.7 37.7336708170949 -122.489727133621 (37.7336708170949, -122.489727133621)
107755 94230 1 71 1501@Everglade Sloat Blvd 9 9 1 1   06/28/2010 12:00:00 AM 12   Permit Number 53611 5986316.3 2095724.7 37.7336708170949 -122.489727133621 (37.7336708170949, -122.489727133621)
84102 94231 1 71 1501@Ocean Sloat Blvd 9 9 1 1   06/28/2010 12:00:00 AM 24   Permit Number 53611 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
116587 94232 1 71 1501@Ocean Sloat Blvd 12 9 1 1   06/28/2010 12:00:00 AM 14   Permit Number 53611 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
88999 94233 1 71 1501@Ocean Sloat Blvd 15 9 1 1   06/28/2010 12:00:00 AM 12   Permit Number 53611 5986316.3 2095724.7 37.7336708170949 -122.489727133621 (37.7336708170949, -122.489727133621)
18734 94234 1 71 1501@Clearfield Sloat Blvd 22 9 1 1   06/28/2010 12:00:00 AM 14   Permit Number 53611 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
141881 94235 1 71 1501@Clearfield Sloat Blvd 9 9 1 1   06/28/2010 12:00:00 AM 27   Permit Number 53611 5986536.9 2095861.8 37.734060135224205 -122.488974540344 (37.7340601352242, -122.488974540344)
103326 96843 1 71 417 Dewey Blvd 3 1 1 1           5995136.0 2100316.9 37.7467908665237 -122.45956754031602 (37.7467908665237, -122.459567540316)
108306 96844 1 71 417 Dewey Blvd 4 1 1 1           5995136.0 2100316.9 37.7467908665237 -122.45956754031602 (37.7467908665237, -122.459567540316)
109599 98161 6 71 600 Front St   7 1 1   12/21/2011 12:00:00 AM     Permit Number 768589 6012888.4 2118392.6 37.7974274520849 -122.39944985704099 (37.7974274520849, -122.399449857041)
92410 98278 1 71 900 Brotherhood Way 500 2 1 1   02/07/2012 12:00:00 AM     Permit Number 768594 5988860.9 2088745.5 37.7146559434524 -122.48041912379101 (37.7146559434524, -122.480419123791)
110779 98279 1 71 900 Brotherhood Way 501 2 1 1   02/07/2012 12:00:00 AM     Permit Number 768594 5988860.9 2088745.5 37.7146559434524 -122.48041912379101 (37.7146559434524, -122.480419123791)
89948 98838 3 71 1101X Portola Dr 7 9 1 2   04/11/2013 12:00:00 AM 3     5994967.957909999 2097979.30417 37.740362747150996 -122.459979297607 (37.740362747151, -122.459979297607)
109790 100068 1 71 303 Serrano Dr 1 1 1 1   07/13/2012 12:00:00 AM     Permit Number 769006 5990392.0 2090762.0 37.720281613079 -122.47527420247 (37.720281613079, -122.47527420247)
144225 101034 3 71 1010X Portola Dr 8 7 1 2           5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621)
107428 101036 3 71 1010X Portola Dr 10 7 1 2   04/11/2013 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621)
118896 101040 3 71 1010X Portola Dr 14 7 1 2   04/11/2013 12:00:00 AM 3     5995923.3 2098391.5 37.7415494342357 -122.45670592621 (37.7415494342357, -122.45670592621)
80132 105261 2 71 619 GONZALEZ DR   2 1 1     3     5988914.8 2089258.8 37.716068469533205 -122.48027037241002 (37.7160684695332, -122.48027037241)
104763 105268 1 71 842X GONZALEZ DR 1 2 1 1     2     5988421.0 2089827.0 37.7175998975755 -122.48201875930201 (37.7175998975755, -122.482018759302)
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)
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)
123850 107158 2 71 101x Elsie St 1 14 1 1     20     6007300.0 2098759.0 37.7432051631731 -122.417395111614 (37.7432051631731, -122.417395111614)
144047 108298 1 71 10X Greenwich St 1 7 1 1   12/15/2014 12:00:00 AM 3   Permit Number 774449 6012830.0 2116175.0 37.791335193350896 -122.399496166675 (37.7913351933509, -122.399496166675)
Powered by Datasette · Query took 5.239ms · Data source: data.sfgov.org