trees

13 rows where qCareAssistant = "FUF" and qSpecies_id = 90

✎ View and edit SQL

This data as json, CSV (advanced)

qCareAssistant ✖

  • FUF · 13 ✖
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)
579 41331 DPW Maintained 1 Cinnamomum camphora :: Camphor Tree 90 1099 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/25/2000 12:00:00 AM 8   Permit Number 41989 6015098.10078 2102956.66001 37.7551667237886 -122.390724391438 (37.7551667237886, -122.390724391438) 10 3 8 28856 29
19853 38046 DPW Maintained 1 Cinnamomum camphora :: Camphor Tree 90 1717 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1998 12:00:00 AM 2   Permit Number 40246 6000011.0372 2114947.9177 37.7872430961375 -122.443761145666 (37.7872430961375, -122.443761145666) 15 6 1 29490 31
26710 40518 Permitted Site 7 Cinnamomum camphora :: Camphor Tree 90 141 Junipero Serra Blvd 5 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/1999 12:00:00 AM     Permit Number 41578 5991646.63736433 2095256.52671108 37.7326951089402 -122.471264671772 (37.7326951089402, -122.471264671772) 9 8 4 59 40
39640 40517 Permitted Site 7 Cinnamomum camphora :: Camphor Tree 90 141 Junipero Serra Blvd 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/1999 12:00:00 AM     Permit Number 41578 5991646.63736433 2095256.52671108 37.7326951089402 -122.471264671772 (37.7326951089402, -122.471264671772) 9 8 4 59 40
45446 40519 Permitted Site 7 Cinnamomum camphora :: Camphor Tree 90 141 Junipero Serra Blvd 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/1999 12:00:00 AM     Permit Number 41578 5991646.63736433 2095256.52671108 37.7326951089402 -122.471264671772 (37.7326951089402, -122.471264671772) 9 8 4 59 40
49999 40514 Permitted Site 7 Cinnamomum camphora :: Camphor Tree 90 141 Junipero Serra Blvd 8 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/1999 12:00:00 AM     Permit Number 41578 5991646.63736433 2095256.52671108 37.7326951089402 -122.471264671772 (37.7326951089402, -122.471264671772) 9 8 4 59 40
54107 40522 Permitted Site 7 Cinnamomum camphora :: Camphor Tree 90 141 Junipero Serra Blvd 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/1999 12:00:00 AM     Permit Number 41578 5991646.63736433 2095256.52671108 37.7326951089402 -122.471264671772 (37.7326951089402, -122.471264671772) 9 8 4 59 40
77077 40515 Permitted Site 7 Cinnamomum camphora :: Camphor Tree 90 141 Junipero Serra Blvd 7 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/1999 12:00:00 AM     Permit Number 41578 5991646.63736433 2095256.52671108 37.7326951089402 -122.471264671772 (37.7326951089402, -122.471264671772) 9 8 4 59 40
112725 67513 DPW Maintained 1 Cinnamomum camphora :: Camphor Tree 90 1132 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/16/1992 12:00:00 AM 8   Permit Number 31046 6011902.94059 2103147.9975 37.7555143045563 -122.401787705537 (37.7555143045563, -122.401787705537) 10 3 8 28856 29
132650 40516 Permitted Site 7 Cinnamomum camphora :: Camphor Tree 90 141 Junipero Serra Blvd 6 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/1999 12:00:00 AM     Permit Number 41578 5991646.63736433 2095256.52671108 37.7326951089402 -122.471264671772 (37.7326951089402, -122.471264671772) 9 8 4 59 40
148909 67494 DPW Maintained 1 Cinnamomum camphora :: Camphor Tree 90 1101 Rhode Island St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/08/1992 12:00:00 AM 10   Permit Number 31019 6011959.0139 2103258.41584 37.7558206181412 -122.401601545873 (37.7558206181412, -122.401601545873) 10 3 8 28856 29
173411 40523 Permitted Site 7 Cinnamomum camphora :: Camphor Tree 90 141 Junipero Serra Blvd 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/23/1999 12:00:00 AM     Permit Number 41578 5991646.63736433 2095256.52671108 37.7326951089402 -122.471264671772 (37.7326951089402, -122.471264671772) 9 8 4 59 40
180045 38045 DPW Maintained 1 Cinnamomum camphora :: Camphor Tree 90 1717 Baker St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 07/10/1998 12:00:00 AM 4   Permit Number 40246 6000011.6939 2114927.5611 37.7871872396683 -122.443757410609 (37.7871872396683, -122.443757410609) 15 6 1 29490 31

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