Data source: data.sfgov.org
This data as json, CSV (advanced)
These facets timed out: qLegalStatus
Link | rowid | TreeID ▼ | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
39687 | 39687 | 80561 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1820X Palou Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/07/2002 12:00:00 AM | 15 | 6013651.87309 | 2096197.8113799999 | 37.736528009043795 | -122.395252475224 | (37.7365280090438, -122.395252475224) | ||
13616 | 13616 | 83038 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/04/2006 12:00:00 AM | 6018593.33009 | 2097780.6594 | 37.7411477742489 | -122.378277419086 | (37.7411477742489, -122.378277419086) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
124125 | 124125 | 101489 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 59X Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/2012 12:00:00 AM | 1 | 3x3 | Permit Number 769087 | 6005416.7 | 2109221.0 | 37.7718252244657 | -122.424651142233 | (37.7718252244657, -122.424651142233) | |
108621 | 108621 | 101685 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 363 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 12x9 | 6013519.417230001 | 2105388.32273 | 37.7617558261822 | -122.396354408248 | (37.7617558261822, -122.396354408248) | |||
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) | |||
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) | ||
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) | |||
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) | |||
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) | |||
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) | ||
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) | |||
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) | |||
92531 | 92531 | 105449 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 890 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009082.7 | 2103985.1 | 37.7576550089679 | -122.411600148106 | (37.7576550089679, -122.411600148106) | |||||
84282 | 84282 | 105450 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 890 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6009082.7 | 2103985.1 | 37.7576550089679 | -122.411600148106 | (37.7576550089679, -122.411600148106) | |||||
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) | |||||
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) | |||
14523 | 14523 | 107150 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 219 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | 5x5 | 6013483.53646 | 2106027.96623 | 37.7635101499066 | -122.396523344982 | (37.7635101499066, -122.396523344982) | |||
13493 | 13493 | 107151 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 215 Missouri St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6013483.16907 | 2106058.28155 | 37.7635933686511 | -122.396526740817 | (37.7635933686511, -122.396526740817) | |||
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) | ||||
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) | ||||
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) | ||||
61155 | 61155 | 111886 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 LUNDYS LN | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x12 | 6006709.0 | 2098750.0 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | |||
126258 | 126258 | 111887 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x12 | 6006709.0 | 2098750.0 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | |||
104253 | 104253 | 111888 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 LUNDYS LN | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x12 | 6006709.0 | 2098750.0 | 37.7431471814186 | -122.41943799965 | (37.7431471814186, -122.41943799965) | ||||
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) | ||||
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) | |||
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) | |||
113525 | 113525 | 113693 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 LUNDYS LN | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x5 | 6006814.0 | 2098928.0 | 37.7436418429474 | -122.419087559811 | (37.7436418429474, -122.419087559811) | ||||
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) | |||
79181 | 79181 | 115360 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 205 ARKANSAS ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x4 | 6012944.0 | 2106057.0 | 37.763559829435295 | -122.39839147938801 | (37.7635598294353, -122.398391479388) | ||||
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) | ||||
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) | ||||
174264 | 174264 | 115842 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Bay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3x3 | 6003573.215530001 | 2120746.37029 | 37.8033666892713 | -122.431850957862 | (37.8033666892713, -122.431850957862) | |||
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) | |||
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) | |||
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) | |||
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) | |||
168072 | 168072 | 115848 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3501 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 6003586.42591 | 2120801.53952 | 37.8035189184231 | -122.43180918435499 | (37.8035189184231, -122.431809184355) | |||
177272 | 177272 | 115849 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3501 Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6003588.62501 | 2120788.7376599996 | 37.803483892518294 | -122.43180065966801 | (37.8034838925183, -122.431800659668) | |||
151213 | 151213 | 115850 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3501 Laguna St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | 3x3 | 6003589.56269 | 2120774.48991 | 37.8034448250715 | -122.431796396884 | (37.8034448250715, -122.431796396884) | |||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
33051 | 33051 | 123914 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 389 09th Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5993078.53663 | 2112857.8084299997 | 37.7811063777719 | -122.467593853963 | (37.7811063777719, -122.467593853963) | |||
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) | |||
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) | |||
38071 | 38071 | 125966 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2198 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6002473.45784 | 2118854.30827 | 37.7981091788388 | -122.435521270088 | (37.7981091788388, -122.435521270088) | |||
35330 | 35330 | 125967 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3440 Clay St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 6ft | 5998347.68841 | 2115559.3339299997 | 37.7888268704136 | -122.449560024485 | (37.7888268704136, -122.449560024485) | |||
71217 | 71217 | 125968 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2810 Sacramento St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001336.417830001 | 2115647.62359 | 37.7892398148051 | -122.43922579254101 | (37.7892398148051, -122.439225792541) | |||
71848 | 71848 | 125969 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2672 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6002023.76351 | 2115741.9503 | 37.7895379005066 | -122.43685441882 | (37.7895379005066, -122.43685441882) | |||
71480 | 71480 | 125970 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2301 Sacramento St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6003734.22562 | 2115934.13704 | 37.7901626613254 | -122.430950126753 | (37.7901626613254, -122.430950126753) | |||
34241 | 34241 | 125971 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6008148.4886 | 2112831.1491900003 | 37.7818917385495 | -122.415457300812 | (37.7818917385495, -122.415457300812) | |||
137044 | 137044 | 125972 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 633 Beach St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6006913.21617 | 2121857.59743 | 37.806606605779294 | -122.42037165782601 | (37.8066066057793, -122.420371657826) | |||
54617 | 54617 | 125973 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 633 Beach St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6006932.43872 | 2121860.17562 | 37.8066147680158 | -122.420305317544 | (37.8066147680158, -122.420305317544) | |||
28725 | 28725 | 125974 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 633 Beach St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6007013.058230001 | 2121870.81717 | 37.806648529474295 | -122.42002707360399 | (37.8066485294743, -122.420027073604) | |||
58420 | 58420 | 125975 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 633 Beach St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6007035.474780001 | 2121873.14157 | 37.806656174619704 | -122.41994966175601 | (37.8066561746197, -122.419949661756) | |||
182201 | 182201 | 125976 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 633 Beach St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6007074.37921 | 2121877.42075 | 37.8066701158897 | -122.419815329109 | (37.8066701158897, -122.419815329109) | |||
175928 | 175928 | 125977 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2360 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6008401.628880001 | 2121444.29683 | 37.8055555474172 | -122.415191434251 | (37.8055555474172, -122.415191434251) | |||
174929 | 174929 | 125978 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2360 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6008392.85025 | 2121496.40648 | 37.8056981340166 | -122.415225505068 | (37.8056981340166, -122.415225505068) | |||
169791 | 169791 | 125979 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2360 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6008389.02756 | 2121512.5692 | 37.80574229793179 | -122.41523987893999 | (37.8057422979318, -122.41523987894) | |||
39568 | 39568 | 125980 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 6008387.31056 | 2121533.89692 | 37.8058007619722 | -122.415247331605 | (37.8058007619722, -122.415247331605) | |||
188551 | 188551 | 125981 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 6ft | 6008384.91577 | 2121552.17509 | 37.8058508146246 | -122.415256913874 | (37.8058508146246, -122.415256913874) | |||
136904 | 136904 | 125982 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 6ft | 6008379.56749 | 2121591.49972 | 37.8059584895516 | -122.415278208017 | (37.8059584895516, -122.415278208017) | |||
136532 | 136532 | 125983 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 5ft | 6008377.32314 | 2121617.1276 | 37.8060287311026 | -122.415287790321 | (37.8060287311026, -122.415287790321) | |||
52501 | 52501 | 125984 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 6ft | 6008373.73288 | 2121637.11508 | 37.8060834098955 | -122.41530163086 | (37.8060834098955, -122.41530163086) | |||
40966 | 40966 | 125985 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 6ft | 6008371.27829 | 2121652.4837 | 37.8061254702907 | -122.415311214049 | (37.8061254702907, -122.415311214049) | |||
44097 | 44097 | 125986 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 6ft | 6008368.52895 | 2121668.4711599997 | 37.8061692132974 | -122.415321861121 | (37.8061692132974, -122.415321861121) | |||
56220 | 56220 | 125987 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2362 Taylor St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 6ft | 6008367.52131 | 2121686.8739 | 37.8062196859398 | -122.415326651828 | (37.8062196859398, -122.415326651828) | |||
174828 | 174828 | 125988 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008319.39655 | 2121673.00017 | 37.806178887323 | -122.41549221341101 | (37.806178887323, -122.415492213411) | |||
160878 | 160878 | 125989 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008326.45195 | 2121634.40634 | 37.8060733149832 | -122.41546506288 | (37.8060733149832, -122.41546506288) | |||
57395 | 57395 | 125990 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008335.581590001 | 2121584.4344900004 | 37.8059366180507 | -122.415429928145 | (37.8059366180507, -122.415429928145) | |||
25271 | 25271 | 125991 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008338.82398 | 2121554.9566599997 | 37.805855861614795 | -122.41541661910699 | (37.8058558616148, -122.415416619107) | |||
174972 | 174972 | 125992 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008341.11218 | 2121531.47257 | 37.8057915088426 | -122.41540703681801 | (37.8057915088426, -122.415407036818) | |||
137305 | 137305 | 125993 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6008342.4716300005 | 2121500.19485 | 37.8057057045282 | -122.415400116539 | (37.8057057045282, -122.415400116539) | |||
188434 | 188434 | 125994 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008347.52133 | 2121476.34798 | 37.805640510859206 | -122.41538095198901 | (37.8056405108592, -122.415380951989) | |||
67946 | 67946 | 125995 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2361 Taylor St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008349.66203 | 2121453.17315 | 37.8055769989413 | -122.41537190211201 | (37.8055769989413, -122.415371902112) | |||
60413 | 60413 | 125996 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007913.10752 | 2121457.27998 | 37.8055637294392 | -122.41688295558001 | (37.8055637294392, -122.41688295558) | |||
67137 | 67137 | 125997 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6007910.60432 | 2121475.9089200003 | 37.8056147389887 | -122.416892938958 | (37.8056147389887, -122.416892938958) | |||
180722 | 180722 | 125998 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6007907.02571 | 2121498.39071 | 37.8056762669961 | -122.416906917118 | (37.8056762669961, -122.416906917118) | |||
70834 | 70834 | 125999 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 6007905.9664 | 2121521.7786 | 37.8057404246312 | -122.41691224110399 | (37.8057404246312, -122.416912241104) | |||
23831 | 23831 | 126000 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6007902.73328 | 2121542.33791 | 37.805796693425705 | -122.41692488738501 | (37.8057966934257, -122.416924887385) | |||
61924 | 61924 | 126001 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 4ft | 6007899.07258 | 2121560.79928 | 37.8058471777553 | -122.41693886466001 | (37.8058471777553, -122.41693886466) | |||
28181 | 28181 | 126002 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6007897.34981 | 2121579.9870599997 | 37.805899765629704 | -122.41694618692699 | (37.8058997656297, -122.416946186927) | |||
71925 | 71925 | 126003 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2510 Jones St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6007892.3710199995 | 2121599.81603 | 37.80595393089521 | -122.41696482266501 | (37.8059539308952, -122.416964822665) |
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");