408 rows where Police Districts = 9 and qSpecies_id = 53

View and edit SQL

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
280 8072 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 661 Octavia St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6005345.6576 2111619.4154 37.7784066780298 -122.425067563729 (37.7784066780298, -122.425067563729) 7 9 11 28852 10
349 253694 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 536 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005450 2111168 37.7771730951376 -122.424674483112 (37.7771730951376, -122.424674483112) 7 9 11 28852 10
1142 260393 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 550 Octavia St 3 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005467 2111269 37.7774513766157 -122.424622861078 (37.7774513766157, -122.424622861078) 7 9 11 28852 10
2280 116028 Undocumented 4 Ficus nitida :: Laurel Fig 53 1500 PACIFIC AVE 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006937 2117734 37.7952855901943 -122.419996533467 (37.7952855901943, -122.419996533467) 13 9 10 28858 32
2653 100053 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
2723 140583 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 949 FILLMORE ST 9 Sidewalk: Curb side : Cutout Tree Private 2     21 Width 0ft   6003424.6737 2111485.9504 37.7779315149131 -122.431703431668 (37.7779315149131, -122.431703431668) 15 9 11 29492 41
2956 139431 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 539 OCTAVIA ST 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6005398.6042 2111220.8061 37.7773151849796 -122.424856035409 (37.7773151849796, -122.424856035409) 7 9 11 28852 10
4658 46466 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3310X Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/25/2002 12:00:00 AM 12 3x3 Permit Number 44668 6002328.64862435 2119517.88465055 37.7999229605029 -122.436069860968 (37.7999229605029, -122.436069860968) 13 9 1 57 17
5715 140049 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 651 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6005353.1353 2111583.6293 37.778308840554 -122.42503914867 (37.778308840554, -122.42503914867) 7 9 11 28852 10
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
6753 140065 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 612 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   6005425.1416 2111379.12 37.7777513751906 -122.424775499228 (37.7777513751906, -122.424775499228) 7 9 11 28852 10
6921 95036 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 7 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
7085 260395 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 550 Octavia St 5 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005467 2111269 37.7774513766157 -122.424622861078 (37.7774513766157, -122.424622861078) 7 9 11 28852 10
7742 21626 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1610 Sutter St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6004833.69671 2114745.44523 37.7869610478907 -122.427061339905 (37.7869610478907, -122.427061339905) 13 9 11 28858 27
9194 260391 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 550 Octavia St 1 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005467 2111269 37.7774513766157 -122.424622861078 (37.7774513766157, -122.424622861078) 7 9 11 28852 10
10459 16731 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 19X Hollis St 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 4X4   6003892.01293 2113485.99196 37.7834496108007 -122.4302294651 (37.7834496108007, -122.4302294651) 7 9 11 29490 41
10644 260392 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 550 Octavia St 2 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005467 2111269 37.7774513766157 -122.424622861078 (37.7774513766157, -122.424622861078) 7 9 11 28852 10
11093 95037 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3224 Pierce St 8 Sidewalk: Property side : Cutout Tree Dept of Real Estate 7     10 3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
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
11231 57646 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 666 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2   12/16/1981 12:00:00 AM 16 7x7 Permit Number 19439 6005402.5793 2111576.4092 37.7782918087921 -122.424867589608 (37.7782918087921, -122.424867589608) 7 9 11 28852 10
11809 7237 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1065 Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003359.4574 2111944.18191 37.7791860077197 -122.431961766737 (37.7791860077197, -122.431961766737) 15 9 11 29490 41
11986 95043 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 4 Sidewalk: Property side : Cutout Tree DPW for City Agency 14     9 3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 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
12493 140066 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 614 Octavia St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 0ft   6005423.0428 2111393.287 37.7777901557735 -122.424783767818 (37.7777901557735, -122.424783767818) 7 9 11 28852 10
13855 260394 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 550 Octavia St 4 Sidewalk: Curb side : Cutout Tree DPW 1       3x3   6005467 2111269 37.7774513766157 -122.424622861078 (37.7774513766157, -122.424622861078) 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
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
14444 7238 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1085 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     2 4X4   6003353.84267 2112023.38614 37.7794031644909 -122.431986847688 (37.7794031644909, -122.431986847688) 15 9 11 29490 41
14920 255508 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1290X Golden Gate Ave 3 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
15062 102786 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3345 Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 4.5x6 Permit Number 772480 6003174.4 2119873.2 37.8009465759098 -122.433168646536 (37.8009465759098, -122.433168646536) 13 9 1 57 17
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
15896 140067 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 616 Octavia St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6005420.4192 2111411.6517 37.7778404325738 -122.424794150591 (37.7778404325738, -122.424794150591) 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
18271 139433 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 539 OCTAVIA ST 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 0ft   6005406.0306 2111183.3028 37.7772126295238 -122.424827676313 (37.7772126295238, -122.424827676313) 7 9 11 28852 10
18607 139432 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 539 OCTAVIA ST 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 0ft   6005403.0601 2111196.299 37.77724814614 -122.424838877048 (37.77724814614, -122.424838877048) 7 9 11 28852 10
20388 6375 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 309X Elm St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6006152.1987649 2112618.7866796 37.7811962356475 -122.422348456516 (37.7811962356475, -122.422348456516) 7 9 11 28852 41
20638 21644 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1657 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6004676.7022509 2114666.9735246 37.7867367053745 -122.427598912468 (37.7867367053745, -122.427598912468) 13 9 11 28858 13
20994 100049 Permitted Site 7 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 768990 6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
21029 102504 Permitted Site 7 Ficus nitida :: Laurel Fig 53 290X Hermann St 2 Sidewalk: Curb side : Cutout Tree Private 2       6x6   6003881.1 2108703.5 37.7703174504719 -122.429925966233 (37.7703174504719, -122.429925966233) 7 9 11 29492 10
21498 98979 Undocumented 4 Ficus nitida :: Laurel Fig 53 38 MILEY ST 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3 Permit Number 778225 5999656 2118689 37.7974948649915 -122.4452585722 (37.7974948649915, -122.4452585722) 13 9 1 57 17
21570 7202 Permitted Site 7 Ficus nitida :: Laurel Fig 53 926 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6003476.58431 2111463.23602 37.7778720892035 -122.431522232661 (37.7778720892035, -122.431522232661) 15 9 11 29492 41
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
24683 16945 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 602 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6004026.09211 2110141.24132 37.7742733469863 -122.429526989132 (37.7742733469863, -122.429526989132) 7 9 11 29492 10
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
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
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
28409 23540 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2750 Van Ness Ave 15 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6005743.06666 2119831.60651 37.8009777467475 -122.424276999326 (37.8009777467475, -122.424276999326) 13 9 1 28858 32
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
29320 21640 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1645 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6004732.1765743 2114674.6857014 37.7867610187213 -122.427407534005 (37.7867610187213, -122.427407534005) 13 9 11 28858 13
29407 16958 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 705 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x5   6003566.56897 2110004.67754 37.7738723476787 -122.431106813505 (37.7738723476787, -122.431106813505) 15 9 11 29492 10
29416 7261 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1727 Fillmore St 2 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
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
30119 23811 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1200X Webster St 3 Sidewalk: Curb side : Cutout Tree DPW 1     20 3x3   6003795.89428 2112830.35916 37.7816439623395 -122.430515201234 (37.7816439623395, -122.430515201234) 7 9 11 29490 41
30808 21696 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1890 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1   04/09/1990 12:00:00 AM 16 4x4   6003576.7245218 2114564.5327129 37.7863931493079 -122.431397256992 (37.7863931493079, -122.431397256992) 13 9 11 29490 27
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
32254 26946 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 5 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x6   6002793.58315 2114456.84816 37.7860530596313 -122.434099024105 (37.7860530596313, -122.434099024105) 13 9 11 29490 27
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
34036 9687 Permitted Site 7 Ficus nitida :: Laurel Fig 53 330 Gough St 1 Sidewalk: Curb side : Cutout Tree Private 2   01/10/2001 12:00:00 AM 16 3x3   6006025.52151 2110969.11138 37.7766594822933 -122.422669431679 (37.7766594822933, -122.422669431679) 7 9 11 28852 10
34775 14651 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 655X McAllister St 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3x3   6006015.9359491 2112078.013352 37.7797037167615 -122.422781416289 (37.7797037167615, -122.422781416289) 7 9 11 28852 10
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
35663 26954 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 13 Sidewalk: Curb side : Cutout Tree DPW 1     18 5x6   6002832.1331203 2114461.0177044 37.7860666959211 -122.433965949874 (37.7860666959211, -122.433965949874) 13 9 11 29490 27
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
36681 22720 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 4 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
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
37545 21656 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1700 Sutter St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6004322.06269 2114670.60111 37.7867265999511 -122.428826139996 (37.7867265999511, -122.428826139996) 13 9 11 29490 27
37838 102503 Permitted Site 7 Ficus nitida :: Laurel Fig 53 290X Hermann St 1 Sidewalk: Curb side : Cutout Tree Private 2       6x9   6003881.1 2108703.5 37.7703174504719 -122.429925966233 (37.7703174504719, -122.429925966233) 7 9 11 29492 10
38287 22723 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 1 Sidewalk: Curb side : Cutout Tree Police Dept 10     3 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894) 15 9 11 29490 41
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
39370 107630 Undocumented 4 Ficus nitida :: Laurel Fig 53 2164 CHESTNUT ST 2 Sidewalk: Curb side : Cutout Tree Private 2     18 3x3   6001495 2119755 37.8005266206576 -122.438971595662 (37.8005266206576, -122.438971595662) 13 9 1 57 17
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
39760 21735 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1980 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x4   6003153.81629 2114507.53827 37.7862126798287 -122.432856338004 (37.7862126798287, -122.432856338004) 13 9 11 29490 27
40439 2452 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1805X Sutter St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6003959.520066 2114567.2690482 37.7864223498862 -122.430073076908 (37.7864223498862, -122.430073076908) 13 9 11 29490 13
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
41963 21634 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1629 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6004806.293908 2114684.9896753 37.786793502462 -122.427151839633 (37.786793502462, -122.427151839633) 13 9 11 28858 13
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
43653 95034 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 3 Sidewalk: Curb side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
43740 9577 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1290X Golden Gate Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 5x5   6003415.08005 2112113.96459 37.7796553418115 -122.431781470984 (37.7796553418115, -122.431781470984) 15 9 11 29490 41
43983 10710 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 17X Hollis St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003901.15311 2113362.61867 37.7831113762968 -122.430189039187 (37.7831113762968, -122.430189039187) 7 9 11 29490 41
44254 20167 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1175 Steiner St 5 Sidewalk: Curb side : Cutout Tree Private 2     50 4X4   6002828.6579039 2112263.6806979 37.7800331654734 -122.433820860908 (37.7800331654734, -122.433820860908) 15 9 11 29490 41
44436 22716 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 8 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
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
45498 22719 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 5 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
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
46032 121039 Undocumented 4 Ficus nitida :: Laurel Fig 53 2101 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006363 2118098 37.7962526868942 -122.422008539697 (37.7962526868942, -122.422008539697) 13 9 10 28858 32
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
47028 110967 Undocumented 4 Ficus nitida :: Laurel Fig 53 2439 WASHINGTON ST   Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003043 2116458 37.7915618650441 -122.433379161821 (37.7915618650441, -122.433379161821) 13 9 1 29490 27
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
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
48975 21630 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1615 Sutter St 4 Sidewalk: Curb side : Cutout Tree Private 2   03/23/1990 12:00:00 AM 6 4X4   6004701.1521 2114671.0024 37.786749150585 -122.427514608894 (37.786749150585, -122.427514608894) 13 9 11 28858 13

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