trees

1,626 rows where qSpecies_id = 53 sorted by Police Districts descending

✎ View and edit SQL

This data as json, CSV (advanced)

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)
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
50280 7218 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000X Fillmore St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003426.09434 2111753.60864 37.778666518442 -122.431717632161 (37.778666518442, -122.431717632161) 15 9 11 29490 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
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
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
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
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
52416 6378 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 310 Elm St 1 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
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
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
57390 9617 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1050X Steiner St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6002921.99888 2111973.13636 37.7792406996886 -122.433477183837 (37.7792406996886, -122.433477183837) 15 9 11 29490 41
57513 12263 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 640 Laguna St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6004991.72568 2111198.95935 37.7772322091826 -122.426262005109 (37.7772322091826, -122.426262005109) 7 9 11 28852 10
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
60815 14812 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1190X McAllister St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6003455.90906 2111772.60341 37.7787203633271 -122.431615848033 (37.7787203633271, -122.431615848033) 15 9 11 29490 41
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
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
61596 102505 Permitted Site 7 Ficus nitida :: Laurel Fig 53 290X Hermann St 3 Sidewalk: Curb side : Cutout Tree Private 2       6x7   6003881.1 2108703.5 37.7703174504719 -122.429925966233 (37.7703174504719, -122.429925966233) 7 9 11 29492 10
61909 7229 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1040 Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6003407.87597 2111884.23201 37.7790241450036 -122.431789985507 (37.7790241450036, -122.431789985507) 15 9 11 29490 41
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
62686 22722 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 2 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
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
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
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
66815 23796 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1133 Webster St 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X3   6003746.01833 2112690.85168 37.7812580840725 -122.430677790145 (37.7812580840725, -122.430677790145) 15 9 11 29490 41
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
67395 20160 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1150X Steiner St 3 Sidewalk: Curb side : Cutout Tree Police Dept 10     18 4X4   6002889.114145 2112192.180758 37.7798402749908 -122.433606604391 (37.7798402749908, -122.433606604391) 15 9 11 29490 41
67556 9975 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 812X Fillmore St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6003525.87553 2111110.58272 37.7769065842705 -122.431326537326 (37.7769065842705, -122.431326537326) 7 9 11 29492 10
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
67817 16940 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 599X Oak St 3 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
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
69091 7190 Permitted Site 7 Ficus nitida :: Laurel Fig 53 896 Fillmore St 2 Sidewalk: Curb side : Cutout Tree Private 2     18 5X5   6003496.10413 2111301.12929 37.7774280906657 -122.431443131507 (37.7774280906657, -122.431443131507) 7 9 11 29492 10
69526 9615 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1050X Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 4X4   6002927.21435 2111923.58629 37.7791049434867 -122.433455599491 (37.7791049434867, -122.433455599491) 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
70605 7148 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 670X Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   6003788.041 2110084.01472 37.7741027355458 -122.430346367315 (37.7741027355458, -122.430346367315) 7 9 11 29492 10
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
71007 116518 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 480 FILLMORE ST 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/2016 12:00:00 AM 3 9x6   6003703 2109976 37.7738013362642 -122.430632829648 (37.7738013362642, -122.430632829648) 7 9 11 29492 10
72584 16863 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 215 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6005958.79101 2110336.37823 37.774918385113 -122.422855293382 (37.774918385113, -122.422855293382) 7 9 11 28852 10
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
73540 22711 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 13 Sidewalk: Curb side : Cutout Tree Police Dept 10     12 4x4   6003306.8488585 2112395.4775226 37.7804221702729 -122.43217599894 (37.7804221702729, -122.43217599894) 15 9 11 29490 41
74073 7223 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1234X McAllister St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003286.8961 2111743.0712 37.7786296939692 -122.432198419662 (37.7786296939692, -122.432198419662) 15 9 11 29490 41
74795 20161 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1150X Steiner St 4 Sidewalk: Curb side : Cutout Tree Police Dept 10     18 4X4   6002889.114145 2112192.180758 37.7798402749908 -122.433606604391 (37.7798402749908, -122.433606604391) 15 9 11 29490 41
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
75688 6379 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 310 Elm St 2 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
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
78906 7228 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1040 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 4X4   6003407.87597 2111884.23201 37.7790241450036 -122.431789985507 (37.7790241450036, -122.431789985507) 15 9 11 29490 41
79190 7215 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000X Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003426.09434 2111753.60864 37.778666518442 -122.431717632161 (37.778666518442, -122.431717632161) 15 9 11 29490 41
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
80780 9576 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1290X Golden Gate Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6003446.27659 2112118.33325 37.7796691054144 -122.431673860699 (37.7796691054144, -122.431673860699) 15 9 11 29490 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
81976 7711 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 43 Franklin St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006508.0978555 2110273.8315465 37.7747776257034 -122.420950679235 (37.7747776257034, -122.420950679235) 7 9 11 28852 10
82016 16948 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 617 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6004030.19479 2110006.18975 37.7739027607756 -122.429503163951 (37.7739027607756, -122.429503163951) 7 9 11 29492 10
82543 7221 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1000X Fillmore St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003426.09434 2111753.60864 37.778666518442 -122.431717632161 (37.778666518442, -122.431717632161) 15 9 11 29490 41
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
83236 7211 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1225X McAllister St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003292.0475526 2111699.258462 37.7785096871743 -122.432177469127 (37.7785096871743, -122.432177469127) 15 9 11 29492 41
83435 14655 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 655X McAllister St 5 Sidewalk: Curb side : Cutout Tree DPW 1     60 3x3   6006015.9359491 2112078.013352 37.7797037167615 -122.422781416289 (37.7797037167615, -122.422781416289) 7 9 11 28852 10
83704 10626 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 414 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 3X3   6005955 2111106 37.7770313662769 -122.422923117926 (37.7770313662769, -122.422923117926) 7 9 11 28852 10
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
83917 7189 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 896 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 5X5   6003518.08132 2111313.80886 37.7774641511736 -122.43136801056 (37.7774641511736, -122.43136801056) 7 9 11 29492 10
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
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
87320 9574 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1290X Golden Gate Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 6x5   6003478.20667 2112124.62637 37.7796881945834 -122.431563850171 (37.7796881945834, -122.431563850171) 15 9 11 29490 41
87434 7222 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 1005 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6003381.12091 2111775.83058 37.7787249849862 -122.431874799698 (37.7787249849862, -122.431874799698) 15 9 11 29490 41
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
89959 22721 Permitted Site 7 Ficus nitida :: Laurel Fig 53 1401X Turk St 3 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
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
90207 6932 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 500 Fell St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3 Permit Number 780762 6004980.8762 2110598.20876 37.7755820815859 -122.426256755638 (37.7755820815859, -122.426256755638) 7 9 11 28852 10
90763 113321 Undocumented 4 Ficus nitida :: Laurel Fig 53 222 HERMANN ST 1 Sidewalk: Curb side : Cutout Tree Private 2     24 3x3   6004169 2108774 37.7705273263251 -122.428935147688 (37.7705273263251, -122.428935147688) 7 9 11 29492 10
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
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
93569 7144 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 685X Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6003730.75372 2110025.58578 37.7739390589029 -122.430540363958 (37.7739390589029, -122.430540363958) 7 9 11 29492 10
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

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