sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
10134 173877 2 47 2651 San Jose Ave 1 18 1 1       3x3   5997397.0 2088796.0 37.7152869722449 -122.450918658158 (37.7152869722449, -122.450918658158)
10255 112606 2 47 100X Monument Way 1 13 1 1       10x10   5999003.0 2105766.0 37.761974353511896 -122.446587863076 (37.7619743535119, -122.446587863076)
10256 173933 6 47 190 Beacon St 1 7 1 1           6003193.0 2097540.0 37.739626138558705 -122.43150902083299 (37.7396261385587, -122.431509020833)
10549 2290 3 47 800X Brotherhood Way 5 11 1 2   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5989540.89128 2088682.16282 37.714521528411495 -122.478064194121 (37.7145215284115, -122.478064194121)
10571 19570 3 47 100 STAIRWAY1 4 1 1 2     48 100ST            
10618 2271 3 47 700X Brotherhood Way 5 11 1 2     25 14M   5990752.82343 2088228.49759 37.71334614597279 -122.47384223413499 (37.7133461459728, -122.473842234135)
10674 19936 3 47 100 STAIRWAY38 5 1 1 2     12 10ST            
10701 20452 3 47 495X Sunset Blvd 17 1 1 2     36 60            
10705 19569 3 47 100 STAIRWAY1 3 1 1 2     48 100ST            
10816 19910 3 47 100 STAIRWAY35 6 1 1 2     12 120ST            
10904 19431 3 47 1200X Sloat Blvd 4 11 1 2   11/13/2007 12:00:00 AM 6 20   5987714.9376 2095926.0092 37.7343051218756 -122.48490645815501 (37.7343051218756, -122.484906458155)
10938 2269 3 47 700X Brotherhood Way 3 11 1 2     6 14M   5990714.96133 2088247.7727 37.7133968776506 -122.473974502829 (37.7133968776506, -122.473974502829)
10949 19933 3 47 100 STAIRWAY38 2 1 1 2     12 10ST            
11028 2270 3 47 700X Brotherhood Way 4 11 1 2     6 14M   5990735.60667 2088236.9442599998 37.7133683412468 -122.473902356505 (37.7133683412468, -122.473902356505)
11220 19950 3 47 100 STAIRWAY39 7 1 1 2     12 25ST            
11591 20428 3 47 485X Sunset Blvd 1 1 1 2     42 40            
11826 20419 3 47 453X Sunset Blvd 8 1 1 2     12 60            
11963 2289 3 47 800X Brotherhood Way 4 11 1 2   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5989454.26944 2088678.0808599999 37.7145052920719 -122.478363292437 (37.7145052920719, -122.478363292437)
12151 19869 3 47 100 STAIRWAY33 1 1 1 2     24 25ST            
12203 2287 3 47 800X Brotherhood Way 2 11 1 2   08/30/2016 12:00:00 AM 3 14M Permit Number 777532 5989126.18342 2088688.6181299998 37.7145151729252 -122.47949804711 (37.7145151729252, -122.47949804711)
12480 20434 3 47 485X Sunset Blvd 7 1 1 2     12 30            
12637 19441 3 47 1300X Sloat Blvd 4 11 1 2     3 20   5986928.6035 2095895.7656 37.7341762495639 -122.487622811763 (37.7341762495639, -122.487622811763)
12812 19953 3 47 100 STAIRWAY39 10 1 1 2     12 25ST            
13158 19753 3 47 100 STAIRWAY15 11 1 1 2     12 10ST            
13184 20013 3 47 100 STAIRWAY47 1 1 1 2     6 100ST            
13268 187627 5 47 88 States St 1 13 1 1           6001213.0 2106258.0 37.7634512529938 -122.438979613423 (37.7634512529938, -122.438979613423)
13271 187638 6 47 875 El Camino Del Mar 2 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
13273 20881 3 47 1892X Sunset Blvd 31 1 1 2   02/21/2017 10:23:00 AM 3 60   5984852.8466778 2102317.5089788004 37.7516873322231 -122.49527267334 (37.7516873322231, -122.49527267334)
13275 187637 6 47 875 El Camino Del Mar 1 17 1 1       10x10   5985641.0 2114972.0 37.786479112006 -122.493479464676 (37.786479112006, -122.493479464676)
13276 20799 3 47 1792X Sunset Blvd 3 1 1 2   02/21/2017 10:19:00 AM 3     5984829.6375693 2102999.3844439 37.7535582155387 -122.49540321629601 (37.7535582155387, -122.495403216296)
13278 20803 3 47 1792X Sunset Blvd 7 1 1 2   02/21/2017 10:15:00 AM 3 60   5984829.6375693 2102999.3844439 37.7535582155387 -122.49540321629601 (37.7535582155387, -122.495403216296)
13307 187654 6 47 375 Woodside Ave 1 2 1 1       3x3   5997267.0 2099886.0 37.7457300260474 -122.452167701039 (37.7457300260474, -122.452167701039)
13314 187669 2 47 554 Valley St 1 3 1 1           6002324.0 2099197.0 37.7441265828549 -122.434632098307 (37.7441265828549, -122.434632098307)
14158 20429 3 47 485X Sunset Blvd 2 1 1 2     42 30            
14206 19813 3 47 100 STAIRWAY24 4 1 1 2     12 100ST            
14400 19934 3 47 100 STAIRWAY38 3 1 1 2     12 10ST            
14425 19694 3 47 100 STAIRWAY7 1 1 1 2     24 12ST            
14506 20366 3 47 262X Sunset Blvd 16 1 1 2     48 60            
14521 20280 3 47 20X Sunset Blvd 1 1 1 2     18 60            
14597 20303 3 47 50X Sunset Blvd 5 1 1 2     12 60            
14923 20430 3 47 485X Sunset Blvd 3 1 1 2     42 30            
14992 19932 3 47 100 STAIRWAY38 1 1 1 2     12 10ST            
15767 19699 3 47 100 STAIRWAY11 1 1 1 2     24 40ST            
15771 19908 3 47 100 STAIRWAY35 4 1 1 2     6 120ST            
15978 19943 3 47 100 STAIRWAY38 12 1 1 2     12 10ST            
16086 20423 3 47 453X Sunset Blvd 12 1 1 2     42 60            
16424 19949 3 47 100 STAIRWAY39 6 1 1 2     24 25ST            
16454 20294 3 47 20X Sunset Blvd 15 1 1 2     24 60            
16608 19951 3 47 100 STAIRWAY39 8 1 1 2     12 25ST            
16721 19947 3 47 100 STAIRWAY39 4 1 1 2     18 25ST            
16807 106757 2 47 999 Key Ave 1 2 1 1   06/02/2014 12:00:00 AM 36     6013321.202330001 2089752.82506 37.718812992515105 -122.395944254446 (37.7188129925151, -122.395944254446)
16878 19909 3 47 100 STAIRWAY35 5 1 1 2     12 120ST            
17092 19978 3 47 100 STAIRWAY45 5 1 1 2     36 30ST            
17118 11746 3 47 700X Junipero Serra Blvd 29 11 1 2   03/03/2006 12:00:00 AM 3 6X6   5991277.67104 2092671.80389 37.7255767576586 -122.472351910013 (37.7255767576586, -122.472351910013)
17384 16354 3 47 1500X Monterey Blvd 4 11 1 2     18 4-HOA   5993443.33225 2095241.5642099997 37.7327577911269 -122.465052016742 (37.7327577911269, -122.465052016742)
17468 11748 3 47 700X Junipero Serra Blvd 31 11 1 2   03/09/2013 12:00:00 AM 3 6X6   5991276.77165 2092652.88165 37.7255247498407 -122.472353640304 (37.7255247498407, -122.472353640304)
17510 23594 3 47 220X Vasquez Ave 5 11 1 2     12 8   5994483.09622 2099061.58793 37.7433065302734 -122.461734198275 (37.7433065302734, -122.461734198275)
17727 11703 3 47 700X Junipero Serra Blvd 20 11 1 2   03/30/2006 12:00:00 AM 3 6X6   5991288.65534 2092789.2072 37.725899753665104 -122.47232249319299 (37.7258997536651, -122.472322493193)
17929 11710 3 47 700X Junipero Serra Blvd 27 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991285.51963 2092735.44075 37.7257519428913 -122.47232941528699 (37.7257519428913, -122.472329415287)
18087 21247 3 47 2401X Sunset Blvd 11 1 1 2     48 60   5985051.1945321 2098862.1753589 37.7422115377949 -122.49433209823401 (37.7422115377949, -122.494332098234)
18578 29625 3 47 900X Junipero Serra Blvd 34 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991156.8644 2090780.0583900001 37.7203755006984 -122.472631660317 (37.7203755006984, -122.472631660317)
18718 21167 3 47 2301 Sunset Blvd 8 1 1 2     6 60   5985027.9083074005 2099542.6271361 37.744078511576 -122.49446276258301 (37.744078511576, -122.494462762583)
18889 106642 2 47 4540X 17TH ST 1 9 1 1     24     5999139.0 2105833.0 37.762166086231204 -122.446122313424 (37.7621660862312, -122.446122313424)
19244 20545 3 47 1303X Sunset Blvd 23 1 1 2     3 6O   5984802.8376111 2106327.3646052 37.7626943540195 -122.49574136031299 (37.7626943540195, -122.495741360313)
19606 21428 3 47 2692X Sunset Blvd 25 1 1 2     48 60   5985040.0664617 2096882.0619327 37.7367740271268 -122.494224659054 (37.7367740271268, -122.494224659054)
19643 21239 3 47 2401X Sunset Blvd 3 1 1 2     36 60   5985051.1945321 2098862.1753589 37.7422115377949 -122.49433209823401 (37.7422115377949, -122.494332098234)
19685 92559 1 47 222 Stanyan St 1 1 1 1       3x3 Permit Number 52905 5996693.0 2111182.0 37.776713072168704 -122.454968563419 (37.7767130721687, -122.454968563419)
19930 29624 3 47 900X Junipero Serra Blvd 33 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991155.39463 2090794.87778 37.720416106010795 -122.472637820699 (37.7204161060108, -122.472637820699)
20248 29611 3 47 900X Junipero Serra Blvd 21 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991160.04623 2090951.2024400001 37.72084560421371 -122.47263313341499 (37.7208456042137, -122.472633133415)
20319 11702 3 47 700X Junipero Serra Blvd 19 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991290.07475 2092800.9455099998 37.7259320662922 -122.47231844175501 (37.7259320662922, -122.472318441755)
20392 106278 3 47 200X VIDAL DR 2 11 1 2     60     5987624.0 2090693.0 37.719931328083206 -122.48483708629801 (37.7199313280832, -122.484837086298)
20621 21114 3 47 2201X Sunset Blvd 18 1 1 2     36 60   5985004.6737667 2100227.1692458 37.745956718592794 -122.494593556276 (37.7459567185928, -122.494593556276)
20640 29609 3 47 900X Junipero Serra Blvd 18 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991172.14351 2091025.81173 37.7210511631493 -122.472596754032 (37.7210511631493, -122.472596754032)
20801 29578 3 47 400X Junipero Serra Blvd 8 11 1 2   04/01/2007 12:00:00 AM 3 3X3   5991374.0324099995 2094196.50916 37.729768794481004 -122.472129887178 (37.729768794481, -122.472129887178)
21086 23592 3 47 200X Vasquez Ave 1 11 1 2     6 8   5994656.2966599995 2099224.9929400003 37.7437651683354 -122.461147162215 (37.7437651683354, -122.461147162215)
21464 23593 3 47 220X Vasquez Ave 4 11 1 2     6 8   5994492.71955 2099073.95458 37.743341039961706 -122.461701819996 (37.7433410399617, -122.461701819996)
21779 29598 3 47 900X Junipero Serra Blvd 7 11 1 2   12/31/2014 08:52:00 AM 3     5991178.77498 2091110.6465200002 37.7212844823864 -122.472580013151 (37.7212844823864, -122.472580013151)
21913 29618 3 47 900X Junipero Serra Blvd 27 11 1 2   03/09/2013 12:00:00 AM 3 3X3   5991164.47662 2090887.5563700001 37.720671104264 -122.47261318107799 (37.720671104264, -122.472613181078)
22142 8214 3 47 2189X Funston Ave 5 11 1 2     6 8X25   5992287.42413 2100535.51604 37.747226921486295 -122.469433461595 (37.7472269214863, -122.469433461595)
22262 29593 3 47 900X Junipero Serra Blvd 2 11 1 2   03/30/2006 12:00:00 AM 3 3X3   5991180.05944 2091153.1258900003 37.7214011945921 -122.47257866867201 (37.7214011945921, -122.472578668672)
22920 251148 2 47 625 Brotherhood Way 1 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22923 251152 2 47 625 Brotherhood Way 5 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22924 251154 2 47 625 Brotherhood Way 7 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22925 251150 2 47 625 Brotherhood Way 3 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22926 251147 2 47 113x Gladeview Way 1 13 1 1       3x3   5997915.0 2102038.0 37.7516759885035 -122.450082102397 (37.7516759885035, -122.450082102397)
22927 251157 2 47 625 Brotherhood Way 10 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22928 251155 2 47 625 Brotherhood Way 8 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22929 251156 2 47 625 Brotherhood Way 9 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22930 251151 2 47 625 Brotherhood Way 4 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22931 251158 2 47 625 Brotherhood Way 11 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22932 251153 2 47 625 Brotherhood Way 6 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22933 251149 2 47 625 Brotherhood Way 2 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
22934 251159 2 47 625 Brotherhood Way 12 1 1 1       3x3   5991521.0 2087959.0 37.7126506341802 -122.471167551627 (37.7126506341802, -122.471167551627)
23006 5050 3 47 5399X Diamond Heights Blvd 11 1 1 2     19     6001979.62541 2098516.88417 37.7422395880754 -122.43577421703002 (37.7422395880754, -122.43577421703)
23021 5047 3 47 5399X Diamond Heights Blvd 8 1 1 2     30     6002007.86459 2098449.21717 37.7420553943514 -122.43567173476002 (37.7420553943514, -122.43567173476)
23079 8464 3 47 1900 Geary Blvd 1 11 1 2     17 8   6002427.515 2113723.6274 37.784019039174794 -122.435313053048 (37.7840190391748, -122.435313053048)
23106 5048 3 47 5399X Diamond Heights Blvd 9 1 1 2     26     6002000.04243 2098472.35983 37.7421184943815 -122.435700436623 (37.7421184943815, -122.435700436623)
23130 5046 3 47 5399X Diamond Heights Blvd 7 1 1 2     30     6002013.964380001 2098440.0292 37.7420305128012 -122.43564998647 (37.7420305128012, -122.43564998647)
23272 5052 3 47 5399X Diamond Heights Blvd 13 1 1 2     27     6001966.9976699995 2098545.79058 37.742318241009606 -122.43581994754999 (37.7423182410096, -122.43581994755)
23275 5049 3 47 5399X Diamond Heights Blvd 10 1 1 2     39     6001985.29603 2098499.31047 37.7421916569134 -122.43575335275101 (37.7421916569134, -122.435753352751)
23290 5051 3 47 5399X Diamond Heights Blvd 12 1 1 2     16     6001971.36584 2098533.18854 37.7422838868872 -122.43580394232 (37.7422838868872, -122.43580394232)
Powered by Datasette · Query took 6.381ms · Data source: data.sfgov.org