sf-trees

Data source: data.sfgov.org

Custom SQL query returning 23 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
10587 27191 1 20 270 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 2X3   6002970.12798 2093687.91706 37.729036562883 -122.43200461784299 (37.729036562883, -122.432004617843)
10609 27189 1 20 262 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 2X3   6002929.54622 2093714.9160799999 37.729108395319706 -122.432146839331 (37.7291083953197, -122.432146839331)
10716 27187 1 20 250 Silver Ave 1 1 1 1   11/25/2002 12:00:00 AM 6 2X3   6002862.24087 2093754.97277 37.7292145657007 -122.43238237894501 (37.7292145657007, -122.432382378945)
11427 27057 3 20 945 Silver Ave 1 1 1 2   06/25/1999 12:00:00 AM 7 2X3   6007415.89764 2093543.05958 37.72888985646029 -122.416624950003 (37.7288898564603, -122.416624950003)
11796 27192 1 20 284 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 2X3   6003080.50306 2093615.49168 37.7288439559672 -122.431617874266 (37.7288439559672, -122.431617874266)
12304 27185 1 20 238 Silver Ave 1 1 1 1   06/08/1999 12:00:00 AM 6 2X3   6002801.11945 2093793.8954 37.7293179724305 -122.43259645987101 (37.7293179724305, -122.432596459871)
12742 27190 3 20 266 Silver Ave 1 1 1 2   06/08/1999 12:00:00 AM 6 2X3   6002951.03979 2093700.24177 37.729069321573604 -122.432071486902 (37.7290693215736, -122.432071486902)
13949 27171 1 20 2206 Silver Ave 1 1 1 1   07/12/1999 12:00:00 AM 6 2X3   6012761.81609 2096197.8088200002 37.7364784617996 -122.398329801495 (37.7364784617996, -122.398329801495)
13978 27170 1 20 2080 Silver Ave 2 1 1 1   06/16/1999 12:00:00 AM 6 2X3   6012569.10474 2096085.04169 37.7361580900166 -122.398988178079 (37.7361580900166, -122.398988178079)
14432 27132 1 20 2009 Silver Ave 1 1 1 1   02/19/2004 12:00:00 AM 3 2X3   6012226.6815599995 2095938.3676200002 37.735736266604704 -122.40016178436501 (37.7357362666047, -122.400161784365)
14967 27136 1 20 1909 Silver Ave 1 1 1 1   07/13/1999 12:00:00 AM 7 2X3   6011799.55776 2095649.995 37.734920630966 -122.40161826426599 (37.734920630966, -122.401618264266)
15016 27146 3 20 1751 Silver Ave 3 1 1 2   05/19/1999 12:00:00 AM 3 2X3   6011294.03802 2095268.15566 37.7338439590333 -122.403339179952 (37.7338439590333, -122.403339179952)
15119 27174 1 20 2300X Silver Ave 2 1 1 1   06/16/1999 12:00:00 AM 6 2X3   6013069.06083 2096365.0106900001 37.7369546735192 -122.397279240461 (37.7369546735192, -122.397279240461)
15299 27175 1 20 2300X Silver Ave 3 1 1 1   06/16/1999 12:00:00 AM 6 2X3   6013102.951669999 2096377.5356599998 37.736990951255706 -122.397162941913 (37.7369909512557, -122.397162941913)
15540 27131 1 20 2015 Silver Ave 1 1 1 1   06/16/1999 12:00:00 AM 6 2X3   6012250.55523 2095951.9003599999 37.735774755805295 -122.400080193368 (37.7357747558053, -122.400080193368)
16365 27145 1 20 1751 Silver Ave 2 1 1 1   05/19/1999 12:00:00 AM 3 2X3   6011315.84096 2095284.6201400002 37.7338903847377 -122.40326495802499 (37.7338903847377, -122.403264958025)
17274 22551 1 20 33 Topaz Way 1 1 1 1   06/03/1992 12:00:00 AM 20 2X3   6001555.699019999 2098568.2188 37.74235645138 -122.437243695762 (37.74235645138, -122.437243695762)
86882 27082 1 20 799X Silver Ave 4 1 1 1   12/08/2000 12:00:00 AM 6 2X3   6006577.59669 2093640.7294700001 37.7291108536609 -122.419529947915 (37.7291108536609, -122.419529947915)
89646 27087 1 20 743X Silver Ave 2 1 1 1   06/26/1999 12:00:00 AM 6 2X3   6006221.2435099995 2093597.03752 37.7289708064437 -122.420758791245 (37.7289708064437, -122.420758791245)
94844 27167 1 20 1970 Silver Ave 1 1 1 1   06/16/1999 12:00:00 AM 6 2X3   6011914.946409999 2095658.54752 37.734950552546394 -122.401219923596 (37.7349505525464, -122.401219923596)
100453 27079 3 20 799X Silver Ave 1 1 1 2   06/26/1999 12:00:00 AM 8 2X3   6006577.59669 2093640.7294700001 37.7291108536609 -122.419529947915 (37.7291108536609, -122.419529947915)
122819 27088 1 20 743X Silver Ave 3 1 1 1   06/26/1999 12:00:00 AM 6 2X3   6006210.7557 2093597.31773 37.728970984710294 -122.42079506833099 (37.7289709847103, -122.420795068331)
124216 27086 1 20 743X Silver Ave 1 1 1 1   06/26/1999 12:00:00 AM 6 2X3   6006263.01382 2093613.9745099999 37.7290196659204 -122.42061558974702 (37.7290196659204, -122.420615589747)
Powered by Datasette · Query took 9.248ms · Data source: data.sfgov.org