trees

Custom SQL query returning 14 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
23696 108446 9 1 672 05th Ave   Sidewalk: Curb side : Cutout Tree 2 FUF     3x3 Permit Number 773773 5994431.81479 2110948.53978 37.7759420777365 -122.462773673163 (37.7759420777365, -122.462773673163) 11 6 2 54 11
65512 108459 9 13 771 11th Ave   Sidewalk: Curb side : Cutout Tree 2 FUF     3x3 Permit Number 773786 5992558.08669 2110211.94426 37.7738114893979 -122.469201704334 (37.7738114893979, -122.469201704334) 11 6 2 54 11
141599 251417 9 56 418 19th Ave 1 Sidewalk: Curb side : Cutout Tree 3       3x3   5990003 2112517 37.7799925618685 -122.478208632121 (37.7799925618685, -122.478208632121) 11 6 2 55 26
170397 36938 9 14 351 11th Ave 1 Sidewalk: Curb side : Cutout Tree 2   02/06/2015 12:00:00 AM 3 3x3 Permit Number 774744 5992449.52236815 2113091.823439 37.781712581861 -122.469786951776 (37.781712581861, -122.469786951776) 11 6 2 54 11
190320 72375 9 2 4299X Fulton St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 03/09/1996 12:00:00 AM   3x3 Permit Number 773790 5990099.63678033 2109979.56687008 37.773031079694 -122.477688796337 (37.773031079694, -122.477688796337) 11 6 2 55 26
54959 258601 9 45 682 12th Ave 1 Sidewalk: Property side : Cutout Landscaping 2   05/29/2019 12:00:00 AM 3 9X2   5992266.47414 2110804.58144 37.7754218561197 -122.470253595146 (37.7754218561197, -122.470253595146) 11 6 2 54 11
85052 258602 9 45 682 12th Ave 1 Sidewalk: Curb side : Cutout Landscaping 2   05/29/2019 12:00:00 AM 3 8X4   5992266.47414 2110804.58144 37.7754218561197 -122.470253595146 (37.7754218561197, -122.470253595146) 11 6 2 54 11
8224 254835 9 31 250 21st Ave 1 Sidewalk: Curb side : Cutout Tree 2 FUF 08/28/2019 12:00:00 AM 3 4x3 Permit Number 784635 5989365 2113673 37.7831295589045 -122.480500378386 (37.7831295589045, -122.480500378386) 11 6 2 55 26
17787 264681 9 19 840 42nd Ave 1 Sidewalk: Curb side : Cutout Tree 2   09/11/2020 12:00:00 AM 3   Permit Number 785486 5982954.56765 2110060.16253 37.7728351334222 -122.502410039067 (37.7728351334222, -122.502410039067) 11 6 2 55 26
2685 264708 9 67 4345 Clement St 4 Sidewalk: Property side : Cutout Tree 2   09/17/2020 12:00:00 AM 3     5982064.28374 2113052.50483 37.7809988756405 -122.505711450059 (37.7809988756405, -122.505711450059) 11 6 2 55 26
8242 264706 9 6 4345 Clement St 2 Sidewalk: Curb side : Cutout Tree 2   09/17/2020 12:00:00 AM 3     5982064.28374 2113052.50483 37.7809988756405 -122.505711450059 (37.7809988756405, -122.505711450059) 11 6 2 55 26
17698 264705 9 6 4345 Clement St 1 Sidewalk: Curb side : Cutout Tree 2   09/17/2020 12:00:00 AM 3     5982064.28374 2113052.50483 37.7809988756405 -122.505711450059 (37.7809988756405, -122.505711450059) 11 6 2 55 26
19591 264707 9 67 4345 Clement St 3 Sidewalk: Property side : Cutout Tree 2   09/17/2020 12:00:00 AM 3     5982064.28374 2113052.50483 37.7809988756405 -122.505711450059 (37.7809988756405, -122.505711450059) 11 6 2 55 26
60 264971 9 31 150 17th Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/25/2020 12:00:00 AM 3     5990555.23468 2114396.47455 37.7851851170506 -122.476435559205 (37.7851851170506, -122.476435559205) 11 6 2 54 26