trees
21 rows where qCaretaker_id = 1 and qSpecies_id = 91
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3568 | 197493 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 950x Kansas St | 7 | Median : Yard | Tree | DPW 1 | 25 | 6011595.70122 | 2103803.27065 | 37.7572963894245 | -122.402896325021 | (37.7572963894245, -122.402896325021) | 10 | 3 | 8 | 28856 | 29 | ||||
6035 | 264650 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 10 | 3 | 8 | 58 | 1 | ||||
6247 | 20077 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 STAIRWAY55 | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
7042 | 264648 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 10 | 3 | 8 | 58 | 1 | ||||
7939 | 264649 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 10 | 3 | 8 | 58 | 1 | ||||
8265 | 19714 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 STAIRWAY13 | 12 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 40ST | |||||||||||||
15670 | 19820 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 STAIRWAY25 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 10ST | |||||||||||||
16158 | 19973 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 STAIRWAY44 | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 36 | |||||||||||||
17499 | 264647 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 2400 Keith St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3x3 | 6014365 | 2092317 | 37.7259117231873 | -122.392515496721 | (37.7259117231873, -122.392515496721) | 10 | 3 | 8 | 58 | 1 | ||||
18879 | 19971 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 100 STAIRWAY44 | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 15 | |||||||||||||
33743 | 5505 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 785 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 6X8 | 6005062.26258 | 2103781.17825 | 37.756868745618 | -122.425489962193 | (37.756868745618, -122.425489962193) | 2 | 4 | 5 | 28859 | 19 | |||
51033 | 12258 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 601 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004950.99275 | 2110977.71573 | 37.7766224258639 | -122.426387156922 | (37.7766224258639, -122.426387156922) | 7 | 9 | 11 | 28852 | 10 | |||
104806 | 12260 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 611 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3X3 | 6004921 | 2111005 | 37.7766956463335 | -122.426492853872 | (37.7766956463335, -122.426492853872) | 7 | 9 | 11 | 28852 | 10 | |||
109994 | 15661 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 3900 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6005100.74203 | 2095958.24727 | 37.7353909444416 | -122.424800364285 | (37.7353909444416, -122.424800364285) | 2 | 7 | 5 | 28859 | 2 | |||
113901 | 12257 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 601 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6004946.44345 | 2111002.77203 | 37.7766909671748 | -122.426404678747 | (37.7766909671748, -122.426404678747) | 7 | 9 | 11 | 28852 | 10 | |||
128125 | 197491 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 900x Carolina St | 23 | Median : Yard | Tree | DPW 1 | 1 | 6012477.42612 | 2103497.47149 | 37.7565059267156 | -122.399825482885 | (37.7565059267156, -122.399825482885) | 10 | 3 | 8 | 28856 | 29 | ||||
130978 | 20249 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1880 Steiner St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/16/2000 12:00:00 AM | 10 | 3X3 | 6002546.9119 | 2114591.5393 | 37.7864088846335 | -122.43496207541 | (37.7864088846335, -122.43496207541) | 13 | 9 | 11 | 29490 | 27 | ||
131779 | 4362 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 951 Chenery St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001187.63557 | 2096055.63136 | 37.7354365441677 | -122.438336378342 | (37.7354365441677, -122.438336378342) | 2 | 7 | 5 | 63 | 7 | |||
139364 | 29613 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 900X Junipero Serra Blvd | 22 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991166.63654 | 2090933.64994 | 37.7207977908582 | -122.472609073865 | (37.7207977908582, -122.472609073865) | 9 | 8 | 4 | 64 | 40 | ||
168964 | 29596 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 900X Junipero Serra Blvd | 5 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991179.03639 | 2091124.89815 | 37.7213236289735 | -122.472580148063 | (37.7213236289735, -122.472580148063) | 9 | 8 | 4 | 64 | 40 | ||
186600 | 29610 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 900X Junipero Serra Blvd | 19 | Median : Cutout | Tree | DPW 1 | 03/30/2006 12:00:00 AM | 3 | 3X3 | 5991173.75038 | 2091017.49654 | 37.7210284247022 | -122.472590593675 | (37.7210284247022, -122.472590593675) | 9 | 8 | 4 | 64 | 40 |
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) );