Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
35223 | 35223 | 197213 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 4 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017295.11492 | 2098681.7702099998 | 37.74355040393579 | -122.382828919425 | (37.7435504039358, -122.382828919425) | |||
58085 | 58085 | 197219 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 20 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6017546.94281 | 2098457.41264 | 37.7429482736446 | -122.38194254943599 | (37.7429482736446, -122.381942549436) | |||
136158 | 136158 | 197211 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017250.2855 | 2098720.3657 | 37.7436539023979 | -122.382986615562 | (37.7436539023979, -122.382986615562) | |||
152030 | 152030 | 197217 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 12 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6017418.77475 | 2098570.88696 | 37.7432527723975 | -122.382393616971 | (37.7432527723975, -122.382393616971) | |||
156588 | 156588 | 197216 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 11 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017405.29347 | 2098583.32775 | 37.7432861876121 | -122.38244109758499 | (37.7432861876121, -122.382441097585) | |||
164348 | 164348 | 197218 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 13 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017435.50351 | 2098556.05574 | 37.743212972902704 | -122.38233474108101 | (37.7432129729027, -122.382334741081) | |||
171037 | 171037 | 197212 | Undocumented 2 | Quercus ilex :: Holly Oak 78 | 351 Cargo Way | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6017263.91913 | 2098709.4149599997 | 37.74362458719779 | -122.38293871135099 | (37.7436245871978, -122.382938711351) |
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");