sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
9735 173670 2 100 251x Lathrop Ave 1 1 1 1       3x3   6012236.0 2086860.0 37.7108094381203 -122.399492405366 (37.7108094381203, -122.399492405366)
22823 251110 9 100 1700X Quesada Ave 5 3 1 2                    
22824 251112 9 100 1700X Quesada Ave 14 22 1 2                    
22825 251109 9 100 1700X Quesada Ave 3 3 1 2                    
22828 251115 9 100 1700X Quesada Ave 19 3 1 2                    
22831 251116 9 100 1700X Quesada Ave 20 3 1 2                    
22832 251108 9 100 1700X Quesada Ave 2 3 1 2                    
22833 251113 9 100 1700X Quesada Ave 15 3 1 2                    
22838 251111 9 100 1700X Quesada Ave 7 3 1 2                    
22839 251114 9 100 1700X Quesada Ave 16 3 1 2                    
78635 60467 1 100 152 MAJESTIC AVE 1 1 1 1   11/24/1982 12:00:00 AM     Permit Number 20060 5996883.0 2089135.0 37.716188348676894 -122.45271971026699 (37.7161883486769, -122.452719710267)
80037 86731 1 100 2 Pico Ave   8 1 1         Permit Number 49705 5994102.9 2092171.9 37.724367252780496 -122.462549157922 (37.7243672527805, -122.462549157922)
81526 103927 3 100 100 The Embarcadero 13 11 1 2   02/05/2001 12:00:00 AM   4x4   6014859.0 2117030.0 37.793795709183996 -122.392535650186 (37.793795709184, -122.392535650186)
87101 96694 1 100 3132@32nd Ave Clement St 16 5 1 1   06/28/2011 12:00:00 AM     Permit Number 768040 5985890.0 2113240.0 37.7817381026149 -122.49249040156602 (37.7817381026149, -122.492490401566)
94540 106114 3 100 1752X DOLORES ST 1 3 1 2           6005197.0 2098194.1 37.741535528464496 -122.424626562024 (37.7415355284645, -122.424626562024)
103442 96695 1 100 3132@32nd Ave Clement St 17 5 1 1   06/28/2011 12:00:00 AM     Permit Number 768040 5985890.0 2113240.0 37.7817381026149 -122.49249040156602 (37.7817381026149, -122.492490401566)
104348 119624 3 100 1797X Market St 5 1 1 2       4X4   6005740.867306 2109154.5344128003 37.7716610284995 -122.423525097847 (37.7716610284995, -122.423525097847)
106263 96692 1 100 3132@32nd Ave Clement St 14 5 1 1   06/28/2011 12:00:00 AM     Permit Number 768040 5985890.0 2113240.0 37.7817381026149 -122.49249040156602 (37.7817381026149, -122.492490401566)
107261 96693 1 100 3132@32nd Ave Clement St 15 5 1 1   06/28/2011 12:00:00 AM     Permit Number 768040 5985890.0 2113240.0 37.7817381026149 -122.49249040156602 (37.7817381026149, -122.492490401566)
110630 92744 1 100 627 Dartmouth St 1 1 1 1       3x3 Permit Number 52968 6009200.0 2091312.0 37.722864017361395 -122.41029969523998 (37.7228640173614, -122.41029969524)
111110 116685 2 100 1x BIRD ST 2 1 1 1       3x3   6005912.0 2105722.0 37.762245762674496 -122.42268916815901 (37.7622457626745, -122.422689168159)
126077 51202 1 100 567 Sanchez St 2 1 1 1         Permit Number 47573 6003673.55383836 2104968.22861825 37.760049541377796 -122.43037732338999 (37.7600495413778, -122.43037732339)
127400 119700 3 100 6x Octavia St Frontage West 2 11 1 2           2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
129396 93074 1 100 301 Executive Park Blvd 15 1 1 1   11/30/2007 12:00:00 AM   3x3 Permit Number 49938 6014761.5 2086930.3 37.711142914018296 -122.390768534473 (37.7111429140183, -122.390768534473)
138316 119699 3 100 6x Octavia St Frontage West 1 11 1 2           2109337.0 6005692.0 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)
140592 26537 3 100 794X Dolores St 4 11 1 2   06/23/1997 12:00:00 AM   20   6004985.41588 2103704.6857762 37.7566543729812 -122.425750282521 (37.7566543729812, -122.425750282521)
142373 87850 1 100 94 Teresita Blvd 1 1 1 1       3x3 Permit Number 50753 5997405.9 2099153.7 37.7437272652603 -122.45163459365601 (37.7437272652603, -122.451634593656)
104182 14173 3 100 1797X Market St 2 1 1 2     0 4X4   6005740.867306 2109154.5344128003 37.7716610284995 -122.423525097847 (37.7716610284995, -122.423525097847)
129459 14174 3 100 1797X Market St 3 1 1 2     0 4X4   6005740.867306 2109154.5344128003 37.7716610284995 -122.423525097847 (37.7716610284995, -122.423525097847)
182278 210908 2 100 1351 06th Ave 1 1 1 1     1 Width 4ft   5994231.8356099995 2106400.1375599997 37.7634418445856 -122.463135347428 (37.7634418445856, -122.463135347428)
52544 186008 2 100 1900 Sunset Blvd 3 9 1 1     2 Width 0ft   5985026.892000001 2101640.0667 37.749837450044495 -122.494620873169 (37.7498374500445, -122.494620873169)
60454 234382 2 100 2624 22nd St 2 1 1 1     2 Width 4ft   6010280.44455 2103423.11774 37.7561790447523 -122.40741821967501 (37.7561790447523, -122.407418219675)
159203 132067 2 100 3038 Lyon St 2 9 1 1     2 Width 2ft   5999089.102080001 2119262.1852 37.799036302553 -122.44726145536 (37.799036302553, -122.44726145536)
11148 20065 3 100 100 STAIRWAY54 12 1 1 2     3 15ST            
14829 95065 1 100 4801 03rd St 1 1 1 1     3 3x3   6014916.5089 2095299.5463 37.7341318071091 -122.390817297505 (37.7341318071091, -122.390817297505)
17235 708 3 100 1504X Dolores St 2 1 1 2   11/06/2015 02:27:00 PM 3 6x6   6005213.6425 2099570.03766 37.745314479891896 -122.42466687479799 (37.7453144798919, -122.424666874798)
54583 132068 2 100 3601 Broderick St 4 9 1 1     3 Width 4ft   5999659.130480001 2120925.06177 37.803634670174496 -122.445408603735 (37.8036346701745, -122.445408603735)
59423 194280 2 100 2 Tulare St 18 7 1 1     3     6016126.44291 2100241.55687 37.747768618243605 -122.38697869801202 (37.7477686182436, -122.386978698012)
70062 234377 2 100 1750 Harrison St 3 4 1 1     3 Width 2ft   6008587.9096 2108086.3181 37.768888242332004 -122.413601406792 (37.768888242332, -122.413601406792)
78381 23674 3 100 319 Virginia Ave 3 11 1 2     3 12   6006936.2458165 2098250.5638735 37.741788638281996 -122.418616833275 (37.741788638282, -122.418616833275)
100781 109174 2 100 63 KEYSTONE WAY 1 9 1 1   05/04/2015 12:00:00 AM 3 3x3 Permit Number 775282 5994095.9 2093146.9 37.7270439629203 -122.46264404963699 (37.7270439629203, -122.462644049637)
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)
158189 234383 2 100 3483 22nd St 2 1 1 1     3 Width 3ft   6005156.87556 2103096.1087599997 37.7549930502992 -122.425114011399 (37.7549930502992, -122.425114011399)
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)
24453 185441 2 100 2300 Sunset Blvd 60 9 1 1     4 Width 0ft   5985106.1344 2099492.3058 37.7439449206951 -122.49418856991899 (37.7439449206951, -122.494188569919)
32150 186007 2 100 1900 Sunset Blvd 2 9 1 1     4 Width 0ft   5985000.2752 2101640.5507 37.749837221065 -122.49471294958 (37.749837221065, -122.49471294958)
181517 194279 2 100 2 Tulare St 21 7 1 1     4     6016113.78589 2100276.91255 37.7478649967659 -122.387024931273 (37.7478649967659, -122.387024931273)
21228 5457 3 100 581 Dolores St 1 1 1 2     5 8   6004998.45452 2104996.17843 37.760201244618294 -122.42579711395099 (37.7602012446183, -122.425797113951)
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)
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)
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)
47083 186006 2 100 1900 Sunset Blvd 1 9 1 1     5 Width 0ft   5985010.9219 2101633.2915 37.7498179124605 -122.494675598244 (37.7498179124605, -122.494675598244)
47741 194278 2 100 1750 22nd St 7 17 1 1     5     6012817.610719999 2103799.38432 37.7573538722899 -122.398670182286 (37.7573538722899, -122.398670182286)
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)
187792 210906 2 100 1113 Kirkham St 3 10 1 1     5 Width 4ft   5991529.16752 2105177.12145 37.7599277068135 -122.47239375186301 (37.7599277068135, -122.472393751863)
18142 13388 3 100 218 Marietta Dr 1 11 1 2     6 5   5997667.5215300005 2098758.8322 37.7426580336411 -122.45070150968999 (37.7426580336411, -122.45070150969)
20932 5679 1 100 1470 Dolores St 1 1 1 1   12/08/2003 12:00:00 AM 6 3x3   6005190.57812 2099817.1721900003 37.7459917521253 -122.424764205708 (37.7459917521253, -122.424764205708)
23714 234376 2 100 1750 Harrison St 2 4 1 1     6 Width 2ft   6008587.75214 2108113.66978 37.7689633348285 -122.41360388622499 (37.7689633348285, -122.413603886225)
59904 187497 2 100 100 Walbridge St 3 7 1 1     6     6005151.09396 2086478.68565 37.7093649785846 -122.42395239669399 (37.7093649785846, -122.423952396694)
180226 186180 2 100 1700 Sunset Blvd 65 9 1 1     6 Width 0ft   5984958.094 2103565.49 37.755120105782204 -122.49500073187099 (37.7551201057822, -122.495000731871)
136550 186179 2 100 1700 Sunset Blvd 64 9 1 1     7 Width 0ft   5984928.6664 2103564.4514 37.755115531312704 -122.49510242297701 (37.7551155313127, -122.495102422977)
163198 234393 2 100 1557 Sanchez St 2 1 1 1     7 Width 3ft   6003994.29589 2099192.81462 37.7442097715744 -122.42885628561001 (37.7442097715744, -122.42885628561)
175193 182680 2 100 2701 Moraga St 1 1 1 1     7 Width 0ft   5985854.1638 2103629.5919999997 37.7553485282392 -122.491906624733 (37.7553485282392, -122.491906624733)
46040 187495 2 100 100 Walbridge St 1 7 1 1     8     6005184.36761 2086469.76682 37.709342367834395 -122.423836763664 (37.7093423678344, -122.423836763664)
61791 182681 2 100 2701 Moraga St 2 1 1 1     8 Width 0ft   5985882.7747 2103629.0901 37.75534882242739 -122.491807644065 (37.7553488224274, -122.491807644065)
134605 194275 2 100 1 01st St 34 23 1 1     8     6014376.659969999 2105881.88915 37.76315871732 -122.39342406806101 (37.76315871732, -122.393424068061)
149136 234366 2 100 9 Duncan St 2 1 1 1     8 Width 3ft   6006381.599330001 2099941.08815 37.746399194477206 -122.420654601644 (37.7463991944772, -122.420654601644)
157052 210909 2 100 151 Garcia Ave 2 9 1 1     8 Width 3ft   5994659.02084 2099296.69557 37.7439622025921 -122.46114293900601 (37.7439622025921, -122.461142939006)
163407 187499 2 100 100 Walbridge St 5 7 1 1     8     6005135.10052 2086491.02363 37.7093979531098 -122.42400854947999 (37.7093979531098, -122.42400854948)
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)
43396 194272 2 100 1022 Minna St 2 4 1 1     9 Width 3ft   6007547.687530001 2109714.25342 37.7732997020571 -122.41731485230801 (37.7732997020571, -122.417314852308)
48420 187504 2 100 100 Walbridge St 10 7 1 1     9     6005101.69485 2086503.71935 37.7094309267755 -122.424124907354 (37.7094309267755, -122.424124907354)
149367 234380 2 100 1001 San Jose Ave 4 2 1 1     9 Width 3ft   6005142.82168 2096774.43039 37.7376343766353 -122.424712922782 (37.7376343766353, -122.424712922782)
25123 210904 2 100 1539 Lincoln Way 1 1 1 1     10 Width 3ft   5990882.40967 2107206.58351 37.7654626131273 -122.47477868020201 (37.7654626131273, -122.474778680202)
48676 210905 2 100 1545 Lincoln Way 1 1 1 1     10 Width 3ft   5990857.32948 2107205.82169 37.76545906800929 -122.47486537036501 (37.7654590680093, -122.474865370365)
55136 234387 2 100 986 Dolores St 2 1 1 1     10 Width 4ft   6005043.99676 2102621.6014400003 37.7536837866767 -122.425470611492 (37.7536837866767, -122.425470611492)
63620 234384 2 100 899 Hampshire St 4 9 1 1     10 Width 3ft   6010216.7904900005 2104076.88773 37.757970587791 -122.407684453188 (37.757970587791, -122.407684453188)
131685 210910 2 100 151 Garcia Ave 4 9 1 1     10 Width 3ft   5994660.64772 2099277.20114 37.743908769387005 -122.461135900907 (37.743908769387, -122.461135900907)
150774 118706 2 100 4201 Balboa St 1 9 1 1     10 Width 2ft   5982550.59501 2110970.7524 37.7753116033094 -122.50387485804899 (37.7753116033094, -122.503874858049)
170283 234385 2 100 384 Page St 2 1 1 1     10 Width 3ft   6004737.93375 2109866.7423400003 37.773559918201606 -122.427045042888 (37.7735599182016, -122.427045042888)
173622 234381 2 100 200 Eugenia Ave 2 7 1 1     10     6006554.5281 2098105.53483 37.74136892295 -122.41992640079599 (37.74136892295, -122.419926400796)
23525 187316 2 100 2200 Sunset Blvd 1 9 1 1     11 Width 0ft   5985075.4607 2099608.8478 37.744263118481705 -122.494303219592 (37.7442631184817, -122.494303219592)
2027 25628 1 100 650 The Embarcadero 1 1 1 9   12/18/2000 12:00:00 AM 12 4X4   6014034.02503 2117986.25531 37.796375512586 -122.39545718430401 (37.796375512586, -122.395457184304)
6610 25631 1 100 650 The Embarcadero 4 1 1 9   12/18/2000 12:00:00 AM 12 4X4   6014105.621619999 2117876.68788 37.7960786481665 -122.395201764263 (37.7960786481665, -122.395201764263)
8064 25629 1 100 650 The Embarcadero 2 1 1 9   12/18/2000 12:00:00 AM 12 4X4   6014059.75449 2117949.14567 37.79627504929729 -122.39536555327801 (37.7962750492973, -122.395365553278)
8404 25630 1 100 650 The Embarcadero 3 1 1 9   12/18/2000 12:00:00 AM 12 4X4   6014084.49775 2117912.38554 37.7961754907607 -122.395277359473 (37.7961754907607, -122.395277359473)
14049 18560 3 100 1700X Quesada Ave 15 11 1 2     12 19   6014546.06488 2095149.2171099999 37.7336984729967 -122.392087539714 (37.7336984729967, -122.392087539714)
16768 18555 9 100 1700X Quesada Ave 10 11 1 2     12 19   6014626.04256 2095092.9200799998 37.733548332979105 -122.39180709603201 (37.7335483329791, -122.391807096032)
19857 5683 3 100 1488 Dolores St 1 1 1 2   05/08/1997 12:00:00 AM 12 6   6005201.38668 2099720.6305299997 37.745727281286705 -122.42471996446301 (37.7457272812867, -122.424719964463)
22064 25150 3 100 50X Dolores St 3 11 1 2     12 20   6004790.11345 2107911.6189 37.7681945727608 -122.42672528803699 (37.7681945727608, -122.426725288037)
61697 28231 3 100 399X King St 14 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
69369 28185 3 100 299X King St 3 1 1 2     12 6   6014324.7762427 2110655.2584450003 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457)
72577 28190 3 100 299X King St 8 1 1 2     12 6   6014324.7762427 2110655.2584450003 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457)
73838 28232 3 100 399X King St 15 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
78875 27848 1 100 100 The Embarcadero 3 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015938.91901 2112416.43301 37.7811878161514 -122.388476823036 (37.7811878161514, -122.388476823036)
78913 25684 1 100 100 The Embarcadero 2 11 1 9   12/18/2000 12:00:00 AM 12 3X3   6015953.02501 2112484.79201 37.781376296324 -122.388432795571 (37.781376296324, -122.388432795571)
79238 28220 3 100 399X King St 3 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
79855 28229 3 100 399X King St 12 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
80653 28194 3 100 299X King St 12 1 1 2     12 6   6014324.7762427 2110655.2584450003 37.7762624487031 -122.393937678457 (37.7762624487031, -122.393937678457)
81194 28236 3 100 399X King St 19 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
81864 28226 3 100 399X King St 9 1 1 2     12     6013667.5202917 2110028.9140531 37.7745060991794 -122.39616741711599 (37.7745060991794, -122.396167417116)
Powered by Datasette · Query took 10.089ms · Data source: data.sfgov.org