trees
856 rows where qSpecies_id = 5 sorted by DBH
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
170988 | 225052 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 375 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6000953.83658 | 2096674.21341 | 37.7371217252913 | -122.439189029173 | (37.7371217252913, -122.439189029173) | 2 | 7 | 5 | 63 | 7 | |||
172553 | 225079 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2804 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009325.52412 | 2103958.77383 | 37.7575963412133 | -122.410758500511 | (37.7575963412133, -122.410758500511) | 2 | 4 | 7 | 28859 | 19 | |||
175418 | 125967 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3440 Clay St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 6ft | 5998347.68841 | 2115559.33393 | 37.7888268704136 | -122.449560024485 | (37.7888268704136, -122.449560024485) | 13 | 6 | 1 | 54 | 31 | |||
176339 | 244469 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 665 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 6003415.8306 | 2109638.093 | 37.7728572538387 | -122.431602065027 | (37.7728572538387, -122.431602065027) | 15 | 9 | 11 | 29492 | 10 | |||
185943 | 225083 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3782 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003229.02977 | 2103031.88331 | 37.7547076090931 | -122.431776461616 | (37.7547076090931, -122.431776461616) | 2 | 4 | 5 | 28862 | 22 | |||
186123 | 189857 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 7 | : | Tree | Private 2 | 11 | Width 4ft | 6017207.28329 | 2098227.98563 | 37.7422995503725 | -122.383101045278 | (37.7422995503725, -122.383101045278) | 10 | 3 | 8 | 58 | 1 | |||
190273 | 222903 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 164 Peralta Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009951.59256 | 2100103.15651 | 37.7470447557132 | -122.408321349458 | (37.7470447557132, -122.408321349458) | 2 | 7 | 7 | 28859 | 2 | |||
193471 | 225085 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 406 Vicksburg St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6004142.31119 | 2101495.14459 | 37.7505398125629 | -122.428508555547 | (37.7505398125629, -122.428508555547) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
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 | |||
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 | |||
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 | |||
11562 | 206018 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 99 Merced Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994828.29695 | 2099714.01169 | 37.7451177882671 | -122.460587859436 | (37.7451177882671, -122.460587859436) | 1 | 8 | 4 | 59 | 40 | |||
12569 | 111886 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 140 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x12 | 6006709 | 2098750 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
16559 | 222925 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1025 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 5998825.08997 | 2106348.09575 | 37.7635624787486 | -122.447245077795 | (37.7635624787486, -122.447245077795) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
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 | |||
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 | |||
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 | |||
22361 | 125968 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2810 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001336.41783 | 2115647.62359 | 37.7892398148051 | -122.439225792541 | (37.7892398148051, -122.439225792541) | 13 | 6 | 1 | 29490 | 27 | |||
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 | |||
26621 | 222916 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 92 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6004301.92294 | 2109033.13825 | 37.7712463798496 | -122.428493839936 | (37.7712463798496, -122.428493839936) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
30477 | 222899 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3737 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 6ft | 6005393.47694 | 2104277.70893 | 37.7582508111316 | -122.424379813902 | (37.7582508111316, -122.424379813902) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
32244 | 111887 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 140 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x12 | 6006709 | 2098750 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | 2 | 7 | 7 | 28859 | 2 | |||
32402 | 115846 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Bay St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6003504.2747 | 2120736.26354 | 37.8033350304463 | -122.432088807873 | (37.8033350304463, -122.432088807873) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
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 | ||
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 | |||
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 | |||
37876 | 125979 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2500 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008389.02756 | 2121512.5692 | 37.8057422979318 | -122.41523987894 | (37.8057422979318, -122.41523987894) | 5 | 1 | 10 | 308 | 23 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
56161 | 18866 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2241 Sacramento St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6004050.55009 | 2115976.04283 | 37.7902956422834 | -122.429858659173 | (37.7902956422834, -122.429858659173) | 13 | 9 | 1 | 29490 | 27 | |||
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 | |||
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 | |||
60751 | 64436 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2445 Larkin St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 05/16/1988 12:00:00 AM | 12 | Permit Number 25292 | 6006658.75135 | 2119650.10198 | 37.8005310432266 | -122.421095439396 | (37.8005310432266, -122.421095439396) | 5 | 9 | 1 | 28858 | 32 | ||
62069 | 4912 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 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 | ||
62355 | 225056 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 354 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6001081.74278 | 2096696.02818 | 37.737188901045 | -122.438748363154 | (37.737188901045, -122.438748363154) | 2 | 7 | 5 | 63 | 7 | |||
62803 | 189959 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6010397.61848 | 2108539.03358 | 37.7702327485634 | -122.40737363759 | (37.7702327485634, -122.40737363759) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |||
66656 | 16644 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 170 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4X4 | 6002849.24717 | 2107272.65524 | 37.7663302115978 | -122.433392876987 | (37.7663302115978, -122.433392876987) | 15 | 5 | 5 | 28862 | 3 | |||
67228 | 206013 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 130 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5992845.13508 | 2095810.81929 | 37.7342863121439 | -122.467161490835 | (37.7342863121439, -122.467161490835) | 9 | 8 | 4 | 59 | 40 | |||
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 | |||
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 | |||
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 | |||
74388 | 16650 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 190 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6002855.60879 | 2107200.17785 | 37.7661315672606 | -122.433365693732 | (37.7661315672606, -122.433365693732) | 15 | 5 | 5 | 28862 | 3 | |||
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 | |||
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 | ||
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 | |||
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 | |||
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 | |||
84909 | 14975 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400X Mendell St | 8 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3x3 | 6016578.93942 | 2097580.627 | 37.7404872941606 | -122.38522858943 | (37.7404872941606, -122.38522858943) | 10 | 3 | 8 | 58 | 1 | |||
87736 | 16483 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 5 | 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 | |||
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 | |||
95486 | 4922 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 11 | 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 | |||
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 | |||
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 | |||
99992 | 16482 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 4 | 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 | |||
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 | |||
102749 | 16480 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 2 | 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 | |||
103062 | 107151 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 215 Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 4x4 | 6013483.16907 | 2106058.28155 | 37.7635933686511 | -122.396526740817 | (37.7635933686511, -122.396526740817) | 14 | 3 | 8 | 28856 | 29 | |||
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 | |||
104673 | 222889 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 81 Webster St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | Width 4ft | 6004268.74767 | 2108942.84192 | 37.7709965706599 | -122.428602156987 | (37.7709965706599, -122.428602156987) | 7 | 9 | 11 | 29492 | 10 | |||
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 | ||
106329 | 142100 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 904 Fell St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 0ft | 6002972.7027 | 2110318.8393 | 37.7747012881718 | -122.433183544102 | (37.7747012881718, -122.433183544102) | 15 | 5 | 11 | 29492 | 10 | |||
106847 | 16553 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 500X Newhall St | 4 | 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 | |||
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 |
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) );