trees
11 rows where qSpecies_id = 372
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16850 | 15577 | DPW Maintained 1 | Solanum rantonnetti :: 372 | 3120 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 1 | 6006912.5724 | 2100283.6127 | 37.7473696007082 | -122.418842842112 | (37.7473696007082, -122.418842842112) | 2 | 7 | 7 | 28859 | 2 | ||||
| 43343 | 28279 | DPW Maintained 1 | Solanum rantonnetti :: 372 | 1435 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 09/12/2002 12:00:00 AM | 3 | 3X3 | 6004563.8852658 | 2100541.3153404 | 37.7479446664543 | -122.426982792733 | (37.7479446664543, -122.426982792733) | 2 | 4 | 5 | 63 | 22 | ||
| 43898 | 215044 | DPW Maintained 1 | Solanum rantonnetti :: 372 | 463 Mangels Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 10ft | 5998368.45034 | 2095224.36624 | 37.732993333458 | -122.448023485115 | (37.732993333458, -122.448023485115) | 9 | 7 | 4 | 59 | 40 | |||
| 54614 | 32516 | DPW Maintained 1 | Solanum rantonnetti :: 372 | 833 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/15/1996 12:00:00 AM | 4 | Permit Number 37018 | 6007585.44241 | 2095495.24083 | 37.7342596562437 | -122.416177023754 | (37.7342596562437, -122.416177023754) | 2 | 7 | 7 | 28859 | 2 | |
| 91192 | 15575 | DPW Maintained 1 | Solanum rantonnetti :: 372 | 3120 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/10/2004 12:00:00 AM | 3 | 3X3 | 6006944.412 | 2100344.7947 | 37.7475393853778 | -122.418737080966 | (37.7475393853778, -122.418737080966) | 2 | 7 | 7 | 28859 | 2 | ||
| 102550 | 86490 | DPW Maintained 1 | Solanum rantonnetti :: 372 | 1618 27th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/28/2006 12:00:00 AM | 3 | 3x3 | 5987805.7655 | 2104249.4147 | 37.7571642715643 | -122.485202959431 | (37.7571642715643, -122.485202959431) | 1 | 8 | 3 | 56 | 35 | ||
| 107991 | 179500 | DPW Maintained 1 | Solanum rantonnetti :: 372 | 35 Rome St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5999277.89214 | 2089403.76534 | 37.7170632553333 | -122.444461147262 | (37.7170632553333, -122.444461147262) | 9 | 7 | 6 | 28861 | 25 | |||
| 133707 | 184631 | DPW Maintained 1 | Solanum rantonnetti :: 372 | 1813 48th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 5981297.4729 | 2102748.6084 | 37.7526622049253 | -122.507599389268 | (37.7526622049253, -122.507599389268) | 1 | 8 | 3 | 56 | 35 | |||
| 174648 | 142726 | DPW Maintained 1 | Solanum rantonnetti :: 372 | 650 FRANCISCO ST | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 25 | Width 0ft | 6008226.8051 | 2121045.8618 | 37.8044517189216 | -122.415768208034 | (37.8044517189216, -122.415768208034) | 5 | 1 | 10 | 308 | 23 | |||
| 180900 | 183282 | DPW Maintained 1 | Solanum rantonnetti :: 372 | 1279 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 0ft | 5983341.6477 | 2106454.1645 | 37.7629568312865 | -122.500804390886 | (37.7629568312865, -122.500804390886) | 1 | 8 | 3 | 56 | 35 | |||
| 189255 | 15576 | DPW Maintained 1 | Solanum rantonnetti :: 372 | 3120 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6006933.1745 | 2100324.1926 | 37.7474821839526 | -122.418774478773 | (37.7474821839526, -122.418774478773) | 2 | 7 | 7 | 28859 | 2 |
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) );