Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, qAddress, SiteOrder, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17977 | 17977 | 116827 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 14 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 59669 | 59669 | 116819 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 6 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 11 | 6010427.9948 | 2121647.4361 | 37.8062269882557 | -122.40819321595501 | (37.8062269882557, -122.408193215955) | ||||
| 78641 | 78641 | 116976 | Undocumented 2 | Salix spp :: Willow 218 | 100x CARGO WAY | 7 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 79463 | 79463 | 116977 | Undocumented 2 | Acacia melanoxylon :: Blackwood Acacia 5 | 100x CARGO WAY | 117 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 83489 | 83489 | 116828 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 15 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 83621 | 83621 | 116826 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 13 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 85395 | 85395 | 116822 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 9 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 92074 | 92074 | 116820 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 7 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 93526 | 93526 | 116831 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 18 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 94354 | 94354 | 116825 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 12 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 99346 | 99346 | 116823 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 10 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 107057 | 107057 | 116830 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 17 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 110974 | 110974 | 116818 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 5 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 111971 | 111971 | 116809 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 1 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 126108 | 126108 | 116824 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 11 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 127145 | 127145 | 116817 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 4 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 133018 | 133018 | 116821 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 Bay St | 8 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 14 | 6010478.7636 | 2121651.8235 | 37.806241877556 | -122.408017830638 | (37.806241877556, -122.408017830638) | ||||
| 139776 | 139776 | 116829 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 16 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 140503 | 140503 | 116975 | Undocumented 2 | Salix spp :: Willow 218 | 100x CARGO WAY | 6 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 144844 | 144844 | 116816 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 3 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) | |||||
| 144887 | 144887 | 116832 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 2 Midway St | 7 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010125.275107 | 2121295.55695439 | 37.8052438606833 | -122.409215987298 | (37.8052438606833, -122.409215987298) | |||||
| 146001 | 146001 | 116815 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 111 BAY ST | 2 | Front Yard : Yard 7 | Tree 1 | PUC 13 | 6010193.0 | 2121519.0 | 37.805861173705296 | -122.408997391272 | (37.8058611737053, -122.408997391272) |
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");