Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qCaretaker, qCareAssistant, PlantDate, DBH, PermitNotes
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate ▼ | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4380 | 4380 | 106727 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2809 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000017.8025 | 2114366.8285 | 37.785647962066996 | -122.443695977864 | (37.785647962067, -122.443695977864) | |||
| 6028 | 6028 | 11179 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2750X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 36 | 3x3 | 6006893.591019999 | 2121789.4662 | 37.8064184289444 | -122.42043473540001 | (37.8064184289444, -122.4204347354) | |||
| 9911 | 9911 | 173732 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1690x Galvez Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6015419.0 | 2098106.0 | 37.7418656239974 | -122.389275919147 | (37.7418656239974, -122.389275919147) | ||||
| 13413 | 13413 | 17446 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1966 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6012949.4647699995 | 2096727.20845 | 37.737942533829106 | -122.397718137505 | (37.7379425338291, -122.397718137505) | |||
| 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) | |||
| 13899 | 13899 | 16527 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016370.17243 | 2098292.39049 | 37.7424301004582 | -122.386000034169 | (37.7424301004582, -122.386000034169) | |||
| 14293 | 14293 | 17415 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1820X Palou Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6013619.40586 | 2096223.80848 | 37.73659758599771 | -122.395366549732 | (37.7365975859977, -122.395366549732) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 16099 | 16099 | 16541 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 400X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016112.61616 | 2098044.40161 | 37.7417349164267 | -122.386873303758 | (37.7417349164267, -122.386873303758) | |||
| 16103 | 16103 | 17387 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1657 Palou Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6014551.02447 | 2095461.0111900002 | 37.7345548713079 | -122.39209219010901 | (37.7345548713079, -122.392092190109) | |||
| 19409 | 19409 | 16623 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 136 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6002840.1476308 | 2107468.9628395 | 37.7668687081336 | -122.433438380285 | (37.7668687081336, -122.433438380285) | |||
| 20496 | 20496 | 97187 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 10X Fremont St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | |||
| 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) | |||
| 32206 | 32206 | 115845 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6003527.72894 | 2120738.7231400004 | 37.8033431135653 | -122.432007819421 | (37.8033431135653, -122.432007819421) | |||
| 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) | ||||
| 42092 | 42092 | 115843 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003556.384769999 | 2120742.54729 | 37.80335523820229 | -122.431908928161 | (37.8033552382023, -122.431908928161) | |||
| 46321 | 46321 | 115844 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6003543.04696 | 2120740.86009 | 37.8033498494719 | -122.43195496357 | (37.8033498494719, -122.43195496357) | |||
| 49114 | 49114 | 103343 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 590X 09th St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6010323.0 | 2108639.0 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | |||
| 49414 | 49414 | 115847 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3501 Laguna St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6003582.67693 | 2120834.7351599997 | 37.80360985246121 | -122.431824529496 | (37.8036098524612, -122.431824529496) | |||
| 79194 | 79194 | 97180 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 10X Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | |||
| 79625 | 79625 | 14913 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017225.13937 | 2098220.80076 | 37.7422808088462 | -122.383038803855 | (37.7422808088462, -122.383038803855) | |||
| 81285 | 81285 | 16511 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016438.273030001 | 2098384.37308 | 37.7426864345304 | -122.385770970205 | (37.7426864345304, -122.385770970205) | |||
| 81394 | 81394 | 103339 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 590X 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6010323.0 | 2108639.0 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | |||
| 82455 | 82455 | 14908 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017351.5544479005 | 2098138.8848753003 | 37.7420628687633 | -122.38259599628599 | (37.7420628687633, -122.382595996286) | |||
| 83106 | 83106 | 16498 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 305X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016898.459480001 | 2098256.16023 | 37.7423598423185 | -122.38417083560499 | (37.7423598423185, -122.384170835605) | |||
| 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) | ||||
| 83439 | 83439 | 119744 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 15X Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013411.0 | 2116073.0 | 37.7910874921548 | -122.39747874956998 | (37.7910874921548, -122.39747874957) | ||||
| 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) | ||||
| 85487 | 85487 | 115558 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2500x 19TH ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010357.0 | 2105131.0 | 37.7608727909959 | -122.407273854716 | (37.7608727909959, -122.407273854716) | ||||
| 86488 | 86488 | 103341 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 590X 09th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 3x3 | 6010323.0 | 2108639.0 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | |||
| 87292 | 87292 | 16507 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016604.68474 | 2098314.9336900003 | 37.7425049753024 | -122.385190723599 | (37.7425049753024, -122.385190723599) | |||
| 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) | |||
| 88469 | 88469 | 96756 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1820X Palou Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3x3 | 6013661.38712 | 2096183.48051 | 37.736489188553 | -122.395218577377 | (37.736489188553, -122.395218577377) | |||
| 89283 | 89283 | 16514 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016343.322430001 | 2098341.01182 | 37.7425621187056 | -122.386096262995 | (37.7425621187056, -122.386096262995) | |||
| 89436 | 89436 | 110184 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500x LYON ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999718.0 | 2114083.0 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | ||||
| 91314 | 91314 | 104633 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 850 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | 6009360.0 | 2104224.0 | 37.7583265252915 | -122.41065799814301 | (37.7583265252915, -122.410657998143) | |||
| 92651 | 92651 | 6652 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
| 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) | |||
| 93430 | 93430 | 14909 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017336.92539 | 2098155.67833 | 37.7421081720326 | -122.382647747732 | (37.7421081720326, -122.382647747732) | |||
| 95567 | 95567 | 110183 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500x LYON ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999718.0 | 2114083.0 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | ||||
| 96123 | 96123 | 119742 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 15X Fremont St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013411.0 | 2116073.0 | 37.7910874921548 | -122.39747874956998 | (37.7910874921548, -122.39747874957) | ||||
| 97353 | 97353 | 110185 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500x LYON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999718.0 | 2114083.0 | 37.7848515388794 | -122.444712796347 | (37.7848515388794, -122.444712796347) | ||||
| 97633 | 97633 | 16512 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016415.99739 | 2098380.53365 | 37.7426746595649 | -122.38584772611999 | (37.7426746595649, -122.38584772612) | |||
| 98540 | 98540 | 16491 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 305X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016683.0708800005 | 2098298.50072 | 37.7424641896573 | -122.384918540359 | (37.7424641896573, -122.384918540359) | |||
| 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) | |||
| 100386 | 100386 | 115557 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2500x 19TH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6010357.0 | 2105131.0 | 37.7608727909959 | -122.407273854716 | (37.7608727909959, -122.407273854716) | ||||
| 101673 | 101673 | 119745 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 15X Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013411.0 | 2116073.0 | 37.7910874921548 | -122.39747874956998 | (37.7910874921548, -122.39747874957) | ||||
| 101854 | 101854 | 114592 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 70 LOMITA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5991433.0 | 2104626.0 | 37.7584089066312 | -122.472686161822 | (37.7584089066312, -122.472686161822) | |||
| 102430 | 102430 | 96852 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1x Bennington St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6007194.0 | 2097789.0 | 37.7405357947447 | -122.417692894396 | (37.7405357947447, -122.417692894396) | |||
| 102458 | 102458 | 22886 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 95X Valencia St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3x3 | 6006042.93395 | 2109155.55847 | 37.771680885423606 | -122.422480302267 | (37.7716808854236, -122.422480302267) | |||
| 102694 | 102694 | 103342 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 590X 09th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6010323.0 | 2108639.0 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | |||
| 103650 | 103650 | 97186 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 10X Fremont St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | |||
| 103733 | 103733 | 97188 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 10X Fremont St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | |||
| 103848 | 103848 | 14914 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017206.58246 | 2098230.05631 | 37.742305197314295 | -122.383103612647 | (37.7423051973143, -122.383103612647) | |||
| 104195 | 104195 | 105930 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 971 Florida St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6009455.0 | 2103552.4 | 37.7564877890416 | -122.410282026926 | (37.7564877890416, -122.410282026926) | |||||
| 107120 | 107120 | 97182 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 10X Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | |||
| 107427 | 107427 | 6650 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
| 109098 | 109098 | 97181 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 10X Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | |||
| 109213 | 109213 | 18922 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 2620 SACRAMENTO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6002038.8 | 2115762.8 | 37.7895960030005 | -122.436803887406 | (37.7895960030005, -122.436803887406) | |||
| 109377 | 109377 | 97184 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 10X Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013138.0 | 2116168.0 | 37.791333135618 | -122.398429995238 | (37.791333135618, -122.398429995238) | |||
| 109877 | 109877 | 103340 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 590X 09th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | Permit Number 772809 | 6010323.0 | 2108639.0 | 37.7705030566796 | -122.407638793146 | (37.7705030566796, -122.407638793146) | ||
| 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) | |||
| 110305 | 110305 | 6648 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
| 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) | ||||
| 112741 | 112741 | 16513 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016404.80629 | 2098376.61978 | 37.742663293572505 | -122.38588614932699 | (37.7426632935725, -122.385886149327) | |||
| 113999 | 113999 | 14911 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6017284.29114 | 2098190.72199 | 37.7422014869413 | -122.38283218039 | (37.7422014869413, -122.38283218039) | |||
| 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) | |||
| 114992 | 114992 | 116858 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 180 NOE ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | 3x3 | 6002788.0 | 2107242.0 | 37.7662425648461 | -122.43360252819201 | (37.7662425648461, -122.433602528192) | |||
| 119053 | 119053 | 6649 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
| 119094 | 119094 | 119743 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 15X Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013411.0 | 2116073.0 | 37.7910874921548 | -122.39747874956998 | (37.7910874921548, -122.39747874957) | ||||
| 119338 | 119338 | 113383 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 146 CASTENADA AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 5994461.0 | 2101055.0 | 37.7487786662853 | -122.46195512222401 | (37.7487786662853, -122.461955122224) | |||
| 119633 | 119633 | 103345 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1000 Brannan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | Permit Number 29899 | 6010491.0 | 2108479.0 | 37.7700731362443 | -122.407046397751 | (37.7700731362443, -122.407046397751) | ||
| 119784 | 119784 | 16497 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 305X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3x3 | 6016834.58957 | 2098268.17724 | 37.7423893070591 | -122.384392517318 | (37.7423893070591, -122.384392517318) | |||
| 120157 | 120157 | 17414 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1820X Palou Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6013664.43707 | 2096187.44321 | 37.7365002389252 | -122.39520830982599 | (37.7365002389252, -122.395208309826) | |||
| 120289 | 120289 | 96855 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Eugenia Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6007257.0 | 2097738.0 | 37.740399305054005 | -122.41747145076599 | (37.740399305054, -122.417471450766) | |||
| 121279 | 121279 | 112815 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 10 LOMITA AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5991472.0 | 2104830.0 | 37.7589712942358 | -122.472566156736 | (37.7589712942358, -122.472566156736) | ||||
| 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) | |||
| 122587 | 122587 | 97183 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 10X Fremont St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | |||
| 122698 | 122698 | 16510 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | |||
| 123040 | 123040 | 97185 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 10X Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013222.5 | 2116242.1 | 37.7915413037038 | -122.398142826086 | (37.7915413037038, -122.398142826086) | |||
| 123471 | 123471 | 6651 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 495X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3x3 | 6016063.3688156 | 2097887.7750356 | 37.7413021249823 | -122.38703266472 | (37.7413021249823, -122.38703266472) | |||
| 124746 | 124746 | 14912 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017247.980359999 | 2098210.14599 | 37.742252815079496 | -122.38295908456999 | (37.7422528150795, -122.38295908457) | |||
| 124887 | 124887 | 97179 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 10X Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6013408.0 | 2116114.0 | 37.7911999015077 | -122.397492006217 | (37.7911999015077, -122.397492006217) | |||
| 125918 | 125918 | 103687 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 903 SHOTWELL ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 6008052.0 | 2102672.0 | 37.7539916655216 | -122.41507179826799 | (37.7539916655216, -122.415071798268) | |||
| 127358 | 127358 | 119741 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 15X Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013411.0 | 2116073.0 | 37.7910874921548 | -122.39747874956998 | (37.7910874921548, -122.39747874957) | ||||
| 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) | |||
| 135731 | 135731 | 115846 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6003504.2747 | 2120736.26354 | 37.8033350304463 | -122.432088807873 | (37.8033350304463, -122.432088807873) | |||
| 138765 | 138765 | 16490 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 305X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016659.29203 | 2098304.79019 | 37.7424801439961 | -122.385001199414 | (37.7424801439961, -122.385001199414) | |||
| 139540 | 139540 | 119746 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 15X Fremont St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6013411.0 | 2116073.0 | 37.7910874921548 | -122.39747874956998 | (37.7910874921548, -122.39747874957) | ||||
| 140383 | 140383 | 16554 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 500X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6016006.287148001 | 2097894.9109735 | 37.74131855784729 | -122.387230532448 | (37.7413185578473, -122.387230532448) | |||
| 142096 | 142096 | 10409 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1398 HAIGHT ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3x3 | 5999436.0 | 2108778.0 | 37.7702692735678 | -122.445306860847 | (37.7702692735678, -122.445306860847) | |||
| 144112 | 144112 | 113692 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 3x3 | 6006814.0 | 2098928.0 | 37.7436418429474 | -122.419087559811 | (37.7436418429474, -122.419087559811) | |||
| 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) | ||||
| 145790 | 145790 | 14915 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3x3 | 6017191.33538 | 2098236.4203 | 37.742321829008496 | -122.383156775767 | (37.7423218290085, -122.383156775767) |
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");