Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, DBH, PlotSize, PermitNotes, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2573 | 2573 | 253125 | Undocumented 2 | Acer japonicum :: Japanese Maple 183 | 1 Oak Park Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 5996419.0 | 2103319.0 | 37.7551075738744 | -122.455348004876 | (37.7551075738744, -122.455348004876) | ||||
| 13267 | 13267 | 187629 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 4283 23rd St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6001353.0 | 2102279.0 | 37.7525338497288 | -122.43821033719401 | (37.7525338497288, -122.438210337194) | ||||
| 18613 | 18613 | 104871 | Undocumented 2 | Acer japonicum :: Japanese Maple 183 | 50-52 Ord St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5x4 | Permit Number 770461 | 6000747.1 | 2106070.8 | 37.762910728567206 | -122.440577579902 | (37.7629107285672, -122.440577579902) | |||
| 75297 | 75297 | 105044 | Undocumented 2 | Acer japonicum :: Japanese Maple 183 | 115 San Jose Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 6006223.6 | 2102382.1 | 37.7530927489395 | -122.421374265597 | (37.7530927489395, -122.421374265597) | ||||
| 78904 | 78904 | 51535 | Permitted Site 1 | Acer japonicum :: Japanese Maple 183 | 575 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2005 12:00:00 AM | Permit Number 47836 | 5997620.77530153 | 2094372.6871886002 | 37.7306120580701 | -122.45054700177499 | (37.7306120580701, -122.450547001775) | |||
| 80785 | 80785 | 104444 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 507 Capp St | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 2x6 | Permit Number 770679 | 6007300.0 | 2104257.5 | 37.7583027968034 | -122.41778477647301 | (37.7583027968034, -122.417784776473) | |||
| 84844 | 84844 | 105990 | Permitted Site 1 | Acer japonicum :: Japanese Maple 183 | 651X Duncan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6002337.0 | 2099724.0 | 37.745574339333 | -122.434624822764 | (37.745574339333, -122.434624822764) | |||||
| 87329 | 87329 | 120503 | Undocumented 2 | Acer japonicum :: Japanese Maple 183 | 50X Ecker St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013004.0 | 2115455.0 | 37.78936793935029 | -122.398843573251 | (37.7893679393503, -122.398843573251) | ||||
| 97988 | 97988 | 119267 | Undocumented 2 | Acer japonicum :: Japanese Maple 183 | 1321 Plymouth Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 10x4 | 5995851.8603726 | 2092807.77065035 | 37.726213767508895 | -122.456549245441 | (37.7262137675089, -122.456549245441) | |||
| 98742 | 98742 | 106973 | Undocumented 2 | Acer japonicum :: Japanese Maple 183 | 493 Day St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6002705.0 | 2098828.0 | 37.74313501676679 | -122.433288323925 | (37.7431350167668, -122.433288323925) | ||||
| 99731 | 99731 | 115673 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 86 Stanton St | Front Yard : Yard 7 | Tree 1 | Private 1 | 6000281.6 | 2103909.8 | 37.7569506357303 | -122.442032456595 | (37.7569506357303, -122.442032456595) | ||||||
| 103716 | 103716 | 107207 | Permitted Site 1 | Acer japonicum :: Japanese Maple 183 | 15 Fountain St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/08/2014 12:00:00 AM | 3x3 | Permit Number 769542 | 6000382.520330001 | 2101570.18202 | 37.7505323633681 | -122.441515551873 | (37.7505323633681, -122.441515551873) | |||
| 103751 | 103751 | 67240 | Permitted Site 1 | Acer japonicum :: Japanese Maple 183 | 332 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/10/1998 12:00:00 AM | 6 | Permit Number 30704 | 6003673.76431871 | 2108680.81312012 | 37.770243413934494 | -122.43064152058099 | (37.7702434139345, -122.430641520581) | |
| 107486 | 107486 | 95090 | Permitted Site 1 | Acer japonicum :: Japanese Maple 183 | 1409 Sanchez St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2010 12:00:00 AM | 3x3 | Permit Number 54028 | 6003943.0 | 2100028.0 | 37.746500093986604 | -122.429093192907 | (37.7465000939866, -122.429093192907) | ||
| 121718 | 121718 | 107408 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 10 PEMBERTON PL | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 5998956.5 | 2104566.5 | 37.7586781689727 | -122.446662380642 | (37.7586781689727, -122.446662380642) | ||||
| 121912 | 121912 | 111085 | Section 143 8 | Acer japonicum :: Japanese Maple 183 | 117 Manchester St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 05/20/2015 12:00:00 AM | 3 | Permit Number 774000 | 6008295.8 | 2099262.4 | 37.744643365507706 | -122.413987490618 | (37.7446433655077, -122.413987490618) | ||
| 122654 | 122654 | 116267 | Planning Code 138.1 required 4 | Acer japonicum :: Japanese Maple 183 | 717 PARIS ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6001138.0 | 2089523.0 | 37.717496606347495 | -122.438040195581 | (37.7174966063475, -122.438040195581) | ||||
| 126531 | 126531 | 112121 | Undocumented 2 | Acer japonicum :: Japanese Maple 183 | 428 COLLINGWOOD ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | 10x9 | 6002093.0 | 2103331.0 | 37.755464449457 | -122.435726554381 | (37.755464449457, -122.435726554381) | |||
| 128184 | 128184 | 25165 | DPW Maintained 3 | Acer japonicum :: Japanese Maple 183 | 2710 Market St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 2X2 | 6001331.1247754 | 2105649.2774538 | 37.761786570345706 | -122.438527441627 | (37.7617865703457, -122.438527441627) | |||
| 140136 | 140136 | 95089 | Permitted Site 1 | Acer japonicum :: Japanese Maple 183 | 1409 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/21/2010 12:00:00 AM | 3x3 | Permit Number 54028 | 6003943.0 | 2100028.0 | 37.746500093986604 | -122.429093192907 | (37.7465000939866, -122.429093192907) | ||
| 144956 | 144956 | 104445 | Significant Tree 6 | Acer japonicum :: Japanese Maple 183 | 507 Capp St | 2 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 2x6 | Permit Number 770679 | 6007300.0 | 2104257.5 | 37.7583027968034 | -122.41778477647301 | (37.7583027968034, -122.417784776473) |
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");