Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15106 | 15106 | 104458 | DPW Maintained 3 | Betula pendula :: European White Birch 146 | 1601X Kansas St | 4 | Sidewalk: Property side : Cutout 5 | Tree 1 | DPW 2 | 4 | 3x6 | 6011832.95066 | 2100589.70632 | 37.748485888729206 | -122.40184993054501 | (37.7484858887292, -122.401849930545) | |||
| 25121 | 25121 | 221244 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3961 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004104.16813 | 2101283.0183099997 | 37.7499552046892 | -122.428625337904 | (37.7499552046892, -122.428625337904) | |||
| 26443 | 26443 | 83812 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1401 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 4 | 6008431.92619 | 2117409.9703900004 | 37.794479995297706 | -122.41480088836201 | (37.7944799952977, -122.414800888362) | ||
| 29156 | 29156 | 221241 | Undocumented 2 | Betula pendula :: European White Birch 146 | 4239 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002260.12391 | 2101180.90395 | 37.749570289451206 | -122.434994824965 | (37.7495702894512, -122.434994824965) | |||
| 31957 | 31957 | 43034 | Permitted Site 1 | Betula pendula :: European White Birch 146 | 2488 Sutter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/06/2000 12:00:00 AM | 4 | Permit Number 42894 | 6000712.8749 | 2114163.5032 | 37.7851293023636 | -122.441276640017 | (37.7851293023636, -122.441276640017) | ||
| 36232 | 36232 | 246668 | Undocumented 2 | Betula pendula :: European White Birch 146 | 199 Ripley St | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6009255.34183 | 2099144.3837900003 | 37.744373163998794 | -122.410661237926 | (37.7443731639988, -122.410661237926) | |||
| 38830 | 38830 | 119928 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3750 Anza St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 7ft | 5986949.49746 | 2111884.4903599997 | 37.7780781472848 | -122.488725421171 | (37.7780781472848, -122.488725421171) | |||
| 40662 | 40662 | 83810 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1401 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 4 | 6008433.54799 | 2117383.58824 | 37.7944076475381 | -122.414793408706 | (37.7944076475381, -122.414793408706) | ||
| 40955 | 40955 | 182042 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1329 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5987076.1241 | 2106191.7238 | 37.7624547889055 | -122.487869010507 | (37.7624547889055, -122.487869010507) | |||
| 48449 | 48449 | 188813 | Undocumented 2 | Betula pendula :: European White Birch 146 | 2005 17th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6011398.91522 | 2106483.38138 | 37.764644384756295 | -122.403765472117 | (37.7646443847563, -122.403765472117) | |||
| 50476 | 50476 | 205624 | Undocumented 2 | Betula pendula :: European White Birch 146 | 76 Dorado Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 5994666.363480001 | 2093043.17057 | 37.726791984541 | -122.460664466391 | (37.726791984541, -122.460664466391) | |||
| 56150 | 56150 | 249670 | Undocumented 2 | Betula pendula :: European White Birch 146 | 2400 Baker St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 5999738.32822 | 2117112.31021 | 37.7931703917478 | -122.444860299664 | (37.7931703917478, -122.444860299664) | ||||
| 59668 | 59668 | 246653 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009062.80504 | 2099192.42716 | 37.7444942837766 | -122.411330385709 | (37.7444942837766, -122.411330385709) | ||||
| 64950 | 64950 | 246654 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009056.91969 | 2099197.55038 | 37.744508020922396 | -122.41135109798599 | (37.7445080209224, -122.411351097986) | ||||
| 67141 | 67141 | 83807 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1401 Jones St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 4 | 4x4 | 6008437.72882 | 2117343.11767 | 37.794296760229294 | -122.414776076964 | (37.7942967602293, -122.414776076964) | |
| 71083 | 71083 | 175563 | Undocumented 2 | Betula pendula :: European White Birch 146 | 0 Gonzalez Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5988277.07749 | 2089797.21556 | 37.71750974536221 | -122.482514046798 | (37.7175097453622, -122.482514046798) | ||||
| 124109 | 124109 | 246657 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009066.271869999 | 2099220.25657 | 37.7445708916489 | -122.411320363658 | (37.7445708916489, -122.411320363658) | ||||
| 126509 | 126509 | 114369 | Undocumented 2 | Betula pendula :: European White Birch 146 | 823 GONZALEZ DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | 5988303.0 | 2089566.0 | 37.7168763935413 | -122.482407513776 | (37.7168763935413, -122.482407513776) | ||||
| 134119 | 134119 | 205627 | Undocumented 2 | Betula pendula :: European White Birch 146 | 55 Linares Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 3ft | 5993995.91474 | 2102156.2239200003 | 37.7517755602042 | -122.463643285426 | (37.7517755602042, -122.463643285426) | |||
| 135305 | 135305 | 83809 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1401 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 4 | 6008435.07794 | 2117371.48968 | 37.794374513836104 | -122.414787258234 | (37.7943745138361, -122.414787258234) | ||
| 137720 | 137720 | 246662 | Undocumented 2 | Betula pendula :: European White Birch 146 | 199 Ripley St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6009287.77432 | 2099148.06165 | 37.7443850809164 | -122.41054935237699 | (37.7443850809164, -122.410549352377) | |||
| 150291 | 150291 | 246652 | Undocumented 2 | Betula pendula :: European White Birch 146 | 3351 Harrison St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 4 | 6009060.331019999 | 2099186.6417900003 | 37.744478259665996 | -122.411338531775 | (37.744478259666, -122.411338531775) | ||||
| 161005 | 161005 | 249692 | Undocumented 2 | Betula pendula :: European White Birch 146 | 2400 Baker St | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 5999712.04694 | 2117251.89075 | 37.7935521431604 | -122.44496127283999 | (37.7935521431604, -122.44496127284) | ||||
| 171711 | 171711 | 83811 | Undocumented 2 | Betula pendula :: European White Birch 146 | 1401 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/21/2006 12:00:00 AM | 4 | 6008432.334919999 | 2117395.35869 | 37.7944398981349 | -122.414798439505 | (37.7944398981349, -122.414798439505) | ||
| 173749 | 173749 | 249673 | Undocumented 2 | Betula pendula :: European White Birch 146 | 2400 Baker St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | 5999744.88786 | 2117135.23947 | 37.793233723796796 | -122.444839251946 | (37.7932337237968, -122.444839251946) |
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");