Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, qAddress, SiteOrder, PlantType, DBH, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 240 | 240 | 251249 | Private 5 | Private shrub :: Private Shrub 64 | 161 Lundys Ln | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 3x3 | 6006716.0 | 2098685.0 | 37.7429691002686 | -122.41940918518 | (37.7429691002686, -122.41940918518) | ||||
| 9555 | 9555 | 105225 | Private 5 | Juniperus chinensis :: Juniper 19 | 175 Spruce St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 9 | 5997195.09596 | 2114417.64894 | 37.785626103218895 | -122.453465347546 | (37.7856261032189, -122.453465347546) | ||||
| 79432 | 79432 | 106576 | Private 5 | Private shrub :: Private Shrub 64 | 507 STEINER ST | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6003113.3 | 2110111.6 | 37.7741402349502 | -122.432682383122 | (37.7741402349502, -122.432682383122) | |||||
| 85608 | 85608 | 105439 | Private 5 | Tree(s) :: 17 | 790 LAKEVIEW AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5994224.8 | 2089960.8 | 37.718303123348605 | -122.461967505828 | (37.7183031233486, -122.461967505828) | |||||
| 90169 | 90169 | 104567 | Private 5 | Tree(s) :: 17 | 8 JOY ST | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6010448.0 | 2098932.0 | 37.7438568002142 | -122.40652229250799 | (37.7438568002142, -122.406522292508) | ||||
| 91183 | 91183 | 114258 | Private 5 | Pinus radiata :: Monterey Pine 3 | 70x CHUMASERO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 5990913.0 | 2088468.0 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | ||||
| 97007 | 97007 | 117070 | Private 5 | Tree(s) :: 17 | 6 JOY ST | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6010444.0 | 2098901.0 | 37.7437714571602 | -122.406533939617 | (37.7437714571602, -122.406533939617) | |||||
| 97548 | 97548 | 113801 | Private 5 | Ulmus parvifolia :: Chinese Elm 46 | 806 SHOTWELL ST | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6007931.0 | 2103220.0 | 37.755489548438 | -122.41552904166201 | (37.755489548438, -122.415529041662) | |||||
| 102645 | 102645 | 110587 | Private 5 | Prunus cerasifera 'Atropurpurea' :: Purple-Leaf Plum 225 | 151 EDGEWOOD AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5996558.0 | 2106132.0 | 37.7628393335165 | -122.45507056334999 | (37.7628393335165, -122.45507056335) | |||||
| 119638 | 119638 | 109607 | Private 5 | Shrub :: Shrub 98 | 775 Congo St | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6000381.8 | 2095947.7 | 37.7350943222142 | -122.44111470541901 | (37.7350943222142, -122.441114705419) | |||||
| 120169 | 120169 | 104564 | Private 5 | Private shrub :: Private Shrub 64 | 18 FLOOD AVE | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6000327.0 | 2094154.0 | 37.730166118083794 | -122.44117551704201 | (37.7301661180838, -122.441175517042) | |||||
| 120714 | 120714 | 104436 | Private 5 | Corymbia ficifolia :: Red Flowering Gum 60 | 2 SAN FERNANDO WAY | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | 5992040.0 | 2096369.0 | 37.7357724272627 | -122.469985704629 | (37.7357724272627, -122.469985704629) | ||||
| 124928 | 124928 | 104968 | Private 5 | Pinus halepensis :: Allepo Pine 164 | 495 COLLINGWOOD ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Permit Number 770776 | 6002186.6 | 2103026.0 | 37.7546323087418 | -122.435381040855 | (37.7546323087418, -122.435381040855) | |||
| 138621 | 138621 | 104565 | Private 5 | Private shrub :: Private Shrub 64 | 18 FLOOD AVE | 1 | Front Yard : Yard 7 | Landscaping 2 | Private 1 | 6000327.0 | 2094154.0 | 37.730166118083794 | -122.44117551704201 | (37.7301661180838, -122.441175517042) |
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");