sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3737 175356 2 12 1 Brotherhood Way 1 1 1 1     3 Width 5ft   5992860.08995 2087808.05232 37.71231353272879 -122.46652830874201 (37.7123135327288, -122.466528308742)
3738 175361 2 12 1 Brotherhood Way 6 7 1 1     3 Width 5ft   5993097.02114 2087813.9243700001 37.7123433254574 -122.465709836634 (37.7123433254574, -122.465709836634)
3740 175359 2 12 1 Brotherhood Way 4 7 1 1     7 Width 5ft   5993023.53483 2087808.23472 37.7123234639353 -122.465963412176 (37.7123234639353, -122.465963412176)
3742 219632 1 12 878 Hampshire St 1 1 1 1   01/20/2015 12:00:00 AM 1 Width 3ft Permit Number 774094 6010166.130969999 2104121.45382 37.7580901202723 -122.40786279863899 (37.7580901202723, -122.407862798639)
3743 175363 2 12 1 Brotherhood Way 8 17 1 1     3 Width 5ft   5993226.79298 2087801.79474 37.71231750501779 -122.465260429219 (37.7123175050178, -122.465260429219)
3747 175360 2 12 1 Brotherhood Way 5 7 1 1     5 Width 5ft   5993054.1062900005 2087811.2090200002 37.7123333942521 -122.46585796488002 (37.7123333942521, -122.46585796488)
3748 175358 2 12 1 Brotherhood Way 3 7 1 1     3 Width 5ft   5992915.27224 2087806.8926400002 37.7123135327144 -122.466337499576 (37.7123135327144, -122.466337499576)
3813 43299 1 12 615 Rhode Island St 2 1 1 1 1 07/12/2000 12:00:00 AM 7   Permit Number 43068 6011854.0 2105476.0 37.761903752987706 -122.402120617661 (37.7619037529877, -122.402120617661)
3815 43300 1 12 615 Rhode Island St 1 1 1 1 1 07/12/2000 12:00:00 AM 10   Permit Number 43068 6011854.0 2105476.0 37.761903752987706 -122.402120617661 (37.7619037529877, -122.402120617661)
4008 216051 2 12 48 Lobos St 1 2 1 1   10/05/2017 02:54:00 PM 3     5996419.4156599995 2088710.03455 37.7149949180514 -122.454291392827 (37.7149949180514, -122.454291392827)
4030 216055 2 12 52 Lobos St 3 2 1 1   10/05/2017 02:49:00 PM 3     5996381.618969999 2088696.9088599999 37.714956710372 -122.454421085891 (37.714956710372, -122.454421085891)
4092 216045 2 12 36 Lobos St 2 2 1 1   10/05/2017 03:04:00 PM 3     5996513.0629 2088696.2251900001 37.7149623706927 -122.45396671331999 (37.7149623706927, -122.45396671332)
4097 216058 2 12 58 Lobos St 1 2 1 1   10/05/2017 02:35:00 PM 3     5996320.31527 2088710.5585599998 37.7149906732676 -122.45463396169599 (37.7149906732676, -122.454633961696)
4103 216046 2 12 38 Lobos St 1 2 1 1   10/05/2017 03:02:00 PM 3     5996487.74032 2088710.41168 37.7149998715299 -122.454055262356 (37.7149998715299, -122.454055262356)
4117 216048 2 12 40 Lobos St 1 2 1 1   10/05/2017 02:58:00 PM 3     5996463.1782599995 2088711.43982 37.7150012861457 -122.45414023299999 (37.7150012861457, -122.454140233)
4154 142830 1 12 1651 POLK ST 1 1 1 1   07/24/1980 12:00:00 AM 2 Width 0ft Permit Number 18599 6006599.2401 2116591.8637 37.7921305340759 -122.42108410275499 (37.7921305340759, -122.421084102755)
4161 142831 1 12 1639 POLK ST 1 1 1 1   02/14/2005 12:00:00 AM 2 Width 0ft Permit Number 47874 6006604.1049 2116553.8302 37.792026377789504 -122.421064568723 (37.7920263777895, -122.421064568723)
4164 57912 1 12 1653 Polk St 1 1 1 1 1 05/07/1994 12:00:00 AM 6   Permit Number 16870 6006600.1246 2116572.8469 37.7920783685385 -122.42107969148998 (37.7920783685385, -122.42107969149)
4185 175269 2 12 72 Morse St 1 1 1 1   10/10/2017 11:02:00 AM 3 Width 4ft   6001060.69663 2088020.77374 37.7133674320474 -122.438199842368 (37.7133674320474, -122.438199842368)
4289 175270 2 12 72 Morse St 2 1 1 1   10/10/2017 11:06:00 AM 3 Width 4ft   6001043.39915 2088014.71934 37.7133498242071 -122.438259194899 (37.7133498242071, -122.438259194899)
4337 180894 2 12 887 Geneva Ave 1 1 1 1   10/11/2017 10:58:00 AM 3 Width 1ft   6000229.00431 2089321.38405 37.716891277996 -122.441167710317 (37.716891277996, -122.441167710317)
4464 222031 2 12 301 Webster St 1 1 1 1     4 Width 3ft   6004133.844959999 2109890.1232 37.7735899384632 -122.429136343468 (37.7735899384632, -122.429136343468)
4682 213163 2 12 142 Granada Ave 1 1 1 1   05/09/2017 12:00:00 AM 3 3x3 Permit Number 780043 5995654.76041 2090862.8911099997 37.7208622740576 -122.45708998411101 (37.7208622740576, -122.457089984111)
4776 97245 3 12 301X Excelsior Ave 1 1 1 4 2 10/25/2017 04:18:00 PM 3 4x4 Permit Number 767495 6003351.72812 2092154.8424200001 37.724848709697106 -122.43057604836099 (37.7248487096971, -122.430576048361)
4799 97246 3 12 301X Excelsior Ave 2 1 1 4 2 10/25/2017 04:11:00 PM 3 4x4 Permit Number 767495 6003334.6314 2092165.82905 37.724877907973706 -122.430635933307 (37.7248779079737, -122.430635933307)
4905 44497 1 12 1531 Silliman St 1 1 1 1 1 03/26/2001 12:00:00 AM 10   Permit Number 43799 6006322.0 2092922.0 37.727122979083205 -122.420362574607 (37.7271229790832, -122.420362574607)
5124 56265 1 12 15 Liberty St 1 1 1 1 1 07/22/2006 12:00:00 AM     Permit Number 12391 6006208.27079513 2104027.08283356 37.7576086269531 -122.42154409690501 (37.7576086269531, -122.421544096905)
5245 205593 2 12 30 Vasquez Ave 2 2 1 1     7 Width 3ft   5995699.652000001 2100090.8564 37.746202601761105 -122.45760214624201 (37.7462026017611, -122.457602146242)
5377 96642 1 12 2111 Steiner St 1 1 1 1   07/17/2013 12:00:00 AM 10   Permit Number 767176 6002359.83736 2115647.31598 37.7892971538 -122.435684867558 (37.7892971538, -122.435684867558)
5605 34138 1 12   2 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37987          
5673 46713 1 12   5 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
5690 34100 1 12   1 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37975          
5786 108707 1 12 1849 Chestnut St 1 1 1 1 1 01/02/2015 12:00:00 AM 3 3x3 Permit Number 773000 6003000.77487 2119918.27171 37.801060480419395 -122.433772685874 (37.8010604804194, -122.433772685874)
5885 46715 1 12   4 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
6242 35188 1 12   16 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
6282 46717 1 12   2 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
6309 63514 1 12 1937 Golden Gate Ave 1 1 1 1 1 12/11/2012 12:00:00 AM 10 3x3 Permit Number 769639 6000284.9286 2111624.1423 37.778132482558 -122.44257480934799 (37.778132482558, -122.442574809348)
7013 18868 3 12 2245 Sacramento St 2 1 1 2   12/27/2014 12:05:00 PM 3 3X4   6004021.14791 2115967.48717 37.7902704855414 -122.42995977804199 (37.7902704855414, -122.429959778042)
7021 46542 1 12 1359 Sacramento St 1 1 1 1   05/20/2015 12:00:00 AM 3 3x3 Permit Number 52262 6008297.30174 2116578.9750900003 37.7921907215636 -122.41520785497299 (37.7921907215636, -122.415207854973)
7139 74724 1 12 1055 Pine St 3 1 1 1   11/17/2014 12:00:00 AM 3   Permit Number 774207 6008888.65221 2115945.87795 37.7904856069694 -122.41311697887899 (37.7904856069694, -122.413116978879)
7158 30976 1 12 1950 Jackson St 1 1 1 1 1 03/13/1995 12:00:00 AM 24 6x12 Permit Number 34765 6004885.74764 2117123.17132 37.7934926287434 -122.427050672647 (37.7934926287434, -122.427050672647)
7169 34120 1 12   1 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37980          
7174 5920 1 12 1300X Eddy St 2 1 1 1   06/17/1997 12:00:00 AM 3 4X4   6004118.5014 2112905.1017 37.781867456720704 -122.42940446540001 (37.7818674567207, -122.4294044654)
7188 34462 1 12 1521 Ralston Ave 1 1 1 1   07/15/1997 12:00:00 AM     Permit Number 38201          
7206 46718 1 12   1 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
7464 35185 1 12   19 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
7558 30975 1 12 1950 Jackson St 2 1 1 1 1 03/13/1995 12:00:00 AM 24 6x9 Permit Number 34765 6004860.3383 2117120.17233 37.7934829574257 -122.42713837725799 (37.7934829574257, -122.427138377258)
7568 107400 1 12 3176 Clay St 1 1 1 1   09/02/2014 12:00:00 AM 3   Permit Number 773290 5999574.99056 2115728.9104299997 37.7893626172302 -122.44532594346 (37.7893626172302, -122.44532594346)
7694 36863 1 12   8 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
7712 35193 1 12   11 1 1 1   02/10/1998 12:00:00 AM     Permit Number 38712          
7819 74571 2 12 1055 Pine St 4 1 1 1 1 11/17/2014 12:00:00 AM 3   Permit Number 774207 6008908.989 2115950.0282799997 37.7904981444129 -122.413046908194 (37.7904981444129, -122.413046908194)
7909 115530 4 12 101 Polk St 3 1 1 1   02/08/2016 12:00:00 AM 3 4x4 Permit Number 770842 6007332.44961 2111311.79762 37.7776740647351 -122.418172674243 (37.7776740647351, -122.418172674243)
7970 96643 1 12 2111 Steiner St 2 1 1 1   07/17/2013 12:00:00 AM 10   Permit Number 767176 6002360.87078 2115637.1355 37.7892692595105 -122.435680563404 (37.7892692595105, -122.435680563404)
8041 46716 1 12   3 1 1 1   04/24/2002 12:00:00 AM     Permit Number 44843          
8175 18056 1 12 2872 Pine St 2 1 1 1     3 3x3   6000171.5399 2114786.4403 37.7868088744704 -122.44319424037701 (37.7868088744704, -122.443194240377)
8242 81844 3 12 1421 Pine St 3 1 1 2 6 09/11/2012 12:00:00 AM 3 3x3 Permit Number 50020 6007169.781140001 2115706.72596 37.789732310539705 -122.419047208268 (37.7897323105397, -122.419047208268)
8295 18867 1 12 2245 Sacramento St 1 1 1 1   09/16/2014 12:00:00 AM 3 3X3   6003997.87429 2115967.42809 37.790269005258004 -122.43004029884399 (37.790269005258, -122.430040298844)
8728 121206 6 12 930 Chestnut St 2 1 1 1   11/22/2016 12:00:00 AM 3 3x3 Permit Number 778903 6007356.48577 2120579.5282099997 37.803122321012296 -122.418746939923 (37.8031223210123, -122.418746939923)
8802 50777 1 12   3 1 1 1         Permit Number 47304          
8884 34133 1 12   2 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37986          
8916 44823 1 12 2440 Bush St 1 1 1 1 1 06/08/2016 12:00:00 AM 3   Permit Number 778318 6001806.8581 2114669.8819999998 37.7865819462822 -122.43752808228201 (37.7865819462822, -122.437528082282)
9299 29089 1 12 2280 Bryant St 2 1 1 1   02/08/2006 12:00:00 AM 3 3x3   6009652.0 2104061.0 37.7578953310723 -122.40963662473301 (37.7578953310723, -122.409636624733)
9307 18043 1 12 2817 Pine St 1 1 1 1   05/25/2011 12:00:00 AM 6 3x3   6000257.4375 2114746.9392 37.7867053122561 -122.442894218022 (37.7867053122561, -122.442894218022)
9308 102869 1 12 2290X Bryant St 1 1 1 1   04/01/2016 12:00:00 AM 10 3x3   6009662.0 2103968.0 37.7576405343874 -122.40959547655301 (37.7576405343874, -122.409595476553)
9418 34114 1 12   1 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37978          
9430 47039 1 12 771 Walter St 1 1 1 1   05/02/2002 12:00:00 AM     Permit Number 45031          
9498 36866 1 12   12 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
9542 34136 1 12   1 1 1 1   07/05/1997 12:00:00 AM     Permit Number 37986          
9578 24736 1 12 7630 Geary Blvd To Point Lobos Ave 1 1 1 1   04/15/2015 12:00:00 AM 1 3x3 Permit Number 774506 5983286.15671 2112505.7286099996 37.7795694254676 -122.501443995349 (37.7795694254676, -122.501443995349)
9591 36856 1 12   2 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
9614 36864 1 12   9 1 1 1   05/26/1998 12:00:00 AM     Permit Number 39538          
9693 50208 1 12 763 27th Ave 1 1 1 1 1 08/21/2003 12:00:00 AM 8 3x3 Permit Number 46916 5987522.0 2110774.0 37.7750624459683 -122.48666339258301 (37.7750624459683, -122.486663392583)
9723 173650 4 12 80 Entrada Ct 2 9 1 1   12/21/2016 12:00:00 AM 3 4x10   5992424.456569999 2092194.59394 37.7243327619491 -122.46835290122299 (37.7243327619491, -122.468352901223)
9815 40304 1 12 276 San Carlos St 1 1 1 1 1 07/02/2003 12:00:00 AM 10   Permit Number 46688 6006675.32022229 2104512.13520977 37.7589667921547 -122.419963267076 (37.7589667921547, -122.419963267076)
9835 121650 2 12 90 Fernwood Dr 5 1 1 1   01/03/2017 12:00:00 AM 3 2x2 Permit Number 779248 5994730.0 2095273.0 37.7329182144954 -122.46060599283999 (37.7329182144954, -122.46060599284)
9934 102961 3 12 1299X Junipero Serra Blvd 4 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9935 102960 3 12 1299X Junipero Serra Blvd 3 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9936 102965 3 12 1299X Junipero Serra Blvd 9 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9937 102966 3 12 1299X Junipero Serra Blvd 10 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9939 102963 3 12 1299X Junipero Serra Blvd 6 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9940 102969 3 12 1299X Junipero Serra Blvd 12 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9941 102968 3 12 1299X Junipero Serra Blvd 11 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9943 102967 3 12 1299X Junipero Serra Blvd 13 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9944 11821 3 12 1299X Junipero Serra Blvd 2 2 1 2   03/09/2013 12:00:00 AM 2 3   5991432.171815401 2088660.0347764 37.7145703669544 -122.47152561846501 (37.7145703669544, -122.471525618465)
9945 102971 3 12 1299X Junipero Serra Blvd 18 2 1 2   03/09/2013 12:00:00 AM 2     5991413.8 2088806.6 37.714971736494 -122.471599792301 (37.714971736494, -122.471599792301)
9947 11824 1 12 1299X Junipero Serra Blvd 14 2 1 13   03/13/2013 12:00:00 AM 2 3   5991432.171815401 2088660.0347764 37.7145703669544 -122.47152561846501 (37.7145703669544, -122.471525618465)
9959 57959 4 12 336 Hanover St 1 1 1 1   01/13/2017 12:00:00 AM 3 3x3 Permit Number 774423 5999490.29697456 2086502.70799744 37.7091097236101 -122.443518692288 (37.7091097236101, -122.443518692288)
10129 173878 2 12 89 Montana St 5 1 1 1       3x3   5995989.0 2089223.0 37.7163787086702 -122.455816142362 (37.7163787086702, -122.455816142362)
10275 32464 1 12 99x Deming St 2 1 1 1 1 10/10/1996 12:00:00 AM     Permit Number 36974 5999085.33670349 2105174.9537063 37.7603561904001 -122.446260575093 (37.7603561904001, -122.446260575093)
10295 86058 3 12 1583 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987441.2276 2104514.7604 37.7578715963284 -122.486483137481 (37.7578715963284, -122.486483137481)
10301 86223 3 12 2490X 25th Ave 1 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988629.212 2098360.9697 37.7410440994961 -122.48192386283199 (37.7410440994961, -122.481923862832)
10327 86040 3 12 1307 28th Ave 1 1 1 2   01/12/2007 12:00:00 AM 3 3x3   5987380.4546 2106353.8076 37.762917573839104 -122.48682835991 (37.7629175738391, -122.48682835991)
10373 27050 1 12 1000 Silver Ave 1 1 1 1   03/21/2005 12:00:00 AM 3 3X3   6007605.2431 2093552.0049599998 37.72892506581471 -122.415971000784 (37.7289250658147, -122.415971000784)
10399 86345 3 12 2375 25th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988557.6358 2099173.0128 37.743269593853704 -122.482230823598 (37.7432695938537, -122.482230823598)
10405 86230 3 12 2434 25th Ave 1 1 1 2   12/15/2006 12:00:00 AM 3 3x3   5988618.0441 2098730.8647 37.742059084770105 -122.481989567109 (37.7420590847701, -122.481989567109)
10420 86166 3 12 1371 24th Ave 1 1 1 2   01/19/2007 12:00:00 AM 3 3x3   5988635.288 2105993.2776 37.7620007347072 -122.48246195923299 (37.7620007347072, -122.482461959233)
10423 86471 3 12 1814 27th Ave 1 1 1 2   12/28/2006 12:00:00 AM 8 3x3   5987856.6219 2102916.0794 37.7535062555598 -122.48492926433501 (37.7535062555598, -122.484929264335)
10428 86141 3 12 1454 24th Ave 1 1 1 2   01/22/2007 12:00:00 AM 3 3x3   5988697.0081 2105426.1429 37.7604471269304 -122.482206944127 (37.7604471269304, -122.482206944127)
10443 109691 1 12 926 Russia Ave 1 1 1 1 1 02/27/2015 12:00:00 AM 3 3x3 Permit Number 774277 6003588.14539 2089614.80455 37.7178877169308 -122.42957771366699 (37.7178877169308, -122.429577713667)
10456 86365 3 12 2527 25th Ave 1 1 1 2   12/18/2006 12:00:00 AM 3 3x3   5988592.98 2098098.1742 37.7403204245752 -122.482029891514 (37.7403204245752, -122.482029891514)
10478 86216 3 12 2619 24th Ave 1 1 1 2   06/18/2015 03:11:00 PM 3 3x3   5988925.4466 2097480.2521 37.7386431021416 -122.48083513933202 (37.7386431021416, -122.480835139332)
Powered by Datasette · Query took 4.003ms · Data source: data.sfgov.org