Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
531 | 531 | 27691 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 1765 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/2015 12:00:00 AM | 7 | 3X3 | 6001581.2067 | 2112155.8038 | 37.779666096456 | -122.438128618136 | (37.779666096456, -122.438128618136) | ||
27292 | 27292 | 250990 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 418 45th Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5981922.57195 | 2112909.00953 | 37.7805965385427 | -122.50619104959299 | (37.7805965385427, -122.506191049593) | |||
31021 | 31021 | 40202 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 409 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/30/1999 12:00:00 AM | 7 | Permit Number 41384 | 5982801.49084 | 2112996.87637 | 37.7808894968635 | -122.503157008013 | (37.7808894968635, -122.503157008013) | |
34976 | 34976 | 210093 | DPW Maintained 3 | Melaleuca nesophila :: Pink Melaleuca 93 | 1x Minerva St | 16 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 5996144.00036 | 2089001.40747 | 37.715779161942 | -122.45526438373899 | (37.715779161942, -122.455264383739) | |||
42850 | 42850 | 43626 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 2222 35th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | 7 | Permit Number 43275 | 5985464.7649 | 2100074.5033 | 37.7455644571804 | -122.49299140272 | (37.7455644571804, -122.49299140272) | |
53256 | 53256 | 47907 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 746 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2002 12:00:00 AM | 7 | Permit Number 45646 | 6000056.4472 | 2111499.7732 | 37.7777779701242 | -122.44335627129999 | (37.7777779701242, -122.4433562713) | |
60700 | 60700 | 183354 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 3544 Rivera St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5982117.2654 | 2100157.6466 | 37.7455964086946 | -122.504572502943 | (37.7455964086946, -122.504572502943) | |||
71166 | 71166 | 232033 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 517 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003277.43124 | 2096153.4098099999 | 37.7358236645184 | -122.431118151596 | (37.7358236645184, -122.431118151596) | |||
149060 | 149060 | 49454 | Permitted Site 1 | Melaleuca nesophila :: Pink Melaleuca 93 | 277@ BLANKEN Wheeler Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/2003 12:00:00 AM | 7 | Permit Number 46388 | 6012179.13947 | 2087360.9312099998 | 37.71218172628829 | -122.39972407980801 | (37.7121817262883, -122.399724079808) | |
150340 | 150340 | 250991 | Undocumented 2 | Melaleuca nesophila :: Pink Melaleuca 93 | 418 45th Ave | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5981922.93947 | 2112926.15087 | 37.7806436252297 | -122.506191049582 | (37.7806436252297, -122.506191049582) |
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");