Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7526 | 7526 | 2669 | Permitted Site 1 | Persea borbonia :: False Avocado 244 | 2035 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6003729.7924 | 2114882.8113 | 37.7872757358691 | -122.43089040403099 | (37.7872757358691, -122.430890404031) | |||
| 78851 | 78851 | 21677 | DPW Maintained 3 | Persea borbonia :: False Avocado 244 | 1800 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6003970.2090836 | 2114619.2359317 | 37.7865656432478 | -122.430039804056 | (37.7865656432478, -122.430039804056) | |||
| 95710 | 95710 | 2668 | Permitted Site 1 | Persea borbonia :: False Avocado 244 | 2033 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/23/1982 12:00:00 AM | 20 | 3x3 | 6003766.67465 | 2114868.62032 | 37.787238860683104 | -122.430761786233 | (37.7872388606831, -122.430761786233) | ||
| 97105 | 97105 | 13138 | DPW Maintained 3 | Persea borbonia :: False Avocado 244 | 1769 Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/22/1994 12:00:00 AM | 50 | 3X3 | 6003923.81049 | 2119648.33681 | 37.800371642588395 | -122.43055931461599 | (37.8003716425884, -122.430559314616) | ||
| 98147 | 98147 | 21678 | DPW Maintained 3 | Persea borbonia :: False Avocado 244 | 1800 Sutter St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4x4 | 6003970.2090836 | 2114619.2359317 | 37.7865656432478 | -122.430039804056 | (37.7865656432478, -122.430039804056) | |||
| 106251 | 106251 | 13123 | DPW Maintained 3 | Persea borbonia :: False Avocado 244 | 1671 Lombard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3X3 | 6004412.3101699995 | 2119715.97512 | 37.8005850211999 | -122.428873735983 | (37.8005850211999, -122.428873735983) | |||
| 121745 | 121745 | 17198 | DPW Maintained 3 | Persea borbonia :: False Avocado 244 | 1675X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 3x3 | 6004367.95797 | 2119722.65234 | 37.8006008446769 | -122.42902768903099 | (37.8006008446769, -122.429027689031) | |||
| 131842 | 131842 | 143118 | DPW Maintained 3 | Persea borbonia :: False Avocado 244 | 1675X Lombard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | Width 0ft | 6004371.2706 | 2119743.6634 | 37.8006587231355 | -122.429017724856 | (37.8006587231355, -122.429017724856) |
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");