Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
51445 | 51445 | 207262 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 510 Ramsell St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993010.6580300005 | 2090589.3329599998 | 37.7199589473287 | -122.466209899286 | (37.7199589473287, -122.466209899286) | |||
131761 | 131761 | 207244 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 246 Monticello St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5991705.04474 | 2090167.4544799998 | 37.7187251566245 | -122.47069219949199 | (37.7187251566245, -122.470692199492) | |||
156004 | 156004 | 207247 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 495 Ralston St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992207.674790001 | 2091176.35111 | 37.721524393612 | -122.46902820910299 | (37.721524393612, -122.469028209103) | |||
156794 | 156794 | 207268 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 321 Shields St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5993118.56975 | 2089825.8623400002 | 37.7178688671261 | -122.46578144695299 | (37.7178688671261, -122.465781446953) | |||
158423 | 158423 | 207267 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 800 Shields St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5991908.73686 | 2089873.18907 | 37.71792895264 | -122.469966710089 | (37.71792895264, -122.469966710089) | |||
166192 | 166192 | 207245 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 495 Ralston St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992206.61176 | 2091125.8340200002 | 37.7213856246322 | -122.469028209083 | (37.7213856246322, -122.469028209083) | |||
187054 | 187054 | 207246 | Undocumented 2 | Leptospermum scoparium :: New Zealand Tea Tree 27 | 495 Ralston St | 2 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5992206.82998 | 2091154.32928 | 37.7214638782474 | -122.469029527495 | (37.7214638782474, -122.469029527495) |
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");