sf-trees

Data source: data.sfgov.org

Custom SQL query returning 11 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
6012 27414 3 72 2300 Van Ness Ave 2 11 1 2     12 9   6005892.4011 2118361.12861 37.7969486190501 -122.42365562852801 (37.7969486190501, -122.423655628528)
6873 23463 3 72 2300 Van Ness Ave 1 11 1 2     12 9   6005896.8378 2118341.60488 37.7968952622641 -122.423638887645 (37.7968952622641, -122.423638887645)
8282 27415 3 72 2300 Van Ness Ave 3 11 1 2     12 9   6005889.8891 2118381.22689 37.7970036620469 -122.423665750374 (37.7970036620469, -122.423665750374)
37563 178857 2 72 701 Delta St 4 9 1 1     12 Width 3ft   6009291.72599 2087274.3379400002 37.711782574777004 -122.409697761866 (37.711782574777, -122.409697761866)
70609 237916 2 72 1295 Stanyan St 2 1 1 1     12 Width 4ft   5997518.24966 2104934.77487 37.7596070976188 -122.451663046815 (37.7596070976188, -122.451663046815)
72296 237926 2 72 23 Seward St 1 7 1 1     12 Width 3ft   6001036.33691 2104228.71408 37.757869277361706 -122.43944515878799 (37.7578692773617, -122.439445158788)
153732 237942 2 72 320 Hermann St 1 1 1 1     12 Width 3ft   6003704.07001 2108683.26654 37.770251867271796 -122.43053686847901 (37.7702518672718, -122.430536868479)
153868 214322 3 72 350x Kensington Way 2 11 1 2     12 Width 6ft   5994251.85903 2099042.92229 37.7432419652355 -122.462532396964 (37.7432419652355, -122.462532396964)
162501 237907 2 72 3911 21st St 3 17 1 1     12     6002340.71018 2103530.84091 37.75602723197329 -122.43488418855301 (37.7560272319733, -122.434884188553)
177811 214313 2 72 1630 09th Ave 1 7 1 1     12 Width 6ft   5993420.04408 2104384.15571 37.7578596869935 -122.465796566365 (37.7578596869935, -122.465796566365)
15860 26103 3 72 1557 Oakdale Ave 1 1 1 2   07/22/1988 12:00:00 AM 12 3x3   6015264.4135 2095277.0122 37.734089230154204 -122.38961289841002 (37.7340892301542, -122.38961289841)
Powered by Datasette · Query took 3.683ms · Data source: data.sfgov.org