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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45037 | 45037 | 129425 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Broadway | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6003239.07369 | 2117504.42466 | 37.794446200597 | -122.432775535577 | (37.794446200597, -122.432775535577) | |||
| 54446 | 54446 | 129451 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1147 Filbert St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6007395.89235 | 2119499.90916 | 37.80016017810029 | -122.418533970572 | (37.8001601781003, -122.418533970572) | |||
| 55147 | 55147 | 246315 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006857.4528 | 2108984.4305 | 37.7712569245067 | -122.419650681714 | (37.7712569245067, -122.419650681714) | |||
| 56470 | 56470 | 129438 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010041.47641 | 2115755.35321 | 37.790027121797294 | -122.409114812309 | (37.7900271217973, -122.409114812309) | |||
| 65596 | 65596 | 129426 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Broadway | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6003248.10705 | 2117506.03033 | 37.7944511216749 | -122.432744393832 | (37.7944511216749, -122.432744393832) | |||
| 132516 | 132516 | 246316 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006848.8767 | 2108962.1326 | 37.7711952166815 | -122.41967876451 | (37.7711952166815, -122.41967876451) | |||
| 146728 | 146728 | 246318 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6006836.8702 | 2108926.9706 | 37.7710979938489 | -122.419717800254 | (37.7710979938489, -122.419717800254) | |||
| 151998 | 151998 | 129437 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010035.0094 | 2115756.1647799998 | 37.790028987884895 | -122.409137245009 | (37.7900289878849, -122.409137245009) | |||
| 162927 | 162927 | 246317 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 0ft | 6006842.0158 | 2108939.8347 | 37.771133605468705 | -122.419700914309 | (37.7711336054687, -122.419700914309) | |||
| 163894 | 163894 | 129427 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2149 Broadway | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6003257.40294 | 2117505.83832 | 37.794451121666604 | -122.43271221522 | (37.7944511216666, -122.43271221522) | |||
| 171961 | 171961 | 129439 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 4 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010043.54378 | 2115756.3306400003 | 37.7900299214 | -122.409107728349 | (37.7900299214, -122.409107728349) | |||
| 173661 | 173661 | 191249 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 2300 18th St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 10ft | 6010915.57021 | 2105542.63703 | 37.7620342994705 | -122.405370986778 | (37.7620342994705, -122.405370986778) | |||
| 182481 | 182481 | 129436 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 715 Bush St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6010030.57511 | 2115756.25526 | 37.7900289879055 | -122.409152593735 | (37.7900289879055, -122.409152593735) | |||
| 187192 | 187192 | 246314 | Undocumented 2 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1660 Mission St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 0ft | 6006868.6018 | 2109014.4469 | 37.7713399704187 | -122.419614246796 | (37.7713399704187, -122.419614246796) |
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");