trees
668 rows where qLegalStatus_id = 1 and 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) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13958 | 262096 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Width 3ft | 6016433.67399 | 2098382.99048 | 37.7426823836985 | -122.385786776164 | (37.7426823836985, -122.385786776164) | 10 | 3 | 8 | 58 | 1 | ||||
| 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 | ||||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 16205 | 222929 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 979 Ashbury St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/21/1979 12:00:00 AM | 10 | Width 4ft | Permit Number 17592 | 5999199.8898 | 2106672.6396 | 37.7644750037296 | -122.445972112616 | (37.7644750037296, -122.445972112616) | 15 | 5 | 11 | 29492 | 9 | |
| 23100 | 125989 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008326.45195 | 2121634.40634 | 37.8060733149832 | -122.41546506288 | (37.8060733149832, -122.41546506288) | 5 | 1 | 10 | 308 | 23 | |||
| 25898 | 225060 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 243 Parnassus Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5997087.67897 | 2106671.87912 | 37.7643520771977 | -122.453277577199 | (37.7643520771977, -122.453277577199) | 15 | 5 | 11 | 29492 | 12 | |||
| 32911 | 248271 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 157 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006700.68835 | 2098666.52237 | 37.7429175024299 | -122.419460818167 | (37.7429175024299, -122.419460818167) | 2 | 7 | 7 | 28859 | 2 | |||
| 35660 | 115844 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003543.04696 | 2120740.86009 | 37.8033498494719 | -122.43195496357 | (37.8033498494719, -122.43195496357) | 13 | 9 | 1 | 57 | 17 | |||
| 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 | |||
| 45877 | 248276 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 137 Lundy's Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006755.61156 | 2098766.6947 | 37.7431956465585 | -122.419278012984 | (37.7431956465585, -122.419278012984) | 2 | 7 | 7 | 28859 | 2 | |||
| 47090 | 222910 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6004846.32395 | 2109834.20253 | 37.7734767003282 | -122.426667787188 | (37.7734767003282, -122.426667787188) | 7 | 9 | 11 | 28852 | 10 | |||
| 48025 | 248201 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 53 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006949.2101 | 2099121.02775 | 37.7441794671077 | -122.418633720666 | (37.7441794671077, -122.418633720666) | 2 | 7 | 7 | 28859 | 2 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 111174 | 248263 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 140 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006717.3063 | 2098747.87418 | 37.7431418122345 | -122.419409127839 | (37.7431418122345, -122.419409127839) | 2 | 7 | 7 | 28859 | 2 | |||
| 113408 | 139006 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1504 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 0ft | 5999695.1779 | 2114053.1244 | 37.7847682058679 | -122.444789604899 | (37.7847682058679, -122.444789604899) | 15 | 6 | 1 | 29490 | 31 | |||
| 116588 | 222905 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6004739.78961 | 2109820.49268 | 37.7734330328342 | -122.427035328438 | (37.7734330328342, -122.427035328438) | 7 | 9 | 11 | 28852 | 10 | |||
| 117653 | 205999 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 60 Chilton Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6001682.52176 | 2095686.82759 | 37.7344520302196 | -122.436598984369 | (37.7344520302196, -122.436598984369) | 2 | 7 | 5 | 63 | 7 | |||
| 118207 | 225062 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 139 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 5998883.5307 | 2107364.06639 | 37.7663554177878 | -122.447116070946 | (37.7663554177878, -122.447116070946) | 15 | 5 | 11 | 29492 | 9 | |||
| 129552 | 189854 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 4 | : | Tree | Private 2 | 10 | Width 3ft | 6017283.71117 | 2098187.47887 | 37.7421925499461 | -122.382833960126 | (37.7421925499461, -122.382833960126) | 10 | 3 | 8 | 58 | 1 | |||
| 136796 | 248230 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 74 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006935.57349 | 2099151.82262 | 37.7442632551522 | -122.418683056597 | (37.7442632551522, -122.418683056597) | 2 | 7 | 7 | 28859 | 2 | |||
| 143777 | 189858 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 8 | : | Tree | Private 2 | 10 | Width 4ft | 6017192.20681 | 2098235.03839 | 37.7423180827181 | -122.383153666435 | (37.7423180827181, -122.383153666435) | 10 | 3 | 8 | 58 | 1 | |||
| 144028 | 125988 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6008319.39655 | 2121673.00017 | 37.806178887323 | -122.415492213411 | (37.806178887323, -122.415492213411) | 5 | 1 | 10 | 308 | 23 | |||
| 149944 | 248228 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 70 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006955.04848 | 2099184.3603 | 37.744353692776 | -122.418618023005 | (37.744353692776, -122.418618023005) | 2 | 7 | 7 | 28859 | 2 | |||
| 153118 | 189887 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 1 | : | Tree | Private 2 | 10 | Width 3ft | 6016910.34518 | 2098303.24769 | 37.7424897920671 | -122.384133016442 | (37.7424897920671, -122.384133016442) | 10 | 3 | 8 | 58 | 1 | |||
| 153705 | 51299 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300X Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2004 12:00:00 AM | 10 | Permit Number 47670 | 6008033.00976 | 2112757.64367 | 37.7816834187084 | -122.415851598691 | (37.7816834187084, -122.415851598691) | 7 | 10 | 9 | 28852 | 36 | |
| 154326 | 175840 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 658 Edinburgh St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6002330.91523 | 2089965.9471 | 37.7187806097236 | -122.433948484453 | (37.7187806097236, -122.433948484453) | 9 | 7 | 6 | 28861 | 5 | |||
| 159275 | 225067 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 900 Alabama St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6009115.2795 | 2103823.24781 | 37.7572124269416 | -122.411476039894 | (37.7572124269416, -122.411476039894) | 2 | 4 | 7 | 28859 | 19 | |||
| 159563 | 205993 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 334 Pacheco St | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 10 | Width 3ft | 5994259.77922 | 2101011.29176 | 37.7486470679175 | -122.462647767404 | (37.7486470679175, -122.462647767404) | 1 | 8 | 4 | 29491 | 40 | |||
| 166050 | 222891 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2759 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 6009566.16928 | 2103923.02169 | 37.7575116637409 | -122.409923724614 | (37.7575116637409, -122.409923724614) | 2 | 4 | 7 | 28859 | 19 | |||
| 169536 | 222895 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3080 16th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | Permit Number 27054 | 6006273.18784 | 2106724.09401 | 37.7650176483701 | -122.421511125848 | (37.7650176483701, -122.421511125848) | 8 | 4 | 7 | 28853 | 19 | ||
| 171993 | 225042 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 979 Ashbury St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 4ft | 5999193.16537 | 2106656.55415 | 37.7644304531311 | -122.445994213458 | (37.7644304531311, -122.445994213458) | 15 | 5 | 11 | 29492 | 9 | |||
| 172152 | 189849 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 12 | : | Tree | Private 2 | 10 | Width 4ft | 6017283.17469 | 2098125.85242 | 37.7420233065307 | -122.38283152746 | (37.7420233065307, -122.38283152746) | 10 | 3 | 8 | 58 | 1 | |||
| 174284 | 189893 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 7 | : | Tree | Private 2 | 10 | Width 3ft | 6016784.24817 | 2098329.21731 | 37.7425541268854 | -122.384570835175 | (37.7425541268854, -122.384570835175) | 10 | 3 | 8 | 58 | 1 | |||
| 176007 | 189894 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 8 | : | Tree | Private 2 | 10 | Width 3ft | 6016764.20599 | 2098333.7275 | 37.7425654025768 | -122.384640449909 | (37.7425654025768, -122.384640449909) | 10 | 3 | 8 | 58 | 1 | |||
| 179100 | 115843 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Bay St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003556.38477 | 2120742.54729 | 37.8033552382023 | -122.431908928161 | (37.8033552382023, -122.431908928161) | 13 | 9 | 1 | 57 | 17 | |||
| 180800 | 248209 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 37 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6007043.43628 | 2099296.21325 | 37.7446657917085 | -122.418320324941 | (37.7446657917085, -122.418320324941) | 2 | 7 | 7 | 28859 | 2 | |||
| 187600 | 56853 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 245 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/01/1974 12:00:00 AM | 10 | Permit Number 14088 | 6004257.88058 | 2091960.10063 | 37.7243652845164 | -122.427429718013 | (37.7243652845164, -122.427429718013) | 9 | 7 | 6 | 28861 | 5 | ||
| 192846 | 175841 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 407 Paris St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 2ft | 6002201.57312 | 2091201.22242 | 37.7221650589433 | -122.434483841864 | (37.7221650589433, -122.434483841864) | 9 | 7 | 6 | 28861 | 5 | |||
| 32130 | 5658 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1349-1349 Dolores St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 100 | 3X3 | 6005239.88286 | 2100530.07402 | 37.7479520016853 | -122.42464442051 | (37.7479520016853, -122.42464442051) | 2 | 4 | 5 | 28859 | 19 | |||
| 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 | |||
| 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 | |
| 9983 | 248199 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 55 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006933.20129 | 2099091.48631 | 37.7440974516285 | -122.41868698122 | (37.7440974516285, -122.41868698122) | 2 | 7 | 7 | 28859 | 2 | |||
| 17034 | 96473 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | Permit Number 767637 | 6014754.27658 | 2116074.97331 | 37.7911676114441 | -122.392831160352 | (37.7911676114441, -122.392831160352) | 12 | 2 | 9 | 28855 | 6 | ||
| 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 | |||
| 18852 | 222928 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 912 Clayton St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998758.16977 | 2106859.07637 | 37.7649616790718 | -122.447513315894 | (37.7649616790718, -122.447513315894) | 15 | 5 | 11 | 29492 | 9 | |||
| 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 | |||
| 21283 | 225084 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3784 22nd St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6003185.26448 | 2103031.00379 | 37.7547027131682 | -122.431927750974 | (37.7547027131682, -122.431927750974) | 2 | 4 | 5 | 28862 | 22 | |||
| 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 | |||
| 31579 | 225050 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 500x 27th St | 24 | Median : Cutout | Tree | DPW 1 | 11 | Width 4ft | 6002949.31338 | 2100070.05084 | 37.7465592558077 | -122.432532251866 | (37.7465592558077, -122.432532251866) | 2 | 7 | 5 | 63 | 22 | |||
| 53638 | 138239 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1509 Lyon St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999639.177 | 2114119.037 | 37.784945988756 | -122.444988088871 | (37.784945988756, -122.444988088871) | 15 | 6 | 1 | 29490 | 31 | |||
| 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 | |||
| 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 | |||
| 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 | |||
| 77339 | 225088 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3899 19th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6003725.04695 | 2104766.83601 | 37.7594994820291 | -122.430184865761 | (37.7594994820291, -122.430184865761) | 2 | 4 | 5 | 28862 | 3 | |||
| 79345 | 18853 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2222 Sacramento St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3X3 | 6004009.33777 | 2116018.08762 | 37.7904087527096 | -122.430004251319 | (37.7904087527096, -122.430004251319) | 13 | 9 | 1 | 29490 | 27 | |||
| 85002 | 125991 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6008338.82398 | 2121554.95666 | 37.8058558616148 | -122.415416619107 | (37.8058558616148, -122.415416619107) | 5 | 1 | 10 | 308 | 23 | |||
| 85099 | 225087 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3901 19th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6003680.66693 | 2104762.35118 | 37.7594846540097 | -122.430338033793 | (37.7594846540097, -122.430338033793) | 2 | 4 | 5 | 28862 | 3 | |||
| 88195 | 189918 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 338 Mission St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 5ft | 6013810.73123 | 2116050.81938 | 37.7910488379738 | -122.396094128247 | (37.7910488379738, -122.396094128247) | 12 | 2 | 9 | 28855 | 6 | |||
| 93710 | 40183 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 298X Missouri St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/27/1999 12:00:00 AM | 11 | Permit Number 41371 | 6013446.24914 | 2105734.66956 | 37.7627027466551 | -122.39663174926 | (37.7627027466551, -122.39663174926) | 14 | 3 | 8 | 28856 | 29 | ||
| 111387 | 222904 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6004715.38798 | 2109818.79814 | 37.7734270001802 | -122.427119616485 | (37.7734270001802, -122.427119616485) | 7 | 9 | 11 | 28852 | 10 | |||
| 115384 | 225080 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2823 21st St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6009082.12028 | 2103902.99509 | 37.7574295349581 | -122.411596352099 | (37.7574295349581, -122.411596352099) | 2 | 4 | 7 | 28859 | 19 | |||
| 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 | |||
| 131100 | 106027 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 180 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2015 12:00:00 AM | 11 | 3x3 | Permit Number 770222 | 6014665.81921 | 2115987.91534 | 37.7909236568574 | -122.393131128317 | (37.7909236568574, -122.393131128317) | 12 | 2 | 9 | 28855 | 6 | |
| 131190 | 126002 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6007897.34981 | 2121579.98706 | 37.8058997656297 | -122.416946186927 | (37.8058997656297, -122.416946186927) | 5 | 1 | 10 | 308 | 23 | |||
| 132144 | 222926 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 980 Clayton St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 5998842.04298 | 2106555.36385 | 37.7641325536076 | -122.447201360861 | (37.7641325536076, -122.447201360861) | 15 | 5 | 11 | 29492 | 9 | |||
| 141583 | 225076 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3328 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6007533.56344 | 2101516.41809 | 37.7507895524966 | -122.416782817886 | (37.7507895524966, -122.416782817886) | 2 | 4 | 7 | 28859 | 19 | |||
| 153227 | 248231 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 80 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 3ft | 6006921.48329 | 2099128.86154 | 37.7441994158673 | -122.418730149576 | (37.7441994158673, -122.418730149576) | 2 | 7 | 7 | 28859 | 2 | |||
| 161983 | 189946 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 162 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 1ft | 6014709.04159 | 2116225.6637 | 37.7915788597386 | -122.392998221109 | (37.7915788597386, -122.392998221109) | 12 | 2 | 9 | 28855 | 6 | |||
| 163249 | 189904 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 11 | Width 3ft | 6016400.23461 | 2098374.6941 | 37.7426577530525 | -122.385901822825 | (37.7426577530525, -122.385901822825) | 10 | 3 | 8 | 58 | 1 | |||
| 168987 | 222912 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 4ft | 6004886.98291 | 2109837.99569 | 37.7734894140273 | -122.42652741201 | (37.7734894140273, -122.42652741201) | 7 | 9 | 11 | 28852 | 10 | |||
| 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 | |||
| 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 | |||
| 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 |
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) );