Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, PlantDate, PlotSize, PermitNotes
Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9626 | 9626 | 173611 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 3779 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6005304.0 | 2101328.0 | 37.7501465436699 | -122.424479453971 | (37.7501465436699, -122.424479453971) | |||
9842 | 9842 | 12410 | DPW Maintained 3 | Prunus serrulata :: Ornamental Cherry 35 | 1610X Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/13/1989 12:00:00 AM | 7 | 4X4 | 6004460.5933 | 2114341.7023 | 37.78583136591 | -122.42832340690398 | (37.78583136591, -122.428323406904) | ||
25052 | 25052 | 196384 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 99 Stillman St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 0ft | 6013750.52811 | 2112736.60264 | 37.781945415491705 | -122.396070069587 | (37.7819454154917, -122.396070069587) | |||
27000 | 27000 | 214389 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 265 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992333.20147 | 2097526.08875 | 37.7389664461405 | -122.469056185189 | (37.7389664461405, -122.469056185189) | |||
29045 | 29045 | 78786 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1356 Grove St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/27/2002 12:00:00 AM | 7 | 6001332.0848 | 2110785.1298 | 37.7758884007732 | -122.438892183533 | (37.7758884007732, -122.438892183533) | ||
37217 | 37217 | 244897 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 39 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000347.0687 | 2109078.5751 | 37.7711465414406 | -122.442177066871 | (37.7711465414406, -122.442177066871) | |||
37603 | 37603 | 196415 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 74 Langton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6010031.16155 | 2110864.86545 | 37.776598425219206 | -122.408805329496 | (37.7765984252192, -122.408805329496) | |||
41433 | 41433 | 139465 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 855 CENTRAL AVE | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 7 | Width 0ft | 5999527.6632 | 2111481.3292 | 37.77769715931579 | -122.445184184965 | (37.7776971593158, -122.445184184965) | |||
41743 | 41743 | 99624 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1941 Grove St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2012 12:00:00 AM | 7 | 3x3 | Permit Number 768786 | 5998532.9 | 2110322.2 | 37.7744576589045 | -122.448541895436 | (37.7744576589045, -122.448541895436) | |
44073 | 44073 | 237980 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 163 Delmar St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999394.39801 | 2107237.60683 | 37.7660373671625 | -122.445339989042 | (37.7660373671625, -122.445339989042) | |||
47331 | 47331 | 47760 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2586 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2002 12:00:00 AM | 7 | Permit Number 45539 | 5989891.5254 | 2097770.0852 | 37.7394950154316 | -122.47751611296002 | (37.7394950154316, -122.47751611296) | |
49485 | 49485 | 178954 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1423 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007391.99195 | 2091825.5129900002 | 37.7241724986518 | -122.41658597517599 | (37.7241724986518, -122.416585975176) | |||
53846 | 53846 | 237983 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 122 Milton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6003747.81471 | 2095090.5430400001 | 37.7329319169677 | -122.429416079391 | (37.7329319169677, -122.429416079391) | |||
55073 | 55073 | 214457 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 87 Joost Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6001468.0488 | 2094911.62577 | 37.732311314613106 | -122.43728499800699 | (37.7323113146131, -122.437284998007) | |||
59484 | 59484 | 244989 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 217 Lily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6005482.6137 | 2110109.6215 | 37.7742688867804 | -122.42448636075899 | (37.7742688867804, -122.424486360759) | |||
61486 | 61486 | 34637 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1466 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/1997 12:00:00 AM | 7 | Permit Number 38317 | 5988079.0097 | 2105334.7239 | 37.7601601497095 | -122.484337584053 | (37.7601601497095, -122.484337584053) | ||
64344 | 64344 | 142257 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 541 LINDEN ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6004803.1693 | 2110709.0411 | 37.7758763538472 | -122.42687938241899 | (37.7758763538472, -122.426879382419) | |||
68675 | 68675 | 72444 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1733 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/22/1996 12:00:00 AM | 7 | 5999558.0145 | 2110143.3213 | 37.7740250637938 | -122.444982979337 | (37.7740250637938, -122.444982979337) | ||
68693 | 68693 | 118431 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 5400 Anza St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5981816.64658 | 2111695.18358 | 37.7772574943259 | -122.506467446284 | (37.7772574943259, -122.506467446284) | |||
71730 | 71730 | 31304 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 535 Birch St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 7 | Permit Number 34945 | 6005195.9419 | 2111461.818 | 37.7779654957454 | -122.425574267643 | (37.7779654957454, -122.425574267643) | |
74939 | 74939 | 135892 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 323 Marina Blvd | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6001823.0897 | 2121828.5954400003 | 37.8062388262166 | -122.437984887306 | (37.8062388262166, -122.437984887306) | |||
90524 | 90524 | 21708 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1710X Webster St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | 7 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | ||
110946 | 110946 | 62926 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 700 Moultrie St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/05/1986 12:00:00 AM | 7 | 3x3 | Permit Number 23306 | 6007604.52300155 | 2096130.96246459 | 37.7360062816195 | -122.41615606417601 | (37.7360062816195, -122.416156064176) |
123299 | 123299 | 143089 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 616 Greenwich St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6009932.6738 | 2120241.3728 | 37.8023385404989 | -122.409808052185 | (37.8023385404989, -122.409808052185) | |||
130843 | 130843 | 142281 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 638 CENTRAL AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999674.3585 | 2110736.0947 | 37.7756593080095 | -122.444623140793 | (37.7756593080095, -122.444623140793) | |||
133797 | 133797 | 214470 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 273 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6000290.09007 | 2094924.9736400002 | 37.7322809301091 | -122.441358417874 | (37.7322809301091, -122.441358417874) | |||
133911 | 133911 | 60295 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1469 Van Dyke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/27/1982 12:00:00 AM | 7 | 3x3 | Permit Number 19860 | 6015087.9595 | 2092963.5731 | 37.727727206447604 | -122.390061402044 | (37.7277272064476, -122.390061402044) | |
135584 | 135584 | 183494 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2471 22nd Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5989504.9089 | 2098548.5569 | 37.741610054481605 | -122.47890977280301 | (37.7416100544816, -122.478909772803) | |||
146715 | 146715 | 244518 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 531 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003993.7068 | 2109716.5376 | 37.77310538093779 | -122.42960871992202 | (37.7731053809378, -122.429608719922) | |||
146957 | 146957 | 135913 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 414 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | 6011476.8778099995 | 2119044.52353 | 37.7991387011458 | -122.404380029217 | (37.7991387011458, -122.404380029217) | ||||
149041 | 149041 | 46629 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 1490 Newcomb Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/2002 12:00:00 AM | 7 | Permit Number 44750 | 6015847.6531 | 2095265.1212 | 37.734088902667104 | -122.38759560956001 | (37.7340889026671, -122.38759560956) | |
154517 | 154517 | 245006 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1201 Page St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000755.8359 | 2109268.0945 | 37.771690201724205 | -122.440776726653 | (37.7716902017242, -122.440776726653) | |||
154550 | 154550 | 137933 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 29 ORBEN PL | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003140.6181 | 2115311.4461 | 37.7884192581755 | -122.432959455149 | (37.7884192581755, -122.432959455149) | |||
155512 | 155512 | 196383 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 172 Clara St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 2ft | 6012113.23171 | 2112074.9324 | 37.780037390439794 | -122.40168787361799 | (37.7800373904398, -122.401687873618) | |||
159144 | 159144 | 46854 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 134 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/25/2002 12:00:00 AM | 7 | Permit Number 44923 | 6003136.568519999 | 2092772.62748 | 37.7265328179246 | -122.431363909331 | (37.7265328179246, -122.431363909331) | |
159197 | 159197 | 44057 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 708 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/19/2000 12:00:00 AM | 7 | Permit Number 43584 | 6007279.94096 | 2121616.88851 | 37.8059663388498 | -122.419085450154 | (37.8059663388498, -122.419085450154) | ||
166127 | 166127 | 185265 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 2616 34th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5985852.1135 | 2097401.8704 | 37.7382487690483 | -122.491455345913 | (37.7382487690483, -122.491455345913) | |||
170457 | 170457 | 238023 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1430 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999614.1824900005 | 2107598.7683900003 | 37.7670415699392 | -122.444605761842 | (37.7670415699392, -122.444605761842) | |||
172535 | 172535 | 47757 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 2517 21st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/04/2002 12:00:00 AM | 7 | Permit Number 45537 | 5989831.6247 | 2098216.4636 | 37.7407171789575 | -122.477755842346 | (37.7407171789575, -122.477755842346) | |
176610 | 176610 | 135908 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 405 Vallejo St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 7ft | 6011535.18315 | 2119025.39151 | 37.7990894272815 | -122.40417692455 | (37.7990894272815, -122.40417692455) | |||
179071 | 179071 | 67710 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 99 Stillman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/19/1992 12:00:00 AM | 7 | Permit Number 31321 | 6013724.697430001 | 2112718.68187 | 37.7818947719595 | -122.396158176154 | (37.7818947719595, -122.396158176154) | |
181219 | 181219 | 237985 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 124 Marsily St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004244.2289 | 2095153.5322200002 | 37.7331329640029 | -122.427704333181 | (37.7331329640029, -122.427704333181) | |||
184613 | 184613 | 178887 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 451 Athens St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6003747.16271 | 2090614.46015 | 37.720641554351296 | -122.429099297695 | (37.7206415543513, -122.429099297695) | |||
185705 | 185705 | 178890 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 482 Edinburgh St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6002959.70968 | 2090965.8257900001 | 37.721561719087795 | -122.431846349732 | (37.7215617190878, -122.431846349732) | |||
187911 | 187911 | 31303 | Permitted Site 1 | Prunus serrulata :: Ornamental Cherry 35 | 535 Birch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/12/1995 12:00:00 AM | 7 | Permit Number 34945 | 6005167.7319 | 2111457.2123 | 37.777951255610795 | -122.425671528209 | (37.7779512556108, -122.425671528209) |
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");