sf-trees

Data source: data.sfgov.org

Custom SQL query returning 13 rows (hide)

Query parameters

rowidTreeIDqLegalStatusqSpeciesqAddressSiteOrderqSiteInfoPlantTypeqCaretakerqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocation
17282 27708 1 27 720 Shields St 1 1 1 1     6 2X3   5992097.16127 2089870.17428 37.717931565159795 -122.46931519623301 (37.7179315651598, -122.469315196233)
31691 37790 1 27 310 Hamilton St 2 1 1 1 1 07/06/1998 12:00:00 AM 6   Permit Number 40120 6009327.0324 2092792.3248 37.7269357978389 -122.40996501967899 (37.7269357978389, -122.409965019679)
36376 37433 1 27 1419 Cabrillo St 1 1 1 1   06/17/1998 12:00:00 AM 6   Permit Number 39907 5991189.91551 2110613.34906 37.7748344845766 -122.473963672883 (37.7748344845766, -122.473963672883)
47768 35124 1 27 763 Madrid St 1 1 1 1 1 01/28/1998 12:00:00 AM 6   Permit Number 38659 6001796.31519 2089542.9326900002 37.717588753495 -122.43576613121701 (37.717588753495, -122.435766131217)
48088 31195 1 27 260 Saint Charles Ave 1 1 1 1   03/22/1995 12:00:00 AM 6   Permit Number 34888 5992024.42182 2086737.21442 37.7093250109181 -122.469338707216 (37.7093250109181, -122.469338707216)
59492 31354 1 27 2324 14th Ave 1 1 1 1 1 04/21/1995 12:00:00 AM 6   Permit Number 34964 5992033.25034 2099586.3658 37.7446061063992 -122.47024325973 (37.7446061063992, -122.47024325973)
62502 46769 1 27 54 Cotter St 1 1 1 1 1 04/25/2002 12:00:00 AM 6   Permit Number 44865 6002394.404709999 2093228.74941 37.7277431363295 -122.43396212714599 (37.7277431363295, -122.433962127146)
73614 40348 1 27 501 38th Ave 1 1 1 1 1 05/17/1999 12:00:00 AM 6   Permit Number 41478 5984070.03891 2112340.8801599997 37.779162805435 -122.498720071631 (37.779162805435, -122.498720071631)
148538 42630 1 27 2634 Octavia St 1 1 1 1 1 06/26/2000 12:00:00 AM 6   Permit Number 42686 6004473.47116 2118249.9245 37.7965630841803 -122.428557534402 (37.7965630841803, -122.428557534402)
171196 31366 1 27 2475 17th Ave 1 1 1 1 1 04/21/1995 12:00:00 AM 6   Permit Number 34971 5991057.56391 2098576.78296 37.7417775946723 -122.473543328283 (37.7417775946723, -122.473543328283)
172685 95711 1 27 277 Athens St 4 1 1 1 1 09/07/2011 12:00:00 AM 6 3x3 Permit Number 767467 6004408.66119 2091673.84489 37.7235878160995 -122.426888112994 (37.7235878160995, -122.426888112994)
176985 34479 1 27 756 Union St 1 1 1 1 1 07/15/1997 12:00:00 AM 6 2x3 Permit Number 38206 6009344.310190001 2119468.83873 37.800184363566 -122.411789466237 (37.800184363566, -122.411789466237)
183734 35133 1 27 805 Madrid St 1 1 1 1 1 01/28/1998 12:00:00 AM 6   Permit Number 38663 6001614.17085 2089254.80742 37.7167872776758 -122.43637511074101 (37.7167872776758, -122.436375110741)
Powered by Datasette · Query took 78.882ms · Data source: data.sfgov.org