trees
11 rows where Police Districts = 5 and qSpecies_id = 153
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1177 | 50666 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 132 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/07/2004 12:00:00 AM | Permit Number 47245 | 5997808.46990271 | 2107170.46182714 | 37.7657623457378 | -122.450820527035 | (37.7657623457378, -122.450820527035) | 15 | 5 | 11 | 29492 | 9 | |||
| 25429 | 247474 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 850 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6002489.938 | 2109552.4307 | 37.7725695227328 | -122.434798704253 | (37.7725695227328, -122.434798704253) | 15 | 5 | 11 | 29492 | 9 | |||
| 40063 | 35160 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 335 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38691 | 6002701.11607915 | 2109682.95719093 | 37.7729399034438 | -122.434077550687 | (37.7729399034438, -122.434077550687) | 15 | 5 | 11 | 29492 | 9 | ||
| 56532 | 244481 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 1074 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6001413.516 | 2109405.0473 | 37.7721036727294 | -122.438511589285 | (37.7721036727294, -122.438511589285) | 15 | 5 | 11 | 29492 | 9 | |||
| 92213 | 222869 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 134 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997758.85551 | 2107160.25032 | 37.7657314672574 | -122.450991395353 | (37.7657314672574, -122.450991395353) | 15 | 5 | 11 | 29492 | 9 | |||
| 105361 | 60676 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 1074 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/25/1983 12:00:00 AM | 12 | Permit Number 20313 | 6001422.6196434 | 2109409.49491386 | 37.772116402608 | -122.438480417824 | (37.772116402608, -122.438480417824) | 15 | 5 | 11 | 29492 | 9 | ||
| 113359 | 35156 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 1076 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/02/1998 12:00:00 AM | Permit Number 38687 | 6001413.36342647 | 2109408.19644929 | 37.7721123108282 | -122.43851234272 | (37.7721123108282, -122.43851234272) | 15 | 5 | 11 | 29492 | 9 | ||
| 129831 | 106940 | Undocumented 4 | Celtis sinensis :: Chinese Hackberry 153 | 1607 WALLER ST | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 5997889 | 2108175 | 37.7685251613651 | -122.450614421545 | (37.7685251613651, -122.450614421545) | 15 | 5 | 11 | 29492 | 9 | ||||
| 138124 | 247494 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 335 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6002693.3039 | 2109766.0565 | 37.7731676302149 | -122.434110515465 | (37.7731676302149, -122.434110515465) | 15 | 5 | 11 | 29492 | 9 | |||
| 172840 | 45193 | Permitted Site 7 | Celtis sinensis :: Chinese Hackberry 153 | 134 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/23/2001 12:00:00 AM | Permit Number 44037 | 5997793.88507772 | 2107168.4294301 | 37.7657559303797 | -122.45087082602 | (37.7657559303797, -122.45087082602) | 15 | 5 | 11 | 29492 | 9 | ||
| 193714 | 247476 | DPW Maintained 1 | Celtis sinensis :: Chinese Hackberry 153 | 856 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6002462.8226 | 2109547.3008 | 37.7725538978004 | -122.434892132162 | (37.7725538978004, -122.434892132162) | 15 | 5 | 11 | 29492 | 9 |
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) );