trees
334 rows where qSpecies_id = 59 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
127 | 119777 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
215 | 119692 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
248 | 119766 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
313 | 119729 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
413 | 119686 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
431 | 119778 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 13 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
1248 | 260958 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 2 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 5996359 | 2114633 | 37.786169437555 | -122.456373557771 | (37.786169437555, -122.456373557771) | 11 | 6 | 1 | 54 | 31 | ||||
1376 | 263620 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 3 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
4419 | 260950 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 460x Davis Ct | 2 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6013239 | 2118152 | 37.7967863568579 | -122.398219792292 | (37.7967863568579, -122.398219792292) | 3 | 1 | 10 | 28860 | 6 | ||||
10225 | 263619 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 2 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
10567 | 263621 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 4 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
11694 | 263618 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Beach St | 1 | Side Yard : Yard | Tree | DPW 1 | Rec/Park | 3x3 | 6005896 | 2121751 | 37.8062565433008 | -122.423884345484 | (37.8062565433008, -122.423884345484) | 3 | 1 | 1 | 28858 | 32 | |||
12376 | 119696 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 14 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
12956 | 119689 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
13002 | 260949 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 460x Davis Ct | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6013239 | 2118152 | 37.7967863568579 | -122.398219792292 | (37.7967863568579, -122.398219792292) | 3 | 1 | 10 | 28860 | 6 | ||||
14005 | 119780 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 15 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
15414 | 96980 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
15701 | 254211 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300X Esmeralda Ave | 3 | Unaccepted Street : Yard | Tree | DPW 1 | |||||||||||||||
16277 | 119724 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
16362 | 119731 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
17671 | 260957 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 1 | Sidewalk: Property side : Cutout | Tree | Private 2 | Width 3ft | 5996359 | 2114633 | 37.786169437555 | -122.456373557771 | (37.786169437555, -122.456373557771) | 11 | 6 | 1 | 54 | 31 | ||||
21014 | 119730 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
24272 | 117475 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1200x MONTGOMERY ST | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 6011580 | 2119440 | 37.800230345698 | -122.404051036068 | (37.800230345698, -122.404051036068) | 3 | 1 | 10 | 308 | 23 | |||||
26017 | 109376 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 3 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
31585 | 119691 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
35418 | 119732 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
42959 | 117474 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1200x MONTGOMERY ST | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 6011580 | 2119440 | 37.800230345698 | -122.404051036068 | (37.800230345698, -122.404051036068) | 3 | 1 | 10 | 308 | 23 | |||||
46759 | 119728 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
52665 | 254470 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1601 Evans Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 3x3 | 6015397 | 2098706 | 37.7435118805521 | -122.389393878977 | (37.7435118805521, -122.389393878977) | 10 | 3 | 8 | 58 | 1 | ||||
53212 | 119723 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
55125 | 98312 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 160 Stanford Heights Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5998064.7 | 2096544.4 | 37.7366004632858 | -122.449168689734 | (37.7366004632858, -122.449168689734) | 9 | 7 | 4 | 59 | 40 | |||||
56641 | 119767 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
58975 | 119683 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
60290 | 119690 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
62466 | 119770 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
64025 | 119685 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
64778 | 109377 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 4 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
64910 | 119734 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 14 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
67051 | 113134 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 03rd St | 2 | Front Yard : Yard | Tree | Private 2 | 09/09/2015 12:00:00 AM | 10x10 | Permit Number 775860 | 6011822.9 | 2114512.2 | 37.7867133521926 | -122.402863731968 | (37.7867133521926, -122.402863731968) | 12 | 2 | 9 | 28853 | 6 | ||
73440 | 116094 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
74255 | 96979 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
74269 | 119684 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
75461 | 119727 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
80147 | 116095 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
84324 | 119697 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 15 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
84676 | 109375 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 2 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
88473 | 85294 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2255 Mariposa St | Sidewalk: Property side : Cutout | Landscaping | Private 2 | 07/27/2007 12:00:00 AM | 2x50 | Permit Number 49675 | 6010752 | 2105977 | 37.7632178155038 | -122.405967315915 | (37.7632178155038, -122.405967315915) | 8 | 4 | 8 | 28859 | 19 | |||
90812 | 119733 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 13 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
93639 | 91056 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 750 FOLSOM ST | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6x4 | 6012569 | 2113092 | 37.7828554456154 | -122.400182606689 | (37.7828554456154, -122.400182606689) | 6 | 2 | 9 | 28853 | 34 | ||||
95955 | 117473 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1201x MONTGOMERY ST | 1 | Unaccepted Street : Cutout | Tree | Private 2 | 6011733 | 2119731 | 37.8010379082809 | -122.403542078239 | (37.8010379082809, -122.403542078239) | 3 | 1 | 10 | 308 | 23 | |||||
104758 | 119774 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 9 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
106853 | 119772 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 7 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
106915 | 119693 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
107339 | 119694 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 12 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
113560 | 119722 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 2 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
113742 | 119769 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 4 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
114094 | 117472 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1201x MONTGOMERY ST | 2 | Unaccepted Street : Cutout | Tree | Private 2 | 6011733 | 2119731 | 37.8010379082809 | -122.403542078239 | (37.8010379082809, -122.403542078239) | 3 | 1 | 10 | 308 | 23 | |||||
119609 | 119771 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
123430 | 96984 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
126751 | 119726 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
135794 | 119725 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
137889 | 109378 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 5 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
142556 | 256880 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2701 Alemany Blvd | 1 | Side Yard : Yard | Tree | Private 2 | 10x10 | 5997600 | 2087902 | 37.7128438731446 | -122.450152604107 | (37.7128438731446, -122.450152604107) | 9 | 7 | 6 | 28861 | 25 | ||||
145439 | 116093 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
151245 | 255455 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 31x Garlington Ct | 1 | Side Yard : Yard | Tree | Private 2 | 3x3 | 6016454 | 2094669 | 37.7324856396877 | -122.385457730704 | (37.7324856396877, -122.385457730704) | 10 | 3 | 8 | 58 | 1 | ||||
153309 | 119768 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 3 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
154885 | 116096 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
155569 | 109374 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 111 BAY ST | 1 | Back Yard : Yard | Tree | Private 2 | 6010193.2 | 2121519.2 | 37.8058617340589 | -122.408996713259 | (37.8058617340589, -122.408996713259) | 3 | 1 | 10 | 308 | 23 | |||||
158897 | 119775 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 10 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
159585 | 119687 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 5 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
160546 | 119721 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 1 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
170444 | 116097 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
171267 | 96981 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
173837 | 119695 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 13 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
177168 | 116092 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | ||||
178614 | 119779 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 14 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
179144 | 119773 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
180133 | 119735 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 104x Octavia St | 15 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
184663 | 113133 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 03rd St | 1 | Front Yard : Yard | Tree | Private 2 | 09/09/2015 12:00:00 AM | 10x10 | Permit Number 775860 | 6011822.9 | 2114512.2 | 37.7867133521926 | -122.402863731968 | (37.7867133521926, -122.402863731968) | 12 | 2 | 9 | 28853 | 6 | ||
187388 | 119776 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 204x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
187717 | 96978 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2090@Buchanan Vallejo St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 25529 | 6003561 | 2117963 | 37.7957235834131 | -122.431694388271 | (37.7957235834131, -122.431694388271) | 13 | 9 | 1 | 57 | 17 | ||||
189536 | 119688 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 4x Octavia St | 6 | Median : Cutout | Tree | DPW 1 | 2109391 | 6005718 | 47.2699873738681 | -138.2836696503 | (47.2699873738681, -138.2836696503) | ||||||||||
32481 | 246567 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 11 | Median : Yard | Tree | DPW 1 | 10 | Width 7ft | 6005696.09569 | 2109523.68249 | 37.7726720930872 | -122.423706217176 | (37.7726720930872, -122.423706217176) | 7 | 9 | 11 | 28852 | 10 | |||
40830 | 248124 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 4 | Front Yard : Yard | Tree | Private 2 | 10 | 6010394.26479 | 2099420.04988 | 37.7451938726969 | -122.406742485274 | (37.7451938726969, -122.406742485274) | 2 | 7 | 7 | 28859 | 2 | ||||
61534 | 195959 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 5 | Back Yard : Yard | Tree | Private 2 | 10 | 6015616.60441 | 2100338.74984 | 37.7480072461368 | -122.388748492749 | (37.7480072461368, -122.388748492749) | 10 | 3 | 8 | 58 | 1 | ||||
63685 | 135663 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5996346.46825 | 2114626.15487 | 37.7861499232377 | -122.456416418905 | (37.7861499232377, -122.456416418905) | 11 | 6 | 1 | 54 | 31 | |||
64096 | 195982 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 11 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | 6018502.10258 | 2099556.87815 | 37.7460198865213 | -122.378716163238 | (37.7460198865213, -122.378716163238) | 10 | 3 | 8 | 58 | 1 | ||||
80487 | 246571 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 15 | Median : Yard | Tree | DPW 1 | 10 | Width 7ft | 6005693.03742 | 2109551.27371 | 37.7727476792916 | -122.423718758221 | (37.7727476792916, -122.423718758221) | 7 | 9 | 11 | 28852 | 10 | |||
98771 | 195973 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 19 | Back Yard : Yard | Tree | Private 2 | 10 | Width 4ft | 6015335.01264 | 2100318.29491 | 37.7479354703429 | -122.389720805596 | (37.7479354703429, -122.389720805596) | 3 | 8 | 58 | 1 | ||||
116865 | 244408 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 14 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6005581.41 | 2110245.7143 | 37.7746481433715 | -122.424154286626 | (37.7746481433715, -122.424154286626) | 7 | 9 | 11 | 28852 | 10 | |||
124042 | 196027 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2 Lane St | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6017034.20589 | 2097061.66689 | 37.7390875092666 | -122.383618319135 | (37.7390875092666, -122.383618319135) | 10 | 3 | 8 | 58 | 1 | |||
127355 | 195972 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 18 | Back Yard : Yard | Tree | Private 2 | 10 | Width 4ft | 6015355.8319 | 2100319.80426 | 37.7479407691514 | -122.389648918288 | (37.7479407691514, -122.389648918288) | 3 | 8 | 58 | 1 | ||||
131182 | 244434 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 102x Octavia St | 8 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6005644.2243 | 2109791.2526 | 37.7734038478353 | -122.423904676174 | (37.7734038478353, -122.423904676174) | 7 | 9 | 11 | 28852 | 10 | |||
136053 | 244405 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 202x Octavia St | 11 | Median : Cutout | Tree | DPW 1 | 10 | Width 0ft | 6005589.0478 | 2110200.651 | 37.7745248417047 | -122.424124660487 | (37.7745248417047, -122.424124660487) | 7 | 9 | 11 | 28852 | 10 | |||
137920 | 195961 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 7 | Back Yard : Yard | Tree | Private 2 | 10 | 6015577.60391 | 2100335.50195 | 37.7479961664858 | -122.388883129368 | (37.7479961664858, -122.388883129368) | 10 | 3 | 8 | 58 | 1 | ||||
138606 | 135664 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 3ft | 5996336.60886 | 2114624.27331 | 37.7861441909595 | -122.456450393471 | (37.7861441909595, -122.456450393471) | 11 | 6 | 1 | 54 | 31 | |||
144333 | 195971 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 17 | Back Yard : Yard | Tree | Private 2 | 10 | Width 4ft | 6015377.86647 | 2100320.41197 | 37.7479436595871 | -122.389572765484 | (37.7479436595871, -122.389572765484) | 3 | 8 | 58 | 1 | ||||
158208 | 196041 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1 Lane St | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 10 | Width 10ft | 6017065.52556 | 2097005.97628 | 37.7389363251367 | -122.383506153 | (37.7389363251367, -122.383506153) | 10 | 3 | 8 | 58 | 1 | |||
161562 | 195955 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 1 | Back Yard : Yard | Tree | Private 2 | 10 | 6015700.85592 | 2100342.37267 | 37.7480218628289 | -122.388457404684 | (37.7480218628289, -122.388457404684) | 10 | 3 | 8 | 58 | 1 | ||||
176690 | 195958 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 4 | Back Yard : Yard | Tree | Private 2 | 10 | 6015649.24062 | 2100340.89834 | 37.7480149542299 | -122.388635787013 | (37.7480149542299, -122.388635787013) | 10 | 3 | 8 | 58 | 1 |
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) );