Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qCaretaker
qLegalStatus ✖
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9834 | 9834 | 6787 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 1360 Fairfax Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/03/2017 06:55:00 AM | 3 | 3x3 | 6016787.1910829 | 2097353.9213772 | 37.739876324716896 | -122.384492742853 | (37.7398763247169, -122.384492742853) | ||
83040 | 83040 | 96012 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 999 California St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3x3 | Permit Number 767660 | 6009569.0 | 2116409.0 | 37.791795397820394 | -122.410795730189 | (37.7917953978204, -122.410795730189) | |
85638 | 85638 | 92584 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 445 Wawona St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2009 12:00:00 AM | 3x3 | Permit Number 52914 | 5991625.0 | 2097033.0 | 37.737571604455205 | -122.471468876287 | (37.7375716044552, -122.471468876287) | ||
99054 | 99054 | 88750 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 990 Polk St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/19/2008 12:00:00 AM | 3x3 | Permit Number 51679 | 6006960.9 | 2114284.0 | 37.785814090273796 | -122.41966893082501 | (37.7858140902738, -122.419668930825) | ||
111220 | 111220 | 94245 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 2125 BRYANT ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/29/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53614 | 6009652.0 | 2104721.0 | 37.7597075419954 | -122.40968320892 | (37.7597075419954, -122.40968320892) | |
116965 | 116965 | 18361 | DPW Maintained 3 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 530 Potrero Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/02/2015 11:39:00 AM | 3 | 3x3 | 6010330.807907499 | 2105828.5872592 | 37.762786742062204 | -122.407413622665 | (37.7627867420622, -122.407413622665) | ||
126063 | 126063 | 91095 | Permitted Site 1 | Magnolia grandiflora 'Samuel Sommer' :: Samuel Sommer Magnolia 90 | 3417X 18th St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/22/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51985 | 6006736.0 | 2105525.0 | 37.761751301646704 | -122.41982527826299 | (37.7617513016467, -122.419825278263) |
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");