Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3782 | 3782 | 182315 | Permitted Site 1 | Hakea suaveolens :: Sweet Hakea Tree 14 | 2724 Kirkham St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/12/2001 12:00:00 AM | 9 | Width 0ft | Permit Number 43905 | 5986428.3511 | 2105069.3949 | 37.759335376640294 | -122.490026834722 | (37.7593353766403, -122.490026834722) | |
| 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) |
| 43982 | 43982 | 122248 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 2 14th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 5991505.6794 | 2114885.8610799997 | 37.786583912584 | -122.473183050399 | (37.786583912584, -122.473183050399) | |||
| 50422 | 50422 | 183141 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 3345 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5982420.2443 | 2099431.2913 | 37.7436198552063 | -122.50347108938601 | (37.7436198552063, -122.503471089386) | |||
| 92727 | 92727 | 44372 | Permitted Site 1 | Hakea suaveolens :: Sweet Hakea Tree 14 | 3000 25th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/31/2001 12:00:00 AM | Permit Number 43739 | 5988858.57145041 | 2095220.96614763 | 37.7324357997732 | -122.480900990723 | (37.7324357997732, -122.480900990723) | ||
| 120065 | 120065 | 52568 | Permitted Site 1 | Hakea suaveolens :: Sweet Hakea Tree 14 | 1600 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 9 | Permit Number 48665 | 5983775.59805013 | 2104247.52774772 | 37.756923495634496 | -122.49914047475201 | (37.7569234956345, -122.499140474752) | |
| 131097 | 131097 | 184681 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 3347 Lawton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5983801.7058 | 2104241.4158 | 37.756908245442 | -122.499049734219 | (37.756908245442, -122.499049734219) | |||
| 145953 | 145953 | 12668 | DPW Maintained 3 | Hakea suaveolens :: Sweet Hakea Tree 14 | 1124 Lake St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 70 | 3X3 | 5991953.3721 | 2114824.26552 | 37.7864406996636 | -122.471629667444 | (37.7864406996636, -122.471629667444) | |||
| 151029 | 151029 | 52552 | Permitted Site 1 | Hakea suaveolens :: Sweet Hakea Tree 14 | 1570 38th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2006 12:00:00 AM | 3 | Permit Number 48646 | 5984388.12260109 | 2104491.91964058 | 37.757630440730296 | -122.49704020611999 | (37.7576304407303, -122.49704020612) | |
| 176299 | 176299 | 182645 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 2326 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5986741.8525 | 2102358.1899 | 37.751909449151796 | -122.48874332116002 | (37.7519094491518, -122.48874332116) | |||
| 176539 | 176539 | 183213 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 2219 43rd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5982939.2739 | 2099996.1393 | 37.745201271967204 | -122.501718222466 | (37.7452012719672, -122.501718222466) | |||
| 180055 | 180055 | 184651 | Undocumented 2 | Hakea suaveolens :: Sweet Hakea Tree 14 | 3340 Moraga St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5983852.0817 | 2103619.2141 | 37.7552028082153 | -122.49882955279399 | (37.7552028082153, -122.498829552794) |
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");