Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSpecies, qAddress, SiteOrder, qSiteInfo, qCareAssistant, PlantDate, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3317 | 3317 | 253413 | Undocumented 2 | Potential Site :: Potential Site 29 | 2433 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | Private 3 | 3x3 | 5989193.66308 | 2098780.80152 | 37.7422296590049 | -122.48000293550501 | (37.7422296590049, -122.480002935505) | |||
| 4969 | 4969 | 3585 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/01/2017 03:02:00 PM | 3 | 3x3 | 6018473.32905 | 2097868.47388 | 37.7413822805579 | -122.37869844028299 | (37.7413822805579, -122.378698440283) | ||
| 5049 | 5049 | 3594 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3x3 | 6018322.1359 | 2097981.33701 | 37.741683843926396 | -122.379229056502 | (37.7416838439264, -122.379229056502) | |||
| 13841 | 13841 | 3685 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 100X Cargo Way | 121 | Sidewalk: Property side : Cutout 5 | Tree 1 | Port 9 | 8 | 3x3 | 6016762.06772 | 2099192.87656 | 37.744924332395 | -122.38470767871999 | (37.744924332395, -122.38470767872) | |||
| 13855 | 13855 | 3635 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 71 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 3 | 3x3 | 6017615.70257 | 2098508.02238 | 37.7430910347139 | -122.38170831381201 | (37.7430910347139, -122.381708313812) | ||
| 15616 | 15616 | 22077 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 3240 03rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/07/1995 12:00:00 AM | 3 | 3x3 | 6015962.924330001 | 2100554.9145299997 | 37.748619977641 | -122.387566000296 | (37.748619977641, -122.387566000296) | ||
| 16743 | 16743 | 3677 | Permitted Site 1 | Eucalyptus sideroxylon :: Red Ironbark 36 | 100X Cargo Way | 113 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/07/2006 12:00:00 AM | 3 | 3x3 | 6016945.8178 | 2099054.7063700003 | 37.7445551058345 | -122.38406267865801 | (37.7445551058345, -122.384062678658) | ||
| 22320 | 22320 | 3658 | Permitted Site 1 | Quercus suber :: Cork Oak 76 | 100X Cargo Way | 94 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3x3 | 6017265.726009999 | 2098814.03291 | 37.7439119466908 | -122.382939742901 | (37.7439119466908, -122.382939742901) | |||
| 22330 | 22330 | 3607 | Private 5 | Lophostemon confertus :: Brisbane Box 11 | 100X Cargo Way | 43 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 6 | 3x3 | 6018106.23722 | 2098142.91565 | 37.742115598557895 | -122.37998679465001 | (37.7421155985579, -122.37998679465) | |||
| 66037 | 66037 | 121471 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 102X King St | 1 | Median : Cutout 11 | Tree 1 | Port 9 | 9 | 3x3 | 6015546.21298 | 2111901.81315 | 37.779753015830394 | -122.38979944679701 | (37.7797530158304, -122.389799446797) | |||
| 84280 | 84280 | 3576 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 100X Cargo Way | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 03/01/2006 12:00:00 AM | 3 | 3x3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 93059 | 93059 | 121444 | Undocumented 2 | Platanus x hispanica :: Sycamore: London Plane 15 | 400X The Embarcadero | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 3x3 | 6013767.0 | 2118587.0 | 37.7980101597556 | -122.39642328332701 | (37.7980101597556, -122.396423283327) | ||||
| 102836 | 102836 | 27575 | Permitted Site 1 | Melaleuca quinquenervia :: Cajeput 50 | 1299X Illinois St | 26 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/12/2003 12:00:00 AM | 12 | 3x3 | 6016181.753398 | 2103053.032112 | 37.7554914042846 | -122.386983490089 | (37.7554914042846, -122.386983490089) | ||
| 107477 | 107477 | 106680 | Permitted Site 1 | Tree(s) :: 17 | 2200 LYON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | Private 3 | 06/24/2014 12:00:00 AM | 20 | 3x3 | Permit Number 773028 | 5999398.2 | 2116386.7 | 37.7911586409716 | -122.445984946853 | (37.7911586409716, -122.445984946853) |
| 116371 | 116371 | 28008 | Permitted Site 1 | Platanus x hispanica 'Yarwood' :: Yarwood Sycamore 127 | 100 The Embarcadero | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 02/05/2001 12:00:00 AM | 6 | 3x3 | 6014135.53401 | 2117846.1200099997 | 37.7959963794451 | -122.39509611853599 | (37.7959963794451, -122.395096118536) | ||
| 117261 | 117261 | 3583 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 05/31/1996 12:00:00 AM | 8 | 3x3 | 6018980.3390981 | 2097500.2540781004 | 37.740399159699294 | -122.376919818221 | (37.7403991596993, -122.376919818221) | ||
| 119175 | 119175 | 108830 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 46 Ney St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | FUF 1 | 3x3 | 6003763.1265 | 2093992.4287599998 | 37.7299176091889 | -122.429284866217 | (37.7299176091889, -122.429284866217) |
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");