sf-trees

Data source: data.sfgov.org

Custom SQL query returning 91 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
114161 56806 1 80 806 Ashbury St 1 1 1 1   08/02/1974 12:00:00 AM     Permit Number 14035 5999139.37670373 2107622.75358893 37.7670803223615 -122.44624976103901 (37.7670803223615, -122.446249761039)
86990 58070 1 80 4530 18th St 1 1 1 1   10/28/1977 12:00:00 AM 2 6x9 Permit Number 17040 6000943.54601309 2105249.62912473 37.7606671794335 -122.439839263811 (37.7606671794335, -122.439839263811)
140842 54801 1 80 1301X 06th Ave 1 1 1 1   12/07/1982 12:00:00 AM   3x3 Permit Number 20098 5994223.60304226 2106594.5281626997 37.7639751162558 -122.463177926852 (37.7639751162558, -122.463177926852)
80767 37127 1 80 1501 46th Ave 3 1 1 1   06/01/1998 12:00:00 AM   2x2 Permit Number 39712 5981856.07887628 2104857.97095308 37.7584868087664 -122.50582403113998 (37.7584868087664, -122.50582403114)
143361 37129 1 80 1501 46th Ave 4 1 1 1   06/01/1998 12:00:00 AM   2x2 Permit Number 39712 5981856.07887628 2104857.97095308 37.7584868087664 -122.50582403113998 (37.7584868087664, -122.50582403114)
79096 84742 1 80 147 Alhambra St 1 5 1 1   03/27/2007 12:00:00 AM   4x6 Permit Number 49255 6001618.0 2120311.0 37.8020602472718 -122.438585827087 (37.8020602472718, -122.438585827087)
84179 98330 1 80 147 Alhambra St 2 5 1 1   03/27/2007 12:00:00 AM   4x6 Permit Number 49255 6001593.9 2120254.3 37.801903193112004 -122.438665159251 (37.801903193112, -122.438665159251)
90402 84929 1 80 1500@Polk Broadway 7 1 1 1   06/06/2007 12:00:00 AM     Permit Number 49344 6006413.8 2117997.6 37.795979878671 -122.421825625767 (37.795979878671, -122.421825625767)
120239 92388 1 80 170 Park St   1 1 1   07/29/2009 12:00:00 AM   3x3 Permit Number 52791 6005986.0 2096352.0 37.7365220626686 -122.421767651977 (37.7365220626686, -122.421767651977)
97656 63786 1 80 4035 25th St 1 1 1 1   09/02/2009 12:00:00 AM   3x3 Permit Number 52930 6003624.27213054 2101252.89355661 37.7498453184987 -122.43028269297 (37.7498453184987, -122.43028269297)
108113 92913 1 80 87 Ramona Ave 1 1 1 1   12/18/2009 12:00:00 AM 3 6x12 Permit Number 53113 6005252.7 2107310.7 37.7665707358936 -122.425082484344 (37.7665707358936, -122.425082484344)
106475 39630 1 80 1568 Shrader St 1 1 1 1   02/25/2010 12:00:00 AM   5x3 Permit Number 53204 5997924.75387781 2105264.0077583 37.7605343603066 -122.45028089123501 (37.7605343603066, -122.450280891235)
81377 683 1 80 2340X Lake St 1 1 1 1   05/20/2010 12:00:00 AM 0 3X3 Permit Number 53450 5988222.7193 2114685.44657 37.7858429996456 -122.484526443804 (37.7858429996456, -122.484526443804)
89979 93574 1 80 2998 San Jose Ave 2 1 1 1   09/13/2010 12:00:00 AM   3x3 Permit Number 53727 5995937.7 2087355.5 37.711248045329 -122.455858535778 (37.711248045329, -122.455858535778)
101908 93575 1 80 2998 San Jose Ave 3 1 1 1   09/13/2010 12:00:00 AM   3x3 Permit Number 53727 5995937.7 2087355.5 37.711248045329 -122.455858535778 (37.711248045329, -122.455858535778)
108192 93577 1 80 2998 San Jose Ave 5 1 1 1   09/13/2010 12:00:00 AM 6 3x3 Permit Number 53727 5995937.7 2087355.5 37.711248045329 -122.455858535778 (37.711248045329, -122.455858535778)
50103 76775 1 80 1320 Lombard St 9 1 1 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
80109 76804 1 80 1320 Lombard St 4 1 1 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
80757 76789 1 80 1320 Lombard St 7 1 1 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
83317 76761 1 80 1320 Lombard St 11 1 1 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
91422 76793 1 80 1320 Lombard St 6 1 1 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
96543 76813 1 80 1320 Lombard St 2 1 1 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
100236 76809 1 80 1320 Lombard St 3 1 1 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
114097 76766 1 80 1320 Lombard St 10 1 1 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
118834 76746 1 80 1320 Lombard St 13 1 1 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
119048 76753 1 80 1320 Lombard St 12 1 1 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
140392 76817 1 80 1320 Lombard St 1 1 1 1   09/12/2012 12:00:00 AM   3x3 Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
142546 76799 1 80 1320 Lombard St 5 1 1 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
143278 76782 1 80 1320 Lombard St 8 1 1 1   09/12/2012 12:00:00 AM     Permit Number 768047 6006034.8249105 2120045.34367344 37.80158108443371 -122.423282592369 (37.8015810844337, -122.423282592369)
112897 30786 1 80 477 Bryant St 3 1 1 1 1 11/02/2011 12:00:00 AM     Permit Number 768077 6013986.79222779 2112639.44439925 37.781691783585 -122.395245890478 (37.781691783585, -122.395245890478)
103124 97293 1 80 2154 Irving St 1 1 1 1   11/23/2011 12:00:00 AM   3x3 Permit Number 768386 5989030.8 2106542.7 37.7635322996796 -122.481134285356 (37.7635322996796, -122.481134285356)
38625 98846 1 80 2400 Noriega St 3 1 1 1   04/11/2012 12:00:00 AM 2 3x3 Permit Number 768753 5986497.5 2103053.8 37.753805142535 -122.48963946401501 (37.753805142535, -122.489639464015)
66670 98847 1 80 2400 Noriega St 5 1 1 1   04/11/2012 12:00:00 AM 2 3x3 Permit Number 768753 5986497.5 2103053.8 37.753805142535 -122.48963946401501 (37.753805142535, -122.489639464015)
162255 98845 1 80 2400 Noriega St 1 1 1 1   04/11/2012 12:00:00 AM 2 3x3 Permit Number 768753 5986497.5 2103053.8 37.753805142535 -122.48963946401501 (37.753805142535, -122.489639464015)
128947 46881 1 80 2300@Green Polk St 1 1 1 1   04/23/2012 12:00:00 AM     Permit Number 768822 6006358.85800747 2118685.04678939 37.797864335812704 -122.422064597009 (37.7978643358127, -122.422064597009)
111637 55048 1 80 3791 21st St 1 1 1 1   07/19/2012 12:00:00 AM     Permit Number 768924 6003127.14535424 2103564.68904381 37.756164790986205 -122.43216685295299 (37.7561647909862, -122.432166852953)
112828 99931 2 80 801X Noe St 1 1 1 1   07/19/2012 12:00:00 AM   3x3 Permit Number 768924 6003100.6 2103580.4 37.756206424442205 -122.432259777723 (37.7562064244422, -122.432259777723)
93425 100044 1 80 1250 De Haro St 1 1 1 1   06/27/2012 12:00:00 AM   3x3 Permit Number 768984 6012201.0 2102568.4 37.7539394855375 -122.400716201774 (37.7539394855375, -122.400716201774)
97623 100396 2 80 500X Oak Park Dr 1 9 1 1   09/18/2012 12:00:00 AM 3 3x9 Permit Number 769101 5994983.3 2103652.8 37.755941622135296 -122.460337221652 (37.7559416221353, -122.460337221652)
78192 109745 1 80 2730 16th St 4 1 1 1 1 03/03/2015 12:00:00 AM 3 3x3 Permit Number 769296 6008568.6 2106948.2 37.7657621501348 -122.413587690705 (37.7657621501348, -122.413587690705)
150717 100949 1 80 1561 45th Ave 1 1 1 1 1 09/20/2012 12:00:00 AM 1   Permit Number 769342 5982149.6 2104456.5 37.7574017552939 -122.504779173294 (37.7574017552939, -122.504779173294)
111851 60027 1 80 41 South Park 1 1 1 1 1 03/18/2013 12:00:00 AM     Permit Number 769856 6014655.81368733 2112837.99803451 37.7822741509003 -122.392945269869 (37.7822741509003, -122.392945269869)
94607 102914 1 80 2848 Union St 1 1 1 1   04/12/2013 12:00:00 AM   3x3 Permit Number 770041 5999369.2 2118090.3 37.7958346193373 -122.446207883579 (37.7958346193373, -122.446207883579)
105204 104605 1 80 10X Russell St 3 1 1 1   10/21/2013 12:00:00 AM   2x3 Permit Number 770083 6007114.434880001 2118959.67619 37.798660985130795 -122.419469576763 (37.7986609851308, -122.419469576763)
108555 104604 1 80 10X Russell St 2 1 1 1   10/21/2013 12:00:00 AM   2x3 Permit Number 770083 6007114.434880001 2118959.67619 37.798660985130795 -122.419469576763 (37.7986609851308, -122.419469576763)
120598 104603 1 80 10X Russell St 1 1 1 1   10/21/2013 12:00:00 AM   2x3 Permit Number 770083 6007114.434880001 2118959.67619 37.798660985130795 -122.419469576763 (37.7986609851308, -122.419469576763)
140547 104606 1 80 30 Russell St 1 1 1 1   10/21/2013 12:00:00 AM   2x3 Permit Number 770083 6007173.0 2118980.0 37.798720087677104 -122.419268364856 (37.7987200876771, -122.419268364856)
117505 105053 1 80 501X 27th Ave 2 1 1 1   12/10/2013 12:00:00 AM   3x3 Permit Number 770390 5987510.95423 2112219.6423299997 37.779031128568796 -122.48680778308001 (37.7790311285688, -122.48680778308)
86820 104607 1 80 1839 Stockton St 1 1 1 1   10/21/2013 12:00:00 AM   3x3 Permit Number 770939 6009882.8 2120354.0 37.80264499181129 -122.409988596173 (37.8026449918113, -122.409988596173)
55368 105009 1 80 11 Commonwealth Ave 1 1 1 1   12/04/2013 12:00:00 AM 7   Permit Number 770953 5996464.5 2114492.5 37.785789717987704 -122.455998396638 (37.7857897179877, -122.455998396638)
57286 105011 1 80 11 Commonwealth Ave 3 1 1 1   12/04/2013 12:00:00 AM 5   Permit Number 770953 5996464.5 2114492.5 37.785789717987704 -122.455998396638 (37.7857897179877, -122.455998396638)
135481 105010 1 80 11 Commonwealth Ave 2 1 1 1   12/04/2013 12:00:00 AM 5   Permit Number 770953 5996464.5 2114492.5 37.785789717987704 -122.455998396638 (37.7857897179877, -122.455998396638)
89798 103596 1 80 10X Hermann St 5 1 1 1   01/08/2014 12:00:00 AM   3x3 Permit Number 771143 6005031.0649 2108842.56611 37.7707643495235 -122.42595813798201 (37.7707643495235, -122.425958137982)
101213 103593 1 80 10X Hermann St 2 1 1 1   01/08/2014 12:00:00 AM   3x3 Permit Number 771143 6005031.0649 2108842.56611 37.7707643495235 -122.42595813798201 (37.7707643495235, -122.425958137982)
121859 103584 1 80 55X Laguna St 5 1 1 1   01/08/2014 12:00:00 AM   3x3 Permit Number 771143 6005242.6 2108960.5 37.7711001201992 -122.42523482670799 (37.7711001201992, -122.425234826708)
142728 103585 1 80 55X Laguna St 6 1 1 1   01/08/2014 12:00:00 AM   3x3 Permit Number 771143 6005242.6 2108960.5 37.7711001201992 -122.42523482670799 (37.7711001201992, -122.425234826708)
143605 103586 1 80 55X Laguna St 7 1 1 1   01/08/2014 12:00:00 AM   3x3 Permit Number 771143 6005242.6 2108960.5 37.7711001201992 -122.42523482670799 (37.7711001201992, -122.425234826708)
113056 106547 1 80 4509A 25th St   1 1 1   05/08/2014 12:00:00 AM   3x3 Permit Number 772697 6000984.2 2101089.3 37.749246236919106 -122.439400435576 (37.7492462369191, -122.439400435576)
87526 97446 1 80 200X Parker Ave 2 1 1 1   05/30/2014 12:00:00 AM   3x3 Permit Number 772930 5997060.8 2112843.2 37.7812953839865 -122.453816232036 (37.7812953839865, -122.453816232036)
89140 24659 1 80 3299X Geary Blvd 2 1 1 1   05/30/2014 12:00:00 AM 3 3x3 Permit Number 772930 5997061.39714 2112911.4526400003 37.7814828219847 -122.453819096525 (37.7814828219847, -122.453819096525)
101543 53808 1 80 200X Parker Ave 1 1 1 1   05/30/2014 12:00:00 AM   3x3 Permit Number 772930 5997126.8655565 2112925.05365722 37.7815239200353 -122.45359359095801 (37.7815239200353, -122.453593590958)
121335 115253 1 80 20 Edgar Ave 1 1 1 1   01/21/2016 12:00:00 AM     Permit Number 772988 5997135.3 2090888.7 37.7210180538388 -122.451974094521 (37.7210180538388, -122.451974094521)
91320 107140 1 80 250X Roosevelt Way   11 1 1   08/01/2014 12:00:00 AM   5x5 Permit Number 773751 6000794.71275 2107196.95489 37.766005582708395 -122.440493678393 (37.7660055827084, -122.440493678393)
122477 112777 1 80 1899X Anza St 1 1 1 1   08/19/2015 12:00:00 AM     Permit Number 774327 5992976.20102 2112064.24796 37.7789215671599 -122.467890144832 (37.7789215671599, -122.467890144832)
125123 112779 1 80 1899X Anza St 3 1 1 1   08/19/2015 12:00:00 AM     Permit Number 774327 5992976.20102 2112064.24796 37.7789215671599 -122.467890144832 (37.7789215671599, -122.467890144832)
93755 115008 1 80 743 32nd Ave 2 1 1 1   01/04/2016 12:00:00 AM     Permit Number 774445 5985969.5 2110831.9 37.775130796003204 -122.49203801834601 (37.7751307960032, -122.492038018346)
96845 13075 1 80 645X Lombard St 5 1 1 3   01/22/2015 12:00:00 AM 3 3X3 Permit Number 774508 6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156)
124233 114680 1 80 54 Colby St 1 8 1 1   12/01/2015 12:00:00 AM     Permit Number 774571 6007954.9 2093861.0 37.729793151999395 -122.414784067206 (37.7297931519994, -122.414784067206)
9756 55923 1 80 530 Moraga St 1 1 1 1   05/17/1973 12:00:00 AM 3 3x3 Permit Number 774578 5992693.0422579 2103919.63429657 37.7565422691319 -122.468277027995 (37.7565422691319, -122.468277027995)
12866 108593 1 80 530 Moraga Ave 1 1 1 1 1 12/29/2014 12:00:00 AM 3 3x3 Permit Number 774578          
11726 54377 1 80 1454 38th Ave 1 1 1 1 1 12/29/2014 12:00:00 AM 3 3x3 Permit Number 774580 5984357.5042 2105265.8509 37.7597536454069 -122.49720322400299 (37.7597536454069, -122.497203224003)
121701 108636 1 80 68 Mangels Ave   5 1 1 1 12/30/2014 12:00:00 AM 3 3x3 Permit Number 774603 6000942.00546 2095224.20835 37.7331396755893 -122.439126041581 (37.7331396755893, -122.439126041581)
91935 115289 1 80 1425 14th Ave 1 1 1 1   01/22/2016 12:00:00 AM     Permit Number 775512 5991747.8 2105705.5 37.761391146048496 -122.47167612106001 (37.7613911460485, -122.47167612106)
63991 115203 1 80 2056 Ellis St 1 1 1 1   01/19/2016 12:00:00 AM 3   Permit Number 775522 6001029.7 2112838.5 37.781509225585104 -122.44008548171301 (37.7815092255851, -122.440085481713)
124414 115297 1 80 84 Forest Side Ave 1 1 1 1   01/22/2016 12:00:00 AM     Permit Number 775683 5992506.3 2098571.2 37.7418460572185 -122.468533715231 (37.7418460572185, -122.468533715231)
43549 43627 1 80 2230 35th Ave 1 1 1 1 1 01/22/2016 12:00:00 AM 0 3x3 Permit Number 775700 5985470.85834553 2100027.42958295 37.7454355618475 -122.49296686595899 (37.7454355618475, -122.492966865959)
80243 56898 1 80 1886 34th Ave 1 1 1 1   01/21/2016 12:00:00 AM     Permit Number 775792 5985700.55899725 2102390.4838018003 37.751937297297395 -122.492346587933 (37.7519372972974, -122.492346587933)
88959 115768 1 80 210 Drake St 1 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 775810 6001697.3 2086437.3 37.709055747846705 -122.43588629224399 (37.7090557478467, -122.435886292244)
128131 115769 1 80 210 Drake St 2 1 1 1   02/24/2016 12:00:00 AM 3   Permit Number 775810 6001697.3 2086437.3 37.709055747846705 -122.43588629224399 (37.7090557478467, -122.435886292244)
79092 115287 1 80 1526 12th Ave 1 5 1 1   01/22/2016 12:00:00 AM     Permit Number 776185 5992489.2 2105046.7 37.759625121297795 -122.469064003389 (37.7596251212978, -122.469064003389)
105773 102005 2 80 1703 CASTRO ST 2 1 1 1   01/26/2016 12:00:00 AM 3 3x3 Permit Number 776283 6002624.0 2100623.7 37.7480609930318 -122.433696712327 (37.7480609930318, -122.433696712327)
120000 102006 2 80 1703 Castro St 3 1 1 1   01/26/2016 12:00:00 AM 3 3x3 Permit Number 776283 6002624.0 2100623.7 37.7480609930318 -122.433696712327 (37.7480609930318, -122.433696712327)
66027 115194 1 80 4150 20th St 1 1 1 1   01/19/2016 12:00:00 AM     Permit Number 777365 6002684.1 2104186.2 37.757846181761295 -122.433743471638 (37.7578461817613, -122.433743471638)
89928 115438 1 80 2500X Larkin St 4 1 1 1   02/01/2016 12:00:00 AM 3   Permit Number 777506 6006688.6 2119773.1 37.8008704472237 -122.421000888697 (37.8008704472237, -122.421000888697)
123028 18540 3 80 60 Quartz Way 1 1 1 2     75 2x2 Permit Number 778371 5999060.658518599 2099832.0947892 37.745684600557794 -122.445961639207 (37.7456846005578, -122.445961639207)
108737 50468 1 80 10 Merced Ave 1 1 1 1 1 08/30/2016 12:00:00 AM 3   Permit Number 778534 5995312.36828974 2100223.18422456 37.7465436862786 -122.45895089565501 (37.7465436862786, -122.458950895655)
560 131782 2 80 2646 Union St 2 1 1 1     11 Width 3ft Permit Number 779549 6000337.27442 2118211.39807 37.7962223607332 -122.442866875924 (37.7962223607332, -122.442866875924)
138577 103085 1 80 99 Colton St 1 1 1 1 1     2x3 See 55 Brady St; trees planted at same time with permits/FUF 6006671.4 2109566.7 37.7728452155106 -122.42033558182301 (37.7728452155106, -122.420335581823)
141309 103086 1 80 99 Colton St 2 1 1 1 1     2x3 See 55 Brady St; trees planted at same time with permits/FUF 6006671.4 2109566.7 37.7728452155106 -122.42033558182301 (37.7728452155106, -122.420335581823)
104340 74892 2 80 141X Arleta Ave 2 1 1 13 1 02/24/2016 12:00:00 AM 3   This is for the trees adjacent to the lot between 141-143 Arleta 6010470.01061258 2087860.00753073 37.713456663779795 -122.40566649087499 (37.7134566637798, -122.405666490875)
104270 75029 2 80 141X Arleta Ave 1 1 1 13 1 02/24/2016 12:00:00 AM 3   This record is for lthe ot between 141-143 Arleta Ave. 6010470.01061258 2087860.00753073 37.713456663779795 -122.40566649087499 (37.7134566637798, -122.405666490875)
Powered by Datasette · Query took 3.925ms · Data source: data.sfgov.org