sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3158 253097 6 3 1290 Portola Dr 1 9 1 1 4 08/22/2017 12:00:00 AM 3 3x3   5994035.0 2097938.0 37.740195634398 -122.463202075736 (37.740195634398, -122.463202075736)
7681 103657 6 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
8197 103668 6 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
9684 173630 6 1 2699x OCEAN AVE 2 5 1 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
11212 103658 6 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
12113 103660 6 17 350X Hickory St 4 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
12885 103661 6 17 350X Hickory St 5 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
15949 103659 6 17 350X Hickory St 3 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
28447 116579 6 98 3000x 19TH AVE 2 5 1 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
80719 116576 6 40 2500x OCEAN AVE 1 9 1 6 4   30 10X10   5991377.0 2094742.0 37.7312667472315 -122.472159374256 (37.7312667472315, -122.472159374256)
114895 116578 6 1 2699x OCEAN AVE 1 5 1 6 4   11 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
120634 116580 6 98 3000x 19TH AVE 3 5 2 6 4     3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
126456 116577 6 98 3000x 19TH AVE 1 5 1 6 4   30 3x3   5990602.0 2095184.0 37.7324354869182 -122.47487091251001 (37.7324354869182, -122.47487091251)
10461 92319 6 35 2788 34th Ave 2 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985889.2586 2096423.8922 37.7355656712712 -122.491254961509 (37.7355656712712, -122.491254961509)
10597 92315 6 35 2783 34th Ave 2 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985839.9086 2096474.3035 37.73570120363421 -122.491429290175 (37.7357012036342, -122.491429290175)
10790 80073 6 35 2788 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3     5985889.2586 2096432.3825 37.735588983385 -122.49125558617901 (37.735588983385, -122.491255586179)
10899 92314 6 35 2783 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985837.7861 2096464.2212 37.7356733962807 -122.491435886509 (37.7356733962807, -122.491435886509)
12363 92312 6 12 2711 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985822.132 2096946.3119 37.7369961745626 -122.49152548244 (37.7369961745626, -122.49152548244)
12500 92318 6 35 2787 34th Ave 3 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985842.0312 2096446.1793 37.7356241060746 -122.49141988222999 (37.7356241060746, -122.49141988223)
12690 92317 6 35 2787 34th Ave 2 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985840.9699 2096433.9745 37.7355905329114 -122.491422653463 (37.7355905329114, -122.491422653463)
13114 92316 6 35 2787 34th Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5985840.4393 2096424.4229 37.7355642757438 -122.49142378511002 (37.7355642757438, -122.49142378511)
19027 97174 6 37 26 Gilbert St   5 1 1 1         6011445.1 2110013.2 37.7743390438118 -122.40385413458 (37.7743390438118, -122.40385413458)
19054 94934 6 311 2451X Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
44829 94949 6 31 50 Pomona St   24 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
50102 94943 6 417 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
58967 96572 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
80217 92320 6 2 2733 Wawona St 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5984522.0 2096783.0 37.736471699686206 -122.49600850837099 (37.7364716996862, -122.496008508371)
80235 96569 6 12 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
81078 94935 6 469 2451X Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
81160 96570 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
83580 92310 6 18 2591 26th Ave 1 5 1 1 1 10/18/2008 12:00:00 AM   3x3   5988279.0 2097698.2 37.7392039339278 -122.48308618722099 (37.7392039339278, -122.483086187221)
86907 96483 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
88058 94937 6 498 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
90057 111634 6 142 3009 26th St 1 1 1 1 1   12     6009514.91537658 2100993.40768569 37.7494647260255 -122.40989418187 (37.7494647260255, -122.40989418187)
90667 94951 6 31 50 Pomona St   24 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
91973 106184 6 41 1327 ULLOA ST 1 8 1 1 1   2 4x4   5991893.8 2098371.4 37.7412620575898 -122.470636971077 (37.7412620575898, -122.470636971077)
93623 94948 6 18 50 Pomona St   5 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
96189 94940 6 112 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
97749 96481 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
99207 96568 6 12 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
101102 96484 6 180 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
103034 96485 6 180 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
103824 94947 6 18 50 Pomona St   5 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
105928 109708 6 17 621 Laguna Honda Blvd 3 8 1 1 1 07/29/2015 12:00:00 AM     Permit Number 774799 5995723.9 2099907.4 37.745700269008296 -122.457505029341 (37.7457002690083, -122.457505029341)
107188 94950 6 31 50 Pomona St   24 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
108780 92311 6 18 2211 33rd Ave 1 1 1 1 1 10/18/2008 12:00:00 AM 3 3x3   5986022.3 2100155.2 37.7458186185696 -122.491069496457 (37.7458186185696, -122.491069496457)
109217 96482 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
111560 94941 6 112 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
111867 112057 6 62 762 FUNSTON AVE 2 1 1 1 1   12     5991999.0 2110277.0 37.773957792878704 -122.47114039751001 (37.7739577928787, -122.47114039751)
111884 94939 6 112 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
112975 94938 6 498 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
113578 96571 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
114698 94946 6 18 50 Pomona St   5 1 4 1 04/04/2009 12:00:00 AM       6014124.7 2094445.3 37.7317422564721 -122.39349508644399 (37.7317422564721, -122.393495086444)
120702 97175 6 37 26 Gilbert St   5 1 1 1         6011445.1 2110013.2 37.7743390438118 -122.40385413458 (37.7743390438118, -122.40385413458)
124197 96567 6 12 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Trees not requiring permit; trees meet the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
138508 96480 6 143 1101 Eucalyptus Dr   5 1 4 1       In Prop 3 Ft. Rule = Tree not requiring permit; tree meets the proximity to Right-of-Way Requirement; funded by City 5988077.2 2094728.1 37.731037066667795 -122.483566221845 (37.7310370666678, -122.483566221845)
139320 94936 6 498 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
140734 94945 6 338 1820X Palou Ave   24 1 3 1 04/04/2009 12:00:00 AM       6013714.4 2096294.3 37.7367964240349 -122.395043047708 (37.7367964240349, -122.395043047708)
140792 94868 6 31 51 Princeton St   5 1 1 1         6007547.0 2093670.0 37.729245779959 -122.416180705349 (37.729245779959, -122.416180705349)
141804 96996 6 235 2451X Griffith St   5 1 20 1         6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
142779 112056 6 62 762 FUNSTON AVE 1 1 1 1 1   8     5991999.0 2110277.0 37.773957792878704 -122.47114039751001 (37.7739577928787, -122.47114039751)
143629 96998 6 84 2451X Griffith St   5 1 20 1         6015858.3 2090034.7 37.7197277910807 -122.38719408923599 (37.7197277910807, -122.387194089236)
144144 94944 6 540 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
144883 94942 6 417 2525 Griffith St   5 1 20 1 04/04/2009 12:00:00 AM       6016314.6 2089984.7 37.719615759266205 -122.38561332473999 (37.7196157592662, -122.38561332474)
164545 82366 6 31 51 Princeton St 3 1 1 1 1 05/28/2005 12:00:00 AM 9     6007564.92616 2093725.05049 37.7293979446509 -122.416122630059 (37.7293979446509, -122.416122630059)
78 251199 6 3 900X 14th St 4 7 1 1       3X3   6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
86 119601 6 34 4357x Mission St 3 7 1 1         Permit Number 774415          
93 251198 6 3 900X 14th St 3 7 1 1           6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
95 251197 6 3 900X 14th St 3 7 1 1   03/22/2017 12:00:00 AM 3   Permit Number 779570 6002798.55883 2107703.57748 37.7675105430125 -122.43359899801901 (37.7675105430125, -122.433598998019)
96 251196 6 3 900X 14th St 2 8 1 1   03/22/2017 12:00:00 AM 3     6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
114 251216 6 1 399X Townsend St 1 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
118 251217 6 1 399X Townsend St 2 5 1 1       3x3   6013957.0 2110872.0 37.776837125863 -122.39522511301901 (37.776837125863, -122.395225113019)
272 251264 6 47 3630x 19th Ave 3 9 1 1         Permit Number 779147          
277 251265 6 47 3630x 19th Ave 4 9 1 1         Permit Number 779147          
293 251262 6 47 3630x 19th Ave 1 9 1 1         Permit Number 779147          
300 251263 6 47 3630x 19th Ave 2 9 1 1         Permit Number 779147          
363 119608 6 34 299x Avalon Ave 4 7 1 1                    
484 205880 6 47 44 Mendosa Ave 1 1 1 1     43 Width 3ft   5993348.04769 2101170.42115 37.7490314462559 -122.46581205990499 (37.7490314462559, -122.465812059905)
563 173951 6 17 2646 Union St 1 8 1 1   04/11/2017 12:00:00 AM 3 10x10 Permit Number 779549 6000338.0 2118225.0 37.796259749404605 -122.442865342513 (37.7962597494046, -122.442865342513)
595 119606 6 1 299x Avalon Ave 2 7 1 1                    
1025 251425 6 128 5016 Diamond Heights Blvd 2 9 1 1           5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
1027 251426 6 3 5020 Diamond Heights Blvd 1 9 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1030 251424 6 47 5016 Diamond Heights Blvd 1 9 1 1       3x3   5999555.0 2100128.0 37.7465253005744 -122.444273545879 (37.7465253005744, -122.444273545879)
1159 112361 6 26 561X Folsom St 1 7 1 1   11/16/2015 12:00:00 AM 3 10x30 Permit Number 775828 6013749.7362 2114198.9064599997 37.785960521430205 -122.396175324952 (37.7859605214302, -122.396175324952)
1310 251480 6 3 51 Peralta Ave 1 7 1 1       3x3   6010641.0 2100362.0 37.747794064611604 -122.40595565659201 (37.7477940646116, -122.405955656592)
1337 251410 6 21 2777 Pine St 1 8 1 1       3x3 Permit Number 779015 6000658.0 2114782.0 37.7868244087741 -122.441510888069 (37.7868244087741, -122.441510888069)
1357 173636 6 17 2590 Pacific Ave 2 7 1 1   05/11/2017 12:00:00 AM 3 3x3 Permit Number 779167 6001760.0 2117029.0 37.7930568116395 -122.43785923271999 (37.7930568116395, -122.43785923272)
1358 173635 6 17 2590 Pacific Ave 1 8 1 1   05/11/2017 12:00:00 AM 3 3x3 Permit Number 779167 6001760.0 2117029.0 37.7930568116395 -122.43785923271999 (37.7930568116395, -122.43785923272)
1384 251515 6 3 99x Mountview Ct 1 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1409 251514 6 3 99x Mountview Ct 2 13 1 1       3x3   5997620.0 2100449.0 37.7472961010623 -122.450987675073 (37.7472961010623, -122.450987675073)
1598 251612 6 3 60R Amber Dr 1 13 1 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1603 251636 6 3 22R Amethyst Way 1 13 1 1           5999148.0 2100052.0 37.74629339412971 -122.44567543770901 (37.7462933941297, -122.445675437709)
1604 251632 6 47 14R Amethyst Way 1 13 1 1           5999202.0 2100044.0 37.746274510978395 -122.445488137723 (37.7462745109784, -122.445488137723)
1607 251602 6 108 44R Amber Dr 1 13 1 1           5999509.0 2100035.0 37.746267320465705 -122.444425925791 (37.7462673204657, -122.444425925791)
1608 251603 6 47 44R Amber Dr 2 13 1 1           5999509.0 2100035.0 37.746267320465705 -122.444425925791 (37.7462673204657, -122.444425925791)
1609 251630 6 47 8R Amethyst Way 2 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
1611 251605 6 108 48R Amber Dr 2 13 1 1           5999482.0 2100041.0 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345)
1615 251604 6 3 48R Amber Dr 1 13 1 1           5999482.0 2100041.0 37.7462822544405 -122.444519719345 (37.7462822544405, -122.444519719345)
1616 251607 6 3 52R Amber Dr 2 13 1 1           5999455.0 2100046.0 37.7462944425817 -122.44461344107401 (37.7462944425817, -122.444613441074)
1623 251613 6 47 60R Amber Dr 2 13 1 1           5999394.0 2100048.0 37.7462964530913 -122.444824514752 (37.7462964530913, -122.444824514752)
1628 251629 6 47 8R Amethyst Way 1 13 1 1           5999237.0 2100032.0 37.7462435599048 -122.44536624972099 (37.7462435599048, -122.445366249721)
Powered by Datasette · Query took 6.401ms · Data source: data.sfgov.org