sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
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)
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)
16097 104813 6 60 1601X Portola Dr 5 7 1 1                    
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)
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)
19583 119914 3 3 400X Brotherhood Way 1 7 1 2       100x100            
20477 104866 6 3 411 Holladay Ave 1 7 1 1           6010309.7 2098610.5 37.7429662928376 -122.406977848202 (37.7429662928376, -122.406977848202)
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)
22822 248039 2 177 21 Rutledge St 1 7 1 1     18     6010496.95071 2099420.9430400003 37.745202070015296 -122.406387476112 (37.7452020700153, -122.406387476112)
22891 247616 2 180 300 Bradford St 7 7 1 1     2     6009490.26965 2096786.7692099998 37.737912836413706 -122.409682528235 (37.7379128364137, -122.409682528235)
23001 251172 6 3 363 Jersey St 2 7 1 1           6002784.74363 2101501.25508 37.750479672211 -122.433203561601 (37.750479672211, -122.433203561601)
23162 251173 6 75 367 Jersey St 2 7 1 1       Width 3ft   6002770.52649 2101500.0126900002 37.7504754543841 -122.43325263672399 (37.7504754543841, -122.433252636724)
23388 191040 2 197 1301 Minnesota St 35 7 1 1     15     6015380.38588 2102504.53618 37.75394094514021 -122.389716581452 (37.7539409451402, -122.389716581452)
23442 187500 2 141 100 Walbridge St 6 7 1 1     2     6005130.65162 2086494.3835099998 37.709406927448796 -122.424024164397 (37.7094069274488, -122.424024164397)
23496 222676 2 270 701 Church St 36 7 1 1     8 Width 3ft   6004317.3839 2104765.72552 37.7595299645462 -122.428136192139 (37.7595299645462, -122.428136192139)
23547 125572 2 185 1120 Greenwich St 4 7 1 1     11     6007488.07621 2119895.66738 37.8012520198356 -122.418243052479 (37.8012520198356, -122.418243052479)
23804 223982 2 107 1000 San Jose Ave 25 7 1 1     6     6005159.471609999 2097237.42875 37.738906606148205 -122.424688283133 (37.7389066061482, -122.424688283133)
23865 188421 2 270 602 Arthur Ave 38 7 1 1     7     6015740.2817 2099823.35637 37.7465989366059 -122.388284852668 (37.7465989366059, -122.388284852668)
23907 247195 2 180 900 Waller St 9 7 1 1     20     6001251.021869999 2108666.7471 37.7700672400275 -122.43902074711201 (37.7700672400275, -122.439020747112)
23909 249678 2 60 2400 Baker St 10 7 1 1     24     5999727.06015 2117202.6736 37.7934178626924 -122.444905786498 (37.7934178626924, -122.444905786498)
23961 247944 2 39 21 Joy St 1 7 1 1     23     6010317.99645 2098902.9194900002 37.7437696775404 -122.40696976733999 (37.7437696775404, -122.40696976734)
24072 246633 2 3 3320 Harrison St 4 7 1 1     3     6009029.84734 2099262.75496 37.7446855398981 -122.411449314735 (37.7446855398981, -122.411449314735)
24107 120282 2 237 129 24th Ave 12 7 1 1     10     5988304.19862 2115114.50046 37.787025803891204 -122.484276029631 (37.7870258038912, -122.484276029631)
24196 198273 2 51 101 Pennsylvania Ave 39 7 1 1     1     6014246.68754 2106694.7124400004 37.7653833298046 -122.393930504207 (37.7653833298046, -122.393930504207)
24228 197487 2 138 1301 Minnesota St 28 7 1 1     11     6015378.84744 2102468.94598 37.75384313667529 -122.389719416144 (37.7538431366753, -122.389719416144)
24281 223831 2 136 100 Santa Marina St 6 7 1 1     4     6006175.86532 2097493.16654 37.7396661564679 -122.421192213677 (37.7396661564679, -122.421192213677)
24288 224150 2 340 1001 San Jose Ave 20 7 1 1     24     6005234.007999999 2096984.22045 37.738215562603294 -122.424412565406 (37.7382155626033, -122.424412565406)
24400 220351 2 175 3921 21st St 1 7 1 1     7     6002309.75741 2103525.9195 37.7560119615059 -122.434990881437 (37.7560119615059, -122.434990881437)
24447 201523 2 1 799 Earl St 1 7 1 1     18 Width 10ft   6020371.96237 2093662.3098400002 37.729937451546704 -122.371842613372 (37.7299374515467, -122.371842613372)
24493 190983 2 47 2 Tulare St 20 7 1 1     15     6016115.94828 2100251.3725900003 37.7477949890666 -122.387015672733 (37.7477949890666, -122.387015672733)
24497 227291 2 55 65 Zircon Pl 4 7 1 1     9 Width 4ft   6002354.98671 2098718.92039 37.7428156470274 -122.43449077742399 (37.7428156470274, -122.434490777424)
24654 190986 2 47 2 Tulare St 16 7 1 1     23     6016149.69105 2100259.24355 37.747818469462 -122.38689953970601 (37.747818469462, -122.386899539706)
24719 247088 2 3 2301 Castro St 6 7 1 1     1     6002764.361830001 2098589.4854900003 37.74248347881979 -122.43306602918001 (37.7424834788198, -122.43306602918)
24891 213671 2 18 120 Edgehill Way 7 7 1 1     6 Width 3ft   5994885.5088599995 2098943.91671 37.7430065910919 -122.460334245238 (37.7430065910919, -122.460334245238)
24892 197177 2 180 1900 23rd St 6 7 1 1     13     6012740.291540001 2102830.02856 37.7546879247201 -122.39886955298599 (37.7546879247201, -122.398869552986)
24900 249938 2 38 339 Filbert St 3 7 1 1     8 Width 0ft   6011244.68883 2120032.5219400004 37.8018385261831 -122.405253098256 (37.8018385261831, -122.405253098256)
24963 189144 2 338 602 Arthur Ave 45 7 1 1     11 Width 5ft   6015967.83076 2099823.77263 37.7466126854204 -122.38749803403 (37.7466126854204, -122.38749803403)
25037 249812 2 5 260 Chestnut St 2 7 1 1     14 Width 0ft   6010650.1980099995 2121033.7396299997 37.8045543690542 -122.40738094817699 (37.8045543690542, -122.407380948177)
25070 245815 2 301 1000 San Jose Ave 92 7 1 1     8     6004991.22077 2096914.7584400002 37.7380111224129 -122.42524706251699 (37.7380111224129, -122.425247062517)
25090 223699 2 47 1100 San Jose Ave 2 7 1 1     72     6004901.063490001 2096745.81285 37.737542142145706 -122.425546760699 (37.7375421421457, -122.425546760699)
25099 224199 2 40 1001 San Jose Ave 35 7 1 1     16     6005272.32245 2097108.7115200001 37.738559550591795 -122.42428894459299 (37.7385595505918, -122.424288944593)
25107 191446 2 55 2 Tulare St 2 7 1 1     7     6016252.95003 2100312.60959 37.747970718394704 -122.386546192477 (37.7479707183947, -122.386546192477)
25153 219212 2 277 1501 15th Ave 1 7 1 1     9     5991536.71945 2105150.6616 37.759855492149704 -122.47236570472 (37.7598554921497, -122.47236570472)
25418 191034 2 293 2338 Lane St 1 7 1 1     5 Width 6ft   6013925.13865 2092881.2708700001 37.727436659956005 -122.394075563956 (37.727436659956, -122.394075563956)
25490 225139 2 347 701 Church St 41 7 1 1     13     6004346.6017 2104631.68872 37.759163584356706 -122.428025590809 (37.7591635843567, -122.428025590809)
25522 175043 2 5 199 Shakespeare St 2 7 1 1     6 Width 8ft   5993498.29454 2086678.39145 37.709248559547504 -122.464240538697 (37.7092485595475, -122.464240538697)
25572 191703 2 190 1501 Quint St 2 7 1 1     7 Width 4ft   6013259.66608 2096346.4213299998 37.7369142408999 -122.396618925818 (37.7369142408999, -122.396618925818)
25613 240953 2 213 1101 San Jose Ave 15 7 1 1     12     6004805.95854 2096424.9931 37.7366558692687 -122.42585275411601 (37.7366558692687, -122.425852754116)
25672 247989 2 47 130 Mullen Ave 1 7 1 1     15 Width 10ft   6009899.29934 2099821.3308900003 37.7462679959733 -122.40848229933901 (37.7462679959733, -122.408482299339)
25680 247142 2 164 500 27th St 12 7 1 1     17     6003177.22177 2100100.19766 37.7466549535644 -122.43174632176 (37.7466549535644, -122.43174632176)
25780 178245 2 3 62 Tomaso Ct 8 7 1 1     39 Width 8ft   6009206.68729 2086340.63676 37.7092140561483 -122.409925810128 (37.7092140561483, -122.409925810128)
25786 196352 2 300 1900 19th St 21 7 1 1     1     6011956.0756 2105144.27438 37.76099860510921 -122.401744258403 (37.7609986051092, -122.401744258403)
25843 121699 2 306 1002 Pennsylvania Ave 1 7 1 1     13     6014459.10408 2102474.46412 37.753807243829 -122.392900512462 (37.753807243829, -122.392900512462)
25962 209036 2 103 427 Baden St 2 7 1 1     41     6000750.14831 2095370.65935 37.7335308771479 -122.439799837889 (37.7335308771479, -122.439799837889)
26215 224159 2 340 1001 San Jose Ave 36 7 1 1     14     6005282.42958 2097112.8696299999 37.738571538533 -122.424254294602 (37.738571538533, -122.424254294602)
26417 247936 2 5 1149 Esmeralda Ave 1 7 1 1     11     6010249.43041 2098747.94631 37.7433403177918 -122.40719593154101 (37.7433403177918, -122.407195931541)
26474 250207 2 3 212 Union St 3 7 1 1     15 Width 0ft   6011784.78005 2119790.75424 37.801204871053706 -122.40336710211399 (37.8012048710537, -122.403367102114)
26504 227603 2 30 1201 San Jose Ave 55 7 1 1     2     6004504.07862 2096101.1879099999 37.735749708773795 -122.42687342978998 (37.7357497087738, -122.42687342979)
26585 187549 2 253 130 Alpha St 6 7 1 1     4     6010899.87279 2088102.00857 37.714145178327996 -122.404197749245 (37.714145178328, -122.404197749245)
26650 109414 6 113 4 GUY PL 1 7 1 1     14     6014378.1 2114502.6 37.786829336844605 -122.394022608955 (37.7868293368446, -122.394022608955)
26728 197173 2 180 1900 23rd St 1 7 1 1     7     6012739.26156 2102864.49072 37.7547824929244 -122.39887553350201 (37.7547824929244, -122.398875533502)
26754 197191 2 180 602 Arthur Ave 12 7 1 1     18     6015839.12005 2099880.54912 37.7467614521736 -122.38794706729799 (37.7467614521736, -122.387947067298)
26819 202073 2 137 1 Gould St 2 7 1 1     12     6012686.9776800005 2090655.72307 37.721256863288396 -122.398199843161 (37.7212568632884, -122.398199843161)
26929 219589 2 12 1201 San Jose Ave 32 7 1 1     1     6004392.47127 2096007.06435 37.7354849555631 -122.42725259745 (37.7354849555631, -122.42725259745)
26932 178306 2 3 777 Brotherhood Way 3 7 1 1     6 Width 0ft   5990015.12646 2088607.4961599999 37.7143440274236 -122.47641961286999 (37.7143440274236, -122.47641961287)
Powered by Datasette · Query took 14.353ms · Data source: data.sfgov.org