Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant ▼ | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
28512 | 28512 | 176338 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 5 | Width 0ft | 6011479.2515 | 2090641.1055 | 37.721149380822 | -122.402373605767 | (37.721149380822, -122.402373605767) | |||
36877 | 36877 | 138087 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1611 Octavia St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | Width 0ft | 6004894.5944 | 2114873.9606 | 37.7873173623789 | -122.426859803648 | (37.7873173623789, -122.426859803648) | |||
38393 | 38393 | 176339 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 26 | Width 0ft | 6011461.59774 | 2090655.36204 | 37.7211875408569 | -122.402435631998 | (37.7211875408569, -122.402435631998) | |||
41245 | 41245 | 138027 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1631 Octavia St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 39 | Width 0ft | 6004885.3328 | 2114935.3188 | 37.7874853129815 | -122.426896218405 | (37.7874853129815, -122.426896218405) | |||
44888 | 44888 | 176341 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 500x Mansell St | 17 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 0ft | 6010266.44711 | 2090286.24099 | 37.7201072185592 | -122.406540946309 | (37.7201072185592, -122.406540946309) | |||
47690 | 47690 | 176337 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 100x Mansell St | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 59 | Width 0ft | 6011478.9031 | 2090656.6645400003 | 37.72119208331829 | -122.40237590353901 | (37.7211920833183, -122.402375903539) | |||
70742 | 70742 | 138025 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1651 Octavia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 49 | Width 0ft | 6004878.9655 | 2114979.8902 | 37.7876073348692 | -122.42692142358601 | (37.7876073348692, -122.426921423586) | |||
76683 | 76683 | 185931 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2000 Sunset Blvd | 74 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5985001.315 | 2101504.3546 | 37.749463324703996 | -122.494699314147 | (37.749463324704, -122.494699314147) | |||
77244 | 77244 | 185929 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2000 Sunset Blvd | 72 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 99 | Width 0ft | 5985012.7201 | 2101493.4926 | 37.7494341681805 | -122.494659074897 | (37.7494341681805, -122.494659074897) | |||
89069 | 89069 | 138024 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1661 Octavia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 48 | Width 0ft | 6004873.7558 | 2115028.5137 | 37.7877405482561 | -122.42694291248002 | (37.7877405482561, -122.42694291248) | |||
153710 | 153710 | 138026 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1641 Octavia St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 57 | Width 0ft | 6004881.8597 | 2114953.8419999997 | 37.787535976676395 | -122.426909554358 | (37.7875359766764, -122.426909554358) | |||
164095 | 164095 | 249920 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 358 Greenwich St | 5 | Back Yard : Yard 13 | Tree 1 | Private 1 | 35 | Width 0ft | 6011181.16541 | 2120413.994 | 37.8028824034529 | -122.405499802075 | (37.8028824034529, -122.405499802075) | |||
174806 | 174806 | 185917 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 2000 Sunset Blvd | 60 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 0ft | 5985004.5736 | 2101420.7172 | 37.749233870008794 | -122.494681880668 | (37.7492338700088, -122.494681880668) | |||
175511 | 175511 | 208978 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 700 Junipero Serra Blvd | 109 | : 4 | Tree 1 | Private 1 | 14 | Width 0ft | 5991241.872330001 | 2091923.37185 | 37.723519677182495 | -122.47242112456001 | (37.7235196771825, -122.47242112456) | |||
176724 | 176724 | 138028 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1621 Octavia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 49 | Width 0ft | 6004887.6482 | 2114917.9533 | 37.7874377625804 | -122.426886970359 | (37.7874377625804, -122.426886970359) | |||
177301 | 177301 | 245010 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1480 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 5999484.2143 | 2109133.9912 | 37.7712494874058 | -122.44516568603999 | (37.7712494874058, -122.44516568604) | |||
178271 | 178271 | 176340 | DPW Maintained 3 | Eucalyptus globulus :: Blue Gum 103 | 200x Mansell St | 15 | Median : Cutout 11 | Tree 1 | DPW 2 | 8 | Width 0ft | 6011135.84107 | 2090535.2556900003 | 37.720839562571996 | -122.403553239308 | (37.720839562572, -122.403553239308) | |||
183205 | 183205 | 245009 | Undocumented 2 | Eucalyptus globulus :: Blue Gum 103 | 1466 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 5999558.6674 | 2109145.6245 | 37.7712856788974 | -122.44490898697701 | (37.7712856788974, -122.444908986977) |
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");