sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
172370 137040 2 46 1034 Sacramento St 4 1 1 1     1 Width 3ft   6009716.374480001 2116806.1167599997 37.7928940462749 -122.410313864011 (37.7928940462749, -122.410313864011)
187118 137037 2 46 1034 Sacramento St 1 1 1 1     1 Width 3ft   6009816.75031 2116820.89237 37.792940242650296 -122.409967600744 (37.7929402426503, -122.409967600744)
11164 17617 3 46 1042 Persia Ave 1 1 1 2     40 3x3   6004228.49613 2089992.79688 37.7189618383998 -122.427391215355 (37.7189618383998, -122.427391215355)
18738 17618 3 46 1049X Persia Ave 1 1 1 2     50 3x3   6004182.578886599 2090079.2106526 37.7191965146646 -122.427556086461 (37.7191965146646, -122.427556086461)
96728 17620 3 46 1049X Persia Ave 3 1 1 2     50 3x3   6004182.578886599 2090079.2106526 37.7191965146646 -122.427556086461 (37.7191965146646, -122.427556086461)
117397 17619 3 46 1049X Persia Ave 2 1 1 2     50 3x3   6004182.578886599 2090079.2106526 37.7191965146646 -122.427556086461 (37.7191965146646, -122.427556086461)
61812 198600 2 46 1050 16th St 3 1 1 1     3 Width 4ft   6013090.52825 2107110.01033 37.7664593236741 -122.397958554166 (37.7664593236741, -122.397958554166)
63083 198599 2 46 1050 16th St 2 1 1 1     3 Width 4ft   6013108.22745 2107111.70363 37.7664649588148 -122.397897454223 (37.7664649588148, -122.397897454223)
159859 198598 2 46 1050 16th St 1 1 1 1     3 Width 4ft   6013134.44315 2107112.3448 37.766468179289 -122.397806823228 (37.766468179289, -122.397806823228)
120690 110630 2 46 1050X MANDALAY LN 1 20 1 1           5991857.0 2101850.0 37.7508112705894 -122.47101756601101 (37.7508112705894, -122.471017566011)
13722 91035 3 46 1051X Folsom St 5 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6010666.0508 2111208.1223 37.7775764693736 -122.40663324749599 (37.7775764693736, -122.406633247496)
14760 91037 3 46 1051X Folsom St 7 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6010705.7086 2111246.6708 37.7776845332645 -122.40649877417499 (37.7776845332645, -122.406498774175)
15087 91034 3 46 1051X Folsom St 4 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6010653.2937 2111194.8106 37.7775392048064 -122.406676440472 (37.7775392048064, -122.406676440472)
15203 91033 3 46 1051X Folsom St 3 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6010628.8889 2111172.6244 37.777476921213605 -122.40675930128401 (37.7774769212136, -122.406759301284)
15284 91036 3 46 1051X Folsom St 6 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6010688.5143 2111227.8126 37.7776317911098 -122.406556926191 (37.7776317911098, -122.406556926191)
16241 91032 3 46 1051X Folsom St 2 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6010616.6864 2111159.8673 37.777441210433395 -122.40680061468099 (37.7774412104334, -122.406800614681)
32202 91031 3 46 1051X Folsom St 1 1 1 2   11/18/2008 12:00:00 AM 3 3x3   6010606.147999999 2111149.8835 37.7774132075868 -122.406836366848 (37.7774132075868, -122.406836366848)
149318 36939 1 46 106 03rd Ave 1 1 1 1 1 05/29/1998 12:00:00 AM 14   Permit Number 39578 5994917.29896 2114783.54641 37.78649992768511 -122.461372345087 (37.7864999276851, -122.461372345087)
12439 17499 3 46 106 Persia Ave 1 1 1 2   02/21/2008 12:00:00 AM 3 3X3   6002048.76612 2091365.2856599998 37.722606864403296 -122.435023785838 (37.7226068644033, -122.435023785838)
15989 7405 3 46 1065 Folsom St 1 1 1 2   12/15/1998 12:00:00 AM 6 3X3   6010535.4473 2111084.5056 37.7772297388865 -122.407076335552 (37.7772297388865, -122.407076335552)
17373 4565 1 46 106X Virginia Ave 1 1 1 1     12 3X3   6006455.63138 2098554.07674 37.742594946206296 -122.420300179707 (37.7425949462063, -122.420300179707)
20914 4566 1 46 106X Virginia Ave 2 1 1 1   07/01/2016 12:00:00 AM 12 3X3   6006479.71302 2098542.22808 37.742563769401606 -122.42021607152901 (37.7425637694016, -122.420216071529)
99951 119755 3 46 106x Octavia St Frontage West 10 11 1 2           2109793.0 6005627.0 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)
17228 23635 3 46 108 Virginia Ave 1 1 1 2     18 5x5   6006522.04559 2098512.21616 37.742483748623 -122.420067568263 (37.742483748623, -122.420067568263)
2748 30802 1 46 109 Chilton Ave 1 1 1 1 1 02/06/1995 12:00:00 AM 10 4x6 Permit Number 34667 6001649.83524 2095450.8302099998 37.733802178321 -122.43669510478998 (37.733802178321, -122.43669510479)
16759 26628 3 46 1099X Bay Shore Blvd 1 1 1 2   03/05/2003 12:00:00 AM 3 3X3   6011258.58098 2094170.8511 37.7308290106415 -122.403384596621 (37.7308290106415, -122.403384596621)
35154 123692 2 46 11 Clement St 1 1 1 1     8 Width 3ft   5995433.731430001 2113533.85695 37.7830983254289 -122.45949508803699 (37.7830983254289, -122.459495088037)
12233 17490 1 46 11 Persia Ave 1 1 1 1     17 3X3   6001895.26392 2091509.73666 37.7229947770751 -122.435564737019 (37.7229947770751, -122.435564737019)
160840 140522 2 46 1100 McAllister St 1 1 1 1     16 Width 0ft   6003844.9407 2111829.9916 37.7788999800677 -122.43027413185499 (37.7788999800677, -122.430274131855)
11929 17621 3 46 1100 Persia Ave 1 1 1 2     10 3X3   6004336.281690001 2089926.3148400001 37.7187853887157 -122.42701391015899 (37.7187853887157, -122.427013910159)
124040 17622 1 46 1100 Persia Ave 2 1 1 1     40 3X3   6004279.363726401 2089959.3319014 37.7188728276872 -122.427213003456 (37.7188728276872, -122.427213003456)
141469 28264 3 46 1100X McAllister St 1 1 1 2     18 3X3   6003899.2367 2111834.49982 37.7789154337837 -122.43008662212601 (37.7789154337837, -122.430086622126)
11325 17624 3 46 1101 Persia Ave 2 1 1 2     50 3X3   6004341.89656 2089971.87372 37.7189108009657 -122.426997744874 (37.7189108009657, -122.426997744874)
13231 17623 3 46 1101 Persia Ave 1 1 1 2     35 3X3   6004371.84322 2089954.8563599999 37.718865768324 -122.426893019707 (37.718865768324, -122.426893019707)
48146 180566 2 46 111 Ney St 1 1 1 1     4 Width 3ft   6004117.41747 2094047.5610599997 37.730089041271206 -122.42806396757099 (37.7300890412712, -122.428063967571)
62701 242666 2 46 1110 Sanchez St 2 1 1 1     7 Width 3ft   6003798.0893 2101733.84258 37.7511757357942 -122.429715924165 (37.7511757357942, -122.429715924165)
177354 242665 2 46 1110 Sanchez St 1 1 1 1     6 Width 3ft   6003796.20784 2101754.26295 37.7512316988054 -122.42972388675899 (37.7512316988054, -122.429723886759)
61326 140553 2 46 1111 McAllister St 1 1 1 1     16 Width 0ft   6003847.0209 2111777.1269 37.778754944533794 -122.43026316304501 (37.7787549445338, -122.430263163045)
127520 23744 3 46 1111X McAllister St 1 1 1 2     12 4X4   6003857.72301 2111778.219 37.7787585493448 -122.430226218205 (37.7787585493448, -122.430226218205)
76983 201851 2 46 1119 Folsom St 1 1 1 1     6 Width 0ft   6010210.791 2110772.6508 37.7763552850367 -122.40817743097799 (37.7763552850367, -122.408177430978)
92745 95635 1 46 111X 14th St 2 1 1 1   02/05/2016 12:00:00 AM 3 3x3 Permit Number 777379 6007972.0 2107962.0 37.76851228983521 -122.415722998498 (37.7685122898352, -122.415722998498)
34661 242376 2 46 112 Fair Oaks St 2 1 1 1     17 Width 3ft   6005382.46829 2102954.4101 37.7546167200124 -122.424323769035 (37.7546167200124, -122.424323769035)
85473 98928 2 46 112 Fair Oaks St 2 1 1 1       3x3   6005385.0 2103055.0 37.7548930594212 -122.42432216764401 (37.7548930594212, -122.424322167644)
20233 23636 3 46 112 Virginia Ave 1 1 1 2     6 3X3   6006546.53068 2098501.4948299997 37.742455689777294 -122.419982145278 (37.7424556897773, -122.419982145278)
13417 85790 3 46 1125 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6010146.2096 2110708.8868 37.776176587646 -122.408396338404 (37.776176587646, -122.408396338404)
12432 17625 3 46 1132 Persia Ave 1 1 1 2     45 3x3   6004425.094930001 2089870.4961599999 37.7186371444562 -122.426702945308 (37.7186371444562, -122.426702945308)
63412 66733 1 46 1133 Taylor St 2 1 1 1   09/06/1991 12:00:00 AM     Permit Number 29980 6008997.0 2116859.0 37.7929988993441 -122.41280668476999 (37.7929988993441, -122.41280668477)
150445 180561 2 46 1134 Naples St 2 2 1 1     10 Width 8ft   6001348.51244 2087850.78247 37.712917038962495 -122.437192888562 (37.7129170389625, -122.437192888562)
165192 180560 2 46 1134 Naples St 1 2 1 1     15 Width 8ft   6001363.50733 2087875.35573 37.7129853640648 -122.437142819708 (37.7129853640648, -122.437142819708)
13153 17626 3 46 1135 Persia Ave 1 1 1 2     50 3X3   6004454.014359999 2089904.4684 37.718732059816205 -122.42660540034099 (37.7187320598162, -122.426605400341)
96603 17627 3 46 1135 Persia Ave 2 1 1 2   04/27/2005 12:00:00 AM 3 3X3   6004380.712681401 2089954.6929998002 37.718865821274 -122.42686234984801 (37.718865821274, -122.426862349848)
104545 51892 1 46 1135 Persia Ave 1 1 1 1   07/18/2005 12:00:00 AM     Permit Number 48104 6004381.23162594 2089955.54800101 37.7188681982632 -122.42686061692 (37.7188681982632, -122.42686061692)
133150 137046 2 46 1149 Taylor St 2 1 1 1     6 Width 4ft   6008987.23365 2116902.13898 37.79311680025621 -122.412843528313 (37.7931168002562, -122.412843528313)
48729 242737 2 46 115 Corbett Ave 4 1 1 1     15 Width 2ft   6000767.45695 2105648.39413 37.7617520652142 -122.44047687542201 (37.7617520652142, -122.440476875422)
70517 242735 2 46 115 Corbett Ave 2 1 1 1     16 Width 3ft   6000736.15625 2105646.04373 37.7617438292481 -122.440584963137 (37.7617438292481, -122.440584963137)
158525 242736 2 46 115 Corbett Ave 3 1 1 1     14 Width 2ft   6000751.24207 2105647.23063 37.761747947223 -122.440532872599 (37.761747947223, -122.440532872599)
187500 242738 2 46 115 Corbett Ave 6 1 1 1     13 Width 3ft   6000793.83368 2105649.34692 37.7617561832258 -122.440385717444 (37.7617561832258, -122.440385717444)
3289 253392 4 46 115 Steuart St 1 1 1 1   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.163380001 2116767.09226 37.793068003154104 -122.392879995147 (37.7930680031541, -122.392879995147)
3293 253393 4 46 115 Steuart St 2 1 1 1   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.163380001 2116767.09226 37.793068003154104 -122.392879995147 (37.7930680031541, -122.392879995147)
3316 253394 4 46 115 Steuart St 3 1 1 1   08/30/2017 12:00:00 AM 3 3x3 Permit Number 771767 6014754.163380001 2116767.09226 37.793068003154104 -122.392879995147 (37.7930680031541, -122.392879995147)
149264 242637 2 46 1155 Florida St 1 1 1 1     1 Width 3ft   6009490.58468 2102465.6938 37.7535059322676 -122.410082245404 (37.7535059322676, -122.410082245404)
14198 85789 1 46 1157 Folsom St 1 1 1 1   05/07/2007 12:00:00 AM 8 3x3   6009966.4934 2110538.8397 37.7756996123582 -122.409006027185 (37.7756996123582, -122.409006027185)
42458 242448 2 46 1157 Stanyan St 1 1 1 1     1 Width 4ft   5997336.0067 2106240.14847 37.7631808847241 -122.452387528971 (37.7631808847241, -122.452387528971)
14226 85788 1 46 1161 Folsom St 1 1 1 1   05/07/2007 12:00:00 AM 3 3x3   6009943.5141 2110517.0093 37.775638383908 -122.409083977926 (37.775638383908, -122.409083977926)
146841 83229 1 46 1169 Bay St 1 1 1 1   07/01/2009 12:00:00 AM 8 3x3 Permit Number 52333 6005183.33361 2120915.83626 37.8039231412044 -122.426291152916 (37.8039231412044, -122.426291152916)
11102 56779 1 46 118 Naples St 1 1 1 1   07/26/1974 12:00:00 AM 10 3x3 Permit Number 14000 6004445.70809 2092827.36067 37.726757210476606 -122.42684215943899 (37.7267572104766, -122.426842159439)
143378 23638 1 46 118 VIRGINIA AVE 1 1 1 1   11/10/2015 12:00:00 AM 12 4x4 Permit Number 776560 6006594.0 2098480.0 37.7423993441016 -122.41981648533199 (37.7423993441016, -122.419816485332)
20985 87685 1 46 118 Virginia Ave   1 1 1   05/23/2008 12:00:00 AM   4x4 Permit Number 776560 6006594.8 2098480.6 37.7424010366351 -122.419813761733 (37.7424010366351, -122.419813761733)
16092 85760 3 46 1196 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6009690.0521 2110363.0901 37.7752015556324 -122.40994990092399 (37.7752015556324, -122.409949900924)
174653 64959 1 46 12 Retiro Way 1 1 1 1   03/30/1989 12:00:00 AM 11   Permit Number 25993 6001806.8392 2121193.6655099997 37.804494553342096 -122.437995616222 (37.8044945533421, -122.437995616222)
94108 88329 1 46 120 London St   1 1 1   07/10/2008 12:00:00 AM   3x3 Permit Number 51317 6002940.0 2092960.0 37.7270361584814 -122.432056812936 (37.7270361584814, -122.432056812936)
163680 76181 2 46 1200 Folsom St 2 1 1 1 1 09/10/1994 12:00:00 AM 3     6009574.6956 2110252.7468 37.7748921128949 -122.410341153951 (37.7748921128949, -122.410341153951)
55907 137045 2 46 1200 Sacramento St 3 1 1 1     8 Width 2ft   6008938.66451 2116698.53363 37.792555023435796 -122.41299717838899 (37.7925550234358, -122.412997178389)
172287 56515 1 46 1200 Sacramento St 1 1 1 1   11/13/1978 12:00:00 AM 10   Permit Number 17376 6008990.48315 2116704.87455 37.7925753427324 -122.412818332001 (37.7925753427324, -122.412818332001)
174322 137044 2 46 1200 Sacramento St 2 1 1 1     7 Width 2ft   6008949.11114 2116700.62228 37.7925613447696 -122.41296118031099 (37.7925613447696, -122.412961180311)
93435 16411 3 46 1200X Newcomb Ave 1 1 1 2     12 3x3   6016451.798598001 2094870.8752060002 37.7330398269448 -122.38547940494499 (37.7330398269448, -122.385479404945)
108708 16415 3 46 1200X Newcomb Ave 5 1 1 2     12 3x3   6016451.798598001 2094870.8752060002 37.7330398269448 -122.38547940494499 (37.7330398269448, -122.385479404945)
176511 242400 2 46 1201 San Jose Ave 34 7 1 1     5     6004412.57648 2096019.13863 37.7355192458083 -122.427183945908 (37.7355192458083, -122.427183945908)
182744 242401 2 46 1201 San Jose Ave 35 7 1 1     3     6004422.12829 2096026.22682 37.7355392485419 -122.427151426394 (37.7355392485419, -122.427151426394)
82805 44113 1 46 1201 Treat Ave 4 1 1 1   11/22/2000 12:00:00 AM     Permit Number 43622 6008701.91833416 2101542.01473417 37.7509254812099 -122.41274433750601 (37.7509254812099, -122.412744337506)
91822 44116 1 46 1201 Treat Ave 1 1 1 1   11/22/2000 12:00:00 AM     Permit Number 43622 6008701.91833416 2101542.01473417 37.7509254812099 -122.41274433750601 (37.7509254812099, -122.412744337506)
102982 44114 1 46 1201 Treat Ave 3 1 1 1   11/22/2000 12:00:00 AM     Permit Number 43622 6008701.91833416 2101542.01473417 37.7509254812099 -122.41274433750601 (37.7509254812099, -122.412744337506)
123175 44112 1 46 1201 Treat Ave 5 1 1 1   11/22/2000 12:00:00 AM     Permit Number 43622 6008701.91833416 2101542.01473417 37.7509254812099 -122.41274433750601 (37.7509254812099, -122.412744337506)
172502 242403 2 46 1201 Treat Ave 12 1 1 1     7 Width 4ft   6008707.95248 2101269.88955 37.75017862504279 -122.412704235035 (37.7501786250428, -122.412704235035)
36571 83024 1 46 1209 18th St 1 1 1 1   07/02/2009 12:00:00 AM 8 3x3 Permit Number 52375 6013948.88284 2105690.7354200003 37.762610074220206 -122.39489022832399 (37.7626100742202, -122.394890228324)
166749 81876 1 46 1209 18th St 2 1 1 1   07/02/2009 12:00:00 AM 7 3x3 Permit Number 52375 6013966.08986 2105691.70822 37.762613702073004 -122.394830783137 (37.762613702073, -122.394830783137)
149313 242611 2 46 121 Virginia Ave 3 1 1 1     17 Width 5ft   6006528.89277 2098549.54535 37.7425866319823 -122.42004654122299 (37.7425866319823, -122.420046541223)
14196 85787 1 46 1211 Folsom St 2 1 1 1   05/07/2007 12:00:00 AM 4 3x3   6009621.8032 2110211.384 37.7747811809083 -122.410175277249 (37.7747811809083, -122.410175277249)
14251 85786 3 46 1211 Folsom St 1 1 1 2   05/07/2007 12:00:00 AM 3 3x3   6009596.5259 2110188.4047 37.7747166682516 -122.410261094209 (37.7747166682516, -122.410261094209)
52590 198500 2 46 1215 Michigan St 8 1 1 1     12 Width 6ft   6016504.90448 2102523.10402 37.754054221042 -122.385828988529 (37.754054221042, -122.385828988529)
57062 198499 2 46 1215 Michigan St 7 1 1 1     4 Width 3ft   6016506.220509999 2102490.10595 37.753963688078706 -122.38582213748 (37.7539636880787, -122.38582213748)
155342 198498 2 46 1215 Michigan St 6 1 1 1     5 Width 4ft   6016508.17513 2102448.92255 37.753850715249 -122.38581250754801 (37.753850715249, -122.385812507548)
132769 242379 2 46 1217 San Bruno Ave 1 1 1 1     1 Width 3ft   6011152.0776 2102554.59258 37.7538430143636 -122.40434267049 (37.7538430143636, -122.40434267049)
180271 242380 2 46 1217 San Bruno Ave 2 1 1 1     1 Width 3ft   6011151.17373 2102568.66425 37.75388160155921 -122.404346786677 (37.7538816015592, -122.404346786677)
13831 85785 1 46 1221 Folsom St 1 1 1 1   05/07/2007 12:00:00 AM 5 3x3   6009541.3755 2110133.2543 37.7745621465765 -122.41044797634198 (37.7745621465765, -122.410447976342)
27071 137049 2 46 1221 Jones St 3 1 1 1     10 Width 3ft   6008515.90058 2116780.9457099997 37.7927575660663 -122.414465794683 (37.7927575660663, -122.414465794683)
49086 137048 2 46 1221 Jones St 2 1 1 1     9 Width 3ft   6008515.8047 2116792.05002 37.7927880503911 -122.414466912531 (37.7927880503911, -122.414466912531)
60626 137052 2 46 1221 Jones St 6 1 1 1     12 Width 3ft   6008525.03986 2116714.30677 37.7925751052991 -122.414429454859 (37.7925751052991, -122.414429454859)
76377 137050 2 46 1221 Jones St 4 1 1 1     11 Width 3ft   6008520.18365 2116745.46008 37.7926603718421 -122.41444846295 (37.7926603718421, -122.41444846295)
159494 53398 1 46 1221 Jones St 1 1 1 1   05/17/1972 12:00:00 AM 9   Permit Number 9833 6008515.21769 2116802.84208 37.7928176497632 -122.414469707612 (37.7928176497632, -122.414469707612)
173523 137051 2 46 1221 Jones St 5 1 1 1     10 Width 3ft   6008522.47154 2116730.9321 37.79262061009871 -122.414439518287 (37.7926206100987, -122.414439518287)
Powered by Datasette · Query took 21.71ms · Data source: data.sfgov.org