Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: DBH, XCoord, YCoord, Latitude, Longitude, Location
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
29379 | 29379 | 105035 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015087.4436800005 | 2107939.01173 | 37.768846592924 | -122.391109479333 | (37.768846592924, -122.391109479333) | |||
42249 | 42249 | 105036 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 6x6 | Permit Number 771181 | 6015089.32821 | 2107914.09587 | 37.7687782840212 | -122.39110121906201 | (37.7687782840212, -122.391101219062) | ||
49942 | 49942 | 105026 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6x6 | 6015072.88546 | 2108163.93601 | 37.7694633776739 | -122.39117555971599 | (37.7694633776739, -122.391175559716) | |||
59549 | 59549 | 105029 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015077.74883 | 2108086.46133 | 37.769250919128 | -122.391153321267 | (37.769250919128, -122.391153321267) | |||
66308 | 66308 | 105031 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015081.19497 | 2108038.83155 | 37.7691203294602 | -122.391138071471 | (37.7691203294602, -122.391138071471) | |||
70706 | 70706 | 105027 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 6x6 | 6015075.4785400005 | 2108137.72551 | 37.7693915533068 | -122.391164757946 | (37.7693915533068, -122.391164757946) | |||
83610 | 83610 | 105034 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) | ||||
100937 | 100937 | 105033 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) | ||||
102467 | 102467 | 105032 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6x6 | 6015094.5 | 2108059.1 | 37.7691767205026 | -122.391093466638 | (37.7691767205026, -122.391093466638) | ||||
137702 | 137702 | 105030 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015079.85403 | 2108063.37025 | 37.769187632923604 | -122.391144425184 | (37.7691876329236, -122.391144425184) | |||
170367 | 170367 | 105028 | Permitted Site 1 | Laurus nobilis :: Sweet Bay: Grecian Laurel 30 | 1550 04th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 6x6 | 6015077.92484 | 2108113.3475599997 | 37.7693247525719 | -122.391154592016 | (37.7693247525719, -122.391154592016) |
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");