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)
34431 256554 8 75 3401X 16th St 3 Side Yard : Yard Tree 4   02/08/2019 09:10:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
43580 33793 8 19 200x Mission St 11 Sidewalk: Curb side : Cutout Tree 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
48396 109097 8 14 601 29th St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 774331 6002630.6 2098839.9 37.7431634703749 -122.43354642925 (37.7431634703749, -122.43354642925) 2 7 5 63 7
54368 33775 8 19 200x Mission St 2 Sidewalk: Curb side : Cutout Tree 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
55834 121404 8 155 1900 08th Ave 1 Back Yard : Yard Tree 2     3 10x10   5993817 2102486 37.7526707300666 -122.464285931649 (37.7526707300666, -122.464285931649) 1 8 4 29491 40
62239 33794 8 19 200x Mission St 13 Sidewalk: Curb side : Cutout Tree 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
71205 33789 8 19 200x Mission St 7 Sidewalk: Curb side : Cutout Tree 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
90011 256555 8 75 3401X 16th St 4 Side Yard : Yard Tree 4   02/08/2019 08:48:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
90477 109091 8 250 4235 23rd St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773805 6001611.4 2102294.1 37.7525900037408 -122.43731782876 (37.7525900037408, -122.43731782876) 2 4 5 28862 22
91079 33787 8 19 200x Mission St 5 Sidewalk: Curb side : Cutout Tree 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
106561 97238 8 9 125 Excelsior Ave 1 Sidewalk: Property side : Yard Tree 4 FUF 09/07/2011 12:00:00 AM 3 3x3 Permit Number 767513 6002911 2092621.3 37.7261045201699 -122.432132888294 (37.7261045201699, -122.432132888294) 9 7 6 28861 5
106981 109092 8 40 237 28th St 1 Sidewalk: Curb side : Cutout Tree 2 FUF 01/27/2015 12:00:00 AM 3 3x3 Permit Number 773766 6004335.1 2099509.2 37.7450977767532 -122.427700396282 (37.7450977767532, -122.427700396282) 2 7 5 63 22
140802 33786 8 19 200x Mission St 4 Sidewalk: Curb side : Cutout Tree 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
163103 33791 8 19 200x Mission St 9 Sidewalk: Curb side : Cutout Tree 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
167692 33790 8 19 200x Mission St 8 Sidewalk: Curb side : Cutout Tree 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
175776 256557 8 75 3401X 16th St 6 Side Yard : Yard Tree 4   02/08/2019 08:44:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
176971 256553 8 75 3401X 16th St 2 Side Yard : Yard Tree 4   02/08/2019 09:24:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3
185435 33788 8 19 200x Mission St 6 Sidewalk: Curb side : Cutout Tree 2   01/05/2015 12:00:00 AM 3 3x3 Permit Number 770804 6014138 2116340 37.7918610639158 -122.394982044679 (37.7918610639158, -122.394982044679) 12 2 9 28855 6
189291 256552 8 75 3401X 16th St 1 Side Yard : Yard Tree 4   02/08/2019 08:54:00 AM 3 3x3   6004088 2106523 37.7643420392989 -122.429054808288 (37.7643420392989, -122.429054808288) 8 4 5 28862 3