Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, PlantDate, DBH, PermitNotes, XCoord, YCoord, Latitude, Longitude, Location
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12488 | 12488 | 108566 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 627 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/24/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772549 | 6010648.7747599995 | 2091709.2722900002 | 37.7240359509768 | -122.405319522179 | (37.7240359509768, -122.405319522179) |
| 15008 | 15008 | 108726 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 460 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 773097 | 6011176.24234 | 2106141.01313 | 37.7636918767911 | -122.404511540684 | (37.7636918767911, -122.404511540684) |
| 71517 | 71517 | 109072 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1570 12th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/23/2015 12:00:00 AM | 3 | 3x3 | Permit Number 769406 | 5992498.7 | 2104770.7 | 37.758867846563795 | -122.469011061686 | (37.7588678465638, -122.469011061686) |
| 93094 | 93094 | 101004 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2801X Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2012 12:00:00 AM | 3x3 | Permit Number 769246 | 6003500.6 | 2117942.3 | 37.795663322696704 | -122.43190190430201 | (37.7956633226967, -122.431901904302) | ||
| 103001 | 103001 | 114970 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 200X MINERVA ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5994532.0 | 2089023.0 | 37.7157458289959 | -122.460837724068 | (37.7157458289959, -122.460837724068) | |||
| 106440 | 106440 | 114968 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 200X MINERVA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5994532.0 | 2089023.0 | 37.7157458289959 | -122.460837724068 | (37.7157458289959, -122.460837724068) | |||
| 110414 | 110414 | 90809 | DPW Maintained 3 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 3351X Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/04/2015 11:05:00 AM | 3 | 3x3 | 5985151.309330001 | 2110394.17837 | 37.77388107713121 | -122.494835999778 | (37.7738810771312, -122.494835999778) | ||
| 117203 | 117203 | 89148 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 5530 California St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/07/2008 12:00:00 AM | 2 | 3x3 | Permit Number 51801 | 5990364.38578 | 2114085.53443 | 37.7843202921023 | -122.47707310075 | (37.7843202921023, -122.47707310075) | |
| 125614 | 125614 | 109897 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1734 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/09/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775111 | 5987546.7 | 2103468.6 | 37.75500527135279 | -122.486041582178 | (37.7550052713528, -122.486041582178) |
| 140457 | 140457 | 108526 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 1677 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 773677 | 5990566.2613699995 | 2103985.48594 | 37.7566000147891 | -122.47563692717699 | (37.7566000147891, -122.475636927177) |
| 141314 | 141314 | 114969 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 200X MINERVA ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 5994532.0 | 2089023.0 | 37.7157458289959 | -122.460837724068 | (37.7157458289959, -122.460837724068) | |||
| 143315 | 143315 | 101003 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2801X Buchanan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2012 12:00:00 AM | 3x3 | Permit Number 769246 | 6003500.6 | 2117942.3 | 37.795663322696704 | -122.43190190430201 | (37.7956633226967, -122.431901904302) | ||
| 144567 | 144567 | 109033 | Permitted Site 1 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 2120 Moraga St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/22/2015 12:00:00 AM | 3 | 3x3 | Permit Number 772816 | 5987671.1 | 2103767.6 | 37.755833493421704 | -122.48563331933 | (37.7558334934217, -122.48563331933) |
| 163497 | 163497 | 108895 | Undocumented 2 | Agonis flexuosa 'After Dark' :: Peppermint willow 'After Dark' 274 | 666 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/20/2016 12:00:00 AM | 1 | 3x3 | Permit Number 774994 | 5987872.85836 | 2111424.89012 | 37.7768700551182 | -122.48549748779399 | (37.7768700551182, -122.485497487794) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");