Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant, PlotSize
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo ▲ | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 161704 | 161704 | 225066 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 199 Franconia St | 13 | : Yard 23 | Tree 1 | Private 1 | 5 | Width 3ft | 6010116.17854 | 2099660.00965 | 37.745837186534295 | -122.407720980957 | (37.7458371865343, -122.407720980957) | |||
| 35881 | 35881 | 225050 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 500x 27th St | 24 | Median : Cutout 11 | Tree 1 | DPW 2 | 11 | Width 4ft | 6002949.31338 | 2100070.05084 | 37.7465592558077 | -122.432532251866 | (37.7465592558077, -122.432532251866) | |||
| 180608 | 180608 | 225049 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 500x 27th St | 22 | Median : Cutout 11 | Tree 1 | DPW 2 | 6 | Width 4ft | 6002919.63953 | 2100068.3028700002 | 37.7465527734974 | -122.432634735922 | (37.7465527734974, -122.432634735922) | |||
| 28883 | 28883 | 225087 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3901 19th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6003680.66693 | 2104762.3511799998 | 37.759484654009704 | -122.43033803379299 | (37.7594846540097, -122.430338033793) | |||
| 41526 | 41526 | 225088 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3899 19th St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 11 | Width 3ft | 6003725.04695 | 2104766.8360099997 | 37.7594994820291 | -122.43018486576099 | (37.7594994820291, -122.430184865761) | |||
| 42030 | 42030 | 206000 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 419 Flood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5997987.32263 | 2094070.28162 | 37.729802697139604 | -122.44925801953801 | (37.7298026971396, -122.449258019538) | ||||
| 67080 | 67080 | 189835 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1698 Galvez Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6015422.83464 | 2098030.46357 | 37.7416584290923 | -122.389257386733 | (37.7416584290923, -122.389257386733) | |||
| 143125 | 143125 | 201373 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2 Hare St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | 6018334.732369999 | 2095383.1099099999 | 37.7345503216464 | -122.379005098324 | (37.7345503216464, -122.379005098324) | ||||
| 161929 | 161929 | 189837 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1698 Galvez Ave | 11 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 16 | Width 8ft | 6015387.45837 | 2098059.88528 | 37.7417372537812 | -122.389381761177 | (37.7417372537812, -122.389381761177) | |||
| 176882 | 176882 | 189838 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 525 Phelps St | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 8ft | 6015431.26911 | 2098152.3632900002 | 37.741993608228505 | -122.389236732886 | (37.7419936082285, -122.389236732886) | |||
| 3206 | 3206 | 189833 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 2 | : 4 | Tree 1 | DPW 2 | 02/12/2016 12:00:00 AM | 14 | Width 3ft | 6016585.78665 | 2098909.19771 | 37.7441356575455 | -122.385297468507 | (37.7441356575455, -122.385297468507) | ||
| 3231 | 3231 | 188482 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1580 Burke Ave | 3 | : 4 | Tree 1 | DPW 2 | 03/30/1990 12:00:00 AM | 9 | Width 4ft | 6016171.38717 | 2099220.37618 | 37.7449671554124 | -122.386752079638 | (37.7449671554124, -122.386752079638) | ||
| 3247 | 3247 | 188481 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 10 | : 4 | Tree 1 | Private 1 | 08/24/2017 12:00:00 AM | 3 | Width 3ft | 6016299.33242 | 2099120.87091 | 37.744701017238796 | -122.38630272799999 | (37.7447010172388, -122.386302728) | ||
| 23951 | 23951 | 222885 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Valencia St | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 5ft | 6006051.02822 | 2109339.24494 | 37.7721857010308 | -122.422465357814 | (37.7721857010308, -122.422465357814) | |||
| 24219 | 24219 | 189857 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6017207.28329 | 2098227.98563 | 37.7422995503725 | -122.383101045278 | (37.7422995503725, -122.383101045278) | |||
| 27659 | 27659 | 189891 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6016826.79146 | 2098321.83879 | 37.7425362195639 | -122.384423217764 | (37.7425362195639, -122.384423217764) | |||
| 28090 | 28090 | 189890 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6016847.575680001 | 2098318.03852 | 37.742526934071 | -122.384351086743 | (37.742526934071, -122.384351086743) | |||
| 30049 | 30049 | 222884 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Valencia St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 5ft | 6006058.1722800005 | 2109199.11331 | 37.7718013362 | -122.422430687153 | (37.7718013362, -122.422430687153) | |||
| 32351 | 32351 | 189916 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1771 Palou Ave | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 4ft | 6013954.80906 | 2095907.8137599998 | 37.7357485783226 | -122.394184791988 | (37.7357485783226, -122.394184791988) | |||
| 32657 | 32657 | 189845 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6017192.34248 | 2098175.05438 | 37.7421533862633 | -122.383149023221 | (37.7421533862633, -122.383149023221) | |||
| 33099 | 33099 | 189852 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017365.88907 | 2098130.81013 | 37.7420414890213 | -122.38254586948999 | (37.7420414890213, -122.38254586949) | |||
| 33190 | 33190 | 189849 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 12 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6017283.17469 | 2098125.85242 | 37.742023306530704 | -122.38283152746 | (37.7420233065307, -122.38283152746) | |||
| 35702 | 35702 | 189866 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 501 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6016000.66321 | 2097804.14137 | 37.7410690116125 | -122.3872436482 | (37.7410690116125, -122.3872436482) | |||
| 37517 | 37517 | 246517 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 41 Waller St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6005417.73549 | 2109222.5624700002 | 37.771829573112605 | -122.424647671566 | (37.7718295731126, -122.424647671566) | |||
| 38544 | 38544 | 189841 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017113.188630001 | 2098207.21128 | 37.742237308295294 | -122.38342495321899 | (37.7422373082953, -122.383424953219) | |||
| 38692 | 38692 | 189888 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016891.26784 | 2098307.49665 | 37.7425004040788 | -122.384199276697 | (37.7425004040788, -122.384199276697) | |||
| 39389 | 39389 | 189870 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 401 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6016138.74056 | 2097991.9117 | 37.741592236291396 | -122.386779313807 | (37.7415922362914, -122.386779313807) | |||
| 44243 | 44243 | 189896 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6016683.25153 | 2098348.88465 | 37.7426025436648 | -122.38492142508899 | (37.7426025436648, -122.384921425089) | |||
| 46617 | 46617 | 189864 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 501 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6015974.53489 | 2097767.4819400003 | 37.7409669053009 | -122.387331434622 | (37.7409669053009, -122.387331434622) | |||
| 49848 | 49848 | 189861 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 11 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017125.66493 | 2098258.40905 | 37.742378576526 | -122.38338537673799 | (37.742378576526, -122.383385376738) | |||
| 50893 | 50893 | 189872 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Newhall St | 12 | : 4 | Tree 1 | Private 1 | 17 | Width 4ft | 6015960.56064 | 2097835.58742 | 37.741153135100205 | -122.387384502698 | (37.7411531351002, -122.387384502698) | |||
| 54002 | 54002 | 189894 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 8 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6016764.20599 | 2098333.7275 | 37.742565402576794 | -122.384640449909 | (37.7425654025768, -122.384640449909) | |||
| 56798 | 56798 | 189836 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1698 Galvez Ave | 9 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6015406.79125 | 2098034.46628 | 37.741668530275604 | -122.389313139314 | (37.7416685302756, -122.389313139314) | |||
| 60830 | 60830 | 189847 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 9 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017231.39271 | 2098158.2223400003 | 37.7421093266962 | -122.383012827183 | (37.7421093266962, -122.383012827183) | |||
| 62858 | 62858 | 189876 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 8 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6016406.62692 | 2098319.91707 | 37.7425077002596 | -122.385875902556 | (37.7425077002596, -122.385875902556) | |||
| 63863 | 63863 | 189858 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 8 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6017192.206809999 | 2098235.0383900004 | 37.7423180827181 | -122.38315366643499 | (37.7423180827181, -122.383153666435) | |||
| 65891 | 65891 | 189889 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016866.9099 | 2098314.50918 | 37.7425183122785 | -122.38428398832501 | (37.7425183122785, -122.384283988325) | |||
| 66110 | 66110 | 189895 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6016704.91422 | 2098345.41637 | 37.7425942186412 | -122.384846279543 | (37.7425942186412, -122.384846279543) | |||
| 67535 | 67535 | 189863 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 13 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6017087.002669999 | 2098268.01639 | 37.742402819541795 | -122.383519729148 | (37.7424028195418, -122.383519729148) | |||
| 67550 | 67550 | 189912 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Flora St | 8 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013884.75868 | 2094408.4745200002 | 37.7316278064595 | -122.394322041155 | (37.7316278064595, -122.394322041155) | |||
| 69864 | 69864 | 189869 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 401 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 13 | Width 3ft | 6016127.95859 | 2097976.0947 | 37.7415482090816 | -122.38681549176 | (37.7415482090816, -122.38681549176) | |||
| 72242 | 72242 | 189913 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Flora St | 9 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013888.27035 | 2094422.90108 | 37.731667614051 | -122.39431091023 | (37.731667614051, -122.39431091023) | |||
| 73397 | 73397 | 246510 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 231 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6004993.26159 | 2099869.66747 | 37.7461247456624 | -122.425450235552 | (37.7461247456624, -122.425450235552) | |||
| 74016 | 74016 | 189915 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Flora St | 13 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013899.07383 | 2094479.41823 | 37.7318233991302 | -122.394277515688 | (37.7318233991302, -122.394277515688) | |||
| 74466 | 74466 | 189898 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6016641.64949 | 2098357.6793299997 | 37.7426243909147 | -122.385065886799 | (37.7426243909147, -122.385065886799) | |||
| 74473 | 74473 | 189880 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016536.79452 | 2098327.4391099997 | 37.742535556771 | -122.385426341355 | (37.742535556771, -122.385426341355) | |||
| 74900 | 74900 | 189884 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 12 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6016685.38219 | 2098298.11667 | 37.7424632629752 | -122.384910521712 | (37.7424632629752, -122.384910521712) | |||
| 77182 | 77182 | 189905 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6016340.3864 | 2098339.29531 | 37.7425572430226 | -122.386106295385 | (37.7425572430226, -122.386106295385) | |||
| 130083 | 130083 | 189882 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6016580.99088 | 2098317.85278 | 37.742511679775205 | -122.385272854085 | (37.7425116797752, -122.385272854085) | |||
| 130575 | 130575 | 189868 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 401 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016117.80915 | 2097961.55377 | 37.7415077207098 | -122.38684957154899 | (37.7415077207098, -122.386849571549) | |||
| 130592 | 130592 | 189900 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 8 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6016469.439569999 | 2098386.38148 | 37.7426936737758 | -122.38566334421199 | (37.7426936737758, -122.385663344212) | |||
| 131320 | 131320 | 189846 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 8 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017214.17115 | 2098166.7194 | 37.7421317063069 | -122.383072965771 | (37.7421317063069, -122.383072965771) | |||
| 131495 | 131495 | 189850 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 14 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6017345.725190001 | 2098082.05897 | 37.7419065142755 | -122.382612199015 | (37.7419065142755, -122.382612199015) | |||
| 132013 | 132013 | 189839 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017074.26086 | 2098217.41845 | 37.7422631836031 | -122.38356026519699 | (37.7422631836031, -122.383560265197) | |||
| 132324 | 132324 | 189873 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Newhall St | 13 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6015949.19552 | 2097817.31467 | 37.741102332416204 | -122.38742252514601 | (37.7411023324162, -122.387422525146) | |||
| 132365 | 132365 | 189887 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6016910.34518 | 2098303.24769 | 37.742489792067104 | -122.384133016442 | (37.7424897920671, -122.384133016442) | |||
| 134310 | 134310 | 188488 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 8 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6016697.4652 | 2098710.93051 | 37.743597433976205 | -122.38489749504299 | (37.7435974339762, -122.384897495043) | |||
| 135246 | 135246 | 189881 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6016559.498980001 | 2098322.6337200003 | 37.7425236182725 | -122.385347500499 | (37.7425236182725, -122.385347500499) | |||
| 135439 | 135439 | 189860 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 10 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6017146.31011 | 2098252.64566 | 37.74236389238379 | -122.38331359014299 | (37.7423638923838, -122.383313590143) | |||
| 135669 | 135669 | 189883 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 9 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6016619.88237 | 2098309.8227 | 37.7424917822737 | -122.38513781816201 | (37.7424917822737, -122.385137818162) | |||
| 137584 | 137584 | 189851 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 15 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6017359.84801 | 2098072.09609 | 37.741879938402704 | -122.38256267332198 | (37.7418799384027, -122.382562673322) | |||
| 146502 | 146502 | 189834 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1698 Galvez Ave | 4 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6015429.09406 | 2098017.0802 | 37.7416220281222 | -122.389234809264 | (37.7416220281222, -122.389234809264) | |||
| 147716 | 147716 | 189842 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6017136.0861599995 | 2098201.14709 | 37.7422219227174 | -122.383345357813 | (37.7422219227174, -122.383345357813) | |||
| 155880 | 155880 | 189903 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6016414.85135 | 2098379.02943 | 37.742670465863796 | -122.38585158400801 | (37.7426704658638, -122.385851584008) | |||
| 156493 | 156493 | 189885 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 201 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016834.26905 | 2098267.19561 | 37.7423865939792 | -122.38439355723601 | (37.7423865939792, -122.384393557236) | |||
| 156617 | 156617 | 189856 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6017223.11391 | 2098220.2806700002 | 37.742279268865104 | -122.383045771154 | (37.7422792688651, -122.383045771154) | |||
| 156633 | 156633 | 189862 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 12 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6017103.28687 | 2098264.2675900003 | 37.7423934261135 | -122.383463161819 | (37.7423934261135, -122.383463161819) | |||
| 157361 | 157361 | 189848 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 11 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6017264.73109 | 2098137.17538 | 37.7420533780644 | -122.38289608801 | (37.7420533780644, -122.38289608801) | |||
| 157640 | 157640 | 189843 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017155.58292 | 2098191.33075 | 37.742196046505 | -122.38327726024599 | (37.742196046505, -122.383277260246) | |||
| 157752 | 157752 | 189865 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 501 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6015985.7864 | 2097784.98338 | 37.7410155838051 | -122.38729375121599 | (37.7410155838051, -122.387293751216) | |||
| 157879 | 157879 | 189879 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6016498.145380001 | 2098335.4641 | 37.7425554533749 | -122.385560539098 | (37.7425554533749, -122.385560539098) | |||
| 158918 | 158918 | 189855 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6017245.40272 | 2098209.38961 | 37.7422505957884 | -122.382967944715 | (37.7422505957884, -122.382967944715) | |||
| 160768 | 160768 | 189840 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017094.37686 | 2098212.93845 | 37.7422519942486 | -122.383490397763 | (37.7422519942486, -122.383490397763) | |||
| 162643 | 162643 | 189859 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 9 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6017171.36242 | 2098242.65136 | 37.7423378345214 | -122.38322627048001 | (37.7423378345214, -122.38322627048) | |||
| 163194 | 163194 | 189875 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Newhall St | 15 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6015903.72942 | 2097762.72481 | 37.740949921590904 | -122.387575924289 | (37.7409499215909, -122.387575924289) | |||
| 165750 | 165750 | 189871 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Newhall St | 9 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016028.58203 | 2097927.48174 | 37.741409225160396 | -122.387155715173 | (37.7414092251604, -122.387155715173) | |||
| 166137 | 166137 | 189911 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Flora St | 7 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013879.72064 | 2094387.8060700002 | 37.73157077506371 | -122.394338012196 | (37.7315707750637, -122.394338012196) | |||
| 166172 | 166172 | 189893 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6016784.24817 | 2098329.2173099997 | 37.7425541268854 | -122.384570835175 | (37.7425541268854, -122.384570835175) | |||
| 167349 | 167349 | 189877 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016448.8562900005 | 2098333.07564 | 37.7425461678608 | -122.38573080145099 | (37.7425461678608, -122.385730801451) | |||
| 170703 | 170703 | 189886 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 201 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016892.13311 | 2098254.09694 | 37.7423538271607 | -122.384192566831 | (37.7423538271607, -122.384192566831) | |||
| 173588 | 173588 | 189854 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6017283.71117 | 2098187.47887 | 37.742192549946104 | -122.38283396012599 | (37.7421925499461, -122.382833960126) | |||
| 173975 | 173975 | 189914 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Flora St | 11 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013894.185819999 | 2094452.33408 | 37.7317487598799 | -122.394292519091 | (37.7317487598799, -122.394292519091) | |||
| 174407 | 174407 | 222887 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 123 Webster St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6004226.51196 | 2109212.81898 | 37.77173547164 | -122.42876750091801 | (37.77173547164, -122.428767500918) | |||
| 175453 | 175453 | 189874 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Newhall St | 14 | : 4 | Tree 1 | Private 1 | 19 | Width 4ft | 6015935.20003 | 2097800.22723 | 37.741054638653004 | -122.387469725156 | (37.741054638653, -122.387469725156) | |||
| 179431 | 179431 | 189853 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017352.03209 | 2098141.27696 | 37.742069463331106 | -122.382594511142 | (37.7420694633311, -122.382594511142) | |||
| 181190 | 181190 | 189878 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016474.87335 | 2098336.17477 | 37.742556117060104 | -122.38564105721399 | (37.7425561170601, -122.385641057214) | |||
| 182071 | 182071 | 222886 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 139 Webster St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6004216.91806 | 2109283.17336 | 37.7719281046318 | -122.428805703247 | (37.7719281046318, -122.428805703247) | |||
| 182504 | 182504 | 189867 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 401 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 16 | Width 3ft | 6016089.46635 | 2097928.7080599996 | 37.7414159637784 | -122.38694528191999 | (37.7414159637784, -122.38694528192) | |||
| 187471 | 187471 | 189892 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6016806.72009 | 2098324.8999099997 | 37.74254351487679 | -122.384492832481 | (37.7425435148768, -122.384492832481) | |||
| 23898 | 23898 | 246421 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Duncan St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 4ft | 6003840.654080001 | 2099855.1968900003 | 37.7460198226686 | -122.429434772709 | (37.7460198226686, -122.429434772709) | |||
| 30270 | 30270 | 225097 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 290 Waller St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 6004333.63591 | 2109116.4123400003 | 37.7714768248196 | -122.42839007973998 | (37.7714768248196, -122.42839007974) | |||
| 32711 | 32711 | 124322 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 115 Jordan Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 8 | Width 3ft | 5996192.87314 | 2113669.7360400003 | 37.7835150337529 | -122.456878613619 | (37.7835150337529, -122.456878613619) | |||
| 34571 | 34571 | 206020 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 146 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 3ft | 5994480.54768 | 2101060.81011 | 37.7487957447457 | -122.46188794817499 | (37.7487957447457, -122.461887948175) | |||
| 43924 | 43924 | 225098 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 290 Waller St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 6004313.032319999 | 2109116.83696 | 37.7714768248189 | -122.42846137891199 | (37.7714768248189, -122.428461378912) | |||
| 51566 | 51566 | 124321 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 115 Jordan Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 14 | Width 3ft | 5996193.40211 | 2113658.2283900003 | 37.783483467186706 | -122.45687595100901 | (37.7834834671867, -122.456875951009) | |||
| 52630 | 52630 | 188477 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 499 San Bruno Ave | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 16 | Width 3ft | 6010894.54885 | 2106022.4243799997 | 37.76335051213071 | -122.40547748360301 | (37.7633505121307, -122.405477483603) | |||
| 60139 | 60139 | 246422 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Duncan St | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 6003829.35465 | 2099854.81871 | 37.746018144524605 | -122.429473817668 | (37.7460181445246, -122.429473817668) | |||
| 60183 | 60183 | 218315 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 437 Castenada Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 7 | Width 0ft | 5993144.55141 | 2099923.03964 | 37.7455947140337 | -122.46642509806401 | (37.7455947140337, -122.466425098064) | |||
| 67325 | 67325 | 206015 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 351 Montecito Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 23 | Width 3ft | 5995922.8819 | 2094068.30815 | 37.7296789783055 | -122.45639483786199 | (37.7296789783055, -122.456394837862) | |||
| 74533 | 74533 | 222898 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2771 22nd St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 21 | Width 6ft | 6009527.7031 | 2103333.9306400004 | 37.7558919964247 | -122.410015170384 | (37.7558919964247, -122.410015170384) |
JSON shape: default, array, newline-delimited
CREATE TABLE "Street_Tree_List" (
"TreeID" INTEGER,
"qLegalStatus" INTEGER,
"qSpecies" INTEGER,
"qAddress" TEXT,
"SiteOrder" INTEGER,
"qSiteInfo" INTEGER,
"PlantType" INTEGER,
"qCaretaker" INTEGER,
"qCareAssistant" INTEGER,
"PlantDate" TEXT,
"DBH" INTEGER,
"PlotSize" TEXT,
"PermitNotes" TEXT,
"XCoord" REAL,
"YCoord" REAL,
"Latitude" REAL,
"Longitude" REAL,
"Location" TEXT
,
FOREIGN KEY ("PlantType") REFERENCES [PlantType](id),
FOREIGN KEY ("qCaretaker") REFERENCES [qCaretaker](id),
FOREIGN KEY ("qSpecies") REFERENCES [qSpecies](id),
FOREIGN KEY ("qSiteInfo") REFERENCES [qSiteInfo](id),
FOREIGN KEY ("qCareAssistant") REFERENCES [qCareAssistant](id),
FOREIGN KEY ("qLegalStatus") REFERENCES [qLegalStatus](id));
CREATE INDEX ["Street_Tree_List_PlantType"] ON [Street_Tree_List]("PlantType");
CREATE INDEX ["Street_Tree_List_qCaretaker"] ON [Street_Tree_List]("qCaretaker");
CREATE INDEX ["Street_Tree_List_qSpecies"] ON [Street_Tree_List]("qSpecies");
CREATE INDEX ["Street_Tree_List_qSiteInfo"] ON [Street_Tree_List]("qSiteInfo");
CREATE INDEX ["Street_Tree_List_qCareAssistant"] ON [Street_Tree_List]("qCareAssistant");
CREATE INDEX ["Street_Tree_List_qLegalStatus"] ON [Street_Tree_List]("qLegalStatus");