Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, PlotSize
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25630 | 25630 | 194576 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 572 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6013508.15849 | 2104424.13067 | 37.7591077391483 | -122.396325765734 | (37.7591077391483, -122.396325765734) | |||
46330 | 46330 | 178393 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 73 Capistrano Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6001400.33163 | 2093764.0907400001 | 37.729156597198795 | -122.437436967259 | (37.7291565971988, -122.437436967259) | ||||
69150 | 69150 | 194582 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 618 Missouri St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | Width 4ft | 6013519.11255 | 2104217.1828099997 | 37.7585401149596 | -122.39627337661001 | (37.7585401149596, -122.39627337661) | |||
93214 | 93214 | 132388 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1468 Greenwich St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6005798.70292 | 2119672.07683 | 37.800542860316 | -122.424073122581 | (37.800542860316, -122.424073122581) | |||
100796 | 100796 | 64213 | Permitted Site 1 | Pittosporum eugenioides :: Tarata 110 | 1625 Carroll Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/15/1988 12:00:00 AM | 5 | Permit Number 25004 | 6013920.481000001 | 2092092.5018 | 37.7252706002708 | -122.39403647132099 | (37.7252706002708, -122.394036471321) | ||
130991 | 130991 | 211451 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 151 Lippard Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001863.37782 | 2095280.7937599998 | 37.7333474307441 | -122.435944662819 | (37.7333474307441, -122.435944662819) | |||
135796 | 135796 | 233974 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2315 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002049.59534 | 2107034.31873 | 37.7656303987394 | -122.436141661111 | (37.7656303987394, -122.436141661111) | |||
166409 | 166409 | 187083 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 2600 Sunset Blvd | 19 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5985170.5104 | 2097012.8962 | 37.7371408955553 | -122.49378330233499 | (37.7371408955553, -122.493783302335) | |||
177634 | 177634 | 132387 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 1468 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6005806.0966 | 2119662.42569 | 37.8005167781868 | -122.424046850703 | (37.8005167781868, -122.424046850703) | |||
179351 | 179351 | 211452 | Undocumented 2 | Pittosporum eugenioides :: Tarata 110 | 151 Lippard Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6001868.44075 | 2095314.06759 | 37.7334390806456 | -122.435929538915 | (37.7334390806456, -122.435929538915) |
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");