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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45140 | 45140 | 191227 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 201 Texas St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6013759.687999999 | 2106121.42545 | 37.763782132758706 | -122.39557476618201 | (37.7637821327587, -122.395574766182) | |||
| 45759 | 45759 | 206989 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1304 11th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5992723.56277 | 2106565.73006 | 37.7638095171187 | -122.468363979738 | (37.7638095171187, -122.468363979738) | |||
| 46405 | 46405 | 176898 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 167 Madison St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6005619.38027 | 2092788.13013 | 37.7267157831975 | -122.42278201629601 | (37.7267157831975, -122.422782016296) | |||
| 46936 | 46936 | 207047 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 654 Joost Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997739.24902 | 2095008.6617599998 | 37.7323650733825 | -122.450183245677 | (37.7323650733825, -122.450183245677) | |||
| 47223 | 47223 | 207040 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 115 Greenwood Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5996029.169869999 | 2093727.8612799998 | 37.728750294270604 | -122.456002788314 | (37.7287502942706, -122.456002788314) | |||
| 47371 | 47371 | 250553 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 130 El Camino Del Mar | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 5988175.48547 | 2115367.76095 | 37.787713689594796 | -122.484739928202 | (37.7877136895948, -122.484739928202) | |||
| 47498 | 47498 | 119083 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 863 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5981985.30992 | 2109867.54201 | 37.7722492542332 | -122.505748473333 | (37.7722492542332, -122.505748473333) | |||
| 47585 | 47585 | 176883 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 96 Alpha St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 6011048.63475 | 2088252.8219299999 | 37.7145675926038 | -122.40369417294501 | (37.7145675926038, -122.403694172945) | ||||
| 47841 | 47841 | 207013 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 178 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6000221.87075 | 2094376.8430299999 | 37.7307720044131 | -122.44155494671101 | (37.7307720044131, -122.441554946711) | |||
| 48057 | 48057 | 227570 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 287 Hartford St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002738.3349 | 2104276.75984 | 37.7580979146911 | -122.43356237671101 | (37.7580979146911, -122.433562376711) | |||
| 48201 | 48201 | 119241 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Sutro Heights Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5981435.03386 | 2111334.77238 | 37.776245435782 | -122.50776079209999 | (37.776245435782, -122.5077607921) | |||
| 48273 | 48273 | 227563 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4565 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6000806.394180001 | 2104634.53115 | 37.7589704630323 | -122.440269497142 | (37.7589704630323, -122.440269497142) | |||
| 48291 | 48291 | 227577 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 18 Dehon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 6003773.27056 | 2106456.0684 | 37.7641404406581 | -122.43013859382299 | (37.7641404406581, -122.430138593823) | |||
| 48320 | 48320 | 140696 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 162 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5997358.0622 | 2109907.9029 | 37.7732528619693 | -122.452575957146 | (37.7732528619693, -122.452575957146) | |||
| 48322 | 48322 | 251000 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 226 Point Lobos Ave | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5982074.747269999 | 2112660.45291 | 37.7799230326473 | -122.505646180935 | (37.7799230326473, -122.505646180935) | |||
| 48842 | 48842 | 207037 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2642 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5990833.84583 | 2097410.6031 | 37.738562605571104 | -122.47423178898501 | (37.7385626055711, -122.474231788985) | |||
| 49520 | 49520 | 129379 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1765 Jackson St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 6005697.11148 | 2117184.40611 | 37.793706610722 | -122.424247645012 | (37.793706610722, -122.424247645012) | |||
| 49688 | 49688 | 119982 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 250 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 5987459.3505 | 2114288.69945 | 37.7847091625278 | -122.487138302864 | (37.7847091625278, -122.487138302864) | |||
| 49701 | 49701 | 191228 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 901 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6015254.00871 | 2096807.9147599998 | 37.7382922001146 | -122.38975576401 | (37.7382922001146, -122.38975576401) | |||
| 49815 | 49815 | 191231 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1251 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014752.47592 | 2096139.2766099998 | 37.7364284325307 | -122.391443100815 | (37.7364284325307, -122.391443100815) | |||
| 50178 | 50178 | 206987 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1248 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 4ft | 5992091.43933 | 2106913.6178900003 | 37.7647281934706 | -122.47057562128799 | (37.7647281934706, -122.470575621288) | |||
| 50222 | 50222 | 113489 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 40 Arguello Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x10 | 5995526.6518 | 2115672.85646 | 37.7889767847188 | -122.45932857543 | (37.7889767847188, -122.45932857543) | |||
| 50519 | 50519 | 201808 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 247 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6020927.8472 | 2093035.08257 | 37.7282457215548 | -122.369877496672 | (37.7282457215548, -122.369877496672) | |||
| 50608 | 50608 | 227132 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 200 Portola Dr | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5999561.91472 | 2100471.96222 | 37.747470132350394 | -122.444274349099 | (37.7474701323504, -122.444274349099) | |||
| 50864 | 50864 | 191241 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1620 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014082.94285 | 2095307.88657 | 37.7341084226719 | -122.39369980292601 | (37.7341084226719, -122.393699802926) | |||
| 50907 | 50907 | 207039 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 270 Magellan Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 4ft | 5994635.03268 | 2100302.9111 | 37.7467236374953 | -122.461298810415 | (37.7467236374953, -122.461298810415) | |||
| 51471 | 51471 | 116543 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 6 | Median : Yard 3 | Tree 1 | DPW 2 | 5 | 3x3 | 6001574.8493099995 | 2088164.89401 | 37.713792383287796 | -122.43643306305 | (37.7137923832878, -122.43643306305) | |||
| 51569 | 51569 | 200835 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1101 16th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6013058.6169 | 2107038.7182 | 37.7662617940431 | -122.398063928568 | (37.7662617940431, -122.398063928568) | |||
| 51918 | 51918 | 176909 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1038 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007759.6380900005 | 2093605.48677 | 37.729080594582896 | -122.41544102937401 | (37.7290805945829, -122.415441029374) | |||
| 52110 | 52110 | 227151 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 48 Fair Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6006822.59734 | 2099508.6280900002 | 37.7452366012942 | -122.419099008325 | (37.7452366012942, -122.419099008325) | |||
| 52529 | 52529 | 176915 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 143 Somerset St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 5ft | 6009701.03874 | 2093769.75693 | 37.7296405745301 | -122.408741008189 | (37.7296405745301, -122.408741008189) | |||
| 52735 | 52735 | 176874 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6012843.86934 | 2086597.3532 | 37.7101221250005 | -122.397373047849 | (37.7101221250005, -122.397373047849) | |||
| 52837 | 52837 | 207008 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 451 Hearst Ave | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5998589.10288 | 2094366.3057 | 37.730649912467 | -122.447198902106 | (37.730649912467, -122.447198902106) | |||
| 52877 | 52877 | 118595 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Point Lobos Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5982415.15882 | 2112561.71552 | 37.7796719571588 | -122.504461248614 | (37.7796719571588, -122.504461248614) | |||
| 53235 | 53235 | 191238 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1600 Newhall St | 8 | : 4 | Tree 1 | Private 1 | 2 | Width 2ft | 6014118.19632 | 2095356.58877 | 37.734244107869294 | -122.393581327137 | (37.7342441078693, -122.393581327137) | |||
| 53500 | 53500 | 227128 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 248 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004363.9622599995 | 2096949.7405400001 | 37.7380717187222 | -122.427418297528 | (37.7380717187222, -122.427418297528) | |||
| 54346 | 54346 | 227582 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 288 States St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6000368.64642 | 2106819.9498400004 | 37.7649461504603 | -122.44194028911501 | (37.7649461504603, -122.441940289115) | |||
| 55458 | 55458 | 207027 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 43 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5997356.5626300005 | 2089224.02458 | 37.716459913666704 | -122.451089274853 | (37.7164599136667, -122.451089274853) | |||
| 55628 | 55628 | 227559 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 84 Seward St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 6000741.2761699995 | 2104538.3206 | 37.758702584674204 | -122.44048780488001 | (37.7587025846742, -122.44048780488) | |||
| 55786 | 55786 | 129372 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2133 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5999985.518069999 | 2120890.75849 | 37.80355910913379 | -122.444276660352 | (37.8035591091338, -122.444276660352) | |||
| 56110 | 56110 | 227546 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4281 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6001381.6755099995 | 2101715.76186 | 37.7509889636801 | -122.43807083010401 | (37.7509889636801, -122.438070830104) | |||
| 56440 | 56440 | 117883 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 734 43rd Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5982620.39521 | 2110769.29715 | 37.7747625699566 | -122.503618485147 | (37.7747625699566, -122.503618485147) | |||
| 56558 | 56558 | 207005 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 171 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992787.45104 | 2098017.3287299997 | 37.7403415032629 | -122.467521326669 | (37.7403415032629, -122.467521326669) | |||
| 56726 | 56726 | 227158 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3318 20th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008087.45284 | 2104471.6208599997 | 37.7589350063619 | -122.415076566546 | (37.7589350063619, -122.415076566546) | |||
| 56930 | 56930 | 207038 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 270 Magellan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 1 | Width 4ft | 5994641.46146 | 2100307.8933900003 | 37.7467376875983 | -122.461276941602 | (37.7467376875983, -122.461276941602) | |||
| 57061 | 57061 | 227584 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 660 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6002549.44678 | 2108867.98451 | 37.7706935809695 | -122.434543909369 | (37.7706935809695, -122.434543909369) | |||
| 57165 | 57165 | 176885 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 191 Rey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6008580.05361 | 2087004.5673599998 | 37.7110019335603 | -122.412138452652 | (37.7110019335603, -122.412138452652) | |||
| 57488 | 57488 | 250555 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 130 El Camino Del Mar | 3 | : 4 | Tree 1 | Private 1 | 5 | Width 4ft | 5988156.37986 | 2115366.75845 | 37.7877098242971 | -122.484805955556 | (37.7877098242971, -122.484805955556) | |||
| 57528 | 57528 | 227572 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 841 Church St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6004362.062530001 | 2104151.54801 | 37.7578461063327 | -122.42793790601499 | (37.7578461063327, -122.427937906015) | |||
| 58124 | 58124 | 206995 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1584 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993720.55073 | 2104714.02617 | 37.7587827556425 | -122.464781251568 | (37.7587827556425, -122.464781251568) | |||
| 58241 | 58241 | 227081 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 71 Woodward St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6006508.23754 | 2108096.29045 | 37.76879862578671 | -122.420795571254 | (37.7687986257867, -122.420795571254) | |||
| 58411 | 58411 | 248399 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 115 Belvedere St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5998223.6499 | 2108104.3812 | 37.768350409277396 | -122.449451812394 | (37.7683504092774, -122.449451812394) | |||
| 58507 | 58507 | 191240 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1620 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014102.75792 | 2095335.27393 | 37.734184723832996 | -122.393633211698 | (37.734184723833, -122.393633211698) | |||
| 58669 | 58669 | 118593 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Point Lobos Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5982449.24993 | 2112557.22359 | 37.7796616287576 | -122.504342981812 | (37.7796616287576, -122.504342981812) | |||
| 58837 | 58837 | 227567 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 308 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6001758.47595 | 2103911.51009 | 37.7570393829676 | -122.43692499579299 | (37.7570393829676, -122.436924995793) | |||
| 58875 | 58875 | 191246 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 22 Rausch St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009574.51886 | 2111002.08454 | 37.776949608681 | -122.41039468697599 | (37.776949608681, -122.410394686976) | |||
| 59010 | 59010 | 116551 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1002x Naples St | 7 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 3x3 | 6001523.56178 | 2088140.13665 | 37.713721490625 | -122.43660856033199 | (37.713721490625, -122.436608560332) | |||
| 59198 | 59198 | 227086 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 6 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 5ft | 6009619.77164 | 2096165.8193400002 | 37.7362150980513 | -122.409190969587 | (37.7362150980513, -122.409190969587) | |||
| 59233 | 59233 | 108371 | Permitted Site 1 | Lagunaria patersonii :: Primrose Tree 48 | 575 Paris St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 1 | 3x3 | 6001620.80772 | 2090281.19611 | 37.719605888781295 | -122.43642558878 | (37.7196058887813, -122.43642558878) | ||
| 59266 | 59266 | 207018 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 466 Staples Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 5997114.73821 | 2093838.00202 | 37.7291149630685 | -122.452257872798 | (37.7291149630685, -122.452257872798) | |||
| 59456 | 59456 | 106431 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 747 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3x3 | 6008848.75367 | 2110684.34026 | 37.7760364460542 | -122.412882870049 | (37.7760364460542, -122.412882870049) | |||
| 60263 | 60263 | 247309 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 220 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 6002790.9139 | 2109368.8454 | 37.7720825259473 | -122.43374447503099 | (37.7720825259473, -122.433744475031) | |||
| 60440 | 60440 | 227159 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 156 Duncan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6005558.07312 | 2099948.5227 | 37.746373159994505 | -122.423502792335 | (37.7463731599945, -122.423502792335) | |||
| 60676 | 60676 | 129381 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 555 O'Farrell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008630.87446 | 2114175.52263 | 37.7856101663154 | -122.41388359157699 | (37.7856101663154, -122.413883591577) | |||
| 60679 | 60679 | 207022 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 Williar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997053.5846 | 2090532.92812 | 37.720036506659206 | -122.452230901246 | (37.7200365066592, -122.452230901246) | |||
| 60843 | 60843 | 227110 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 105 Manchester St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6008268.06848 | 2099378.0671099997 | 37.7449594041621 | -122.41409156248001 | (37.7449594041621, -122.41409156248) | |||
| 61434 | 61434 | 227118 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005870.45988 | 2099040.93392 | 37.743898754514106 | -122.42235811905701 | (37.7438987545141, -122.422358119057) | |||
| 62607 | 62607 | 207043 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 73 Keystone Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5994097.83418 | 2093287.06293 | 37.7274289275879 | -122.46264752636999 | (37.7274289275879, -122.46264752637) | |||
| 62998 | 62998 | 176882 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 371 Wilde Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010924.50069 | 2089093.90072 | 37.7168700890604 | -122.404182392406 | (37.7168700890604, -122.404182392406) | |||
| 63459 | 63459 | 184208 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1474 40th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983740.5189 | 2105133.2538 | 37.759353393050105 | -122.49932723943 | (37.7593533930501, -122.49932723943) | |||
| 63496 | 63496 | 227556 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 95 Seward St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 3ft | 6000674.34081 | 2104608.13246 | 37.7588904593411 | -122.440724304978 | (37.7588904593411, -122.440724304978) | |||
| 63806 | 63806 | 181949 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2450 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5986451.9754 | 2098568.253 | 37.7414863814969 | -122.489467090095 | (37.7414863814969, -122.489467090095) | |||
| 63861 | 63861 | 207046 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 654 Joost Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5997758.19926 | 2095006.4821 | 37.7323601729864 | -122.450117573561 | (37.7323601729864, -122.450117573561) | |||
| 63881 | 63881 | 129374 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 454 Walnut St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5998634.47077 | 2115144.9555599997 | 37.7877054985629 | -122.448537946784 | (37.7877054985629, -122.448537946784) | |||
| 64011 | 64011 | 176891 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 128 Craut St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004014.42285 | 2094241.1944400002 | 37.730614887467205 | -122.428433829062 | (37.7306148874672, -122.428433829062) | |||
| 64119 | 64119 | 227082 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 4021 Mission St | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6004538.86235 | 2095169.3396700001 | 37.7331930297319 | -122.426686831253 | (37.7331930297319, -122.426686831253) | |||
| 64250 | 64250 | 116547 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 1041x Naples St | 3 | Median : Yard 3 | Tree 1 | DPW 2 | 4 | 3x3 | 6001554.67745 | 2088129.8106 | 37.7136949057732 | -122.436500274771 | (37.7136949057732, -122.436500274771) | |||
| 64913 | 64913 | 201811 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 2 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6021050.71889 | 2093203.62599 | 37.7287152512926 | -122.369464359799 | (37.7287152512926, -122.369464359799) | |||
| 65062 | 65062 | 201810 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 101 Friedell St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 6ft | 6021035.70856 | 2093179.8039900002 | 37.7286490171175 | -122.369514606714 | (37.7286490171175, -122.369514606714) | |||
| 65132 | 65132 | 191233 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2055 Silver Ave | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6012545.7197199995 | 2096123.8065400003 | 37.7362632270542 | -122.399071750278 | (37.7362632270542, -122.399071750278) | |||
| 65576 | 65576 | 176919 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 140 Seville St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6001505.61042 | 2087336.29034 | 37.71151328628479 | -122.436613103724 | (37.7115132862848, -122.436613103724) | |||
| 66467 | 66467 | 176899 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 167 Madison St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 4ft | 6005613.54422 | 2092807.28897 | 37.7267680598911 | -122.422803552358 | (37.7267680598911, -122.422803552358) | |||
| 66926 | 66926 | 184599 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1795 40th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5983770.6594 | 2102984.6576 | 37.7534557168171 | -122.499064248064 | (37.7534557168171, -122.499064248064) | |||
| 68212 | 68212 | 119242 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 Sutro Heights Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 1 | Width 8ft | 5981417.66127 | 2111333.86508 | 37.7762419210818 | -122.507820820241 | (37.7762419210818, -122.507820820241) | |||
| 68691 | 68691 | 176904 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 68 Cambridge St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6006443.50632 | 2094472.10137 | 37.7313860651023 | -122.42005248574499 | (37.7313860651023, -122.420052485745) | |||
| 68947 | 68947 | 176905 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 68 Cambridge St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 3ft | 6006453.00873 | 2094472.53688 | 37.731387796298705 | -122.420019664972 | (37.7313877962987, -122.420019664972) | |||
| 70054 | 70054 | 184494 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1875 38th Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5984410.615 | 2102424.5695 | 37.7519553887834 | -122.496809845733 | (37.7519553887834, -122.496809845733) | |||
| 70354 | 70354 | 207004 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 171 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5992803.19794 | 2098037.0989599996 | 37.7403966964551 | -122.46746831791 | (37.7403966964551, -122.46746831791) | |||
| 70932 | 70932 | 119542 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 791 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5986618.95807 | 2110548.82595 | 37.7743914964818 | -122.48977060648899 | (37.7743914964818, -122.489770606489) | |||
| 71244 | 71244 | 227084 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1217 York St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010060.56336 | 2102014.9446799997 | 37.7523002058063 | -122.408079341009 | (37.7523002058063, -122.408079341009) | |||
| 72063 | 72063 | 176879 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 140 Bacon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6010956.3364 | 2092967.7781599998 | 37.7275087379234 | -122.404344863032 | (37.7275087379234, -122.404344863032) | |||
| 72194 | 72194 | 121883 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 50 18th Ave | 5 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 5ft | 5990230.48175 | 2114847.31405 | 37.786404156248004 | -122.477592056385 | (37.786404156248, -122.477592056385) | |||
| 72347 | 72347 | 191244 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1620 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6014050.660540001 | 2095263.98772 | 37.733986091481206 | -122.39380834209801 | (37.7339860914812, -122.393808342098) | |||
| 72880 | 72880 | 248155 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 235 Rutledge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6010048.23979 | 2099492.4434599997 | 37.7453732829604 | -122.40794409015 | (37.7453732829604, -122.40794409015) | |||
| 73263 | 73263 | 129389 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2507 Larkin St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006655.24817 | 2120043.6921200003 | 37.801611544485205 | -122.421135524881 | (37.8016115444852, -122.421135524881) | |||
| 73895 | 73895 | 176887 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 13 Santa Rosa Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 2ft | 6002286.64114 | 2092541.4001799999 | 37.725849714484404 | -122.434285547657 | (37.7258497144844, -122.434285547657) | |||
| 74076 | 74076 | 120009 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 746 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5986962.570590001 | 2110820.51914 | 37.775157546008 | -122.48860197556101 | (37.775157546008, -122.488601975561) | |||
| 74077 | 74077 | 227120 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 799 Duncan St | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 4ft | 6001486.2339699995 | 2099669.55813 | 37.7453765205103 | -122.43756273743 | (37.7453765205103, -122.43756273743) | |||
| 74310 | 74310 | 129384 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 91 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008749.2926 | 2112454.6236099997 | 37.7808916402666 | -122.41335215429399 | (37.7808916402666, -122.413352154294) | |||
| 74626 | 74626 | 227547 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 780 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6001390.11593 | 2102052.79607 | 37.7519148588942 | -122.43806578220502 | (37.7519148588942, -122.438065782205) |
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");