556 rows where qSpecies_id = 71

View and edit SQL

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)
76134 109289 Undocumented 4 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 26X Blanken Ave 2 Sidewalk: Curb side : Cutout Tree Private 2           6011707.98734 2087352.96474 37.7121335759116 -122.401351970141 (37.7121335759116, -122.401351970141) 10 3 8 309 1
76431 246971 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 281 Noe St 1 : Tree Private 2     8 Width 4ft   6002932.26985 2106723.06084 37.7648258688387 -122.433066446456 (37.7648258688387, -122.433066446456) 15 5 5 28862 3
76455 54989 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 639 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/1972 12:00:00 AM 8   Permit Number 10867 5990941.20394 2111018.63383 37.7759328763268 -122.474853597928 (37.7759328763268, -122.474853597928) 11 6 2 54 26
77259 192382 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 500 Illinois St 12 Sidewalk: Property side : Yard Tree Private 2     11 Width 9ft   6015926.91076 2106504.64628 37.7649546850211 -122.388105684345 (37.7649546850211, -122.388105684345) 14 3 9 310 29
77595 11010 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 85 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X4   6018199.1590574 2094619.5131788 37.7324461587057 -122.379420799908 (37.7324461587057, -122.379420799908) 10 3 8 58 1
77825 251640 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1785 Webster St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6003432 2114811 37.7870616829204 -122.431915572303 (37.7870616829204, -122.431915572303) 13 9 11 29490 27
78335 139235 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1401 WEBSTER ST 11 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6003653.9972 2113322.0819 37.7829860707073 -122.431041203749 (37.7829860707073, -122.431041203749) 15 9 11 29490 41
78428 246975 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 247 Noe St 2 : Tree Private 2     18 Width 7ft   6002924.19309 2106865.87751 37.7652175505697 -122.433104586729 (37.7652175505697, -122.433104586729) 15 5 5 28862 3
78552 17330 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 150 Otis St 6 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006661.1201948 2108857.0849494 37.770896202588 -122.420320765713 (37.770896202588, -122.420320765713) 8 2 9 28853 19
78616 23803 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1160 Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2     60 3X3   6003835.7537369 2112705.7306783 37.7813040215007 -122.430368411811 (37.7813040215007, -122.430368411811) 7 9 11 29490 41
79161 14515 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 515 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     15 4X4   5999080.7636 2111027.2361 37.7764248176545 -122.446697476687 (37.7764248176545, -122.446697476687) 15 5 2 29492 16
79209 245144 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1274 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 0ft   6000455.2634 2109270.2671 37.7716790450125 -122.441816578597 (37.7716790450125, -122.441816578597) 15 5 11 29492 9
79745 138004 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1701 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 0ft   6003467.7112 2114620.8384 37.7865415716279 -122.431778436947 (37.7865415716279, -122.431778436947) 13 9 11 29490 27
79900 225867 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 190 Coleridge St 3 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 5ft   6006525.15417 2098793.36254 37.7432558885579 -122.420076767448 (37.7432558885579, -122.420076767448) 2 7 7 28859 2
80208 23917 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1639 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     25 4X4   6003511.011206 2114320.0570948 37.7857181564596 -122.431607147924 (37.7857181564596, -122.431607147924) 13 9 11 29490 13
81236 107394 Undocumented 4 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 299X Noe St 8 Sidewalk: Property side : Cutout Tree Private 2           6002910.36282 2106651.27938 37.7646275317101 -122.433137087982 (37.7646275317101, -122.433137087982) 15 5 5 28862 3
81709 23706 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 700X Webster St 1 Median : Cutout Tree DPW 1     80 8X8   6003994.1877 2111257.6303 37.7773368699173 -122.429716993438 (37.7773368699173, -122.429716993438) 7 9 11 28852 10
81746 192381 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 500 Illinois St 11 Sidewalk: Property side : Yard Tree Private 2     16 Width 9ft   6015923.36734 2106564.05052 37.7651175999097 -122.38812208619 (37.7651175999097, -122.38812208619) 14 3 9 310 29
81873 225873 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 822 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6009090.83473 2104278.80303 37.7584619072188 -122.411592765614 (37.7584619072188, -122.411592765614) 2 4 7 28859 19
82553 247196 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 900 Waller St 10 Front Yard : Yard Tree Private 2     20     6001271.52633 2108649.87649 37.7700220841792 -122.438948613411 (37.7700220841792, -122.438948613411) 15 5 5 29492 9
83231 248181 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 218 Esmeralda Ave 10 Side Yard : Yard Tree Private 2     32     6007478.19635 2098656.73242 37.7429343836221 -122.41677171037 (37.7429343836221, -122.41677171037) 2 7 7 28859 2
83455 109833 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 2525 Judah St 2 Sidewalk: Curb side : Cutout Tree Private 2     6     5986661.7219 2105698.5773 37.761076563265 -122.489265996065 (37.761076563265, -122.489265996065) 1 8 3 56 35
83991 11013 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 95 Hudson Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X4   6018177.8841382 2094612.4287261 37.7324255328509 -122.379493861146 (37.7324255328509, -122.379493861146) 10 3 8 58 1
84198 17334 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 170 Otis St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006561.61722 2108839.89648 37.7708433996885 -122.420663729244 (37.7708433996885, -122.420663729244) 8 2 9 28853 19
84478 21715 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1711X Webster St 2 Sidewalk: Curb side : Cutout Tree DPW 1     40 4X4   6003474.1759741 2114557.4451345 37.7863678761913 -122.431751542559 (37.7863678761913, -122.431751542559) 13 9 11 29490 27
85883 138434 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1601 Webster St 6 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 0ft   6003509.9485 2114351.9734 37.7858057303506 -122.431613104021 (37.7858057303506, -122.431613104021) 13 9 11 29490 13
86160 140447 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1147 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6003727.7488 2112779.9316 37.781501640262 -122.430747352489 (37.781501640262, -122.430747352489) 15 9 11 29490 41
86341 8109 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 790X Webster St 1 Sidewalk: Curb side : Cutout Tree DPW 1     70 4X4   6004003.8918438 2111454.7703146 37.7778787172016 -122.429697487702 (37.7778787172016, -122.429697487702) 7 9 11 28852 10
87062 104651 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 21 Beaver St   Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 770906 6002646.8 2106754 37.7648946232156 -122.434056023873 (37.7648946232156, -122.434056023873) 15 5 5 28862 3
87200 117712 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 499 41st Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 3ft   5983131.36299 2112604.59919 37.7798318029571 -122.501986802339 (37.7798318029571, -122.501986802339) 11 6 2 55 26
87389 23710 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 700X Webster St 5 Median : Cutout Tree DPW 1     20 20   6003962.5277 2111419.0963 37.7777784228578 -122.429838035535 (37.7777784228578, -122.429838035535) 7 9 11 29492 10
87636 103288 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 50 Francisco St 2 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6011153.48298 2121450.51033 37.8057268745504 -122.405668647988 (37.8057268745504, -122.405668647988) 3 1 10 308 23
87895 225843 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 20 Liberty St 2 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 6ft   6006135.09604 2104067.35501 37.7577150787036 -122.421800025871 (37.7577150787036, -122.421800025871) 2 4 5 28859 19
88282 138105 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1120 WEBSTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 0ft   6003444.1593 2114828.1877 37.7871095652954 -122.431874731573 (37.7871095652954, -122.431874731573) 13 9 11 29490 27
88413 50967 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 225 Rutland St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/21/1974 12:00:00 AM     Permit Number 47461 6010511.43889259 2088929.82162599 37.7163964722207 -122.405598602601 (37.7163964722207, -122.405598602601) 9 7 8 309 39
88725 30368 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 406 Arkansas St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/03/1956 12:00:00 AM 43   Permit Number 56 6012907.77426 2105144.73435 37.761052931381 -122.398452757696 (37.761052931381, -122.398452757696) 10 3 8 28856 29
89678 52015 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 282 29th St 4 Sidewalk: Curb side : Cutout Tree Private 2   09/12/2005 12:00:00 AM     Permit Number 48233 6004742.33522921 2099026.78484359 37.7437962026999 -122.426257908124 (37.7437962026999, -122.426257908124) 2 7 5 63 22
89703 225852 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 58 Liberty St 4 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 9ft   6005926.46484 2104057.0106 37.7576749077845 -122.422520824396 (37.7576749077845, -122.422520824396) 2 4 5 28859 19
91566 104328 Undocumented 4 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 21 Beaver St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 770906 6002767 2106786 37.76498930837 -122.433642570245 (37.76498930837, -122.433642570245) 15 5 5 28862 3
91666 246257 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 271 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6002925.2307 2106787.7129 37.7650029884026 -122.433095412687 (37.7650029884026, -122.433095412687) 15 5 5 28862 3
92068 10421 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1219X Masonic Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     50 3X3   5999421.35342 2108678.34127 37.7699947998181 -122.44535035645 (37.7699947998181, -122.44535035645) 15 5 11 29492 9
92803 245998 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1211 Masonic Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5999402.4121 2108663.858 37.769953951156 -122.445414832365 (37.769953951156, -122.445414832365) 15 5 11 29492 9
92982 140520 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 911 WEBSTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft   6003853.2967 2111871.7714 37.7790151703313 -122.430248206636 (37.7790151703313, -122.430248206636) 15 9 11 29490 41
93267 248455 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 722 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 0ft   5997972.3018 2107953.8752 37.7679227767606 -122.450310347361 (37.7679227767606, -122.450310347361) 15 5 11 29492 9
94053 107393 Undocumented 4 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 299X Noe St 7 Sidewalk: Curb side : Cutout Tree Private 2           6002910.36282 2106651.27938 37.7646275317101 -122.433137087982 (37.7646275317101, -122.433137087982) 15 5 5 28862 3
94799 14535 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 701X Masonic Ave 5 Sidewalk: Curb side : Cutout Tree City College 20     100 3X3   5999165.2663 2110445.36773 37.7748319828874 -122.446363290435 (37.7748319828874, -122.446363290435) 15 5 11 29492 16
94950 11004 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 40 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6018314.1623349 2094585.1363671 37.7323581084588 -122.379020815535 (37.7323581084588, -122.379020815535) 10 3 8 58 1
95699 139227 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1401 WEBSTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6003610.8493 2113629.9476 37.7838289476933 -122.431212459812 (37.7838289476933, -122.431212459812) 13 9 11 29490 41
96016 23850 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1401X Webster St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6003612.0155 2113606.6244 37.7837649741264 -122.431206759864 (37.7837649741264, -122.431206759864) 13 9 11 29490 41
96184 107386 Undocumented 4 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 26x BLANKEN AVE 1 Sidewalk: Curb side : Cutout Tree Private 2     22 3x3   6011510 2087367 37.712161065506 -122.402037262127 (37.712161065506, -122.402037262127) 10 3 8 309 1
96399 245143 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1272 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6000478.1977 2109271.929 37.7716849149487 -122.441737366956 (37.7716849149487, -122.441737366956) 15 5 11 29492 9
97191 142059 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1000 WEBSTER ST 9 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6003872.0789 2112451.9864 37.7806093604309 -122.43022463646 (37.7806093604309, -122.43022463646) 7 9 11 29490 41
99065 245927 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 745 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   5997935.2052 2107912.9933 37.7678084023919 -122.45043571219 (37.7678084023919, -122.45043571219) 15 5 11 29492 9
100009 176485 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 775 Edinburgh St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6001969.46269 2089311.7454 37.7169637984193 -122.435151113644 (37.7169637984193, -122.435151113644) 9 7 6 28861 5
100806 107500 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1101x PAGE ST 3 Sidewalk: Curb side : Cutout Tree Private 2     14 4x4 Permit Number 773474 6001297 2109248 37.7716658315653 -122.438903370258 (37.7716658315653, -122.438903370258) 15 5 11 29492 9
100961 140251 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 701 Masonic Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     26 Width 0ft   5999178.3085 2110310.1412 37.7744614302846 -122.446308445103 (37.7744614302846, -122.446308445103) 15 5 11 29492 16
101086 10411 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1160 Masonic Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     20 4X4   5999445.7253 2108826.6734 37.7704034735557 -122.445276721272 (37.7704034735557, -122.445276721272) 15 5 11 29492 9
101395 23717 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 755 Webster St 1 Sidewalk: Curb side : Cutout Tree DPW 1     80 4X4   6003929.8516061 2111310.486379 37.7774783563958 -122.429943324105 (37.7774783563958, -122.429943324105) 7 9 11 29492 10
101488 16653 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 198 Noe St 2 Sidewalk: Curb side : Cutout Tree DPW 1     30 6X6   6002873.07681 2107160.80802 37.7660244582848 -122.433302461864 (37.7660244582848, -122.433302461864) 15 5 5 28862 3
101775 21701 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1710X Webster St 3 Sidewalk: Curb side : Cutout Tree DPW 1     40 3x3   6003481.65409 2114822.70407 37.7870966340846 -122.431744616249 (37.7870966340846, -122.431744616249) 13 9 11 29490 27
102087 192385 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 500 Illinois St 18 Sidewalk: Property side : Yard Tree Private 2     19 Width 9ft   6015934.88312 2106386.42358 37.7646305127095 -122.388069858948 (37.7646305127095, -122.388069858948) 14 3 9 310 29
102316 4434 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1246 Church St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 4X4   6004452.33203 2101636.8791292 37.7509465218336 -122.427446575049 (37.7509465218336, -122.427446575049) 2 4 5 28862 22
102445 60678 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1160 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/05/1983 12:00:00 AM   6x5 Permit Number 20316 6001007.89737324 2109351.27378976 37.7719329428525 -122.439910797466 (37.7719329428525, -122.439910797466) 15 5 11 29492 9
102965 138106 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1120 WEBSTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 0ft   6003448.3155 2114793.5525 37.7870147014052 -122.431857878063 (37.7870147014052, -122.431857878063) 13 9 11 29490 27
103065 21703 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1710X Webster St 5 Sidewalk: Curb side : Cutout Tree DPW 1     50 3x3   6003481.65409 2114822.70407 37.7870966340846 -122.431744616249 (37.7870966340846, -122.431744616249) 13 9 11 29490 27
103315 23782 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1010 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     35 3X3   6003903.8361546 2112182.8886989 37.7798722837048 -122.430095570639 (37.7798722837048, -122.430095570639) 7 9 11 29490 41
103837 140106 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 590 Masonic Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     28 Width 0ft   5999163.5213 2110903.9816 37.7760911194684 -122.446402326499 (37.7760911194684, -122.446402326499) 15 5 11 29492 16
104041 254801 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 700 Brotherhood Way 24 Sidewalk: Curb side : Cutout Tree Private 2       4x9   5991178 2088065 37.7129218386335 -122.472360778797 (37.7129218386335, -122.472360778797) 1 8 4 64 14
104067 255325 Significant Tree 6 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 42 Lippard Ave 1 Front Yard : Yard Tree Private 2       Width 0ft Permit Number 781812 6002006.02273 2095939.48888 37.7351641583954 -122.435498605394 (37.7351641583954, -122.435498605394) 2 7 5 63 7
104201 141880 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1150 WEBSTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6003846.6211 2112606.9608 37.7810334395886 -122.430323767128 (37.7810334395886, -122.430323767128) 7 9 11 29490 41
104497 10420 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1219X Masonic Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     100 3X3   5999405.64403 2108687.20317 37.7700182355876 -122.445405332062 (37.7700182355876, -122.445405332062) 15 5 11 29492 9
104724 11007 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 60 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6018282.6314 2094636.8214067 37.7324982868599 -122.379133414916 (37.7324982868599, -122.379133414916) 10 3 8 58 1
105088 138415 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1600 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6003590.5786 2114415.133 37.7859837205396 -122.431338656815 (37.7859837205396, -122.431338656815) 13 9 11 29490 13
105123 225870 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 154 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6006559.10741 2098855.11424 37.7434273578018 -122.419963746949 (37.7434273578018, -122.419963746949) 2 7 7 28859 2
105388 245086 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 163 Lyon St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6000286.248 2109508.2514 37.7723228579372 -122.44241830003 (37.7723228579372, -122.44241830003) 15 5 11 29492 9
105657 59133 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 730 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/1980 12:00:00 AM 24   Permit Number 18438 5992594.65054267 2110474.91091897 37.7745356377316 -122.469094367405 (37.7745356377316, -122.469094367405) 11 6 2 54 11
105719 225830 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1200 San Bruno Ave 12 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6011105.21745 2102361.77794 37.7533109691405 -122.404491153067 (37.7533109691405, -122.404491153067) 10 4 8 28859 19
105825 14347 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 299X Noe St 11 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6002931.2163471 2106726.8081779 37.7648360983599 -122.433070358007 (37.7648360983599, -122.433070358007) 15 5 5 28862 3
106065 225836 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1201 Utah St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6010877.08338 2102509.67969 37.7537043227005 -122.405290506444 (37.7537043227005, -122.405290506444) 10 4 8 28859 19
106754 16683 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 255 Noe St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 10X9   6002919.68827 2106838.75041 37.7651428106103 -122.433118229438 (37.7651428106103, -122.433118229438) 15 5 5 28862 3
106998 140248 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 701 Masonic Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft   5999166.4977 2110388.5774 37.7746761214933 -122.446354944507 (37.7746761214933, -122.446354944507) 15 5 11 29492 16
108140 107391 Undocumented 4 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 299X Noe St 5 Sidewalk: Curb side : Cutout Tree Private 2           6002910.36282 2106651.27938 37.7646275317101 -122.433137087982 (37.7646275317101, -122.433137087982) 15 5 5 28862 3
108279 51601 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1250 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/04/2005 12:00:00 AM     Permit Number 47896 6000577.00438268 2109291.24211111 37.7717435732091 -122.44139697552 (37.7717435732091, -122.44139697552) 15 5 11 29492 9
108353 145278 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 730 11th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   03/20/2017 12:00:00 AM 0 Width 3ft Permit Number 779614 5992589.96157 2110455.11477 37.7744810119102 -122.469109146279 (37.7744810119102, -122.469109146279) 11 6 2 54 11
108712 246260 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 2298 Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6002933.4837 2106633.9471 37.7645812529976 -122.433055880666 (37.7645812529976, -122.433055880666) 15 5 5 28862 3
109157 192379 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 500 Illinois St 8 Sidewalk: Property side : Yard Tree Private 2     8 Width 9ft   6015920.8983 2106611.50942 37.7652477749961 -122.38813393835 (37.7652477749961, -122.38813393835) 14 3 9 310 29
109293 247506 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1156 Masonic Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   5999445.2509 2108843.2771 37.7704490360361 -122.445279556183 (37.7704490360361, -122.445279556183) 15 5 11 29492 9
109554 139228 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1401 WEBSTER ST 4 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 0ft   6003615.514 2113580.969 37.7836947290906 -122.43119282453 (37.7836947290906, -122.43119282453) 13 9 11 29490 41
109836 128838 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1614 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6005643.34494 2118253.58513 37.7966392702321 -122.424509769525 (37.7966392702321, -122.424509769525) 13 9 1 28858 17
110074 140252 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 701 Masonic Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 0ft   5999181.9426 2110282.5826 37.774385968961 -122.446293891234 (37.774385968961, -122.446293891234) 15 5 11 29492 16
110181 192384 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 500 Illinois St 14 Sidewalk: Property side : Yard Tree Private 2     10 Width 9ft   6015929.33713 2106466.90045 37.7648511775542 -122.38809465775 (37.7648511775542, -122.38809465775) 14 3 9 310 29
110198 107387 Undocumented 4 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 299X Noe St 1 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 773951 6002910.36282 2106651.27938 37.7646275317101 -122.433137087982 (37.7646275317101, -122.433137087982) 15 5 5 28862 3
110305 142007 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 661 FULTON ST 1 Sidewalk: Curb side : Cutout Tree Private 2     23 Width 0ft   6004595.1648 2111534.882 37.7781321470778 -122.427657776048 (37.7781321470778, -122.427657776048) 7 9 11 28852 10
110744 60698 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 918 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM 15   Permit Number 20345 6009112.76031538 2103802.68080771 37.7571558133036 -122.411483299228 (37.7571558133036, -122.411483299228) 2 4 7 28859 19
111127 246972 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 281 Noe St 2 : Tree Private 2     12 Width 4ft   6002932.11099 2106737.87543 37.7648665370939 -122.433068054458 (37.7648665370939, -122.433068054458) 15 5 5 28862 3
111436 139232 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1401 WEBSTER ST 8 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6003638.8371 2113421.2053 37.7832573796845 -122.431100728609 (37.7832573796845, -122.431100728609) 15 9 11 29490 41
111702 23906 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1605 Webster St 1 Sidewalk: Curb side : Cutout Tree DPW 1     13 4X4   6003542.7980522 2114194.1073783 37.7853741319224 -122.431488179889 (37.7853741319224, -122.431488179889) 13 9 11 29490 13
111755 109415 Significant Tree 6 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 4 GUY PL 2 Front Yard : Yard Tree Private 2           6014378.1 2114502.6 37.7868293368446 -122.394022608955 (37.7868293368446, -122.394022608955) 6 2 9 28855 6
111832 253382 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 899 Waller St 4 Side Yard : Yard Tree Private 2           6001282 2108613 37.7699214264211 -122.438909742148 (37.7699214264211, -122.438909742148) 15 5 5 29492 9
111879 225837 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1201 Utah St 7 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6010874.71509 2102536.14279 37.7537768521194 -122.405300559996 (37.7537768521194, -122.405300559996) 10 4 8 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)
);