856 rows where qSpecies_id = 5 sorted by qSiteInfo

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)
372 189871 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Newhall St 9 : Tree Private 2     7 Width 3ft   6016028.58203 2097927.48174 37.7414092251604 -122.387155715173 (37.7414092251604, -122.387155715173) 10 3 8 58 1
8125 189865 DPW Maintained 1 Ceratonia siliqua :: Carob 5 501 Newhall St 2 : Tree Private 2     13 Width 4ft   6015985.7864 2097784.98338 37.7410155838051 -122.387293751216 (37.7410155838051, -122.387293751216) 10 3 8 58 1
10434 189892 DPW Maintained 1 Ceratonia siliqua :: Carob 5 200 Newhall St 6 : Tree Private 2     13 Width 4ft   6016806.72009 2098324.89991 37.7425435148768 -122.384492832481 (37.7425435148768, -122.384492832481) 10 3 8 58 1
10873 189885 DPW Maintained 1 Ceratonia siliqua :: Carob 5 201 Newhall St 6 : Tree Private 2     3 Width 3ft   6016834.26905 2098267.19561 37.7423865939792 -122.384393557236 (37.7423865939792, -122.384393557236) 10 3 8 58 1
11061 189851 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 15 : Tree Private 2     12 Width 3ft   6017359.84801 2098072.09609 37.7418799384027 -122.382562673322 (37.7418799384027, -122.382562673322) 10 3 8 58 1
14221 189868 DPW Maintained 1 Ceratonia siliqua :: Carob 5 401 Newhall St 3 : Tree Private 2     7 Width 3ft   6016117.80915 2097961.55377 37.7415077207098 -122.386849571549 (37.7415077207098, -122.386849571549) 10 3 8 58 1
15607 189834 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1698 Galvez Ave 4 : Tree Private 2     14 Width 4ft   6015429.09406 2098017.0802 37.7416220281222 -122.389234809264 (37.7416220281222, -122.389234809264) 10 3 8 58 1
18217 222886 DPW Maintained 1 Ceratonia siliqua :: Carob 5 139 Webster St 1 : Tree Private 2     15 Width 3ft   6004216.91806 2109283.17336 37.7719281046318 -122.428805703247 (37.7719281046318, -122.428805703247) 7 9 11 29492 10
21523 189852 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100 Newhall St 2 : Tree Private 2     8 Width 3ft   6017365.88907 2098130.81013 37.7420414890213 -122.38254586949 (37.7420414890213, -122.38254586949) 10 3 8 58 1
21954 189895 DPW Maintained 1 Ceratonia siliqua :: Carob 5 220 Newhall St 2 : Tree Private 2     9 Width 3ft   6016704.91422 2098345.41637 37.7425942186412 -122.384846279543 (37.7425942186412, -122.384846279543) 10 3 8 58 1
23115 189845 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 7 : Tree Private 2     6 Width 3ft   6017192.34248 2098175.05438 37.7421533862633 -122.383149023221 (37.7421533862633, -122.383149023221) 10 3 8 58 1
26717 189875 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Newhall St 15 : Tree Private 2     12 Width 3ft   6015903.72942 2097762.72481 37.7409499215909 -122.387575924289 (37.7409499215909, -122.387575924289) 10 3 8 58 1
29579 189876 DPW Maintained 1 Ceratonia siliqua :: Carob 5 375 Newhall St 8 : Tree Private 2     8 Width 3ft   6016406.62692 2098319.91707 37.7425077002596 -122.385875902556 (37.7425077002596, -122.385875902556) 10 3 8 58 1
35885 189864 DPW Maintained 1 Ceratonia siliqua :: Carob 5 501 Newhall St 1 : Tree Private 2     16 Width 3ft   6015974.53489 2097767.48194 37.7409669053009 -122.387331434622 (37.7409669053009, -122.387331434622) 10 3 8 58 1
39895 189881 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 6 : Tree Private 2     10 Width 3ft   6016559.49898 2098322.63372 37.7425236182725 -122.385347500499 (37.7425236182725, -122.385347500499) 10 3 8 58 1
40554 189850 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 14 : Tree Private 2     9 Width 3ft   6017345.72519 2098082.05897 37.7419065142755 -122.382612199015 (37.7419065142755, -122.382612199015) 10 3 8 58 1
44548 189913 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Flora St 9 : Tree Private 2     6 Width 3ft   6013888.27035 2094422.90108 37.731667614051 -122.39431091023 (37.731667614051, -122.39431091023) 10 3 8 58 1
48751 189873 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Newhall St 13 : Tree Private 2     13 Width 4ft   6015949.19552 2097817.31467 37.7411023324162 -122.387422525146 (37.7411023324162, -122.387422525146) 10 3 8 58 1
49432 222887 DPW Maintained 1 Ceratonia siliqua :: Carob 5 123 Webster St 1 : Tree Private 2     13 Width 5ft   6004226.51196 2109212.81898 37.77173547164 -122.428767500918 (37.77173547164, -122.428767500918) 7 9 11 29492 10
52787 222885 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Valencia St 3 : Tree Private 2     18 Width 5ft   6006051.02822 2109339.24494 37.7721857010308 -122.422465357814 (37.7721857010308, -122.422465357814) 8 2 9 28853 19
56752 189914 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Flora St 11 : Tree Private 2     5 Width 3ft   6013894.18582 2094452.33408 37.7317487598799 -122.394292519091 (37.7317487598799, -122.394292519091) 10 3 8 58 1
61480 246510 DPW Maintained 1 Ceratonia siliqua :: Carob 5 231 Duncan St 1 : Tree Private 2     1 Width 5ft   6004993.26159 2099869.66747 37.7461247456624 -122.425450235552 (37.7461247456624, -122.425450235552) 2 7 5 63 22
62825 246517 DPW Maintained 1 Ceratonia siliqua :: Carob 5 41 Waller St 1 : Tree Private 2     3 Width 3ft   6005417.73549 2109222.56247 37.7718295731126 -122.424647671566 (37.7718295731126, -122.424647671566) 7 9 5 28852 10
65426 189896 DPW Maintained 1 Ceratonia siliqua :: Carob 5 220 Newhall St 3 : Tree Private 2     14 Width 4ft   6016683.25153 2098348.88465 37.7426025436648 -122.384921425089 (37.7426025436648, -122.384921425089) 10 3 8 58 1
65626 189862 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 12 : Tree Private 2     7 Width 3ft   6017103.28687 2098264.26759 37.7423934261135 -122.383463161819 (37.7423934261135, -122.383463161819) 10 3 8 58 1
67259 189842 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 4 : Tree Private 2     7 Width 3ft   6017136.08616 2098201.14709 37.7422219227174 -122.383345357813 (37.7422219227174, -122.383345357813) 10 3 8 58 1
67696 189866 DPW Maintained 1 Ceratonia siliqua :: Carob 5 501 Newhall St 3 : Tree Private 2     11 Width 4ft   6016000.66321 2097804.14137 37.7410690116125 -122.3872436482 (37.7410690116125, -122.3872436482) 10 3 8 58 1
70275 189859 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 9 : Tree Private 2     7 Width 3ft   6017171.36242 2098242.65136 37.7423378345214 -122.38322627048 (37.7423378345214, -122.38322627048) 10 3 8 58 1
71087 189833 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1570 Burke Ave 2 : Tree DPW 1   02/12/2016 12:00:00 AM 14 Width 3ft   6016585.78665 2098909.19771 37.7441356575455 -122.385297468507 (37.7441356575455, -122.385297468507) 10 3 8 58 1
71679 189860 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 10 : Tree Private 2     7 Width 3ft   6017146.31011 2098252.64566 37.7423638923838 -122.383313590143 (37.7423638923838, -122.383313590143) 10 3 8 58 1
72425 189898 DPW Maintained 1 Ceratonia siliqua :: Carob 5 220 Newhall St 5 : Tree Private 2     10 Width 3ft   6016641.64949 2098357.67933 37.7426243909147 -122.385065886799 (37.7426243909147, -122.385065886799) 10 3 8 58 1
75614 189900 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Newhall St 8 : Tree Private 2     10 Width 3ft   6016469.43957 2098386.38148 37.7426936737758 -122.385663344212 (37.7426936737758, -122.385663344212) 10 3 8 58 1
75632 188488 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1525 Burke Ave 8 : Tree Private 2     8 Width 4ft   6016697.4652 2098710.93051 37.7435974339762 -122.384897495043 (37.7435974339762, -122.384897495043) 10 3 8 58 1
77795 189855 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 5 : Tree Private 2     9 Width 3ft   6017245.40272 2098209.38961 37.7422505957884 -122.382967944715 (37.7422505957884, -122.382967944715) 10 3 8 58 1
80577 189839 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 1 : Tree Private 2     1 Width 3ft   6017074.26086 2098217.41845 37.7422631836031 -122.383560265197 (37.7422631836031, -122.383560265197) 10 3 8 58 1
80674 189869 DPW Maintained 1 Ceratonia siliqua :: Carob 5 401 Newhall St 4 : Tree Private 2     13 Width 3ft   6016127.95859 2097976.0947 37.7415482090816 -122.38681549176 (37.7415482090816, -122.38681549176) 10 3 8 58 1
83224 189863 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 13 : Tree Private 2     9 Width 3ft   6017087.00267 2098268.01639 37.7424028195418 -122.383519729148 (37.7424028195418, -122.383519729148) 10 3 8 58 1
83845 189890 DPW Maintained 1 Ceratonia siliqua :: Carob 5 200 Newhall St 4 : Tree Private 2     10 Width 4ft   6016847.57568 2098318.03852 37.742526934071 -122.384351086743 (37.742526934071, -122.384351086743) 10 3 8 58 1
85138 189878 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 3 : Tree Private 2     7 Width 3ft   6016474.87335 2098336.17477 37.7425561170601 -122.385641057214 (37.7425561170601, -122.385641057214) 10 3 8 58 1
94315 189882 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 7 : Tree Private 2     9 Width 3ft   6016580.99088 2098317.85278 37.7425116797752 -122.385272854085 (37.7425116797752, -122.385272854085) 10 3 8 58 1
98760 189879 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 4 : Tree Private 2     8 Width 3ft   6016498.14538 2098335.4641 37.7425554533749 -122.385560539098 (37.7425554533749, -122.385560539098) 10 3 8 58 1
99211 189861 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 11 : Tree Private 2     8 Width 3ft   6017125.66493 2098258.40905 37.742378576526 -122.383385376738 (37.742378576526, -122.383385376738) 10 3 8 58 1
100985 189841 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 3 : Tree Private 2     1 Width 3ft   6017113.18863 2098207.21128 37.7422373082953 -122.383424953219 (37.7422373082953, -122.383424953219) 10 3 8 58 1
102050 189886 DPW Maintained 1 Ceratonia siliqua :: Carob 5 201 Newhall St 7 : Tree Private 2     6 Width 3ft   6016892.13311 2098254.09694 37.7423538271607 -122.384192566831 (37.7423538271607, -122.384192566831) 10 3 8 58 1
102361 189877 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 2 : Tree Private 2     7 Width 3ft   6016448.85629 2098333.07564 37.7425461678608 -122.385730801451 (37.7425461678608, -122.385730801451) 10 3 8 58 1
102811 189880 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 5 : Tree Private 2     7 Width 3ft   6016536.79452 2098327.43911 37.742535556771 -122.385426341355 (37.742535556771, -122.385426341355) 10 3 8 58 1
107432 189915 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Flora St 13 : Tree Private 2     5 Width 3ft   6013899.07383 2094479.41823 37.7318233991302 -122.394277515688 (37.7318233991302, -122.394277515688) 10 3 8 58 1
108597 189872 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Newhall St 12 : Tree Private 2     17 Width 4ft   6015960.56064 2097835.58742 37.7411531351002 -122.387384502698 (37.7411531351002, -122.387384502698) 10 3 8 58 1
111049 189870 DPW Maintained 1 Ceratonia siliqua :: Carob 5 401 Newhall St 5 : Tree Private 2     13 Width 3ft   6016138.74056 2097991.9117 37.7415922362914 -122.386779313807 (37.7415922362914, -122.386779313807) 10 3 8 58 1
111910 189867 DPW Maintained 1 Ceratonia siliqua :: Carob 5 401 Newhall St 2 : Tree Private 2     16 Width 3ft   6016089.46635 2097928.70806 37.7414159637784 -122.38694528192 (37.7414159637784, -122.38694528192) 10 3 8 58 1
117844 188482 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1580 Burke Ave 3 : Tree DPW 1   03/30/1990 12:00:00 AM 9 Width 4ft   6016171.38717 2099220.37618 37.7449671554124 -122.386752079638 (37.7449671554124, -122.386752079638) 10 3 8 58 1
120516 189836 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1698 Galvez Ave 9 : Tree Private 2     13 Width 4ft   6015406.79125 2098034.46628 37.7416685302756 -122.389313139314 (37.7416685302756, -122.389313139314) 10 3 8 58 1
123006 189856 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 6 : Tree Private 2     6 Width 3ft   6017223.11391 2098220.28067 37.7422792688651 -122.383045771154 (37.7422792688651, -122.383045771154) 10 3 8 58 1
124439 189888 DPW Maintained 1 Ceratonia siliqua :: Carob 5 200 Newhall St 2 : Tree Private 2     6 Width 3ft   6016891.26784 2098307.49665 37.7425004040788 -122.384199276697 (37.7425004040788, -122.384199276697) 10 3 8 58 1
129074 189916 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1771 Palou Ave 1 : Tree Private 2     15 Width 4ft   6013954.80906 2095907.81376 37.7357485783226 -122.394184791988 (37.7357485783226, -122.394184791988) 10 3 8 58 1
129151 188481 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1570 Burke Ave 10 : Tree Private 2   08/24/2017 12:00:00 AM 3 Width 3ft   6016299.33242 2099120.87091 37.7447010172388 -122.386302728 (37.7447010172388, -122.386302728) 10 3 8 58 1
129552 189854 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 4 : Tree Private 2     10 Width 3ft   6017283.71117 2098187.47887 37.7421925499461 -122.382833960126 (37.7421925499461, -122.382833960126) 10 3 8 58 1
136362 189853 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 1 : Tree Private 2     8 Width 3ft   6017352.03209 2098141.27696 37.7420694633311 -122.382594511142 (37.7420694633311, -122.382594511142) 10 3 8 58 1
139582 189874 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Newhall St 14 : Tree Private 2     19 Width 4ft   6015935.20003 2097800.22723 37.741054638653 -122.387469725156 (37.741054638653, -122.387469725156) 10 3 8 58 1
143317 189891 DPW Maintained 1 Ceratonia siliqua :: Carob 5 200 Newhall St 5 : Tree Private 2     4 Width 3ft   6016826.79146 2098321.83879 37.7425362195639 -122.384423217764 (37.7425362195639, -122.384423217764) 10 3 8 58 1
143777 189858 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 8 : Tree Private 2     10 Width 4ft   6017192.20681 2098235.03839 37.7423180827181 -122.383153666435 (37.7423180827181, -122.383153666435) 10 3 8 58 1
153118 189887 DPW Maintained 1 Ceratonia siliqua :: Carob 5 200 Newhall St 1 : Tree Private 2     10 Width 3ft   6016910.34518 2098303.24769 37.7424897920671 -122.384133016442 (37.7424897920671, -122.384133016442) 10 3 8 58 1
162252 189848 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 11 : Tree Private 2     8 Width 4ft   6017264.73109 2098137.17538 37.7420533780644 -122.38289608801 (37.7420533780644, -122.38289608801) 10 3 8 58 1
172152 189849 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 12 : Tree Private 2     10 Width 4ft   6017283.17469 2098125.85242 37.7420233065307 -122.38283152746 (37.7420233065307, -122.38283152746) 10 3 8 58 1
174284 189893 DPW Maintained 1 Ceratonia siliqua :: Carob 5 200 Newhall St 7 : Tree Private 2     10 Width 3ft   6016784.24817 2098329.21731 37.7425541268854 -122.384570835175 (37.7425541268854, -122.384570835175) 10 3 8 58 1
174476 189889 DPW Maintained 1 Ceratonia siliqua :: Carob 5 200 Newhall St 3 : Tree Private 2     7 Width 3ft   6016866.9099 2098314.50918 37.7425183122785 -122.384283988325 (37.7425183122785, -122.384283988325) 10 3 8 58 1
176007 189894 DPW Maintained 1 Ceratonia siliqua :: Carob 5 200 Newhall St 8 : Tree Private 2     10 Width 3ft   6016764.20599 2098333.7275 37.7425654025768 -122.384640449909 (37.7425654025768, -122.384640449909) 10 3 8 58 1
182345 222884 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Valencia St 1 : Tree Private 2     18 Width 5ft   6006058.17228 2109199.11331 37.7718013362 -122.422430687153 (37.7718013362, -122.422430687153) 8 2 9 28853 19
184901 189840 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 2 : Tree Private 2     3 Width 3ft   6017094.37686 2098212.93845 37.7422519942486 -122.383490397763 (37.7422519942486, -122.383490397763) 10 3 8 58 1
186123 189857 DPW Maintained 1 Ceratonia siliqua :: Carob 5 102 Newhall St 7 : Tree Private 2     11 Width 4ft   6017207.28329 2098227.98563 37.7422995503725 -122.383101045278 (37.7422995503725, -122.383101045278) 10 3 8 58 1
187611 189884 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 12 : Tree Private 2     8 Width 3ft   6016685.38219 2098298.11667 37.7424632629752 -122.384910521712 (37.7424632629752, -122.384910521712) 10 3 8 58 1
189250 189912 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Flora St 8 : Tree Private 2     4 Width 3ft   6013884.75868 2094408.47452 37.7316278064595 -122.394322041155 (37.7316278064595, -122.394322041155) 10 3 8 58 1
189381 189911 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Flora St 7 : Tree Private 2     5 Width 3ft   6013879.72064 2094387.80607 37.7315707750637 -122.394338012196 (37.7315707750637, -122.394338012196) 10 3 8 58 1
194211 189883 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 9 : Tree Private 2     8 Width 3ft   6016619.88237 2098309.8227 37.7424917822737 -122.385137818162 (37.7424917822737, -122.385137818162) 10 3 8 58 1
20489 225066 DPW Maintained 1 Ceratonia siliqua :: Carob 5 199 Franconia St 13 : Yard Tree Private 2     5 Width 3ft   6010116.17854 2099660.00965 37.7458371865343 -122.407720980957 (37.7458371865343, -122.407720980957) 2 7 7 28859 2
31579 225050 DPW Maintained 1 Ceratonia siliqua :: Carob 5 500x 27th St 24 Median : Cutout Tree DPW 1     11 Width 4ft   6002949.31338 2100070.05084 37.7465592558077 -122.432532251866 (37.7465592558077, -122.432532251866) 2 7 5 63 22
175659 225049 DPW Maintained 1 Ceratonia siliqua :: Carob 5 500x 27th St 22 Median : Cutout Tree DPW 1     6 Width 4ft   6002919.63953 2100068.30287 37.7465527734974 -122.432634735922 (37.7465527734974, -122.432634735922) 2 7 5 63 22
7 188479 Prune Opt Out 3 Ceratonia siliqua :: Carob 5 2208 Mariposa St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft Permit Number 787847 6010817.79084 2106032.71885 37.7633744862602 -122.405743691032 (37.7633744862602, -122.405743691032) 8 4 8 28859 19
239 205987 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1639 17th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   5990866.8027 2104246.93654 37.7573353075836 -122.474616638541 (37.7573353075836, -122.474616638541) 1 8 4 56 12
438 16548 Permitted Site 7 Ceratonia siliqua :: Carob 5 400X Newhall St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6016043.45751 2097947.55726 37.7414651721818 -122.387105680372 (37.7414651721818, -122.387105680372) 10 3 8 58 1
640 222906 DPW Maintained 1 Ceratonia siliqua :: Carob 5 363 Page St 3 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6004761.72453 2109824.22026 37.7734445081828 -122.42695971791 (37.7734445081828, -122.42695971791) 7 9 11 28852 10
846 115842 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Bay St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6003573.21553 2120746.37029 37.8033666892713 -122.431850957862 (37.8033666892713, -122.431850957862) 13 9 1 57 17
857 189910 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 11 Sidewalk: Curb side : Cutout Tree DPW 1     14 Width 3ft   6016250.22154 2098227.10108 37.7422441899167 -122.386410241063 (37.7422441899167, -122.386410241063) 10 3 8 58 1
1256 97187 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 9 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013222.5 2116242.1 37.7915413037038 -122.398142826086 (37.7915413037038, -122.398142826086) 12 2 9 28855 6
1800 189943 DPW Maintained 1 Ceratonia siliqua :: Carob 5 160 Spear St 3 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 3ft   6014663.90287 2116268.03372 37.7916926905231 -122.393157367813 (37.7916926905231, -122.393157367813) 12 2 9 28855 6
1856 16547 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400X Newhall St 8 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6016044.76119 2097949.4335 37.7414703961451 -122.387101303489 (37.7414703961451, -122.387101303489) 10 3 8 58 1
2297 16623 DPW Maintained 1 Ceratonia siliqua :: Carob 5 136 Noe St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6002840.1476308 2107468.9628395 37.7668687081336 -122.433438380285 (37.7668687081336, -122.433438380285) 15 5 5 28862 3
2472 6651 DPW Maintained 1 Ceratonia siliqua :: Carob 5 495X Newhall St 7 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472) 10 3 8 58 1
3395 17446 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1966 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6012949.46477 2096727.20845 37.7379425338291 -122.397718137505 (37.7379425338291, -122.397718137505) 10 3 8 58 1
3688 189905 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 Width 3ft   6016340.3864 2098339.29531 37.7425572430226 -122.386106295385 (37.7425572430226, -122.386106295385) 10 3 8 58 1
4137 61685 DPW Maintained 1 Ceratonia siliqua :: Carob 5 34 Ceres St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/29/1984 12:00:00 AM 11   Permit Number 21682 6013864.09066 2093969.56082 37.7304214900476 -122.394362775032 (37.7304214900476, -122.394362775032) 10 3 8 58 1
5594 106035 Permitted Site 7 Ceratonia siliqua :: Carob 5 195X Main St 4 Sidewalk: Curb side : Cutout Tree Private 2       3x3   6014366.74772 2116104.57878 37.7912273690908 -122.394174082061 (37.7912273690908, -122.394174082061) 12 2 9 28855 6
5811 2517 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016481.64243 2098901.45238 37.7441086284068 -122.385657039951 (37.7441086284068, -122.385657039951) 10 3 8 58 1
6002 65883 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3100X Fillmore St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/23/2013 12:00:00 AM 3   Permit Number 770126 6002440.42815 2118878.88214 37.7981747762893 -122.435637321312 (37.7981747762893, -122.435637321312) 13 9 1 57 17
6377 82142 Permitted Site 7 Ceratonia siliqua :: Carob 5 30 Molimo Dr 2 Sidewalk: Curb side : Cutout Tree Private 2   10/25/2007 12:00:00 AM   3x3 Permit Number 49838 5998889.06181671 2096571.98929044 37.736723332936 -122.446320512355 (37.736723332936, -122.446320512355) 9 7 4 59 40
6962 189948 DPW Maintained 1 Ceratonia siliqua :: Carob 5 162 Spear St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 1ft   6014781.22378 2116142.62721 37.7913548700732 -122.392742658052 (37.7913548700732, -122.392742658052) 12 2 9 28855 6
7794 78331 DPW Maintained 1 Ceratonia siliqua :: Carob 5 50 Pomona St 16 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6014103.03356 2094377.1679 37.7315539757311 -122.393565225657 (37.7315539757311, -122.393565225657) 10 3 8 58 1
8003 21791 Permitted Site 7 Ceratonia siliqua :: Carob 5 2585 Taylor St 6 Sidewalk: Curb side : Cutout Tree Private 2     8 4X4   6008347.28278 2121527.17705 37.8057800612465 -122.415385378175 (37.8057800612465, -122.415385378175) 5 1 10 308 23
8094 78325 DPW Maintained 1 Ceratonia siliqua :: Carob 5 50 Pomona St 22 Sidewalk: Curb side : Cutout Tree SFUSD 4 DPW for City Agency   3 3x3   6014082.07463 2094268.00581 37.7312530742586 -122.393630047885 (37.7312530742586, -122.393630047885) 10 3 8 58 1
8282 80561 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1820X Palou Ave 4 Sidewalk: Curb side : Cutout Tree Private 2 FUF   15     6013651.87309 2096197.81138 37.7365280090438 -122.395252475224 (37.7365280090438, -122.395252475224) 10 3 8 58 1

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