trees
556 rows where qSpecies_id = 71 sorted by SiteOrder
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||
3580 | 56277 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 70 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/03/2016 12:00:00 AM | 3 | Permit Number 778721 | 6005870.9645754 | 2104060.4446756 | 37.7576812057902 | -122.422713011346 | (37.7576812057902, -122.422713011346) | 2 | 4 | 5 | 28859 | 19 | ||
6463 | 40381 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 336 Jersey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/02/1999 12:00:00 AM | Permit Number 41493 | 6002951.47000009 | 2101559.64792523 | 37.7506494618032 | -122.432631180412 | (37.7506494618032, -122.432631180412) | 2 | 4 | 5 | 28862 | 22 | |||
9711 | 128841 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6011188.37532 | 2121452.80256 | 37.8057351195451 | -122.405548058817 | (37.8057351195451, -122.405548058817) | 3 | 1 | 10 | 308 | 23 | |||
14510 | 225860 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1400 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/09/1979 12:00:00 AM | 32 | Width 4ft | Permit Number 17861 | 5997829.91039 | 2105879.41446 | 37.7622186838636 | -122.450653279939 | (37.7622186838636, -122.450653279939) | 15 | 5 | 11 | 29492 | 9 | |
14955 | 139262 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 740 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6004035.029 | 2111258.7004 | 37.7773421207118 | -122.429575786462 | (37.7773421207118, -122.429575786462) | 7 | 9 | 11 | 28852 | 10 | |||
16143 | 225872 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 918 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/31/1983 12:00:00 AM | 17 | Width 3ft | Permit Number 20345 | 6009124.648 | 2103673.1383 | 37.7568007856426 | -122.411433035206 | (37.7568007856426, -122.411433035206) | 2 | 4 | 7 | 28859 | 19 | |
16382 | 2685 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1785 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 35 | 4x4 | 6003437.92088 | 2114825.67122 | 37.7871023020297 | -122.431896135366 | (37.7871023020297, -122.431896135366) | 13 | 9 | 11 | 29490 | 27 | |||
16419 | 260956 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 53 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9x9 | 6005953 | 2103995 | 37.7575061380505 | -122.422424648788 | (37.7575061380505, -122.422424648788) | 2 | 4 | 5 | 28859 | 19 | ||||
17334 | 248431 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 721 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 0ft | 5997917.0355 | 2108037.1532 | 37.7681482738929 | -122.450507510702 | (37.7681482738929, -122.450507510702) | 15 | 5 | 11 | 29492 | 9 | |||
20329 | 225847 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 7ft | 6006004.32173 | 2104059.75576 | 37.7576868372893 | -122.422251758015 | (37.7576868372893, -122.422251758015) | 2 | 4 | 5 | 28859 | 19 | |||
20644 | 14589 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1221 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 3X3 | 5999408.7715 | 2108648.7165 | 37.7699127394546 | -122.445391746523 | (37.7699127394546, -122.445391746523) | 15 | 5 | 11 | 29492 | 9 | |||
21645 | 192374 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 9ft | 6015916.946 | 2106720.28142 | 37.7655462204113 | -122.388155200109 | (37.7655462204113, -122.388155200109) | 14 | 3 | 9 | 310 | 29 | |||
21857 | 225878 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 3336 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006137.18827 | 2103195.79991 | 37.7553221086433 | -122.421730885992 | (37.7553221086433, -122.421730885992) | 2 | 4 | 5 | 28859 | 19 | |||
22214 | 23712 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 703 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X4 | 6003969.6344427 | 2111125.822349 | 37.7769735674529 | -122.429792527426 | (37.7769735674529, -122.429792527426) | 7 | 9 | 11 | 29492 | 10 | |||
23080 | 248433 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 718 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 5997964.5796 | 2108003.6906 | 37.7680591152112 | -122.450340648856 | (37.7680591152112, -122.450340648856) | 15 | 5 | 11 | 29492 | 9 | |||
23680 | 10997 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 3X Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6018318.9881754 | 2094475.1533635 | 37.732056382705 | -122.378996495822 | (37.732056382705, -122.378996495822) | 10 | 3 | 8 | 58 | 1 | |||
24503 | 247010 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Valley St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6002631.32186 | 2099201.86815 | 37.7441573914612 | -122.433569796116 | (37.7441573914612, -122.433569796116) | 2 | 7 | 5 | 63 | 22 | ||||
24512 | 225862 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 198 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 5ft | 6006460.77519 | 2098675.08466 | 37.7429274966048 | -122.420290980542 | (37.7429274966048, -122.420290980542) | 2 | 7 | 7 | 28859 | 2 | |||
24969 | 258214 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 20 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 4x4 | 6018341.5004 | 2094530.72341 | 37.7322102084437 | -122.378922523056 | (37.7322102084437, -122.378922523056) | 10 | 3 | 8 | 58 | 1 | ||||
25569 | 253379 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 899 Waller St | 1 | Side Yard : Yard | Tree | Private 2 | 6001282 | 2108613 | 37.7699214264211 | -122.438909742148 | (37.7699214264211, -122.438909742148) | 15 | 5 | 5 | 29492 | 9 | |||||
25654 | 16632 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 150 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6002845.7066 | 2107359.01628 | 37.7665671370879 | -122.433411295115 | (37.7665671370879, -122.433411295115) | 15 | 5 | 5 | 28862 | 3 | |||
26497 | 141790 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1280 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 26 | Width 0ft | 6003808.9126 | 2112898.5974 | 37.7818320649833 | -122.430475034423 | (37.7818320649833, -122.430475034423) | 7 | 9 | 11 | 29490 | 41 | |||
26535 | 5944 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1415 Eddy St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6003654.4203 | 2112794.2785 | 37.7815368785362 | -122.431002057977 | (37.7815368785362, -122.431002057977) | 15 | 9 | 11 | 29490 | 41 | |||
28014 | 5941 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1155X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 15 | 3X3 | 6003735.29014 | 2112772.66113 | 37.7814821046204 | -122.430720744107 | (37.7814821046204, -122.430720744107) | 15 | 9 | 11 | 29490 | 41 | |||
29375 | 23140 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1621X Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 3x3 | 6004632.02812 | 2099337.8259 | 37.7446440145012 | -122.426661469126 | (37.7446440145012, -122.426661469126) | 2 | 7 | 5 | 63 | 22 | |||
29813 | 141878 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1130 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 6003852.9179 | 2112548.3998 | 37.7808730023316 | -122.4302978041 | (37.7808730023316, -122.4302978041) | 7 | 9 | 11 | 29490 | 41 | |||
30057 | 142002 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 681 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6004463.7555 | 2111518.3082 | 37.778079205485 | -122.428111187061 | (37.778079205485, -122.428111187061) | 7 | 9 | 11 | 28852 | 10 | |||
30151 | 1324 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 4051X Alemany Blvd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3x3 | 5991764.76245 | 2086963.37686 | 37.7099309898835 | -122.470252581934 | (37.7099309898835, -122.470252581934) | 9 | 8 | 4 | 64 | 24 | |||
30390 | 23721 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 802X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 4X4 | 6003990.0153246 | 2111477.493419 | 37.7779403234669 | -122.429747112563 | (37.7779403234669, -122.429747112563) | 7 | 9 | 11 | 28852 | 41 | |||
31663 | 165 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 185X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6002905.5013881 | 2107191.4781257 | 37.7661105103373 | -122.433192503539 | (37.7661105103373, -122.433192503539) | 15 | 5 | 5 | 28862 | 3 | |||
32190 | 56267 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 20 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | 20 | 6x6 | Permit Number 12393 | 6006178.98761338 | 2104077.53782444 | 37.7577455134305 | -122.421648953731 | (37.7577455134305, -122.421648953731) | 2 | 4 | 5 | 28859 | 19 | |
32987 | 16652 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 198 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X5 | 6002855.56746 | 2107156.83131 | 37.7660125458771 | -122.43336273892 | (37.7660125458771, -122.43336273892) | 15 | 5 | 5 | 28862 | 3 | |||
33740 | 128831 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 2610 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6002271.43104 | 2116104.60084 | 37.7905477186542 | -122.436023477612 | (37.7905477186542, -122.436023477612) | 13 | 6 | 1 | 29490 | 27 | |||
33907 | 112518 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1849 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 5999474.66705 | 2115314.93957 | 37.7882202345095 | -122.445643268334 | (37.7882202345095, -122.445643268334) | 13 | 6 | 1 | 29490 | 31 | |||
37468 | 10559 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 266 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1992 12:00:00 AM | 18 | 3X4 | 6018220.577079 | 2094928.7869738 | 37.7332965451478 | -122.379368227321 | (37.7332965451478, -122.379368227321) | 10 | 3 | 8 | 58 | 1 | ||
37549 | 4506 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1799 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6004678.8435244 | 2098420.1905157 | 37.7421270443151 | -122.42643426555 | (37.7421270443151, -122.42643426555) | 2 | 7 | 5 | 63 | 22 | |||
37708 | 68776 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 499 41st Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/16/1993 12:00:00 AM | 16 | Permit Number 32706 | 5983126.84332 | 2112651.33679 | 37.7799598652159 | -122.502005896932 | (37.7799598652159, -122.502005896932) | 11 | 6 | 2 | 55 | 26 | |
40907 | 16681 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 251 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 10X9 | 6002922.02909 | 2106861.12006 | 37.7652043650157 | -122.433111731538 | (37.7652043650157, -122.433111731538) | 15 | 5 | 5 | 28862 | 3 | |||
43188 | 21692 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1630X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 4X4 | 6003612.6236388 | 2114305.6361391 | 37.7856843190794 | -122.431254568258 | (37.7856843190794, -122.431254568258) | 13 | 9 | 11 | 29490 | 13 | |||
43455 | 225857 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 3561 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6004603.67421 | 2103652.16834 | 37.7564885931993 | -122.427066743535 | (37.7564885931993, -122.427066743535) | 2 | 4 | 5 | 28862 | 22 | |||
44813 | 225871 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 187 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 3ft | 6006494.40119 | 2098665.31091 | 37.742902554819 | -122.420174017412 | (37.742902554819, -122.420174017412) | 2 | 7 | 7 | 28859 | 2 | |||
45124 | 248461 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 737 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 5997928.543 | 2107954.7837 | 37.7679227668769 | -122.450461768872 | (37.7679227668769, -122.450461768872) | 15 | 5 | 11 | 29492 | 9 | |||
45567 | 14354 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 299X Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/06/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778955 | 6002931.2163471 | 2106726.8081779 | 37.7648360983599 | -122.433070358007 | (37.7648360983599, -122.433070358007) | 15 | 5 | 5 | 28862 | 3 | |
46194 | 23768 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1001 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 3X3 | 6003798.77229 | 2112300.9395 | 37.7801904708611 | -122.430467458421 | (37.7801904708611, -122.430467458421) | 15 | 9 | 11 | 29490 | 41 | |||
47792 | 141636 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 701 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 0ft | 5999161.9551 | 2110417.0445 | 37.7747540254261 | -122.446372706542 | (37.7747540254261, -122.446372706542) | 15 | 5 | 11 | 29492 | 16 | |||
48455 | 225820 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1200 San Bruno Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 4ft | 6011084.05744 | 2102692.04656 | 37.754216631403 | -122.404587576568 | (37.754216631403, -122.404587576568) | 10 | 4 | 8 | 28859 | 19 | |||
48915 | 9961 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 700X Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4X4 | 6004044.3152 | 2111193.6969 | 37.777164162929 | -122.429539025484 | (37.777164162929, -122.429539025484) | 7 | 9 | 11 | 28852 | 10 | |||
50087 | 54991 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 646 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 13 | 3x3 | Permit Number 10869 | 5990991.81393 | 2111001.00614 | 37.7758874082105 | -122.474677239765 | (37.7758874082105, -122.474677239765) | 11 | 6 | 2 | 54 | 26 | |
50629 | 225859 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 784 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 5998015.01543 | 2107655.1459 | 37.7671049865286 | -122.450141071966 | (37.7671049865286, -122.450141071966) | 15 | 5 | 11 | 29492 | 9 | |||
51273 | 140606 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 753 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6003916.6549 | 2111410.853 | 37.7777531909662 | -122.429996137193 | (37.7777531909662, -122.429996137193) | 7 | 9 | 11 | 29492 | 10 | |||
52591 | 4495 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1618 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11/02/1990 12:00:00 AM | 18 | 3x3 | 6004570.56721 | 2099356.40768 | 37.7446915608619 | -122.426875312064 | (37.7446915608619, -122.426875312064) | 2 | 7 | 5 | 63 | 22 | ||
53560 | 142035 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 631 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 6004734.9181 | 2111554.9581 | 37.7781951752439 | -122.427175748971 | (37.7781951752439, -122.427175748971) | 7 | 9 | 11 | 28852 | 10 | |||
54077 | 57851 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1001 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/14/1977 12:00:00 AM | 20 | Permit Number 16792 | 6003796.0811 | 2112295.2301 | 37.78017464182 | -122.430476360985 | (37.78017464182, -122.430476360985) | 15 | 9 | 11 | 29490 | 41 | ||
54903 | 225819 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1266 Vermont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 5ft | 6011382.17033 | 2102444.14422 | 37.7535526025704 | -122.403539182014 | (37.7535526025704, -122.403539182014) | 10 | 4 | 8 | 28859 | 19 | |||
56277 | 4504 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1780 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 4X4 | 6004619.48057 | 2098494.87239 | 37.7423287477646 | -122.426644841002 | (37.7423287477646, -122.426644841002) | 2 | 7 | 5 | 63 | 22 | |||
56398 | 58361 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 435 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1978 12:00:00 AM | 13 | Permit Number 17389 | 5997651.60838 | 2114939.03748 | 37.7870838556688 | -122.451923583106 | (37.7870838556688, -122.451923583106) | 11 | 6 | 1 | 54 | 31 | ||
56764 | 16659 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 201 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3X4 | 6002918.29496 | 2107052.83778 | 37.7657305634319 | -122.43313834635 | (37.7657305634319, -122.43313834635) | 15 | 5 | 5 | 28862 | 3 | |||
57308 | 245118 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1154 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6001064.1842 | 2109354.1931 | 37.7719441624797 | -122.439716306994 | (37.7719441624797, -122.439716306994) | 15 | 5 | 11 | 29492 | 9 | |||
57328 | 192387 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Quint St | 1 | Front Yard : Yard | Tree | Private 2 | 4 | Width 6ft | 6015746.95233 | 2099779.40581 | 37.7464786270998 | -122.388258719272 | (37.7464786270998, -122.388258719272) | 10 | 3 | 8 | 58 | 1 | |||
58993 | 56273 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 44 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | 28 | Permit Number 12399 | 6006031.13656237 | 2104069.3331134 | 37.7577146469635 | -122.422159701591 | (37.7577146469635, -122.422159701591) | 2 | 4 | 5 | 28859 | 19 | ||
60449 | 141772 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1300 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 6003762.9168 | 2113237.1517 | 37.7827590448466 | -122.430658324501 | (37.7827590448466, -122.430658324501) | 7 | 9 | 11 | 29490 | 41 | |||
61907 | 248382 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 708 Cole St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 5997947.924 | 2108128.759 | 37.76840156792 | -122.450407275567 | (37.76840156792, -122.450407275567) | 15 | 5 | 11 | 29492 | 9 | |||
62034 | 218978 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 635 Joost Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 5997875.75574 | 2094965.1361 | 37.7322533730829 | -122.449708177017 | (37.7322533730829, -122.449708177017) | 9 | 7 | 4 | 59 | 40 | ||||
63458 | 56276 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 58 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | 24 | Permit Number 12402 | 6005944.89012346 | 2104064.54703238 | 37.7576966405039 | -122.422457637621 | (37.7576966405039, -122.422457637621) | 2 | 4 | 5 | 28859 | 19 | ||
63922 | 225855 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1619 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 4ft | 6004635.97757 | 2099333.51392 | 37.7446323980786 | -122.426647505701 | (37.7446323980786, -122.426647505701) | 2 | 7 | 5 | 63 | 22 | |||
64886 | 244222 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 403 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5998378.2216 | 2109230.1948 | 37.7714504473502 | -122.448998275071 | (37.7714504473502, -122.448998275071) | 15 | 5 | 11 | 29492 | 9 | |||
65689 | 247291 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1167 Masonic Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 0ft | 5999365.8341 | 2108846.2504 | 37.7704526663824 | -122.445554472067 | (37.7704526663824, -122.445554472067) | 15 | 5 | 11 | 29492 | 9 | |||
65796 | 138722 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1653 BAKER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 6000049.7804 | 2114670.149 | 37.786482625236 | -122.443607141292 | (37.786482625236, -122.443607141292) | 15 | 6 | 1 | 29490 | 31 | |||
65929 | 16655 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 200 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 5X4 | 6002860.3108 | 2107045.92477 | 37.7657082926243 | -122.433338406847 | (37.7657082926243, -122.433338406847) | 15 | 5 | 5 | 28862 | 3 | |||
66505 | 244875 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1325 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6000196.2123 | 2109189.1083 | 37.7714414391807 | -122.442706821096 | (37.7714414391807, -122.442706821096) | 15 | 5 | 11 | 29492 | 9 | |||
67267 | 141770 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1370 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003739.4888 | 2113387.6587 | 37.7831709721136 | -122.430750119322 | (37.7831709721136, -122.430750119322) | 7 | 9 | 11 | 29490 | 41 | |||
67996 | 225849 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 58 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 9ft | 6005973.95639 | 2104058.73898 | 37.7576823326016 | -122.422356701726 | (37.7576823326016, -122.422356701726) | 2 | 4 | 5 | 28859 | 19 | |||
70188 | 139226 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1401 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003606.1847 | 2113661.4339 | 37.7839151368306 | -122.431230845808 | (37.7839151368306, -122.431230845808) | 13 | 9 | 11 | 29490 | 41 | |||
70321 | 23907 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1615 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 4X4 | 6003522.4282637 | 2114237.5945626 | 37.7854923822508 | -122.431561758919 | (37.7854923822508, -122.431561758919) | 13 | 9 | 11 | 29490 | 13 | |||
70948 | 245131 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1264 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6000494.8167 | 2109275.2528 | 37.7716949881709 | -122.441680119544 | (37.7716949881709, -122.441680119544) | 15 | 5 | 11 | 29492 | 9 | |||
71066 | 120870 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 815 Duboce Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 36 | 3x3 | 6001854 | 2108207 | 37.7688391782107 | -122.436902139783 | (37.7688391782107, -122.436902139783) | 15 | 5 | 5 | 29492 | 3 | |||
71076 | 225879 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 3332 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6006112.65396 | 2103193.20831 | 37.7553136091612 | -122.421815549056 | (37.7553136091612, -122.421815549056) | 2 | 4 | 5 | 28859 | 19 | |||
71658 | 17333 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 170 Otis St | 1 | 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 | |||
72740 | 225885 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 144 Henry St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | Width 3ft | 6002594.52334 | 2107398.5197 | 37.7666613500558 | -122.43428291715 | (37.7666613500558, -122.43428291715) | 15 | 5 | 5 | 28862 | 3 | |||
73644 | 225842 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 20 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 6ft | 6006154.9324 | 2104068.30883 | 37.7577188162864 | -122.421731491214 | (37.7577188162864, -122.421731491214) | 2 | 4 | 5 | 28859 | 19 | |||
75347 | 192357 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1 25th St | 1 | : Yard | Tree | Private 2 | 16 | 6015039.28391 | 2102127.23317 | 37.7528860304727 | -122.390869835188 | (37.7528860304727, -122.390869835188) | 10 | 3 | 8 | 28856 | 29 | ||||
75414 | 4503 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1767 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004674.71192 | 2098595.28716 | 37.7426075861674 | -122.426461015956 | (37.7426075861674, -122.426461015956) | 2 | 7 | 5 | 63 | 22 | |||
75833 | 245084 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 122 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 0ft | 6000331.4821 | 2109497.9077 | 37.772297034891 | -122.44226108892 | (37.772297034891, -122.44226108892) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
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 | ||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );