trees
87 rows where SiteOrder = 3 and qSpecies_id = 5 sorted by Longitude
This data as json, CSV (advanced)
qLegalStatus_id ✖
- DPW Maintained 67
- Permitted Site 14
- Undocumented 6
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) |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
77909 | 14909 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 110X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6017336.92539 | 2098155.67833 | 37.7421081720326 | -122.382647747732 | (37.7421081720326, -122.382647747732) | 10 | 3 | 8 | 58 | 1 | |||
100985 | 189841 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 101 Newhall St | 3 | : | Tree | Private 2 | 1 | Width 3ft | 6017113.18863 | 2098207.21128 | 37.7422373082953 | -122.383424953219 | (37.7422373082953, -122.383424953219) | 10 | 3 | 8 | 58 | 1 | |||
188633 | 4914 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 195X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6017015.0972074 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | 10 | 3 | 8 | 58 | 1 | |||
40384 | 16481 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.384218928939 | (37.7425024549748, -122.384218928939) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
124745 | 2499 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Burke Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016750.97009 | 2098814.51662 | 37.7438848195436 | -122.384719700863 | (37.7438848195436, -122.384719700863) | 10 | 3 | 8 | 58 | 1 | |||
65426 | 189896 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 220 Newhall St | 3 | : | Tree | Private 2 | 14 | Width 4ft | 6016683.25153 | 2098348.88465 | 37.7426025436648 | -122.384921425089 | (37.7426025436648, -122.384921425089) | 10 | 3 | 8 | 58 | 1 | |||
55055 | 2507 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1501 Burke Ave | 3 | 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 | |||
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 | |||
141218 | 93111 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/02/2010 12:00:00 AM | 7 | 3x3 | Permit Number 53024 | 6016584.37921 | 2098370.12887 | 37.7426554067123 | -122.385264779961 | (37.7426554067123, -122.385264779961) | 10 | 3 | 8 | 58 | 1 | |
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 | |||
77385 | 14926 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 320X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016461.7664057 | 2098387.7906821 | 37.7426971185746 | -122.385689974252 | (37.7426971185746, -122.385689974252) | 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 | |||
149727 | 2515 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1555 Burke Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016446.65639 | 2098928.8879 | 37.7441820247861 | -122.385779926925 | (37.7441820247861, -122.385779926925) | 10 | 3 | 8 | 58 | 1 | |||
13958 | 262096 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 350 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | Width 3ft | 6016433.67399 | 2098382.99048 | 37.7426823836985 | -122.385786776164 | (37.7426823836985, -122.385786776164) | 10 | 3 | 8 | 58 | 1 | ||||
168339 | 2544 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1580 BURKE AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3X3 | 6016440 | 2099034 | 37.7444702727306 | -122.385810268433 | (37.7444702727306, -122.385810268433) | 10 | 3 | 8 | 58 | 1 | |||
107870 | 16512 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 330 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3x3 | 6016415.99739 | 2098380.53365 | 37.7426746595649 | -122.38584772612 | (37.7426746595649, -122.38584772612) | 10 | 3 | 8 | 58 | 1 | |||
95532 | 16523 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 375 Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3X3 | 6016311.20334 | 2098218.94031 | 37.7422251575656 | -122.386198814044 | (37.7422251575656, -122.386198814044) | 10 | 3 | 8 | 58 | 1 | |||
106760 | 2535 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1575 Burke Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 6 | 3X3 | 6016210.73833 | 2099105.12284 | 37.7446528720358 | -122.386607974081 | (37.7446528720358, -122.386607974081) | 10 | 3 | 8 | 58 | 1 | |||
117844 | 188482 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1580 Burke Ave | 3 | : | Tree | DPW 1 | 03/30/1990 12:00:00 AM | 9 | Width 4ft | 6016171.38717 | 2099220.37618 | 37.7449671554124 | -122.386752079638 | (37.7449671554124, -122.386752079638) | 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 | |||
141600 | 6647 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 495X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 04/01/1990 12:00:00 AM | 3 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | 10 | 3 | 8 | 58 | 1 | ||
193340 | 16552 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 500X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6016006.287148 | 2097894.9109735 | 37.7413185578473 | -122.387230532448 | (37.7413185578473, -122.387230532448) | 10 | 3 | 8 | 58 | 1 | |||
67696 | 189866 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 501 Newhall St | 3 | : | Tree | Private 2 | 11 | Width 4ft | 6016000.66321 | 2097804.14137 | 37.7410690116125 | -122.3872436482 | (37.7410690116125, -122.3872436482) | 10 | 3 | 8 | 58 | 1 | |||
39064 | 6846 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 595X Newhall St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | 3x3 | 6015951.07042 | 2097735.77472 | 37.7408785442151 | -122.387410355501 | (37.7408785442151, -122.387410355501) | 10 | 3 | 8 | 58 | 1 | |||
17034 | 96473 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 120 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | 3x3 | Permit Number 767637 | 6014754.27658 | 2116074.97331 | 37.7911676114441 | -122.392831160352 | (37.7911676114441, -122.392831160352) | 12 | 2 | 9 | 28855 | 6 | ||
161983 | 189946 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 162 Spear St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 1ft | 6014709.04159 | 2116225.6637 | 37.7915788597386 | -122.392998221109 | (37.7915788597386, -122.392998221109) | 12 | 2 | 9 | 28855 | 6 | |||
131100 | 106027 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 180 Howard St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 02/05/2015 12:00:00 AM | 11 | 3x3 | Permit Number 770222 | 6014665.81921 | 2115987.91534 | 37.7909236568574 | -122.393131128317 | (37.7909236568574, -122.393131128317) | 12 | 2 | 9 | 28855 | 6 | |
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 | |||
112435 | 47241 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 1000X Jamestown Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 05/09/2002 12:00:00 AM | 8 | 3x3 | Permit Number 45190 | 6014093.2543098 | 2089771.82198012 | 37.718908077116 | -122.393276886105 | (37.718908077116, -122.393276886105) | 10 | 3 | 8 | 58 | 1 |
84292 | 94894 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Flora St | 3 | Sidewalk: Curb side : Cutout | Tree | SFUSD 4 | DPW for City Agency | 11/23/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53954 | 6014036.5 | 2094589.2 | 37.7321324754711 | -122.393810082896 | (37.7321324754711, -122.393810082896) | 10 | 3 | 8 | 58 | 1 |
109482 | 200192 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1008 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 0ft | 6013935.7075 | 2089708.6863 | 37.718725965018 | -122.393817050636 | (37.718725965018, -122.393817050636) | 10 | 3 | 8 | 58 | 1 | |||
158939 | 17414 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1820X Palou Ave | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 3x3 | 6013664.43707 | 2096187.44321 | 37.7365002389252 | -122.395208309826 | (37.7365002389252, -122.395208309826) | 10 | 3 | 8 | 58 | 1 | |||
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 | |||
72975 | 15123 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300 Mission St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 2X2 | 6013765.88916 | 2116013.74101 | 37.7909445343765 | -122.396246681474 | (37.7909445343765, -122.396246681474) | 12 | 2 | 9 | 28855 | 6 | |||
62483 | 119737 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 45 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | 6013490.74423 | 2116034.43287 | 37.7909860356216 | -122.397200129801 | (37.7909860356216, -122.397200129801) | 12 | 2 | 9 | 28855 | 6 | ||||
163468 | 119743 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 15X Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 6013411 | 2116073 | 37.7910874921548 | -122.39747874957 | (37.7910874921548, -122.39747874957) | 12 | 2 | 9 | 28855 | 6 | ||||
80002 | 189928 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 43 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013312.71119 | 2116223.04908 | 37.7914940185848 | -122.397829357532 | (37.7914940185848, -122.397829357532) | 12 | 2 | 9 | 28855 | 6 | |||
92390 | 189934 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 28 Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 5ft | 6013232.87553 | 2116207.31651 | 37.7914463743094 | -122.398104485334 | (37.7914463743094, -122.398104485334) | 12 | 2 | 9 | 28855 | 6 | |||
124374 | 97181 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 10X Fremont St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | 12 | 2 | 9 | 28855 | 6 | |||
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 | |||
155251 | 103345 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 1000 Brannan St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | 3x3 | Permit Number 29899 | 6010491 | 2108479 | 37.7700731362443 | -122.407046397751 | (37.7700731362443, -122.407046397751) | 8 | 2 | 9 | 28853 | 34 | ||
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 | |||
60431 | 103341 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 590X 09th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | 3x3 | 6010323 | 2108639 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | 8 | 2 | 9 | 28853 | 34 | |||
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 | |||
29632 | 102874 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2761 21st St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 4x4 | 6009574.6 | 2103896.5 | 37.7574393136514 | -122.409892695521 | (37.7574393136514, -122.409892695521) | 2 | 4 | 7 | 28859 | 19 | ||||
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 | |||
81591 | 21783 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 2550 TAYLOR ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | 5x5 | 6008458.6 | 2121488.8 | 37.8056809434427 | -122.414997429015 | (37.8056809434427, -122.414997429015) | 3 | 1 | 10 | 308 | 23 | |||
145684 | 21794 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2598 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 21 | 4X4 | 6008439.13676 | 2121624.27905 | 37.8060518410095 | -122.415074380155 | (37.8060518410095, -122.415074380155) | 3 | 1 | 10 | 308 | 23 | |||
19339 | 21778 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2500X Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 12 | 5X5 | 6008409.45282 | 2121407.87429 | 37.8054559800011 | -122.415161778523 | (37.8054559800011, -122.415161778523) | 5 | 1 | 10 | 308 | 23 | |||
37876 | 125979 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2500 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 4ft | 6008389.02756 | 2121512.5692 | 37.8057422979318 | -122.41523987894 | (37.8057422979318, -122.41523987894) | 5 | 1 | 10 | 308 | 23 | |||
124920 | 125982 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2550 Taylor St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 19 | Width 6ft | 6008379.56749 | 2121591.49972 | 37.8059584895516 | -122.415278208017 | (37.8059584895516, -122.415278208017) | 5 | 1 | 10 | 308 | 23 | |||
26958 | 188469 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 255 12th St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 8 | Width 5ft | 6008084.26268 | 2108917.74209 | 37.771142843604 | -122.415402360325 | (37.771142843604, -122.415402360325) | 8 | 2 | 9 | 28853 | 19 | |||
75940 | 51298 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 300X Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 09/07/2004 12:00:00 AM | 7 | Permit Number 47670 | 6008009.38054 | 2112753.19289 | 37.7816698695126 | -122.415933029587 | (37.7816698695126, -122.415933029587) | 7 | 10 | 9 | 28852 | 36 | |
67782 | 125998 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2510 Jones St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 18 | Width 4ft | 6007907.02571 | 2121498.39071 | 37.8056762669961 | -122.416906917118 | (37.8056762669961, -122.416906917118) | 5 | 1 | 10 | 308 | 23 | |||
69517 | 48533 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 500(REVISED) Capp St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 08/22/2002 12:00:00 AM | Permit Number 45857 | 6007225.9541014 | 2104383.62172477 | 37.7586449307205 | -122.41804980128 | (37.7586449307205, -122.41804980128) | 2 | 4 | 7 | 28859 | 19 | |||
9470 | 46514 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 525or larger Golden Gate Ave In A 24 Box | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 03/27/2002 12:00:00 AM | Permit Number 44680 | 6007056.20383649 | 2112568.41573989 | 37.7811088818185 | -122.419217465788 | (37.7811088818185, -122.419217465788) | 7 | 9 | 9 | 28852 | 36 | |||
45877 | 248276 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 137 Lundy's Ln | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | Width 3ft | 6006755.61156 | 2098766.6947 | 37.7431956465585 | -122.419278012984 | (37.7431956465585, -122.419278012984) | 2 | 7 | 7 | 28859 | 2 | |||
124822 | 111888 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 140 LUNDYS LN | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x12 | 6006709 | 2098750 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | 2 | 7 | 7 | 28859 | 2 | ||||
146048 | 125974 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 633 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 2ft | 6007013.05823 | 2121870.81717 | 37.8066485294743 | -122.420027073604 | (37.8066485294743, -122.420027073604) | 5 | 1 | 1 | 28858 | 32 | |||
95994 | 11181 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 2750X Hyde St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 14 | 3X3 | 6006890.68476 | 2121823.94924 | 37.8065129467732 | -122.420447242256 | (37.8065129467732, -122.420447242256) | 5 | 1 | 1 | 28858 | 32 | |||
156506 | 101043 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 655 Beach St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | Permit Number 47845 | 6006837 | 2121873 | 37.8066446021589 | -122.420636512845 | (37.8066446021589, -122.420636512845) | 5 | 1 | 1 | 28858 | 32 | ||||
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 | |||
52787 | 222885 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1 Valencia St | 3 | : | Tree | Private 2 | 18 | Width 5ft | 6006051.02822 | 2109339.24494 | 37.7721857010308 | -122.422465357814 | (37.7721857010308, -122.422465357814) | 8 | 2 | 9 | 28853 | 19 | |||
77005 | 140023 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 775 MCALLISTER ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6005484.9085 | 2112001.3325 | 37.7794631941198 | -122.424613016933 | (37.7794631941198, -122.424613016933) | 7 | 9 | 11 | 28852 | 41 | |||
25251 | 14688 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 775 McAllister St | 3 | Sidewalk: Curb side : Cutout | Tree | DPW 1 | 26 | 4x4 | 6005346.74925 | 2111820.94662 | 37.7789600951073 | -122.425078130411 | (37.7789600951073, -122.425078130411) | 7 | 9 | 11 | 28852 | 41 | |||
640 | 222906 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 363 Page St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 9 | Width 4ft | 6004761.72453 | 2109824.22026 | 37.7734445081828 | -122.42695971791 | (37.7734445081828, -122.42695971791) | 7 | 9 | 11 | 28852 | 10 | |||
131762 | 50388 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 296 Liberty St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/01/2003 12:00:00 AM | Permit Number 47041 | 6004379.7762802 | 2103977.8532584 | 37.7573701836913 | -122.427864268021 | (37.7573701836913, -122.427864268021) | 2 | 4 | 5 | 28862 | 3 | |||
68805 | 225098 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 290 Waller St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 16 | Width 3ft | 6004313.03232 | 2109116.83696 | 37.7714768248189 | -122.428461378912 | (37.7714768248189, -122.428461378912) | 7 | 9 | 11 | 28852 | 10 | |||
110454 | 246421 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 400 Duncan St | 3 | Sidewalk: Curb side : Yard | Tree | Private 2 | 7 | Width 4ft | 6003840.65408 | 2099855.19689 | 37.7460198226686 | -122.429434772709 | (37.7460198226686, -122.429434772709) | 2 | 7 | 5 | 63 | 22 | |||
77339 | 225088 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3899 19th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6003725.04695 | 2104766.83601 | 37.7594994820291 | -122.430184865761 | (37.7594994820291, -122.430184865761) | 2 | 4 | 5 | 28862 | 3 | |||
85099 | 225087 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3901 19th St | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 11 | Width 3ft | 6003680.66693 | 2104762.35118 | 37.7594846540097 | -122.430338033793 | (37.7594846540097, -122.430338033793) | 2 | 4 | 5 | 28862 | 3 | |||
108294 | 140580 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 949 FILLMORE ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 13 | Width 0ft | 6003403.4849 | 2111618.6108 | 37.7782945663272 | -122.43178620552 | (37.7782945663272, -122.43178620552) | 15 | 9 | 11 | 29492 | 41 | |||
114975 | 115848 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 3501 Laguna St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 6 | 3x3 | 6003586.42591 | 2120801.53952 | 37.8035189184231 | -122.431809184355 | (37.8035189184231, -122.431809184355) | 13 | 9 | 1 | 57 | 17 | |||
35660 | 115844 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1500 Bay St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10 | 3x3 | 6003543.04696 | 2120740.86009 | 37.8033498494719 | -122.43195496357 | (37.8033498494719, -122.43195496357) | 13 | 9 | 1 | 57 | 17 | |||
82972 | 110185 | Undocumented 4 | Ceratonia siliqua :: Carob 5 | 1500x LYON ST | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 3x3 | 5999718 | 2114083 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | 15 | 6 | 1 | 29490 | 31 | ||||
156051 | 139008 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1504 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 16 | Width 0ft | 5999687.2486 | 2114098.7181 | 37.7848929418184 | -122.444820316061 | (37.7848929418184, -122.444820316061) | 15 | 6 | 1 | 29490 | 31 | |||
75012 | 138241 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 1509 Lyon St | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 11 | Width 0ft | 5999646.1152 | 2114082.8594 | 37.7848470504501 | -122.444961483404 | (37.7848470504501, -122.444961483404) | 15 | 6 | 1 | 29490 | 31 | |||
146949 | 82141 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 10/25/2007 12:00:00 AM | 3x3 | Permit Number 49838 | 5998889.06181671 | 2096571.98929044 | 37.736723332936 | -122.446320512355 | (37.736723332936, -122.446320512355) | 9 | 7 | 4 | 59 | 40 | ||
47524 | 205997 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 30 Molimo Dr | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 7 | Width 2ft | 5998801.07075 | 2096511.79706 | 37.7365530335853 | -122.446620405109 | (37.7365530335853, -122.446620405109) | 9 | 7 | 4 | 59 | 40 | |||
20659 | 59670 | Permitted Site 7 | Ceratonia siliqua :: Carob 5 | 98X PARNASSUS AVE | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | FUF | 08/09/1993 12:00:00 AM | 15 | 3x3 | Permit Number 32228 | 5998297 | 2106864 | 37.7649488326227 | -122.449108733904 | (37.7649488326227, -122.449108733904) | 15 | 5 | 11 | 29492 | 9 |
128316 | 206000 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 419 Flood Ave | 3 | Sidewalk: Property side : Yard | Tree | Private 2 | 7 | 5997987.32263 | 2094070.28162 | 37.7298026971396 | -122.449258019538 | (37.7298026971396, -122.449258019538) | 9 | 7 | 4 | 28861 | 40 | ||||
11562 | 206018 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 99 Merced Ave | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 12 | Width 3ft | 5994828.29695 | 2099714.01169 | 37.7451177882671 | -122.460587859436 | (37.7451177882671, -122.460587859436) | 1 | 8 | 4 | 59 | 40 | |||
76986 | 205989 | DPW Maintained 1 | Ceratonia siliqua :: Carob 5 | 566 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout | Tree | Private 2 | 5 | Width 6ft | 5994108.82044 | 2099457.01961 | 37.744370734026 | -122.463057021885 | (37.744370734026, -122.463057021885) | 1 | 8 | 4 | 29491 | 40 | |||
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 | |||
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 | |||
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 |
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) );