293 rows where Police Districts = 3 and qSpecies_id = 5 sorted by PlantDate

View and edit SQL

Police Districts

rowid TreeID qLegalStatus_id qSpecies_id qAddress SiteOrder qSiteInfo PlantType qCaretaker_id qCareAssistant PlantDate ▼ DBH PlotSize PermitNotes XCoord YCoord Latitude Longitude Location Fire Prevention Districts Police Districts Supervisor Districts Zip Codes Neighborhoods (old)
372 189871 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400 Newhall St 9 : Tree Private 2     7 Width 3ft   6016028.58203 2097927.48174 37.7414092251604 -122.387155715173 (37.7414092251604, -122.387155715173) 10 3 8 58 1
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
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
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
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
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
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
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
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
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
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
13958 262096 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 3 Sidewalk: Curb side : Cutout Tree DPW 1       Width 3ft   6016433.67399 2098382.99048 37.7426823836985 -122.385786776164 (37.7426823836985, -122.385786776164) 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
16214 16506 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 8 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
16420 189843 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 5 Sidewalk: Curb side : Cutout Tree Private 2     1 Width 3ft   6017155.58292 2098191.33075 37.742196046505 -122.383277260246 (37.742196046505, -122.383277260246) 10 3 8 58 1
17541 14919 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 13 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
18347 189903 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 4 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6016618 2098337 37.7425663014752 -122.385146220096 (37.7425663014752, -122.385146220096) 10 3 8 58 1
19053 153989 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 5 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6016386.30028 2098368.17483 37.7426390813321 -122.385949549827 (37.7426390813321, -122.385949549827) 10 3 8 58 1
19610 14916 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 10 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6017173.30591 2098243.55942 37.7423404352704 -122.383219613607 (37.7423404352704, -122.383219613607) 10 3 8 58 1
20031 17400 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1740 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6014126.91093 2095851.18558 37.7356026534403 -122.393585802156 (37.7356026534403, -122.393585802156) 10 3 8 58 1
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
22352 16479 DPW Maintained 1 Ceratonia siliqua :: Carob 5 220 Newhall St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016885.6016222 2098308.357669 37.7425024549748 -122.384218928939 (37.7425024549748, -122.384218928939) 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
23738 4926 DPW Maintained 1 Ceratonia siliqua :: Carob 5 195X Newhall St 15 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
24789 188485 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1525 Burke Ave 5 Sidewalk: Curb side : Cutout Tree Private 2     5 Width 3ft   6016660.6215 2098754.7402 37.7437156885266 -122.385027944407 (37.7437156885266, -122.385027944407) 10 3 8 58 1
26053 16540 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400X Newhall St 1 Sidewalk: Curb side : Cutout Tree DPW 1     5 0   6016126.25571 2098060.8881 37.7417809401523 -122.386827291768 (37.7417809401523, -122.386827291768) 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
29463 189899 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Newhall St 7 Sidewalk: Curb side : Cutout Tree Private 2     11 Width 3ft   6016506.94741 2098386.01279 37.7426947367801 -122.385533625971 (37.7426947367801, -122.385533625971) 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
32220 17420 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1844 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6013467.77602 2096339.40457 37.7369065543995 -122.395898900707 (37.7369065543995, -122.395898900707) 10 3 8 58 1
32557 6849 Permitted Site 7 Ceratonia siliqua :: Carob 5 595X Newhall St 6 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6015895.1615953 2097662.6258274 37.7406745956723 -122.387598567026 (37.7406745956723, -122.387598567026) 10 3 8 58 1
33168 14912 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017247.98036 2098210.14599 37.7422528150795 -122.38295908457 (37.7422528150795, -122.38295908457) 10 3 8 58 1
35835 2509 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1501 Burke Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016682.7889975 2098765.8378067 37.743747386446 -122.384952066789 (37.743747386446, -122.384952066789) 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
36755 14910 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017317.95316 2098168.33206 37.7421418684871 -122.38271422872 (37.7421418684871, -122.38271422872) 10 3 8 58 1
37237 16527 DPW Maintained 1 Ceratonia siliqua :: Carob 5 375 Newhall St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016370.17243 2098292.39049 37.7424301004582 -122.386000034169 (37.7424301004582, -122.386000034169) 10 3 8 58 1
39064 6846 DPW Maintained 1 Ceratonia siliqua :: Carob 5 595X Newhall St 3 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6015951.07042 2097735.77472 37.7408785442151 -122.387410355501 (37.7408785442151, -122.387410355501) 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
40094 2518 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 6 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016498.61775 2098890.19219 37.7440786495081 -122.385597557904 (37.7440786495081, -122.385597557904) 10 3 8 58 1
40384 16481 Permitted Site 7 Ceratonia siliqua :: Carob 5 220 Newhall St 3 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
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
40972 16484 DPW Maintained 1 Ceratonia siliqua :: Carob 5 220 Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016885.6016222 2098308.357669 37.7425024549748 -122.384218928939 (37.7425024549748, -122.384218928939) 10 3 8 58 1
41334 2516 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016465.84234 2098914.75953 37.7441442928392 -122.38571260096 (37.7441442928392, -122.38571260096) 10 3 8 58 1
41358 115360 Undocumented 4 Ceratonia siliqua :: Carob 5 205 ARKANSAS ST 1 Sidewalk: Curb side : Cutout Tree Private 2       3x4   6012944 2106057 37.7635598294353 -122.398391479388 (37.7635598294353, -122.398391479388) 14 3 8 28856 29
42288 199691 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1343 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 0ft   6016071.0177 2092930.0859 37.7276897308085 -122.38666058841 (37.7276897308085, -122.38666058841) 10 3 8 58 1
42634 2501 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1500 Burke Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016709.08958 2098828.16093 37.7439199677279 -122.384865465686 (37.7439199677279, -122.384865465686) 10 3 8 58 1
43304 14908 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 2 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
43361 14928 DPW Maintained 1 Ceratonia siliqua :: Carob 5 320X Newhall St 5 Sidewalk: Curb side : Cutout Tree DPW 1     3 3X3   6016461.7664057 2098387.7906821 37.7426971185746 -122.385689974252 (37.7426971185746, -122.385689974252) 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
48636 16511 DPW Maintained 1 Ceratonia siliqua :: Carob 5 330 Newhall St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016438.27303 2098384.37308 37.7426864345304 -122.385770970205 (37.7426864345304, -122.385770970205) 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
49574 14913 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 7 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017225.13937 2098220.80076 37.7422808088462 -122.383038803855 (37.7422808088462, -122.383038803855) 10 3 8 58 1
49970 2531 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1570 Burke Ave 9 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6016273.7509883 2099134.0637751 37.7447358261247 -122.386392104106 (37.7447358261247, -122.386392104106) 10 3 8 58 1
50667 2542 Permitted Site 7 Ceratonia siliqua :: Carob 5 1580 Burke Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6016211.040056 2099180.9466222 37.7448610852571 -122.386612216975 (37.7448610852571, -122.386612216975) 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
52927 17415 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1820X Palou Ave 5 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6013619.40586 2096223.80848 37.7365975859977 -122.395366549732 (37.7365975859977, -122.395366549732) 10 3 8 58 1
54072 4915 Permitted Site 7 Ceratonia siliqua :: Carob 5 195X Newhall St 4 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6017015.0972074 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687) 10 3 8 58 1
54911 16498 DPW Maintained 1 Ceratonia siliqua :: Carob 5 305X Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6016898.45948 2098256.16023 37.7423598423185 -122.384170835605 (37.7423598423185, -122.384170835605) 10 3 8 58 1
55055 2507 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1501 Burke Ave 3 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
55882 4925 DPW Maintained 1 Ceratonia siliqua :: Carob 5 195X Newhall St 14 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
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
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
57622 14925 DPW Maintained 1 Ceratonia siliqua :: Carob 5 320X Newhall St 2 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
58785 16556 Permitted Site 7 Ceratonia siliqua :: Carob 5 500X Newhall St 7 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6016006.287148 2097894.9109735 37.7413185578473 -122.387230532448 (37.7413185578473, -122.387230532448) 10 3 8 58 1
60722 16489 DPW Maintained 1 Ceratonia siliqua :: Carob 5 220 Newhall St 11 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016885.6016222 2098308.357669 37.7425024549748 -122.384218928939 (37.7425024549748, -122.384218928939) 10 3 8 58 1
62892 16507 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6016604.68474 2098314.93369 37.7425049753024 -122.385190723599 (37.7425049753024, -122.385190723599) 10 3 8 58 1
63557 17398 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1734X Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6014174.38954 2095813.0161 37.7355004859498 -122.393418978825 (37.7355004859498, -122.393418978825) 10 3 8 58 1
63725 96756 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1820X Palou Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     3 3x3   6013661.38712 2096183.48051 37.736489188553 -122.395218577377 (37.736489188553, -122.395218577377) 10 3 8 58 1
64200 189844 DPW Maintained 1 Ceratonia siliqua :: Carob 5 101 Newhall St 6 Sidewalk: Curb side : Cutout Tree Private 2     4 Width 3ft   6017173.06513 2098183.08322 37.7421743665616 -122.383216237654 (37.7421743665616, -122.383216237654) 10 3 8 58 1
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
66893 199696 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1337 Thomas Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     7 Width 0ft   6016147.0349 2092868.9416 37.7275260488519 -122.386393532075 (37.7275260488519, -122.386393532075) 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
70301 2533 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1575 Burke Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016180.33193 2099126.30756 37.7447093575531 -122.386714591425 (37.7447093575531, -122.386714591425) 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
73224 16514 DPW Maintained 1 Ceratonia siliqua :: Carob 5 330 Newhall St 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6016343.32243 2098341.01182 37.7425621187056 -122.386096262995 (37.7425621187056, -122.386096262995) 10 3 8 58 1
73481 6848 Permitted Site 7 Ceratonia siliqua :: Carob 5 595X Newhall St 5 Sidewalk: Curb side : Cutout Tree Private 2     12 3x3   6015895.1615953 2097662.6258274 37.7406745956723 -122.387598567026 (37.7406745956723, -122.387598567026) 10 3 8 58 1
73656 16503 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 5 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
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
75654 189902 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 Width 3ft   6016433.67399 2098382.99048 37.7426823836985 -122.385786776164 (37.7426823836985, -122.385786776164) 10 3 8 58 1
76900 6652 DPW Maintained 1 Ceratonia siliqua :: Carob 5 495X Newhall St 8 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
77385 14926 DPW Maintained 1 Ceratonia siliqua :: Carob 5 320X Newhall St 3 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
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
77909 14909 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017336.92539 2098155.67833 37.7421081720326 -122.382647747732 (37.7421081720326, -122.382647747732) 10 3 8 58 1
78824 16520 DPW Maintained 1 Ceratonia siliqua :: Carob 5 330 Newhall St 11 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
80491 17417 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1836 Palou Ave 1 Sidewalk: Curb side : Cutout Tree Private 2     12 3X3   6013526.86611 2096296.97727 37.7367933450374 -122.395691626761 (37.7367933450374, -122.395691626761) 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
81257 2540 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1575 Burke Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016367.14673 2098986.82897 37.7443367189812 -122.386058894813 (37.7443367189812, -122.386058894813) 10 3 8 58 1
82733 14930 DPW Maintained 1 Ceratonia siliqua :: Carob 5 320X Newhall St 7 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

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