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) | |||||
| 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) | |||||
| 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) | ||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | ||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 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) | |||||
| 24493 | 24493 | 190983 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 20 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 6016115.94828 | 2100251.3725900003 | 37.7477949890666 | -122.387015672733 | (37.7477949890666, -122.387015672733) | ||||
| 24654 | 24654 | 190986 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 16 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6016149.69105 | 2100259.24355 | 37.747818469462 | -122.38689953970601 | (37.747818469462, -122.386899539706) | ||||
| 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) | ||||
| 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) | |||
| 30126 | 30126 | 223714 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 82 | Front Yard : Yard 7 | Tree 1 | Private 1 | 34 | 6004606.42672 | 2096213.68372 | 37.736064383369396 | -122.42652758019699 | (37.7360643833694, -122.426527580197) | ||||
| 31803 | 31803 | 223794 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 701 Church St | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 21 | Width 3ft | 6004330.71364 | 2104618.42618 | 37.7591262696742 | -122.42807959421002 | (37.7591262696742, -122.42807959421) | |||
| 31808 | 31808 | 217840 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Cranleigh Dr | 30 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 5991415.56175 | 2095863.71205 | 37.7343489175724 | -122.47210779175501 | (37.7343489175724, -122.472107791755) | ||||
| 33033 | 33033 | 223700 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 37 | Front Yard : Yard 7 | Tree 1 | Private 1 | 32 | 6004786.16622 | 2096652.60405 | 37.7372797190785 | -122.42593738210199 | (37.7372797190785, -122.425937382102) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 35718 | 35718 | 223696 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1001 San Jose Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 23 | 6005111.39586 | 2096784.72517 | 37.7376608688401 | -122.42482230911999 | (37.7376608688401, -122.42482230912) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | |||
| 46888 | 46888 | 223710 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 13 | Front Yard : Yard 7 | Tree 1 | Private 1 | 67 | 6004258.36813 | 2095937.1689 | 37.735285453551604 | -122.427711264267 | (37.7352854535516, -122.427711264267) | ||||
| 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) | |||
| 47893 | 47893 | 223716 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1101 San Jose Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004761.80581 | 2096370.25265 | 37.7365030690611 | -122.42600151366399 | (37.7365030690611, -122.426001513664) | ||||
| 49562 | 49562 | 223703 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 77 | Front Yard : Yard 7 | Tree 1 | Private 1 | 18 | 6004573.37155 | 2096423.41392 | 37.7366383864359 | -122.426656795699 | (37.7366383864359, -122.426656795699) | ||||
| 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) | |||
| 53546 | 53546 | 223712 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 75 | Front Yard : Yard 7 | Tree 1 | Private 1 | 59 | 6004557.86024 | 2096180.22234 | 37.7359697602838 | -122.426693112116 | (37.7359697602838, -122.426693112116) | ||||
| 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) | ||||
| 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) | |||
| 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) | ||||
| 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) | |||
| 60460 | 60460 | 217838 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Cranleigh Dr | 28 | Front Yard : Yard 7 | Tree 1 | Private 1 | 1 | 5991394.82586 | 2095823.8530599999 | 37.7342382748577 | -122.47217657729799 | (37.7342382748577, -122.472176577298) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 76851 | 76851 | 190981 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 24 | Front Yard : Yard 7 | Tree 1 | Private 1 | 17 | 6016079.678669999 | 2100249.91321 | 37.7477889734994 | -122.38714099058998 | (37.7477889734994, -122.38714099059) | ||||
| 77269 | 77269 | 223713 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 81 | Front Yard : Yard 7 | Tree 1 | Private 1 | 52 | 6004590.4575 | 2096203.6023099998 | 37.7360357993049 | -122.426582074619 | (37.7360357993049, -122.426582074619) | ||||
| 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) | |||||
| 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) | ||||
| 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) | |||
| 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) | ||||||
| 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) | ||||
| 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) | |||
| 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) | |||||
| 102194 | 102194 | 101037 | DPW Maintained 3 | Cupressus macrocarpa :: Monterey Cypress 47 | 1010X Portola Dr | 11 | Front Yard : Yard 7 | Tree 1 | DPW 2 | 5995923.3 | 2098391.5 | 37.7415494342357 | -122.45670592621 | (37.7415494342357, -122.45670592621) | |||||
| 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) | ||||
| 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) | ||||
| 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) | |||||
| 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) | |||
| 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) | ||||
| 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) | ||||
| 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) | ||||||
| 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) | |||
| 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) | |||||
| 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) | |||
| 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) | |||
| 131336 | 131336 | 223709 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1201 San Jose Ave | 12 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 6004249.02504 | 2095933.99045 | 37.7352761977326 | -122.42774334037901 | (37.7352761977326, -122.427743340379) | ||||
| 131402 | 131402 | 190979 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Tulare St | 26 | Front Yard : Yard 7 | Tree 1 | Private 1 | 10 | 6016095.64833 | 2100226.2738200002 | 37.747724948962606 | -122.387084119257 | (37.7477249489626, -122.387084119257) | ||||
| 131626 | 131626 | 206850 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 2 Cranleigh Dr | 11 | Front Yard : Yard 7 | Tree 1 | Private 1 | 13 | Width 0ft | 5991355.50473 | 2095693.7152900002 | 37.733878673758504 | -122.472303038149 | (37.7338786737585, -122.472303038149) | |||
| 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) | ||||
| 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) | |||
| 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) | |||
| 135900 | 135900 | 223793 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 701 Church St | 29 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | Width 3ft | 6004332.42346 | 2104590.86919 | 37.7590507014501 | -122.428071717046 | (37.7590507014501, -122.428071717046) | |||
| 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) | ||||
| 137317 | 137317 | 223704 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1100 San Jose Ave | 78 | Front Yard : Yard 7 | Tree 1 | Private 1 | 40 | 6004560.21701 | 2096406.8969299998 | 37.7365922907993 | -122.426701100777 | (37.7365922907993, -122.426701100777) | ||||
| 137779 | 137779 | 223717 | Undocumented 2 | Cupressus macrocarpa :: Monterey Cypress 47 | 1101 San Jose Ave | 58 | Front Yard : Yard 7 | Tree 1 | Private 1 | 55 | 6005027.45143 | 2096662.24212 | 37.737319816266705 | -122.425103832873 | (37.7373198162667, -122.425103832873) | ||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 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) |
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");