Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qCaretaker, PlantDate, PlotSize, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder ▼ | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 999 | 999 | 251422 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 480x De Long St | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5992963.0 | 2086633.0 | 37.709093057147996 | -122.466087289133 | (37.709093057148, -122.466087289133) | |||||
| 90230 | 90230 | 98140 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 315 San Marcos Ave | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992920.8 | 2100212.1 | 37.746375486546704 | -122.467219803339 | (37.7463754865467, -122.467219803339) | ||||||
| 122936 | 122936 | 107159 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000 ESMERALDA AVE | Front Yard : Yard 7 | Tree 1 | Private 1 | 6009839.0 | 2098688.0 | 37.7431527400861 | -122.408610872619 | (37.7431527400861, -122.408610872619) | ||||||
| 145874 | 145874 | 100769 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3701 21st St | Front Yard : Yard 7 | Tree 1 | Private 1 | 55 | Street tree w/in RoW | 6003717.0 | 2103606.0 | 37.7563116466144 | -122.43012988292 | (37.7563116466144, -122.43012988292) | ||||
| 1633 | 1633 | 251599 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 740 Moraga St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 5992006.0 | 2103899.0 | 37.756445907456396 | -122.470651540396 | (37.7564459074564, -122.470651540396) | ||||
| 1820 | 1820 | 251716 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3929 19th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003450.0 | 2104734.0 | 37.75939373993371 | -122.431133769968 | (37.7593937399337, -122.431133769968) | |||||
| 1822 | 1822 | 251717 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1000X San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6004710.0 | 2096486.0 | 37.736817957153605 | -122.426188866367 | (37.7368179571536, -122.426188866367) | |||||
| 2186 | 2186 | 252924 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 700 Sanchez St | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 6003672.0 | 2104202.0 | 37.757945572264 | -122.430328029181 | (37.757945572264, -122.430328029181) | |||||
| 4923 | 4923 | 253718 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 227 Madison St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 3x3 | 6005690.0 | 2092595.0 | 37.726189474375204 | -122.422524168298 | (37.7261894743752, -122.422524168298) | ||||
| 5105 | 5105 | 253777 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
| 7834 | 7834 | 119605 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 299x Avalon Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | ||||||||||
| 10256 | 10256 | 173933 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 Beacon St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6003193.0 | 2097540.0 | 37.739626138558705 | -122.43150902083299 | (37.7396261385587, -122.431509020833) | |||||
| 25672 | 25672 | 247989 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 130 Mullen Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | Width 10ft | 6009899.29934 | 2099821.3308900003 | 37.7462679959733 | -122.40848229933901 | (37.7462679959733, -122.408482299339) | |||
| 35815 | 35815 | 249711 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2901 Broadway | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 5999592.84448 | 2116997.53125 | 37.7928469352999 | -122.44535542411501 | (37.7928469352999, -122.445355424115) | ||||
| 46935 | 46935 | 250205 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 212 Union St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 6011817.68969 | 2119792.01106 | 37.8012101599872 | -122.4032533082 | (37.8012101599872, -122.4032533082) | |||
| 49820 | 49820 | 223735 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1760 Diamond St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 34 | 6002021.50784 | 2098799.04405 | 37.7430167120556 | -122.43564958267 | (37.7430167120556, -122.43564958267) | ||||
| 53350 | 53350 | 223795 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 22 Saturn St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 47 | Width 3ft | 6000543.87273 | 2106026.1348599996 | 37.7627765144437 | -122.44127726574101 | (37.7627765144437, -122.441277265741) | |||
| 53725 | 53725 | 223707 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1200 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6004449.31264 | 2096325.41802 | 37.7363622972844 | -122.42707874320699 | (37.7363622972844, -122.427078743207) | ||||
| 58790 | 58790 | 205909 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 14 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 56 | 6000896.43949 | 2095509.3176099998 | 37.733919926568106 | -122.43930400388399 | (37.7339199265681, -122.439304003884) | ||||
| 60073 | 60073 | 223798 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 250 States St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 51 | Width 3ft | 6000691.89745 | 2106604.60917 | 37.764373293104896 | -122.44080679981501 | (37.7643732931049, -122.440806799815) | |||
| 62231 | 62231 | 176114 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 10 Zoo Rd | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | Width 10ft | 5982696.49512 | 2094384.4536 | 37.729778850703894 | -122.502142508582 | (37.7297788507039, -122.502142508582) | |||
| 67041 | 67041 | 249828 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 339 Greenwich St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | Width 0ft | 6011201.53996 | 2120373.03951 | 37.802771091668205 | -122.405426409314 | (37.8027710916682, -122.405426409314) | |||
| 67821 | 67821 | 223782 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4067 20th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 3ft | 6003283.38954 | 2104156.06965 | 37.7577974386201 | -122.43166872824699 | (37.7577974386201, -122.431668728247) | |||
| 71003 | 71003 | 223708 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 220 Coso Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6007533.84485 | 2099558.41005 | 37.7454133189685 | -122.416643154074 | (37.7454133189685, -122.416643154074) | ||||
| 71400 | 71400 | 223722 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 College Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 2ft | 6005269.83523 | 2095874.10119 | 37.735169447301104 | -122.424209762894 | (37.7351694473011, -122.424209762894) | |||
| 78509 | 78509 | 102745 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 222 Moncada Way | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992354.0 | 2093377.4 | 37.727576385896604 | -122.468682482409 | (37.7275763858966, -122.468682482409) | |||||
| 98176 | 98176 | 105497 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3929 19TH ST | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 60 | 6003450.9 | 2104734.8 | 37.7593959875427 | -122.431130714429 | (37.7593959875427, -122.431130714429) | ||||
| 98711 | 98711 | 105649 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 3 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990274.6 | 2090665.2 | 37.7200090188364 | -122.475672946469 | (37.7200090188364, -122.475672946469) | |||||
| 103620 | 103620 | 93204 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
| 108351 | 108351 | 106363 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 URBANO DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 80 | 5993535.8 | 2092458.1 | 37.7251204132224 | -122.464530299025 | (37.7251204132224, -122.464530299025) | ||||
| 115560 | 115560 | 109453 | Permitted Site 1 | Cupressus macrocarpa :: Monterey Cypress 47 | 951 GILMAN AVE | 1 | Front Yard : Yard 7 | Tree 1 | Rec/Park 3 | 03/24/2015 12:00:00 AM | 3 | Permit Number 774986 | 6015934.0 | 2089205.0 | 37.717453787650705 | -122.38687458595501 | (37.7174537876507, -122.386874585955) | ||
| 116468 | 116468 | 103351 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 15X Highland Ave | 1 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 18 | 6004989.3 | 2096795.8 | 37.73768438084971 | -122.42524524109 | (37.7376843808497, -122.42524524109) | ||||
| 117533 | 117533 | 105764 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1X GONZALEZ DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990111.8 | 2090190.8 | 37.718696994740704 | -122.476201051717 | (37.7186969947407, -122.476201051717) | |||||
| 120332 | 120332 | 103422 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1365 Portola Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | Permit Number 769779 | 5993416.2 | 2097683.7 | 37.7394617231066 | -122.46532315146601 | (37.7394617231066, -122.465323151466) | ||||
| 125813 | 125813 | 103600 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 50X Hermann St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005031.0649 | 2108842.56611 | 37.7707643495235 | -122.42595813798201 | (37.7707643495235, -122.425958137982) | |||||
| 135517 | 135517 | 249787 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 173 Chestnut St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | Width 0ft | 6010924.52484 | 2121034.4207099997 | 37.8045715892836 | -122.40643165799 | (37.8045715892836, -122.40643165799) | |||
| 137917 | 137917 | 223789 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 190 Storrie St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | Width 3ft | 6000719.29532 | 2105252.42792 | 37.7606620968006 | -122.44061504455401 | (37.7606620968006, -122.440615044554) | |||
| 139692 | 139692 | 99826 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1 Cascade Walk | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5992183.1 | 2103187.3 | 37.7545020044945 | -122.469987253468 | (37.7545020044945, -122.469987253468) | |||||
| 140312 | 140312 | 115391 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 21X BELMONT AVE | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 48 | 5996611.0 | 2106266.0 | 37.7632103037359 | -122.45489693849501 | (37.7632103037359, -122.454896938495) | ||||
| 143237 | 143237 | 104888 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 146 Gonzalez Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5990401.0 | 2090562.0 | 37.719732984351396 | -122.475228499286 | (37.7197329843514, -122.475228499286) | |||||
| 144598 | 144598 | 99662 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 1337 Portola Dr | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5993559.3 | 2097744.3 | 37.7396363671104 | -122.46483277796801 | (37.7396363671104, -122.464832777968) | |||||
| 145393 | 145393 | 98880 | Property Tree 7 | Cupressus macrocarpa :: Monterey Cypress 47 | 101 Lansdale Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 11 | 5994747.9 | 2097283.1 | 37.738438484278895 | -122.460689725403 | (37.7384384842789, -122.460689725403) | ||||
| 148628 | 148628 | 248051 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 25 Rutledge St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6010607.1512400005 | 2099382.29757 | 37.745102122072396 | -122.406003697633 | (37.7451021220724, -122.406003697633) | ||||
| 152523 | 152523 | 223698 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 151 | 6004903.42732 | 2096771.39372 | 37.7376125150086 | -122.42554040785801 | (37.7376125150086, -122.425540407858) | ||||
| 160062 | 160062 | 176162 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 301 Naglee Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | Width 10ft | 5997669.17463 | 2088536.7397200002 | 37.7145906808916 | -122.449959233558 | (37.7145906808916, -122.449959233558) | |||
| 166986 | 166986 | 223780 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4071 20th St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | Width 3ft | 6003254.362819999 | 2104156.16383 | 37.757796051860296 | -122.431769121362 | (37.7577960518603, -122.431769121362) | |||
| 168070 | 168070 | 250204 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 206 Union St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 0ft | 6011843.5346800005 | 2119802.5611900003 | 37.8012405714539 | -122.403164615272 | (37.8012405714539, -122.403164615272) | |||
| 170501 | 170501 | 205908 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 22 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 6000855.4988 | 2095527.0411599998 | 37.733966261424 | -122.43944681802799 | (37.733966261424, -122.439446818028) | ||||
| 179027 | 179027 | 205907 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 30 Martha Ave | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 34 | 6000842.20104 | 2095534.19328 | 37.7339851426839 | -122.439493304878 | (37.7339851426839, -122.439493304878) | ||||
| 2848 | 2848 | 253255 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 270 Castenada Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10x10 | 5994049.0 | 2100330.0 | 37.746764271907 | -122.46332720271201 | (37.746764271907, -122.463327202712) | ||||
| 5089 | 5089 | 253778 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 2 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
| 25090 | 25090 | 223699 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 72 | 6004901.063490001 | 2096745.81285 | 37.737542142145706 | -122.425546760699 | (37.7375421421457, -122.425546760699) | ||||
| 35196 | 35196 | 223693 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1501 San Jose Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 6004632.33856 | 2096219.1037400002 | 37.736080730338394 | -122.426438378246 | (37.7360807303384, -122.426438378246) | ||||
| 41942 | 41942 | 176158 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 825 Brotherhood Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 27 | Width 0ft | 5989484.91598 | 2088634.67131 | 37.7143878792713 | -122.47825419477199 | (37.7143878792713, -122.478254194772) | |||
| 65231 | 65231 | 247990 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 130 Mullen Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 10ft | 6009904.82703 | 2099823.3195700003 | 37.7462737660155 | -122.40846332542499 | (37.7462737660155, -122.408463325425) | |||
| 122020 | 122020 | 223736 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1760 Diamond St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 6002022.64455 | 2098766.1332 | 37.7429264111321 | -122.435643298224 | (37.7429264111321, -122.435643298224) | ||||
| 126172 | 126172 | 223721 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 201 College Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 2ft | 6005265.6215699995 | 2095876.8454099998 | 37.7351767443941 | -122.424224526166 | (37.7351767443941, -122.424224526166) | |||
| 137161 | 137161 | 249710 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2901 Broadway | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5999603.39885 | 2116998.0274799997 | 37.7928489002955 | -122.44531894132099 | (37.7928489002955, -122.445318941321) | ||||
| 139394 | 139394 | 93203 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
| 148452 | 148452 | 247988 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 124 Mullen Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 29 | Width 10ft | 6009878.9446 | 2099816.70211 | 37.746254146420796 | -122.40855235741199 | (37.7462541464208, -122.408552357412) | |||
| 150471 | 150471 | 201721 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Lindsay Cir | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 26 | 6016317.40109 | 2095614.0815400002 | 37.7350730858367 | -122.385995846031 | (37.7350730858367, -122.385995846031) | ||||
| 166536 | 166536 | 223783 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4053 20th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 19 | Width 3ft | 6003309.14673 | 2104160.40669 | 37.7578108070506 | -122.431579958864 | (37.7578108070506, -122.431579958864) | |||
| 168599 | 168599 | 176157 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 999 Brotherhood Way | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 0ft | 5988327.5004199995 | 2088688.82584 | 37.714469318273004 | -122.482258598878 | (37.714469318273, -122.482258598878) | |||
| 176669 | 176669 | 223743 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 65 Zircon Pl | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 45 | 6002363.70914 | 2098682.85125 | 37.7427171047157 | -122.434458039421 | (37.7427171047157, -122.434458039421) | ||||
| 182295 | 182295 | 249826 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 391 Filbert St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 41 | Width 0ft | 6011015.83097 | 2120024.81975 | 37.8018045803872 | -122.406044514263 | (37.8018045803872, -122.406044514263) | |||
| 182837 | 182837 | 223781 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4071 20th St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 3ft | 6003265.85281 | 2104155.2145700003 | 37.757794096729704 | -122.431729316456 | (37.7577940967297, -122.431729316456) | |||
| 5095 | 5095 | 253779 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 3 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
| 34768 | 34768 | 247991 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 130 Mullen Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | Width 10ft | 6009914.62518 | 2099827.74346 | 37.7462864617583 | -122.408429756449 | (37.7462864617583, -122.408429756449) | |||
| 46521 | 46521 | 249857 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 241 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | Width 0ft | 6011495.8307 | 2120401.68392 | 37.8028661922948 | -122.404410025227 | (37.8028661922948, -122.404410025227) | |||
| 75294 | 75294 | 93205 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
| 130214 | 130214 | 249786 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 161 Chestnut St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | Width 0ft | 6010943.97363 | 2121044.47732 | 37.8046002902368 | -122.406365062323 | (37.8046002902368, -122.406365062323) | |||
| 135849 | 135849 | 223784 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4053 20th St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 12 | Width 3ft | 6003311.94713 | 2104157.91434 | 37.7578041223787 | -122.431570095991 | (37.7578041223787, -122.431570095991) | |||
| 185302 | 185302 | 223737 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1760 Diamond St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6002025.38373 | 2098740.99425 | 37.7428575410441 | -122.43563202880699 | (37.7428575410441, -122.435632028807) | ||||
| 188593 | 188593 | 249830 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 339 Greenwich St | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 22 | Width 0ft | 6011191.13425 | 2120368.12029 | 37.8027570028825 | -122.405462071912 | (37.8027570028825, -122.405462071912) | |||
| 3044 | 3044 | 253288 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 650 Peru Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005101.95698 | 2092563.1940099997 | 37.7260689503102 | -122.42455474103201 | (37.7260689503102, -122.424554741032) | |||||
| 5107 | 5107 | 253780 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 4 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
| 56694 | 56694 | 223785 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4053 20th St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 33 | Width 3ft | 6003318.98777 | 2104163.44905 | 37.7578197184314 | -122.431546141668 | (37.7578197184314, -122.431546141668) | |||
| 92075 | 92075 | 111588 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 4 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | 48 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | |||
| 118374 | 118374 | 93206 | Significant Tree 6 | Cupressus macrocarpa :: Monterey Cypress 47 | 400 Masonic Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 02/24/2010 12:00:00 AM | Permit Number 53203 | 5999124.7 | 2111407.5 | 37.777471434329904 | -122.446572853901 | (37.7774714343299, -122.446572853901) | |||
| 170407 | 170407 | 223738 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1760 Diamond St | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6002028.666809999 | 2098687.0013900003 | 37.742709475762894 | -122.43561681495899 | (37.7427094757629, -122.435616814959) | ||||
| 3046 | 3046 | 253289 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 650 Peru Ave | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005101.95698 | 2092563.1940099997 | 37.7260689503102 | -122.42455474103201 | (37.7260689503102, -122.424554741032) | |||||
| 5100 | 5100 | 253781 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 90 Cuesta Ct | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5999757.0 | 2101744.0 | 37.750973968576496 | -122.443691128062 | (37.7509739685765, -122.443691128062) | |||||
| 89354 | 89354 | 111589 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 730X Lake Merced Blvd | 5 | Front Yard : Yard 7 | Tree 1 | DPW for City Agency 10 | DPW 4 | Permit Number 774260 | 5987577.495069999 | 2091187.90071 | 37.7212874908284 | -122.485034126397 | (37.7212874908284, -122.485034126397) | |||
| 138302 | 138302 | 113064 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2X Cranleigh Dr | 5 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 08/18/2016 09:54:00 AM | 3 | 5991370.3 | 2095943.7 | 37.734565924896394 | -122.472270103664 | (37.7345659248964, -122.472270103664) | |||
| 170171 | 170171 | 223739 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1760 Diamond St | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 25 | 6002032.6649400005 | 2098618.50085 | 37.7425216163939 | -122.43559809108 | (37.7425216163939, -122.43559809108) | ||||
| 183568 | 183568 | 176102 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 62 Tomaso Ct | 5 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | Width 8ft | 6009173.04361 | 2086270.9274900001 | 37.709020763061396 | -122.41003717048099 | (37.7090207630614, -122.410037170481) | |||
| 3049 | 3049 | 253290 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 650 Peru Ave | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005101.95698 | 2092563.1940099997 | 37.7260689503102 | -122.42455474103201 | (37.7260689503102, -122.424554741032) | |||||
| 46071 | 46071 | 223740 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1760 Diamond St | 6 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6002036.21609 | 2098593.82428 | 37.742454062002395 | -122.43558404729299 | (37.7424540620024, -122.435584047293) | ||||
| 124189 | 124189 | 113065 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 2X Cranleigh Dr | 6 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 08/18/2016 09:51:00 AM | 3 | 5991370.3 | 2095943.7 | 37.734565924896394 | -122.472270103664 | (37.7345659248964, -122.472270103664) | |||
| 3050 | 3050 | 253291 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 650 Peru Ave | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6005101.95698 | 2092563.1940099997 | 37.7260689503102 | -122.42455474103201 | (37.7260689503102, -122.424554741032) | |||||
| 42862 | 42862 | 249675 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2400 Baker St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 49 | 5999731.49147 | 2117154.85585 | 37.7932868206735 | -122.444887014927 | (37.7932868206735, -122.444887014927) | ||||
| 147608 | 147608 | 223786 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 4053 20th St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 31 | Width 3ft | 6003330.94018 | 2104170.0994700002 | 37.7578386563428 | -122.43150528004401 | (37.7578386563428, -122.431505280044) | |||
| 157577 | 157577 | 126419 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 956 Vallejo St | 7 | Front Yard : Yard 7 | Tree 1 | Private 1 | 20 | 6008811.64334 | 2118703.9569599996 | 37.7980542914263 | -122.413578579305 | (37.7980542914263, -122.413578579305) | ||||
| 114769 | 114769 | 114267 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800x BROTHERHOOD WAY | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 50 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 132735 | 132735 | 223694 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 65 | 6005104.45792 | 2096735.8383799999 | 37.7375262448502 | -122.424842819945 | (37.7375262448502, -122.424842819945) | ||||
| 135200 | 135200 | 223752 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 3944 22nd St | 8 | Front Yard : Yard 7 | Tree 1 | Private 1 | 16 | 6002172.64124 | 2102975.1005599997 | 37.754491758314295 | -122.435425673069 | (37.7544917583143, -122.435425673069) | ||||
| 91685 | 91685 | 114268 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800x BROTHERHOOD WAY | 9 | Front Yard : Yard 7 | Tree 1 | Private 1 | 30 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) | ||||
| 34710 | 34710 | 223715 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1101 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6004750.57812 | 2096360.89303 | 37.736476735096296 | -122.426039666491 | (37.7364767350963, -122.426039666491) | ||||
| 58052 | 58052 | 223695 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 37 | 6005104.91543 | 2096758.07935 | 37.73758733938811 | -122.42484281995701 | (37.7375873393881, -122.424842819957) | ||||
| 88589 | 88589 | 114269 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 800x BROTHERHOOD WAY | 10 | Front Yard : Yard 7 | Tree 1 | Private 1 | 38 | 5990271.0 | 2088582.0 | 37.7142888575797 | -122.475533361779 | (37.7142888575797, -122.475533361779) |
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");