Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3320 | 3320 | 56733 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1583 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Permit Number 780681 | 6015469.0433 | 2095825.5988 | 37.7356068823061 | -122.388943710821 | (37.7356068823061, -122.388943710821) | |||
| 27101 | 27101 | 124082 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3220 Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993384.863369999 | 2110069.41246 | 37.773467874758296 | -122.466331413768 | (37.7734678747583, -122.466331413768) | |||
| 31367 | 31367 | 204614 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1255 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5990910.22691 | 2105165.14407 | 37.7598589779192 | -122.474533471065 | (37.7598589779192, -122.474533471065) | |||
| 36933 | 36933 | 244274 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 470 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6004329.9355 | 2109813.5769 | 37.7733908594087 | -122.42845257964501 | (37.7733908594087, -122.428452579645) | |||
| 44057 | 44057 | 175774 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5990113.97654 | 2089437.91841 | 37.7166298945381 | -122.47613856845 | (37.7166298945381, -122.47613856845) | ||||
| 44455 | 44455 | 222555 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 121 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006651.1877 | 2098952.76416 | 37.743700669854796 | -122.419652282953 | (37.7437006698548, -122.419652282953) | |||
| 59851 | 59851 | 175772 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | 5989911.02174 | 2089222.5365 | 37.716026738112 | -122.47682434649201 | (37.716026738112, -122.476824346492) | ||||
| 63144 | 63144 | 204637 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 181 Staples Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 1ft | 5998869.73196 | 2093802.12764 | 37.7291168426482 | -122.446188161278 | (37.7291168426482, -122.446188161278) | |||
| 63204 | 63204 | 204667 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 582 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997581.48097 | 2095279.2111 | 37.7330989075759 | -122.45074818359899 | (37.7330989075759, -122.450748183599) | |||
| 67302 | 67302 | 32207 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1760 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 9 | Permit Number 35529 | 6009303.23325 | 2099186.73635 | 37.7444921398121 | -122.41049862882 | (37.7444921398121, -122.41049862882) | |
| 85541 | 85541 | 30142 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 410X Mansell St | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 9 | M | 6010678.994322 | 2090457.6265959998 | 37.720600879856704 | -122.405126964413 | (37.7206008798567, -122.405126964413) | |||
| 126192 | 126192 | 56043 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4129 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/12/1973 12:00:00 AM | 9 | 3x3 | Permit Number 12130 | 6002248.77832892 | 2105270.36244465 | 37.760798318618704 | -122.435326543463 | (37.7607983186187, -122.435326543463) | |
| 130229 | 130229 | 204666 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 535 Mangels Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 5997878.67086 | 2095246.42281 | 37.7330258862214 | -122.449718361808 | (37.7330258862214, -122.449718361808) | |||
| 135590 | 135590 | 142317 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 442 LYON ST | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 0ft | 6000199.2759 | 2110472.9787 | 37.774966797429705 | -122.442788429748 | (37.7749667974297, -122.442788429748) | |||
| 136620 | 136620 | 188304 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 601 19th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6015659.791809999 | 2105320.44232 | 37.7616883131784 | -122.38894690567801 | (37.7616883131784, -122.388946905678) | |||
| 153446 | 153446 | 221323 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3517 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006097.76573 | 2104905.6123599997 | 37.7600146325834 | -122.421988676659 | (37.7600146325834, -122.421988676659) | |||
| 157003 | 157003 | 49416 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 17643RD/PHELPS La Salle Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/25/2003 12:00:00 AM | 9 | Permit Number 46362 | 6014695.16416 | 2096823.71289 | 37.7383045729921 | -122.39168909330401 | (37.7383045729921, -122.391689093304) | ||
| 169508 | 169508 | 204622 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1518 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5993700.04012 | 2105141.70568 | 37.7599558699739 | -122.46488324546499 | (37.7599558699739, -122.464883245465) | |||
| 174190 | 174190 | 56722 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1560 McKinnon Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/1974 12:00:00 AM | 9 | Permit Number 13995 | 6015605.7227 | 2095794.747 | 37.7355297446147 | -122.388469000899 | (37.7355297446147, -122.388469000899) | ||
| 179145 | 179145 | 221345 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 152 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008640.31836 | 2097829.07218 | 37.740727106470004 | -122.41269490094801 | (37.74072710647, -122.412694900948) |
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");