Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4518 | 4518 | 225796 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3000X 21st St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008035.828509999 | 2103884.08468 | 37.7573188652869 | -122.415213517995 | (37.7573188652869, -122.415213517995) | |||
| 7259 | 7259 | 23270 | DPW Maintained 3 | Fraxinus spp :: Ash Spp 83 | 843X Van Ness Ave | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 24 | 3X3 | 6006591.05831 | 2113351.86982 | 37.783233848997 | -122.42088227939101 | (37.783233848997, -122.420882279391) | |||
| 25338 | 25338 | 225387 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Chattanooga St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6004770.30193 | 2101839.2583 | 37.7515201869079 | -122.426361411567 | (37.7515201869079, -122.426361411567) | |||
| 28167 | 28167 | 192309 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 100 De Haro St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6011943.7523300005 | 2107376.90821 | 37.767128230416105 | -122.401943831469 | (37.7671282304161, -122.401943831469) | |||
| 32509 | 32509 | 192275 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1490 Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009036.05094 | 2108770.66843 | 37.7707924632209 | -122.412099681957 | (37.7707924632209, -122.412099681957) | |||
| 33435 | 33435 | 192252 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6009308.54371 | 2108355.35398 | 37.7696673915621 | -122.411127779219 | (37.7696673915621, -122.411127779219) | |||
| 33563 | 33563 | 192305 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2599 Mariposa St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009925.06485 | 2105936.96188 | 37.763061595931894 | -122.40882459747 | (37.7630615959319, -122.40882459747) | |||
| 34317 | 34317 | 192232 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 1192 Bryant St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009598.466630001 | 2108528.5531599997 | 37.7701592110077 | -122.41013717060899 | (37.7701592110077, -122.410137170609) | |||
| 40518 | 40518 | 192261 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 450 11th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009200.74359 | 2108465.0274400003 | 37.769962483400796 | -122.41150840741001 | (37.7699624834008, -122.41150840741) | |||
| 42776 | 42776 | 225811 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 197 Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 3ft | 6002903.222130001 | 2107175.55757 | 37.766066667072 | -122.43319924936701 | (37.766066667072, -122.433199249367) | |||
| 46017 | 46017 | 192334 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 65 10th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6007885.81479 | 2110555.97346 | 37.775629883255796 | -122.416204846094 | (37.7756298832558, -122.416204846094) | |||
| 49592 | 49592 | 11636 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 499X Junipero Serra Blvd | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | PUC 13 | 12 | 3 | 5991474.53212 | 2093889.5616418 | 37.7289318087747 | -122.471760091134 | (37.7289318087747, -122.471760091134) | |||
| 49946 | 49946 | 192325 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 193 Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6011700.9501 | 2107853.89642 | 37.768424378313206 | -122.40281720266199 | (37.7684243783132, -122.402817202662) | |||
| 52799 | 52799 | 192306 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 3600 03rd St | 4 | : 4 | Tree 1 | Private 1 | 21 | Width 5ft | 6015896.02327 | 2098855.55467 | 37.74395018136929 | -122.38767879773701 | (37.7439501813693, -122.387678797737) | |||
| 62979 | 62979 | 128816 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 215 Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 4ft | 6008534.849640001 | 2112776.4712099996 | 37.7817633144723 | -122.414116796578 | (37.7817633144723, -122.414116796578) | |||
| 66462 | 66462 | 192315 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 195 Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 5ft | 6011711.98857 | 2107614.42243 | 37.7677674532432 | -122.402762177653 | (37.7677674532432, -122.402762177653) | |||
| 69720 | 69720 | 192302 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 2250 24th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6011784.47888 | 2102348.07827 | 37.753311290205296 | -122.402141149916 | (37.7533112902053, -122.402141149916) | |||
| 118261 | 118261 | 33474 | Permitted Site 1 | Fraxinus spp :: Ash Spp 83 | 190 Coleridge St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/20/1996 12:00:00 AM | Permit Number 37572 | 6006437.49245401 | 2098651.34949844 | 37.742861013201704 | -122.420369801641 | (37.7428610132017, -122.420369801641) | |||
| 129868 | 129868 | 192343 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 10 10th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6007880.06697 | 2110469.37964 | 37.7753917940266 | -122.416218594918 | (37.7753917940266, -122.416218594918) | |||
| 130927 | 130927 | 109476 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 300 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 6012009.31763 | 2118795.25368 | 37.7984840054917 | -122.402520057652 | (37.7984840054917, -122.402520057652) | |||
| 137651 | 137651 | 128821 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 99 Leavenworth St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6008602.80861 | 2112693.55273 | 37.7815394570312 | -122.41387582233 | (37.7815394570312, -122.41387582233) | |||
| 138106 | 138106 | 225814 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 159 Noe St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6002898.26283 | 2107347.8267 | 37.7665393948003 | -122.43322871294501 | (37.7665393948003, -122.433228712945) | |||
| 155272 | 155272 | 75920 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 350 Broadway | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/07/1995 12:00:00 AM | 12 | 6011822.33856 | 2118769.3001099997 | 37.7984023029841 | -122.403165240278 | (37.7984023029841, -122.403165240278) | ||
| 166557 | 166557 | 192206 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 340 10th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6009319.54279 | 2108962.9583900003 | 37.77133634892171 | -122.411132658949 | (37.7713363489217, -122.411132658949) | |||
| 170242 | 170242 | 192294 | Undocumented 2 | Fraxinus spp :: Ash Spp 83 | 551 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6010701.8989 | 2105624.20056 | 37.7622463056326 | -122.40611574324 | (37.7622463056326, -122.40611574324) |
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");