trees
2,365 rows where qSpecies_id = 31 sorted by SiteOrder
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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17974 | 7452 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2567 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008279.66518 | 2103491.16877 | 37.7562537082641 | -122.414342431978 | (37.7562537082641, -122.414342431978) | 2 | 4 | 7 | 28859 | 19 | |||
| 17980 | 180512 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1027 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6004254.69534 | 2090025.204 | 37.7190523030053 | -122.427302962162 | (37.7190523030053, -122.427302962162) | 9 | 7 | 6 | 28861 | 5 | |||
| 18136 | 112514 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1014 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 5992342.97239 | 2113476.2606 | 37.7827619817135 | -122.47018356399 | (37.7827619817135, -122.47018356399) | 11 | 6 | 2 | 54 | 11 | |||
| 18278 | 242639 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 546 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6007844.9141 | 2104767.39545 | 37.7597335027307 | -122.415936326515 | (37.7597335027307, -122.415936326515) | 2 | 4 | 7 | 28859 | 19 | |||
| 18373 | 259350 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 201x Goettingen St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | FUF | 04/27/2019 12:00:00 AM | 3 | ||||||||||||
| 18401 | 146496 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3570 Pierce St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 0 | Width 4ft | 6001206.87483 | 2120871.25234 | 37.8035751557371 | -122.440048709094 | (37.8035751557371, -122.440048709094) | 13 | 9 | 1 | 57 | 17 | |||
| 18715 | 17618 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1049X Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 6004182.5788866 | 2090079.2106526 | 37.7191965146646 | -122.427556086461 | (37.7191965146646, -122.427556086461) | 9 | 7 | 6 | 28861 | 5 | |||
| 18804 | 85789 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1157 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 8 | 3x3 | 6009966.4934 | 2110538.8397 | 37.7756996123582 | -122.409006027185 | (37.7756996123582, -122.409006027185) | 8 | 2 | 9 | 28853 | 34 | ||
| 18889 | 242437 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 155 Day St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6004941.65866 | 2098698.95529 | 37.7429073221216 | -122.425545367634 | (37.7429073221216, -122.425545367634) | 2 | 7 | 5 | 63 | 22 | |||
| 19169 | 34703 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 591 46th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/21/2008 12:00:00 AM | 4 | 3x3 | Permit Number 50359 | 5981606.78939 | 2111740.24587 | 37.777368864087 | -122.507196740825 | (37.777368864087, -122.507196740825) | 11 | 6 | 2 | 55 | 26 | |
| 19592 | 23636 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 112 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 4x4 | 6006546.53068 | 2098501.49483 | 37.7424556897773 | -122.419982145278 | (37.7424556897773, -122.419982145278) | 2 | 7 | 7 | 28859 | 2 | |||
| 19733 | 215491 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 45 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | Width 6ft | 5993998.37881 | 2097545.6525 | 37.7391162363258 | -122.463300232728 | (37.7391162363258, -122.463300232728) | 1 | 8 | 4 | 59 | 40 | |||
| 19934 | 123687 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 24 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5995428.99259 | 2113586.04452 | 37.7832413460359 | -122.459515263281 | (37.7832413460359, -122.459515263281) | 11 | 6 | 2 | 54 | 11 | |||
| 19935 | 242560 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2331 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6008202.94857 | 2104853.89142 | 37.7599911234086 | -122.414704179747 | (37.7599911234086, -122.414704179747) | 2 | 4 | 7 | 28859 | 19 | |||
| 20097 | 57068 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 918 Minnesota St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/22/1974 12:00:00 AM | 15 | 6x7 | Permit Number 14334 | 6015212.77238 | 2104346.74514 | 37.7589899621477 | -122.390424942382 | (37.7589899621477, -122.390424942382) | 10 | 3 | 8 | 28856 | 29 | |
| 20199 | 46505 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 165 08th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2002 12:00:00 AM | Permit Number 44676 | 6009030.30482136 | 2110979.07994252 | 37.7768559207247 | -122.412275670972 | (37.7768559207247, -122.412275670972) | 8 | 2 | 9 | 28853 | 34 | |||
| 20447 | 198509 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 361 Texas St | 1 | : | Tree | Private 2 | 16 | Width 4ft | 6013800.26675 | 2105409.79767 | 37.7618304159729 | -122.395384559572 | (37.7618304159729, -122.395384559572) | 10 | 3 | 8 | 28856 | 29 | |||
| 20556 | 18546 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1700X Quesada Ave | 1 | Median : Cutout | Tree | DPW 1 | 9 | 19 | 6014682.66084 | 2095048.92479 | 37.7334306737717 | -122.391608273909 | (37.7334306737717, -122.391608273909) | 10 | 3 | 8 | 58 | 1 | |||
| 20688 | 242726 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 66 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6003143.88793 | 2107880.88822 | 37.7680169827249 | -122.432417216901 | (37.7680169827249, -122.432417216901) | 15 | 5 | 5 | 28862 | 3 | |||
| 20748 | 18055 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2872 Pine St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6000192.328 | 2114789.41 | 37.7868182138227 | -122.443122531996 | (37.7868182138227, -122.443122531996) | 13 | 6 | 1 | 29490 | 27 | |||
| 20814 | 242748 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 4096 17th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6001694.23867 | 2105873.65626 | 37.7624233084181 | -122.437287644716 | (37.7624233084181, -122.437287644716) | 15 | 5 | 5 | 28862 | 3 | |||
| 20821 | 85762 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1246 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 3 | 3x3 | 6009446.0112 | 2110126.3604 | 37.7745378709641 | -122.410777374473 | (37.7745378709641, -122.410777374473) | 8 | 2 | 9 | 28853 | 34 | ||
| 21205 | 215567 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 254 Santa Paula Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | Width 4ft | 5993893.11792 | 2096318.45791 | 37.735740600456 | -122.463575134792 | (37.735740600456, -122.463575134792) | 9 | 8 | 4 | 59 | 40 | |||
| 21714 | 242719 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 853 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004377.23368 | 2103892.56966 | 37.7571358712273 | -122.427866984578 | (37.7571358712273, -122.427866984578) | 2 | 4 | 5 | 28862 | 3 | |||
| 22037 | 242534 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2360 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008152.44131 | 2104693.50741 | 37.7595479078416 | -122.414867509238 | (37.7595479078416, -122.414867509238) | 2 | 4 | 7 | 28859 | 19 | |||
| 22234 | 242677 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3933 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6003560.02812 | 2102420.4138 | 37.753047415608 | -122.430588150548 | (37.753047415608, -122.430588150548) | 2 | 4 | 5 | 28862 | 22 | |||
| 22413 | 242733 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 177 Corbett Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 2ft | 6000262.66947 | 2105618.74767 | 37.7616419072768 | -122.442220599714 | (37.7616419072768, -122.442220599714) | 15 | 5 | 5 | 28862 | 3 | |||
| 22837 | 215572 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 745 Detroit St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 5999421.36042 | 2095348.4772 | 37.7333942440298 | -122.44439222862 | (37.7333942440298, -122.44439222862) | 9 | 7 | 4 | 59 | 40 | |||
| 22843 | 55859 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 206 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/25/2011 12:00:00 AM | 3x3 | Permit Number 56866 | 6005405.07087572 | 2102495.68659096 | 37.7533584481258 | -122.424212980631 | (37.7533584481258, -122.424212980631) | 2 | 4 | 5 | 28859 | 19 | ||
| 23291 | 41906 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 60 Walter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/20/2000 12:00:00 AM | Permit Number 42269 | 6003134.36765804 | 2107953.23072837 | 37.7682150777502 | -122.432455314129 | (37.7682150777502, -122.432455314129) | 15 | 5 | 5 | 28862 | 3 | ||
| 23318 | 112503 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 645 Clement St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | 5993489.26776 | 2113460.89025 | 37.7827859823771 | -122.46621678157 | (37.7827859823771, -122.46621678157) | 11 | 6 | 2 | 54 | 11 | |||
| 23349 | 242769 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 922 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6002452.60513 | 2102826.48579 | 37.7540995936313 | -122.43444686085 | (37.7540995936313, -122.43444686085) | 2 | 4 | 5 | 28862 | 22 | |||
| 23356 | 258198 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1918 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Width 0ft | 6003441 | 2115348 | 37.7885366590719 | -122.431922793308 | (37.7885366590719, -122.431922793308) | 13 | 9 | 1 | 29490 | 27 | ||||
| 23472 | 242575 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2019 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6008104.80442 | 2106706.37062 | 37.7650720888176 | -122.415174745544 | (37.7650720888176, -122.415174745544) | 8 | 4 | 7 | 28859 | 19 | |||
| 23560 | 198505 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 743 Rhode Island St | 1 | : | Tree | Private 2 | 11 | Width 3ft | 6011863.14571 | 2104907.21276 | 37.7603425002176 | -122.402048998175 | (37.7603425002176, -122.402048998175) | 10 | 3 | 8 | 28856 | 29 | |||
| 23618 | 112386 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 2200 LYON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999398 | 2116386 | 37.7911567075357 | -122.445985588475 | (37.7911567075357, -122.445985588475) | 13 | 6 | 1 | 29490 | 27 | ||||
| 23639 | 7466 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2601 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3X3 | 6008295.31777 | 2103224.31145 | 37.7555218579731 | -122.41426941961 | (37.7555218579731, -122.41426941961) | 2 | 4 | 7 | 28859 | 19 | |||
| 23746 | 7561 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2921 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 4X4 | 6008393.48132 | 2101389.94596 | 37.7504906178693 | -122.413800190239 | (37.7504906178693, -122.413800190239) | 2 | 4 | 7 | 28859 | 19 | |||
| 24025 | 242641 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 262 Shotwell St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007759.04259 | 2106432.24164 | 37.764299956994 | -122.416351235928 | (37.764299956994, -122.416351235928) | 8 | 4 | 7 | 28859 | 19 | |||
| 24270 | 242668 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3956 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6003431.93143 | 2102453.4748 | 37.7531309356663 | -122.431033493027 | (37.7531309356663, -122.431033493027) | 2 | 4 | 5 | 28862 | 22 | |||
| 24576 | 248409 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 120 Belvedere St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998272.8596 | 2108056.6857 | 37.7682222644528 | -122.449278164682 | (37.7682222644528, -122.449278164682) | 15 | 5 | 11 | 29492 | 9 | |||
| 24615 | 242404 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2868 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6010188.91419 | 2101663.03935 | 37.7513411372819 | -122.407610671899 | (37.7513411372819, -122.407610671899) | 2 | 4 | 7 | 28859 | 19 | |||
| 24697 | 91031 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1051X Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/18/2008 12:00:00 AM | 3 | 3x3 | 6010606.148 | 2111149.8835 | 37.7774132075868 | -122.406836366848 | (37.7774132075868, -122.406836366848) | 14 | 2 | 9 | 28853 | 34 | ||
| 24709 | 123166 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 579 10th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 5992807.48236 | 2111535.86844 | 37.7774610360275 | -122.468435352622 | (37.7774610360275, -122.468435352622) | 11 | 6 | 2 | 54 | 11 | ||||
| 24769 | 198491 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 907 Minnesota St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 1 | Width 6ft | 6015266.77203 | 2104421.22514 | 37.7591974636091 | -122.390243388116 | (37.7591974636091, -122.390243388116) | 10 | 3 | 8 | 28856 | 29 | |||
| 25001 | 242526 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1922 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/2007 12:00:00 AM | 7 | Width 2ft | 6008013.77103 | 2107241.1183 | 37.7665352651235 | -122.415527471335 | (37.7665352651235, -122.415527471335) | 8 | 4 | 7 | 28853 | 19 | ||
| 25061 | 104771 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 928 CASTRO ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | 3x3 | 6002435.2 | 2102798.9 | 37.7540228616298 | -122.434505079683 | (37.7540228616298, -122.434505079683) | 2 | 4 | 5 | 28862 | 22 | |||
| 25246 | 242379 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1217 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6011152.0776 | 2102554.59258 | 37.7538430143636 | -122.40434267049 | (37.7538430143636, -122.40434267049) | 10 | 4 | 8 | 28859 | 19 | |||
| 25389 | 215519 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1800 10th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5993153.53472 | 2103109.22386 | 37.7543436777209 | -122.466625589315 | (37.7543436777209, -122.466625589315) | 1 | 8 | 4 | 56 | 12 | |||
| 25402 | 242705 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 622 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6002352.40846 | 2104549.28931 | 37.7588243106064 | -122.434916564156 | (37.7588243106064, -122.434916564156) | 2 | 4 | 5 | 28862 | 3 | |||
| 25513 | 17523 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 309 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6002491.854148 | 2091141.7505443 | 37.7220182361725 | -122.433476163825 | (37.7220182361725, -122.433476163825) | 9 | 7 | 6 | 28861 | 5 | |||
| 25624 | 138666 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2721 PINE ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 0ft | 6000819.0242 | 2114826.1264 | 37.7869547408882 | -122.440956950105 | (37.7869547408882, -122.440956950105) | 13 | 6 | 1 | 29490 | 27 | |||
| 25646 | 7497 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2700 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 3X3 | 6008270.16145 | 2102659.31707 | 37.753969098407 | -122.414316444274 | (37.753969098407, -122.414316444274) | 2 | 4 | 7 | 28859 | 19 | |||
| 25685 | 242513 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2948 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6008340.21249 | 2101308.02712 | 37.7502626954836 | -122.413978604037 | (37.7502626954836, -122.413978604037) | 2 | 4 | 7 | 28859 | 19 | |||
| 25694 | 242395 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1772 15th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 4ft | 6005651.81735 | 2107273.82605 | 37.7664920266105 | -122.423699384137 | (37.7664920266105, -122.423699384137) | 8 | 4 | 5 | 28853 | 19 | |||
| 25715 | 242409 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 214 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6005416.645 | 2102345.79668 | 37.7529475387091 | -122.424162295755 | (37.7529475387091, -122.424162295755) | 2 | 4 | 5 | 28859 | 19 | |||
| 25809 | 242477 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2831 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6008363.71798 | 2101936.55898 | 37.7519898227944 | -122.413941777714 | (37.7519898227944, -122.413941777714) | 2 | 4 | 7 | 28859 | 19 | |||
| 25820 | 25189 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3733 Market St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3x3 | 6000311.6199976 | 2102932.6354717 | 37.7542692908961 | -122.441858505139 | (37.7542692908961, -122.441858505139) | 2 | 4 | 5 | 63 | 38 | |||
| 25912 | 215526 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 478 Dewey Blvd | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 3ft | 5994752.10675 | 2100066.65325 | 37.7460816699447 | -122.460876862898 | (37.7460816699447, -122.460876862898) | 1 | 8 | 4 | 29491 | 40 | |||
| 26005 | 137018 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2716 Pacific Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 4ft | 6001024.79883 | 2116912.49705 | 37.7926950910553 | -122.440394705264 | (37.7926950910553, -122.440394705264) | 13 | 6 | 1 | 29490 | 27 | |||
| 26514 | 17556 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 626 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3X3 | 6003246.79786 | 2090613.71944 | 37.7206111833437 | -122.430828848684 | (37.7206111833437, -122.430828848684) | 9 | 7 | 6 | 28861 | 5 | |||
| 26544 | 50045 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 3928 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 07/28/2003 12:00:00 AM | 3x3 | Permit Number 46776 | 6003593.46976323 | 2102471.5753466 | 37.753189787602 | -122.430476153053 | (37.753189787602, -122.430476153053) | 2 | 4 | 5 | 28862 | 22 | |
| 26567 | 110786 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 410 PACIFIC AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6012080 | 2118442 | 37.7975180016372 | -122.402250623365 | (37.7975180016372, -122.402250623365) | 3 | 1 | 10 | 308 | 23 | ||||
| 26629 | 7553 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2896 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 2 | 3X3 | 6008325.6957 | 2101595.54831 | 37.751051348746 | -122.41404914235 | (37.751051348746, -122.41404914235) | 2 | 4 | 7 | 28859 | 19 | |||
| 26663 | 85795 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 985 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/07/2007 12:00:00 AM | 12 | 3x3 | 6011121.9774 | 2111644.9134 | 37.7788012938106 | -122.405086799447 | (37.7788012938106, -122.405086799447) | 14 | 2 | 9 | 28856 | 34 | ||
| 26707 | 242697 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 264 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6001741.09826 | 2104301.70162 | 37.7581097668584 | -122.437013028641 | (37.7581097668584, -122.437013028641) | 2 | 4 | 5 | 28862 | 3 | |||
| 26729 | 7657 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3334 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6008459.10706 | 2099217.21001 | 37.7445284544392 | -122.413419609751 | (37.7445284544392, -122.413419609751) | 2 | 7 | 7 | 28859 | 2 | |||
| 26830 | 97057 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 227 Sanchez St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6003560 | 2106944 | 37.7654681015181 | -122.430911059584 | (37.7654681015181, -122.430911059584) | 8 | 4 | 5 | 28862 | 3 | |||
| 26832 | 7543 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2872 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 3 | 3x3 | 6008316.06064 | 2101754.32335 | 37.7514867681181 | -122.414093692993 | (37.7514867681181, -122.414093692993) | 2 | 4 | 7 | 28859 | 19 | |||
| 26914 | 242771 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 930 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002454.1308 | 2102779.02186 | 37.7539693556059 | -122.434438191367 | (37.7539693556059, -122.434438191367) | 2 | 4 | 5 | 28862 | 22 | |||
| 26996 | 242532 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2140 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/21/2007 12:00:00 AM | 7 | Width 3ft | 6008084.96302 | 2105937.52751 | 37.7629599086871 | -122.41518894402 | (37.7629599086871, -122.41518894402) | 8 | 4 | 7 | 28859 | 19 | ||
| 27279 | 7440 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2528 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6008209.2972 | 2103689.65921 | 37.7567947646774 | -122.414599835016 | (37.7567947646774, -122.414599835016) | 2 | 4 | 7 | 28859 | 19 | |||
| 27643 | 7457 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2577 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 60 | 3X3 | 6008281.25133 | 2103428.77827 | 37.7560824872415 | -122.414332532234 | (37.7560824872415, -122.414332532234) | 2 | 4 | 7 | 28859 | 19 | |||
| 27895 | 23744 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1111X McAllister St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6003857.72301 | 2111778.219 | 37.7787585493448 | -122.430226218205 | (37.7787585493448, -122.430226218205) | 15 | 9 | 11 | 29492 | 41 | |||
| 27897 | 242493 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2500 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6008201.36551 | 2103826.65132 | 37.7571704681572 | -122.414636959936 | (37.7571704681572, -122.414636959936) | 2 | 4 | 7 | 28859 | 19 | |||
| 27901 | 7664 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3348 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6008462.72403 | 2099121.09112 | 37.7442647363292 | -122.413400306703 | (37.7442647363292, -122.413400306703) | 2 | 7 | 7 | 28859 | 2 | |||
| 27935 | 253392 | Planning Code 138.1 required 2 | Ulmus parvifolia :: Chinese Elm 31 | 115 Steuart St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/30/2017 12:00:00 AM | 3 | 3x3 | Permit Number 771767 | 6014754.16338 | 2116767.09226 | 37.7930680031541 | -122.392879995147 | (37.7930680031541, -122.392879995147) | 12 | 2 | 9 | 28855 | 6 | |
| 28436 | 17602 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 912 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 45 | 3X3 | 6003897.46129 | 2090203.63126 | 37.7195220153206 | -122.428550493605 | (37.7195220153206, -122.428550493605) | 9 | 7 | 6 | 28861 | 5 | |||
| 28588 | 17551 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 601 Persia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6003191.74591 | 2090695.76954 | 37.7208333554501 | -122.431024998907 | (37.7208333554501, -122.431024998907) | 9 | 7 | 6 | 28861 | 5 | |||
| 28726 | 242418 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 299 Fair Oaks St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6005476.19264 | 2102018.01843 | 37.7520508975422 | -122.423933062164 | (37.7520508975422, -122.423933062164) | 2 | 4 | 5 | 28859 | 19 | |||
| 28774 | 242588 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 660 Elizabeth St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6002106.32831 | 2102091.37064 | 37.7520614807656 | -122.435591781438 | (37.7520614807656, -122.435591781438) | 2 | 4 | 5 | 28862 | 22 | |||
| 28840 | 137884 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1928 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003417.2048 | 2115384.0895 | 37.7886344027041 | -122.432007699107 | (37.7886344027041, -122.432007699107) | 13 | 9 | 1 | 29490 | 27 | |||
| 28907 | 113443 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 742 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 5994762.07163 | 2110522.43311 | 37.7747911175465 | -122.461600336607 | (37.7747911175465, -122.461600336607) | 11 | 6 | 2 | 54 | 11 | |||
| 28962 | 136999 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2452 Jackson St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 5ft | 6002307.2495 | 2116764.38372 | 37.7923613472576 | -122.435946778048 | (37.7923613472576, -122.435946778048) | 13 | 9 | 1 | 29490 | 27 | |||
| 29010 | 141480 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2210 GOLDEN GATE AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 5998945.488 | 2111497.8751 | 37.7777093428916 | -122.447199310957 | (37.7777093428916, -122.447199310957) | 15 | 6 | 2 | 54 | 16 | |||
| 29074 | 109434 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 7 DANVERS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999816.1 | 2105451.8 | 37.7611580492101 | -122.443753102957 | (37.7611580492101, -122.443753102957) | 15 | 5 | 5 | 28862 | 3 | ||||
| 29302 | 7646 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3301 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 3x3 | 6008513.44624 | 2099397.67081 | 37.745027010685 | -122.413244473962 | (37.745027010685, -122.413244473962) | 2 | 7 | 7 | 28859 | 2 | |||
| 29360 | 201851 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1119 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6010210.791 | 2110772.6508 | 37.7763552850367 | -122.408177430978 | (37.7763552850367, -122.408177430978) | 8 | 2 | 9 | 28853 | 34 | |||
| 29404 | 23635 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 108 Virginia Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 5x5 | 6006522.04559 | 2098512.21616 | 37.742483748623 | -122.420067568263 | (37.742483748623, -122.420067568263) | 2 | 7 | 7 | 28859 | 2 | |||
| 29511 | 244254 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 200x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 6 | Width 0ft | 6005646.3317 | 2110018.1063 | 37.7740268522621 | -122.423913520847 | (37.7740268522621, -122.423913520847) | 7 | 9 | 11 | 28852 | 10 | |||
| 29840 | 242773 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 1514 Castro St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 5ft | 6002543.02817 | 2101051.83615 | 37.749231959098 | -122.43400730909 | (37.749231959098, -122.43400730909) | 2 | 4 | 5 | 28862 | 22 | |||
| 30064 | 242461 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 206 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006823.0502 | 2098332.30015 | 37.7420066942676 | -122.419014023301 | (37.7420066942676, -122.419014023301) | 2 | 7 | 7 | 28859 | 2 | |||
| 30137 | 52300 | Permitted Site 7 | Ulmus parvifolia :: Chinese Elm 31 | 264 Diamond St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 5 | 3x3 | Permit Number 53169 | 6001736.20846819 | 2104306.03679934 | 37.758121392277 | -122.437030249981 | (37.758121392277, -122.437030249981) | 2 | 4 | 5 | 28862 | 3 | |
| 30193 | 31614 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2146 Chestnut St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/22/1995 12:00:00 AM | 12 | Permit Number 35135 | 6001571.0697 | 2119772.3198 | 37.8005785040659 | -122.43870960599 | (37.8005785040659, -122.43870960599) | 13 | 9 | 1 | 57 | 17 | ||
| 30219 | 7647 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 3302 Folsom St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4X4 | 6008452.78429 | 2099390.30637 | 37.7450033836799 | -122.413453712108 | (37.7450033836799, -122.413453712108) | 2 | 7 | 7 | 28859 | 2 | |||
| 30661 | 242456 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 145 Delmar St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5999380.76435 | 2107349.43867 | 37.7663436510568 | -122.445395186755 | (37.7663436510568, -122.445395186755) | 15 | 5 | 5 | 29492 | 9 | |||
| 30695 | 255050 | Undocumented 4 | Ulmus parvifolia :: Chinese Elm 31 | 199x 09th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6008753 | 2110574 | 37.7757281025158 | -122.413206304146 | (37.7757281025158, -122.413206304146) | 8 | 2 | 9 | 28853 | 34 | ||||
| 30944 | 180566 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 111 Ney St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6004117.41747 | 2094047.56106 | 37.7300890412712 | -122.428063967571 | (37.7300890412712, -122.428063967571) | 9 | 7 | 6 | 28861 | 5 | |||
| 31630 | 109498 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 2440 23rd Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | 3x3 | 5989239.6228 | 2098735.6386 | 37.7421083236068 | -122.479840718717 | (37.7421083236068, -122.479840718717) | 1 | 8 | 3 | 29491 | 35 | |||
| 32217 | 242427 | DPW Maintained 1 | Ulmus parvifolia :: Chinese Elm 31 | 301 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 2ft | 6005044.68577 | 2109860.00586 | 37.77355876256 | -122.425983461566 | (37.77355876256, -122.425983461566) | 7 | 9 | 11 | 28852 | 10 |
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) );