trees

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

✎ 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
50801 95033 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 1 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
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
50984 95035 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 5 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
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
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
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
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
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
59694 127215 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 4 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999937.99418 2117121.61309 37.7932073277938 -122.44417011406 (37.7932073277938, -122.44417011406) 13 9 1 57 27
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
60795 94982 Undocumented 4 Ficus nitida :: Laurel Fig 53 2301 Broadway 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6002562.1 2117394.1 37.7941048599095 -122.435110049481 (37.7941048599095, -122.435110049481) 13 9 1 29490 27
61417 7288 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1860 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 5x5   6003020.21181 2114689.03027 37.7867034322579 -122.433331547756 (37.7867034322579, -122.433331547756) 13 9 11 29490 27
62202 23539 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2750 Van Ness Ave 14 Sidewalk: Curb side : Cutout Tree DPW 1     23 3x3   6005738.98285 2119846.6704 37.8010188777475 -122.424292203059 (37.8010188777475, -122.424292203059) 13 9 1 28858 32
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
62512 21625 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1610 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6004858.21198 2114748.18478 37.7869699562504 -122.426976717781 (37.7869699562504, -122.426976717781) 13 9 11 28858 27
63529 56688 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1865X Grant Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3 Permit Number 17346 6002930 2119911 37.801036497901 -122.434017077007 (37.801036497901, -122.434017077007) 13 9 1 57 17
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
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
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
67334 99615 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
67743 26950 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 9 Sidewalk: Curb side : Cutout Tree DPW 1     17 3X3   6002695.46817 2114444.00008 37.7860122131882 -122.434437556188 (37.7860122131882, -122.434437556188) 13 9 11 29490 27
68956 16394 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 250X Myrtle St 3 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
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
70974 23955 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1985X Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   6002890.93346 2119517.51166 37.7999538645084 -122.434124118866 (37.7999538645084, -122.434124118866) 13 9 1 57 17
72817 121043 Undocumented 4 Ficus nitida :: Laurel Fig 53 2125 Polk St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006363 2118096 37.7962471953974 -122.422008397548 (37.7962471953974, -122.422008397548) 13 9 10 28858 32
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
75386 23542 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2750 Van Ness Ave 17 Sidewalk: Curb side : Cutout Tree DPW 1     14 3x3   6005753.45253 2119744.59142 37.8007394119615 -122.424234867659 (37.8007394119615, -122.424234867659) 13 9 1 28858 32
76207 127218 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2864 Broadway 7 Front Yard : Yard Tree Private 2     8 Width 4ft Permit Number 782825 5999923.49955 2117118.25276 37.7931972742965 -122.44422002466 (37.7931972742965, -122.44422002466) 13 9 1 57 27
77560 95038 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 9 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
77688 1668 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2679X LOMBARD ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     15 3X3   5999625 2119128 37.7986984723422 -122.445397421769 (37.7986984723422, -122.445397421769) 13 9 1 57 17
77847 13285 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2576 Lombard St 2 Sidewalk: Curb side : Cutout Tree DPW 1   10/26/1993 12:00:00 AM 3 3X3   6000068.81033 2119230.46658 37.799005143246 -122.443869066799 (37.799005143246, -122.443869066799) 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
78831 99639 Undocumented 4 Ficus nitida :: Laurel Fig 53 2201 Polk St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006359 2118331 37.7968922206311 -122.422038941111 (37.7968922206311, -122.422038941111) 13 9 10 28858 32
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
81527 26942 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 6x5   6002862.4862 2114464.90765 37.7860790992099 -122.433861214618 (37.7860790992099, -122.433861214618) 13 9 11 29490 27
81673 21749 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1840X Steiner St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6002560.9316389 2114541.9034523 37.786273393243 -122.434910019678 (37.786273393243, -122.434910019678) 13 9 11 29490 27
82597 21583 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1499 Sutter St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6005557.61202 2114792.21407 37.7871303723087 -122.424560082666 (37.7871303723087, -122.424560082666) 13 9 1 28858 41
83755 7286 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1848 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003026.38997 2114635.62779 37.7865571530845 -122.433306355459 (37.7865571530845, -122.433306355459) 13 9 11 29490 27
84337 9917 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1905X Gough St 1 Sidewalk: Curb side : Cutout Tree Rec/Park 5     30 3x3 Permit Number 768908 6005198.9827241 2116181.2464075 37.7909240477297 -122.425899774562 (37.7909240477297, -122.425899774562) 13 9 1 28858 27
84820 98591 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2375 Jackson St 2 Sidewalk: Curb side : Cutout Tree Private 2       3x3 Permit Number 9808 6002830 2116793 37.7924696026791 -122.434140096981 (37.7924696026791, -122.434140096981) 13 9 1 29490 27
85651 100050 Undocumented 4 Ficus nitida :: Laurel Fig 53 3233X Buchanan St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6003300 2119605 37.8002172925371 -122.432714848025 (37.8002172925371, -122.432714848025) 13 9 1 57 17
87750 53929 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1700 Laguna St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/29/1972 12:00:00 AM   3x3 Permit Number 9642 6004487.99959123 2114676.46033991 37.786752078395 -122.428252455396 (37.786752078395, -122.428252455396) 13 9 11 28858 27
87780 95040 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 3224 Pierce St 13 Sidewalk: Property side : Cutout Tree DPW for City Agency 14       3x3   6001388 2119447 37.7996748454742 -122.4393197689 (37.7996748454742, -122.4393197689) 13 9 1 57 17
90065 13211 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2190 Lombard St 1 Sidewalk: Curb side : Cutout Tree Private 2     70 3X3   6001897.52108 2119466.22991 37.7997566277665 -122.437558020868 (37.7997566277665, -122.437558020868) 13 9 1 57 17
90875 110969 Permitted Site 7 Ficus nitida :: Laurel Fig 53 2475 Washington St 2 Sidewalk: Curb side : Cutout Tree Private 2     17 3x3   6002881.27515757 2116466.21692287 37.7915752502174 -122.433939314763 (37.7915752502174, -122.433939314763) 13 9 1 29490 27
91924 21638 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1637 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6004769.4625949 2114679.8692957 37.7867773603046 -122.427278902509 (37.7867773603046, -122.427278902509) 13 9 11 28858 13
93727 26951 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 2040 Sutter St 10 Sidewalk: Curb side : Cutout Tree DPW 1     17 5x6   6002681.79801 2114441.89018 37.7860056439611 -122.434484700269 (37.7860056439611, -122.434484700269) 13 9 11 29490 27
93831 7281 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1820X Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   6003034.84406 2114579.8244 37.7864044107242 -122.433273117504 (37.7864044107242, -122.433273117504) 13 9 11 29490 27
94054 21691 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1881 Sutter St 6 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
95164 18160 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2     40 3X3   6005423.38609 2114511.38367 37.7863517006932 -122.42500448695 (37.7863517006932, -122.42500448695) 13 9 11 28858 13
95876 26159 Permitted Site 7 Ficus nitida :: Laurel Fig 53 210 Richardson Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   5999117.59522 2119823.02413 37.800577843616 -122.447203245105 (37.800577843616, -122.447203245105) 13 9 1 57 17
96583 12428 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1710 Laguna St 2 Sidewalk: Curb side : Cutout Tree Private 2   09/13/1989 12:00:00 AM 12 4X4   6004482.43729 2114709.16781 37.7868415701808 -122.428274031584 (37.7868415701808, -122.428274031584) 13 9 11 28858 27
96607 21642 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1649 Sutter St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 4X4   6004713.5335639 2114672.0939043 37.7867528478772 -122.427471849732 (37.7867528478772, -122.427471849732) 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)
);