sf-trees

Data source: data.sfgov.org

Custom SQL query returning 101 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
9726 173663 6 82 3878 17th St 1 5 1 1       3x3   6003109.0 2105964.0 37.7627516946294 -122.432400964417 (37.7627516946294, -122.432400964417)
66105 98309 6 82 401X Newhall St 1 25 1 1     6 3x3   6016081.14502 2097910.9401599998 37.741366715992896 -122.386972815546 (37.7413667159929, -122.386972815546)
80993 85086 6 82 1600 Chestnut St 2 1 1 1         Permit Number 49476 6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303)
81776 114391 6 82 23x PINTO AVE 2 7 1 1     7     5988521.0 2090808.0 37.720299292258794 -122.481744923362 (37.7202992922588, -122.481744923362)
93217 114390 6 82 23x PINTO AVE 1 7 1 1     7     5988521.0 2090808.0 37.720299292258794 -122.481744923362 (37.7202992922588, -122.481744923362)
93295 104872 6 82 1753 Noe St 1 27 1 1   11/22/2013 12:00:00 AM     Permit Number 770054 6003434.1 2098036.1 37.7410019772539 -122.430710793678 (37.7410019772539, -122.430710793678)
96134 85085 6 82 1600 Chestnut St 1 1 1 1         Permit Number 49476 6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303)
102660 85090 6 82 1600 Chestnut St 3 5 1 1           6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303)
105009 85087 6 82 1600 Chestnut St 3 1 1 1         Permit Number 49476 6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303)
109838 98274 6 82 766 Anderson St   7 1 1   01/23/2012 12:00:00 AM 18   Permit Number 768445 6007723.0 2095324.0 37.7337971999422 -122.41568932106199 (37.7337971999422, -122.415689321062)
110346 114383 6 82 418X SERRANO DR 1 2 1 1     6     5988379.0 2090615.0 37.7197611043299 -122.48222163222201 (37.7197611043299, -122.482221632222)
114979 118322 6 82 720 BATTERY ST 1 19 1 1           6012486.0 2118560.0 37.7978646555778 -122.400854041686 (37.7978646555778, -122.400854041686)
125168 85089 6 82 1600 Chestnut St 2 5 1 1           6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303)
138436 114384 6 82 418X SERRANO DR 2 7 1 1     6     5988379.0 2090615.0 37.7197611043299 -122.48222163222201 (37.7197611043299, -122.482221632222)
146084 85088 6 82 1600 Chestnut St 1 5 1 1           6004108.1 2120157.9 37.8017812094321 -122.429957968303 (37.8017812094321, -122.429957968303)
3419 252969 5 82 101 Whipple Ave 1 1 1 1           5998180.94106 2087280.50358 37.711170613109104 -122.448099970249 (37.7111706131091, -122.448099970249)
4012 252965 5 82 115X Whipple Ave 1 1 1 1   10/05/2017 02:04:00 PM 3              
4061 252970 5 82 101X Whipple Ave 2 2 1 1   10/05/2017 12:21:00 PM 3              
4066 252966 5 82 111 Whipple Ave 1 1 1 1   10/05/2017 12:19:00 PM 3     5998135.7809 2087327.97675 37.7112983819328 -122.448259470506 (37.7112983819328, -122.448259470506)
4074 252967 5 82 109 Whipple Ave 1 1 1 1   10/05/2017 01:55:00 PM 3     5998144.81293 2087318.48212 37.7112728281964 -122.448227570418 (37.7112728281964, -122.448227570418)
2715 253166 4 82 2405 32nd Ave 1 1 1 1   07/31/2017 12:00:00 AM 3 3x3 Permit Number 778209 5986396.6612 2098868.17463 37.742306656921 -122.48968039586501 (37.742306656921, -122.489680395865)
113880 115805 4 82 872 Kansas St   1 1 1   02/24/2016 12:00:00 AM 3 3x3   6011546.4 2104246.9 37.758511744317296 -122.40309803301201 (37.7585117443173, -122.403098033012)
652 237023 3 82 8 Octavia St 4 4 1 2   04/15/2017 01:44:00 PM 3 Width 6ft   6005765.01716 2109438.39176 37.7724417955802 -122.423461745458 (37.7724417955802, -122.423461745458)
661 237024 3 82 8 Octavia St 5 4 1 2   04/15/2017 01:48:00 PM 3 Width 6ft   6005763.84021 2109451.72322 37.772478334130994 -122.423466764586 (37.772478334131, -122.423466764586)
663 237022 3 82 8 Octavia St 3 4 1 2   04/15/2017 01:40:00 PM 3 Width 6ft   6005770.133230001 2109412.50366 37.772371001847 -122.423442207693 (37.772371001847, -122.423442207693)
665 239151 3 82 100 Octavia St 2 4 1 2   04/15/2017 01:58:00 PM 3 Width 4ft   6005731.03459 2109700.90805 37.7731606839629 -122.423597962203 (37.7731606839629, -122.423597962203)
666 237028 3 82 8 Octavia St 9 4 1 2   04/15/2017 01:55:00 PM 3 Width 6ft   6005756.39315 2109517.28856 37.7726579404383 -122.423497186858 (37.7726579404383, -122.423497186858)
1093 244319 3 82 331 Octavia St 2 1 1 2   05/02/2017 04:00:00 PM 3 Width 0ft   6005497.6412 2110517.1934 37.7753888290162 -122.424463374134 (37.7753888290162, -122.424463374134)
1105 244414 3 82 261 Octavia St 3 1 1 2   05/02/2017 04:17:00 PM 3 Width 0ft   6005541.7456 2110219.4552 37.7745738026307 -122.424289625835 (37.7745738026307, -122.424289625835)
1108 244318 3 82 331 Octavia St 1 1 1 2   05/02/2017 04:08:00 PM 3 Width 0ft   6005494.8083 2110541.2729 37.7754547855001 -122.424474886956 (37.7754547855001, -122.424474886956)
1966 138440 3 82 1820 POST ST 1 1 1 2   07/16/2014 12:00:00 AM 6 Width 0ft   6003498.0109 2114207.9928 37.7854097192823 -122.431644121578 (37.7854097192823, -122.431644121578)
3763 18277 3 82 1950 Post St 6 1 1 2   12/27/2007 12:00:00 AM 6 4X4   6002776.9831 2114109.0569 37.7850971709049 -122.434131584258 (37.7850971709049, -122.434131584258)
4615 137866 3 82 2044 Fillmore St 2 1 1 2   07/03/2012 12:00:00 AM 1 Width 0ft   6002931.7599 2115390.6101 37.7886247736431 -122.43368773072201 (37.7886247736431, -122.433687730722)
5339 7304 3 82 1908 Fillmore St 1 1 1 2     7 3X3   6002992.4511 2114925.4093 37.7873508941206 -122.433444491336 (37.7873508941206, -122.433444491336)
5596 7325 3 82 2027 Fillmore St 1 1 1 2     12 3X3   6002881.7283 2115306.8957 37.7883920762372 -122.433854846414 (37.7883920762372, -122.433854846414)
6336 7291 3 82 1899X Fillmore St 1 1 1 2     12 4x4   6002969.1284 2114733.7648 37.7868233637677 -122.433511482074 (37.7868233637677, -122.433511482074)
6434 7318 3 82 2001 Fillmore St 1 1 1 2   07/11/1996 12:00:00 AM 6 3x3   6002895.5378 2115212.2273 37.7881329245579 -122.43380029876002 (37.7881329245579, -122.43380029876)
6898 2436 3 82 740 Buchanan St 2 1 1 2   01/22/1999 12:00:00 AM 3 3X3   6004500.111269999 2111079.2700799997 37.7768757716325 -122.427954126177 (37.7768757716325, -122.427954126177)
7747 7300 3 82 1900 Fillmore St 1 1 1 2     7 3X3   6002999.289 2114860.4079 37.7871728047294 -122.433416186864 (37.7871728047294, -122.433416186864)
8083 7308 3 82 1919 Fillmore St 1 1 1 2   12/27/2011 12:00:00 AM 3 3x3   6002923.2911 2115026.9363 37.787625737445204 -122.433691029207 (37.7876257374452, -122.433691029207)
8100 14763 3 82 983 McAllister St 1 1 1 2     18 4X4   6004471.7203 2111860.4178 37.7790190047533 -122.42810802032601 (37.7790190047533, -122.428108020326)
8221 5902 3 82 1230 Eddy St 1 1 1 2     6 3X3   6004519.1281 2112960.2158 37.7820414601118 -122.428022411289 (37.7820414601118, -122.428022411289)
8606 8111 3 82 810 Fulton St 1 1 1 2   04/28/1993 12:00:00 AM 20 3X3   6003847.5569 2111477.6208 37.7779326053256 -122.430239935515 (37.7779326053256, -122.430239935515)
8714 2466 3 82 1826 Buchanan St 3 1 1 2   02/17/1998 12:00:00 AM 3 4X4   6003983.3989 2114773.4102 37.786989713975295 -122.43000517250799 (37.7869897139753, -122.430005172508)
8758 7287 3 82 1850 Fillmore St 1 1 1 2     13 3X3   6003043.7765 2114538.1757 37.786290560678204 -122.433239236497 (37.7862905606782, -122.433239236497)
9603 19972 3 82 100 STAIRWAY44 3 1 1 2     3 36            
10059 24572 3 82 2122 Fillmore St 1 1 1 2   03/16/2013 12:00:00 AM 3 3x3   6002889.00041 2115679.48805 37.7894155324538 -122.433856328234 (37.7894155324538, -122.433856328234)
10418 77647 3 82 1300X Silliman St 8 1 1 4 2 10/26/1984 12:00:00 AM 10 3x3   6006841.82551 2093150.82877 37.7277805724005 -122.418581759638 (37.7277805724005, -122.418581759638)
10895 27085 3 82 747 Silver Ave 1 1 1 2     6 2X3   6006317.37103 2093607.15152 37.729003994832 -122.420427188268 (37.729003994832, -122.420427188268)
12987 1848 3 82 2401 Bay Shore Blvd 3 1 1 2     6 3X3   6011043.028059999 2086938.1542099998 37.7109574665846 -122.403621108454 (37.7109574665846, -122.403621108454)
13142 27250 3 82 747 Silver Ave 2 1 1 2     6 2X3   6006299.28886 2093605.00165 37.728997072755206 -122.420489547272 (37.7289970727552, -122.420489547272)
13396 85628 3 82 1470 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015957.8963 2094137.5833 37.730999015226104 -122.387135841638 (37.7309990152261, -122.387135841638)
13407 16508 3 82 325 Newhall St 10 1 1 2     12 3x3   6016639.93914 2098306.03692 37.7424824967653 -122.385068203435 (37.7424824967653, -122.385068203435)
13415 85617 3 82 1274 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6017015.0778 2093348.1164 37.7288897808137 -122.383426014631 (37.7288897808137, -122.383426014631)
13512 85658 3 82 1643 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015004.908 2094769.8823 37.7326823614983 -122.39047467450001 (37.7326823614983, -122.3904746745)
13554 85620 3 82 1344 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016632.8917 2093635.0593 37.729656539473 -122.384767252586 (37.729656539473, -122.384767252586)
13600 85619 3 82 1338 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016653.5768 2093624.593 37.729628945087704 -122.384695012523 (37.7296289450877, -122.384695012523)
13802 85643 3 82 1235 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6017171.4256 2093155.5219 37.7283695937915 -122.38287210620199 (37.7283695937915, -122.382872106202)
13961 85647 3 82 1351 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016557.1838 2093613.7118 37.7295937360014 -122.385027498588 (37.7295937360014, -122.385027498588)
14061 24180 3 82 101X Whitney Young Cir 13 1 1 2     30 3x3   6016621.33395 2095295.74377 37.7342158098126 -122.384922860422 (37.7342158098126, -122.384922860422)
14120 85653 3 82 1541 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015555.708 2094360.5338 37.731588912651404 -122.388541843069 (37.7315889126514, -122.388541843069)
14131 85613 3 82 1190 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6017458.1534 2093022.4369 37.728020006278 -122.38187161186 (37.728020006278, -122.38187161186)
14162 85622 3 82 1360 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016552.9396 2093696.0654 37.729819627930105 -122.385047906896 (37.7298196279301, -122.385047906896)
14204 85646 3 82 1321 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016609.4363 2093572.233 37.7294827335965 -122.38484396608999 (37.7294827335965, -122.38484396609)
14255 85641 3 82 1215 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6017274.7558 2093081.4055 37.72817179324429 -122.382509730509 (37.7281717932443, -122.382509730509)
14505 85632 3 82 1582 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015365.5421 2094575.4322 37.7321684400373 -122.38921428964 (37.7321684400373, -122.38921428964)
14632 85652 3 82 1519 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015655.7374 2094284.1377 37.7313846871586 -122.388190689138 (37.7313846871586, -122.388190689138)
14634 24178 3 82 101X Whitney Young Cir 11 1 1 2   02/15/2001 12:00:00 AM 4 4x3   6016619.186290001 2095310.93644 37.7342574070589 -122.384931343733 (37.7342574070589, -122.384931343733)
14774 85650 3 82 1419 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016182.7975 2093891.6734 37.730336247224706 -122.386341174586 (37.7303362472247, -122.386341174586)
14882 85659 3 82 1623 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015103.6745 2094694.6627 37.7324813021879 -122.390127958436 (37.7324813021879, -122.390127958436)
14937 16560 3 82 702X Newhall St 2 1 1 2   12/03/1992 12:00:00 AM 12 3X3   6015615.61867 2097370.07413 37.7398558207833 -122.38854471268299 (37.7398558207833, -122.388544712683)
14960 85627 3 82 1466 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015977.8277 2094121.4228 37.730955745426606 -122.387065808076 (37.7309557454266, -122.387065808076)
15002 85644 3 82 1275 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016975.0441 2093297.8038 37.728749419657 -122.383560914081 (37.728749419657, -122.383560914081)
15041 24179 3 82 101X Whitney Young Cir 12 1 1 2   03/29/1990 12:00:00 AM 12 5x3   6016625.58798 2095312.02915 37.7342607615082 -122.38490928693199 (37.7342607615082, -122.384909286932)
15196 85648 3 82 1357 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016534.0204 2093632.0271 37.7296427448929 -122.38510885322701 (37.7296427448929, -122.385108853227)
15328 85611 3 82 1150 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6017700.249 2092841.4739 37.7275364831055 -122.381022095395 (37.7275364831055, -122.381022095395)
15360 85624 3 82 1422 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016199.7661 2093954.969 37.7305109836044 -122.38628692243 (37.7305109836044, -122.38628692243)
15393 11470 3 82 39X Hawkins Ln 5 1 1 2     60 3X3   6016849.3995 2095607.3792400002 37.7350841106266 -122.38415605258001 (37.7350841106266, -122.38415605258)
15458 85621 3 82 1356 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016575.2959 2093679.014 37.7297740447744 -122.38496943038601 (37.7297740447744, -122.384969430386)
15537 85657 3 82 1651 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6014964.3549 2094799.3159999999 37.7327609307407 -122.39061693379999 (37.7327609307407, -122.3906169338)
15649 85651 3 82 1467 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015942.8131 2094070.7863 37.730814768733396 -122.387183329829 (37.7308147687334, -122.387183329829)
15814 85630 3 82 1518 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015608.4708 2094395.709 37.7316884205401 -122.388361884277 (37.7316884205401, -122.388361884277)
15931 85649 3 82 1399 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016350.3286 2093764.5437 37.7299964462298 -122.385753133703 (37.7299964462298, -122.385753133703)
15934 85623 3 82 1404 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016275.7207 2093898.407 37.7303598794973 -122.38602039250401 (37.7303598794973, -122.386020392504)
16109 85626 3 82 1454 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016038.1604 2094077.7893 37.7308392772335 -122.38685418415001 (37.7308392772335, -122.38685418415)
16244 85633 3 82 1590 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6015320.4739 2094608.4089 37.732256488847106 -122.38937240380899 (37.7322564888471, -122.389372403809)
16295 27141 3 82 1775 Silver Ave 2 1 1 2     12 2X3   6011398.088769999 2095346.30396 37.7340643486912 -122.402984937921 (37.7340643486912, -122.402984937921)
16358 85616 3 82 1258 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6017082.7023 2093297.2628 37.7287538840188 -122.383188691469 (37.7287538840188, -122.383188691469)
16510 85610 3 82 1132 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6017745.1516 2092811.7191 37.727457260594704 -122.38086479752899 (37.7274572605947, -122.380864797529)
16538 85640 3 82 1201X Quesada Ave 3 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6017322.9044 2093043.5358 37.7280704700942 -122.382340643729 (37.7280704700942, -122.382340643729)
16554 85618 3 82 1314 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016773.2527 2093530.9730000002 37.729378500955896 -122.384274758873 (37.7293785009559, -122.384274758873)
16579 85638 3 82 1201X Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6017293.1497 2093067.8806 37.728135672587904 -122.382445200849 (37.7281356725879, -122.382445200849)
16642 85639 3 82 1201X Quesada Ave 2 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6017307.7565 2093058.1427 37.7281097410693 -122.382394026885 (37.7281097410693, -122.382394026885)
16831 16544 3 82 400X Newhall St 5 1 1 2     12 3x3   6016074.6462900005 2097992.47705 37.7415902397879 -122.38700097152399 (37.7415902397879, -122.387000971524)
16855 85645 3 82 1313 Quesada Ave 1 1 1 2   03/30/2007 12:00:00 AM 3 3x3   6016677.8494 2093524.29 37.7293548752151 -122.384604114815 (37.7293548752151, -122.384604114815)
17662 4223 3 82 3975 Cesar Chavez St 1 1 1 2     12 3X3   6004059.37365 2100401.32602 37.7475317476004 -122.428717394312 (37.7475317476004, -122.428717394312)
18626 5933 3 82 1355 Eddy St 2 1 1 2   03/28/1990 12:00:00 AM 3 4X4   6004029.334559999 2112693.29822 37.781280848415 -122.42969783017901 (37.781280848415, -122.429697830179)
18749 10444 3 82 1508 Haight St 1 1 1 2   12/04/1999 12:00:00 AM 6 3x3   5998873.5099 2108710.5533 37.770051957545704 -122.447247648975 (37.7700519575457, -122.447247648975)
19015 23089 3 82 1360 Valencia St 1 1 1 2   04/03/1992 12:00:00 AM 3 3X3   6006386.45124 2101639.17827 37.751062036612 -122.420758355385 (37.751062036612, -122.420758355385)
19418 90383 3 82 20 12th St 3 1 1 2   02/21/2008 12:00:00 AM 3 3x3   6006777.292282 2110019.638696 37.7740948433326 -122.42000143597099 (37.7740948433326, -122.420001435971)
19877 22862 3 82 151 Turquoise Way 3 1 1 2     3 2X2   5999932.75509 2099167.18309 37.7439086722544 -122.442898328797 (37.7439086722544, -122.442898328797)
Powered by Datasette · Query took 17.721ms · Data source: data.sfgov.org