trees

2,365 rows where qSpecies_id = 31 sorted by qCareAssistant

✎ View and edit SQL

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)
19980 98857 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 149 09th St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6008572.87311 2110548.2851 37.77564738136 -122.413827590795 (37.77564738136, -122.413827590795) 8 2 9 28853 34
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
20869 198471 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 704 18th St 3 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6015348.95336 2105815.25959 37.7630297401524 -122.390056547668 (37.7630297401524, -122.390056547668) 14 3 8 28856 29
21138 198434 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 500 Mariposa St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 6ft   6015605.2539 2106298.94966 37.7643720601453 -122.389203859978 (37.7643720601453, -122.389203859978) 14 3 9 310 29
21183 254244 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 499x Benton Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6006980 2095456 37.7341178478927 -122.418267455605 (37.7341178478927, -122.418267455605) 2 7 7 28859 2
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
21307 215486 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 25 Santa Paula Ave 2 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   5994053.65956 2097702.19422 37.7395492454888 -122.463120453749 (37.7395492454888, -122.463120453749) 1 8 4 59 40
21448 215545 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 90 Santa Paula Ave 6 Sidewalk: Curb side : Yard Tree Private 2     5 Width 3ft   5993953.28384 2097231.84575 37.7382520031164 -122.463433382759 (37.7382520031164, -122.463433382759) 1 8 4 59 40
21528 242621 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3274 Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1     20 Width 3ft   6008442.97152 2099602.35151 37.7455850616153 -122.413502636934 (37.7455850616153, -122.413502636934) 2 7 7 28859 2
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
21755 13324 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 435X Persia Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     50 3X3   6002777.3722738 2090962.3160144 37.7215417439498 -122.432476389775 (37.7215417439498, -122.432476389775) 9 7 6 28861 5
22011 198661 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1670 Owen St 17 Sidewalk: Property side : Yard Tree Private 2     3 Width 8ft   6013934.2668 2107404.04412 37.7673136301584 -122.39506079103 (37.7673136301584, -122.39506079103) 14 3 9 310 20
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
22198 14869 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 1399 McAllister St 6 Sidewalk: Curb side : Cutout Tree Private 2   04/10/2011 12:00:00 AM 3 3x3   6002569.68984 2111577.93891 37.7781355917554 -122.434667698155 (37.7781355917554, -122.434667698155) 15 5 11 29492 41
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
22343 242556 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2405 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008229.8333 2104396.39289 37.7587364477383 -122.414578823255 (37.7587364477383, -122.414578823255) 2 4 7 28859 19
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
22420 102669 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 4097 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001692 2105829 37.7623005659716 -122.437292189744 (37.7623005659716, -122.437292189744) 15 5 5 28862 3
22426 93041 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 4076 17th St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   6001828 2105877 37.7624400926035 -122.43682525386 (37.7624400926035, -122.43682525386) 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
22856 180559 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 192 Dublin St 2 Sidewalk: Property side : Yard Tree Private 2     11 Width 5ft   6004156.47541 2089333.3612 37.7171470982496 -122.427593206665 (37.7171470982496, -122.427593206665) 9 7 6 28861 5
22910 75248 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 199X RUSS ST 2 Sidewalk: Curb side : Cutout Tree Private 2   09/09/1995 12:00:00 AM 2 5x5   6010421 2111456 37.7782433704481 -122.407498444933 (37.7782433704481, -122.407498444933) 14 2 9 28853 34
23251 119710 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 3 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
23263 137056 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 430 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6012005.94187 2118434.64519 37.7974936729554 -122.402506368172 (37.7974936729554, -122.402506368172) 3 1 10 308 23
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
23450 91035 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1051X Folsom St 5 Sidewalk: Curb side : Cutout Tree DPW 1   11/18/2008 12:00:00 AM 3 3x3   6010666.0508 2111208.1223 37.7775764693736 -122.406633247496 (37.7775764693736, -122.406633247496) 14 2 9 28853 34
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
23559 17486 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 220X Persia Ave 4 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
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
23716 242547 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2470 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 4ft   6008189.29085 2104062.22691 37.7578166265547 -122.414695389796 (37.7578166265547, -122.414695389796) 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
23867 215521 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1750 10th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   5993133.83624 2103556.81567 37.755571512239 -122.466726245046 (37.755571512239, -122.466726245046) 1 8 4 56 12
23894 200745 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 5101 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6014683.7532 2094550.1103 37.7320610911002 -122.391569635286 (37.7320610911002, -122.391569635286) 10 3 8 58 1
23988 198459 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 700 Mariposa St 7 Sidewalk: Curb side : Yard Tree Private 2     1 Width 6ft   6014889.29769 2106275.30651 37.7642674249283 -122.391678519967 (37.7642674249283, -122.391678519967) 14 3 9 310 29
24002 198501 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 900x Carolina St 13 Median : Yard Tree DPW 1     15     6012463.03254 2103576.30053 37.7567215715659 -122.399880796574 (37.7567215715659, -122.399880796574) 10 3 8 28856 29
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
24118 97269 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2050X Baker St 3 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 769192 5999973.8 2116027.1 37.79020412496 -122.443967546887 (37.79020412496, -122.443967546887) 13 6 1 29490 27
24238 215561 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 240 Santa Paula Ave 4 Sidewalk: Curb side : Yard Tree Private 2     4 Width 4ft   5994051.56415 2096391.91316 37.7359514186289 -122.463032656549 (37.7359514186289, -122.463032656549) 9 8 4 59 40
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
24722 244306 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 300x Octavia St 8 Median : Cutout Tree DPW 1     2 Width 0ft   6005576.9618 2110512.9441 37.7753816404734 -122.42418868303 (37.7753816404734, -122.42418868303) 7 9 11 28852 10
24738 16679 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 248 Noe St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6002873.9908755 2106855.8321643 37.7651871206567 -122.433277506161 (37.7651871206567, -122.433277506161) 15 5 5 28862 3
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
24826 198583 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 980 16th St 3 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2018 12:00:00 AM 3 Width 4ft Permit Number 775761 6013760.46871 2107146.56354 37.7665969793027 -122.395643896153 (37.7665969793027, -122.395643896153) 14 3 8 28856 20
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
25169 17576 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 752X Persia Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     15 3x3   6003542.00606 2090427.72603 37.7201172080443 -122.429795147634 (37.7201172080443, -122.429795147634) 9 7 6 28861 5
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
25292 89024 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2724 Pacific Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   10/01/2008 12:00:00 AM 4 4x4 Permit Number 51769 6000900.18903 2116892.91159 37.7926342186313 -122.440824453501 (37.7926342186313, -122.440824453501) 13 6 1 29490 27
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
25561 101710 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 990 Rhode Island St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/12/2016 12:00:00 AM 3 3x3   6011874 2103773 37.7572288087602 -122.401931725179 (37.7572288087602, -122.401931725179) 10 3 8 28856 29
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
25726 215523 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 80 Northwood Dr 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   5995460.48677 2094242.81923 37.7301315873058 -122.458006001202 (37.7301315873058, -122.458006001202) 9 7 4 28861 40
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
26225 244356 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 300x Octavia St 4 Median : Cutout Tree DPW 1     7 Width 0ft   6005588.2934 2110426.5412 37.7751450388721 -122.424143338216 (37.7751450388721, -122.424143338216) 7 9 11 28852 10
26267 198618 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 454 Mission Bay Blvd South 7 Sidewalk: Curb side : Yard Tree Private 2     5     6015853.85549 2108626.75005 37.770777472425 -122.388506502268 (37.770777472425, -122.388506502268) 14 3 9 310 20
26272 9765 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 827X Broderick St 3 Sidewalk: Curb side : Cutout Tree Private 2   12/15/2005 12:00:00 AM 3 3X3   6000964.4329 2111657.6469 37.7782631876883 -122.440226567073 (37.7782631876883, -122.440226567073) 15 5 11 29490 41
26333 85767 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1400X Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   05/07/2007 12:00:00 AM 3 3x3   6008747.4583 2109466.0696 37.7726856753072 -122.41314711365 (37.7726856753072, -122.41314711365) 8 2 9 28853 34
26377 18527 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3104X Folsom St 4 Sidewalk: Curb side : Cutout Tree DPW 1     60 3X3   6008391.22062 2100547.0534 37.7481760966626 -122.413748394121 (37.7481760966626, -122.413748394121) 2 4 7 28859 2
26388 244359 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 6 Median : Cutout Tree DPW 1     5 Width 0ft   6005522.1928 2110456.2865 37.7752229798737 -122.424374111287 (37.7752229798737, -122.424374111287) 7 9 11 28852 10
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
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
26836 198657 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1670 Owen St 10 Sidewalk: Property side : Yard Tree Private 2     4 Width 8ft   6013998.08453 2107337.5024 37.7671344699085 -122.394835392165 (37.7671344699085, -122.394835392165) 14 3 9 310 20
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
26952 137023 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2201 Broadway 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6003036.9655 2117481.25366 37.7943711144001 -122.433473197238 (37.7943711144001, -122.433473197238) 13 9 1 29490 27
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
27032 119717 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 10 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
27123 242567 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2121 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6008134.5513 2106113.05528 37.7634446540583 -122.415029859359 (37.7634446540583, -122.415029859359) 8 4 7 28859 19
27268 16442 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1395 Newcomb Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016285.996927 2094866.016739 37.7330173117391 -122.386052291775 (37.7330173117391, -122.386052291775) 10 3 8 58 1
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);