trees
668 rows where qLegalStatus_id = 1 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 | |||
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 | |||
192927 | 16499 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016428.13466 | 2098327.93774 | 37.7425309135822 | -122.385802093385 | (37.7425309135822, -122.385802093385) | 10 | 3 | 8 | 58 | 1 | |||
192924 | 125980 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 4ft | 6008387.31056 | 2121533.89692 | 37.8058007619722 | -122.415247331605 | (37.8058007619722, -122.415247331605) | 5 | 1 | 10 | 308 | 23 | |||
192875 | 2502 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 6 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016691.63378 | 2098834.3481 | 37.743935990944 | -122.38492625536 | (37.743935990944, -122.38492625536) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
192717 | 222909 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 4ft | 6004826.79581 | 2109830.90843 | 37.7734665514719 | -122.426735103265 | (37.7734665514719, -122.426735103265) | 7 | 9 | 11 | 28852 | 10 | |||
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 | |||
191865 | 2511 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1501 Burke Ave | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067 | 37.743747386446 | -122.384952066789 | (37.743747386446, -122.384952066789) | 10 | 3 | 8 | 58 | 1 | |||
191816 | 115841 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3501 Laguna St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 09/19/2017 12:00:00 AM | 3 | 3x3 | 6003584.99572 | 2120815.79777 | 37.8035579867804 | -122.431815152253 | (37.8035579867804, -122.431815152253) | 13 | 9 | 1 | 57 | 17 | ||
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 | |||
191495 | 225054 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 342 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 15 | Width 2ft | 6001139.36381 | 2096693.29596 | 37.7371846769336 | -122.438548945674 | (37.7371846769336, -122.438548945674) | 2 | 7 | 5 | 63 | 7 | |||
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 | |||
191303 | 14915 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 9 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017191.33538 | 2098236.4203 | 37.7423218290085 | -122.383156775767 | (37.7423218290085, -122.383156775767) | 10 | 3 | 8 | 58 | 1 | |||
190873 | 2530 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 Burke Ave | 8 | 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 | |||
190306 | 93110 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53024 | 6016603.54888 | 2098366.45199 | 37.7426463712226 | -122.385198240014 | (37.7426463712226, -122.385198240014) | 10 | 3 | 8 | 58 | 1 | |
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 | |||
189953 | 189835 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1698 Galvez Ave | 7 | Sidewalk: Property side : Yard | Tree | Private 2 | 9 | Width 8ft | 6015422.83464 | 2098030.46357 | 37.7416584290923 | -122.389257386733 | (37.7416584290923, -122.389257386733) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
188809 | 218314 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 437 Castenada Ave | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 0ft | 5993129.70143 | 2099920.62697 | 37.7455872325622 | -122.466476271275 | (37.7455872325622, -122.466476271275) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
187922 | 10409 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1398 HAIGHT ST | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 24 | 3x3 | 5999436 | 2108778 | 37.7702692735678 | -122.445306860847 | (37.7702692735678, -122.445306860847) | 15 | 5 | 11 | 29492 | 9 | |||
187721 | 125971 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100 Hyde St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 4ft | 6008148.4886 | 2112831.14919 | 37.7818917385495 | -122.415457300812 | (37.7818917385495, -122.415457300812) | 7 | 10 | 9 | 28852 | 36 | |||
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 | |||
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 | ||
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 | ||||
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 | |||
186991 | 16521 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 375 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016284.3157 | 2098184.69928 | 37.7421296504552 | -122.386289397351 | (37.7421296504552, -122.386289397351) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||||
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 | |||
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 | |||
185290 | 4919 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 05/11/2016 12:00:00 AM | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | ||
184994 | 225046 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 901 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6009412.50008 | 2103884.66728 | 37.7573977376442 | -122.41045246843 | (37.7573977376442, -122.41045246843) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
183957 | 16509 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12/03/1992 12:00:00 AM | 3 | 3X3 | 6016661.92107 | 2098301.48789 | 37.742471221974 | -122.384991878867 | (37.742471221974, -122.384991878867) | 10 | 3 | 8 | 58 | 1 | ||
183470 | 4916 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 01/26/2015 05:46:00 AM | 3 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | ||
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 | |||
182657 | 5384 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325X Dolores St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 90 | 4X4 | 6004919.4864142 | 2106495.5645768 | 37.7643137401636 | -122.426176974515 | (37.7643137401636, -122.426176974515) | 8 | 4 | 5 | 28859 | 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 | |||
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 | |||
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 | |||
181416 | 225043 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 463 Nevada St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 2ft | 6008911.67409 | 2096164.66425 | 37.7361722309519 | -122.411639081583 | (37.7361722309519, -122.411639081583) | 10 | 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 | |||
180338 | 14917 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 11 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6017157.89779 | 2098250.45331 | 37.7423585130106 | -122.383273370488 | (37.7423585130106, -122.383273370488) | 10 | 3 | 8 | 58 | 1 | |||
179658 | 2505 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1501 Burke Ave | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016682.7889975 | 2098765.8378067 | 37.743747386446 | -122.384952066789 | (37.743747386446, -122.384952066789) | 10 | 3 | 8 | 58 | 1 | |||
179562 | 2526 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1570 Burke Ave | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | 3X3 | 6016552.46567 | 2098935.10176 | 37.744204941317 | -122.385414490998 | (37.744204941317, -122.385414490998) | 10 | 3 | 8 | 58 | 1 | |||
179176 | 139007 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1504 Lyon St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 14 | Width 0ft | 5999691.7088 | 2114071.461 | 37.7848183554363 | -122.444802925313 | (37.7848183554363, -122.444802925313) | 15 | 6 | 1 | 29490 | 31 | |||
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 | |||
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 | |||
178863 | 125997 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6007910.60432 | 2121475.90892 | 37.8056147389887 | -122.416892938958 | (37.8056147389887, -122.416892938958) | 5 | 1 | 10 | 308 | 23 | |||
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 | |||
177736 | 14931 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016461.7664057 | 2098387.7906821 | 37.7426971185746 | -122.385689974252 | (37.7426971185746, -122.385689974252) | 10 | 3 | 8 | 58 | 1 | |||
177283 | 16490 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 305X Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016659.29203 | 2098304.79019 | 37.7424801439961 | -122.385001199414 | (37.7424801439961, -122.385001199414) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |||
176301 | 21784 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550X Taylor St | 4 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 02/11/2016 12:00:00 AM | 12 | 4X4 | 6008458.56586 | 2121488.77145 | 37.8056808631332 | -122.41499754514 | (37.8056808631332, -122.41499754514) | 3 | 1 | 10 | 308 | 23 | ||
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 | |||
175659 | 225049 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 500x 27th St | 22 | Median : Cutout | Tree | DPW 1 | 6 | Width 4ft | 6002919.63953 | 2100068.30287 | 37.7465527734974 | -122.432634735922 | (37.7465527734974, -122.432634735922) | 2 | 7 | 5 | 63 | 22 | |||
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 | |||
175440 | 7419 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1090 Folsom St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 50 | 3X3 | 6010341.13591 | 2111005.37017 | 37.777001575706 | -122.407742942642 | (37.777001575706, -122.407742942642) | 14 | 2 | 9 | 28853 | 34 | |||
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 | |||
175245 | 2498 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016761.82696 | 2098799.80324 | 37.7438450200413 | -122.384681135251 | (37.7438450200413, -122.384681135251) | 10 | 3 | 8 | 58 | 1 | |||
175193 | 16501 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 3 | 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 | |||
174999 | 205996 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 5998822.4881 | 2096514.65172 | 37.7365620951723 | -122.446546561796 | (37.7365620951723, -122.446546561796) | 9 | 7 | 4 | 59 | 40 | |||
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 | |||
173950 | 16516 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 7 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 10 | 3 | 8 | 58 | 1 | |||
173944 | 189837 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1698 Galvez Ave | 11 | Sidewalk: Property side : Yard | Tree | Private 2 | 16 | Width 8ft | 6015387.45837 | 2098059.88528 | 37.7417372537812 | -122.389381761177 | (37.7417372537812, -122.389381761177) | 10 | 3 | 8 | 58 | 1 | |||
173492 | 16554 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 500X Newhall St | 5 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016006.287148 | 2097894.9109735 | 37.7413185578473 | -122.387230532448 | (37.7413185578473, -122.387230532448) | 10 | 3 | 8 | 58 | 1 | |||
172941 | 225057 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 360 Sussex St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 17 | Width 4ft | 6001062.01743 | 2096696.77883 | 37.7371898399477 | -122.438816616317 | (37.7371898399477, -122.438816616317) | 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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
170549 | 16497 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 305X Newhall St | 8 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016834.58957 | 2098268.17724 | 37.7423893070591 | -122.384392517318 | (37.7423893070591, -122.384392517318) | 10 | 3 | 8 | 58 | 1 | |||
170432 | 199692 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1343 Thomas Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 0ft | 6016085.8906 | 2092920.1706 | 37.7276633287451 | -122.386608480998 | (37.7276633287451, -122.386608480998) | 10 | 3 | 8 | 58 | 1 | |||
169962 | 83036 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 100X Cargo Way | 16 | Sidewalk: Curb side : Cutout | Tree | Port 6 | 03/18/2017 02:55:00 PM | 3 | 6018559.56213 | 2097806.04485 | 37.7412156164156 | -122.378395939846 | (37.7412156164156, -122.378395939846) | 10 | 3 | 8 | 58 | 1 | |||
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 | ||
169246 | 14640 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600X McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 18 | 4x4 | 6006169.26455 | 2112150.7692 | 37.779912136471 | -122.422256155719 | (37.779912136471, -122.422256155719) | 7 | 9 | 11 | 28852 | 41 | |||
169044 | 16510 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 1 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6016409.9700879 | 2098376.06541 | 37.7426620571468 | -122.385868255606 | (37.7426620571468, -122.385868255606) | 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 | |||
168615 | 4389 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 56 Chilton Ave | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 06/09/2008 12:00:00 AM | 30 | 3x3 | 6001657.8215553 | 2095631.9001159 | 37.7342998083721 | -122.436680450501 | (37.7342998083721, -122.436680450501) | 2 | 7 | 5 | 63 | 7 | ||
168028 | 16541 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400X Newhall St | 2 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016112.61616 | 2098044.40161 | 37.7417349164267 | -122.386873303758 | (37.7417349164267, -122.386873303758) | 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) );