Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16786 | 16786 | 110745 | Section 143 8 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 2300x Mariposa St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/05/2015 12:00:00 AM | 3 | 3x3 | 6010533.01376 | 2106015.32988 | 37.763310810661295 | -122.406727421634 | (37.7633108106613, -122.406727421634) | ||
| 33408 | 33408 | 206428 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 999 Chenery St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 6000994.535540001 | 2096137.9809700001 | 37.7356516718869 | -122.43900989591499 | (37.7356516718869, -122.439009895915) | |||
| 44230 | 44230 | 206429 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 681 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | 5997546.5717400005 | 2094969.2613 | 37.7322458610553 | -122.450846532568 | (37.7322458610553, -122.450846532568) | ||||
| 45405 | 45405 | 222976 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 1250 San Jose Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6003899.91915 | 2095844.7801599998 | 37.735011492168205 | -122.428943969481 | (37.7350114921682, -122.428943969481) | |||
| 49517 | 49517 | 222973 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 271 Bemis St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6002983.66177 | 2096230.12236 | 37.736017648289 | -122.43213930391 | (37.736017648289, -122.43213930391) | |||
| 52667 | 52667 | 206430 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 20 Mendosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993491.7391099995 | 2101167.40276 | 37.749031446253 | -122.465314958712 | (37.749031446253, -122.465314958712) | |||
| 58898 | 58898 | 222971 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 621 Jarboe Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6008732.361740001 | 2096944.66893 | 37.738303894007295 | -122.41231415408001 | (37.7383038940073, -122.41231415408) | |||
| 74874 | 74874 | 126355 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 2826 Broderick St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 4ft | 6000087.33004 | 2118307.97161 | 37.7964732733833 | -122.44373867332199 | (37.7964732733833, -122.443738673322) | |||
| 135379 | 135379 | 222974 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 45 Aztec St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6007582.8393 | 2099584.38119 | 37.7454873853315 | -122.416475577999 | (37.7454873853315, -122.416475577999) | |||
| 148206 | 148206 | 222972 | DPW Maintained 3 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 500x 27th St | 27 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 4ft | 6002994.97901 | 2100071.17381 | 37.746564928728205 | -122.432374425345 | (37.7465649287282, -122.432374425345) | |||
| 157392 | 157392 | 190908 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 1 01st St | 32 | : Yard 23 | Tree 1 | Private 1 | 1 | 6014392.80706 | 2105893.3505 | 37.7631910848138 | -122.393369022367 | (37.7631910848138, -122.393369022367) | ||||
| 158000 | 158000 | 222977 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 150 Coso Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | 6007376.65063 | 2099645.40217 | 37.7456433376618 | -122.417192870974 | (37.7456433376618, -122.417192870974) | ||||
| 166267 | 166267 | 222975 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 1250 San Jose Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6003909.72513 | 2095852.1134900001 | 37.735032182874605 | -122.42891058937799 | (37.7350321828746, -122.428910589378) | |||
| 173570 | 173570 | 75012 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 618X Missouri St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/03/1996 12:00:00 AM | 2 | 6013537.74567 | 2104188.90633 | 37.7584635107089 | -122.396206952689 | (37.7584635107089, -122.396206952689) | ||
| 176309 | 176309 | 190907 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 901 24th St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 2 | Width 5ft | 6015410.61611 | 2102532.4645 | 37.754019306672 | -122.38961398771299 | (37.754019306672, -122.389613987713) | |||
| 182235 | 182235 | 190909 | Undocumented 2 | Cotinus coggygria 'Royal Purple' :: Smoke tree 298 | 1301 19th St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013727.00615 | 2105213.48323 | 37.76128730458971 | -122.395624185733 | (37.7612873045897, -122.395624185733) |
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");