Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5049 | 5049 | 3594 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 30 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3x3 | 6018322.1359 | 2097981.33701 | 37.741683843926396 | -122.379229056502 | (37.7416838439264, -122.379229056502) | |||
| 5070 | 5070 | 3618 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 54 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017899.85524 | 2098296.735 | 37.7425265680461 | -122.380711096061 | (37.7425265680461, -122.380711096061) | |||
| 13807 | 13807 | 3515 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 25 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/30/1990 12:00:00 AM | 12 | 3X3 | 6018092.0886699995 | 2098050.06678 | 37.741859873634205 | -122.380029266058 | (37.7418598736342, -122.380029266058) | ||
| 13941 | 13941 | 3603 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 39 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6018171.24251 | 2098094.76588 | 37.741986974834106 | -122.379758679838 | (37.7419869748341, -122.379758679838) | |||
| 14056 | 14056 | 3640 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 76 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017536.43295 | 2098576.56598 | 37.7432748642351 | -122.381987176477 | (37.7432748642351, -122.381987176477) | |||
| 14225 | 14225 | 3498 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017700.75455 | 2098337.80167 | 37.7426283389164 | -122.381402389631 | (37.7426283389164, -122.381402389631) | |||
| 14413 | 14413 | 3500 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017738.77776 | 2098309.39264 | 37.7425524325559 | -122.381268940124 | (37.7425524325559, -122.381268940124) | |||
| 15070 | 15070 | 3495 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017646.36043 | 2098378.21595 | 37.742736305236605 | -122.381593280624 | (37.7427363052366, -122.381593280624) | |||
| 15214 | 15214 | 3606 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 42 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6018122.20462 | 2098131.02661 | 37.742083834489605 | -122.379930757907 | (37.7420838344896, -122.379930757907) | |||
| 15250 | 15250 | 3496 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017663.23695 | 2098365.77973 | 37.74270308968379 | -122.381534061174 | (37.7427030896838, -122.381534061174) | |||
| 15552 | 15552 | 3616 | Permitted Site 1 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 52 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017954.336080001 | 2098256.07975 | 37.7424179434233 | -122.38051989028901 | (37.7424179434233, -122.380519890289) | |||
| 15955 | 15955 | 3494 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017631.184309999 | 2098389.6910900003 | 37.7427669757157 | -122.38164655374099 | (37.7427669757157, -122.381646553741) | |||
| 16339 | 16339 | 3548 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 201X Cargo Way | 58 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018674.8366 | 2097616.25665 | 37.7407008489755 | -122.37798418701999 | (37.7407008489755, -122.37798418702) | |||
| 22315 | 22315 | 3636 | Private 5 | Quercus ilex :: Holly Oak 78 | 100X Cargo Way | 72 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 12 | 3X3 | 6017599.14752 | 2098522.45762 | 37.7431297568333 | -122.38176656108601 | (37.7431297568333, -122.381766561086) |
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");