12 rows where Fire Prevention Districts = 2 and qLegalStatus_id = 5

View and edit SQL

Fire Prevention 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)
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
6198 112830 Section 806 (d) 5 Pittosporum undulatum :: Victorian Box 36 2265 MISSION ST 1 Sidewalk: Curb side : Cutout Tree Private 2   08/21/2015 12:00:00 AM 3 3x3   6006944 2105170 37.760788269781 -122.419080706794 (37.760788269781, -122.419080706794) 2 4 7 28859 19
6318 261662 Section 806 (d) 5 Aesculus californica :: California Buckeye 168 137 Elsie St 1 Sidewalk: Property side : Yard Tree Private 2   02/13/2020 12:00:00 AM 3     6007155.81154 2098485.15545 37.7424451335194 -122.417874270912 (37.7424451335194, -122.417874270912) 2 7 7 28859 2
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
9107 264723 Section 806 (d) 5 Pistacia chinensis :: Chinese Pistache 32 335 Precita Ave 1 Sidewalk: Curb side : Cutout Tree Private 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
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
16257 225172 Section 806 (d) 5 Ginkgo biloba 'Princeton Sentry' :: Princeton Sentry Maidenhair 343 248 Prospect Ave 1 Sidewalk: Curb side : Cutout Tree Private 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
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
18916 152848 Section 806 (d) 5 Tristaniopsis laurina :: Swamp Myrtle 1 160 San Carlos St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/12/2019 12:00:00 AM 3 Width 3ft Permit Number 781252 6006654.74312 2105190.58967 37.7608285109489 -122.420082580673 (37.7608285109489, -122.420082580673) 2 4 7 28859 19

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)
);