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)
8961 260880 5 11 2395 29th Ave 3 Sidewalk: Curb side : Cutout Tree 2   10/17/2019 12:00:00 AM 3 4x4   5987323.25257 2098992.99273 37.7427034297078 -122.486485729507 (37.7427034297078, -122.486485729507) 1 8 3 29491 35
14443 260878 5 11 2395 29th Ave 1 Sidewalk: Curb side : Cutout Tree 2   10/17/2019 12:00:00 AM 3 4x4   5987323.25257 2098992.99273 37.7427034297078 -122.486485729507 (37.7427034297078, -122.486485729507) 1 8 3 29491 35
18095 260879 5 11 2395 29th Ave 2 Sidewalk: Curb side : Cutout Tree 2   10/17/2019 12:00:00 AM 3 4x4   5987323.25257 2098992.99273 37.7427034297078 -122.486485729507 (37.7427034297078, -122.486485729507) 1 8 3 29491 35
6139 264669 5 297 1890 Church St 2 Sidewalk: Curb side : Cutout Tree 2   09/11/2020 12:00:00 AM 3 4x4 Permit Number 770415 6004581.61952 2097649.26106 37.7400047512279 -122.426715548384 (37.7400047512279, -122.426715548384) 2 7 5 63 7
15098 169494 5 297 1890 Church St 1 Sidewalk: Curb side : Cutout Tree 2   09/11/2020 12:00:00 AM 3 4x4 Permit Number 770415 6004581.61952 2097649.26106 37.7400047512279 -122.426715548384 (37.7400047512279, -122.426715548384) 2 7 5 63 7
4387 264910 5 19 1615 Wallace Ave 1 Front Yard : Cutout Tree 2   11/04/2020 12:00:00 AM 3 4x4 Permit Number 775989 6014687.7877 2092924.6213 37.7275980500808 -122.391442091837 (37.7275980500808, -122.391442091837) 10 3 8 58 1
16257 225172 5 343 248 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree 2   10/08/2020 12:00:00 AM 3 4x4 Permit Number 779647 6006535.62128 2098220.14009 37.7416825381227 -122.419999905071 (37.7416825381227, -122.419999905071) 2 7 7 28859 2
194389 265057 5 11 1190 Mason St 1 Sidewalk: Curb side : Cutout Tree 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590                    
194396 265058 5 11 1190 Mason St 2 Sidewalk: Curb side : Cutout Tree 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590                    
194400 265055 5 11 1085 Washington St 1 Sidewalk: Curb side : Cutout Tree 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590 6009500.70465 2117396.93811 37.794504205778 -122.41110184732 (37.794504205778, -122.41110184732) 3 1 10 28857 21
194401 265056 5 11 1085 Washington St 2 Sidewalk: Curb side : Cutout Tree 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590 6009500.70465 2117396.93811 37.794504205778 -122.41110184732 (37.794504205778, -122.41110184732) 3 1 10 28857 21
194403 265059 5 11 1190 Mason St 3 Sidewalk: Curb side : Cutout Tree 2   12/23/2020 12:00:00 AM 3 4x4 Permit Number 781590                    
16057 167157 5 19 368 Diamond St 1 Sidewalk: Curb side : Cutout Tree 2   11/11/2020 12:00:00 AM 3 4x4 Permit Number 782616 6001774.58914 2103700.91584 37.7564620577863 -122.436854194887 (37.7564620577863, -122.436854194887) 2 4 5 28862 3
9107 264723 5 32 335 Precita Ave 1 Sidewalk: Curb side : Cutout Tree 2   09/18/2020 12:00:00 AM 3 4x4 Permit Number 782646 6008658.96802 2100212.34216 37.7472720863526 -122.412798868954 (37.7472720863526, -122.412798868954) 2 7 7 28859 2
7765 263633 5 146 160 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree 2   09/01/2020 12:00:00 AM 3 4x4 Permit Number 782824 6000235.49843 2104901.88273 37.7596720242526 -122.442263109517 (37.7596720242526, -122.442263109517) 2 4 5 28862 3
8647 146616 5 19 1320 Chestnut St 1 Sidewalk: Curb side : Cutout Tree 2     0 4x4 Permit Number 783073 6005474.41066 2120313.40732 37.8022854748664 -122.425240967805 (37.8022854748664, -122.425240967805) 13 9 1 57 17
11626 262262 5 1 1324 08th Ave 1 Sidewalk: Curb side : Cutout Tree 2   06/19/2020 12:00:00 AM 3 4x4 Permit Number 784290 5993653.14185 2106470.72632 37.763602309694 -122.465141974097 (37.763602309694, -122.465141974097) 1 8 11 56 12
6880 24222 5 78 54 Whitney Young Cir 1 Sidewalk: Curb side : Cutout Tree 2   05/07/2010 12:00:00 AM 3 4x4 this is original dpw basin record. 6017205.2608 2094992.48681 37.7334154068844 -122.382882921904 (37.7334154068844, -122.382882921904) 10 3 8 58 1