Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, DBH, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▼ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 195 | 195 | 138365 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2060 SUTTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 19 | Width 0ft | 6002748.6045 | 2114451.296 | 37.78603526200121 | -122.43425424087799 | (37.7860352620012, -122.434254240878) | |||
| 273 | 273 | 20166 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1155X Steiner St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 4X4 | 6002621.0 | 2112212.0 | 37.7798794773869 | -122.43453554599199 | (37.7798794773869, -122.434535545992) | |||
| 1759 | 1759 | 7200 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 949 Fillmore St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003420.9887 | 2111521.8792 | 37.7780299575939 | -122.431718745255 | (37.7780299575939, -122.431718745255) | |||
| 3335 | 3335 | 140428 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 1499 TURK ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Police Dept 18 | 14 | Width 0ft | 6003076.6138 | 2112365.9894 | 37.7803281468599 | -122.43297038187401 | (37.7803281468599, -122.432970381874) | |||
| 5145 | 5145 | 4664 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 600X Columbus Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 90 | 5X5 | 6009692.467999999 | 2119649.5892 | 37.8007001848924 | -122.410597470914 | (37.8007001848924, -122.410597470914) | |||
| 8244 | 8244 | 99232 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1111 Columbus Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008054.705 | 2121057.3439 | 37.8044735696368 | -122.416364591045 | (37.8044735696368, -122.416364591045) | |||
| 18580 | 18580 | 497 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 2749X 24th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6010516.451 | 2102220.2128 | 37.75288934158429 | -122.40651726425399 | (37.7528893415843, -122.406517264254) | |||
| 22044 | 22044 | 15319 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1680 Mission St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006779.4102 | 2108712.5677 | 37.77050605746361 | -122.41990134010099 | (37.7705060574636, -122.419901340101) | |||
| 23633 | 23633 | 137529 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1300 Pierce St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6002258.0131 | 2113181.285 | 37.7825202770743 | -122.43586064910801 | (37.7825202770743, -122.435860649108) | |||
| 26537 | 26537 | 199734 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1500 Armstrong Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6014741.5822 | 2092253.0007 | 37.725756899909 | -122.391209195431 | (37.725756899909, -122.391209195431) | |||
| 46867 | 46867 | 140710 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 500 PIERCE ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6002647.4691 | 2110413.42 | 37.7749425283913 | -122.434315354923 | (37.7749425283913, -122.434315354923) | |||
| 50506 | 50506 | 140544 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1025 FILLMORE ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003387.6502 | 2111766.8151 | 37.7787006008552 | -122.431851568456 | (37.7787006008552, -122.431851568456) | |||
| 60153 | 60153 | 140509 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1020 FILLMORE ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6003414.9884 | 2111885.4448 | 37.779027878196004 | -122.43176546737101 | (37.779027878196, -122.431765467371) | |||
| 133245 | 133245 | 246094 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 700 Stanyan St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5997100.0026 | 2108265.6377 | 37.7687288366145 | -122.453350026115 | (37.7687288366145, -122.453350026115) | |||
| 136070 | 136070 | 111735 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 313 Ivy St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 2.5x3 | 6005874.8827 | 2111210.5438 | 37.7773138971451 | -122.423207702005 | (37.7773138971451, -122.423207702005) | |||
| 148089 | 148089 | 141688 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2350 TURK BLVD | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5998531.7594 | 2111801.3756 | 37.7785190283548 | -122.44865239820801 | (37.7785190283548, -122.448652398208) | |||
| 150951 | 150951 | 138127 | DPW Maintained 3 | Ficus retusa nitida :: Banyan Fig 59 | 1850 FILLMORE ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 0ft | 6003021.61 | 2114689.1851 | 37.78670393670271 | -122.433326721425 | (37.7867039367027, -122.433326721425) | |||
| 161834 | 161834 | 143353 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 1651 UNION ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6005181.3418 | 2118836.9868 | 37.7982150414331 | -122.42614995936701 | (37.7982150414331, -122.426149959367) | |||
| 173501 | 173501 | 142596 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 365 COLUMBUS AVE | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6008359.2007 | 2120780.7848 | 37.8037313259866 | -122.415291263605 | (37.8037313259866, -122.415291263605) | |||
| 176045 | 176045 | 199858 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 2513 Keith St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6014132.4385 | 2092038.2943 | 37.7251335354362 | -122.393299957721 | (37.7251335354362, -122.393299957721) | |||
| 176204 | 176204 | 143255 | Undocumented 2 | Ficus retusa nitida :: Banyan Fig 59 | 661 LOMBARD ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6009331.5401 | 2120459.4412 | 37.802903595680704 | -122.411903695843 | (37.8029035956807, -122.411903695843) | |||
| 179301 | 179301 | 110471 | Permitted Site 1 | Ficus retusa nitida :: Banyan Fig 59 | 465 Grove St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12 | 3x3 | 6005689.0684 | 2111342.3906 | 37.77766542832121 | -122.42385987213899 | (37.7776654283212, -122.423859872139) |
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");