Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qAddress, SiteOrder, qSiteInfo, DBH
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
27154 | 27154 | 192389 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 450 Amador St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 6018217.012999999 | 2099612.2395900004 | 37.746156176965606 | -122.37970582128901 | (37.7461561769656, -122.379705821289) | |||
36251 | 36251 | 128836 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2610 Clay St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6001965.16531 | 2116062.35333 | 37.790414314124796 | -122.43708011086399 | (37.7904143141248, -122.437080110864) | |||
47911 | 47911 | 225862 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 198 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 6006460.77519 | 2098675.0846599997 | 37.74292749660479 | -122.42029098054199 | (37.7429274966048, -122.420290980542) | |||
49098 | 49098 | 225864 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6006484.93585 | 2098722.65542 | 37.7430594766165 | -122.420210814975 | (37.7430594766165, -122.420210814975) | |||
52003 | 52003 | 128837 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2610 Clay St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6001930.71219 | 2116056.5883 | 37.790396526424104 | -122.43719890322399 | (37.7903965264241, -122.437198903224) | |||
57216 | 57216 | 225868 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 5ft | 6006540.56065 | 2098821.81069 | 37.743334868812205 | -122.42002551416799 | (37.7433348688122, -122.420025514168) | |||
62366 | 62366 | 128835 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2610 Clay St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6002002.11764 | 2116066.62683 | 37.7904281483977 | -122.436952564533 | (37.7904281483977, -122.436952564533) | |||
63611 | 63611 | 225863 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6006477.67033 | 2098701.98839 | 37.743002320208795 | -122.420234470738 | (37.7430023202088, -122.420234470738) | |||
65708 | 65708 | 128832 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2610 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6002198.1821 | 2116092.80029 | 37.7905111558262 | -122.436276069294 | (37.7905111558262, -122.436276069294) | |||
129233 | 129233 | 225865 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 6006497.19455 | 2098745.86937 | 37.7431239076329 | -122.420170074782 | (37.7431239076329, -122.420170074782) | |||
132320 | 132320 | 225867 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6006525.15417 | 2098793.36254 | 37.7432558885579 | -122.42007676744801 | (37.7432558885579, -122.420076767448) | |||
148323 | 148323 | 128833 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2610 Clay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6002164.86487 | 2116089.53084 | 37.7905002856984 | -122.436391110584 | (37.7905002856984, -122.436391110584) | |||
152294 | 152294 | 225856 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1242 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 6004441.23544 | 2101663.28988 | 37.75101841198661 | -122.42748682946699 | (37.7510184119866, -122.427486829467) | |||
155580 | 155580 | 225869 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | Width 5ft | 6006549.95034 | 2098834.86462 | 37.743371240990896 | -122.419993973142 | (37.7433712409909, -122.419993973142) | |||
155634 | 155634 | 128834 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2610 Clay St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6002036.91724 | 2116071.66485 | 37.7904439593598 | -122.436832521201 | (37.7904439593598, -122.436832521201) | |||
180843 | 180843 | 225819 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1266 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6011382.17033 | 2102444.14422 | 37.7535526025704 | -122.403539182014 | (37.7535526025704, -122.403539182014) | |||
185136 | 185136 | 225866 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 5ft | 6006516.03586 | 2098775.00428 | 37.7432049671495 | -122.42010699366199 | (37.7432049671495, -122.420106993662) | |||
186178 | 186178 | 128831 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2610 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6002271.43104 | 2116104.60084 | 37.7905477186542 | -122.436023477612 | (37.7905477186542, -122.436023477612) |
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");