Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, qCareAssistant, DBH, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 114 | 114 | 251216 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 399X Townsend St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 118 | 118 | 251217 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 399X Townsend St | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6013957.0 | 2110872.0 | 37.776837125863 | -122.39522511301901 | (37.776837125863, -122.395225113019) | ||||
| 4468 | 4468 | 253632 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 527 Oak St | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 3x3 | 6004455.0 | 2110106.0 | 37.7742008582336 | -122.42804080634701 | (37.7742008582336, -122.428040806347) | ||||
| 9684 | 9684 | 173630 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2699x OCEAN AVE | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | |||
| 87112 | 87112 | 108316 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1795 Lincoln Way | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5990313.88148 | 2107203.45347 | 37.765421057721795 | -122.476744840008 | (37.7654210577218, -122.476744840008) | |||||
| 87416 | 87416 | 108318 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1795 Lincoln Way | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5990313.88148 | 2107203.45347 | 37.765421057721795 | -122.476744840008 | (37.7654210577218, -122.476744840008) | |||||
| 87538 | 87538 | 97027 | Property Tree 7 | Myoporum laetum :: Myoporum 1 | 195B Kiska Rd | Sidewalk: Property side : Cutout 5 | Tree 1 | Housing Authority 20 | FUF 1 | 6019164.1 | 2093438.1 | 37.7292553954157 | -122.376002845114 | (37.7292553954157, -122.376002845114) | |||||
| 90642 | 90642 | 108476 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1201X 19th Ave | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 774311 | 5990125.2811900005 | 2107203.87819 | 37.7654112822972 | -122.477397189068 | (37.7654112822972, -122.477397189068) | ||||
| 93028 | 93028 | 115827 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 60X CHUMASERO DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | Permit Number 777531 | 5990913.0 | 2088468.0 | 37.714013037331 | -122.473306070941 | (37.714013037331, -122.473306070941) | |
| 100581 | 100581 | 108317 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1795 Lincoln Way | 2 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 5990313.88148 | 2107203.45347 | 37.765421057721795 | -122.476744840008 | (37.7654210577218, -122.476744840008) | |||||
| 104770 | 104770 | 108475 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1201X 19th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 774311 | 5990125.2811900005 | 2107203.87819 | 37.7654112822972 | -122.477397189068 | (37.7654112822972, -122.477397189068) | ||||
| 114895 | 114895 | 116578 | Significant Tree 6 | Myoporum laetum :: Myoporum 1 | 2699x OCEAN AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW 4 | 11 | 3x3 | 5990602.0 | 2095184.0 | 37.7324354869182 | -122.47487091251001 | (37.7324354869182, -122.47487091251) | ||
| 119669 | 119669 | 108477 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 1201X 19th Ave | 3 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | Permit Number 774311 | 5990125.2811900005 | 2107203.87819 | 37.7654112822972 | -122.477397189068 | (37.7654112822972, -122.477397189068) | ||||
| 127092 | 127092 | 116522 | DPW Maintained 3 | Myoporum laetum :: Myoporum 1 | 324 08TH AVE | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | MTA 6 | DPW for City Agency 2 | 8 | 3x3 | 5993416.0 | 2113304.0 | 37.7823509768718 | -122.466458848407 | (37.7823509768718, -122.466458848407) | ||
| 140493 | 140493 | 115828 | Undocumented 2 | Myoporum laetum :: Myoporum 1 | 65 CHUMASERO DR | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 08/30/2016 12:00:00 AM | 3 | 3x3 | 5991168.0 | 2088425.0 | 37.713909732222 | -122.472421570074 | (37.713909732222, -122.472421570074) |
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");