Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19672 | 19672 | 96325 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2011 12:00:00 AM | 5 | 4x4 | Permit Number 768012 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |
| 32103 | 32103 | 38388 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1150 Phelps St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1998 12:00:00 AM | 5 | Permit Number 40446 | 6014255.1081300005 | 2096652.83017 | 37.737810927032704 | -122.39319864851801 | (37.7378109270327, -122.393198648518) | ||
| 47233 | 47233 | 129800 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1180 Sansome St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6011900.25036 | 2120353.89385 | 37.802757564074604 | -122.40300715386101 | (37.8027575640746, -122.403007153861) | |||
| 55664 | 55664 | 129767 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1375 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6006477.1660400005 | 2118669.59087 | 37.7978285696796 | -122.421654118939 | (37.7978285696796, -122.421654118939) | |||
| 75033 | 75033 | 228849 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 210 Cumberland St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004184.64448 | 2104547.65023 | 37.75892367042171 | -122.42857972608499 | (37.7589236704217, -122.428579726085) | |||
| 84349 | 84349 | 96323 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
| 85027 | 85027 | 96326 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
| 88337 | 88337 | 96318 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011857.0 | 2120322.0 | 37.802667576079 | -122.403154578184 | (37.802667576079, -122.403154578184) | |||
| 91499 | 91499 | 96324 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
| 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) | |||
| 119723 | 119723 | 96319 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
| 128349 | 128349 | 96320 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
| 137367 | 137367 | 200339 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 22 | : 4 | Tree 1 | Private 1 | 5 | Width 2ft | 6015308.33502 | 2098065.1650799997 | 37.741747363937606 | -122.389655714464 | (37.7417473639376, -122.389655714464) | |||
| 139177 | 139177 | 96321 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 4x4 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |||
| 167501 | 167501 | 129749 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2300 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000782.42382 | 2119661.2506 | 37.8002286408033 | -122.44143066041599 | (37.8002286408033, -122.441430660416) |
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");