trees
226 rows where PlotSize = "Width 3ft" and qSpecies_id = 5 sorted by rowid descending
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
194344 | 124321 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 115 Jordan Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 12/16/2020 12:00:00 AM | 3 | Width 3ft | 5996193.40211 | 2113658.22839 | 37.7834834671867 | -122.456875951009 | (37.7834834671867, -122.456875951009) | 11 | 6 | 1 | 54 | 31 | ||
194211 | 189883 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 9 | : | Tree | Private 2 | 8 | Width 3ft | 6016619.88237 | 2098309.8227 | 37.7424917822737 | -122.385137818162 | (37.7424917822737, -122.385137818162) | 10 | 3 | 8 | 58 | 1 | |||
193801 | 248275 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 137 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006752.53211 | 2098758.77008 | 37.743173713897 | -122.419288098893 | (37.743173713897, -122.419288098893) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
191608 | 248257 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006778.60351 | 2098856.6294 | 37.7434438819296 | -122.419204890889 | (37.7434438819296, -122.419204890889) | 2 | 7 | 7 | 28859 | 2 | |||
191561 | 206003 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1593 15th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991725.49788 | 2104502.2556 | 37.7580860643266 | -122.471665566325 | (37.7580860643266, -122.471665566325) | 1 | 8 | 4 | 56 | 12 | |||
191380 | 123914 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 389 09th Ave | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 5993078.53663 | 2112857.80843 | 37.7811063777719 | -122.467593853963 | (37.7811063777719, -122.467593853963) | 11 | 6 | 2 | 54 | 11 | |||
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 | |||
189381 | 189911 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1 Flora St | 7 | : | Tree | Private 2 | 5 | Width 3ft | 6013879.72064 | 2094387.80607 | 37.7315707750637 | -122.394338012196 | (37.7315707750637, -122.394338012196) | 10 | 3 | 8 | 58 | 1 | |||
189250 | 189912 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1 Flora St | 8 | : | Tree | Private 2 | 4 | Width 3ft | 6013884.75868 | 2094408.47452 | 37.7316278064595 | -122.394322041155 | (37.7316278064595, -122.394322041155) | 10 | 3 | 8 | 58 | 1 | |||
189232 | 248206 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 39 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007021.99675 | 2099262.74695 | 37.7445726938814 | -122.41839208634 | (37.7445726938814, -122.41839208634) | 2 | 7 | 7 | 28859 | 2 | |||
188712 | 125990 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008335.58159 | 2121584.43449 | 37.8059366180507 | -122.415429928145 | (37.8059366180507, -122.415429928145) | 5 | 1 | 10 | 308 | 23 | |||
188640 | 248208 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 37 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007034.71089 | 2099281.86096 | 37.7446258923754 | -122.418349478271 | (37.7446258923754, -122.418349478271) | 2 | 7 | 7 | 28859 | 2 | |||
187611 | 189884 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 12 | : | Tree | Private 2 | 8 | Width 3ft | 6016685.38219 | 2098298.11667 | 37.7424632629752 | -122.384910521712 | (37.7424632629752, -122.384910521712) | 10 | 3 | 8 | 58 | 1 | |||
187326 | 248200 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 53 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006940.78232 | 2099105.37762 | 37.7441360208722 | -122.418661752548 | (37.7441360208722, -122.418661752548) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
184901 | 189840 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 2 | : | Tree | Private 2 | 3 | Width 3ft | 6017094.37686 | 2098212.93845 | 37.7422519942486 | -122.383490397763 | (37.7422519942486, -122.383490397763) | 10 | 3 | 8 | 58 | 1 | |||
182568 | 206012 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 650 Vicente St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990870.16608 | 2097736.47672 | 37.7394594751618 | -122.474129983014 | (37.7394594751618, -122.474129983014) | 1 | 8 | 4 | 29491 | 40 | |||
182447 | 224898 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1X Bennington St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6007216.8564 | 2097735.11711 | 37.7403891304638 | -122.417610047575 | (37.7403891304638, -122.417610047575) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
179167 | 206017 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 59 Hazelwood Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 9 | Width 3ft | 5996580.00391 | 2094034.75678 | 37.7296245567167 | -122.454120687124 | (37.7296245567167, -122.454120687124) | 9 | 7 | 4 | 28861 | 40 | |||
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 | |||
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 | |||
178019 | 248274 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 137 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6006747.61558 | 2098750.15701 | 37.743149787441 | -122.419304488116 | (37.743149787441, -122.419304488116) | 2 | 7 | 7 | 28859 | 2 | |||
177859 | 248254 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 112 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6006798.65634 | 2098892.16282 | 37.7435425780247 | -122.419138073069 | (37.7435425780247, -122.419138073069) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
176911 | 206011 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 650 Vicente St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990881.65673 | 2097736.82059 | 37.7394610849722 | -122.474090278863 | (37.7394610849722, -122.474090278863) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
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 | |||
174571 | 225065 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 219 Bonview St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6006960.17815 | 2097772.45281 | 37.7404771992577 | -122.418500188445 | (37.7404771992577, -122.418500188445) | 2 | 7 | 7 | 28859 | 2 | |||
174476 | 189889 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6016866.9099 | 2098314.50918 | 37.7425183122785 | -122.384283988325 | (37.7425183122785, -122.384283988325) | 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 | |||
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 | |||
172314 | 225082 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 543 Hill St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 22 | Width 3ft | 6002779.31526 | 2103257.03916 | 37.7553003306644 | -122.433347783174 | (37.7553003306644, -122.433347783174) | 2 | 4 | 5 | 28862 | 22 | |||
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 | |||
170663 | 225064 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 253 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998981.07779 | 2106664.05961 | 37.7644389481338 | -122.446728303069 | (37.7644389481338, -122.446728303069) | 15 | 5 | 11 | 29492 | 9 | |||
170609 | 206008 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 5990990.06403 | 2097739.22497 | 37.7394739659536 | -122.473715632987 | (37.7394739659536, -122.473715632987) | 1 | 8 | 4 | 29491 | 40 | |||
169891 | 205990 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 452 Kenwood Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993405.09676 | 2093676.51676 | 37.7284583518695 | -122.46507057606 | (37.7284583518695, -122.46507057606) | 9 | 8 | 4 | 59 | 40 | |||
169680 | 225063 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 247 Downey St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5998979.47876 | 2106681.18548 | 37.7644858801306 | -122.44673506599 | (37.7644858801306, -122.44673506599) | 15 | 5 | 11 | 29492 | 9 | |||
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 | ||
167962 | 189908 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 8 | Width 3ft | 6016294.30511 | 2098287.70361 | 37.7424130322313 | -122.38626203637 | (37.7424130322313, -122.38626203637) | 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 | |||
166205 | 175843 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 154 Vienna St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 3ft | 6004555.98826 | 2092507.33419 | 37.7258847232758 | -122.426438147115 | (37.7258847232758, -122.426438147115) | 9 | 7 | 6 | 28861 | 5 | |||
166057 | 225074 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3354 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 20 | Width 3ft | 6007335.7626 | 2101504.20622 | 37.7507448939762 | -122.417465967185 | (37.7507448939762, -122.417465967185) | 2 | 4 | 7 | 28859 | 19 | |||
165457 | 225071 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 900 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009374.80383 | 2103883.56216 | 37.7573925899019 | -122.410582759505 | (37.7573925899019, -122.410582759505) | 2 | 4 | 7 | 28859 | 19 | |||
164831 | 206009 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 650 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5990946.44352 | 2097737.21302 | 37.7394659152092 | -122.47386630538 | (37.7394659152092, -122.47386630538) | 1 | 8 | 4 | 29491 | 40 | |||
164614 | 225069 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 892 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009108.56559 | 2103972.85995 | 37.7576228514299 | -122.41150982923 | (37.7576228514299, -122.41150982923) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
161658 | 225096 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 290 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6004357.77926 | 2109121.04656 | 37.7714909154158 | -122.428306896964 | (37.7714909154158, -122.428306896964) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
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 | |||
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 | |||
158664 | 189901 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 7 | Width 3ft | 6016452.46192 | 2098385.21634 | 37.7426895350994 | -122.385721967406 | (37.7426895350994, -122.385721967406) | 10 | 3 | 8 | 58 | 1 | |||
158465 | 188476 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 499 San Bruno Ave | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 5 | Width 3ft | 6010896.57818 | 2106030.20806 | 37.7633719978287 | -122.405471012994 | (37.7633719978287, -122.405471012994) | 8 | 4 | 8 | 28856 | 19 | |||
157121 | 248253 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 112 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 3ft | 6006804.33159 | 2098902.21261 | 37.7435704920937 | -122.419119162122 | (37.7435704920937, -122.419119162122) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
153552 | 248204 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 47 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006982.89792 | 2099182.49751 | 37.7443501458548 | -122.418521593214 | (37.7443501458548, -122.418521593214) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
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 | |||
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 | |||
149591 | 206002 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1593 15th Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991725.37276 | 2104496.31776 | 37.7580697533422 | -122.471665566332 | (37.7580697533422, -122.471665566332) | 1 | 8 | 4 | 56 | 12 | |||
149414 | 205991 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 452 Kenwood Way | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993388.91946 | 2093682.37508 | 37.7284735045328 | -122.465126926677 | (37.7284735045328, -122.465126926677) | 9 | 8 | 4 | 59 | 40 | |||
145696 | 206010 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 650 Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5990906.39798 | 2097737.17838 | 37.7394635005399 | -122.474004761412 | (37.7394635005399, -122.474004761412) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
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 | |||
143317 | 189891 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 5 | : | Tree | Private 2 | 4 | Width 3ft | 6016826.79146 | 2098321.83879 | 37.7425362195639 | -122.384423217764 | (37.7425362195639, -122.384423217764) | 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 | |||
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 | |||
137377 | 225077 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2862 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 27 | Width 3ft | 6009020.65891 | 2103938.13075 | 37.7575225617285 | -122.411811393486 | (37.7575225617285, -122.411811393486) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
136362 | 189853 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 1 | : | Tree | Private 2 | 8 | Width 3ft | 6017352.03209 | 2098141.27696 | 37.7420694633311 | -122.382594511142 | (37.7420694633311, -122.382594511142) | 10 | 3 | 8 | 58 | 1 | |||
135947 | 225081 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 181 College Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6004907.37106 | 2095955.144 | 37.7353714997996 | -122.425468699532 | (37.7353714997996, -122.425468699532) | 2 | 7 | 5 | 28861 | 2 | |||
135682 | 189909 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 10 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 9 | Width 3ft | 6016264.27306 | 2098246.63974 | 37.7422986168968 | -122.386363016745 | (37.7422986168968, -122.386363016745) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
133710 | 222919 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 121 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 5997880.24105 | 2107132.61559 | 37.7656625378249 | -122.450569558437 | (37.7656625378249, -122.450569558437) | 15 | 5 | 11 | 29492 | 9 | |||
131488 | 225048 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2823 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6009293.07164 | 2103911.54746 | 37.7574648486362 | -122.410867399417 | (37.7574648486362, -122.410867399417) | 2 | 4 | 7 | 28859 | 19 | |||
130222 | 248198 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 57 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 6006917.65895 | 2099068.87829 | 37.7440345000033 | -122.418739120308 | (37.7440345000033, -122.418739120308) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
129151 | 188481 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 Burke Ave | 10 | : | Tree | Private 2 | 08/24/2017 12:00:00 AM | 3 | Width 3ft | 6016299.33242 | 2099120.87091 | 37.7447010172388 | -122.386302728 | (37.7447010172388, -122.386302728) | 10 | 3 | 8 | 58 | 1 | ||
126551 | 125995 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 9 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6008349.66203 | 2121453.17315 | 37.8055769989413 | -122.415371902112 | (37.8055769989413, -122.415371902112) | 5 | 1 | 10 | 308 | 23 | |||
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 | |||
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 | |||
124439 | 189888 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 200 Newhall St | 2 | : | Tree | Private 2 | 6 | Width 3ft | 6016891.26784 | 2098307.49665 | 37.7425004040788 | -122.384199276697 | (37.7425004040788, -122.384199276697) | 10 | 3 | 8 | 58 | 1 | |||
124058 | 225092 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 66 Carmelita St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 6002638.75231 | 2108633.09345 | 37.7700536971488 | -122.434218205527 | (37.7700536971488, -122.434218205527) | 15 | 5 | 5 | 29492 | 9 | |||
124051 | 248207 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 39 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007026.81239 | 2099268.29908 | 37.7445882098712 | -122.418375828376 | (37.7445882098712, -122.418375828376) | 2 | 7 | 7 | 28859 | 2 | |||
123006 | 189856 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 6 | : | Tree | Private 2 | 6 | Width 3ft | 6017223.11391 | 2098220.28067 | 37.7422792688651 | -122.383045771154 | (37.7422792688651, -122.383045771154) | 10 | 3 | 8 | 58 | 1 | |||
122903 | 125992 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008341.11218 | 2121531.47257 | 37.8057915088426 | -122.415407036818 | (37.8057915088426, -122.415407036818) | 5 | 1 | 10 | 308 | 23 | |||
120839 | 206020 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 146 Castenada Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 6 | Width 3ft | 5994480.54768 | 2101060.81011 | 37.7487957447457 | -122.461887948175 | (37.7487957447457, -122.461887948175) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
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 | |||
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 | |||
115453 | 222918 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 140 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 3ft | 5997702.83236 | 2107152.93734 | 37.7657081802151 | -122.451184638974 | (37.7657081802151, -122.451184638974) | 15 | 5 | 11 | 29492 | 9 | |||
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 | |||
115285 | 222894 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3080 16th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 06/14/1989 12:00:00 AM | 14 | Width 3ft | Permit Number 27054 | 6006296.82054 | 2106727.45524 | 37.765028210007 | -122.421429624803 | (37.765028210007, -122.421429624803) | 8 | 4 | 7 | 28853 | 19 | |
114437 | 206015 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 351 Montecito Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 23 | Width 3ft | 5995922.8819 | 2094068.30815 | 37.7296789783055 | -122.456394837862 | (37.7296789783055, -122.456394837862) | 9 | 7 | 4 | 28861 | 40 | |||
114352 | 248264 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 140 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 6006711.60121 | 2098736.37276 | 37.743109910586 | -122.419428038785 | (37.743109910586, -122.419428038785) | 2 | 7 | 7 | 28859 | 2 | |||
112246 | 125993 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2501 Taylor St | 7 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 3ft | 6008342.47163 | 2121500.19485 | 37.8057057045282 | -122.415400116539 | (37.8057057045282, -122.415400116539) | 5 | 1 | 10 | 308 | 23 | |||
111983 | 206019 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 99 Merced Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 3ft | 5994816.51833 | 2099704.78199 | 37.7450917681756 | -122.460627918846 | (37.7450917681756, -122.460627918846) | 1 | 8 | 4 | 59 | 40 | |||
111910 | 189867 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 401 Newhall St | 2 | : | Tree | Private 2 | 16 | Width 3ft | 6016089.46635 | 2097928.70806 | 37.7414159637784 | -122.38694528192 | (37.7414159637784, -122.38694528192) | 10 | 3 | 8 | 58 | 1 | |||
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 |
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) );