sf-trees

Data source: data.sfgov.org

Custom SQL query returning 15 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
1590 5343 3 90 180 Dolores St 1 1 1 1   10/24/2014 02:20:00 PM 3 3X3   6004776.7961099995 2107352.0132 37.7666572770255 -122.426731495165 (37.7666572770255, -122.426731495165)
9325 25487 1 90 645X POTRERO AVE 4 1 1 1   04/10/2013 12:00:00 AM 3 3X3   6010440.0 2105310.0 37.7613689295586 -122.40699940993099 (37.7613689295586, -122.406999409931)
14910 17426 3 90 1869 Palou Ave 1 1 1 2   12/05/2015 01:06:00 PM 3 3X3   6013447.639169999 2096284.8118900002 37.736755533926 -122.39596469871401 (37.736755533926, -122.395964698714)
14973 18344 3 90 440 Potrero Ave 3 1 1 2   07/16/2015 07:27:00 AM 3 3X3   6010309.570730001 2106285.64769 37.7640405376657 -122.40751930078001 (37.7640405376657, -122.40751930078)
16888 18349 4 90 480 Potrero Ave 1 1 1 1   02/28/2006 12:00:00 AM 3 3X3   6010310.27618 2106136.10948 37.763629979170496 -122.40750631726101 (37.7636299791705, -122.407506317261)
20723 5477 3 90 655 Dolores St 1 1 1 2     3 3X3   6005026.79294 2104432.16218 37.7586541903676 -122.42565896099899 (37.7586541903676, -122.425658960999)
85160 2390 3 90 2642X Bryant St 2 1 1 2   03/11/2007 12:00:00 AM 3 3X3   6009749.5258463 2101948.1671123 37.752099429361294 -122.409150251369 (37.7520994293613, -122.409150251369)
85642 18418 3 90 645X POTRERO AVE 3 1 1 2   05/02/2016 12:00:00 AM 3 3X3   6010440.0 2105310.0 37.7613689295586 -122.40699940993099 (37.7613689295586, -122.406999409931)
91376 4894 3 90 745X Mansell St 2 1 1 2   03/29/2007 12:00:00 AM 3 3X3   6009751.8988059005 2090059.5024836997 37.7194558413593 -122.408303589874 (37.7194558413593, -122.408303589874)
91447 5370 3 90 265 DOLORES ST 1 1 1 2   07/11/2015 03:03:00 PM 3 3X3   6005008.2 2106862.7 37.765326820302 -122.42589627439101 (37.765326820302, -122.425896274391)
93529 2 3 90 850X Lake St 1 1 1 2   04/25/2009 12:00:00 AM 3 3X3   5992872.52482 2114854.21479 37.78657606668221 -122.468451837381 (37.7865760666822, -122.468451837381)
114281 26918 3 90 2000X Bay Shore Blvd 8 1 1 2   10/19/2010 12:00:00 AM 3 3X3   6012375.8565272 2088505.2474916999 37.7153347551878 -122.399124435859 (37.7153347551878, -122.399124435859)
127564 16583 1 90 810X Lake St 2 1 1 1   06/26/2008 12:00:00 AM 2 3X3   5992991.92524 2114858.80829 37.7865955752076 -122.46803907898199 (37.7865955752076, -122.468039078982)
139100 2389 3 90 2642X Bryant St 1 1 1 2   03/11/2007 12:00:00 AM 3 3X3   6009749.5258463 2101948.1671123 37.752099429361294 -122.409150251369 (37.7520994293613, -122.409150251369)
146333 9298 1 90 135X Mansell St 4 1 1 1   06/10/1992 12:00:00 AM 3 3X3   6011497.3933157995 2090592.5284866001 37.7210170109869 -122.40230748066001 (37.7210170109869, -122.40230748066)
Powered by Datasette · Query took 4.246ms · Data source: data.sfgov.org