trees

Custom SQL query returning 24 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
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
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
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
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
9465 260400 9 1 190 Parker Ave 4 Sidewalk: Curb side : Cutout Tree 2   08/21/2019 12:00:00 AM 3     5996965.93026 2113053.17261 37.7818664738231 -122.454159603161 (37.7818664738231, -122.454159603161) 11 6 1 54 31
10283 264747 9 36 2002 Pierce St 1 Sidewalk: Curb side : Cutout Tree 2   10/01/2020 12:00:00 AM 3 3x3   6001953.79528 2115381.82831 37.7885451212547 -122.437070707369 (37.7885451212547, -122.437070707369) 13 6 1 29490 27
13028 264748 9 36 2002 Pierce St 2 Sidewalk: Curb side : Cutout Tree 2   10/01/2020 12:00:00 AM 3 3x3   6001953.79528 2115381.82831 37.7885451212547 -122.437070707369 (37.7885451212547, -122.437070707369) 13 6 1 29490 27
15771 259520 9 45 190 Parker Ave 3 Sidewalk: Curb side : Cutout Tree 2   07/23/2019 12:00:00 AM 3     5996965.93026 2113053.17261 37.7818664738231 -122.454159603161 (37.7818664738231, -122.454159603161) 11 6 1 54 31
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
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
18444 259521 9 45 190 Parker Ave 4 Sidewalk: Curb side : Cutout Tree 2   07/23/2019 12:00:00 AM 3     5996965.93026 2113053.17261 37.7818664738231 -122.454159603161 (37.7818664738231, -122.454159603161) 11 6 1 54 31
18936 260399 9 1 190 Parker Ave 3 Sidewalk: Curb side : Cutout Tree 2   08/21/2019 12:00:00 AM 3     5996965.93026 2113053.17261 37.7818664738231 -122.454159603161 (37.7818664738231, -122.454159603161) 11 6 1 54 31
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
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
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
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
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
99316 108440 9 19 105 Lake St   Sidewalk: Curb side : Cutout Tree 2 FUF     3x3   5995179.45913 2114890.0759 37.7868075137311 -122.460473064302 (37.7868075137311, -122.460473064302) 11 6 1 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
149976 104650 9 28 346 LAKE ST   Sidewalk: Curb side : Cutout Tree 2     28 10x8   5994385.6 2114927.2 37.7868637456835 -122.463222305141 (37.7868637456835, -122.463222305141) 11 6 1 54 11
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
171901 82180 9 13 105 Lake St 1 Front Yard : Cutout Tree 2 FUF     3x3 Permit Number 773769 5995179.68463591 2114884.08050195 37.7867910649613 -122.460471849521 (37.7867910649613, -122.460471849521) 11 6 1 54 11
187934 108441 9 19 105 Lake St   Front Yard : Cutout Tree 2 FUF     3x3 Permit Number 773769 5995179.45913 2114890.0759 37.7868075137311 -122.460473064302 (37.7868075137311, -122.460473064302) 11 6 1 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