trees

Custom SQL query returning 28 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
153301 17587 1 31 801X Persia Ave 11 Sidewalk: Property side : Cutout Tree 1     35 3X3   6003703.48138 2090378.19842 37.7199903588363 -122.429233452259 (37.7199903588363, -122.429233452259) 9 7 6 28861 5
15104 16448 1 31 1395 Newcomb Ave 11 Sidewalk: Curb side : Cutout Tree 1   02/20/2008 12:00:00 AM 12 3x3   6016285.996927 2094866.016739 37.7330173117391 -122.386052291775 (37.7330173117391, -122.386052291775) 10 3 8 58 1
57103 16428 1 31 1390X Newcomb Ave 11 Sidewalk: Curb side : Cutout Tree 1     12 3x3   6016278.230833 2094877.189867 37.7330475611009 -122.386079920066 (37.7330475611009, -122.386079920066) 10 3 8 58 1
47416 255466 1 31 1301X Newcomb Ave 11 Sidewalk: Curb side : Cutout Tree 1       15x200   6016676.72369 2094975.37763 37.7333392118181 -122.384709049297 (37.7333392118181, -122.384709049297) 10 3 8 58 1
116424 97842 1 31 900 Minnesota St 11 Sidewalk: Curb side : Cutout Tree 2     14     6015209.65715 2104398.16252 37.7591309704315 -122.390439309039 (37.7591309704315, -122.390439309039) 10 3 8 28856 29
10327 198443 1 31 500 Mariposa St 11 Sidewalk: Curb side : Cutout Tree 2     3 Width 6ft   6015407.0439 2106284.70526 37.7643219580036 -122.389888423915 (37.7643219580036, -122.389888423915) 14 3 9 310 29
72278 198591 2 31 980 16th St 11 Sidewalk: Curb side : Cutout Tree 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013476.96853 2107132.95858 37.7665438491392 -122.396623526764 (37.7665438491392, -122.396623526764) 14 3 8 28856 20
72725 198658 1 31 1670 Owen St 11 Sidewalk: Property side : Yard Tree 2     3 Width 8ft   6013985.93072 2107349.0106 37.7671653930992 -122.39487823676 (37.7671653930992, -122.39487823676) 14 3 9 310 20
44496 198622 1 31 454 Mission Bay Blvd South 11 Sidewalk: Curb side : Yard Tree 2     4     6015766.21634 2108621.93006 37.7707593807704 -122.388809313913 (37.7707593807704, -122.388809313913) 14 3 9 310 20
60183 198611 1 31 456 Mission Bay Blvd South 11 Sidewalk: Curb side : Yard Tree 2     8     6016143.32489 2108643.38282 37.7708391794209 -122.387506373441 (37.7708391794209, -122.387506373441) 14 3 9 310 20
142267 198637 1 31 419 Mission Bay Blvd North 11 Sidewalk: Curb side : Yard Tree 2     4     6015891.9528 2108749.14049 37.7711156409024 -122.388383265478 (37.7711156409024, -122.388383265478) 14 3 9 310 20
33488 198652 1 31 421 Mission Bay Blvd North 11 Sidewalk: Curb side : Yard Tree 2     8     6016352.81609 2108774.30794 37.7712102720761 -122.386790863815 (37.7712102720761, -122.386790863815) 14 3 9 310 20
119514 246544 1 31 1x Octavia St 11 Median : Yard Tree 1     4 Width 8ft   6005666.89387 2109521.55091 37.7726645918273 -122.42380707794 (37.7726645918273, -122.42380707794) 7 9 11 28852 10
87894 244467 1 31 101x Octavia St 11 Median : Cutout Tree 1     6 Width 0ft   6005631.8918 2109690.1946 37.7731256707262 -122.423940148458 (37.7731256707262, -122.423940148458) 7 9 11 28852 10
129666 244331 1 31 100x Octavia St 11 Median : Cutout Tree 1     6 Width 0ft   6005661.6953 2109906.0133 37.7737199393103 -122.423852403284 (37.7737199393103, -122.423852403284) 7 9 11 28852 10
11729 244288 1 31 201x Octavia St 11 Median : Cutout Tree 1     7 Width 0ft   6005589.8116 2110006.6495 37.7739922036556 -122.424108218812 (37.7739922036556, -122.424108218812) 7 9 11 28852 10
151318 244400 1 31 200x Octavia St 11 Median : Cutout Tree 1     6 Width 0ft   6005615.7803 2110234.2576 37.7746186266053 -122.424034577863 (37.7746186266053, -122.424034577863) 7 9 11 28852 10
85836 244364 1 31 301x Octavia St 11 Median : Cutout Tree 1     8 Width 0ft   6005534.4686 2110345.8041 37.7749203151844 -122.424323786781 (37.7749203151844, -122.424323786781) 7 9 11 28852 10
59252 244309 1 31 300x Octavia St 11 Median : Cutout Tree 1     5 Width 0ft   6005567.5189 2110582.8218 37.7755729745028 -122.424226319105 (37.7755729745028, -122.424226319105) 7 9 11 28852 10
42968 100580 7 31 900 Folsom St 11 Sidewalk: Curb side : Cutout Tree 2           6011458.7 2112074.6 37.7799999312698 -122.403952182873 (37.7799999312698, -122.403952182873) 14 2 9 28853 34
193091 100624 7 31 900 Folsom St 11 Sidewalk: Curb side : Cutout Tree 2           6011458.7 2112074.6 37.7799999312698 -122.403952182873 (37.7799999312698, -122.403952182873) 14 2 9 28853 34
107729 109164 1 31 6x Octavia St Frontage West 11 Median : Cutout Tree 1       3x20   2109337 6005692 47.2698908128932 -138.283860688311 (47.2698908128932, -138.283860688311)          
191150 119756 1 31 101x Octavia St 11 Median : Cutout Tree 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
126141 119803 1 31 201x Octavia St 11 Median : Cutout Tree 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
154 119838 1 31 301x Octavia St 11 Median : Cutout Tree 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
442 119718 1 31 102x Octavia St Frontage East 11 Median : Cutout Tree 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
344 119791 1 31 202x Octavia St Frontage East 11 Median : Cutout Tree 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
89957 119827 1 31 302x Octavia St Frontage East 11 Median : Cutout Tree 1           2110484 6005595 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)