178 rows where qCaretaker_id = 1 and qSpecies_id = 5

View and edit SQL

qCaretaker_id

  • DPW · 78
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)
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
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
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
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
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
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
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
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
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
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
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
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
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
129987 16525 DPW Maintained 1 Ceratonia siliqua :: Carob 5 375 Newhall St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016336.59711 2098251.27907 37.7423153586798 -122.386113263318 (37.7423153586798, -122.386113263318) 10 3 8 58 1
131158 5479 DPW Maintained 1 Ceratonia siliqua :: Carob 5 695 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     20 8   6005031.79334 2104320.15384 37.758346924379 -122.425633695438 (37.758346924379, -122.425633695438) 2 4 5 28859 19
131181 16524 DPW Maintained 1 Ceratonia siliqua :: Carob 5 375 Newhall St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016323.68687 2098236.56346 37.7422742380775 -122.386156877755 (37.7422742380775, -122.386156877755) 10 3 8 58 1
132298 16502 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016450.0254075 2098336.1941649 37.7425547953869 -122.385726976255 (37.7425547953869, -122.385726976255) 10 3 8 58 1
132813 16493 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1   12/03/1992 12:00:00 AM 3 3X3   6016616 2098292 37.7424426300051 -122.385150000825 (37.7424426300051, -122.385150000825) 10 3 8 58 1
135227 21781 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550X Taylor St 1 Sidewalk: Curb side : Cutout Tree DPW 1   08/12/2011 12:00:00 AM 3 4x4   6008458.56586 2121488.77145 37.8056808631332 -122.41499754514 (37.8056808631332, -122.41499754514) 3 1 10 308 23
135231 16505 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016450.0254075 2098336.1941649 37.7425547953869 -122.385726976255 (37.7425547953869, -122.385726976255) 10 3 8 58 1
135682 189909 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 10 Sidewalk: Curb side : Cutout Tree DPW 1     9 Width 3ft   6016264.27306 2098246.63974 37.7422986168968 -122.386363016745 (37.7422986168968, -122.386363016745) 10 3 8 58 1
136729 16519 DPW Maintained 1 Ceratonia siliqua :: Carob 5 330 Newhall St 10 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6016409.9700879 2098376.06541 37.7426620571468 -122.385868255606 (37.7426620571468, -122.385868255606) 10 3 8 58 1
137043 6850 DPW Maintained 1 Ceratonia siliqua :: Carob 5 595X Newhall St 7 Sidewalk: Curb side : Cutout Tree DPW 1   01/22/1998 12:00:00 AM 12 3x3   6015895.1615953 2097662.6258274 37.7406745956723 -122.387598567026 (37.7406745956723, -122.387598567026) 10 3 8 58 1
139429 2541 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1575 Burke Ave 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016218.6051359 2099112.8628025 37.7446745598911 -122.386581311559 (37.7446745598911, -122.386581311559) 10 3 8 58 1
140399 6648 DPW Maintained 1 Ceratonia siliqua :: Carob 5 495X Newhall St 4 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
140473 11180 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2750X Hyde St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6006892.18437 2121805.14198 37.806461391357 -122.420440716763 (37.806461391357, -122.420440716763) 5 1 1 28858 32
142913 21795 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2598 Taylor St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6008439.13676 2121624.27905 37.8060518410095 -122.415074380155 (37.8060518410095, -122.415074380155) 3 1 10 308 23
145080 16513 DPW Maintained 1 Ceratonia siliqua :: Carob 5 330 Newhall St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016404.80629 2098376.61978 37.7426632935725 -122.385886149327 (37.7426632935725, -122.385886149327) 10 3 8 58 1
145684 21794 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2598 Taylor St 3 Sidewalk: Curb side : Cutout Tree DPW 1     21 4X4   6008439.13676 2121624.27905 37.8060518410095 -122.415074380155 (37.8060518410095, -122.415074380155) 3 1 10 308 23
146541 17437 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1919 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     40 3X3   6013108.75457 2096537.612 37.7374308105776 -122.397154099803 (37.7374308105776, -122.397154099803) 10 3 8 58 1
146708 116858 DPW Maintained 1 Ceratonia siliqua :: Carob 5 180 NOE ST 1 Sidewalk: Curb side : Cutout Tree DPW 1     14 3x3   6002788 2107242 37.7662425648461 -122.433602528192 (37.7662425648461, -122.433602528192) 15 5 5 28862 3
149371 14911 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6017284.29114 2098190.72199 37.7422014869413 -122.38283218039 (37.7422014869413, -122.38283218039) 10 3 8 58 1
149727 2515 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016446.65639 2098928.8879 37.7441820247861 -122.385779926925 (37.7441820247861, -122.385779926925) 10 3 8 58 1
149886 5523 DPW Maintained 1 Ceratonia siliqua :: Carob 5 865 Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     50 3X3   6005084.41522 2103351.40166 37.7556899313628 -122.425382766602 (37.7556899313628, -122.425382766602) 2 4 5 28859 19
151412 2504 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Burke Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016654.18712 2098861.64491 37.7440088711085 -122.385057640012 (37.7440088711085, -122.385057640012) 10 3 8 58 1
155081 2536 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1575 Burke Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016262.66893 2099065.69559 37.744547487686 -122.38642565812 (37.744547487686, -122.38642565812) 10 3 8 58 1
158664 189901 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 1 Sidewalk: Curb side : Cutout Tree DPW 1     7 Width 3ft   6016452.46192 2098385.21634 37.7426895350994 -122.385721967406 (37.7426895350994, -122.385721967406) 10 3 8 58 1
158939 17414 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1820X Palou Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6013664.43707 2096187.44321 37.7365002389252 -122.395208309826 (37.7365002389252, -122.395208309826) 10 3 8 58 1
161350 2503 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Burke Ave 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016672.43224 2098847.72364 37.7439716553617 -122.384993582204 (37.7439716553617, -122.384993582204) 10 3 8 58 1
163249 189904 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 4 Sidewalk: Curb side : Cutout Tree DPW 1     11 Width 3ft   6016400.23461 2098374.6941 37.7426577530525 -122.385901822825 (37.7426577530525, -122.385901822825) 10 3 8 58 1
164263 6649 DPW Maintained 1 Ceratonia siliqua :: Carob 5 495X Newhall St 5 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
164425 4913 DPW Maintained 1 Ceratonia siliqua :: Carob 5 195X Newhall St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6017015.0972074 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687) 10 3 8 58 1
164547 14929 DPW Maintained 1 Ceratonia siliqua :: Carob 5 320X Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016461.7664057 2098387.7906821 37.7426971185746 -122.385689974252 (37.7426971185746, -122.385689974252) 10 3 8 58 1
165394 17387 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1657 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6014551.02447 2095461.01119 37.7345548713079 -122.392092190109 (37.7345548713079, -122.392092190109) 10 3 8 58 1
165477 4918 DPW Maintained 1 Ceratonia siliqua :: Carob 5 195X Newhall St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017015.0972074 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687) 10 3 8 58 1
166537 6646 DPW Maintained 1 Ceratonia siliqua :: Carob 5 495X Newhall St 2 Sidewalk: Curb side : Cutout Tree DPW 1   04/01/1990 12:00:00 AM 18 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472) 10 3 8 58 1
166582 14918 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 12 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017351.5544479 2098138.8848753 37.7420628687633 -122.382595996286 (37.7420628687633, -122.382595996286) 10 3 8 58 1
167263 14924 DPW Maintained 1 Ceratonia siliqua :: Carob 5 320X Newhall St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016461.7664057 2098387.7906821 37.7426971185746 -122.385689974252 (37.7426971185746, -122.385689974252) 10 3 8 58 1
167962 189908 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1     8 Width 3ft   6016294.30511 2098287.70361 37.7424130322313 -122.38626203637 (37.7424130322313, -122.38626203637) 10 3 8 58 1
168028 16541 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400X Newhall St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6016112.61616 2098044.40161 37.7417349164267 -122.386873303758 (37.7417349164267, -122.386873303758) 10 3 8 58 1
168615 4389 DPW Maintained 1 Ceratonia siliqua :: Carob 5 56 Chilton Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   06/09/2008 12:00:00 AM 30 3x3   6001657.8215553 2095631.9001159 37.7342998083721 -122.436680450501 (37.7342998083721, -122.436680450501) 2 7 5 63 7
169044 16510 DPW Maintained 1 Ceratonia siliqua :: Carob 5 330 Newhall St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016409.9700879 2098376.06541 37.7426620571468 -122.385868255606 (37.7426620571468, -122.385868255606) 10 3 8 58 1
169246 14640 DPW Maintained 1 Ceratonia siliqua :: Carob 5 600X McAllister St 3 Sidewalk: Curb side : Cutout Tree DPW 1     18 4x4   6006169.26455 2112150.7692 37.779912136471 -122.422256155719 (37.779912136471, -122.422256155719) 7 9 11 28852 41
170549 16497 DPW Maintained 1 Ceratonia siliqua :: Carob 5 305X Newhall St 8 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6016834.58957 2098268.17724 37.7423893070591 -122.384392517318 (37.7423893070591, -122.384392517318) 10 3 8 58 1
173492 16554 DPW Maintained 1 Ceratonia siliqua :: Carob 5 500X Newhall St 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016006.287148 2097894.9109735 37.7413185578473 -122.387230532448 (37.7413185578473, -122.387230532448) 10 3 8 58 1
173950 16516 DPW Maintained 1 Ceratonia siliqua :: Carob 5 330 Newhall St 7 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
175193 16501 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016450.0254075 2098336.1941649 37.7425547953869 -122.385726976255 (37.7425547953869, -122.385726976255) 10 3 8 58 1
175245 2498 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Burke Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016761.82696 2098799.80324 37.7438450200413 -122.384681135251 (37.7438450200413, -122.384681135251) 10 3 8 58 1
175440 7419 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1090 Folsom St 3 Sidewalk: Curb side : Cutout Tree DPW 1     50 3X3   6010341.13591 2111005.37017 37.777001575706 -122.407742942642 (37.777001575706, -122.407742942642) 14 2 9 28853 34
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
176301 21784 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2550X Taylor St 4 Sidewalk: Curb side : Cutout Tree DPW 1   02/11/2016 12:00:00 AM 12 4X4   6008458.56586 2121488.77145 37.8056808631332 -122.41499754514 (37.8056808631332, -122.41499754514) 3 1 10 308 23
177283 16490 DPW Maintained 1 Ceratonia siliqua :: Carob 5 305X Newhall St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016659.29203 2098304.79019 37.7424801439961 -122.385001199414 (37.7424801439961, -122.385001199414) 10 3 8 58 1
177736 14931 DPW Maintained 1 Ceratonia siliqua :: Carob 5 320X Newhall St 8 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016461.7664057 2098387.7906821 37.7426971185746 -122.385689974252 (37.7426971185746, -122.385689974252) 10 3 8 58 1
179658 2505 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1501 Burke Ave 1 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
180338 14917 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017157.89779 2098250.45331 37.7423585130106 -122.383273370488 (37.7423585130106, -122.383273370488) 10 3 8 58 1
182657 5384 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325X Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     90 4X4   6004919.4864142 2106495.5645768 37.7643137401636 -122.426176974515 (37.7643137401636, -122.426176974515) 8 4 5 28859 19
183470 4916 DPW Maintained 1 Ceratonia siliqua :: Carob 5 195X Newhall St 5 Sidewalk: Curb side : Cutout Tree DPW 1   01/26/2015 05:46:00 AM 3 3X3   6017015.0972074 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687) 10 3 8 58 1
183957 16509 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 11 Sidewalk: Curb side : Cutout Tree DPW 1   12/03/1992 12:00:00 AM 3 3X3   6016661.92107 2098301.48789 37.742471221974 -122.384991878867 (37.742471221974, -122.384991878867) 10 3 8 58 1
185290 4919 DPW Maintained 1 Ceratonia siliqua :: Carob 5 195X Newhall St 8 Sidewalk: Curb side : Cutout Tree DPW 1   05/11/2016 12:00:00 AM 12 3X3   6017015.0972074 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687) 10 3 8 58 1
186991 16521 DPW Maintained 1 Ceratonia siliqua :: Carob 5 375 Newhall St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016284.3157 2098184.69928 37.7421296504552 -122.386289397351 (37.7421296504552, -122.386289397351) 10 3 8 58 1
187922 10409 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1398 HAIGHT ST 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 3x3   5999436 2108778 37.7702692735678 -122.445306860847 (37.7702692735678, -122.445306860847) 15 5 11 29492 9
191303 14915 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017191.33538 2098236.4203 37.7423218290085 -122.383156775767 (37.7423218290085, -122.383156775767) 10 3 8 58 1
191865 2511 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1501 Burke Ave 7 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
192875 2502 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Burke Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016691.63378 2098834.3481 37.743935990944 -122.38492625536 (37.743935990944, -122.38492625536) 10 3 8 58 1
192927 16499 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016428.13466 2098327.93774 37.7425309135822 -122.385802093385 (37.7425309135822, -122.385802093385) 10 3 8 58 1

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