trees

379 rows where qSpecies_id = 86 sorted by DBH descending

✎ View and edit SQL

This data as json, CSV (advanced)

Zip Codes ✖

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)
4496 74361 DPW Maintained 1 Taxus baccata :: Irish Yew 86 299 Madison St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   9     6005755.65434 2092345.08491 37.7255069657486 -122.422279456248 (37.7255069657486, -122.422279456248) 9 7 7 309 5
8931 215339 DPW Maintained 1 Taxus baccata :: Irish Yew 86 637 Detroit St 5 Sidewalk: Property side : Yard Tree Private 2     9 Width 8ft   5999420.83111 2095184.41503 37.7329437376643 -122.444382272244 (37.7329437376643, -122.444382272244) 9 7 4 59 40
23212 179853 DPW Maintained 1 Taxus baccata :: Irish Yew 86 802 Delano Ave 6 Sidewalk: Property side : Yard Tree Private 2     9 Width 10ft   5998760.78346 2089904.78247 37.7184094145512 -122.446284557804 (37.7184094145512, -122.446284557804) 9 7 6 28861 25
47539 31120 DPW Maintained 1 Taxus baccata :: Irish Yew 86 450 Edna St 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/21/1995 12:00:00 AM 9   Permit Number 34839 5998792.22814 2094324.02861 37.7305454337211 -122.446493629496 (37.7305454337211, -122.446493629496) 9 7 4 28861 40
54391 179886 DPW Maintained 1 Taxus baccata :: Irish Yew 86 675 Sweeny St 3 Sidewalk: Property side : Yard Tree Private 2     9 Width 2ft   6007455.79909 2094011.3835 37.7301780166028 -122.416520168176 (37.7301780166028, -122.416520168176) 9 3 7 309 28
62558 136653 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1490 Jefferson St 10 Sidewalk: Property side : Yard Tree Private 2     9 Width 2ft   6002117.3275 2121589.45847 37.8055989477865 -122.436949497817 (37.8055989477865, -122.436949497817) 13 9 1 57 17
81813 241070 DPW Maintained 1 Taxus baccata :: Irish Yew 86 415 Collingwood St 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 10ft   6002148.82258 2103426.21289 37.7557290518693 -122.43554031414 (37.7557290518693, -122.43554031414) 2 4 5 28862 22
85899 136715 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1599 North Point St 9 Side Yard : Yard Tree Private 2     9 Width 7ft   6003190.85748 2120979.91426 37.803986257417 -122.433190818205 (37.803986257417, -122.433190818205) 13 9 1 57 17
86661 197902 DPW Maintained 1 Taxus baccata :: Irish Yew 86 578 San Bruno Ave 3 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   6010935.09599 2105618.63993 37.7622440780325 -122.405308806777 (37.7622440780325, -122.405308806777) 8 3 8 28856 29
101151 179820 DPW Maintained 1 Taxus baccata :: Irish Yew 86 25 Dichiera Ct 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   5998698.87726 2087810.60096 37.712655734647 -122.446347971688 (37.712655734647, -122.446347971688) 9 7 6 28861 25
105099 179861 DPW Maintained 1 Taxus baccata :: Irish Yew 86 243 Athens St 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6004531.11595 2091836.46353 37.7240412542901 -122.426476381783 (37.7240412542901, -122.426476381783) 9 7 6 28861 5
121616 136698 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1047 Lombard St 3 Sidewalk: Property side : Yard Tree Private 2     9 Width 6ft   6007369.77523 2120178.57084 37.802022141674 -122.418672500363 (37.802022141674, -122.418672500363) 5 1 1 28858 32
126177 179892 DPW Maintained 1 Taxus baccata :: Irish Yew 86 101 Dartmouth St 9 Sidewalk: Property side : Yard Tree Private 2     9 Width 5ft   6008521.95318 2093544.04536 37.728954707483 -122.412801294348 (37.728954707483, -122.412801294348) 9 3 7 309 28
129935 215324 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1288 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 5ft   5993647.63812 2106753.81902 37.764379290687 -122.465181573075 (37.764379290687, -122.465181573075) 11 8 11 56 12
133462 179834 DPW Maintained 1 Taxus baccata :: Irish Yew 86 134 Cotter St 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6001971.52486 2093519.43437 37.7285172835473 -122.435444813332 (37.7285172835473, -122.435444813332) 9 7 6 28861 25
136982 215322 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1546 10th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5993091.78936 2104948.86266 37.7593912846005 -122.466972852608 (37.7593912846005, -122.466972852608) 1 8 4 56 12
137739 241056 DPW Maintained 1 Taxus baccata :: Irish Yew 86 4864 17th St 3 Sidewalk: Property side : Yard Tree Private 2     9 Width 5ft   5997871.31028 2105665.38567 37.7616333843862 -122.450494663794 (37.7616333843862, -122.450494663794) 15 5 11 29492 9
147511 136710 DPW Maintained 1 Taxus baccata :: Irish Yew 86 801 Chestnut St 4 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6007938.82451 2120606.36693 37.8032287836485 -122.41673363846 (37.8032287836485, -122.41673363846) 5 1 1 308 32
149332 179850 DPW Maintained 1 Taxus baccata :: Irish Yew 86 802 Delano Ave 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 10ft   5998778.24395 2089941.01946 37.7185099101936 -122.446226809638 (37.7185099101936, -122.446226809638) 9 7 6 28861 25
161074 41928 DPW Maintained 1 Taxus baccata :: Irish Yew 86 524 04th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF 06/20/2000 12:00:00 AM 9   Permit Number 42287 5994708.51972 2111929.51477 37.7786515066402 -122.461887634901 (37.7786515066402, -122.461887634901) 11 6 2 54 11
178178 197908 DPW Maintained 1 Taxus baccata :: Irish Yew 86 75 Arkansas St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6012886.87762 2106673.42615 37.7652492165901 -122.398632309145 (37.7652492165901, -122.398632309145) 14 3 8 28856 20
179893 179877 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1516 Bacon St 1 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6007105.23827 2091790.85239 37.7240611967477 -122.417574786965 (37.7240611967477, -122.417574786965) 9 7 7 309 28
189980 179878 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1516 Bacon St 2 Sidewalk: Property side : Yard Tree Private 2     9 Width 3ft   6007090.65933 2091786.11509 37.7240473687785 -122.417624848631 (37.7240473687785, -122.417624848631) 9 7 7 309 28
192763 215327 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1301 14th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   5992028.3413 2098343.65136 37.7411936459769 -122.470169759049 (37.7411936459769, -122.470169759049) 1 8 4 59 40
1950 71713 DPW Maintained 1 Taxus baccata :: Irish Yew 86 782 40th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5983564.60428 2110493.72832 37.7740614056929 -122.500331946576 (37.7740614056929, -122.500331946576) 11 6 2 55 26
3399 197903 DPW Maintained 1 Taxus baccata :: Irish Yew 86 578 San Bruno Ave 4 Sidewalk: Curb side : Yard Tree Private 2     8 Width 4ft   6010927.90334 2105602.38731 37.762199049855 -122.405332538967 (37.762199049855, -122.405332538967) 8 3 8 28856 29
6392 70172 DPW Maintained 1 Taxus baccata :: Irish Yew 86 3027 Anza St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF   8     5989237.11171 2111905.73167 37.7782697016213 -122.480813388031 (37.7782697016213, -122.480813388031) 11 6 2 55 26
11189 136665 DPW Maintained 1 Taxus baccata :: Irish Yew 86 65 Normandie Ter 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6000886.70084 2117510.54537 37.7943293112096 -122.4409154505 (37.7943293112096, -122.4409154505) 13 9 1 57 27
12939 136649 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1490 Jefferson St 4 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6002175.88564 2121598.89549 37.8056281874435 -122.436747525379 (37.8056281874435, -122.436747525379) 13 9 1 57 17
17039 136666 DPW Maintained 1 Taxus baccata :: Irish Yew 86 45 Normandie Ter 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   6000890.78199 2117450.16174 37.7941637460202 -122.440896995501 (37.7941637460202, -122.440896995501) 13 9 1 57 27
23215 218419 DPW Maintained 1 Taxus baccata :: Irish Yew 86 206 Castenada Ave 2 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5994236.56093 2100588.83344 37.7474857670642 -122.462697413572 (37.7474857670642, -122.462697413572) 1 8 4 29491 40
35581 179842 DPW Maintained 1 Taxus baccata :: Irish Yew 86 212 Silver Ave 5 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6002649.41519 2093884.99893 37.7295595177473 -122.433127421409 (37.7295595177473, -122.433127421409) 9 7 6 28861 25
37301 241067 DPW Maintained 1 Taxus baccata :: Irish Yew 86 229 Grand View Ave 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   6000638.50789 2103037.93604 37.7545770419209 -122.440735600467 (37.7545770419209, -122.440735600467) 2 4 5 28862 22
39108 179880 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1151 Felton St 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6007526.36673 2092824.84352 37.7269240023301 -122.416192203412 (37.7269240023301, -122.416192203412) 9 3 7 309 28
44005 179893 DPW Maintained 1 Taxus baccata :: Irish Yew 86 101 Dartmouth St 10 Sidewalk: Property side : Yard Tree Private 2     8 Width 5ft   6008518.11565 2093559.33094 37.7289964630154 -122.412815641254 (37.7289964630154, -122.412815641254) 9 3 7 309 28
44578 179805 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1475 Cayuga Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5998972.41815 2089460.57977 37.7172018201812 -122.445521103537 (37.7172018201812, -122.445521103537) 9 7 6 28861 25
54331 215340 DPW Maintained 1 Taxus baccata :: Irish Yew 86 637 Detroit St 7 Sidewalk: Property side : Yard Tree Private 2     8 Width 8ft   5999417.92849 2095175.79644 37.7329199074284 -122.444391688153 (37.7329199074284, -122.444391688153) 9 7 4 59 40
57951 179814 DPW Maintained 1 Taxus baccata :: Irish Yew 86 522 Sunnydale Ave 1 Sidewalk: Curb side : Pot Tree Private 2     8     6010066.66697 2086413.12079 37.7094612429124 -122.406958677794 (37.7094612429124, -122.406958677794) 9 7 8 309 39
77632 136687 DPW Maintained 1 Taxus baccata :: Irish Yew 86 915 Bay St 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6006389.37934 2121076.02461 37.8044310746876 -122.422128935803 (37.8044310746876, -122.422128935803) 5 1 1 28858 32
81457 179891 DPW Maintained 1 Taxus baccata :: Irish Yew 86 101 Dartmouth St 7 Sidewalk: Property side : Yard Tree Private 2     8 Width 5ft   6008528.33324 2093531.3526 37.7289202139869 -122.41277834095 (37.7289202139869, -122.41277834095) 9 3 7 309 28
84545 136709 DPW Maintained 1 Taxus baccata :: Irish Yew 86 801 Chestnut St 3 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   6007914.92474 2120604.50253 37.8032223202271 -122.416816212417 (37.8032223202271, -122.416816212417) 5 1 1 308 32
100716 136692 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1101 Green St 5 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6007731.45393 2118841.87046 37.7983722539254 -122.417326136092 (37.7983722539254, -122.417326136092) 5 1 10 28858 32
102034 136652 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1490 Jefferson St 9 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6002131.53394 2121592.77416 37.8056088592346 -122.43690057202 (37.8056088592346, -122.43690057202) 13 9 1 57 17
103524 179808 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1401 Cayuga Ave 1 Front Yard : Yard Tree Private 2     8 Width 0ft   5999197.61143 2089687.82893 37.7178386481083 -122.444759045 (37.7178386481083, -122.444759045) 9 7 6 28861 25
107311 179825 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1115 Cayuga Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 1ft   6000416.25611 2090642.64667 37.7205298306712 -122.440615189366 (37.7205298306712, -122.440615189366) 9 7 6 28861 25
107371 179874 DPW Maintained 1 Taxus baccata :: Irish Yew 86 590 Cambridge St 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   6007111.06937 2091808.8773 37.7241110173924 -122.4175559066 (37.7241110173924, -122.4175559066) 9 7 7 309 28
114189 179855 DPW Maintained 1 Taxus baccata :: Irish Yew 86 950 Delano Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   5998508.96783 2089424.10578 37.7170752019331 -122.447120402108 (37.7170752019331, -122.447120402108) 9 7 6 28861 25
124748 179822 DPW Maintained 1 Taxus baccata :: Irish Yew 86 364 Ellington Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5998692.05829 2087780.21802 37.7125719205336 -122.446369355756 (37.7125719205336, -122.446369355756) 9 7 6 28861 25
125098 179852 DPW Maintained 1 Taxus baccata :: Irish Yew 86 802 Delano Ave 5 Sidewalk: Property side : Yard Tree Private 2     8 Width 10ft   5998768.26163 2089920.0752 37.7184518319668 -122.446259808467 (37.7184518319668, -122.446259808467) 9 7 6 28861 25
127847 218418 DPW Maintained 1 Taxus baccata :: Irish Yew 86 206 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2     8 Width 0ft   5994240.64803 2100595.30557 37.7475037732855 -122.462683750177 (37.7475037732855, -122.462683750177) 1 8 4 29491 40
140172 136708 DPW Maintained 1 Taxus baccata :: Irish Yew 86 801 Chestnut St 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   6007910.30742 2120604.37308 37.803221705081 -122.416832181661 (37.803221705081, -122.416832181661) 5 1 1 308 32
142858 179806 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1475 Cayuga Ave 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 0ft   5998976.19185 2089464.18471 37.7172119339604 -122.445508318764 (37.7172119339604, -122.445508318764) 9 7 6 28861 25
144301 136647 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1490 Jefferson St 1 : Tree Private 2     8 Width 2ft   6002197.32767 2121601.52004 37.8056366123151 -122.436673510277 (37.8056366123151, -122.436673510277) 13 9 1 57 17
148102 179864 DPW Maintained 1 Taxus baccata :: Irish Yew 86 274 Moscow St 3 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6004587.63153 2091546.86804 37.7232492834105 -122.4262604078 (37.7232492834105, -122.4262604078) 9 7 6 28861 5
148964 241064 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1801 Castro St 3 Sidewalk: Property side : Yard Tree Private 2     8     6002651.6707 2100291.95945 37.7471516815152 -122.433577323454 (37.7471516815152, -122.433577323454) 2 7 5 63 22
152355 136667 DPW Maintained 1 Taxus baccata :: Irish Yew 86 45 Normandie Ter 3 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   6000893.50994 2117430.42201 37.7941097012578 -122.440886139797 (37.7941097012578, -122.440886139797) 13 9 1 57 27
163744 179847 DPW Maintained 1 Taxus baccata :: Irish Yew 86 231 Delano Ave 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6000051.92108 2092264.11906 37.7249612688295 -122.441990900256 (37.7249612688295, -122.441990900256) 9 7 6 28861 25
164736 136638 DPW Maintained 1 Taxus baccata :: Irish Yew 86 98 Blake St 4 Sidewalk: Property side : Yard Tree Private 2     8 Width 3ft   5997852.8228 2113221.03458 37.7823781953411 -122.451103490434 (37.7823781953411, -122.451103490434) 15 6 1 54 31
166932 136648 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1490 Jefferson St 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6002184.59684 2121599.43708 37.8056301695703 -122.436717417869 (37.8056301695703, -122.436717417869) 13 9 1 57 17
169145 179841 DPW Maintained 1 Taxus baccata :: Irish Yew 86 212 Silver Ave 4 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6002653.07168 2093883.32374 37.7295551254715 -122.433114660921 (37.7295551254715, -122.433114660921) 9 7 6 28861 25
173813 179843 DPW Maintained 1 Taxus baccata :: Irish Yew 86 19 Camellia Ave 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6003264.53226 2094054.72637 37.7300604248468 -122.431013009142 (37.7300604248468, -122.431013009142) 9 7 6 28861 25
175773 179848 DPW Maintained 1 Taxus baccata :: Irish Yew 86 801 Delano Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 6ft   5998870.31235 2090001.49747 37.7186812265492 -122.445912915673 (37.7186812265492, -122.445912915673) 9 7 6 28861 25
179861 179869 DPW Maintained 1 Taxus baccata :: Irish Yew 86 299 Madison St 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   6005754.24665 2092349.7952 37.725519819773 -122.422284657027 (37.725519819773, -122.422284657027) 9 7 7 309 5
183558 215284 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1442 10th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 2ft   5993065.75738 2105645.52263 37.7613026281332 -122.467113534456 (37.7613026281332, -122.467113534456) 1 8 4 56 12
184131 179832 DPW Maintained 1 Taxus baccata :: Irish Yew 86 89 Belle Ave 1 Sidewalk: Property side : Yard Tree Private 2     8 Width 2ft   5991610.51667 2086489.35195 37.7086205125859 -122.470751174349 (37.7086205125859, -122.470751174349) 9 8 4 64 24
188918 179849 DPW Maintained 1 Taxus baccata :: Irish Yew 86 801 Delano Ave 2 Sidewalk: Property side : Yard Tree Private 2     8 Width 6ft   5998875.31966 2090008.53873 37.7187008461546 -122.445896113635 (37.7187008461546, -122.445896113635) 9 7 6 28861 25
192633 215285 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1536 08th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5993707.75608 2105010.81191 37.7595969145732 -122.464847054052 (37.7595969145732, -122.464847054052) 1 8 4 56 12
5435 70223 DPW Maintained 1 Taxus baccata :: Irish Yew 86 2011 Balboa St 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF   7     5989310.46344 2111227.07993 37.776410575875 -122.480509949706 (37.776410575875, -122.480509949706) 11 6 2 55 26
22753 136655 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1490 Jefferson St 13 Sidewalk: Property side : Yard Tree Private 2     7 Width 2ft   6002095.53828 2121587.56307 37.80559250506 -122.437024766584 (37.80559250506, -122.437024766584) 13 9 1 57 17
23410 215313 DPW Maintained 1 Taxus baccata :: Irish Yew 86 323 Tara St 2 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5997655.06789 2090049.20462 37.7187427527624 -122.450116941352 (37.7187427527624, -122.450116941352) 9 8 6 28861 24
24370 215317 DPW Maintained 1 Taxus baccata :: Irish Yew 86 323 Tara St 8 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5997677.83985 2090093.68651 37.7188661927949 -122.450041432477 (37.7188661927949, -122.450041432477) 9 8 6 28861 24
27119 215314 DPW Maintained 1 Taxus baccata :: Irish Yew 86 323 Tara St 3 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5997659.25231 2090057.81858 37.7187666441474 -122.450103098091 (37.7187666441474, -122.450103098091) 9 8 6 28861 24
38031 215288 DPW Maintained 1 Taxus baccata :: Irish Yew 86 800 Pacheco St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5991477.1073 2101838.1015 37.7507566211347 -122.472330389247 (37.7507566211347, -122.472330389247) 1 8 4 29491 12
42831 215318 DPW Maintained 1 Taxus baccata :: Irish Yew 86 323 Tara St 9 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5997681.5922 2090099.04662 37.7188811251298 -122.450028848265 (37.7188811251298, -122.450028848265) 9 8 6 28861 24
44291 215312 DPW Maintained 1 Taxus baccata :: Irish Yew 86 323 Tara St 1 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5997649.01848 2090038.45407 37.7187128880716 -122.450137077175 (37.7187128880716, -122.450137077175) 9 8 6 28861 24
49688 136713 DPW Maintained 1 Taxus baccata :: Irish Yew 86 290 Green St 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   6011569.99478 2119432.50864 37.8002092172264 -122.404085130728 (37.8002092172264, -122.404085130728) 3 1 10 308 23
51532 179818 DPW Maintained 1 Taxus baccata :: Irish Yew 86 25 Dichiera Ct 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 2ft   5998665.00636 2087845.19043 37.7127487749191 -122.446467526652 (37.7127487749191, -122.446467526652) 9 7 6 28861 25
53129 136663 DPW Maintained 1 Taxus baccata :: Irish Yew 86 3109 Franklin St 1 : Tree Private 2     7 Width 3ft   6005049.76701 2120690.58566 37.8032971105329 -122.426737318298 (37.8032971105329, -122.426737318298) 13 9 1 28858 17
56759 215319 DPW Maintained 1 Taxus baccata :: Irish Yew 86 323 Tara St 10 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5997686.11778 2090106.56575 37.7189020298764 -122.450013746835 (37.7189020298764, -122.450013746835) 9 8 6 28861 24
58420 136671 DPW Maintained 1 Taxus baccata :: Irish Yew 86 2650 Divisadero St 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 4ft   6000711.13679 2117411.08582 37.7940462208083 -122.441515780329 (37.7940462208083, -122.441515780329) 13 9 1 57 27
68300 241061 DPW Maintained 1 Taxus baccata :: Irish Yew 86 112 Crescent Ave 4 Sidewalk: Curb side : Yard Tree Private 2     7 Width 5ft   6005940.184 2095824.54912 37.7350712161596 -122.421888601897 (37.7350712161596, -122.421888601897) 2 7 7 28859 2
70544 179889 DPW Maintained 1 Taxus baccata :: Irish Yew 86 9 Dartmouth St 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 4ft   6008314.8677 2094310.92324 37.7310487635727 -122.41357142338 (37.7310487635727, -122.41357142338) 9 3 7 309 28
90245 136682 DPW Maintained 1 Taxus baccata :: Irish Yew 86 874 Green St 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   6008846.30156 2119059.10202 37.7990313778645 -122.413483781748 (37.7990313778645, -122.413483781748) 3 1 10 308 32
93014 136664 DPW Maintained 1 Taxus baccata :: Irish Yew 86 3109 Franklin St 2 : Tree Private 2     7 Width 3ft   6005052.80958 2120674.99367 37.8032544709705 -122.42672567836 (37.8032544709705, -122.42672567836) 13 9 1 28858 17
104409 179798 DPW Maintained 1 Taxus baccata :: Irish Yew 86 295 Foote Ave 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 4ft   5998239.51925 2088721.51535 37.7151306509273 -122.448001195404 (37.7151306509273, -122.448001195404) 9 7 6 28861 25
105223 179902 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1039 Woolsey St 9 Sidewalk: Property side : Yard Tree Private 2     7 Width 4ft   6008644.61497 2091242.09558 37.7226409262237 -122.412214613536 (37.7226409262237, -122.412214613536) 9 3 7 309 28
118052 52756 DPW Maintained 1 Taxus baccata :: Irish Yew 86 176@ GEARY Palm Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   05/04/2006 12:00:00 AM 7   Permit Number 48800 5995950.25747 2113100.83881 37.7819390591214 -122.457676787394 (37.7819390591214, -122.457676787394) 11 6 1 54 31
122775 215315 DPW Maintained 1 Taxus baccata :: Irish Yew 86 323 Tara St 6 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5997671.74515 2090080.76177 37.7188303557048 -122.450061568292 (37.7188303557048, -122.450061568292) 9 8 6 28861 24
123804 179868 DPW Maintained 1 Taxus baccata :: Irish Yew 86 345 Congdon St 3 Sidewalk: Property side : Yard Tree Private 2     7 Width 2ft   6004732.69466 2093569.91681 37.7288123277178 -122.425902888604 (37.7288123277178, -122.425902888604) 9 7 6 28861 5
144491 136651 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1490 Jefferson St 6 Sidewalk: Property side : Yard Tree Private 2     7 Width 2ft   6002148.06177 2121594.41755 37.8056143109046 -122.436843492933 (37.8056143109046, -122.436843492933) 13 9 1 57 17
146018 136674 DPW Maintained 1 Taxus baccata :: Irish Yew 86 2127 Broadway 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 4ft   6003286.01413 2117511.22224 37.7944675271099 -122.432613601844 (37.7944675271099, -122.432613601844) 13 9 1 29490 27
147312 215316 DPW Maintained 1 Taxus baccata :: Irish Yew 86 323 Tara St 7 Sidewalk: Curb side : Yard Tree Private 2     7 Width 3ft   5997674.77739 2090086.49914 37.7188462827039 -122.45005150039 (37.7188462827039, -122.45005150039) 9 8 6 28861 24
148428 179906 DPW Maintained 1 Taxus baccata :: Irish Yew 86 600 Somerset St 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 3ft   6010277.8918 2091719.16171 37.7240423622482 -122.406602309775 (37.7240423622482, -122.406602309775) 10 3 7 309 28
156393 136650 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1490 Jefferson St 5 Sidewalk: Property side : Yard Tree Private 2     7 Width 2ft   6002164.97809 2121597.31622 37.8056232312917 -122.436785159329 (37.8056232312917, -122.436785159329) 13 9 1 57 17
157954 179904 DPW Maintained 1 Taxus baccata :: Irish Yew 86 1039 Woolsey St 11 Sidewalk: Property side : Yard Tree Private 2     7 Width 4ft   6008652.42423 2091244.38754 37.7226476576547 -122.412187780452 (37.7226476576547, -122.412187780452) 9 3 7 309 28
159941 136686 DPW Maintained 1 Taxus baccata :: Irish Yew 86 915 Bay St 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 2ft   6006372.4804 2121073.97355 37.8044244898475 -122.42218727034 (37.8044244898475, -122.42218727034) 5 1 1 28858 32
162049 179857 DPW Maintained 1 Taxus baccata :: Irish Yew 86 2344 Alemany Blvd 1 Sidewalk: Property side : Yard Tree Private 2     7 Width 2ft   5999361.46611 2089227.95328 37.7165852836723 -122.444159646863 (37.7165852836723, -122.444159646863) 9 7 6 28861 25
177939 179858 DPW Maintained 1 Taxus baccata :: Irish Yew 86 2344 Alemany Blvd 2 Sidewalk: Property side : Yard Tree Private 2     7 Width 2ft   5999350.65317 2089217.81228 37.7165568219137 -122.444196293341 (37.7165568219137, -122.444196293341) 9 7 6 28861 25
181270 136675 DPW Maintained 1 Taxus baccata :: Irish Yew 86 2127 Broadway 3 Sidewalk: Property side : Yard Tree Private 2     7 Width 4ft   6003298.06459 2117513.66207 37.7944749096307 -122.432572080161 (37.7944749096307, -122.432572080161) 13 9 1 29490 27
753 197913 DPW Maintained 1 Taxus baccata :: Irish Yew 86 75 Conkling St 1 Sidewalk: Property side : Yard Tree Private 2     6 Width 8ft   6011758.24884 2095732.01029 37.7351435225424 -122.40176684758 (37.7351435225424, -122.40176684758) 10 3 8 58 1

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