sf-trees

Data source: data.sfgov.org

Custom SQL query returning 21 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
18252 30740 3 21 380 Webster St 2 1 1 4 2 01/31/1995 12:00:00 AM 3 3x3 Permit Number 34630 6004184.33514 2109844.2088200003 37.7734667268354 -122.428958416203 (37.7734667268354, -122.428958416203)
18618 98576 3 21 301X Francisco St 14 1 1 4 2 03/23/2016 02:52:00 PM 3 3x3   6009861.3 2121227.6 37.805042475469605 -122.410124709263 (37.8050424754696, -122.410124709263)
19357 76081 3 21 380 Webster St 7 1 1 4 2 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
19738 30738 3 21 380 Webster St 1 1 1 4 2 01/31/1995 12:00:00 AM 3 3x3 Permit Number 34630 6004189.67673 2109821.80854 37.773405523491995 -122.428938341537 (37.773405523492, -122.428938341537)
61044 57790 3 21 950 Clay St 4 1 1 4 2 02/08/1977 12:00:00 AM 15 4x4 Permit Number 768771 6010215.62504 2117204.00661 37.7940145286904 -122.408614505968 (37.7940145286904, -122.408614505968)
64068 76159 3 21 380 Webster St 10 1 1 4 2 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
92277 76019 3 21 380 Webster St 5 1 1 4 2 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
94595 98794 3 21 950@Washington Clay St 6 1 1 4 2     3x3 Permit Number 768771 6010160.7 2117472.9 37.794749768385294 -122.40882353278799 (37.7947497683853, -122.408823532788)
101631 94927 1 21 325 Sanchez St   1 1 4   12/07/2010 12:00:00 AM   3x3 Permit Number 53976 6003898.0 2106263.7 37.7636193068731 -122.42969346968599 (37.7636193068731, -122.429693469686)
105856 113571 2 21 901 LOMBARD ST 2 1 1 4 2     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247)
108157 113570 2 21 901 LOMBARD ST 1 1 1 4 2     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247)
109492 76051 3 21 380 Webster St 6 1 1 4 2 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
117053 76205 3 21 380 Webster St 12 1 1 4 2 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
117516 98793 3 21 950x CLAY ST 4 1 1 4 2     3x6 Permit Number 768771 6010160.0 2117472.0 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367)
118277 76185 3 21 380 Webster St 11 1 1 4 2 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
121500 42841 3 21 2245 Jones St 4 1 1 4 2 07/03/2000 12:00:00 AM     Permit Number 42773 6008051.69679947 2120116.37092576 37.8018897255523 -122.416308313185 (37.8018897255523, -122.416308313185)
122407 98792 3 21 950 Clay St 9 1 1 4 2 03/16/2012 12:00:00 AM   5x4 Permit Number 768771 6010160.7 2117472.9 37.794749768385294 -122.40882353278799 (37.7947497683853, -122.408823532788)
125879 95271 3 21 2245 Jones St 10 1 1 4 2 03/23/2016 02:36:00 PM 3 6x6   6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
143933 113572 2 21 901 LOMBARD ST 3 1 1 4 2     3x3   6007968.0 2120121.0 37.8018977290678 -122.41659827224701 (37.8018977290678, -122.416598272247)
145283 76112 3 21 380 Webster St 8 1 1 4 2 11/12/1994 12:00:00 AM 4 3x3   6004161.50647736 2110040.16949733 37.7740034947051 -122.42905135835501 (37.7740034947051, -122.429051358355)
145453 95270 3 21 2245 Jones St 9 1 1 4 2 03/23/2016 02:41:00 PM 3     6007968.5 2120121.7 37.801899679212 -122.416596591624 (37.801899679212, -122.416596591624)
Powered by Datasette · Query took 59.132ms · Data source: data.sfgov.org