sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
65375 200196 2 59 1124 Fitzgerald Ave 2 2 1 1     20 Width 0ft   6015063.1024 2090263.455 37.720311838731 -122.38995879887301 (37.720311838731, -122.389958798873)
177466 32291 1 59 1400 Egbert Ave 2 1 1 1   08/15/1996 12:00:00 AM 7   Permit Number 36872 6014236.59 2091225.7906 37.722908348540294 -122.39288309530001 (37.7229083485403, -122.3928830953)
18821 25266 3 59 1738 Ocean Ave 2 1 1 2     13 3X3   5994668.335 2092363.0322 37.7249246023662 -122.460608386003 (37.7249246023662, -122.460608386003)
162336 217617 2 59 1830 Ocean Ave 2 1 1 1     12 Width 0ft   5994396.9504 2092455.3654 37.7251625099423 -122.46155321589701 (37.7251625099423, -122.461553215897)
36681 199730 2 59 1500 Armstrong Ave 2 1 1 1     7 Width 0ft   6014897.5638 2092133.7733 37.725438180339 -122.390661646389 (37.725438180339, -122.390661646389)
73307 199853 2 59 2503 Keith St 2 1 1 1     8 Width 0ft   6014209.1818 2092155.2364 37.7254588983374 -122.39304284056499 (37.7254588983374, -122.393042840565)
173135 199722 2 59 2300 Jennings St 2 1 1 1     9 Width 0ft   6015093.5789 2092222.3792 37.72569234746 -122.38999022091998 (37.72569234746, -122.38999022092)
65445 199741 2 59 2396 Keith St 2 1 1 1     6 Width 0ft   6014513.885 2092478.0086 37.7263620876399 -122.392012061617 (37.7263620876399, -122.392012061617)
61042 38609 1 59 1570 Revere Ave 2 1 1 1 1 05/15/2002 12:00:00 AM 6   Permit Number 45423 6015273.2073 2094293.4811 37.7313891398709 -122.38951383063 (37.7313891398709, -122.38951383063)
13740 97243 2 59 1300X Keith St 2 1 1 1     18 3x3   6016226.9194 2094855.7145 37.7329857540551 -122.38625582218701 (37.7329857540551, -122.386255822187)
4557 245383 3 59 3720 Mission St 2 1 1 2     14 Width 0ft   6005268.7499 2096538.92 37.7369948294896 -122.42426078327499 (37.7369948294896, -122.424260783275)
154252 245378 2 59 3550 Mission St 2 1 1 1     15 Width 0ft   6005581.5521 2097815.7311 37.7405183234498 -122.42327002037099 (37.7405183234498, -122.423270020371)
44905 182129 2 59 2650 Ulloa St 2 1 1 1     4 Width 0ft   5987716.6576 2098310.3756 37.740852067466506 -122.485075392772 (37.7408520674665, -122.485075392772)
41163 181854 2 59 2318 32nd Ave 2 2 1 1     6 Width 0ft   5986419.9945 2099457.4563 37.7439260290789 -122.48964304245001 (37.7439260290789, -122.48964304245)
148571 183823 2 59 2235 27th Ave 2 1 1 1     4 Width 0ft   5987905.9224 2100064.0482 37.7456782117444 -122.48454959408501 (37.7456782117444, -122.484549594085)
116559 113410 2 59 401x DUNCAN ST 2 1 1 1       3x3   6003916.0 2099815.0 37.745913716911 -122.429171370863 (37.745913716911, -122.429171370863)
92442 37059 1 59 1450 Sanchez St 2 1 1 1   06/01/1998 12:00:00 AM   3x3 Permit Number 39663 6003906.83973736 2099821.31146391 37.745930528166596 -122.429203495744 (37.7459305281666, -122.429203495744)
19398 547 3 59 2889 24th St 2 1 1 2     12 3X3   6009603.6887 2102171.1765 37.7527035922626 -122.409670319384 (37.7527035922626, -122.409670319384)
168438 245420 2 59 2855 24th St 2 1 1 1     18 Width 0ft   6009712.0846 2102179.2059 37.7527317128259 -122.409296032004 (37.7527317128259, -122.409296032004)
19043 533 3 59 2850 24th St 2 1 1 2     18 3X3   6009680.0053 2102218.3979 37.7528375279845 -122.409409734124 (37.7528375279845, -122.409409734124)
21990 528 1 59 2836 24th St 2 1 1 1     18 3X3   6009819.9871 2102225.5005 37.7528648722833 -122.408926150195 (37.7528648722833, -122.408926150195)
10079 492 3 59 2749X 24th St 2 1 1 2     12 3x3   6010397.1581 2102215.0511 37.752868494158704 -122.406929439613 (37.7528684941587, -122.406929439613)
188438 245412 2 59 2802 24th St 2 1 1 1     19 Width 0ft   6009963.8161 2102233.787 37.7528956807716 -122.408429345015 (37.7528956807716, -122.408429345015)
177119 245470 2 59 2700 24th St 2 1 1 1     21 Width 0ft   6010486.0542 2102262.08 37.753002599060295 -122.40662533272899 (37.7530025990603, -122.406625332729)
879 246305 3 59 2135 Mission St 2 1 1 2     18 Width 0ft   6006876.9266 2105933.3644 37.762880513109295 -122.41936683944401 (37.7628805131093, -122.419366839444)
228 246283 3 59 2125 Mission St 2 1 1 2     17 Width 0ft   6006872.377 2105970.5198 37.7629822769131 -122.419385210964 (37.7629822769131, -122.419385210964)
187140 183273 2 59 1251 40th Ave 2 1 1 1     12 Width 0ft   5983646.3542 2106625.2038 37.7634443416971 -122.49976317535801 (37.7634443416971, -122.499763175358)
26993 101263 1 59 2000 Irving St 2 1 1 1     12   Permit Number 20727 5989478.8752 2106534.6445 37.76353621964879 -122.479583963683 (37.7635362196488, -122.479583963683)
92566 113466 2 59 450 CHURCH ST 2 1 1 4       6x6   6004088.0 2106523.0 37.764342039298896 -122.429054808288 (37.7643420392989, -122.429054808288)
67589 181728 2 59 2755 29th Ave 2 1 1 1     5 Width 0ft   5987089.3098 2107026.595 37.7647478839827 -122.487884750055 (37.7647478839827, -122.487884750055)
157627 245462 2 59 2886 16th St 2 1 1 1     17 Width 0ft   6007544.8329 2106792.8686 37.7652781065022 -122.41711768386001 (37.7652781065022, -122.41711768386)
57912 200832 2 59 2000 16th St 2 1 1 1     8 Width 0ft   6010535.924 2106957.4024 37.7658976908793 -122.406783753376 (37.7658976908793, -122.406783753376)
165399 32294 1 59 1616 16th St 2 1 1 1   08/19/1996 12:00:00 AM 12   Permit Number 36875 6011626.7926 2107023.9767 37.7661414653506 -122.403015326989 (37.7661414653506, -122.403015326989)
177880 248404 2 59 1713 Waller St 2 1 1 1     11 Width 0ft   5997468.9999 2108115.1317 37.768336729240296 -122.452062838629 (37.7683367292403, -122.452062838629)
155231 246099 2 59 700 Stanyan St 2 1 1 1     14 Width 0ft   5997115.1441 2108154.4994 37.7684245472814 -122.453289628456 (37.7684245472814, -122.453289628456)
52969 248377 2 59 701 Cole St 2 1 1 1     19 Width 0ft   5997902.4997 2108143.1434 37.7684384639657 -122.45056543049401 (37.7684384639657, -122.450565430494)
153054 246152 2 59 1720 Waller St 2 1 1 1     14 Width 0ft   5997446.2877 2108155.2565 37.7684456006596 -122.45214429305 (37.7684456006596, -122.45214429305)
35119 248351 2 59 1587 Waller St 2 1 1 1     10 Width 0ft   5997991.38 2108188.2649 37.7685674429378 -122.450261255818 (37.7685674429378, -122.450261255818)
167539 248335 2 59 1559 Waller St 2 1 1 1     12 Width 0ft   5998127.3503 2108207.3431 37.768627607196 -122.449792323102 (37.768627607196, -122.449792323102)
177206 246136 2 59 1556 Waller St 2 1 1 1     16 Width 0ft   5998150.3653 2108253.3731 37.768755310607 -122.449716033907 (37.768755310607, -122.449716033907)
4243 246126 1 59 1546 Waller St 2 1 1 1     14 Width 0ft   5998264.228999999 2108270.3316 37.768808388052605 -122.449323411621 (37.7688083880526, -122.449323411621)
173043 248359 2 59 1485 Waller St 2 1 1 1     11 Width 0ft   5998647.9135 2108278.8108 37.768853609287206 -122.44799689076099 (37.7688536092872, -122.447996890761)
189100 246130 2 59 1486 Waller St 2 1 1 1     13 Width 0ft   5998621.8702 2108319.087 37.768962708792 -122.448089872703 (37.768962708792, -122.448089872703)
150342 246133 2 59 662 Clayton St 2 1 1 1     10 Width 0ft   5998546.7685 2108359.3633 37.7690690038469 -122.44835254426701 (37.7690690038469, -122.448352544267)
156171 246039 2 59 1378 Waller St 2 1 1 1     14 Width 0ft   5999138.4966 2108392.6745 37.7691942805388 -122.446308196721 (37.7691942805388, -122.446308196721)
72403 247348 2 59 1563 Page St 2 1 1 1     11 Width 0ft   5999102.728999999 2109036.7578 37.7709607271706 -122.44647825803001 (37.7709607271706, -122.44647825803)
73607 247258 2 59 2089 Oak St 2 1 1 1     8 Width 0ft   5997028.4355 2109091.0184 37.7709910168471 -122.453657177015 (37.7709910168471, -122.453657177015)
19705 17131 3 59 2001 Oak St 2 1 1 2     18 3x3   5997393.7333 2109140.5793 37.771148033222794 -122.452397184671 (37.7711480332228, -122.452397184671)
18301 17129 3 59 1999 Oak St 2 1 1 2     18 3X3   5997503.109 2109154.2513 37.7711918386222 -122.452019838592 (37.7711918386222, -122.452019838592)
19773 17120 1 59 1931 Oak St 2 1 1 1     18 3X3   5997753.4769 2109191.4219 37.7713082373467 -122.45115649157499 (37.7713082373467, -122.451156491575)
72703 244544 2 59 1921 Oak St 2 1 1 1     10 Width 0ft   5997795.9759 2109196.9758 37.7713259200895 -122.451009886929 (37.7713259200895, -122.451009886929)
21997 17116 1 59 1899 Oak St 2 1 1 1     12 3X3   5997981.6278 2109222.6111 37.771406934874896 -122.450369559944 (37.7714069348749, -122.450369559944)
22051 28786 1 59 800 Haight St 2 1 1 1     20 3X3   6002265.8749 2109178.7673 37.7715308120493 -122.43554702410299 (37.7715308120493, -122.435547024103)
18044 4510 3 59 1805X Oak St 2 1 1 2     18 3x3   5998343.9349 2109273.4537 37.7715672642721 -122.449119990901 (37.7715672642721, -122.449119990901)
186591 247390 2 59 217 Scott St 2 1 1 1     8 Width 0ft   6002281.8171 2109227.9509 37.7716667634841 -122.43549539828501 (37.7716667634841, -122.435495398285)
159801 247268 2 59 1621 Oak St 2 1 1 1     15 Width 0ft   5999221.2905 2109393.9379 37.77194822419221 -122.44609384766501 (37.7719482241922, -122.446093847665)
18829 14559 1 59 1595X Oak St 2 1 1 1     12 3x3   5999419.8987 2109421.3340000003 37.772034786606 -122.44540881989799 (37.772034786606, -122.445408819898)
21019 15299 3 59 1640 Mission St 2 1 1 2     12 3X3   6006975.8032 2109269.1574 37.7720453828325 -122.41926150288602 (37.7720453828325, -122.419261502886)
47829 245112 2 59 1511 Oak St 2 1 1 1     9 Width 0ft   5999762.5828 2109470.1939 37.7721884999222 -122.44422696449499 (37.7721884999222, -122.444226964495)
155471 247306 2 59 873 Page St 2 1 1 1     10 Width 0ft   6002371.1002 2109493.4114 37.772400722701796 -122.435205553676 (37.7724007227018, -122.435205553676)
151317 245078 2 59 1387 Oak St 2 1 1 1     13 Width 0ft   6000393.4407 2109556.4466 37.7724612989944 -122.442050971779 (37.7724612989944, -122.442050971779)
21314 17056 3 59 1285 Oak St 2 1 1 2     18 5x4.5   6000853.6213 2109624.5846 37.7726746024779 -122.44046405381799 (37.7726746024779, -122.440464053818)
185077 244147 2 59 405 Rose St 2 1 1 1     6 Width 0ft   6004529.1957 2109628.6007 37.772894233589795 -122.42775012801701 (37.7728942335898, -122.427750128017)
166183 140160 2 59 251 ASHBURY ST 2 1 1 1     14 Width 0ft   5998786.9251 2109803.6706 37.773048431195 -122.44762584345501 (37.773048431195, -122.447625843455)
171426 140142 2 59 208 Cole St 2 1 1 1     11 Width 0ft   5997849.5605 2109871.4122 37.773180816519606 -122.450873174815 (37.7731808165196, -122.450873174815)
2909 140144 1 59 2077 HAYES ST 2 1 1 1     9 Width 0ft   5997892.6775 2109904.5645 37.7732743123753 -122.450726418895 (37.7732743123753, -122.450726418895)
17687 9652 3 59 75 Gough St 2 1 1 2   01/07/1995 12:00:00 AM 3 2x3   6006083.2108 2109791.7339 37.773429942464205 -122.42238619158998 (37.7734299424642, -122.42238619159)
50203 247450 2 59 917 Oak St 2 1 1 1     6 Width 0ft   6002601.5894 2109867.0536 37.773439737619704 -122.43443498999599 (37.7734397376197, -122.434434989996)
17157 16991 3 59 899 Oak St 2 1 1 2     12 3x3   6002773.5007 2109890.2869 37.7735132873347 -122.433841985714 (37.7735132873347, -122.433841985714)
17284 16993 3 59 900 Oak St 2 1 1 2     18 3x3   6002625.7759 2109923.0859 37.7735949613156 -122.434355332323 (37.7735949613156, -122.434355332323)
18945 17664 3 59 892X Oak St 2 1 1 2     18 3X3   6002741.8184 2109937.0039 37.773639762745 -122.433954919315 (37.773639762745, -122.433954919315)
30879 247445 2 59 811 Oak St 2 1 1 1     11 Width 0ft   6003098.9445 2109936.0688 37.7736574554899 -122.432719499751 (37.7736574554899, -122.432719499751)
57372 247439 2 59 430 Scott St 2 1 1 1     10 Width 0ft   6002222.1913 2110011.395 37.7738145198575 -122.435757709689 (37.7738145198575, -122.435757709689)
21063 16972 1 59 780 Oak St 2 1 1 1     18 3X3   6003244.9501 2110008.9107 37.7738657407699 -122.43221964740499 (37.7738657407699, -122.432219647405)
130045 244324 2 59 717 Oak St 2 1 1 1     14 Width 0ft   6003593.9138 2110004.6215 37.7738737432923 -122.43101221930401 (37.7738737432923, -122.431012219304)
58025 244505 2 59 691 Oak St 2 1 1 1     9 Width 0ft   6003712.7095 2110021.2984 37.7739262645997 -122.430602475909 (37.7739262645997, -122.430602475909)
168437 244244 2 59 150 Page St 2 1 1 1     17 Width 0ft   6005791.8047 2110016.6014 37.7740309317752 -122.423410197258 (37.7740309317752, -122.423410197258)
56402 244277 2 59 591 Oak St 2 1 1 1     12 Width 0ft   6004198.7601 2110089.4375 37.7741408812785 -122.42892600498301 (37.7741408812785, -122.428926004983)
167163 142073 2 59 419 BRODERICK ST 2 1 1 1     14 Width 0ft   6001163.9737 2110159.9703 37.774162304079 -122.439428898655 (37.774162304079, -122.439428898655)
21210 19218 3 59 1103X Fell St 2 1 1 2     18 3X3   6002097.9849 2110143.8576 37.7741711731344 -122.43619684024799 (37.7741711731344, -122.436196840248)
53929 140264 2 59 2100X Grove St 2 1 1 1     18 Width 0ft   5997701.9343 2110276.144 37.7742836533846 -122.451413027686 (37.7742836533846, -122.451413027686)
62836 71305 2 59 445 Broderick St 2 1 1 1 1 06/11/1988 12:00:00 AM 12     6001154.5387 2110263.7555 37.7744467352044 -122.43946897716299 (37.7744467352044, -122.439468977163)
120076 140725 2 59 508 SCOTT ST 2 1 1 1     12 Width 0ft   6002187.9434 2110254.4569 37.77447996187411 -122.43589357348499 (37.7744799618741, -122.435893573485)
39552 141364 2 59 451 BRODERICK ST 2 2 1 1     13 Width 0ft   6001150.566000001 2110292.0606 37.7745242278003 -122.439484748915 (37.7745242278003, -122.439484748915)
170986 141341 2 59 448 BRODERICK ST 2 1 1 1     6 Width 0ft   6001191.7822 2110294.5435 37.7745333908239 -122.43934235241699 (37.7745333908239, -122.439342352417)
71619 140705 2 59 500 PIERCE ST 2 1 1 1     18 Width 0ft   6002662.6848 2110317.4944 37.774680004154504 -122.43425586131599 (37.7746800041545, -122.434255861316)
175619 244473 2 59 859 Fell St 2 1 1 1     11 Width 0ft   6003334.8057 2110313.6958 37.774707699745996 -122.43193059003599 (37.774707699746, -122.431930590036)
74857 245843 2 59 350 Oak St 2 1 1 1     19 Width 0ft   6005198.7946 2110284.9355 37.774734224571795 -122.42548062261001 (37.7747342245718, -122.42548062261)
38088 142102 2 59 900 Fell St 2 2 1 1     14 Width 0ft   6003042.617000001 2110331.1771 37.7747391304954 -122.43294257823798 (37.7747391304954, -122.432942578238)
35911 142179 2 59 400 BAKER ST 2 1 1 1     13 Width 0ft   6000700.9795 2110406.5438 37.7748129727095 -122.441048166714 (37.7748129727095, -122.441048166714)
18202 16867 3 59 235 Oak St 2 1 1 2     18 5x5   6005854.7098 2110323.2964 37.7748765923478 -122.42321440275299 (37.7748765923478, -122.423214402753)
22102 16865 3 59 230 Oak St 2 1 1 2     12 3X3   6005838.6934 2110371.3705 37.7750076883115 -122.423273225017 (37.7750076883115, -122.423273225017)
63097 140722 2 59 555 PIERCE ST 2 1 1 1     16 Width 0ft   6002600.4394 2110449.7026 37.775039481864205 -122.43448063524599 (37.7750394818642, -122.434480635246)
47374 70252 2 59 500 Broderick St 2 1 1 1 1 07/11/1993 12:00:00 AM 10     6001164.2534 2110490.0118 37.7750685309709 -122.43945159440399 (37.7750685309709, -122.439451594404)
48261 140224 2 59 610 FILLMORE ST 2 1 1 1     10 Width 0ft   6003614.5841 2110462.3343 37.775131681161106 -122.430973390858 (37.7751316811611, -122.430973390858)
158599 112132 1 59 630 Fillmore St 2 1 1 1 1   9     6003600.3374 2110567.9569 37.775420887509796 -122.431030213476 (37.7754208875098, -122.431030213476)
76232 140214 2 59 668 Fillmore St 2 1 1 1     11 Width 0ft   6003589.5295 2110658.3502 37.7756684727789 -122.43107405366001 (37.7756684727789, -122.43107405366)
163992 138865 2 59 700 STEINER ST 2 1 1 1     8 Width 0ft   6003091.7893 2110720.9068 37.775812020633005 -122.432800328558 (37.775812020633, -122.432800328558)
49751 141659 2 59 16 LOYOLA TER 2 1 1 1     11 Width 0ft   5998449.6222 2110830.3835 37.7758482379963 -122.44886658065799 (37.7758482379963, -122.448866580658)
911 12249 3 59 511 Laguna St 2 1 1 2     12 3X3   6004989.1563 2110705.1842 37.7758762780635 -122.42623573054199 (37.7758762780635, -122.426235730542)
8030 10637 3 59 843 Hayes St 2 1 1 2   08/02/1990 12:00:00 AM 12 3X3   6003821.4079 2110734.0055 37.7758893402664 -122.43027732793101 (37.7758893402664, -122.430277327931)
Powered by Datasette · Query took 14.956ms · Data source: data.sfgov.org