9 rows where qSpecies_id = 443

View and edit SQL

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)
38353 256715 Planning Code 138.1 required 2 Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 1540 17th Ave 1 Sidewalk: Property side : Cutout Tree Private 2   01/15/2019 12:00:00 AM 3 4x8 Permit Number 779534 5990911 2104908 37.7591529734205 -122.474512031039 (37.7591529734205, -122.474512031039) 1 8 4 56 12
62908 106343 Permitted Site 7 Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 497 VALLEY ST 5 Sidewalk: Curb side : Cutout Tree Private 2   04/17/2014 12:00:00 AM 2   Permit Number 770848 6002779 2099138 37.7439904023543 -122.433054595711 (37.7439904023543, -122.433054595711) 2 7 5 63 22
88557 106340 Permitted Site 7 Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 497 VALLEY ST 2 Sidewalk: Curb side : Cutout Tree Private 2     2   Permit Number 770848 6002779 2099138 37.7439904023543 -122.433054595711 (37.7439904023543, -122.433054595711) 2 7 5 63 22
97487 106338 Undocumented 4 Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 497 VALLEY ST 3 Sidewalk: Property side : Cutout Tree Private 2   04/17/2014 12:00:00 AM 2   Permit Number 770848 6002779 2099138 37.7439904023543 -122.433054595711 (37.7439904023543, -122.433054595711) 2 7 5 63 22
107126 117095 Undocumented 4 Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 2X 09TH AVE 6 Sidewalk: Curb side : Yard Tree Private 2     5 3x3   5993083 2114893 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285) 11 6 1 54 11
108628 122389 Undocumented 4 Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 166 Lomita Ave 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5991334 2104180 37.7571785771329 -122.472996021046 (37.7571785771329, -122.472996021046) 1 8 4 56 12
113573 117093 Undocumented 4 Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 2X 09TH AVE 4 Sidewalk: Curb side : Yard Tree Private 2     4 3x3   5993083 2114893 37.7866947153523 -122.46772647285 (37.7866947153523, -122.46772647285) 11 6 1 54 11
173166 106339 Permitted Site 7 Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 497X Valley St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/17/2014 12:00:00 AM 2   Permit Number 770848 6002779.6 2099138.4 37.7439915346951 -122.433052549622 (37.7439915346951, -122.433052549622) 2 7 5 63 22
192010 106337 Undocumented 4 Prunus serrulata 'Mt. Fuji' :: Mt. Fuji Cherry Tree 443 497 VALLEY ST 6 Sidewalk: Property side : Cutout Tree Private 2   04/17/2014 12:00:00 AM 2   Permit Number 770848 6002779 2099138 37.7439904023543 -122.433054595711 (37.7439904023543, -122.433054595711) 2 7 5 63 22

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