Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
70188 | 70188 | 194167 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1300x De Haro St | 14 | Median : Yard 3 | Tree 1 | DPW 2 | 1 | 6012274.0442699995 | 2102163.00717 | 37.7528304388731 | -122.40043512247802 | (37.7528304388731, -122.400435122478) | ||||
115432 | 115432 | 210682 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 100x Idora Ave | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 15 | Width 9ft | 5995339.29404 | 2099412.4410200003 | 37.7443191354124 | -122.4587991034 | (37.7443191354124, -122.4587991034) | |||
131484 | 131484 | 132028 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 33x Battery St | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6012842.61776 | 2116100.99756 | 37.7911327033699 | -122.39944731163901 | (37.7911327033699, -122.399447311639) | ||||
136110 | 136110 | 178033 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1378x Geneva Ave | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6002471.97564 | 2087830.38013 | 37.712924818104 | -122.433308378475 | (37.712924818104, -122.433308378475) | ||||
148081 | 148081 | 178035 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1378x Geneva Ave | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 6 | 6002505.07902 | 2087811.4607 | 37.7128747474362 | -122.433192611453 | (37.7128747474362, -122.433192611453) | ||||
155895 | 155895 | 132029 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 33x Battery St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 20 | 6012837.6749599995 | 2116094.57512 | 37.79111479336421 | -122.399463962592 | (37.7911147933642, -122.399463962592) | ||||
188176 | 188176 | 178034 | DPW Maintained 3 | Olea europaea :: Olive Tree 41 | 1378x Geneva Ave | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 7 | 6002495.00651 | 2087816.3446 | 37.7128875861582 | -122.433227774048 | (37.7128875861582, -122.433227774048) |
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");