417 rows where Supervisor Districts = 11 and qSpecies_id = 53 sorted by rowid descending

View and edit SQL

Supervisor Districts

  • 11 · 417
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)
193656 16998 Permitted Site 7 Ficus nitida :: Laurel Fig 53 903 Oak St 3 Sidewalk: Curb side : Cutout Tree Private 2     10 3X3   6002629.22495 2109872.04506 37.7734550115897 -122.434339751705 (37.7734550115897, -122.434339751705) 15 5 11 29492 9
193625 255507 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1290X Golden Gate Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6003415.08005 2112113.96459 37.7796553418115 -122.431781470984 (37.7796553418115, -122.431781470984) 15 9 11 29490 41
193568 26953 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 12 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x6   6002643.91242 2114436.71459 37.7859892824562 -122.43461540376 (37.7859892824562, -122.43461540376) 13 9 11 29490 27
192852 16949 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 625 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6003989.24409 2110039.43116 37.7739917148646 -122.429647190447 (37.7739917148646, -122.429647190447) 7 9 11 29492 10
192777 48866 Permitted Site 7 Ficus nitida :: Laurel Fig 53 129 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/15/2002 12:00:00 AM     Permit Number 46075 6006370.62112219 2110394.65908683 37.7751016387897 -122.421434823029 (37.7751016387897, -122.421434823029) 7 9 11 28852 10
192243 94600 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1709 Waller St 2 Sidewalk: Curb side : Cutout Tree Private 2           5997540 2108126 37.7683706375079 -122.451818041345 (37.7683706375079, -122.451818041345) 15 5 11 29492 9
191412 2431 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 490X Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X3   6004657.78302 2110211.29448 37.7745014417711 -122.427346845616 (37.7745014417711, -122.427346845616) 7 9 11 28852 10
191157 16897 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 385 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6005198.99692 2110159.80887 37.7743906686767 -122.425471016021 (37.7743906686767, -122.425471016021) 7 9 11 28852 10
191064 21654 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1698 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004474.7477956 2114689.3781886 37.7867867977452 -122.428299224496 (37.7867867977452, -122.428299224496) 13 9 11 28858 27
190628 7233 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1045 Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003367.24511 2111893.72513 37.7790479074603 -122.431931222001 (37.7790479074603, -122.431931222001) 15 9 11 29490 41
190566 21751 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1787X Steiner St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6002537.7996519 2114344.6571005 37.7857304915222 -122.434975938446 (37.7857304915222, -122.434975938446) 13 9 11 29490 13
189695 21726 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1942 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6003284.347 2114523.85502 37.7862648839776 -122.432405902047 (37.7862648839776, -122.432405902047) 13 9 11 29490 27
188563 10618 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 350 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006025.52151 2110969.11138 37.7766594822933 -122.422669431679 (37.7766594822933, -122.422669431679) 7 9 11 28852 10
188552 17045 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1200X Oak St 9 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6001235.1914802 2109729.1714048 37.7729834911046 -122.439151661694 (37.7729834911046, -122.439151661694) 15 5 11 29492 10
188273 2450 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1805X Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4x4   6003959.520066 2114567.2690482 37.7864223498862 -122.430073076908 (37.7864223498862, -122.430073076908) 13 9 11 29490 13
188066 9689 Permitted Site 7 Ficus nitida :: Laurel Fig 53 332 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6006025.5202 2110969.11106 37.7766594813407 -122.422669436188 (37.7766594813407, -122.422669436188) 7 9 11 28852 10
187860 22712 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 12 Sidewalk: Curb side : Cutout Tree Police Dept 10     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894) 15 9 11 29490 41
187443 22718 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 6 Sidewalk: Curb side : Cutout Tree Police Dept 10     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894) 15 9 11 29490 41
186128 21645 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1657 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2   03/23/1990 12:00:00 AM 18 4X4   6004676.7022509 2114666.9735246 37.7867367053745 -122.427598912468 (37.7867367053745, -122.427598912468) 13 9 11 28858 13
184850 2719 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2185X Bush St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003092.7695 2114646.14799 37.786589804405 -122.433077450713 (37.786589804405, -122.433077450713) 13 9 11 29490 27
184217 113003 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
183127 7232 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1045 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003365.392 2111902.08022 37.7790707434033 -122.431938229416 (37.7790707434033, -122.431938229416) 15 9 11 29490 41
183075 17003 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 985 Oak St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 5x9   6002297.8184 2109825.1269 37.7733073694664 -122.435482776108 (37.7733073694664, -122.435482776108) 15 5 11 29492 9
182974 16988 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 879 Oak St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6002804.94816 2109899.79468 37.773541177823 -122.433733884114 (37.773541177823, -122.433733884114) 15 5 11 29492 9
182795 26424 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 555 Fulton St 12 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6005277.15037 2111634.16402 37.7784433040001 -122.425305605903 (37.7784433040001, -122.425305605903) 7 9 11 28852 10
182329 21698 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1890 Sutter St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6003576.7245218 2114564.5327129 37.7863931493079 -122.431397256992 (37.7863931493079, -122.431397256992) 13 9 11 29490 27
181893 7246 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1700 Fillmore St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x5   6003087.664 2114207.65389 37.7853855210138 -122.433063773672 (37.7853855210138, -122.433063773672) 13 9 11 29490 13
181818 13305 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1377X Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6000417.28547 2109565.1947 37.7724866778901 -122.441969118639 (37.7724866778901, -122.441969118639) 15 5 11 29492 9
181230 7271 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1761 Fillmore St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003011.13827 2114398.62455 37.7859055370085 -122.433342180608 (37.7859055370085, -122.433342180608) 13 9 11 29490 13
180211 18159 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2     40 3x3   6005423.15 2114537.67279 37.7864238707484 -122.425007174907 (37.7864238707484, -122.425007174907) 13 9 11 28858 13
180149 112971 Undocumented 4 Ficus nitida :: Laurel Fig 53 601x COLE ST 1 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   5997795 2108483 37.7693654697431 -122.450961770246 (37.7693654697431, -122.450961770246) 15 5 11 29492 9
178705 59665 Permitted Site 7 Ficus nitida :: Laurel Fig 53 993 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/30/1981 12:00:00 AM 12 2x2 Permit Number 19087 6002914.43276984 2111641.44659541 37.7783295332017 -122.433479648258 (37.7783295332017, -122.433479648258) 15 9 11 29492 41
177966 106938 Undocumented 4 Ficus nitida :: Laurel Fig 53 1607 WALLER ST 3 Sidewalk: Curb side : Cutout Tree Private 2     11     5997889 2108175 37.7685251613651 -122.450614421545 (37.7685251613651, -122.450614421545) 15 5 11 29492 9
177601 17085 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1585 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5999415.39608 2109426.2103 37.7720479186519 -122.445424745443 (37.7720479186519, -122.445424745443) 15 5 11 29492 9
177482 255340 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1881 Sutter St 6 Sidewalk: Curb side : Cutout Tree DPW 1           6003626.50122 2114526.01983 37.7862902235864 -122.431222292272 (37.7862902235864, -122.431222292272) 13 9 11 29490 13
176974 113008 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 9 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
176749 6380 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 310 Elm St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6006136.3622128 2112667.0618885 37.7813278942368 -122.422406674363 (37.7813278942368, -122.422406674363) 7 9 11 28852 41
176167 16388 Permitted Site 7 Ficus nitida :: Laurel Fig 53 238 Myrtle St 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6006262.13214 2114058.51032 37.7851555645201 -122.422070450769 (37.7851555645201, -122.422070450769) 13 9 11 28858 41
175601 7197 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 949 Fillmore St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003395.68163 2111577.87165 37.7781822644093 -122.431810290332 (37.7781822644093, -122.431810290332) 15 9 11 29492 41
174828 21667 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1773 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6004123.7222039 2114590.0968475 37.7864943276059 -122.429506607504 (37.7864943276059, -122.429506607504) 13 9 11 29490 13
174162 16730 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 19X Hollis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6003888.91549 2113509.70556 37.7835145469728 -122.430241873385 (37.7835145469728, -122.430241873385) 7 9 11 29490 41
174129 16872 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 259 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6005773.57352 2110239.8238 37.7746428175577 -122.423489134945 (37.7746428175577, -122.423489134945) 7 9 11 28852 10
173558 113006 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 7 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
173262 16934 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 534 Oak St 1 Sidewalk: Property side : Cutout Tree DPW 1     24 3X3   6004202.21217 2110156.57626 37.7743254232669 -122.428918851232 (37.7743254232669, -122.428918851232) 7 9 11 28852 10
173238 113007 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 8 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
172889 7892 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1187 Franklin St 9 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6006000.38049 2113895.86172 37.7846942050769 -122.422964467171 (37.7846942050769, -122.422964467171) 13 9 11 28858 41
172861 117048 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2183 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     0 3x3   6002170 2114323 37.7856501363162 -122.436246868292 (37.7856501363162, -122.436246868292) 13 6 11 29490 13
172277 10647 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 913 Hayes St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/02/1991 12:00:00 AM 12 3X3   6003471.55966 2110689.4075 37.775747062973 -122.431484357932 (37.775747062973, -122.431484357932) 15 9 11 29492 10
172169 117345 Undocumented 4 Ficus nitida :: Laurel Fig 53 395 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006014 2111158 37.7771774746178 -122.422722714586 (37.7771774746178, -122.422722714586) 7 9 11 28852 10
171101 17693 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1095X Pierce St 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6002343.2153394 2112268.6379219 37.7800192180629 -122.435500577793 (37.7800192180629, -122.435500577793) 15 5 11 29490 41
170574 114952 Undocumented 4 Ficus nitida :: Laurel Fig 53 601X OCTAVIA ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005348 2111368 37.7777164851071 -122.42504156742 (37.7777164851071, -122.42504156742) 7 9 11 28852 10
170119 103480 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1247 06th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 5x5 Permit Number 31998 5994182.5 2107061.8 37.765255754741 -122.463353999562 (37.765255754741, -122.463353999562) 11 5 11 56 12
169890 21652 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1697 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6004490.7268551 2114641.118768 37.7866551936091 -122.428240500008 (37.7866551936091, -122.428240500008) 13 9 11 28858 13
169006 17011 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1001 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6002208.6674 2109818.85859 37.7732850945599 -122.43579071263 (37.7732850945599, -122.43579071263) 15 5 11 29492 9
168743 7855 Permitted Site 7 Ficus nitida :: Laurel Fig 53 915 Franklin St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6006074.49976 2113274.48833 37.7829922485484 -122.422663866925 (37.7829922485484, -122.422663866925) 7 9 11 28858 41
168672 9974 Permitted Site 7 Ficus nitida :: Laurel Fig 53 812X Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6003525.87553 2111110.58272 37.7769065842705 -122.431326537326 (37.7769065842705, -122.431326537326) 7 9 11 29492 10
168453 17019 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1053 Oak St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6001967.47701 2109780.334 37.7731656122234 -122.436622263598 (37.7731656122234, -122.436622263598) 15 5 11 29492 9
166398 9620 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1165X Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/16/1990 12:00:00 AM 50 3X3   6002862.99505 2112096.1743 37.779575183286 -122.433690098242 (37.779575183286, -122.433690098242) 15 9 11 29490 41
166324 8202 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1323 Fulton St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6001450.33053 2111015.64115 37.7765280537514 -122.438499661404 (37.7765280537514, -122.438499661404) 15 5 11 29492 10
165652 21672 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1781 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6004087.4531427 2114585.0546301 37.7864784293602 -122.429631729681 (37.7864784293602, -122.429631729681) 13 9 11 29490 13
165112 116511 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1500x Waller St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5998488 2108327 37.7689767823615 -122.448553488995 (37.7689767823615, -122.448553488995) 15 5 11 29492 9
164782 26423 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 555 Fulton St 11 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6005252.46633 2111627.39845 37.7784233328254 -122.425390515771 (37.7784233328254, -122.425390515771) 7 9 11 28852 10
164124 57410 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 109 Wilmot St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/08/1976 12:00:00 AM 15   Permit Number 770100 6002753.5601 2114939.9175 37.7873771736852 -122.434272041026 (37.7873771736852, -122.434272041026) 13 9 11 29490 27
163968 16919 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 500 Oak St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 13x6   6004493.27484 2110185.04209 37.7744200538695 -122.427914040239 (37.7744200538695, -122.427914040239) 7 9 11 28852 10
163768 9696 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 414 Gough St 4 Sidewalk: Curb side : Cutout Tree DPW 1     22 3X3   6005964.80411 2111186.62637 37.7772532999259 -122.422894934036 (37.7772532999259, -122.422894934036) 7 9 11 28852 10
163074 110027 Undocumented 4 Ficus nitida :: Laurel Fig 53 1101X WEBSTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3X3   6003707 2112516 37.7807757743573 -122.430800292528 (37.7807757743573, -122.430800292528) 15 9 11 29490 41
162862 58508 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1390 Waller St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/1979 12:00:00 AM   3x3 Permit Number 17683 5999052.33988667 2108383.59508746 37.7691644298026 -122.446605553634 (37.7691644298026, -122.446605553634) 15 5 11 29492 9
162853 105343 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2500X Post St 1 Sidewalk: Curb side : Cutout Tree Private 2           5999969.06573 2113691.86409 37.7837919048286 -122.443816082596 (37.7837919048286, -122.443816082596) 15 6 11 29490 31
162574 113000 Undocumented 4 Ficus nitida :: Laurel Fig 53 700x STANYAN ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997124 2108268 37.768736698354 -122.453267191941 (37.768736698354, -122.453267191941) 15 5 11 29492 9
162520 10628 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 805 Hayes St 2 Sidewalk: Curb side : Cutout Tree DPW 1   08/02/1990 12:00:00 AM 6 3X4   6003942.23141 2110755.32974 37.775954734286 -122.429860889744 (37.775954734286, -122.429860889744) 7 9 11 29492 10
161897 253634 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 830 Oak St 1 Sidewalk: Property side : Cutout tree DPW 1           6003018.63904 2109969.70237 37.7737452502421 -122.432999691851 (37.7737452502421, -122.432999691851) 15 5 11 29492 10
161493 6285 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1480 Ellis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4x4   6003867.05631 2113210.81806 37.7826926384963 -122.43029616652 (37.7826926384963, -122.43029616652) 7 9 11 29490 41
160258 6989 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 848 Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 15x3.5   6003368.38608 2110385.91832 37.7749079085756 -122.431819586637 (37.7749079085756, -122.431819586637) 15 9 11 29492 10
159266 7227 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1025 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6003385.45092 2111827.8386 37.7788680315263 -122.431863535021 (37.7788680315263, -122.431863535021) 15 9 11 29490 41
158763 111774 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 215 CLAYTON ST 2 Sidewalk: Curb side : Cutout Tree Private 2     11 3x3   5998260 2109886 37.7732443583423 -122.449454468346 (37.7732443583423, -122.449454468346) 15 5 11 29492 16
158220 9662 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 112 Gough St 2 Sidewalk: Curb side : Cutout Tree DPW 1     22 3X3   6006086.53311 2110106.07673 37.7742932396102 -122.422397038566 (37.7742932396102, -122.422397038566) 7 9 11 28852 10
156870 21690 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1881 Sutter St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6003627.3299403 2114521.0871369 37.7862767266181 -122.431219072895 (37.7862767266181, -122.431219072895) 13 9 11 29490 13
156516 13310 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 300X Lyon St 3 Median : Cutout Tree DPW 1     6 100   6000275.5456666 2109923.7813264 37.7734631881999 -122.442485158742 (37.7734631881999, -122.442485158742) 15 5 11 29492 16
156343 113279 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2 Hugo St 2 Sidewalk: Curb side : Cutout Tree Private 2       5x5   5995790.34429445 2107089.36315796 37.7654239364323 -122.457794878244 (37.7654239364323, -122.457794878244) 15 5 11 56 12
156320 6133 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 900X ELLIS ST 3 Sidewalk: Curb side : Cutout Tree DPW 1     30 4x4   6006542 2113585 37.7838712020833 -122.421068560353 (37.7838712020833, -122.421068560353) 7 9 11 28858 41
156308 7284 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1840 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   6003030.41064 2114610.94925 37.7864896201648 -122.433290680867 (37.7864896201648, -122.433290680867) 13 9 11 29490 27
156157 59335 Permitted Site 7 Ficus nitida :: Laurel Fig 53 201 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1980 12:00:00 AM   4x4 Permit Number 18682 6003287.79827449 2108952.35112135 37.7709671172915 -122.431995967048 (37.7709671172915, -122.431995967048) 15 9 11 29492 9
155915 6134 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 900X Ellis St 6 Sidewalk: Curb side : Cutout Tree DPW 1     30 4x4   6006541.37151 2113590.32225 37.7838857802496 -122.421071112727 (37.7838857802496, -122.421071112727) 7 9 11 28858 41
155645 110676 Undocumented 4 Ficus nitida :: Laurel Fig 53 1898 SCOTT ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6001594 2114879 37.7871440264162 -122.438279504546 (37.7871440264162, -122.438279504546) 13 6 11 29490 27
155542 54199 Permitted Site 7 Ficus nitida :: Laurel Fig 53 44 Hugo St 1 Sidewalk: Curb side : Cutout Tree Private 2   07/10/1972 12:00:00 AM   4x4 Permit Number 9937 5995656.55399656 2107084.69972772 37.7654034448102 -122.458257287589 (37.7654034448102, -122.458257287589) 15 5 11 56 12
155245 7236 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1065 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003355.08756 2111967.13899 37.7792487944095 -122.431978523544 (37.7792487944095, -122.431978523544) 15 9 11 29490 41
155152 26943 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 2 Sidewalk: Curb side : Cutout Tree DPW 1     20 5x6   6002846.96094 2114462.84733 37.7860725610737 -122.43391478048 (37.7860725610737, -122.43391478048) 13 9 11 29490 27
154378 26949 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 8 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6002710.37506 2114446.07693 37.7860187618492 -122.434386130989 (37.7860187618492, -122.434386130989) 13 9 11 29490 27
153860 94059 Undocumented 4 Ficus nitida :: Laurel Fig 53 1401X 08th Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5993648 2105942 37.7621502689837 -122.465121353228 (37.7621502689837, -122.465121353228) 1 8 11 56 12
153353 7273 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1801 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6002991.82699 2114526.90059 37.7862566549301 -122.433418162207 (37.7862566549301, -122.433418162207) 13 9 11 29490 27
152847 120532 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1390 Waller St 5 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5999052.33988667 2108383.59508746 37.7691644298026 -122.446605553634 (37.7691644298026, -122.446605553634) 15 5 11 29492 9
151746 10712 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 17X Hollis St 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6003917.66999 2113282.5787 37.7828925420276 -122.430126185708 (37.7828925420276, -122.430126185708) 7 9 11 29490 41
151645 116113 Undocumented 4 Ficus nitida :: Laurel Fig 53 201x SCOTT ST 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002265 2109203 37.7715972993524 -122.435551784305 (37.7715972993524, -122.435551784305) 15 5 11 29492 9
151636 20239 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1757X Steiner St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4x4   6002551.4219946 2114246.4002369 37.7854614766008 -122.434921779618 (37.7854614766008, -122.434921779618) 13 9 11 29490 13
151430 115906 Undocumented 4 Ficus nitida :: Laurel Fig 53 500x WALLER ST 3 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2016 12:00:00 AM 3 4x4   6003255 2109006 37.7711125644946 -122.432113248928 (37.7711125644946, -122.432113248928) 15 5 11 29492 9
150893 17691 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1095X Pierce St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6002343.2153394 2112268.6379219 37.7800192180629 -122.435500577793 (37.7800192180629, -122.435500577793) 15 5 11 29490 41
149790 22717 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 7 Sidewalk: Curb side : Cutout Tree Police Dept 10     18 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894) 15 9 11 29490 41
148808 102824 Undocumented 4 Ficus nitida :: Laurel Fig 53 2001X Baker St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   5997438 2109144 37.7711599615563 -122.452244312179 (37.7711599615563, -122.452244312179) 15 5 11 29492 9
148675 7262 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1727 Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6003024.60166 2114236.6744 37.7854616266825 -122.433284024643 (37.7854616266825, -122.433284024643) 13 9 11 29490 13
148453 52589 Permitted Site 7 Ficus nitida :: Laurel Fig 53 675 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/27/2006 12:00:00 AM     Permit Number 774039 5997878.20498734 2108284.16023065 37.7688242695831 -122.450659631577 (37.7688242695831, -122.450659631577) 15 5 11 29492 9

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