Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 32407 | 32407 | 866 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 600X Alemany Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6007241.9784 | 2095034.8696299999 | 37.7329762592527 | -122.41733187808398 | (37.7329762592527, -122.417331878084) | |||
| 43705 | 43705 | 190817 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 390x Hampshire St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 6010044.56493 | 2106488.02831 | 37.7645813917285 | -122.40845015844101 | (37.7645813917285, -122.408450158441) | |||
| 45155 | 45155 | 190814 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 390x Hampshire St | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 16 | Width 5ft | 6010041.1190599995 | 2106539.02685 | 37.7647212291204 | -122.40846567444599 | (37.7647212291204, -122.408465674446) | |||
| 46600 | 46600 | 116804 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 131 LAKESHORE DR | 1 | Median : Yard 3 | Landscaping 2 | DPW 2 | 10x100 | 5984782.0 | 2094243.0 | 37.7295127607338 | -122.494922366174 | (37.7295127607338, -122.494922366174) | ||||
| 75147 | 75147 | 129353 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 51 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | Width 8ft | 6011391.406830001 | 2120329.06369 | 37.8026609588854 | -122.404766271855 | (37.8026609588854, -122.404766271855) | |||
| 86324 | 86324 | 121732 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1301 Vermont St | 7 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011430.0 | 2102074.0 | 37.75253893927721 | -122.403347738299 | (37.7525389392772, -122.403347738299) | ||||
| 95182 | 95182 | 16377 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1400X Montgomery St | 10 | Median : Cutout 11 | Tree 1 | DPW 2 | 18 | 8 | 6011455.2971485 | 2120087.0441833 | 37.8020000032358 | -122.404528131508 | (37.8020000032358, -122.404528131508) | |||
| 100221 | 100221 | 5821 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1027 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 75 | 3X3 | 5999811.0829915 | 2099731.7400522 | 37.745451872839 | -122.443359584044 | (37.745451872839, -122.443359584044) | |||
| 104252 | 104252 | 121734 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1301 Vermont St | 9 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 6011430.0 | 2102074.0 | 37.75253893927721 | -122.403347738299 | (37.7525389392772, -122.403347738299) | ||||
| 110428 | 110428 | 12623 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 825 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 27 | 3X3 | 5992882.168 | 2114794.01241 | 37.7864113245051 | -122.468414093066 | (37.7864113245051, -122.468414093066) | |||
| 112118 | 112118 | 878 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 600X Alemany Blvd | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 1X1 | 6007241.9784 | 2095034.8696299999 | 37.7329762592527 | -122.41733187808398 | (37.7329762592527, -122.417331878084) | |||
| 135071 | 135071 | 190816 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 390x Hampshire St | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 5ft | 6010044.10542 | 2106509.4810599997 | 37.7646402703573 | -122.40845326111099 | (37.7646402703573, -122.408453261111) | |||
| 139863 | 139863 | 24744 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 128X Point Lobos Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/02/1996 12:00:00 AM | 3 | 3x3 | 5982380.471419999 | 2112632.1433099997 | 37.7798632908372 | -122.504586464809 | (37.7798632908372, -122.504586464809) | ||
| 154652 | 154652 | 129351 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 39 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | Width 8ft | 6011425.67929 | 2120161.57643 | 37.8022029953207 | -122.404635873741 | (37.8022029953207, -122.404635873741) | |||
| 163136 | 163136 | 129352 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 45 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | Width 8ft | 6011406.69978 | 2120255.02893 | 37.8024585322873 | -122.404708135188 | (37.8024585322873, -122.404708135188) | |||
| 175803 | 175803 | 129354 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 52 | Median : Yard 3 | Tree 1 | DPW 2 | 14 | Width 8ft | 6011388.89614 | 2120338.61388 | 37.8026870410416 | -122.40477563290199 | (37.8026870410416, -122.404775632902) | |||
| 181902 | 181902 | 190815 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 390x Hampshire St | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 5ft | 6010042.68497 | 2106527.82648 | 37.7646905631515 | -122.408459468238 | (37.7646905631515, -122.408459468238) | |||
| 183528 | 183528 | 219372 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 400x Marietta Dr | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | Width 3ft | 5999397.86314 | 2097051.08053 | 37.7380678498474 | -122.444595794674 | (37.7380678498474, -122.444595794674) | |||
| 188999 | 188999 | 129349 | DPW Maintained 3 | Juniperus chinensis :: Juniper 19 | 1306x Montgomery St | 35 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | Width 8ft | 6011426.64663 | 2120143.89656 | 37.8021545047788 | -122.40463128093398 | (37.8021545047788, -122.404631280934) |
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");