trees
19 rows where qSpecies_id = 205
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1781 | 259401 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 1851 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 10/13/2018 12:00:00 AM | 3 | 3x4 | 6013660.95601 | 2094668.87428 | 37.7323303677695 | -122.395114009854 | (37.7323303677695, -122.395114009854) | 10 | 3 | 8 | 58 | 1 | |
| 12062 | 259364 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 1553 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 6015326.61891 | 2094194.43937 | 37.7311201525136 | -122.389322261551 | (37.7311201525136, -122.389322261551) | 10 | 3 | 8 | 58 | 1 | ||||
| 12955 | 193527 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 2525 Phelps St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/19/2019 12:00:00 AM | 3 | 4x6 | 6012134.12036 | 2093726.86436 | 37.7296587777324 | -122.400326524868 | (37.7296587777324, -122.400326524868) | 10 | 3 | 8 | 58 | 1 | |
| 18839 | 259359 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 1470 Revere Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 05/25/2019 12:00:00 AM | 3 | 6015792.03244 | 2093898.47534 | 37.7303332862111 | -122.387692589701 | (37.7303332862111, -122.387692589701) | 10 | 3 | 8 | 58 | 1 | ||
| 19099 | 113032 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 251 06th Ave | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | 3 | 3x3 | 5993973.41927 | 2113841.38508 | 37.7838586397785 | -122.464569471656 | (37.7838586397785, -122.464569471656) | 11 | 6 | 2 | 54 | 11 | |||
| 35554 | 3584 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 19 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12/11/1998 12:00:00 AM | 3 | 3X3 | 6018506.82441 | 2097843.80813 | 37.7413163998229 | -122.378580911506 | (37.7413163998229, -122.378580911506) | 10 | 3 | 8 | 58 | 1 | ||
| 43754 | 43977 | Permitted Site 7 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 39 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/07/2016 12:00:00 AM | 3 | Permit Number 778501 | 6000993.81514185 | 2101486.77683791 | 37.7503381602792 | -122.439395674198 | (37.7503381602792, -122.439395674198) | 2 | 4 | 5 | 28862 | 22 | ||
| 49190 | 3634 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 70 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6017632.60306 | 2098495.95511 | 37.7430588336066 | -122.381649036799 | (37.7430588336066, -122.381649036799) | 10 | 3 | 8 | 58 | 1 | |||
| 76384 | 3647 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 83 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6017425.17191 | 2098677.66921 | 37.7435463281955 | -122.382378924746 | (37.7435463281955, -122.382378924746) | 10 | 3 | 8 | 58 | 1 | ||
| 79530 | 3657 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 93 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017283.49959 | 2098800.90892 | 37.7438768929081 | -122.382877372202 | (37.7438768929081, -122.382877372202) | 10 | 3 | 8 | 58 | 1 | |||
| 86496 | 28490 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 1499X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/08/2003 12:00:00 AM | 12 | 3X3 | 6005277.9300739 | 2099610.0882818 | 37.7454280803333 | -122.42444742702 | (37.7454280803333, -122.42444742702) | 2 | 7 | 5 | 28859 | 22 | ||
| 95018 | 3626 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 62 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017765.80037 | 2098395.89545 | 37.7427914435713 | -122.381181516112 | (37.7427914435713, -122.381181516112) | 10 | 3 | 8 | 58 | 1 | |||
| 103402 | 3610 | Private 9 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 46 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 6 | 3X3 | 6018056.23038 | 2098180.90993 | 37.7422171644003 | -122.380162344118 | (37.7422171644003, -122.380162344118) | 10 | 3 | 8 | 58 | 1 | |||
| 103819 | 43976 | Permitted Site 7 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 39 Homestead St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/24/2000 12:00:00 AM | 3 | Permit Number 778501 | 6000993.81514185 | 2101486.77683791 | 37.7503381602792 | -122.439395674198 | (37.7503381602792, -122.439395674198) | 2 | 4 | 5 | 28862 | 22 | ||
| 125045 | 3659 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 95 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 12 | 3X3 | 6017251.66004 | 2098826.19142 | 37.7439445542915 | -122.382989226284 | (37.7439445542915, -122.382989226284) | 10 | 3 | 8 | 58 | 1 | |||
| 142877 | 57275 | Permitted Site 7 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 43 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/10/1975 12:00:00 AM | 3 | Permit Number 778501 | 6000995.09395251 | 2101464.42922438 | 37.7502768718683 | -122.439389650282 | (37.7502768718683, -122.439389650282) | 2 | 4 | 5 | 28862 | 22 | ||
| 154705 | 116791 | Permitted Site 7 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 700x ANDERSON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | 3x3 | 6007719 | 2095661 | 37.7347223035732 | -122.415727003996 | (37.7347223035732, -122.415727003996) | 2 | 7 | 7 | 28859 | 2 | |||
| 176094 | 117323 | Permitted Site 7 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 43 Homestead St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Permit Number 778501 | 6001062.3 | 2101454.3 | 37.7502528838659 | -122.439156522004 | (37.7502528838659, -122.439156522004) | 2 | 4 | 5 | 28862 | 22 | |||
| 185262 | 3648 | DPW Maintained 1 | Aesculus x carnea 'Briotii' :: Ruby Horse Chestnut 205 | 100X Cargo Way | 84 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6017409.48154 | 2098690.6025 | 37.7435809736936 | -122.382434078367 | (37.7435809736936, -122.382434078367) | 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) );