Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
23421 | 23421 | 195972 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 18 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 4ft | 6015355.8319 | 2100319.8042599997 | 37.7479407691514 | -122.389648918288 | (37.7479407691514, -122.389648918288) | |||
42525 | 42525 | 195977 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 23 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 4ft | 6015256.877230001 | 2100313.90806 | 37.7479190918917 | -122.389990690329 | (37.7479190918917, -122.389990690329) | |||
49446 | 49446 | 195978 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 24 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 4ft | 6015236.23042 | 2100312.22008 | 37.747913311958605 | -122.390061968785 | (37.7479133119586, -122.390061968785) | |||
61234 | 61234 | 195975 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 21 | Back Yard : Yard 13 | Tree 1 | Private 1 | 9 | Width 4ft | 6015294.9834 | 2100316.47199 | 37.747928245201 | -122.389859098828 | (37.747928245201, -122.389859098828) | |||
147625 | 147625 | 195976 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 22 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | Width 4ft | 6015275.57642 | 2100315.1093900003 | 37.7479234275315 | -122.38992611271401 | (37.7479234275315, -122.389926112714) | |||
171288 | 171288 | 195971 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 17 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 4ft | 6015377.86647 | 2100320.4119700002 | 37.7479436595871 | -122.389572765484 | (37.7479436595871, -122.389572765484) | |||
171805 | 171805 | 195974 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 20 | Back Yard : Yard 13 | Tree 1 | Private 1 | 12 | Width 4ft | 6015315.44713 | 2100317.81293 | 37.7479330619596 | -122.389788429193 | (37.7479330619596, -122.389788429193) | |||
173877 | 173877 | 195973 | Undocumented 2 | Populus nigra 'Italica' :: Lombardy Poplar 86 | 200 Tulare St | 19 | Back Yard : Yard 13 | Tree 1 | Private 1 | 10 | Width 4ft | 6015335.01264 | 2100318.2949099997 | 37.747935470342895 | -122.38972080559601 | (37.7479354703429, -122.389720805596) |
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");