sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
106 10645 3 36 906 Hayes St 3 1 1 2     24 4x4   6003455.1435 2110726.9996 37.775849351151706 -122.431543829861 (37.7758493511517, -122.431543829861)
148 175046 3 2 80X Junipero Serra Blvd 3 1 1 2     4 Width 3ft   5991566.54873 2087591.2585200001 37.7116435395983 -122.47098334961399 (37.7116435395983, -122.470983349614)
189 138807 3 46 2355 PINE ST 3 1 1 2     13 Width 0ft   6002661.6347 2115086.2451 37.7877737339769 -122.434600550462 (37.7877737339769, -122.434600550462)
221 138361 3 59 2060 SUTTER ST 3 1 1 2     16 Width 0ft   6002830.8674 2114461.7028 37.78606850519029 -122.433970377911 (37.7860685051903, -122.433970377911)
222 251247 3 2 722X Mendell St 3 1 1 2       3X3   6016169.292972799 2097000.9113916 37.738872842648796 -122.38660458641 (37.7388728426488, -122.38660458641)
239 251252 3 63 321X Corbett Ave 3 7 1 2       10x10   5999565.0 2105069.0 37.7600926500434 -122.444594033425 (37.7600926500434, -122.444594033425)
242 194017 3 2 717 Mendell St 3 1 1 2     22 Width 4ft   6016141.23024 2096883.95841 37.7385501598741 -122.386693461838 (37.7385501598741, -122.386693461838)
246 251253 3 21 1350 Howard St 3 1 1 2       3x3   6008544.9526 2110145.4696299997 37.774539777213995 -122.413895673958 (37.774539777214, -122.413895673958)
288 226558 3 32 320 Dolores St 3 1 1 2     22 Width 7ft   6004836.50691 2106380.98977 37.7639944545966 -122.42645581878 (37.7639944545966, -122.42645581878)
309 20164 3 26 1155X Steiner St 3 1 1 2   12/31/1990 12:00:00 AM 25 4X4   6002621.0 2112212.0 37.7798794773869 -122.43453554599199 (37.7798794773869, -122.434535545992)
323 27392 3 55 2240 Hyde St 3 1 1 2     45 3X3   6007139.14869 2120046.64789 37.801646927424706 -122.419461214785 (37.8016469274247, -122.419461214785)
325 21670 3 59 1776 Sutter St 3 1 1 2     22 4X4   6004121.8146 2114641.2436 37.786634655728605 -122.429516856277 (37.7866346557286, -122.429516856277)
329 5267 3 26 1245 Divisadero St 3 1 1 2     6 3X4   6001292.1098 2112753.8798 37.7812918154006 -122.43917160516001 (37.7812918154006, -122.43917160516)
393 251277 3 76 1200x Hudson Ave 3 1 1 2 3 10/26/2011 12:00:00 AM   3x3   6017356.0 2095183.0 37.733946845802 -122.38237501907301 (37.733946845802, -122.382375019073)
479 85531 3 49 101X 12th St 3 1 1 2   05/29/2007 12:00:00 AM 6     6007317.968280001 2109362.68703 37.7723214572932 -122.418084555959 (37.7723214572932, -122.418084555959)
481 14087 3 15 1446 Market St 3 1 1 2     12 4X4 Permit Number 779892 6007224.7884 2110663.6072 37.775888228839705 -122.418499137854 (37.7758882288397, -122.418499137854)
499 248944 3 87 1500x Galvez Ave 3 1 1 2 3 04/10/2017 12:58:00 PM 3 3x3   6016393.0 2097292.0 37.739684495027205 -122.385851388433 (37.7396844950272, -122.385851388433)
613 20019 3 5 100 STAIRWAY48 3 1 1 2     6 10ST            
663 237022 3 82 8 Octavia St 3 4 1 2   04/15/2017 01:40:00 PM 3 Width 6ft   6005770.133230001 2109412.50366 37.772371001847 -122.423442207693 (37.772371001847, -122.423442207693)
696 5946 3 10 1415 Eddy St 3 1 1 2     12 3X3   6003699.8521 2112803.046 37.7815635260957 -122.43084551167601 (37.7815635260957, -122.430845511676)
723 230153 3 21 583 Church St 3 1 1 2     12 Width 3ft   6004293.15538 2105508.69845 37.7615686206128 -122.428272938555 (37.7615686206128, -122.428272938555)
731 251375 3 47 401 Portola Dr 3 3 1 2           5998962.0 2100210.0 37.7467166026546 -122.446329965078 (37.7467166026546, -122.446329965078)
746 251371 3 43 390 06th St 3 1 1 2 3     3x3   6011351.0 2111108.0 37.7773398544385 -122.404256716486 (37.7773398544385, -122.404256716486)
753 48 3 22 810 14th St 3 1 1 2     4 3X3   6003376.13457 2107738.85817 37.767640169485105 -122.43160376032499 (37.7676401694851, -122.431603760325)
772 221430 3 109 100x Guerrero St 3 11 1 2   07/15/2016 06:19:00 AM 1 Width 3ft   6005430.67341 2108312.23866 37.7693307735195 -122.424538153922 (37.7693307735195, -122.424538153922)
790 216490 3 11 800x Bosworth St 3 1 1 2     0 Width 3ft   6001788.93125 2095501.57158 37.7339494063362 -122.436217839104 (37.7339494063362, -122.436217839104)
791 191798 3 114 2 Newhall St 3 4 1 2   11/12/2014 12:00:00 AM 6 Width 3ft Permit Number 774049 6018546.987380001 2097184.73725 37.7395089360924 -122.378396294176 (37.7395089360924, -122.378396294176)
796 212189 3 60 720 Bosworth St 3 9 1 2     16     6002068.0773599995 2095471.6867 37.7338832054473 -122.435250610137 (37.7338832054473, -122.435250610137)
831 244348 3 98 300 Octavia St 3 1 1 2   04/19/2017 02:44:00 PM 3 Width 0ft   6005622.9962 2110384.2841 37.7750309704349 -122.424020287681 (37.7750309704349, -122.424020287681)
852 244300 3 98 350 Octavia St 3 1 1 2   04/20/2017 11:46:00 AM 3 Width 0ft   6005602.4578 2110538.44 37.775453085580295 -122.424102299872 (37.7754530855803, -122.424102299872)
854 203901 3 5 3794 19th Ave 3 2 1 2     12 Width 3ft   5990470.121669999 2090714.3108400002 37.720155198286 -122.475000685058 (37.720155198286, -122.475000685058)
893 18095 3 22 3001 Pine St 3 1 1 2     15 3X3   5999540.0604 2114647.8242 37.7863922432736 -122.44536903339501 (37.7863922432736, -122.445369033395)
965 130085 3 11 600 Franklin St 3 1 1 2     11 Width 4ft   6006282.409 2112253.58537 37.7802008260541 -122.421872043567 (37.7802008260541, -122.421872043567)
968 129976 3 11 90x Jones St 3 1 1 2     8 Width 4ft   6009114.5006 2112815.4856 37.781902979173005 -122.41211422669399 (37.781902979173, -122.412114226694)
988 199496 3 75 87 06th St 3 1 1 2     21 Width 4ft   6010015.0817 2112492.094 37.781065511609604 -122.40897579419399 (37.7810655116096, -122.408975794194)
1018 7366 3 32 2360 Fillmore St 3 1 1 2     18 3X3   6002774.54957 2116438.38146 37.79149276403471 -122.434306592692 (37.7914927640347, -122.434306592692)
1062 189665 3 32 2585 03rd St 3 1 1 2     19 Width 5ft   6015925.0907 2103156.8300799998 37.755762196378996 -122.387878359099 (37.755762196379, -122.387878359099)
1074 11442 3 32 2200X Gough St 3 1 1 2     15 3X3   6005100.87554 2117226.15448 37.7937875569128 -122.42631364855801 (37.7937875569128, -122.426313648558)
1084 8287 3 5 1601 Galvez Ave 3 1 1 2   05/01/2017 12:00:00 AM 6 3x3   6015799.31492 2097666.33838 37.7406794801837 -122.387930230222 (37.7406794801837, -122.387930230222)
1105 244414 3 82 261 Octavia St 3 1 1 2   05/02/2017 04:17:00 PM 3 Width 0ft   6005541.7456 2110219.4552 37.7745738026307 -122.424289625835 (37.7745738026307, -122.424289625835)
1111 3698 3 11 401X Cargo Way 3 1 1 2   05/03/2017 11:57:00 AM 3 3X3   6016408.29218 2099351.9279400003 37.745341482920296 -122.385942065688 (37.7453414829203, -122.385942065688)
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)
1175 2161 3 5 700X Mansell St 3 1 1 2     12 3x100   6009743.36579 2090187.72527 37.71980743673429 -122.408342124702 (37.7198074367343, -122.408342124702)
1194 119795 3 46 201x Octavia St 3 11 1 2           2110122.0 6005581.0 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)
1226 119830 3 46 301x Octavia St 3 11 1 2           2110475.0 6005532.0 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)
1234 119748 3 46 101x Octavia St 3 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
1336 7171 3 59 801 Fillmore St 3 1 1 2     12 3x3 Permit Number 780067 6003475.9145 2111120.5411 37.7769310959731 -122.431500078765 (37.7769310959731, -122.431500078765)
1355 29680 3 11 1900X Van Ness Ave 3 11 1 2     3     6006072.343230001 2117086.04016 37.7934577026643 -122.422942314134 (37.7934577026643, -122.422942314134)
1383 26841 3 43 100 Van Ness Ave 3 1 1 2     18 3X3 Permit Number 779930 6006975.88726 2110943.04151 37.7766414730488 -122.419379980819 (37.7766414730488, -122.419379980819)
1400 235284 3 26 4235 19th St 3 1 1 4   03/07/1990 12:00:00 AM 11 Width 3ft   6001885.77275 2104671.54401 37.7591334867264 -122.43653915428499 (37.7591334867264, -122.436539154285)
1448 138093 3 59 1890 Sutter St 3 1 1 2     18 Width 0ft   6003632.0 2114586.0 37.7864552256154 -122.43120755079399 (37.7864552256154, -122.431207550794)
1461 234073 3 26 1400 San Bruno Ave 3 1 1 4     17 Width 3ft   6011143.13167 2101723.71293 37.7515611015794 -122.404315130536 (37.7515611015794, -122.404315130536)
1544 196581 3 9 375 07th St 3 4 1 2     10 Width 3ft   6010649.28152 2110608.88242 37.77593015789721 -122.40664901875 (37.7759301578972, -122.40664901875)
1575 246375 3 15 2248 Market St 3 1 1 2     11 Width 0ft   6003217.3444 2106843.7794 37.765173499092995 -122.43208906900499 (37.765173499093, -122.432089069005)
1578 143015 3 11 968 COLUMBUS AVE 3 1 1 2   09/13/2016 07:32:00 AM 16 Width 0ft   6008678.8788 2120570.254 37.8031712224349 -122.41417009265301 (37.8031712224349, -122.414170092653)
1585 23896 3 98 1581 Webster St 3 1 1 2   05/24/2017 12:00:00 AM 3 3x3   6003535.353102201 2114132.0136397 37.7852032161945 -122.43150950273301 (37.7852032161945, -122.431509502733)
1743 200855 3 15 1101 Market St 3 1 1 2     8 Width 0ft   6008978.4093 2112218.7143 37.7802567505844 -122.412542843301 (37.7802567505844, -122.412542843301)
1744 9601 3 26 1355 Golden Gate Ave 3 1 1 2     10 3X3   6003062.4207 2112013.0769 37.7793583323419 -122.432994261414 (37.7793583323419, -122.432994261414)
1745 17972 3 41 2515 Pine St 3 1 1 2     12 3x3   6001748.1253 2114954.2725 37.7873594702652 -122.437751658759 (37.7873594702652, -122.437751658759)
1762 200860 3 15 1131 Market St 3 1 1 2     9 Width 0ft   6008794.0112 2112059.0249 37.779807931141 -122.413169468366 (37.779807931141, -122.413169468366)
1791 251711 3 124 902 Market St 3 8 1 2       3x3   6010270.0 2113565.0 37.7840257341798 -122.4081695922 (37.7840257341798, -122.4081695922)
1858 12328 3 55 1025 Laguna St 3 1 1 2     12 4X4   6004756.1585 2112422.6893 37.780578952523996 -122.427164094387 (37.780578952524, -122.427164094387)
1902 242360 3 119 388 Coleridge St 3 1 1 2     30 Width 3ft   6006031.24378 2097876.97394 37.7407118512751 -122.421719507764 (37.7407118512751, -122.421719507764)
1940 139586 3 37 3 Saint Joseph's Ave 3 1 1 2     8 Width 0ft   6000731.3449 2112139.6442 37.779573356306 -122.44106749101401 (37.779573356306, -122.441067491014)
1958 23757 3 62 900X Webster St 3 11 1 2     25 20   6003900.3372 2111922.0621 37.7791559204238 -122.43008906318701 (37.7791559204238, -122.430089063187)
1990 123760 3 44 201 Cabrillo St 3 1 1 2   06/14/2017 12:00:00 AM 3 Width 3ft Permit Number 778327 5994952.60534 2110751.23907 37.7754303235309 -122.460957832773 (37.7754303235309, -122.460957832773)
1997 28906 3 49 354 05th St 3 1 1 2   02/28/2014 12:00:00 AM 5 3X3 Permit Number 779305 6011835.68516 2111895.24936 37.779528530663704 -122.402635398413 (37.7795285306637, -122.402635398413)
2011 224701 3 94 3230 24th St 3 1 1 2     17 Width 3ft   6007503.74003 2102097.0446900004 37.7523821439458 -122.416927083514 (37.7523821439458, -122.416927083514)
2047 127862 3 32 1898 Hyde St 3 1 1 2     14 Width 3ft   6007316.9194 2118776.88276 37.7981704829404 -122.41875594393 (37.7981704829404, -122.41875594393)
2050 252861 3 17 988 Howard St 3 1 1 2   06/19/2017 12:00:00 AM 3 3x3 Permit Number 779759 6010589.4479 2112082.95565 37.7799742710855 -122.40695991983 (37.7799742710855, -122.40695991983)
2061 252860 3 167 1800X Steiner St 3 1 1 2       3x3   6002556.0 2114541.0 37.7862706325854 -122.434927017215 (37.7862706325854, -122.434927017215)
2063 24316 3 11 600X Golden Gate Ave 3 1 1 2   06/08/2004 12:00:00 AM 3 3X3   6006540.648630001 2112546.28984 37.7810190813924 -122.420999461083 (37.7810190813924, -122.420999461083)
2067 252866 3 2 1660 Masonic Ave 3 1 1 2       3x3   6000023.0 2106990.0 37.7653933634599 -122.443148003218 (37.7653933634599, -122.443148003218)
2217 13060 3 21 583 Lombard St 3 1 1 2   09/26/2013 12:00:00 AM 3 2X2   6009601.7098 2120500.5639 37.8030316618488 -122.41097167179701 (37.8030316618488, -122.410971671797)
2240 122755 3 55 693 Vermont St 3 1 1 4 2   14     6011274.22678 2105356.76628 37.7615439863765 -122.40411744427601 (37.7615439863765, -122.404117444276)
2243 20174 3 26 1200X Steiner St 3 1 1 2   01/02/1991 12:00:00 AM 6 3X3   6002845.6787 2112476.9688 37.7806197669525 -122.433777227143 (37.7806197669525, -122.433777227143)
2249 191500 3 55 1196 La Salle Ave 3 1 1 2     15 Width 3ft   6016876.9140800005 2094649.78681 37.732456273623704 -122.38399426453998 (37.7324562736237, -122.38399426454)
2251 13985 3 15 1155 Market St 3 1 1 2     35 4X4   6008672.0 2111900.0 37.779364436223 -122.4135803097 (37.779364436223, -122.4135803097)
2264 14060 3 125 1390 Market St 3 1 1 2   07/07/2017 12:00:00 AM 3 4x4   6007755.5079 2111176.7984 37.777327192558104 -122.41669960143999 (37.7773271925581, -122.41669960144)
2329 6184 3 79 1100 Ellis St 3 1 1 2     12 3X3   6005484.2824 2113445.6337 37.7834288547985 -122.424717956993 (37.7834288547985, -122.424717956993)
2330 6147 3 15 939 Ellis St 3 1 1 2     6 4x4   6006318.99495 2113507.73043 37.7836464651567 -122.42183458592 (37.7836464651567, -122.42183458592)
2342 3126 3 15 3200 California St 3 1 1 2     18 3X3   5998843.08615 2114964.7899700003 37.787222737075 -122.447803205161 (37.787222737075, -122.447803205161)
2426 192160 3 32 1500 Mission St 3 1 1 2     22 Width 3ft Permit Number 779453 6007491.12658 2110012.65001 37.774115845790796 -122.41753165726699 (37.7741158457908, -122.417531657267)
2495 13230 3 26 2301X Lombard St 3 1 1 2     15 3X3   6001287.1241 2119305.7914 37.7992813828917 -122.439658706658 (37.7992813828917, -122.439658706658)
2501 119761 3 35 101X Octavia St Frontage West 3 1 1 2       4x4            
2513 138183 3 35 1865 Buchanan St 3 1 1 2   06/26/2012 12:00:00 AM 2 Width 0ft   6003936.4381 2114774.6580000003 37.7869904804487 -122.43016773530199 (37.7869904804487, -122.430167735302)
2531 8603 3 47 2400 Geary Blvd 3 11 1 2     36 6   5999987.1554 2113318.7057 37.782768340075606 -122.443726682203 (37.7827683400756, -122.443726682203)
2559 19580 3 2 100 STAIRWAY4 3 1 1 2     3 8            
2574 139639 3 36 1780 Turk St 3 1 1 2   03/14/1997 12:00:00 AM 22 Width 0ft   6001669.0 2112367.0 37.7802509803634 -122.437840034507 (37.7802509803634, -122.437840034507)
2613 98090 3 35 2X Frank Norris St 3 1 1 4 2   3 3x3   6007144.43128 2115568.9527 37.7893525915946 -122.419125139911 (37.7893525915946, -122.419125139911)
2655 5870 3 15 1010X Eddy St 3 1 1 2     12 3X3   6005526.7803 2113108.4242 37.782505360766294 -122.42454693631599 (37.7825053607663, -122.424546936316)
2745 1164 3 120 2849X Alemany Blvd 3 1 1 2   03/06/2006 12:00:00 AM 3 3X3   5997509.5346800005 2087964.66518 37.7130107600005 -122.450469794845 (37.7130107600005, -122.450469794845)
2843 23527 3 32 2750 Van Ness Ave 3 1 1 2     18 3X3   6005732.6493 2119830.06962 37.800972938614294 -122.424312938499 (37.8009729386143, -122.424312938499)
2844 17858 3 5 2121 Pine St 3 1 1 2     12 3X3   6003631.9915 2115212.7417 37.7881760994608 -122.43125233371799 (37.7881760994608, -122.431252333718)
2871 16699 3 11 900 Noriega St 3 11 1 2   08/10/2017 12:00:00 AM 3 8   5991131.39821 2103159.65216 37.7543652389679 -122.473622260865 (37.7543652389679, -122.473622260865)
2880 41129 3 60 2049 Grove St 3 1 1 4 2 08/10/2017 12:00:00 AM 3 6x6 Permit Number 41868 5998020.62854813 2110270.29167038 37.7742858282579 -122.450310189268 (37.7742858282579, -122.450310189268)
2927 13682 3 15 700 Market St 3 1 1 2     35 4X4   6011577.51187 2114828.29204 37.787567561449706 -122.403734970715 (37.7875675614497, -122.403734970715)
2961 137577 3 11 1095 Pierce St 3 1 1 2   05/20/1992 12:00:00 AM 17 Width 0ft   6002355.8984 2112213.5374 37.7798686462193 -122.435452758685 (37.7798686462193, -122.435452758685)
3066 13737 3 15 800 Market St 3 1 1 2     12 4x4 Permit Number 780155 6010751.43772 2114034.04518 37.7853405666668 -122.40653704776001 (37.7853405666668, -122.40653704776)
3191 21648 3 17 1660 Sutter St 3 1 1 2     12 3X2   6004632.9541 2114713.0403 37.7868607185832 -122.427753554263 (37.7868607185832, -122.427753554263)
3231 188482 3 97 1580 Burke Ave 3 4 1 2   03/30/1990 12:00:00 AM 9 Width 4ft   6016171.38717 2099220.37618 37.7449671554124 -122.386752079638 (37.7449671554124, -122.386752079638)
Powered by Datasette · Query took 4.28ms · Data source: data.sfgov.org