sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
36940 233930 2 100 451 Florida St 5 9 1 1     38 Width 9ft   6009251.7265800005 2106253.20346 37.763892184592706 -122.41117579493 (37.7638921845927, -122.41117579493)
39479 234374 2 100 581 Dolores St 4 1 1 1     15 Width 9ft   6004996.87402 2105008.5457599997 37.760235113069896 -122.425803460464 (37.7602351130699, -122.425803460464)
64753 233931 2 100 451 Florida St 6 9 1 1     22 Width 9ft   6009251.45318 2106264.05651 37.763921969247704 -122.411177507234 (37.7639219692477, -122.411177507234)
159189 234375 2 100 581 Dolores St 5 1 1 1     12 Width 9ft   6004995.06327 2105009.72546 37.760238249920604 -122.425809806971 (37.7602382499206, -122.425809806971)
168179 119407 2 100 375 32nd Ave 10 9 1 1     26 Width 9ft   5985884.85714 2113320.57304 37.78195903231371 -122.49251412874399 (37.7819590323137, -122.492514128744)
179975 234373 2 100 581 Dolores St 3 1 1 1     3 Width 9ft   6004999.25531 2105001.6441599997 37.76021629747461 -122.42579473344401 (37.7602162974746, -122.425794733444)
608 233928 2 100 8 Octavia St Frontage East 1 2 1 1     29 Width 8ft   6005775.18179 2109348.30824 37.77219502161479 -122.423420179704 (37.7721950216148, -122.423420179704)
25236 194362 3 100 380x The Embarcadero 9 3 1 2     29 Width 8ft   6016123.073030001 2114362.8388099996 37.786542411639 -122.38797559828899 (37.786542411639, -122.387975598289)
25996 194361 3 100 380x The Embarcadero 8 3 1 2     28 Width 8ft   6016114.70966 2114269.45463 37.786285536482296 -122.38799801482 (37.7862855364823, -122.38799801482)
27329 194334 3 100 88x King St 10 3 1 2     30 Width 8ft   6015942.04821 2112270.67914 37.7807877820727 -122.388455820993 (37.7807877820727, -122.388455820993)
29064 194335 3 100 88x King St 11 3 1 2     30 Width 8ft   6015932.5598 2112347.87113 37.7809992081901 -122.38849403588999 (37.7809992081901, -122.38849403589)
29492 194379 3 100 300x The Embarcadero 2 3 1 2     30 Width 8ft   6015888.45756 2115624.95631 37.7899948982019 -122.388875463533 (37.7899948982019, -122.388875463533)
30590 118002 2 100 7 Shore View Ave 2 2 1 1     5 Width 8ft   5984637.38492 2112844.95185 37.780580098776795 -122.49679463074699 (37.7805800987768, -122.496794630747)
33192 194377 3 100 310x The Embarcadero 14 3 1 2     28 Width 8ft   6016027.16358 2115370.7776 37.789304668530896 -122.388377800289 (37.7893046685309, -122.388377800289)
35368 194364 3 100 310x The Embarcadero 1 3 1 2     30 Width 8ft   6016200.86003 2114659.13107 37.78736027221179 -122.387727152497 (37.7873602722118, -122.387727152497)
35716 194337 3 100 88x King St 13 3 1 2     29 Width 8ft   6015953.29851 2112409.5704799998 37.781169770014294 -122.38842659752198 (37.7811697700143, -122.388426597522)
42530 194380 3 100 300x The Embarcadero 3 3 1 2     30 Width 8ft   6015792.97899 2115653.31942 37.79006748427221 -122.38920779542102 (37.7900674842722, -122.389207795421)
42729 194375 3 100 310x The Embarcadero 12 3 1 2     27 Width 8ft   6016059.60857 2115304.2736400003 37.7891238616108 -122.388260900137 (37.7891238616108, -122.388260900137)
43461 194341 3 100 418x The Embarcadero 1 3 1 2     25 Width 8ft   6016036.61123 2112738.53497 37.7820776491035 -122.388161338867 (37.7820776491035, -122.388161338867)
45534 124659 2 100 199 Arguello Blvd 1 1 1 1     37 Width 8ft   5995478.86593 2115238.56038 37.7877815776324 -122.45946244145901 (37.7877815776324, -122.459462441459)
46468 194330 3 100 88x King St 6 3 1 2     32 Width 8ft   6015863.586519999 2112149.96757 37.780451986896296 -122.38871883132 (37.7804519868963, -122.38871883132)
48046 194385 3 100 300x The Embarcadero 8 3 1 2     26 Width 8ft   6015616.39603 2115848.18198 37.7905927414207 -122.38983237995701 (37.7905927414207, -122.389832379957)
51725 194333 3 100 88x King St 9 3 1 2     31 Width 8ft   6015903.377169999 2112286.3418900003 37.78082864545979 -122.38859069771999 (37.7808286454598, -122.38859069772)
53093 194359 3 100 380x The Embarcadero 6 3 1 2     33 Width 8ft   6016151.3585 2114078.17293 37.785762350501706 -122.38785786627199 (37.7857623505017, -122.387857866272)
55101 194331 3 100 88x King St 7 3 1 2     30 Width 8ft   6015869.7392 2112229.4323400003 37.7806705203569 -122.388703094985 (37.7806705203569, -122.388703094985)
55186 194332 3 100 88x King St 8 3 1 2     33 Width 8ft   6015905.66871 2112206.70701 37.7806101129033 -122.38857720969601 (37.7806101129033, -122.388577209696)
56517 194347 3 100 418x The Embarcadero 7 3 1 2     32 Width 8ft   6016017.18881 2113128.44937 37.783147190320896 -122.388255753298 (37.7831471903209, -122.388255753298)
58200 246535 3 100 1x Octavia St 1 3 1 2     29 Width 8ft   6005703.308569999 2109325.61851 37.7721286642513 -122.423667182089 (37.7721286642513, -122.423667182089)
59677 194329 3 100 88x King St 5 3 1 2     29 Width 8ft   6015829.09984 2112179.7817 37.7805319384279 -122.388840220015 (37.7805319384279, -122.388840220015)
61273 194336 3 100 88x King St 12 3 1 2     30 Width 8ft   6015966.10007 2112335.54697 37.7809672274079 -122.38837714201799 (37.7809672274079, -122.388377142018)
61369 194368 3 100 310x The Embarcadero 5 3 1 2     29 Width 8ft   6016180.02295 2114964.39899 37.7881973143891 -122.38782055336901 (37.7881973143891, -122.387820553369)
63682 194360 3 100 380x The Embarcadero 7 3 1 2     28 Width 8ft   6016108.030590001 2114179.2623099997 37.786037518748 -122.388014826737 (37.786037518748, -122.388014826737)
66121 194352 3 100 418x The Embarcadero 12 3 1 2     28 Width 8ft   6016055.63748 2113520.42583 37.7842255997618 -122.388150099168 (37.7842255997618, -122.388150099168)
69876 194371 3 100 310x The Embarcadero 8 3 1 2     30 Width 8ft   6016101.395269999 2115134.80634 37.7886608582508 -122.388104490939 (37.7886608582508, -122.388104490939)
70483 194365 3 100 310x The Embarcadero 2 3 1 2     30 Width 8ft   6016199.77941 2114766.14566 37.7876540501504 -122.38773836074199 (37.7876540501504, -122.387738360742)
71598 194349 3 100 418x The Embarcadero 9 3 1 2     25 Width 8ft   6016039.59045 2113336.99155 37.7837210414445 -122.388192810667 (37.7837210414445, -122.388192810667)
76413 194348 3 100 418x The Embarcadero 8 3 1 2     32 Width 8ft   6016063.83562 2113121.68463 37.783131200395296 -122.388093900527 (37.7831312003953, -122.388093900527)
76527 194370 3 100 310x The Embarcadero 7 3 1 2     28 Width 8ft   6016163.96985 2115051.82185 37.788436468407 -122.387882197423 (37.788436468407, -122.387882197423)
119303 194372 3 100 310x The Embarcadero 9 3 1 2     30 Width 8ft   6016142.80175 2115153.3259099997 37.788714002784296 -122.387962522166 (37.7887140027843, -122.387962522166)
127243 194363 3 100 380x The Embarcadero 10 3 1 2     27 Width 8ft   6016134.25394 2114462.08003 37.7868155249754 -122.387943842344 (37.7868155249754, -122.387943842344)
130206 194374 3 100 310x The Embarcadero 11 3 1 2     28 Width 8ft   6016126.62936 2115234.83636 37.788936915964705 -122.388024167087 (37.7889369159647, -122.388024167087)
130277 194351 3 100 418x The Embarcadero 11 3 1 2     31 Width 8ft   6016097.15673 2113420.59165 37.7839537779004 -122.387999487006 (37.7839537779004, -122.387999487006)
130735 194346 3 100 418x The Embarcadero 6 3 1 2     30 Width 8ft   6016057.40985 2113028.64004 37.782875364847705 -122.388109635977 (37.7828753648477, -122.388109635977)
134092 194378 3 100 300x The Embarcadero 1 3 1 2     27 Width 8ft   6015852.133669999 2115594.9283 37.7899104347693 -122.388999044794 (37.7899104347693, -122.388999044794)
135215 194383 3 100 300x The Embarcadero 6 3 1 2     29 Width 8ft   6015768.92359 2115752.8180400003 37.7903393511162 -122.389297976729 (37.7903393511162, -122.389297976729)
137727 246536 3 100 1x Octavia St 2 3 1 2     31 Width 8ft   6005696.49055 2109344.97624 37.7721814310539 -122.42369214280501 (37.7721814310539, -122.423692142805)
138222 194356 3 100 380x The Embarcadero 3 3 1 2     28 Width 8ft   6016092.96172 2113985.53296 37.7855047469016 -122.38805343733401 (37.7855047469016, -122.388053437334)
147393 194355 3 100 380x The Embarcadero 2 3 1 2     28 Width 8ft   6016135.3126300005 2113894.74213 37.785257802049706 -122.38790057687001 (37.7852578020497, -122.38790057687)
148681 194369 3 100 310x The Embarcadero 6 3 1 2     26 Width 8ft   6016121.084980001 2115040.32123 37.7884025145026 -122.388029770758 (37.7884025145026, -122.388029770758)
152768 194354 3 100 380x The Embarcadero 1 3 1 2     27 Width 8ft   6016129.928040001 2113821.08982 37.7850552711313 -122.387914064893 (37.7850552711313, -122.387914064893)
152917 194273 3 100 1150x Tennessee St 16 3 1 2     20 Width 8ft   6015573.17514 2103426.7647700002 37.7564838780418 -122.38911425333 (37.7564838780418, -122.38911425333)
153149 194381 3 100 300x The Embarcadero 4 3 1 2     28 Width 8ft   6015827.50848 2115690.11268 37.79017042428 -122.389090895237 (37.79017042428, -122.389090895237)
153572 194344 3 100 418x The Embarcadero 4 3 1 2     28 Width 8ft   6016049.59347 2112931.0937900003 37.7826070916921 -122.38812986802 (37.7826070916921, -122.38812986802)
154122 194384 3 100 300x The Embarcadero 7 3 1 2     27 Width 8ft   6015676.83265 2115781.59367 37.7904132565166 -122.38961861831699 (37.7904132565166, -122.389618618317)
155383 194338 3 100 88x King St 14 3 1 2     30 Width 8ft   6015989.55415 2112403.0150099997 37.781153779156206 -122.388300712233 (37.7811537791562, -122.388300712233)
155521 194340 3 100 88x King St 16 3 1 2     26 Width 8ft   6015972.31673 2112547.01001 37.7815482020175 -122.388370398867 (37.7815482020175, -122.388370398867)
156409 194327 3 100 88x King St 3 3 1 2     25 Width 8ft   6015782.92624 2112129.67425 37.780391795274 -122.388996458319 (37.780391795274, -122.388996458319)
157962 194366 3 100 310x The Embarcadero 3 3 1 2     28 Width 8ft   6016195.859569999 2114866.22772 37.78792863564279 -122.387758908461 (37.7879286356428, -122.387758908461)
158245 194357 3 100 380x King St 4 3 1 2     28 Width 8ft   6016143.59514 2113983.21728 37.7855011936686 -122.387878097405 (37.7855011936686, -122.387878097405)
162596 194326 3 100 88x King St 2 3 1 2     30 Width 8ft   6015764.48229 2112042.08861 37.7801502823482 -122.38905414805599 (37.7801502823482, -122.389054148056)
163146 194345 3 100 418x The Embarcadero 5 3 1 2     28 Width 8ft   6016011.38638 2113034.09815 37.7828878015789 -122.388269240457 (37.7828878015789, -122.388269240457)
164090 194328 3 100 88x King St 4 3 1 2     32 Width 8ft   6015816.38649 2112097.21372 37.7803045205874 -122.388878435804 (37.7803045205874, -122.388878435804)
164799 194376 3 100 310x The Embarcadero 13 3 1 2     28 Width 8ft   6016101.40226 2115318.33028 37.789164773592205 -122.38811727930201 (37.7891647735922, -122.388117279302)
168401 194350 3 100 418x The Embarcadero 10 3 1 2     29 Width 8ft   6016048.53605 2113426.10211 37.7839662146185 -122.388168082915 (37.7839662146185, -122.388168082915)
168851 194325 2 100 88 King St 1 4 1 1     31 Width 8ft   6015700.5691599995 2111985.57661 37.779991570003205 -122.38927130734601 (37.7799915700032, -122.389271307346)
170290 194382 3 100 300x The Embarcadero 5 3 1 2     28 Width 8ft   6015730.53426 2115716.1031299997 37.7902364120368 -122.389428237241 (37.7902364120368, -122.389428237241)
173116 194373 3 100 310x The Embarcadero 10 3 1 2     29 Width 8ft   6016083.2484800005 2115225.4963700003 37.7889088670017 -122.38817360834 (37.7889088670017, -122.38817360834)
173586 194339 3 100 88x King St 15 3 1 2     21 Width 8ft   6015964.49017 2112481.16819 37.781366981449295 -122.388392878343 (37.7813669814493, -122.388392878343)
178718 194367 3 100 310x The Embarcadero 4 3 1 2     32 Width 8ft   6016138.88729 2114959.31506 37.7881810762396 -122.38796252216999 (37.7881810762396, -122.38796252217)
182277 194342 3 100 418x The Embarcadero 2 3 1 2     26 Width 8ft   6016043.56926 2112825.74631 37.7823174973895 -122.38814335514999 (37.7823174973895, -122.38814335515)
182585 194343 3 100 418x The Embarcadero 3 3 1 2     29 Width 8ft   6016001.634319999 2112937.23784 37.7826213045779 -122.38829621649799 (37.7826213045779, -122.388296216498)
182808 194353 3 100 418x The Embarcadero 13 3 1 2     26 Width 8ft   6016057.99648 2113605.1395799997 37.7844583353237 -122.388147851742 (37.7844583353237, -122.388147851742)
183458 194358 3 100 380x The Embarcadero 5 3 1 2     30 Width 8ft   6016102.75205 2114084.3299 37.7857765633769 -122.388026462162 (37.7857765633769, -122.388026462162)
25380 124656 2 100 1 Presidio Ter 1 2 1 1     24 Width 7ft   5995441.43994 2115441.36584 37.7883362746058 -122.45960662195401 (37.7883362746058, -122.459606621954)
26160 194311 3 100 380x The Embarcadero 3 3 1 2     21 Width 7ft   6015171.2298099995 2116694.38601 37.79289152546961 -122.39143182424401 (37.7928915254696, -122.391431824244)
41054 194324 3 100 400x The Embarcadero 5 3 1 2     18 Width 7ft   6014719.872819999 2117222.0655900002 37.7943153492131 -122.39303049145701 (37.7943153492131, -122.393030491457)
56280 194309 2 100 380 The Embarcadero 1 4 1 1     24 Width 7ft   6015233.93882 2116624.33128 37.79270265166021 -122.39120994708 (37.7927026516602, -122.39120994708)
70019 194312 3 100 380x The Embarcadero 4 3 1 2     25 Width 7ft   6015090.90053 2116737.38808 37.7930051404365 -122.391712777831 (37.7930051404365, -122.391712777831)
72003 194321 3 100 400x The Embarcadero 2 3 1 2     22 Width 7ft   6014800.62587 2117118.44333 37.794035312034104 -122.392743821769 (37.7940353120341, -122.392743821769)
131405 194320 3 100 400x The Embarcadero 1 3 1 2     23 Width 7ft   6014831.89764 2117081.36813 37.7939352489635 -122.392633022622 (37.7939352489635, -122.392633022622)
133391 194310 3 100 380x The Embarcadero 2 3 1 2     20 Width 7ft   6015149.43028 2116672.0498900004 37.7928289857212 -122.39150569005301 (37.7928289857212, -122.391505690053)
136668 194314 3 100 380x The Embarcadero 6 3 1 2     20 Width 7ft   6015030.092180001 2116803.1524 37.793182338337296 -122.39192778056601 (37.7931823383373, -122.391927780566)
137503 234343 2 100 769 Dolores St 2 1 1 1     3 Width 7ft   6005056.066269999 2103868.0427200003 37.7571069049763 -122.42551757317601 (37.7571069049763, -122.425517573176)
152011 194318 3 100 380x The Embarcadero 10 3 1 2     24 Width 7ft   6014918.376630001 2116934.10067 37.7935356891802 -122.392323489462 (37.7935356891802, -122.392323489462)
160227 194315 3 100 380x The Embarcadero 7 3 1 2     20 Width 7ft   6015053.743430001 2116822.79374 37.793237581902105 -122.391847319118 (37.7932375819021, -122.391847319118)
162235 194317 3 100 380x The Embarcadero 9 3 1 2     22 Width 7ft   6014996.79198 2116890.75749 37.7934210328094 -122.392049131461 (37.7934210328094, -122.392049131461)
171516 194323 3 100 400x The Embarcadero 4 3 1 2     15 Width 7ft   6014746.37404 2117187.8708099998 37.7942229303951 -122.39293639989201 (37.7942229303951, -122.392936399892)
174052 194319 3 100 380x The Embarcadero 11 3 1 2     19 Width 7ft   6014937.91263 2116957.6212 37.793601355862705 -122.392257538577 (37.7936013558627, -122.392257538577)
179136 124657 2 100 30 Presidio Ter 1 2 1 1     30 Width 7ft   5995444.46973 2115398.79213 37.7882195529326 -122.459593054716 (37.7882195529326, -122.459593054716)
182110 194322 3 100 400x The Embarcadero 3 3 1 2     22 Width 7ft   6014773.3420400005 2117151.64182 37.7941249519603 -122.392840551058 (37.7941249519603, -122.392840551058)
183295 194277 2 100 1301 Rhode Island St 1 2 1 1     48 Width 7ft   6012002.23785 2102241.02504 37.7530294975215 -122.401380567153 (37.7530294975215, -122.401380567153)
185824 234392 2 100 1379 Dolores St 2 1 1 1     8 Width 7ft   6005257.78896 2100266.47383 37.7472292273428 -122.424563754022 (37.7472292273428, -122.424563754022)
186747 194316 3 100 380x The Embarcadero 8 3 1 2     26 Width 7ft   6014969.23068 2116866.2603700003 37.793352239169295 -122.392142782374 (37.7933522391693, -122.392142782374)
187874 194313 3 100 380x The Embarcadero 5 3 1 2     12 Width 7ft   6015116.8381 2116756.98357 37.793060384871 -122.391624402345 (37.793060384871, -122.391624402345)
23789 234390 2 100 1600 Dolores St 2 1 1 1     5 Width 6ft   6005245.617219999 2098983.50062 37.7437057887861 -122.42451459797199 (37.7437057887861, -122.424514597972)
39811 234396 2 100 1351 Douglass St 3 9 1 1     25 Width 6ft   6001401.68154 2099734.75899 37.74555073898829 -122.43785977451701 (37.7455507389883, -122.437859774517)
42292 234344 2 100 751 Dolores St 1 2 1 1     5 Width 6ft   6005051.924 2103931.9938 37.757282265587 -122.42553644996299 (37.757282265587, -122.425536449963)
54191 234389 2 100 1488 Dolores St 4 1 1 1     26 Width 6ft   6005200.95707 2099699.7446 37.7456699090375 -122.424719964457 (37.7456699090375, -122.424719964457)
72691 234342 2 100 500 Dolores St 27 2 1 1     35 Width 6ft   6004943.9168300005 2104413.64545 37.7585986644128 -122.425944266413 (37.7585986644128, -122.425944266413)
76588 247039 2 100 574 Valley St 1 2 1 1     33 Width 6ft   6002246.4280199995 2099186.76685 37.7440940809725 -122.43489959305 (37.7440940809725, -122.43489959305)
174857 234391 2 100 1600 Dolores St 3 1 1 1     5 Width 6ft   6005241.74432 2098978.16752 37.743690926593295 -122.424527610268 (37.7436909265933, -122.424527610268)
Powered by Datasette · Query took 5.822ms · Data source: data.sfgov.org