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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
183681 | 183681 | 250308 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 10 Redfield Aly | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 4 | Width 0ft | 6008483.77451 | 2119506.40025 | 37.8002391853351 | -122.41476992380801 | (37.8002391853351, -122.414769923808) | |||
115201 | 115201 | 121666 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 100 Montalvo Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x6 | 5993653.0 | 2099666.0 | 37.7449182738718 | -122.46464831295299 | (37.7449182738718, -122.464648312953) | ||||
38906 | 38906 | 237981 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 100 Rousseau St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6003493.73736 | 2095146.1048599998 | 37.7330700888164 | -122.43029845283002 | (37.7330700888164, -122.43029845283) | |||
165001 | 165001 | 139978 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1002 SCOTT ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6001945.5177 | 2111990.8232 | 37.7792338137079 | -122.436856496835 | (37.7792338137079, -122.436856496835) | |||
94813 | 94813 | 115487 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1004 SANCHEZ ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6003744.0 | 2102383.0 | 37.7529551066007 | -122.4299492716 | (37.7529551066007, -122.4299492716) | ||||
103592 | 103592 | 121759 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1019 Minnesota St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015338.0 | 2103772.0 | 37.7574187808175 | -122.389951694408 | (37.7574187808175, -122.389951694408) | ||||
54244 | 54244 | 196406 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1021 Minnesota St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 6015301.01099 | 2103753.62638 | 37.7573662793475 | -122.390078334671 | (37.7573662793475, -122.390078334671) | |||
54951 | 54951 | 178873 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1029 Russia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003894.97731 | 2089471.2893700001 | 37.7175110241788 | -122.428506907095 | (37.7175110241788, -122.428506907095) | |||
165537 | 165537 | 178872 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1029 Russia Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6003905.75349 | 2089465.8631799999 | 37.717496734867396 | -122.428469272232 | (37.7174967348674, -122.428469272232) | |||
56504 | 56504 | 214451 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 103 Dorantes Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993921.129 | 2099948.59538 | 37.7457096635647 | -122.463741686529 | (37.7457096635647, -122.463741686529) | |||
123029 | 123029 | 116779 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1031 BROADWAY | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2016 12:00:00 AM | 3 | 3x3 | 6008650.0 | 2118281.0 | 37.796883878440795 | -122.41410797545099 | (37.7968838784408, -122.414107975451) | ||
49913 | 49913 | 199985 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1032 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6018147.7753 | 2092169.4169 | 37.725715836336896 | -122.379428312297 | (37.7257158363369, -122.379428312297) | |||
74159 | 74159 | 135907 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1034 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6007940.29606 | 2119623.01107 | 37.80052881831 | -122.416658842755 | (37.80052881831, -122.416658842755) | |||
25034 | 25034 | 245135 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 108 Lyon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000350.1465 | 2109371.4561 | 37.7719508943795 | -122.442187448391 | (37.7719508943795, -122.442187448391) | |||
132838 | 132838 | 178906 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 109 Delta St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009976.781880001 | 2089389.92306 | 37.7176299046612 | -122.40747906690399 | (37.7176299046612, -122.407479066904) | |||
50138 | 50138 | 245099 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1116 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6001200.4602 | 2109374.4683 | 37.7720075888162 | -122.43924637279899 | (37.7720075888162, -122.439246372799) | |||
30204 | 30204 | 74333 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1118 Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2002 12:00:00 AM | 4 | 6015132.5367 | 2090213.511 | 37.720178552846 | -122.389715298726 | (37.720178552846, -122.389715298726) | ||
133064 | 133064 | 178900 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1128 Bowdoin St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 4ft | 6009581.67769 | 2090926.3916900002 | 37.721826605402 | -122.40895311598699 | (37.721826605402, -122.408953115987) | |||
75493 | 75493 | 237987 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 114 Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005526.563490001 | 2096388.0227 | 37.736595053504296 | -122.423358681381 | (37.7365950535043, -122.423358681381) | |||
132824 | 132824 | 237988 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 114 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005544.33972 | 2096386.4343299998 | 37.736591695453896 | -122.42329710838001 | (37.7365916954539, -122.42329710838) | |||
151841 | 151841 | 237989 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 114 Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005562.12851 | 2096385.4572 | 37.7365900164084 | -122.423235535394 | (37.7365900164084, -122.423235535394) | |||
177308 | 177308 | 237986 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 114 Park St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005505.73076 | 2096390.28542 | 37.7366000906246 | -122.42343086995899 | (37.7366000906246, -122.423430869959) | |||
63044 | 63044 | 196410 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1143 Howard St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 1 | Width 3ft | 6009614.35227 | 2111076.8827400003 | 37.7771572198736 | -122.410262172786 | (37.7771572198736, -122.410262172786) | |||
171106 | 171106 | 196409 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1143 Howard St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 9 | Width 3ft | 6009598.37036 | 2111065.11658 | 37.7771240168943 | -122.41031662852801 | (37.7771240168943, -122.410316628528) | |||
52586 | 52586 | 214452 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 115 Dorantes Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 5993881.37151 | 2099908.46331 | 37.7455971799806 | -122.463876248508 | (37.7455971799806, -122.463876248508) | |||
26914 | 26914 | 245213 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1155 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001001.539 | 2109303.6237 | 37.7718017456892 | -122.439929374343 | (37.7718017456892, -122.439929374343) | |||
176542 | 176542 | 135906 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1178 Greenwich St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 6007265.472680001 | 2119876.0558700003 | 37.8011856390751 | -122.41901196834 | (37.8011856390751, -122.41901196834) | |||
44877 | 44877 | 238005 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 118 Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6002126.98293 | 2096665.47856 | 37.7371644277915 | -122.435132311514 | (37.7371644277915, -122.435132311514) | |||
52829 | 52829 | 135900 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 12 Frank Norris St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006826.338330001 | 2115526.46894 | 37.7892180233479 | -122.420222690545 | (37.7892180233479, -122.420222690545) | |||
56608 | 56608 | 135898 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 12 Frank Norris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006854.3438099995 | 2115529.77615 | 37.7892286821026 | -122.420126029605 | (37.7892286821026, -122.420126029605) | |||
68414 | 68414 | 135899 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 12 Frank Norris St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006839.2179 | 2115528.7927900003 | 37.7892251297772 | -122.420178293706 | (37.7892251297772, -122.420178293706) | |||
53803 | 53803 | 250309 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 12 Redfield Aly | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 5 | Width 0ft | 6008474.46022 | 2119519.71704 | 37.800275226579 | -122.414803097987 | (37.800275226579, -122.414803097987) | |||
188866 | 188866 | 238006 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 120 Surrey St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6002226.03876 | 2096243.0070099998 | 37.7360100427193 | -122.434759628851 | (37.7360100427193, -122.434759628851) | |||
55286 | 55286 | 186809 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 118 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984810.136 | 2106955.7691 | 37.7644202036906 | -122.495762474243 | (37.7644202036906, -122.495762474243) | |||
68183 | 68183 | 186811 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 116 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984818.3107 | 2106920.8907 | 37.7643249161453 | -122.495731627712 | (37.7643249161453, -122.495731627712) | |||
75257 | 75257 | 186812 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 115 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 0ft | 5984824.8504 | 2106905.6313 | 37.764283401100705 | -122.495707883417 | (37.7642834011007, -122.495707883417) | |||
155382 | 155382 | 186813 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 114 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 0ft | 5984818.8556 | 2106897.4567 | 37.7642606048812 | -122.4957280144 | (37.7642606048812, -122.4957280144) | |||
173050 | 173050 | 186810 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1200 Sunset Blvd | 117 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 0ft | 5984819.4006 | 2106939.4198 | 37.7643758556702 | -122.49572922497102 | (37.7643758556702, -122.495729224971) | |||
3398 | 3398 | 245004 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1201 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000727.3724 | 2109263.3505 | 37.7716755548589 | -122.44087484303499 | (37.7716755548589, -122.440874843035) | |||
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) | |||
27002 | 27002 | 181705 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1206 22nd Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 0ft | 5989261.3602 | 2107107.536 | 37.7650965865931 | -122.48037820612 | (37.7650965865931, -122.48037820612) | |||
153200 | 153200 | 183419 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1206 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989183.8607 | 2096995.3104 | 37.73732659489539 | -122.479906199072 | (37.7373265948954, -122.479906199072) | |||
36230 | 36230 | 237982 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 121 Rousseau St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6003530.56657 | 2095073.53788 | 37.732872922347205 | -122.43016594940501 | (37.7328729223472, -122.430165949405) | |||
167724 | 167724 | 183420 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1210 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5989168.5817 | 2096994.6461 | 37.737323883205704 | -122.479958976444 | (37.7373238832057, -122.479958976444) | |||
48024 | 48024 | 183421 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1214 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5989156.9564 | 2096994.6461 | 37.7373232077722 | -122.47999917002701 | (37.7373232077722, -122.479999170027) | |||
54063 | 54063 | 237992 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1217 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001369.41512 | 2100163.22575 | 37.7467253722857 | -122.438002031971 | (37.7467253722857, -122.438002031971) | |||
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) | |||
25201 | 25201 | 183343 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1220 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983371.791 | 2106830.4783 | 37.7639918518381 | -122.500727966306 | (37.7639918518381, -122.500727966306) | |||
147043 | 147043 | 245121 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1226 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000650.5369 | 2109296.0266 | 37.7717608989394 | -122.441142965804 | (37.7717608989394, -122.441142965804) | |||
161319 | 161319 | 181747 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1231 29th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5987052.1054 | 2106842.9351 | 37.7642414343948 | -122.48799993277099 | (37.7642414343948, -122.487999932771) | |||
158425 | 158425 | 245019 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1231 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6000585.055 | 2109242.4773 | 37.7716101359109 | -122.441365628321 | (37.7716101359109, -122.441365628321) | |||
165895 | 165895 | 238010 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1231 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5997428.72694 | 2105545.13928 | 37.76127787699421 | -122.452016696208 | (37.7612778769942, -122.452016696208) | |||
172080 | 172080 | 214438 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1237 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993585.37565 | 2107057.08841 | 37.7652083981778 | -122.465418951844 | (37.7652083981778, -122.465418951844) | |||
30319 | 30319 | 237984 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 124 Marsily St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004243.12433 | 2095170.9025700002 | 37.733180596596206 | -122.42770938917101 | (37.7331805965962, -122.427709389171) | |||
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) | |||
181756 | 181756 | 245991 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1250 Waller St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5999788.9734 | 2108484.4317 | 37.769483351344 | -122.44406483418899 | (37.769483351344, -122.444064834189) | |||
70065 | 70065 | 245026 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1255 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6000539.9879 | 2109236.7846 | 37.771591937743295 | -122.441521109042 | (37.7715919377433, -122.441521109042) | |||
146378 | 146378 | 245027 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1255 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6000554.2196 | 2109238.2078 | 37.771596656285894 | -122.44147198305201 | (37.7715966562859, -122.441471983052) | |||
154712 | 154712 | 245028 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1267 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000516.7427 | 2109233.4639 | 37.7715814955912 | -122.441601276959 | (37.7715814955912, -122.441601276959) | |||
65928 | 65928 | 238009 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1269 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 5997476.9069 | 2105200.1672799997 | 37.7603334305535 | -122.45182517571199 | (37.7603334305535, -122.451825175712) | |||
136211 | 136211 | 183297 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1279 42nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5983033.5705 | 2106401.2294 | 37.762793394201005 | -122.501865989484 | (37.762793394201, -122.501865989484) | |||
157170 | 157170 | 178964 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 129 Girard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010537.280619999 | 2094115.27956 | 37.7306361096482 | -122.40587434723 | (37.7306361096482, -122.40587434723) | |||
24995 | 24995 | 181628 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1290 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988037.8386 | 2106538.091 | 37.7634618698416 | -122.48456824258498 | (37.7634618698416, -122.484568242585) | |||
148597 | 148597 | 181637 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1291 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5987994.5653 | 2106518.5606 | 37.763405724610294 | -122.484716476416 | (37.7634057246103, -122.484716476416) | |||
169267 | 169267 | 71822 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1300 26th Ave | 1 | Sidewalk: Property side : Cutout 5 | Tree 1 | Private 1 | 09/11/1982 12:00:00 AM | 3 | 5988042.7796 | 2106389.3653 | 37.763053797513706 | -122.48454024385201 | (37.7630537975137, -122.484540243852) | |||
70668 | 70668 | 178961 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1313 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007631.35752 | 2091897.4568599998 | 37.7243835002773 | -122.415763613493 | (37.7243835002773, -122.415763613493) | |||
164677 | 164677 | 237975 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 132 Rivoli St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5998055.3096900005 | 2105976.44068 | 37.7624979926238 | -122.44988070562401 | (37.7624979926238, -122.449880705624) | |||
104713 | 104713 | 121604 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 132 Surrey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/21/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779127 | 6002211.0 | 2096230.0 | 37.735973474651296 | -122.43481069394899 | (37.7359734746513, -122.434810693949) | |
73742 | 73742 | 178960 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1323 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6007600.028630001 | 2091890.26579 | 37.7243619938904 | -122.415871404438 | (37.7243619938904, -122.415871404438) | |||
169450 | 169450 | 238008 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1324 Willard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5996818.03207 | 2106833.22569 | 37.7647796346966 | -122.454221859976 | (37.7647796346966, -122.454221859976) | |||
152339 | 152339 | 214383 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1328 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 5993657.40703 | 2106457.98969 | 37.7635675841926 | -122.465126297154 | (37.7635675841926, -122.465126297154) | |||
48637 | 48637 | 140842 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 133 COMMONWEALTH AVE | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5996517.655 | 2113507.2067 | 37.783087415663 | -122.455743248453 | (37.783087415663, -122.455743248453) | |||
177949 | 177949 | 178959 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1333 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6007585.1415 | 2091886.2374099998 | 37.7243500958617 | -122.41592258217399 | (37.7243500958617, -122.415922582174) | |||
35596 | 35596 | 79919 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1343 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/03/2001 12:00:00 AM | 4 | 5988008.149 | 2106155.0675 | 37.762408463106496 | -122.484642830378 | (37.7624084631065, -122.484642830378) | ||
62539 | 62539 | 183257 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1343 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5981497.12 | 2105917.3408 | 37.7613744008584 | -122.50714403834999 | (37.7613744008584, -122.50714403835) | |||
187060 | 187060 | 178958 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1343 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6007547.64809 | 2091871.91329 | 37.7243086569025 | -122.41605117804 | (37.7243086569025, -122.41605117804) | |||
109105 | 109105 | 111662 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1343 SAN BRUNO AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011203.0 | 2102078.0 | 37.752537241421706 | -122.404133028772 | (37.7525372414217, -122.404133028772) | ||||
1472 | 1472 | 244877 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1349 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000105.0 | 2109153.0 | 37.7713370947812 | -122.443019734512 | (37.7713370947812, -122.443019734512) | |||
55206 | 55206 | 196381 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Clara St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012369.74132 | 2112319.30273 | 37.7807226855437 | -122.400817659004 | (37.7807226855437, -122.400817659004) | |||
78614 | 78614 | 196378 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Clara St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012410.6733800005 | 2112360.21924 | 37.78083731581879 | -122.400678929615 | (37.7808373158188, -122.400678929615) | |||
148188 | 148188 | 196382 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Clara St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012355.92865 | 2112312.32296 | 37.780702750265704 | -122.400864953468 | (37.7807027502657, -122.400864953468) | |||
163292 | 163292 | 196380 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Clara St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012381.80562 | 2112329.94836 | 37.780752588889705 | -122.40077667062599 | (37.7807525888897, -122.400776670626) | |||
184862 | 184862 | 196379 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Clara St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6012397.66121 | 2112347.77768 | 37.7808024284316 | -122.400723071038 | (37.7808024284316, -122.400723071038) | |||
74536 | 74536 | 196375 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Shipley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012200.498790001 | 2112422.5734200003 | 37.7809968015951 | -122.401410413864 | (37.7809968015951, -122.401410413864) | |||
159980 | 159980 | 196374 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Shipley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012209.830030001 | 2112433.27452 | 37.7810267049661 | -122.40137888454201 | (37.7810267049661, -122.401378884542) | |||
187913 | 187913 | 196376 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 135 Shipley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012181.9653199995 | 2112407.5214 | 37.780954438148704 | -122.40147347253999 | (37.7809544381487, -122.40147347254) | |||
33528 | 33528 | 182051 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1353 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988011.3956 | 2106063.6211 | 37.7621575653556 | -122.484624893587 | (37.7621575653556, -122.484624893587) | |||
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) | ||
32986 | 32986 | 245166 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1356 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000067.3756 | 2109215.4243 | 37.771506350919296 | -122.443154362685 | (37.7715063509193, -122.443154362685) | |||
148757 | 148757 | 196402 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 136 Langton St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6010324.85595 | 2110562.99084 | 37.775785993859294 | -122.407768059545 | (37.7757859938593, -122.407768059545) | |||
27817 | 27817 | 141769 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1360 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6003743.0385 | 2113357.1314 | 37.7830873528992 | -122.430735659623 | (37.7830873528992, -122.430735659623) | |||
32147 | 32147 | 182060 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1363 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988012.4779 | 2106014.3806 | 37.7620224274243 | -122.48461753831002 | (37.7620224274243, -122.48461753831) | |||
171467 | 171467 | 196377 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 137 Clara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6012419.03852 | 2112368.2176 | 37.7808597440141 | -122.40065055237899 | (37.7808597440141, -122.400650552379) | |||
187927 | 187927 | 246220 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1375 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5999535.8083 | 2107910.8735 | 37.767894059626606 | -122.444899283084 | (37.7678940596266, -122.444899283084) | |||
153885 | 153885 | 246222 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1381 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999537.3225 | 2107899.6688 | 37.7678633807549 | -122.444893240119 | (37.7678633807549, -122.444893240119) | |||
52490 | 52490 | 246224 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1382 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5999585.4723 | 2107870.9 | 37.767787136682294 | -122.444724628037 | (37.7677871366823, -122.444724628037) | |||
53825 | 53825 | 182065 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1383 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988018.43 | 2105853.6729 | 37.761581514586396 | -122.484585163984 | (37.7615815145864, -122.484585163984) | |||
151338 | 151338 | 182066 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1383 26th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988020.5944 | 2105839.0631 | 37.761541526107 | -122.48457660662399 | (37.761541526107, -122.484576606624) | |||
179234 | 179234 | 182064 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1383 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5988016.8067 | 2105885.598 | 37.7616690776633 | -122.48459312008 | (37.7616690776633, -122.48459312008) | |||
162426 | 162426 | 178957 | Undocumented 2 | Prunus serrulata :: Ornamental Cherry 35 | 1383 Bacon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 6007486.28826 | 2091855.13775 | 37.7242591447243 | -122.41626210321002 | (37.7242591447243, -122.41626210321) |
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");