Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 128834 | 128834 | 1324 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 4051X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 50 | 3x3 | 5991764.76245 | 2086963.37686 | 37.709930989883496 | -122.47025258193399 | (37.7099309898835, -122.470252581934) | |||
| 32970 | 32970 | 176487 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 14 Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 4ft | 6011797.051530001 | 2087306.90558 | 37.7120120754601 | -122.401040902239 | (37.7120120754601, -122.401040902239) | |||
| 152600 | 152600 | 176486 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 14 Blanken Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 4ft | 6011771.80954 | 2087312.16984 | 37.712025121923396 | -122.40112851596399 | (37.7120251219234, -122.401128515964) | |||
| 90894 | 90894 | 109289 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 26X Blanken Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6011707.98734 | 2087352.9647400002 | 37.7121335759116 | -122.401351970141 | (37.7121335759116, -122.401351970141) | |||||
| 101948 | 101948 | 107386 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 26x BLANKEN AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 3x3 | 6011510.0 | 2087367.0 | 37.712161065506 | -122.402037262127 | (37.712161065506, -122.402037262127) | |||
| 95437 | 95437 | 50967 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 225 Rutland St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/21/1974 12:00:00 AM | Permit Number 47461 | 6010511.43889259 | 2088929.82162599 | 37.7163964722207 | -122.40559860260099 | (37.7163964722207, -122.405598602601) | |||
| 162419 | 162419 | 176485 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 775 Edinburgh St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6001969.46269 | 2089311.7454 | 37.7169637984193 | -122.43515111364401 | (37.7169637984193, -122.435151113644) | |||
| 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) | |||
| 23876 | 23876 | 218979 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 551 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991462.95986 | 2093729.88952 | 37.7284927194476 | -122.47178846497101 | (37.7284927194476, -122.471788464971) | |||
| 131678 | 131678 | 218980 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 501 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 3ft | 5991479.42203 | 2093975.5381 | 37.729168161565596 | -122.47174944968 | (37.7291681615656, -122.47174944968) | |||
| 55255 | 55255 | 218981 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 501 Junipero Serra Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5991484.23887 | 2094055.3535200001 | 37.7293875934485 | -122.47173861195 | (37.7293875934485, -122.47173861195) | |||
| 124482 | 124482 | 10997 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 3X Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6018318.9881754005 | 2094475.1533634998 | 37.732056382705004 | -122.378996495822 | (37.732056382705, -122.378996495822) | |||
| 117497 | 117497 | 11002 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 25 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018294.3685242 | 2094521.575214 | 37.7321824905391 | -122.379084835175 | (37.7321824905391, -122.379084835175) | |||
| 122617 | 122617 | 11001 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 20 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018345.6932697 | 2094533.4513275002 | 37.7322179299469 | -122.37890821657899 | (37.7322179299469, -122.378908216579) | |||
| 169571 | 169571 | 218978 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 635 Joost Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 5997875.75574 | 2094965.1361 | 37.7322533730829 | -122.449708177017 | (37.7322533730829, -122.449708177017) | ||||
| 94656 | 94656 | 11004 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 40 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018314.1623349 | 2094585.1363671 | 37.7323581084588 | -122.37902081553499 | (37.7323581084588, -122.379020815535) | |||
| 142601 | 142601 | 11006 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 55 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6018247.9816681 | 2094597.6118588 | 37.7323887144105 | -122.37925048612 | (37.7323887144105, -122.37925048612) | |||
| 85524 | 85524 | 11012 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 95 Hudson Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018177.8841382 | 2094612.4287261001 | 37.7324255328509 | -122.37949386114599 | (37.7324255328509, -122.379493861146) | |||
| 97084 | 97084 | 11013 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 95 Hudson Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X4 | 6018177.8841382 | 2094612.4287261001 | 37.7324255328509 | -122.37949386114599 | (37.7324255328509, -122.379493861146) | |||
| 110819 | 110819 | 11005 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 50 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018298.396867501 | 2094610.9788869 | 37.7324281976732 | -122.37907711517201 | (37.7324281976732, -122.379077115172) | |||
| 95235 | 95235 | 11010 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 85 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X4 | 6018199.1590574 | 2094619.5131788002 | 37.7324461587057 | -122.379420799908 | (37.7324461587057, -122.379420799908) | |||
| 101591 | 101591 | 11007 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 60 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6018282.6314 | 2094636.8214067002 | 37.7324982868599 | -122.379133414916 | (37.7324982868599, -122.379133414916) | |||
| 105990 | 105990 | 11009 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 80 Hudson Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6018206.0401963 | 2094670.6666495 | 37.7325869956158 | -122.379400561989 | (37.7325869956158, -122.379400561989) | |||
| 118584 | 118584 | 10550 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 217 Harbor Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1992 12:00:00 AM | 12 | 3X4 | 6018348.7736836 | 2094772.4250311002 | 37.7328742748645 | -122.378914156582 | (37.7328742748645, -122.378914156582) | ||
| 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) | |||
| 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) | |||
| 136872 | 136872 | 201408 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 201 Harbor Rd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6018149.85399 | 2094926.3080400003 | 37.7332858379605 | -122.379612566976 | (37.7332858379605, -122.379612566976) | |||
| 128617 | 128617 | 10559 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 266 Harbor Rd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/1992 12:00:00 AM | 18 | 3X4 | 6018220.577079 | 2094928.7869737998 | 37.733296545147795 | -122.379368227321 | (37.7332965451478, -122.379368227321) | ||
| 68047 | 68047 | 218985 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 735 Foerster St | 1 | Back Yard : Yard 13 | Tree 1 | Private 1 | 15 | Width 3ft | 5998106.15759 | 2095768.84675 | 37.7344733504624 | -122.448969503563 | (37.7344733504624, -122.448969503563) | |||
| 2149 | 2149 | 225887 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 117 Conrad St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/27/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 42143 | 6001804.962730001 | 2096660.33983 | 37.73713202700829 | -122.436245312495 | (37.7371320270083, -122.436245312495) | |
| 18912 | 18912 | 4820 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 398X Coleridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 4x4 | 6006006.1956778 | 2097849.2293648 | 37.7406342583881 | -122.42180414448299 | (37.7406342583881, -122.421804144483) | |||
| 86129 | 86129 | 4819 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 398X Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 4X4 | 6006006.1956778 | 2097849.2293648 | 37.7406342583881 | -122.42180414448299 | (37.7406342583881, -122.421804144483) | |||
| 176497 | 176497 | 225861 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 321 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6006214.50743 | 2098136.12844 | 37.741433764066 | -122.42110424736 | (37.741433764066, -122.42110424736) | |||
| 125201 | 125201 | 4506 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1799 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6004678.8435244 | 2098420.1905157 | 37.7421270443151 | -122.42643426555 | (37.7421270443151, -122.42643426555) | |||
| 17700 | 17700 | 4504 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1780 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 26 | 4X4 | 6004619.48057 | 2098494.87239 | 37.7423287477646 | -122.426644841002 | (37.7423287477646, -122.426644841002) | |||
| 21368 | 21368 | 4571 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 229 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 32 | 4x4 | 6006415.89392 | 2098506.82504 | 37.7424629643998 | -122.42043422728399 | (37.7424629643998, -122.420434227284) | |||
| 22065 | 22065 | 4564 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 203 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 4x4 | 6006429.48639 | 2098539.4739099997 | 37.7425533768305 | -122.42038954535101 | (37.7425533768305, -122.420389545351) | |||
| 18383 | 18383 | 4503 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1767 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6004674.71192 | 2098595.28716 | 37.742607586167395 | -122.42646101595601 | (37.7426075861674, -122.426461015956) | |||
| 20771 | 20771 | 4502 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1763 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 4x4 | 6004673.08752 | 2098626.19455 | 37.7426923589722 | -122.426468832889 | (37.7426923589722, -122.426468832889) | |||
| 18104 | 18104 | 23633 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 198X Coleridge St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6006450.06706 | 2098653.35241 | 37.7428672213344 | -122.42032646421801 | (37.7428672213344, -122.420326464218) | |||
| 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) | |||
| 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) | |||
| 47445 | 47445 | 248181 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 218 Esmeralda Ave | 10 | Side Yard : Yard 17 | Tree 1 | Private 1 | 32 | 6007478.19635 | 2098656.7324200002 | 37.7429343836221 | -122.41677171036999 | (37.7429343836221, -122.41677171037) | ||||
| 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) | |||
| 45137 | 45137 | 248182 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 216 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 51 | 6007496.06144 | 2098688.36246 | 37.743022237487004 | -122.41671217793899 | (37.743022237487, -122.416712177939) | ||||
| 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) | |||
| 129233 | 129233 | 225865 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 5ft | 6006497.19455 | 2098745.86937 | 37.7431239076329 | -122.420170074782 | (37.7431239076329, -122.420170074782) | |||
| 185136 | 185136 | 225866 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 31 | Width 5ft | 6006516.03586 | 2098775.00428 | 37.7432049671495 | -122.42010699366199 | (37.7432049671495, -122.420106993662) | |||
| 132320 | 132320 | 225867 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 5ft | 6006525.15417 | 2098793.36254 | 37.7432558885579 | -122.42007676744801 | (37.7432558885579, -122.420076767448) | |||
| 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) | |||
| 155580 | 155580 | 225869 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 190 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 35 | Width 5ft | 6006549.95034 | 2098834.86462 | 37.743371240990896 | -122.419993973142 | (37.7433712409909, -122.419993973142) | |||
| 137895 | 137895 | 225870 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 154 Coleridge St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006559.10741 | 2098855.11424 | 37.74342735780179 | -122.41996374694901 | (37.7434273578018, -122.419963746949) | |||
| 96681 | 96681 | 52015 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 282 29th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2005 12:00:00 AM | Permit Number 48233 | 6004742.33522921 | 2099026.78484359 | 37.7437962026999 | -122.42625790812401 | (37.7437962026999, -122.426257908124) | |||
| 98309 | 98309 | 52013 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 282 29th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2005 12:00:00 AM | Permit Number 48233 | 6004742.33522921 | 2099026.78484359 | 37.7437962026999 | -122.42625790812401 | (37.7437962026999, -122.426257908124) | |||
| 111349 | 111349 | 52016 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 282 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/2005 12:00:00 AM | Permit Number 48233 | 6004742.33522921 | 2099026.78484359 | 37.7437962026999 | -122.42625790812401 | (37.7437962026999, -122.426257908124) | |||
| 166798 | 166798 | 248247 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 296 Esmeralda Ave | 7 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6006821.11352 | 2098989.33644 | 37.743810659629204 | -122.419067312628 | (37.7438106596292, -122.419067312628) | ||||
| 154669 | 154669 | 248242 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 296 Esmeralda Ave | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 27 | 6006789.286590001 | 2099004.18236 | 37.7438496308664 | -122.419178415757 | (37.7438496308664, -122.419178415757) | ||||
| 176872 | 176872 | 248241 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 296 Esmeralda Ave | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 63 | 6006778.03314 | 2099006.59157 | 37.743855612256 | -122.419217498503 | (37.743855612256, -122.419217498503) | ||||
| 28136 | 28136 | 247011 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Valley St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6002619.5945 | 2099198.996 | 37.7441488398068 | -122.433610141488 | (37.7441488398068, -122.433610141488) | ||||
| 73871 | 73871 | 247012 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Valley St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | 6002599.35575 | 2099199.8727700002 | 37.744150098849204 | -122.43368018521299 | (37.7441500988492, -122.433680185213) | ||||
| 28691 | 28691 | 247010 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 500 Valley St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6002631.32186 | 2099201.86815 | 37.74415739146121 | -122.433569796116 | (37.7441573914612, -122.433569796116) | ||||
| 27230 | 27230 | 218984 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 145 Vasquez Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 3ft | 5994984.805980001 | 2099511.62786 | 37.744571095774 | -122.46003202358101 | (37.744571095774, -122.460032023581) | |||
| 150110 | 150110 | 218983 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 145 Vasquez Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5994996.58862 | 2099522.38942 | 37.7446013220014 | -122.459992061292 | (37.7446013220014, -122.459992061292) | |||
| 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) | |||
| 9109 | 9109 | 23140 | Permitted Site 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1621X Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 40 | 3x3 | 6004632.02812 | 2099337.8259 | 37.744644014501205 | -122.42666146912599 | (37.7446440145012, -122.426661469126) | |||
| 18178 | 18178 | 4495 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1618 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11/02/1990 12:00:00 AM | 18 | 3x3 | 6004570.56721 | 2099356.4076799997 | 37.744691560861895 | -122.426875312064 | (37.7446915608619, -122.426875312064) | ||
| 27154 | 27154 | 192389 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 450 Amador St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | Width 5ft | 6018217.012999999 | 2099612.2395900004 | 37.746156176965606 | -122.37970582128901 | (37.7461561769656, -122.379705821289) | |||
| 146890 | 146890 | 192388 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 50 Quint St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 5 | Width 6ft | 6015744.90256 | 2099774.65774 | 37.7464654763079 | -122.388265475891 | (37.7464654763079, -122.388265475891) | |||
| 73452 | 73452 | 192387 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 50 Quint St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 4 | Width 6ft | 6015746.952330001 | 2099779.40581 | 37.7464786270998 | -122.388258719272 | (37.7464786270998, -122.388258719272) | |||
| 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) | |||
| 186131 | 186131 | 225883 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1170 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6003173.01454 | 2101419.50409 | 37.7502772213358 | -122.43185505607401 | (37.7502772213358, -122.431855056074) | |||
| 4608 | 4608 | 4436 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1292 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 09/29/2017 12:00:00 AM | 3 | 3X3 | 6004456.3598 | 2101397.3807200002 | 37.75028914274171 | -122.42741558697901 | (37.7502891427417, -122.427415586979) | ||
| 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) | |||
| 98046 | 98046 | 4434 | DPW Maintained 3 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1246 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6004452.33203 | 2101636.8791292 | 37.7509465218336 | -122.427446575049 | (37.7509465218336, -122.427446575049) | |||
| 152294 | 152294 | 225856 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1242 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 5ft | 6004441.23544 | 2101663.28988 | 37.75101841198661 | -122.42748682946699 | (37.7510184119866, -122.427486829467) | |||
| 35549 | 35549 | 192359 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 3 | : Yard 23 | Tree 1 | Private 1 | 11 | 6015007.494080001 | 2102120.97523 | 37.7528670835631 | -122.390979333923 | (37.7528670835631, -122.390979333923) | ||||
| 173611 | 173611 | 192357 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 1 | : Yard 23 | Tree 1 | Private 1 | 16 | 6015039.28391 | 2102127.23317 | 37.7528860304727 | -122.39086983518801 | (37.7528860304727, -122.390869835188) | ||||
| 54292 | 54292 | 192358 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 2 | : Yard 23 | Tree 1 | Private 1 | 12 | 6015008.12096 | 2102140.25985 | 37.752920069827 | -122.39097851376499 | (37.752920069827, -122.390978513765) | ||||
| 60677 | 60677 | 192360 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 8 | : Yard 23 | Tree 1 | Private 1 | 5 | 6015020.29565 | 2102164.4791599996 | 37.75298724647129 | -122.39093810360399 | (37.7529872464713, -122.390938103604) | ||||
| 28971 | 28971 | 192361 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 10 | : Yard 23 | Tree 1 | Private 1 | 10 | 6015010.08641 | 2102185.10422 | 37.7530433120206 | -122.390974850809 | (37.7530433120206, -122.390974850809) | ||||
| 60000 | 60000 | 192362 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1 25th St | 20 | : Yard 23 | Tree 1 | Private 1 | 9 | 6014965.98324 | 2102248.74822 | 37.7532156176115 | -122.391131817592 | (37.7532156176115, -122.391131817592) | ||||
| 109836 | 109836 | 225831 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6010886.07537 | 2102341.86633 | 37.753244046982395 | -122.405247593515 | (37.7532440469824, -122.405247593515) | |||
| 152837 | 152837 | 225830 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6011105.21745 | 2102361.77794 | 37.7533109691405 | -122.404491153067 | (37.7533109691405, -122.404491153067) | |||
| 155581 | 155581 | 225832 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6010884.0917 | 2102372.03414 | 37.7533267702301 | -122.405256577724 | (37.7533267702301, -122.405256577724) | |||
| 185139 | 185139 | 225829 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6011100.71134 | 2102387.9622400003 | 37.753382613635296 | -122.40450857923099 | (37.7533826136353, -122.404508579231) | |||
| 187330 | 187330 | 225833 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6010883.2575 | 2102402.44646 | 37.753410229111 | -122.40526160403999 | (37.753410229111, -122.40526160404) | |||
| 187507 | 187507 | 225828 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6011100.1328300005 | 2102409.04918 | 37.7534404813975 | -122.404512064091 | (37.7534404813975, -122.404512064091) | |||
| 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) | |||
| 51964 | 51964 | 192363 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 26 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014946.149019999 | 2102349.52066 | 37.753491216648705 | -122.39120745237899 | (37.7534912166487, -122.391207452379) | ||||
| 152103 | 152103 | 225827 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1200 San Bruno Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6011098.29939 | 2102434.5099400003 | 37.753510288572 | -122.40452019665899 | (37.753510288572, -122.404520196659) | |||
| 184577 | 184577 | 192373 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 18 | : Yard 23 | Tree 1 | Private 1 | 17 | 6015020.94183 | 2102357.50513 | 37.7535172906979 | -122.390949358625 | (37.7535172906979, -122.390949358625) | ||||
| 180843 | 180843 | 225819 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1266 Vermont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 5ft | 6011382.17033 | 2102444.14422 | 37.7535526025704 | -122.403539182014 | (37.7535526025704, -122.403539182014) | |||
| 31965 | 31965 | 192372 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 11 | : Yard 23 | Tree 1 | Private 1 | 18 | 6015021.64054 | 2102392.08058 | 37.753612266314796 | -122.39094935864401 | (37.7536122663148, -122.390949358644) | ||||
| 74435 | 74435 | 192364 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 23 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014928.1243 | 2102399.042 | 37.7536261914184 | -122.391273247671 | (37.7536261914184, -122.391273247671) | ||||
| 27348 | 27348 | 225835 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1201 Utah St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6010878.34698 | 2102482.51525 | 37.7536298057935 | -122.40528422380899 | (37.7536298057935, -122.405284223809) | |||
| 36486 | 36486 | 192371 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 10 | : Yard 23 | Tree 1 | Private 1 | 11 | 6015009.21329 | 2102415.55606 | 37.7536760354269 | -122.390993975811 | (37.7536760354269, -122.390993975811) | ||||
| 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) | |||
| 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) | |||
| 70325 | 70325 | 192365 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 21 | : Yard 23 | Tree 1 | Private 1 | 8 | 6014917.078430001 | 2102437.6688900003 | 37.7537316396243 | -122.391314147037 | (37.7537316396243, -122.391314147037) | ||||
| 148293 | 148293 | 192370 | Undocumented 2 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 10 | 1310 Indiana St | 9 | : Yard 23 | Tree 1 | Private 1 | 8 | 6015014.73228 | 2102443.11605 | 37.7537520155509 | -122.390976815833 | (37.7537520155509, -122.390976815833) |
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");