trees
1,196 rows where SiteOrder = 1 and qSpecies_id = 31 sorted by rowid descending
This data as json, CSV (advanced)
| rowid ▲ | TreeID | qLegalStatus_id | qSpecies_id | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker_id | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location | Fire Prevention Districts | Police Districts | Supervisor Districts | Zip Codes | Neighborhoods (old) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 194091 | 2632 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 1884 Bush St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004471.16425 | 2115036.06465 | 37.7877385090069 | -122.428336341174 | (37.7877385090069, -122.428336341174) | 13 | 9 | 11 | 28858 | 27 | |||
| 193971 | 242595 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1328 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6003227.3356 | 2100480.54153 | 37.7477021295503 | -122.431600182828 | (37.7477021295503, -122.431600182828) | 2 | 4 | 5 | 63 | 22 | |||
| 193879 | 215489 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 37 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 6ft | 5994010.31675 | 2097590.67092 | 37.7392405334333 | -122.463262222872 | (37.7392405334333, -122.463262222872) | 1 | 8 | 4 | 59 | 40 | |||
| 193109 | 180571 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 131 Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6009971.64388 | 2093913.46554 | 37.7300503209452 | -122.407815622898 | (37.7300503209452, -122.407815622898) | 10 | 3 | 7 | 309 | 28 | |||
| 193000 | 17623 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1101 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 3X3 | 6004371.84322 | 2089954.85636 | 37.718865768324 | -122.426893019707 | (37.718865768324, -122.426893019707) | 9 | 7 | 6 | 28861 | 5 | |||
| 192968 | 242540 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2428 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6008174.47034 | 2104286.92905 | 37.7584327745652 | -122.414762547558 | (37.7584327745652, -122.414762547558) | 2 | 4 | 7 | 28859 | 19 | |||
| 192817 | 242605 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1315 Clayton St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5999041.02625 | 2105175.78998 | 37.7603559558947 | -122.446413883893 | (37.7603559558947, -122.446413883893) | 15 | 5 | 5 | 28862 | 12 | |||
| 192719 | 7601 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3127 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/23/2011 12:00:00 AM | 3 | 3x3 | 6008460.24171 | 2100469.91585 | 37.7479681699401 | -122.413504265914 | (37.7479681699401, -122.413504265914) | 2 | 7 | 7 | 28859 | 2 | ||
| 192705 | 215518 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 278 Howth St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 5997249.4841 | 2090499.44451 | 37.7199557889053 | -122.451551333026 | (37.7199557889053, -122.451551333026) | 9 | 8 | 6 | 28861 | 24 | |||
| 192673 | 24651 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 399X Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6006472.6793353 | 2097605.2357322 | 37.7399906020072 | -122.420173907565 | (37.7399906020072, -122.420173907565) | 2 | 7 | 7 | 28859 | 2 | |||
| 192648 | 137003 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2009 Divisadero St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/21/2018 12:00:00 AM | 3 | Width 5ft | Permit Number 54784 | 6000925.45589 | 2115354.39726 | 37.7884112973018 | -122.44062662694 | (37.7884112973018, -122.44062662694) | 13 | 6 | 1 | 29490 | 27 | |
| 192534 | 242649 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2900 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 5ft | 6008827.11611 | 2103342.80721 | 37.755877078492 | -122.412438665223 | (37.755877078492, -122.412438665223) | 2 | 4 | 7 | 28859 | 19 | |||
| 192515 | 7505 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2722 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 3X3 | 6008270.98253 | 2102559.52462 | 37.7536951370472 | -122.414306544538 | (37.7536951370472, -122.414306544538) | 2 | 4 | 7 | 28859 | 19 | |||
| 192245 | 242392 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1758 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6005722.91625 | 2107278.54234 | 37.7665089896121 | -122.423453800862 | (37.7665089896121, -122.423453800862) | 8 | 4 | 5 | 28853 | 19 | |||
| 192192 | 242458 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 572 Moultrie St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007665.97823 | 2096689.5087 | 37.7375433823202 | -122.415983129938 | (37.7375433823202, -122.415983129938) | 2 | 7 | 7 | 28859 | 2 | |||
| 192083 | 22309 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 5033 03rd St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6014806.53085 | 2094754.47288 | 37.7326290435242 | -122.391159442188 | (37.7326290435242, -122.391159442188) | 10 | 3 | 8 | 58 | 1 | |||
| 192017 | 180525 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 701 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6003487.94744 | 2090511.72451 | 37.7203447879672 | -122.429987998761 | (37.7203447879672, -122.429987998761) | 9 | 7 | 6 | 28861 | 5 | |||
| 191837 | 7595 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3079 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008433.91036 | 2100662.40633 | 37.7484952272826 | -122.413608931409 | (37.7484952272826, -122.413608931409) | 2 | 4 | 7 | 28859 | 19 | |||
| 191739 | 201850 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 911 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6011602 | 2112119 | 37.7801298483764 | -122.403459565618 | (37.7801298483764, -122.403459565618) | 14 | 2 | 9 | 28856 | 34 | |||
| 191517 | 198669 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 160 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 4ft | 6010437.66091 | 2111395.28872 | 37.7780776040245 | -122.407436527193 | (37.7780776040245, -122.407436527193) | 14 | 2 | 9 | 28853 | 34 | |||
| 191469 | 136992 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2299 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000906.27756 | 2119628.73077 | 37.8001464049771 | -122.440999744847 | (37.8001464049771, -122.440999744847) | 13 | 9 | 1 | 57 | 17 | |||
| 191468 | 61926 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 880 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/10/1985 12:00:00 AM | 6 | Permit Number 21980 | 6011757.5002 | 2112339.2572 | 37.7807433076933 | -122.402937112534 | (37.7807433076933, -122.402937112534) | 6 | 2 | 9 | 28853 | 34 | ||
| 191306 | 87304 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 2895 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | Permit Number 50315 | 6010124.3 | 2101560.9 | 37.7510570681062 | -122.407826914654 | (37.7510570681062, -122.407826914654) | 2 | 4 | 7 | 28859 | 19 | |||
| 191001 | 7514 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2757 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008339.77996 | 2102396.45751 | 37.753251255958 | -122.414057091485 | (37.753251255958, -122.414057091485) | 2 | 4 | 7 | 28859 | 19 | |||
| 190909 | 7545 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2873 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | 3X3 | 6008374.1374 | 2101703.06598 | 37.7513492887427 | -122.413889230323 | (37.7513492887427, -122.413889230323) | 2 | 4 | 7 | 28859 | 19 | |||
| 190727 | 180562 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4101 Alemany Blvd | 1 | : | Tree | Private 2 | 12 | Width 3ft | 5991620.89043 | 2086817.03581 | 37.7095208535614 | -122.470739173794 | (37.7095208535614, -122.470739173794) | 9 | 8 | 4 | 64 | 24 | |||
| 190695 | 7460 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2585 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008283.17207 | 2103400.23243 | 37.7560042147509 | -122.414323869978 | (37.7560042147509, -122.414323869978) | 2 | 4 | 7 | 28859 | 19 | |||
| 190456 | 103270 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 350 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004879 | 2109882 | 37.7736097878739 | -122.426558160091 | (37.7736097878739, -122.426558160091) | 7 | 9 | 11 | 28852 | 10 | ||||
| 190436 | 215505 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 245 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994112.73436 | 2096460.53675 | 37.7361433654214 | -122.462826145227 | (37.7361433654214, -122.462826145227) | 9 | 8 | 4 | 59 | 40 | |||
| 190294 | 7612 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3206 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6008407.88866 | 2100124.9846 | 37.7470181258843 | -122.413660907746 | (37.7470181258843, -122.413660907746) | 2 | 7 | 7 | 28859 | 2 | |||
| 190137 | 244936 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 294 Page St | 1 | Sidewalk: Curb side : Pot | Tree | Private 2 | 16 | Width 0ft | 6005165.6636 | 2109931.2421 | 37.7737611964044 | -122.425570051796 | (37.7737611964044, -122.425570051796) | 7 | 9 | 11 | 28852 | 10 | |||
| 190115 | 85763 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1316 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 7 | 3x3 | 6009115.2013 | 2109815.2438 | 37.7736650638278 | -122.411899724934 | (37.7736650638278, -122.411899724934) | 8 | 2 | 9 | 28853 | 34 | ||
| 189978 | 57074 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 966 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 24 | 9x7.5 | Permit Number 14341 | 6015226.17172 | 2104099.64367 | 37.7583122177548 | -122.390361336011 | (37.7583122177548, -122.390361336011) | 10 | 3 | 8 | 28856 | 29 | |
| 189741 | 242375 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 130 Church St | 1 | : | Tree | Private 2 | 7 | Width 2ft | 6004079.07598 | 2108183.78189 | 37.7689016404155 | -122.429204103801 | (37.7689016404155, -122.429204103801) | 7 | 9 | 5 | 28862 | 3 | |||
| 189735 | 142897 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2007 DIVISADERO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 0ft | 6000929.1614 | 2115327.915 | 37.7883387948833 | -122.440611906276 | (37.7883387948833, -122.440611906276) | 13 | 6 | 1 | 29490 | 27 | |||
| 189690 | 198667 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 124 Russ St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 6ft | 6010302.39718 | 2111555.70743 | 37.7785105043828 | -122.407915770511 | (37.7785105043828, -122.407915770511) | 14 | 2 | 9 | 28853 | 34 | |||
| 189661 | 7628 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3255 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6008489.95741 | 2099735.13949 | 37.7459523060695 | -122.41334955525 | (37.7459523060695, -122.41334955525) | 2 | 7 | 7 | 28859 | 2 | |||
| 189621 | 198539 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1774 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 4ft | 6014319.22336 | 2096405.90013 | 37.7371364696747 | -122.392959697748 | (37.7371364696747, -122.392959697748) | 10 | 3 | 8 | 58 | 1 | |||
| 189203 | 242695 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 578 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 5ft | 6002976.51253 | 2104871.02375 | 37.7597431317598 | -122.432781108673 | (37.7597431317598, -122.432781108673) | 2 | 4 | 5 | 28862 | 3 | |||
| 188966 | 198537 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1799 Newcomb Ave | 1 | : | Tree | Private 2 | 5 | Width 3ft | 6014201.9546 | 2096422.50115 | 37.737175538008 | -122.393366313629 | (37.737175538008, -122.393366313629) | 10 | 3 | 8 | 58 | 1 | |||
| 188869 | 215535 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 56 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | Width 3ft | 5993961.10276 | 2097536.59197 | 37.739089210791 | -122.463428458058 | (37.739089210791, -122.463428458058) | 1 | 8 | 4 | 59 | 40 | |||
| 188745 | 38953 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3204 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/13/1998 12:00:00 AM | Permit Number 40748 | 6008411.48904152 | 2100134.52641769 | 37.747044527767 | -122.413649132677 | (37.747044527767, -122.413649132677) | 2 | 7 | 7 | 28859 | 2 | |||
| 188567 | 109070 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 3027 16TH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6006619.6 | 2106627.5 | 37.7647719501604 | -122.420306113631 | (37.7647719501604, -122.420306113631) | 8 | 4 | 7 | 28859 | 19 | ||||
| 188412 | 48353 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2085 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Permit Number 45762 | 6001879.23455 | 2119763.86307 | 37.8005728104329 | -122.437642626012 | (37.8005728104329, -122.437642626012) | 13 | 9 | 1 | 57 | 17 | |||
| 188398 | 48883 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1515 Baker St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/21/2002 12:00:00 AM | 4 | 5x4 | Permit Number 46089 | 6000106.0163 | 2114246.8974 | 37.7853236932557 | -122.443382166919 | (37.7853236932557, -122.443382166919) | 15 | 6 | 1 | 29490 | 31 | |
| 188171 | 242542 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2438 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008177.76087 | 2104227.05215 | 37.7582685511758 | -122.414746929933 | (37.7582685511758, -122.414746929933) | 2 | 4 | 7 | 28859 | 19 | |||
| 188083 | 198559 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1708 Newcomb Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6014669.54022 | 2096142.63764 | 37.7364330577276 | -122.391730081702 | (37.7364330577276, -122.391730081702) | 10 | 3 | 8 | 58 | 1 | |||
| 187731 | 17553 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 615 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 50 | 2X2 | 6003240.95528 | 2090665.71698 | 37.7207536260542 | -122.430852753549 | (37.7207536260542, -122.430852753549) | 9 | 7 | 6 | 28861 | 5 | |||
| 187604 | 43412 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 854 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/2008 12:00:00 AM | 3x3 | Permit Number 51843 | 6003073.74768147 | 2103234.41761238 | 37.7552549166143 | -122.432327933003 | (37.7552549166143, -122.432327933003) | 2 | 4 | 5 | 28862 | 22 | ||
| 187586 | 123153 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 506 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 5992845.37698 | 2111963.44852 | 37.7786372439018 | -122.468335378208 | (37.7786372439018, -122.468335378208) | 11 | 6 | 2 | 54 | 11 | |||
| 187572 | 7626 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3250 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6008427.33483 | 2099791.71253 | 37.7461041269002 | -122.413570096878 | (37.7461041269002, -122.413570096878) | 2 | 7 | 7 | 28859 | 2 | |||
| 187570 | 32488 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 282 States St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/2008 12:00:00 AM | 12 | 3x3 | Permit Number 50560 | 6000387.70986 | 2106807.48138 | 37.7649130014568 | -122.441873458699 | (37.7649130014568, -122.441873458699) | 15 | 5 | 5 | 28862 | 3 | |
| 187402 | 121251 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 4151 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | Permit Number 776206 | 6001358 | 2105811 | 37.762232149605 | -122.438446078367 | (37.762232149605, -122.438446078367) | 15 | 5 | 5 | 28862 | 3 | ||
| 187320 | 14864 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1399 McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 04/10/2011 12:00:00 AM | 5 | 3x3 | 6002569.68984 | 2111577.93891 | 37.7781355917554 | -122.434667698155 | (37.7781355917554, -122.434667698155) | 15 | 5 | 11 | 29492 | 41 | ||
| 186905 | 242411 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 276 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 5ft | 6005434.9057 | 2102102.80352 | 37.7522813668053 | -122.42408186761 | (37.7522813668053, -122.42408186761) | 2 | 4 | 5 | 28859 | 19 | |||
| 186652 | 28264 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1100X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6003899.2367 | 2111834.49982 | 37.7789154337837 | -122.430086622126 | (37.7789154337837, -122.430086622126) | 7 | 9 | 11 | 29490 | 41 | |||
| 186628 | 18001 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2673 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6001165.7528 | 2114873.8019 | 37.7871053873216 | -122.439760770078 | (37.7871053873216, -122.439760770078) | 13 | 6 | 1 | 29490 | 27 | |||
| 186619 | 606 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2785X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3x3 | 6008351.06015 | 2102163.79121 | 37.7526130403718 | -122.414001623984 | (37.7526130403718, -122.414001623984) | 2 | 4 | 7 | 28859 | 19 | |||
| 186422 | 35676 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 490 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/03/1998 12:00:00 AM | 8 | 4x4 | Permit Number 38982 | 6011704.38678633 | 2118401.70170081 | 37.7973863786405 | -122.403547515196 | (37.7973863786405, -122.403547515196) | 3 | 1 | 10 | 308 | 23 | |
| 186371 | 67600 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 555 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 10/06/1992 12:00:00 AM | 10 | Permit Number 31170 | 6013571.5238 | 2104494.52261 | 37.7593045458768 | -122.396111549926 | (37.7593045458768, -122.396111549926) | 10 | 3 | 8 | 28856 | 29 | |
| 186340 | 30358 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 657 Arkansas St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 14 | Permit Number 14187 | 6013035.79545 | 2104016.54587 | 37.7579623041386 | -122.397930841554 | (37.7579623041386, -122.397930841554) | 10 | 3 | 8 | 28856 | 29 | ||
| 185745 | 7506 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2728 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008274.4224 | 2102517.76202 | 37.7535806596234 | -122.41429169402 | (37.7535806596234, -122.41429169402) | 2 | 4 | 7 | 28859 | 19 | |||
| 185571 | 215478 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1283 12th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 5992361.60735 | 2106714.7447 | 37.7641977589329 | -122.4696267106 | (37.7641977589329, -122.4696267106) | 11 | 8 | 11 | 56 | 12 | |||
| 185387 | 242454 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 466 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 5998567.8134 | 2106456.95878 | 37.7638466852012 | -122.448142751394 | (37.7638466852012, -122.448142751394) | 15 | 5 | 11 | 29492 | 9 | |||
| 185255 | 242699 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4421 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6001625.17244 | 2104067.18144 | 37.7574592413801 | -122.437397156048 | (37.7574592413801, -122.437397156048) | 2 | 4 | 5 | 28862 | 3 | |||
| 185186 | 46875 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1031 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/26/2002 12:00:00 AM | 10 | 3x4 | Permit Number 44938 | 6009178.55411 | 2118013.02984 | 37.7961777714378 | -122.412260097639 | (37.7961777714378, -122.412260097639) | 3 | 1 | 10 | 308 | 21 |
| 185141 | 242525 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1916 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/2007 12:00:00 AM | 7 | Width 2ft | 6008012.49588 | 2107266.03409 | 37.7666036064 | -122.415533646066 | (37.7666036064, -122.415533646066) | 8 | 4 | 7 | 28853 | 19 | ||
| 185031 | 7522 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2801 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3X3 | 6008356.19666 | 2102043.47464 | 37.7522829666863 | -122.413975350304 | (37.7522829666863, -122.413975350304) | 2 | 4 | 7 | 28859 | 19 | |||
| 184983 | 52726 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 169 ROOSEVELT Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2006 12:00:00 AM | Permit Number 48781 | 6001418.20285712 | 2107376.9010813 | 37.7665351533118 | -122.438350049909 | (37.7665351533118, -122.438350049909) | 15 | 5 | 5 | 28862 | 3 | |||
| 184969 | 103753 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1615 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/04/2007 12:00:00 AM | 3 | 3x3 | 6008187.9193 | 2108722.8263 | 37.7706134761345 | -122.415030008645 | (37.7706134761345, -122.415030008645) | 8 | 2 | 9 | 28853 | 19 | ||
| 184925 | 46912 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 455 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 04/29/2002 12:00:00 AM | Permit Number 44969 | 5993172.81345795 | 2105910.62938376 | 37.7620367208125 | -122.466762547601 | (37.7620367208125, -122.466762547601) | 1 | 8 | 4 | 56 | 12 | ||
| 184345 | 198593 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1000 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6013352.21579 | 2107122.2943 | 37.7665076235661 | -122.397054279536 | (37.7665076235661, -122.397054279536) | 14 | 3 | 8 | 28856 | 20 | |||
| 184052 | 123587 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 62 05th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5994280.07322 | 2115179.97331 | 37.7875517125633 | -122.463605752716 | (37.7875517125633, -122.463605752716) | 11 | 6 | 1 | 54 | 11 | |||
| 183649 | 242682 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 415 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6002985.90603 | 2105797.23135 | 37.7622868075003 | -122.432814788295 | (37.7622868075003, -122.432814788295) | 15 | 4 | 5 | 28862 | 3 | |||
| 182964 | 198675 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 Russ St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 4ft | 6010435.10015 | 2111478.17829 | 37.7783050560667 | -122.407451231095 | (37.7783050560667, -122.407451231095) | 14 | 2 | 9 | 28853 | 34 | |||
| 182893 | 198513 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2216 23rd St | 1 | : | Tree | Private 2 | 14 | Width 3ft | 6011806.19785 | 2102818.97218 | 37.754605473978 | -122.402099143454 | (37.754605473978, -122.402099143454) | 10 | 3 | 8 | 28856 | 29 | |||
| 182817 | 137891 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1735 BUSH ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 6005146.5819 | 2115135.5945 | 37.7880499882125 | -122.426006611145 | (37.7880499882125, -122.426006611145) | 13 | 9 | 11 | 28858 | 27 | |||
| 182809 | 180551 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 90 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6001942.54043 | 2091434.19539 | 37.7227900428055 | -122.435395910889 | (37.7227900428055, -122.435395910889) | 9 | 7 | 6 | 28861 | 5 | |||
| 182709 | 123995 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 57 06th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5993926.48607 | 2115175.33347 | 37.7875185929993 | -122.464828746995 | (37.7875185929993, -122.464828746995) | 11 | 6 | 1 | 54 | 11 | |||
| 182519 | 85784 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1257 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/09/2015 11:19:00 AM | 3 | 3x3 | 6009427.6278 | 2110025.2513 | 37.7742592182749 | -122.410833824093 | (37.7742592182749, -122.410833824093) | 8 | 2 | 9 | 28853 | 34 | ||
| 182476 | 242663 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 369 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002749.5058 | 2101497.98954 | 37.7504687067818 | -122.433325183215 | (37.7504687067818, -122.433325183215) | 2 | 4 | 5 | 28862 | 22 | |||
| 182472 | 198463 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 707 18th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6015318.33391 | 2105764.39063 | 37.7628883667318 | -122.390158896816 | (37.7628883667318, -122.390158896816) | 14 | 3 | 8 | 28856 | 29 | |||
| 182434 | 242673 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3995 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6003206.76531 | 2102408.34794 | 37.752994266572 | -122.431808939752 | (37.752994266572, -122.431808939752) | 2 | 4 | 5 | 28862 | 22 | |||
| 182324 | 16418 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1390X Newcomb Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/21/1992 12:00:00 AM | 13 | 3x3 | 6016308.5496 | 2094919.7628 | 37.7331661358215 | -122.385978065712 | (37.7331661358215, -122.385978065712) | 10 | 3 | 8 | 58 | 1 | ||
| 182257 | 17491 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 33 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6001944.766 | 2091477.89942 | 37.7229101706379 | -122.435391342346 | (37.7229101706379, -122.435391342346) | 9 | 7 | 6 | 28861 | 5 | |||
| 181823 | 242742 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4075 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6001841.78911 | 2105834.98209 | 37.7623255053519 | -122.43677455453 | (37.7623255053519, -122.43677455453) | 15 | 5 | 5 | 28862 | 3 | |||
| 181780 | 137025 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2257 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6003076.30587 | 2117463.99371 | 37.79432595493 | -122.43333584109 | (37.79432595493, -122.43333584109) | 13 | 9 | 1 | 29490 | 27 | |||
| 181320 | 57535 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 546 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/08/1976 12:00:00 AM | 3x3 | Permit Number 16394 | 6007841.0815384 | 2104745.28982278 | 37.7596725902927 | -122.41594801607 | (37.7596725902927, -122.41594801607) | 2 | 4 | 7 | 28859 | 19 | ||
| 181114 | 7500 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2709 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008323.74727 | 2102623.75492 | 37.7538744627533 | -122.414128615438 | (37.7538744627533, -122.414128615438) | 2 | 4 | 7 | 28859 | 19 | |||
| 181096 | 242460 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 207 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6006786.17438 | 2098418.92511 | 37.7422424704181 | -122.419147671535 | (37.7422424704181, -122.419147671535) | 2 | 7 | 7 | 28859 | 2 | |||
| 180662 | 242546 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2470 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008189.20727 | 2104080.21656 | 37.7578660173281 | -122.41469695193 | (37.7578660173281, -122.41469695193) | 2 | 4 | 7 | 28859 | 19 | |||
| 180406 | 43363 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 4147 24th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/17/2000 12:00:00 AM | Permit Number 43113 | 6002235.09605777 | 2101760.99319187 | 37.7511616557639 | -122.435122856595 | (37.7511616557639, -122.435122856595) | 2 | 4 | 5 | 28862 | 22 | ||
| 180386 | 215502 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 225 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5994102.83883 | 2096543.31026 | 37.7363700710175 | -122.462866361103 | (37.7363700710175, -122.462866361103) | 9 | 8 | 4 | 59 | 40 | |||
| 180076 | 103743 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2011 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 07/11/2014 12:00:00 AM | 3 | 3x3 | 6008128.1 | 2106710.2 | 37.7650839125599 | -122.415094442696 | (37.7650839125599, -122.415094442696) | 8 | 4 | 7 | 28859 | 19 | ||
| 180002 | 258222 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 2997 Harrison St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/2019 12:00:00 AM | 3x3 | 6009042 | 2101022 | 37.7495167187784 | -122.41153156233 | (37.7495167187784, -122.41153156233) | 2 | 4 | 7 | 28859 | 19 | |||
| 179924 | 26628 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1099X Bay Shore Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 03/05/2003 12:00:00 AM | 3 | 3X3 | 6011258.58098 | 2094170.8511 | 37.7308290106415 | -122.403384596621 | (37.7308290106415, -122.403384596621) | 10 | 3 | 8 | 58 | 1 | ||
| 179706 | 17599 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 901X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 16 | 3x3 | 6003845.6513541 | 2090290.953545 | 37.7197588510105 | -122.428735803294 | (37.7197588510105, -122.428735803294) | 9 | 7 | 6 | 28861 | 5 | |||
| 179512 | 123685 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 8 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995474.7934 | 2113587.5491 | 37.7832481106245 | -122.459356920862 | (37.7832481106245, -122.459356920862) | 11 | 6 | 2 | 54 | 11 | |||
| 179498 | 106172 | Significant Tree 6 | Ulmus parvifolia :: Chinese Elm 31 | 150 CONRAD ST | 1 | Back Yard : Yard | Tree | Private 2 | 14 | 6001768.8 | 2096480 | 37.7366348009068 | -122.436357440328 | (37.7366348009068, -122.436357440328) | 2 | 7 | 5 | 63 | 7 | ||||
| 179496 | 55354 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 601 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/22/1972 12:00:00 AM | 10 | 3x3 | Permit Number 11287 | 5993641.36369 | 2113466.98214 | 37.782811483217 | -122.465691040743 | (37.782811483217, -122.465691040743) | 11 | 6 | 2 | 54 | 11 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "trees" ( [rowid] INTEGER PRIMARY KEY, [TreeID] TEXT, [qLegalStatus_id] INTEGER REFERENCES [qLegalStatus]([id]), [qSpecies_id] INTEGER, [qAddress] TEXT, [SiteOrder] TEXT, [qSiteInfo] TEXT, [PlantType] TEXT, [qCaretaker_id] INTEGER REFERENCES [qCaretaker]([id]), [qCareAssistant] TEXT, [PlantDate] TEXT, [DBH] TEXT, [PlotSize] TEXT, [PermitNotes] TEXT, [XCoord] TEXT, [YCoord] TEXT, [Latitude] TEXT, [Longitude] TEXT, [Location] TEXT, [Fire Prevention Districts] TEXT, [Police Districts] TEXT, [Supervisor Districts] TEXT, [Zip Codes] TEXT, [Neighborhoods (old)] TEXT, FOREIGN KEY(qSpecies_id) REFERENCES qSpecies(id) );