trees
13 rows where qCareAssistant = "FUF" and qSpecies_id = 90 sorted by qAddress
This data as json, CSV (advanced)
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 | |
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 | |
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 | |
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 | ||
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 | ||
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 | ||
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 | |
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
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) );