Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, PlantDate, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2952 | 2952 | 244491 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 442 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/28/2011 12:00:00 AM | 2 | Width 0ft | 6004006.3051 | 2109418.5142 | 37.7722877948852 | -122.42954388259199 | (37.7722877948852, -122.429543882592) | ||
| 2975 | 2975 | 244494 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 400 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 5 | Width 0ft | 6004177.5073 | 2109444.4069999997 | 37.7723685822151 | -122.428953525151 | (37.7723685822151, -122.428953525151) | ||
| 2982 | 2982 | 244493 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 418 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/30/2011 12:00:00 AM | 2 | Width 0ft | 6004092.0994 | 2109430.4944 | 37.772325546907794 | -122.42924796682699 | (37.7723255469078, -122.429247966827) | ||
| 3015 | 3015 | 244496 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 478 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/08/2009 12:00:00 AM | 4 | Width 0ft | 6003878.5797 | 2109399.3843 | 37.7722280361906 | -122.429984331292 | (37.7722280361906, -122.429984331292) | ||
| 3016 | 3016 | 244492 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 456 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/02/2009 12:00:00 AM | 2 | Width 0ft | 6003951.2344 | 2109410.9782 | 37.7722639846023 | -122.429733839468 | (37.7722639846023, -122.429733839468) | ||
| 23437 | 23437 | 139746 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1314 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004648.3504 | 2113539.1351 | 37.783638338734995 | -122.427616619318 | (37.783638338735, -122.427616619318) | |||
| 29229 | 29229 | 244127 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 398 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6004270.549 | 2109462.5132 | 37.7724235634161 | -122.42863297607501 | (37.7724235634161, -122.428632976075) | |||
| 30449 | 30449 | 143026 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 2027 POWELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6009443.5652 | 2120635.2508 | 37.80339260933211 | -122.411528458224 | (37.8033926093321, -122.411528458224) | |||
| 42373 | 42373 | 246384 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1655 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6006982.6308 | 2109153.3972 | 37.7717279173795 | -122.419229672629 | (37.7717279173795, -122.419229672629) | |||
| 46354 | 46354 | 244230 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 546 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003542.3247 | 2109354.0057 | 37.7720843887684 | -122.43114422654699 | (37.7720843887684, -122.431144226547) | |||
| 47551 | 47551 | 244231 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 576 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003405.9505 | 2109334.219 | 37.772022330462796 | -122.43161454270799 | (37.7720223304628, -122.431614542708) | |||
| 51365 | 51365 | 140195 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 801 GROVE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6003913.9155 | 2111095.4696 | 37.7768870709162 | -122.429983110687 | (37.7768870709162, -122.429983110687) | |||
| 56739 | 56739 | 246385 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1655 Mission St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6006994.7646 | 2109179.687 | 37.7718007862576 | -122.419189566122 | (37.7718007862576, -122.419189566122) | |||
| 61878 | 61878 | 244232 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 582 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6003376.0691 | 2109331.3272 | 37.77201269653779 | -122.431717698222 | (37.7720126965378, -122.431717698222) | |||
| 148748 | 148748 | 246382 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1655 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6006956.341 | 2109096.7729 | 37.77157095990471 | -122.41931659334999 | (37.7715709599047, -122.41931659335) | |||
| 152814 | 152814 | 247323 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 752 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6002559.2743 | 2109218.8363 | 37.771657491274205 | -122.434535006264 | (37.7716574912742, -122.434535006264) | |||
| 153625 | 153625 | 244495 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 462 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003934.2301 | 2109407.8865 | 37.7722545326532 | -122.42979243828199 | (37.7722545326532, -122.429792438282) | |||
| 154443 | 154443 | 245065 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1150 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000577.9392 | 2108943.6108 | 37.7707891181366 | -122.441368793683 | (37.7707891181366, -122.441368793683) | |||
| 156077 | 156077 | 246383 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1655 Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6006970.497 | 2109128.1185 | 37.771657824727 | -122.419269850794 | (37.771657824727, -122.419269850794) | |||
| 161130 | 161130 | 244138 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 398 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004318.4145 | 2109467.7034 | 37.7724405231997 | -122.428467774696 | (37.7724405231997, -122.428467774696) | |||
| 161281 | 161281 | 244228 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 500 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6003580.1475 | 2109359.8483 | 37.7721025743544 | -122.431013811567 | (37.7721025743544, -122.431013811567) |
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");