trees
752 rows where qSiteInfo = "Sidewalk: Curb side : Cutout" and qSpecies_id = 5 sorted by Longitude
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 | |||||||||||||
| 12701 | 3581 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/01/2006 12:00:00 AM | 3 | 3X3 | 6018980.3390981 | 2097500.2540781 | 37.7403991596993 | -122.376919818221 | (37.7403991596993, -122.376919818221) | 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 | |||
| 169962 | 83036 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/18/2017 02:55:00 PM | 3 | 6018559.56213 | 2097806.04485 | 37.7412156164156 | -122.378395939846 | (37.7412156164156, -122.378395939846) | 10 | 3 | 8 | 58 | 1 | |||
| 101145 | 3593 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 29 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/06/2016 12:00:00 AM | 7 | 3X3 | 6018341.35218 | 2097966.95491 | 37.7416454132021 | -122.379161613636 | (37.7416454132021, -122.379161613636) | 10 | 3 | 8 | 58 | 1 | ||
| 46225 | 3611 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 47 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 05/31/1996 12:00:00 AM | 3 | 3X3 | 6018038.29611 | 2098194.83807 | 37.7422544187983 | -122.380225323637 | (37.7422544187983, -122.380225323637) | 10 | 3 | 8 | 58 | 1 | ||
| 163469 | 3627 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 63 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 04/06/2016 12:00:00 AM | 3 | 3X3 | 6017747.14415 | 2098409.63099 | 37.7428281287262 | -122.381246979566 | (37.7428281287262, -122.381246979566) | 10 | 3 | 8 | 58 | 1 | ||
| 42308 | 3639 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 75 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017551.66161 | 2098562.89956 | 37.743238180002 | -122.381933568796 | (37.743238180002, -122.381933568796) | 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 | |||
| 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 | |||
| 166582 | 14918 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 12 | 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 | |||
| 100284 | 3652 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 88 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/07/2006 12:00:00 AM | 3 | 3X3 | 6017348.88964 | 2098746.4497 | 37.7437309716031 | -122.382647477613 | (37.7437309716031, -122.382647477613) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 166358 | 189847 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6017231.39271 | 2098158.22234 | 37.7421093266962 | -122.383012827183 | (37.7421093266962, -122.383012827183) | 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 | |||
| 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 | |||
| 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 | |||
| 191303 | 14915 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017191.33538 | 2098236.4203 | 37.7423218290085 | -122.383156775767 | (37.7423218290085, -122.383156775767) | 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 | |||
| 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 | |||
| 180338 | 14917 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017157.89779 | 2098250.45331 | 37.7423585130106 | -122.383273370488 | (37.7423585130106, -122.383273370488) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 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 | |||
| 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 | ||
| 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 | |||
| 143134 | 4923 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 12 | 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 | |||
| 164425 | 4913 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | |||
| 165477 | 4918 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 7 | 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 | |||
| 183470 | 4916 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/26/2015 05:46:00 AM | 3 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | ||
| 185290 | 4919 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 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 | ||
| 188633 | 4914 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | |||
| 54911 | 16498 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 305X Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016898.45948 | 2098256.16023 | 37.7423598423185 | -122.384170835605 | (37.7423598423185, -122.384170835605) | 10 | 3 | 8 | 58 | 1 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 155907 | 16488 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 0 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.384218928939 | (37.7425024549748, -122.384218928939) | 10 | 3 | 8 | 58 | 1 | |||
| 191172 | 16486 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 8 | 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 | |||
| 170549 | 16497 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 305X Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016834.58957 | 2098268.17724 | 37.7423893070591 | -122.384392517318 | (37.7423893070591, -122.384392517318) | 10 | 3 | 8 | 58 | 1 | |||
| 175245 | 2498 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016761.82696 | 2098799.80324 | 37.7438450200413 | -122.384681135251 | (37.7438450200413, -122.384681135251) | 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 | |||
| 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 | |||
| 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 | |||
| 192875 | 2502 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016691.63378 | 2098834.3481 | 37.743935990944 | -122.38492625536 | (37.743935990944, -122.38492625536) | 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 179658 | 2505 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1501 Burke Ave | 1 | 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 | |||
| 191865 | 2511 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1501 Burke Ave | 7 | 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 | |||
| 125723 | 188487 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1525 Burke Ave | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6016679.39003 | 2098723.90702 | 37.7436320650598 | -122.384960899022 | (37.7436320650598, -122.384960899022) | 10 | 3 | 8 | 58 | 1 | |||
| 183957 | 16509 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/03/1992 12:00:00 AM | 3 | 3X3 | 6016661.92107 | 2098301.48789 | 37.742471221974 | -122.384991878867 | (37.742471221974, -122.384991878867) | 10 | 3 | 8 | 58 | 1 | ||
| 175649 | 189897 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6016662.64586 | 2098353.63161 | 37.7426144381027 | -122.384993004817 | (37.7426144381027, -122.384993004817) | 10 | 3 | 8 | 58 | 1 | |||
| 161350 | 2503 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016672.43224 | 2098847.72364 | 37.7439716553617 | -122.384993582204 | (37.7439716553617, -122.384993582204) | 10 | 3 | 8 | 58 | 1 | |||
| 177283 | 16490 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 305X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016659.29203 | 2098304.79019 | 37.7424801439961 | -122.385001199414 | (37.7424801439961, -122.385001199414) | 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 | |||
| 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 | |||
| 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 | |||
| 142543 | 188484 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1525 Burke Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6016633.99026 | 2098788.07165 | 37.7438057367534 | -122.38512235163 | (37.7438057367534, -122.38512235163) | 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 | |
| 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 | |||
| 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 | ||
| 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 | |||
| 139349 | 14974 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400X Mendell St | 7 | Sidewalk: Curb side : Cutout | Tree | Fire Dept 16 | 12 | 3X3 | 6016589.22096 | 2097595.13367 | 37.7405276953073 | -122.385194050084 | (37.7405276953073, -122.385194050084) | 10 | 3 | 8 | 58 | 1 | |||
| 190306 | 93110 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53024 | 6016603.54888 | 2098366.45199 | 37.7426463712226 | -122.385198240014 | (37.7426463712226, -122.385198240014) | 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 | |||
| 141218 | 93111 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 7 | 3x3 | Permit Number 53024 | 6016584.37921 | 2098370.12887 | 37.7426554067123 | -122.385264779961 | (37.7426554067123, -122.385264779961) | 10 | 3 | 8 | 58 | 1 | |
| 161276 | 188483 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1525 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6016580.58877 | 2098830.37302 | 37.7439189335051 | -122.385309950204 | (37.7439189335051, -122.385309950204) | 10 | 3 | 8 | 58 | 1 | |||
| 163591 | 93112 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53024 | 6016561.73954 | 2098375.23066 | 37.7426681627043 | -122.385343417566 | (37.7426681627043, -122.385343417566) | 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 | |||
| 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 | |
| 179562 | 2526 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 Burke Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6016552.46567 | 2098935.10176 | 37.744204941317 | -122.385414490998 | (37.744204941317, -122.385414490998) | 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 | |
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 164547 | 14929 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 6 | 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 | |||
| 167263 | 14924 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 1 | 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 |
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) );