Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▼ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 39496 | 39496 | 128828 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 435 Locust St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5997654.94419 | 2114925.25732 | 37.7870462100671 | -122.45191104747101 | (37.7870462100671, -122.451911047471) | |||
| 39523 | 39523 | 103291 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 50 Francisco St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3x3 | 6011052.07349 | 2121439.56361 | 37.8056911462811 | -122.406018820613 | (37.8056911462811, -122.406018820613) | |||
| 39958 | 39958 | 139227 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1401 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003610.8493 | 2113629.9476 | 37.783828947693294 | -122.43121245981199 | (37.7838289476933, -122.431212459812) | |||
| 40024 | 40024 | 225850 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 58 Liberty St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 9ft | 6005957.80102 | 2104057.14664 | 37.7576770490776 | -122.42241246056001 | (37.7576770490776, -122.42241246056) | |||
| 41129 | 41129 | 95156 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 21 | 5988717.78601 | 2113765.0163 | 37.7833445754979 | -122.48274619510799 | (37.7833445754979, -122.482746195108) | |||
| 41509 | 41509 | 54991 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 646 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 13 | 3x3 | Permit Number 10869 | 5990991.81393 | 2111001.00614 | 37.7758874082105 | -122.474677239765 | (37.7758874082105, -122.474677239765) | |
| 41861 | 41861 | 225839 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6010870.72267 | 2102625.60051 | 37.754022260038 | -122.40532066611 | (37.754022260038, -122.40532066611) | |||
| 42002 | 42002 | 247256 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 495 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5998886.7546 | 2109090.8048 | 37.7710967882875 | -122.44722920696002 | (37.7710967882875, -122.44722920696) | |||
| 42651 | 42651 | 246257 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 271 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6002925.2307 | 2106787.7129 | 37.7650029884026 | -122.433095412687 | (37.7650029884026, -122.433095412687) | |||
| 42999 | 42999 | 225871 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 187 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 3ft | 6006494.401190001 | 2098665.31091 | 37.742902554819004 | -122.420174017412 | (37.742902554819, -122.420174017412) | |||
| 43107 | 43107 | 141795 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1280 WEBSTER ST | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6003792.0243 | 2113029.1397 | 37.7821895448546 | -122.43054277764 | (37.7821895448546, -122.43054277764) | |||
| 43680 | 43680 | 225886 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 252 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6003516.0044 | 2106734.0164 | 37.764889044418794 | -122.43104824187901 | (37.7648890444188, -122.431048241879) | |||
| 44123 | 44123 | 201434 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 200 Harbor Rd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 4ft | 6018235.129430001 | 2094913.6539 | 37.7332557952224 | -122.37931686450099 | (37.7332557952224, -122.379316864501) | |||
| 44362 | 44362 | 225855 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1619 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 6004635.97757 | 2099333.5139200003 | 37.7446323980786 | -122.42664750570101 | (37.7446323980786, -122.426647505701) | |||
| 45480 | 45480 | 247292 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1177 Masonic Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5999383.1114 | 2108836.268 | 37.770426243584104 | -122.44549399211701 | (37.7704262435841, -122.445493992117) | |||
| 46057 | 46057 | 246266 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2298 Noe St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6002930.282000001 | 2106697.9127 | 37.7647567053947 | -122.43307152499901 | (37.7647567053947, -122.433071524999) | |||
| 46282 | 46282 | 225875 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 465 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6008974.19744 | 2106120.42477 | 37.763512036680495 | -122.412126303697 | (37.7635120366805, -122.412126303697) | |||
| 46467 | 46467 | 225824 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6011091.77167 | 2102559.41951 | 37.753852897909105 | -122.404551563217 | (37.7538528979091, -122.404551563217) | |||
| 46763 | 46763 | 225859 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 784 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 5998015.015430001 | 2107655.1459 | 37.7671049865286 | -122.450141071966 | (37.7671049865286, -122.450141071966) | |||
| 47911 | 47911 | 225862 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 198 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 5ft | 6006460.77519 | 2098675.0846599997 | 37.74292749660479 | -122.42029098054199 | (37.7429274966048, -122.420290980542) | |||
| 48870 | 48870 | 248472 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 739 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 5997932.4798 | 2107931.7687 | 37.7678597988713 | -122.45044649265101 | (37.7678597988713, -122.450446492651) | |||
| 48991 | 48991 | 225846 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 44 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 9ft | 6006029.75247 | 2104062.03373 | 37.7576945264884 | -122.422163969788 | (37.7576945264884, -122.422163969788) | |||
| 49098 | 49098 | 225864 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 5ft | 6006484.93585 | 2098722.65542 | 37.7430594766165 | -122.420210814975 | (37.7430594766165, -122.420210814975) | |||
| 49132 | 49132 | 57220 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2525 Judah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/09/1975 12:00:00 AM | 8 | Permit Number 14507 | 5986650.329 | 2105697.8423 | 37.761073880118396 | -122.489305344609 | (37.7610738801184, -122.489305344609) | ||
| 49857 | 49857 | 225874 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 455 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008970.66577 | 2106145.68989 | 37.7635812107387 | -122.412140304358 | (37.7635812107387, -122.412140304358) | |||
| 50660 | 50660 | 225854 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 70 Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 7ft | 6005875.84915 | 2104054.64821 | 37.757665565633395 | -122.422695706548 | (37.7576655656334, -122.422695706548) | |||
| 51104 | 51104 | 218982 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 765 Lakeview Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 5994400.37766 | 2089911.3418700001 | 37.7181774299307 | -122.46135702892599 | (37.7181774299307, -122.461357028926) | |||
| 52003 | 52003 | 128837 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2610 Clay St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6001930.71219 | 2116056.5883 | 37.790396526424104 | -122.43719890322399 | (37.7903965264241, -122.437198903224) | |||
| 52681 | 52681 | 103293 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 50 Francisco St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | 3x3 | 6010999.50344 | 2121432.93356 | 37.80567000143571 | -122.406200280445 | (37.8056700014357, -122.406200280445) | |||
| 52930 | 52930 | 54989 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 639 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 8 | Permit Number 10867 | 5990941.20394 | 2111018.6338299997 | 37.77593287632679 | -122.474853597928 | (37.7759328763268, -122.474853597928) | ||
| 53143 | 53143 | 225823 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6011090.95025 | 2102601.58592 | 37.7539686316657 | -122.404557371938 | (37.7539686316657, -122.404557371938) | |||
| 53618 | 53618 | 138097 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1716 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003549.5370000005 | 2114696.9008 | 37.7867550577771 | -122.43150077205 | (37.7867550577771, -122.43150077205) | |||
| 53721 | 53721 | 103292 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 50 Francisco St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 3x3 | 6011032.30685 | 2121439.6325 | 37.8056902298748 | -122.40608723115601 | (37.8056902298748, -122.406087231156) | |||
| 54232 | 54232 | 128829 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 435 Locust St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5997655.29995 | 2114907.57058 | 37.7869976673453 | -122.45190854016 | (37.7869976673453, -122.45190854016) | |||
| 54303 | 54303 | 246260 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2298 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002933.4837 | 2106633.9471 | 37.7645812529976 | -122.433055880666 | (37.7645812529976, -122.433055880666) | |||
| 54662 | 54662 | 40381 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 336 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/1999 12:00:00 AM | Permit Number 41493 | 6002951.47000009 | 2101559.64792523 | 37.7506494618032 | -122.432631180412 | (37.7506494618032, -122.432631180412) | |||
| 54867 | 54867 | 141878 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1130 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6003852.9179 | 2112548.3998 | 37.7808730023316 | -122.4302978041 | (37.7808730023316, -122.4302978041) | |||
| 55325 | 55325 | 140447 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1147 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003727.7488 | 2112779.9316 | 37.781501640262 | -122.43074735248899 | (37.781501640262, -122.430747352489) | |||
| 57216 | 57216 | 225868 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 29 | Width 5ft | 6006540.56065 | 2098821.81069 | 37.743334868812205 | -122.42002551416799 | (37.7433348688122, -122.420025514168) | |||
| 58381 | 58381 | 141796 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1280 WEBSTER ST | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6003788.4746 | 2113052.5677 | 37.782253671201794 | -122.43055673021999 | (37.7822536712018, -122.43055673022) | |||
| 58579 | 58579 | 139232 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1401 WEBSTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003638.8371 | 2113421.2053 | 37.7832573796845 | -122.43110072860901 | (37.7832573796845, -122.431100728609) | |||
| 58844 | 58844 | 141881 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1160 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6003834.0273 | 2112698.8952 | 37.781285155187796 | -122.430373896592 | (37.7812851551878, -122.430373896592) | |||
| 58945 | 58945 | 2685 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1785 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 4x4 | 6003437.92088 | 2114825.67122 | 37.7871023020297 | -122.431896135366 | (37.7871023020297, -122.431896135366) | |||
| 61569 | 61569 | 142009 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 625 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6004793.0024 | 2111561.975 | 37.7782177264629 | -122.426975313976 | (37.7782177264629, -122.426975313976) | |||
| 61678 | 61678 | 245995 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1211 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 5999389.3905 | 2108708.3738 | 37.770075436927705 | -122.44546307506901 | (37.7700754369277, -122.445463075069) | |||
| 61916 | 61916 | 57851 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1001 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/14/1977 12:00:00 AM | 20 | Permit Number 16792 | 6003796.0811 | 2112295.2301 | 37.780174641820004 | -122.430476360985 | (37.78017464182, -122.430476360985) | ||
| 62062 | 62062 | 225836 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6010877.083380001 | 2102509.67969 | 37.7537043227005 | -122.40529050644399 | (37.7537043227005, -122.405290506444) | |||
| 62366 | 62366 | 128835 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2610 Clay St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 5ft | 6002002.11764 | 2116066.62683 | 37.7904281483977 | -122.436952564533 | (37.7904281483977, -122.436952564533) | |||
| 62428 | 62428 | 225847 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 50 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 7ft | 6006004.32173 | 2104059.7557599996 | 37.75768683728929 | -122.42225175801501 | (37.7576868372893, -122.422251758015) | |||
| 63010 | 63010 | 141880 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1150 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6003846.6211 | 2112606.9608 | 37.7810334395886 | -122.43032376712799 | (37.7810334395886, -122.430323767128) | |||
| 63548 | 63548 | 140250 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 707 Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 28 | Width 0ft | 5999174.9773 | 2110335.2771 | 37.7745302567897 | -122.446321776898 | (37.7745302567897, -122.446321776898) | |||
| 63611 | 63611 | 225863 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 5ft | 6006477.67033 | 2098701.98839 | 37.743002320208795 | -122.420234470738 | (37.7430023202088, -122.420234470738) | |||
| 63943 | 63943 | 138106 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1120 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 0ft | 6003448.3155 | 2114793.5525 | 37.7870147014052 | -122.431857878063 | (37.7870147014052, -122.431857878063) | |||
| 64040 | 64040 | 225877 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1186 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008049.26481 | 2101038.17068 | 37.749505385374604 | -122.414965625261 | (37.7495053853746, -122.414965625261) | |||
| 64189 | 64189 | 245210 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1101 Page St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6001240.8957 | 2109337.497 | 37.771908375761704 | -122.439103853397 | (37.7719083757617, -122.439103853397) | |||
| 64422 | 64422 | 139266 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 780 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6004011.1502 | 2111430.7162 | 37.777813081545794 | -122.42967066249099 | (37.7778130815458, -122.429670662491) | |||
| 64512 | 64512 | 57085 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 725 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/22/1974 12:00:00 AM | 15 | Permit Number 14352 | 6011859.01316 | 2104976.52396 | 37.7605325827245 | -122.40206816360799 | (37.7605325827245, -122.402068163608) | ||
| 65364 | 65364 | 245086 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 163 Lyon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6000286.248 | 2109508.2514 | 37.772322857937205 | -122.44241830003 | (37.7723228579372, -122.44241830003) | |||
| 65465 | 65465 | 140521 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 911 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6003857.0949 | 2111847.4632 | 37.7789486411746 | -122.43023333245701 | (37.7789486411746, -122.430233332457) | |||
| 65708 | 65708 | 128832 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 2610 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6002198.1821 | 2116092.80029 | 37.7905111558262 | -122.436276069294 | (37.7905111558262, -122.436276069294) | |||
| 65804 | 65804 | 245998 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1211 Masonic Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999402.4121 | 2108663.858 | 37.769953951156 | -122.445414832365 | (37.769953951156, -122.445414832365) | |||
| 66357 | 66357 | 246256 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 281 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002934.772000001 | 2106740.5678 | 37.764874080629994 | -122.43305904308998 | (37.76487408063, -122.43305904309) | |||
| 66667 | 66667 | 246255 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 281 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6002935.3332 | 2106713.0665 | 37.7647986005719 | -122.433055137007 | (37.7647986005719, -122.433055137007) | |||
| 66920 | 66920 | 138005 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1701 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003469.0966 | 2114590.8212 | 37.7864592305121 | -122.431771499801 | (37.7864592305121, -122.431771499801) | |||
| 66955 | 66955 | 30368 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 406 Arkansas St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/03/1956 12:00:00 AM | 43 | Permit Number 56 | 6012907.774259999 | 2105144.73435 | 37.761052931381 | -122.398452757696 | (37.761052931381, -122.398452757696) | ||
| 67585 | 67585 | 138435 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1601 Webster St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003509.4651 | 2114326.3540000003 | 37.785735358539206 | -122.431612946728 | (37.7857353585392, -122.431612946728) | |||
| 69085 | 69085 | 225826 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 4ft | 6011095.54336 | 2102504.4626599997 | 37.7537022093019 | -122.40453465146601 | (37.7537022093019, -122.404534651466) | |||
| 69171 | 69171 | 201411 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 201 Harbor Rd | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6018303.48681 | 2094820.24532 | 37.7330030830165 | -122.379074046625 | (37.7330030830165, -122.379074046625) | |||
| 69771 | 69771 | 225837 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6010874.71509 | 2102536.14279 | 37.7537768521194 | -122.405300559996 | (37.7537768521194, -122.405300559996) | |||
| 69970 | 69970 | 142007 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 661 FULTON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 0ft | 6004595.1648 | 2111534.8819999998 | 37.7781321470778 | -122.427657776048 | (37.7781321470778, -122.427657776048) | |||
| 70099 | 70099 | 141636 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 701 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 0ft | 5999161.9551 | 2110417.0445 | 37.7747540254261 | -122.446372706542 | (37.7747540254261, -122.446372706542) | |||
| 70390 | 70390 | 142068 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1000 WEBSTER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003893.9859 | 2112297.2467 | 37.780185724477604 | -122.43013780751001 | (37.7801857244776, -122.43013780751) | |||
| 70852 | 70852 | 247505 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1170 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5999449.0461 | 2108807.2233 | 37.7703502580574 | -122.44526383601999 | (37.7703502580574, -122.44526383602) | |||
| 70878 | 70878 | 95154 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 250 23rd Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 20 | 5988718.8555 | 2113711.8550400003 | 37.783198671909794 | -122.48273859805 | (37.7831986719098, -122.48273859805) | |||
| 71343 | 71343 | 138432 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1601 Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 0ft | 6003502.2144 | 2114406.5958 | 37.785955271305 | -122.43164376298 | (37.785955271305, -122.43164376298) | |||
| 71663 | 71663 | 245122 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1160 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6001035.5995 | 2109350.537 | 37.7719324966998 | -122.43981492117099 | (37.7719324966998, -122.439814921171) | |||
| 71853 | 71853 | 139261 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 702 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 6004039.451 | 2111223.3243 | 37.777245237047794 | -122.429557965765 | (37.7772452370478, -122.429557965765) | |||
| 72530 | 72530 | 107389 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 773951 | 6002910.362819999 | 2106651.2793799997 | 37.7646275317101 | -122.433137087982 | (37.7646275317101, -122.433137087982) | ||||
| 73189 | 73189 | 138436 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1601 Webster St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6003517.0237 | 2114299.5361 | 37.7856621517715 | -122.431584880845 | (37.7856621517715, -122.431584880845) | |||
| 73522 | 73522 | 138438 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1601 Webster St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6003522.9999 | 2114255.78 | 37.7855423472789 | -122.431561079979 | (37.7855423472789, -122.431561079979) | |||
| 73857 | 73857 | 245143 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1272 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 0ft | 6000478.1977 | 2109271.929 | 37.7716849149487 | -122.441737366956 | (37.7716849149487, -122.441737366956) | |||
| 74402 | 74402 | 225834 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6010880.09664 | 2102425.6694099996 | 37.7534738174881 | -122.40527417026001 | (37.7534738174881, -122.40527417026) | |||
| 75023 | 75023 | 225844 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 20 Liberty St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 6ft | 6006115.25271 | 2104066.0613700002 | 37.757710407621204 | -122.421868560489 | (37.7577104076212, -122.421868560489) | |||
| 77057 | 77057 | 244222 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 403 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 0ft | 5998378.2216 | 2109230.1948 | 37.771450447350205 | -122.44899827507099 | (37.7714504473502, -122.448998275071) | |||
| 77091 | 77091 | 245948 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 751 Cole St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 0ft | 5997946.7127 | 2107822.2959 | 37.7675600290425 | -122.45038937038099 | (37.7675600290425, -122.450389370381) | |||
| 77445 | 77445 | 121460 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 58 Liberty St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6005944.89012346 | 2104064.54703238 | 37.757696640503895 | -122.42245763762101 | (37.7576966405039, -122.422457637621) | |||||
| 77596 | 77596 | 56267 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 20 Liberty St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1973 12:00:00 AM | 20 | 6x6 | Permit Number 12393 | 6006178.98761338 | 2104077.53782444 | 37.7577455134305 | -122.42164895373101 | (37.7577455134305, -122.421648953731) | |
| 77925 | 77925 | 5942 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1155X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 35 | 3X3 | 6003738.78415 | 2112752.38886 | 37.781426639976 | -122.430707209452 | (37.781426639976, -122.430707209452) | |||
| 78070 | 78070 | 14506 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 55 | 6X6 | 5999167.52145 | 2111070.84281 | 37.776549506017105 | -122.446400495731 | (37.7765495060171, -122.446400495731) | |||
| 78824 | 78824 | 167 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 185X Noe St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 6002905.5013881 | 2107191.4781257 | 37.7661105103373 | -122.433192503539 | (37.7661105103373, -122.433192503539) | ||||
| 80291 | 80291 | 21692 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1630X Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 4X4 | 6003612.6236388 | 2114305.6361391004 | 37.7856843190794 | -122.431254568258 | (37.7856843190794, -122.431254568258) | |||
| 80650 | 80650 | 23768 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1001 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 80 | 3X3 | 6003798.77229 | 2112300.9395 | 37.7801904708611 | -122.430467458421 | (37.7801904708611, -122.430467458421) | |||
| 80688 | 80688 | 14354 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 299X Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778955 | 6002931.216347099 | 2106726.8081779 | 37.7648360983599 | -122.43307035800699 | (37.7648360983599, -122.433070358007) | |
| 82086 | 82086 | 16681 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 251 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 10X9 | 6002922.02909 | 2106861.1200599996 | 37.765204365015705 | -122.43311173153799 | (37.7652043650157, -122.433111731538) | |||
| 82292 | 82292 | 21704 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1710X Webster St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | |||
| 82641 | 82641 | 10412 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1154X Masonic Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 5999422.66976 | 2108913.34746 | 37.7706401425115 | -122.445362703114 | (37.7706401425115, -122.445362703114) | ||||
| 83471 | 83471 | 142072 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1000 WEBSTER ST | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 6003881.1199 | 2112378.2677 | 37.780407459294295 | -122.430188098643 | (37.7804074592943, -122.430188098643) | |||
| 83963 | 83963 | 23741 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 856 Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 4X4 | 6003980.765967 | 2111671.7236867 | 37.7784731079824 | -122.429792966614 | (37.7784731079824, -122.429792966614) | |||
| 84315 | 84315 | 21700 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1710X Webster St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 6003481.65409 | 2114822.70407 | 37.7870966340846 | -122.431744616249 | (37.7870966340846, -122.431744616249) | |||
| 84493 | 84493 | 14510 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500X Masonic Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 6X6 | 5999167.52145 | 2111070.84281 | 37.776549506017105 | -122.446400495731 | (37.7765495060171, -122.446400495731) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");