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)
62860 32726 1 103 200X Farallones St 7 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 10/29/1996 12:00:00 AM 20 6x9 Permit Number 37116 5995015.41074948 2088495.64250033 37.7143256328225 -122.459128681816 (37.7143256328225, -122.459128681816) 9 8 6 28861 24
27100 92958 7 17 300 Seneca Ave 3 Sidewalk: Curb side : Cutout Tree 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
142685 92960 7 17 300 Seneca Ave 5 Sidewalk: Curb side : Cutout Tree 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
180121 92959 7 17 300 Seneca Ave 4 Sidewalk: Curb side : Cutout Tree 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
189331 92957 7 70 300 Seneca Ave 2 Sidewalk: Curb side : Cutout Tree 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
190901 92956 7 70 300 Seneca Ave 1 Sidewalk: Curb side : Cutout Tree 4   12/23/2009 12:00:00 AM 20 3x3 Permit Number 53118 5999177.1 2091098.3 37.7217103076746 -122.444931280306 (37.7217103076746, -122.444931280306) 9 7 6 28861 25
129944 115551 1 31 925x Minnesota St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   20 18x7   6015277.41921 2104189.44931 37.7585616474178 -122.390190372193 (37.7585616474178, -122.390190372193) 10 3 8 28856 29
68625 96214 1 70 200X Collingwood St 2 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   20 3x3   6002035.7 2104682 37.7591707149085 -122.436021383266 (37.7591707149085, -122.436021383266) 2 4 5 28862 3
69253 72535 1 17 150X Alma St 1 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency 03/21/1992 12:00:00 AM 20 3x3   5997957.39996807 2106223.02713962 37.7631694542329 -122.450237113175 (37.7631694542329, -122.450237113175) 15 5 11 29492 9
33807 113465 4 54 450 CHURCH ST 1 Sidewalk: Curb side : Cutout Tree 4     20 6x6   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
26191 99549 1 27 200X Henry St 3 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   20 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
115483 99554 1 27 200X Henry St 8 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   20 3x3   6002211.6 2107376.8 37.7665799711801 -122.435605827147 (37.7665799711801, -122.435605827147) 15 5 5 28862 3
72163 95154 1 71 250 23rd Ave 10 Sidewalk: Curb side : Cutout Tree 4 DPW for City Agency   20     5988718.8555 2113711.85504 37.7831986719098 -122.48273859805 (37.7831986719098, -122.48273859805) 11 6 2 55 26
123904 98659 7 53 2110 Greenwich St 13 Sidewalk: Curb side : Cutout Tree 4 DPW   20 7x7   6002683.8 2119245.6 37.7991955081761 -122.434821422435 (37.7991955081761, -122.434821422435) 13 9 1 57 17
66275 142545 1 70 301 FRANCISCO ST 7 Sidewalk: Curb side : Cutout Tree 4     20 Width 0ft   6009562.3577 2121186.5007 37.8049128667558 -122.411156332795 (37.8049128667558, -122.411156332795) 3 1 10 308 23
65057 142547 1 70 301 FRANCISCO ST 9 Sidewalk: Curb side : Cutout Tree 4     20 Width 0ft   6009612.5597 2121193.6724 37.8049353736756 -122.410983109438 (37.8049353736756, -122.410983109438) 3 1 10 308 23
8590 142524 1 36 301 FRANCISCO ST 14 Sidewalk: Curb side : Cutout Tree 4   03/23/2016 02:52:00 PM 20 Width 0ft   6009733.2838 2121208.6135 37.8049831671154 -122.410566384357 (37.8049831671154, -122.410566384357) 3 1 10 308 23