sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
3733 175357 2 12 1 Brotherhood Way 2 7 1 1     3 Width 5ft   5992890.63105 2087809.5806900002 37.7123194916216 -122.466422861444 (37.7123194916216, -122.466422861444)
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)
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)
3756 252875 2 5 2400 Post St 2 7 1 1       3x3   6000387.0 2114050.0 37.784799083264396 -122.44239591065 (37.7847990832644, -122.44239591065)
3759 253555 1 71 27 Ceres St 1 7 1 1 1         6013919.66127 2093997.4229599999 37.730501082737604 -122.394172607985 (37.7305010827376, -122.394172607985)
3804 253558 2 143 1240 Wisconsin St 1 7 1 1           6012830.0 2101639.0 37.7514226163546 -122.39847574638901 (37.7514226163546, -122.398475746389)
3851 252871 2 5 2557 Sutter St   7 1 1       3x3   5999847.0 2113975.0 37.7845623594454 -122.444258736096 (37.7845623594454, -122.444258736096)
4105 253605 2 5 301 Teresita Blvd 1 7 1 1       3x3   5997753.0 2098469.0 37.741867117319 -122.45038506263799 (37.741867117319, -122.450385062638)
4383 253609 2 224 318 Utah St 2 7 1 1       Width 4ft Permit Number 780845 6010580.39617 2106780.39752 37.7654141639451 -122.40661745795299 (37.7654141639451, -122.406617457953)
4553 253637 6 3 701 Noe St 2 7 1 1       Width 3ft   6003144.80454 2104133.37104 37.757727257313704 -122.43214639144101 (37.7577272573137, -122.432146391441)
4693 253655 2 36 1048 Ingalls St 1 7 1 1       3x3   6018024.0 2094000.0 37.7307354351655 -122.379983340658 (37.7307354351655, -122.379983340658)
4771 253556 1 17 27 Ceres St 2 7 1 1 1 10/25/2017 12:00:00 AM 3   Permit Number 780682 6013919.66127 2093997.4229599999 37.730501082737604 -122.394172607985 (37.7305010827376, -122.394172607985)
4881 253712 2 128 339 Vienna St 1 7 1 1       Width 3ft   6003970.0 2091429.0 37.7228907132276 -122.428387044746 (37.7228907132276, -122.428387044746)
4923 253718 6 47 227 Madison St 1 7 1 1       3x3   6005690.0 2092595.0 37.726189474375204 -122.422524168298 (37.7261894743752, -122.422524168298)
5055 253765 6 42 1366 Guerrero St 2 7 1 1       3X3   6005800.0848900005 2101007.6677599996 37.7492949871928 -122.422741198761 (37.7492949871928, -122.422741198761)
5089 253778 3 47 90 Cuesta Ct 2 7 1 2           5999757.0 2101744.0 37.750973968576496 -122.443691128062 (37.7509739685765, -122.443691128062)
5095 253779 3 47 90 Cuesta Ct 3 7 1 2           5999757.0 2101744.0 37.750973968576496 -122.443691128062 (37.7509739685765, -122.443691128062)
5100 253781 3 47 90 Cuesta Ct 5 7 1 2           5999757.0 2101744.0 37.750973968576496 -122.443691128062 (37.7509739685765, -122.443691128062)
5105 253777 3 47 90 Cuesta Ct 1 7 1 2           5999757.0 2101744.0 37.750973968576496 -122.443691128062 (37.7509739685765, -122.443691128062)
5107 253780 3 47 90 Cuesta Ct 4 7 1 2           5999757.0 2101744.0 37.750973968576496 -122.443691128062 (37.7509739685765, -122.443691128062)
5478 121205 6 234 930 Chestnut St 1 7 1 1     20 3x3   6007386.5238 2120591.4348299997 37.8031567047665 -122.418643837145 (37.8031567047665, -122.418643837145)
5598 103666 2 17 350X Hickory St 5 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7171 9447 1 22 800X Golden Gate Ave 3 7 1 3     12 3X3   6005622.1957 2112431.3933 37.780651788182794 -122.424168675479 (37.7806517881828, -122.424168675479)
7570 9448 1 22 800X Golden Gate Ave 4 7 1 3   05/18/1992 12:00:00 AM 12 3X3   6005590.2441 2112426.5193 37.78063660125729 -122.424278864743 (37.7806366012573, -122.424278864743)
7676 9450 1 150 800X Golden Gate Ave 6 7 1 3     12 3X3   6005543.6705 2112420.5622 37.780617614602896 -122.424439561439 (37.7806176146029, -122.424439561439)
7681 103657 6 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7740 9445 1 22 800X Golden Gate Ave 1 7 1 3   03/01/1994 12:00:00 AM 12 3X3   6005680.1419 2112439.5166 37.780677364386705 -122.423968789396 (37.7806773643867, -122.423968789396)
7743 121449 6 2 1274 Filbert St 1 7 1 1     12 10x6   6006927.94593 2119481.89109 37.800084349978 -122.420151970562 (37.800084349978, -122.420151970562)
7764 103662 2 17 350X Hickory St 1 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
7809 119599 6 34 4357x Mission St 1 7 1 1         Permit Number 774415          
7810 119607 6 3 299x Avalon Ave 3 7 1 1                    
7834 119605 6 47 299x Avalon Ave 1 7 1 1                    
8003 109210 6 32 2637 Larkin St 1 7 1 1   02/18/2015 12:00:00 AM 3 3x3 Permit Number 774817 6006569.78732 2120282.61277 37.802262741793704 -122.421448236261 (37.8022627417937, -122.421448236261)
8128 87100 1 3 700 Connecticut St 1 7 1 3       3x3 Permit Number 50056          
8197 103668 6 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
8408 103664 2 17 350X Hickory St 3 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
8920 9449 1 22 800X Golden Gate Ave 5 7 1 3     12 3X3   6005556.1262 2112420.5622 37.780618317973 -122.424396471178 (37.780618317973, -122.424396471178)
9555 105225 5 19 175 Spruce St 1 7 1 1     9     5997195.09596 2114417.64894 37.785626103218895 -122.453465347546 (37.7856261032189, -122.453465347546)
9641 114157 6 3 1200x JUNIPERO SERRA BLVD 18 7 1 1     32     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9643 114152 6 3 1200X JUNIPERO SERRA BLVD 11 7 1 1     8     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9644 114150 6 3 1200X JUNIPERO SERRA BLVD 9 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9647 114149 6 3 1200X JUNIPERO SERRA BLVD 8 7 1 1     12     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9651 114156 6 3 1200x JUNIPERO SERRA BLVD 17 7 1 1     32     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9655 114155 6 128 1200X JUNIPERO SERRA BLVD 16 7 1 1           5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9656 114151 6 3 1200X JUNIPERO SERRA BLVD 10 7 1 1     8     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9657 114153 6 3 1200x JUNIPERO SERRA BLVD 12 7 1 1     40     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9661 114148 6 3 1200X JUNIPERO SERRA BLVD 7 7 1 1     19     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9677 114154 6 5 1200x JUNIPERO SERRA BLVD 13 7 1 1     20     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
9883 173726 6 3 1101 Connecticut St 1 7 1 1           6013424.0 2101939.0 37.752279425117294 -122.396442635345 (37.7522794251173, -122.396442635345)
9912 173731 6 1 484 Chenery St 1 7 1 1           6003566.0 2096120.0 37.7357482768139 -122.43011807363199 (37.7357482768139, -122.430118073632)
9972 173766 2 39 1100x Bacon St 2 7 1 1       3x3   6008195.0 2092351.0 37.725660503016 -122.413847240833 (37.725660503016, -122.413847240833)
9974 173765 2 39 1100x Bacon St 1 7 1 1       3x3   6008195.0 2092351.0 37.725660503016 -122.413847240833 (37.725660503016, -122.413847240833)
9975 173768 2 39 1100x Bacon St 4 7 1 1       3x3   6008195.0 2092351.0 37.725660503016 -122.413847240833 (37.725660503016, -122.413847240833)
9976 173769 2 39 1100x Bacon St 5 7 1 1       3x3   6008195.0 2092351.0 37.725660503016 -122.413847240833 (37.725660503016, -122.413847240833)
9978 173767 2 39 1100x Bacon St 3 7 1 1       3x3   6008195.0 2092351.0 37.725660503016 -122.413847240833 (37.725660503016, -122.413847240833)
9996 173615 6 5 1200X JUNIPERO SERRA BLVD 14 7 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10002 114158 6 259 1200X JUNIPERO SERRA BLVD 6 7 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10011 173616 6 26 1200X JUNIPERO SERRA BLVD 15 7 1 1   01/20/2017 12:00:00 AM 3     5991123.0 2089585.0 37.7170922039834 -122.47266163030399 (37.7170922039834, -122.472661630304)
10020 115676 2 3 1200X Junipero Serra Blvd 5 7 1 1   01/20/2017 12:00:00 AM 3     5991123.2 2089585.5 37.717093588438 -122.472660975441 (37.717093588438, -122.472660975441)
10099 173842 2 3 288X Graystone Ter 1 7 1 1           5999483.0 2103863.0 37.7567765924541 -122.444790942005 (37.7567765924541, -122.444790942005)
10174 173886 6 75 2931 20th St 1 7 1 1           6009454.0 2104482.0 37.759040204703496 -122.41035112011801 (37.7590402047035, -122.410351120118)
10190 173887 6 75 2931 20th St 2 7 1 1           6009454.0 2104482.0 37.759040204703496 -122.41035112011801 (37.7590402047035, -122.410351120118)
10256 173933 6 47 190 Beacon St 1 7 1 1           6003193.0 2097540.0 37.739626138558705 -122.43150902083299 (37.7396261385587, -122.431509020833)
10665 103665 2 17 350X Hickory St 4 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
11212 103658 6 17 350X Hickory St 2 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
11415 103667 2 17 350X Hickory St 6 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
11662 102569 6 41 0 Diaz Ave 1 7 1 1   02/04/2013 12:00:00 AM 2   Permit Number 769785 5990053.95839 2089992.8197400002 37.7181500356804 -122.476386530439 (37.7181500356804, -122.476386530439)
12113 103660 6 17 350X Hickory St 4 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
12440 100166 7 218 2340 Twin Peaks Blvd   7 1 1         Permit Number 769026          
12540 108677 1 42 11 Otsego Ave 1 7 1 1 1 12/30/2014 12:00:00 AM 3   Permit Number 773206 6000966.57436 2092971.8241299998 37.7269565451936 -122.438879746024 (37.7269565451936, -122.438879746024)
12885 103661 6 17 350X Hickory St 5 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
13267 187629 6 183 4283 23rd St 1 7 1 1       3x3   6001353.0 2102279.0 37.7525338497288 -122.43821033719401 (37.7525338497288, -122.438210337194)
13296 187658 7 39 600X Clarendon Ave 1 7 1 1       3x3   5995637.0 2102382.0 37.7524899085688 -122.457984564932 (37.7524899085688, -122.457984564932)
15949 103659 6 17 350X Hickory St 3 7 1 10 4 06/07/2013 12:00:00 AM     Permit Number 770306          
16097 104813 6 60 1601X Portola Dr 5 7 1 1                    
16457 93053 1 105     7 1 1   04/28/2010 12:00:00 AM 36   Permit Number 53387          
17030 110785 1 17 2 Edna St 2 7 1 1   05/06/2015 12:00:00 AM 3     5998788.4 2092979.9 37.7268545527586 -122.446410203741 (37.7268545527586, -122.446410203741)
17858 121173 6 17 950 Duncan St 2 7 1 1       3x3   6000333.0 2099683.0 37.7453477932295 -122.44155138616101 (37.7453477932295, -122.441551386161)
17977 116827 2 15 111 BAY ST 14 7 1 13           6010193.0 2121519.0 37.805861173705296 -122.408997391272 (37.8058611737053, -122.408997391272)
18019 111271 3 71 700X BOSWORTH ST 9 7 1 2     42     6002150.0 2095428.0 37.73376790368221 -122.434964255854 (37.7337679036822, -122.434964255854)
18620 121737 3 52 1301 Vermont St 12 7 1 2       3x3   6011430.0 2102074.0 37.75253893927721 -122.403347738299 (37.7525389392772, -122.403347738299)
18684 109456 1 17 951 GILMAN AVE 1 7 1 3   03/24/2015 12:00:00 AM 3   Permit Number 774986 6015934.0 2089205.0 37.717453787650705 -122.38687458595501 (37.7174537876507, -122.386874585955)
18708 121749 3 52 1201x Vermont St 12 7 1 2       3x3   6011405.0 2102539.0 37.753814330877205 -122.403466904543 (37.7538143308772, -122.403466904543)
18793 114373 7 62 805 GONZALEZ DR 1 7 1 1     18     5988302.0 2089566.0 37.7168763353695 -122.482410970247 (37.7168763353695, -122.482410970247)
18877 82435 6 3 51 Peralta Ave 1 7 1 1   04/02/2005 12:00:00 AM 20     6010636.52703341 2100363.58782589 37.7477981742678 -122.405971235802 (37.7477981742678, -122.405971235802)
18891 107407 2 58 171 TWIN PEAKS BLVD 1 7 1 1     12     5998631.4 2104681.4 37.7589750798494 -122.44779499190099 (37.7589750798494, -122.447794991901)
19018 102131 6 17 850 Treat Ave 1 7 1 1   12/24/2012 12:00:00 AM     Permit Number 769452 6008548.2 2103592.2 37.7565461982029 -122.41342088796499 (37.7565461982029, -122.413420887965)
19350 95161 6 175 2721 Pacific Ave   7 1 1         Permit Number 54078 6001026.7 2116843.3 37.7925052022591 -122.440383162252 (37.7925052022591, -122.440383162252)
19405 103965 6 17 141 Marview Way 1 7 1 1   07/11/2013 12:00:00 AM     Permit Number 770303 5998318.6 2103174.0 37.7548182509721 -122.448768222318 (37.7548182509721, -122.448768222318)
19583 119914 3 3 400X Brotherhood Way 1 7 1 2       100x100            
19656 101900 7 3 1100 Ocean Ave 1 7 1 2         Permit Number 769623 5996507.7 2092470.2 37.7253245106519 -122.454257683967 (37.7253245106519, -122.454257683967)
19781 96412 6 175 185 Chilton Ave   7 1 1   05/18/2011 12:00:00 AM     Permit Number 767805 6001587.1 2095138.7 37.732941575251004 -122.436889661497 (37.732941575251, -122.436889661497)
19797 97906 1 175 401 Upper Ter 1 7 1 1   12/01/2011 12:00:00 AM 60   Permit Number 768366 5999222.6 2106240.8 37.7632905770055 -122.44586250428002 (37.7632905770055, -122.44586250428)
20477 104866 6 3 411 Holladay Ave 1 7 1 1           6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202)
20656 107549 6 17 198X Jennings St 2 7 1 2   11/12/2014 12:00:00 AM 3   Permit Number 774049 6018784.70414 2097136.12526 37.739388557233205 -122.377570991407 (37.7393885572332, -122.377570991407)
20865 103256 6 22 4187 26th St 1 7 1 1     16 3x3   6002700.0 2100625.0 37.7480688746475 -122.433434000346 (37.7480688746475, -122.433434000346)
22288 237856 2 16 636 30th St 1 7 1 1     5 Width 6ft   6002455.57988 2098272.49197 37.7415955682714 -122.434111048608 (37.7415955682714, -122.434111048608)
22304 248911 6 129 1633 Oakdale Ave 1 7 1 1           6014844.92913 2095599.8976 37.7349525388235 -122.39108575959101 (37.7349525388235, -122.391085759591)
22308 248932 9 24 46 Cook St 1 7 1 1         Tree has temporary Landmark Status while nonimation is under consideration. - Chris Buck 4/7/16 5997514.0 2113392.0 37.7828282170553 -122.452288002469 (37.7828282170553, -122.452288002469)
Powered by Datasette · Query took 2.658ms · Data source: data.sfgov.org