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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
120553 | 120553 | 22818 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 60 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 06/12/1997 12:00:00 AM | 3 | 3X3 | 5998904.0126134 | 2099759.7693507997 | 37.745477066338 | -122.446498092976 | (37.745477066338, -122.446498092976) | ||
84527 | 84527 | 22821 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 64 Turquoise Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 01/01/2008 12:00:00 AM | 3 | 3x3 | 5998921.4611914 | 2099744.1843889 | 37.7454352704129 | -122.446436637784 | (37.7454352704129, -122.446436637784) | ||
97527 | 97527 | 16188 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 460X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999032.780474599 | 2094728.5162104 | 37.731669798591 | -122.445691084837 | (37.731669798591, -122.445691084837) | |||
111934 | 111934 | 16186 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 460X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999032.780474599 | 2094728.5162104 | 37.731669798591 | -122.445691084837 | (37.731669798591, -122.445691084837) | |||
88696 | 88696 | 16157 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 400X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | |||
109184 | 109184 | 16158 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 400X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/06/1998 12:00:00 AM | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | ||
126834 | 126834 | 16155 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 400X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | |||
139515 | 139515 | 16160 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 400X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 02/18/1999 12:00:00 AM | 3 | 5 | 5999414.3973652 | 2094721.8518035999 | 37.731673280479 | -122.44437128480699 | (37.731673280479, -122.444371284807) | ||
91678 | 91678 | 16109 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 300X Monterey Blvd | 7 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 6000087.992657701 | 2094703.0882103 | 37.731660169421204 | -122.44204119171499 | (37.7316601694212, -122.442041191715) | |||
145632 | 145632 | 16107 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 300X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 6000087.992657701 | 2094703.0882103 | 37.731660169421204 | -122.44204119171499 | (37.7316601694212, -122.442041191715) | |||
78844 | 78844 | 24312 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 258X Monterey Blvd | 6 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 6000364.9354737 | 2094709.7194476002 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | ||||
98506 | 98506 | 16077 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 258X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 6000364.9354737 | 2094709.7194476002 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | |||
108818 | 108818 | 16074 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 258X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 6000364.9354737 | 2094709.7194476002 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | |||
111702 | 111702 | 16076 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 258X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 6000364.9354737 | 2094709.7194476002 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | |||
114201 | 114201 | 16075 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 258X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 6000364.9354737 | 2094709.7194476002 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | |||
127845 | 127845 | 16073 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 258X Monterey Blvd | 1 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 6000364.9354737 | 2094709.7194476002 | 37.7316941555853 | -122.441084223383 | (37.7316941555853, -122.441084223383) | |||
85784 | 85784 | 16046 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 200X Monterey Blvd | 4 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | 5 | 6000746.7708385 | 2094693.2718477002 | 37.731670735926 | -122.43976296625401 | (37.731670735926, -122.439762966254) | |||
82169 | 82169 | 103330 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1600X McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001400.4 | 2111522.1 | 37.7779158216762 | -122.438708684362 | (37.7779158216762, -122.438708684362) | ||||
141020 | 141020 | 103331 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 1600X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001400.4 | 2111522.1 | 37.7779158216762 | -122.438708684362 | (37.7779158216762, -122.438708684362) | ||||
91038 | 91038 | 16011 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 100X Monterey Blvd | 5 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 4 | 6001411.931226401 | 2094682.0759854 | 37.7316778334432 | -122.437462576871 | (37.7316778334432, -122.437462576871) | |||
141148 | 141148 | 16008 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 100X Monterey Blvd | 2 | Median : Cutout 11 | Tree 1 | DPW 2 | 04/06/1998 12:00:00 AM | 12 | 8 | 6001411.931226401 | 2094682.0759854 | 37.7316778334432 | -122.437462576871 | (37.7316778334432, -122.437462576871) | ||
139919 | 139919 | 103333 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 243 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001783.9 | 2108958.2 | 37.7708978028329 | -122.43719840332399 | (37.7708978028329, -122.437198403324) | ||||
102585 | 102585 | 103332 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 245 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001802.8 | 2109052.7 | 37.7711583507176 | -122.43713979494301 | (37.7711583507176, -122.437139794943) | ||||
23233 | 23233 | 5150 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 243 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2016 12:00:00 AM | 2 | 3x3 | 6001815.3824 | 2108971.2006 | 37.7709352888143 | -122.437090436044 | (37.7709352888143, -122.437090436044) | ||
81486 | 81486 | 103328 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 242 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 4 | 3x3 | 6001866.0 | 2109053.0 | 37.7711627667236 | -122.436921205648 | (37.7711627667236, -122.436921205648) | |||
143218 | 143218 | 103327 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 234 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001874.0 | 2108997.0 | 37.771009459311706 | -122.43688952378 | (37.7710094593117, -122.43688952378) | ||||
18809 | 18809 | 5147 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 228 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/21/2016 12:00:00 AM | 3 | 3x3 | 6001883.9625 | 2108955.9605 | 37.7708973412472 | -122.436852124872 | (37.7708973412472, -122.436852124872) | ||
120532 | 120532 | 103325 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 200 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001895.0 | 2108750.0 | 37.7703324520775 | -122.436799199856 | (37.7703324520775, -122.436799199856) | ||||
100542 | 100542 | 103326 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 224 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3x3 | 6001907.0 | 2108933.4 | 37.7708367050105 | -122.43677082248301 | (37.7708367050105, -122.436770822483) | ||||
112123 | 112123 | 16004 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 10X Monterey Blvd | 3 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | 8 | 6002126.588544 | 2094889.952748 | 37.732289219947 | -122.435006728573 | (37.732289219947, -122.435006728573) | |||
83307 | 83307 | 24349 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 85 Duboce Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/24/2003 12:00:00 AM | 3 | 2x2 | 6006210.36104 | 2108383.4741700003 | 37.769570370002604 | -122.421846308181 | (37.7695703700026, -122.421846308181) | ||
114263 | 114263 | 18659 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 7 Richards Ct | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016312.43294 | 2095882.6817 | 37.7358103329414 | -122.386031740711 | (37.7358103329414, -122.386031740711) | |||
92010 | 92010 | 18658 | DPW Maintained 3 | Pyrus calleryana 'Bradford' :: Ornamental Pear: Bradford 96 | 7 Richards Ct | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016334.44824 | 2095879.1633400002 | 37.7358018906208 | -122.38595537929599 | (37.7358018906208, -122.385955379296) |
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");