556 rows where qSpecies_id = 71 sorted by rowid descending

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)
194099 176486 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 14 Blanken Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     27 Width 4ft   6011771.80954 2087312.16984 37.7120251219234 -122.401128515964 (37.7120251219234, -122.401128515964) 10 3 8 309 1
194082 138436 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1601 Webster St 8 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6003517.0237 2114299.5361 37.7856621517715 -122.431584880845 (37.7856621517715, -122.431584880845) 13 9 11 29490 13
193930 10418 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1219X Masonic Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 4X4   5999402.57096 2108712.61162 37.7700878253378 -122.445417788957 (37.7700878253378, -122.445417788957) 15 5 11 29492 9
193814 23927 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1715 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     90 4X4   6003460.7841 2114695.1886 37.7867453258178 -122.431807713622 (37.7867453258178, -122.431807713622) 13 9 11 29490 27
193007 8081 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 679 Fulton St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6004653.03771 2111392.08692 37.7777433402869 -122.427447397341 (37.7777433402869, -122.427447397341) 7 9 11 28852 10
192219 23748 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 900X Webster St 4 Sidewalk: Curb side : Cutout Tree DPW 1     38 4x4   6003941.8583 2111953.2204 37.7792438248983 -122.429947647907 (37.7792438248983, -122.429947647907) 7 9 11 29490 41
192127 140253 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 701 Masonic Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   5999184.6682 2110258.3552 37.7743196023733 -122.446282719732 (37.7743196023733, -122.446282719732) 15 5 11 29492 16
191978 246267 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 2298 Noe St 8 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6002943.1907 2106699.0352 37.7647605197291 -122.433026957416 (37.7647605197291, -122.433026957416) 15 5 5 28862 3
191863 192367 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1310 Indiana St 6 : Yard Tree Private 2     13     6014979.38493 2102511.0329 37.7539365393432 -122.391103802821 (37.7539365393432, -122.391103802821) 10 3 8 28856 29
191213 192377 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 500 Illinois St 6 Sidewalk: Property side : Yard Tree Private 2     12 Width 9ft   6015920.48189 2106647.80141 37.7653474018847 -122.388137911545 (37.7653474018847, -122.388137911545) 14 3 9 310 29
190962 103289 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 50 Francisco St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6011124.97439 2121449.08907 37.805721377897 -122.405767206501 (37.805721377897, -122.405767206501) 3 1 10 308 23
190536 138094 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1702 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6003569.3298 2114583.3281 37.7864443376028 -122.431424183077 (37.7864443376028, -122.431424183077) 13 9 11 29490 27
189751 128836 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 2610 Clay St 10 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6001965.16531 2116062.35333 37.7904143141248 -122.437080110864 (37.7904143141248, -122.437080110864) 13 6 1 29490 27
189729 225831 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1201 Utah St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6010886.07537 2102341.86633 37.7532440469824 -122.405247593515 (37.7532440469824, -122.405247593515) 10 4 8 28859 19
189628 23750 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 900X Webster St 6 Sidewalk: Curb side : Cutout Tree Private 2     40 4x4   6003934.1806 2112005.4294 37.7793867430583 -122.429977933491 (37.7793867430583, -122.429977933491) 7 9 11 29490 41
189168 225844 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 20 Liberty St 3 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 6ft   6006115.25271 2104066.06137 37.7577104076212 -122.421868560489 (37.7577104076212, -122.421868560489) 2 4 5 28859 19
188908 4564 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 203 Coleridge St 1 Sidewalk: Curb side : Cutout Tree DPW 1     30 4x4   6006429.48639 2098539.47391 37.7425533768305 -122.420389545351 (37.7425533768305, -122.420389545351) 2 7 7 28859 2
188847 141879 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1140 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6003851.0289 2112571.0685 37.7809351379405 -122.430305956855 (37.7809351379405, -122.430305956855) 7 9 11 29490 41
188447 245183 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 101 Baker St 3 Sidewalk: Curb side : Yard Tree Private 2     17 Width 0ft   6000788.1423 2109334.9151 37.7718755141223 -122.440669770843 (37.7718755141223, -122.440669770843) 15 5 11 29492 9
188357 192369 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1310 Indiana St 8 : Yard Tree Private 2     7     6014983.64642 2102476.35721 37.7538415637469 -122.391086641939 (37.7538415637469, -122.391086641939) 10 3 8 28856 29
188201 225835 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1201 Utah St 5 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6010878.34698 2102482.51525 37.7536298057935 -122.405284223809 (37.7536298057935, -122.405284223809) 10 4 8 28859 19
187804 140448 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1149 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6003730.1399 2112752.832 37.7814273669905 -122.43073714599 (37.7814273669905, -122.43073714599) 15 9 11 29490 41
187760 247736 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 900 Waller St 1 Front Yard : Yard Tree Private 2     26     6001355.82425 2108703.21094 37.7701733231789 -122.438660851038 (37.7701733231789, -122.438660851038) 15 5 11 29492 9
187704 16657 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 201 Noe St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6002910.8788077 2107093.8667075 37.7658427981924 -122.433166929024 (37.7658427981924, -122.433166929024) 15 5 5 28862 3
187251 253380 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 899 Waller St 2 Side Yard : Yard Tree Private 2           6001282 2108613 37.7699214264211 -122.438909742148 (37.7699214264211, -122.438909742148) 15 5 5 29492 9
186460 23738 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 848 Webster St 1 Sidewalk: Curb side : Cutout Tree DPW 1     90 4X4   6003984.4734674 2111644.7647146 37.7783992952615 -122.429778217597 (37.7783992952615, -122.429778217597) 7 9 11 29490 41
186406 138097 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1716 Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 0ft   6003549.537 2114696.9008 37.7867550577771 -122.43150077205 (37.7867550577771, -122.43150077205) 13 9 11 29490 27
186304 121459 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 58 Liberty St 3 Sidewalk: Curb side : Cutout Tree Private 2           6005944.89012346 2104064.54703238 37.7576966405039 -122.422457637621 (37.7576966405039, -122.422457637621) 2 4 5 28859 19
185734 138430 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1601 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 0ft   6003494.9636 2114451.5505 37.7860782945777 -122.431672059489 (37.7860782945777, -122.431672059489) 13 9 11 29490 13
185261 5943 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1407 Eddy St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6003673.95863 2112759.04875 37.7814412535167 -122.430931949696 (37.7814412535167, -122.430931949696) 15 9 11 29490 41
185162 225863 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 190 Coleridge St 7 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 5ft   6006477.67033 2098701.98839 37.7430023202088 -122.420234470738 (37.7430023202088, -122.420234470738) 2 7 7 28859 2
182925 142067 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1000 WEBSTER ST 3 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   6003899.9247 2112251.4221 37.7800602378696 -122.430113992512 (37.7800602378696, -122.430113992512) 7 9 11 29490 41
182461 138432 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1601 Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6003502.2144 2114406.5958 37.785955271305 -122.43164376298 (37.785955271305, -122.43164376298) 13 9 11 29490 13
182322 225869 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 190 Coleridge St 1 Sidewalk: Curb side : Cutout Tree Private 2     35 Width 5ft   6006549.95034 2098834.86462 37.7433712409909 -122.419993973142 (37.7433712409909, -122.419993973142) 2 7 7 28859 2
182025 128832 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 2610 Clay St 3 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 5ft   6002198.1821 2116092.80029 37.7905111558262 -122.436276069294 (37.7905111558262, -122.436276069294) 13 6 1 29490 27
182017 246974 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 255 Noe St 1 : Tree Private 2     22 Width 7ft   6002927.8614 2106813.40847 37.7650736914197 -122.433088149808 (37.7650736914197, -122.433088149808) 15 5 5 28862 3
181587 225854 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 70 Liberty St 3 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 7ft   6005875.84915 2104054.64821 37.7576655656334 -122.422695706548 (37.7576655656334, -122.422695706548) 2 4 5 28859 19
181566 128840 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 4 Francisco St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6011231.32586 2121455.93201 37.8057461137655 -122.405399641876 (37.8057461137655, -122.405399641876) 3 1 10 308 23
181445 23908 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1620 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     30 4X4   6003617.383911 2114271.2538834 37.78559018383 -122.431235644012 (37.78559018383, -122.431235644012) 13 9 11 29490 13
180409 23745 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 900X Webster St 1 Sidewalk: Curb side : Cutout Tree DPW 1     32 4x4   6003951.3115 2111867.7982 37.779009812059 -122.429908850506 (37.779009812059, -122.429908850506) 7 9 11 29490 41
180146 21718 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1649X Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     35 4X4   6003506.2579819 2114354.3884348 37.7858121522449 -122.431626044652 (37.7858121522449, -122.431626044652) 13 9 11 29490 13
180013 246256 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 281 Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   6002934.772 2106740.5678 37.76487408063 -122.43305904309 (37.76487408063, -122.43305904309) 15 5 5 28862 3
178895 16658 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 201 Noe St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6002910.8788077 2107093.8667075 37.7658427981924 -122.433166929024 (37.7658427981924, -122.433166929024) 15 5 5 28862 3
178695 23932 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1737 Webster St 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 4x4   6003450.6245 2114754.2993 37.7869070529375 -122.431847085623 (37.7869070529375, -122.431847085623) 13 9 11 29490 27
177463 128829 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 435 Locust St 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5997655.29995 2114907.57058 37.7869976673453 -122.45190854016 (37.7869976673453, -122.45190854016) 11 6 1 54 31
176467 142000 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 818 WEBSTER ST 10 Sidewalk: Curb side : Cutout Tree DPW 1     19 Width 0ft   6003967.2401 2111768.9836 37.7787393936814 -122.429846696894 (37.7787393936814, -122.429846696894) 7 9 11 29490 41
176091 247200 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 900 Waller St 14 Front Yard : Yard Tree Private 2     23     6001346.7374 2108658.67533 37.7700505225398 -122.438689090625 (37.7700505225398, -122.438689090625) 15 5 5 29492 9
176003 14346 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 299X Noe St 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002931.2163471 2106726.8081779 37.7648360983599 -122.433070358007 (37.7648360983599, -122.433070358007) 15 5 5 28862 3
175772 11006 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 55 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X4   6018247.9816681 2094597.6118588 37.7323887144105 -122.37925048612 (37.7323887144105, -122.37925048612) 10 3 8 58 1
175762 21705 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1710X Webster St 7 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
175258 51000 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 3000X Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2   08/31/2010 12:00:00 AM 3 3x3 Permit Number 774202 5999777.56327 2116411.25364 37.7912477140612 -122.444674131902 (37.7912477140612, -122.444674131902) 13 6 1 29490 27
174709 16660 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 201 Noe St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 2X3   6002906.0863 2107052.64489 37.76572934125 -122.433180559653 (37.76572934125, -122.433180559653) 15 5 5 28862 3
174324 246970 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 299 Noe St 2 : Tree DPW 1     9 Width 4ft   6002947.4073 2106634.57369 37.7645837632448 -122.433007767491 (37.7645837632448, -122.433007767491) 15 5 5 28862 3
174084 128839 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1661 Green St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6005108.54777 2118478.70027 37.7972271633692 -122.426376325029 (37.7972271633692, -122.426376325029) 13 9 1 57 17
173992 23800 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1160 Webster St 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6003835.7537369 2112705.7306783 37.7813040215007 -122.430368411811 (37.7813040215007, -122.430368411811) 7 9 11 29490 41
173668 247198 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 900 Waller St 12 Front Yard : Yard Tree Private 2     23     6001308.18443 2108654.86509 37.7700378672708 -122.438822171426 (37.7700378672708, -122.438822171426) 15 5 5 29492 9
173473 192360 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1 25th St 8 : Yard Tree Private 2     5     6015020.29565 2102164.47916 37.7529872464713 -122.390938103604 (37.7529872464713, -122.390938103604) 10 3 8 28856 29
173293 225856 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1242 Church St 1 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 5ft   6004441.23544 2101663.28988 37.7510184119866 -122.427486829467 (37.7510184119866, -122.427486829467) 2 4 5 28862 22
172913 218984 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 145 Vasquez Ave 1 Sidewalk: Curb side : Yard Tree Private 2     15 Width 3ft   5994984.80598 2099511.62786 37.744571095774 -122.460032023581 (37.744571095774, -122.460032023581) 1 8 4 59 40
170919 248242 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 296 Esmeralda Ave 2 Side Yard : Yard Tree Private 2     27     6006789.28659 2099004.18236 37.7438496308664 -122.419178415757 (37.7438496308664, -122.419178415757) 2 7 7 28859 2
170835 192368 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1310 Indiana St 7 : Yard Tree Private 2     6     6014962.22106 2102496.55555 37.7538958351351 -122.391162148138 (37.7538958351351, -122.391162148138) 10 3 8 28856 29
170756 23764 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 911 Webster St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6003870.64227 2111837.18218 37.7789211793615 -122.430185733043 (37.7789211793615, -122.430185733043) 15 9 11 29490 41
170602 11002 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 25 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X4   6018294.3685242 2094521.575214 37.7321824905391 -122.379084835175 (37.7321824905391, -122.379084835175) 10 3 8 58 1
170601 248182 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 216 Esmeralda Ave 1 Side Yard : Yard Tree Private 2     51     6007496.06144 2098688.36246 37.743022237487 -122.416712177939 (37.743022237487, -122.416712177939) 2 7 7 28859 2
170598 58360 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 457 Locust St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/20/1978 12:00:00 AM 16   Permit Number 17388 5997662.21392 2114878.66722 37.7869187023848 -122.45188253355 (37.7869187023848, -122.45188253355) 11 6 1 54 31
170517 139265 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 780 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft   6004014.6878 2111401.0888 37.7777319323367 -122.429656311107 (37.7777319323367, -122.429656311107) 7 9 11 28852 10
169929 139266 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 780 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 0ft   6004011.1502 2111430.7162 37.7778130815458 -122.429670662491 (37.7778130815458, -122.429670662491) 7 9 11 28852 10
168715 140250 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 701 Masonic Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     28 Width 0ft   5999174.9773 2110335.2771 37.7745302567897 -122.446321776898 (37.7745302567897, -122.446321776898) 15 5 11 29492 16
168325 245085 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 163 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 0ft   6000283.9214 2109528.1943 37.7723774835002 -122.442427779951 (37.7723774835002, -122.442427779951) 15 5 11 29492 9
168104 11001 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 20 Hudson Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6018345.6932697 2094533.4513275 37.7322179299469 -122.378908216579 (37.7322179299469, -122.378908216579) 10 3 8 58 1
167843 228132 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 236 Grattan St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/31/1973 12:00:00 AM 23 Width 3ft Permit Number 12386 5997539.90606 2106468.8722 37.7638205814857 -122.451698812867 (37.7638205814857, -122.451698812867) 15 5 11 29492 9
167732 192389 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 450 Amador St 3 Sidewalk: Curb side : Yard Tree Private 2     13 Width 5ft   6018217.013 2099612.23959 37.7461561769656 -122.379705821289 (37.7461561769656, -122.379705821289) 10 3 8 58 1
167222 138098 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1720 Webster St 5 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6003547.1807 2114720.4636 37.7868196217242 -122.431510607058 (37.7868196217242, -122.431510607058) 13 9 11 29490 27
167214 225845 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 38 Liberty St 1 Sidewalk: Curb side : Cutout Tree Private 2     22 Width 9ft   6006048.77626 2104063.35692 37.7576992326564 -122.422098271613 (37.7576992326564, -122.422098271613) 2 4 5 28859 19
167050 14531 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 701X Masonic Ave 1 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
166986 54990 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 643 16th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2   09/12/1972 12:00:00 AM 11   Permit Number 10868 5990941.26745 2111008.08375 37.7759039123762 -122.474852607991 (37.7759039123762, -122.474852607991) 11 6 2 54 26
166967 14358 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 299X Noe St 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6002934.58534 2106677.65284 37.7647013208388 -122.433055193266 (37.7647013208388, -122.433055193266) 15 5 5 28862 3
166912 14537 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 701X Masonic Ave 7 Sidewalk: Curb side : Cutout Tree City College 20     70 3X3   5999165.2663 2110445.36773 37.7748319828874 -122.446363290435 (37.7748319828874, -122.446363290435) 15 5 11 29492 16
166679 140622 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 701 WEBSTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     25 Width 0ft   6003947.4892 2111192.4634 37.7771552932763 -122.429873889239 (37.7771552932763, -122.429873889239) 7 9 11 29492 10
166353 102829 Undocumented 4 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 101 Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x12   6000750.2 2109361.5 37.7719463488262 -122.440802922949 (37.7719463488262, -122.440802922949) 15 5 11 29492 9
165243 103291 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 50 Francisco St 5 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6011052.07349 2121439.56361 37.8056911462811 -122.406018820613 (37.8056911462811, -122.406018820613) 3 1 10 308 23
165055 23747 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 900X Webster St 3 Sidewalk: Curb side : Cutout Tree Private 2     38 4x4   6003945.3133 2111922.8931 37.7791607493139 -122.429933531753 (37.7791607493139, -122.429933531753) 7 9 11 29490 41
164801 245928 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 745 Cole St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 0ft   5997937.6279 2107896.9433 37.7677644718406 -122.450426175235 (37.7677644718406, -122.450426175235) 15 5 11 29492 9
164408 201411 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 201 Harbor Rd 7 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6018303.48681 2094820.24532 37.7330030830165 -122.379074046625 (37.7330030830165, -122.379074046625) 10 3 8 58 1
163568 21699 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1710X Webster St 1 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
163217 225876 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 475 Alabama St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008973.72548 2106072.56722 37.7633806043531 -122.412124553603 (37.7633806043531, -122.412124553603) 8 4 7 28859 19
162798 225825 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1200 San Bruno Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6011093.6138 2102532.57214 37.7537792839011 -122.404543302929 (37.7537792839011, -122.404543302929) 10 4 8 28859 19
162674 225880 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 3426 20th St 2 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007377.89199 2104432.51269 37.7587877244056 -122.41752779468 (37.7587877244056, -122.41752779468) 2 4 7 28859 19
162195 225881 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 3426 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6007418.72238 2104432.80532 37.7587908252517 -122.417386604731 (37.7587908252517, -122.417386604731) 2 4 7 28859 19
162076 140694 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1003 WEBSTER ST 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 0ft   6003790.2787 2112326.7287 37.7802608004471 -122.430498682274 (37.7802608004471, -122.430498682274) 15 9 11 29490 41
162068 4571 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 229 Coleridge St 1 Sidewalk: Curb side : Cutout Tree DPW 1     32 4x4   6006415.89392 2098506.82504 37.7424629643998 -122.420434227284 (37.7424629643998, -122.420434227284) 2 7 7 28859 2
161727 14538 Permitted Site 7 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 701X Masonic Ave 8 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
161560 140521 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 911 WEBSTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft   6003857.0949 2111847.4632 37.7789486411746 -122.430233332457 (37.7789486411746, -122.430233332457) 15 9 11 29490 41
161236 138099 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1730 Webster St 6 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6003544.3532 2114749.2102 37.786898392368 -122.431522442538 (37.786898392368, -122.431522442538) 13 9 11 29490 27
161129 225823 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 1200 San Bruno Ave 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6011090.95025 2102601.58592 37.7539686316657 -122.404557371938 (37.7539686316657, -122.404557371938) 10 4 8 28859 19
161128 14355 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 299X Noe St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002931.2163471 2106726.8081779 37.7648360983599 -122.433070358007 (37.7648360983599, -122.433070358007) 15 5 5 28862 3
160207 107388 Undocumented 4 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 299X Noe St 2 Sidewalk: Property 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
159802 10550 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 217 Harbor Rd 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/12/1992 12:00:00 AM 12 3X4   6018348.7736836 2094772.4250311 37.7328742748645 -122.378914156582 (37.7328742748645, -122.378914156582) 10 3 8 58 1
159793 140110 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 590 Masonic Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 0ft   5999154.3839 2110993.6634 37.7763368408046 -122.446440388413 (37.7763368408046, -122.446440388413) 15 5 11 29492 16
159209 128828 DPW Maintained 1 Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 435 Locust St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5997654.94419 2114925.25732 37.7870462100671 -122.451911047471 (37.7870462100671, -122.451911047471) 11 6 1 54 31

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