trees

Custom SQL query returning 23 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
12188 102373 1 22 870 39th Ave 1 Sidewalk: Curb side : Cutout Tree 5     1     5983890.73069 2109977.48147 37.7726630776505 -122.499165683617 (37.7726630776505, -122.499165683617) 11 6 2 55 26
49590 7378 1 22 1000X Folsom St 2 Sidewalk: Curb side : Cutout Tree 5     45 3X3   6010884.8623 2111505.4176 37.7784050126686 -122.40589724881 (37.7784050126686, -122.40589724881) 14 2 9 28853 34
52190 98423 1 22 1501X Steiner St 7 Sidewalk: Curb side : Cutout Tree 5   01/28/2013 12:00:00 AM   3x3 Permit Number 768629 6002677.2 2113386.1 37.7831064505465 -122.434425094313 (37.7831064505465, -122.434425094313) 13 9 11 29490 41
79505 112131 7 22 850X COLUMBUS AVE 5 Sidewalk: Curb side : Cutout Tree 5     3 3x6   6008928 2120320 37.8024980771426 -122.41329029105 (37.8024980771426, -122.41329029105) 3 1 10 308 23
91265 7382 1 22 1000X Folsom St 6 Sidewalk: Curb side : Cutout Tree 5     60 3X3   6010814.6984 2111439.6909 37.7782206182135 -122.406135341461 (37.7782206182135, -122.406135341461) 14 2 9 28853 34
98712 98434 1 22 1401X Steiner St 9 Sidewalk: Curb side : Cutout Tree 5   01/28/2013 12:00:00 AM   3x3 Permit Number 768629 6002724.9 2113044.1 37.7821701122998 -122.434235614198 (37.7821701122998, -122.434235614198) 15 9 11 29490 41
101404 102516 1 22 1401X Steiner St 2 Sidewalk: Curb side : Cutout Tree 5   01/28/2013 12:00:00 AM   4x4 Permit Number 768629 6002724.9 2113044.1 37.7821701122998 -122.434235614198 (37.7821701122998, -122.434235614198) 15 9 11 29490 41
104845 75258 1 22 288 Eddy St 3 Sidewalk: Curb side : Cutout Tree 5   04/23/2015 04:17:00 PM 3     6009102.38385 2113598.35596 37.7840518741506 -122.412211492867 (37.7840518741506, -122.412211492867) 14 10 9 28852 36
121936 112128 7 22 850X COLUMBUS AVE 2 Sidewalk: Curb side : Cutout Tree 5     3 3x6   6008928 2120320 37.8024980771426 -122.41329029105 (37.8024980771426, -122.41329029105) 3 1 10 308 23
130766 75415 7 22 290 Eddy St 1 Sidewalk: Curb side : Cutout Tree 5   04/23/2015 04:14:00 PM 3     6009037.88726419 2113590.00375699 37.7840253217877 -122.412434037929 (37.7840253217877, -122.412434037929) 14 10 9 28852 36
149555 7377 1 22 1000X Folsom St 1 Sidewalk: Curb side : Cutout Tree 5     45 3X3   6010910.3764 2111530.9317 37.7784764953194 -122.405810783213 (37.7784764953194, -122.405810783213) 14 2 9 28853 34
149960 24950 7 22 2199X Post St 5 Sidewalk: Curb side : Cutout Tree 5   06/22/1998 12:00:00 AM 3 3X3   6001667.0796215 2113903.324382 37.7844692272317 -122.437956753313 (37.7844692272317, -122.437956753313) 13 6 11 29490 13
155217 7379 1 22 1000X Folsom St 3 Sidewalk: Curb side : Cutout Tree 5     45 3X3   6010870.4412 2111489.3325 37.7783600402028 -122.40594600364 (37.7783600402028, -122.40594600364) 14 2 9 28853 34
156162 102375 1 22 870 39th Ave 5 Sidewalk: Curb side : Cutout Tree 5     1     5983887.37527 2110050.49294 37.7728633493226 -122.499182686047 (37.7728633493226, -122.499182686047) 11 6 2 55 26
158540 98435 1 22 1401X Steiner St 10 Sidewalk: Curb side : Cutout Tree 5   01/28/2013 12:00:00 AM   3x3 Permit Number 768629 6002724.9 2113044.1 37.7821701122998 -122.434235614198 (37.7821701122998, -122.434235614198) 15 9 11 29490 41
161077 98422 1 22 1501X Steiner St 6 Sidewalk: Curb side : Cutout Tree 5   01/28/2013 12:00:00 AM   3x3 Permit Number 768629 6002677.2 2113386.1 37.7831064505465 -122.434425094313 (37.7831064505465, -122.434425094313) 13 9 11 29490 41
165276 102374 1 22 870 39th Ave 3 Sidewalk: Curb side : Cutout Tree 5     2     5983888.78905 2110020.99125 37.7727824290992 -122.499175615397 (37.7727824290992, -122.499175615397) 11 6 2 55 26
166192 98432 1 22 1401X Steiner St 7 Sidewalk: Curb side : Cutout Tree 5   01/28/2013 12:00:00 AM   3x3 Permit Number 768629 6002724.9 2113044.1 37.7821701122998 -122.434235614198 (37.7821701122998, -122.434235614198) 15 9 11 29490 41
166253 110046 1 22 288 Eddy St 6 Sidewalk: Curb side : Cutout Tree 5     2     6009043.83179 2113590.50747 37.7840270384566 -122.412413507572 (37.7840270384566, -122.412413507572) 14 10 9 28852 36
172055 112127 7 22 850X COLUMBUS AVE 1 Sidewalk: Curb side : Cutout Tree 5     3 3x6   6008928 2120320 37.8024980771426 -122.41329029105 (37.8024980771426, -122.41329029105) 3 1 10 308 23
174435 112129 7 22 850X COLUMBUS AVE 3 Sidewalk: Curb side : Cutout Tree 5     3 3x6   6008928 2120320 37.8024980771426 -122.41329029105 (37.8024980771426, -122.41329029105) 3 1 10 308 23
187311 7380 1 22 1000X Folsom St 4 Sidewalk: Curb side : Cutout Tree 5     45 3X3   6010853.2469 2111475.4662 37.7783210049209 -122.406004508334 (37.7783210049209, -122.406004508334) 14 2 9 28853 34
189815 112130 7 22 850X COLUMBUS AVE 4 Sidewalk: Curb side : Cutout Tree 5     3 3x6   6008928 2120320 37.8024980771426 -122.41329029105 (37.8024980771426, -122.41329029105) 3 1 10 308 23