Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 36138 | 36138 | 249778 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 119 Pfeiffer St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 0ft | 6010409.80858 | 2121137.7854400002 | 37.804826595643 | -122.408220184708 | (37.804826595643, -122.408220184708) | |||
| 37767 | 37767 | 211724 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 41 Ralston St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 5992178.335940001 | 2088233.1934099998 | 37.71344150289679 | -122.468915552827 | (37.7134415028968, -122.468915552827) | ||||
| 41322 | 41322 | 211727 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 41 Ralston St | 10 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6 | 5992176.51123 | 2088212.22362 | 37.7133838194885 | -122.468920334526 | (37.7133838194885, -122.468920334526) | ||||
| 57451 | 57451 | 249779 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 119 Pfeiffer St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 0ft | 6010421.07006 | 2121139.1053400002 | 37.804830850333204 | -122.408181306135 | (37.8048308503332, -122.408181306135) | |||
| 170319 | 170319 | 211723 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 47 Ralston St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | 5992174.6999 | 2088241.1909400001 | 37.7134632521081 | -122.468928701793 | (37.7134632521081, -122.468928701793) | ||||
| 171235 | 171235 | 249889 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 230 Greenwich St | 25 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | Width 0ft | 6011472.47528 | 2120454.19881 | 37.8030090801563 | -122.404494546207 | (37.8030090801563, -122.404494546207) | |||
| 174735 | 174735 | 236183 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 1 Penny Ln | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 2ft | 6002335.35488 | 2096511.4177599999 | 37.7367532424671 | -122.434400864109 | (37.7367532424671, -122.434400864109) | |||
| 175716 | 175716 | 211722 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 47 Ralston St | 6 | Back Yard : Yard 13 | Tree 1 | Private 1 | 8 | 5992176.846480001 | 2088244.58976 | 37.7134727084689 | -122.468921529709 | (37.7134727084689, -122.468921529709) | ||||
| 179054 | 179054 | 249777 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 119 Pfeiffer St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | Width 0ft | 6010400.427069999 | 2121136.58311 | 37.8048227690275 | -122.40825256571001 | (37.8048227690275, -122.40825256571) | |||
| 180672 | 180672 | 211726 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 41 Ralston St | 8 | Back Yard : Yard 13 | Tree 1 | Private 1 | 7 | 5992180.41529 | 2088216.9630599997 | 37.7133970584078 | -122.46890718553699 | (37.7133970584078, -122.468907185537) | ||||
| 188904 | 188904 | 211725 | Undocumented 2 | Pittosporum undulatum :: Victorian Box 26 | 41 Ralston St | 7 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992180.34622 | 2088219.99909 | 37.7134053906231 | -122.468907645067 | (37.7134053906231, -122.468907645067) |
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");