Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 375 | 375 | 251284 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299x Hudson Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | Private 3 | 06/21/1996 12:00:00 AM | 3x3 | 6017207.0 | 2095414.0 | 37.7345728945406 | -122.38290623346 | (37.7345728945406, -122.38290623346) | ||
| 11345 | 11345 | 27198 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 302 Silver Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 3 | 3X3 | 6003379.2285400005 | 2093490.3772 | 37.7285173473825 | -122.43057623633001 | (37.7285173473825, -122.43057623633) | ||
| 16389 | 16389 | 96935 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 901 Bay Shore Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6010973.7505 | 2094855.21788 | 37.7326922251695 | -122.404417459925 | (37.7326922251695, -122.404417459925) | |||
| 25966 | 25966 | 204670 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 380 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999483.78605 | 2094717.6896400002 | 37.7316658109241 | -122.44413109610001 | (37.7316658109241, -122.4441310961) | |||
| 30579 | 30579 | 175758 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 201 Tocoloma Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 6012839.87945 | 2087571.5634599999 | 37.7127968922232 | -122.397455115464 | (37.7127968922232, -122.397455115464) | ||||
| 30747 | 30747 | 188322 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 800 Wisconsin St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012715.86863 | 2103660.87857 | 37.75696789675921 | -122.39901232755399 | (37.7569678967592, -122.399012327554) | |||
| 44691 | 44691 | 175766 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5989094.03032 | 2089506.27121 | 37.7167583770722 | -122.47966897135001 | (37.7167583770722, -122.47966897135) | ||||
| 51195 | 51195 | 244276 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 480 Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6004294.0037 | 2109808.1625 | 37.7733739594079 | -122.428576486808 | (37.7733739594079, -122.428576486808) | |||
| 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) | ||||
| 89141 | 89141 | 30743 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 490X Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 01/31/1995 12:00:00 AM | 3 | 3x3 | Permit Number 34630 | 6004161.50647736 | 2110040.16949733 | 37.7740034947051 | -122.42905135835501 | (37.7740034947051, -122.429051358355) |
| 91224 | 91224 | 96020 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 810 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767661 | 6008769.0 | 2115301.0 | 37.7887082111555 | -122.413485341988 | (37.7887082111555, -122.413485341988) | |
| 92027 | 92027 | 103511 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 100X Leroy Pl | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6008356.0 | 2116660.0 | 37.7924164947138 | -122.41501049488501 | (37.7924164947138, -122.415010494885) | |||
| 107908 | 107908 | 41599 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 11 Haight St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | Permit Number 42106 | 6006168.11250893 | 2109650.54781373 | 37.7730470683498 | -122.42208247198299 | (37.7730470683498, -122.422082471983) | |||
| 111947 | 111947 | 48438 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2399 Post St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2002 12:00:00 AM | Permit Number 45814 | 6000698.38093235 | 2113767.30398552 | 37.784040615681 | -122.441298346596 | (37.784040615681, -122.441298346596) | |||
| 120251 | 120251 | 47218 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 102 Colby St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/2002 12:00:00 AM | Permit Number 45167 | 6008165.27144692 | 2093507.30784615 | 37.7288338073717 | -122.414031775389 | (37.7288338073717, -122.414031775389) | ||
| 121491 | 121491 | 116351 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 4051X 24TH ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | MTA 6 | 3x3 | 6002850.0 | 2101803.0 | 37.7513118941202 | -122.432999456035 | (37.7513118941202, -122.432999456035) | ||||
| 124787 | 124787 | 16142 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 370 Monterey Blvd | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5999632.4946283 | 2094718.5075125 | 37.7316765391045 | -122.443617041287 | (37.7316765391045, -122.443617041287) | |||
| 139848 | 139848 | 27127 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2095X Silver Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/16/1999 12:00:00 AM | 6 | 3X3 | 6012407.8106259005 | 2096047.4553772 | 37.736045896585495 | -122.399543203223 | (37.7360458965855, -122.399543203223) | ||
| 140514 | 140514 | 10856 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1299X HUDSON AVE | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/21/1996 12:00:00 AM | 6 | 3X4 | 6017281.0 | 2095243.0 | 37.734107450868 | -122.38263849321599 | (37.734107450868, -122.382638493216) | ||
| 149081 | 149081 | 116875 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 824 Carolina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6012413.40755 | 2104121.29509 | 37.7582152402716 | -122.400090692059 | (37.7582152402716, -122.400090692059) | |||
| 150539 | 150539 | 188297 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1582 12th St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 5ft | 6008118.01492 | 2108896.99552 | 37.771087775398705 | -122.415284140848 | (37.7710877753987, -122.415284140848) | |||
| 158243 | 158243 | 119916 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 3801 Anza St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5986867.2095099995 | 2111818.56024 | 37.777892319492295 | -122.489005232889 | (37.7778923194923, -122.489005232889) | |||
| 162660 | 162660 | 139384 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1492 Broderick St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000711.3822 | 2113738.0773 | 37.7839611073263 | -122.441251269333 | (37.7839611073263, -122.441251269333) | |||
| 170092 | 170092 | 43890 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1233 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/03/2000 12:00:00 AM | 5 | Permit Number 43498 | 6009124.11279 | 2110606.98987 | 37.77583951252829 | -122.41192485917 | (37.7758395125283, -122.41192485917) | ||
| 171701 | 171701 | 175770 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 0 Gonzalez Dr | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 27 | 5989758.80887 | 2089246.54995 | 37.7160838423675 | -122.477352214341 | (37.7160838423675, -122.477352214341) | ||||
| 180711 | 180711 | 188316 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 850 Carolina St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6012420.02519 | 2103984.29593 | 37.7578394396596 | -122.40005818423799 | (37.7578394396596, -122.400058184238) | |||
| 181339 | 181339 | 124077 | Undocumented 2 | Callistemon viminalis :: Weeping Bottlebrush 20 | 701 Funston Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5991933.739630001 | 2110279.93645 | 37.7739620806591 | -122.471366355942 | (37.7739620806591, -122.471366355942) |
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");