trees
27 rows where Neighborhoods (old) = 29 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3344 | 197494 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 401 Texas St | 3 | : | Tree | Private 2 | 23 | Width 7ft | 6013811.84722 | 2105166.53521 | 37.7611631145139 | -122.395327465206 | (37.7611631145139, -122.395327465206) | 10 | 3 | 8 | 28856 | 29 | |||
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 | ||||
9816 | 32952 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 673X Missouri St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554 | 2103938 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | 10 | 3 | 8 | 28856 | 29 | |||
20260 | 197489 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1301 Minnesota St | 42 | Front Yard : Yard | Tree | Private 2 | 8 | 6015361.30396 | 2102471.04633 | 37.753847930956 | -122.389780232768 | (37.753847930956, -122.389780232768) | 10 | 3 | 8 | 28856 | 29 | ||||
46169 | 197497 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 651 Missouri St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | 6013599.16401 | 2103957.68535 | 37.7578320454303 | -122.395978336045 | (37.7578320454303, -122.395978336045) | 10 | 3 | 8 | 28856 | 29 | ||||
49320 | 32953 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 673X Missouri St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554 | 2103938 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | 10 | 3 | 8 | 28856 | 29 | |||
56212 | 197490 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1301 Minnesota St | 43 | Front Yard : Yard | Tree | Private 2 | 13 | 6015358.4418 | 2102466.66646 | 37.7538357460423 | -122.38978982496 | (37.7538357460423, -122.38978982496) | 10 | 3 | 8 | 28856 | 29 | ||||
58030 | 197487 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1301 Minnesota St | 28 | Front Yard : Yard | Tree | Private 2 | 11 | 6015378.84744 | 2102468.94598 | 37.7538431366753 | -122.389719416144 | (37.7538431366753, -122.389719416144) | 10 | 3 | 8 | 28856 | 29 | ||||
60629 | 106612 | Significant Tree 6 | Schinus molle :: California Pepper 91 | 1189 TENNESSEE ST | Front Yard : Yard | Tree | Private 2 | 55 | 6015654.1 | 2103577.3 | 37.7569017014681 | -122.388844893024 | (37.7569017014681, -122.388844893024) | 10 | 3 | 8 | 28856 | 29 | |||||
67494 | 197496 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 651 Missouri St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6013599.60524 | 2103941.4739 | 37.7577875568584 | -122.395975674052 | (37.7577875568584, -122.395975674052) | 10 | 3 | 8 | 28856 | 29 | ||||
68839 | 119665 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
75500 | 32955 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 673X Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554 | 2103938 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | 10 | 3 | 8 | 28856 | 29 | |||
81470 | 61782 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 2107 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/26/1985 12:00:00 AM | 20 | Permit Number 21804 | 6012179.15182 | 2102325.12749 | 37.7532702936903 | -122.400774668711 | (37.7532702936903, -122.400774668711) | 10 | 3 | 8 | 28856 | 29 | |
82256 | 197486 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1112 Tennessee St | 2 | Sidewalk: Curb side : Pot | Tree | Private 2 | 19 | Width 6ft | 6015516.35006 | 2103817.53146 | 37.7575536899561 | -122.389338063096 | (37.7575536899561, -122.389338063096) | 10 | 3 | 8 | 28856 | 29 | |||
116094 | 197488 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 1301 Minnesota St | 29 | Front Yard : Yard | Tree | Private 2 | 9 | 6015374.95978 | 2102473.44448 | 37.753855273025 | -122.389733174866 | (37.753855273025, -122.389733174866) | 10 | 3 | 8 | 28856 | 29 | ||||
120041 | 197495 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 651 Missouri St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6013600.82032 | 2103923.07952 | 37.757737117488 | -122.39597018278 | (37.757737117488, -122.39597018278) | 10 | 3 | 8 | 28856 | 29 | ||||
125492 | 119663 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
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 | ||||
132843 | 119662 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
132958 | 32950 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 673X Missouri St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554 | 2103938 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | 10 | 3 | 8 | 28856 | 29 | |||
145663 | 119666 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
148145 | 119668 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
172673 | 32951 | Permitted Site 7 | Schinus molle :: California Pepper 91 | 673X Missouri St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/01/1996 12:00:00 AM | Permit Number 37269 | 6013554 | 2103938 | 37.7577754809094 | -122.396133153567 | (37.7577754809094, -122.396133153567) | 10 | 3 | 8 | 28856 | 29 | |||
180003 | 119664 | Undocumented 4 | Schinus molle :: California Pepper 91 | 699x Missouri St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 6013712 | 2104098 | 37.7582235960409 | -122.395597929962 | (37.7582235960409, -122.395597929962) | 10 | 3 | 8 | 28856 | 29 | |||||
184817 | 197500 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 651 Missouri St | 25 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6013593.70141 | 2104032.4139 | 37.7580369298728 | -122.396002464843 | (37.7580369298728, -122.396002464843) | 10 | 3 | 8 | 28856 | 29 | ||||
187579 | 197499 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 651 Missouri St | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6013595.97387 | 2103991.32166 | 37.7579242259433 | -122.395991726059 | (37.7579242259433, -122.395991726059) | 10 | 3 | 8 | 28856 | 29 | ||||
188324 | 197498 | DPW Maintained 1 | Schinus molle :: California Pepper 91 | 651 Missouri St | 22 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6013596.26371 | 2103973.99117 | 37.757876656309 | -122.395989509211 | (37.757876656309, -122.395989509211) | 10 | 3 | 8 | 28856 | 29 |
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) );