trees

228 rows where qCaretaker_id = 2 and qSpecies_id = 59 sorted by TreeID

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

  • Private · 228 ✖
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)
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
47415 125722 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     43 Width 4ft   6003540.89789 2117978.17849 37.7957641201722 -122.431765029446 (37.7957641201722, -122.431765029446) 13 9 1 57 17
37565 125723 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     38 Width 4ft   6003539.04242 2117994.60754 37.7958091249389 -122.431772623315 (37.7958091249389, -122.431772623315) 13 9 1 57 17
49152 125724 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 2800 Buchanan St 3 Sidewalk: Curb side : Cutout Tree Private 2     35 Width 4ft   6003536.06003 2118009.60299 37.7958501295278 -122.431784014136 (37.7958501295278, -122.431784014136) 13 9 1 57 17
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
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
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
83859 139060 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 1455 Lyon St 4 Sidewalk: Curb side : Cutout Tree Private 2     39 Width 0ft   5999670.4186 2113895.7324 37.7843346353185 -122.444863945857 (37.7843346353185, -122.444863945857) 15 6 11 29490 31
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
14173 140080 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 102 Saint Joseph's Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6000726.8608 2112462.5832 37.7804598090154 -122.441106178881 (37.7804598090154, -122.441106178881) 15 5 1 29490 41
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
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
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
42007 195956 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 2 Back Yard : Yard Tree Private 2     9     6015682.42479 2100340.57249 37.7480158985316 -122.388521013727 (37.7480158985316, -122.388521013727) 10 3 8 58 1
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
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
61534 195959 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 5 Back Yard : Yard Tree Private 2     10     6015616.60441 2100338.74984 37.7480072461368 -122.388748492749 (37.7480072461368, -122.388748492749) 10 3 8 58 1
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
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
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
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
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
63271 195965 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 11 Back Yard : Yard Tree Private 2     8     6015497.16873 2100330.63483 37.7479783437428 -122.389160933554 (37.7479783437428, -122.389160933554) 10 3 8 58 1
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
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
79032 195968 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 14 Back Yard : Yard Tree Private 2     7     6015437.03514 2100327.81381 37.7479672640843 -122.389368677829 (37.7479672640843, -122.389368677829)   3 8 58 1
64076 195969 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 15 Back Yard : Yard Tree Private 2     8     6015417.97335 2100326.09336 37.7479614832509 -122.389434473133 (37.7479614832509, -122.389434473133)   3 8 58 1
29793 195970 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 16 Back Yard : Yard Tree Private 2     8     6015399.1088 2100325.42161 37.7479585928282 -122.389499659601 (37.7479585928282, -122.389499659601)   3 8 58 1
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
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
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
41514 195974 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 20 Back Yard : Yard Tree Private 2     12 Width 4ft   6015315.44713 2100317.81293 37.7479330619596 -122.389788429193 (37.7479330619596, -122.389788429193)   3 8 58 1
81240 195975 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 21 Back Yard : Yard Tree Private 2     9 Width 4ft   6015294.9834 2100316.47199 37.747928245201 -122.389859098828 (37.747928245201, -122.389859098828)   3 8 58 1
185019 195976 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 22 Back Yard : Yard Tree Private 2     5 Width 4ft   6015275.57642 2100315.10939 37.7479234275315 -122.389926112714 (37.7479234275315, -122.389926112714)   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
53808 195978 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 200 Tulare St 24 Back Yard : Yard Tree Private 2     9 Width 4ft   6015236.23042 2100312.22008 37.7479133119586 -122.390061968785 (37.7479133119586, -122.390061968785)   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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
10408 195999 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 3 Sidewalk: Property side : Yard Tree Private 2     16     6016051.5903 2110711.60548 37.7765129824099 -122.387968033214 (37.7765129824099, -122.387968033214) 14 3 9 310 20
32582 196000 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 4 Sidewalk: Property side : Yard Tree Private 2     17     6016029.90141 2110710.35403 37.7765083446095 -122.38804297462 (37.7765083446095, -122.38804297462) 14 3 9 310 20
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
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
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
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
87935 196005 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 9 Sidewalk: Property side : Yard Tree Private 2     15     6015919.22066 2110703.31156 37.7764828749315 -122.38842536276 (37.7764828749315, -122.38842536276) 14 3 9 310 20
80958 196006 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 10 Sidewalk: Property side : Yard Tree Private 2     14     6015895.59891 2110702.13918 37.7764783468376 -122.388506996001 (37.7764783468376, -122.388506996001) 14 3 9 310 20
81978 196007 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 11 Sidewalk: Property side : Yard Tree Private 2     15     6015874.48096 2110701.94702 37.7764766489106 -122.388580036236 (37.7764766489106, -122.388580036236) 14 3 9 310 20
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
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
37957 196010 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 14 Sidewalk: Property side : Yard Tree Private 2     17     6015807.5178 2110696.90854 37.7764591031505 -122.38881133109 (37.7764591031505, -122.38881133109) 14 3 9 310 20
84576 196011 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 15 Sidewalk: Property side : Yard Tree Private 2     16     6015786.39152 2110696.30426 37.7764562729832 -122.388884371337 (37.7764562729832, -122.388884371337) 14 3 9 310 20
23490 196012 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 16 Sidewalk: Property side : Yard Tree Private 2     16     6015764.41678 2110694.68671 37.7764506135265 -122.388960275907 (37.7764506135265, -122.388960275907) 14 3 9 310 20
49343 196013 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 17 Sidewalk: Property side : Yard Tree Private 2     17     6015743.28218 2110693.67028 37.7764466511333 -122.389033316139 (37.7764466511333, -122.389033316139) 14 3 9 310 20
30255 196014 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 18 Sidewalk: Property side : Yard Tree Private 2     17     6015720.48392 2110692.27541 37.7764415573597 -122.389112085054 (37.7764415573597, -122.389112085054) 14 3 9 310 20
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
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
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
6092 196018 DPW Maintained 1 Populus nigra 'Italica' :: Lombardy Poplar 59 212 Terry A Francois Blvd 22 Sidewalk: Property side : Yard Tree Private 2     15     6015632.04702 2110689.93838 37.7764302375944 -122.389417852744 (37.7764302375944, -122.389417852744) 14 3 9 310 20
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
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

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