Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11560 | 11560 | 35695 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 13924 | 13924 | 15115 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6014020.20981 | 2116155.23725 | 37.7913471979732 | -122.395376652733 | (37.7913471979732, -122.395376652733) | |||
| 35454 | 35454 | 129838 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 733 Front St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6012789.03405 | 2118594.11911 | 37.797975236527904 | -122.39980784898 | (37.7979752365279, -122.39980784898) | |||
| 35863 | 35863 | 129806 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Sacramento St | 5 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 6 | Width 3ft | 6010377.17129 | 2116863.70379 | 37.793089185679705 | -122.40803152672702 | (37.7930891856797, -122.408031526727) | |||
| 36000 | 36000 | 129798 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1180 Sansome St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6011911.92184 | 2120288.0073599997 | 37.8025773075571 | -122.40296212752399 | (37.8025773075571, -122.402962127524) | |||
| 45529 | 45529 | 200360 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1150 Phelps St | 5 | : 4 | Tree 1 | Private 1 | 6 | Width 5ft | 6014196.6239 | 2096573.2462900002 | 37.737589156904995 | -122.393395290662 | (37.737589156905, -122.393395290662) | |||
| 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) | |||
| 68851 | 68851 | 228850 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004169.71901 | 2104547.0578 | 37.7589211990752 | -122.42863130311501 | (37.7589211990752, -122.428631303115) | |||
| 88634 | 88634 | 100146 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 222X Cumberland St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004147.2 | 2104574.7 | 37.75899582353679 | -122.428711154895 | (37.7589958235368, -122.428711154895) | |||||
| 102887 | 102887 | 100698 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954.0 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | |||
| 107979 | 107979 | 96322 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
| 120360 | 120360 | 108653 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
| 125491 | 125491 | 17660 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1000X Phelps St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3X3 | 6014635.9682774 | 2097168.9021451 | 37.739249105451 | -122.391917896407 | (37.739249105451, -122.391917896407) | |||
| 138977 | 138977 | 32406 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/03/1996 12:00:00 AM | Permit Number 36942 | 6014160.17669171 | 2116306.66761031 | 37.7917707740774 | -122.394902977188 | (37.7917707740774, -122.394902977188) | |||
| 145002 | 145002 | 17644 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 600X Phelps St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 8 | 2x2 | 6015304.738625 | 2098066.4602575 | 37.74175072080671 | -122.38966824014999 | (37.7417507208067, -122.38966824015) | |||
| 145599 | 145599 | 17635 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | |||
| 151663 | 151663 | 129773 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 80 Vallejo St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012883.50017 | 2119263.61 | 37.799818763986295 | -122.399527995233 | (37.7998187639863, -122.399527995233) | |||
| 167176 | 167176 | 200363 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 5 | : 4 | Tree 1 | Private 1 | 8 | Width 5ft | 6014137.38405 | 2096492.6896799998 | 37.7373646735385 | -122.393594476122 | (37.7373646735385, -122.393594476122) | |||
| 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) |
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");