Data source: data.sfgov.org
This data as json, CSV (advanced)
Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
564 | 564 | 222895 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 3080 16th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | Permit Number 27054 | 6006273.18784 | 2106724.0940099997 | 37.765017648370105 | -122.42151112584801 | (37.7650176483701, -122.421511125848) | ||
946 | 946 | 23565 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2958 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 2X2 | 6005634.29929 | 2120573.5209 | 37.8030087114389 | -122.424706189543 | (37.8030087114389, -122.424706189543) | |||
7048 | 7048 | 18853 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2222 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3X3 | 6004009.33777 | 2116018.08762 | 37.7904087527096 | -122.430004251319 | (37.7904087527096, -122.430004251319) | |||
7397 | 7397 | 18866 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2241 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6004050.55009 | 2115976.0428299997 | 37.7902956422834 | -122.429858659173 | (37.7902956422834, -122.429858659173) | |||
7791 | 7791 | 18864 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2230 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6003886.2489 | 2116004.41909 | 37.7903642506674 | -122.430429154879 | (37.7903642506674, -122.430429154879) | |||
9098 | 9098 | 2530 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016273.7509883 | 2099134.0637751 | 37.7447358261247 | -122.38639210410601 | (37.7447358261247, -122.386392104106) | |||
9135 | 9135 | 2542 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1580 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016211.0400559995 | 2099180.9466222 | 37.7448610852571 | -122.386612216975 | (37.7448610852571, -122.386612216975) | |||
9160 | 9160 | 16481 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
9221 | 9221 | 16483 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
9262 | 9262 | 16480 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
9277 | 9277 | 16482 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
9322 | 9322 | 16485 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
9397 | 9397 | 2544 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1580 BURKE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6016440.0 | 2099034.0 | 37.7444702727306 | -122.385810268433 | (37.7444702727306, -122.385810268433) | |||
9402 | 9402 | 16488 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 0 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
9478 | 9478 | 16486 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
9480 | 9480 | 2531 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016273.7509883 | 2099134.0637751 | 37.7447358261247 | -122.38639210410601 | (37.7447358261247, -122.386392104106) | |||
13474 | 13474 | 17398 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1734X Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6014174.38954 | 2095813.0161 | 37.7355004859498 | -122.393418978825 | (37.7355004859498, -122.393418978825) | |||
13524 | 13524 | 17444 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1950 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6013023.363469999 | 2096670.73663 | 37.737791588910206 | -122.397458672302 | (37.7377915889102, -122.397458672302) | |||
13824 | 13824 | 2526 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6016552.46567 | 2098935.10176 | 37.744204941317 | -122.385414490998 | (37.744204941317, -122.385414490998) | |||
14309 | 14309 | 14975 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400X Mendell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3x3 | 6016578.93942 | 2097580.627 | 37.7404872941606 | -122.38522858943001 | (37.7404872941606, -122.38522858943) | |||
14401 | 14401 | 17464 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2043 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6012526.80505 | 2096970.93797 | 37.738588218270294 | -122.39919659325301 | (37.7385882182703, -122.399196593253) | |||
14457 | 14457 | 6846 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 595X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015951.07042 | 2097735.77472 | 37.7408785442151 | -122.387410355501 | (37.7408785442151, -122.387410355501) | |||
14666 | 14666 | 17420 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1844 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6013467.77602 | 2096339.40457 | 37.736906554399496 | -122.395898900707 | (37.7369065543995, -122.395898900707) | |||
15376 | 15376 | 17400 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1740 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6014126.91093 | 2095851.1855799998 | 37.735602653440296 | -122.393585802156 | (37.7356026534403, -122.393585802156) | |||
15837 | 15837 | 16547 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016044.76119 | 2097949.4335 | 37.741470396145104 | -122.387101303489 | (37.7414703961451, -122.387101303489) | |||
15887 | 15887 | 16546 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6016053.72523 | 2097961.74591 | 37.7415046998888 | -122.387071167201 | (37.7415046998888, -122.387071167201) | |||
15967 | 15967 | 17458 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1999 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 55 | 3x3 | 6012778.88075 | 2096779.8432200002 | 37.7380775571329 | -122.398311626199 | (37.7380775571329, -122.398311626199) | |||
16138 | 16138 | 14974 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400X Mendell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016589.22096 | 2097595.13367 | 37.7405276953073 | -122.385194050084 | (37.7405276953073, -122.385194050084) | |||
16340 | 16340 | 17417 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1836 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6013526.86611 | 2096296.9772700001 | 37.7367933450374 | -122.39569162676099 | (37.7367933450374, -122.395691626761) | |||
16941 | 16941 | 16644 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 170 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6002849.247169999 | 2107272.65524 | 37.7663302115978 | -122.433392876987 | (37.7663302115978, -122.433392876987) | |||
18910 | 18910 | 21791 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2585 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4X4 | 6008347.28278 | 2121527.17705 | 37.8057800612465 | -122.41538537817499 | (37.8057800612465, -122.415385378175) | |||
20514 | 20514 | 5432 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 499 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 36 | 3X3 | 6004968.151269999 | 2105494.35348 | 37.761567402922296 | -122.42593738121799 | (37.7615674029223, -122.425937381218) | |||
27998 | 27998 | 103976 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2440 Geary Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 6000022.661 | 2113372.9775 | 37.7829193814773 | -122.44360774817 | (37.7829193814773, -122.44360774817) | |||
37750 | 37750 | 106035 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Main St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014366.747719999 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | ||||
54603 | 54603 | 119737 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6013490.74423 | 2116034.43287 | 37.7909860356216 | -122.397200129801 | (37.7909860356216, -122.397200129801) | ||||
78717 | 78717 | 4915 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
83395 | 83395 | 106031 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 180 Howard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014640.7 | 2115990.0 | 37.7909279854042 | -122.39321818634 | (37.7909279854042, -122.39321818634) | ||||
84621 | 84621 | 21779 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2535 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4x4 | 6008355.3148 | 2121474.2130400003 | 37.8056350868765 | -122.415353830252 | (37.8056350868765, -122.415353830252) | |||
84776 | 84776 | 6848 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 595X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015895.1615953 | 2097662.6258274 | 37.740674595672296 | -122.387598567026 | (37.7406745956723, -122.387598567026) | |||
85060 | 85060 | 102876 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2761 21st St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009574.6 | 2103896.5 | 37.757439313651396 | -122.409892695521 | (37.7574393136514, -122.409892695521) | ||||
86378 | 86378 | 21780 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2535 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 4X4 | 6008357.89402 | 2121452.8869 | 37.805576675639 | -122.41534339379 | (37.805576675639, -122.41534339379) | |||
88100 | 88100 | 16556 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | |||
88163 | 88163 | 21790 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2585 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 4X4 | 6008342.51156 | 2121554.8602 | 37.8058558040212 | -122.41540385079901 | (37.8058558040212, -122.415403850799) | |||
88683 | 88683 | 16650 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 190 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002855.60879 | 2107200.17785 | 37.7661315672606 | -122.433365693732 | (37.7661315672606, -122.433365693732) | |||
90047 | 90047 | 21787 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2585 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 4X4 | 6008331.30284 | 2121636.25204 | 37.806078655460894 | -122.41544840628201 | (37.8060786554609, -122.415448406282) | |||
91412 | 91412 | 21783 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2550 TAYLOR ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 5x5 | 6008458.6 | 2121488.8 | 37.8056809434427 | -122.414997429015 | (37.8056809434427, -122.414997429015) | |||
92019 | 92019 | 94581 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1025 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 5998825.0 | 2106371.0 | 37.763625362932 | -122.44724703752199 | (37.763625362932, -122.447247037522) | ||||
92988 | 92988 | 87254 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 32 McCarthy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50278 | 6007985.7 | 2086740.5 | 37.710243492017895 | -122.414174016703 | (37.7102434920179, -122.414174016703) | |||
96191 | 96191 | 22896 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 201 Valencia St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | 2X2 | 6006117.697509999 | 2108447.0783700002 | 37.7697397858216 | -122.422171347799 | (37.7697397858216, -122.422171347799) | |||
98251 | 98251 | 16517 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | |||
99856 | 99856 | 16553 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | |||
102536 | 102536 | 4922 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
110128 | 110128 | 17403 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1775 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 55 | 3x3 | 6013944.430980001 | 2095916.733 | 37.7357724918668 | -122.39422129757901 | (37.7357724918668, -122.394221297579) | |||
110377 | 110377 | 16641 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 161 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6002897.949322799 | 2107328.6416625 | 37.7664866995789 | -122.433228426337 | (37.7664866995789, -122.433228426337) | |||
110724 | 110724 | 101044 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 655 Beach St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47845 | 6006837.0 | 2121873.0 | 37.8066446021589 | -122.42063651284501 | (37.8066446021589, -122.420636512845) | ||||
111336 | 111336 | 106033 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014366.747719999 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | ||||
112036 | 112036 | 101042 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 655 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47845 | 6006837.0 | 2121873.0 | 37.8066446021589 | -122.42063651284501 | (37.8066446021589, -122.420636512845) | ||||
112758 | 112758 | 21782 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2550 TAYLOR ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 5x5 | 6008458.6 | 2121488.8 | 37.8056809434427 | -122.414997429015 | (37.8056809434427, -122.414997429015) | |||
113571 | 113571 | 22889 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 95X Valencia St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6006042.93395 | 2109155.55847 | 37.771680885423606 | -122.422480302267 | (37.7716808854236, -122.422480302267) | |||
113730 | 113730 | 4923 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 12 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
114124 | 114124 | 87253 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2 McCarthy Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 50277 | 6008031.4 | 2086860.8 | 37.7105763778259 | -122.414024572568 | (37.7105763778259, -122.414024572568) | |||
115904 | 115904 | 21786 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2585 Taylor St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 4X4 | 6008350.54359 | 2121501.89618 | 37.805710829631295 | -122.41537230277201 | (37.8057108296313, -122.415372302772) | |||
116284 | 116284 | 2744 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 5995591.7347 | 2110770.58853 | 37.775520208006604 | -122.458748349075 | (37.7755202080066, -122.458748349075) | |||
120218 | 120218 | 51670 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 848 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47948 | 5998713.82301338 | 2107188.47532501 | 37.765863591183 | -122.44769041413299 | (37.765863591183, -122.447690414133) | ||||
120916 | 120916 | 101045 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 655 Beach St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47845 | 6006837.0 | 2121873.0 | 37.8066446021589 | -122.42063651284501 | (37.8066446021589, -122.420636512845) | ||||
121368 | 121368 | 101043 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 655 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 47845 | 6006837.0 | 2121873.0 | 37.8066446021589 | -122.42063651284501 | (37.8066446021589, -122.420636512845) | ||||
121655 | 121655 | 16548 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016043.45751 | 2097947.5572599997 | 37.7414651721818 | -122.387105680372 | (37.7414651721818, -122.387105680372) | |||
126122 | 126122 | 20125 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 924X Fell St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | 6002999.41967 | 2110319.2516799998 | 37.7747039360019 | -122.433091154251 | (37.7747039360019, -122.433091154251) | |||
127903 | 127903 | 102874 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 2761 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4x4 | 6009574.6 | 2103896.5 | 37.757439313651396 | -122.409892695521 | (37.7574393136514, -122.409892695521) | ||||
128870 | 128870 | 6849 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 595X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6015895.1615953 | 2097662.6258274 | 37.740674595672296 | -122.387598567026 | (37.7406745956723, -122.387598567026) | |||
141444 | 141444 | 4914 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6017015.097207401 | 2098230.5166868 | 37.742295878473 | -122.383765748687 | (37.742295878473, -122.383765748687) | |||
145698 | 145698 | 106032 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6014366.747719999 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | ||||
146013 | 146013 | 16552 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 500X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | |||
154265 | 154265 | 119738 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6013480.63892 | 2116044.41356 | 37.7910128776808 | -122.397235794198 | (37.7910128776808, -122.397235794198) | ||||
157632 | 157632 | 119739 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6013469.82728 | 2116055.87494 | 37.7910437460335 | -122.397274006392 | (37.7910437460335, -122.397274006392) | ||||
163641 | 163641 | 96473 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | Permit Number 767637 | 6014754.27658 | 2116074.97331 | 37.7911676114441 | -122.392831160352 | (37.7911676114441, -122.392831160352) | ||
165346 | 165346 | 85254 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Permit Number 49553 | 6013520.55509 | 2116003.76772 | 37.7909034958536 | -122.39709483357201 | (37.7909034958536, -122.397094833572) | |||
171008 | 171008 | 119740 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 6013460.477580001 | 2116066.8176700003 | 37.791073271674705 | -122.397307123936 | (37.7910732716747, -122.397307123936) | ||||
175776 | 175776 | 85255 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 45 Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Permit Number 49553 | 6013503.0525 | 2116024.16318 | 37.7909585226636 | -122.39715682295 | (37.7909585226636, -122.39715682295) | |||
176954 | 176954 | 106030 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 180 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 3x3 | 6014615.46906 | 2115943.46238 | 37.790798802166 | -122.393302227016 | (37.790798802166, -122.393302227016) | |||
82535 | 82535 | 63222 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 76 Prospect Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1987 12:00:00 AM | Permit Number 23766 | 6007018.22684623 | 2099086.03719365 | 37.7440872763149 | -122.41839259476801 | (37.7440872763149, -122.418392594768) | ||
81111 | 81111 | 49041 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 406 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/2003 12:00:00 AM | Permit Number 46216 | 6004132.32350443 | 2101573.22879489 | 37.750753648355605 | -122.428548658976 | (37.7507536483556, -122.428548658976) | ||
31183 | 31183 | 61726 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 28 Ceres St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | 9 | Permit Number 21728 | 6013869.02725 | 2093995.2493599998 | 37.7304922999628 | -122.39434750633998 | (37.7304922999628, -122.39434750634) | |
81866 | 81866 | 61684 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 49 Ceres St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | Permit Number 21681 | 6013901.59422939 | 2093898.15648128 | 37.7302275129585 | -122.394228121663 | (37.7302275129585, -122.394228121663) | ||
158717 | 158717 | 61724 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 18 Ceres St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | 8 | Permit Number 21726 | 6013883.84127 | 2094072.5147 | 37.7307052783181 | -122.39430169937599 | (37.7307052783181, -122.394301699376) | |
166502 | 166502 | 61685 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 34 Ceres St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/1985 12:00:00 AM | 11 | Permit Number 21682 | 6013864.09066 | 2093969.56082 | 37.730421490047604 | -122.39436277503201 | (37.7304214900476, -122.394362775032) | |
127474 | 127474 | 63232 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 53 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/13/1987 12:00:00 AM | Permit Number 23779 | 6007031.32644483 | 2099242.02691528 | 37.7445163265111 | -122.418358357204 | (37.7445163265111, -122.418358357204) | ||
145872 | 145872 | 63270 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 15 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/26/1987 12:00:00 AM | Permit Number 23827 | 6007494.42657363 | 2099465.13084364 | 37.7451549781049 | -122.41677284932 | (37.7451549781049, -122.41677284932) | ||
105799 | 105799 | 51546 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 655 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/01/2005 12:00:00 AM | Permit Number 47845 | 6007074.31830792 | 2121880.33708987 | 37.806678119982706 | -122.419815746942 | (37.8066781199827, -122.419815746942) | |||
33365 | 33365 | 93109 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 9 | 3x3 | Permit Number 53024 | 6016621.354169999 | 2098362.60938 | 37.7426368051604 | -122.385136406214 | (37.7426368051604, -122.385136406214) | |
35467 | 35467 | 93114 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53024 | 6016526.70747 | 2098382.7110900003 | 37.7426867642747 | -122.385465070679 | (37.7426867642747, -122.385465070679) | |
123421 | 123421 | 93111 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 7 | 3x3 | Permit Number 53024 | 6016584.37921 | 2098370.12887 | 37.742655406712295 | -122.38526477996099 | (37.7426554067123, -122.385264779961) | |
153716 | 153716 | 93113 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 9 | 3x3 | Permit Number 53024 | 6016543.92232 | 2098378.4931799998 | 37.7426761351889 | -122.385405252254 | (37.7426761351889, -122.385405252254) | |
154271 | 154271 | 93112 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53024 | 6016561.73954 | 2098375.23066 | 37.7426681627043 | -122.38534341756599 | (37.7426681627043, -122.385343417566) | |
184090 | 184090 | 93110 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53024 | 6016603.548880001 | 2098366.45199 | 37.7426463712226 | -122.385198240014 | (37.7426463712226, -122.385198240014) | |
23428 | 23428 | 106029 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 180 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2015 12:00:00 AM | 14 | 3x3 | Permit Number 770222 | 6014636.89755 | 2115962.51686 | 37.790852311826704 | -122.39322941879801 | (37.7908523118267, -122.393229418798) | |
98613 | 98613 | 106036 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 195X Main St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2015 12:00:00 AM | 3x3 | Permit Number 770222 | 6014366.747719999 | 2116104.57878 | 37.7912273690908 | -122.394174082061 | (37.7912273690908, -122.394174082061) | ||
182276 | 182276 | 106027 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 180 Howard St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/05/2015 12:00:00 AM | 11 | 3x3 | Permit Number 770222 | 6014665.819209999 | 2115987.9153400003 | 37.7909236568574 | -122.393131128317 | (37.7909236568574, -122.393131128317) | |
137523 | 137523 | 65609 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 259 Maynard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/1990 12:00:00 AM | 12 | Permit Number 28514 | 6005079.93888 | 2093817.0268700002 | 37.7295104552453 | -122.42472001303801 | (37.7295104552453, -122.424720013038) | |
117465 | 117465 | 51304 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 4331 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/24/2011 12:00:00 AM | 3x3 | Permit Number 767250 | 6001037.11613846 | 2102279.06351254 | 37.752516053262795 | -122.439302719451 | (37.7525160532628, -122.439302719451) |
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");