Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qAddress, SiteOrder, qCaretaker, PlantDate, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
12077 | 12077 | 94990 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 48 Leland Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 3 | 6010713.1186 | 2087200.5157 | 37.7116594240627 | -122.40477981842301 | (37.7116594240627, -122.404779818423) | ||||
12485 | 12485 | 94989 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 44 Leland Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 3 | 6010751.8878 | 2087184.0277 | 37.711616318234206 | -122.404644660956 | (37.7116163182342, -122.404644660956) | ||||
52627 | 52627 | 98408 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 24 19th Ave | 2 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 02/09/2012 12:00:00 AM | 3 | Permit Number 768590 | 5989918.49451 | 2114923.36913 | 37.7865948726066 | -122.478677005621 | (37.7865948726066, -122.478677005621) | ||
88454 | 88454 | 94991 | Permitted Site 1 | Ginkgo biloba :: Maidenhair Tree 44 | 48 Leland Ave | 2 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 3 | 6010722.4 | 2087213.8 | 37.7116964188451 | -122.40474867386699 | (37.7116964188451, -122.404748673867) | ||||
117984 | 117984 | 91210 | DPW Maintained 3 | Hymenosporum flavum :: Sweet Shade 91 | 333 Haight St | 1 | Sidewalk: Curb side : 21 | Tree 1 | DPW 2 | 02/15/2008 12:00:00 AM | 3 | 6004540.59043 | 2109422.99046 | 37.7723303224715 | -122.427696060061 | (37.7723303224715, -122.427696060061) | |||
155501 | 155501 | 98407 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 24 19th Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 02/09/2012 12:00:00 AM | 3 | Permit Number 768590 | 5989919.44776 | 2114906.64899 | 37.7865490191546 | -122.47867248440201 | (37.7865490191546, -122.478672484402) | ||
176682 | 176682 | 98235 | Permitted Site 1 | Prunus x yedoensis :: Yoshino Cherry 237 | 42 19th Ave | 1 | Sidewalk: Curb side : 21 | Tree 1 | Private 1 | 01/09/2012 12:00:00 AM | 3 | Permit Number 768620 | 5989920.54745 | 2114876.2625700003 | 37.7864656504451 | -122.47866645673 | (37.7864656504451, -122.47866645673) |
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");