sf-trees

Data source: data.sfgov.org

Custom SQL query returning 69 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
18412 247322 2 54 218 Pierce St 4 1 1 1       Width 0ft   6002795.6845 2109344.9924 37.7720173021936 -122.433726268045 (37.7720173021936, -122.433726268045)
79062 33409 1 54 100 Ulloa St 4 1 1 1 1 11/19/1996 12:00:00 AM     Permit Number 37523 5996457.34152631 2099451.4193202 37.7444903608651 -122.454935970247 (37.7444903608651, -122.454935970247)
80039 114619 2 54 2400X Post St 4 1 1 1           6000387.7 2114050.6 37.7848007706075 -122.442393531976 (37.7848007706075, -122.442393531976)
83697 108792 1 54 201-299 University St 4 1 1 1 1         6008053.41125 2093004.09823 37.727445818429295 -122.414382893832 (37.7274458184293, -122.414382893832)
85903 105084 6 54 344 Fulton St 4 7 1 1           6006101.8 2111789.5 37.778916373563206 -122.42246386857201 (37.7789163735632, -122.422463868572)
89025 36518 1 54 430 Crescent Ave 4 1 1 1 1 05/18/1998 12:00:00 AM     Permit Number 39394 6007460.82693634 2095697.00770714 37.7348066562255 -122.416622148824 (37.7348066562255, -122.416622148824)
92935 104156 1 54 525X Church St 4 1 2 4 4     5x20   6004243.11162 2105844.84418 37.7624887647889 -122.428469979895 (37.7624887647889, -122.428469979895)
95183 116324 2 54 1400X Potrero Ave 4 1 1 3           6010648.284969999 2101378.4314900003 37.7505853701643 -122.40600205927099 (37.7505853701643, -122.406002059271)
101816 31149 1 54 500 Hearst Ave 4 1 1 1 1 03/21/1995 12:00:00 AM     Permit Number 34853 5998089.630643 2094417.27408922 37.730761307799504 -122.44892931603 (37.7307613077995, -122.44892931603)
102292 33205 1 54 80 Ulloa St 4 1 1 1   11/06/1996 12:00:00 AM     Permit Number 37408 5996508.84910838 2099508.74034148 37.74465070488021 -122.454762009134 (37.7446507048802, -122.454762009134)
106819 105042 1 54 2660 Harrison St 4 5 2 1       2x10   6008868.4 2102978.1 37.7548779915591 -122.412270115586 (37.7548779915591, -122.412270115586)
107142 108804 2 54 401-499 University St 4 1 1 1           6008323.152369999 2092121.01007 37.7250361958168 -122.413387969207 (37.7250361958168, -122.413387969207)
115960 38111 1 54 1296 29th Ave 4 1 1 1 1 07/13/1998 12:00:00 AM     Permit Number 40278 5987114.66231835 2106457.26685396 37.763186144894 -122.48775523264901 (37.763186144894, -122.487755232649)
117089 116277 2 54 700X Greenwich St 4 1 1 3           6009521.9 2120182.3 37.8021533125646 -122.41122536090799 (37.8021533125646, -122.411225360908)
117839 106461 2 54 701 Cortland Ave 4 1 1 2           6007932.0 2097222.5 37.739021812259104 -122.415101080128 (37.7390218122591, -122.415101080128)
122059 108765 2 54 500X Lathrop Ave 4 1 1 1 1         6012750.2 2086624.6 37.7101917236901 -122.397698699654 (37.7101917236901, -122.397698699654)
126640 108797 2 54 501-599 University St 4 1 1 1           6008503.45306 2091469.8325200002 37.7232583218261 -122.412718672961 (37.7232583218261, -122.412718672961)
138290 39089 1 54 3140102 21st St 4 1 1 1 1 11/18/1998 12:00:00 AM     Permit Number 40782 6007340.78433039 2103849.3427132 37.757184385901496 -122.41761479761601 (37.7571843859015, -122.417614797616)
142035 31191 1 54 744 Shields St 4 1 1 1 1 03/21/1995 12:00:00 AM     Permit Number 34885 5992088.16257343 2089881.74957895 37.7179628280945 -122.469347142572 (37.7179628280945, -122.469347142572)
144770 115064 3 54 70 Coral Rd 4 1 1 2           6012676.36761 2102522.24683 37.7538392609312 -122.39906901845501 (37.7538392609312, -122.399069018455)
145417 115870 2 54 84X Cordova St 4 1 1 1         on Athens St. Frontage 6001679.7 2087642.4 37.712363687575795 -122.43603329568501 (37.7123636875758, -122.436033295685)
28842 244343 2 54 462 Steiner St 4 1 1 1     0 Width 0ft   6003204.9743 2109911.1218 37.7735949699184 -122.432350944562 (37.7735949699184, -122.432350944562)
30926 245835 2 54 451 Fell St 4 1 1 1     0 Width 0ft   6005269.6444 2110584.5711 37.7755609539167 -122.42525686469999 (37.7755609539167, -122.4252568647)
33492 185808 2 54 1655 21st Ave 4 1 1 1     0 Width 0ft   5989755.3501 2101698.7532 37.7502742090567 -122.478274123288 (37.7502742090567, -122.478274123288)
33830 244279 2 54 585 Oak St 4 1 1 1     0 Width 0ft   6004230.7823 2110095.8419999997 37.7741602789386 -122.42881569121799 (37.7741602789386, -122.428815691218)
35127 185838 2 54 2000 35th Ave 4 2 1 1     0 Width 0ft   5985430.142000001 2101125.3499 37.7484477718341 -122.493188522588 (37.7484477718341, -122.493188522588)
35957 183110 2 54 3474 Santiago St 4 1 1 1     0 Width 0ft   5982112.0542 2099478.6077 37.7437316497768 -122.504540222201 (37.7437316497768, -122.504540222201)
36535 139766 2 54 1308 Laguna St 4 1 1 1     0 Width 0ft   6004662.1567 2113418.8231 37.7833087728144 -122.427560280444 (37.7833087728144, -122.427560280444)
37787 184683 2 54 3343 Lawton St 4 1 1 1     0 Width 0ft   5983825.9671 2104243.1006 37.7569142945607 -122.498965955362 (37.7569142945607, -122.498965955362)
43147 138988 2 54 661 FILLMORE ST 4 1 1 1     0 Width 0ft   6003478.1301 2110687.6732 37.775742673405205 -122.43146150530701 (37.7757426734052, -122.431461505307)
44559 141411 2 54 530 IVY ST 4 1 1 1     0 Width 0ft   6004748.0909 2111070.6139 37.776866029844996 -122.42709567230601 (37.776866029845, -122.427095672306)
48216 142535 2 54 2100 POWELL ST 4 1 1 1     0 Width 0ft   6009442.0785 2120948.1005 37.8042515332642 -122.411555719808 (37.8042515332642, -122.411555719808)
51060 183255 2 54 1300 La Playa 4 1 1 1     0 Width 0ft   5980911.3073 2106159.7216 37.762005388573606 -122.509188082818 (37.7620053885736, -122.509188082818)
52327 139022 2 54 2557 SUTTER ST 4 1 1 1     0 Width 0ft   6000419.2522 2114077.8239 37.784877318741 -122.44228632704201 (37.784877318741, -122.442286327042)
58153 184163 2 54 3544 Lawton St 4 2 1 1     0 Width 0ft   5983184.3019 2104274.4825 37.756962801278206 -122.501187358865 (37.7569628012782, -122.501187358865)
64050 139028 2 54 2501 SUTTER ST 4 1 1 1     0 Width 0ft   6000547.3036 2114093.8303 37.7849285655089 -122.44184446112301 (37.7849285655089, -122.441844461123)
67598 183656 2 54 4000 Kirkham St 4 1 1 1     0 Width 0ft   5982355.2044 2104927.0637 37.758705882923 -122.50410297872801 (37.758705882923, -122.504102978728)
68816 140401 2 54 650 WILLOW ST 4 1 1 1     0 Width 0ft   6004290.5512 2113088.0425 37.7823795059387 -122.428822298842 (37.7823795059387, -122.428822298842)
71462 183935 2 54 2101 24th Ave 4 1 1 1     0 Width 0ft   5988808.3679 2100849.1108 37.747886298336205 -122.481486593386 (37.7478862983362, -122.481486593386)
73182 245418 2 54 2761 24th St 4 1 1 1     0 Width 0ft   6010213.0571 2102206.4482 37.7528345690624 -122.407565491585 (37.7528345690624, -122.407565491585)
73932 245458 2 54 2800 16th St 4 1 1 1     0 Width 0ft   6007840.6133 2106809.0367 37.765339135235706 -122.416095791627 (37.7653391352357, -122.416095791627)
74439 187452 2 54 5098 Mission St 4 2 1 1     0 Width 0ft   6000296.2838 2089278.8073 37.7167782039769 -122.440932105905 (37.7167782039769, -122.440932105905)
76338 184424 2 54 3735 Quintara St 4 1 1 1     0 Width 0ft   5981804.597999999 2100770.5329 37.7472608268582 -122.50569906643601 (37.7472608268582, -122.505699066436)
76975 184546 2 54 3445 Moraga St 4 1 1 1     0 Width 0ft   5983564.2693 2103555.7588 37.7550116923713 -122.499820187022 (37.7550116923713, -122.499820187022)
77189 181710 2 54 3335 Lincoln Way 4 1 1 1     0 Width 0ft   5985330.8116 2107013.2752 37.764608577957794 -122.49396586585699 (37.7646085779578, -122.493965865857)
132369 181641 2 54 2520 Irving St 4 1 1 1     0 Width 0ft   5987893.3386 2106475.9106 37.7632827235336 -122.48506345305599 (37.7632827235336, -122.485063453056)
135552 140125 2 54 1321 Divisadero St 4 1 1 1     0 Width 0ft   6001271.8045 2112891.6174 37.7816688523257 -122.43925172679899 (37.7816688523257, -122.439251726799)
150168 182323 2 54 2931 Kirkham St 4 1 1 1     0 Width 0ft   5985702.3126 2104987.9378 37.7590692943081 -122.49253179470502 (37.7590692943081, -122.492531794705)
158309 142169 2 54 1477 GROVE ST 4 1 1 1     0 Width 0ft   6000761.182999999 2110657.0332 37.7755041822084 -122.4408578836 (37.7755041822084, -122.4408578836)
163559 182217 2 54 2998 Lawton St 4 2 1 1     0 Width 0ft   5985040.9971 2104340.2555 37.7572522503219 -122.49477115168999 (37.7572522503219, -122.49477115169)
168900 139031 2 54 1535 Broderick St 4 1 1 1     0 Width 0ft   6000623.856000001 2114017.2778 37.784722733809 -122.441574119703 (37.784722733809, -122.441574119703)
169071 185826 2 54 2031 34th Ave 4 1 1 1     0 Width 0ft   5985688.7443 2101349.2146 37.7490775651475 -122.492310775953 (37.7490775651475, -122.492310775953)
169590 244368 2 54 301 Octavia St 4 1 1 1     0 Width 0ft   6005522.1928 2110360.9128 37.7749611068256 -122.424367326274 (37.7749611068256, -122.424367326274)
170361 246200 2 54 737 Buena Vista Ave West 4 1 1 1     0 Width 0ft   5999871.6458 2107989.0034 37.7681277455177 -122.443743277143 (37.7681277455177, -122.443743277143)
176249 184692 2 54 3545 Lawton St 4 1 1 1     0 Width 0ft   5983219.9396 2104221.872 37.7568204402945 -122.50106022131 (37.7568204402945, -122.50106022131)
180411 139043 2 54 1434 BAKER ST 4 1 1 1     0 Width 0ft   6000190.2907 2114006.1429 37.7846674491742 -122.443073307519 (37.7846674491742, -122.443073307519)
184510 244966 2 54 250 Lily St 4 1 1 1     0 Width 0ft   6005265.6412 2110100.505 37.7742315998648 -122.42523625993401 (37.7742315998648, -122.425236259934)
185965 140443 2 54 1101 FILLMORE ST 4 1 1 1     0 Width 0ft   6003331.4074 2112177.9445 37.7798262712775 -122.432075500833 (37.7798262712775, -122.432075500833)
186300 183883 2 54 2130 24th Ave 4 2 1 1     0 Width 0ft   5988850.4477 2100968.5581 37.7482167156371 -122.481349831083 (37.7482167156371, -122.481349831083)
187636 183293 2 54 1286 42nd Ave 4 2 1 1     0 Width 0ft   5983075.6533 2106421.6609 37.76285196523921 -122.50172195396401 (37.7628519652392, -122.501721953964)
1389 251532 1 54 2100X 20th St 4 1 2 1   05/15/2017 12:00:00 AM 3 4x11            
10093 173849 1 54 450 Toland St 4 1 2 1   01/27/2017 12:00:00 AM 3 17.6x4   6012768.71675 2099101.44192 37.74445161113729 -122.39850962968201 (37.7444516111373, -122.398509629682)
55449 183888 2 54 1390 Quintara St 4 2 1 1     3 Width 0ft   5988941.521000001 2101013.106 37.7483443270077 -122.48103816738501 (37.7483443270077, -122.481038167385)
77586 121129 2 54 201 Bemis St 4 1 1 1   09/09/2016 12:00:00 AM 3 3x3   6003216.0 2096386.0 37.7364588227531 -122.431347141396 (37.7364588227531, -122.431347141396)
97307 109345 1 54 3211 Baker St 4 9 2 1   02/11/2015 12:00:00 AM 3 8.75x13   5999315.1 2119860.5 37.8006920253414 -122.446522498385 (37.8006920253414, -122.446522498385)
101195 115894 1 54 1900X Kirkham St 4 1 1 1   03/02/2016 12:00:00 AM 3     5988841.66469 2105121.6083400003 37.75961937033 -122.48168434385401 (37.75961937033, -122.481684343854)
112218 109536 1 54 1234 Filbert St 4 5 2 1 1 02/23/2015 12:00:00 AM 3 1.5x2.4   6007007.9 2119506.8 37.800157248198296 -122.419877066677 (37.8001572481983, -122.419877066677)
124298 109367 1 54 1205 Filbert St 4 1 2 1 1 02/11/2015 12:00:00 AM 3 4.5x6.5   6007075.4 2119431.2 37.7999534721279 -122.419638123127 (37.7999534721279, -122.419638123127)
45274 246179 2 54 1588 Waller St 4 1 1 1     4 Width 0ft   5997977.1471 2108227.9355 37.768675553750796 -122.45031334601101 (37.7686755537508, -122.450313346011)
Powered by Datasette · Query took 8.786ms · Data source: data.sfgov.org