Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2581 | 2581 | 107490 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 1306x Montgomery St | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6011447.18476 | 2119974.7633599997 | 37.8016912541172 | -122.404548295963 | (37.8016912541172, -122.404548295963) | ||||
| 9562 | 9562 | 19696 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 100 STAIRWAY9 | -3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15ST | ||||||||
| 16368 | 16368 | 19956 | DPW Maintained 3 | Prunus spp :: Cherry 84 | 100 STAIRWAY40 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 15ST | ||||||||
| 43070 | 43070 | 234922 | Undocumented 2 | Prunus spp :: Cherry 84 | 818 Hampshire St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6010155.119 | 2104325.0374 | 37.758648498551004 | -122.40791523902399 | (37.758648498551, -122.407915239024) | |||
| 61578 | 61578 | 238534 | Undocumented 2 | Prunus spp :: Cherry 84 | 671 Church St | 39 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 3ft | 6004315.939809999 | 2105094.00544 | 37.7604312615151 | -122.428164581928 | (37.7604312615151, -122.428164581928) | |||
| 76569 | 76569 | 136021 | Undocumented 2 | Prunus spp :: Cherry 84 | 1010 Lombard St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6007482.49892 | 2120248.47345 | 37.802220422406705 | -122.418287380977 | (37.8022204224067, -122.418287380977) | ||||
| 90536 | 90536 | 19034 | Permitted Site 1 | Prunus spp :: Cherry 84 | 3192 Sacramento St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 12 | 2X2 | 5999529.89099 | 2115397.3219999997 | 37.7884495878023 | -122.445458129536 | (37.7884495878023, -122.445458129536) | |||
| 92134 | 92134 | 56560 | Permitted Site 1 | Prunus spp :: Cherry 84 | 298X SAN FERNANDO WAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2x2 | 5992129.0 | 2095185.0 | 37.7325266047982 | -122.46959183484199 | (37.7325266047982, -122.469591834842) | |||
| 113713 | 113713 | 19022 | Permitted Site 1 | Prunus spp :: Cherry 84 | 3170 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 5999571.77228 | 2115429.18678 | 37.7885394709311 | -122.445315519372 | (37.7885394709311, -122.445315519372) | |||
| 143403 | 143403 | 122586 | Undocumented 2 | Prunus spp :: Cherry 84 | 2500X Lyon St | 6 | Median : Cutout 11 | Tree 1 | Private 1 | 12 | 10x20 | 5999276.0 | 2117538.0 | 37.794312827392396 | -122.446490617691 | (37.7943128273924, -122.446490617691) | |||
| 144369 | 144369 | 19033 | Permitted Site 1 | Prunus spp :: Cherry 84 | 3192 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 5999542.700669999 | 2115392.3027 | 37.7884365373764 | -122.44541344917101 | (37.7884365373764, -122.445413449171) |
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");