trees

Custom SQL query returning 20 rows (hide)

Query parameters

This data as json, CSV

rowidTreeIDqLegalStatus_idqSpecies_idqAddressSiteOrderqSiteInfoPlantTypeqCaretaker_idqCareAssistantPlantDateDBHPlotSizePermitNotesXCoordYCoordLatitudeLongitudeLocationFire Prevention DistrictsPolice DistrictsSupervisor DistrictsZip CodesNeighborhoods (old)
1742 28048 7 148 1800 The Embarcadero 4 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
9221 28049 7 148 1800 The Embarcadero 5 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
52938 28045 7 148 1800 The Embarcadero 1 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
63150 28050 7 148 1800 The Embarcadero 6 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
69024 28053 7 148 1800 The Embarcadero 9 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
69445 28047 7 148 1800 The Embarcadero 3 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
79601 28046 7 148 1800 The Embarcadero 2 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
135463 28055 7 148 1800 The Embarcadero 11 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
152629 28052 7 148 1800 The Embarcadero 8 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
172485 28054 7 148 1800 The Embarcadero 10 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
183471 28051 7 148 1800 The Embarcadero 7 Sidewalk: Curb side : Cutout Tree 6   02/05/2001 12:00:00 AM 12 3X3   6008269.10023 2122669.55539 37.808912348093 -122.41573688061 (37.808912348093, -122.41573688061) 3 1 10 308 23
8152 116289 4 148 1901X Powell St 5 Sidewalk: Curb side : Cutout Tree 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
45892 116291 4 148 1901X Powell St 7 Sidewalk: Curb side : Cutout Tree 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
56128 116290 4 148 1901X Powell St 6 Sidewalk: Curb side : Cutout Tree 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
68754 116286 4 148 1901X Powell St 2 Sidewalk: Curb side : Cutout Tree 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
83891 116287 4 148 1901X Powell St 3 Sidewalk: Curb side : Cutout Tree 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
86603 116285 4 148 1901X Powell St 1 Sidewalk: Curb side : Cutout Tree 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
118778 116293 4 148 1901X Powell St 9 Sidewalk: Curb side : Cutout Tree 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
145255 116288 4 148 1901X Powell St 4 Sidewalk: Curb side : Cutout Tree 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23
174092 116292 4 148 1901X Powell St 8 Sidewalk: Curb side : Cutout Tree 5           6009504.70132 2120333.42493 37.8025672995432 -122.41129555893 (37.8025672995432, -122.41129555893) 3 1 10 308 23