trees

Custom SQL query returning 19 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
163797 198485 1 31 900 Minnesota St 4 Sidewalk: Curb side : Yard Tree 2     9 Width 6ft   6015200.26669 2104562.53753 37.7595817879946 -122.3904832715 (37.7595817879946, -122.3904832715) 10 3 8 28856 29
164216 98273 7 31 990X York St 4 Sidewalk: Curb side : Cutout Tree 2 FUF 01/20/2012 12:00:00 AM   within landscaping plot Permit Number 768491 6009943.7 2103445.2 37.7562208239384 -122.408584359698 (37.7562208239384, -122.408584359698) 2 4 7 28859 19
170637 141787 1 31 1461 Ellis St 4 Sidewalk: Curb side : Cutout Tree 2     13 Width 0ft   6003867.7567 2113170.8508 37.7825829380566 -122.430290891107 (37.7825829380566, -122.430290891107) 7 9 11 29490 41
172477 198615 1 31 454 Mission Bay Blvd South 4 Sidewalk: Curb side : Yard Tree 2     5     6015921.38849 2108631.46904 37.7707941719296 -122.388273231625 (37.7707941719296, -122.388273231625) 14 3 9 310 20
173965 137008 1 31 2110 Broderick St 4 Sidewalk: Curb side : Cutout Tree 2     18 Width 4ft   6000406.08095 2115938.23713 37.7899847799168 -122.44246550939 (37.7899847799168, -122.44246550939) 13 6 1 29490 27
174939 198566 1 31 400 01st St 4 Sidewalk: Curb side : Yard Tree 2     7 Width 6ft   6014751.35168 2114157.00483 37.785901149169 -122.392707049386 (37.785901149169, -122.392707049386) 6 2 9 28855 6
176701 11878 7 31 1501X Junipero Serra Blvd 4 Sidewalk: Curb side : Cutout Tree 8     18 3X3   5991566.1252788 2087212.7603742 37.7106042506249 -122.470957258061 (37.7106042506249, -122.470957258061) 9 8 4 64 24
177447 31075 1 31 1700X 15th St 4 Sidewalk: Curb side : Cutout Tree 2 FUF 03/21/1995 12:00:00 AM 7   Permit Number 34816 6005979.98097 2107292.47987 37.7665617645507 -122.422565649286 (37.7665617645507, -122.422565649286) 8 4 5 28853 19
178759 198685 1 31 145 08th St 4 Sidewalk: Curb side : Cutout Tree 2     10 Width 4ft   6009031.35533 2110985.92555 37.7768747760941 -122.412272520887 (37.7768747760941, -122.412272520887) 8 2 9 28853 34
180678 119831 1 31 301x Octavia St 4 Median : Cutout Tree 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
181698 198507 1 31 701 Rhode Island St 4 Sidewalk: Property side : Yard Tree 2     11 Width 6ft   6011858.82974 2105091.40426 37.7608480082603 -122.402076874465 (37.7608480082603, -122.402076874465) 10 3 8 28856 29
184046 46506 7 31 165 08th St 4 Sidewalk: Curb side : Cutout Tree 2   03/27/2002 12:00:00 AM     Permit Number 44676 6009030.30482136 2110979.07994252 37.7768559207247 -122.412275670972 (37.7768559207247, -122.412275670972) 8 2 9 28853 34
187128 23644 7 31 197 Virginia Ave 4 Sidewalk: Curb side : Cutout Tree 2   04/07/2005 12:00:00 AM 8 3X3   6006643.75963 2098486.48829 37.7424199625796 -122.41964489142 (37.7424199625796, -122.41964489142) 2 7 7 28859 2
188233 109165 4 31 51x OCTAVIA ST 4 Median : Cutout Tree 1       3x20   6005650.4 2109419.7 37.772384002649 -122.423856888434 (37.772384002649, -122.423856888434) 7 9 11 28852 10
188402 180550 1 31 200 Persia Ave 4 Sidewalk: Curb side : Cutout Tree 2     13 Width 3ft   6002268.14618 2091228.59703 37.7222440023296 -122.434255671279 (37.7222440023296, -122.434255671279) 9 7 6 28861 5
189071 97835 7 31 900 Minnesota St 4 Sidewalk: Curb side : Cutout Tree 2           6015215.2 2103967.9 37.757949869225 -122.390390076491 (37.757949869225, -122.390390076491) 10 3 8 28856 29
189386 137009 1 31 3099 Washington St 4 Sidewalk: Curb side : Cutout Tree 2     3 Width 4ft   5999994.90207 2116065.86366 37.7903117635268 -122.443897321805 (37.7903117635268, -122.443897321805) 13 6 1 29490 27
189918 31036 1 31 300 Bennington St 4 Sidewalk: Curb side : Cutout Tree 2   12/23/2015 12:00:00 AM 2   Permit Number 771782 6007053.24421 2096706.03657 37.7375542956049 -122.418102817609 (37.7375542956049, -122.418102817609) 2 7 7 28859 2
190593 244374 1 31 101x Octavia St 4 Median : Cutout Tree 1     7 Width 0ft   6005614.0781 2109847.0914 37.7735554657504 -122.424012927889 (37.7735554657504, -122.424012927889) 7 9 11 28852 10