trees
11 rows where qCaretaker_id = 1 and qSpecies_id = 98 sorted by qSiteInfo
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
30372 | 215739 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 15x San Marcos Ave | 20 | Median : Cutout | Tree | DPW 1 | 14 | Width 5ft | 5993350.77612 | 2100350.23209 | 37.746779573516 | -122.465743042324 | (37.746779573516, -122.465743042324) | 1 | 8 | 4 | 29491 | 40 | |||
165683 | 215738 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 15x San Marcos Ave | 19 | Median : Cutout | Tree | DPW 1 | 17 | Width 5ft | 5993371.75539 | 2100358.30231 | 37.7468029424032 | -122.465671084868 | (37.7468029424032, -122.465671084868) | 1 | 8 | 4 | 29491 | 40 | |||
165885 | 3748 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 900 Carolina St | 2 | Median : Cutout | Tree | DPW 1 | 6 | 18 | 6012456.16548 | 2103686.28097 | 37.7570231709119 | -122.399912268343 | (37.7570231709119, -122.399912268343) | 10 | 3 | 8 | 28856 | 29 | |||
141140 | 198696 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 900x Carolina St | 5 | Median : Yard | Tree | DPW 1 | 3 | 6012471.20589 | 2103666.47878 | 37.7569696369443 | -122.399858862095 | (37.7569696369443, -122.399858862095) | 10 | 3 | 8 | 28856 | 29 | ||||
9499 | 10082 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 635 Guerrero St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 2X2 | 6005631.67807 | 2105272.56381 | 37.7609958972634 | -122.42362674139 | (37.7609958972634, -122.42362674139) | 2 | 4 | 5 | 28859 | 19 | |||
12264 | 1493 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 312 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 3x3 | 5995573.92539 | 2114332.46977 | 37.7852991621023 | -122.459067922044 | (37.7852991621023, -122.459067922044) | 11 | 6 | 1 | 54 | 31 | |||
38151 | 29911 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 810x Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | ||||
48866 | 29913 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 810 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | ||||
71278 | 25187 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 3765 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000249.08614 | 2102834.07361 | 37.7539951005144 | -122.442067687981 | (37.7539951005144, -122.442067687981) | 2 | 4 | 5 | 63 | 38 | |||
83882 | 29912 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 810 Junipero Serra Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5991252.04535388 | 2092080.81829703 | 37.7239525748811 | -122.472397431071 | (37.7239525748811, -122.472397431071) | 9 | 8 | 4 | 64 | 40 | ||||
149205 | 26591 | DPW Maintained 1 | Ulmus spp :: Elm Spp 98 | 1645 Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/18/1998 12:00:00 AM | 6 | 3X3 | 6012131.0656 | 2091075.31629 | 37.722378000425 | -122.400150938517 | (37.722378000425, -122.400150938517) | 10 | 3 | 8 | 58 | 1 |
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) );