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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2825 | 2825 | 81846 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1421 Pine St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50020 | 6007049.49584 | 2115692.06976 | 37.7896852939829 | -122.419462344328 | (37.7896852939829, -122.419462344328) |
| 25529 | 25529 | 81905 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2999 Pacific Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 7 | 3x3 | Permit Number 50026 | 5999847.61488 | 2116692.12916 | 37.7920229215711 | -122.44445195079099 | (37.7920229215711, -122.444451950791) | |
| 36388 | 36388 | 87087 | Permitted Site 1 | Acacia melanoxylon :: Blackwood Acacia 5 | 20501 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 28 | Permit Number 50035 | 5999440.60645 | 2115900.3485 | 37.7898256691591 | -122.44580322984 | (37.7898256691591, -122.44580322984) | ||
| 67865 | 67865 | 81847 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 611 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 6 | 3x3 | Permit Number 50019 | 6007860.49957 | 2114503.1389200003 | 37.78646642612021 | -122.416572088746 | (37.7864664261202, -122.416572088746) | |
| 73750 | 73750 | 81771 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 118 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 7 | 3x3 | Permit Number 50018 | 6009093.57763 | 2112998.11082 | 37.7824032504549 | -122.41219952198999 | (37.7824032504549, -122.41219952199) | |
| 81617 | 81617 | 81843 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Larkin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.789712940015704 | -122.419194651452 | (37.7897129400157, -122.419194651452) |
| 86195 | 86195 | 43111 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 290 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 3x3 | Permit Number 50034 | 6008607.94107209 | 2113184.33182846 | 37.782887307027394 | -122.413892794032 | (37.7828873070274, -122.413892794032) | ||
| 90767 | 90767 | 87093 | Permitted Site 1 | Liquidambar styraciflua :: American Sweet Gum 62 | 3975 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 3x3 | Permit Number 50046 | 6003177.0 | 2104745.0 | 37.7594084694279 | -122.432078722509 | (37.7594084694279, -122.432078722509) | ||
| 97025 | 97025 | 81841 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Larkin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.789712940015704 | -122.419194651452 | (37.7897129400157, -122.419194651452) |
| 100401 | 100401 | 81842 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Larkin St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.789712940015704 | -122.419194651452 | (37.7897129400157, -122.419194651452) |
| 101989 | 101989 | 53767 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 280 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 3x3 | Permit Number 50032 | 5992868.31748404 | 2094997.91347506 | 37.732055613263604 | -122.467022262159 | (37.7320556132636, -122.467022262159) | ||
| 111252 | 111252 | 81840 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Larkin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.789712940015704 | -122.419194651452 | (37.7897129400157, -122.419194651452) |
| 111605 | 111605 | 87088 | Permitted Site 1 | Ulmus spp :: Elm Spp 215 | 354 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 3x3 | Permit Number 50036 | 6005462.0 | 2101644.0 | 37.751023128085606 | -122.42395554828 | (37.7510231280856, -122.42395554828) | ||
| 116620 | 116620 | 81904 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 2266X Baker St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 3 | 3x3 | Permit Number 50026 | 5999807.10049019 | 2116693.18861925 | 37.7920235188379 | -122.444592206646 | (37.7920235188379, -122.444592206646) | |
| 120438 | 120438 | 81929 | Permitted Site 1 | Prunus cerasifera :: Cherry Plum 16 | 118 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 6 | 3x3 | Permit Number 50018 | 6009095.92555 | 2112986.0024900003 | 37.782370135616496 | -122.41219054315201 | (37.7823701356165, -122.412190543152) | |
| 121952 | 121952 | 81838 | Permitted Site 1 | Tristaniopsis laurina 'Elegant' :: Small-leaf Tristania 'Elegant' 51 | 901 Post St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 3x3 | Permit Number 50027 | 6007847.58999161 | 2114760.86418186 | 37.787173350858296 | -122.41663501680901 | (37.7871733508583, -122.416635016809) | ||
| 139306 | 139306 | 87084 | Permitted Site 1 | Lophostemon confertus :: Brisbane Box 11 | 850 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 5 | 3x3 | Permit Number 50029 | 6001068.0 | 2114562.0 | 37.786243695117506 | -122.440076605796 | (37.7862436951175, -122.440076605796) | |
| 141753 | 141753 | 81839 | DPW Maintained 3 | Arbutus 'Marina' :: Hybrid Strawberry Tree 12 | 1299X Larkin St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | SFUSD 6 | 12/20/2007 12:00:00 AM | 4 | 3x3 | Permit Number 50020 | 6007127.03967719 | 2115700.54784829 | 37.789712940015704 | -122.419194651452 | (37.7897129400157, -122.419194651452) |
| 143663 | 143663 | 82026 | Permitted Site 1 | Olea europaea :: Olive Tree 41 | 4657 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 3x3 | Permit Number 50028 | 6000147.95764033 | 2105151.97717561 | 37.7603537323491 | -122.442583825347 | (37.7603537323491, -122.442583825347) | ||
| 163716 | 163716 | 87085 | Permitted Site 1 | Tristaniopsis laurina :: Swamp Myrtle 37 | 2298 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/20/2007 12:00:00 AM | 6 | 3x3 | Permit Number 50031 | 6002114.68328 | 2118108.86588 | 37.796042005295206 | -122.43670934466299 | (37.7960420052952, -122.436709344663) |
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");