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");