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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28919 | 28919 | 90914 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3050X Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5989136.088409999 | 2111955.70702 | 37.7784010475601 | -122.48116652116501 | (37.7784010475601, -122.481166521165) | ||
| 79442 | 79442 | 90927 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3309 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5988374.16306 | 2111873.0452900003 | 37.7781297578465 | -122.483796211577 | (37.7781297578465, -122.483796211577) | ||
| 80389 | 80389 | 90916 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3342 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5988281.76291 | 2111927.4637 | 37.778273796306 | -122.48411984494899 | (37.778273796306, -122.484119844949) | ||
| 83556 | 83556 | 90922 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4601 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5984359.943030001 | 2111727.94801 | 37.777496869554206 | -122.497671921843 | (37.7774968695542, -122.497671921843) | ||
| 89378 | 89378 | 46154 | Permitted Site 1 | Prunus serrulata 'Kwanzan' :: Kwanzan Flowering Cherry 18 | 466 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2008 12:00:00 AM | 3x3 | Permit Number 51922 | 5997486.25604709 | 2107473.80664401 | 37.766576803009 | -122.45195687708201 | (37.766576803009, -122.451956877082) | ||
| 95005 | 95005 | 90923 | DPW Maintained 3 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 4239 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5985467.79642 | 2111768.32537 | 37.7776726131943 | -122.493842520581 | (37.7776726131943, -122.493842520581) | ||
| 95754 | 95754 | 90925 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3849X Anza St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5986753.433769001 | 2111821.240765 | 37.7778930383067 | -122.489399014928 | (37.7778930383067, -122.489399014928) | |
| 107653 | 107653 | 90924 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4233 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5985493.49961 | 2111768.66026 | 37.7776750364803 | -122.493753630464 | (37.7776750364803, -122.493753630464) | ||
| 108372 | 108372 | 90917 | DPW Maintained 3 | Pyrus calleryana :: Ornamental Pear 9 | 3342 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5988262.25204 | 2111926.42905 | 37.778269819478396 | -122.484187263511 | (37.7782698194784, -122.484187263511) | ||
| 108903 | 108903 | 90918 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3718 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5987075.42224 | 2111883.2624 | 37.7780821233805 | -122.48828971759501 | (37.7780821233805, -122.488289717595) | ||
| 109181 | 109181 | 90915 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3228 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5988669.966739 | 2111929.945878 | 37.7783032057889 | -122.482777102874 | (37.7783032057889, -122.482777102874) | |
| 109728 | 109728 | 90926 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3835 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5986737.80206 | 2111811.5435099998 | 37.7778654998636 | -122.489452376533 | (37.7778654998636, -122.489452376533) | ||
| 112216 | 112216 | 90913 | DPW Maintained 3 | Eriobotrya deflexa :: Bronze Loquat 49 | 2400X Anza St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5991148.92064 | 2112028.22065 | 37.778716959932396 | -122.474208743203 | (37.7787169599324, -122.474208743203) | ||
| 116740 | 116740 | 90919 | DPW Maintained 3 | Quercus ilex :: Holly Oak 78 | 5048 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 5 | 3x3 | 5982934.22783 | 2111732.57013 | 37.7774258833955 | -122.502604205438 | (37.7774258833955, -122.502604205438) | ||
| 119261 | 119261 | 90929 | DPW Maintained 3 | Tristaniopsis laurina :: Swamp Myrtle 37 | 4425 Anza St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Cleary Bros. Landscape 8 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5984963.926317 | 2111755.997226 | 37.7776092710215 | -122.49558464338101 | (37.7776092710215, -122.495584643381) | |
| 139361 | 139361 | 90928 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 3245 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/10/2008 12:00:00 AM | 3 | 3x3 | 5988532.97415 | 2111879.8724599998 | 37.778157746757 | -122.483247333765 | (37.778157746757, -122.483247333765) | ||
| 144202 | 144202 | 89330 | Permitted Site 1 | Acer palmatum :: Japanese Maple 175 | 846 Junipero Serra Blvd | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/10/2008 12:00:00 AM | 3x3 | Permit Number 51923 | 5991242.2 | 2091754.0 | 37.723054643014 | -122.47240765036501 | (37.723054643014, -122.472407650365) |
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");