sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
5807 47379 1 51 4453 Manzanita Ave 1 1 1 1   05/13/2002 12:00:00 AM     Permit Number 45296          
10621 52188 1 51 76 Camona Av 1 1 1 1   11/01/2005 12:00:00 AM     Permit Number 48379          
15164 51415 1 51 7121 Kirkham St 1 1 1 1   10/14/2004 12:00:00 AM     Permit Number 47739          
108782 15977 1 51 5937 Mission St 2 1 1 1   02/28/1995 12:00:00 AM 6 3X3   5996505.5077599995 2086284.06053 37.7083386912237 -122.453818737586 (37.7083386912237, -122.453818737586)
84568 15970 1 51 5919X Mission St 1 1 1 1   02/28/1995 12:00:00 AM 6 3X3   5996671.773019999 2086351.2464599998 37.708532699460896 -122.45324895592199 (37.7085326994609, -122.453248955922)
110307 117181 2 51 8 KNOTT CT 2 1 1 1       3x3   6000120.0 2086463.0 37.7090365866676 -122.44133950250601 (37.7090365866676, -122.441339502506)
144893 117180 2 51 8 KNOTT CT 1 1 1 1     10 3x3   6000120.0 2086463.0 37.7090365866676 -122.44133950250601 (37.7090365866676, -122.441339502506)
9415 15943 1 51 5810X MISSION ST 8 1 1 1     6 4X4   5997175.0 2086632.0 37.7093324147693 -122.451529986796 (37.7093324147693, -122.451529986796)
96152 15940 3 51 5810X MISSION ST 5 1 1 2   04/20/1998 12:00:00 AM 6 3X3   5997175.0 2086632.0 37.7093324147693 -122.451529986796 (37.7093324147693, -122.451529986796)
79600 15934 1 51 5775 Mission St 2 1 1 1   03/01/1995 12:00:00 AM 6 3X3   5997641.29025 2086713.63365 37.7095832536665 -122.449924299561 (37.7095832536665, -122.449924299561)
26854 103532 1 51 130 South Hill Blvd 2 1 1 1   02/07/2014 12:00:00 AM 1   Permit Number 770957 6003118.601980001 2086861.7562 37.7103018500205 -122.431004337903 (37.7103018500205, -122.431004337903)
36031 103531 1 51 130 South Hill Blvd 1 1 1 1   02/07/2014 12:00:00 AM 1   Permit Number 770957 6003099.91342 2086880.6888299999 37.7103527759382 -122.43107027978901 (37.7103527759382, -122.431070279789)
87032 1201 1 51 3099X Alemany Blvd 3 1 1 1     6 3x3   5996220.7283 2087044.1157099998 37.7104092959015 -122.454857840965 (37.7104092959015, -122.454857840965)
95862 1202 1 51 3099X Alemany Blvd 4 1 1 1     6 3x3   5996220.7283 2087044.1157099998 37.7104092959015 -122.454857840965 (37.7104092959015, -122.454857840965)
111383 1199 3 51 3099X Alemany Blvd 1 1 1 2     6 3x3   5996220.7283 2087044.1157099998 37.7104092959015 -122.454857840965 (37.7104092959015, -122.454857840965)
141065 1200 1 51 3099X Alemany Blvd 2 1 1 1     6 3x3   5996220.7283 2087044.1157099998 37.7104092959015 -122.454857840965 (37.7104092959015, -122.454857840965)
9112 122861 3 51 3000X Alemany Blvd 8 11 1 2   12/08/2016 01:43:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9209 122858 3 51 3000X Alemany Blvd 5 11 1 2   12/08/2016 01:48:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9268 122855 3 51 3000X Alemany Blvd 2 11 1 2   12/08/2016 01:30:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9272 122860 3 51 3000X Alemany Blvd 7 11 1 2   12/08/2016 01:54:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9280 122859 3 51 3000X Alemany Blvd 6 11 1 2   12/08/2016 01:46:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9291 122856 3 51 3000X Alemany Blvd 3 11 1 2   12/08/2016 01:13:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9327 122854 3 51 3000X Alemany Blvd 1 11 1 2   12/08/2016 01:40:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9354 122862 3 51 3000X Alemany Blvd 9 11 1 2   12/08/2016 01:57:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
9406 122857 3 51 3000X Alemany Blvd 4 11 1 2   12/08/2016 01:17:00 PM 3 3x3   5996648.0 2087344.0 37.7112572095529 -122.453402744961 (37.7112572095529, -122.453402744961)
81227 42741 1 51 295 Tocoloma Ave 3 1 1 1 1 08/22/2002 12:00:00 AM     Permit Number 45864 6012649.44440777 2087097.71305381 37.711485187600495 -122.39808010272101 (37.7114851876005, -122.398080102721)
78479 122863 3 51 2900X Alemany Blvd 1 11 1 2     1 3x3   5996824.0 2087575.0 37.7119015691826 -122.45281111027501 (37.7119015691826, -122.452811110275)
78492 122871 3 51 2900X Alemany Blvd 9 11 1 2       3x3   5996824.0 2087575.0 37.7119015691826 -122.45281111027501 (37.7119015691826, -122.452811110275)
95149 122869 3 51 2900X Alemany Blvd 7 11 1 2       3x3   5996824.0 2087575.0 37.7119015691826 -122.45281111027501 (37.7119015691826, -122.452811110275)
106109 122870 3 51 2900X Alemany Blvd 8 11 1 2       3x3   5996824.0 2087575.0 37.7119015691826 -122.45281111027501 (37.7119015691826, -122.452811110275)
117798 122864 3 51 2900X Alemany Blvd 2 11 1 2       3x3   5996824.0 2087575.0 37.7119015691826 -122.45281111027501 (37.7119015691826, -122.452811110275)
120858 122865 3 51 2900X Alemany Blvd 3 11 1 2       3x3   5996824.0 2087575.0 37.7119015691826 -122.45281111027501 (37.7119015691826, -122.452811110275)
122628 122868 3 51 2900X Alemany Blvd 6 11 1 2       3x3   5996824.0 2087575.0 37.7119015691826 -122.45281111027501 (37.7119015691826, -122.452811110275)
138657 122866 3 51 2900X Alemany Blvd 4 11 1 2       3x3   5996824.0 2087575.0 37.7119015691826 -122.45281111027501 (37.7119015691826, -122.452811110275)
145296 122867 3 51 2900X Alemany Blvd 5 11 1 2       3x3   5996824.0 2087575.0 37.7119015691826 -122.45281111027501 (37.7119015691826, -122.452811110275)
148867 44382 1 51 1257 Athens St 1 1 1 1 1 03/22/2001 12:00:00 AM 10   Permit Number 43744 6001457.21112 2087559.6242799999 37.71212376138379 -122.43679636128901 (37.7121237613838, -122.436796361289)
69123 180485 2 51 1222 Athens St 3 1 1 1     1 Width 4ft   6001620.509380001 2087598.74128 37.712240447503 -122.436234753557 (37.712240447503, -122.436234753557)
103491 85333 1 51 179 Sadowa St 1 1 1 1   08/13/2007 12:00:00 AM     Permit Number 49613 5995212.0 2087736.0 37.7122511325681 -122.458394244156 (37.7122511325681, -122.458394244156)
85331 115871 1 51 84X Cordova St 3 1 1 1   02/29/2016 12:00:00 AM 3   Permit Number 775902. On Athens St frontage 6001679.7 2087642.4 37.712363687575795 -122.43603329568501 (37.7123636875758, -122.436033295685)
77816 52055 1 51 199 Leland Ave 2 1 1 1   09/29/2005 12:00:00 AM     Permit Number 48255 6009975.44300852 2087511.82859192 37.712472966599705 -122.407351368495 (37.7124729665997, -122.407351368495)
81081 52056 1 51 199 Leland Ave 3 1 1 1   09/29/2005 12:00:00 AM     Permit Number 48255 6009975.44300852 2087511.82859192 37.712472966599705 -122.407351368495 (37.7124729665997, -122.407351368495)
97908 52053 1 51 199 Leland Ave 5 1 1 1   09/29/2005 12:00:00 AM     Permit Number 48255 6009975.44300852 2087511.82859192 37.712472966599705 -122.407351368495 (37.7124729665997, -122.407351368495)
124729 52057 1 51 199 Leland Ave 4 1 1 1   09/29/2005 12:00:00 AM     Permit Number 48255 6009975.44300852 2087511.82859192 37.712472966599705 -122.407351368495 (37.7124729665997, -122.407351368495)
10028 161764 1 51 142 Newton St 1 1 1 1   01/23/2017 12:00:00 AM 3 3x3 Permit Number 779227 6000990.7389 2087787.91218 37.7127240669257 -122.43842496696001 (37.7127240669257, -122.43842496696)
42751 108789 1 51 1100-1198X Schwerin St 5 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)
82210 108786 1 51 1100-1198X Schwerin St 2 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)
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)
99997 108787 1 51 1100-1198X Schwerin St 3 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)
142924 108788 1 51 1100-1198X Schwerin St 4 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)
50167 122876 3 51 2701X Alemany Blvd 5 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
79180 122891 3 51 2701X Alemany Blvd 20 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
83773 122890 3 51 2701X Alemany Blvd 19 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
84374 122889 3 51 2701X Alemany Blvd 18 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
85203 122882 3 51 2701X Alemany Blvd 11 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
86640 122875 3 51 2701X Alemany Blvd 4 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
87507 122894 3 51 2701X Alemany Blvd 23 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
87518 122881 3 51 2701X Alemany Blvd 10 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
87928 122879 3 51 2701X Alemany Blvd 8 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
89597 122877 3 51 2701X Alemany Blvd 6 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
89782 122888 3 51 2701X Alemany Blvd 17 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
89911 122886 3 51 2701X Alemany Blvd 15 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
90143 122880 3 51 2701X Alemany Blvd 9 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
100569 122874 3 51 2701X Alemany Blvd 3 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
100705 122895 3 51 2701X Alemany Blvd 24 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
105370 122885 3 51 2701X Alemany Blvd 14 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
108044 122872 3 51 2701X Alemany Blvd 1 11 1 2     1 3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
111753 122873 3 51 2701X Alemany Blvd 2 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
113911 122878 3 51 2701X Alemany Blvd 7 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
120027 122883 3 51 2701X Alemany Blvd 12 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
126508 122887 3 51 2701X Alemany Blvd 16 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
138864 122893 3 51 2701X Alemany Blvd 22 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
144043 122884 3 51 2701X Alemany Blvd 13 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
144507 122892 3 51 2701X Alemany Blvd 21 11 1 2       3x3   5997494.0 2087981.0 37.7130547225267 -122.45052466448799 (37.7130547225267, -122.450524664488)
76812 26075 1 51 279 Broad St 1 1 1 1   03/19/2003 12:00:00 AM 12 3X3   5994244.197480001 2088053.67853 37.7130677382333 -122.46176225203001 (37.7130677382333, -122.46176225203)
19942 26077 1 51 261 Broad St 1 1 1 1   11/24/2015 02:44:00 PM 3 3X3   5994378.441000001 2088053.8388 37.7130759052536 -122.461298276453 (37.7130759052536, -122.461298276453)
97339 85212 1 51 229 Broad St 1 1 1 1   07/02/2007 12:00:00 AM 3 3x3 maintenance agreement through 7/2/2010 5994738.0 2088050.0 37.7130860517587 -122.46005525076299 (37.7130860517587, -122.460055250763)
116632 29949 3 51 239 Broad St 1 1 1 2   03/10/2007 12:00:00 AM 3 3x3   5994631.9727903 2088054.39173388 37.7130920115953 -122.460422031825 (37.7130920115953, -122.460422031825)
98063 29947 1 51 203 Broad St 2 1 1 1   03/10/2007 12:00:00 AM 3 3x3   5994985.99771987 2088049.72518423 37.7130995578919 -122.45919807332301 (37.7130995578919, -122.459198073323)
79471 26094 1 51 21 Broad St 1 1 1 1   12/31/1997 12:00:00 AM 12 3X3   5996391.73364 2088029.79177 37.71312554209 -122.454337965939 (37.71312554209, -122.454337965939)
163 29943 3 51 242 Broad St 1 1 1 2   03/28/2017 12:23:00 PM 3 3x3   5994593.32204167 2088106.90572275 37.7132339790874 -122.460559423837 (37.7132339790874, -122.460559423837)
113738 26400 1 51 272 Broad St 1 1 1 1   12/31/1997 12:00:00 AM 12 3X3   5994293.52025 2088114.03225 37.7132362944599 -122.46159615030899 (37.7132362944599, -122.461596150309)
113119 26066 1 51 252 Broad St 2 1 1 1   12/22/1997 12:00:00 AM 12 3X3   5994485.32272 2088110.77616 37.7132383925183 -122.46093298415701 (37.7132383925183, -122.460932984157)
78942 29941 1 51 200 Broad St 1 1 1 1   03/10/2007 12:00:00 AM 3 3x3   5995006.35114609 2088101.46141456 37.7132427835292 -122.459131469448 (37.7132427835292, -122.459131469448)
98617 26044 1 51 32 Broad St 13 1 1 1   12/19/1997 12:00:00 AM 7 3X3   5996138.5208 2088089.89027 37.7132760340232 -122.45521749021002 (37.7132760340232, -122.45521749021)
107773 26043 1 51 32 Broad St 12 1 1 1   06/03/2015 12:00:00 AM 3 3X3   5996178.64561 2088089.5286700001 37.7132773431944 -122.455078779743 (37.7132773431944, -122.455078779743)
83999 26042 1 51 32 Broad St 11 1 1 1   03/19/2003 12:00:00 AM 10 3X3   5996190.731819999 2088089.91613 37.7132791004475 -122.455037033861 (37.7132791004475, -122.455037033861)
116305 26040 3 51 32 Broad St 9 1 1 2   06/03/2015 12:00:00 AM 8 3x3   5996258.07972 2088089.3008299998 37.7132812744111 -122.45480421322901 (37.7132812744111, -122.454804213229)
79330 26039 1 51 32 Broad St 8 1 1 1   06/03/2015 12:00:00 AM 6 3X3   5996279.3875 2088089.20515 37.713282233928 -122.454730559713 (37.713282233928, -122.454730559713)
113312 26041 1 51 32 Broad St 10 1 1 1   12/19/1997 12:00:00 AM 9 3X3   5996239.04821 2088090.4012099998 37.7132832040965 -122.454870071763 (37.7132832040965, -122.454870071763)
128289 112742 1 51 156 Broad St 1 1 1 1 1 11/22/2014 12:00:00 AM     Permit Number 774175 5995316.4 2088116.5 37.7133018954425 -122.45806092895701 (37.7133018954425, -122.458060928957)
125649 15854 1 51 5319 Mission St 1 1 1 1   03/01/1995 12:00:00 AM 6 3X3   5999668.720480001 2088318.36983 37.714105297270606 -122.443032341019 (37.7141052972706, -122.443032341019)
142815 15859 1 51 5367 Mission St 1 1 1 1   03/01/1995 12:00:00 AM 6 3X3   5999657.0 2088324.0 37.7141200881786 -122.44307325545601 (37.7141200881786, -122.443073255456)
88818 18610 1 51 615 Randolph St 1 1 1 1   09/12/2016 12:00:00 AM 3 3x3 Permit Number 778725 5992407.5548851 2088503.1314627 37.7141959284164 -122.468142922603 (37.7141959284164, -122.468142922603)
143672 18582 3 51 200 Randolph St 1 1 1 2   03/08/2005 12:00:00 AM 3 3X3   5993482.998785401 2088541.1278418999 37.7143623091404 -122.46442855867399 (37.7143623091404, -122.464428558674)
145771 18583 3 51 200 Randolph St 2 1 1 2   03/08/2005 12:00:00 AM 3 3X3   5993482.998785401 2088541.1278418999 37.7143623091404 -122.46442855867399 (37.7143623091404, -122.464428558674)
20624 25466 1 51 446 Randolph St 1 1 1 1   05/13/2015 12:00:00 AM 6 3X3   5992823.9205 2088555.2969999998 37.714363200126904 -122.466707603629 (37.7143632001269, -122.466707603629)
108188 25464 3 51 308 Randolph St 3 1 1 2   09/24/1998 12:00:00 AM 3 3X3   5993086.26773 2088550.30696 37.714364635542395 -122.46580047311001 (37.7143646355424, -122.46580047311)
77490 25459 1 51 120 Randolph St 2 1 1 1   03/15/2003 12:00:00 AM 3 3X3   5993585.96467 2088543.99773 37.714376124024504 -122.464072878916 (37.7143761240245, -122.464072878916)
92289 25458 1 51 120 Randolph St 1 1 1 1   03/15/2003 12:00:00 AM 3 3X3   5993547.93552 2088545.97374 37.7143793578368 -122.464204465034 (37.7143793578368, -122.464204465034)
86022 17243 1 51 10X Randolph St 1 1 1 1   03/15/2003 12:00:00 AM 6 3X34   5993969.30173 2088537.74626 37.7143810447114 -122.462747471174 (37.7143810447114, -122.462747471174)
91430 51896 1 51 109 Lobos St 1 1 1 1   07/18/2005 12:00:00 AM     Permit Number 48107 5995812.81263218 2088671.52692975 37.7148543797151 -122.45638527464199 (37.7148543797151, -122.456385274642)
Powered by Datasette · Query took 10.39ms · Data source: data.sfgov.org