Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qSpecies, qAddress, qSiteInfo, XCoord, YCoord, Latitude, Longitude, Location
qLegalStatus ✖
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
85237 | 85237 | 113807 | Undocumented 2 | Pinus radiata :: Monterey Pine 3 | 70X MALTA DR | 1 | Back Yard : Cutout 16 | Tree 1 | Private 1 | 3x30 | 5999481.0 | 2096265.0 | 37.735914202367894 | -122.444251877835 | (37.7359142023679, -122.444251877835) | ||||
89418 | 89418 | 76344 | DPW Maintained 3 | Metrosideros excelsa :: New Zealand Xmas Tree 2 | 3899X Kirkham St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 05/14/1994 12:00:00 AM | 12 | 3x30 | 5982828.25460357 | 2104700.39822601 | 37.758111331314396 | -122.50245020588699 | (37.7581113313144, -122.502450205887) | |
90489 | 90489 | 113805 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 990X OSHAUGHNESSY BLVD | 2 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 3x30 | 6000025.0 | 2096199.0 | 37.735764003208 | -122.442366322687 | (37.735764003208, -122.442366322687) | ||||
104898 | 104898 | 110397 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 2200 BAY SHORE BLVD | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x30 | 6011234.0 | 2087411.0 | 37.7122664722191 | -122.40299429708999 | (37.7122664722191, -122.40299429709) | ||||
109652 | 109652 | 113804 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 990X OSHAUGHNESSY BLVD | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 3x30 | 6000025.0 | 2096199.0 | 37.735764003208 | -122.442366322687 | (37.735764003208, -122.442366322687) | ||||
128292 | 128292 | 110396 | Undocumented 2 | Pinus pinea :: Italian Stone Pine 143 | 1x ARLETA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x30 | 6011055.0 | 2087587.0 | 37.7127397354919 | -122.403625353192 | (37.7127397354919, -122.403625353192) | ||||
139657 | 139657 | 117644 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 1111X SANSOME ST | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 3x30 | 6011937.0 | 2119613.0 | 37.8007253016149 | -122.402827843034 | (37.8007253016149, -122.402827843034) | ||||
141063 | 141063 | 29135 | DPW Maintained 3 | Lophostemon confertus :: Brisbane Box 11 | 60 Leavenworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/19/2005 12:00:00 AM | 8 | 3x30 | 6008671.4052929 | 2112539.0130008 | 37.781118980071 | -122.413627576137 | (37.781118980071, -122.413627576137) |
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");