trees
226 rows where PlotSize = "Width 3ft" 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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
108228 | 225097 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 290 Waller St | 2 | Sidewalk: Curb side : Yard | Tree | Private 2 | 17 | Width 3ft | 6004333.63591 | 2109116.41234 | 37.7714768248196 | -122.42839007974 | (37.7714768248196, -122.42839007974) | 7 | 9 | 11 | 28852 | 10 | |||
56324 | 225070 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 890 Alabama St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 3ft | 6009108.93583 | 2103990.98377 | 37.757672636103 | -122.411509829221 | (37.757672636103, -122.411509829221) | 2 | 4 | 7 | 28859 | 19 | |||
59723 | 248262 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 136 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 3ft | 6006723.28629 | 2098755.01317 | 37.743161751109 | -122.41938895693 | (37.743161751109, -122.41938895693) | 2 | 7 | 7 | 28859 | 2 | |||
71893 | 189957 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 572 07th St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 2 | Width 3ft | 6011483.58307 | 2109635.35024 | 37.7733037049339 | -122.403694422077 | (37.7733037049339, -122.403694422077) | 14 | 2 | 9 | 28853 | 34 | |||
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 | |||
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 | |||
95860 | 225078 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2844 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 21 | Width 3ft | 6009189.80262 | 2103948.11037 | 37.7575594510339 | -122.411227129126 | (37.7575594510339, -122.411227129126) | 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 | |||
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 | |||
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 | |||
1800 | 189943 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 160 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6014663.90287 | 2116268.03372 | 37.7916926905231 | -122.393157367813 | (37.7916926905231, -122.393157367813) | 12 | 2 | 9 | 28855 | 6 | |||
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 | |||
22540 | 225094 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 621 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780775 | 6002723.2165 | 2108842.98565 | 37.7706348030957 | -122.433941050651 | (37.7706348030957, -122.433941050651) | 15 | 5 | 5 | 29492 | 9 | |
38322 | 206016 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5995893.6658 | 2094152.61505 | 37.7299087874515 | -122.456501934539 | (37.7299087874515, -122.456501934539) | 9 | 7 | 4 | 28861 | 40 | |||
62825 | 246517 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 41 Waller St | 1 | : | Tree | Private 2 | 3 | Width 3ft | 6005417.73549 | 2109222.56247 | 37.7718295731126 | -122.424647671566 | (37.7718295731126, -122.424647671566) | 7 | 9 | 5 | 28852 | 10 | |||
71731 | 205992 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 452 Kenwood Way | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 5993371.39802 | 2093686.31414 | 37.728483309841 | -122.465187784693 | (37.728483309841, -122.465187784693) | 9 | 8 | 4 | 59 | 40 | |||
73221 | 189956 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 572 07th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3 | Width 3ft | 6011467.9689 | 2109652.48068 | 37.7733498689462 | -122.403749639528 | (37.7733498689462, -122.403749639528) | 14 | 2 | 9 | 28853 | 34 | |||
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 | ||
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 | |||
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 | |||
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 | |||
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 | ||
33818 | 206007 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991032.21326 | 2097741.26802 | 37.7394820166929 | -122.473570049822 | (37.7394820166929, -122.473570049822) | 1 | 8 | 4 | 29491 | 40 | |||
50124 | 206005 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 5991064.94409 | 2097743.51009 | 37.7394900683054 | -122.47345704553 | (37.7394900683054, -122.47345704553) | 1 | 8 | 4 | 29491 | 40 | |||
64200 | 189844 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 6 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4 | Width 3ft | 6017173.06513 | 2098183.08322 | 37.7421743665616 | -122.383216237654 | (37.7421743665616, -122.383216237654) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
20489 | 225066 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 199 Franconia St | 13 | : Yard | Tree | Private 2 | 5 | Width 3ft | 6010116.17854 | 2099660.00965 | 37.7458371865343 | -122.407720980957 | (37.7458371865343, -122.407720980957) | 2 | 7 | 7 | 28859 | 2 | |||
21860 | 206006 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 600 Vicente St | 2 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5991049.3393 | 2097743.54574 | 37.7394892625221 | -122.473511002145 | (37.7394892625221, -122.473511002145) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
34635 | 225051 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 4331 23rd St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6000881.81518 | 2102275.99981 | 37.7524988021808 | -122.439839555559 | (37.7524988021808, -122.439839555559) | 2 | 4 | 5 | 28862 | 22 | |||
49612 | 125976 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6007074.37921 | 2121877.42075 | 37.8066701158897 | -122.419815329109 | (37.8066701158897, -122.419815329109) | 5 | 1 | 1 | 28858 | 32 | |||
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 | |||
57765 | 225058 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 283 Carl St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 5996870.76469 | 2106986.93981 | 37.76520471814 | -122.454050575073 | (37.76520471814, -122.454050575073) | 15 | 5 | 11 | 29492 | 12 | |||
64038 | 248270 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 157 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 3ft | 6006694.18006 | 2098651.40644 | 37.7428756308979 | -122.419482249905 | (37.7428756308979, -122.419482249905) | 2 | 7 | 7 | 28859 | 2 | |||
107432 | 189915 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1 Flora St | 13 | : | Tree | Private 2 | 5 | Width 3ft | 6013899.07383 | 2094479.41823 | 37.7318233991302 | -122.394277515688 | (37.7318233991302, -122.394277515688) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
74298 | 225086 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3689 21st St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | Width 3ft | 6003831.7176 | 2103603.4271 | 37.7563110786983 | -122.429732966312 | (37.7563110786983, -122.429732966312) | 2 | 4 | 5 | 28862 | 22 | |||
102050 | 189886 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 201 Newhall St | 7 | : | Tree | Private 2 | 6 | Width 3ft | 6016892.13311 | 2098254.09694 | 37.7423538271607 | -122.384192566831 | (37.7423538271607, -122.384192566831) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
24361 | 206014 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 San Benito Way | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5992843.12782 | 2095854.05613 | 37.7344049138512 | -122.467171573123 | (37.7344049138512, -122.467171573123) | 9 | 8 | 4 | 59 | 40 | |||
28248 | 248203 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 47 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6006976.18023 | 2099171.17204 | 37.7443186704674 | -122.418544018687 | (37.7443186704674, -122.418544018687) | 2 | 7 | 7 | 28859 | 2 | |||
48301 | 225091 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 169 Lower Ter | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6000007.70524 | 2106202.33536 | 37.7632297601708 | -122.443144329371 | (37.7632297601708, -122.443144329371) | 15 | 5 | 5 | 28862 | 3 | |||
62178 | 189960 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6010412.08756 | 2108524.30899 | 37.7701931280454 | -122.407322550708 | (37.7701931280454, -122.407322550708) | 8 | 2 | 9 | 28853 | 34 | |||
65626 | 189862 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 12 | : | Tree | Private 2 | 7 | Width 3ft | 6017103.28687 | 2098264.26759 | 37.7423934261135 | -122.383463161819 | (37.7423934261135, -122.383463161819) | 10 | 3 | 8 | 58 | 1 | |||
66742 | 225072 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 902 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6009377.02442 | 2103868.3997 | 37.7573510817046 | -122.410574009103 | (37.7573510817046, -122.410574009103) | 2 | 4 | 7 | 28859 | 19 | |||
67259 | 189842 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 4 | : | Tree | Private 2 | 7 | Width 3ft | 6017136.08616 | 2098201.14709 | 37.7422219227174 | -122.383345357813 | (37.7422219227174, -122.383345357813) | 10 | 3 | 8 | 58 | 1 | |||
70275 | 189859 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 9 | : | Tree | Private 2 | 7 | Width 3ft | 6017171.36242 | 2098242.65136 | 37.7423378345214 | -122.38322627048 | (37.7423378345214, -122.38322627048) | 10 | 3 | 8 | 58 | 1 | |||
71679 | 189860 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 10 | : | Tree | Private 2 | 7 | Width 3ft | 6017146.31011 | 2098252.64566 | 37.7423638923838 | -122.383313590143 | (37.7423638923838, -122.383313590143) | 10 | 3 | 8 | 58 | 1 | |||
75171 | 206004 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 10 Lomita Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 5991469.80126 | 2104851.05791 | 37.7590289864229 | -122.472575296214 | (37.7590289864229, -122.472575296214) | 1 | 8 | 4 | 56 | 12 | |||
84314 | 125975 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 4 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6007035.47478 | 2121873.14157 | 37.8066561746197 | -122.419949661756 | (37.8066561746197, -122.419949661756) | 5 | 1 | 1 | 28858 | 32 | |||
85138 | 189878 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 3 | : | Tree | Private 2 | 7 | Width 3ft | 6016474.87335 | 2098336.17477 | 37.7425561170601 | -122.385641057214 | (37.7425561170601, -122.385641057214) | 10 | 3 | 8 | 58 | 1 | |||
102361 | 189877 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 2 | : | Tree | Private 2 | 7 | Width 3ft | 6016448.85629 | 2098333.07564 | 37.7425461678608 | -122.385730801451 | (37.7425461678608, -122.385730801451) | 10 | 3 | 8 | 58 | 1 | |||
102811 | 189880 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 5 | : | Tree | Private 2 | 7 | Width 3ft | 6016536.79452 | 2098327.43911 | 37.742535556771 | -122.385426341355 | (37.742535556771, -122.385426341355) | 10 | 3 | 8 | 58 | 1 | |||
108284 | 225093 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 635 Waller St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 3ft | 6002682.06353 | 2108837.51126 | 37.770617436283 | -122.434083007749 | (37.770617436283, -122.434083007749) | 15 | 5 | 5 | 29492 | 9 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
7 | 188479 | Prune Opt Out 3 | Ceratonia siliqua :: Carob 5 | 2208 Mariposa St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | Permit Number 787847 | 6010817.79084 | 2106032.71885 | 37.7633744862602 | -122.405743691032 | (37.7633744862602, -122.405743691032) | 8 | 4 | 8 | 28859 | 19 | ||
239 | 205987 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1639 17th Ave | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 5990866.8027 | 2104246.93654 | 37.7573353075836 | -122.474616638541 | (37.7573353075836, -122.474616638541) | 1 | 8 | 4 | 56 | 12 | |||
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 | |||
22673 | 248195 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 99 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6006895.3062 | 2099022.51404 | 37.7439059356157 | -122.418813123741 | (37.7439059356157, -122.418813123741) | 2 | 7 | 7 | 28859 | 2 | |||
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 | |||
60927 | 189962 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 562 09th St | 5 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6010439.90597 | 2108494.60457 | 37.7701131234445 | -122.407224232334 | (37.7701131234445, -122.407224232334) | 8 | 2 | 9 | 28853 | 34 | |||
74084 | 124322 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 115 Jordan Ave | 1 | Sidewalk: Curb side : Yard | Tree | Private 2 | 8 | Width 3ft | 5996192.87314 | 2113669.73604 | 37.7835150337529 | -122.456878613619 | (37.7835150337529, -122.456878613619) | 11 | 6 | 1 | 54 | 31 | |||
82304 | 225073 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 904 Florida St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6009377.25257 | 2103854.78979 | 37.7573137247548 | -122.410572259011 | (37.7573137247548, -122.410572259011) | 2 | 4 | 7 | 28859 | 19 | |||
84804 | 225044 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 15 Winfield St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007468.43971 | 2099454.94472 | 37.7451255476034 | -122.4168619861 | (37.7451255476034, -122.4168619861) | 2 | 7 | 7 | 28859 | 2 | |||
98760 | 189879 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 325 Newhall St | 4 | : | Tree | Private 2 | 8 | Width 3ft | 6016498.14538 | 2098335.4641 | 37.7425554533749 | -122.385560539098 | (37.7425554533749, -122.385560539098) | 10 | 3 | 8 | 58 | 1 | |||
99211 | 189861 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 102 Newhall St | 11 | : | Tree | Private 2 | 8 | Width 3ft | 6017125.66493 | 2098258.40905 | 37.742378576526 | -122.383385376738 | (37.742378576526, -122.383385376738) | 10 | 3 | 8 | 58 | 1 | |||
108761 | 225075 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3334 25th St | 1 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 3ft | 6007507.05129 | 2101513.08881 | 37.750778919809 | -122.416874263658 | (37.750778919809, -122.416874263658) | 2 | 4 | 7 | 28859 | 19 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 | |||
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 |
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) );