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");