sf-trees

Data source: data.sfgov.org

Custom SQL query returning 9 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
13832 27154 1 20 1700X Silver Ave 3 1 1 3   01/12/2001 12:00:00 AM 6 3X3   6011126.61874 2095085.7194599998 37.7333336755986 -122.403905168305 (37.7333336755986, -122.403905168305)
15856 27155 1 20 1700X Silver Ave 4 1 1 3   01/29/2000 12:00:00 AM 6 3X3   6011143.89147 2095098.83858 37.733370662922795 -122.403846374205 (37.7333706629228, -122.403846374205)
16026 27153 1 20 1700X Silver Ave 2 1 1 3   01/12/2001 12:00:00 AM 6 3X3   6011109.96837 2095074.7045 37.7333025005961 -122.403961958687 (37.7333025005961, -122.403961958687)
40373 37238 3 20 2200X Moraga St 2 5 1 3   03/26/2013 12:00:00 AM 11   Permit Number 770085 5987346.2909 2103736.5081 37.755729192821704 -122.48675431687 (37.7557291928217, -122.48675431687)
78978 87642 1 20 1002X Laguna St 1 1 1 3           6004813.344433 2112300.6630169996 37.7802471321724 -122.42695756751101 (37.7802471321724, -122.426957567511)
95392 37236 3 20 2200X Moraga St 8 5 1 3   03/26/2013 12:00:00 AM     Permit Number 770085 5987459.55498562 2104367.82715752 37.757469225946295 -122.48640896705601 (37.7574692259463, -122.486408967056)
95395 27160 1 20 1700X Silver Ave 9 1 1 3     3 3X3   6011020.5092245005 2095004.7366116 37.733105385033795 -122.40426632243 (37.7331053850338, -122.40426632243)
107812 87643 1 20 1002X Laguna St 2 1 1 3           6004813.344433 2112300.6630169996 37.7802471321724 -122.42695756751101 (37.7802471321724, -122.426957567511)
140654 27152 1 20 1700X Silver Ave 1 1 1 3   06/02/1999 12:00:00 AM 6 3X3   6011020.5092245005 2095004.7366116 37.733105385033795 -122.40426632243 (37.7331053850338, -122.40426632243)
Powered by Datasette · Query took 8.734ms · Data source: data.sfgov.org