trees
334 rows where qSpecies_id = 59 sorted by qAddress 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
74182 | 195980 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Phelps St | 2 | Side Yard : Yard | Tree | Private 2 | 24 | 6014694.29284 | 2097256.88186 | 37.7394939174204 | -122.391722384404 | (37.7394939174204, -122.391722384404) | 10 | 3 | 8 | 58 | 1 | ||||
183244 | 195979 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 900 Phelps St | 1 | Side Yard : Yard | Tree | Private 2 | 30 | Width 9ft | 6014704.25324 | 2097268.53042 | 37.7395264548697 | -122.39168875964 | (37.7395264548697, -122.39168875964) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |||
74379 | 246918 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | Width 3ft | 5997638.10514 | 2107510.95773 | 37.7666875068428 | -122.451434340243 | (37.7666875068428, -122.451434340243) | 15 | 5 | 11 | 29492 | 9 | |||
96656 | 248613 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 28 | Width 0ft | 5997648.1233 | 2107524.615 | 37.766725579885 | -122.451400674442 | (37.766725579885, -122.451400674442) | 15 | 5 | 11 | 29492 | 9 | |||
102733 | 248614 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 0ft | 5997650.5459 | 2107506.4452 | 37.7666758289672 | -122.451390984496 | (37.7666758289672, -122.451390984496) | 15 | 5 | 11 | 29492 | 9 | |||
145764 | 246917 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 845 Shrader St | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 3ft | 5997637.48509 | 2107521.28402 | 37.766715824697 | -122.451437229753 | (37.766715824697, -122.451437229753) | 15 | 5 | 11 | 29492 | 9 | |||
111973 | 247225 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 754 Duboce Ave | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6002109.57301 | 2108309.81574 | 37.7691360073432 | -122.4360254903 | (37.7691360073432, -122.4360254903) | 15 | 5 | 5 | 29492 | 9 | ||||
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 | ||||
148445 | 91057 | Permitted Site 7 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 750 FOLSOM ST | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | 6x4 | 6012569 | 2113092 | 37.7828554456154 | -122.400182606689 | (37.7828554456154, -122.400182606689) | 6 | 2 | 9 | 28853 | 34 | |||
169477 | 255308 | Undocumented 4 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Mendell St | 1 | Front Yard : Yard | Tree | Private 2 | 06/05/2018 12:00:00 AM | 3 | 3x3 | 6017061 | 2098665 | 37.7434914187463 | -122.383637271506 | (37.7434914187463, -122.383637271506) | 10 | 3 | 8 | 58 | 1 | ||
3136 | 234897 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6009692.09622 | 2096449.43711 | 37.7369979030329 | -122.408960917621 | (37.7369979030329, -122.408960917621) | 10 | 7 | 7 | 28859 | 2 | ||||
19126 | 234903 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6009692.65358 | 2096419.54828 | 37.7369158659624 | -122.408956882348 | (37.7369158659624, -122.408956882348) | 10 | 7 | 7 | 28859 | 2 | ||||
49707 | 234909 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 10ft | 6009677.77783 | 2096362.72232 | 37.7367590008107 | -122.409004306302 | (37.7367590008107, -122.409004306302) | 10 | 7 | 7 | 28859 | 2 | |||
56401 | 234907 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6009682.36778 | 2096375.42259 | 37.7367941301369 | -122.408989332604 | (37.7367941301369, -122.408989332604) | 10 | 7 | 7 | 28859 | 2 | |||
58340 | 234904 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6009689.76503 | 2096405.45865 | 37.7368770170648 | -122.408965875569 | (37.7368770170648, -122.408965875569) | 10 | 7 | 7 | 28859 | 2 | ||||
83040 | 234899 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6009698.94501 | 2096439.52165 | 37.7369710609585 | -122.408936538802 | (37.7369710609585, -122.408936538802) | 10 | 7 | 7 | 28859 | 2 | ||||
122830 | 234901 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 12 | 6009690.97834 | 2096436.62736 | 37.7369626675976 | -122.408963879105 | (37.7369626675976, -122.408963879105) | 10 | 7 | 7 | 28859 | 2 | ||||
125376 | 234906 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | Width 8ft | 6009686.02423 | 2096384.83518 | 37.7368201799074 | -122.408977354526 | (37.7368201799074, -122.408977354526) | 10 | 7 | 7 | 28859 | 2 | |||
125984 | 234908 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 20 | Width 10ft | 6009679.55053 | 2096368.23252 | 37.7367742299367 | -122.408998565949 | (37.7367742299367, -122.408998565949) | 10 | 7 | 7 | 28859 | 2 | |||
147412 | 234898 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 2 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6009700.61042 | 2096445.6891 | 37.7369880887377 | -122.408931215729 | (37.7369880887377, -122.408931215729) | 10 | 7 | 7 | 28859 | 2 | ||||
152488 | 234902 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 6 | 6009698.63441 | 2096418.94153 | 37.7369145349811 | -122.408936161078 | (37.7369145349811, -122.408936161078) | 10 | 7 | 7 | 28859 | 2 | ||||
164603 | 234905 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | Width 8ft | 6009688.58582 | 2096390.10165 | 37.736834783993 | -122.40896886942 | (37.736834783993, -122.40896886942) | 10 | 7 | 7 | 28859 | 2 | |||
179780 | 234900 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 50 Alemany Blvd | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6009696.65795 | 2096435.22954 | 37.7369591476365 | -122.40894414348 | (37.7369591476365, -122.40894414348) | 10 | 7 | 7 | 28859 | 2 | ||||
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 | ||
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 | ||
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) | ||||||||||
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) | ||||||||||
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) | ||||||||||
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) | ||||||||||
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) | ||||||||||
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) | ||||||||||
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) | ||||||||||
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) | ||||||||||
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) | ||||||||||
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) | ||||||||||
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) | ||||||||||
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) | ||||||||||
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 | ||||
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 | ||||
28533 | 195986 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 7 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6018468.61509 | 2099561.76349 | 37.7460314544851 | -122.378832298987 | (37.7460314544851, -122.378832298987) | 10 | 3 | 8 | 58 | 1 | ||||
47866 | 195983 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 10 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6018491.3513 | 2099573.26629 | 37.7460642923356 | -122.378754477939 | (37.7460642923356, -122.378754477939) | 10 | 3 | 8 | 58 | 1 | ||||
55799 | 195988 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 5 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6018362.60368 | 2099564.59582 | 37.7460333862374 | -122.379199073078 | (37.7460333862374, -122.379199073078) | 10 | 3 | 8 | 58 | 1 | ||||
62379 | 195992 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6018320.61791 | 2099573.80473 | 37.7460563567193 | -122.379344895446 | (37.7460563567193, -122.379344895446) | 10 | 3 | 8 | 58 | 1 | ||||
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 | ||||
82059 | 195984 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 9 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6018485.16554 | 2099556.70792 | 37.7460184853642 | -122.378774718093 | (37.7460184853642, -122.378774718093) | 10 | 3 | 8 | 58 | 1 | ||||
99139 | 195989 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 3 | 6018358.23149 | 2099573.02507 | 37.7460562901585 | -122.379214777067 | (37.7460562901585, -122.379214777067) | 10 | 3 | 8 | 58 | 1 | ||||
120240 | 195985 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 8 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6018474.35913 | 2099556.32192 | 37.7460168297129 | -122.378812058831 | (37.7460168297129, -122.378812058831) | 10 | 3 | 8 | 58 | 1 | ||||
127782 | 195991 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | 6018339.20952 | 2099575.6179 | 37.7460623605839 | -122.379280733321 | (37.7460623605839, -122.379280733321) | 10 | 3 | 8 | 58 | 1 | ||||
135590 | 195990 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 4 | 6018348.89198 | 2099575.3229 | 37.7460620845153 | -122.379247231793 | (37.7460620845153, -122.379247231793) | 10 | 3 | 8 | 58 | 1 | ||||
176786 | 195987 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 6 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | 6018466.53487 | 2099573.76457 | 37.7460642923433 | -122.378840325441 | (37.7460642923433, -122.378840325441) | 10 | 3 | 8 | 58 | 1 | ||||
185083 | 195981 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 401 Amador St | 12 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | 6018524.13374 | 2099557.33259 | 37.7460223488573 | -122.378640013128 | (37.7460223488573, -122.378640013128) | 10 | 3 | 8 | 58 | 1 | ||||
193664 | 121867 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 382 18th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5990303.78145 | 2112825.75308 | 37.7808577673116 | -122.477190674715 | (37.7808577673116, -122.477190674715) | 11 | 6 | 2 | 55 | 26 | |||
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 | ||||
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 | ||||
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 | |||
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 | |||
154598 | 135665 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3790 California St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 3ft | 5996326.40952 | 2114621.95963 | 37.7861372526689 | -122.456485512902 | (37.7861372526689, -122.456485512902) | 11 | 6 | 1 | 54 | 31 | |||
99978 | 234895 | Property Tree 8 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3255x 24th St | 6 | Side Yard : Cutout | Tree | Private 2 | 40 | Width 10ft | 6007298 | 2102020 | 37.7521590216883 | -122.417633107694 | (37.7521590216883, -122.417633107694) | 2 | 4 | 7 | 28859 | 19 | |||
109416 | 212850 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 32 Malta Dr | 32 | Sidewalk: Curb side : Yard | Tree | Private 2 | 32 | Width 3ft | 5999489.82188 | 2096117.1264 | 37.7355086796695 | -122.444210754429 | (37.7355086796695, -122.444210754429) | 9 | 7 | 4 | 63 | 40 | |||
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 | ||||
148446 | 53540 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 308 04th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/05/1969 12:00:00 AM | 24 | Permit Number 6452 | 5994656.44022 | 2113376.70713 | 37.7826221103339 | -122.462172779062 | (37.7826221103339, -122.462172779062) | 11 | 6 | 2 | 54 | 11 | ||
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 | ||||
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 | ||||
118842 | 116091 | Significant Tree 6 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300x EXECUTIVE PARK BLVD | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3x3 | 6014482 | 2086919 | 37.7110963749119 | -122.391733773238 | (37.7110963749119, -122.391733773238) | 10 | 3 | 8 | 309 | 1 | |||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
153116 | 24282 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300X Winding Way | 20 | Median : Cutout | Tree | DPW 1 | 3 | 8 | 6001646.2933309 | 2086550.8578367 | 37.7093646550959 | -122.436070699117 | (37.7093646550959, -122.436070699117) | 9 | 7 | 6 | 28861 | 5 | |||
15701 | 254211 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 300X Esmeralda Ave | 3 | Unaccepted Street : Yard | Tree | DPW 1 | |||||||||||||||
78015 | 135666 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 3001 Divisadero St | 4 | Sidewalk: Curb side : Yard | Tree | Private 2 | 42 | Width 9ft | 6000472.49775 | 2118651.89467 | 37.7974395562567 | -122.442430617479 | (37.7974395562567, -122.442430617479) | 13 | 9 | 1 | 57 | 17 | |||
19788 | 246559 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 3 | Median : Yard | Tree | DPW 1 | 6 | Width 7ft | 6005723.21879 | 2109372.62983 | 37.7722588698898 | -122.423601653893 | (37.7722588698898, -122.423601653893) | 7 | 9 | 11 | 28852 | 10 | |||
24737 | 246562 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 6 | Median : Yard | Tree | DPW 1 | 16 | Width 7ft | 6005708.50416 | 2109443.88838 | 37.7724536981194 | -122.423657620518 | (37.7724536981194, -122.423657620518) | 7 | 9 | 11 | 28852 | 10 | |||
26372 | 246564 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 8 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6005706.72335 | 2109459.01828 | 37.7724951406584 | -122.423664856449 | (37.7724951406584, -122.423664856449) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
37967 | 246565 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 9 | Median : Yard | Tree | DPW 1 | 11 | Width 7ft | 6005706.10974 | 2109468.40026 | 37.7725208666788 | -122.423667646169 | (37.7725208666788, -122.423667646169) | 7 | 9 | 11 | 28852 | 10 | |||
67742 | 246560 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 4 | Median : Yard | Tree | DPW 1 | 5 | Width 7ft | 6005720.56075 | 2109380.70244 | 37.772280885298 | -122.423611422347 | (37.772280885298, -122.423611422347) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
81955 | 246558 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 2 | Median : Yard | Tree | DPW 1 | 7 | Width 7ft | 6005725.55596 | 2109365.49138 | 37.7722394013476 | -122.423593061791 | (37.7722394013476, -122.423593061791) | 7 | 9 | 11 | 28852 | 10 | |||
84264 | 246561 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 5 | Median : Yard | Tree | DPW 1 | 8 | Width 7ft | 6005718.25772 | 2109387.68034 | 37.7722999149342 | -122.423619884948 | (37.7722999149342, -122.423619884948) | 7 | 9 | 11 | 28852 | 10 | |||
100151 | 246569 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 13 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6005694.60842 | 2109539.50826 | 37.772715462883 | -122.423712487254 | (37.772715462883, -122.423712487254) | 7 | 9 | 11 | 28852 | 10 | |||
115890 | 246568 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 12 | Median : Yard | Tree | DPW 1 | 7 | Width 7ft | 6005695.27816 | 2109533.51475 | 37.7726990439551 | -122.423709744321 | (37.7726990439551, -122.423709744321) | 7 | 9 | 11 | 28852 | 10 | |||
142683 | 246566 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 10 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6005705.41603 | 2109475.54193 | 37.772540436826 | -122.423670553651 | (37.772540436826, -122.423670553651) | 7 | 9 | 11 | 28852 | 10 | |||
148891 | 246563 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 7 | Median : Yard | Tree | DPW 1 | 14 | Width 7ft | 6005707.64026 | 2109451.46523 | 37.7724744535597 | -122.423661147645 | (37.7724744535597, -122.423661147645) | 7 | 9 | 11 | 28852 | 10 | |||
165695 | 246570 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 14 | Median : Yard | Tree | DPW 1 | 9 | Width 7ft | 6005693.82305 | 2109545.39115 | 37.7727315715478 | -122.423715622299 | (37.7727315715478, -122.423715622299) | 7 | 9 | 11 | 28852 | 10 | |||
178785 | 246557 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2x Octavia St | 1 | Median : Yard | Tree | DPW 1 | 11 | Width 7ft | 6005728.07536 | 2109359.17359 | 37.7722221964256 | -122.4235838977 | (37.7722221964256, -122.4235838977) | 7 | 9 | 11 | 28852 | 10 | |||
23378 | 234893 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 7 | Front Yard : Yard | Tree | Private 2 | 17 | 6010664.01336 | 2100659.8191 | 37.7486130978165 | -122.405897053323 | (37.7486130978165, -122.405897053323) | 2 | 7 | 7 | 28859 | 2 | ||||
47166 | 234889 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 3 | Front Yard : Yard | Tree | Private 2 | 25 | 6010620.28496 | 2100677.87035 | 37.7486602169168 | -122.406049537871 | (37.7486602169168, -122.406049537871) | 2 | 7 | 7 | 28859 | 2 | ||||
52513 | 234888 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 2 | Front Yard : Yard | Tree | Private 2 | 33 | 6010611.763 | 2100694.95228 | 37.7487066435094 | -122.406080210127 | (37.7487066435094, -122.406080210127) | 2 | 7 | 7 | 28859 | 2 | ||||
76548 | 234891 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 5 | Front Yard : Yard | Tree | Private 2 | 12 | 6010619.31212 | 2100642.55964 | 37.7485632070257 | -122.406050414705 | (37.7485632070257, -122.406050414705) | 2 | 7 | 7 | 28859 | 2 | ||||
97525 | 234890 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 4 | Front Yard : Yard | Tree | Private 2 | 14 | 6010623.85334 | 2100666.44158 | 37.7486290355994 | -122.406036393361 | (37.7486290355994, -122.406036393361) | 2 | 7 | 7 | 28859 | 2 | ||||
110194 | 234887 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 1 | Front Yard : Yard | Tree | Private 2 | 15 | 6010600.22161 | 2100713.10517 | 37.7487558418292 | -122.406121399085 | (37.7487558418292, -122.406121399085) | 2 | 7 | 7 | 28859 | 2 | ||||
111007 | 234892 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 6 | Front Yard : Yard | Tree | Private 2 | 18 | 6010653.55518 | 2100656.49907 | 37.7486033968442 | -122.40593298392 | (37.7486033968442, -122.40593298392) | 2 | 7 | 7 | 28859 | 2 |
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) );