83 rows where PlotSize = "Width 4ft" and qSpecies_id = 5

View and edit SQL

PlotSize

  • Width 4ft · 83
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)
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
4441 246422 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Duncan St 4 Sidewalk: Curb side : Yard Tree Private 2     9 Width 4ft   6003829.35465 2099854.81871 37.7460181445246 -122.429473817668 (37.7460181445246, -122.429473817668) 2 7 5 63 22
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
9018 126003 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2510 Jones St 8 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6007892.37102 2121599.81603 37.8059539308952 -122.416964822665 (37.8059539308952, -122.416964822665) 5 1 10 308 23
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
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
16205 222929 DPW Maintained 1 Ceratonia siliqua :: Carob 5 979 Ashbury St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/21/1979 12:00:00 AM 10 Width 4ft Permit Number 17592 5999199.8898 2106672.6396 37.7644750037296 -122.445972112616 (37.7644750037296, -122.445972112616) 15 5 11 29492 9
16559 222925 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1025 Clayton St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   5998825.08997 2106348.09575 37.7635624787486 -122.447245077795 (37.7635624787486, -122.447245077795) 15 5 11 29492 9
18852 222928 DPW Maintained 1 Ceratonia siliqua :: Carob 5 912 Clayton St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   5998758.16977 2106859.07637 37.7649616790718 -122.447513315894 (37.7649616790718, -122.447513315894) 15 5 11 29492 9
26621 222916 DPW Maintained 1 Ceratonia siliqua :: Carob 5 92 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6004301.92294 2109033.13825 37.7712463798496 -122.428493839936 (37.7712463798496, -122.428493839936) 7 9 11 28852 10
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
32299 222920 DPW Maintained 1 Ceratonia siliqua :: Carob 5 957 Cole St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   5998076.5165 2106905.97838 37.765051481758 -122.449874352843 (37.765051481758, -122.449874352843) 15 5 11 29492 9
35932 222922 DPW Maintained 1 Ceratonia siliqua :: Carob 5 848 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   5998725.13711 2107078.63003 37.7655626303238 -122.44764337315 (37.7655626303238, -122.44764337315) 15 5 11 29492 9
37876 125979 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500 Taylor St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6008389.02756 2121512.5692 37.8057422979318 -122.41523987894 (37.8057422979318, -122.41523987894) 5 1 10 308 23
41601 222917 DPW Maintained 1 Ceratonia siliqua :: Carob 5 88 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6004303.69708 2109018.65394 37.7712067098536 -122.428486670528 (37.7712067098536, -122.428486670528) 7 9 11 28852 10
47090 222910 DPW Maintained 1 Ceratonia siliqua :: Carob 5 363 Page St 7 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6004846.32395 2109834.20253 37.7734767003282 -122.426667787188 (37.7734767003282, -122.426667787188) 7 9 11 28852 10
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
52442 188480 DPW Maintained 1 Ceratonia siliqua :: Carob 5 209 Arkansas St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6012920.54855 2106035.89651 37.7635005775036 -122.398471110175 (37.7635005775036, -122.398471110175) 14 3 8 28856 29
55436 126001 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2510 Jones St 6 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6007899.07258 2121560.79928 37.8058471777553 -122.41693886466 (37.8058471777553, -122.41693886466) 5 1 10 308 23
56518 237914 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1001 Stanyan St 1 Sidewalk: Curb side : Cutout Tree DPW 1     21 Width 4ft   5997227 2107052 37.7654037766697 -122.452823145368 (37.7654037766697, -122.452823145368) 15 5 11 29492 12
57257 189907 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 8 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6016312.90853 2098309.60993 37.7424742122044 -122.386199237601 (37.7424742122044, -122.386199237601) 10 3 8 58 1
60894 246420 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Duncan St 2 Sidewalk: Curb side : Yard Tree Private 2     5 Width 4ft   6003851.19686 2099854.61267 37.7460188154337 -122.429398275524 (37.7460188154337, -122.429398275524) 2 7 5 63 22
63341 189955 DPW Maintained 1 Ceratonia siliqua :: Carob 5 145 Main St 2 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6014561.09202 2115949.59191 37.790812611275 -122.393490799583 (37.790812611275, -122.393490799583) 12 2 9 28855 6
63609 222900 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3733 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6005413.47026 2104278.82733 37.7582550109751 -122.424310747749 (37.7582550109751, -122.424310747749) 2 4 5 28859 19
64795 225045 DPW Maintained 1 Ceratonia siliqua :: Carob 5 881 Alabama St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6009145.12233 2103987.25914 37.7576644387915 -122.411384417877 (37.7576644387915, -122.411384417877) 2 4 7 28859 19
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
66277 222890 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2761 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6009529.18788 2103922.95806 37.757509416346 -122.4100516172 (37.757509416346, -122.4100516172) 2 4 7 28859 19
67065 222911 DPW Maintained 1 Ceratonia siliqua :: Carob 5 363 Page St 8 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6004864.94155 2109835.08183 37.7734801672159 -122.426603448797 (37.7734801672159, -122.426603448797) 7 9 11 28852 10
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
67782 125998 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2510 Jones St 3 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6007907.02571 2121498.39071 37.8056762669961 -122.416906917118 (37.8056762669961, -122.416906917118) 5 1 10 308 23
69631 189954 DPW Maintained 1 Ceratonia siliqua :: Carob 5 145 Main St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6014570.20304 2115942.2831 37.7907930492013 -122.393458763924 (37.7907930492013, -122.393458763924) 12 2 9 28855 6
69905 222921 DPW Maintained 1 Ceratonia siliqua :: Carob 5 957 Cole St 2 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   5998078.46928 2106885.24351 37.7649946607859 -122.449866104246 (37.7649946607859, -122.449866104246) 15 5 11 29492 9
71557 125966 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2198 Filbert St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6002473.45784 2118854.30827 37.7981091788388 -122.435521270088 (37.7981091788388, -122.435521270088) 13 9 1 57 17
72128 225047 DPW Maintained 1 Ceratonia siliqua :: Carob 5 971 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6009431.36633 2103539.27108 37.7564504151646 -122.410362833886 (37.7564504151646, -122.410362833886) 2 4 7 28859 19
75395 125996 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2510 Jones St 1 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6007913.10752 2121457.27998 37.8055637294392 -122.41688295558 (37.8055637294392, -122.41688295558) 5 1 10 308 23
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
77058 222893 DPW Maintained 1 Ceratonia siliqua :: Carob 5 301 Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 Width 4ft   6004914.2278 2106488.73534 37.7642946914815 -122.426194676362 (37.7642946914815, -122.426194676362) 8 4 5 28859 19
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
87824 125999 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2510 Jones St 4 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6007905.9664 2121521.7786 37.8057404246312 -122.416912241104 (37.8057404246312, -122.416912241104) 5 1 10 308 23
95691 225059 DPW Maintained 1 Ceratonia siliqua :: Carob 5 245 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     20 Width 4ft   5997024.32382 2107012.23049 37.7652829636624 -122.453521279988 (37.7652829636624, -122.453521279988) 15 5 11 29492 12
96630 222908 DPW Maintained 1 Ceratonia siliqua :: Carob 5 363 Page St 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 4ft   6004803.10417 2109829.19919 37.773460518813 -122.426816934368 (37.773460518813, -122.426816934368) 7 9 11 28852 10
98799 126000 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2510 Jones St 5 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6007902.73328 2121542.33791 37.8057966934257 -122.416924887385 (37.8057966934257, -122.416924887385) 5 1 10 308 23
99121 125970 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2301 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6003734.22562 2115934.13704 37.7901626613254 -122.430950126753 (37.7901626613254, -122.430950126753) 13 9 1 29490 27
104673 222889 DPW Maintained 1 Ceratonia siliqua :: Carob 5 81 Webster St 1 Sidewalk: Curb side : Yard Tree Private 2     12 Width 4ft   6004268.74767 2108942.84192 37.7709965706599 -122.428602156987 (37.7709965706599, -122.428602156987) 7 9 11 29492 10
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
110010 222924 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1025 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   5998822.08068 2106365.67219 37.763610567293 -122.447256751019 (37.763610567293, -122.447256751019) 15 5 11 29492 9
110454 246421 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Duncan St 3 Sidewalk: Curb side : Yard Tree Private 2     7 Width 4ft   6003840.65408 2099855.19689 37.7460198226686 -122.429434772709 (37.7460198226686, -122.429434772709) 2 7 5 63 22
111387 222904 DPW Maintained 1 Ceratonia siliqua :: Carob 5 363 Page St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6004715.38798 2109818.79814 37.7734270001802 -122.427119616485 (37.7734270001802, -122.427119616485) 7 9 11 28852 10
111673 222927 DPW Maintained 1 Ceratonia siliqua :: Carob 5 912 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 4ft   5998760.52748 2106841.60616 37.764913845009 -122.44750390358 (37.764913845009, -122.44750390358) 15 5 11 29492 9
116588 222905 DPW Maintained 1 Ceratonia siliqua :: Carob 5 363 Page St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6004739.78961 2109820.49268 37.7734330328342 -122.427035328438 (37.7734330328342, -122.427035328438) 7 9 11 28852 10
117059 222915 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6004287.81752 2109130.32918 37.7715124442731 -122.42854956012 (37.7715124442731, -122.42854956012) 7 9 11 28852 10
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
118217 189906 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 7 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6016329.85018 2098328.36686 37.7425266525877 -122.386141965188 (37.7425266525877, -122.386141965188) 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
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
129163 205988 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1469 09th Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   5993333.43827 2105504.18267 37.7609299931406 -122.466177475131 (37.7609299931406, -122.466177475131) 1 8 4 56 12
131190 126002 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2510 Jones St 7 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6007897.34981 2121579.98706 37.8058997656297 -122.416946186927 (37.8058997656297, -122.416946186927) 5 1 10 308 23
132144 222926 DPW Maintained 1 Ceratonia siliqua :: Carob 5 980 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   5998842.04298 2106555.36385 37.7641325536076 -122.447201360861 (37.7641325536076, -122.447201360861) 15 5 11 29492 9
138379 222901 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500 19th St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6010350.92768 2105070.60578 37.7607066222297 -122.407290598708 (37.7607066222297, -122.407290598708) 10 4 8 28859 19
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
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
145445 222923 DPW Maintained 1 Ceratonia siliqua :: Carob 5 88 Parnassus Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   5998162.74598 2106870.63901 37.7649593821837 -122.449573561064 (37.7649593821837, -122.449573561064) 15 5 11 29492 9
147007 222888 DPW Maintained 1 Ceratonia siliqua :: Carob 5 109 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 4ft   6004218 2109157 37.7715817245566 -122.428792964354 (37.7715817245566, -122.428792964354) 7 9 11 29492 10
148016 222902 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500 19th St 2 Sidewalk: Curb side : Cutout Tree Private 2     16 Width 4ft   6010304.7702 2105067.63235 37.760695874438 -122.407450027813 (37.760695874438, -122.407450027813) 10 4 8 28859 19
151186 222896 DPW Maintained 1 Ceratonia siliqua :: Carob 5 115 Julian Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     18 Width 4ft   6006441.81181 2107164.43854 37.7662362369242 -122.420959163358 (37.7662362369242, -122.420959163358) 8 4 7 28853 19
152398 125977 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 4ft   6008401.62888 2121444.29683 37.8055555474172 -122.415191434251 (37.8055555474172, -122.415191434251) 5 1 10 308 23
154326 175840 DPW Maintained 1 Ceratonia siliqua :: Carob 5 658 Edinburgh St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6002330.91523 2089965.9471 37.7187806097236 -122.433948484453 (37.7187806097236, -122.433948484453) 9 7 6 28861 5
154655 125978 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500 Taylor St 2 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 4ft   6008392.85025 2121496.40648 37.8056981340166 -122.415225505068 (37.8056981340166, -122.415225505068) 5 1 10 308 23
155575 222907 DPW Maintained 1 Ceratonia siliqua :: Carob 5 363 Page St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6004783.41695 2109826.60113 37.7734522720333 -122.426884850272 (37.7734522720333, -122.426884850272) 7 9 11 28852 10
158043 222892 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2751 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 4ft   6009588.6552 2103924.1994 37.7575161576583 -122.409846042069 (37.7575161576583, -122.409846042069) 2 4 7 28859 19
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
166050 222891 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2759 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   6009566.16928 2103923.02169 37.7575116637409 -122.409923724614 (37.7575116637409, -122.409923724614) 2 4 7 28859 19
168987 222912 DPW Maintained 1 Ceratonia siliqua :: Carob 5 363 Page St 9 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 4ft   6004886.98291 2109837.99569 37.7734894140273 -122.42652741201 (37.7734894140273, -122.42652741201) 7 9 11 28852 10
171993 225042 DPW Maintained 1 Ceratonia siliqua :: Carob 5 979 Ashbury St 2 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 4ft   5999193.16537 2106656.55415 37.7644304531311 -122.445994213458 (37.7644304531311, -122.445994213458) 15 5 11 29492 9
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
172941 225057 DPW Maintained 1 Ceratonia siliqua :: Carob 5 360 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 4ft   6001062.01743 2096696.77883 37.7371898399477 -122.438816616317 (37.7371898399477, -122.438816616317) 2 7 5 63 7
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
178863 125997 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2510 Jones St 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 4ft   6007910.60432 2121475.90892 37.8056147389887 -122.416892938958 (37.8056147389887, -122.416892938958) 5 1 10 308 23
184994 225046 DPW Maintained 1 Ceratonia siliqua :: Carob 5 901 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 4ft   6009412.50008 2103884.66728 37.7573977376442 -122.41045246843 (37.7573977376442, -122.41045246843) 2 4 7 28859 19
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
187721 125971 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 4ft   6008148.4886 2112831.14919 37.7818917385495 -122.415457300812 (37.7818917385495, -122.415457300812) 7 10 9 28852 36
192717 222909 DPW Maintained 1 Ceratonia siliqua :: Carob 5 363 Page St 6 Sidewalk: Curb side : Cutout Tree Private 2     2 Width 4ft   6004826.79581 2109830.90843 37.7734665514719 -122.426735103265 (37.7734665514719, -122.426735103265) 7 9 11 28852 10
192924 125980 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 4ft   6008387.31056 2121533.89692 37.8058007619722 -122.415247331605 (37.8058007619722, -122.415247331605) 5 1 10 308 23

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