trees

Custom SQL query returning 17 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
11856 107887 1 22 941 Washington St 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
58584 57790 1 19 950 Clay St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 02/08/1977 12:00:00 AM 15 4x4 Permit Number 768771 6010215.62504 2117204.00661 37.7940145286904 -122.408614505968 (37.7940145286904, -122.408614505968) 3 1 10 28857 4
84271 98794 1 19 950@Washington Clay St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x3 Permit Number 768771 6010160.7 2117472.9 37.7947497683853 -122.408823532788 (37.7947497683853, -122.408823532788) 3 1 10 28857 4
99627 107884 1 22 941 Washington St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x3   6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
104181 98790 1 40 950x CLAY ST 5 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x3 Permit Number 768771 6010160 2117472 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367) 3 1 10 28857 4
114301 98806 1 22 950x CLAY ST 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x3 Permit Number 768771 6010160 2117472 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367) 3 1 10 28857 4
121110 98804 1 22 950x Clay St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/16/2012 12:00:00 AM 2 3x3 Permit Number 768771 6010297.35863 2117215.00262 37.7940492982967 -122.408332474088 (37.7940492982967, -122.408332474088) 3 1 10 28857 4
122492 107885 1 22 941 Washington St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x3   6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
130969 116857 1 22 950x Clay St 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   2 3x3   6010080.35093 2117187.65635 37.793962057763 -122.409081415981 (37.793962057763, -122.409081415981) 3 1 10 28857 4
153795 98792 1 19 950 Clay St 9 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/16/2012 12:00:00 AM   5x4 Permit Number 768771 6010160.7 2117472.9 37.7947497683853 -122.408823532788 (37.7947497683853, -122.408823532788) 3 1 10 28857 4
157895 98793 1 19 950x CLAY ST 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency     3x6 Permit Number 768771 6010160 2117472 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367) 3 1 10 28857 4
163523 107883 1 22 941 Washington St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency         6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
169090 98805 1 22 950x Clay St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/16/2012 12:00:00 AM 1 3x3 Permit Number 768771 6010143.10639 2117195.10642 37.793986029186 -122.408864800763 (37.793986029186, -122.408864800763) 3 1 10 28857 4
170083 98803 1 22 950x Clay St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/16/2012 12:00:00 AM   3x3 Permit Number 768771 6010160.7 2117472.9 37.7947497683853 -122.408823532788 (37.7947497683853, -122.408823532788) 3 1 10 28857 4
171481 107886 1 22 941 Washington St 4 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 11/03/2014 12:00:00 AM 3 3x3 Permit Number 771772 6010165.08902 2117347.11602 37.7944046419585 -122.40879946772 (37.7944046419585, -122.40879946772) 3 1 10 28857 4
179485 98802 1 22 950x CLAY ST 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/16/2012 12:00:00 AM   3x3 Permit Number 768771 6010160 2117472 37.7947472579955 -122.408825891367 (37.7947472579955, -122.408825891367) 3 1 10 28857 4
188988 98791 1 22 950 Clay St 6 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   1 3x6 Permit Number 768771 6010164.1906 2117196.54488 37.7939911598214 -122.408791948484 (37.7939911598214, -122.408791948484) 3 1 10 28857 4