Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40511 | 40511 | 66824 | Permitted Site 1 | Cassia leptophylla :: Gold Medallion Tree 406 | 225 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/23/1994 12:00:00 AM | 7 | Permit Number 30120 | 5997817.9413 | 2109780.1957 | 37.7729285493952 | -122.450975970453 | (37.7729285493952, -122.450975970453) | |
| 53532 | 53532 | 222613 | Undocumented 2 | Cassia leptophylla :: Gold Medallion Tree 406 | 2671 22nd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6010097.92629 | 2103368.2864900003 | 37.7560182729435 | -122.408045566068 | (37.7560182729435, -122.408045566068) | |||
| 59636 | 59636 | 48535 | Permitted Site 1 | Cassia leptophylla :: Gold Medallion Tree 406 | 20 Cook St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/2002 12:00:00 AM | 6 | Permit Number 45858 | 5997506.862000001 | 2113470.6571 | 37.7830437798156 | -122.452318374447 | (37.7830437798156, -122.452318374447) | |
| 71590 | 71590 | 222615 | Undocumented 2 | Cassia leptophylla :: Gold Medallion Tree 406 | 34 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998460.8716 | 2107260.22492 | 37.766046137330605 | -122.44857048426 | (37.7660461373306, -122.44857048426) | |||
| 79039 | 79039 | 112619 | Section 143 8 | Cassia leptophylla :: Gold Medallion Tree 406 | 3534 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/12/2015 12:00:00 AM | 3x3 | 6005980.0 | 2102026.6 | 37.752102890525606 | -122.42219142885 | (37.7521028905256, -122.42219142885) | |||
| 105481 | 105481 | 93548 | Permitted Site 1 | Cassia leptophylla :: Gold Medallion Tree 406 | 1860 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/10/2010 12:00:00 AM | Permit Number 53244 | 5997669.0 | 2108882.0 | 37.7704538072826 | -122.451426378466 | (37.7704538072826, -122.451426378466) | |||
| 118695 | 118695 | 108511 | Permitted Site 1 | Cassia leptophylla :: Gold Medallion Tree 406 | 301x LEXINGTON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2015 12:00:00 AM | 3 | 3x3 | Permit Number 775600 | 6006555.0 | 2104289.0 | 37.7583473352026 | -122.420363554061 | (37.7583473352026, -122.420363554061) | |
| 127447 | 127447 | 78664 | Permitted Site 1 | Cassia leptophylla :: Gold Medallion Tree 406 | 1110 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/25/2008 12:00:00 AM | 3x3 | Permit Number 51506 | 6001236.93227028 | 2109383.43753665 | 37.772034291469396 | -122.439120856334 | (37.7720342914694, -122.439120856334) | ||
| 163819 | 163819 | 222614 | Undocumented 2 | Cassia leptophylla :: Gold Medallion Tree 406 | 2876 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010138.73273 | 2101659.88938 | 37.751329679030704 | -122.40778398386401 | (37.7513296790307, -122.407783983864) | |||
| 169429 | 169429 | 188395 | Undocumented 2 | Cassia leptophylla :: Gold Medallion Tree 406 | 1618 Jerrold Ave | 2 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015178.3816 | 2097166.29925 | 37.7392720564504 | -122.39004227634199 | (37.7392720564504, -122.390042276342) | |||
| 170327 | 170327 | 188394 | Undocumented 2 | Cassia leptophylla :: Gold Medallion Tree 406 | 1618 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6015188.47499 | 2097158.6579 | 37.7392516346604 | -122.39000684395901 | (37.7392516346604, -122.390006843959) | |||
| 179374 | 179374 | 247207 | Undocumented 2 | Cassia leptophylla :: Gold Medallion Tree 406 | 800 Duboce Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 6001883.43002 | 2108299.04695 | 37.7690935890354 | -122.436806933701 | (37.7690935890354, -122.436806933701) |
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");