sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
152536 176979 2 30 100 Winding Way 4 1 1 1     1 Width 5ft   6002427.23589 2086817.03836 37.7101398650242 -122.433390645786 (37.7101398650242, -122.433390645786)
64273 176978 2 30 100 Winding Way 3 1 1 1     1 Width 5ft   6002453.716630001 2086834.19677 37.7101884805901 -122.433300348445 (37.7101884805901, -122.433300348445)
181896 176977 2 30 100 Winding Way 2 1 1 1     1 Width 5ft   6002472.369080001 2086850.07188 37.710233128335396 -122.433237015483 (37.7102331283354, -122.433237015483)
37575 176976 2 30 100 Winding Way 1 1 1 1     1 Width 5ft   6002487.993290001 2086859.8664400002 37.710260908397395 -122.433183714473 (37.7102609083974, -122.433183714473)
77131 54664 1 30 360 Peninsula Ave 1 1 1 1   07/27/1972 12:00:00 AM 1   Permit Number 10488 6012252.975769999 2086866.6648099998 37.710828684568206 -122.399434200424 (37.7108286845682, -122.399434200424)
159965 176962 2 30 121 Saint Charles Ave 1 4 1 1     12 Width 2ft   5992069.06615 2087619.0428799998 37.71174887986621 -122.46924855110301 (37.7117488798662, -122.469248551103)
168888 176927 2 30 200 Morse St 6 9 1 1     30 Width 10ft   6000575.21017 2087869.90013 37.7129255429455 -122.43986703794201 (37.7129255429455, -122.439867037942)
160010 176926 2 30 200 Morse St 5 9 1 1     23 Width 10ft   6000586.22066 2087873.8924099999 37.712937131606395 -122.439829268227 (37.7129371316064, -122.439829268227)
78926 112621 2 30 226x HESTER AVE 1 1 1 1       3x3   6012667.0 2087636.0 37.712964194877294 -122.398057164184 (37.7129641948773, -122.398057164184)
148062 176958 2 30 214 Hester Ave 1 1 1 1     4 Width 2ft   6012631.12356 2087648.5603099999 37.7129966847253 -122.39818204648701 (37.7129966847253, -122.398182046487)
186617 176959 2 30 228 Hester Ave 2 1 1 1     4 Width 2ft   6012551.8348 2087659.68415 37.7130228118314 -122.398456876593 (37.7130228118314, -122.398456876593)
94418 112623 2 30 228 HESTER AVE 1 1 1 1       3x2   6012539.0 2087662.0 37.7130284556779 -122.398501400627 (37.7130284556779, -122.398501400627)
138206 176957 2 30 208 Hester Ave 1 1 1 1     4 Width 2ft   6012704.399540001 2087660.6669400001 37.7130340083786 -122.397929627449 (37.7130340083786, -122.397929627449)
26316 176960 2 30 242 Hester Ave 1 1 1 1     7 Width 2ft   6012452.5611 2087695.0016599998 37.7131142557927 -122.39880247885701 (37.7131142557927, -122.398802478857)
29524 108754 2 30 200x Hester Ave 2 1 1 1     4 3x3   6012760.63999 2087707.7823400002 37.7131665099896 -122.397738543111 (37.7131665099896, -122.397738543111)
35610 176951 2 30 63 Lois Ln 1 1 1 1     7 Width 2ft   6012562.34064 2087723.35892 37.7131982353775 -122.398425029786 (37.7131982353775, -122.398425029786)
44632 176950 2 30 59 Lois Ln 2 1 1 1     7 Width 2ft   6012544.33708 2087727.46225 37.7132084993531 -122.398487544387 (37.7132084993531, -122.398487544387)
62932 108753 2 30 200x Hester Ave 1 1 1 1     4 3x3   6012766.4768 2087726.3545799998 37.713217830719294 -122.397719670851 (37.7132178307193, -122.397719670851)
177487 176949 2 30 59 Lois Ln 1 1 1 1     8 Width 2ft   6012531.85348 2087734.51235 37.7132271620641 -122.39853118666201 (37.7132271620641, -122.398531186662)
38656 176952 2 30 75 Lois Ln 1 1 1 1     7 Width 2ft   6012648.82319 2087733.77895 37.713231664082706 -122.39812684519698 (37.7132316640827, -122.398126845197)
45505 176953 2 30 79 Lois Ln 1 1 1 1     4 Width 2ft   6012671.13481 2087736.7840599997 37.713241158228705 -122.39804993876999 (37.7132411582287, -122.39804993877)
169089 176954 2 30 95 Lois Ln 1 1 1 1     4 Width 2ft   6012699.50978 2087739.26695 37.713249556105104 -122.397952038554 (37.7132495561051, -122.397952038554)
52561 114222 2 30 55 Lois Ln 1 1 1 1     7 2x2   6012512.59554 2087744.0784200002 37.713252355697605 -122.398598420002 (37.7132523556976, -122.398598420002)
179315 176955 2 30 95 Lois Ln 2 1 1 1     4 Width 2ft   6012720.393999999 2087742.5814099999 37.7132598200564 -122.397880087391 (37.7132598200564, -122.397880087391)
64660 176932 2 30 56 Lois Ln 1 1 1 1     8 Width 2ft   6012552.9526 2087748.4178 37.7132665190974 -122.39845923552299 (37.7132665190974, -122.398459235523)
69520 176931 2 30 68 Lois Ln 1 1 1 1     5 Width 2ft   6012597.15839 2087748.03583 37.713267932833794 -122.398306417307 (37.7132679328338, -122.398306417307)
148096 176961 2 30 41 Teddy Ave 1 1 1 1     1 Width 3ft   6011207.15899 2087778.71194 37.7132746363936 -122.403112916852 (37.7132746363936, -122.403112916852)
148773 176956 2 30 99 Lois Ln 1 1 1 1     3 Width 2ft   6012750.523080001 2087747.4076 37.713274749713605 -122.39777628854799 (37.7132747497136, -122.397776288548)
150169 176933 2 30 56 Lois Ln 2 1 1 1     3 Width 2ft   6012542.43425 2087752.49307 37.7132771230101 -122.398495876584 (37.7132771230101, -122.398495876584)
177180 176930 2 30 78 Lois Ln 1 1 1 1     7 Width 2ft   6012665.081590001 2087756.9566900001 37.7132962111247 -122.39807227523501 (37.7132962111247, -122.398072275235)
92160 39928 1 30 100 Arleta Ave 2 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41199 6010702.15739083 2087798.94554582 37.7133019788898 -122.404859809077 (37.7133019788898, -122.404859809077)
105518 39927 1 30 100 Arleta Ave 1 1 1 1   01/25/1999 12:00:00 AM     Permit Number 41199 6010702.15739083 2087798.94554582 37.7133019788898 -122.404859809077 (37.7133019788898, -122.404859809077)
171606 176934 2 30 52 Lois Ln 1 1 1 1     3 Width 2ft   6012523.28008 2087764.2105 37.7133082296521 -122.398562902163 (37.7133082296521, -122.398562902163)
169932 176948 2 30 43 Lois Ln 1 1 1 1     7 Width 2ft   6012470.82697 2087771.0926700002 37.7133242043273 -122.39874468213101 (37.7133242043273, -122.398744682131)
183903 176947 2 30 39 Lois Ln 1 1 1 1     7 Width 2ft   6012433.06951 2087793.9478900002 37.713384856409 -122.398876788934 (37.713384856409, -122.398876788934)
182528 176929 2 30 110 Hester Ave 2 1 1 1     4 Width 2ft   6012755.76956 2087791.93581 37.7133973075252 -122.397761276185 (37.7133973075252, -122.397761276185)
181722 176935 2 30 38 Lois Ln 1 1 1 1     2 Width 2ft   6012462.52056 2087802.51935 37.7134100329326 -122.398775596322 (37.7134100329326, -122.398775596322)
133916 176946 2 30 33 Lois Ln 1 1 1 1     6 Width 2ft   6012391.32203 2087821.98143 37.7134595046344 -122.39902305019699 (37.7134595046344, -122.399023050197)
169093 176928 2 30 110 Hester Ave 1 1 1 1     4 Width 2ft   6012745.689669999 2087817.6299700001 37.713467297259996 -122.397797917233 (37.71346729726, -122.397797917233)
132161 176945 2 30 31 Lois Ln 3 1 1 1     7 Width 2ft   6012378.545530001 2087831.41605 37.7134846982415 -122.399067872395 (37.7134846982415, -122.399067872395)
161305 114220 2 30 31 Lois Ln 2 1 1 1     5 3x3   6012353.592019999 2087846.1951099997 37.713523887993105 -122.39915515788799 (37.7135238879931, -122.399155157888)
149495 114219 2 30 31 Lois Ln 1 1 1 1     4 3x3   6012347.17965 2087849.72367 37.713533219358396 -122.399177569 (37.7135332193584, -122.399177569)
182745 114221 2 30 28 Lois Ln 1 1 1 1     2 3x3   6012377.24762 2087856.00195 37.7135521339029 -122.39907408311599 (37.7135521339029, -122.399074083116)
151835 176944 2 30 19 Lois Ln 4 1 1 1     6 Width 2ft   6012329.67576 2087861.6330900001 37.7135649447506 -122.39923890456801 (37.7135649447506, -122.399238904568)
23969 176943 2 30 19 Lois Ln 3 1 1 1     6 Width 2ft   6012322.95001 2087866.52725 37.713578008300296 -122.39926249466801 (37.7135780083003, -122.399262494668)
46965 176936 2 30 20 Lois Ln 1 1 1 1     5 Width 2ft   6012351.49393 2087873.7751200001 37.713599500286 -122.399164344459 (37.713599500286, -122.399164344459)
70808 176942 2 30 19 Lois Ln 2 1 1 1     7 Width 2ft   6012304.7570400005 2087878.1106900002 37.713608800166504 -122.39932618916299 (37.7136088001665, -122.399326189163)
150126 176941 2 30 19 Lois Ln 1 1 1 1     7 Width 2ft   6012299.34717 2087880.5993299999 37.7136153319601 -122.39934506233999 (37.7136153319601, -122.39934506234)
188401 207079 2 30 59 Ralston St 3 13 1 1     12     5992173.18035 2088300.4585900002 37.7136258989769 -122.46893826428699 (37.7136258989769, -122.468938264287)
172429 176940 2 30 15 Lois Ln 1 1 1 1     11 Width 2ft   6012273.467119999 2087900.15525 37.7136675861685 -122.399435885762 (37.7136675861685, -122.399435885762)
75435 176937 2 30 18 Lois Ln 1 1 1 1     5 Width 2ft   6012312.20962 2087899.37244 37.7136675960583 -122.399301921852 (37.7136675960583, -122.399301921852)
171489 176938 2 30 10 Lois Ln 1 1 1 1     11 Width 2ft   6012264.960419999 2087928.82829 37.7137458424772 -122.39946729997101 (37.7137458424772, -122.399467299971)
37113 176939 2 30 8 Lois Ln 1 1 1 1     10 Width 2ft   6012245.82216 2087941.3179099998 37.7137790697309 -122.399534325569 (37.7137790697309, -122.399534325569)
130451 176925 2 30 17 Curtis St 2 2 1 1     1 Width 4ft   6000534.5551 2088493.30994 37.7146349724878 -122.440052229032 (37.7146349724878, -122.440052229032)
178956 176921 2 30 715 Naples St 1 1 1 1     3 Width 2ft   6002409.56015 2089503.5863700002 37.717515532482096 -122.43364361428301 (37.7175155324821, -122.433643614283)
187926 176923 2 30 298 Prague St 2 1 1 1     1 Width 2ft   6003940.88243 2089479.82592 37.7175370613599 -122.42834884222201 (37.7175370613599, -122.428348842222)
73208 49756 1 30 1171 Goettingen St 1 1 1 1 1 06/04/2003 12:00:00 AM 1   Permit Number 46552 6011373.3818 2089351.75942 37.71760318852571 -122.40264894398899 (37.7176031885257, -122.402648943989)
54047 176922 2 30 298 Prague St 1 1 1 1     1 Width 2ft   6003957.47292 2089506.6993599997 37.7176117887305 -122.42829341070801 (37.7176117887305, -122.428293410708)
131178 66298 1 30 2920 Hawes St 1 1 1 1   11/27/1990 12:00:00 AM 6 3x3 Permit Number 29409 6014606.2975 2089345.5816 37.7177661944335 -122.391473700889 (37.7177661944335, -122.391473700889)
34497 191363 2 30 955 Key Ave 1 2 1 1     13     6013550.52728 2089583.75311 37.7183615103672 -122.395139727222 (37.7183615103672, -122.395139727222)
47675 176920 2 30 671 London St 3 2 1 1     6     6001061.12784 2089906.70665 37.718545806627205 -122.43833338090299 (37.7185458066272, -122.438333380903)
155800 53889 1 30 1009 Goettingen St 1 1 1 1   03/10/1972 12:00:00 AM 6   Permit Number 9600 6011157.21659 2090045.52637 37.7194960599821 -122.403444914172 (37.7194960599821, -122.403444914172)
59444 80749 1 30 375 Munich St 1 1 1 1   07/01/2009 12:00:00 AM 3 3x3 Permit Number 52325 6004167.50654 2090267.3011900003 37.719712117607 -122.42762157938101 (37.719712117607, -122.427621579381)
111098 50485 1 30 118 Lee Ave 1 1 1 1 1 10/29/2003 12:00:00 AM     Permit Number 47121 5996542.39678919 2090678.14826944 37.720405949717104 -122.45400837564699 (37.7204059497171, -122.454008375647)
180047 35838 1 30 524 London St 1 1 1 1 1 04/23/1998 12:00:00 AM 6   Permit Number 39065 6001524.77874 2090714.46307 37.7207900854698 -122.436788524592 (37.7207900854698, -122.436788524592)
62411 176924 2 30 525 Edinburgh St 1 1 1 1     1 Width 3ft   6002840.55904 2090695.62 37.720813038882206 -122.43223893347799 (37.7208130388822, -122.432238933478)
69112 187585 2 30 748 University St 1 7 1 1     19     6008708.47344 2090752.4419999998 37.7213000235466 -122.411959282496 (37.7213000235466, -122.411959282496)
176194 187582 2 30 747 University St 3 17 1 1     12     6008739.08909 2090759.6184900003 37.7213214463175 -122.41185395930799 (37.7213214463175, -122.411853959308)
38136 46819 1 30 366 Athens St 1 1 1 1 1 04/25/2002 12:00:00 AM 10   Permit Number 44897 6004049.020819999 2091179.47735 37.7222100502291 -122.428096112963 (37.7222100502291, -122.428096112963)
10378 98180 1 30 622 Cambridge St 1 1 1 1   12/29/2011 12:00:00 AM 3 3x3 Permit Number 768099 6007169.16242 2091641.99398 37.7236560602499 -122.417343266399 (37.7236560602499, -122.417343266399)
67146 105243 1 30 616 Cambridge St 1 1 1 1   01/07/2014 12:00:00 AM 2 3x3 Permit Number 770335 6007163.0512 2091665.3874599999 37.723719949895 -122.417366048922 (37.723719949895, -122.417366048922)
80995 81638 1 30 611 San Bruno Ave 1 1 1 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52388 6011631.16657043 2091602.57917757 37.7237978701092 -122.40191602971301 (37.7237978701092, -122.401916029713)
154729 176975 2 30 248 London St 1 1 1 1     3 Width 3ft   6002517.77047 2092300.43042 37.7252011818667 -122.43346933824301 (37.7252011818667, -122.433469338243)
73740 200018 2 30 1008 Revere Ave 1 1 1 1     1 Width 0ft   6018250.1161 2092086.6599 37.7254942451327 -122.37906877917801 (37.7254942451327, -122.379068779178)
56909 200009 2 30 1435 Griffith St 4 1 1 1     1 Width 0ft   6017676.8443 2092268.1534 37.72596096442079 -122.381063162948 (37.7259609644208, -122.381063162948)
59332 200004 2 30 1450 Griffith St 6 1 1 1     2 Width 0ft   6017626.5562 2092285.3405 37.7260053809224 -122.38123820192101 (37.7260053809224, -122.381238201921)
62276 200097 2 30 1528 Yosemite Ave 2 1 1 1     1 Width 0ft   6015067.4938 2092354.869 37.7260546913573 -122.390089647295 (37.7260546913573, -122.390089647295)
159060 200098 2 30 1528 Yosemite Ave 3 1 1 1     1 Width 0ft   6015053.9581 2092365.0208 37.726081815437205 -122.39013714867201 (37.7260818154372, -122.390137148672)
64313 200002 2 30 1450 Griffith St 4 1 1 1     1 Width 0ft   6017646.9261 2092314.6221 37.726086906985 -122.381169818775 (37.726086906985, -122.381169818775)
182025 200099 2 30 1528 Yosemite Ave 4 1 1 1     1 Width 0ft   6015044.482999999 2092374.4958 37.7261073063636 -122.390170565448 (37.7261073063636, -122.390170565448)
176268 200103 2 30 1528 Yosemite Ave 8 1 1 1     1 Width 0ft   6014982.2186 2092417.8102 37.72622278535071 -122.390388836652 (37.7262227853507, -122.390388836652)
148569 200000 2 30 1450 Griffith St 2 1 1 1     1 Width 0ft   6017688.3023 2092371.2757 37.726244750724 -122.381030719301 (37.726244750724, -122.381030719301)
52001 200104 2 30 1528 Yosemite Ave 9 1 1 1     1 Width 0ft   6014963.9454 2092431.3459 37.726258938018 -122.39045295200899 (37.726258938018, -122.390452952009)
64448 200105 2 30 1528 Yosemite Ave 10 1 1 1     1 Width 0ft   6014949.7328 2092444.2049 37.7262934578304 -122.39050298275801 (37.7262934578304, -122.390502982758)
28685 99380 1 30 1590 Yosemite Ave 3 1 1 1   05/09/2012 12:00:00 AM 1 3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980855996 -122.390639783135 (37.726418980856, -122.390639783135)
89315 99393 1 30 1590 Yosemite Ave 16 1 1 1   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980855996 -122.390639783135 (37.726418980856, -122.390639783135)
89862 99399 1 30 1590 Yosemite Ave 22 1 1 1   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980855996 -122.390639783135 (37.726418980856, -122.390639783135)
108977 99385 1 30 1590 Yosemite Ave 8 1 1 1   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980855996 -122.390639783135 (37.726418980856, -122.390639783135)
110341 99386 1 30 1590 Yosemite Ave 9 1 1 1   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980855996 -122.390639783135 (37.726418980856, -122.390639783135)
112798 99381 1 30 1590 Yosemite Ave 4 1 1 1   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980855996 -122.390639783135 (37.726418980856, -122.390639783135)
113044 99398 1 30 1590 Yosemite Ave 21 1 1 1   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980855996 -122.390639783135 (37.726418980856, -122.390639783135)
114337 99387 1 30 1590 Yosemite Ave 10 1 1 1   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980855996 -122.390639783135 (37.726418980856, -122.390639783135)
115661 99395 1 30 1590 Yosemite Ave 18 1 1 1   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980855996 -122.390639783135 (37.726418980856, -122.390639783135)
142142 99394 1 30 1590 Yosemite Ave 17 1 1 1   05/09/2012 12:00:00 AM   3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980855996 -122.390639783135 (37.726418980856, -122.390639783135)
148905 99379 1 30 1590 Yosemite Ave 2 1 1 1   05/09/2012 12:00:00 AM 1 3x3 Permit Number 768917 6014911.1 2092490.7 37.726418980855996 -122.390639783135 (37.726418980856, -122.390639783135)
176691 75284 2 30 1335 Griffith St 3 1 1 1 1 06/13/1998 12:00:00 AM 3     6017835.3471 2092484.583 37.7265639860027 -122.380530259866 (37.7265639860027, -122.380530259866)
172420 200111 2 30 1552 Yosemite Ave 1 1 1 1     1 Width 0ft   6014807.6076 2092549.7837 37.726575470666106 -122.39100168241998 (37.7265754706661, -122.39100168242)
131229 200112 2 30 1560 Yosemite Ave 1 1 1 1     1 Width 0ft   6014792.7183 2092559.9355 37.726602519263004 -122.391053863847 (37.726602519263, -122.391053863847)
51298 200113 2 30 1566 Yosemite Ave 1 1 1 1     1 Width 0ft   6014774.445 2092572.7944 37.7266368132033 -122.391117932915 (37.7266368132033, -122.391117932915)
88005 30508 1 30 363 Holyoke St 1 1 1 1 1 07/06/1998 12:00:00 AM     Permit Number 40123 6009708.62861324 2092740.2698514 37.72681424554771 -122.40864217293199 (37.7268142455477, -122.408642172932)
157041 199935 2 30 1310 Griffith St 1 1 1 1     3 Width 0ft   6017874.9241 2092620.1152 37.726938315047896 -122.380402857754 (37.7269383150479, -122.380402857754)
Powered by Datasette · Query took 5.857ms · Data source: data.sfgov.org