Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, DBH, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
656 | 656 | 23200 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 520X Van Ness Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 9 | 6006725.22564 | 2112390.29825 | 37.7806011691535 | -122.420349841196 | (37.7806011691535, -122.420349841196) | |||
10119 | 10119 | 173856 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 118 Saint Mary's Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | Width 3ft | 6003956.18287 | 2095944.61673 | 37.735288805319904 | -122.42875656067 | (37.7352888053199, -122.42875656067) | ||||
18271 | 18271 | 28138 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 418 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 4X5 | 6006975.957669999 | 2097881.62293 | 37.7407778444163 | -122.41845336792801 | (37.7407778444163, -122.418453367928) | |||
85741 | 85741 | 114041 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 95 LINARES AVE | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 3x3 | 5994258.0 | 2102054.0 | 37.751509977458795 | -122.462729551044 | (37.7515099774588, -122.462729551044) | ||||
102986 | 102986 | 112188 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 301x CORBETT AVE | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | DPW 2 | 45 | 3x3 | 5999677.0 | 2105220.0 | 37.760513648972996 | -122.444217531177 | (37.760513648973, -122.444217531177) | |||
112606 | 112606 | 105901 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 11X ELLIOT ST | 2 | Unaccepted Street : Yard 14 | Tree 1 | DPW 2 | 30 | 6009059.0 | 2088845.0 | 37.716082244868005 | -122.410612975888 | (37.716082244868, -122.410612975888) | ||||
116419 | 116419 | 2615 | Landmark tree 9 | Eucalyptus globulus :: Blue Gum 103 | 1661X Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 42 | 10X10 | 6004876.92395 | 2115038.87855 | 37.787769186678204 | -122.42693268975599 | (37.7877691866782, -122.426932689756) |
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");