Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, DBH, PlotSize, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9696 | 9696 | 173645 | Permitted Site 1 | Ficus laurel :: 256 | 33 Gough St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6006450.1 | 2109317.2 | 37.772147675466705 | -122.421083366581 | (37.7721476754667, -122.421083366581) | |||||
| 10211 | 10211 | 108902 | Permitted Site 1 | Ficus laurel :: 256 | 33 Gough St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 4x6 | 6006450.1 | 2109317.2 | 37.772147675466705 | -122.421083366581 | (37.7721476754667, -122.421083366581) | |||
| 10215 | 10215 | 173913 | Permitted Site 1 | Ficus laurel :: 256 | 33 Gough St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6006450.1 | 2109317.2 | 37.772147675466705 | -122.421083366581 | (37.7721476754667, -122.421083366581) | ||||
| 63418 | 63418 | 105725 | Undocumented 2 | Ficus laurel :: 256 | 895 PAGE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6002505.0 | 2109533.0 | 37.7725170259656 | -122.434745213579 | (37.7725170259656, -122.434745213579) | |||
| 81959 | 81959 | 112297 | Undocumented 2 | Ficus laurel :: 256 | 336 HAYES ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006219.0 | 2111187.0 | 37.7772686655697 | -122.422015614022 | (37.7772686655697, -122.422015614022) | ||||
| 88965 | 88965 | 108583 | Undocumented 2 | Ficus laurel :: 256 | 1100x BROADWAY | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008279.0 | 2118302.0 | 37.796920694259704 | -122.415393214122 | (37.7969206942597, -122.415393214122) | ||||
| 90223 | 90223 | 116892 | Undocumented 2 | Ficus laurel :: 256 | 2798X LYON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999158.0 | 2118194.0 | 37.7961072882302 | -122.446946138081 | (37.7961072882302, -122.446946138081) | ||||
| 91581 | 91581 | 50172 | Permitted Site 1 | Ficus laurel :: 256 | 256 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/2003 12:00:00 AM | Permit Number 46881 | 5990896.23441717 | 2113690.84424492 | 37.7832674231585 | -122.47520428543699 | (37.7832674231585, -122.475204285437) | |||
| 92496 | 92496 | 63242 | Permitted Site 1 | Ficus laurel :: 256 | 3644 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/14/1987 12:00:00 AM | Permit Number 23791 | 6006002.12358092 | 2104359.28236914 | 37.7585091435434 | -122.422280640726 | (37.7585091435434, -122.422280640726) | ||
| 96341 | 96341 | 56114 | Permitted Site 1 | Ficus laurel :: 256 | 1198 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1983 12:00:00 AM | 22 | Permit Number 20860 | 6007637.08582291 | 2102687.30413508 | 37.7540103620288 | -122.41650775824301 | (37.7540103620288, -122.416507758243) | ||
| 101265 | 101265 | 110403 | Undocumented 2 | Ficus laurel :: 256 | 419X 18TH AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | MTA 10 | 22 | 3x3 | 5990240.0 | 2112557.0 | 37.7801161452828 | -122.477391675869 | (37.7801161452828, -122.477391675869) | ||
| 110422 | 110422 | 108900 | Undocumented 2 | Ficus laurel :: 256 | 33 Gough St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 6x4 | 6006450.1 | 2109317.2 | 37.772147675466705 | -122.421083366581 | (37.7721476754667, -122.421083366581) | |||
| 122637 | 122637 | 50183 | Permitted Site 1 | Ficus laurel :: 256 | 720 Potrero Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/2003 12:00:00 AM | Permit Number 46890 | 6010377.59083712 | 2104947.86525406 | 37.7603710966216 | -122.407189730085 | (37.7603710966216, -122.407189730085) | |||
| 124270 | 124270 | 57308 | Permitted Site 1 | Ficus laurel :: 256 | 3109 16TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/1976 12:00:00 AM | 4x4 | Permit Number 16130 | 6006083.0 | 2106599.0 | 37.764663444270795 | -122.422160051366 | (37.7646634442708, -122.422160051366) | ||
| 127129 | 127129 | 110176 | Undocumented 2 | Ficus laurel :: 256 | 375 FAIR OAKS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6005525.2 | 2101540.6 | 37.750742783376495 | -122.423729644924 | (37.7507427833765, -122.423729644924) | ||||
| 128878 | 128878 | 108582 | Undocumented 2 | Ficus laurel :: 256 | 1100x BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6008279.0 | 2118302.0 | 37.796920694259704 | -122.415393214122 | (37.7969206942597, -122.415393214122) | ||||
| 129323 | 129323 | 108145 | DPW Maintained 3 | Ficus laurel :: 256 | 969 OAK ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6002380.6 | 2109817.2 | 37.7732903053544 | -122.435195856484 | (37.7732903053544, -122.435195856484) | ||||
| 139345 | 139345 | 107469 | Undocumented 2 | Ficus laurel :: 256 | 255 GRANT AVE | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | 3x3 | 6011077.0 | 2115520.2 | 37.789439403439296 | -122.405515400574 | (37.7894394034393, -122.405515400574) | |||
| 145104 | 145104 | 61104 | Permitted Site 1 | Ficus laurel :: 256 | 2957 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/10/1983 12:00:00 AM | 10 | 4x4 | Permit Number 20948 | 6008533.81167485 | 2103278.81383557 | 37.7556849030207 | -122.413448485443 | (37.7556849030207, -122.413448485443) |
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");