Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlantDate, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26800 | 26800 | 191208 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 325 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013709.665519999 | 2109700.15636 | 37.7736057494514 | -122.39599858427601 | (37.7736057494514, -122.395998584276) | |||
| 29071 | 29071 | 51117 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 7 | Permit Number 47557 | 6012851.53345 | 2108941.1546099996 | 37.7714739218185 | -122.398913731299 | (37.7714739218185, -122.398913731299) | ||
| 47376 | 47376 | 191176 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 362 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013081.89405 | 2109153.9281900004 | 37.7720709835069 | -122.398131826536 | (37.7720709835069, -122.398131826536) | |||
| 51695 | 51695 | 49809 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1546ARKANSAS 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 7 | Permit Number 46602 | 6012971.722709999 | 2105685.57554 | 37.762541524281204 | -122.398269533421 | (37.7625415242812, -122.398269533421) | |
| 51814 | 51814 | 191204 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 335 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013569.4383 | 2109566.49789 | 37.773230950690106 | -122.396474284254 | (37.7732309506901, -122.396474284254) | |||
| 65354 | 65354 | 190835 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 540 Barneveld Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 6011143.20834 | 2097895.22742 | 37.7410489144739 | -122.404045463449 | (37.7410489144739, -122.404045463449) | |||
| 67423 | 67423 | 49806 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 1164SSIPPI 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2003 12:00:00 AM | 7 | Permit Number 46601 | 6014134.35886 | 2105751.7151200003 | 37.762787822535 | -122.394252998377 | (37.762787822535, -122.394252998377) | ||
| 67668 | 67668 | 190863 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 180 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6014272.3812 | 2110293.28106 | 37.775265628138705 | -122.394093581849 | (37.7752656281387, -122.394093581849) | |||
| 67747 | 67747 | 190846 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6014778.17275 | 2110775.57556 | 37.776617999847204 | -122.39237766009899 | (37.7766179998472, -122.392377660099) | |||
| 71158 | 71158 | 85234 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 7 | Permit Number 49539 | 6013403.64119 | 2109407.9569599996 | 37.772786404996296 | -122.397036684295 | (37.7727864049963, -122.397036684295) | ||
| 125557 | 125557 | 227033 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 2813 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6009433.9529 | 2104976.2744400003 | 37.760396246421706 | -122.41045535432801 | (37.7603962464217, -122.410455354328) | |||
| 148369 | 148369 | 190889 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 255 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6014009.99216 | 2109987.0339200003 | 37.77441015524511 | -122.39497979807301 | (37.7744101552451, -122.394979798073) | |||
| 150285 | 150285 | 190887 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 255 Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013974.07808 | 2109952.45981 | 37.774313225399396 | -122.395101610353 | (37.7743132253994, -122.395101610353) | |||
| 155090 | 155090 | 227043 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 203 Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007125.1333800005 | 2096948.3880099999 | 37.7382237850914 | -122.417871436422 | (37.7382237850914, -122.417871436422) | |||
| 175327 | 175327 | 32981 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 558 Texas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/01/1996 12:00:00 AM | 7 | Permit Number 37294 | 6013791.869419999 | 2104484.1784 | 37.759288400371204 | -122.39534875755699 | (37.7592884003712, -122.395348757557) | |
| 183159 | 183159 | 191194 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 5ft | 6013058.71986 | 2109068.39463 | 37.771834836828 | -122.398205986443 | (37.771834836828, -122.398205986443) |
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");