Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, PlantDate, PlotSize, PermitNotes
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27953 | 27953 | 227044 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 319 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6006891.79407 | 2096315.8696700002 | 37.7364738950591 | -122.41863336815399 | (37.7364738950591, -122.418633368154) | |||
| 31504 | 31504 | 85233 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 355 Berry St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/19/2007 12:00:00 AM | 12 | Permit Number 49539 | 6013385.079919999 | 2109389.55863 | 37.7727348540654 | -122.397099599979 | (37.7727348540654, -122.397099599979) | ||
| 32951 | 32951 | 190852 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014650.447319999 | 2110654.39937 | 37.7762781838256 | -122.392811023636 | (37.7762781838256, -122.392811023636) | |||
| 38306 | 38306 | 190886 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 255 Berry St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6013955.0722900005 | 2109935.90001 | 37.774266698985 | -122.395166195169 | (37.774266698985, -122.395166195169) | |||
| 50770 | 50770 | 190848 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014724.19019 | 2110724.1932200002 | 37.7764739176778 | -122.39256080793001 | (37.7764739176778, -122.39256080793) | |||
| 53359 | 53359 | 190869 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 200 Berry St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014125.99477 | 2110153.29442 | 37.774873119023205 | -122.394590165008 | (37.7748731190232, -122.394590165008) | |||
| 60290 | 60290 | 51124 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 12 | Permit Number 47557 | 6012694.61425 | 2108791.31053 | 37.7710537387716 | -122.399446004933 | (37.7710537387716, -122.399446004933) | ||
| 60991 | 60991 | 191152 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014282.05159 | 2110245.81497 | 37.7751358343856 | -122.39405680588101 | (37.7751358343856, -122.394056805881) | |||
| 62300 | 62300 | 190845 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014811.37622 | 2110807.32883 | 37.7767070309344 | -122.39226502002899 | (37.7767070309344, -122.392265020029) | |||
| 76978 | 76978 | 190864 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 180 Berry St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014254.38486 | 2110274.9394900003 | 37.7752142660511 | -122.39415455141399 | (37.7752142660511, -122.394154551414) | |||
| 129638 | 129638 | 191192 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 401 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6013013.2029099995 | 2109033.31501 | 37.7717359806621 | -122.398360971982 | (37.7717359806621, -122.398360971982) | |||
| 161462 | 161462 | 190849 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 150 Berry St | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014705.4339 | 2110706.25649 | 37.776423625788496 | -122.392624436776 | (37.7764236257885, -122.392624436776) | |||
| 168757 | 168757 | 191212 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 325 Berry St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6013783.16711 | 2109770.0092599997 | 37.7738016388768 | -122.39574922474199 | (37.7738016388768, -122.395749224742) | |||
| 174965 | 174965 | 190895 | Undocumented 2 | Koelreuteria paniculata :: Golden Rain Tree 56 | 235 Berry St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 5ft | 6014262.57866 | 2110228.29984 | 37.7750866594644 | -122.394122941124 | (37.7750866594644, -122.394122941124) | |||
| 186041 | 186041 | 51128 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 12 | Permit Number 47557 | 6012773.055380001 | 2108865.31837 | 37.7712613193831 | -122.399179868575 | (37.7712613193831, -122.399179868575) | ||
| 186208 | 186208 | 51125 | Permitted Site 1 | Koelreuteria paniculata :: Golden Rain Tree 56 | 420@ 6TH ST Berry St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/27/2004 12:00:00 AM | 12 | Permit Number 47557 | 6012869.40685 | 2108957.05013 | 37.7715185632492 | -122.398853021653 | (37.7715185632492, -122.398853021653) |
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");