trees

856 rows where qSpecies_id = 5

✎ View and edit SQL

This data as json, CSV (advanced)

qCaretaker_id ✖

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)
109482 200192 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1008 Jamestown Ave 3 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   6013935.7075 2089708.6863 37.718725965018 -122.393817050636 (37.718725965018, -122.393817050636) 10 3 8 58 1
109810 115845 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Bay St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3   6003527.72894 2120738.72314 37.8033431135653 -122.432007819421 (37.8033431135653, -122.432007819421) 13 9 1 57 17
109930 16491 DPW Maintained 1 Ceratonia siliqua :: Carob 5 305X Newhall St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016683.07088 2098298.50072 37.7424641896573 -122.384918540359 (37.7424641896573, -122.384918540359) 10 3 8 58 1
109981 189920 DPW Maintained 1 Ceratonia siliqua :: Carob 5 338 Mission St 4 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6013751.03466 2115995.67684 37.7908941078228 -122.396296811166 (37.7908941078228, -122.396296811166) 12 2 9 28855 6
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
110285 32421 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2   10/08/1996 12:00:00 AM 12   Permit Number 36948 6000917.26502 2096711.23126 37.7372212865363 -122.439318125938 (37.7372212865363, -122.439318125938) 2 7 5 63 7
110444 97188 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 10 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
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
110855 114592 Undocumented 4 Ceratonia siliqua :: Carob 5 70 LOMITA AVE 2 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   5991433 2104626 37.7584089066312 -122.472686161822 (37.7584089066312, -122.472686161822) 1 8 4 56 12
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
111120 225061 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1289 Stanyan St 1 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 6ft   5997502.5049 2105021.09629 37.7598432128005 -122.451723726786 (37.7598432128005, -122.451723726786) 15 5 11 29492 12
111174 248263 DPW Maintained 1 Ceratonia siliqua :: Carob 5 140 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6006717.3063 2098747.87418 37.7431418122345 -122.419409127839 (37.7431418122345, -122.419409127839) 2 7 7 28859 2
111186 189933 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Fremont St 1 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6013208.14765 2116234.45684 37.7915195179644 -122.398191948892 (37.7915195179644, -122.398191948892) 12 2 9 28855 6
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
111400 248232 DPW Maintained 1 Ceratonia siliqua :: Carob 5 86 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 2ft   6006910.04538 2099108.75258 37.7441435571799 -122.418768273649 (37.7441435571799, -122.418768273649) 2 7 7 28859 2
111478 139056 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2693 SUTTER ST 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 0ft   5999748.2433 2113980.0087 37.7845704772917 -122.444600759792 (37.7845704772917, -122.444600759792) 15 6 11 29490 31
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
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
111983 206019 DPW Maintained 1 Ceratonia siliqua :: Carob 5 99 Merced Ave 2 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   5994816.51833 2099704.78199 37.7450917681756 -122.460627918846 (37.7450917681756, -122.460627918846) 1 8 4 59 40
112108 16517 Permitted Site 7 Ceratonia siliqua :: Carob 5 330 Newhall St 8 Sidewalk: Curb side : Cutout Tree Private 2     6 3X3   6016409.9700879 2098376.06541 37.7426620571468 -122.385868255606 (37.7426620571468, -122.385868255606) 10 3 8 58 1
112170 56845 Permitted Site 7 Ceratonia siliqua :: Carob 5 980 Clayton St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/02/1974 12:00:00 AM   4x4 Permit Number 14078 5998833.42862215 2106621.08669964 37.7643125198309 -122.447235885769 (37.7643125198309, -122.447235885769) 15 5 11 29492 9
112219 60684 Permitted Site 7 Ceratonia siliqua :: Carob 5 2969 23rd St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 03/05/1983 12:00:00 AM     Permit Number 20325 6009095.19054271 2102724.34950865 37.7541939732112 -122.411467881257 (37.7541939732112, -122.411467881257) 2 4 7 28859 19
112246 125993 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2501 Taylor St 7 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008342.47163 2121500.19485 37.8057057045282 -122.415400116539 (37.8057057045282, -122.415400116539) 5 1 10 308 23
112435 47241 Permitted Site 7 Ceratonia siliqua :: Carob 5 1000X Jamestown Ave 3 Sidewalk: Curb side : Cutout Tree Private 2 FUF 05/09/2002 12:00:00 AM 8 3x3 Permit Number 45190 6014093.2543098 2089771.82198012 37.718908077116 -122.393276886105 (37.718908077116, -122.393276886105) 10 3 8 58 1
112676 189950 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 Howard St 4 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 2ft   6014741.1957 2116062.87497 37.7911336656463 -122.392875573361 (37.7911336656463, -122.392875573361) 12 2 9 28855 6
112903 62270 Permitted Site 7 Ceratonia siliqua :: Carob 5 102 Webster St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 10/09/1985 12:00:00 AM     Permit Number 22404 6004290.78316217 2109110.18870614 37.7714573112605 -122.42853786595 (37.7714573112605, -122.42853786595) 7 9 11 28852 10
113085 58721 Permitted Site 7 Ceratonia siliqua :: Carob 5 66 Carmelita St 1 Sidewalk: Curb side : Cutout Tree Private 2   03/16/1981 12:00:00 AM     Permit Number 19065 6002629.53182761 2108749.25499909 37.7703721248343 -122.434258404788 (37.7703721248343, -122.434258404788) 15 5 5 29492 9
113265 59009 Permitted Site 7 Ceratonia siliqua :: Carob 5 3737 20th St 1 Sidewalk: Curb side : Cutout Tree Private 2   04/07/1980 12:00:00 AM 15 4x4 Permit Number 18300 6005405.85335043 2104274.1193379 37.758241653827 -122.424336755524 (37.758241653827, -122.424336755524) 2 4 5 28859 19
113408 139006 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1504 Lyon St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 0ft   5999695.1779 2114053.1244 37.7847682058679 -122.444789604899 (37.7847682058679, -122.444789604899) 15 6 1 29490 31
113438 16522 DPW Maintained 1 Ceratonia siliqua :: Carob 5 375 Newhall St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016298.51131 2098203.01239 37.7421807202532 -122.386241589372 (37.7421807202532, -122.386241589372) 10 3 8 58 1
113575 17433 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1900 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6013265.7394 2096489.52235 37.7373075045406 -122.396607955902 (37.7373075045406, -122.396607955902) 10 3 8 58 1
113987 189951 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 Howard St 5 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 1ft   6014728.34644 2116051.81938 37.7911025958469 -122.392919257911 (37.7911025958469, -122.392919257911) 12 2 9 28855 6
114352 248264 DPW Maintained 1 Ceratonia siliqua :: Carob 5 140 Lundy's Ln 2 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6006711.60121 2098736.37276 37.743109910586 -122.419428038785 (37.743109910586, -122.419428038785) 2 7 7 28859 2
114437 206015 DPW Maintained 1 Ceratonia siliqua :: Carob 5 351 Montecito Ave 1 Sidewalk: Curb side : Yard Tree Private 2     23 Width 3ft   5995922.8819 2094068.30815 37.7296789783055 -122.456394837862 (37.7296789783055, -122.456394837862) 9 7 4 28861 40
114608 189938 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Fremont St 7 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 5ft   6013289.37156 2116149.22674 37.7912900199673 -122.397904932091 (37.7912900199673, -122.397904932091) 12 2 9 28855 6
114719 6650 DPW Maintained 1 Ceratonia siliqua :: Carob 5 495X Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472) 10 3 8 58 1
114865 201371 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1 Hare St 1 Sidewalk: Curb side : Yard Tree Private 2     12     6018297.03999 2095334.93444 37.7344159629251 -122.379132069983 (37.7344159629251, -122.379132069983) 10 3 8 58 1
114975 115848 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3501 Laguna St 3 Sidewalk: Curb side : Cutout Tree Private 2     6 3x3   6003586.42591 2120801.53952 37.8035189184231 -122.431809184355 (37.8035189184231, -122.431809184355) 13 9 1 57 17
115220 115850 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3501 Laguna St 5 Sidewalk: Curb side : Cutout Tree Private 2     7 3x3   6003589.56269 2120774.48991 37.8034448250715 -122.431796396884 (37.8034448250715, -122.431796396884) 13 9 1 57 17
115285 222894 DPW Maintained 1 Ceratonia siliqua :: Carob 5 3080 16th St 1 Sidewalk: Curb side : Cutout Tree Private 2   06/14/1989 12:00:00 AM 14 Width 3ft Permit Number 27054 6006296.82054 2106727.45524 37.765028210007 -122.421429624803 (37.765028210007, -122.421429624803) 8 4 7 28853 19
115384 225080 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2823 21st St 2 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6009082.12028 2103902.99509 37.7574295349581 -122.411596352099 (37.7574295349581, -122.411596352099) 2 4 7 28859 19
115453 222918 DPW Maintained 1 Ceratonia siliqua :: Carob 5 140 Carl St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 Width 3ft   5997702.83236 2107152.93734 37.7657081802151 -122.451184638974 (37.7657081802151, -122.451184638974) 15 5 11 29492 9
115939 82092 Permitted Site 7 Ceratonia siliqua :: Carob 5 30 Molimo Dr 4 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
116296 182304 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2531 Kirkham St 4 Sidewalk: Curb side : Cutout Tree Private 2     3 Width 0ft   5986925.2797 2105029.7497 37.7592555273516 -122.488305322992 (37.7592555273516, -122.488305322992) 1 8 3 56 35
116533 138243 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1509 Lyon St 5 Sidewalk: Curb side : Cutout Tree Private 2     17 Width 0ft   5999648.5931 2114056.0979 37.7847737117432 -122.444950986247 (37.7847737117432, -122.444950986247) 15 6 1 29490 31
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
117426 17378 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1600 Palou Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6014792.92868 2095354.29337 37.7342752738796 -122.391248382303 (37.7342752738796, -122.391248382303) 10 3 8 58 1
117441 16485 Permitted Site 7 Ceratonia siliqua :: Carob 5 220 Newhall St 7 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6016885.6016222 2098308.357669 37.7425024549748 -122.384218928939 (37.7425024549748, -122.384218928939) 10 3 8 58 1
117653 205999 DPW Maintained 1 Ceratonia siliqua :: Carob 5 60 Chilton Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   6001682.52176 2095686.82759 37.7344520302196 -122.436598984369 (37.7344520302196, -122.436598984369) 2 7 5 63 7
117722 2513 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016387.51247 2098972.29453 37.7442979375022 -122.385987460765 (37.7442979375022, -122.385987460765) 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
117938 105930 Undocumented 4 Ceratonia siliqua :: Carob 5 971 Florida St   Sidewalk: Curb side : Cutout Tree Private 2       3x3   6009455 2103552.4 37.7564877890416 -122.410282026926 (37.7564877890416, -122.410282026926) 2 4 7 28859 19
118207 225062 DPW Maintained 1 Ceratonia siliqua :: Carob 5 139 Downey St 1 Sidewalk: Curb side : Cutout Tree Private 2     10 Width 3ft   5998883.5307 2107364.06639 37.7663554177878 -122.447116070946 (37.7663554177878, -122.447116070946) 15 5 11 29492 9
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
118594 199693 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1341 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 0ft   6016099.111 2092907.501 37.7276292724139 -122.386561894416 (37.7276292724139, -122.386561894416) 10 3 8 58 1
118720 17403 Permitted Site 7 Ceratonia siliqua :: Carob 5 1775 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     55 3x3   6013944.43098 2095916.733 37.7357724918668 -122.394221297579 (37.7357724918668, -122.394221297579) 10 3 8 58 1
119313 65609 DPW Maintained 1 Ceratonia siliqua :: Carob 5 259 Maynard St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 02/06/1990 12:00:00 AM 12   Permit Number 28514 6005079.93888 2093817.02687 37.7295104552453 -122.424720013038 (37.7295104552453, -122.424720013038) 9 7 6 28861 5
119539 60259 Permitted Site 7 Ceratonia siliqua :: Carob 5 900 Florida St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 08/26/1989 12:00:00 AM     Permit Number 28050 6009367.15001104 2103917.51160129 37.7574853782949 -122.410611626923 (37.7574853782949, -122.410611626923) 2 4 7 28859 19
119961 188486 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1525 Burke Ave 6 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6016667.7961 2098739.5766 37.7436744492327 -122.385002079878 (37.7436744492327, -122.385002079878) 10 3 8 58 1
120474 2514 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6016429.25086 2098939.95078 37.7442114380124 -122.385840882964 (37.7442114380124, -122.385840882964) 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
120772 51301 Permitted Site 7 Ceratonia siliqua :: Carob 5 101 Hyde St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 11/20/2004 12:00:00 AM     Permit Number 47670 6008105.70875607 2112751.56982087 37.7816708281319 -122.415599663608 (37.7816708281319, -122.415599663608) 7 10 9 28852 36
120815 93114 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Newhall St 6 Sidewalk: Curb side : Cutout Tree Private 2   02/02/2010 12:00:00 AM 6 3x3 Permit Number 53024 6016526.70747 2098382.71109 37.7426867642747 -122.385465070679 (37.7426867642747, -122.385465070679) 10 3 8 58 1
120839 206020 DPW Maintained 1 Ceratonia siliqua :: Carob 5 146 Castenada Ave 1 Sidewalk: Curb side : Yard Tree Private 2     6 Width 3ft   5994480.54768 2101060.81011 37.7487957447457 -122.461887948175 (37.7487957447457, -122.461887948175) 1 8 4 29491 40
120856 63118 Permitted Site 7 Ceratonia siliqua :: Carob 5 70 Lundy's Ln 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 12/08/1986 12:00:00 AM     Permit Number 23625 6006935.01451866 2099174.11524824 37.7443244342333 -122.418686569992 (37.7443244342333, -122.418686569992) 2 7 7 28859 2
121999 18922 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2620 SACRAMENTO ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6002038.8 2115762.8 37.7895960030005 -122.436803887406 (37.7895960030005, -122.436803887406) 13 6 1 29490 27
122285 107150 DPW Maintained 1 Ceratonia siliqua :: Carob 5 219 Missouri St 1 Sidewalk: Curb side : Cutout Tree Private 2     15 5x5   6013483.53646 2106027.96623 37.7635101499066 -122.396523344982 (37.7635101499066, -122.396523344982) 14 3 8 28856 29
122418 2519 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016516.51157 2098877.59586 37.7440450526322 -122.385534806811 (37.7440450526322, -122.385534806811) 10 3 8 58 1
122504 18864 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2230 Sacramento St 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6003886.2489 2116004.41909 37.7903642506674 -122.430429154879 (37.7903642506674, -122.430429154879) 13 9 1 29490 27
122812 23566 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2958 Van Ness Ave 2 Sidewalk: Curb side : Cutout Tree Private 2   06/09/2005 12:00:00 AM 6     6005632.06356 2120580.68582 37.8030282582004 -122.424714436346 (37.8030282582004, -122.424714436346) 5 9 1 28858 32
122903 125992 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2501 Taylor St 6 Sidewalk: Curb side : Cutout Tree Private 2     9 Width 3ft   6008341.11218 2121531.47257 37.8057915088426 -122.415407036818 (37.8057915088426, -122.415407036818) 5 1 10 308 23
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
123100 56925 DPW Maintained 1 Ceratonia siliqua :: Carob 5 120 Howard St 1 Sidewalk: Curb side : Cutout Tree Private 2   08/15/1974 12:00:00 AM 12   Permit Number 14168 6014784.53223 2116103.90747 37.7912487383869 -122.392728500917 (37.7912487383869, -122.392728500917) 12 2 9 28855 6
123202 2510 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1501 Burke Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016682.7889975 2098765.8378067 37.743747386446 -122.384952066789 (37.743747386446, -122.384952066789) 10 3 8 58 1
123502 59722 Permitted Site 7 Ceratonia siliqua :: Carob 5 2905 21st St 1 Sidewalk: Curb side : Cutout Tree Private 2 FUF 09/14/1984 12:00:00 AM     Permit Number 19154 6008831.83417105 2103879.56302809 37.757351153159 -122.41246028798 (37.757351153159, -122.41246028798) 2 4 7 28859 19
123765 189939 DPW Maintained 1 Ceratonia siliqua :: Carob 5 28 Fremont St 8 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 5ft   6013302.11078 2116136.01551 37.7912544544909 -122.397859927289 (37.7912544544909, -122.397859927289) 12 2 9 28855 6
123783 2521 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016567.75907 2098840.98498 37.7439473619958 -122.385355052105 (37.7439473619958, -122.385355052105) 10 3 8 58 1
124051 248207 DPW Maintained 1 Ceratonia siliqua :: Carob 5 39 Lundy's Ln 2 Sidewalk: Curb side : Cutout Tree Private 2     8 Width 3ft   6007026.81239 2099268.29908 37.7445882098712 -122.418375828376 (37.7445882098712, -122.418375828376) 2 7 7 28859 2
124058 225092 DPW Maintained 1 Ceratonia siliqua :: Carob 5 66 Carmelita St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 3ft   6002638.75231 2108633.09345 37.7700536971488 -122.434218205527 (37.7700536971488, -122.434218205527) 15 5 5 29492 9
124374 97181 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 3 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
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
124477 189963 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1000 Brannan St 5 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 3ft   6010349.36768 2108372.96344 37.7697740574441 -122.40752882731 (37.7697740574441, -122.40752882731) 8 2 9 28853 34
124717 20967 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2002X Sunset Blvd 7 Sidewalk: Curb side : Cutout Tree DPW 1     3 40   5984887.6165706 2101567.3225095 37.7496295616808 -122.495097123245 (37.7496295616808, -122.495097123245) 1 8 3 29491 35
124745 2499 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Burke Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016750.97009 2098814.51662 37.7438848195436 -122.384719700863 (37.7438848195436, -122.384719700863) 10 3 8 58 1
124822 111888 Undocumented 4 Ceratonia siliqua :: Carob 5 140 LUNDYS LN 3 Sidewalk: Curb side : Cutout Tree Private 2       3x12   6006709 2098750 37.7431471814186 -122.41943799965 (37.7431471814186, -122.41943799965) 2 7 7 28859 2
124920 125982 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 3 Sidewalk: Curb side : Cutout Tree Private 2     19 Width 6ft   6008379.56749 2121591.49972 37.8059584895516 -122.415278208017 (37.8059584895516, -122.415278208017) 5 1 10 308 23
125723 188487 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1525 Burke Ave 7 Sidewalk: Curb side : Cutout Tree Private 2     6 Width 3ft   6016679.39003 2098723.90702 37.7436320650598 -122.384960899022 (37.7436320650598, -122.384960899022) 10 3 8 58 1
125848 125983 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550 Taylor St 4 Sidewalk: Curb side : Cutout Tree Private 2     14 Width 5ft   6008377.32314 2121617.1276 37.8060287311026 -122.415287790321 (37.8060287311026, -122.415287790321) 5 1 10 308 23
126551 125995 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2501 Taylor St 9 Sidewalk: Curb side : Cutout Tree Private 2     12 Width 3ft   6008349.66203 2121453.17315 37.8055769989413 -122.415371902112 (37.8055769989413, -122.415371902112) 5 1 10 308 23
126809 2500 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Burke Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016728.12134 2098825.14197 37.7439127309012 -122.384799447345 (37.7439127309012, -122.384799447345) 10 3 8 58 1
127110 103340 Undocumented 4 Ceratonia siliqua :: Carob 5 590X 09th St 2 Sidewalk: Curb side : Cutout Tree Private 2     9 3x3 Permit Number 772809 6010323 2108639 37.7705030566796 -122.407638793146 (37.7705030566796, -122.407638793146) 8 2 9 28853 34
127764 97182 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 4 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
127978 225055 DPW Maintained 1 Ceratonia siliqua :: Carob 5 348 Sussex St 1 Sidewalk: Curb side : Cutout Tree Private 2     13 Width 2ft   6001114.83392 2096694.1461 37.7371856158122 -122.438633817409 (37.7371856158122, -122.438633817409) 2 7 5 63 7
128143 16515 DPW Maintained 1 Ceratonia siliqua :: Carob 5 330 Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016409.9700879 2098376.06541 37.7426620571468 -122.385868255606 (37.7426620571468, -122.385868255606) 10 3 8 58 1
128316 206000 DPW Maintained 1 Ceratonia siliqua :: Carob 5 419 Flood Ave 3 Sidewalk: Property side : Yard Tree Private 2     7     5997987.32263 2094070.28162 37.7298026971396 -122.449258019538 (37.7298026971396, -122.449258019538) 9 7 4 28861 40
128485 97184 Undocumented 4 Ceratonia siliqua :: Carob 5 10X Fremont St 6 Sidewalk: Curb side : Cutout Tree Private 2     5 3x3   6013138 2116168 37.791333135618 -122.398429995238 (37.791333135618, -122.398429995238) 12 2 9 28855 6
129067 51546 Permitted Site 7 Ceratonia siliqua :: Carob 5 655 Beach St 1 Sidewalk: Curb side : Cutout Tree Private 2   02/01/2005 12:00:00 AM     Permit Number 47845 6007074.31830792 2121880.33708987 37.8066781199827 -122.419815746942 (37.8066781199827, -122.419815746942) 5 1 1 28858 32
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

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