sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
14379 48480 1 17   1 11 1 1         Permit Number 45832          
99750 92208 1 60 300x Miramar Ave 2 11 1 1   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
100266 92210 1 143 300x Miramar Ave 4 11 1 1   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
112226 92209 1 60 300x Miramar Ave 3 11 1 1   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
112766 92207 1 143 300X Miramar Ave 1 11 1 1   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
128923 92212 1 17 300x Miramar Ave 6 11 1 1   07/16/2009 12:00:00 AM   2x2 Permit Number 52642 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
139081 92211 1 60 300x Miramar Ave 5 11 1 1   12/29/2010 12:00:00 AM   2x2 Permit Number 54064 5995384.3 2092126.4 37.724316032008204 -122.45811627477501 (37.7243160320082, -122.458116274775)
86969 99459 1 60 550X Miramar Ave 5 11 1 1   10/28/2014 12:00:00 AM 3 15x280 Permit Number 772553 5995413.0 2092983.7 37.7266716211667 -122.45807907885799 (37.7266716211667, -122.458079078858)
19496 34866 1 41 579 Miramar Ave 1 11 1 1 1 12/29/2015 12:00:00 AM     Permit Number 775311 5995338.59696042 2093168.95782094 37.7271760192259 -122.458349689476 (37.7271760192259, -122.458349689476)
78674 99497 1 180 1400X Plymouth Ave 4 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
83274 99496 1 60 1400X Plymouth Ave 3 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
87404 99494 1 60 1400X Plymouth Ave 1 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
122780 99495 1 60 1400X Plymouth Ave 2 11 1 1           5995903.0 2093347.3 37.7276981218086 -122.45641145576 (37.7276981218086, -122.45641145576)
100862 99476 1 60 650X Miramar Ave 2 11 1 1   10/28/2014 12:00:00 AM 3 15x280 Permit Number 772553 5995425.4 2093662.3 37.728535605791 -122.45808530293199 (37.728535605791, -122.458085302932)
128765 99475 1 60 650X Miramar Ave 1 11 1 1   04/18/2014 12:00:00 AM 44 15x280 Permit Number 772553 5995425.4 2093662.3 37.728535605791 -122.45808530293199 (37.728535605791, -122.458085302932)
86095 103414 1 180 1490X Plymouth Ave 1 11 1 1   04/18/2013 12:00:00 AM     Permit Number 770026 5995919.3 2094026.5 37.7295639775589 -122.456404198854 (37.7295639775589, -122.456404198854)
113986 115182 1 51 315 Lakeshore Dr 1 11 1 1   01/15/2016 12:00:00 AM     Permit Number 775158 5983956.6 2095109.9 37.7318446842931 -122.497839799214 (37.7318446842931, -122.497839799214)
118559 3686 1 5 100X Cargo Way 1 11 1 9     12 8   6018980.3390981 2097500.2540781004 37.740399159699294 -122.376919818221 (37.7403991596993, -122.376919818221)
117426 106344 1 7 2428 14th Ave 1 11 1 1   04/18/2014 12:00:00 AM   3x3   5992079.0 2098890.7 37.7426986307713 -122.470034423922 (37.7426986307713, -122.470034423922)
144189 106345 1 7 2428 14th Ave 2 11 1 1   04/18/2014 12:00:00 AM   3x3   5992079.0 2098890.7 37.7426986307713 -122.470034423922 (37.7426986307713, -122.470034423922)
99473 3689 1 5 200X Cargo Way 3 11 1 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
127580 3691 1 5 200X Cargo Way 5 11 1 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
127726 3690 1 5 200X Cargo Way 4 11 1 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
128521 3688 1 5 200X Cargo Way 2 11 1 9     18 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
140153 3687 1 5 200X Cargo Way 1 11 1 9     12 8   6017218.5539168 2098854.5663776 37.7440206368399 -122.38310567533199 (37.7440206368399, -122.383105675332)
98538 98820 1 47 302X Pacheco St 28 11 1 1   05/09/2010 12:00:00 AM     Permit Number 768820 5994341.5 2100725.2 37.747866238402096 -122.46234443277001 (37.7478662384021, -122.46234443277)
72222 87818 1 180 85 Mendosa Ave 1 11 1 1   06/04/2008 12:00:00 AM     Permit Number 50680 5993356.0 2100787.0 37.747979128324 -122.46575670711701 (37.747979128324, -122.465756707117)
125989 87027 1 302 23 Magellan Ave 1 11 1 1       3x3 Permit Number 49971 5994623.4 2101166.9 37.74909526366879 -122.461401658799 (37.7490952636688, -122.461401658799)
127755 83007 1 457 1058 De Haro St 1 11 2 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52381 6012170.46860809 2103464.70975517 37.7563988530014 -122.40088475581499 (37.7563988530014, -122.400884755815)
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)
86601 27299 1 71 7800X Geary Blvd 6 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982630.17797 2112395.09735 37.779227117259296 -122.503705073784 (37.7792271172593, -122.503705073784)
143978 27298 1 71 7800X Geary Blvd 5 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982658.07107 2112395.9042 37.7792309725957 -122.503608641413 (37.7792309725957, -122.503608641413)
111288 27297 1 71 7800X Geary Blvd 4 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982680.863919999 2112396.64212 37.7792343387449 -122.50352984750401 (37.7792343387449, -122.503529847504)
114112 27296 1 71 7800X Geary Blvd 3 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982703.46074 2112397.7930900003 37.7792388274313 -122.50345176232 (37.7792388274313, -122.50345176232)
92056 27295 1 71 7800X Geary Blvd 2 11 1 11   06/10/1999 12:00:00 AM 6 5X5   5982729.47953 2112398.50568 37.779242313567295 -122.50336180684499 (37.7792423135673, -122.503361806845)
125546 27294 1 71 7800X Geary Blvd 1 11 1 11   02/12/2001 12:00:00 AM 6 5X5   5982752.16339 2112399.44122 37.77924621575129 -122.503283404585 (37.7792462157513, -122.503283404585)
139779 27853 1 100 100 The Embarcadero 8 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015772.90401 2112134.31501 37.780403982219205 -122.389031454309 (37.7804039822192, -122.389031454309)
117445 27852 1 100 100 The Embarcadero 7 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015817.39201 2112182.05801 37.780537539741395 -122.388880882265 (37.7805375397414, -122.388880882265)
139983 27851 1 100 100 The Embarcadero 6 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015857.5390099995 2112236.31101 37.7806887314792 -122.388745782008 (37.7806887314792, -122.388745782008)
109189 27850 1 100 100 The Embarcadero 5 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015895.51701 2112292.73501 37.7808457639334 -122.38861833648701 (37.7808457639334, -122.388618336487)
120266 27849 1 100 100 The Embarcadero 4 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015921.55801 2112354.58401 37.7810170305764 -122.388532565578 (37.7810170305764, -122.388532565578)
78875 27848 1 100 100 The Embarcadero 3 11 1 9   07/15/1994 12:00:00 AM 12 3X3   6015938.91901 2112416.43301 37.7811878161514 -122.388476823036 (37.7811878161514, -122.388476823036)
78913 25684 1 100 100 The Embarcadero 2 11 1 9   12/18/2000 12:00:00 AM 12 3X3   6015953.02501 2112484.79201 37.781376296324 -122.388432795571 (37.781376296324, -122.388432795571)
126124 25683 1 100 100 The Embarcadero 1 11 1 9   12/18/2000 12:00:00 AM 12 3X3   6015960.62101 2112553.15201 37.781564418481004 -122.388411289639 (37.781564418481, -122.388411289639)
94674 27870 1 100 800 The Embarcadero 5 11 1 9   01/31/2001 12:00:00 AM 24 4X4   6015155.50001 2116672.0830099997 37.79282941355329 -122.391484690649 (37.7928294135533, -122.391484690649)
118790 27869 1 100 800 The Embarcadero 4 11 1 9   01/31/2001 12:00:00 AM 24 4X4   6015100.81301 2116738.49001 37.7930087163181 -122.39167855690701 (37.7930087163181, -122.391678556907)
115406 27868 1 100 800 The Embarcadero 3 11 1 9   01/31/2001 12:00:00 AM 24 4X4   6015038.31301 2116806.19801 37.793191157262704 -122.39189954881 (37.7931911572627, -122.39189954881)
125282 27867 1 100 800 The Embarcadero 2 11 1 9   01/31/2001 12:00:00 AM 24 4X4   6014979.71901 2116870.00001 37.7933630896865 -122.392106753362 (37.7933630896865, -122.392106753362)
109422 27866 1 100 800 The Embarcadero 1 11 1 9   01/31/2001 12:00:00 AM 24 4X4   6014921.77607 2116935.19701 37.793538888238395 -122.39231180375 (37.7935388882384, -122.39231180375)
104698 27952 1 15 107X The Embarcadero 2 11 1 9   02/05/2001 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
106951 27956 1 15 107X The Embarcadero 6 11 1 9   02/05/2001 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
108807 27718 1 15 107X The Embarcadero 1 11 1 9   09/11/2000 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
114418 27957 1 15 107X The Embarcadero 7 11 1 9   02/05/2001 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
128222 27953 1 15 107X The Embarcadero 3 11 1 9   02/05/2001 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
140645 27955 1 15 107X The Embarcadero 5 11 1 9   02/05/2001 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
145142 27954 1 15 107X The Embarcadero 4 11 1 9   02/05/2001 12:00:00 AM 6     6014670.2880903 2117144.019363 37.7940982979938 -122.39319659791501 (37.7940982979938, -122.393196597915)
94898 28032 1 100 100 The Embarcadero 12 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014349.29301 2117643.21201 37.7954511263865 -122.394342251353 (37.7954511263865, -122.394342251353)
104388 28031 1 100 100 The Embarcadero 11 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014334.10201 2117669.25401 37.7955217871698 -122.394396639485 (37.7955217871698, -122.394396639485)
78636 28030 1 100 100 The Embarcadero 10 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014322.16601 2117689.8700099997 37.795577730351205 -122.39443938464899 (37.7955777303512, -122.394439384649)
142211 28029 1 100 100 The Embarcadero 9 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014304.80501 2117713.7420099997 37.7956423121436 -122.394501129585 (37.7956423121436, -122.394501129585)
144979 28028 1 100 100 The Embarcadero 8 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014289.61401 2117737.61301 37.7957070117951 -122.394555365911 (37.7957070117951, -122.394555365911)
102648 28027 1 100 100 The Embarcadero 7 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014263.57201 2117754.9750099997 37.795753235969 -122.394646693031 (37.795753235969, -122.394646693031)
123608 28026 1 100 100 The Embarcadero 6 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014253.80701 2117776.67601 37.795812278914 -122.39468200241699 (37.795812278914, -122.394682002417)
1379 25668 1 100 450X The Embarcadero 1 11 1 9   12/18/2000 12:00:00 AM 36 15   6014174.0749699995 2117868.41683 37.796059744425996 -122.394964320767 (37.796059744426, -122.394964320767)
77877 28025 1 100 100 The Embarcadero 5 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014170.25601 2117873.24701 37.796072794607895 -122.39497787369301 (37.7960727946079, -122.394977873693)
6748 26030 1 100 450X The Embarcadero 2 11 1 9   12/01/2000 12:00:00 AM 36 10   6014150.34723 2117905.1373099997 37.796159250800294 -122.395048997307 (37.7961592508003, -122.395048997307)
81297 28024 1 100 100 The Embarcadero 4 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014145.300009999 2117911.2250099997 37.7961756855245 -122.39506688844999 (37.7961756855245, -122.39506688845)
6093 26031 1 100 450X The Embarcadero 3 11 1 9   12/01/2000 12:00:00 AM 36 10   6014122.12078 2117941.0950599997 37.7962564126589 -122.39514918719999 (37.7962564126589, -122.3951491872)
92971 28023 1 100 100 The Embarcadero 3 11 1 9   02/05/2001 12:00:00 AM 24 4x4   6014119.25801 2117944.86201 37.7962665966149 -122.395159357042 (37.7962665966149, -122.395159357042)
5331 25671 1 100 450X The Embarcadero 4 11 1 9   12/18/2000 12:00:00 AM 36 15   6014100.8579 2117974.29057 37.7963463772386 -122.395225088169 (37.7963463772386, -122.395225088169)
115397 28022 1 100 100 The Embarcadero 2 11 1 9   02/05/2001 12:00:00 AM 24 4X4   6014106.23701 2117977.41401 37.796355252616294 -122.39520669408002 (37.7963552526163, -122.39520669408)
5927 25672 1 100 450X The Embarcadero 5 11 1 9   12/18/2000 12:00:00 AM 36 15   6014076.201780001 2118013.23421 37.796451936061295 -122.39531313361799 (37.7964519360613, -122.395313133618)
82580 28021 1 100 100 The Embarcadero 1 11 1 9   02/05/2001 12:00:00 AM 24 4x4   6014080.19501 2118017.56101 37.796464038519396 -122.39529961933201 (37.7964640385194, -122.395299619332)
89834 27792 1 127 199X The Embarcadero 9 11 1 9     12     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
91142 28372 1 100 199X The Embarcadero 1 11 1 9     18     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
101242 27788 1 100 199X The Embarcadero 5 11 1 9     14     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
101933 27789 1 127 199X The Embarcadero 6 11 1 9     12     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
104599 27791 1 127 199X The Embarcadero 8 11 1 9     12     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
112303 27790 1 127 199X The Embarcadero 7 11 1 9     12     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
113231 27793 1 127 199X The Embarcadero 10 11 1 9     12     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
120310 27785 1 100 199X The Embarcadero 2 11 1 9     18     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
140643 27786 1 100 199X The Embarcadero 3 11 1 9     14     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
141929 27794 1 127 199X The Embarcadero 11 11 1 9     12     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
145407 27787 1 100 199X The Embarcadero 4 11 1 9     14     6014015.4653372 2118064.3876984 37.796589013389394 -122.39552688195299 (37.7965890133894, -122.395526881953)
7340 25782 1 100 500X The Embarcadero 1 11 1 9   08/15/1996 12:00:00 AM 36 10   6013997.3565 2118221.08563 37.7970182616509 -122.395600527244 (37.7970182616509, -122.395600527244)
7108 25783 1 100 500X The Embarcadero 2 11 1 9   08/30/1996 12:00:00 AM 36 10   6013938.98446 2118296.9177 37.7972232315271 -122.39580782638599 (37.7972232315271, -122.395807826386)
8987 25784 1 100 500X The Embarcadero 3 11 1 9   08/30/1996 12:00:00 AM 36 10   6013869.26975 2118339.24702 37.797335579338004 -122.396052026484 (37.797335579338, -122.396052026484)
724 25734 1 100 500X The Embarcadero 4 11 1 9   08/15/1996 12:00:00 AM 16 10   6013899.49111 2118360.1858599996 37.7973947538281 -122.395948920127 (37.7973947538281, -122.395948920127)
82090 27775 1 100 299X The Embarcadero 3 11 1 9   12/01/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
87650 27777 1 100 299X The Embarcadero 5 11 1 9   12/01/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
96124 27767 1 100 299X The Embarcadero 1 11 1 9   12/10/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
100132 27778 1 100 299X The Embarcadero 6 11 1 9   12/01/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
121752 27776 1 100 299X The Embarcadero 4 11 1 9   12/01/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
139415 27774 1 100 299X The Embarcadero 2 11 1 9   12/10/2000 12:00:00 AM 26     6013785.1217042 2118375.8431165 37.797431381421 -122.39634576874799 (37.797431381421, -122.396345768748)
90111 27847 1 100 280 The Embarcadero 8 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
99547 27845 1 100 280 The Embarcadero 6 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
100729 27843 1 100 280 The Embarcadero 4 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
105556 27842 1 100 280 The Embarcadero 3 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
105677 27827 1 100 280 The Embarcadero 1 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
110061 27844 1 100 280 The Embarcadero 5 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
115875 27841 1 100 280 The Embarcadero 2 11 1 9   07/15/1994 12:00:00 AM 36     6013933.6105332 2118392.9536833 37.797486624670704 -122.395833154489 (37.7974866246707, -122.395833154489)
Powered by Datasette · Query took 79.225ms · Data source: data.sfgov.org