Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlantDate, DBH, PlotSize, PermitNotes, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4001 | 4001 | 96367 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 1326 Green St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2011 12:00:00 AM | 10 | 3x3 | Permit Number 767927 | 6006638.67124 | 2118739.19153 | 37.798028781266 | -122.42110020940399 | (37.798028781266, -122.421100209404) | |
| 24801 | 24801 | 179172 | Undocumented 2 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 766 Brussels St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6011071.2158 | 2091212.4916599998 | 37.7226955033774 | -122.403824260795 | (37.7226955033774, -122.403824260795) | |||
| 38374 | 38374 | 136055 | Undocumented 2 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 1114 Greenwich St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 6 | 6007559.35658 | 2119902.6850400004 | 37.8012753005604 | -122.417996888269 | (37.8012753005604, -122.417996888269) | ||||
| 45205 | 45205 | 213733 | Undocumented 2 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 185 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993500.83999 | 2094145.3739200002 | 37.7297512388321 | -122.46477362350402 | (37.7297512388321, -122.464773623504) | |||
| 47617 | 47617 | 136056 | Undocumented 2 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 1821 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008246.73056 | 2118726.15344 | 37.7980835005213 | -122.415534919517 | (37.7980835005213, -122.415534919517) | |||
| 54914 | 54914 | 179171 | Undocumented 2 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 424 Ellington Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5998427.605819999 | 2087535.4733799999 | 37.711884799823295 | -122.44726577840599 | (37.7118847998233, -122.447265778406) | |||
| 54923 | 54923 | 213734 | Undocumented 2 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 1272 06th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5994263.31306 | 2106836.80145 | 37.7646426229904 | -122.46305816221 | (37.7646426229904, -122.46305816221) | |||
| 79680 | 79680 | 94650 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 315 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53788 | 6004384.0 | 2096385.0 | 37.7365222023985 | -122.427308799379 | (37.7365222023985, -122.427308799379) | |
| 81644 | 81644 | 107751 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 865 Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774060 | 6000974.16121 | 2099624.59634 | 37.74522393852921 | -122.439330175434 | (37.7452239385292, -122.439330175434) | |
| 81827 | 81827 | 94674 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 487 Laidley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53810 | 6003431.0 | 2096274.0 | 37.7361634787457 | -122.430595806407 | (37.7361634787457, -122.430595806407) | |
| 85084 | 85084 | 94651 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 315 Arlington St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53788 | 6004384.0 | 2096385.0 | 37.7365222023985 | -122.427308799379 | (37.7365222023985, -122.427308799379) | |
| 87424 | 87424 | 46267 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 442 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53790 | 6003891.38270828 | 2096052.65424899 | 37.7355817841202 | -122.428988298919 | (37.7355817841202, -122.428988298919) | |
| 101809 | 101809 | 107750 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 865 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/2014 12:00:00 AM | 3 | 3x3 | Permit Number 774060 | 6000974.16121 | 2099624.59634 | 37.74522393852921 | -122.439330175434 | (37.7452239385292, -122.439330175434) | |
| 106207 | 106207 | 57733 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 319 Arlington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53789 | 6004369.0 | 2096373.0 | 37.736488404776296 | -122.427359806199 | (37.7364884047763, -122.427359806199) | |
| 107155 | 107155 | 99941 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 182 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/10/2012 12:00:00 AM | 3x3 | Permit Number 769134 | 6003955.9 | 2092670.0 | 37.7262974264753 | -122.42852420031001 | (37.7262974264753, -122.42852420031) | ||
| 116519 | 116519 | 94677 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 1769 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/22/2010 12:00:00 AM | 3x3 | Permit Number 53813 | 6003429.0 | 2097986.0 | 37.740864125247796 | -122.430724853295 | (37.7408641252478, -122.430724853295) | |
| 120711 | 120711 | 108458 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 756 12th Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 3x3 | Permit Number 773789 | 5992285.05339 | 2110293.92869 | 37.7740208158449 | -122.47015213289801 | (37.7740208158449, -122.470152132898) | |||
| 121826 | 121826 | 62450 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 830 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1985 12:00:00 AM | 3x3 | Permit Number 770523 | 5998051.57475048 | 2107414.07098441 | 37.766445148089204 | -122.449997242519 | (37.7664451480892, -122.449997242519) | ||
| 122778 | 122778 | 63663 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 3935 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1987 12:00:00 AM | 2 | 3x3 | Permit Number 24312 | 6004315.94111181 | 2100412.82772504 | 37.7475778460258 | -122.42783101924299 | (37.7475778460258, -122.427831019243) | |
| 130014 | 130014 | 39932 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 179 Arleta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | 8 | Permit Number 48169 | 6010269.41426 | 2087965.6956200001 | 37.7137356423509 | -122.406367268328 | (37.7137356423509, -122.406367268328) | |
| 138150 | 138150 | 239030 | Undocumented 2 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 4521 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6000872.90431 | 2101105.1902900003 | 37.7492835334236 | -122.439786436197 | (37.7492835334236, -122.439786436197) | |||
| 141937 | 141937 | 92000 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 1393 Bacon St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/21/2009 12:00:00 AM | 3x3 | Permit Number 52152 | 6007474.0 | 2091791.0 | 37.724082345197104 | -122.416300041455 | (37.7240823451971, -122.416300041455) | |||
| 144896 | 144896 | 79557 | Permitted Site 1 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 153 Buchanan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/2014 12:00:00 AM | 3 | 3x3 | Permit Number 772536 | 6004741.65189255 | 2108986.02751221 | 37.7711418993687 | -122.426969442731 | (37.7711418993687, -122.426969442731) |
| 144970 | 144970 | 179173 | Undocumented 2 | Prunus x yedoensis 'Akebono' :: Daybreak Yoshino Cherry 220 | 136 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6001549.186980001 | 2087334.6879 | 37.7115113626193 | -122.43646237733299 | (37.7115113626193, -122.436462377333) |
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");