trees
334 rows where qSpecies_id = 59 sorted by PlotSize
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||||||||
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 | ||||
111134 | 234874 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 4 | Sidewalk: Property side : Yard | Tree | Private 2 | 33 | 6010703.27515 | 2100855.87105 | 37.7491536092595 | -122.40577509356 | (37.7491536092595, -122.40577509356) | 10 | 4 | 7 | 28859 | 19 | ||||
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 | ||||
113044 | 248122 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 2 | Front Yard : Yard | Tree | Private 2 | 14 | 6010390.78091 | 2099407.55033 | 37.7451593567256 | -122.406753651253 | (37.7451593567256, -122.406753651253) | 2 | 7 | 7 | 28859 | 2 | ||||
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 | |||||
114900 | 234880 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 24 | 6010577.49101 | 2100830.77043 | 37.7490776534227 | -122.406208290698 | (37.7490776534227, -122.406208290698) | 10 | 4 | 7 | 28859 | 19 | ||||
115793 | 234881 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 29 | 6010567.07854 | 2100828.40228 | 37.749070568567 | -122.406244130469 | (37.749070568567, -122.406244130469) | 10 | 4 | 7 | 28859 | 19 | ||||
117375 | 234878 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 9 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6010615.53478 | 2100839.32379 | 37.7491032670092 | -122.406077336824 | (37.7491032670092, -122.406077336824) | 10 | 4 | 7 | 28859 | 19 | ||||
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) | ||||||||||
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 | ||||
121047 | 234886 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 17 | Sidewalk: Property side : Yard | Tree | Private 2 | 28 | 6010522.64734 | 2100819.38367 | 37.7490433200014 | -122.406397139344 | (37.7490433200014, -122.406397139344) | 10 | 4 | 7 | 28859 | 19 | ||||
121304 | 234879 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 10 | Sidewalk: Property side : Yard | Tree | Private 2 | 30 | 6010587.10266 | 2100832.95642 | 37.7490841933025 | -122.406175207346 | (37.7490841933025, -122.406175207346) | 10 | 4 | 7 | 28859 | 19 | ||||
121735 | 196003 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015962.95079 | 2110705.93329 | 37.7764924967751 | -122.388274269443 | (37.7764924967751, -122.388274269443) | 14 | 3 | 9 | 310 | 20 | ||||
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 | ||||
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 | ||||
126204 | 196009 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 13 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015830.73834 | 2110698.70731 | 37.776465329147 | -122.388731129538 | (37.776465329147, -122.388731129538) | 14 | 3 | 9 | 310 | 20 | ||||
126542 | 248127 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 7 | Front Yard : Yard | Tree | Private 2 | 18 | 6010399.6226 | 2099438.06548 | 37.7452436393873 | -122.406725228187 | (37.7452436393873, -122.406725228187) | 2 | 7 | 7 | 28859 | 2 | ||||
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) | ||||||||||
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 | ||||
131745 | 234883 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 14 | Sidewalk: Property side : Yard | Tree | Private 2 | 22 | 6010542.26084 | 2100823.35069 | 37.7490553097539 | -122.406329594845 | (37.7490553097539, -122.406329594845) | 10 | 4 | 7 | 28859 | 19 | ||||
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 | ||||
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) | ||||||||||
137112 | 196001 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 5 | Sidewalk: Property side : Yard | Tree | Private 2 | 4 | 6016008.12939 | 2110708.52586 | 37.7765021186104 | -122.388118163334 | (37.7765021186104, -122.388118163334) | 14 | 3 | 9 | 310 | 20 | ||||
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 | |||||
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 | ||||
138177 | 196019 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 23 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6015611.09455 | 2110687.68162 | 37.7764228793455 | -122.389490176245 | (37.7764228793455, -122.389490176245) | 14 | 3 | 9 | 310 | 20 | ||||
138530 | 195967 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 13 | Back Yard : Yard | Tree | Private 2 | 5 | 6015456.78398 | 2100328.64296 | 37.747970635647 | -122.389300444473 | (37.747970635647, -122.389300444473) | 3 | 8 | 58 | 1 | |||||
142091 | 234885 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 16 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 6010529.65259 | 2100820.82881 | 37.7490476799194 | -122.406373016826 | (37.7490476799194, -122.406373016826) | 10 | 4 | 7 | 28859 | 19 | ||||
145197 | 196008 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 12 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015854.16157 | 2110700.296 | 37.7764709894889 | -122.388650212137 | (37.7764709894889, -122.388650212137) | 14 | 3 | 9 | 310 | 20 | ||||
145571 | 248126 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 6 | Front Yard : Yard | Tree | Private 2 | 6 | 6010387.78953 | 2099433.6295 | 37.7452307970734 | -122.406765832574 | (37.7452307970734, -122.406765832574) | 2 | 7 | 7 | 28859 | 2 | ||||
146008 | 234876 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 27 | 6010649.76891 | 2100846.09542 | 37.7491237751432 | -122.405959431208 | (37.7491237751432, -122.405959431208) | 10 | 4 | 7 | 28859 | 19 | ||||
146085 | 248120 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 10 | Side Yard : Yard | Tree | Private 2 | 12 | 6010373.21137 | 2099395.33781 | 37.745124840742 | -122.406813543437 | (37.745124840742, -122.406813543437) | 2 | 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 | ||||
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 | ||
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 | ||||
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) | ||||||||||
155557 | 195964 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 10 | Back Yard : Yard | Tree | Private 2 | 8 | 6015516.57214 | 2100331.82177 | 37.7479826784534 | -122.38909391965 | (37.7479826784534, -122.38909391965) | 10 | 3 | 8 | 58 | 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 | |||||
155750 | 196017 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 21 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015653.37625 | 2110690.3321 | 37.776432501193 | -122.389344095768 | (37.776432501193, -122.389344095768) | 14 | 3 | 9 | 310 | 20 | ||||
156312 | 104131 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800X Buchanan St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | 6003522.94878 | 2118100.93382 | 37.7961001572485 | -122.431835905912 | (37.7961001572485, -122.431835905912) | 13 | 9 | 1 | 57 | 17 | ||||
158107 | 196020 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 24 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6015589.15281 | 2110687.71234 | 37.7764217471115 | -122.38956608172 | (37.7764217471115, -122.38956608172) | 14 | 3 | 9 | 310 | 20 | ||||
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) | ||||||||||
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 | ||||
165442 | 234871 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6010740.98958 | 2100867.24575 | 37.7491869507297 | -122.405645476962 | (37.7491869507297, -122.405645476962) | 10 | 4 | 7 | 28859 | 19 | ||||
167404 | 195963 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 9 | Back Yard : Yard | Tree | Private 2 | 8 | 6015537.22246 | 2100333.68578 | 37.7479889413373 | -122.389022641203 | (37.7479889413373, -122.389022641203) | 10 | 3 | 8 | 58 | 1 | ||||
169280 | 201997 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 1799 Carroll Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 2 | 6013313.68951 | 2092516.98736 | 37.7264024081338 | -122.396163841002 | (37.7264024081338, -122.396163841002) | 10 | 3 | 8 | 58 | 1 | ||||
169789 | 196016 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 20 | Sidewalk: Property side : Yard | Tree | Private 2 | 15 | 6015678.42156 | 2110690.23877 | 37.7764336334278 | -122.389257449686 | (37.7764336334278, -122.389257449686) | 14 | 3 | 9 | 310 | 20 | ||||
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 | ||||
172175 | 248118 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 108 Brewster St | 8 | Side Yard : Yard | Tree | Private 2 | 6 | 6010376.97092 | 2099406.95495 | 37.7451569492381 | -122.40680136209 | (37.7451569492381, -122.40680136209) | 2 | 7 | 7 | 28859 | 2 | ||||
173532 | 195957 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 3 | Back Yard : Yard | Tree | Private 2 | 12 | 6015667.37966 | 2100340.53223 | 37.7480149542209 | -122.388573036834 | (37.7480149542209, -122.388573036834) | 10 | 3 | 8 | 58 | 1 | ||||
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) | ||||||||||
175828 | 195997 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 1 | Sidewalk: Property side : Yard | Tree | Private 2 | 23 | 6016094.12732 | 2110713.51522 | 37.776520582607 | -122.387821017432 | (37.776520582607, -122.387821017432) | 14 | 3 | 9 | 310 | 20 | ||||
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 | ||||
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 | ||||
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) | ||||||||||
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 | ||||
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) | ||||||||||
182229 | 234877 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2800 Cesar Chavez St | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 38 | 6010643.54009 | 2100844.31084 | 37.7491185267072 | -122.405980844948 | (37.7491185267072, -122.405980844948) | 10 | 4 | 7 | 28859 | 19 | ||||
184380 | 196015 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 19 | Sidewalk: Property side : Yard | Tree | Private 2 | 17 | 6015698.09519 | 2110690.66596 | 37.7764358970472 | -122.389189422279 | (37.7764358970472, -122.389189422279) | 14 | 3 | 9 | 310 | 20 | ||||
185058 | 196002 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 6 | Sidewalk: Property side : Yard | Tree | Private 2 | 18 | 6015985.51722 | 2110706.09628 | 37.7764941946745 | -122.388196216398 | (37.7764941946745, -122.388196216398) | 14 | 3 | 9 | 310 | 20 | ||||
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 | ||||
187174 | 234894 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 2827 Cesar Chavez St | 12 | Front Yard : Yard | Tree | Private 2 | 27 | 6010729.67514 | 2100698.35511 | 37.7487225812957 | -122.405672708429 | (37.7487225812957, -122.405672708429) | 2 | 7 | 7 | 28859 | 2 | ||||
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) | ||||||||||
191532 | 196004 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 212 Terry A Francois Blvd | 8 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | 6015940.35109 | 2110704.12187 | 37.7764862707572 | -122.388352322497 | (37.7764862707572, -122.388352322497) | 14 | 3 | 9 | 310 | 20 | ||||
191905 | 248123 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 109 Brewster St | 3 | Front Yard : Yard | Tree | Private 2 | 13 | 6010392.06783 | 2099413.07866 | 37.7451746083214 | -122.406749590819 | (37.7451746083214, -122.406749590819) | 2 | 7 | 7 | 28859 | 2 | ||||
192137 | 195960 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 200 Tulare St | 6 | Back Yard : Yard | Tree | Private 2 | 8 | 6015597.7328 | 2100337.72732 | 37.7480033925609 | -122.388813679213 | (37.7480033925609, -122.388813679213) | 10 | 3 | 8 | 58 | 1 | ||||
13169 | 20051 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 100 STAIRWAY52 | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 10 | |||||||||||||
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 | ||
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 | ||||
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 | ||
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 | |||
36058 | 6095 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 106X Saint Joseph's Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 10/19/2015 12:00:00 AM | 12 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.7803859446112 | -122.44108008458 | (37.7803859446112, -122.44108008458) | 15 | 5 | 1 | 29490 | 41 | ||
129436 | 6094 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 106X Saint Joseph's Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 20 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.7803859446112 | -122.44108008458 | (37.7803859446112, -122.44108008458) | 15 | 5 | 1 | 29490 | 41 | |||
145827 | 6098 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 106X Saint Joseph's Ave | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3X3 | 6000733.8426241 | 2112435.5369559 | 37.7803859446112 | -122.44108008458 | (37.7803859446112, -122.44108008458) | 15 | 5 | 1 | 29490 | 41 | |||
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 | |||
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 | ||||
14196 | 6096 | DPW Maintained 1 | Populus nigra 'Italica' :: Lombardy Poplar 59 | 106X Saint Joseph's Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6000733.8426241 | 2112435.5369559 | 37.7803859446112 | -122.44108008458 | (37.7803859446112, -122.44108008458) | 15 | 5 | 1 | 29490 | 41 | |||
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 | ||||
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 | ||||
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 | ||||
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 | ||||
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 | ||
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 |
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) );