sf-trees

Data source: data.sfgov.org

Custom SQL query returning 33 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
96 251196 6 3 900X 14th St 2 8 1 1   03/22/2017 12:00:00 AM 3     6002515.0 2107976.0 37.768242455454995 -122.43459927073098 (37.768242455455, -122.434599270731)
563 173951 6 17 2646 Union St 1 8 1 1   04/11/2017 12:00:00 AM 3 10x10 Permit Number 779549 6000338.0 2118225.0 37.796259749404605 -122.442865342513 (37.7962597494046, -122.442865342513)
1358 173635 6 17 2590 Pacific Ave 1 8 1 1   05/11/2017 12:00:00 AM 3 3x3 Permit Number 779167 6001760.0 2117029.0 37.7930568116395 -122.43785923271999 (37.7930568116395, -122.43785923272)
2105 251411 6 17 2751 Buchanan St 1 8 1 1   06/21/2017 12:00:00 AM 3 6x6 Permit Number 779887 6003497.0 2117826.0 37.7953437887296 -122.431906052505 (37.7953437887296, -122.431906052505)
2436 110026 1 175 2585 Pacific Ave 2 8 1 1   03/18/2015 12:00:00 AM 3   Permit Number 779691 6001774.18039 2116969.68651 37.7928947585324 -122.437805917729 (37.7928947585324, -122.437805917729)
2687 253164 4 17 146 Cambridge St 1 8 1 1   07/27/2017 12:00:00 AM 3 4x4   6006598.94029 2094006.4119099998 37.7301161400075 -122.419482094225 (37.7301161400075, -122.419482094225)
3318 253415 4 88 55 Stoneybrook Ave   8 1 1   08/31/2017 12:00:00 AM 3   Permit Number 779907 6005926.97731 2093972.4268599998 37.729984953042795 -122.421802746417 (37.7299849530428, -122.421802746417)
3709 253265 6 19 180 San Aleso Ave 1 8 1 1   09/19/2017 12:00:00 AM 3 3x3   5993319.0 2094440.0 37.730549723890206 -122.465423653439 (37.7305497238902, -122.465423653439)
5087 150676 4 26 548 Rhode Island St 1 8 1 1   11/07/2017 12:00:00 AM 3 3x3 Permit Number 780811 6011754.983990001 2105812.52377 37.762822244976505 -122.402486741392 (37.7628222449765, -122.402486741392)
8205 110025 1 15 2585 Pacific Ave 1 8 1 1   03/18/2015 12:00:00 AM 3   Permit Number 774536 6001760.7528800005 2116964.32872 37.7928792839017 -122.437851993568 (37.7928792839017, -122.437851993568)
9848 122687 6 17 1462 Funston Ave 1 8 1 1   01/04/2017 12:00:00 AM 3 3x8 Permit Number 779171 5992142.99696903 2105491.66018597 37.7608268551195 -122.470293739312 (37.7608268551195, -122.470293739312)
10183 173712 2 17 699x 29th St 1 8 1 1   02/03/2017 12:00:00 AM 3 3x3 Permit Number 779391 6002089.0 2098776.0 37.7429572717864 -122.435414565427 (37.7429572717864, -122.435414565427)
10195 173713 2 17 699x 29th St 2 8 1 1   02/03/2017 12:00:00 AM 3 3x3 Permit Number 779391 6002089.0 2098776.0 37.7429572717864 -122.435414565427 (37.7429572717864, -122.435414565427)
11497 69940 1 49 1295 30th Ave 1 8 1 1   05/06/2016 12:00:00 AM 3 5x5 Permit Number 778203 5986757.5345 2106473.3538 37.7632094781069 -122.488991584645 (37.7632094781069, -122.488991584645)
22873 251137 2 11 25x Goettingen St 1 8 1 1   03/10/2017 12:00:00 AM 3 3x3 Permit Number 779273 6009828.0 2094364.0 37.7312793503434 -122.40834398535401 (37.7312793503434, -122.408343985354)
66196 107892 1 88 162 Brewster St   8 1 1   11/04/2014 12:00:00 AM 3 3x3 Permit Number 773952 6010231.01704 2099016.49618 37.7440766668365 -122.40727852777799 (37.7440766668365, -122.407278527778)
80053 109497 1 254 785 Mangels Ave 1 8 1 1 1 02/19/2015 12:00:00 AM 3 3x3 Permit Number 771883 5996438.0 2095245.0 37.732939449865896 -122.45469900823 (37.7329394498659, -122.45469900823)
85057 115566 1 17 2026 36TH AVE 1 8 1 1   04/04/2016 12:00:00 AM 3 3x3 Permit Number 777529 5985134.0 2101392.0 37.7491625951009 -122.49423221215099 (37.7491625951009, -122.494232212151)
85532 108239 1 17 15 ASHBURY TER 1 8 1 1   01/14/2015 12:00:00 AM 3 5x50 Permit Number 774721 5999554.7 2106911.6 37.7651513833487 -122.444762103204 (37.7651513833487, -122.444762103204)
85775 114272 6 17 2241 Sacramento St 1 8 1 1   03/22/2016 12:00:00 AM 3 3x6 Permit Number 776884 6004082.4 2115905.7 37.79010430227179 -122.42974344149499 (37.7901043022718, -122.429743441495)
94493 110787 8 17 850x SANCHEZ ST 1 8 1 1   02/18/2016 12:00:00 AM 3 3x3 Permit Number 777427 6003717.0 2103349.0 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694)
98858 114924 2 3 37X EVERGLADE DR 1 8 1 1   01/13/2016 12:00:00 AM 3 3x3   5986312.0 2095495.0 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139)
102481 114925 2 71 4400x OCEAN AVE 3 8 1 1   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
103011 114923 2 3 51X EVERGLADE DR 1 8 1 1   01/13/2016 12:00:00 AM 3 3x3   5986312.0 2095495.0 37.7330398702545 -122.489725113139 (37.7330398702545, -122.489725113139)
103199 114934 2 71 4400x OCEAN AVE 10 8 1 1   02/17/2016 12:00:00 AM 3 3x3 Permit Number 777127 5985931.0 2095134.0 37.7320264068308 -122.491015755892 (37.7320264068308, -122.491015755892)
106272 115004 5 80 1050 MCALLISTER ST 1 8 1 21 4 01/19/2016 09:19:00 AM 3 3x3   6004148.0 2111858.0 37.778994045300706 -122.42922772691401 (37.7789940453007, -122.429227726914)
111849 117150 8 49 928 TOLAND ST 5 8 1 1   07/13/2016 12:00:00 AM 3 3x3 Permit Number 774325 6011950.0 2098029.0 37.7414612698949 -122.401265252936 (37.7414612698949, -122.401265252936)
115370 107863 1 61 218 HOWTH ST 1 8 1 1     3     5997350.1 2090721.9 37.720572361158105 -122.451219574954 (37.7205723611581, -122.451219574954)
128304 115100 6 17 710 PACHECO ST 1 8 1 1   02/04/2016 12:00:00 AM 3 3x3 Permit Number 777305 5992727.0 2102215.0 37.7518637464828 -122.468035600741 (37.7518637464828, -122.468035600741)
129398 109973 2 17 1458 43rd Ave 1 8 1 1   03/16/2015 12:00:00 AM 3 3x3   5982831.2 2105195.6 37.7594711884194 -122.502476670215 (37.7594711884194, -122.502476670215)
142230 120534 1 12 2043 32nd Ave 1 8 1 1   08/10/2016 12:00:00 AM 3 3x3   5986293.0 2101328.0 37.7490546230695 -122.49021972232599 (37.7490546230695, -122.490219722326)
142954 110788 8 17 850x SANCHEZ ST 2 8 1 1   02/18/2016 12:00:00 AM 3 3x3 Permit Number 777427 6003717.0 2103349.0 37.7556059854845 -122.430111549694 (37.7556059854845, -122.430111549694)
143274 122379 4 88 466 Vernon St 1 8 1 1   10/26/2016 12:00:00 AM 3 3x3   5992521.0 2090937.0 37.7208852925782 -122.46792773796801 (37.7208852925782, -122.467927737968)
Powered by Datasette · Query took 2.645ms · Data source: data.sfgov.org