trees
856 rows where qSpecies_id = 5 sorted by qSiteInfo
This data as json, CSV (advanced)
PlotSize ✖
qCareAssistant ✖
- - 779
- FUF 71
- DPW for City Agency 6
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );