sf-trees

Data source: data.sfgov.org

Custom SQL query returning 18 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
20367 29572 3 27 400X Junipero Serra Blvd 1 11 1 2   04/01/2007 12:00:00 AM 3 3X3   5991380.33669 2094272.13717 37.7299768148765 -122.47211360317 (37.7299768148765, -122.47211360317)
21729 29577 3 27 400X Junipero Serra Blvd 6 11 1 2   04/01/2007 12:00:00 AM 3 3X3   5991369.68485 2094223.17677 37.7298417654626 -122.47214686011002 (37.7298417654626, -122.47214686011)
24627 207239 3 27 1x Minerva St 43 11 1 2     13 Width 0ft   5996447.62341 2088998.17361 37.7157876983331 -122.45421469505199 (37.7157876983331, -122.454214695052)
29724 207328 3 27 400x Marietta Dr 10 11 1 2     5 Width 3ft   5999485.75789 2097034.69989 37.738027887567796 -122.444290723035 (37.7380278875678, -122.444290723035)
30605 207238 3 27 1x Minerva St 34 11 1 2     6 Width 0ft   5996327.60089 2088999.83253 37.7157853699672 -122.454629665632 (37.7157853699672, -122.454629665632)
33929 207241 3 27 1x Minerva St 46 11 1 2     6 Width 0ft   5996475.13618 2088997.3163599998 37.7157869221947 -122.45411953688601 (37.7157869221947, -122.454119536886)
65599 207240 3 27 1x Minerva St 44 11 1 2     14 Width 0ft   5996458.70543 2088998.7901400002 37.7157900266684 -122.45417643520001 (37.7157900266684, -122.4541764352)
69603 207236 3 27 1x Minerva St 25 11 1 2     3 Width 0ft   5996258.071 2089000.15441 37.7157822655196 -122.45487001484301 (37.7157822655196, -122.454870014843)
76312 207237 3 27 1x Minerva St 33 11 1 2     15 Width 0ft   5996320.92755 2088998.85833 37.715782312278 -122.454652661299 (37.715782312278, -122.454652661299)
80194 4999 3 27 5300 Diamond Heights Blvd 16 11 1 2     7 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
88236 4991 3 27 5300 Diamond Heights Blvd 8 11 1 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
94015 4992 3 27 5300 Diamond Heights Blvd 9 11 1 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
95563 4998 3 27 5300 Diamond Heights Blvd 15 11 1 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
97805 4994 3 27 5300 Diamond Heights Blvd 11 11 1 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
99734 4993 3 27 5300 Diamond Heights Blvd 10 11 1 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
110729 4995 3 27 5300 Diamond Heights Blvd 12 11 1 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
133379 207242 3 27 1x Minerva St 53 11 1 2     8 Width 0ft   5996583.3083 2088999.01444 37.7157977869175 -122.453745768776 (37.7157977869175, -122.453745768776)
143370 5001 3 27 5300 Diamond Heights Blvd 18 11 1 2     12 12   6001419.5409281 2098992.5811716 37.743513909519294 -122.437744874344 (37.7435139095193, -122.437744874344)
Powered by Datasette · Query took 24.096ms · Data source: data.sfgov.org