trees
23 rows where qSpecies_id = 274
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4078 | 78328 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 50 Pomona St | 19 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014090.70522 | 2094312.98368 | 37.7313770539035 | -122.393603356926 | (37.7313770539035, -122.393603356926) | 10 | 3 | 8 | 58 | 1 | ||
| 7428 | 78326 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 50 Pomona St | 21 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014084.32077 | 2094282.11607 | 37.7312919429706 | -122.393623269718 | (37.7312919429706, -122.393623269718) | 10 | 3 | 8 | 58 | 1 | ||
| 9294 | 247083 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 2301 Castro St | 1 | Front Yard : Yard | Tree | Private 2 | 6 | 6002715.97589 | 2098582.66862 | 37.7424620165241 | -122.433232846235 | (37.7424620165241, -122.433232846235) | 2 | 7 | 5 | 63 | 22 | ||||
| 15783 | 78330 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 50 Pomona St | 17 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 3 | 3x3 | 6014096.48223 | 2094344.10726 | 37.7314628339206 | -122.39358556205 | (37.7314628339206, -122.39358556205) | 10 | 3 | 8 | 58 | 1 | ||
| 19132 | 244224 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 1832 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 0ft | 5997773.5489 | 2108897.9553 | 37.7705036025949 | -122.451065895872 | (37.7705036025949, -122.451065895872) | 15 | 5 | 11 | 29492 | 9 | |||
| 33992 | 6437 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 1100X Evans Ave | 19 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | |||
| 35975 | 91298 | Permitted Site 7 | Celtis australis :: European Hackberry 274 | 450 Rhode Island St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 41215 | 91308 | Permitted Site 7 | Celtis australis :: European Hackberry 274 | 450 Rhode Island St | 13 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 42221 | 91302 | Permitted Site 7 | Celtis australis :: European Hackberry 274 | 450 Rhode Island St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 64856 | 91300 | Permitted Site 7 | Celtis australis :: European Hackberry 274 | 450 Rhode Island St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 67046 | 91296 | Permitted Site 7 | Celtis australis :: European Hackberry 274 | 450 Rhode Island St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 76328 | 6480 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 1200X Evans Ave | 22 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017406.29701 | 2097289.15601 | 37.7397327083536 | -122.382347607267 | (37.7397327083536, -122.382347607267) | 10 | 3 | 8 | 58 | 1 | |||
| 78508 | 91305 | Permitted Site 7 | Celtis australis :: European Hackberry 274 | 450 Rhode Island St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 84083 | 91307 | Permitted Site 7 | Celtis australis :: European Hackberry 274 | 450 Rhode Island St | 12 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 87816 | 6441 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 1100X Evans Ave | 23 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 10 | 3 | 8 | 58 | 1 | |||
| 90503 | 186683 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 1401 Sunset Blvd | 40 | Sidewalk: Property side : Yard | Tree | Private 2 | 1 | Width 0ft | 5984744.5022 | 2105372.2434 | 37.7600684420947 | -122.495872657495 | (37.7600684420947, -122.495872657495) | 1 | 8 | 3 | 56 | 35 | |||
| 99562 | 91309 | Permitted Site 7 | Celtis australis :: European Hackberry 274 | 450 Rhode Island St | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 113399 | 91306 | Permitted Site 7 | Celtis australis :: European Hackberry 274 | 450 Rhode Island St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 137428 | 91301 | Permitted Site 7 | Celtis australis :: European Hackberry 274 | 450 Rhode Island St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 156093 | 91299 | Permitted Site 7 | Celtis australis :: European Hackberry 274 | 450 Rhode Island St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 172082 | 91297 | Permitted Site 7 | Celtis australis :: European Hackberry 274 | 450 Rhode Island St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/06/2009 12:00:00 AM | 3x3 | Permit Number 52049 | 6011745 | 2106547 | 37.7648383947947 | -122.40257292402 | (37.7648383947947, -122.40257292402) | 8 | 3 | 8 | 28853 | 20 | ||
| 183569 | 247093 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 2301 Castro St | 11 | Front Yard : Yard | Tree | Private 2 | 6 | 6002746.24371 | 2098623.20959 | 37.7425750496142 | -122.433131085235 | (37.7425750496142, -122.433131085235) | 2 | 7 | 5 | 63 | 22 | ||||
| 187115 | 6436 | DPW Maintained 1 | Celtis australis :: European Hackberry 274 | 1100X Evans Ave | 18 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6018339.9760743 | 2096552.8140758 | 37.7377623877793 | -122.379068180173 | (37.7377623877793, -122.379068180173) | 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) );