sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
21199 97237 7 41 125 Excelsior Ave   9 1 4 1 09/07/2011 12:00:00 AM     Permit Number 767513 6002911.0 2092621.3 37.7261045201699 -122.43213288829399 (37.7261045201699, -122.432132888294)
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)
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)
78101 96597 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
79535 96590 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
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)
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)
81703 96593 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
85657 96591 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
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)
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)
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)
97416 96594 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
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)
101631 94927 1 21 325 Sanchez St   1 1 4   12/07/2010 12:00:00 AM   3x3 Permit Number 53976 6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
102637 107643 3 17 455 ATHENS ST   5 1 4 1     4x4   6003769.0 2090659.8 37.720767283734105 -122.429027043999 (37.7207672837341, -122.429027043999)
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)
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)
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)
110024 96606 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
111128 96599 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
113186 96604 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
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)
113756 96600 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
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)
116314 96592 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
121581 96589 7 49 450 Church St   5 1 4 1         6004088.8 2106523.6 37.7643437320395 -122.42905208409401 (37.7643437320395, -122.429052084094)
123910 96598 7 458 325 Sanchez St   5 3 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
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)
126860 96602 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
127434 97236 7 458 125 Excelsior Ave   9 1 4 1 09/07/2011 12:00:00 AM     Permit Number 767513 6002911.0 2092621.3 37.7261045201699 -122.43213288829399 (37.7261045201699, -122.432132888294)
128034 96601 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
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)
142264 96605 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
144514 96603 7 458 325 Sanchez St   5 1 4 1         6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
1405 228661 3 11 4235 19th St 1 1 1 4   03/07/1990 12:00:00 AM 13 Width 3ft   6001838.07707 2104669.16217 37.7591242363206 -122.436703937943 (37.7591242363206, -122.436703937943)
2873 41127 3 60 2049 Grove St 1 1 1 4 2 08/10/2017 12:00:00 AM 3 6x6 Permit Number 41868 5998020.62854813 2110270.29167038 37.7742858282579 -122.450310189268 (37.7742858282579, -122.450310189268)
3260 42633 3 79 1651 Union St 1 1 1 4 2 06/22/2016 02:56:00 PM 3 5x5 Permit Number 45045 6005048.16251 2118816.23898 37.7981505449739 -122.426609321383 (37.7981505449739, -122.426609321383)
4605 142542 3 16 301 FRANCISCO ST 1 1 1 4     8 Width 0ft   6009433.8643 2121170.962 37.8048629945672 -122.411599901453 (37.8048629945672, -122.411599901453)
4753 98088 3 35 2X Frank Norris St 1 1 1 4 2   3 3x3   6007178.15894 2115574.08384 37.7893685797349 -122.41900880992901 (37.7893685797349, -122.419008809929)
4776 97245 3 12 301X Excelsior Ave 1 1 1 4 2 10/25/2017 04:18:00 PM 3 4x4 Permit Number 767495 6003351.72812 2092154.8424200001 37.724848709697106 -122.43057604836099 (37.7248487096971, -122.430576048361)
5004 253731 3 15 350 Girard St 1 1 1 4       3x12   6010529.0 2093052.0 37.7277161040977 -122.405828105175 (37.7277161040977, -122.405828105175)
5496 99696 3 26 1451 Jackson St 1 1 1 4 2   24 3x3   6007201.17567 2117403.71838 37.794393599230204 -122.41905900288799 (37.7943935992302, -122.419059002888)
5696 98622 3 32 3500X Fillmore St 1 1 1 4 2   12 6x6   6002297.34528 2119958.5907400004 37.8011312453645 -122.436209738003 (37.8011312453645, -122.436209738003)
5962 82000 3 2 1150 Francisco St 1 1 1 4 2 06/04/2008 12:00:00 AM 6 3x3 Permit Number 50638 6005983.68719 2120729.63993 37.803457100839296 -122.423508229633 (37.8034571008393, -122.423508229633)
7275 98612 3 236 2501X Franklin St 1 1 1 4 2   5 3x3   6005312.4459 2118826.60748 37.7981939516456 -122.42569556069598 (37.7981939516456, -122.425695560696)
7587 98602 3 26 2340 Jackson St 1 1 1 4 2   9 3x3   6003137.34298 2116882.04608 37.792731538790704 -122.433083047059 (37.7927315387907, -122.433083047059)
9734 173682 3 103 450x Raymond Ave 1 1 1 4 2     3x3   6008515.0 2088365.0 37.71473375007071 -122.41245939537501 (37.7147337500707, -122.412459395375)
10264 92961 3 17 2051 34th Ave 1 1 1 4   12/24/2009 12:00:00 AM   3x3 Permit Number 53120 5985698.5 2101265.4 37.748848003369005 -122.49227087024799 (37.748848003369, -122.492270870248)
10290 37814 3 42 450X Moscow St 1 1 1 4 2 07/07/1998 12:00:00 AM 8 3x3 Permit Number 40134 6003977.37565 2090552.2455 37.720483755714 -122.428299091747 (37.720483755714, -122.428299091747)
10426 108779 1 61 2055 Sunnydale Ave 1 1 1 4 1 01/06/2015 12:00:00 AM 3 3x3 Permit Number 773821 6005562.18075 2088048.73923 37.7136992126121 -122.422643108799 (37.7136992126121, -122.422643108799)
12446 95750 3 180 260 Madrid St 1 1 1 4 2 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767495 6003564.18987 2092436.8443200001 37.7256350580097 -122.429861698861 (37.7256350580097, -122.429861698861)
12710 37830 3 35 451 Athens St 1 1 1 4 2 07/09/2007 12:00:00 AM 3 6x6 Permit Number 49480 6003635.85955 2090436.9204099998 37.7201477680848 -122.429471383195 (37.7201477680848, -122.429471383195)
12861 75133 3 155 125 Excelsior Ave 1 1 1 4 2 05/08/1992 12:00:00 AM 14 4x4   6002899.19862 2092441.61812 37.7256104849218 -122.43216085884501 (37.7256104849218, -122.432160858845)
14765 51356 3 135 50 Pomona St 1 1 1 4 2 12/10/2005 12:00:00 AM 3 3x3 Permit Number 47704 6014174.8382 2094728.0237900002 37.732521344076204 -122.393341524701 (37.7325213440762, -122.393341524701)
19029 32731 3 2 431 Capitol Ave 1 1 1 4 2 10/29/1996 12:00:00 AM 3 3x3   5995024.91433 2088666.6169099999 37.7147956345921 -122.45910820668699 (37.7147956345921, -122.459108206687)
19738 30738 3 21 380 Webster St 1 1 1 4 2 01/31/1995 12:00:00 AM 3 3x3 Permit Number 34630 6004189.67673 2109821.80854 37.773405523491995 -122.428938341537 (37.773405523492, -122.428938341537)
23202 77640 3 55 1300X Silliman St 1 1 1 4 2 10/26/1984 12:00:00 AM 13 0   6006980.92428 2093193.1114700001 37.7279045016753 -122.418103887786 (37.7279045016753, -122.418103887786)
23284 76311 3 44 299X Cambridge St 1 1 1 4 2 10/26/1984 12:00:00 AM 4 0   6006754.260559999 2093151.90933 37.7277786091743 -122.418884550584 (37.7277786091743, -122.418884550584)
28296 33101 3 26 450X Chestnut St 1 1 1 4 4 11/01/1997 12:00:00 AM 14   Permit Number 37341 6009682.3141 2120901.0273 37.804135754366996 -122.410721035819 (37.804135754367, -122.410721035819)
29249 60892 1 26 940 Filbert St 1 1 1 4 2 06/11/1983 12:00:00 AM 16 5x5 Permit Number 20677 6008514.66964 2119698.45237 37.8007682484075 -122.414676612845 (37.8007682484075, -122.414676612845)
50161 96500 3 150 2360X Harrison St 1 1 1 4 2 09/15/2012 12:00:00 AM   3x3   6008639.8 2104954.0 37.7602905334715 -122.413200395323 (37.7602905334715, -122.413200395323)
61243 34693 1 55 3101X Webster St 1 1 1 4 4 07/28/1997 12:00:00 AM 9 3x3 Permit Number 38352 6002813.73545 2119366.57801 37.799535058456 -122.43438045581301 (37.799535058456, -122.434380455813)
63146 75990 2 273 350 Broadway 1 1 1 4 4 10/07/1995 12:00:00 AM 3 3x3   6011912.57037 2118781.03793 37.7984395708796 -122.40285383475599 (37.7984395708796, -122.402853834756)
63419 106952 2 17 399X SOMERSET ST 1 1 1 4       3x3   6009953.0 2092875.0 37.7271978698015 -122.40780687976499 (37.7271978698015, -122.407806879765)
73786 94516 1 49 1106X Wisconsin St 1 1 1 4   08/27/2010 12:00:00 AM 2   Permit Number 53703 6012787.7377 2102360.9473599996 37.753402573178896 -122.39867255379299 (37.7534025731789, -122.398672553793)
74427 67860 1 55 2110 Greenwich St 1 1 1 4 4 01/20/1993 12:00:00 AM 5 5x5 Permit Number 31536 6002806.21719 2119247.92289 37.7992088356751 -122.43439798360501 (37.7992088356751, -122.434397983605)
77973 95480 2 2 601X 30th Ave 1 1 1 4 2   8 3x3   5986567.36684 2111939.07455 37.7782057127303 -122.490051346189 (37.7782057127303, -122.490051346189)
78146 95448 2 2 601X 30th Ave 1 1 1 4 2   6 3x3   5986572.26887 2111788.56268 37.777792736173794 -122.49002331517599 (37.7777927361738, -122.490023315176)
79513 95519 2 51 600X 32nd Ave 1 1 1 4     5 3x3   5985993.74648 2111883.3180400003 37.7780191077803 -122.49203157445 (37.7780191077803, -122.49203157445)
79727 99261 3 2 3099X Polk St 1 5 1 4 2   12 3x6   6005936.6 2121383.7 37.805250324017294 -122.42371770971 (37.8052503240173, -122.42371770971)
79819 95474 2 2 601X 30th Ave 1 1 1 4 2   3 3x3   5986559.68186 2112141.60911 37.7787613662348 -122.490092832202 (37.7787613662348, -122.490092832202)
82051 99347 3 2 451X 29th Ave 1 1 1 4 2   3 3x3   5986832.70752 2113173.16715 37.7816096708126 -122.489224205331 (37.7816096708126, -122.489224205331)
82878 60316 3 2 450 30th Ave 1 1 1 4 2 10/07/1982 12:00:00 AM 8 4x4   5986588.61699 2112633.05068 37.7801124144217 -122.490028891926 (37.7801124144217, -122.490028891926)
82909 95459 2 60 657X 30th Ave 1 1 1 4 2   18 3x3   5986588.2 2111449.2 37.776861872872 -122.48994323847201 (37.776861872872, -122.489943238472)
83153 95455 2 2 601X 30th Ave 1 1 1 4 2   8 3x3   5986575.69735 2111690.69221 37.777524211869896 -122.490004254704 (37.7775242118699, -122.490004254704)
83482 95466 2 2 529X 30th Ave 1 1 1 4 2   5 3x3   5986555.1 2112324.8 37.7792640886788 -122.490122160768 (37.7792640886788, -122.490122160768)
84647 72535 3 17 150X Alma St 1 1 1 4 2 03/21/1992 12:00:00 AM 20 3x3   5997957.39996807 2106223.02713962 37.763169454232894 -122.45023711317499 (37.7631694542329, -122.450237113175)
84790 76728 3 41 200X Farallones St 1 1 1 4 2 11/20/1989 12:00:00 AM 10 3x3   5995015.41074948 2088495.64250033 37.7143256328225 -122.45912868181601 (37.7143256328225, -122.459128681816)
84851 95479 2 2 601X 30th Ave 1 1 1 4 2   10 3x3   5986565.4115 2111984.30283 37.7783297825409 -122.490061437893 (37.7783297825409, -122.490061437893)
84872 108785 1 51 1100-1198X Schwerin St 1 1 1 4 1 01/06/2015 12:00:00 AM 3   Permit Number 773823 6009097.136580001 2087632.54285 37.7127552255458 -122.41039559568199 (37.7127552255458, -122.410395595682)
85371 95482 2 2 601X 30th Ave 1 1 1 4 2   3 3x3   5986568.36529 2111879.34223 37.7780417630679 -122.49004349761299 (37.7780417630679, -122.490043497613)
86000 102186 2 5 3999X Folsom St 1 1 1 4 2   8 3x3   6008408.0 2096514.0 37.7371031642446 -122.41340519256 (37.7371031642446, -122.41340519256)
86573 34754 3 52 825 Shotwell St 1 1 1 4 2 04/07/2010 12:00:00 AM 5 3x3 Permit Number 53353 6007982.56974873 2103121.8781615 37.7552230267666 -122.415343751113 (37.7552230267666, -122.415343751113)
86592 97067 3 26 1551 Newcomb Ave 1 1 1 4 2 03/06/2014 12:00:00 AM 3 3x3   6015475.3 2095481.7 37.734662952658894 -122.38889807707899 (37.7346629526589, -122.388898077079)
86703 95460 2 41 601X 30th Ave 1 1 1 4 2 03/12/2011 12:00:00 AM 3 3x3   5986585.7747 2111417.7398 37.77677535046679 -122.489949313769 (37.7767753504668, -122.489949313769)
87154 95463 2 41 601X 30th Ave 1 1 1 4 2 03/12/2011 12:00:00 AM 3 3x3   5986592.12306 2111264.12941 37.7763539505765 -122.489916052727 (37.7763539505765, -122.489916052727)
88215 95470 2 2 539X 30th Ave 1 1 1 4 2   4 3x3   5986557.7 2112257.8 37.7790802775989 -122.49010823686399 (37.7790802775989, -122.490108236864)
88568 98931 3 26 1401X Utah St 1 1 1 4 2   10 3x3   6010911.0 2101810.0 37.751785052607204 -122.405123950338 (37.7517850526072, -122.405123950338)
89310 66890 3 2 1035 Gilman Ave 1 1 1 4 2 05/07/2005 12:00:00 AM 6 3x3 Permit Number 45482 6015368.10493708 2089617.80548286 37.71855592189279 -122.388859444456 (37.7185559218928, -122.388859444456)
89660 113434 3 55 198x HIGHLAND AVE 1 1 1 4     12 4x4   6006173.0 2096415.0 37.73670559026029 -122.421125584355 (37.7367055902603, -122.421125584355)
90893 46948 3 2 1530 43rd Ave 1 1 1 4 2 05/01/2002 12:00:00 AM 3 3x25 Permit Number 44987 5982828.25460357 2104700.39822601 37.758111331314396 -122.50245020588699 (37.7581113313144, -122.502450205887)
92589 93633 3 26 151X Palm Ave 1 1 1 4 2 03/16/2010 12:00:00 AM 3 3x3 Permit Number 53266 5995881.0393 2113432.55638 37.782845890633794 -122.457940261495 (37.7828458906338, -122.457940261495)
92726 97722 3 94 1000X Bay St 1 5 1 4 2   14 7x57   6005985.5 2121074.1 37.8044030021841 -122.42352646028 (37.8044030021841, -122.42352646028)
93377 95497 2 51 600X 32nd Ave 1 1 1 4     6 3x3   5985999.2312900005 2111660.71954 37.777408236422296 -122.491996207782 (37.7774082364223, -122.491996207782)
93482 75385 3 108 163X London St 1 1 1 4 2 05/08/1992 12:00:00 AM 10 3x3   6002837.0 2092721.0 37.7263740781507 -122.432395819389 (37.7263740781507, -122.432395819389)
94066 77325 2 37 165X Chattanooga St 1 1 1 4 2 11/18/1988 12:00:00 AM 3 3x3   6004753.0 2102714.0 37.7539210456637 -122.426483522656 (37.7539210456637, -122.426483522656)
94772 98675 1 17 199X Park St 1 1 1 4 4         6006189.1 2096374.1 37.736594195559505 -122.421067016387 (37.7365941955595, -122.421067016387)
Powered by Datasette · Query took 11.442ms · Data source: data.sfgov.org