Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27224 | 27224 | 190666 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Freelon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6013164.18283 | 2111305.0882200003 | 37.7779821643861 | -122.397998114425 | (37.7779821643861, -122.397998114425) | |||
| 55309 | 55309 | 190664 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6013137.75359 | 2111279.19954 | 37.7779096079765 | -122.398087726493 | (37.7779096079765, -122.398087726493) | |||
| 56606 | 56606 | 219177 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 1351 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5991107.88095 | 2106214.54011 | 37.7627517902819 | -122.473926451152 | (37.7627517902819, -122.473926451152) | |||
| 56681 | 56681 | 190671 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 149 Freelon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6013262.027919999 | 2111394.33223 | 37.7782326570475 | -122.397665892288 | (37.7782326570475, -122.397665892288) | |||
| 59088 | 59088 | 190668 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 151 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6013191.282000001 | 2111332.8508900004 | 37.7780599035854 | -122.397906316128 | (37.7780599035854, -122.397906316128) | |||
| 74343 | 74343 | 190667 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Freelon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6013174.92981 | 2111315.77599 | 37.7780121091073 | -122.39796168649099 | (37.7780121091073, -122.397961686491) | |||
| 117665 | 117665 | 190670 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 149 Freelon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6013247.06653 | 2111383.52028 | 37.778202136764605 | -122.39771689102 | (37.7782021367646, -122.39771689102) | |||
| 130323 | 130323 | 228477 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 432 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6003665.88299 | 2100131.59167 | 37.74676884190679 | -122.43005882127599 | (37.7467688419068, -122.430058821276) | |||
| 135498 | 135498 | 228476 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 427 29th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003772.71447 | 2098922.9201 | 37.7434561594686 | -122.42960322110599 | (37.7434561594686, -122.429603221106) | |||
| 146693 | 146693 | 190665 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 153 Freelon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6013152.15167 | 2111293.3784 | 37.777949341814 | -122.398038913074 | (37.777949341814, -122.398038913074) | |||
| 156471 | 156471 | 190673 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 149 Freelon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 6013287.80421 | 2111419.1855200003 | 37.7783023338298 | -122.397578465593 | (37.7783023338298, -122.397578465593) | |||
| 187193 | 187193 | 190669 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 149 Freelon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6013237.11478 | 2111370.50988 | 37.7781658589921 | -122.39775040518101 | (37.7781658589921, -122.397750405181) | |||
| 188019 | 188019 | 190672 | Undocumented 2 | Hymenosporum flavum :: Sweet Shade 91 | 149 Freelon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6013276.0134 | 2111408.93876 | 37.778273542017395 | -122.39761853578001 | (37.7782735420174, -122.39761853578) |
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");