Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
6018 | 6018 | 19926 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 100 STAIRWAY37 | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 20ST | ||||||||
7267 | 7267 | 19835 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 100 STAIRWAY25 | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60X | ||||||||
8172 | 8172 | 19836 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 100 STAIRWAY25 | 20 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 60X | ||||||||
11287 | 11287 | 20003 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 100 STAIRWAY46 | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 2 | ||||||||
14534 | 14534 | 18564 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 1700X Quesada Ave | 19 | Median : Cutout 11 | Tree 1 | DPW 2 | 30 | 19 | 6014511.59225 | 2095170.6430400002 | 37.7337553901961 | -122.392208220649 | (37.7337553901961, -122.392208220649) | |||
15209 | 15209 | 19838 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 100 STAIRWAY25 | 22 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 60X | ||||||||
16686 | 16686 | 19817 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 100 STAIRWAY25 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 100ST | ||||||||
17045 | 17045 | 19792 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 100 STAIRWAY19 | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 20ST | ||||||||
50134 | 50134 | 191700 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 1700x Quesada Ave | 39 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6014384.30677 | 2095263.8272900002 | 37.7340041867507 | -122.39265480417801 | (37.7340041867507, -122.392654804178) | ||||
64747 | 64747 | 191695 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 950x Kansas St | 4 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 6011603.94241 | 2103847.92507 | 37.7574194607598 | -122.40287096412901 | (37.7574194607598, -122.402870964129) | ||||
65580 | 65580 | 191710 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 1427x Innes Ave | 28 | Median : Yard 3 | Tree 1 | DPW 2 | 3 | 6016141.2133599995 | 2096757.17707 | 37.7382020430791 | -122.386684681762 | (37.7382020430791, -122.386684681762) | ||||
67780 | 67780 | 191690 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 900x Carolina St | 22 | Median : Yard 3 | Tree 1 | DPW 2 | 2 | 6012468.62754 | 2103498.74867 | 37.756508943061206 | -122.39985600137399 | (37.7565089430612, -122.399856001374) | ||||
79512 | 79512 | 804 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 680X 39th Ave | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 6-HOA | 5983823.94935 | 2111143.69789 | 37.7758612538886 | -122.499482885033 | (37.7758612538886, -122.499482885033) | |||
94834 | 94834 | 99679 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 165 Grattan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 10 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.45052048585899 | (37.7638673579207, -122.450520485859) | ||
143567 | 143567 | 111509 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 800x BOSWORTH ST | 4 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 4 | 6001905.0 | 2095492.0 | 37.733929718905394 | -122.435815869962 | (37.7339297189054, -122.435815869962) | ||||
172289 | 172289 | 207711 | DPW Maintained 3 | Eriobotrya japonica :: Edible Loquat 190 | 200x Terrace Dr | 31 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 5993844.07189 | 2096487.62875 | 37.7362022754996 | -122.463756979508 | (37.7362022754996, -122.463756979508) |
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");