trees

408 rows where Police Districts = 9 and qSpecies_id = 53 sorted by PlotSize

✎ View and edit SQL

This data as json, CSV (advanced)

Police Districts ✖

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)
117 108152 Undocumented 4 Ficus nitida :: Laurel Fig 53 2232 Webster St 4 Sidewalk: Curb side : Cutout Tree Private 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
11207 108105 Undocumented 4 Ficus nitida :: Laurel Fig 53 2390X Green St 7 Sidewalk: Property side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
12223 59958 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 515 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/1981 12:00:00 AM 17   Permit Number 19435 6005418.82 2111104.349 37.7769965639956 -122.424777815426 (37.7769965639956, -122.424777815426) 7 9 11 28852 10
14200 33719 Permitted Site 7 Ficus nitida :: Laurel Fig 53 27 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/04/1996 12:00:00 AM 13   Permit Number 37787 6004127.51235208 2108864.68166901 37.7707739677449 -122.429085120408 (37.7707739677449, -122.429085120408) 7 9 11 29492 10
15312 59957 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 539 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/16/1981 12:00:00 AM 12   Permit Number 19434 6005396.005 2111241.6 37.7773721331465 -122.424866506623 (37.7773721331465, -122.424866506623) 7 9 11 28852 10
15375 57511 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 636 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2   09/30/1976 12:00:00 AM 17   Permit Number 16364 6005408.351 2111510.821 37.7781120456222 -122.424842955768 (37.7781120456222, -122.424842955768) 7 9 11 28852 10
16922 59787 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1755 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/03/1981 12:00:00 AM     Permit Number 19237 6004552.42886001 2119092.68520918 37.7988815571833 -122.428344419585 (37.7988815571833, -122.428344419585) 13 9 1 57 17
17302 59963 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 523 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/19/1981 12:00:00 AM 15   Permit Number 19442 6005413.5665 2111133.9591 37.777077569392 -122.424798095948 (37.777077569392, -122.424798095948) 7 9 11 28852 10
26376 107654 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 600 Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2014 12:00:00 AM 3   Permit Number 772916 6005452.33302 2111401.13742 37.7778133653937 -122.424683001313 (37.7778133653937, -122.424683001313) 7 9 11 28852 10
29776 44063 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2700 Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2000 12:00:00 AM     Permit Number 43588 6001640.58397077 2117683.20689336 37.7948463022786 -122.438319307967 (37.7948463022786, -122.438319307967) 13 9 1 57 27
35407 94294 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
39669 95554 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1333@ Larkin Bush St 4 Sidewalk: Curb side : Cutout Tree Private 2           6007121 2115358 37.7887720478953 -122.419191239667 (37.7887720478953, -122.419191239667) 13 9 10 28858 21
48110 108103 Undocumented 4 Ficus nitida :: Laurel Fig 53 2390X Green St 5 Sidewalk: Property side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
49412 94931 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1771 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2           6004522 2118744 37.7979224352085 -122.428424847305 (37.7979224352085, -122.428424847305) 13 9 1 57 17
56427 44064 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2700 Pierce St 3 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2000 12:00:00 AM     Permit Number 43588 6001640.58397077 2117683.20689336 37.7948463022786 -122.438319307967 (37.7948463022786, -122.438319307967) 13 9 1 57 27
66213 50374 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2727 Pierce St 4 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47038 6001577.22511674 2117761.13132823 37.7950566585474 -122.43854412401 (37.7950566585474, -122.43854412401) 13 9 1 57 27
66280 94296 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
70447 44061 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2700 Pierce St 4 Sidewalk: Curb side : Cutout Tree Private 2   10/19/2000 12:00:00 AM     Permit Number 43588 6001640.58397077 2117683.20689336 37.7948463022786 -122.438319307967 (37.7948463022786, -122.438319307967) 13 9 1 57 27
75083 46223 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1888 Lombard St 2 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2002 12:00:00 AM     Permit Number 44530 6003335.27744655 2119677.01043482 37.8004170150887 -122.432597920925 (37.8004170150887, -122.432597920925) 13 9 1 57 17
77904 56931 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1909 Vallejo St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/1974 12:00:00 AM 17   Permit Number 14175 6004317.92538 2118019.69798 37.795922137343 -122.429079333669 (37.795922137343, -122.429079333669) 13 9 1 28858 27
79471 59271 Permitted Site 7 Ficus nitida :: Laurel Fig 53 110 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/09/2017 12:00:00 AM 3   Permit Number 18607 6004280.88948873 2109181.36087728 37.7716521728269 -122.428577162778 (37.7716521728269, -122.428577162778) 7 9 11 28852 10
79513 47917 Permitted Site 7 Ficus nitida :: Laurel Fig 53 999 Revised) Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/21/2002 12:00:00 AM     Permit Number 45655 6006486.39229912 2113910.68802822 37.7847623267063 -122.421284078173 (37.7847623267063, -122.421284078173) 13 9 11 28858 41
86887 94302 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 5 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
98424 94303 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 6 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
98717 33718 Permitted Site 7 Ficus nitida :: Laurel Fig 53 25 Germania St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/04/1996 12:00:00 AM 13   Permit Number 37786 6004139.32588988 2108866.31797637 37.7707791293659 -122.429044373837 (37.7707791293659, -122.429044373837) 7 9 11 29492 10
105203 107284 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2260 JACKSON ST 2 Sidewalk: Curb side : Cutout Tree Private 2           6003354.3 2116979.4 37.7930111519645 -122.432339323402 (37.7930111519645, -122.432339323402) 13 9 1 29490 27
110239 94295 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 2 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
115288 107652 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 600 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2014 12:00:00 AM 3   Permit Number 772916 6005452.33302 2111401.13742 37.7778133653937 -122.424683001313 (37.7778133653937, -122.424683001313) 7 9 11 28852 10
116014 107653 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 600 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2   10/07/2014 12:00:00 AM 3   Permit Number 772916 6005452.33302 2111401.13742 37.7778133653937 -122.424683001313 (37.7778133653937, -122.424683001313) 7 9 11 28852 10
118707 94293 Significant Tree 6 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 1 Sidewalk: Property side : Cutout Tree Rec/Park 5           6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
121115 94298 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 3 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
127089 108101 Undocumented 4 Ficus nitida :: Laurel Fig 53 2390X Green St 3 Sidewalk: Property side : Cutout Tree Private 2           6001806.63782 2118043.59498 37.7958452773357 -122.437770563269 (37.7958452773357, -122.437770563269) 13 9 1 57 17
129156 116906 Permitted Site 7 Ficus nitida :: Laurel Fig 53 358 Hermann St 2 Sidewalk: Curb side : Cutout Tree Private 2     30     6003554.93862357 2108664.35445356 37.7701914899734 -122.431051362966 (37.7701914899734, -122.431051362966) 15 9 11 29492 10
130680 59674 Permitted Site 7 Ficus nitida :: Laurel Fig 53 358 Hermann St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/21/1981 12:00:00 AM 26   Permit Number 19100 6003554.93862357 2108664.35445356 37.7701914899734 -122.431051362966 (37.7701914899734, -122.431051362966) 15 9 11 29492 10
134290 94304 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1150X Fillmore St 6 Sidewalk: Curb side : Cutout Tree DPW 1 Rec/Park         6003451.3 2112195.3 37.7798807216656 -122.431661979156 (37.7798807216656, -122.431661979156) 15 9 11 29490 41
147353 52716 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1330on LARKIN Bush St 2 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2006 12:00:00 AM     Permit Number 48769 6007121.03491046 2115409.40396286 37.7889131924877 -122.419194766666 (37.7889131924877, -122.419194766666) 13 9 10 28858 21
160693 108107 Undocumented 4 Ficus nitida :: Laurel Fig 53 1990X Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2 Port         6004838 2115780 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027) 13 9 1 28858 27
162297 108098 Undocumented 4 Ficus nitida :: Laurel Fig 53 2800X Pierce St 2 Sidewalk: Curb side : Cutout Tree Private 2           5999639 2117762 37.7949485989127 -122.445250712888 (37.7949485989127, -122.445250712888) 13 9 1 57 17
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
169402 50375 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2727 Pierce St 5 Sidewalk: Curb side : Cutout Tree Private 2         Permit Number 47038 6001577.22511674 2117761.13132823 37.7950566585474 -122.43854412401 (37.7950566585474, -122.43854412401) 13 9 1 57 27
171446 257980 Significant Tree 6 Ficus nitida :: Laurel Fig 53 2864 Broadway 3 Front Yard : Yard Tree Private 2         Permit Number 782825 5999909.76407 2117098.92712 37.7931434275556 -122.444266160734 (37.7931434275556, -122.444266160734) 13 9 1 57 27
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
183181 108106 Undocumented 4 Ficus nitida :: Laurel Fig 53 1990X Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2 Port         6004838 2115780 37.7898019192352 -122.427120168027 (37.7898019192352, -122.427120168027) 13 9 1 28858 27
184329 173906 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2510 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1           6005854.79213 2118988.36383 37.7986687249765 -122.423830387644 (37.7986687249765, -122.423830387644) 13 9 1 28858 32
184672 113275 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2147 Union St 2 Sidewalk: Curb side : Cutout Tree Private 2           6002730.25600058 2118492.02135193 37.7971290147198 -122.43460675571 (37.7971290147198, -122.43460675571) 13 9 1 57 17
186717 107211 Undocumented 4 Ficus nitida :: Laurel Fig 53 2255 CLAY ST 1 Sidewalk: Curb side : Cutout Tree Private 2           6003966.3 2116269.9 37.7910977281266 -122.430171131086 (37.7910977281266, -122.430171131086) 13 9 1 29490 27
190125 52718 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1330on LARKIN Bush St 3 Sidewalk: Curb side : Cutout Tree Private 2   04/04/2006 12:00:00 AM     Permit Number 48769 6007121.03491046 2115409.40396286 37.7889131924877 -122.419194766666 (37.7889131924877, -122.419194766666) 13 9 10 28858 21
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
193965 108150 Undocumented 4 Ficus nitida :: Laurel Fig 53 2232 Webster St 2 Sidewalk: Curb side : Cutout Tree Private 2           6003295.44003 2116396.66877 37.7914077834913 -122.432501340527 (37.7914077834913, -122.432501340527) 13 9 1 29490 27
37162 18698 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 251X Richardson Ave 5 Median : Cutout Tree DPW 1     12 100   5999064.164064 2119841.396854 37.8006252370733 -122.447389461083 (37.8006252370733, -122.447389461083) 13 9 1 57 17
107261 18696 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 251X Richardson Ave 3 Median : Cutout Tree DPW 1     12 100   5999064.164064 2119841.396854 37.8006252370733 -122.447389461083 (37.8006252370733, -122.447389461083) 13 9 1 57 17
171543 18697 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 251X Richardson Ave 4 Median : Cutout Tree DPW 1     12 100   5999064.164064 2119841.396854 37.8006252370733 -122.447389461083 (37.8006252370733, -122.447389461083) 13 9 1 57 17
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
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
92133 62276 Permitted Site 7 Ficus nitida :: Laurel Fig 53 124 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/09/1985 12:00:00 AM 13 21x6 Permit Number 22414 6003841.87853288 2108837.79837285 37.7706839798213 -122.430071215032 (37.7706839798213, -122.430071215032) 7 9 11 29492 10
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
5822 16933 Permitted Site 7 Ficus nitida :: Laurel Fig 53 530 Oak St 1 Sidewalk: Property side : Cutout Tree Private 2     24 3X3   6004214.00427 2110149.16937 37.7743057532085 -122.428877532014 (37.7743057532085, -122.428877532014) 7 9 11 28852 10
14128 16935 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 542 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6004164.66828 2110140.85762 37.7742801386068 -122.429047601533 (37.7742801386068, -122.429047601533) 7 9 11 28852 10
22585 23704 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2119X Gough St 4 Sidewalk: Curb side : Cutout Tree Private 2     8 3X3   6005103.6033 2116867.23334 37.7928022043515 -122.426278644375 (37.7928022043515, -122.426278644375) 13 9 1 28858 27
22613 7891 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1187 Franklin St 8 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6005998.65959 2113925.10155 37.7847743933389 -122.422972499839 (37.7847743933389, -122.422972499839) 13 9 11 28858 41
24360 26948 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 7 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6002746.89171 2114446.33864 37.7860215531341 -122.434259812125 (37.7860215531341, -122.434259812125) 13 9 11 29490 27
26003 20242 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1801X Steiner St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002529.5506914 2114404.1561918 37.7858933925245 -122.435008734319 (37.7858933925245, -122.435008734319) 13 9 1 29490 27
28315 6990 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 855 Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6003337.33996 2110322.66362 37.7747324668328 -122.431922464006 (37.7747324668328, -122.431922464006) 15 9 11 29492 10
28468 23821 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1200X Webster St 13 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6003795.89428 2112830.35916 37.7816439623395 -122.430515201234 (37.7816439623395, -122.430515201234) 7 9 11 29490 41
31660 7182 Permitted Site 7 Ficus nitida :: Laurel Fig 53 857 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3X3   6003432.47617 2111314.05853 37.7774599847744 -122.43166416476 (37.7774599847744, -122.43166416476) 15 9 11 29492 10
32727 16390 Permitted Site 7 Ficus nitida :: Laurel Fig 53 246 Myrtle St 1 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6006205.61528 2114051.709 37.7851337020107 -122.422265498437 (37.7851337020107, -122.422265498437) 13 9 11 28858 41
32743 22671 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1140X Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     35 3X3   6003752.72615 2112639.82159 37.7811183481869 -122.430650941901 (37.7811183481869, -122.430650941901) 15 9 11 29490 41
33408 6246 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1280 Ellis St 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6004721.4422 2113335.3655 37.7830829720913 -122.427349228935 (37.7830829720913, -122.427349228935) 7 9 11 28858 41
35689 7151 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 708 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003574.54383 2110759.08622 37.775944219835 -122.431133084506 (37.775944219835, -122.431133084506) 7 9 11 29492 10
38327 17368 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2308X Gough St 5 Sidewalk: Curb side : Cutout Tree DPW 1     30 3X3   6005067.32521 2117488.78546 37.794506778582 -122.426448444628 (37.794506778582, -122.426448444628) 13 9 1 28858 27
38667 21584 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1499 Sutter St 6 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6005574.52113 2114792.70084 37.787132663766 -122.424501615425 (37.787132663766, -122.424501615425) 13 9 1 28858 41
39319 23703 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2119X Gough St 3 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6005103.6033 2116867.23334 37.7928022043515 -122.426278644375 (37.7928022043515, -122.426278644375) 13 9 1 28858 27
40655 16939 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 599X Oak St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6004143.7777346 2110082.9014722 37.774119822678 -122.429115732545 (37.774119822678, -122.429115732545) 7 9 11 28852 10
41634 13254 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2408 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/26/1993 12:00:00 AM 45 3X3   6000832.23006 2119380.36917 37.7994602521243 -122.441238147567 (37.7994602521243, -122.441238147567) 13 9 1 57 17
43323 23820 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1200X Webster St 12 Sidewalk: Curb side : Cutout Tree DPW 1     15 3X3   6003795.89428 2112830.35916 37.7816439623395 -122.430515201234 (37.7816439623395, -122.430515201234) 7 9 11 29490 41
45474 26944 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 3 Sidewalk: Curb side : Cutout Tree DPW 1     21 3X3   6002826.48876 2114460.91922 37.7860661051899 -122.433985470782 (37.7860661051899, -122.433985470782) 13 9 11 29490 27
45836 9661 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 112 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6006079.13931 2110176.88384 37.7744872417771 -122.422427647286 (37.7744872417771, -122.422427647286) 7 9 11 28852 10
46932 17830 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1961 Pine St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004561.39396 2115345.0767756 37.7885920838825 -122.428046192771 (37.7885920838825, -122.428046192771) 13 9 11 28858 27
48251 23814 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1200X Webster St 6 Sidewalk: Curb side : Cutout Tree DPW 1     15 3X3   6003795.89428 2112830.35916 37.7816439623395 -122.430515201234 (37.7816439623395, -122.430515201234) 7 9 11 29490 41
48721 9675 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 235 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1   12/19/1981 12:00:00 AM 12 3X3   6005972.11971 2110519.21136 37.7754211527567 -122.422822183014 (37.7754211527567, -122.422822183014) 7 9 11 28852 10
49601 16393 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 250X Myrtle St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6006231.99165 2114068.14091 37.7851803077551 -122.422175412097 (37.7851803077551, -122.422175412097) 13 9 11 28858 41
50755 7185 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 865 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003457.39592 2111275.80383 37.7773563593355 -122.431575227386 (37.7773563593355, -122.431575227386) 15 9 11 29492 10
50810 20244 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1801X Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6002529.5506914 2114404.1561918 37.7858933925245 -122.435008734319 (37.7858933925245, -122.435008734319) 13 9 1 29490 27
50875 7183 Permitted Site 7 Ficus nitida :: Laurel Fig 53 857 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6003432.47617 2111314.05853 37.7774599847744 -122.43166416476 (37.7774599847744, -122.43166416476) 15 9 11 29492 10
51362 2729 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2250 Bush St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6002744.1445 2114802.6476 37.7869997310528 -122.434294799469 (37.7869997310528, -122.434294799469) 13 9 11 29490 27
51471 20141 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1001 Steiner St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002903.1358 2111776.1473 37.7786987467479 -122.433528357436 (37.7786987467479, -122.433528357436) 15 9 11 29490 41
51714 7156 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 712 Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6003631.55189 2110917.37527 37.7763820727629 -122.430947178384 (37.7763820727629, -122.430947178384) 7 9 11 29492 10
51742 11446 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2191X Gough St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6005072.64937 2117089.85961 37.7934117301419 -122.426401604865 (37.7934117301419, -122.426401604865) 13 9 1 28858 27
53228 7198 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 949 Fillmore St 5 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
54208 9683 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 298 Gough St 3 Sidewalk: Curb side : Cutout Tree DPW 1   04/24/1982 12:00:00 AM 20 3X3   6006045.73768 2110624.99987 37.7757157759068 -122.422575039685 (37.7757157759068, -122.422575039685) 7 9 11 28852 10
55002 13200 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2130X Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1     90 3X3   6002179.06604 2119515.41872 37.7999076905723 -122.436587295662 (37.7999076905723, -122.436587295662) 13 9 1 57 17
55528 23492 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2510 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6005839.2618 2119053.89467 37.7988477792821 -122.423888789861 (37.7988477792821, -122.423888789861) 13 9 1 28858 32
57812 13193 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2095 Lombard St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002451.4681 2119463.3271 37.7997801365268 -122.435640954547 (37.7997801365268, -122.435640954547) 13 9 1 57 17
60447 20241 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1801X Steiner St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6002529.5506914 2114404.1561918 37.7858933925245 -122.435008734319 (37.7858933925245, -122.435008734319) 13 9 1 29490 27
61171 16895 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 371 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6005249.75731 2110166.87775 37.7744129459718 -122.425295929281 (37.7744129459718, -122.425295929281) 7 9 11 28852 10
62418 2714 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2185X Bush St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003185.15216 2114858.41892 37.7871778864418 -122.432772999031 (37.7871778864418, -122.432772999031) 13 9 11 29490 27
64713 7152 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 708 Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003574.54383 2110759.08622 37.775944219835 -122.431133084506 (37.775944219835, -122.431133084506) 7 9 11 29492 10
65216 23529 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2750 Van Ness Ave 18 Sidewalk: Curb side : Cutout Tree DPW 1     24 3X3   6005762.85494 2119704.71005 37.8006304387912 -122.42419949344 (37.8006304387912, -122.42419949344) 13 9 1 28858 32
65399 7150 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 701 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003528.61787 2110726.18593 37.7758512811844 -122.431289605258 (37.7758512811844, -122.431289605258) 15 9 11 29492 10
66032 21736 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1980 Sutter St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6003117.21702 2114500.64002 37.7861916631027 -122.432982468773 (37.7861916631027, -122.432982468773) 13 9 11 29490 27

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