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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10089 | 10089 | 173834 | Undocumented 2 | Privet :: 262 | 37 Tucker Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 6010894.0 | 2088503.0 | 37.7152458914151 | -122.404246253618 | (37.7152458914151, -122.404246253618) | |||||
| 19060 | 19060 | 116350 | Undocumented 2 | Privet :: 262 | 4051X 24TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 6002850.0 | 2101803.0 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | ||||
| 53613 | 53613 | 12210 | DPW Maintained 3 | Privet :: 262 | 1365X La Salle Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/27/2007 12:00:00 AM | 3 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.38458793904199 | (37.7327261850679, -122.384587939042) | ||
| 80092 | 80092 | 114511 | Undocumented 2 | Privet :: 262 | 34 LEVANT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 6x10 | 6000223.0 | 2106691.0 | 37.76458378565329 | -122.44243478339199 | (37.7645837856533, -122.442434783392) | |||
| 88684 | 88684 | 50598 | Permitted Site 1 | Privet :: 262 | 1700 Buchanan St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/26/2003 12:00:00 AM | Permit Number 47204 | 6004061.24207522 | 2114267.02341516 | 37.7856037113433 | -122.42969972213801 | (37.7856037113433, -122.429699722138) | |||
| 93024 | 93024 | 106882 | Undocumented 2 | Privet :: 262 | 1730 08TH AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5993775.2 | 2103704.9 | 37.7560151067022 | -122.464518978626 | (37.7560151067022, -122.464518978626) | ||||
| 93462 | 93462 | 40799 | Permitted Site 1 | Privet :: 262 | 66 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/25/1999 12:00:00 AM | Permit Number 41748 | 5999338.09274172 | 2107943.29200954 | 37.7679717869212 | -122.445585487508 | (37.7679717869212, -122.445585487508) | |||
| 99668 | 99668 | 104881 | Private 5 | Privet :: 262 | 101 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | missing? | 5990474.7 | 2090014.4 | 37.718233681711204 | -122.47493379652201 | (37.7182336817112, -122.474933796522) | ||||
| 109819 | 109819 | 115150 | Undocumented 2 | Privet :: 262 | 209 Grattan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/04/2016 12:00:00 AM | 3 | 3x3 | 5997642.1 | 2106419.3 | 37.7636903209387 | -122.451341781368 | (37.7636903209387, -122.451341781368) | ||
| 110857 | 110857 | 116796 | Undocumented 2 | Privet :: 262 | 2253 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003196.0 | 2116495.0 | 37.791672136469394 | -122.43285242858101 | (37.7916721364694, -122.432852428581) | ||||
| 112003 | 112003 | 110913 | Undocumented 2 | Privet :: 262 | 359-363 WALLER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003989.0 | 2108999.0 | 37.7711349314416 | -122.42957381812401 | (37.7711349314416, -122.429573818124) | ||||
| 114615 | 114615 | 104938 | Undocumented 2 | Privet :: 262 | 101 Gonzalez Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | missing? | 5990474.7 | 2090014.4 | 37.718233681711204 | -122.47493379652201 | (37.7182336817112, -122.474933796522) | ||||
| 126561 | 126561 | 110912 | Undocumented 2 | Privet :: 262 | 359-363 WALLER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003989.0 | 2108999.0 | 37.7711349314416 | -122.42957381812401 | (37.7711349314416, -122.429573818124) | ||||
| 127764 | 127764 | 110914 | Undocumented 2 | Privet :: 262 | 359-363 WALLER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003989.0 | 2108999.0 | 37.7711349314416 | -122.42957381812401 | (37.7711349314416, -122.429573818124) | ||||
| 142913 | 142913 | 53302 | Permitted Site 1 | Privet :: 262 | 38 Levant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/1969 12:00:00 AM | 9 | Permit Number 6192 | 6000247.71875461 | 2106609.17319721 | 37.7643605184726 | -122.442343413318 | (37.7643605184726, -122.442343413318) | ||
| 144599 | 144599 | 40158 | Permitted Site 1 | Privet :: 262 | 2211 Stockton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/22/2006 12:00:00 AM | Permit Number 48863 | 6009783.18603588 | 2121626.8328918 | 37.8061342908169 | -122.41042324029499 | (37.8061342908169, -122.410423240295) |
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");