Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: SiteOrder, qSiteInfo
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
33282 | 33282 | 217464 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 127 Beverly St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 10ft | 5991405.11003 | 2090040.73714 | 37.7183598726973 | -122.471719713607 | (37.7183598726973, -122.471719713607) | |||
43216 | 43216 | 203186 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1501 25th St | 25 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 6014234.68411 | 2101965.33677 | 37.752396820871894 | -122.393640982742 | (37.7523968208719, -122.393640982742) | ||||
44429 | 44429 | 244865 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 142 Highland Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 3ft | 6005730.73165 | 2096631.6868599998 | 37.737275621771104 | -122.42267009385401 | (37.7372756217711, -122.422670093854) | |||
66131 | 66131 | 244861 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 106 Chattanooga St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 4 | Width 4ft | 6004701.8654 | 2103001.6771 | 37.7547080488647 | -122.42668084266501 | (37.7547080488647, -122.426680842665) | |||
149805 | 149805 | 199482 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 1300 03rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 5ft | 6015508.8068699995 | 2108983.54244 | 37.7717380185256 | -122.38972496674 | (37.7717380185256, -122.38972496674) | |||
151854 | 151854 | 217482 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 19 Melrose Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 8ft | 5999956.53878 | 2095464.0242299999 | 37.7337420298675 | -122.442550265996 | (37.7337420298675, -122.442550265996) | |||
174670 | 174670 | 184444 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 2131 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5981678.0282 | 2100560.0346 | 37.7466754073158 | -122.50612112236 | (37.7466754073158, -122.50612112236) | |||
185076 | 185076 | 244824 | Undocumented 2 | Washingtonia robusta :: Mexican Fan Palm 75 | 773 Dolores St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 7ft | 6005057.02214 | 2103838.7107 | 37.757026420139 | -122.42551217995701 | (37.757026420139, -122.425512179957) |
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");