Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3835 | 3835 | 253567 | Private 5 | Salix spp :: Willow 218 | 25 Raycliff Ter | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6000333.0 | 2116919.0 | 37.792673532262505 | -122.44278881704399 | (37.7926735322625, -122.442788817044) | |||||
| 12440 | 12440 | 100166 | Property Tree 7 | Salix spp :: Willow 218 | 2340 Twin Peaks Blvd | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769026 | ||||||||||
| 24893 | 24893 | 249803 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 0ft | 6010797.8681 | 2121034.56269 | 37.8045648929076 | -122.406869977661 | (37.8045648929076, -122.406869977661) | |||
| 31900 | 31900 | 197465 | Undocumented 2 | Salix spp :: Willow 218 | 300 Tulare St | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 2 | 6015074.429330001 | 2100286.5599 | 37.747833879328205 | -122.39061968157101 | (37.7478338793282, -122.390619681571) | ||||
| 37531 | 37531 | 197464 | Undocumented 2 | Salix spp :: Willow 218 | 300 Tulare St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3 | 6015091.2774 | 2100275.40552 | 37.747804186425704 | -122.390560641961 | (37.7478041864257, -122.390560641961) | ||||
| 41112 | 41112 | 249802 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6010800.51699 | 2121027.19165 | 37.804544802067795 | -122.40686029106399 | (37.8045448020678, -122.406860291064) | |||
| 41725 | 41725 | 249801 | Undocumented 2 | Salix spp :: Willow 218 | 199 Chestnut St | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 0ft | 6010817.41818 | 2121032.42215 | 37.8045601094112 | -122.40680217150101 | (37.8045601094112, -122.406802171501) | |||
| 46915 | 46915 | 249805 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 14 | Width 0ft | 6010790.25874 | 2121038.89871 | 37.8045763727666 | -122.40689661648099 | (37.8045763727666, -122.406896616481) | |||
| 53267 | 53267 | 249799 | Undocumented 2 | Salix spp :: Willow 218 | 199 Chestnut St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 0ft | 6010830.01398 | 2121049.58658 | 37.8046079434619 | -122.406759792755 | (37.8046079434619, -122.406759792755) | |||
| 59239 | 59239 | 249804 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 3 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 0ft | 6010798.41124 | 2121026.88639 | 37.8045438460731 | -122.406867556714 | (37.8045438460731, -122.406867556714) | |||
| 73394 | 73394 | 214151 | Undocumented 2 | Salix spp :: Willow 218 | 312 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5993037.76549 | 2102572.2822 | 37.7528626930695 | -122.466986911741 | (37.7528626930695, -122.466986911741) | |||
| 74282 | 74282 | 249879 | Undocumented 2 | Salix spp :: Willow 218 | 230 Greenwich St | 15 | Back Yard : Yard 13 | Tree 1 | Private 1 | 31 | Width 0ft | 6011548.40111 | 2120431.82846 | 37.8029518994613 | -122.404230226458 | (37.8029518994613, -122.404230226458) | |||
| 74556 | 74556 | 181908 | Undocumented 2 | Salix spp :: Willow 218 | 2361 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5987931.3863 | 2099236.8053 | 37.743408304681104 | -122.484400882071 | (37.7434083046811, -122.484400882071) | |||
| 78641 | 78641 | 116976 | Undocumented 2 | Salix spp :: Willow 218 | 100x CARGO WAY | 7 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 83082 | 83082 | 91365 | Permitted Site 1 | Salix spp :: Willow 218 | 2850 22nd St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2009 12:00:00 AM | 3x3 | Permit Number 52066 | 6009160.0 | 2103356.0 | 37.755931978245705 | -122.411288371704 | (37.7559319782457, -122.411288371704) | ||
| 83368 | 83368 | 120504 | Undocumented 2 | Salix spp :: Willow 218 | 2050 Turk Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 6000175.0 | 2112136.0 | 37.779531646131204 | -122.442991859062 | (37.7795316461312, -122.442991859062) | |||||
| 92869 | 92869 | 99821 | Undocumented 2 | Salix spp :: Willow 218 | 1230 Twin Peaks Blvd | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 11 | Tree closest to sidewalk and retaining wall | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||
| 95481 | 95481 | 101470 | Undocumented 2 | Salix spp :: Willow 218 | 1230 Twin Peaks Blvd | 2 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5997905.5 | 2100119.1 | 37.7464066170132 | -122.449976668748 | (37.7464066170132, -122.449976668748) | |||||
| 99185 | 99185 | 91367 | Permitted Site 1 | Salix spp :: Willow 218 | 2850 22nd St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2009 12:00:00 AM | 3x3 | Permit Number 52066 | 6009160.0 | 2103356.0 | 37.755931978245705 | -122.411288371704 | (37.7559319782457, -122.411288371704) | ||
| 101651 | 101651 | 106059 | Significant Tree 6 | Salix spp :: Willow 218 | 339 FILBERT ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6 | 6011263.6 | 2119947.8 | 37.801606957686 | -122.40518168715599 | (37.801606957686, -122.405181687156) | ||||
| 120600 | 120600 | 97302 | Permitted Site 1 | Salix spp :: Willow 218 | 1051 Portola Dr | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5995688.7 | 2098126.6 | 37.7408086112536 | -122.457497926865 | (37.7408086112536, -122.457497926865) | |||||
| 128483 | 128483 | 91366 | Permitted Site 1 | Salix spp :: Willow 218 | 2850 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/27/2009 12:00:00 AM | 3x3 | Permit Number 52066 | 6009160.0 | 2103356.0 | 37.755931978245705 | -122.411288371704 | (37.7559319782457, -122.411288371704) | ||
| 140503 | 140503 | 116975 | Undocumented 2 | Salix spp :: Willow 218 | 100x CARGO WAY | 6 | Front Yard : Yard 7 | Tree 1 | PUC 13 | DPW for City Agency 2 | 6019010.0 | 2097405.0 | 37.7401392444118 | -122.376810655394 | (37.7401392444118, -122.376810655394) | ||||
| 152632 | 152632 | 179421 | Undocumented 2 | Salix spp :: Willow 218 | 700 John Muir Dr | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 0ft | 5986275.223040001 | 2087885.25154 | 37.7121433180403 | -122.489292946617 | (37.7121433180403, -122.489292946617) | |||
| 154623 | 154623 | 183597 | Undocumented 2 | Salix spp :: Willow 218 | 2639 23rd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 0ft | 5989238.6658 | 2097359.0167 | 37.7383284221723 | -122.479743320072 | (37.7383284221723, -122.479743320072) | |||
| 160668 | 160668 | 197463 | Undocumented 2 | Salix spp :: Willow 218 | 300 Tulare St | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | Width 5ft | 6015063.03435 | 2100312.52398 | 37.7479045390722 | -122.39066089929199 | (37.7479045390722, -122.390660899292) | |||
| 171764 | 171764 | 197466 | Undocumented 2 | Salix spp :: Willow 218 | 625 Bay Shore Blvd | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 6ft | 6010372.73357 | 2096324.48673 | 37.7366929195414 | -122.40659883568199 | (37.7366929195414, -122.406598835682) | |||
| 179670 | 179670 | 249796 | Undocumented 2 | Salix spp :: Willow 218 | 199 Chestnut St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 8 | Width 0ft | 6010844.62516 | 2121045.45639 | 37.80459742048421 | -122.40670893787701 | (37.8045974204842, -122.406708937877) | |||
| 180980 | 180980 | 249806 | Undocumented 2 | Salix spp :: Willow 218 | 258 Chestnut St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 16 | Width 0ft | 6010784.31321 | 2121039.01987 | 37.804576372755605 | -122.406917200191 | (37.8045763727556, -122.406917200191) |
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");