19 rows where qSpecies_id = 205

View and edit SQL

Suggested facets: qCaretaker_id

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

CSV options:

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)
);