Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7342 | 7342 | 35697 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/10/1998 12:00:00 AM | Permit Number 38993 | |||||||||
| 14190 | 14190 | 15118 | DPW Maintained 3 | Liriodendron tulipifera :: Tulip Tree 85 | 201 Mission St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6014060.69419 | 2116194.6265 | 37.7914576032294 | -122.395239337045 | (37.7914576032294, -122.395239337045) | |||
| 19672 | 19672 | 96325 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 1300X Sansome St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/06/2011 12:00:00 AM | 5 | 4x4 | Permit Number 768012 | 6011919.0 | 2120150.9 | 37.8022012393453 | -122.40292798450399 | (37.8022012393453, -122.402927984504) | |
| 25127 | 25127 | 200366 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1300 Phelps St | 8 | : 4 | Tree 1 | Private 1 | 12 | Width 5ft | 6014047.106269999 | 2096372.4575200002 | 37.7370295240776 | -122.393898196954 | (37.7370295240776, -122.393898196954) | |||
| 28250 | 28250 | 129809 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 901 Sacramento St | 8 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 12 | Width 3ft | 6010417.7029 | 2116870.15869 | 37.7931091785103 | -122.40789173971399 | (37.7931091785103, -122.407891739714) | |||
| 34108 | 34108 | 129780 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 900 Front St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012726.999559999 | 2119408.50299 | 37.800207880833895 | -122.400079730213 | (37.8002078808339, -122.400079730213) | |||
| 76914 | 76914 | 129776 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 80 Vallejo St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 3ft | 6012790.20467 | 2119250.54506 | 37.7997776901326 | -122.39984991653601 | (37.7997776901326, -122.399849916536) | |||
| 83164 | 83164 | 17638 | Permitted Site 1 | Liriodendron tulipifera :: Tulip Tree 85 | 420X Phelps St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Purchasing Dept 15 | 12 | 3X3 | 6015607.4628299 | 2098472.4768112 | 37.7428823403387 | -122.38864984673799 | (37.7428823403387, -122.388649846738) | |||
| 100107 | 100107 | 100701 | Significant Tree 6 | Liriodendron tulipifera :: Tulip Tree 85 | 200X 01st St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 09/05/2012 12:00:00 AM | Permit Number 768932 | 6013804.4 | 2114954.0 | 37.7880368749487 | -122.396039137137 | (37.7880368749487, -122.396039137137) | |||
| 124448 | 124448 | 108656 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1200x SANSOME ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011928.0 | 2119969.0 | 37.8017022887014 | -122.402884039163 | (37.8017022887014, -122.402884039163) | ||||
| 131138 | 131138 | 129792 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 1160 Sansome St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6011937.51445 | 2120075.46294 | 37.8019951413282 | -122.402858606545 | (37.8019951413282, -122.402858606545) | |||
| 149570 | 149570 | 129755 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 2407 Clay St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6003208.43493 | 2116180.994 | 37.7908106615232 | -122.432786962347 | (37.7908106615232, -122.432786962347) | |||
| 166431 | 166431 | 200336 | Undocumented 2 | Liriodendron tulipifera :: Tulip Tree 85 | 750 Phelps St | 8 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6015493.51667 | 2098314.62088 | 37.7424425848476 | -122.38903282511002 | (37.7424425848476, -122.38903282511) |
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");