trees
556 rows where qSpecies_id = 71 sorted by Longitude
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
116486 | 109999 | Undocumented 4 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 501X Shotwell St | 16 | Sidewalk: Curb side : Cutout | Tree | DPW for City Agency 14 | DPW | 6007873.2 | 2105005.6 | 37.7603891478182 | -122.415855367022 | (37.7603891478182, -122.415855367022) | 2 | 4 | 7 | 28859 | 19 | ||||
152837 | 225882 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 2080 17th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6007844.83231 | 2106218.97723 | 37.7637192062999 | -122.41603940859 | (37.7637192062999, -122.41603940859) | 8 | 4 | 7 | 28859 | 19 | |||
170601 | 248182 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 216 Esmeralda Ave | 1 | Side Yard : Yard | Tree | Private 2 | 51 | 6007496.06144 | 2098688.36246 | 37.743022237487 | -122.416712177939 | (37.743022237487, -122.416712177939) | 2 | 7 | 7 | 28859 | 2 | ||||
83231 | 248181 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 218 Esmeralda Ave | 10 | Side Yard : Yard | Tree | Private 2 | 32 | 6007478.19635 | 2098656.73242 | 37.7429343836221 | -122.41677171037 | (37.7429343836221, -122.41677171037) | 2 | 7 | 7 | 28859 | 2 | ||||
162195 | 225881 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 3426 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007418.72238 | 2104432.80532 | 37.7587908252517 | -122.417386604731 | (37.7587908252517, -122.417386604731) | 2 | 4 | 7 | 28859 | 19 | |||
162674 | 225880 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 3426 20th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6007377.89199 | 2104432.51269 | 37.7587877244056 | -122.41752779468 | (37.7587877244056, -122.41752779468) | 2 | 4 | 7 | 28859 | 19 | |||
126439 | 248247 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 296 Esmeralda Ave | 7 | Side Yard : Yard | Tree | Private 2 | 12 | 6006821.11352 | 2098989.33644 | 37.7438106596292 | -122.419067312628 | (37.7438106596292, -122.419067312628) | 2 | 7 | 7 | 28859 | 2 | ||||
170919 | 248242 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 296 Esmeralda Ave | 2 | Side Yard : Yard | Tree | Private 2 | 27 | 6006789.28659 | 2099004.18236 | 37.7438496308664 | -122.419178415757 | (37.7438496308664, -122.419178415757) | 2 | 7 | 7 | 28859 | 2 | ||||
145469 | 248241 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 296 Esmeralda Ave | 1 | Side Yard : Yard | Tree | Private 2 | 63 | 6006778.03314 | 2099006.59157 | 37.743855612256 | -122.419217498503 | (37.743855612256, -122.419217498503) | 2 | 7 | 7 | 28859 | 2 | ||||
105123 | 225870 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 154 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006559.10741 | 2098855.11424 | 37.7434273578018 | -122.419963746949 | (37.7434273578018, -122.419963746949) | 2 | 7 | 7 | 28859 | 2 | |||
182322 | 225869 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 190 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 35 | Width 5ft | 6006549.95034 | 2098834.86462 | 37.7433712409909 | -122.419993973142 | (37.7433712409909, -122.419993973142) | 2 | 7 | 7 | 28859 | 2 | |||
133757 | 225868 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 190 Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 29 | Width 5ft | 6006540.56065 | 2098821.81069 | 37.7433348688122 | -122.420025514168 | (37.7433348688122, -122.420025514168) | 2 | 7 | 7 | 28859 | 2 | |||
79900 | 225867 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 190 Coleridge St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6006525.15417 | 2098793.36254 | 37.7432558885579 | -122.420076767448 | (37.7432558885579, -122.420076767448) | 2 | 7 | 7 | 28859 | 2 | |||
150319 | 225866 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 190 Coleridge St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 31 | Width 5ft | 6006516.03586 | 2098775.00428 | 37.7432049671495 | -122.420106993662 | (37.7432049671495, -122.420106993662) | 2 | 7 | 7 | 28859 | 2 | |||
45081 | 225865 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 190 Coleridge St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 5ft | 6006497.19455 | 2098745.86937 | 37.7431239076329 | -122.420170074782 | (37.7431239076329, -122.420170074782) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
158619 | 225864 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 190 Coleridge St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 5ft | 6006484.93585 | 2098722.65542 | 37.7430594766165 | -122.420210814975 | (37.7430594766165, -122.420210814975) | 2 | 7 | 7 | 28859 | 2 | |||
185162 | 225863 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 190 Coleridge St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6006477.67033 | 2098701.98839 | 37.7430023202088 | -122.420234470738 | (37.7430023202088, -122.420234470738) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
78552 | 17330 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 150 Otis St | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 3X3 | 6006661.1201948 | 2108857.0849494 | 37.770896202588 | -122.420320765713 | (37.770896202588, -122.420320765713) | 8 | 2 | 9 | 28853 | 19 | |||
44920 | 23633 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 198X Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6006450.06706 | 2098653.35241 | 37.7428672213344 | -122.420326464218 | (37.7428672213344, -122.420326464218) | 2 | 7 | 7 | 28859 | 2 | |||
133877 | 17331 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 150 Otis St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6006645.84304 | 2108796.58735 | 37.7707292297079 | -122.420369315185 | (37.7707292297079, -122.420369315185) | 8 | 2 | 9 | 28853 | 19 | |||
188908 | 4564 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 203 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 30 | 4x4 | 6006429.48639 | 2098539.47391 | 37.7425533768305 | -122.420389545351 | (37.7425533768305, -122.420389545351) | 2 | 7 | 7 | 28859 | 2 | |||
162068 | 4571 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 229 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 32 | 4x4 | 6006415.89392 | 2098506.82504 | 37.7424629643998 | -122.420434227284 | (37.7424629643998, -122.420434227284) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
84198 | 17334 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 170 Otis St | 2 | 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 | |||
126633 | 17335 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 170 Otis St | 3 | 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 | |||
116960 | 225861 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 321 Coleridge St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6006214.50743 | 2098136.12844 | 37.741433764066 | -122.42110424736 | (37.741433764066, -122.42110424736) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
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 | |||
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 | |||
87895 | 225843 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 20 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 6ft | 6006135.09604 | 2104067.35501 | 37.7577150787036 | -122.421800025871 | (37.7577150787036, -122.421800025871) | 2 | 4 | 5 | 28859 | 19 | |||
6835 | 4820 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 398X Coleridge St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 36 | 4x4 | 6006006.1956778 | 2097849.2293648 | 37.7406342583881 | -122.421804144483 | (37.7406342583881, -122.421804144483) | 2 | 7 | 7 | 28859 | 2 | |||
64251 | 4819 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 398X Coleridge St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 28 | 4X4 | 6006006.1956778 | 2097849.2293648 | 37.7406342583881 | -122.421804144483 | (37.7406342583881, -122.421804144483) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
65828 | 108040 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 20 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6006128.8 | 2104138.4 | 37.7579097966574 | -122.421826846578 | (37.7579097966574, -122.421826846578) | 2 | 4 | 5 | 28859 | 19 | ||||
130775 | 108039 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 20 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x6 | 6006128.8 | 2104138.4 | 37.7579097966574 | -122.421826846578 | (37.7579097966574, -122.421826846578) | 2 | 4 | 5 | 28859 | 19 | ||||
189168 | 225844 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 20 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 6ft | 6006115.25271 | 2104066.06137 | 37.7577104076212 | -122.421868560489 | (37.7577104076212, -122.421868560489) | 2 | 4 | 5 | 28859 | 19 | |||
133475 | 56271 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 38 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 07/31/1973 12:00:00 AM | 30 | Permit Number 12397 | 6006068.09932512 | 2104071.38429116 | 37.7577223637877 | -122.422032014666 | (37.7577223637877, -122.422032014666) | 2 | 4 | 5 | 28859 | 19 | ||
167214 | 225845 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 38 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 9ft | 6006048.77626 | 2104063.35692 | 37.7576992326564 | -122.422098271613 | (37.7576992326564, -122.422098271613) | 2 | 4 | 5 | 28859 | 19 | |||
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 | ||
115711 | 225846 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 44 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 9ft | 6006029.75247 | 2104062.03373 | 37.7576945264884 | -122.422163969788 | (37.7576945264884, -122.422163969788) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
141589 | 225848 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 50 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 7ft | 6005985.96721 | 2104059.53083 | 37.7576851843542 | -122.422315219586 | (37.7576851843542, -122.422315219586) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
50617 | 225850 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 58 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 9ft | 6005957.80102 | 2104057.14664 | 37.7576770490776 | -122.42241246056 | (37.7576770490776, -122.42241246056) | 2 | 4 | 5 | 28859 | 19 | |||
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 | ||||
34257 | 121460 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 58 Liberty St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005944.89012346 | 2104064.54703238 | 37.7576966405039 | -122.422457637621 | (37.7576966405039, -122.422457637621) | 2 | 4 | 5 | 28859 | 19 | |||||
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 | ||
157826 | 121458 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 58 Liberty St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005944.89012346 | 2104064.54703238 | 37.7576966405039 | -122.422457637621 | (37.7576966405039, -122.422457637621) | 2 | 4 | 5 | 28859 | 19 | |||||
186304 | 121459 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 58 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6005944.89012346 | 2104064.54703238 | 37.7576966405039 | -122.422457637621 | (37.7576966405039, -122.422457637621) | 2 | 4 | 5 | 28859 | 19 | |||||
47468 | 225851 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 58 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 9ft | 6005940.80903 | 2104056.71589 | 37.7576749077866 | -122.4224711953 | (37.7576749077866, -122.4224711953) | 2 | 4 | 5 | 28859 | 19 | |||
89703 | 225852 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 58 Liberty St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 9ft | 6005926.46484 | 2104057.0106 | 37.7576749077845 | -122.422520824396 | (37.7576749077845, -122.422520824396) | 2 | 4 | 5 | 28859 | 19 | |||
139659 | 225853 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 70 Liberty St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 6ft | 6005914.14898 | 2104056.24306 | 37.7576721055001 | -122.422563363205 | (37.7576721055001, -122.422563363205) | 2 | 4 | 5 | 28859 | 19 | |||
181587 | 225854 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 70 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 7ft | 6005875.84915 | 2104054.64821 | 37.7576655656334 | -122.422695706548 | (37.7576655656334, -122.422695706548) | 2 | 4 | 5 | 28859 | 19 | |||
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 | ||
109836 | 128838 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1614 Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6005643.34494 | 2118253.58513 | 37.7966392702321 | -122.424509769525 | (37.7966392702321, -122.424509769525) | 13 | 9 | 1 | 28858 | 17 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
123494 | 142009 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 625 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 0ft | 6004793.0024 | 2111561.975 | 37.7782177264629 | -122.426975313976 | (37.7782177264629, -122.426975313976) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
53636 | 225858 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 3561 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 4ft | 6004581.43862 | 2103650.71284 | 37.7564833393424 | -122.427143538447 | (37.7564833393424, -122.427143538447) | 2 | 4 | 5 | 28862 | 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 | |||
157626 | 8065 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 631 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 3x3 | 6004732.981 | 2111553.11801 | 37.7781900132645 | -122.427182319007 | (37.7781900132645, -122.427182319007) | 7 | 9 | 11 | 28852 | 10 | |||
102316 | 4434 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1246 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 4X4 | 6004452.33203 | 2101636.8791292 | 37.7509465218336 | -122.427446575049 | (37.7509465218336, -122.427446575049) | 2 | 4 | 5 | 28862 | 22 | |||
121899 | 8080 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 677 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 6004653.03771 | 2111392.08692 | 37.7777433402869 | -122.427447397341 | (37.7777433402869, -122.427447397341) | 7 | 9 | 11 | 28852 | 10 | |||
193007 | 8081 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 679 Fulton St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6004653.03771 | 2111392.08692 | 37.7777433402869 | -122.427447397341 | (37.7777433402869, -122.427447397341) | 7 | 9 | 11 | 28852 | 10 | |||
173293 | 225856 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 1242 Church St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 24 | Width 5ft | 6004441.23544 | 2101663.28988 | 37.7510184119866 | -122.427486829467 | (37.7510184119866, -122.427486829467) | 2 | 4 | 5 | 28862 | 22 | |||
110305 | 142007 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 661 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 23 | Width 0ft | 6004595.1648 | 2111534.882 | 37.7781321470778 | -122.427657776048 | (37.7781321470778, -122.427657776048) | 7 | 9 | 11 | 28852 | 10 | |||
145035 | 142003 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 677 FULTON ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 0ft | 6004485.604 | 2111519.815 | 37.7780845789097 | -122.428035712631 | (37.7780845789097, -122.428035712631) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
60470 | 8094 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 762 Fulton St | 5 | Sidewalk: Curb side : Cutout | Tree | Arts Commission 19 | 100 | 3X3 | 6004211.6397 | 2111535.7715 | 37.7781128879326 | -122.428984591665 | (37.7781128879326, -122.428984591665) | 7 | 9 | 11 | 28852 | 41 | |||
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 | |||
13993 | 139261 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 702 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6004039.451 | 2111223.3243 | 37.7772452370478 | -122.429557965765 | (37.7772452370478, -122.429557965765) | 7 | 9 | 11 | 28852 | 10 | |||
19018 | 28638 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 740 Webster St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 80 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.7773782078508 | -122.429572574215 | (37.7773782078508, -122.429572574215) | 7 | 9 | 11 | 28852 | 10 | |||
70665 | 23715 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 740 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.7773782078508 | -122.429572574215 | (37.7773782078508, -122.429572574215) | 7 | 9 | 11 | 28852 | 10 | |||
146070 | 23714 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 740 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 80 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.7773782078508 | -122.429572574215 | (37.7773782078508, -122.429572574215) | 7 | 9 | 11 | 28852 | 10 | |||
149324 | 23716 | Permitted Site 7 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 740 Webster St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 40 | 4X4 | 6004036.2280897 | 2111271.8185656 | 37.7773782078508 | -122.429572574215 | (37.7773782078508, -122.429572574215) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
150330 | 23718 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 760 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/19/1992 12:00:00 AM | 12 | 4X4 | 6004031.4914 | 2111284.7902 | 37.7774135565599 | -122.429589885322 | (37.7774135565599, -122.429589885322) | 7 | 9 | 11 | 28852 | 10 | ||
57094 | 23711 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 700X Webster St | 6 | Median : Cutout | Tree | DPW 1 | 80 | 20 | 6004027.2031566 | 2111122.3858595 | 37.7769673915023 | -122.429593134388 | (37.7769673915023, -122.429593134388) | 7 | 9 | 11 | 28852 | 10 | |||
115822 | 23719 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 780 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/21/1999 12:00:00 AM | 80 | 4X4 | 6004022.2052 | 2111346.6982 | 37.7775830148403 | -122.429626425718 | (37.7775830148403, -122.429626425718) | 7 | 9 | 11 | 28852 | 10 | ||
125601 | 139264 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 780 WEBSTER ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 0ft | 6004019.552 | 2111371.0192 | 37.7776496440687 | -122.42963733905 | (37.7776496440687, -122.42963733905) | 7 | 9 | 11 | 28852 | 10 | |||
59536 | 23720 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 780 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 70 | 4X4 | 6004017.263545 | 2111409.9612221 | 37.7777564396633 | -122.429648033671 | (37.7777564396633, -122.429648033671) | 7 | 9 | 11 | 28852 | 10 | |||
170517 | 139265 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 780 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 0ft | 6004014.6878 | 2111401.0888 | 37.7777319323367 | -122.429656311107 | (37.7777319323367, -122.429656311107) | 7 | 9 | 11 | 28852 | 10 | |||
169929 | 139266 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 780 Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 6004011.1502 | 2111430.7162 | 37.7778130815458 | -122.429670662491 | (37.7778130815458, -122.429670662491) | 7 | 9 | 11 | 28852 | 10 | |||
32575 | 8110 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 790X Webster St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 60 | 4X4 | 6004003.8918438 | 2111454.7703146 | 37.7778787172016 | -122.429697487702 | (37.7778787172016, -122.429697487702) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
115587 | 141991 | DPW Maintained 1 | Fraxinus uhdei :: Shamel Ash: Evergreen Ash 71 | 818 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 6004002.4362 | 2111527.1662 | 37.7780774159831 | -122.429707688099 | (37.7780774159831, -122.429707688099) | 7 | 9 | 11 | 29490 | 41 | |||
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 | |||
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 |
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) );