Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17486 | 17486 | 18596 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 409 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/1996 12:00:00 AM | 6 | 3X3 | 5992903.2652 | 2088492.7734 | 37.7141961040887 | -122.46642881780501 | (37.7141961040887, -122.466428817805) | ||
| 17788 | 17788 | 18608 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 550 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/03/1997 12:00:00 AM | 6 | 3X3 | 5992502.2173 | 2088557.38 | 37.7143503484358 | -122.467819678694 | (37.7143503484358, -122.467819678694) | ||
| 18385 | 18385 | 25468 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 437 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/26/1996 12:00:00 AM | 6 | 3X3 | 5992774.4094 | 2088493.0908 | 37.7141895393891 | -122.466874212626 | (37.7141895393891, -122.466874212626) | ||
| 21649 | 21649 | 18607 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 530 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/1996 12:00:00 AM | 6 | 3x3 | 5992558.0676 | 2088557.0731 | 37.7143527306111 | -122.467626617395 | (37.7143527306111, -122.467626617395) | ||
| 24847 | 24847 | 214027 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 130 Baden St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6000768.47308 | 2094513.82924 | 37.7311792633149 | -122.439675077667 | (37.7311792633149, -122.439675077667) | |||
| 25257 | 25257 | 240410 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 235 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6001912.29637 | 2096185.45895 | 37.735834211766 | -122.43584024433599 | (37.735834211766, -122.435840244336) | |||
| 25889 | 25889 | 48457 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 520 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/05/2002 12:00:00 AM | 6 | Permit Number 45824 | 6011919.3472 | 2110495.26684 | 37.7756891719521 | -122.402247516312 | (37.7756891719521, -122.402247516312) | ||
| 32809 | 32809 | 137686 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2143 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999343.9567 | 2111495.7816 | 37.7777263543907 | -122.445820725833 | (37.7777263543907, -122.445820725833) | |||
| 33363 | 33363 | 240383 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 65 Hermann St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6004954.4402 | 2108809.15318 | 37.770668274943205 | -122.426220805247 | (37.7706682749432, -122.426220805247) | |||
| 56835 | 56835 | 240403 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 557 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002931.13898 | 2099759.29881 | 37.7457049727185 | -122.43257290392799 | (37.7457049727185, -122.432572903928) | |||
| 66574 | 66574 | 214018 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2464 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991736.67899 | 2098669.28572 | 37.742070888761894 | -122.47120193253001 | (37.7420708887619, -122.47120193253) | |||
| 70628 | 70628 | 240402 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 4440 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6000362.39575 | 2102290.8235 | 37.7525099241126 | -122.441636854259 | (37.7525099241126, -122.441636854259) | |||
| 73887 | 73887 | 214033 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 342 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5997821.19553 | 2093821.6931599998 | 37.7291106283447 | -122.449814429211 | (37.7291106283447, -122.449814429211) | |||
| 74280 | 74280 | 217578 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 308 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5993138.4427 | 2088550.8537 | 37.7143691463099 | -122.46562017697799 | (37.7143691463099, -122.465620176978) | |||
| 79717 | 79717 | 10670 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1045 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6002868.606349099 | 2110598.6567928 | 37.775463691965896 | -122.43356363564301 | (37.7754636919659, -122.433563635643) | |||
| 83025 | 83025 | 7243 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 1929X Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6002956.0424065 | 2114080.0912444 | 37.7850277993699 | -122.43351002509701 | (37.7850277993699, -122.433510025097) | |||
| 84043 | 84043 | 73758 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 2220 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/17/1996 12:00:00 AM | 6 | 5988694.038819999 | 2110577.4842 | 37.774591123751605 | -122.48259469871799 | (37.7745911237516, -122.482594698718) | ||
| 111533 | 111533 | 25183 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 3448X Market St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/19/1996 12:00:00 AM | 6 | 3X3 | 6000085.2661190005 | 2103906.7160847997 | 37.7569309776636 | -122.442711229464 | (37.7569309776636, -122.442711229464) | ||
| 113357 | 113357 | 18570 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 698X Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1997 12:00:00 AM | 6 | 3X3 | 5992368.005846401 | 2088553.4079402 | 37.7143316913291 | -122.46828327353701 | (37.7143316913291, -122.468283273537) | ||
| 113563 | 113563 | 18603 | DPW Maintained 3 | Rhamnus alaternus :: Italian Buckthorn 45 | 520 Randolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/25/1996 12:00:00 AM | 6 | 3X3 | 5992619.61154 | 2088559.40218 | 37.7143626789426 | -122.467414068351 | (37.7143626789426, -122.467414068351) | ||
| 132552 | 132552 | 136315 | Undocumented 2 | Rhamnus alaternus :: Italian Buckthorn 45 | 895 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6009067.06929 | 2119033.92208 | 37.7989746333364 | -122.41271806751001 | (37.7989746333364, -122.41271806751) | |||
| 136514 | 136514 | 35869 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 1 Boutwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/24/1998 12:00:00 AM | 6 | Permit Number 39080 | 6010666.93779 | 2096840.63562 | 37.7381266097475 | -122.40561798198799 | (37.7381266097475, -122.405617981988) | |
| 162171 | 162171 | 63485 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 2159 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/07/1987 12:00:00 AM | 6 | Permit Number 24080 | 5999253.53185357 | 2111483.89157027 | 37.77768854395789 | -122.44613267975299 | (37.7776885439579, -122.446132679753) | |
| 183550 | 183550 | 32520 | Permitted Site 1 | Rhamnus alaternus :: Italian Buckthorn 45 | 848 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/15/1996 12:00:00 AM | 6 | Permit Number 37022 | 6007545.9989 | 2095398.0670900003 | 37.7339906204551 | -122.416306512649 | (37.7339906204551, -122.416306512649) |
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");