Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13241 | 13241 | 187609 | Undocumented 2 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 100 Northridge Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018548.0 | 2094208.0 | 37.7313354560629 | -122.37818620453699 | (37.7313354560629, -122.378186204537) | ||||
| 13243 | 13243 | 187610 | Undocumented 2 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 100 Northridge Rd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6018548.0 | 2094208.0 | 37.7313354560629 | -122.37818620453699 | (37.7313354560629, -122.378186204537) | ||||
| 55884 | 55884 | 185738 | Undocumented 2 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 2159 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5987265.8413 | 2100577.9345 | 37.747051910766395 | -122.486800600201 | (37.7470519107664, -122.486800600201) | |||
| 82198 | 82198 | 18695 | DPW Maintained 3 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 251X Richardson Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12/23/2002 12:00:00 AM | 3 | 100 | 5999064.164064 | 2119841.396854 | 37.8006252370733 | -122.44738946108299 | (37.8006252370733, -122.447389461083) | ||
| 85033 | 85033 | 109457 | Undocumented 2 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 951 GILMAN AVE | 43 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 23 | 6015934.0 | 2089205.0 | 37.717453787650705 | -122.38687458595501 | (37.7174537876507, -122.386874585955) | ||||
| 94823 | 94823 | 4558 | DPW Maintained 3 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 1340X Laguna St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4X4 | 6004655.03099 | 2113461.96066 | 37.7834268147862 | -122.427588006915 | (37.7834268147862, -122.427588006915) | |||
| 133366 | 133366 | 247524 | Undocumented 2 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 1101 Waller St | 5 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6000021.13855 | 2108488.5030900002 | 37.769507771781704 | -122.44326207937901 | (37.7695077717817, -122.443262079379) | ||||
| 136234 | 136234 | 142094 | Undocumented 2 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 1210 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002005.2608 | 2110527.33 | 37.7752188239963 | -122.43654504180799 | (37.7752188239963, -122.436545041808) | |||
| 145782 | 145782 | 1778 | DPW Maintained 3 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 2001X Bay Shore Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X5 | 6012442.836211099 | 2088493.8744970001 | 37.7153072596479 | -122.398892125343 | (37.7153072596479, -122.398892125343) | |||
| 154950 | 154950 | 246434 | Undocumented 2 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 501 Duncan St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 6003227.42454 | 2099777.76851 | 37.7457724839196 | -122.431549711071 | (37.7457724839196, -122.431549711071) | ||||
| 183000 | 183000 | 66543 | Permitted Site 1 | Eucalyptus cinerea :: Ash-colored Eucalyptus 279 | 272 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/08/1991 12:00:00 AM | 14 | Permit Number 29722 | 5993095.7656 | 2113664.12537 | 37.783321299183704 | -122.46759290626001 | (37.7833212991837, -122.46759290626) |
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");