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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 164875 | 164875 | 125589 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 2500 Francisco St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 5999280.9627 | 2119804.58635 | 37.8005365515701 | -122.446636601905 | (37.8005365515701, -122.446636601905) | |||
| 166592 | 166592 | 118482 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 8349 Geary Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5981039.36975 | 2112282.68151 | 37.7788247951526 | -122.509199886896 | (37.7788247951526, -122.509199886896) | ||||
| 167937 | 167937 | 175535 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 802 Excelsior Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 6ft | 6004451.66624 | 2091408.82441 | 37.7228625596499 | -122.42672058818998 | (37.7228625596499, -122.42672058819) | |||
| 171620 | 171620 | 175404 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 791 Cayuga Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 6001267.74485 | 2092320.87185 | 37.725186308890294 | -122.437792005219 | (37.7251863088903, -122.437792005219) | |||
| 171941 | 171941 | 175533 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 802 Excelsior Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6004414.28275 | 2091431.5690799998 | 37.7229228978625 | -122.426851434158 | (37.7229228978625, -122.426851434158) | |||
| 172967 | 172967 | 125610 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 400 Euclid Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 5997341.77442 | 2113883.05363 | 37.7841666528188 | -122.452919283707 | (37.7841666528188, -122.452919283707) | |||
| 176222 | 176222 | 204191 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 300 Mangels Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | 5999378.70206 | 2095270.00955 | 37.73317635629571 | -122.44453407238701 | (37.7331763562957, -122.444534072387) | ||||
| 180626 | 180626 | 221018 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 4719 18th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 3ft | 5999826.598040001 | 2105058.19081 | 37.7600778944879 | -122.44368851721201 | (37.7600778944879, -122.443688517212) | |||
| 181856 | 181856 | 175429 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 71 Mansfield St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 6005291.55613 | 2091812.29845 | 37.7240178611328 | -122.423845937645 | (37.7240178611328, -122.423845937645) | ||||
| 181898 | 181898 | 175416 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 242 Mount Vernon Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | 5998753.41529 | 2089599.85175 | 37.717571723930604 | -122.446288102908 | (37.7175717239306, -122.446288102908) | ||||
| 184693 | 184693 | 222050 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 Treat Ave | 13 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6008988.1834 | 2107834.71836 | 37.7682198760784 | -122.412199097531 | (37.7682198760784, -122.412199097531) | ||||
| 185121 | 185121 | 222054 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 Treat Ave | 17 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6009039.4166 | 2107896.45275 | 37.76839225903311 | -122.41202624962601 | (37.7683922590331, -122.412026249626) | ||||
| 185834 | 185834 | 204184 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 38 Nordhoff St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 8ft | 6000455.88706 | 2095418.88157 | 37.733646529945 | -122.440820638554 | (37.733646529945, -122.440820638554) | |||
| 185966 | 185966 | 204801 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1810 16th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5991265.21756 | 2103069.59229 | 37.7541257072513 | -122.47315291637 | (37.7541257072513, -122.47315291637) | |||
| 186230 | 186230 | 124093 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 601 Funston Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | 5991890.71648 | 2111223.1855 | 37.7765494976525 | -122.47158392790001 | (37.7765494976525, -122.4715839279) | ||||
| 187667 | 187667 | 188050 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 651 Missouri St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6013666.75973 | 2103848.0054099998 | 37.7575346486134 | -122.39573687526001 | (37.7575346486134, -122.39573687526) | ||||
| 188157 | 188157 | 222051 | Undocumented 2 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 201 Treat Ave | 14 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | 6009002.14028 | 2107849.4775900003 | 37.7682611846314 | -122.41215186512301 | (37.7682611846314, -122.412151865123) |
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");