trees

Custom SQL query returning 18 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
1462 225196 2 116 3160 21st St 3 Sidewalk: Curb side : Cutout Tree 2     9 3x3 Permit Number 778605 6007182.851 2103832.80652 37.7571300930895 -122.418159821127 (37.7571300930895, -122.418159821127) 2 4 7 28859 19
1902 261997 2 27 607X Florida St 3 Sidewalk: Curb side : Cutout Tree 2   04/07/2020 12:00:00 AM 3 4x4 Permit Number 780566 6009282 2105415 37.7615923672124 -122.411011879772 (37.7615923672124, -122.411011879772) 2 4 7 28859 19
2941 261590 2 11 299x 14th St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6006795 2107850 37.7681385292637 -122.41978620049 (37.7681385292637, -122.41978620049) 8 4 7 28853 19
3713 225189 2 116 580 Capp St 3 Sidewalk: Curb side : Cutout Tree 2     10 3x3 Permit Number 778605 6007240 2103949 37.7574523501876 -122.417970414127 (37.7574523501876, -122.417970414127) 2 4 7 28859 19
10960 166315 2 32 2600 Harrison St 3 Sidewalk: Curb side : Cutout Tree 2   07/29/2019 12:00:00 AM 3 10x4 Permit Number 779829 6008872.21502 2103120.32489 37.7552687230844 -122.412266973836 (37.7552687230844, -122.412266973836) 2 4 7 28859 19
11620 260954 2 92 1296 Shotwell St 3 Sidewalk: Curb side : Cutout Tree 2       4x8   6008013 2100716 37.7486187391462 -122.4150682294 (37.7486187391462, -122.4150682294) 2 4 7 28859 19
15819 151746 2 1 3030 17th St 3 Sidewalk: Curb side : Cutout Tree 2   12/28/2016 12:00:00 AM 3 3x3 Permit Number 779245 6008502.96204 2106251.6003 37.763845762487 -122.413765441348 (37.763845762487, -122.413765441348) 8 4 7 28859 19
46028 152812 2 36 2901 25th St 3 Sidewalk: Curb side : Cutout Tree 2   09/18/2017 12:00:00 AM 3 6x6 Permit Number 777487 6010002.42353 2101608.75594 37.7511816461268 -122.408251752714 (37.7511816461268, -122.408251752714) 2 4 7 28859 19
72715 44010 2 50 405x Florida St 3 Sidewalk: Curb side : Cutout Tree 2   01/05/2016 12:00:00 AM   3x3 Permit Number 775718 6009464.30573862 2106385.10315991 37.7642662704227 -122.410449858863 (37.7642662704227, -122.410449858863) 8 4 7 28859 19
101909 122699 2 22 98 Woolsey St 3 Sidewalk: Curb side : Cutout Tree 2   11/16/2016 12:00:00 AM 3 3x3   6011441.99272 2092150.08828 37.725290657742 -122.402608459524 (37.725290657742, -122.402608459524) 10 3 7 309 28
107596 151878 2 8 1450 15th St 3 Sidewalk: Curb side : Cutout Tree 2   10/31/2017 12:00:00 AM 3 3x4 Permit Number 775137 6007623.77597 2107385.08821 37.7669086438472 -122.416886599646 (37.7669086438472, -122.416886599646) 8 4 7 28853 19
112949 244834 2 36 1875 Mission St 3 Sidewalk: Curb side : Cutout Tree 1   12/02/2017 12:00:00 AM 3 Width 3ft   6006796.01232 2107481.11788 37.7671257231045 -122.419756521569 (37.7671257231045, -122.419756521569) 8 4 7 28853 19
125934 256878 2 51 3098 26th St 3 Sidewalk: Curb side : Cutout Tree 2   04/23/2019 12:00:00 AM 3 3x3 Permit Number 782654 6009121.70897 2101021.23838 37.7495190982493 -122.411255871462 (37.7495190982493, -122.411255871462) 2 4 7 28859 19
128791 247940 2 146 29 Joy St 3 Unaccepted Street : Yard Tree 1     5   Permit Number 775404 6010280.31746 2098909.28814 37.7437850559498 -122.407100501782 (37.7437850559498, -122.407100501782) 2 7 7 28859 2
158751 115978 2 13 2x Olmstead St 3 Sidewalk: Curb side : Cutout Tree 2     1 3x3   6011623.9012 2091244.95295 37.7228154963084 -122.40191601721 (37.7228154963084, -122.40191601721) 10 3 7 309 28
163013 115504 2 40 2901 25th St 3 Sidewalk: Curb side : Cutout Tree 2   02/05/2016 12:00:00 AM 3 3x3 Permit Number 777487 6010040.72394239 2101604.72592715 37.7511727251881 -122.408119020981 (37.7511727251881, -122.408119020981) 2 4 7 28859 19
169946 187675 2 9 2690 Harrison St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6008898.65774693 2102801.94608421 37.7543960104367 -122.41215302657 (37.7543960104367, -122.41215302657) 2 4 7 28859 19
176471 252908 2 36 600 South Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree 2   06/26/2017 12:00:00 AM 3 3x3 Permit Number 777588 6007451.05071 2106154.24093 37.7635193076139 -122.417396792879 (37.7635193076139, -122.417396792879) 8 4 7 28859 19