sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
2490 119764 3 9 101X Octavia St Frontage West 6 1 1 2       4x4            
2496 119765 3 9 101X Octavia St Frontage West 7 1 1 2       4x4            
2509 119763 3 9 101X Octavia St Frontage West 5 1 1 2       4x4            
3007 253279 2 9 201X Laguna Honda Blvd 1 9 1 2       10x10 ROW IS 10' tree is street tree          
59350 84206 1 9 655 Sunnydale Ave 5 1 1 1   06/05/2008 12:00:00 AM 8 3x3 Permit Number 50698 6009700.46384 2086497.5066400003 37.7096724504982 -122.40823029041 (37.7096724504982, -122.40823029041)
70211 84207 1 9 655 Sunnydale Ave 4 1 1 1   06/05/2008 12:00:00 AM 8 3x3 Permit Number 50698 6009673.82964 2086513.38985 37.7097145711409 -122.408323462874 (37.7097145711409, -122.408323462874)
151992 84208 1 9 655 Sunnydale Ave 3 1 1 1   06/05/2008 12:00:00 AM 8 3x3 Permit Number 50698 6009650.10329 2086520.7766900002 37.709733525243394 -122.40840598644199 (37.7097335252434, -122.408405986442)
149413 84209 1 9 655 Sunnydale Ave 2 1 1 1   06/05/2008 12:00:00 AM 8 3x3 Permit Number 50698 6009625.62268 2086528.94568 37.7097545846723 -122.408491172057 (37.7097545846723, -122.408491172057)
174381 84210 1 9 655 Sunnydale Ave 1 1 1 1   06/05/2008 12:00:00 AM 8 3x3 Permit Number 50698 6009606.75025 2086539.9182400003 37.709783656161605 -122.408557172383 (37.7097836561616, -122.408557172383)
166186 112969 2 9 701 Sunnydale Ave 9 1 1 1     8 3x3   6009537.04857 2086566.80096 37.7098535667562 -122.408799970467 (37.7098535667562, -122.408799970467)
163187 112968 2 9 701 Sunnydale Ave 8 1 1 1     8 3x3   6009509.441330001 2086572.7332900001 37.709868309348394 -122.40889580489299 (37.7098683093484, -122.408895804893)
148831 112967 2 9 701 Sunnydale Ave 7 1 1 1     8 3x3   6009490.41259 2086583.85945 37.709897793608896 -122.408962356547 (37.7098977936089, -122.408962356547)
31640 112966 2 9 701 Sunnydale Ave 6 1 1 1     8 3x3   6009445.28541 2086599.3527799998 37.709937807151704 -122.409119417731 (37.7099378071517, -122.409119417731)
64815 112965 2 9 701 Sunnydale Ave 5 1 1 1     8 3x3   6009423.83756 2086605.1592 37.7099525488346 -122.409193955337 (37.7099525488346, -122.409193955337)
32246 187491 2 9 750 Velasco Ave 2 2 1 1     3     6006526.88476 2086669.8859599999 37.7099675513223 -122.419210983794 (37.7099675513223, -122.419210983794)
48198 112964 2 9 701 Sunnydale Ave 4 1 1 1     8 3x3   6009407.05623 2086613.17163 37.7099736091697 -122.409252520091 (37.7099736091697, -122.409252520091)
74253 112963 2 9 701 Sunnydale Ave 3 1 1 1     8 3x3   6009387.902419999 2086618.16453 37.709986245537294 -122.40931907171199 (37.7099862455373, -122.409319071712)
151648 187492 2 9 750 Velasco Ave 3 2 1 1     3     6006524.35531 2086677.42218 37.7099881017507 -122.419220260308 (37.7099881017507, -122.419220260308)
146989 112962 2 9 701 Sunnydale Ave 2 1 1 1     8 3x3   6009373.36818 2086623.06286 37.7099988810277 -122.409369650496 (37.7099988810277, -122.409369650496)
156294 112961 2 9 701 Sunnydale Ave 1 1 1 1     9 3x3   6009358.8024 2086626.42802 37.710007304956605 -122.409420230177 (37.7100073049566, -122.409420230177)
54048 179198 2 9 122 Santos St 7 9 1 1     3 Width 6ft   6006476.020330001 2086698.2398299999 37.7100425404106 -122.41938879147 (37.7100425404106, -122.41938879147)
4087 159329 2 9 556 Ellington Ave 1 1 1 1   10/05/2017 11:09:00 AM 3 Width 0ft   5997921.94288 2087046.44589 37.7105131349458 -122.448978278232 (37.7105131349458, -122.448978278232)
31551 179200 2 9 65 Blythdale Ave 2 9 1 1     7 Width 6ft   6006727.82618 2086918.41314 37.7106612694605 -122.418534101884 (37.7106612694605, -122.418534101884)
26875 179199 2 9 65 Blythdale Ave 1 9 1 1     8 Width 6ft   6006710.21835 2086918.77417 37.710661269476 -122.41859498419 (37.710661269476, -122.41859498419)
160335 179202 2 9 50 Santos St 4 9 1 1     5 Width 6ft   6006615.933569999 2086979.4031 37.710822435165205 -122.41892515139799 (37.7108224351652, -122.418925151398)
39093 179201 2 9 50 Santos St 3 9 1 1     6 Width 6ft   6006633.11275 2086991.19455 37.7108557793466 -122.418866611803 (37.7108557793466, -122.418866611803)
3998 159324 2 9 516 Ellington Ave 1 1 1 1   10/05/2017 10:39:00 AM 3 Width 0ft   5998061.98233 2087178.88925 37.710884802276205 -122.44850380581998 (37.7108848022762, -122.44850380582)
55470 179197 2 9 165 Blythdale Ave 1 9 1 1     10 Width 6ft   6005726.28272 2087133.8162 37.7111962851662 -122.42201095643499 (37.7111962851662, -122.422010956435)
50936 179196 2 9 178 Brookdale Ave 3 9 1 1     6 Width 6ft   6005626.77881 2087137.8945099998 37.7112018708407 -122.42235515666599 (37.7112018708407, -122.422355156666)
4015 159294 2 9 118 Whipple Ave 1 1 1 1   10/05/2017 02:12:00 PM 3 Width 0ft   5998151.37307 2087303.3135799998 37.7112315538724 -122.44820380548799 (37.7112315538724, -122.448203805488)
44669 179195 2 9 178 Brookdale Ave 2 9 1 1     5 Width 6ft   6005631.155180001 2087152.0442 37.7112409697606 -122.422341035527 (37.7112409697606, -122.422341035527)
49167 179194 2 9 178 Brookdale Ave 1 9 1 1     5 Width 6ft   6005636.53153 2087165.1563799998 37.7112772763038 -122.422323384518 (37.7112772763038, -122.422323384518)
188341 179203 2 9 145 Blythdale Ave 1 9 1 1     5 Width 6ft   6005739.90981 2087176.84104 37.711315190823996 -122.42196691216101 (37.711315190824, -122.421966912161)
63599 179204 2 9 145 Blythdale Ave 2 9 1 1     51 Width 6ft   6005707.03107 2087192.3586400002 37.711355944501 -122.422081651264 (37.711355944501, -122.422081651264)
26179 179193 2 9 170 Brookdale Ave 7 9 1 1     3 Width 6ft   6005644.83636 2087196.5165400002 37.7113638531203 -122.422296907583 (37.7113638531203, -122.422296907583)
184195 179192 2 9 170 Brookdale Ave 6 9 1 1     3 Width 6ft   6005649.34848 2087217.2749299998 37.711421105778996 -122.422282786434 (37.711421105779, -122.422282786434)
57344 179191 2 9 170 Brookdale Ave 5 9 1 1     5 Width 6ft   6005654.25627 2087232.43068 37.711462997092205 -122.42226689991999 (37.7114629970922, -122.42226689992)
28265 179185 2 9 1500 Sunnydale Ave 3 9 1 1     4 Width 6ft   6007214.91098 2087479.51248 37.7122293408956 -122.41689035163401 (37.7122293408956, -122.416890351634)
148480 179186 2 9 1500 Sunnydale Ave 4 9 1 1     6 Width 6ft   6007201.69456 2087483.6172599997 37.712239868336894 -122.416936322255 (37.7122398683369, -122.416936322255)
134919 179187 2 9 1500 Sunnydale Ave 7 9 1 1     5 Width 6ft   6007159.282430001 2087497.73072 37.712276235134794 -122.41708391091998 (37.7122762351348, -122.41708391092)
74136 179188 2 9 1500 Sunnydale Ave 8 9 1 1     5 Width 6ft   6007144.00968 2087503.96893 37.7122925047707 -122.41713713998199 (37.7122925047707, -122.417137139982)
185866 179189 2 9 1600 Sunnydale Ave 1 9 1 1     6 Width 6ft   6007006.17756 2087541.64708 37.712388206122 -122.417616198935 (37.712388206122, -122.417616198935)
4025 159222 2 9 384 Ellington Ave 1 1 1 1   10/05/2017 09:28:00 AM 3 Width 0ft   5998624.92984 2087716.64467 37.712393528324206 -122.446596800611 (37.7123935283242, -122.446596800611)
133095 179190 2 9 1600 Sunnydale Ave 2 9 1 1     10 Width 6ft   6006848.67689 2087568.72125 37.71245368215921 -122.418162488524 (37.7124536821592, -122.418162488524)
4104 159219 2 9 366 Ellington Ave 1 1 1 1   10/05/2017 09:32:00 AM 3 Width 0ft   5998673.37335 2087760.7240000002 37.7125173271842 -122.446432534932 (37.7125173271842, -122.446432534932)
4042 179821 2 9 364 Ellington Ave 1 1 1 1   10/05/2017 10:07:00 AM 3 Width 2ft   5998698.94465 2087786.79601 37.712590375508796 -122.446346027354 (37.7125903755088, -122.446346027354)
63898 179230 2 9 1725 Sunnydale Ave 3 9 1 1     6 Width 10ft   6006577.9120000005 2087637.98608 37.712628624579395 -122.41910324683998 (37.7126286245794, -122.41910324684)
51456 179205 2 9 1700 Sunnydale Ave 1 9 1 1     8 Width 10ft   6006698.43617 2087637.4256 37.7126338721354 -122.418686636782 (37.7126338721354, -122.418686636782)
54258 179206 2 9 1700 Sunnydale Ave 2 9 1 1     10 Width 10ft   6006680.55061 2087645.0552700001 37.712653814591 -122.418748995784 (37.712653814591, -122.418748995784)
185850 179229 2 9 1725 Sunnydale Ave 2 9 1 1     5 Width 10ft   6006523.82481 2087658.59053 37.712682154019 -122.41929165028999 (37.712682154019, -122.41929165029)
69779 179228 2 9 1725 Sunnydale Ave 1 9 1 1     5 Width 10ft   6006500.20711 2087667.48458 37.7127052450291 -122.419373911274 (37.7127052450291, -122.419373911274)
155573 179227 2 9 1751 Sunnydale Ave 2 9 1 1     11 Width 10ft   6006428.508719999 2087690.36193 37.7127640229211 -122.419623346348 (37.7127640229211, -122.419623346348)
24120 179207 2 9 1750 Sunnydale Ave 2 9 1 1     10 Width 10ft   6006573.63704 2087691.58982 37.7127755684169 -122.41912182232402 (37.7127755684169, -122.419121822324)
44475 179208 2 9 1750 Sunnydale Ave 3 9 1 1     10 Width 10ft   6006534.036859999 2087707.31011 37.712816502856796 -122.419259808007 (37.7128165028568, -122.419259808007)
147788 179226 2 9 1751 Sunnydale Ave 1 9 1 1     10 Width 10ft   6006357.33519 2087720.1094 37.7128416937526 -122.419871454925 (37.7128416937526, -122.419871454925)
78036 41518 1 9 208 Peninsula Ave 9 1 1 1   04/20/2000 12:00:00 AM     Permit Number 42062 6012484.96446964 2087604.06197755 37.712866358901294 -122.398684103253 (37.7128663589013, -122.398684103253)
81458 41517 1 9 208 Peninsula Ave 1 1 1 1   04/20/2000 12:00:00 AM     Permit Number 42062 6012484.96446964 2087604.06197755 37.712866358901294 -122.398684103253 (37.7128663589013, -122.398684103253)
104292 41511 1 9 208 Peninsula Ave 5 1 1 1   04/20/2000 12:00:00 AM     Permit Number 42062 6012484.96446964 2087604.06197755 37.712866358901294 -122.398684103253 (37.7128663589013, -122.398684103253)
104945 41513 1 9 208 Peninsula Ave 7 1 1 1   04/20/2000 12:00:00 AM     Permit Number 42062 6012484.96446964 2087604.06197755 37.712866358901294 -122.398684103253 (37.7128663589013, -122.398684103253)
105710 41514 1 9 208 Peninsula Ave 8 1 1 1   04/20/2000 12:00:00 AM     Permit Number 42062 6012484.96446964 2087604.06197755 37.712866358901294 -122.398684103253 (37.7128663589013, -122.398684103253)
119767 41512 1 9 208 Peninsula Ave 6 1 1 1   04/20/2000 12:00:00 AM     Permit Number 42062 6012484.96446964 2087604.06197755 37.712866358901294 -122.398684103253 (37.7128663589013, -122.398684103253)
125677 41516 1 9 208 Peninsula Ave 10 1 1 1   04/20/2000 12:00:00 AM     Permit Number 42062 6012484.96446964 2087604.06197755 37.712866358901294 -122.398684103253 (37.7128663589013, -122.398684103253)
142479 41520 1 9 208 Peninsula Ave 2 1 1 1   04/20/2000 12:00:00 AM     Permit Number 42062 6012484.96446964 2087604.06197755 37.712866358901294 -122.398684103253 (37.7128663589013, -122.398684103253)
143714 41515 1 9 208 Peninsula Ave 4 1 1 1   04/20/2000 12:00:00 AM     Permit Number 42062 6012484.96446964 2087604.06197755 37.712866358901294 -122.398684103253 (37.7128663589013, -122.398684103253)
143880 41519 1 9 208 Peninsula Ave 3 1 1 1   04/20/2000 12:00:00 AM     Permit Number 42062 6012484.96446964 2087604.06197755 37.712866358901294 -122.398684103253 (37.7128663589013, -122.398684103253)
28483 179209 2 9 1772 Sunnydale Ave 1 9 1 1     7 Width 10ft   6006471.88428 2087727.6982 37.712868983682604 -122.419476073376 (37.7128689836826, -122.419476073376)
131276 87955 1 9 240 Leland Ave 2 1 1 1   06/19/2008 12:00:00 AM 4 3x3 Permit Number 50979 6009689.61 2087667.18 37.712883527737006 -122.40835025024599 (37.712883527737, -122.408350250246)
69086 179225 2 9 1801 Sunnydale Ave 3 9 1 1     9 Width 10ft   6006308.59662 2087739.45788 37.71289207468671 -122.420041283778 (37.7128920746867, -122.420041283778)
73849 179210 2 9 1772 Sunnydale Ave 2 9 1 1     8 Width 10ft   6006450.99959 2087738.82958 37.7128983717435 -122.41954904706499 (37.7128983717435, -122.419549047065)
154768 179224 2 9 1801 Sunnydale Ave 2 9 1 1     9 Width 10ft   6006288.05669 2087748.6711799998 37.7129162151802 -122.420112930068 (37.7129162151802, -122.420112930068)
4119 159216 2 9 326 Ellington Ave 1 1 1 1   10/05/2017 10:09:00 AM 3 Width 0ft   5998830.44796 2087909.1779599998 37.712933918350394 -122.445900308946 (37.7129339183504, -122.445900308946)
73852 179223 2 9 1801 Sunnydale Ave 1 9 1 1     14 Width 10ft   6006254.517659999 2087760.44493 37.7129466536263 -122.42022968726299 (37.7129466536263, -122.420229687263)
165777 179211 2 9 1800 Sunnydale Ave 1 9 1 1     9 Width 10ft   6006359.89696 2087770.1325599998 37.7129791911096 -122.419866148013 (37.7129791911096, -122.419866148013)
48309 179212 2 9 1800 Sunnydale Ave 2 9 1 1     11 Width 10ft   6006336.27941 2087779.02675 37.713002282110295 -122.419948408995 (37.7130022821103, -122.419948408995)
75489 179213 2 9 1800 Sunnydale Ave 3 9 1 1     12 Width 10ft   6006300.8377 2087791.60426 37.7130348204719 -122.420071799571 (37.7130348204719, -122.420071799571)
117034 179222 2 9 1825 Sunnydale Ave 1 9 1 1     14 Width 10ft   6006153.59555 2087799.59528 37.7130484649775 -122.420581285317 (37.7130484649775, -122.420581285317)
162500 179231 2 9 321 Ellington Ave 4 1 1 1     6 Width 2ft   5998927.87734 2087954.11713 37.7130628739226 -122.445566791793 (37.7130628739226, -122.445566791793)
137277 179221 2 9 1851 Sunnydale Ave 3 9 1 1     9 Width 10ft   6006089.55617 2087821.5515700001 37.713105142972296 -122.420804184985 (37.7131051429723, -122.420804184985)
120602 115341 2 9 1514 SUNNYDALE AVE 2 9 1 20 3     3x3   6006572.0 2087815.0 37.7131143345755 -122.41913622882099 (37.7131143345755, -122.419136228821)
26907 179220 2 9 1851 Sunnydale Ave 2 9 1 1     9 Width 10ft   6006068.28025 2087832.3093700001 37.7131334823856 -122.420878485149 (37.7131334823856, -122.420878485149)
30562 179219 2 9 1901 Sunnydale Ave 2 9 1 1     9 Width 10ft   6005910.8454 2087904.7300099998 37.7133234587798 -122.42142777398399 (37.7133234587798, -122.421427773984)
65999 179218 2 9 1901 Sunnydale Ave 1 9 1 1     11 Width 10ft   6005890.39204 2087918.14698 37.713359145694795 -122.42149942028401 (37.7133591456948, -122.421499420284)
42567 179214 2 9 1900 Sunnydale Ave 1 9 1 1     13 Width 10ft   6005943.70452 2087934.63592 37.7134074266914 -122.421316323695 (37.7134074266914, -122.421316323695)
40967 179215 2 9 1900 Sunnydale Ave 2 9 1 1     12 Width 10ft   6005901.26281 2087961.5006799998 37.7134787986892 -122.421464924083 (37.7134787986892, -122.421464924083)
103237 69394 1 9 40 Morse St 1 1 1 1 1 05/09/1994 12:00:00 AM     Permit Number 33498 6001207.260514401 2088075.42261957 37.7135258204231 -122.437697178946 (37.7135258204231, -122.437697178946)
170574 179216 2 9 1924 Sunnydale Ave 1 9 1 1     12 Width 10ft   6005874.75653 2087979.24642 37.7135260301628 -122.42155779887699 (37.7135260301628, -122.421557798877)
43869 179217 2 9 2055 Sunnydale Ave 2 1 1 1     2 Width 3ft   6005575.94717 2088046.16302 37.7136929155569 -122.42259534402001 (37.7136929155569, -122.42259534402)
35869 179244 2 9 917 Edinburgh St 1 1 1 1     5 Width 6ft   6001618.54316 2088748.06741 37.7153961307972 -122.436323752237 (37.7153961307972, -122.436323752237)
135686 179245 2 9 917 Edinburgh St 2 1 1 1     3 Width 6ft   6001629.43176 2088767.7080400002 37.7154506782843 -122.436287521258 (37.7154506782843, -122.436287521258)
96302 43704 1 9 279 Bright St 1 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43347 5993731.25212267 2089033.11150067 37.7157274860875 -122.46360618846 (37.7157274860875, -122.46360618846)
136708 213819 2 9 279 Bright St 1 4 1 1     4 Width 3ft   5993740.04713 2089048.21868 37.7157694735569 -122.46357688488101 (37.7157694735569, -122.463576884881)
87874 43705 1 9 283 Bright St 1 1 1 1 1 07/25/2000 12:00:00 AM     Permit Number 43348 5993731.55292772 2089058.73633294 37.7157978630843 -122.463607007411 (37.7157978630843, -122.463607007411)
129983 213818 2 9 283 Bright St 1 4 1 1     6 Width 3ft   5993740.2865699995 2089076.61519 37.715847457382104 -122.463578116946 (37.7158474573821, -122.463578116946)
57091 179247 2 9 353 Prague St 1 10 1 1     11 Width 3ft   6003781.052759999 2089121.49913 37.7165441288874 -122.42887576852199 (37.7165441288874, -122.428875768522)
184857 213807 2 9 235 Vernon St 1 4 1 1     1 Width 3ft   5992444.29236 2089435.87285 37.7167591325169 -122.46808375276501 (37.7167591325169, -122.468083752765)
161665 213800 2 9 114 Majestic Ave 4 4 1 1     3 Width 3ft   5997059.55329 2089349.83232 37.7167883433744 -122.452124952113 (37.7167883433744, -122.452124952113)
76251 213799 2 9 114 Majestic Ave 3 4 1 1     8 Width 3ft   5997066.26777 2089358.12222 37.7168114901382 -122.452102341364 (37.7168114901382, -122.452102341364)
132573 213798 2 9 114 Majestic Ave 2 4 1 1     5 Width 3ft   5997074.19184 2089369.0687 37.716842000536296 -122.45207574122601 (37.7168420005363, -122.452075741226)
114301 97408 1 9 201@Majestic Lakeview Ave 3 1 1 1         Permit Number 43358 5997066.9 2089403.7 37.7169366723432 -122.452103442674 (37.7169366723432, -122.452103442674)
114851 97407 1 9 201@Majestic Lakeview Ave 2 1 1 1         Permit Number 43358 5997066.9 2089403.7 37.7169366723432 -122.452103442674 (37.7169366723432, -122.452103442674)
144824 65597 1 9 801 France Ave 1 1 1 1 1 02/05/1990 12:00:00 AM     Permit Number 28499 6002915.21736577 2089314.84025929 37.717025955789794 -122.431882320705 (37.7170259557898, -122.431882320705)
Powered by Datasette · Query took 15.041ms · Data source: data.sfgov.org