178 rows where qCaretaker_id = 1 and qSpecies_id = 5

View and edit SQL

Suggested facets: PlantDate, Fire Prevention Districts, Zip Codes

qCaretaker_id

  • DPW · 178
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)
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
2297 16623 DPW Maintained 1 Ceratonia siliqua :: Carob 5 136 Noe St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6002840.1476308 2107468.9628395 37.7668687081336 -122.433438380285 (37.7668687081336, -122.433438380285) 15 5 5 28862 3
2472 6651 DPW Maintained 1 Ceratonia siliqua :: Carob 5 495X Newhall St 7 Sidewalk: Curb side : Cutout Tree DPW 1     18 3x3   6016063.3688156 2097887.7750356 37.7413021249823 -122.38703266472 (37.7413021249823, -122.38703266472) 10 3 8 58 1
3395 17446 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1966 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6012949.46477 2096727.20845 37.7379425338291 -122.397718137505 (37.7379425338291, -122.397718137505) 10 3 8 58 1
3688 189905 DPW Maintained 1 Ceratonia siliqua :: Carob 5 350 Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1     12 Width 3ft   6016340.3864 2098339.29531 37.7425572430226 -122.386106295385 (37.7425572430226, -122.386106295385) 10 3 8 58 1
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
12712 19967 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100 STAIRWAY41 5 Sidewalk: Curb side : Cutout Tree DPW 1     6 25ST                      
13041 19762 DPW Maintained 1 Ceratonia siliqua :: Carob 5 100 STAIRWAY16 1 Sidewalk: Curb side : Cutout Tree DPW 1     3 30ST                      
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
15049 16543 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400X Newhall St 4 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/2006 12:00:00 AM 3 3x3   6016084.8488 2098009.98397 37.7416388751438 -122.38696691509 (37.7416388751438, -122.38696691509) 10 3 8 58 1
15625 27616 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 McAllister St 4 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   6005483.48508 2112000.60744 37.7794611228941 -122.424617889559 (37.7794611228941, -122.424617889559) 7 9 11 28852 41
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
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
18931 16634 DPW Maintained 1 Ceratonia siliqua :: Carob 5 158 Noe St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 4X4   6002846.26234 2107315.61995 37.7664480128774 -122.433406271499 (37.7664480128774, -122.433406271499) 15 5 5 28862 3
19339 21778 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500X Taylor St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 5X5   6008409.45282 2121407.87429 37.8054559800011 -122.415161778523 (37.8054559800011, -122.415161778523) 5 1 10 308 23
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
20273 18860 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2212 Sacramento St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6004055.90045 2116026.39415 37.7904341972353 -122.429843740294 (37.7904341972353, -122.429843740294) 13 9 1 29490 27
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
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
25251 14688 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 McAllister St 3 Sidewalk: Curb side : Cutout Tree DPW 1     26 4x4   6005346.74925 2111820.94662 37.7789600951073 -122.425078130411 (37.7789600951073, -122.425078130411) 7 9 11 28852 41
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
27880 438 DPW Maintained 1 Ceratonia siliqua :: Carob 5 792X Dolores St 2 Sidewalk: Curb side : Cutout Tree DPW 1     80 6   6004975.0011312 2103729.1085203 37.7567208435744 -122.425788038834 (37.7567208435744, -122.425788038834) 2 4 5 28862 3
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
32130 5658 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1349-1349 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 3X3   6005239.88286 2100530.07402 37.7479520016853 -122.42464442051 (37.7479520016853, -122.42464442051) 2 4 5 28859 19
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
33787 2545 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1590X Burke Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1   03/30/1990 12:00:00 AM 12 3X3   6016148.3291237 2099227.8294693 37.7449863439757 -122.386832330586 (37.7449863439757, -122.386832330586) 10 3 8 58 1
34404 4917 DPW Maintained 1 Ceratonia siliqua :: Carob 5 195X Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1   01/26/2015 05:50:00 AM 3 3X3   6017015.0972074 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687) 10 3 8 58 1
34503 21789 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2585 Taylor St 4 Sidewalk: Curb side : Cutout Tree DPW 1   05/20/2015 12:00:00 AM 3 4X4   6008161.90241 2121549.79462 37.8058317424248 -122.41602851934 (37.8058317424248, -122.41602851934) 5 1 10 308 23
35125 4920 DPW Maintained 1 Ceratonia siliqua :: Carob 5 195X Newhall St 9 Sidewalk: Curb side : Cutout Tree DPW 1   01/26/2015 05:54:00 AM 3 3X3   6017015.0972074 2098230.5166868 37.742295878473 -122.383765748687 (37.742295878473, -122.383765748687) 10 3 8 58 1
35126 15121 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Mission St 1 Sidewalk: Curb side : Cutout Tree DPW 1     18 2X2   6013826.37134 2116069.93693 37.7911022004845 -122.396041353962 (37.7911022004845, -122.396041353962) 12 2 9 28855 6
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
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
36850 21792 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2598 Taylor St 1 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
36977 14687 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 McAllister St 2 Sidewalk: Curb side : Cutout Tree DPW 1     24 4x4   6005346.74925 2111820.94662 37.7789600951073 -122.425078130411 (37.7789600951073, -122.425078130411) 7 9 11 28852 41
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
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
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
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
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
49549 13332 DPW Maintained 1 Ceratonia siliqua :: Carob 5 145 Mansell St 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6011384.17484 2090567.17856 37.7209410845847 -122.402697063866 (37.7209410845847, -122.402697063866) 10 7 8 309 28
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
51567 20965 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2002X Sunset Blvd 5 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
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
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
55015 20969 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2002X Sunset Blvd 9 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
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
55304 14686 DPW Maintained 1 Ceratonia siliqua :: Carob 5 775 McAllister St 1 Sidewalk: Curb side : Cutout Tree DPW 1     16 4X4   6005447.7824 2111997.5051 37.7794505882327 -122.424741179621 (37.7794505882327, -122.424741179621) 7 9 11 28852 41
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
56233 18865 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2230 Sacramento St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6003863.26827 2115999.97726 37.7903507527417 -122.430508349195 (37.7903507527417, -122.430508349195) 13 9 1 29490 27
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
56857 16545 DPW Maintained 1 Ceratonia siliqua :: Carob 5 400X Newhall St 6 Sidewalk: Curb side : Cutout Tree DPW 1   03/10/2016 02:31:00 PM 3 3x3   6016063.42274 2097976.36799 37.7415453861211 -122.387038655827 (37.7415453861211, -122.387038655827) 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
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
62291 5529 DPW Maintained 1 Ceratonia siliqua :: Carob 5 895 Dolores St 1 Sidewalk: Curb side : Cutout Tree DPW 1     100 4X4   6005093.86648 2103161.82188 37.7551699235695 -122.425336590916 (37.7551699235695, -122.425336590916) 2 4 5 28859 19
62764 16626 DPW Maintained 1 Ceratonia siliqua :: Carob 5 138 Noe St 1 Sidewalk: Curb side : Cutout Tree DPW 1   02/02/2001 12:00:00 AM 21 3X3   6002836.08721 2107485.6498 37.7669142960875 -122.43345361721 (37.7669142960875, -122.43345361721) 15 5 5 28862 3
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
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
68954 7418 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1090 Folsom St 2 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6010342.8854 2110986.7114 37.7769504410171 -122.407735574616 (37.7769504410171, -122.407735574616) 14 2 9 28853 34
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
71054 21785 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2585 Taylor St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 4X4   6008161.90241 2121549.79462 37.8058317424248 -122.41602851934 (37.8058317424248, -122.41602851934) 5 1 10 308 23
71087 189833 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1570 Burke Ave 2 : Tree DPW 1   02/12/2016 12:00:00 AM 14 Width 3ft   6016585.78665 2098909.19771 37.7441356575455 -122.385297468507 (37.7441356575455, -122.385297468507) 10 3 8 58 1
72975 15123 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Mission St 3 Sidewalk: Curb side : Cutout Tree DPW 1     14 2X2   6013765.88916 2116013.74101 37.7909445343765 -122.396246681474 (37.7909445343765, -122.396246681474) 12 2 9 28855 6
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
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
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
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
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
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
79778 2524 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1570 BURKE AVE 2 Sidewalk: Curb side : Cutout Tree DPW 1   02/12/2016 12:00:00 AM 12 3X3   6016449 2099041 37.7444899913278 -122.385779635787 (37.7444899913278, -122.385779635787) 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
83022 2522 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 10 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016344.0270005 2099019.0971083 37.7444240410894 -122.386141087772 (37.7444240410894, -122.386141087772) 10 3 8 58 1
84076 2520 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1555 Burke Ave 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016533.26 2098864.45764 37.744009904432 -122.385475978555 (37.744009904432, -122.385475978555) 10 3 8 58 1
85699 11179 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2750X Hyde St 1 Sidewalk: Curb side : Cutout Tree DPW 1     36 3x3   6006893.59102 2121789.4662 37.8064184289444 -122.4204347354 (37.8064184289444, -122.4204347354) 5 1 1 28858 32
85869 2534 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1575 Burke Ave 2 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016196.15475 2099115.85615 37.7446815361299 -122.386659150015 (37.7446815361299, -122.386659150015) 10 3 8 58 1
93762 15124 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Mission St 4 Sidewalk: Curb side : Cutout Tree DPW 1     14 2X2   6013752.67684 2116000.07901 37.7909062865319 -122.396291437927 (37.7909062865319, -122.396291437927) 12 2 9 28855 6
93841 17432 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1899 Palou Ave 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6013304.38665 2096386.76437 37.7370275033033 -122.396467132869 (37.7370275033033, -122.396467132869) 10 3 8 58 1
95233 15122 DPW Maintained 1 Ceratonia siliqua :: Carob 5 300 Mission St 2 Sidewalk: Curb side : Cutout Tree DPW 1     8 2X2   6013811.40838 2116056.32171 37.7910639837629 -122.396092171091 (37.7910639837629, -122.396092171091) 12 2 9 28855 6
95532 16523 DPW Maintained 1 Ceratonia siliqua :: Carob 5 375 Newhall St 3 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016311.20334 2098218.94031 37.7422251575656 -122.386198814044 (37.7422251575656, -122.386198814044) 10 3 8 58 1
95994 11181 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2750X Hyde St 3 Sidewalk: Curb side : Cutout Tree DPW 1     14 3X3   6006890.68476 2121823.94924 37.8065129467732 -122.420447242256 (37.8065129467732, -122.420447242256) 5 1 1 28858 32
98289 14914 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 8 Sidewalk: Curb side : Cutout Tree DPW 1     12 3x3   6017206.58246 2098230.05631 37.7423051973143 -122.383103612647 (37.7423051973143, -122.383103612647) 10 3 8 58 1
98842 22886 DPW Maintained 1 Ceratonia siliqua :: Carob 5 95X Valencia St 2 Sidewalk: Curb side : Cutout Tree DPW 1     30 3x3   6006042.93395 2109155.55847 37.7716808854236 -122.422480302267 (37.7716808854236, -122.422480302267) 8 2 9 28853 19
99086 7417 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1090 Folsom St 1 Sidewalk: Curb side : Cutout Tree DPW 1   01/23/2003 12:00:00 AM 6 3X3   6010360.059 2111002.9309 37.7769959373466 -122.407677309481 (37.7769959373466, -122.407677309481) 14 2 9 28853 34
99094 21776 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2500X Taylor St 1 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6008409.45282 2121407.87429 37.8054559800011 -122.415161778523 (37.8054559800011, -122.415161778523) 5 1 10 308 23
100104 21793 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2598 Taylor St 2 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
100676 16500 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 2 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
102144 14932 DPW Maintained 1 Ceratonia siliqua :: Carob 5 320X Newhall St 9 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
102198 16504 DPW Maintained 1 Ceratonia siliqua :: Carob 5 325 Newhall St 6 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
102602 14927 DPW Maintained 1 Ceratonia siliqua :: Carob 5 320X Newhall St 4 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
104002 2512 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1501 Burke Ave 8 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
105990 18859 DPW Maintained 1 Ceratonia siliqua :: Carob 5 2212 Sacramento St 1 Sidewalk: Curb side : Cutout Tree DPW 1   10/13/1992 12:00:00 AM 12 3X3   6004082.46062 2116030.31556 37.7904464684691 -122.429752123658 (37.7904464684691, -122.429752123658) 13 9 1 29490 27
106760 2535 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1575 Burke Ave 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 3X3   6016210.73833 2099105.12284 37.7446528720358 -122.386607974081 (37.7446528720358, -122.386607974081) 10 3 8 58 1
107870 16512 DPW Maintained 1 Ceratonia siliqua :: Carob 5 330 Newhall St 3 Sidewalk: Curb side : Cutout Tree DPW 1     6 3x3   6016415.99739 2098380.53365 37.7426746595649 -122.38584772612 (37.7426746595649, -122.38584772612) 10 3 8 58 1
108291 14920 DPW Maintained 1 Ceratonia siliqua :: Carob 5 110X Newhall St 14 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6017135.89317 2098259.62578 37.7423824826909 -122.383350094901 (37.7423824826909, -122.383350094901) 10 3 8 58 1
109158 2546 DPW Maintained 1 Ceratonia siliqua :: Carob 5 1590X Burke Ave 4 Sidewalk: Curb side : Cutout Tree DPW 1     12 3X3   6016148.3291237 2099227.8294693 37.7449863439757 -122.386832330586 (37.7449863439757, -122.386832330586) 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)
);