Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16372 | 16372 | 19988 | DPW Maintained 3 | Quercus spp :: Oak 297 | 100 STAIRWAY46 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 40 | ||||||||
| 22959 | 22959 | 111336 | Permitted Site 1 | Quercus spp :: Oak 297 | 615 Spruce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775554; also known as Quercus Tomentella - Island Oak | 5997120.4 | 2113679.4 | 37.7835947853002 | -122.45367044545601 | (37.7835947853002, -122.453670445456) | |
| 28302 | 28302 | 136287 | Undocumented 2 | Quercus spp :: Oak 297 | 24 Priest St | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6008330.692530001 | 2117142.80042 | 37.7937407238113 | -122.415132249867 | (37.7937407238113, -122.415132249867) | |||
| 64022 | 64022 | 136289 | Undocumented 2 | Quercus spp :: Oak 297 | 2836 Larkin St | 16 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6006495.00775 | 2121066.48783 | 37.80441084625 | -122.42176272108101 | (37.80441084625, -122.421762721081) | ||||
| 65299 | 65299 | 3472 | DPW Maintained 3 | Quercus spp :: Oak 297 | 301X Cargo Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2006 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.1452900004 | 37.7419474372657 | -122.38006393110399 | (37.7419474372657, -122.380063931104) | ||
| 69628 | 69628 | 240345 | Undocumented 2 | Quercus spp :: Oak 297 | 45 Harry St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 10ft | 6003219.319680001 | 2097654.55858 | 37.7399421817732 | -122.431426194578 | (37.7399421817732, -122.431426194578) | |||
| 72476 | 72476 | 101441 | DPW Maintained 3 | Quercus spp :: Oak 297 | 31X College Ave | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6004315.3 | 2095877.6 | 37.7351251110849 | -122.427510187339 | (37.7351251110849, -122.427510187339) | |||||
| 79906 | 79906 | 3477 | DPW Maintained 3 | Quercus spp :: Oak 297 | 301X Cargo Way | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/1999 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.1452900004 | 37.7419474372657 | -122.38006393110399 | (37.7419474372657, -122.380063931104) | ||
| 81711 | 81711 | 3552 | DPW Maintained 3 | Quercus spp :: Oak 297 | 201X Cargo Way | 62 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016626.76696 | 2099218.04074 | 37.7449859443431 | -122.38517728139 | (37.7449859443431, -122.38517728139) | |||
| 88784 | 88784 | 3470 | Permitted Site 1 | Quercus spp :: Oak 297 | 301X Cargo Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2006 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.1452900004 | 37.7419474372657 | -122.38006393110399 | (37.7419474372657, -122.380063931104) | ||
| 90177 | 90177 | 109991 | Undocumented 2 | Quercus spp :: Oak 297 | 501X Shotwell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | DPW 4 | 3x3 | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | |||
| 96098 | 96098 | 113792 | Undocumented 2 | Quercus spp :: Oak 297 | 1106 SHOTWELL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6008003.0 | 2101442.0 | 37.7506116099511 | -122.41515419236 | (37.7506116099511, -122.41515419236) | |||
| 104980 | 104980 | 3469 | DPW Maintained 3 | Quercus spp :: Oak 297 | 301X Cargo Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/04/2006 12:00:00 AM | 12 | 3X3 | 6018082.70776 | 2098082.1452900004 | 37.7419474372657 | -122.38006393110399 | (37.7419474372657, -122.380063931104) | ||
| 108389 | 108389 | 3478 | Permitted Site 1 | Quercus spp :: Oak 297 | 301X Cargo Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/1999 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.1452900004 | 37.7419474372657 | -122.38006393110399 | (37.7419474372657, -122.380063931104) | ||
| 110398 | 110398 | 103171 | Permitted Site 1 | Quercus spp :: Oak 297 | 1201X Fillmore St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003055.6 | 2112559.2 | 37.7808574628324 | -122.43305688657 | (37.7808574628324, -122.43305688657) | ||||
| 112775 | 112775 | 3481 | DPW Maintained 3 | Quercus spp :: Oak 297 | 301X Cargo Way | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/1999 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.1452900004 | 37.7419474372657 | -122.38006393110399 | (37.7419474372657, -122.380063931104) | ||
| 115062 | 115062 | 3479 | DPW Maintained 3 | Quercus spp :: Oak 297 | 301X Cargo Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/1999 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.1452900004 | 37.7419474372657 | -122.38006393110399 | (37.7419474372657, -122.380063931104) | ||
| 117222 | 117222 | 3488 | DPW Maintained 3 | Quercus spp :: Oak 297 | 301X Cargo Way | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6018082.70776 | 2098082.1452900004 | 37.7419474372657 | -122.38006393110399 | (37.7419474372657, -122.380063931104) | |||
| 125940 | 125940 | 3480 | DPW Maintained 3 | Quercus spp :: Oak 297 | 301X Cargo Way | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 10/19/1999 12:00:00 AM | 6 | 3X3 | 6018082.70776 | 2098082.1452900004 | 37.7419474372657 | -122.38006393110399 | (37.7419474372657, -122.380063931104) | ||
| 136750 | 136750 | 136286 | Undocumented 2 | Quercus spp :: Oak 297 | 24 Priest St | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 15 | Width 10ft | 6008331.71277 | 2117117.35553 | 37.793670915742204 | -122.415126917793 | (37.7936709157422, -122.415126917793) | |||
| 147910 | 147910 | 136288 | Undocumented 2 | Quercus spp :: Oak 297 | 2836 Larkin St | 15 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | 6006500.63968 | 2121061.90297 | 37.804398574988205 | -122.421742905414 | (37.8043985749882, -122.421742905414) | ||||
| 174135 | 174135 | 136285 | Undocumented 2 | Quercus spp :: Oak 297 | 24 Priest St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 10ft | 6008334.01769 | 2117089.46847 | 37.7935944742691 | -122.41511696767 | (37.7935944742691, -122.41511696767) |
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");