trees

18 rows where Supervisor Districts = 5 and qLegalStatus_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

Supervisor Districts ✖

rowid ▼ TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
38 167409 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 4 Divisadero St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2020 12:00:00 AM 3 3X3 Permit Number 781788 6001979.94285 2107686.90453 37.7674182815445 -122.436429284105 (37.7674182815445, -122.436429284105) 15 5 5 29492 3
56 124 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 1032 14th St 2 Sidewalk: Curb side : Cutout Tree Private 2   11/20/2020 12:00:00 AM 3 3X3 Permit Number 781788 6002037.12702 2107659.05322 37.7673450578674 -122.436229498819 (37.7673450578674, -122.436229498819) 15 5 5 29492 3
2593 19154 Section 806 (d) 5 Pittosporum undulatum :: Victorian Box 36 64 Sanchez St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/30/2014 12:00:00 AM 3 3x3 Permit Number 774356 6003450.27402 2107953.58185 37.7682339504649 -122.431362651168 (37.7682339504649, -122.431362651168) 15 9 5 28862 3
3076 228280 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 3 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
3160 228282 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 5 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
3306 228286 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 9 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
5528 167133 Section 806 (d) 5 Melaleuca quinquenervia :: Cajeput 10 4564 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/01/2019 12:00:00 AM 3 3x5 Permit Number 785333 6000784.60188 2104670.73247 37.7590686222364 -122.440347461192 (37.7590686222364, -122.440347461192) 2 4 5 28862 3
6139 264669 Section 806 (d) 5 Prunus subhirtella 'autumnalis' :: Higan Cherry 297 1890 Church St 2 Sidewalk: Curb side : Cutout Tree Private 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
6383 228279 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
7100 228281 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 4 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
7765 263633 Section 806 (d) 5 Ceanothus 'Ray Hartman' :: California Lilac 'Ray Hartman' 146 160 Caselli Ave 1 Sidewalk: Curb side : Cutout Tree Private 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
8602 228283 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 6 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
10725 228284 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 7 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
10740 228285 Section 806 (d) 5 Ginkgo biloba :: Maidenhair Tree 22 2036X 15th St 8 Sidewalk: Curb side : Yard Tree Private 2     3 Width 3ft   6003817 2107261 37.7663530653237 -122.430044770651 (37.7663530653237, -122.430044770651) 8 4 5 28862 3
11247 264702 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 625 Guerrero St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/17/2020 12:00:00 AM   3x3 Permit Number 783216 6005628.43923 2105332.18724 37.761159426347 -122.42364218242 (37.761159426347, -122.42364218242) 2 4 5 28859 19
15098 169494 Section 806 (d) 5 Prunus subhirtella 'autumnalis' :: Higan Cherry 297 1890 Church St 1 Sidewalk: Curb side : Cutout Tree Private 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
16057 167157 Section 806 (d) 5 Magnolia grandiflora :: Southern Magnolia 19 368 Diamond St 1 Sidewalk: Curb side : Cutout Tree Private 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
17710 169495 Section 806 (d) 5 Prunus subhirtella 'autumnalis' :: Higan Cherry 297 150 Randall St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/11/2020 12:00:00 AM 3 Width 3ft Permit Number 770415 6004561.3283 2097566.6275 37.7397767110236 -122.426779823841 (37.7397767110236, -122.426779823841) 2 7 5 63 7

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "trees" (
   [rowid] INTEGER PRIMARY KEY,
   [TreeID] TEXT,
   [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]),
   [qSpecies_id] INTEGER,
   [qAddress] TEXT,
   [SiteOrder] TEXT,
   [qSiteInfo] TEXT,
   [PlantType] TEXT,
   [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]),
   [qCareAssistant] TEXT,
   [PlantDate] TEXT,
   [DBH] TEXT,
   [PlotSize] TEXT,
   [PermitNotes] TEXT,
   [XCoord] TEXT,
   [YCoord] TEXT,
   [Latitude] TEXT,
   [Longitude] TEXT,
   [Location] TEXT,
   [Fire Prevention Districts] TEXT,
   [Police Districts] TEXT,
   [Supervisor Districts] TEXT,
   [Zip Codes] TEXT,
   [Neighborhoods (old)] TEXT,
   FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id)
);