sf-trees

Data source: data.sfgov.org

Custom SQL query returning 9 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
177773 188511 2 42 101 Pennsylvania Ave 33 7 1 1     2     6014272.76615 2106665.73514 37.7653052137955 -122.393838275126 (37.7653052137955, -122.393838275126)
176295 249709 2 42 2901 Broadway 3 7 1 1     8     5999701.30683 2117014.48804 37.7928996850292 -122.44498136009899 (37.7928996850292, -122.444981360099)
169866 188508 2 42 101 Pennsylvania Ave 3 7 1 1     3     6014332.46782 2106283.64375 37.764259392178005 -122.393605035044 (37.764259392178, -122.393605035044)
72487 249768 2 42 266 Lombard St 4 7 1 1     12 Width 0ft   6010977.12206 2120702.10235 37.8036620671076 -122.406226211476 (37.8036620671076, -122.406226211476)
60414 188512 2 42 101 Pennsylvania Ave 41 7 1 1     5     6014229.234019999 2106696.64866 37.7653876762377 -122.393991007905 (37.7653876762377, -122.393991007905)
55738 188509 2 42 101 Pennsylvania Ave 12 7 1 1     2     6014325.646980001 2106424.64729 37.7646461780098 -122.393638496141 (37.7646461780098, -122.393638496141)
42028 188510 2 42 101 Pennsylvania Ave 25 7 1 1     2     6014318.1653 2106535.6894400003 37.76495065967789 -122.39367214607401 (37.7649506596779, -122.393672146074)
12540 108677 1 42 11 Otsego Ave 1 7 1 1 1 12/30/2014 12:00:00 AM 3   Permit Number 773206 6000966.57436 2092971.8241299998 37.7269565451936 -122.438879746024 (37.7269565451936, -122.438879746024)
5055 253765 6 42 1366 Guerrero St 2 7 1 1       3X3   6005800.0848900005 2101007.6677599996 37.7492949871928 -122.422741198761 (37.7492949871928, -122.422741198761)
Powered by Datasette · Query took 27.494ms · Data source: data.sfgov.org