trees
661 rows where qCaretaker_id = 2 and qSpecies_id = 5 sorted by Police Districts
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
103825 | 97186 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
104489 | 189953 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6014700.62775 | 2116023.46282 | 37.7910231956157 | -122.393013179512 | (37.7910231956157, -122.393013179512) | 12 | 2 | 9 | 28855 | 6 | |||
105981 | 106036 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2015 12:00:00 AM | 3x3 | Permit Number 770222 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||
107019 | 225101 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 75 Valencia St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 5ft | 6006050.3801 | 2109334.27291 | 37.7721720124675 | -122.422467246366 | (37.7721720124675, -122.422467246366) | 8 | 2 | 9 | 28853 | 19 | |||
107370 | 189952 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 1ft | 6014715.63981 | 2116037.408 | 37.7910623197318 | -122.392962214036 | (37.7910623197318, -122.392962214036) | 12 | 2 | 9 | 28855 | 6 | |||
107461 | 85255 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Permit Number 49553 | 6013503.0525 | 2116024.16318 | 37.7909585226636 | -122.39715682295 | (37.7909585226636, -122.39715682295) | 12 | 2 | 9 | 28855 | 6 | |||
108134 | 103342 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 590X 09th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6010323 | 2108639 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | 8 | 2 | 9 | 28853 | 34 | |||
108171 | 188473 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 25 | Width 5ft | 6007942.65601 | 2109006.33264 | 37.7713781323189 | -122.415898458759 | (37.7713781323189, -122.415898458759) | 8 | 2 | 9 | 28853 | 19 | |||
109981 | 189920 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 338 Mission St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6013751.03466 | 2115995.67684 | 37.7908941078228 | -122.396296811166 | (37.7908941078228, -122.396296811166) | 12 | 2 | 9 | 28855 | 6 | |||
110444 | 97188 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
111186 | 189933 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013208.14765 | 2116234.45684 | 37.7915195179644 | -122.398191948892 | (37.7915195179644, -122.398191948892) | 12 | 2 | 9 | 28855 | 6 | |||
112676 | 189950 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 2ft | 6014741.1957 | 2116062.87497 | 37.7911336656463 | -122.392875573361 | (37.7911336656463, -122.392875573361) | 12 | 2 | 9 | 28855 | 6 | |||
113987 | 189951 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 6014728.34644 | 2116051.81938 | 37.7911025958469 | -122.392919257911 | (37.7911025958469, -122.392919257911) | 12 | 2 | 9 | 28855 | 6 | |||
114608 | 189938 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013289.37156 | 2116149.22674 | 37.7912900199673 | -122.397904932091 | (37.7912900199673, -122.397904932091) | 12 | 2 | 9 | 28855 | 6 | |||
123100 | 56925 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/15/1974 12:00:00 AM | 12 | Permit Number 14168 | 6014784.53223 | 2116103.90747 | 37.7912487383869 | -122.392728500917 | (37.7912487383869, -122.392728500917) | 12 | 2 | 9 | 28855 | 6 | ||
123765 | 189939 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013302.11078 | 2116136.01551 | 37.7912544544909 | -122.397859927289 | (37.7912544544909, -122.397859927289) | 12 | 2 | 9 | 28855 | 6 | |||
124374 | 97181 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
124477 | 189963 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1000 Brannan St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6010349.36768 | 2108372.96344 | 37.7697740574441 | -122.40752882731 | (37.7697740574441, -122.40752882731) | 8 | 2 | 9 | 28853 | 34 | |||
127110 | 103340 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 590X 09th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3x3 | Permit Number 772809 | 6010323 | 2108639 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | 8 | 2 | 9 | 28853 | 34 | ||
127764 | 97182 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
128485 | 97184 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013138 | 2116168 | 37.791333135618 | -122.398429995238 | (37.791333135618, -122.398429995238) | 12 | 2 | 9 | 28855 | 6 | |||
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 | |
134295 | 189961 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6010424.61803 | 2108510.17842 | 37.7701550300493 | -122.407278211428 | (37.7701550300493, -122.407278211428) | 8 | 2 | 9 | 28853 | 34 | |||
136547 | 22889 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 95X Valencia St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 30 | 3X3 | 6006042.93395 | 2109155.55847 | 37.7716808854236 | -122.422480302267 | (37.7716808854236, -122.422480302267) | 8 | 2 | 9 | 28853 | 19 | |||
137700 | 189922 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 8 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6013429.98555 | 2116100.18474 | 37.791163192164 | -122.397414967051 | (37.791163192164, -122.397414967051) | 12 | 2 | 9 | 28855 | 6 | |||
138761 | 189947 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 162 Spear St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 1ft | 6014726.02618 | 2116202.25149 | 37.7915155186799 | -122.392937815425 | (37.7915155186799, -122.392937815425) | 12 | 2 | 9 | 28855 | 6 | |||
141155 | 189927 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Fremont St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013321.30985 | 2116211.38819 | 37.7914624793694 | -122.3977987878 | (37.7914624793694, -122.3977987878) | 12 | 2 | 9 | 28855 | 6 | |||
141672 | 188475 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 10 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 5ft | 6007904.0486 | 2109028.39399 | 37.7714365370061 | -122.416033566603 | (37.7714365370061, -122.416033566603) | 8 | 2 | 9 | 28853 | 19 | |||
144602 | 189930 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 5ft | 6013282.15015 | 2116252.99602 | 37.7915745438725 | -122.397937200642 | (37.7915745438725, -122.397937200642) | 12 | 2 | 9 | 28855 | 6 | |||
144683 | 189919 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 338 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6013770.13743 | 2116011.13859 | 37.7909376251249 | -122.396231800058 | (37.7909376251249, -122.396231800058) | 12 | 2 | 9 | 28855 | 6 | |||
146281 | 189940 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013316.29733 | 2116121.55291 | 37.791215533629 | -122.39780982696 | (37.791215533629, -122.39780982696) | 12 | 2 | 9 | 28855 | 6 | |||
147008 | 106033 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||||
154516 | 189965 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 185 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6009800.49683 | 2111495.15523 | 37.7783161303187 | -122.409647766737 | (37.7783161303187, -122.409647766737) | 14 | 2 | 9 | 28853 | 34 | |||
155251 | 103345 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 1000 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | Permit Number 29899 | 6010491 | 2108479 | 37.7700731362443 | -122.407046397751 | (37.7700731362443, -122.407046397751) | 8 | 2 | 9 | 28853 | 34 | ||
156238 | 189936 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013261.48411 | 2116177.89779 | 37.7913671907995 | -122.398003434816 | (37.7913671907995, -122.398003434816) | 12 | 2 | 9 | 28855 | 6 | |||
157690 | 97185 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
158873 | 97183 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
159299 | 189945 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 162 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 1ft | 6014694.61322 | 2116242.67208 | 37.7916247593304 | -122.393049334066 | (37.7916247593304, -122.393049334066) | 12 | 2 | 9 | 28855 | 6 | |||
161020 | 189926 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Fremont St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 5ft | 6013338.6063 | 2116192.95214 | 37.7914128215027 | -122.397737648268 | (37.7914128215027, -122.397737648268) | 12 | 2 | 9 | 28855 | 6 | |||
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 | |||
162198 | 189923 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6013419.15414 | 2116110.66886 | 37.7911913760301 | -122.397453179235 | (37.7911913760301, -122.397453179235) | 12 | 2 | 9 | 28855 | 6 | |||
163468 | 119743 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
165805 | 188470 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 5ft | 6008074.61393 | 2108923.40936 | 37.7711578622784 | -122.415436137088 | (37.7711578622784, -122.415436137088) | 8 | 2 | 9 | 28853 | 19 | |||
166336 | 188472 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6007955.34249 | 2108999.99523 | 37.7713614445082 | -122.415854126661 | (37.7713614445082, -122.415854126661) | 8 | 2 | 9 | 28853 | 19 | |||
173505 | 119746 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
177137 | 189949 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6014767.16396 | 2116087.91405 | 37.791203859513 | -122.392787475772 | (37.791203859513, -122.392787475772) | 12 | 2 | 9 | 28855 | 6 | |||
178073 | 189942 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 160 Spear St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014651.73587 | 2116280.65037 | 37.7917266570015 | -122.393200349112 | (37.7917266570015, -122.393200349112) | 12 | 2 | 9 | 28855 | 6 | |||
179136 | 189964 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 287 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6010268.27805 | 2111003.99646 | 37.7769937249279 | -122.407994884783 | (37.7769937249279, -122.407994884783) | 14 | 2 | 9 | 28853 | 34 | |||
182345 | 222884 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1 Valencia St | 1 | : | Tree | Private 2 | 18 | Width 5ft | 6006058.17228 | 2109199.11331 | 37.7718013362 | -122.422430687153 | (37.7718013362, -122.422430687153) | 8 | 2 | 9 | 28853 | 19 | |||
182570 | 189917 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 338 Mission St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6013829.87851 | 2116068.4816 | 37.7910983996161 | -122.396029117153 | (37.7910983996161, -122.396029117153) | 12 | 2 | 9 | 28855 | 6 | |||
183287 | 188468 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 5ft | 6008096.35172 | 2108912.02487 | 37.7711278249234 | -122.415360138963 | (37.7711278249234, -122.415360138963) | 8 | 2 | 9 | 28853 | 19 | |||
186270 | 119739 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 6013469.82728 | 2116055.87494 | 37.7910437460335 | -122.397274006392 | (37.7910437460335, -122.397274006392) | 12 | 2 | 9 | 28855 | 6 | ||||
187401 | 119740 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6013460.47758 | 2116066.81767 | 37.7910732716747 | -122.397307123936 | (37.7910732716747, -122.397307123936) | 12 | 2 | 9 | 28855 | 6 | ||||
192269 | 189944 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 162 Spear St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6014676.15778 | 2116259.76194 | 37.7916706589171 | -122.393114386531 | (37.7916706589171, -122.393114386531) | 12 | 2 | 9 | 28855 | 6 | |||
194245 | 106032 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Main St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6014366.74772 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | 12 | 2 | 9 | 28855 | 6 | ||||
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 | |||
41358 | 115360 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 205 ARKANSAS ST | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x4 | 6012944 | 2106057 | 37.7635598294353 | -122.398391479388 | (37.7635598294353, -122.398391479388) | 14 | 3 | 8 | 28856 | 29 | ||||
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 | |||
52442 | 188480 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 209 Arkansas St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 4ft | 6012920.54855 | 2106035.89651 | 37.7635005775036 | -122.398471110175 | (37.7635005775036, -122.398471110175) | 14 | 3 | 8 | 28856 | 29 | |||
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 |
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) );