Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qCaretaker, PlantDate, DBH, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10587 | 10587 | 27191 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 270 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 2X3 | 6002970.12798 | 2093687.91706 | 37.729036562883 | -122.43200461784299 | (37.729036562883, -122.432004617843) | ||
| 10609 | 10609 | 27189 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 262 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 2X3 | 6002929.54622 | 2093714.9160799999 | 37.729108395319706 | -122.432146839331 | (37.7291083953197, -122.432146839331) | ||
| 10716 | 10716 | 27187 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 250 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/25/2002 12:00:00 AM | 6 | 2X3 | 6002862.24087 | 2093754.97277 | 37.7292145657007 | -122.43238237894501 | (37.7292145657007, -122.432382378945) | ||
| 11427 | 11427 | 27057 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 945 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/25/1999 12:00:00 AM | 7 | 2X3 | 6007415.89764 | 2093543.05958 | 37.72888985646029 | -122.416624950003 | (37.7288898564603, -122.416624950003) | ||
| 11796 | 11796 | 27192 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 284 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 2X3 | 6003080.50306 | 2093615.49168 | 37.7288439559672 | -122.431617874266 | (37.7288439559672, -122.431617874266) | ||
| 12304 | 12304 | 27185 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 238 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/08/1999 12:00:00 AM | 6 | 2X3 | 6002801.11945 | 2093793.8954 | 37.7293179724305 | -122.43259645987101 | (37.7293179724305, -122.432596459871) | ||
| 12742 | 12742 | 27190 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 266 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/08/1999 12:00:00 AM | 6 | 2X3 | 6002951.03979 | 2093700.24177 | 37.729069321573604 | -122.432071486902 | (37.7290693215736, -122.432071486902) | ||
| 13949 | 13949 | 27171 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2206 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/12/1999 12:00:00 AM | 6 | 2X3 | 6012761.81609 | 2096197.8088200002 | 37.7364784617996 | -122.398329801495 | (37.7364784617996, -122.398329801495) | ||
| 13978 | 13978 | 27170 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2080 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 2X3 | 6012569.10474 | 2096085.04169 | 37.7361580900166 | -122.398988178079 | (37.7361580900166, -122.398988178079) | ||
| 14432 | 14432 | 27132 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2009 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/19/2004 12:00:00 AM | 3 | 2X3 | 6012226.6815599995 | 2095938.3676200002 | 37.735736266604704 | -122.40016178436501 | (37.7357362666047, -122.400161784365) | ||
| 14967 | 14967 | 27136 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1909 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/13/1999 12:00:00 AM | 7 | 2X3 | 6011799.55776 | 2095649.995 | 37.734920630966 | -122.40161826426599 | (37.734920630966, -122.401618264266) | ||
| 15016 | 15016 | 27146 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1751 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/19/1999 12:00:00 AM | 3 | 2X3 | 6011294.03802 | 2095268.15566 | 37.7338439590333 | -122.403339179952 | (37.7338439590333, -122.403339179952) | ||
| 15119 | 15119 | 27174 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2300X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 2X3 | 6013069.06083 | 2096365.0106900001 | 37.7369546735192 | -122.397279240461 | (37.7369546735192, -122.397279240461) | ||
| 15299 | 15299 | 27175 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2300X Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 2X3 | 6013102.951669999 | 2096377.5356599998 | 37.736990951255706 | -122.397162941913 | (37.7369909512557, -122.397162941913) | ||
| 15540 | 15540 | 27131 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 2015 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 2X3 | 6012250.55523 | 2095951.9003599999 | 37.735774755805295 | -122.400080193368 | (37.7357747558053, -122.400080193368) | ||
| 16365 | 16365 | 27145 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1751 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/19/1999 12:00:00 AM | 3 | 2X3 | 6011315.84096 | 2095284.6201400002 | 37.7338903847377 | -122.40326495802499 | (37.7338903847377, -122.403264958025) | ||
| 17274 | 17274 | 22551 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 33 Topaz Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/1992 12:00:00 AM | 20 | 2X3 | 6001555.699019999 | 2098568.2188 | 37.74235645138 | -122.437243695762 | (37.74235645138, -122.437243695762) | ||
| 86882 | 86882 | 27082 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 799X Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/08/2000 12:00:00 AM | 6 | 2X3 | 6006577.59669 | 2093640.7294700001 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | ||
| 89646 | 89646 | 27087 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 743X Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1999 12:00:00 AM | 6 | 2X3 | 6006221.2435099995 | 2093597.03752 | 37.7289708064437 | -122.420758791245 | (37.7289708064437, -122.420758791245) | ||
| 94844 | 94844 | 27167 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 1970 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/1999 12:00:00 AM | 6 | 2X3 | 6011914.946409999 | 2095658.54752 | 37.734950552546394 | -122.401219923596 | (37.7349505525464, -122.401219923596) | ||
| 100453 | 100453 | 27079 | DPW Maintained 3 | Callistemon viminalis :: Weeping Bottlebrush 20 | 799X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/26/1999 12:00:00 AM | 8 | 2X3 | 6006577.59669 | 2093640.7294700001 | 37.7291108536609 | -122.419529947915 | (37.7291108536609, -122.419529947915) | ||
| 122819 | 122819 | 27088 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 743X Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1999 12:00:00 AM | 6 | 2X3 | 6006210.7557 | 2093597.31773 | 37.728970984710294 | -122.42079506833099 | (37.7289709847103, -122.420795068331) | ||
| 124216 | 124216 | 27086 | Permitted Site 1 | Callistemon viminalis :: Weeping Bottlebrush 20 | 743X Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/26/1999 12:00:00 AM | 6 | 2X3 | 6006263.01382 | 2093613.9745099999 | 37.7290196659204 | -122.42061558974702 | (37.7290196659204, -122.420615589747) |
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");