trees
178 rows where qCaretaker_id = 1 and qSpecies_id = 5 sorted by Fire Prevention Districts
This data as json, CSV (advanced)
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) );