trees

Custom SQL query returning 26 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
136198 255789 2 6 2240 Washington St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6003983 2116665 37.7921835181407 -122.430141547967 (37.7921835181407, -122.430141547967) 13 9 1 29490 27
2311 256568 2 110 2099X Steiner St 4 Sidewalk: Curb side : Cutout Tree 2       3x3   6002352 2115365 37.7885215412843 -122.435691777518 (37.7885215412843, -122.435691777518) 13 6 1 29490 27
21074 256565 2 110 2099X Steiner St 1 Sidewalk: Curb side : Cutout Tree 2       3x3   6002352 2115365 37.7885215412843 -122.435691777518 (37.7885215412843, -122.435691777518) 13 6 1 29490 27
37738 256569 2 110 2099X Steiner St 5 Sidewalk: Curb side : Cutout Tree 2       3x3   6002352 2115365 37.7885215412843 -122.435691777518 (37.7885215412843, -122.435691777518) 13 6 1 29490 27
49532 256566 2 110 2099X Steiner St 2 Sidewalk: Curb side : Cutout Tree 2       3x3   6002352 2115365 37.7885215412843 -122.435691777518 (37.7885215412843, -122.435691777518) 13 6 1 29490 27
53714 256567 2 110 2099X Steiner St 3 Sidewalk: Curb side : Cutout Tree 2       3x3   6002352 2115365 37.7885215412843 -122.435691777518 (37.7885215412843, -122.435691777518) 13 6 1 29490 27
175873 112198 2 22 2570 Jackson St 2 Sidewalk: Curb side : Cutout Tree 2   10/05/2015 12:00:00 AM 3 3x3 Permit Number 771994 6001873.5131 2116702.41623 37.7921665513862 -122.437443074554 (37.7921665513862, -122.437443074554) 13 6 1 29490 27
99037 253999 2 11 2500 Bush St 1 Sidewalk: Curb side : Cutout Tree 2   12/08/2017 12:00:00 AM 3 3x3 Permit Number 771961 6001313 2114572 37.7862850971301 -122.439229688457 (37.7862850971301, -122.439229688457) 13 6 1 29490 27
119152 5313 2 22 1785 Divisadero St 1 Sidewalk: Curb side : Cutout Tree 2   10/31/2016 12:00:00 AM 3 3X3 Permit Number 770253 6001045 2114480 37.786017234839 -122.440150297316 (37.786017234839, -122.440150297316) 15 6 1 29490 27
162627 35487 2 159 2655 Bush St 2 Sidewalk: Curb side : Cutout Tree 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000866.3431 2114483.9624 37.7860179417845 -122.440768684557 (37.7860179417845, -122.440768684557) 15 6 1 29490 27
982 104688 2 159 2655 Bush St 3 Sidewalk: Curb side : Cutout Tree 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
81956 122427 2 159 2655 Bush St 9 Sidewalk: Curb side : Cutout Tree 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
99982 122422 2 159 2655 Bush St 4 Sidewalk: Curb side : Cutout Tree 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
113221 122425 2 159 2655 Bush St 7 Sidewalk: Curb side : Cutout Tree 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
136423 122426 2 159 2655 Bush St 8 Sidewalk: Curb side : Cutout Tree 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
159819 122424 2 159 2655 Bush St 6 Sidewalk: Curb side : Cutout Tree 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
172560 122428 2 159 2655 Bush St 10 Sidewalk: Curb side : Cutout Tree 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
177350 122423 2 159 2655 Bush St 5 Sidewalk: Curb side : Cutout Tree 2   10/31/2016 12:00:00 AM 3 3x3 Permit Number 770253 6000851.7 2114462.1 37.7859570793449 -122.440817776746 (37.7859570793449, -122.440817776746) 15 6 1 29490 27
55452 35488 2 159 2655 Bush St 1 Sidewalk: Curb side : Cutout Tree 2   10/31/2016 12:00:00 AM 3   Permit Number 770253 6000772.5656 2114469.8149 37.7859737553806 -122.441092113094 (37.7859737553806, -122.441092113094) 15 6 1 29490 27
184280 63407 2 149 2125 Broderick St 1 Sidewalk: Curb side : Cutout Tree 2   12/29/2016 12:00:00 AM 3 3x3 Permit Number 770314 6000344.0086 2116075.34024 37.7903576909945 -122.442690122255 (37.7903576909945, -122.442690122255) 13 6 1 29490 27
36929 256611 2 14 80 Terra Vista Ave 3 Sidewalk: Curb side : Cutout Tree 2   11/07/2018 12:00:00 AM 3 3x3 Permit Number 780481 6000092 2112863 37.7815230689536 -122.443331223004 (37.7815230689536, -122.443331223004) 15 5 1 29490 16
78803 256612 2 14 2375 Ofarrell St 1 Sidewalk: Curb side : Cutout Tree 2   11/07/2018 12:00:00 AM 3 3x3 Permit Number 780481 6000092 2112863 37.7815230689536 -122.443331223004 (37.7815230689536, -122.443331223004) 15 5 1 29490 16
99613 256169 2 14 80 Terra Vista Ave 1 Sidewalk: Curb side : Cutout Tree 2   11/07/2018 12:00:00 AM 3 3x3 Permit Number 780481 6000092 2112863 37.7815230689536 -122.443331223004 (37.7815230689536, -122.443331223004) 15 5 1 29490 16
102847 256610 2 14 80 Terra Vista Ave 2 Sidewalk: Curb side : Cutout Tree 2   11/07/2018 12:00:00 AM 3 3x3 Permit Number 780481 6000092 2112863 37.7815230689536 -122.443331223004 (37.7815230689536, -122.443331223004) 15 5 1 29490 16
16386 262532 2 9 815 Lyon St 1 Sidewalk: Curb side : Cutout Tree 2   08/12/2020 12:00:00 AM 3 4x4 Permit Number 781917 5999987.51846 2111668.14853 37.7782363548085 -122.443606817465 (37.7782363548085, -122.443606817465) 15 5 11 29490 16
157324 32045 2 22 2979 Jackson St 1 Sidewalk: Curb side : Cutout Tree 2   06/07/2018 12:00:00 AM 3   Permit Number 781325 5999951.23823 2116389.65594 37.7911983214916 -122.444071670681 (37.7911983214916, -122.444071670681) 13 6 1 29490 27