trees
556 rows where qSpecies_id = 71 sorted by Zip Codes descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||
104041 | 254801 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 700 Brotherhood Way | 24 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x9 | 5991178 | 2088065 | 37.7129218386335 | -122.472360778797 | (37.7129218386335, -122.472360778797) | 1 | 8 | 4 | 64 | 14 | ||||
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 | ||||
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 | |||
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 | |||
46459 | 225887 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 117 Conrad St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/27/2017 12:00:00 AM | 3 | Width 2ft | Permit Number 42143 | 6001804.96273 | 2096660.33983 | 37.7371320270083 | -122.436245312495 | (37.7371320270083, -122.436245312495) | 2 | 7 | 5 | 63 | 7 | |
48987 | 247012 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Valley St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | 6002599.35575 | 2099199.87277 | 37.7441500988492 | -122.433680185213 | (37.7441500988492, -122.433680185213) | 2 | 7 | 5 | 63 | 22 | ||||
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 | ||
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 | |||
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 | |||
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 | |||
89678 | 52015 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 282 29th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2005 12:00:00 AM | Permit Number 48233 | 6004742.33522921 | 2099026.78484359 | 37.7437962026999 | -122.426257908124 | (37.7437962026999, -122.426257908124) | 2 | 7 | 5 | 63 | 22 | |||
104067 | 255325 | Significant Tree 6 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 42 Lippard Ave | 1 | Front Yard : Yard | Tree | Private 2 | Width 0ft | Permit Number 781812 | 6002006.02273 | 2095939.48888 | 37.7351641583954 | -122.435498605394 | (37.7351641583954, -122.435498605394) | 2 | 7 | 5 | 63 | 7 | |||
112905 | 52013 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 282 29th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2005 12:00:00 AM | Permit Number 48233 | 6004742.33522921 | 2099026.78484359 | 37.7437962026999 | -122.426257908124 | (37.7437962026999, -122.426257908124) | 2 | 7 | 5 | 63 | 22 | |||
137075 | 247011 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Valley St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | 6002619.5945 | 2099198.996 | 37.7441488398068 | -122.433610141488 | (37.7441488398068, -122.433610141488) | 2 | 7 | 5 | 63 | 22 | ||||
142263 | 52016 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 282 29th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/2005 12:00:00 AM | Permit Number 48233 | 6004742.33522921 | 2099026.78484359 | 37.7437962026999 | -122.426257908124 | (37.7437962026999, -122.426257908124) | 2 | 7 | 5 | 63 | 22 | |||
148254 | 4502 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1763 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6004673.08752 | 2098626.19455 | 37.7426923589722 | -122.426468832889 | (37.7426923589722, -122.426468832889) | 2 | 7 | 5 | 63 | 22 | |||
37303 | 218980 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 501 Junipero Serra Blvd | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5991479.42203 | 2093975.5381 | 37.7291681615656 | -122.47174944968 | (37.7291681615656, -122.47174944968) | 9 | 8 | 4 | 59 | 40 | |||
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 | ||||
74884 | 218981 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 501 Junipero Serra Blvd | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991484.23887 | 2094055.35352 | 37.7293875934485 | -122.47173861195 | (37.7293875934485, -122.47173861195) | 9 | 8 | 4 | 59 | 40 | |||
139162 | 218983 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 145 Vasquez Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 14 | Width 3ft | 5994996.58862 | 2099522.38942 | 37.7446013220014 | -122.459992061292 | (37.7446013220014, -122.459992061292) | 1 | 8 | 4 | 59 | 40 | |||
142148 | 218985 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 735 Foerster St | 1 | Back Yard : Yard | Tree | Private 2 | 15 | Width 3ft | 5998106.15759 | 2095768.84675 | 37.7344733504624 | -122.448969503563 | (37.7344733504624, -122.448969503563) | 9 | 7 | 4 | 59 | 40 | |||
154270 | 218979 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 551 Junipero Serra Blvd | 18 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5991462.95986 | 2093729.88952 | 37.7284927194476 | -122.471788464971 | (37.7284927194476, -122.471788464971) | 9 | 8 | 4 | 59 | 40 | |||
172913 | 218984 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 145 Vasquez Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 15 | Width 3ft | 5994984.80598 | 2099511.62786 | 37.744571095774 | -122.460032023581 | (37.744571095774, -122.460032023581) | 1 | 8 | 4 | 59 | 40 | |||
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 | |||
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 | ||||
33922 | 192388 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Quint St | 2 | Front Yard : Yard | Tree | Private 2 | 5 | Width 6ft | 6015744.90256 | 2099774.65774 | 37.7464654763079 | -122.388265475891 | (37.7464654763079, -122.388265475891) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
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 | |||
57992 | 11012 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 95 Hudson Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018177.8841382 | 2094612.4287261 | 37.7324255328509 | -122.379493861146 | (37.7324255328509, -122.379493861146) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
83991 | 11013 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 95 Hudson Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6018177.8841382 | 2094612.4287261 | 37.7324255328509 | -122.379493861146 | (37.7324255328509, -122.379493861146) | 10 | 3 | 8 | 58 | 1 | |||
94950 | 11004 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 40 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018314.1623349 | 2094585.1363671 | 37.7323581084588 | -122.379020815535 | (37.7323581084588, -122.379020815535) | 10 | 3 | 8 | 58 | 1 | |||
104724 | 11007 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 60 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018282.6314 | 2094636.8214067 | 37.7324982868599 | -122.379133414916 | (37.7324982868599, -122.379133414916) | 10 | 3 | 8 | 58 | 1 | |||
117907 | 201408 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 201 Harbor Rd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6018149.85399 | 2094926.30804 | 37.7332858379605 | -122.379612566976 | (37.7332858379605, -122.379612566976) | 10 | 3 | 8 | 58 | 1 | |||
120606 | 11009 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 80 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018206.0401963 | 2094670.6666495 | 37.7325869956158 | -122.379400561989 | (37.7325869956158, -122.379400561989) | 10 | 3 | 8 | 58 | 1 | |||
135727 | 11005 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6018298.3968675 | 2094610.9788869 | 37.7324281976732 | -122.379077115172 | (37.7324281976732, -122.379077115172) | 10 | 3 | 8 | 58 | 1 | |||
142273 | 201434 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 200 Harbor Rd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 4ft | 6018235.12943 | 2094913.6539 | 37.7332557952224 | -122.379316864501 | (37.7332557952224, -122.379316864501) | 10 | 3 | 8 | 58 | 1 | |||
159802 | 10550 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 217 Harbor Rd | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/12/1992 12:00:00 AM | 12 | 3X4 | 6018348.7736836 | 2094772.4250311 | 37.7328742748645 | -122.378914156582 | (37.7328742748645, -122.378914156582) | 10 | 3 | 8 | 58 | 1 | ||
164408 | 201411 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 201 Harbor Rd | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6018303.48681 | 2094820.24532 | 37.7330030830165 | -122.379074046625 | (37.7330030830165, -122.379074046625) | 10 | 3 | 8 | 58 | 1 | |||
167732 | 192389 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 450 Amador St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 5ft | 6018217.013 | 2099612.23959 | 37.7461561769656 | -122.379705821289 | (37.7461561769656, -122.379705821289) | 10 | 3 | 8 | 58 | 1 | |||
168104 | 11001 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 20 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6018345.6932697 | 2094533.4513275 | 37.7322179299469 | -122.378908216579 | (37.7322179299469, -122.378908216579) | 10 | 3 | 8 | 58 | 1 | |||
170602 | 11002 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 25 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X4 | 6018294.3685242 | 2094521.575214 | 37.7321824905391 | -122.379084835175 | (37.7321824905391, -122.379084835175) | 10 | 3 | 8 | 58 | 1 | |||
175772 | 11006 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 55 Hudson Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X4 | 6018247.9816681 | 2094597.6118588 | 37.7323887144105 | -122.37925048612 | (37.7323887144105, -122.37925048612) | 10 | 3 | 8 | 58 | 1 | |||
174084 | 128839 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1661 Green St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6005108.54777 | 2118478.70027 | 37.7972271633692 | -122.426376325029 | (37.7972271633692, -122.426376325029) | 13 | 9 | 1 | 57 | 17 | |||
83455 | 109833 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 2525 Judah St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 5986661.7219 | 2105698.5773 | 37.761076563265 | -122.489265996065 | (37.761076563265, -122.489265996065) | 1 | 8 | 3 | 56 | 35 | ||||
120491 | 182547 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 2521 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 0ft | 5986679.7301 | 2105699.3123 | 37.7610796325405 | -122.489203768361 | (37.7610796325405, -122.489203768361) | 1 | 8 | 3 | 56 | 35 | |||
141176 | 109834 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 2521 JUDAH ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 2x2 | 5986663 | 2105677 | 37.7610173925517 | -122.489259989237 | (37.7610173925517, -122.489259989237) | 1 | 8 | 3 | 56 | 35 | |||
150620 | 57220 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 2525 Judah St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 01/09/1975 12:00:00 AM | 8 | Permit Number 14507 | 5986650.329 | 2105697.8423 | 37.7610738801184 | -122.489305344609 | (37.7610738801184, -122.489305344609) | 1 | 8 | 3 | 56 | 35 | ||
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 | |
58967 | 95156 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 250 23rd Ave | 12 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 21 | 5988717.78601 | 2113765.0163 | 37.7833445754979 | -122.482746195108 | (37.7833445754979, -122.482746195108) | 11 | 6 | 2 | 55 | 26 | |||
71559 | 117711 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 499 41st Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 1ft | 5983128.07701 | 2112627.91147 | 37.779895618618 | -122.501999895277 | (37.779895618618, -122.501999895277) | 11 | 6 | 2 | 55 | 26 | |||
72163 | 95154 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 250 23rd Ave | 10 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 20 | 5988718.8555 | 2113711.85504 | 37.7831986719098 | -122.48273859805 | (37.7831986719098, -122.48273859805) | 11 | 6 | 2 | 55 | 26 | |||
87200 | 117712 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 499 41st Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 5983131.36299 | 2112604.59919 | 37.7798318029571 | -122.501986802339 | (37.7798318029571, -122.501986802339) | 11 | 6 | 2 | 55 | 26 | |||
111890 | 95155 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 250 23rd Ave | 11 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 16 | 5988718.09873 | 2113738.33114 | 37.7832713237769 | -122.482743157022 | (37.7832713237769, -122.482743157022) | 11 | 6 | 2 | 55 | 26 | |||
41615 | 103034 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 646 16th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 5990990.66602 | 2111015.32542 | 37.7759266585193 | -122.474682255974 | (37.7759266585193, -122.474682255974) | 11 | 6 | 2 | 54 | 26 | |||
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 | |
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 | ||
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 | ||
105657 | 59133 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 730 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/23/1980 12:00:00 AM | 24 | Permit Number 18438 | 5992594.65054267 | 2110474.91091897 | 37.7745356377316 | -122.469094367405 | (37.7745356377316, -122.469094367405) | 11 | 6 | 2 | 54 | 11 | ||
108353 | 145278 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 730 11th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/20/2017 12:00:00 AM | 0 | Width 3ft | Permit Number 779614 | 5992589.96157 | 2110455.11477 | 37.7744810119102 | -122.469109146279 | (37.7744810119102, -122.469109146279) | 11 | 6 | 2 | 54 | 11 | |
124599 | 124031 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 101 Funston Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 13 | Width 3ft | 5991786.57969 | 2114495.60147 | 37.7855286280973 | -122.472182755667 | (37.7855286280973, -122.472182755667) | 11 | 6 | 2 | 54 | 11 | |||
136169 | 128830 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 435 Locust St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997658.68844 | 2114896.31526 | 37.7869669572999 | -122.451896004506 | (37.7869669572999, -122.451896004506) | 11 | 6 | 1 | 54 | 31 | |||
138173 | 123091 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 625 11th Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 3ft | 5992511.62982 | 2111163.49628 | 37.7764215097268 | -122.469431683073 | (37.7764215097268, -122.469431683073) | 11 | 6 | 2 | 54 | 11 | |||
140429 | 54987 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 634 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2014 12:00:00 AM | 3 | Permit Number 774084 | 5990988.52251 | 2111051.18052 | 37.7760249826043 | -122.474692288357 | (37.7760249826043, -122.474692288357) | 11 | 6 | 2 | 54 | 26 | ||
159209 | 128828 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 435 Locust St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 5997654.94419 | 2114925.25732 | 37.7870462100671 | -122.451911047471 | (37.7870462100671, -122.451911047471) | 11 | 6 | 1 | 54 | 31 | |||
166986 | 54990 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 643 16th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/12/1972 12:00:00 AM | 11 | Permit Number 10868 | 5990941.26745 | 2111008.08375 | 37.7759039123762 | -122.474852607991 | (37.7759039123762, -122.474852607991) | 11 | 6 | 2 | 54 | 26 | ||
170598 | 58360 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 457 Locust St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/20/1978 12:00:00 AM | 16 | Permit Number 17388 | 5997662.21392 | 2114878.66722 | 37.7869187023848 | -122.45188253355 | (37.7869187023848, -122.45188253355) | 11 | 6 | 1 | 54 | 31 | ||
177463 | 128829 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 435 Locust St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5997655.29995 | 2114907.57058 | 37.7869976673453 | -122.45190854016 | (37.7869976673453, -122.45190854016) | 11 | 6 | 1 | 54 | 31 | |||
18178 | 192378 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 14 | Width 9ft | 6015920.68395 | 2106620.64032 | 37.7652728345979 | -122.388135317012 | (37.7652728345979, -122.388135317012) | 14 | 3 | 9 | 310 | 29 | |||
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 | |||
30836 | 192376 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 9ft | 6015917.31296 | 2106690.54623 | 37.7654645943419 | -122.388151855539 | (37.7654645943419, -122.388151855539) | 14 | 3 | 9 | 310 | 29 | |||
60664 | 192383 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 9ft | 6015928.56627 | 2106487.94693 | 37.7649089239349 | -122.388098792835 | (37.7649089239349, -122.388098792835) | 14 | 3 | 9 | 310 | 29 | |||
77259 | 192382 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 9ft | 6015926.91076 | 2106504.64628 | 37.7649546850211 | -122.388105684345 | (37.7649546850211, -122.388105684345) | 14 | 3 | 9 | 310 | 29 | |||
81746 | 192381 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 9ft | 6015923.36734 | 2106564.05052 | 37.7651175999097 | -122.38812208619 | (37.7651175999097, -122.38812208619) | 14 | 3 | 9 | 310 | 29 | |||
102087 | 192385 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 18 | Sidewalk: Property side : Yard | Tree | Private 2 | 19 | Width 9ft | 6015934.88312 | 2106386.42358 | 37.7646305127095 | -122.388069858948 | (37.7646305127095, -122.388069858948) | 14 | 3 | 9 | 310 | 29 | |||
109157 | 192379 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 8 | Width 9ft | 6015920.8983 | 2106611.50942 | 37.7652477749961 | -122.38813393835 | (37.7652477749961, -122.38813393835) | 14 | 3 | 9 | 310 | 29 | |||
110181 | 192384 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 9ft | 6015929.33713 | 2106466.90045 | 37.7648511775542 | -122.38809465775 | (37.7648511775542, -122.38809465775) | 14 | 3 | 9 | 310 | 29 | |||
148424 | 192375 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 9ft | 6015916.65317 | 2106707.2255 | 37.7655103554542 | -122.38815530173 | (37.7655103554542, -122.38815530173) | 14 | 3 | 9 | 310 | 29 | |||
152342 | 192380 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 9ft | 6015923.02581 | 2106586.61921 | 37.7651795497335 | -122.388124842588 | (37.7651795497335, -122.388124842588) | 14 | 3 | 9 | 310 | 29 | |||
191213 | 192377 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 500 Illinois St | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | Width 9ft | 6015920.48189 | 2106647.80141 | 37.7653474018847 | -122.388137911545 | (37.7653474018847, -122.388137911545) | 14 | 3 | 9 | 310 | 29 | |||
21775 | 176487 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 14 Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 4ft | 6011797.05153 | 2087306.90558 | 37.7120120754601 | -122.401040902239 | (37.7120120754601, -122.401040902239) | 10 | 3 | 8 | 309 | 1 | |||
76134 | 109289 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 26X Blanken Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6011707.98734 | 2087352.96474 | 37.7121335759116 | -122.401351970141 | (37.7121335759116, -122.401351970141) | 10 | 3 | 8 | 309 | 1 | |||||
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 | |||
96184 | 107386 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 26x BLANKEN AVE | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | 3x3 | 6011510 | 2087367 | 37.712161065506 | -122.402037262127 | (37.712161065506, -122.402037262127) | 10 | 3 | 8 | 309 | 1 | |||
194099 | 176486 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 14 Blanken Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 4ft | 6011771.80954 | 2087312.16984 | 37.7120251219234 | -122.401128515964 | (37.7120251219234, -122.401128515964) | 10 | 3 | 8 | 309 | 1 | |||
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 | |||
18781 | 103292 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Francisco St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6011032.30685 | 2121439.6325 | 37.8056902298748 | -122.406087231156 | (37.8056902298748, -122.406087231156) | 3 | 1 | 10 | 308 | 23 | |||
87636 | 103288 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Francisco St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | 3x3 | 6011153.48298 | 2121450.51033 | 37.8057268745504 | -122.405668647988 | (37.8057268745504, -122.405668647988) | 3 | 1 | 10 | 308 | 23 | |||
134580 | 103293 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Francisco St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | 3x3 | 6010999.50344 | 2121432.93356 | 37.8056700014357 | -122.406200280445 | (37.8056700014357, -122.406200280445) | 3 | 1 | 10 | 308 | 23 | |||
149463 | 103290 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Francisco St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | 3x3 | 6011095.04469 | 2121443.69303 | 37.8057048879202 | -122.405870402816 | (37.8057048879202, -122.405870402816) | 3 | 1 | 10 | 308 | 23 | |||
153770 | 103287 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6011114.9 | 2121460 | 37.805750773231 | -122.405802839637 | (37.805750773231, -122.405802839637) | 3 | 1 | 10 | 308 | 23 | ||||
165243 | 103291 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Francisco St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 3x3 | 6011052.07349 | 2121439.56361 | 37.8056911462811 | -122.406018820613 | (37.8056911462811, -122.406018820613) | 3 | 1 | 10 | 308 | 23 | |||
181566 | 128840 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 4 Francisco St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6011231.32586 | 2121455.93201 | 37.8057461137655 | -122.405399641876 | (37.8057461137655, -122.405399641876) | 3 | 1 | 10 | 308 | 23 | |||
190962 | 103289 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Francisco St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6011124.97439 | 2121449.08907 | 37.805721377897 | -122.405767206501 | (37.805721377897, -122.405767206501) | 3 | 1 | 10 | 308 | 23 | |||
183 | 253381 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 899 Waller St | 3 | Side Yard : Yard | Tree | Private 2 | 6001282 | 2108613 | 37.7699214264211 | -122.438909742148 | (37.7699214264211, -122.438909742148) | 15 | 5 | 5 | 29492 | 9 | |||||
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 | |
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 | |||
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 | |||
20980 | 140249 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 701 Masonic Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 0ft | 5999170.7375 | 2110360.1102 | 37.7745981999883 | -122.446338229944 | (37.7745981999883, -122.446338229944) | 15 | 5 | 11 | 29492 | 16 |
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) );