Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3786 | 3786 | 182314 | Permitted Site 1 | Hakea suaveolens :: Sweet Hakea Tree 14 | 2722 Kirkham St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2001 12:00:00 AM | 8 | Width 0ft | Permit Number 43905 | 5986467.3075 | 2105072.335 | 37.7593457241234 | -122.489892322597 | (37.7593457241234, -122.489892322597) | |
| 27920 | 27920 | 219161 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 521 Bright St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 5993760.1338 | 2090633.97995 | 37.720124750843794 | -122.463622478709 | (37.7201247508438, -122.463622478709) | |||
| 40272 | 40272 | 72148 | Permitted Site 1 | Hakea suaveolens :: Sweet Hakea Tree 14 | 86 San Gabriel Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/15/2010 12:00:00 AM | 8 | 3x3 | Permit Number 53743 | 6000997.4480800005 | 2093594.63988 | 37.72866841100429 | -122.43881762803998 | (37.7286684110043, -122.43881762804) |
| 58979 | 58979 | 183140 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 3349 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5982406.7135 | 2099430.6148 | 37.74361720224611 | -122.503517824716 | (37.7436172022461, -122.503517824716) | |||
| 60262 | 60262 | 219167 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 13 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 5993768.02883 | 2100241.187 | 37.7465042226907 | -122.464292318936 | (37.7465042226907, -122.464292318936) | |||
| 70245 | 70245 | 190636 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 1 01st St | 30 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014391.99798 | 2105898.86804 | 37.763206189822796 | -122.393372206868 | (37.7632061898228, -122.393372206868) | ||||
| 107608 | 107608 | 52570 | Permitted Site 1 | Hakea suaveolens :: Sweet Hakea Tree 14 | 1600 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 8 | Permit Number 48665 | 5983775.59805013 | 2104247.52774772 | 37.756923495634496 | -122.49914047475201 | (37.7569234956345, -122.499140474752) | |
| 132890 | 132890 | 47213 | Permitted Site 1 | Hakea suaveolens :: Sweet Hakea Tree 14 | 786 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2002 12:00:00 AM | 8 | Permit Number 45164 | 5982321.87525 | 2110412.54018 | 37.773765463784706 | -122.504624671037 | (37.7737654637847, -122.504624671037) | |
| 153012 | 153012 | 46379 | Permitted Site 1 | Hakea suaveolens :: Sweet Hakea Tree 14 | 2487 43rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/05/2002 12:00:00 AM | 8 | Permit Number 44616 | 5982998.62822569 | 2098215.25779792 | 37.740314946690795 | -122.501381278015 | (37.7403149466908, -122.501381278015) | |
| 153512 | 153512 | 219166 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 99x San Marcos Ave | 12 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 5ft | 5993758.91368 | 2100249.51951 | 37.7465265762511 | -122.46432444273 | (37.7465265762511, -122.46432444273) | |||
| 172293 | 172293 | 184682 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 3345 Lawton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5983812.8255 | 2104241.7528 | 37.756909823021005 | -122.499011303641 | (37.756909823021, -122.499011303641) | |||
| 179342 | 179342 | 184680 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 3349 Lawton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5983788.2273 | 2104242.0898 | 37.7569093054043 | -122.49909639697701 | (37.7569093054043, -122.499096396977) |
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");