trees
661 rows where qCaretaker_id = 2 and qSpecies_id = 5 sorted by Neighborhoods (old)
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) ▼ |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |||
| 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 | |||
| 4137 | 61685 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 34 Ceres St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 11/29/1984 12:00:00 AM | 11 | Permit Number 21682 | 6013864.09066 | 2093969.56082 | 37.7304214900476 | -122.394362775032 | (37.7304214900476, -122.394362775032) | 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 | |||
| 14153 | 61726 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Ceres St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/14/1984 12:00:00 AM | 9 | Permit Number 21728 | 6013869.02725 | 2093995.24936 | 37.7304922999628 | -122.39434750634 | (37.7304922999628, -122.39434750634) | 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 | |||
| 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 | |||
| 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 | |||
| 18873 | 61724 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 18 Ceres St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 12/17/1984 12:00:00 AM | 8 | Permit Number 21726 | 6013883.84127 | 2094072.5147 | 37.7307052783181 | -122.394301699376 | (37.7307052783181, -122.394301699376) | 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 | |||
| 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 | |||
| 20304 | 49779 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 241@ BLANKEN Tocoloma Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 06/09/2003 12:00:00 AM | Permit Number 46565 | 6012711.25696991 | 2087289.78103258 | 37.7120160109599 | -122.397879925295 | (37.7120160109599, -122.397879925295) | 10 | 3 | 8 | 309 | 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 | |||
| 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 | |||
| 24626 | 93109 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 9 | 3x3 | Permit Number 53024 | 6016621.35417 | 2098362.60938 | 37.7426368051604 | -122.385136406214 | (37.7426368051604, -122.385136406214) | 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 | |||
| 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 | |||
| 34794 | 83038 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 14 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 02/04/2006 12:00:00 AM | 6018593.33009 | 2097780.6594 | 37.7411477742489 | -122.378277419086 | (37.7411477742489, -122.378277419086) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 46212 | 61684 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 49 Ceres St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 01/12/1985 12:00:00 AM | Permit Number 21681 | 6013901.59422939 | 2093898.15648128 | 37.7302275129585 | -122.394228121663 | (37.7302275129585, -122.394228121663) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 65447 | 93113 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 9 | 3x3 | Permit Number 53024 | 6016543.92232 | 2098378.49318 | 37.7426761351889 | -122.385405252254 | (37.7426761351889, -122.385405252254) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 83224 | 189863 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 13 | : | Tree | Private 2 | 9 | Width 3ft | 6017087.00267 | 2098268.01639 | 37.7424028195418 | -122.383519729148 | (37.7424028195418, -122.383519729148) | 10 | 3 | 8 | 58 | 1 | |||
| 83845 | 189890 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 4 | : | Tree | Private 2 | 10 | Width 4ft | 6016847.57568 | 2098318.03852 | 37.742526934071 | -122.384351086743 | (37.742526934071, -122.384351086743) | 10 | 3 | 8 | 58 | 1 | |||
| 85138 | 189878 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6016474.87335 | 2098336.17477 | 37.7425561170601 | -122.385641057214 | (37.7425561170601, -122.385641057214) | 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 | |||
| 90694 | 189838 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 525 Phelps St | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6015431.26911 | 2098152.36329 | 37.7419936082285 | -122.389236732886 | (37.7419936082285, -122.389236732886) | 10 | 3 | 8 | 58 | 1 | |||
| 94315 | 189882 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 7 | : | Tree | Private 2 | 9 | Width 3ft | 6016580.99088 | 2098317.85278 | 37.7425116797752 | -122.385272854085 | (37.7425116797752, -122.385272854085) | 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 | |||
| 98742 | 189846 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017214.17115 | 2098166.7194 | 37.7421317063069 | -122.383072965771 | (37.7421317063069, -122.383072965771) | 10 | 3 | 8 | 58 | 1 | |||
| 98760 | 189879 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 4 | : | Tree | Private 2 | 8 | Width 3ft | 6016498.14538 | 2098335.4641 | 37.7425554533749 | -122.385560539098 | (37.7425554533749, -122.385560539098) | 10 | 3 | 8 | 58 | 1 | |||
| 99211 | 189861 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 11 | : | Tree | Private 2 | 8 | Width 3ft | 6017125.66493 | 2098258.40905 | 37.742378576526 | -122.383385376738 | (37.742378576526, -122.383385376738) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 100972 | 199697 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1331 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6016182.8401 | 2092843.0517 | 37.7274569422187 | -122.386267947878 | (37.7274569422187, -122.386267947878) | 10 | 3 | 8 | 58 | 1 | |||
| 100985 | 189841 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6017113.18863 | 2098207.21128 | 37.7422373082953 | -122.383424953219 | (37.7422373082953, -122.383424953219) | 10 | 3 | 8 | 58 | 1 | |||
| 100997 | 173732 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1690x Galvez Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6015419 | 2098106 | 37.7418656239974 | -122.389275919147 | (37.7418656239974, -122.389275919147) | 10 | 3 | 8 | 58 | 1 | ||||
| 102050 | 189886 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 201 Newhall St | 7 | : | Tree | Private 2 | 6 | Width 3ft | 6016892.13311 | 2098254.09694 | 37.7423538271607 | -122.384192566831 | (37.7423538271607, -122.384192566831) | 10 | 3 | 8 | 58 | 1 | |||
| 102361 | 189877 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6016448.85629 | 2098333.07564 | 37.7425461678608 | -122.385730801451 | (37.7425461678608, -122.385730801451) | 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 | |||
| 102811 | 189880 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 5 | : | Tree | Private 2 | 7 | Width 3ft | 6016536.79452 | 2098327.43911 | 37.742535556771 | -122.385426341355 | (37.742535556771, -122.385426341355) | 10 | 3 | 8 | 58 | 1 | |||
| 102986 | 17458 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1999 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 55 | 3x3 | 6012778.88075 | 2096779.84322 | 37.7380775571329 | -122.398311626199 | (37.7380775571329, -122.398311626199) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 107061 | 47237 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1200X Fitzgerald Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 9 | 3x3 | Permit Number 45189 | 6014656.8506 | 2090563.7281 | 37.721113790544 | -122.391384069594 | (37.721113790544, -122.391384069594) | 10 | 3 | 8 | 58 | 1 |
| 107432 | 189915 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1 Flora St | 13 | : | Tree | Private 2 | 5 | Width 3ft | 6013899.07383 | 2094479.41823 | 37.7318233991302 | -122.394277515688 | (37.7318233991302, -122.394277515688) | 10 | 3 | 8 | 58 | 1 | |||
| 107783 | 17444 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1950 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6013023.36347 | 2096670.73663 | 37.7377915889102 | -122.397458672302 | (37.7377915889102, -122.397458672302) | 10 | 3 | 8 | 58 | 1 | |||
| 108597 | 189872 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Newhall St | 12 | : | Tree | Private 2 | 17 | Width 4ft | 6015960.56064 | 2097835.58742 | 37.7411531351002 | -122.387384502698 | (37.7411531351002, -122.387384502698) | 10 | 3 | 8 | 58 | 1 | |||
| 109482 | 200192 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1008 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6013935.7075 | 2089708.6863 | 37.718725965018 | -122.393817050636 | (37.718725965018, -122.393817050636) | 10 | 3 | 8 | 58 | 1 | |||
| 111049 | 189870 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 401 Newhall St | 5 | : | Tree | Private 2 | 13 | Width 3ft | 6016138.74056 | 2097991.9117 | 37.7415922362914 | -122.386779313807 | (37.7415922362914, -122.386779313807) | 10 | 3 | 8 | 58 | 1 | |||
| 111910 | 189867 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 401 Newhall St | 2 | : | Tree | Private 2 | 16 | Width 3ft | 6016089.46635 | 2097928.70806 | 37.7414159637784 | -122.38694528192 | (37.7414159637784, -122.38694528192) | 10 | 3 | 8 | 58 | 1 | |||
| 112108 | 16517 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3X3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 10 | 3 | 8 | 58 | 1 | |||
| 112435 | 47241 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1000X Jamestown Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6014093.2543098 | 2089771.82198012 | 37.718908077116 | -122.393276886105 | (37.718908077116, -122.393276886105) | 10 | 3 | 8 | 58 | 1 |
| 114865 | 201371 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1 Hare St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12 | 6018297.03999 | 2095334.93444 | 37.7344159629251 | -122.379132069983 | (37.7344159629251, -122.379132069983) | 10 | 3 | 8 | 58 | 1 | ||||
| 117441 | 16485 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 7 | 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 | |||
| 118217 | 189906 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6016329.85018 | 2098328.36686 | 37.7425266525877 | -122.386141965188 | (37.7425266525877, -122.386141965188) | 10 | 3 | 8 | 58 | 1 | |||
| 118594 | 199693 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1341 Thomas Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 0ft | 6016099.111 | 2092907.501 | 37.7276292724139 | -122.386561894416 | (37.7276292724139, -122.386561894416) | 10 | 3 | 8 | 58 | 1 | |||
| 118720 | 17403 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1775 Palou Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 55 | 3x3 | 6013944.43098 | 2095916.733 | 37.7357724918668 | -122.394221297579 | (37.7357724918668, -122.394221297579) | 10 | 3 | 8 | 58 | 1 | |||
| 119961 | 188486 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1525 Burke Ave | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6016667.7961 | 2098739.5766 | 37.7436744492327 | -122.385002079878 | (37.7436744492327, -122.385002079878) | 10 | 3 | 8 | 58 | 1 | |||
| 120516 | 189836 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1698 Galvez Ave | 9 | : | Tree | Private 2 | 13 | Width 4ft | 6015406.79125 | 2098034.46628 | 37.7416685302756 | -122.389313139314 | (37.7416685302756, -122.389313139314) | 10 | 3 | 8 | 58 | 1 | |||
| 120815 | 93114 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53024 | 6016526.70747 | 2098382.71109 | 37.7426867642747 | -122.385465070679 | (37.7426867642747, -122.385465070679) | 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) );