sf-trees

Data source: data.sfgov.org

Custom SQL query returning 18 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
67 166623 1 29 520 Jersey St 1 1 1 1   03/21/2017 12:00:00 AM 3 Width 3ft Permit Number 18521 6001647.24706 2101482.78936 37.7503643764264 -122.437135780708 (37.7503643764264, -122.437135780708)
938 251414 2 29 10x Jones St 2 1 1 1   11/19/2005 12:00:00 AM   3x3   6009207.0 2112641.0 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248)
947 251413 2 29 10x Jones St 1 1 1 1   11/19/2005 12:00:00 AM   3x3   6009207.0 2112641.0 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248)
967 251416 2 29 10x Jones St 4 1 1 1       3x3   6009207.0 2112641.0 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248)
971 251415 2 29 10x Jones St 3 1 1 1   11/19/2005 12:00:00 AM   3x3   6009207.0 2112641.0 37.7814290728676 -122.411781887248 (37.7814290728676, -122.411781887248)
1937 251785 3 29 245 Lobos St 1 1 1 2       3x3   5994580.0 2088672.0 37.714784827932604 -122.460646394253 (37.7147848279326, -122.460646394253)
3317 253413 2 29 2433 23rd Ave 1 1 1 9 3     3x3   5989193.66308 2098780.80152 37.7422296590049 -122.48000293550501 (37.7422296590049, -122.480002935505)
5209 169218 1 29 824 Ellis St 1 1 1 1 4   0 3x3   6006905.3054599995 2113639.6299099997 37.7840416758297 -122.419815533287 (37.7840416758297, -122.419815533287)
5217 169168 1 29 701 Polk St 2 1 1 1 4   0 3x3   6007051.56678 2113380.55802 37.7833385660552 -122.41929113679599 (37.7833385660552, -122.419291136796)
5218 169214 1 29 724 Ellis St 1 1 1 1 4   0 Width 4ft   6007369.544319999 2113705.88387 37.7842497348906 -122.41821413029301 (37.7842497348906, -122.418214130293)
5227 169217 1 29 800 Ellis St 1 1 1 1 4   0 3x3   6006932.37231 2113646.73425 37.7840627073778 -122.41972239586501 (37.7840627073778, -122.419722395865)
5234 169170 1 29 750 Eddy St 1 1 1 1 4   0 3x3   6006877.9642199995 2113290.02776 37.7830802133315 -122.419885308057 (37.7830802133315, -122.419885308057)
5238 169219 1 29 840 Polk St 1 1 1 1 4   0 3x3   6006827.36035 2113629.7400599997 37.7840101293977 -122.42008449353001 (37.7840101293977, -122.42008449353)
9742 610 3 29 3105 24TH ST 1 1 1 2   01/01/2009 12:00:00 AM 3 3x3   6008244.0 2102074.0 37.752360480426205 -122.414365505061 (37.7523604804262, -122.414365505061)
9753 173669 1 29 1200X Alabama St 3 1 1 1       3x3   6009203.67582999 2102144.49744393 37.7526079137784 -122.41105175633601 (37.7526079137784, -122.411051756336)
13272 187624 2 29 325 Vicente St 2 1 1 1       3x3   5991928.0 2097693.0 37.7394013212876 -122.470469324928 (37.7394013212876, -122.470469324928)
13277 187623 2 29 325 Vicente St 1 1 1 1       3x3   5991928.0 2097693.0 37.7394013212876 -122.470469324928 (37.7394013212876, -122.470469324928)
13305 187653 2 29 307 Vicente St 1 1 1 1       3x3   5992004.0 2097696.0 37.7394139526506 -122.47020677123899 (37.7394139526506, -122.470206771239)
Powered by Datasette · Query took 1.174ms · Data source: data.sfgov.org