Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCareAssistant, PermitNotes, XCoord, YCoord, Latitude, Location
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23457 | 23457 | 221362 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1301 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001384.01408 | 2099859.31671 | 37.7458917403255 | -122.437929785824 | (37.7458917403255, -122.437929785824) | |||
| 30100 | 30100 | 188310 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 189 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012910.658530001 | 2106249.7856099997 | 37.764087318611395 | -122.39852032646499 | (37.7640873186114, -122.398520326465) | |||
| 33225 | 33225 | 188311 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 189 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012910.01504 | 2106269.57454 | 37.764141618776 | -122.398523940823 | (37.764141618776, -122.398523940823) | |||
| 35293 | 35293 | 204639 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 185 Marston Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5998393.85271 | 2093179.60638 | 37.7273803570158 | -122.44778850934401 | (37.7273803570158, -122.447788509344) | ||||
| 38724 | 38724 | 204643 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 290 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995381.41136 | 2092014.7979700002 | 37.7240094335681 | -122.458118187113 | (37.7240094335681, -122.458118187113) | |||
| 39326 | 39326 | 221354 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2979 21st St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008383.52326 | 2103860.65415 | 37.7572740646699 | -122.41400939143601 | (37.7572740646699, -122.414009391436) | |||
| 51006 | 51006 | 221351 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 85 Sycamore St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6006363.61838 | 2105832.54053 | 37.7625747506491 | -122.421135037456 | (37.7625747506491, -122.421135037456) | |||
| 56696 | 56696 | 188309 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195 Arkansas St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012912.6135599995 | 2106204.46931 | 37.763962999012996 | -122.398510384468 | (37.763962999013, -122.398510384468) | |||
| 62010 | 62010 | 188308 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 195 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 6012915.64836 | 2106174.8089400004 | 37.76388172727871 | -122.398497806527 | (37.7638817272787, -122.398497806527) | |||
| 63595 | 63595 | 181646 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1266 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986485.3888 | 2106651.0455 | 37.7636814828681 | -122.489945903056 | (37.7636814828681, -122.489945903056) | |||
| 101889 | 101889 | 95411 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2815 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 1 | 3x3 | Planted by Glen Park Library; will become DPW maintained. | 6002467.0 | 2095594.0 | 37.734241695714005 | -122.43388015504499 | (37.734241695714, -122.433880155045) | |
| 120383 | 120383 | 95412 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2815 Diamond St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | DPW 4 | 1 | 3x3 | Planted by Glen Park Public Library; will become DPW maintained after it is established. | 6002467.0 | 2095594.0 | 37.734241695714005 | -122.43388015504499 | (37.734241695714, -122.433880155045) | |
| 131647 | 131647 | 175755 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 10 Ruth St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 2ft | 6001686.67815 | 2091578.8653 | 37.7231727394058 | -122.43629071923401 | (37.7231727394058, -122.436290719234) | |||
| 132718 | 132718 | 188329 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1850 23rd St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 2ft | 6012894.83022 | 2102885.3269599997 | 37.7548483718617 | -122.398338992565 | (37.7548483718617, -122.398338992565) | |||
| 137884 | 137884 | 221328 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 178 Peralta Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6009834.372719999 | 2100044.46783 | 37.7468770447458 | -122.40872254780399 | (37.7468770447458, -122.408722547804) | |||
| 147105 | 147105 | 182416 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1555 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5987127.1216 | 2104695.2134 | 37.758348756439204 | -122.487582689554 | (37.7583487564392, -122.487582689554) | |||
| 153820 | 153820 | 108373 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 637 Naples St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | Permit Number 773812 | 6002662.58132 | 2089906.96275 | 37.718637468222 | -122.432797836946 | (37.718637468222, -122.432797836946) | |
| 159023 | 159023 | 114552 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1121 Kansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/24/2015 12:00:00 AM | 1 | Permit Number 777071 | 6011681.54455 | 2103150.14548 | 37.7555078447183 | -122.402553516927 | (37.7555078447183, -122.402553516927) | ||
| 162269 | 162269 | 39521 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1330 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/1998 12:00:00 AM | 1 | 3x3 | Permit Number 40968 | 6012480.371 | 2107070.1033 | 37.7663157471753 | -122.400066187848 | (37.7663157471753, -122.400066187848) |
| 165500 | 165500 | 175780 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 21 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003848.49776 | 2093464.0621200001 | 37.728471665422504 | -122.4289520724 | (37.7284716654225, -122.4289520724) | |||
| 169971 | 169971 | 184438 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2118 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982650.6525 | 2100679.8359 | 37.7470615561433 | -122.50276680933399 | (37.7470615561433, -122.502766809334) | |||
| 171430 | 171430 | 30366 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 764 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/12/2005 12:00:00 AM | 1 | Permit Number 38805 | 6013019.81503 | 2103473.1005 | 37.756469231694005 | -122.397947987108 | (37.756469231694, -122.397947987108) | |
| 172887 | 172887 | 221363 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1301 Douglass St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6001383.2027 | 2099881.79885 | 37.745953424815504 | -122.43793420150699 | (37.7459534248155, -122.437934201507) | |||
| 175753 | 175753 | 204641 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 290 Granada Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995679.43604 | 2091904.4278 | 37.7237235031239 | -122.45707998907601 | (37.7237235031239, -122.457079989076) | |||
| 182698 | 182698 | 108374 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 637 Naples St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | Permit Number 773812 | 6002670.30203 | 2089919.45736 | 37.718672213540295 | -122.432772041698 | (37.7186722135403, -122.432772041698) |
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");