Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
32349 | 32349 | 184697 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1616 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5982844.3503 | 2104136.3629 | 37.7565635951525 | -122.502352798468 | (37.7565635951525, -122.502352798468) | |||
58411 | 58411 | 248399 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 115 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998223.6499 | 2108104.3812 | 37.768350409277396 | -122.449451812394 | (37.7683504092774, -122.449451812394) | |||
63459 | 63459 | 184208 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1474 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983740.5189 | 2105133.2538 | 37.759353393050105 | -122.49932723943 | (37.7593533930501, -122.49932723943) | |||
132639 | 132639 | 183523 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2542 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986781.4828 | 2097933.2945 | 37.7397621847049 | -122.488281131206 | (37.7397621847049, -122.488281131206) | |||
161381 | 161381 | 245893 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1001 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6001728.4463 | 2109399.5631 | 37.772106523732 | -122.437421829009 | (37.772106523732, -122.437421829009) | |||
172020 | 172020 | 184126 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1643 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5986219.0266 | 2104040.7857 | 37.756498872957394 | -122.490675089245 | (37.7564988729574, -122.490675089245) |
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");