sf-trees

Data source: data.sfgov.org

Custom SQL query returning 77 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2524 141906 2 49 900 MCALLISTER ST 7 1 1 1     7 Width 0ft   6004683.4832 2111946.7944 37.7792681524686 -122.427381601663 (37.7792681524686, -122.427381601663)
2675 223660 1 49 336 Bosworth St 1 1 1 1   12/04/1980 12:00:00 AM 7 Width 3ft Permit Number 18811 6003709.54346 2095276.16661 37.7334394304696 -122.429561626586 (37.7334394304696, -122.429561626586)
25987 114650 2 49 2200 Post St 4 1 1 1     7 3x3   6001545.1748 2113940.4839 37.784564324662 -122.43838116449301 (37.784564324662, -122.438381164493)
27273 138750 2 49 2200 POST ST 11 1 1 1     7 Width 0ft   6001227.9034 2113893.9374 37.7844184685956 -122.439475475851 (37.7844184685956, -122.439475475851)
29383 207619 2 49 724 Head St 2 4 1 1     7 Width 3ft   5993530.3141 2090655.8864799999 37.720171655864604 -122.46441847134199 (37.7201716558646, -122.464418471342)
30000 72470 2 49 955 Sansome St 1 1 1 1 1 05/18/1996 12:00:00 AM 7     6012030.25538 2119045.5342200003 37.7991723843595 -122.402465214308 (37.7991723843595, -122.402465214308)
30932 74829 2 49 998 Sansome St 2 1 1 1 1 10/07/1995 12:00:00 AM 7     6012078.13426 2119069.37262 37.7992405115981 -122.402301213024 (37.7992405115981, -122.402301213024)
32722 191110 2 49 2251 24th St 3 4 1 1     7 Width 3ft   6011791.4986 2102301.92631 37.753184958831895 -122.40211362973999 (37.7531849588319, -122.40211362974)
33927 207670 2 49 1946 18th Ave 1 1 1 1     7 Width 3ft   5990672.18333 2102133.32849 37.751520618601106 -122.475135407975 (37.7515206186011, -122.475135407975)
35080 191665 2 49 535 Brannan St 11 1 1 1     7 Width 2ft   6013224.690669999 2111029.2007400002 37.7772280099979 -122.39776943840799 (37.7772280099979, -122.397769438408)
35456 223428 2 49 357 Precita Ave 6 1 1 1     7 Width 5ft   6008915.2046 2100223.65051 37.7473175155876 -122.411913617629 (37.7473175155876, -122.411913617629)
38332 176262 2 49 56 University St 1 1 1 1     7 Width 2ft   6007768.4416 2093799.0798400003 37.7296126542007 -122.41542429481899 (37.7296126542007, -122.415424294819)
40020 224067 2 49 198 Corbin Pl 2 17 1 1     7 Width 3ft   6000076.797040001 2105677.0536599997 37.7617914060643 -122.44286764213301 (37.7617914060643, -122.442867642133)
42290 223546 2 49 384 Sussex St 2 1 1 1     7 Width 3ft   6000939.020959999 2096709.0709799998 37.7372165929608 -122.43924275106899 (37.7372165929608, -122.439242751069)
45158 207655 2 49 1321 04th Ave 1 1 1 1     7 Width 3ft   5994849.00569 2106528.5964599997 37.763830092700296 -122.461010081256 (37.7638300927003, -122.461010081256)
46569 207598 2 49 484 Faxon Ave 3 1 1 1     7 Width 4ft   5994786.89964 2091797.5049599998 37.7233786212014 -122.460157571622 (37.7233786212014, -122.460157571622)
47347 223590 2 49 500 Jarboe Ave 1 1 1 1     7 Width 3ft   6008475.14451 2096933.16197 37.7382578613013 -122.413202674371 (37.7382578613013, -122.413202674371)
49805 45669 1 49 815 37th Ave 1 1 1 1   12/07/2007 12:00:00 AM 7 3x3 Permit Number 49963 5984453.94726 2110275.98244 37.7735156996405 -122.497239525872 (37.7735156996405, -122.497239525872)
50518 189268 2 49 1721 Oakdale Ave 2 4 1 1     7 Width 3ft   6014331.30759 2095974.08961 37.735951477983704 -122.39288771511002 (37.7359514779837, -122.39288771511)
51066 224041 2 49 3900 25th St 1 1 1 1     7 Width 3ft   6004443.2007 2101347.0778200002 37.750150278415205 -122.427457508869 (37.7501502784152, -122.427457508869)
52017 141629 2 49 1801 GROVE ST 11 1 1 1     7 Width 0ft   5999005.9913 2110412.5019 37.7747326436678 -122.446911888169 (37.7747326436678, -122.446911888169)
52128 32155 1 49 521 Ivy St 2 1 1 1   08/15/1995 12:00:00 AM 7   Permit Number 35505 6004828.77889 2111059.03276 37.7768387933121 -122.42681572299401 (37.7768387933121, -122.426815722994)
55656 126560 2 49 1005 Sansome St 7 1 1 1     7 Width 3ft   6012009.79179 2119188.89054 37.7995648637804 -122.402546111926 (37.7995648637804, -122.402546111926)
55728 74929 2 49 39 Stillman St 1 1 1 1 1 05/14/1994 12:00:00 AM 7     6014021.820230001 2112985.48182 37.78264387125021 -122.395148955186 (37.7826438712502, -122.395148955186)
56193 223619 2 49 429 Bartlett St 1 1 1 1     7 Width 3ft   6006801.93738 2101276.12036 37.7500885714431 -122.419295806956 (37.7500885714431, -122.419295806956)
56938 33335 1 49 3360 Octavia St 2 1 1 1 1 11/14/1996 12:00:00 AM 7 9x9 Permit Number 37474 6004127.03344 2120735.4068 37.8033679654079 -122.429933668002 (37.8033679654079, -122.429933668002)
60578 181735 2 49 2801 Lincoln Way 2 1 1 1     7 Width 0ft   5986996.5941 2107070.8859 37.7648640858106 -122.488208680173 (37.7648640858106, -122.488208680173)
62924 191663 2 49 535 Brannan St 7 1 1 1     7 Width 2ft   6013137.81115 2110946.71833 37.7769966935644 -122.398064196625 (37.7769966935644, -122.398064196625)
70733 71444 2 49 1088 Sansome St 2 1 1 1 1 10/07/1995 12:00:00 AM 7     6012034.251 2119394.2595 37.8001301227773 -122.402475922527 (37.8001301227773, -122.402475922527)
71713 68222 1 49 1324 Clement St 1 1 1 1 1 09/27/1993 12:00:00 AM 7   Permit Number 32012 5991360.0302800005 2113443.0378799997 37.78261388597161 -122.47358167061199 (37.7826138859716, -122.473581670612)
74762 223400 2 49 3438 21st St 2 1 1 1     7 Width 2ft   6005402.025719999 2103738.26826 37.7567701160611 -122.42431188179701 (37.7567701160611, -122.424311881797)
75138 223433 2 49 321 Valencia St 1 1 1 1     7 Width 3ft   6006139.56315 2107708.4180799997 37.7677128338021 -122.422043233108 (37.7677128338021, -122.422043233108)
76366 126496 2 49 1695 Filbert St 2 1 1 1     7 Width 3ft   6004921.92717 2119147.2014599997 37.7990521458892 -122.42706971848999 (37.7990521458892, -122.42706971849)
76579 248098 2 49 11 Brewster St 1 1 1 1     7 Width 3ft   6010471.50543 2099820.33523 37.746297290485295 -122.40650360018 (37.7462972904853, -122.40650360018)
81382 112862 2 49 1732 ULLOA ST 1 1 1 1     7 3x3   5990594.0 2098423.0 37.7413284897401 -122.47513493887301 (37.7413284897401, -122.475134938873)
91177 2768 1 49 238 Cabrillo St 4 1 1 1   01/19/2005 12:00:00 AM 7 3X3   5994792.462780001 2110798.98024 37.7755521919136 -122.461515261652 (37.7755521919136, -122.461515261652)
116058 113703 2 49 14 LUNDYS LN 2 1 1 1     7 3x3   6007138.0 2099599.0 37.7455024988094 -122.418014802057 (37.7455024988094, -122.418014802057)
119604 191100 2 49 2041 26th St 4 1 1 1     7 Width 2ft   6012349.12966 2101394.53419 37.7507245656958 -122.40012149651899 (37.7507245656958, -122.400121496519)
121004 49497 1 49 2X ORDWAY ST 4 1 1 1   04/21/2003 12:00:00 AM 7 3x3 Permit Number 46411 6011821.0 2090323.0 37.720294999502 -122.401169931587 (37.720294999502, -122.401169931587)
121784 112066 2 49 768 Funston Ave 1 1 1 1     7 3x3   5991979.16642 2110231.12718 37.77383069132 -122.47120566172701 (37.77383069132, -122.471205661727)
129958 191065 2 49 250 Clara St 1 4 1 1     7 Width 3ft   6011631.45196 2111618.92007 37.7787583899224 -122.403322487638 (37.7787583899224, -122.403322487638)
130599 223526 2 49 4128 24th St 1 1 1 1     7 Width 4ft   6002300.1316599995 2101812.6373099997 37.7513071510194 -122.434901649798 (37.7513071510194, -122.434901649798)
131570 207608 2 49 299 Tara St 1 4 1 1     7 Width 3ft   5997723.56116 2090176.57785 37.71909640934621 -122.44988936340799 (37.7190964093462, -122.449889363408)
132487 31506 1 49 275 Collins St 1 1 1 1 1 05/13/1995 12:00:00 AM 7   Permit Number 35066 5998177.9524 2112750.4955 37.781104827172705 -122.44994476744199 (37.7811048271727, -122.449944767442)
134369 207591 2 49 207 Flood Ave 2 9 1 1     7 Width 10ft   5999361.39835 2094045.00117 37.7298117829776 -122.444505884965 (37.7298117829776, -122.444505884965)
134610 53155 1 49 1785@ 3RD ST Quesada Ave 2 1 1 1   11/02/2006 12:00:00 AM 7   Permit Number 49078 6014228.24564 2095345.46405 37.7342196759901 -122.393200070342 (37.7342196759901, -122.393200070342)
135802 207636 2 49 1475 06th Ave 1 1 1 1     7 Width 3ft   5994263.22804 2105474.6217900002 37.7609024271204 -122.462959619907 (37.7609024271204, -122.462959619907)
136320 207653 2 49 1259 12th Ave 1 1 1 1     7 Width 4ft   5992353.426469999 2106870.06919 37.7646237659879 -122.46966631405199 (37.7646237659879, -122.469666314052)
137143 189245 2 49 2445 Mariposa St 1 1 1 1     7 Width 3ft   6010120.66455 2105943.60701 37.7630907960193 -122.408148550138 (37.7630907960193, -122.408148550138)
146993 126553 2 49 247 Vallejo St 2 1 1 1     7 Width 3ft   6012114.08056 2119104.08763 37.7993378371204 -122.40217926767099 (37.7993378371204, -122.402179267671)
147207 120492 2 49 2101 Cabrillo St 1 1 1 1     7 Width 3ft   5989019.39617 2110533.53925 37.7744893859398 -122.481466017661 (37.7744893859398, -122.481466017661)
147225 31708 1 49 498 Frederick St 2 1 1 1   06/19/1995 12:00:00 AM 7   Permit Number 35209 5997262.9247 2107438.6115 37.766467371667794 -122.452726796412 (37.7664673716678, -122.452726796412)
147834 41577 1 49 715 47th Ave 1 1 1 1   05/18/2000 12:00:00 AM 7   Permit Number 42091 5981330.80652 2110844.76376 37.774893875261505 -122.50808495995001 (37.7748938752615, -122.50808495995)
150014 176243 2 49 10 Ordway St 1 1 1 1     7 Width 3ft   6011901.96297 2090368.71329 37.72042503536171 -122.40089327761801 (37.7204250353617, -122.400893277618)
151276 223611 2 49 255 Bartlett St 1 1 1 1     7 Width 3ft   6006745.90219 2102323.75764 37.752961988114 -122.419563899379 (37.752961988114, -122.419563899379)
152061 141989 2 49 1019 MCALLISTER ST 2 1 1 1     7 Width 0ft   6004298.7778 2111838.3869 37.77894872708271 -122.42870472731 (37.7789487270827, -122.42870472731)
153042 207605 2 49 68 Ashton Ave 1 1 1 1     7 Width 3ft   5994168.04761 2090360.8156299999 37.71939820295 -122.46219266815599 (37.71939820295, -122.462192668156)
153296 244881 2 49 1397 Page St 1 1 1 1     7 Width 0ft   5999919.405 2109151.3942 37.7713221021012 -122.44366159862601 (37.7713221021012, -122.443661598626)
155627 84783 1 49 280 Charter Oak Ave 1 1 1 1   05/09/2007 12:00:00 AM 7   Permit No. 49320 6010967.59518 2095106.3489299999 37.733381434103705 -122.404456411357 (37.7333814341037, -122.404456411357)
158823 207612 2 49 157 Majestic Ave 1 4 1 1     7 Width 3ft   5996901.64922 2089066.51215 37.7160013655568 -122.452650309965 (37.7160013655568, -122.452650309965)
159033 223376 2 49 2801 26th St 2 1 1 1     7 Width 3ft   6010275.7458 2101037.64941 37.74962881461661 -122.407266315203 (37.7496288146166, -122.407266315203)
161029 246486 2 49 346 Duncan St 1 10 1 1     7 Width 3ft   6004013.8028 2099862.02066 37.746048360848896 -122.4288365338 (37.7460483608489, -122.4288365338)
163124 223606 2 49 552 Capp St 1 1 1 1     7 Width 3ft   6007244.98796 2104086.07115 37.7578289967226 -122.417962880381 (37.7578289967226, -122.417962880381)
163427 71380 2 49 1415 Lane St 1 1 1 1 1 05/21/1988 12:00:00 AM 7     6015545.815 2094978.0232 37.7332838660921 -122.388619133184 (37.7332838660921, -122.388619133184)
164431 207539 2 49 1216 Arguello Blvd 1 1 1 1     7 Width 3ft   5995838.12242 2107108.03274 37.7654779429827 -122.457630976687 (37.7654779429827, -122.457630976687)
164622 47462 1 49 1818 Baker St 2 1 1 1 1 05/14/2002 12:00:00 AM 7   Permit Number 45366 6000023.68636 2115243.51305 37.788055445440996 -122.443738626559 (37.788055445441, -122.443738626559)
165802 63192 1 49 439 38th Ave 1 1 1 1 1 08/25/2001 12:00:00 AM 7   Permit Number 33572 5984052.00356 2112858.1902400004 37.78058213076871 -122.49882069014099 (37.7805821307687, -122.498820690141)
166529 224057 2 49 4677 18th St 1 1 1 1     7 Width 3ft   6000058.79012 2105152.70486 37.7603506471783 -122.442892265582 (37.7603506471783, -122.442892265582)
167242 224080 2 49 68 Potomac St 1 1 1 1     7 Width 3ft   6003118.91153 2108722.42334 37.7703262160109 -122.432563724544 (37.7703262160109, -122.432563724544)
170806 244883 2 49 1395 Page St 1 1 1 1     7 Width 0ft   5999962.5746 2109158.9845 37.7713454052089 -122.443512818846 (37.7713454052089, -122.443512818846)
171078 122259 2 49 1300 Clement St 4 1 1 1     7 Width 3ft   5991408.07058 2113443.99656 37.7826193002424 -122.47341554338499 (37.7826193002424, -122.473415543385)
172122 207618 2 49 720 Head St 1 4 1 1     7 Width 3ft   5993529.31712 2090633.6912900002 37.720110655762 -122.464420306879 (37.720110655762, -122.464420306879)
179999 246031 2 49 632 Ashbury St 1 1 1 1     7 Width 0ft   5999010.3999 2108524.1023 37.7695478312752 -122.446760732499 (37.7695478312752, -122.446760732499)
180689 223585 2 49 490 Tompkins Ave 2 1 1 1     7 Width 4ft   6007537.470430001 2096557.5689 37.7371738787611 -122.41641810052099 (37.7371738787611, -122.416418100521)
181202 200709 2 49 1399 Lane St 2 1 1 1     7 Width 0ft   6015661.7831 2095130.2658 37.7337083198644 -122.388228817428 (37.7337083198644, -122.388228817428)
182554 126550 2 49 953 Sansome St 1 1 1 1     7 Width 3ft   6012056.66231 2118852.08433 37.79864269176171 -122.402360227452 (37.7986426917617, -122.402360227452)
187607 223555 2 49 700 Andover St 1 1 1 1     7 Width 3ft   6007416.45129 2095644.8678700002 37.7346609957998 -122.416771878526 (37.7346609957998, -122.416771878526)
Powered by Datasette · Query took 10.069ms · Data source: data.sfgov.org