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

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)
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
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
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
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
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
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
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
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
137864 115903 Permitted Site 7 Ficus nitida :: Laurel Fig 53 201 Steiner St 2 Sidewalk: Curb side : Cutout Tree Private 2   06/13/2016 12:00:00 AM 3 4x4   6003287.79827449 2108952.35112135 37.7709671172915 -122.431995967048 (37.7709671172915, -122.431995967048) 15 9 11 29492 9
156157 59335 Permitted Site 7 Ficus nitida :: Laurel Fig 53 201 Steiner St 1 Sidewalk: Curb side : Cutout Tree Private 2   11/05/1980 12:00:00 AM   4x4 Permit Number 18682 6003287.79827449 2108952.35112135 37.7709671172915 -122.431995967048 (37.7709671172915, -122.431995967048) 15 9 11 29492 9
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
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
140971 16959 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 705 Oak St 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6003588.88104 2109980.45883 37.7738071133695 -122.431027903554 (37.7738071133695, -122.431027903554) 15 9 11 29492 10
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
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
113219 16946 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 609 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
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
192852 16949 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 625 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6003989.24409 2110039.43116 37.7739917148646 -122.429647190447 (37.7739917148646, -122.429647190447) 7 9 11 29492 10
109776 23705 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 601X Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6004026.4448 2110044.61455 37.7740080535371 -122.429518876644 (37.7740080535371, -122.429518876644) 7 9 11 29492 10
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
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
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
158220 9662 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 112 Gough St 2 Sidewalk: Curb side : Cutout Tree DPW 1     22 3X3   6006086.53311 2110106.07673 37.7742932396102 -122.422397038566 (37.7742932396102, -122.422397038566) 7 9 11 28852 10
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
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
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
173262 16934 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 534 Oak St 1 Sidewalk: Property side : Cutout Tree DPW 1     24 3X3   6004202.21217 2110156.57626 37.7743254232669 -122.428918851232 (37.7743254232669, -122.428918851232) 7 9 11 28852 10
191157 16897 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 385 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6005198.99692 2110159.80887 37.7743906686767 -122.425471016021 (37.7743906686767, -122.425471016021) 7 9 11 28852 10
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
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
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
191412 2431 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 490X Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     25 3X3   6004657.78302 2110211.29448 37.7745014417711 -122.427346845616 (37.7745014417711, -122.427346845616) 7 9 11 28852 10
174129 16872 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 259 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6005773.57352 2110239.8238 37.7746428175577 -122.423489134945 (37.7746428175577, -122.423489134945) 7 9 11 28852 10
95502 16899 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 406 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3   6005035.08833 2110252.02045 37.7746345969303 -122.426044572686 (37.7746345969303, -122.426044572686) 7 9 11 28852 10
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
142032 16862 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 205 Oak St 1 Sidewalk: Curb side : Cutout Tree DPW 1     24 7x6   6005961.9803 2110311.49787 37.7748502496054 -122.422842492323 (37.7748502496054, -122.422842492323) 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
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
103903 7712 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 47 Franklin St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006492.59831 2110356.24747 37.7750030463236 -122.421010148365 (37.7750030463236, -122.421010148365) 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
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
122936 16856 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 150 Oak St 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6006257.87931 2110498.54999 37.7753805408795 -122.421832203671 (37.7753805408795, -122.421832203671) 7 9 11 28852 10
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
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
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
117462 12246 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 501 Laguna St 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/03/2015 03:15:00 PM 3 5x5   6004973.20209 2110637.42143 37.775689316239 -122.426286094705 (37.775689316239, -122.426286094705) 7 9 11 28852 10
142334 12245 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 503 Laguna St 3 Sidewalk: Curb side : Cutout Tree DPW 1   02/03/2015 03:15:00 PM 3 5x5 Permit Number 780762 6004995.5845 2110652.4736 37.7757319109571 -122.426209740207 (37.7757319109571, -122.426209740207) 7 9 11 28852 10
172277 10647 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 913 Hayes St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/02/1991 12:00:00 AM 12 3X3   6003471.55966 2110689.4075 37.775747062973 -122.431484357932 (37.775747062973, -122.431484357932) 15 9 11 29492 10
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
162520 10628 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 805 Hayes St 2 Sidewalk: Curb side : Cutout Tree DPW 1   08/02/1990 12:00:00 AM 6 3X4   6003942.23141 2110755.32974 37.775954734286 -122.429860889744 (37.775954734286, -122.429860889744) 7 9 11 29492 10
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
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
111324 7153 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 708 Fillmore St 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6003550.62034 2110877.34065 37.7762675615733 -122.431224284875 (37.7762675615733, -122.431224284875) 7 9 11 29492 10
124076 7165 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 735 Fillmore St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003427.15007 2110890.32808 37.776296224072 -122.431652329724 (37.776296224072, -122.431652329724) 15 9 11 29492 10
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
183025 26841 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 100 Van Ness Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 3X3 Permit Number 779930 6006975.88726 2110943.04151 37.7766414730488 -122.419379980819 (37.7766414730488, -122.419379980819) 7 9 9 28852 36
188066 9689 Permitted Site 7 Ficus nitida :: Laurel Fig 53 332 Gough St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 3x3   6006025.5202 2110969.11106 37.7766594813407 -122.422669436188 (37.7766594813407, -122.422669436188) 7 9 11 28852 10
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
188563 10618 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 350 Gough St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6006025.52151 2110969.11138 37.7766594822933 -122.422669431679 (37.7766594822933, -122.422669431679) 7 9 11 28852 10
133335 99718 Undocumented 4 Ficus nitida :: Laurel Fig 53 430 Hayes St 3 Sidewalk: Curb side : Cutout Tree Private 2     14 3x3   6005787 2111054 37.7768791059226 -122.423500585068 (37.7768791059226, -122.423500585068) 7 9 11 28852 10
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
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
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
168672 9974 Permitted Site 7 Ficus nitida :: Laurel Fig 53 812X Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 3X3   6003525.87553 2111110.58272 37.7769065842705 -122.431326537326 (37.7769065842705, -122.431326537326) 7 9 11 29492 10
128624 117343 Undocumented 4 Ficus nitida :: Laurel Fig 53 372 HAYES ST 5 Sidewalk: Curb side : Cutout Tree Private 2       5x5   6006019 2111114 37.7770569433878 -122.422702290381 (37.7770569433878, -122.422702290381) 7 9 11 28852 10
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
172169 117345 Undocumented 4 Ficus nitida :: Laurel Fig 53 395 HAYES ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6006014 2111158 37.7771774746178 -122.422722714586 (37.7771774746178, -122.422722714586) 7 9 11 28852 10
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
125851 253693 Undocumented 4 Ficus nitida :: Laurel Fig 53 536 Octavia St 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005450 2111168 37.7771730951376 -122.424674483112 (37.7771730951376, -122.424674483112) 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
163768 9696 DPW Maintained 1 Ficus nitida :: Laurel Fig 53 414 Gough St 4 Sidewalk: Curb side : Cutout Tree DPW 1     22 3X3   6005964.80411 2111186.62637 37.7772532999259 -122.422894934036 (37.7772532999259, -122.422894934036) 7 9 11 28852 10
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
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
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
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
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
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
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
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
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
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
115162 7181 Permitted Site 7 Ficus nitida :: Laurel Fig 53 847 Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2     3 3x3   6003442.40326 2111287.35095 37.7773872150711 -122.431627916454 (37.7773872150711, -122.431627916454) 15 9 11 29492 10
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
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
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
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
132184 7184 Permitted Site 7 Ficus nitida :: Laurel Fig 53 857 Fillmore St 3 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
115819 7191 Permitted Site 7 Ficus nitida :: Laurel Fig 53 896 Fillmore St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 5X5   6003494.59692 2111314.73243 37.7774653560924 -122.431449316775 (37.7774653560924, -122.431449316775) 7 9 11 29492 10
170574 114952 Undocumented 4 Ficus nitida :: Laurel Fig 53 601X OCTAVIA ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6005348 2111368 37.7777164851071 -122.42504156742 (37.7777164851071, -122.42504156742) 7 9 11 28852 10
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
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
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
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
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
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
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
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
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

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