Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, DBH
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude ▼ | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 186108 | 186108 | 176878 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 17 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6013154.94381 | 2086496.55313 | 37.709862662502104 | -122.396290845073 | (37.7098626625021, -122.396290845073) | |||
| 31319 | 31319 | 176877 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013098.43993 | 2086515.08302 | 37.709910397621705 | -122.396487432357 | (37.7099103976217, -122.396487432357) | |||
| 146826 | 146826 | 176876 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6013031.567530001 | 2086536.06642 | 37.7099642921874 | -122.396720027609 | (37.7099642921874, -122.396720027609) | |||
| 135940 | 135940 | 176875 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 526 Lathrop Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012929.76757 | 2086570.3757 | 37.710052832254796 | -122.39707427417801 | (37.7100528322548, -122.397074274178) | |||
| 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) | |||
| 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) | |||
| 179772 | 179772 | 176916 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 380 Rolph St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6001888.93185 | 2087835.8979599997 | 37.7129068748214 | -122.43532396063601 | (37.7129068748214, -122.435323960636) | |||
| 4130 | 4130 | 216848 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 258 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 02:39:00 PM | 3 | Width 3ft | 5994378.76562 | 2088424.12647 | 37.7140926462446 | -122.461323980613 | (37.7140926462446, -122.461323980613) | ||
| 4192 | 4192 | 216845 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 194 Farallones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/10/2017 07:48:00 AM | 3 | Width 3ft | 5995118.95449 | 2088413.12295 | 37.714105005620205 | -122.458764825742 | (37.7141050056202, -122.458764825742) | ||
| 159962 | 159962 | 207028 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 227 Ramsell St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 5992956.15905 | 2088729.24095 | 37.7148484391912 | -122.46626317241001 | (37.7148484391912, -122.46626317241) | |||
| 39635 | 39635 | 207026 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 229 Lobos St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5994724.722630001 | 2088692.2453700001 | 37.71484874224021 | -122.460147642199 | (37.7148487422402, -122.460147642199) | |||
| 137158 | 137158 | 207029 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 835 Sargent St | 1 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5991723.94975 | 2089189.17612 | 37.7160401362134 | -122.47055564102301 | (37.7160401362134, -122.470555641023) | |||
| 178180 | 178180 | 207030 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 835 Sargent St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 5991738.49074 | 2089190.01168 | 37.716043271265704 | -122.470505441771 | (37.7160432712657, -122.470505441771) | |||
| 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) | |||
| 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) | |||
| 4451 | 4451 | 216718 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 978 Capitol Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10/13/2017 11:36:00 AM | 3 | Width 3ft | 5995057.03199 | 2090421.24862 | 37.7196152839906 | -122.45912417326299 | (37.7196152839906, -122.459124173263) | ||
| 154067 | 154067 | 176880 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3333 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6012013.01229 | 2090122.1042900002 | 37.719754090752204 | -122.40049209994801 | (37.7197540907522, -122.400492099948) | |||
| 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) | |||
| 38084 | 38084 | 207023 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 Williar Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5997061.0236599995 | 2090546.31892 | 37.7200737008175 | -122.452206152789 | (37.7200737008175, -122.452206152789) | |||
| 4127 | 4127 | 207021 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 400 Grafton Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/06/2017 07:38:00 AM | 3 | Width 3ft | 5995575.229619999 | 2090581.47857 | 37.720085014301894 | -122.457344548018 | (37.7200850143019, -122.457344548018) | ||
| 37420 | 37420 | 207024 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 Williar Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5997067.34432 | 2090557.5942799998 | 37.7201050223995 | -122.452185117661 | (37.7201050223995, -122.452185117661) | |||
| 136757 | 136757 | 176881 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 3303 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011991.79808 | 2090250.44255 | 37.7201052985 | -122.400574440964 | (37.7201052985, -122.400574440964) | |||
| 161119 | 161119 | 207025 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 85 Williar Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5997075.91635 | 2090573.81293 | 37.72015004606371 | -122.45215665681299 | (37.7201500460637, -122.452156656813) | |||
| 4007 | 4007 | 216655 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 161 Miramar Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/05/2017 02:49:00 PM | 3 | Width 3ft | 5995318.74701 | 2090961.5845400002 | 37.7211139601174 | -122.45825861266 | (37.7211139601174, -122.45825861266) | ||
| 34085 | 34085 | 207020 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 230 Brighton Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5996253.66444 | 2091441.06295 | 37.722484173480204 | -122.45506152367201 | (37.7224841734802, -122.455061523672) | |||
| 174051 | 174051 | 176889 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 277 Athens St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6004392.5622 | 2091665.65248 | 37.7235644112504 | -122.42694318119499 | (37.7235644112504, -122.426943181195) | |||
| 75835 | 75835 | 176894 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 68 La Grande Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6005238.00808 | 2092009.9005900002 | 37.724557410279296 | -122.42404509073201 | (37.7245574102793, -122.424045090732) | |||
| 137913 | 137913 | 176893 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 68 La Grande Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6005229.89136 | 2092027.9096099997 | 37.7246064008395 | -122.42407442931601 | (37.7246064008395, -122.424074429316) | |||
| 138540 | 138540 | 176888 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 13 Santa Rosa Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6002306.40089 | 2092528.2983099998 | 37.7258148612434 | -122.43421630345301 | (37.7258148612434, -122.434216303453) | |||
| 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) | |||
| 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) | |||
| 169214 | 169214 | 207041 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1414 Plymouth Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5995889.45634 | 2093373.1410400001 | 37.727768297568005 | -122.456460143934 | (37.727768297568, -122.456460143934) | |||
| 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) | |||
| 167479 | 167479 | 176902 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 676 Silver Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6005861.557080001 | 2093540.1941099998 | 37.728794447392396 | -122.421998219354 | (37.7287944473924, -122.421998219354) | |||
| 37145 | 37145 | 176886 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 119 Theresa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002169.33644 | 2093633.7193099998 | 37.7288423165165 | -122.434769138285 | (37.7288423165165, -122.434769138285) | |||
| 31111 | 31111 | 207007 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 127 Westgate Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5993382.1086800005 | 2093854.3174299998 | 37.7289452232334 | -122.465162955333 | (37.7289452232334, -122.465162955333) | |||
| 169335 | 169335 | 176907 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 769 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6006492.037819999 | 2093629.408 | 37.7290749477448 | -122.419824929392 | (37.7290749477448, -122.419824929392) | |||
| 33440 | 33440 | 176906 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 769 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006512.6379 | 2093630.87617 | 37.7290801395131 | -122.419753817278 | (37.7290801395131, -122.419753817278) | |||
| 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) | |||
| 160817 | 160817 | 176903 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 290 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6005283.95555 | 2093790.15237 | 37.729448184373105 | -122.424012796049 | (37.7294481843731, -122.424012796049) | |||
| 130789 | 130789 | 176890 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 18 Ney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6003663.21456 | 2093989.9827 | 37.7299052360341 | -122.429630099158 | (37.7299052360341, -122.429630099158) | |||
| 152401 | 152401 | 176892 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 128 Craut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6004016.19178 | 2094155.9191400001 | 37.7303808407035 | -122.428421637873 | (37.7303808407035, -122.428421637873) | |||
| 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) | |||
| 134831 | 134831 | 176914 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1300 Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009346.093669999 | 2094283.90387 | 37.7310324255937 | -122.41000437762 | (37.7310324255937, -122.41000437762) | |||
| 22862 | 22862 | 176910 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1390 Silver Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009561.38521 | 2094361.93193 | 37.7312587382014 | -122.409265579153 | (37.7312587382014, -122.409265579153) | |||
| 22870 | 22870 | 176911 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1390 Silver Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009574.07755 | 2094366.6897 | 37.731272513113296 | -122.409222034865 | (37.7312725131133, -122.409222034865) | |||
| 22875 | 22875 | 176912 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1390 Silver Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009589.47798 | 2094371.19963 | 37.7312857592085 | -122.409169110679 | (37.7312857592085, -122.409169110679) | |||
| 22876 | 22876 | 176913 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1390 Silver Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6009673.25426 | 2094402.8730900001 | 37.7313774208194 | -122.40888171341999 | (37.7313774208194, -122.40888171342) | |||
| 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) | |||
| 149989 | 149989 | 227160 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 236 Bosworth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6003812.10722 | 2095285.7669 | 37.7334715974377 | -122.42920771908301 | (37.7334715974377, -122.429207719083) | |||
| 153496 | 153496 | 227150 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 808 Crescent Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008185.203290001 | 2095640.9266099997 | 37.7346933830922 | -122.41411375505301 | (37.7346933830922, -122.414113755053) | |||
| 38228 | 38228 | 227149 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 530 Crescent Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007719.361409999 | 2095678.5372900001 | 37.734770477458795 | -122.41572699582301 | (37.7347704774588, -122.415726995823) | |||
| 129668 | 129668 | 207044 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 755 Foerster St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5998014.32968 | 2095894.50831 | 37.7348131350024 | -122.44929603208 | (37.7348131350024, -122.44929603208) | |||
| 170337 | 170337 | 227090 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 22 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 6009411.625 | 2095915.20486 | 37.7355153013828 | -122.40989293540702 | (37.7355153013828, -122.409892935407) | |||
| 129699 | 129699 | 227161 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Leese St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6005575.79788 | 2096114.93647 | 37.73584799837779 | -122.423169051236 | (37.7358479983778, -122.423169051236) | |||
| 133135 | 133135 | 227087 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6009571.148469999 | 2096096.9094 | 37.736023162027294 | -122.409354219042 | (37.7360231620273, -122.409354219042) | |||
| 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) | |||
| 29460 | 29460 | 191230 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1251 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6014739.49892 | 2096121.8776900002 | 37.7363799383901 | -122.391486752132 | (37.7363799383901, -122.391486752132) | |||
| 150509 | 150509 | 227085 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 100 Alemany Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009638.60709 | 2096225.80995 | 37.736380874569896 | -122.409130079214 | (37.7363808745699, -122.409130079214) | |||
| 27360 | 27360 | 191232 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2055 Silver Ave | 1 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6012617.37339 | 2096166.05375 | 37.7363832218132 | -122.39882697638201 | (37.7363832218132, -122.398826976382) | |||
| 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) | |||
| 133679 | 133679 | 207045 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 607 Teresita Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998977.59415 | 2096753.4397599997 | 37.737226608721706 | -122.446027465895 | (37.7372266087217, -122.446027465895) | |||
| 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) | |||
| 150094 | 150094 | 227148 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 401 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6008617.6421300005 | 2096897.82478 | 37.7381688320284 | -122.412707488766 | (37.7381688320284, -122.412707488766) | |||
| 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) | |||
| 137533 | 137533 | 191229 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 901 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6015272.35005 | 2096832.51763 | 37.7383607716336 | -122.389694066038 | (37.7383607716336, -122.389694066038) | |||
| 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) | |||
| 22360 | 22360 | 191245 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1675 Jerrold Ave | 1 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6014937.212180001 | 2097262.06336 | 37.7395216264201 | -122.3908828304 | (37.7395216264201, -122.3908828304) | |||
| 146673 | 146673 | 207006 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 243 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5992316.05801 | 2097825.5684599997 | 37.739787751096294 | -122.469137249186 | (37.7397877510963, -122.469137249186) | |||
| 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) | |||
| 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) | |||
| 165898 | 165898 | 227147 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 195 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008297.42871 | 2097716.19697 | 37.7403979249162 | -122.41387250470899 | (37.7403979249162, -122.413872504709) | |||
| 180255 | 180255 | 207036 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1645 Ulloa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5990861.16949 | 2098351.90974 | 37.7411487751831 | -122.474205983836 | (37.7411487751831, -122.474205983836) | |||
| 180853 | 180853 | 227108 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 102 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6007939.95228 | 2098099.81155 | 37.741431163228604 | -122.41513566820299 | (37.7414311632286, -122.415135668203) | |||
| 178499 | 178499 | 227109 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 72 Gates St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6008318.15108 | 2098296.22562 | 37.741991719651 | -122.41384187381 | (37.741991719651, -122.41384187381) | |||
| 5012 | 5012 | 189150 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 351 Cargo Way | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:46:00 AM | 3 | Width 3ft | 6017356.8528 | 2098625.87133 | 37.7434003277556 | -122.382611554189 | (37.7434003277556, -122.382611554189) | ||
| 5071 | 5071 | 203010 | DPW Maintained 3 | Lagunaria patersonii :: Primrose Tree 48 | 351 Cargo Way | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/10/2017 11:48:00 AM | 3 | Width 3ft | 6017339.6558 | 2098641.75454 | 37.743442989794005 | -122.38267212263399 | (37.743442989794, -122.382672122634) | ||
| 159201 | 159201 | 207002 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2380 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992354.33739 | 2099175.8386 | 37.7434974617379 | -122.46910314240601 | (37.7434974617379, -122.469103142406) | |||
| 136042 | 136042 | 207003 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 2380 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992355.41935 | 2099194.1789700002 | 37.74354788223621 | -122.46910073580601 | (37.7435478822362, -122.469100735806) | |||
| 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) | |||
| 136194 | 136194 | 227101 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 395 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003382.77934 | 2099193.25446 | 37.744176348274294 | -122.43097080757799 | (37.7441763482743, -122.430970807578) | |||
| 24647 | 24647 | 227111 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 19 Stoneman St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6008285.63801 | 2099411.47629 | 37.745052125166296 | -122.414033173096 | (37.7450521251663, -122.414033173096) | |||
| 134651 | 134651 | 207001 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 404 Santiago St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991538.30054 | 2099790.96979 | 37.7451392685705 | -122.47196959112301 | (37.7451392685705, -122.471969591123) | |||
| 149356 | 149356 | 207000 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 404 Santiago St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991556.482030001 | 2099793.0654 | 37.7451460746357 | -122.471906875997 | (37.7451460746357, -122.471906875997) | |||
| 149848 | 149848 | 206999 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 404 Santiago St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991570.38275 | 2099794.54343 | 37.7451509372588 | -122.471858917877 | (37.7451509372588, -122.471858917877) | |||
| 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) | |||
| 40644 | 40644 | 227097 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1650 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009272.782269999 | 2099754.5666099996 | 37.7460495695343 | -122.41064401410601 | (37.7460495695343, -122.410644014106) | |||
| 148319 | 148319 | 207042 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 40 Vasquez Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5995660.33467 | 2100048.89738 | 37.746085134133 | -122.45773506422701 | (37.746085134133, -122.457735064227) | |||
| 185174 | 185174 | 227098 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 1646 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009270.38668 | 2099790.7272200002 | 37.7461487242839 | -122.41065485095801 | (37.7461487242839, -122.410654850958) | |||
| 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) | |||
| 180870 | 180870 | 227099 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 75 Montcalm St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6010635.77556 | 2100089.10311 | 37.7470444571367 | -122.40595450111401 | (37.7470444571367, -122.405954501114) | |||
| 159779 | 159779 | 227135 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 200 Portola Dr | 11 | : 4 | Tree 1 | Private 1 | 2 | Width 3ft | 5999460.85655 | 2100362.14837 | 37.7471628438967 | -122.444615908893 | (37.7471628438967, -122.444615908893) | |||
| 169727 | 169727 | 227134 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 200 Portola Dr | 10 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5999484.90108 | 2100375.94772 | 37.747202105595 | -122.44453375672501 | (37.747202105595, -122.444533756725) | |||
| 35827 | 35827 | 227133 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 200 Portola Dr | 9 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 5999502.6369199995 | 2100390.28597 | 37.7472424869628 | -122.44447345808999 | (37.7472424869628, -122.44447345809) | |||
| 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) | |||
| 130556 | 130556 | 227131 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 200 Portola Dr | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5999574.512619999 | 2100531.90957 | 37.7476354520323 | -122.44423509368 | (37.7476354520323, -122.44423509368) | |||
| 25454 | 25454 | 227130 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 200 Portola Dr | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 5999573.3022300005 | 2100550.7346900003 | 37.747687072210105 | -122.44424063169599 | (37.7476870722101, -122.444240631696) | |||
| 25567 | 25567 | 227123 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 483 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6002011.92527 | 2100876.5046200003 | 37.748720385135705 | -122.43583132576201 | (37.7487203851357, -122.435831325762) | |||
| 131491 | 131491 | 227124 | Undocumented 2 | Lagunaria patersonii :: Primrose Tree 48 | 483 Clipper St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6002026.8924 | 2100876.99711 | 37.74872258759179 | -122.435779604843 | (37.7487225875918, -122.435779604843) |
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");