Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3586 | 3586 | 253468 | DPW Maintained 3 | Salix lasiolepis :: Arroyo willow 213 | 801X Alemany Blvd | 1 | Side Yard : Yard 17 | Tree 1 | DPW 2 | ||||||||||
| 17946 | 17946 | 2396 | DPW Maintained 3 | Salix lasiolepis :: Arroyo willow 213 | 2689 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/15/1990 12:00:00 AM | 12 | 3X3 | 6009821.72724 | 2101682.95822 | 37.751375269250396 | -122.408881857325 | (37.7513752692504, -122.408881857325) | ||
| 25613 | 25613 | 240953 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 1101 San Jose Ave | 15 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | 6004805.95854 | 2096424.9931 | 37.7366558692687 | -122.42585275411601 | (37.7366558692687, -122.425852754116) | ||||
| 48394 | 48394 | 197468 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 1 24th St | 2 | : Yard 23 | Tree 1 | Private 1 | 14 | 6017037.26149 | 2102635.05439 | 37.754391058511295 | -122.38399574663299 | (37.7543910585113, -122.383995746633) | ||||
| 66438 | 66438 | 197470 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 300 Tulare St | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6015061.6001699995 | 2100303.5452900003 | 37.7478798059021 | -122.390665231323 | (37.7478798059021, -122.390665231323) | ||||
| 158881 | 158881 | 249724 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 2500 Broderick St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6000224.51348 | 2117347.62333 | 37.79384423396429 | -122.443194981868 | (37.7938442339643, -122.443194981868) | ||||
| 160459 | 160459 | 240954 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 1101 San Jose Ave | 21 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6004832.47132 | 2096456.2246700001 | 37.7367431223852 | -122.425763310243 | (37.7367431223852, -122.425763310243) | ||||
| 161378 | 161378 | 240952 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 1101 San Jose Ave | 14 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004797.42091 | 2096412.76168 | 37.7366218020611 | -122.425881402015 | (37.7366218020611, -122.425881402015) | ||||
| 162209 | 162209 | 197471 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 300 Tulare St | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6015048.81541 | 2100312.7782 | 37.747904448235296 | -122.390710085918 | (37.7479044482353, -122.390710085918) | ||||
| 164865 | 164865 | 239558 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 26 Ohlone Way | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 2ft | 6002169.792830001 | 2096347.5297 | 37.7362938444778 | -122.434961566227 | (37.7362938444778, -122.434961566227) | |||
| 170165 | 170165 | 197469 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 1 24th St | 3 | : Yard 23 | Tree 1 | Private 1 | 12 | 6017071.17305 | 2102662.5786200003 | 37.7544685090175 | -122.383880386982 | (37.7544685090175, -122.383880386982) | ||||
| 171214 | 171214 | 239557 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 1100 San Jose Ave | 81 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | Width 5ft | 6004609.877180001 | 2096414.58836 | 37.736616217249704 | -122.42652995170299 | (37.7366162172497, -122.426529951703) | |||
| 173426 | 173426 | 197473 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 1670 Armstrong Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | 6014003.18498 | 2092809.6912 | 37.727244454143204 | -122.393800747332 | (37.7272444541432, -122.393800747332) | ||||
| 180940 | 180940 | 197472 | DPW Maintained 3 | Salix lasiolepis :: Arroyo willow 213 | 1700x Quesada Ave | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6014448.1116 | 2095227.50583 | 37.7339079988375 | -122.39243166978599 | (37.7339079988375, -122.392431669786) | ||||
| 188614 | 188614 | 197467 | Undocumented 2 | Salix lasiolepis :: Arroyo willow 213 | 1 24th St | 1 | : Yard 23 | Tree 1 | Private 1 | 13 | 6017027.60375 | 2102629.3032400003 | 37.7543747331295 | -122.38402874544799 | (37.7543747331295, -122.384028745448) |
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");