sf-trees

Data source: data.sfgov.org

Custom SQL query returning 91 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
4152 216685 2 80 111 Ashton Ave 2 2 1 1   10/06/2017 08:11:00 AM 3 Width 3ft   5994133.1609 2090669.8719900001 37.720244788744104 -122.46233566126101 (37.7202447887441, -122.462335661261)
4474 162754 2 80 997x Capitol Ave 2 1 1 1   10/13/2017 11:43:00 AM 3 Width 0ft   5995095.0 2090528.0 37.719910580533295 -122.45900065774599 (37.7199105805333, -122.459000657746)
5406 13016 3 80 407 Lombard St 2 1 1 2   03/16/2016 02:31:00 PM 3 3X3   6010356.171 2120603.3463 37.8033561544514 -122.408368084374 (37.8033561544514, -122.408368084374)
5910 13011 3 80 396 Lombard St 2 1 1 2   10/28/2015 07:12:00 AM 3 3X3   6010476.6325 2120660.3892 37.8035195251148 -122.40795524597999 (37.8035195251148, -122.40795524598)
7621 29909 1 80 515-519 Lombard St 2 1 1 1   01/06/2016 07:29:00 AM 3 3x3   6009867.8709 2120537.6157 37.8031483182934 -122.41005322890301 (37.8031483182934, -122.410053228903)
22867 143011 1 80 650-654 LOMBARD ST 2 1 1 1   03/11/2017 12:26:00 PM 3 Width 0ft   6009188.4253 2120483.2963 37.8029610657241 -122.41240063587601 (37.8029610657241, -122.412400635876)
79381 114695 2 80 799x TAYLOR ST 2 1 1 1       3x3   6009121.0 2115613.0 37.7895846457112 -122.41228952949498 (37.7895846457112, -122.412289529495)
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)
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)
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)
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)
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)
98226 116254 2 80 155 LAGUNA ST 2 1 1 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
100092 112520 2 80 146x ARLETA AVE 2 1 1 1       3x3   6010471.0 2087928.0 37.7136434126305 -122.40566785728501 (37.7136434126305, -122.405667857285)
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)
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)
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)
107040 119284 2 80 651 28th Ave 2 1 1 1   07/26/2016 12:00:00 AM 3 3x3   5987187.0 2111505.0 37.777050030999604 -122.487875935939 (37.7770500309996, -122.487875935939)
107527 1444 1 80 151X Arguello Blvd 2 1 1 1   10/17/2009 12:00:00 AM 3 3X5   5995492.27499 2115135.20138 37.7874985527143 -122.459408560713 (37.7874985527143, -122.459408560713)
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)
110276 121108 2 80 1391 08th Ave 2 1 1 1   09/09/2016 12:00:00 AM 3 3x3   5993608.0 2106030.0 37.7623895873424 -122.46526608917601 (37.7623895873424, -122.465266089176)
114164 116239 2 80 229x HAIGHT ST 2 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
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)
120569 113398 2 80 603 CLAYTON ST 2 1 1 1       3x3   5998367.0 2108846.0 37.7703949048055 -122.44900941031099 (37.7703949048055, -122.449009410311)
122317 13082 1 80 650 Lombard St 2 1 1 1   10/05/2016 10:37:00 AM 3 3x3   6009219.60633 2120572.31429 37.803207236671604 -122.41229902844101 (37.8032072366716, -122.412299028441)
125041 13072 1 80 645X Lombard St 2 1 1 3   09/27/2008 12:00:00 AM 3 3X3   6009269.1098284 2120449.52185 37.8028728569333 -122.412119036156 (37.8028728569333, -122.412119036156)
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)
128494 13022 3 80 431 Lombard St 2 1 1 2   10/28/2015 07:20:00 AM 3 3X3   6010276.62799 2120585.425 37.803302492372396 -122.408642082138 (37.8033024923724, -122.408642082138)
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)
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)
2783 252852 2 80 100X Langton St 3 1 1 1       2.5x4   6010166.0 2110701.0 37.776156040570996 -122.408327321329 (37.776156040571, -122.408327321329)
6621 13040 1 80 515-519 Lombard St 3 1 1 1   01/06/2016 07:26:00 AM 3 3X3   6009890.5899 2120540.3695 37.8031571528751 -122.409974803368 (37.8031571528751, -122.409974803368)
22647 9116 3 80 5757 Geary Blvd 3 1 1 2   09/23/2015 12:00:00 AM 3 3x3   5989143.6236 2112579.8502 37.7801152084298 -122.48118616959499 (37.7801152084298, -122.481186169595)
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)
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)
66020 116255 2 80 155 LAGUNA ST 3 1 1 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
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)
82486 114696 2 80 799x TAYLOR ST 3 1 1 1       3x3   6009121.0 2115613.0 37.7895846457112 -122.41228952949498 (37.7895846457112, -122.412289529495)
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)
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)
102168 116240 2 80 229x HAIGHT ST 3 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
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)
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)
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)
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)
9791 116717 2 80 690X 03RD ST 4 1 1 1   09/22/2003 12:00:00 AM 5 3x3   6014548.0 2111604.0 37.7788798826953 -122.393231883862 (37.7788798826953, -122.393231883862)
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)
78461 113802 2 80 806 SHOTWELL ST 4 7 1 1           6007931.0 2103220.0 37.755489548438 -122.41552904166201 (37.755489548438, -122.415529041662)
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)
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)
111595 112521 2 80 146x ARLETA AVE 4 1 1 1       3x3   6010471.0 2087928.0 37.7136434126305 -122.40566785728501 (37.7136434126305, -122.405667857285)
126761 116241 2 80 229x HAIGHT ST 4 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
141724 121042 2 80 2101 Polk St 4 1 1 1       3x3   6006363.0 2118098.0 37.7962526868942 -122.422008539697 (37.7962526868942, -122.422008539697)
142800 116256 2 80 155 LAGUNA ST 4 1 1 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
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)
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)
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)
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)
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)
113421 116242 2 80 229x HAIGHT ST 5 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
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)
142521 116257 2 80 155 LAGUNA ST 5 1 1 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
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)
43784 83046 5 80 100X Cargo Way 6 1 1 9   02/04/2006 12:00:00 AM 1     6018811.25128 2097616.11187 37.740707968002 -122.37751250161399 (37.740707968002, -122.377512501614)
81022 116243 2 80 229x HAIGHT ST 6 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
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)
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)
143334 116258 2 80 155 LAGUNA ST 6 1 1 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
4886 17862 3 80 2121 Pine St 7 1 1 2   10/31/2017 11:37:00 AM 3 3X3   6003706.1864 2115222.5689 37.7882072868246 -122.43099633374901 (37.7882072868246, -122.430996333749)
19726 116259 2 80 155 LAGUNA ST 7 1 1 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
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)
81344 116244 2 80 229x HAIGHT ST 7 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
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)
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)
107711 116260 2 80 155 LAGUNA ST 8 1 1 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
108883 116245 2 80 229 HAIGHT ST 8 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
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)
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)
90305 116261 2 80 155 LAGUNA ST 9 1 1 1       7x6   6005176.0 2109399.0 37.772300372561496 -122.425496410637 (37.7723003725615, -122.425496410637)
100241 116246 2 80 229 HAIGHT ST 9 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
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)
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)
119717 116247 2 80 229 HAIGHT ST 11 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
85348 116248 2 80 229 HAIGHT ST 12 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
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)
107993 116249 2 80 229 HAIGHT ST 13 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
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)
92554 116250 2 80 229 HAIGHT ST 14 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
104602 116251 2 80 229 HAIGHT ST 15 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
86226 116252 2 80 229 HAIGHT ST 16 1 1 1       4x4   6005035.0 2109517.0 37.7726164042624 -122.425992544154 (37.7726164042624, -122.425992544154)
Powered by Datasette · Query took 3.651ms · Data source: data.sfgov.org