Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, PlantDate, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1882 | 1882 | 227046 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 715 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6009320.74588 | 2104897.8286599996 | 37.760174505071895 | -122.410841346058 | (37.7601745050719, -122.410841346058) | |||
| 14820 | 14820 | 96729 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1531 Jerrold Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6015669.53931 | 2096721.84355 | 37.738078899822995 | -122.388313045518 | (37.738078899823, -122.388313045518) | |||
| 16167 | 16167 | 107773 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772845 | 6014155.30561 | 2110125.53241 | 37.7747985202595 | -122.394486827531 | (37.7747985202595, -122.394486827531) | |
| 28628 | 28628 | 95805 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1180 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 4 | 3x3 | Permit Number 767549 | 6012197.65812 | 2102892.33506 | 37.754828754052504 | -122.40075051472701 | (37.7548287540525, -122.400750514727) |
| 40737 | 40737 | 88768 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 335 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2008 12:00:00 AM | 8 | 3x3 | Permit Number 51687 | 6013512.4253 | 2109511.33019 | 37.7730762996632 | -122.39666763312701 | (37.7730762996632, -122.396667633127) | |
| 81996 | 81996 | 95589 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1598 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/10/2009 12:00:00 AM | 3x3 | Permit Number 767379 | 6008735.1 | 2099385.7 | 37.7450065831384 | -122.412477186149 | (37.7450065831384, -122.412477186149) | |
| 90534 | 90534 | 87858 | Koelreuteria paniculata :: Golden Rain Tree 56 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6000340.49747 | 2104887.90927 | 37.7596396402708 | -122.441898968169 | (37.7596396402708, -122.441898968169) | |||||||
| 90850 | 90850 | 95804 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1172 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767548 | 6012200.0 | 2102946.0 | 37.7549762368602 | -122.400746185712 | (37.7549762368602, -122.400746185712) | |
| 107091 | 107091 | 82106 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1442 Sanchez St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/2011 12:00:00 AM | 3x3 | Permit Number 767418 | 6003903.93114879 | 2099873.27169394 | 37.746073034264604 | -122.42921725762 | (37.7460730342646, -122.42921725762) | |
| 112386 | 112386 | 61427 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 3514 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/2011 12:00:00 AM | 3x3 | Permit Number 767543 | 6006340.52913524 | 2100870.00155072 | 37.7489474646868 | -122.42086255612301 | (37.7489474646868, -122.420862556123) | |
| 114721 | 114721 | 47290 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2100 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2002 12:00:00 AM | 3x3 | Permit Number 45232 | 6009541.72996085 | 2104990.45798185 | 37.7604412326322 | -122.41008360325701 | (37.7604412326322, -122.410083603257) | |
| 143417 | 143417 | 96730 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1531 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6015658.7 | 2096702.1 | 37.738024087431995 | -122.38834914513201 | (37.738024087432, -122.388349145132) | |||
| 146179 | 146179 | 92223 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 715 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/21/2009 12:00:00 AM | 3x3 | Permit Number 52658 | 6009316.0 | 2104920.0 | 37.7602351164227 | -122.410859325784 | (37.7602351164227, -122.410859325784) | ||
| 162675 | 162675 | 88046 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1547 Jerrold Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/24/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51057 | 6015682.046 | 2096712.9906400002 | 37.738055284531896 | -122.388269185596 | (37.7380552845319, -122.388269185596) | |
| 168457 | 168457 | 91114 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 330 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/13/2009 12:00:00 AM | 8 | 3x3 | Permit Number 52002 | 6013611.29629 | 2109661.1066900003 | 37.773493054483 | -122.39633612322399 | (37.773493054483, -122.396336123224) | |
| 183780 | 183780 | 119659 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401X Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6012884.61917 | 2108905.3838400003 | 37.7713775468798 | -122.398796774473 | (37.7713775468798, -122.398796774473) | |||
| 183890 | 183890 | 83155 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1714 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/02/2009 12:00:00 AM | 5 | 3x3 | Permit Number 52368 | 6014530.43704 | 2094836.5062099998 | 37.7328389648403 | -122.392119708481 | (37.7328389648403, -122.392119708481) |
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");