trees

427 rows where SiteOrder = 2 and qSpecies_id = 31 sorted by Neighborhoods (old)

✎ View and edit SQL

This data as json, CSV (advanced)

SiteOrder ✖

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) ▼
481 119782 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 202x Octavia St Frontage East 2 Median : Cutout Tree DPW 1           2110143 6005643 47.270172161735 -138.280681481725 (47.270172161735, -138.280681481725)          
1908 119794 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 2 Median : Cutout Tree DPW 1           2110122 6005581 47.2699969117914 -138.280716869623 (47.2699969117914, -138.280716869623)          
9121 46285 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31   2 Sidewalk: Curb side : Cutout Tree Private 2   01/31/2002 12:00:00 AM     Permit Number 44564                    
18433 260397 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1x Thornton Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/20/2018 12:00:00 AM 3                        
31673 119709 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 102x Octavia St Frontage East 2 Median : Cutout Tree DPW 1           2109802 6005691 47.2701255040516 -138.282046982267 (47.2701255040516, -138.282046982267)          
73186 119818 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 302x Octavia St Frontage East 2 Median : Cutout Tree DPW 1           2110484 6005595 47.27021880585 -138.279315979183 (47.27021880585, -138.279315979183)          
85012 119676 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2x Octavia St Frontage East 2 Median : Cutout Tree DPW 1           2109501 6005733 47.2700833275765 -138.283252028036 (47.2700833275765, -138.283252028036)          
139973 119829 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 2 Median : Cutout Tree DPW 1           2110475 6005532 47.2700470263222 -138.279303834774 (47.2700470263222, -138.279303834774)          
149108 119747 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 2 Median : Cutout Tree DPW 1           2109793 6005627 47.2699510709683 -138.28203408065 (47.2699510709683, -138.28203408065)          
4812 198517 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1763 Newcomb Ave 2 : Tree Private 2     5 Width 7ft   6014346.73951 2096322.78373 37.7369097775472 -122.392858747949 (37.7369097775472, -122.392858747949) 10 3 8 58 1
8701 200755 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 5099 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6014751.1238 2094745.6812 37.7326018284177 -122.391350385093 (37.7326018284177, -122.391350385093) 10 3 8 58 1
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
36858 22315 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 5115X 03rd St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 3X3   6014716.40109 2094586.27231 37.7321621967642 -122.391459290654 (37.7321621967642, -122.391459290654) 10 3 8 58 1
41660 198529 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1722 Newcomb Ave 2 : Tree Private 2     7 Width 7ft   6014569.28946 2096208.90311 37.73660944358 -122.392081326305 (37.73660944358, -122.392081326305) 10 3 8 58 1
54742 200631 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1354 Newcomb Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6016389.5518 2094874.5522 37.7330464790647 -122.385694866729 (37.7330464790647, -122.385694866729) 10 3 8 58 1
61858 200580 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1330 Newcomb Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6016475.5774 2094870.1567 37.7330391696694 -122.385397144532 (37.7330391696694, -122.385397144532) 10 3 8 58 1
101626 201907 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1751 Yosemite Ave 2 : Tree Private 2     5 Width 3ft   6013751.60826 2093257.56774 37.7284602485269 -122.394701804167 (37.7284602485269, -122.394701804167) 10 3 8 58 1
103111 46632 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1478 Underwood Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 04/12/2002 12:00:00 AM 9 3x3 Permit Number 44753 6015248.4747 2093270.3779 37.7285785323655 -122.389527911332 (37.7285785323655, -122.389527911332) 10 3 8 58 1
116534 198560 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1708 Newcomb Ave 2 Sidewalk: Curb side : Yard Tree Private 2     6 Width 4ft   6014655.2828 2096153.01044 37.7364607478562 -122.391780101069 (37.7364607478562, -122.391780101069) 10 3 8 58 1
142895 107048 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 1478 UNDERWOOD AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6015262.9 2093276.2 37.7285953185109 -122.389478448264 (37.7285953185109, -122.389478448264) 10 3 8 58 1
145272 22327 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 5155 03rd St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6014617.6908 2094280.6281 37.7313174804906 -122.391779193474 (37.7313174804906, -122.391779193474) 10 3 8 58 1
146461 16439 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1395 Newcomb Ave 2 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
153183 198533 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1762 Newcomb Ave 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 7ft   6014374.32844 2096361.30259 37.7370170747819 -122.392766053934 (37.7370170747819, -122.392766053934) 10 3 8 58 1
160465 198522 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1725 Newcomb Ave 2 : Tree Private 2     3 Width 7ft   6014552.77288 2096169.89847 37.7365014278009 -122.392135704718 (37.7365014278009, -122.392135704718) 10 3 8 58 1
162884 198521 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1737 Newcomb Ave 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 7ft   6014485.10287 2096211.09486 37.7366107871579 -122.392372551071 (37.7366107871579, -122.392372551071) 10 3 8 58 1
163774 198514 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1601 Bay Shore Blvd 2 : Tree Private 2     6 Width 3ft   6012038.03347 2091375.16372 37.7231961325824 -122.400493582929 (37.7231961325824, -122.400493582929) 10 3 8 58 1
168414 198544 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1700 Newcomb Ave 2 : Tree Private 2     4 Width 0ft   6014356.36657 2096313.21091 37.7368840272751 -122.392824793156 (37.7368840272751, -122.392824793156) 10 3 8 58 1
170708 200597 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1300x Newcomb Ave 2 Median : Cutout Tree DPW 1     1 Width 0ft   6016514.3807 2094844.0461 37.7329696218978 -122.385261171263 (37.7329696218978, -122.385261171263) 10 3 8 58 1
172739 200628 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1362 Newcomb Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6016361.9231 2094886.4828 37.7330777092621 -122.385791218603 (37.7330777092621, -122.385791218603) 10 3 8 58 1
172901 198526 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1700 Newcomb Ave 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 7ft   6014646.0524 2096160.05646 37.736479582376 -122.391812507248 (37.736479582376, -122.391812507248) 10 3 8 58 1
395 246548 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 20x Octavia St 2 Median : Cutout Tree DPW 1     6 Width 6ft   6005741.17746 2109432.24964 37.7724235852138 -122.423543772638 (37.7724235852138, -122.423543772638) 7 9 11 28852 10
6138 244422 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 100x Octavia St 2 Median : Cutout Tree DPW 1     5 Width 0ft   6005691.1562 2109690.8797 37.7731308974862 -122.423735193743 (37.7731308974862, -122.423735193743) 7 9 11 28852 10
34818 245849 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 251 Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6005124.4628 2109778.1319 37.7733384648593 -122.425701672194 (37.7733384648593, -122.425701672194) 7 9 11 28852 10
39077 103271 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 350 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6004879 2109882 37.7736097878739 -122.426558160091 (37.7736097878739, -122.426558160091) 7 9 11 28852 10
60593 242431 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 308 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6004963.84675 2109896.18712 37.7736535385006 -122.42626567242 (37.7736535385006, -122.42626567242) 7 9 11 28852 10
61325 244354 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 300x Octavia St 2 Median : Cutout Tree DPW 1     9 Width 0ft   6005594.4313 2110381.2151 37.7750209309426 -122.424118881689 (37.7750209309426, -122.424118881689) 7 9 11 28852 10
66993 244411 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 201x Octavia St 2 Median : Cutout Tree DPW 1     1 Width 0ft   6005560.024 2110238.8403 37.7746280615118 -122.424227776164 (37.7746280615118, -122.424227776164) 7 9 11 28852 10
74986 244345 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 101x Octavia St 2 Median : Cutout Tree DPW 1     7 Width 0ft   6005607.2268 2109894.3659 37.7736848832921 -122.424039990106 (37.7736848832921, -122.424039990106) 7 9 11 28852 10
96653 242433 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 340 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6004899.43089 2109888.25231 37.7736281101874 -122.426487931787 (37.7736281101874, -122.426487931787) 7 9 11 28852 10
115729 244312 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 301x Octavia St 2 Median : Cutout Tree DPW 1     6 Width 0ft   6005504.7234 2110575.2675 37.7755486863335 -122.424443006762 (37.7755486863335, -122.424443006762) 7 9 11 28852 10
157220 142251 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 471 LINDEN ST 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   6005162.3875 2110758.8534 37.7760334306508 -122.425640299516 (37.7760334306508, -122.425640299516) 7 9 11 28852 10
181994 242428 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 300 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   6005059.64252 2109908.94794 37.7736939909104 -122.425935208466 (37.7736939909104, -122.425935208466) 7 9 11 28852 10
12506 105953 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 54 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   03/10/2014 12:00:00 AM 4   Permit Number 771133 5994277.8794 2115232.96253 37.7876970801078 -122.463617190077 (37.7876970801078, -122.463617190077) 11 6 1 54 11
28829 123586 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 62 05th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   5994279.04973 2115190.28174 37.787579957729 -122.463610042193 (37.787579957729, -122.463610042193) 11 6 1 54 11
44191 123695 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1 Clement St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5995508.22475 2113538.45627 37.7831152369297 -122.459237706338 (37.7831152369297, -122.459237706338) 11 6 2 54 11
67660 123533 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3 05th Ave 2 Sidewalk: Curb side : Yard Tree Private 2     3 Width 5ft   5994221.75726 2115563.21138 37.7886006193808 -122.463835340542 (37.7886006193808, -122.463835340542) 11 6 1 54 11
121132 19301 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 100X Balboa St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   5995247.10654 2111496.409 37.7774933045144 -122.459993084378 (37.7774933045144, -122.459993084378) 11 6 2 54 11
135352 108481 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 195x 09TH AVE 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5993013.6 2114237 37.7848895119291 -122.467918846049 (37.7848895119291, -122.467918846049) 11 6 2 54 11
145175 113444 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 742 04th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   5994761.5711 2110535.58365 37.7748271966325 -122.461603021673 (37.7748271966325, -122.461603021673) 11 6 2 54 11
161347 123129 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 758 10th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 4ft   5992907.03183 2110299.16217 37.7740711235286 -122.468001002791 (37.7740711235286, -122.468001002791) 11 6 2 54 11
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
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
43197 215476 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 455 Judah St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   5993096.43343 2105917.73669 37.7620518272484 -122.467027231034 (37.7620518272484, -122.467027231034) 1 8 4 56 12
51709 173899 Planning Code 138.1 required 2 Ulmus parvifolia :: Chinese Elm 31 1762 12th Ave 2 Sidewalk: Property side : Cutout Tree Private 2       3x3 Permit Number 779465 5992511.90241 2103608.89481 37.7556785957656 -122.468880856653 (37.7556785957656, -122.468880856653) 1 8 4 56 12
148692 242602 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1311 Clayton St 2 : Tree Private 2     7 Width 3ft   5999038.72124 2105222.15033 37.7604831182267 -122.446425191088 (37.7604831182267, -122.446425191088) 15 5 5 28862 12
168239 46913 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 455 Judah St 2 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
41592 33124 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2380 Greenwich St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/05/1996 12:00:00 AM 12 6x6 Permit Number 37358 6001499.40758 2119065.90574 37.7986348002003 -122.438906933417 (37.7986348002003, -122.438906933417) 13 9 1 57 17
51115 41185 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3440 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/24/1999 12:00:00 AM 2   Permit Number 41903 6001280.22409 2120345.11349 37.8021346936235 -122.439757137177 (37.8021346936235, -122.439757137177) 13 9 1 57 17
66717 136968 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 77 Pixley St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6003015.29864 2119068.11708 37.7987270014142 -122.433661633074 (37.7987270014142, -122.433661633074) 13 9 1 57 17
89847 101524 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2326 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6001795.96309 2118760.54126 37.7978132173675 -122.437858876082 (37.7978132173675, -122.437858876082) 13 9 1 57 17
173998 136990 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2423 Chestnut St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6000237.89939 2119535.3298 37.7998518599455 -122.443305872762 (37.7998518599455, -122.443305872762) 13 9 1 57 17
180201 136989 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2781 Filbert St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   5999666.44189 2118415.79962 37.7967453254804 -122.445202788494 (37.7967453254804, -122.445202788494) 13 9 1 57 17
184193 136961 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2900 Divisadero St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6000580.09999 2118271.36688 37.7964008599691 -122.442030958785 (37.7964008599691, -122.442030958785) 13 9 1 57 17
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
4784 242408 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3711 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 3x3   6005560.82063 2104287.7294 37.7582877732797 -122.42380177823 (37.7582877732797, -122.42380177823) 2 4 5 28859 19
6498 242573 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2055 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 5x9   6008115.25699 2106522.97754 37.7645691213862 -122.415125610158 (37.7645691213862, -122.415125610158) 8 4 7 28859 19
11086 242374 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2x McCoppin St 2 Median : Yard Tree DPW 1     5 Width 9ft   6006546.0037 2109148.19709 37.7716890396519 -122.420739627149 (37.7716890396519, -122.420739627149) 8 2 9 28853 19
11178 200944 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1595 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6008285.8995 2108891.4726 37.771082044751 -122.41470302964 (37.771082044751, -122.41470302964) 8 2 9 28853 19
16133 7485 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2676 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     60 3X3   6008262.291899 2102845.0627354 37.7544786718635 -122.414356800841 (37.7544786718635, -122.414356800841) 2 4 7 28859 19
17600 220014 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 58X Elizabeth St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 3x3   6005814 2102330 37.752926592326 -122.422787042427 (37.752926592326, -122.422787042427) 2 4 5 28859 19
17985 242506 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2690 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6008258.82022 2102787.11957 37.7543193780408 -122.414364707265 (37.7543193780408, -122.414364707265) 2 4 7 28859 19
18776 242548 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2498 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008191.23851 2104001.87408 37.7576510208955 -122.414684382976 (37.7576510208955, -122.414684382976) 2 4 7 28859 19
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
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
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
28789 31076 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1700X 15th St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM 8   Permit Number 34816 6006020.69113 2107294.38947 37.7665693044606 -122.422424975532 (37.7665693044606, -122.422424975532) 8 4 5 28853 19
37889 242424 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 209 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   6005453.21466 2102408.07888 37.7531206159404 -122.424040259559 (37.7531206159404, -122.424040259559) 2 4 5 28859 19
38205 7428 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2507 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     60 3X3   6008259.11324 2103798.38895 37.757096110403 -122.414435245589 (37.757096110403, -122.414435245589) 2 4 7 28859 19
40491 242416 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3652 24th St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6005376.79468 2101978.6432 37.7519371701822 -122.424273995163 (37.7519371701822, -122.424273995163) 2 4 5 28859 19
49216 7525 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2804 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6008301.92426 2102042.90132 37.7522783441942 -122.414162992926 (37.7522783441942, -122.414162992926) 2 4 7 28859 19
53154 7487 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2675X Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6008318.24783 2102788.20898 37.7543257074831 -122.41415926793 (37.7543257074831, -122.41415926793) 2 4 7 28859 19
53830 105078 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 299X FAIR OAKS ST 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6005467 2101988 37.7519679548938 -122.42396271727 (37.7519679548938, -122.42396271727) 2 4 5 28859 19
57360 242510 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2808 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6008305.34942 2102000.42568 37.7521619080513 -122.41414814334 (37.7521619080513, -122.41414814334) 2 4 7 28859 19
58501 242380 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1217 San Bruno Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6011151.17373 2102568.66425 37.7538816015592 -122.404346786677 (37.7538816015592, -122.404346786677) 10 4 8 28859 19
59471 87143 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2405 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/18/2008 12:00:00 AM 7 3x3 Permit Number 50131 6008226 2104427 37.7588202724984 -122.414594246502 (37.7588202724984, -122.414594246502) 2 4 7 28859 19
60434 7582 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3000X Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1     50 3x3   6008378.51714 2100951.63552 37.7492862752884 -122.413820936867 (37.7492862752884, -122.413820936867) 2 4 7 28859 19
61116 242528 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 1942 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   6008018.69066 2107110.79119 37.7661776937697 -122.415501227304 (37.7661776937697, -122.415501227304) 8 4 7 28853 19
62811 242570 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2075 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   6008127.10713 2106318.8789 37.7640093797557 -122.415070175952 (37.7640093797557, -122.415070175952) 8 4 7 28859 19
64879 607 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2785X Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     60 3x3   6008349.31996 2102181.90054 37.7526626667701 -122.414008922882 (37.7526626667701, -122.414008922882) 2 4 7 28859 19
68297 242376 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 112 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 3ft   6005382.46829 2102954.4101 37.7546167200124 -122.424323769035 (37.7546167200124, -122.424323769035) 2 4 5 28859 19
68734 7442 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2533 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     60 3X3   6008266.30803 2103660.34256 37.7567174706459 -122.414400595608 (37.7567174706459, -122.414400595608) 2 4 7 28859 19
68907 98928 Undocumented 4 Ulmus parvifolia :: Chinese Elm 31 112 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005385 2103055 37.7548930594212 -122.424322167644 (37.7548930594212, -122.424322167644) 2 4 5 28859 19
69356 242529 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2020 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 2ft   6008038.38558 2106699.26019 37.7650488323522 -122.415403969232 (37.7650488323522, -122.415403969232) 8 4 7 28859 19
74174 242410 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 260 Fair Oaks St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 3ft   6005429.48582 2102185.84233 37.7525090661421 -122.424106515303 (37.7525090661421, -122.424106515303) 2 4 5 28859 19
74389 104447 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2490X Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park     3x3   6008214.39649 2104163.75253 37.7580968032353 -122.41461574816 (37.7580968032353, -122.41461574816) 2 4 7 28859 19
74873 7527 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2808 Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2     60 3X3   6008275.78702 2102017.83073 37.7522080378675 -122.414251606301 (37.7522080378675, -122.414251606301) 2 4 7 28859 19
75248 49733 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 2940REVISED Folsom St 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/26/2005 12:00:00 AM     Permit Number 46534 6008347.91771108 2101298.08089598 37.7502358181357 -122.413951255275 (37.7502358181357, -122.413951255275) 2 4 7 28859 19
81102 242382 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 2612 25th St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 3ft   6011032.0091 2101843.28005 37.7518831964576 -122.404707824918 (37.7518831964576, -122.404707824918) 10 4 8 28859 19
81404 242406 DPW Maintained 1 Ulmus parvifolia :: Chinese Elm 31 3798 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6005061.53168 2104301.3649 37.7582970147075 -122.425529509896 (37.7582970147075, -122.425529509896) 2 4 5 28859 19
81593 95635 Permitted Site 7 Ulmus parvifolia :: Chinese Elm 31 111X 14th St 2 Sidewalk: Curb side : Cutout Tree Private 2   02/05/2016 12:00:00 AM 3 3x3 Permit Number 777379 6007972 2107962 37.7685122898352 -122.415722998498 (37.7685122898352, -122.415722998498) 8 4 7 28853 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)
);