trees

228 rows where qCaretaker_id = 2 and qSpecies_id = 59

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

  • Private · 128 ✖
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)
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
90159 195962 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 8 Back Yard : Yard Tree Private 2     9     6015556.60842 2100333.99599 37.7479908676843 -122.388955626422 (37.7479908676843, -122.388955626422) 10 3 8 58 1
91372 96982 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     41   Permit Number 25529 6003530.13563 2118059.26209 37.7959861448054 -122.431808061115 (37.7959861448054, -122.431808061115) 13 9 1 57 17
91426 196034 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 1 Sidewalk: Property side : Yard Tree Private 2     19 Width 10ft   6017038.23562 2096967.92235 37.7388303283508 -122.38359786136 (37.7388303283508, -122.38359786136) 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
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
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
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
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
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
98268 196037 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 6 Sidewalk: Property side : Yard Tree Private 2     15 Width 10ft   6017049.14343 2096982.73756 37.7388716108342 -122.383561177999 (37.7388716108342, -122.383561177999) 10 3 8 58 1
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
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
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
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
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
100061 195998 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 2 Sidewalk: Property side : Yard Tree Private 2     18     6016075.49067 2110714.30849 37.7765217283366 -122.387885542896 (37.7765217283366, -122.387885542896) 14 3 9 310 20
102343 196033 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2 Lane St 13 Sidewalk: Property side : Yard Tree Private 2     6 Width 10ft   6017016.3348 2097035.41086 37.7390144276853 -122.383678282325 (37.7390144276853, -122.383678282325) 10 3 8 58 1
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
103959 195966 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 12 Back Yard : Yard Tree Private 2     6     6015475.98989 2100328.78152 37.7479720808553 -122.389234040342 (37.7479720808553, -122.389234040342)   3 8 58 1
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
104734 196035 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 2 Sidewalk: Property side : Yard Tree Private 2     18 Width 10ft   6017042.43736 2096973.93304 37.7388470647366 -122.383583751905 (37.7388470647366, -122.383583751905) 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
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
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
110153 196040 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 10 Sidewalk: Property side : Yard Tree Private 2     12 Width 10ft   6017061.14337 2096999.06361 37.7389171021312 -122.383520823632 (37.7389171021312, -122.383520823632) 10 3 8 58 1
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
112062 196048 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 25 Sidewalk: Property side : Yard Tree Private 2     16 Width 10ft   6017086.86394 2097032.16257 37.7390094067689 -122.383434196434 (37.7390094067689, -122.383434196434) 10 3 8 58 1
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
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
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
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
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
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
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
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
126030 140081 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 104 Saint Joseph's Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 0ft   6000726.184 2112472.3974 37.7804867177527 -122.441109224562 (37.7804867177527, -122.441109224562) 15 5 1 29490 41
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
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
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
136935 196026 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2 Lane St 3 Sidewalk: Property side : Yard Tree Private 2     20 Width 10ft   6017039.21913 2097067.45785 37.7391036871735 -122.383601388517 (37.7391036871735, -122.383601388517) 10 3 8 58 1
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
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
140069 212849 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1201 Ulloa St 3 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   5992374.69215 2098410.70315 37.7413977704887 -122.468977090726 (37.7413977704887, -122.468977090726) 1 8 4 59 40
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
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
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
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
144912 196042 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 14 Sidewalk: Property side : Yard Tree Private 2     7 Width 10ft   6017068.02223 2097008.36414 37.7389430197102 -122.383497686772 (37.7389430197102, -122.383497686772) 10 3 8 58 1
145025 195977 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 23 Back Yard : Yard Tree Private 2     5 Width 4ft   6015256.87723 2100313.90806 37.7479190918917 -122.389990690329 (37.7479190918917, -122.389990690329)   3 8 58 1
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
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
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
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
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
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
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
148904 196044 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 18 Sidewalk: Property side : Yard Tree Private 2     9 Width 10ft   6017074.4672 2097014.32935 37.7389597551859 -122.383475817977 (37.7389597551859, -122.383475817977) 10 3 8 58 1
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
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
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
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
152832 140079 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 100 Saint Joseph's Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6000729.2298 2112451.4153 37.7804292797496 -122.441097181955 (37.7804292797496, -122.441097181955) 15 5 1 29490 41
152914 196031 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2 Lane St 10 Sidewalk: Property side : Yard Tree Private 2     7 Width 10ft   6017021.60504 2097043.83814 37.7390378586108 -122.383660646635 (37.7390378586108, -122.383660646635) 10 3 8 58 1
153530 196036 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 4 Sidewalk: Property side : Yard Tree Private 2     17 Width 10ft   6017046.41048 2096978.72928 37.738860453849 -122.383570348389 (37.738860453849, -122.383570348389) 10 3 8 58 1
154261 140083 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 108 Saint Joseph's Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     24 Width 0ft   6000722.7998 2112497.1022 37.7805543580623 -122.441122705034 (37.7805543580623, -122.441122705034) 15 5 1 29490 41
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
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
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
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
159019 196047 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 23 Sidewalk: Property side : Yard Tree Private 2     21 Width 10ft   6017083.09876 2097027.5652 37.7389965752218 -122.383446894874 (37.7389965752218, -122.383446894874) 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
164057 196049 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1 Lane St 26 Sidewalk: Property side : Yard Tree Private 2     35 Width 10ft   6017090.91062 2097040.61449 37.7390328376916 -122.383420792935 (37.7390328376916, -122.383420792935) 10 3 8 58 1
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
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
166467 125725 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     36 Width 4ft   6003533.81623 2118024.94741 37.7958921341649 -122.431792874238 (37.7958921341649, -122.431792874238) 13 9 1 57 17

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