trees
856 rows where qSpecies_id = 5 sorted by qCareAssistant
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
56492 | 21779 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2535 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4x4 | 6008355.3148 | 2121474.21304 | 37.8056350868765 | -122.415353830252 | (37.8056350868765, -122.415353830252) | 5 | 1 | 10 | 308 | 23 | |||
56518 | 237914 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1001 Stanyan St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | Width 4ft | 5997227 | 2107052 | 37.7654037766697 | -122.452823145368 | (37.7654037766697, -122.452823145368) | 15 | 5 | 11 | 29492 | 12 | |||
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 | |||
56818 | 139055 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2693 SUTTER ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 0ft | 5999732.7035 | 2113978.0164 | 37.7845641202108 | -122.444654378813 | (37.7845641202108, -122.444654378813) | 15 | 6 | 11 | 29490 | 31 | |||
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 | ||
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 | |||
57482 | 140579 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 949 FILLMORE ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003399.7999 | 2111643.4846 | 37.7783626547096 | -122.431800729752 | (37.7783626547096, -122.431800729752) | 15 | 9 | 11 | 29492 | 41 | |||
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 | |||
57765 | 225058 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 283 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996870.76469 | 2106986.93981 | 37.76520471814 | -122.454050575073 | (37.76520471814, -122.454050575073) | 15 | 5 | 11 | 29492 | 12 | |||
58282 | 115847 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3501 Laguna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6003582.67693 | 2120834.73516 | 37.8036098524612 | -122.431824529496 | (37.8036098524612, -122.431824529496) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
59723 | 248262 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 136 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006723.28629 | 2098755.01317 | 37.743161751109 | -122.41938895693 | (37.743161751109, -122.41938895693) | 2 | 7 | 7 | 28859 | 2 | |||
59975 | 125986 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 6ft | 6008368.52895 | 2121668.47116 | 37.8061692132974 | -122.415321861121 | (37.8061692132974, -122.415321861121) | 5 | 1 | 10 | 308 | 23 | |||
60278 | 189935 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013248.49941 | 2116191.11402 | 37.791402756277 | -122.398049289468 | (37.791402756277, -122.398049289468) | 12 | 2 | 9 | 28855 | 6 | |||
60431 | 103341 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 590X 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6010323 | 2108639 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | 8 | 2 | 9 | 28853 | 34 | |||
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 | ||
60894 | 246420 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Duncan St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 4ft | 6003851.19686 | 2099854.61267 | 37.7460188154337 | -122.429398275524 | (37.7460188154337, -122.429398275524) | 2 | 7 | 5 | 63 | 22 | |||
60927 | 189962 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010439.90597 | 2108494.60457 | 37.7701131234445 | -122.407224232334 | (37.7701131234445, -122.407224232334) | 8 | 2 | 9 | 28853 | 34 | |||
61480 | 246510 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 231 Duncan St | 1 | : | Tree | Private 2 | 1 | Width 5ft | 6004993.26159 | 2099869.66747 | 37.7461247456624 | -122.425450235552 | (37.7461247456624, -122.425450235552) | 2 | 7 | 5 | 63 | 22 | |||
61840 | 222914 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 108 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 2ft | 6004276.58953 | 2109191.75922 | 37.7716804808011 | -122.428592777936 | (37.7716804808011, -122.428592777936) | 7 | 9 | 11 | 28852 | 10 | |||
61904 | 110184 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 1500x LYON ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999718 | 2114083 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | 15 | 6 | 1 | 29490 | 31 | ||||
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 | ||
62148 | 115558 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 2500x 19TH ST | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6010357 | 2105131 | 37.7608727909959 | -122.407273854716 | (37.7608727909959, -122.407273854716) | 10 | 4 | 8 | 28859 | 19 | ||||
62178 | 189960 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010412.08756 | 2108524.30899 | 37.7701931280454 | -122.407322550708 | (37.7701931280454, -122.407322550708) | 8 | 2 | 9 | 28853 | 34 | |||
62291 | 5529 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 895 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 4X4 | 6005093.86648 | 2103161.82188 | 37.7551699235695 | -122.425336590916 | (37.7551699235695, -122.425336590916) | 2 | 4 | 5 | 28859 | 19 | |||
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 | |||
62483 | 119737 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6013490.74423 | 2116034.43287 | 37.7909860356216 | -122.397200129801 | (37.7909860356216, -122.397200129801) | 12 | 2 | 9 | 28855 | 6 | ||||
62764 | 16626 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 138 Noe St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/02/2001 12:00:00 AM | 21 | 3X3 | 6002836.08721 | 2107485.6498 | 37.7669142960875 | -122.43345361721 | (37.7669142960875, -122.43345361721) | 15 | 5 | 5 | 28862 | 3 | ||
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 | |||
62825 | 246517 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 41 Waller St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6005417.73549 | 2109222.56247 | 37.7718295731126 | -122.424647671566 | (37.7718295731126, -122.424647671566) | 7 | 9 | 5 | 28852 | 10 | |||
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 | |||
62929 | 57320 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2728 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1976 12:00:00 AM | 15 | Permit Number 16145 | 5999531.6355 | 2114001.5838 | 37.7846173544843 | -122.445351698652 | (37.7846173544843, -122.445351698652) | 15 | 6 | 1 | 29490 | 31 | ||
63208 | 206021 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 42 Stanford Heights Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5997867.55836 | 2095818.65061 | 37.7345964514605 | -122.449798003996 | (37.7345964514605, -122.449798003996) | 9 | 7 | 4 | 59 | 40 | |||
63341 | 189955 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 145 Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6014561.09202 | 2115949.59191 | 37.790812611275 | -122.393490799583 | (37.790812611275, -122.393490799583) | 12 | 2 | 9 | 28855 | 6 | |||
63547 | 57317 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2706 Sutter St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1976 12:00:00 AM | 13 | Permit Number 16141 | 5999606.4685 | 2114016.4513 | 37.7846624482509 | -122.445093871748 | (37.7846624482509, -122.445093871748) | 15 | 6 | 1 | 29490 | 31 | ||
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 | |||
63609 | 222900 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3733 20th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6005413.47026 | 2104278.82733 | 37.7582550109751 | -122.424310747749 | (37.7582550109751, -122.424310747749) | 2 | 4 | 5 | 28859 | 19 | |||
63652 | 104633 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 850 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | 6009360 | 2104224 | 37.7583265252915 | -122.410657998143 | (37.7583265252915, -122.410657998143) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
64038 | 248270 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 157 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006694.18006 | 2098651.40644 | 37.7428756308979 | -122.419482249905 | (37.7428756308979, -122.419482249905) | 2 | 7 | 7 | 28859 | 2 | |||
64093 | 21787 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2585 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 4X4 | 6008331.30284 | 2121636.25204 | 37.8060786554609 | -122.415448406282 | (37.8060786554609, -122.415448406282) | 5 | 1 | 10 | 308 | 23 | |||
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 | |||
64750 | 21777 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2500X Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12/15/1992 12:00:00 AM | 3 | 3x3 | 6008409.45282 | 2121407.87429 | 37.8054559800011 | -122.415161778523 | (37.8054559800011, -122.415161778523) | 5 | 1 | 10 | 308 | 23 | ||
64795 | 225045 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 881 Alabama St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6009145.12233 | 2103987.25914 | 37.7576644387915 | -122.411384417877 | (37.7576644387915, -122.411384417877) | 2 | 4 | 7 | 28859 | 19 | |||
64807 | 248261 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 136 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006731.57977 | 2098768.277 | 37.7431986377163 | -122.419361220966 | (37.7431986377163, -122.419361220966) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |
65527 | 248255 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 116 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006791.47872 | 2098879.96545 | 37.7435086825726 | -122.41916202653 | (37.7435086825726, -122.41916202653) | 2 | 7 | 7 | 28859 | 2 | |||
65585 | 248202 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 51 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006954.7875 | 2099136.48348 | 37.7442222190818 | -122.418615530989 | (37.7442222190818, -122.418615530989) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
66277 | 222890 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2761 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6009529.18788 | 2103922.95806 | 37.757509416346 | -122.4100516172 | (37.757509416346, -122.4100516172) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
66742 | 225072 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 902 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009377.02442 | 2103868.3997 | 37.7573510817046 | -122.410574009103 | (37.7573510817046, -122.410574009103) | 2 | 4 | 7 | 28859 | 19 | |||
66852 | 222897 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2771 22nd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009509.00989 | 2103333.02961 | 37.7558884746751 | -122.41007975427 | (37.7558884746751, -122.41007975427) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
67065 | 222911 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004864.94155 | 2109835.08183 | 37.7734801672159 | -122.426603448797 | (37.7734801672159, -122.426603448797) | 7 | 9 | 11 | 28852 | 10 | |||
67119 | 189932 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013255.69526 | 2116279.68267 | 37.7916463457648 | -122.398030607826 | (37.7916463457648, -122.398030607826) | 12 | 2 | 9 | 28855 | 6 | |||
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 | |||
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 | |||
67416 | 125984 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 6ft | 6008373.73288 | 2121637.11508 | 37.8060834098955 | -122.41530163086 | (37.8060834098955, -122.41530163086) | 5 | 1 | 10 | 308 | 23 | |||
67442 | 21780 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2535 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | 4X4 | 6008357.89402 | 2121452.8869 | 37.805576675639 | -122.41534339379 | (37.805576675639, -122.41534339379) | 5 | 1 | 10 | 308 | 23 | |||
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 | |||
67782 | 125998 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6007907.02571 | 2121498.39071 | 37.8056762669961 | -122.416906917118 | (37.8056762669961, -122.416906917118) | 5 | 1 | 10 | 308 | 23 | |||
67860 | 57316 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1515 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/31/1976 12:00:00 AM | 13 | Permit Number 16140 | 5999629.2653 | 2114178.0114 | 37.7851073514303 | -122.445026621162 | (37.7851073514303, -122.445026621162) | 15 | 6 | 1 | 29490 | 31 | ||
68290 | 57557 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 88 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/26/1976 12:00:00 AM | 8 | 3x3 | Permit Number 16422 | 6006885 | 2099070 | 37.7440357411005 | -122.418852127392 | (37.7440357411005, -122.418852127392) | 2 | 7 | 7 | 28859 | 2 | |
68552 | 138242 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1509 Lyon St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 5999647.1063 | 2114070.9654 | 37.7848144491807 | -122.444957199215 | (37.7848144491807, -122.444957199215) | 15 | 6 | 1 | 29490 | 31 | |||
68805 | 225098 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 290 Waller St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 6004313.03232 | 2109116.83696 | 37.7714768248189 | -122.428461378912 | (37.7714768248189, -122.428461378912) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
69120 | 125994 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008347.52133 | 2121476.34798 | 37.8056405108592 | -122.415380951989 | (37.8056405108592, -122.415380951989) | 5 | 1 | 10 | 308 | 23 | |||
69517 | 48533 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 500(REVISED) Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | 2 | 4 | 7 | 28859 | 19 | |||
69631 | 189954 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 145 Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 4ft | 6014570.20304 | 2115942.2831 | 37.7907930492013 | -122.393458763924 | (37.7907930492013, -122.393458763924) | 12 | 2 | 9 | 28855 | 6 | |||
69905 | 222921 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 957 Cole St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 4ft | 5998078.46928 | 2106885.24351 | 37.7649946607859 | -122.449866104246 | (37.7649946607859, -122.449866104246) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
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 | |||
70904 | 115849 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3501 Laguna St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 3x3 | 6003588.62501 | 2120788.73766 | 37.8034838925183 | -122.431800659668 | (37.8034838925183, -122.431800659668) | 13 | 9 | 1 | 57 | 17 | |||
70907 | 102876 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2761 21st St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6009574.6 | 2103896.5 | 37.7574393136514 | -122.409892695521 | (37.7574393136514, -122.409892695521) | 2 | 4 | 7 | 28859 | 19 | ||||
71028 | 189931 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013267.71842 | 2116267.46362 | 37.7916134647515 | -122.397988149957 | (37.7916134647515, -122.397988149957) | 12 | 2 | 9 | 28855 | 6 | |||
71054 | 21785 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2585 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 4X4 | 6008161.90241 | 2121549.79462 | 37.8058317424248 | -122.41602851934 | (37.8058317424248, -122.41602851934) | 5 | 1 | 10 | 308 | 23 | |||
71087 | 189833 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 Burke Ave | 2 | : | Tree | DPW 1 | 02/12/2016 12:00:00 AM | 14 | Width 3ft | 6016585.78665 | 2098909.19771 | 37.7441356575455 | -122.385297468507 | (37.7441356575455, -122.385297468507) | 10 | 3 | 8 | 58 | 1 | ||
71557 | 125966 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2198 Filbert St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 4ft | 6002473.45784 | 2118854.30827 | 37.7981091788388 | -122.435521270088 | (37.7981091788388, -122.435521270088) | 13 | 9 | 1 | 57 | 17 | |||
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 | |||
71727 | 65411 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 81 Webster St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/16/1989 12:00:00 AM | Permit Number 28262 | 6004263.16526256 | 2108931.19399052 | 37.7709642723528 | -122.428620636268 | (37.7709642723528, -122.428620636268) | 7 | 9 | 11 | 29492 | 10 | |||
71731 | 205992 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 452 Kenwood Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993371.39802 | 2093686.31414 | 37.728483309841 | -122.465187784693 | (37.728483309841, -122.465187784693) | 9 | 8 | 4 | 59 | 40 | |||
71893 | 189957 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 572 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011483.58307 | 2109635.35024 | 37.7733037049339 | -122.403694422077 | (37.7733037049339, -122.403694422077) | 14 | 2 | 9 | 28853 | 34 | |||
72128 | 225047 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 971 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6009431.36633 | 2103539.27108 | 37.7564504151646 | -122.410362833886 | (37.7564504151646, -122.410362833886) | 2 | 4 | 7 | 28859 | 19 | |||
72220 | 189941 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013331.4553 | 2116106.58194 | 37.7911752709767 | -122.397756329903 | (37.7911752709767, -122.397756329903) | 12 | 2 | 9 | 28855 | 6 | |||
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 | |||
72504 | 225095 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 231 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 1 | Width 3ft | 6004583.37564 | 2109107.4182 | 37.7714662577942 | -122.427525575841 | (37.7714662577942, -122.427525575841) | 7 | 9 | 11 | 28852 | 10 | |||
72975 | 15123 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 2X2 | 6013765.88916 | 2116013.74101 | 37.7909445343765 | -122.396246681474 | (37.7909445343765, -122.396246681474) | 12 | 2 | 9 | 28855 | 6 | |||
72985 | 21790 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2585 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 4X4 | 6008342.51156 | 2121554.8602 | 37.8058558040212 | -122.415403850799 | (37.8058558040212, -122.415403850799) | 5 | 1 | 10 | 308 | 23 | |||
73221 | 189956 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 572 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011467.9689 | 2109652.48068 | 37.7733498689462 | -122.403749639528 | (37.7733498689462, -122.403749639528) | 14 | 2 | 9 | 28853 | 34 | |||
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 | |||
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 | |||
74084 | 124322 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 115 Jordan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5996192.87314 | 2113669.73604 | 37.7835150337529 | -122.456878613619 | (37.7835150337529, -122.456878613619) | 11 | 6 | 1 | 54 | 31 | |||
74298 | 225086 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3689 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003831.7176 | 2103603.4271 | 37.7563110786983 | -122.429732966312 | (37.7563110786983, -122.429732966312) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
75012 | 138241 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1509 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999646.1152 | 2114082.8594 | 37.7848470504501 | -122.444961483404 | (37.7848470504501, -122.444961483404) | 15 | 6 | 1 | 29490 | 31 | |||
75130 | 248258 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006769.18682 | 2098841.93634 | 37.7434030077589 | -122.419236409442 | (37.7434030077589, -122.419236409442) | 2 | 7 | 7 | 28859 | 2 |
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) );