Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 30051 | 30051 | 129811 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 435 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012498.509190001 | 2117154.1734 | 37.794005289065794 | -122.40071194282801 | (37.7940052890658, -122.400711942828) | |||
| 38264 | 38264 | 200368 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 199 Mission St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6014118.97804 | 2116248.97229 | 37.7916100652992 | -122.395041482589 | (37.7916100652992, -122.395041482589) | |||
| 40031 | 40031 | 129832 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 354 Sacramento St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012451.480280001 | 2117191.95794 | 37.7941064133197 | -122.400877324536 | (37.7941064133197, -122.400877324536) | |||
| 40130 | 40130 | 228846 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004252.08143 | 2104552.56077 | 37.758940969765 | -122.428346847525 | (37.758940969765, -122.428346847525) | |||
| 44261 | 44261 | 129795 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1180 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011922.61764 | 2120202.56088 | 37.8023432895615 | -122.40291910123699 | (37.8023432895615, -122.402919101237) | |||
| 50680 | 50680 | 129764 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1379 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006404.89602 | 2118659.8041 | 37.7977976222176 | -122.42190349824101 | (37.7977976222176, -122.421903498241) | |||
| 54619 | 54619 | 129787 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1160 Sansome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011959.4647699995 | 2119924.96913 | 37.801583147494604 | -122.402772057584 | (37.8015831474946, -122.402772057584) | |||
| 59650 | 59650 | 129831 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 354 Sacramento St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012476.45918 | 2117195.3094900004 | 37.7941170091435 | -122.40079112993 | (37.7941170091435, -122.40079112993) | |||
| 62368 | 62368 | 39387 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2710 Broadway | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 7 | Permit Number 40925 | 6000579.41048 | 2117201.67826 | 37.7934637371134 | -122.44195652817899 | (37.7934637371134, -122.441956528179) | ||
| 72647 | 72647 | 200369 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 650 Townsend St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011472.2786 | 2108553.20224 | 37.7703317423487 | -122.403657370911 | (37.7703317423487, -122.403657370911) | |||
| 134375 | 134375 | 39384 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 2710 Broadway | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/1998 12:00:00 AM | 7 | Permit Number 40925 | 6000588.20452 | 2117202.1206900002 | 37.793465453027395 | -122.441926131987 | (37.7934654530274, -122.441926131987) | ||
| 136918 | 136918 | 200356 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6014331.3129900005 | 2096752.73935 | 37.7380894902424 | -122.39294215736601 | (37.7380894902424, -122.392942157366) | |||
| 146537 | 146537 | 200350 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Phelps St | 12 | : 4 | Tree 1 | Private 1 | 7 | Width 4ft | 6014508.81125 | 2096991.75117 | 37.738755625282394 | -122.39234516490299 | (37.7387556252824, -122.392345164903) | |||
| 146744 | 146744 | 140288 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1960 HAYES ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5998467.9884 | 2110034.371 | 37.7736636426957 | -122.44874570038 | (37.7736636426957, -122.44874570038) | |||
| 151057 | 151057 | 129786 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1160 Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011965.83445 | 2119897.8199 | 37.8015089579449 | -122.402748105054 | (37.8015089579449, -122.402748105054) | |||
| 156528 | 156528 | 129824 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 504 Battery St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6012608.14 | 2117404.20841 | 37.794697939723704 | -122.40035017702499 | (37.7946979397237, -122.400350177025) | |||
| 161074 | 161074 | 129768 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 489 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6011131.656690001 | 2118977.1984099997 | 37.7989345451634 | -122.40556987367201 | (37.7989345451634, -122.405569873672) | |||
| 161111 | 161111 | 129785 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1160 Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011966.59622 | 2119867.2001900002 | 37.8014249261853 | -122.402743314356 | (37.8014249261853, -122.402743314356) | |||
| 167735 | 167735 | 129788 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1160 Sansome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011956.16596 | 2119957.68161 | 37.8016727838339 | -122.402785774963 | (37.8016727838339, -122.402785774963) | |||
| 169005 | 169005 | 129791 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1160 Sansome St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011942.54079 | 2120045.79904 | 37.801913972121895 | -122.402839125451 | (37.8019139721219, -122.402839125451) | |||
| 169282 | 169282 | 200361 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 5ft | 6014182.02229 | 2096553.32448 | 37.7375336444497 | -122.39344438196699 | (37.7375336444497, -122.393444381967) | |||
| 176983 | 176983 | 129765 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1379 Green St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006424.31939 | 2118660.7850599997 | 37.797801411063396 | -122.421836357588 | (37.7978014110634, -122.421836357588) | |||
| 181981 | 181981 | 129801 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1180 Sansome St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011895.86595 | 2120414.05559 | 37.8029225087266 | -122.40302656033701 | (37.8029225087266, -122.403026560337) | |||
| 186385 | 186385 | 129789 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1160 Sansome St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6011950.175319999 | 2119985.5388 | 37.80174893842371 | -122.402808465741 | (37.8017489384237, -122.402808465741) | |||
| 186583 | 186583 | 200362 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 5ft | 6014166.7855 | 2096532.27247 | 37.7374749933851 | -122.39349559025801 | (37.7374749933851, -122.393495590258) | |||
| 187663 | 187663 | 129748 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2300 Chestnut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000804.68172 | 2119664.29702 | 37.800238273442396 | -122.441353858292 | (37.8002382734424, -122.441353858292) |
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");