trees
2,365 rows where 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 | |||
| 193847 | 7630 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3255 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3x3 | 6008486.33548 | 2099778.1775 | 37.7460702755308 | -122.413365122515 | (37.7460702755308, -122.413365122515) | 2 | 7 | 7 | 28859 | 2 | |||
| 193536 | 99816 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 660-662 Elizabeth St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | Most likely permitted for planting at same time as tree no. 1 | 6002127 | 2102089 | 37.7520561456392 | -122.435520126196 | (37.7520561456392, -122.435520126196) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 193091 | 100624 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Folsom St | 11 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011458.7 | 2112074.6 | 37.7799999312698 | -122.403952182873 | (37.7799999312698, -122.403952182873) | 14 | 2 | 9 | 28853 | 34 | |||||
| 193067 | 198624 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 13 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015725.44924 | 2108619.45871 | 37.7707503353808 | -122.388950156737 | (37.7707503353808, -122.388950156737) | 14 | 3 | 9 | 310 | 20 | ||||
| 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 | |||
| 192867 | 200938 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1470 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 0ft | 6008510.5042 | 2109241.2256 | 37.7720550012629 | -122.41395085769 | (37.7720550012629, -122.41395085769) | 8 | 2 | 9 | 28853 | 34 | |||
| 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 | |||
| 192802 | 198660 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1670 Owen St | 15 | Sidewalk: Property side : Yard | Tree | Private 2 | 3 | Width 8ft | 6013952.39137 | 2107385.97936 | 37.7672650361872 | -122.394996834841 | (37.7672650361872, -122.394996834841) | 14 | 3 | 9 | 310 | 20 | |||
| 192783 | 119714 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 102x Octavia St Frontage East | 7 | Median : Cutout | Tree | DPW 1 | 2109802 | 6005691 | 47.2701255040516 | -138.282046982267 | (47.2701255040516, -138.282046982267) | ||||||||||
| 192768 | 17485 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 220X Persia Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 40 | 3X3 | 6002262.8923189 | 2091226.588151 | 37.7222381881928 | -122.434273689054 | (37.7222381881928, -122.434273689054) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 192321 | 242417 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3652 24th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6005352.57915 | 2101976.52488 | 37.7519299863868 | -122.424357585351 | (37.7519299863868, -122.424357585351) | 2 | 4 | 5 | 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 | |||
| 192053 | 215563 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 244 Santa Paula Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993985.88408 | 2096348.37502 | 37.7358280900889 | -122.463256578734 | (37.7358280900889, -122.463256578734) | 9 | 8 | 4 | 59 | 40 | |||
| 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 | |||
| 192009 | 17568 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | 3x3 | 6003419.61693 | 2090505.67023 | 37.720324294201 | -122.430223763218 | (37.720324294201, -122.430223763218) | 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 | |||
| 191729 | 16445 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1395 Newcomb Ave | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/10/2012 12:00:00 AM | 3 | 3x3 | 6016285.996927 | 2094866.016739 | 37.7330173117391 | -122.386052291775 | (37.7330173117391, -122.386052291775) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | ||
| 191448 | 242716 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3880 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002505.00154 | 2103577.91214 | 37.7561658049102 | -122.434319380161 | (37.7561658049102, -122.434319380161) | 2 | 4 | 5 | 28862 | 3 | |||
| 191398 | 137007 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2110 Broderick St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6000409.78884 | 2115912.00692 | 37.7899129699478 | -122.442450796488 | (37.7899129699478, -122.442450796488) | 13 | 6 | 1 | 29490 | 27 | |||
| 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 | |||
| 191279 | 119748 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 191242 | 200601 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1300x Newcomb Ave | 7 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6016439.2859 | 2094833.558 | 37.7329366690371 | -122.385520065311 | (37.7329366690371, -122.385520065311) | 10 | 3 | 8 | 58 | 1 | |||
| 191150 | 119756 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 191103 | 198481 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 800 Minnesota St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 6ft | 6015200.5956 | 2104639.69489 | 37.7597936637724 | -122.390487525273 | (37.7597936637724, -122.390487525273) | 10 | 3 | 8 | 28856 | 29 | |||
| 191098 | 255052 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 199x 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008753 | 2110574 | 37.7757281025158 | -122.413206304146 | (37.7757281025158, -122.413206304146) | 8 | 2 | 9 | 28853 | 34 | ||||
| 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 | |||
| 190991 | 198460 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 700 Mariposa St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6014862.84066 | 2106274.78772 | 37.7642645317963 | -122.391769991798 | (37.7642645317963, -122.391769991798) | 14 | 3 | 9 | 310 | 29 | |||
| 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 | |||
| 190843 | 119787 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 202x Octavia St Frontage East | 7 | Median : Cutout | Tree | DPW 1 | 2110143 | 6005643 | 47.270172161735 | -138.280681481725 | (47.270172161735, -138.280681481725) | ||||||||||
| 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 | |||
| 190598 | 119757 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 2109793 | 6005627 | 47.2699510709683 | -138.28203408065 | (47.2699510709683, -138.28203408065) | ||||||||||
| 190593 | 244374 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 101x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 7 | Width 0ft | 6005614.0781 | 2109847.0914 | 37.7735554657504 | -122.424012927889 | (37.7735554657504, -122.424012927889) | 7 | 9 | 11 | 28852 | 10 | |||
| 190529 | 137028 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2057 Green St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 4ft | 6003223.22919 | 2118218.73656 | 37.7964066183283 | -122.432881414555 | (37.7964066183283, -122.432881414555) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 190372 | 137058 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 440 Pacific Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6011933.40589 | 2118423.08303 | 37.7974578763363 | -122.402756549698 | (37.7974578763363, -122.402756549698) | 3 | 1 | 10 | 308 | 23 | |||
| 190369 | 17527 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 349X Persia Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 19 | 3x3 | 6002621.9363 | 2091050.61782 | 37.7217753855301 | -122.433019994862 | (37.7217753855301, -122.433019994862) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |||
| 190245 | 37289 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 799 Castro St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/15/1998 12:00:00 AM | Permit Number 39819 | 6002464.40667382 | 2103562.84638335 | 37.7561221336837 | -122.434458693674 | (37.7561221336837, -122.434458693674) | 2 | 4 | 5 | 28862 | 3 | |||
| 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 | |
| 189918 | 31036 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 300 Bennington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/23/2015 12:00:00 AM | 2 | Permit Number 771782 | 6007053.24421 | 2096706.03657 | 37.7375542956049 | -122.418102817609 | (37.7375542956049, -122.418102817609) | 2 | 7 | 7 | 28859 | 2 | ||
| 189844 | 198625 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 14 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6015702.76358 | 2108617.6361 | 37.7707440734189 | -122.38902850026 | (37.7707440734189, -122.38902850026) | 14 | 3 | 9 | 310 | 20 | ||||
| 189843 | 119701 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 6x Octavia St Frontage West | 3 | Median : Cutout | Tree | DPW 1 | 2109337 | 6005692 | 47.2698908128932 | -138.283860688311 | (47.2698908128932, -138.283860688311) | ||||||||||
| 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 | |||
| 189573 | 198589 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 980 16th St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2018 12:00:00 AM | 3 | Width 4ft | Permit Number 775761 | 6013524.37895 | 2107133.46335 | 37.76654787361 | -122.396459576758 | (37.76654787361, -122.396459576758) | 14 | 3 | 8 | 28856 | 20 | |
| 189568 | 6037 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1822 Eddy St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/31/2008 12:00:00 AM | 3 | 3x3 | Permit Number 51912 | 6001625.9468 | 2112554.8978 | 37.7807644518495 | -122.43800243798 | (37.7807644518495, -122.43800243798) | 15 | 5 | 11 | 29490 | 41 | |
| 189386 | 137009 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3099 Washington St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 5999994.90207 | 2116065.86366 | 37.7903117635268 | -122.443897321805 | (37.7903117635268, -122.443897321805) | 13 | 6 | 1 | 29490 | 27 | |||
| 189220 | 121499 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 851 Church St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6004400 | 2103913 | 37.7571932560102 | -122.427789705541 | (37.7571932560102, -122.427789705541) | 2 | 4 | 5 | 28862 | 3 | ||||
| 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 | |||
| 189177 | 198679 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 149 Russ St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6010343.11508 | 2111575.05475 | 37.7785659071229 | -122.40777627577 | (37.7785659071229, -122.40777627577) | 14 | 2 | 9 | 28853 | 34 | |||
| 189071 | 97835 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 900 Minnesota St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6015215.2 | 2103967.9 | 37.757949869225 | -122.390390076491 | (37.757949869225, -122.390390076491) | 10 | 3 | 8 | 28856 | 29 | |||||
| 189016 | 7593 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3065 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/28/1992 12:00:00 AM | 6 | 3X3 | 6008718.17 | 2100791.65733 | 37.7488660796272 | -122.41263509881 | (37.7488660796272, -122.41263509881) | 2 | 4 | 7 | 28859 | 19 | ||
| 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 | |||
| 188844 | 198617 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 454 Mission Bay Blvd South | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6015877.04462 | 2108628.30945 | 37.7707830392222 | -122.388426398764 | (37.7707830392222, -122.388426398764) | 14 | 3 | 9 | 310 | 20 | ||||
| 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 | |||
| 188406 | 198496 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 950 Tennessee St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6015478.89402 | 2104602.20916 | 37.7597061705092 | -122.389522401658 | (37.7597061705092, -122.389522401658) | 10 | 3 | 8 | 28856 | 29 | |||
| 188402 | 180550 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200 Persia Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002268.14618 | 2091228.59703 | 37.7222440023296 | -122.434255671279 | (37.7222440023296, -122.434255671279) | 9 | 7 | 6 | 28861 | 5 | |||
| 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 | |
| 188233 | 109165 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 51x OCTAVIA ST | 4 | Median : Cutout | Tree | DPW 1 | 3x20 | 6005650.4 | 2109419.7 | 37.772384002649 | -122.423856888434 | (37.772384002649, -122.423856888434) | 7 | 9 | 11 | 28852 | 10 | ||||
| 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 | |||
| 188111 | 97225 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1301X Newcomb Ave | 5 | Median : Cutout | Tree | DPW 1 | 09/30/2011 12:00:00 AM | 3 | 15x200 | 6016649.85073 | 2094946.91351 | 37.7332595687675 | -122.384799975236 | (37.7332595687675, -122.384799975236) | 10 | 3 | 8 | 58 | 1 | ||
| 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 | |||
| 187931 | 123996 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 57 06th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993927.17847 | 2115159.11926 | 37.7874741131307 | -122.464825173506 | (37.7874741131307, -122.464825173506) | 11 | 6 | 1 | 54 | 11 | |||
| 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 | |||
| 187670 | 142236 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 689 HAYES ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6004695.4808 | 2110855.1353 | 37.77627140325 | -122.427262313822 | (37.77627140325, -122.427262313822) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | ||
| 187365 | 16666 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 221 Noe St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/04/2011 12:00:00 AM | 3 | 3x3 | 6002922.68979 | 2106990.55693 | 37.7655598046678 | -122.433118695273 | (37.7655598046678, -122.433118695273) | 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 | ||
| 187315 | 242512 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2850 Folsom St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008312.76593 | 2101820.67254 | 37.751668763001 | -122.414109780052 | (37.751668763001, -122.414109780052) | 2 | 4 | 7 | 28859 | 19 |
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) );