Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, PlantDate, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1081 | 1081 | 3617 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 53 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:16:00 PM | 3 | 3X3 | 6017937.25359 | 2098269.56212 | 37.742454020638796 | -122.380579893948 | (37.7424540206388, -122.380579893948) | ||
13427 | 13427 | 3615 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 51 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017970.88261 | 2098244.46459 | 37.7423869635862 | -122.380461869644 | (37.7423869635862, -122.380461869644) | ||
16754 | 16754 | 3613 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 49 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6018003.94992 | 2098219.94993 | 37.742321475865296 | -122.380345828295 | (37.7423214758653, -122.380345828295) | |||
22313 | 22313 | 3602 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 38 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6018187.24152 | 2098084.4470599997 | 37.7419595239099 | -122.379702643058 | (37.7419595239099, -122.379702643058) | ||
22341 | 22341 | 3629 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 65 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3X3 | 6017712.663240001 | 2098437.04484 | 37.7429014981049 | -122.38136811194201 | (37.7429014981049, -122.381368111942) | |||
22348 | 22348 | 3623 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 59 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017813.51979 | 2098359.7555299997 | 37.7426948446985 | -122.38101400211 | (37.7426948446985, -122.38101400211) | ||
101112 | 101112 | 3570 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | |||
134600 | 134600 | 83049 | Private 5 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/04/2006 12:00:00 AM | 11 | 6018864.1607099995 | 2097578.2563400003 | 37.7406069390666 | -122.377326932804 | (37.7406069390666, -122.377326932804) | |||
159024 | 159024 | 3587 | Permitted Site 1 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 100X Cargo Way | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018440.3984199995 | 2097892.70026 | 37.7414469858874 | -122.378813986102 | (37.7414469858874, -122.378813986102) |
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");