trees

334 rows where qSpecies_id = 59 sorted by Longitude

✎ View and edit SQL

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)
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
108842 196023 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1670 Owen St 28 Sidewalk: Property side : Yard Tree Private 2     12 Width 8ft   6013858.29957 2107482.27299 37.7675242045935 -122.395329033601 (37.7675242045935, -122.395329033601) 14 3 9 310 20
100049 196024 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1670 Owen St 29 Sidewalk: Property side : Yard Tree Private 2     15 Width 8ft   6013848.21751 2107498.56576 37.7675683801977 -122.395365047877 (37.7675683801977, -122.395365047877) 14 3 9 310 20
61218 201995 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1799 Carroll Ave 1 Sidewalk: Curb side : Yard Tree Private 2     2     6013319.20907 2092521.70031 37.7264156560521 -122.396145090149 (37.7264156560521, -122.396145090149) 10 3 8 58 1
104890 201994 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1799 Carroll Ave 3 Sidewalk: Curb side : Yard Tree Private 2     2     6013316.6056 2092506.69666 37.7263743142142 -122.396153039251 (37.7263743142142, -122.396153039251) 10 3 8 58 1
97183 201993 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1799 Carroll Ave 5 Sidewalk: Curb side : Yard Tree Private 2     2     6013314.35101 2092488.44605 37.7263240762942 -122.396159554816 (37.7263240762942, -122.396159554816) 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
21347 201996 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1799 Carroll Ave 4 Sidewalk: Curb side : Yard Tree Private 2     2     6013312.67339 2092499.74696 37.7263550129554 -122.396166145968 (37.7263550129554, -122.396166145968) 10 3 8 58 1
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
115902 195996 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2101 Newcomb Ave 5 Side Yard : Yard Tree Private 2     14 Width 3ft   6012499.27572 2097703.95349 37.7405993901482 -122.399343221431 (37.7405993901482, -122.399343221431) 10 3 8 58 1
93753 195995 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2101 Newcomb Ave 4 Side Yard : Yard Tree Private 2     23 Width 3ft   6012483.54441 2097715.89022 37.7406312890986 -122.399398452383 (37.7406312890986, -122.399398452383) 10 3 8 58 1
32210 195994 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2101 Newcomb Ave 3 Side Yard : Yard Tree Private 2     20 Width 3ft   6012438.11131 2097750.05558 37.7407225675882 -122.39955794175 (37.7407225675882, -122.39955794175) 10 3 8 58 1
189964 195993 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2101 Newcomb Ave 2 Side Yard : Yard Tree Private 2     23 Width 3ft   6012429.27896 2097757.0265 37.7407412159349 -122.399588970171 (37.7407412159349, -122.399588970171) 10 3 8 58 1
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
86942 103067 Permitted Site 7 Populus nigra 'Italica' :: Lombardy Poplar 59 255 Broadway 6 Sidewalk: Curb side : Cutout Tree Private 2   12/11/2014 12:00:00 AM 3 6x6 Permit Number 769997 6012256.1 2118721.6 37.7982955442476 -122.401660929382 (37.7982955442476, -122.401660929382) 3 1 10 28860 6
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
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
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
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
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
66019 249894 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 230 Greenwich St 30 Back Yard : Yard Tree Private 2     24 Width 0ft   6011403.76038 2120447.63681 37.8029872221404 -122.404731874586 (37.8029872221404, -122.404731874586) 3 1 10 28860 6
98514 249895 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 230 Greenwich St 31 Back Yard : Yard Tree Private 2     18 Width 0ft   6011395.76102 2120447.38073 37.8029860719045 -122.404759538639 (37.8029860719045, -122.404759538639) 3 1 10 28860 6
77598 249893 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 230 Greenwich St 29 Back Yard : Yard Tree Private 2     13 Width 0ft   6011394.80053 2120441.53452 37.8029699659579 -122.404762450627 (37.8029699659579, -122.404762450627) 3 1 10 28860 6
142161 249896 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 230 Greenwich St 32 Back Yard : Yard Tree Private 2     24 Width 0ft   6011386.30387 2120437.51769 37.8029584618196 -122.404791570676 (37.8029584618196, -122.404791570676) 3 1 10 28860 6
150059 249897 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1497 Montgomery St 5 Side Yard : Yard Tree Private 2     20 Width 0ft   6011384.61876 2120458.08201 37.8030148322229 -122.404798850701 (37.8030148322229, -122.404798850701) 3 1 10 28860 6
35274 249899 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1497 Montgomery St 3 Side Yard : Yard Tree Private 2     17 Width 0ft   6011381.09793 2120471.14228 37.8030504957345 -122.404811954701 (37.8030504957345, -122.404811954701) 3 1 10 28860 6
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
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
24893 234872 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 2 Sidewalk: Property side : Yard Tree Private 2     31     6010732.42318 2100864.09022 37.7491778073048 -122.405674877619 (37.7491778073048, -122.405674877619) 10 4 7 28859 19
21087 234873 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 3 Sidewalk: Property side : Yard Tree Private 2     11     6010726.23893 2100862.83367 37.7491740112676 -122.405696174457 (37.7491740112676, -122.405696174457) 10 4 7 28859 19
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
66581 234875 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 5 Sidewalk: Property side : Yard Tree Private 2     12     6010693.4536 2100854.39807 37.7491490155229 -122.405808953037 (37.7491490155229, -122.405808953037) 10 4 7 28859 19
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
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
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
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
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
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
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
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
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
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
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
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
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
78172 234882 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 13 Sidewalk: Property side : Yard Tree Private 2     14     6010551.46993 2100825.34606 37.7490613037485 -122.406297890147 (37.7490613037485, -122.406297890147) 10 4 7 28859 19
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
34861 234884 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Cesar Chavez St 15 Sidewalk: Property side : Yard Tree Private 2     20     6010535.25533 2100821.90556 37.7490509498578 -122.406353718268 (37.7490509498578, -122.406353718268) 10 4 7 28859 19
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
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
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
12617 249797 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 199 Chestnut St 5 Front Yard : Yard Tree Private 2     13 Width 0ft   6010839.41961 2121064.72571 37.8046500380318 -122.406728311085 (37.8046500380318, -122.406728311085) 3 1 10 308 23
19786 248125 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 109 Brewster St 5 Front Yard : Yard Tree Private 2     7     6010397.04877 2099427.00914 37.7452131370768 -122.406733349058 (37.7452131370768, -122.406733349058) 2 7 7 28859 2
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
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
27833 249798 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 199 Chestnut St 6 Front Yard : Yard Tree Private 2     14 Width 0ft   6010832.73906 2121063.1197 37.8046452545423 -122.406751316639 (37.8046452545423, -122.406751316639) 3 1 10 308 23
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
77949 248121 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 109 Brewster St 1 Front Yard : Yard Tree Private 2     11     6010387.39582 2099398.52057 37.7451343735684 -122.406764720109 (37.7451343735684, -122.406764720109) 2 7 7 28859 2
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
40536 248113 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Brewster St 3 Side Yard : Yard Tree Private 2     17     6010385.30327 2099441.28079 37.7452516667373 -122.406774968811 (37.7452516667373, -122.406774968811) 2 7 7 28859 2
35297 248111 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Brewster St 1 Side Yard : Yard Tree Private 2     24     6010383.71107 2099443.85944 37.7452586580609 -122.406780656096 (37.7452586580609, -122.406780656096) 2 7 7 28859 2
80514 248115 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Brewster St 5 Side Yard : Yard Tree Private 2     7     6010382.66989 2099427.30215 37.7452131370921 -122.406783089664 (37.7452131370921, -122.406783089664) 2 7 7 28859 2
89186 248114 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Brewster St 4 Side Yard : Yard Tree Private 2     15     6010381.0463 2099434.05906 37.7452315992509 -122.406789179902 (37.7452315992509, -122.406789179902) 2 7 7 28859 2
104444 248116 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Brewster St 6 Side Yard : Yard Tree Private 2     9     6010379.57479 2099419.47211 37.745191464328 -122.406793240314 (37.745191464328, -122.406793240314) 2 7 7 28859 2
37570 248117 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Brewster St 7 Side Yard : Yard Tree Private 2     6     6010378.29952 2099414.5285 37.7451778188963 -122.406797301657 (37.7451778188963, -122.406797301657) 2 7 7 28859 2
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
87689 248119 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Brewster St 9 Side Yard : Yard Tree Private 2     18     6010375.35501 2099399.67941 37.7451368817742 -122.406806436993 (37.7451368817742, -122.406806436993) 2 7 7 28859 2
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
78217 249800 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 199 Chestnut St 8 Front Yard : Yard Tree Private 2     16 Width 0ft   6010811.58408 2121055.18857 37.8046222939481 -122.406823966551 (37.8046222939481, -122.406823966551) 3 1 10 308 23
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
20810 248173 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 218 Esmeralda Ave 2 Side Yard : Yard Tree Private 2     6     6007303.95131 2098726.55555 37.743116300271 -122.417379150221 (37.743116300271, -122.417379150221) 2 7 7 28859 2
80814 248172 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 218 Esmeralda Ave 1 Side Yard : Yard Tree Private 2     12     6007302.01446 2098729.32454 37.7431237943252 -122.417386043537 (37.7431237943252, -122.417386043537) 2 7 7 28859 2
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
150253 234896 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 4 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 10ft   6007240.7393 2101963.94083 37.7520018736867 -122.417827151095 (37.7520018736867, -122.417827151095) 2 4 7 28859 19
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

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);