sf-trees

Data source: data.sfgov.org

Custom SQL query returning 39 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
30779 60998 1 67 340 Brannan St 1 1 1 1   09/20/1991 12:00:00 AM 6 3x3 Permit Number 30085 6014626.949469999 2112460.0438599996 37.7812347712083 -122.393018675278 (37.7812347712083, -122.393018675278)
43415 82842 1 67 624 Natoma St 1 1 1 1   07/07/2009 12:00:00 AM 5 3x3 Permit Number 52445 6009524.75632 2111364.58269 37.7779421535385 -122.4105924362 (37.7779421535385, -122.4105924362)
53021 36796 1 67 1350 Donner Ave 6 1 1 1   12/21/2015 12:00:00 AM 5   Permit Number 39527 6015132.5367 2090909.0726 37.7220884281377 -122.38976385626002 (37.7220884281377, -122.38976385626)
63417 31615 1 67 750 Guerrero St 2 1 1 1   05/22/1995 12:00:00 AM     Permit Number 35136 6005596.48777411 2104595.39586612 37.75913456673371 -122.423700300709 (37.7591345667337, -122.423700300709)
78326 39114 1 67 501 Bartlett St 2 1 1 1   11/19/1998 12:00:00 AM     Permit Number 40801 6006834.26665835 2100862.7419909 37.7489553490953 -122.419154691519 (37.7489553490953, -122.419154691519)
83784 47253 1 67 1001 Le Conte Ave 2 1 1 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52373 6013117.42744406 2089558.25653077 37.718267407089 -122.39663499597201 (37.718267407089, -122.396634995972)
89975 36802 1 67 1365 Donner Ave 1 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39529 6015184.51378884 2090800.41329061 37.72179295326 -122.389576597698 (37.72179295326, -122.389576597698)
90164 36714 1 67 39 Lexington St 1 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39500 6006465.12887792 2105724.70992559 37.762284395060796 -122.420776293192 (37.7622843950608, -122.420776293192)
93836 47725 1 67 85 Sycamore St 1 1 1 1 1 05/23/2002 12:00:00 AM     Permit Number 45520 6006351.18478147 2105818.87737664 37.7625365339004 -122.421177070604 (37.7625365339004, -122.421177070604)
94572 98483 1 67 531X Franconia St 8 1 1 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
95056 98485 1 67 531X Franconia St 10 1 1 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
95946 36801 1 67 1365 Donner Ave 2 1 1 1 1 05/26/1998 12:00:00 AM     Permit Number 39529 6015184.51378884 2090800.41329061 37.72179295326 -122.389576597698 (37.72179295326, -122.389576597698)
102740 47727 1 67 85 Sycamore St 4 1 1 1   05/23/2002 12:00:00 AM     Permit Number 45520 6006351.18478147 2105818.87737664 37.7625365339004 -122.421177070604 (37.7625365339004, -122.421177070604)
102987 46811 1 67 172 Yerba Buena Ave 1 1 1 1 1 04/25/2002 12:00:00 AM     Permit Number 44893 5994497.83320908 2096348.9473150002 37.7358591414077 -122.461486623647 (37.7358591414077, -122.461486623647)
104961 41701 1 67 34 Natick St 1 1 1 1 1 06/19/2000 12:00:00 AM     Permit Number 42151 6003036.29664011 2095600.66365718 37.734292282497 -122.431912391757 (37.734292282497, -122.431912391757)
105830 79561 1 67 1001 Le Conte Ave 3 1 1 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52373 6013117.42744406 2089558.25653077 37.718267407089 -122.39663499597201 (37.718267407089, -122.396634995972)
106729 37269 1 67 3720 21st St 1 1 1 1 1 12/06/2002 12:00:00 AM     Permit Number 44410 6003590.32041295 2103642.33347016 37.7564042340637 -122.430570577111 (37.7564042340637, -122.430570577111)
107365 39492 1 67 3927 26th St 1 1 1 1 1 12/28/1998 12:00:00 AM     Permit Number 40950 6004349.113469999 2100706.94457928 37.74838729928089 -122.42773726390399 (37.7483872992809, -122.427737263904)
109042 31399 1 67 3850 18th St 3 1 1 1   04/26/1995 12:00:00 AM     Permit Number 34990 6003938.7782539 2105415.4152023997 37.7612924290105 -122.429491931159 (37.7612924290105, -122.429491931159)
109787 36542 1 67 190 Gates St 4 1 1 1 1 05/18/1998 12:00:00 AM     Permit Number 39415 6008260.22671845 2097736.01770388 37.7404502589313 -122.414002536769 (37.7404502589313, -122.414002536769)
115772 47723 1 67 85 Sycamore St 5 1 1 1   05/23/2002 12:00:00 AM     Permit Number 45520 6006351.18478147 2105818.87737664 37.7625365339004 -122.421177070604 (37.7625365339004, -122.421177070604)
117868 63534 1 67 345 San Carlos St 1 1 1 1 1 04/10/1987 12:00:00 AM     Permit Number 24147 6006748.16886694 2104110.61481304 37.757868414154295 -122.41968283278798 (37.7578684141543, -122.419682832788)
118734 39113 1 67 501 Bartlett St 1 1 1 1   11/19/1998 12:00:00 AM     Permit Number 40801 6006834.26665835 2100862.7419909 37.7489553490953 -122.419154691519 (37.7489553490953, -122.419154691519)
119934 47726 1 67 85 Sycamore St 2 1 1 1   05/23/2002 12:00:00 AM     Permit Number 45520 6006351.18478147 2105818.87737664 37.7625365339004 -122.421177070604 (37.7625365339004, -122.421177070604)
123786 31397 1 67 3850 18th St 1 1 1 1   04/26/1995 12:00:00 AM     Permit Number 34990 6003938.7782539 2105415.4152023997 37.7612924290105 -122.429491931159 (37.7612924290105, -122.429491931159)
126405 63533 1 67 368 San Carlos St 1 1 1 1 1 04/10/1987 12:00:00 AM     Permit Number 24146 6006703.62861604 2103973.71687458 37.7574900150011 -122.419827158071 (37.7574900150011, -122.419827158071)
133807 111385 1 67 340 Brannan St 3 1 1 1     5 3x3   6014582.17665 2112417.55167 37.7811156101297 -122.39317059416099 (37.7811156101297, -122.393170594161)
138883 79132 1 67 1001 Le Conte Ave 4 1 1 1   07/02/2009 12:00:00 AM   3x3 Permit Number 52373 6013117.42744406 2089558.25653077 37.718267407089 -122.39663499597201 (37.718267407089, -122.396634995972)
139243 98475 1 67 531X Franconia St 2 1 1 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
141780 31398 1 67 3850 18th St 2 1 1 1   04/26/1995 12:00:00 AM     Permit Number 34990 6003938.7782539 2105415.4152023997 37.7612924290105 -122.429491931159 (37.7612924290105, -122.429491931159)
142349 46812 1 67 172 Yerba Buena Ave 2 1 1 1 1 04/25/2002 12:00:00 AM     Permit Number 44893 5994497.83320908 2096348.9473150002 37.7358591414077 -122.461486623647 (37.7358591414077, -122.461486623647)
142511 63790 1 67 4064 25th St 1 1 1 1 1 07/09/1987 12:00:00 AM     Permit Number 24476 6003436.69055965 2101294.50423962 37.7499489448753 -122.430934327568 (37.7499489448753, -122.430934327568)
143298 98479 1 67 531X Franconia St 4 1 1 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
143504 98481 1 67 531X Franconia St 6 1 1 2     6 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
144928 98487 1 67 531X Franconia St 12 1 1 2     3 3x3   6009973.6 2098264.6 37.7419977132603 -122.408115605514 (37.7419977132603, -122.408115605514)
145314 55969 1 67 35 Mirabel Ave 1 1 1 1 1 02/26/2000 12:00:00 AM     Permit Number 770524 6007464.012592 2099914.14210495 37.7463861516938 -122.416909822502 (37.7463861516938, -122.416909822502)
151005 36798 1 67 1355 Donner Ave 3 1 1 1 1 07/17/1999 12:00:00 AM 6   Permit Number 39528 6015230.5975 2090758.0224 37.7216791113631 -122.38941433805701 (37.7216791113631, -122.389414338057)
153345 31802 1 67 55 Divisadero St 1 1 1 1 1 06/19/1995 12:00:00 AM 7   Permit Number 35272 6001924.59605 2107955.77099 37.768153377501505 -122.43663996825701 (37.7681533775015, -122.436639968257)
170346 38578 1 67 1539 Palou Ave 1 1 1 1 1 03/12/2005 12:00:00 AM 4   Permit Number 40538 6015192.4143 2094984.0689 37.733280874609704 -122.38984136904499 (37.7332808746097, -122.389841369045)
Powered by Datasette · Query took 81.016ms · Data source: data.sfgov.org