Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qAddress, SiteOrder, qSiteInfo, qCaretaker, DBH, PlotSize
Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2861 | 2861 | 1909 | DPW Maintained 3 | Eucalyptus robusta :: Swamp mahogany 122 | 47 Beideman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6001510.2227 | 2113085.0255 | 37.7822134660516 | -122.43844077549801 | (37.7822134660516, -122.438440775498) | |||
19375 | 19375 | 25239 | DPW Maintained 3 | Eucalyptus robusta :: Swamp mahogany 122 | 1199X Ocean Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 5996283.2054 | 2091824.5737 | 37.7235388978416 | -122.454987105753 | (37.7235388978416, -122.454987105753) | |||
185461 | 185461 | 75086 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 450 Stanyan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/01/1983 12:00:00 AM | 8 | 5x5 | 5996845.061000001 | 2110107.7895 | 37.773772292352604 | -122.45436492894 | (37.7737722923526, -122.45436492894) | |
34261 | 34261 | 80838 | Permitted Site 1 | Eucalyptus robusta :: Swamp mahogany 122 | 2210 45th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2008 12:00:00 AM | 3 | 3x3 | Permit Number 50737 | 5982367.3505 | 2100035.4874 | 37.74527570068779 | -122.50369871614299 | (37.7452757006878, -122.503698716143) | |
37587 | 37587 | 139675 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 2130 O'Farrell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000973.3282 | 2113158.8604 | 37.7823856440019 | -122.440303482082 | (37.7823856440019, -122.440303482082) | |||
152945 | 152945 | 139679 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 2200 O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6000698.183999999 | 2113151.9086 | 37.7823508867449 | -122.44125485846901 | (37.7823508867449, -122.441254858469) | |||
66326 | 66326 | 139680 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 2200 O'Farrell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6000664.8886 | 2113151.5427 | 37.7823479853916 | -122.44137001927601 | (37.7823479853916, -122.441370019276) | |||
42029 | 42029 | 140289 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 143 ASHBURY ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998736.4414 | 2110178.4157 | 37.7740744999849 | -122.447827456218 | (37.7740744999849, -122.447827456218) | |||
55344 | 55344 | 140633 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 498 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5996881.0877 | 2109845.2546 | 37.773053505754596 | -122.454221341129 | (37.7730535057546, -122.454221341129) | |||
134196 | 134196 | 140651 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 113 Shrader St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997307.4674 | 2109953.9095 | 37.7733762851731 | -122.452754291616 | (37.7733762851731, -122.452754291616) | |||
164519 | 164519 | 140652 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 115 Shrader St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5997309.3837 | 2109929.764 | 37.7733100976884 | -122.452745919872 | (37.7733100976884, -122.452745919872) | |||
27458 | 27458 | 140653 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 117 Shrader St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5997311.6833 | 2109908.6845 | 37.7732523506079 | -122.452736443592 | (37.7732523506079, -122.452736443592) | |||
60730 | 60730 | 140749 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 59 BEIDEMAN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 6001509.5459 | 2113123.2672 | 37.7823184295271 | -122.43844585764299 | (37.7823184295271, -122.438445857643) | |||
919 | 919 | 140949 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 2060 Ofarrell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6001488.0 | 2113369.0 | 37.7829919235948 | -122.438538008913 | (37.7829919235948, -122.438538008913) | |||
132185 | 132185 | 141148 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 1930 O'Farrell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6001986.0438 | 2113301.6154 | 37.7828352207239 | -122.43681016000299 | (37.7828352207239, -122.436810160003) | |||
137700 | 137700 | 141151 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 1950 O'Farrell St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 0ft | 6001871.3188 | 2113285.3712 | 37.782784097409994 | -122.437205896264 | (37.78278409741, -122.437205896264) | |||
148854 | 148854 | 141297 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 1835 ELLIS ST | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002096.3693 | 2112918.522 | 37.781789612857295 | -122.43640105361901 | (37.7817896128573, -122.436401053619) | |||
72908 | 72908 | 185244 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 2559 33rd Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5986116.5072 | 2097821.4777 | 37.739416345886795 | -122.490572078711 | (37.7394163458868, -122.490572078711) | |||
50113 | 50113 | 199340 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 1130 Connecticut St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 34 | Width 8ft | 6013385.1777099995 | 2101675.07072 | 37.751552571504995 | -122.396558390655 | (37.751552571505, -122.396558390655) | |||
61968 | 61968 | 244542 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 1520 Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 5999085.4254 | 2109079.6963 | 37.7710776370382 | -122.446541201155 | (37.7710776370382, -122.446541201155) | |||
65356 | 65356 | 244550 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 1520 Page St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 5999050.2365 | 2109073.1583 | 37.77105767533679 | -122.446662449781 | (37.7710576753368, -122.446662449781) | |||
29441 | 29441 | 245002 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 1424 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 5999732.5024 | 2109169.2235 | 37.7713603951949 | -122.44430938240299 | (37.7713603951949, -122.444309382403) | |||
57356 | 57356 | 245163 | Undocumented 2 | Eucalyptus robusta :: Swamp mahogany 122 | 1310 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6000215.6172 | 2109235.6996 | 37.77157047334 | -122.442643044641 | (37.77157047334, -122.442643044641) |
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");