Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4800 | 4800 | 161279 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 594 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/25/2017 12:18:00 PM | 3 | Width 0ft | 6002806.05279 | 2090211.99508 | 37.7194831555901 | -122.43232368828998 | (37.7194831555901, -122.43232368829) | |
| 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) | |
| 24507 | 24507 | 191158 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 201 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014425.7087199995 | 2110384.34677 | 37.775524194919704 | -122.393569557682 | (37.7755241949197, -122.393569557682) | |||
| 28982 | 28982 | 190860 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 180 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014325.82728 | 2110344.39106 | 37.7754089351207 | -122.393912276726 | (37.7754089351207, -122.393912276726) | |||
| 33739 | 33739 | 191159 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 201 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014441.85996 | 2110400.0230099997 | 37.7755681357843 | -122.39351478358 | (37.7755681357843, -122.39351478358) | |||
| 75959 | 75959 | 190894 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014191.20495 | 2110159.4009 | 37.7748935111682 | -122.394365015227 | (37.7748935111682, -122.394365015227) | |||
| 124248 | 124248 | 115879 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1125X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/01/2016 12:00:00 AM | 3 | Permit Number 773046 | 6015016.8 | 2096457.8 | 37.737317699837206 | -122.390551463966 | (37.7373176998372, -122.390551463966) | ||
| 132876 | 132876 | 190847 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014760.45028 | 2110759.5978 | 37.77657314436011 | -122.392437849936 | (37.7765731443601, -122.392437849936) | |||
| 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) | |||
| 149364 | 149364 | 190837 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 540 Barneveld Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6011137.802619999 | 2097880.16304 | 37.7410072488818 | -122.404063094656 | (37.7410072488818, -122.404063094656) | |||
| 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) | |
| 168558 | 168558 | 190836 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 540 Barneveld Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 6011141.49126 | 2097886.93529 | 37.7410260501239 | -122.404050817101 | (37.7410260501239, -122.404050817101) | |||
| 183392 | 183392 | 190874 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6014038.01567 | 2110068.93569 | 37.774636597347495 | -122.394888596037 | (37.7746365973475, -122.394888596037) | |||
| 187426 | 187426 | 85231 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 3 | Permit Number 49539 | 6013350.68536 | 2109356.01998 | 37.772640849735396 | -122.39721622315001 | (37.7726408497354, -122.39721622315) |
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");