sf-trees

Data source: data.sfgov.org

Custom SQL query returning 25 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
142332 95517 2 51 600X 32nd Ave 3 1 1 4     10 3x3   5985993.99278 2111923.13747 37.778128454962 -122.49203365493601 (37.778128454962, -122.492033654936)
123561 95485 2 51 600X 32nd Ave 13 1 1 4     10 3x3   5986006.6183 2111569.83262 37.777159118639496 -122.49196396094601 (37.7771591186395, -122.491963960946)
83999 26042 1 51 32 Broad St 11 1 1 1   03/19/2003 12:00:00 AM 10 3X3   5996190.731819999 2088089.91613 37.7132791004475 -122.455037033861 (37.7132791004475, -122.455037033861)
159162 219449 2 51 339 Detroit St 3 1 1 1     10 Width 3ft   5999411.789580001 2094299.60071 37.7305137290122 -122.444349966799 (37.7305137290122, -122.444349966799)
147132 68240 1 51 3235 Divisadero St 1 1 1 1 1 08/09/1993 12:00:00 AM 10   Permit Number 32038 6000367.65651 2119408.48932 37.799510988101396 -122.442847752719 (37.7995109881014, -122.442847752719)
168983 68254 1 51 3835 Scott St 1 1 1 1 1 08/09/1993 12:00:00 AM 10   Permit Number 32056 6000569.04912 2121537.58273 37.8053683895105 -122.44230379238199 (37.8053683895105, -122.442303792382)
144893 117180 2 51 8 KNOTT CT 1 1 1 1     10 3x3   6000120.0 2086463.0 37.7090365866676 -122.44133950250601 (37.7090365866676, -122.441339502506)
52023 68238 1 51 290 Avila St 1 1 1 1 1 08/09/1993 12:00:00 AM 10   Permit Number 32036 6000949.5088599995 2120925.17442 37.8037085566624 -122.440943204485 (37.8037085566624, -122.440943204485)
184089 180430 2 51 122 Ocean Ave 1 1 1 1     10 Width 3ft   6000838.328869999 2091757.95651 37.723616244584704 -122.43923612035299 (37.7236162445847, -122.439236120353)
92825 25288 3 51 110X Ocean Ave 1 1 1 2   05/06/1996 12:00:00 AM 10 3x3   6000890.43944 2091777.01619 37.7236715433472 -122.43905734896299 (37.7236715433472, -122.439057348963)
27006 35019 1 51 27 Alhambra St 1 1 1 1   12/29/1997 12:00:00 AM 10   Permit Number 38594 6001880.48988 2120550.7716599996 37.8027335251878 -122.437694670695 (37.8027335251878, -122.437694670695)
37559 35018 1 51 15 Alhambra St 1 1 1 1   12/29/1997 12:00:00 AM 10   Permit Number 38593 6001898.27273 2120571.24867 37.8027907607435 -122.437634600462 (37.8027907607435, -122.437634600462)
148867 44382 1 51 1257 Athens St 1 1 1 1 1 03/22/2001 12:00:00 AM 10   Permit Number 43744 6001457.21112 2087559.6242799999 37.71212376138379 -122.43679636128901 (37.7121237613838, -122.436796361289)
76747 69489 1 51 675 Cayuga Ave 1 1 1 1 1 05/24/1994 12:00:00 AM 10   Permit Number 33611 6001629.6307 2093134.5419700001 37.7274410333571 -122.436599219094 (37.7274410333571, -122.436599219094)
26966 70402 2 51 212 Oxford St 1 1 1 1 1 05/21/1994 12:00:00 AM 10     6006462.64225 2092921.27798 37.727128920939606 -122.419876323835 (37.7271289209396, -122.419876323835)
162109 70404 2 51 218 Oxford St 1 1 1 1 1 05/21/1994 12:00:00 AM 10     6006477.26442 2092881.04144 37.7270192639056 -122.41982292118601 (37.7270192639056, -122.419822921186)
50620 180458 2 51 599 University St 26 1 1 1     10 Width 3ft   6008265.9310099995 2092323.59976 37.725589251032 -122.41360010007901 (37.725589251032, -122.413600100079)
23892 180452 2 51 599 University St 20 1 1 1     10 Width 4ft   6008393.709980001 2091906.0725900002 37.724449984452704 -122.413128866997 (37.7244499844527, -122.413128866997)
48947 180450 2 51 599 University St 18 1 1 1     10 Width 4ft   6008413.5895 2091843.5213400002 37.7242793479848 -122.413055725159 (37.7242793479848, -122.413055725159)
112572 45297 1 51 608 Prentiss St 1 1 1 1 1 06/12/2001 12:00:00 AM 10 2x3 Permit Number 44137 6008675.13295434 2095998.82519754 37.7357036012205 -122.412445185237 (37.7357036012205, -122.412445185237)
46135 180483 2 51 321 Silliman St 1 1 1 1     10 Width 3ft   6009804.862930001 2094010.61906 37.7303077455958 -122.40839905808998 (37.7303077455958, -122.40839905809)
67824 198414 2 51 3310 Jennings St 1 1 1 1     10 Width 3ft   6013355.178590001 2089895.60565 37.71920692974621 -122.39583681063299 (37.7192069297462, -122.395836810633)
15030 101775 1 51 1700 Yosemite Ave 2 1 1 1 1   10 3x3 Permit Number 19103 6014052.75296 2093112.8912 37.728079734566606 -122.393650601914 (37.7280797345666, -122.393650601914)
13359 99591 1 51 1855X Evans Ave 4 1 1 1   12/27/2012 12:00:00 AM 10 3x3 Permit Number 769738 6014314.47679 2099474.93569 37.745563139741996 -122.39319079741301 (37.745563139742, -122.393190797413)
15099 99592 2 51 1855X Evans Ave 5 1 1 1     10 3x3   6014373.22453 2099430.50237 37.7454443986533 -122.392984546922 (37.7454443986533, -122.392984546922)
Powered by Datasette · Query took 15.718ms · Data source: data.sfgov.org