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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||||
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) | |||
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) | ||||
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) | ||||
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) | |||||
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) | ||||
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) | ||||
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) | |||||
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) | ||||
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) | ||||
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) | |||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
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) | ||||
38544 | 38544 | 189841 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017113.188630001 | 2098207.21128 | 37.742237308295294 | -122.38342495321899 | (37.7422373082953, -122.383424953219) | |||
41360 | 41360 | 225095 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 231 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 6004583.37564 | 2109107.4182 | 37.7714662577942 | -122.427525575841 | (37.7714662577942, -122.427525575841) | |||
60830 | 60830 | 189847 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 9 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017231.39271 | 2098158.2223400003 | 37.7421093266962 | -122.383012827183 | (37.7421093266962, -122.383012827183) | |||
73397 | 73397 | 246510 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 231 Duncan St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 5ft | 6004993.26159 | 2099869.66747 | 37.7461247456624 | -122.425450235552 | (37.7461247456624, -122.425450235552) | |||
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) | |
131320 | 131320 | 189846 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 8 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017214.17115 | 2098166.7194 | 37.7421317063069 | -122.383072965771 | (37.7421317063069, -122.383072965771) | |||
132013 | 132013 | 189839 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017074.26086 | 2098217.41845 | 37.7422631836031 | -122.38356026519699 | (37.7422631836031, -122.383560265197) | |||
157640 | 157640 | 189843 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 1 | Width 3ft | 6017155.58292 | 2098191.33075 | 37.742196046505 | -122.38327726024599 | (37.742196046505, -122.383277260246) | |||
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) | |||
34932 | 34932 | 222909 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 363 Page St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 4ft | 6004826.79581 | 2109830.90843 | 37.7734665514719 | -122.426735103265 | (37.7734665514719, -122.426735103265) | |||
166259 | 166259 | 189957 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 572 07th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6011483.58307 | 2109635.35024 | 37.773303704933895 | -122.40369442207701 | (37.7733037049339, -122.403694422077) | |||
5182 | 5182 | 225094 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 621 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 3ft | Permit Number 780775 | 6002723.2165 | 2108842.98565 | 37.7706348030957 | -122.433941050651 | (37.7706348030957, -122.433941050651) | |
35349 | 35349 | 189956 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 572 07th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6011467.9689 | 2109652.48068 | 37.773349868946205 | -122.403749639528 | (37.7733498689462, -122.403749639528) | |||
37517 | 37517 | 246517 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 41 Waller St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6005417.73549 | 2109222.5624700002 | 37.771829573112605 | -122.424647671566 | (37.7718295731126, -122.424647671566) | |||
43464 | 43464 | 206016 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1500 Plymouth Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995893.6658 | 2094152.61505 | 37.7299087874515 | -122.45650193453899 | (37.7299087874515, -122.456501934539) | |||
45186 | 45186 | 205991 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 452 Kenwood Way | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993388.91946 | 2093682.37508 | 37.72847350453279 | -122.465126926677 | (37.7284735045328, -122.465126926677) | |||
58573 | 58573 | 189943 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 160 Spear St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 6014663.902869999 | 2116268.03372 | 37.7916926905231 | -122.39315736781299 | (37.7916926905231, -122.393157367813) | |||
63634 | 63634 | 182440 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1530 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5985926.0511 | 2104791.6519 | 37.7585434265078 | -122.49174356193998 | (37.7585434265078, -122.49174356194) | |||
65825 | 65825 | 205992 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 452 Kenwood Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993371.398019999 | 2093686.3141400001 | 37.728483309840996 | -122.46518778469299 | (37.728483309841, -122.465187784693) | |||
67512 | 67512 | 225043 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 463 Nevada St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6008911.67409 | 2096164.66425 | 37.7361722309519 | -122.411639081583 | (37.7361722309519, -122.411639081583) | |||
73260 | 73260 | 205990 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 452 Kenwood Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993405.09676 | 2093676.5167599998 | 37.7284583518695 | -122.46507057606001 | (37.7284583518695, -122.46507057606) | |||
114538 | 114538 | 189945 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 162 Spear St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 6014694.61322 | 2116242.67208 | 37.791624759330396 | -122.393049334066 | (37.7916247593304, -122.393049334066) | |||
148086 | 148086 | 182304 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2531 Kirkham St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5986925.2797 | 2105029.7497 | 37.759255527351606 | -122.488305322992 | (37.7592555273516, -122.488305322992) | |||
156493 | 156493 | 189885 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 201 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6016834.26905 | 2098267.19561 | 37.7423865939792 | -122.38439355723601 | (37.7423865939792, -122.384393557236) | |||
160768 | 160768 | 189840 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6017094.37686 | 2098212.93845 | 37.7422519942486 | -122.383490397763 | (37.7422519942486, -122.383490397763) | |||
27659 | 27659 | 189891 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6016826.79146 | 2098321.83879 | 37.7425362195639 | -122.384423217764 | (37.7425362195639, -122.384423217764) | |||
34084 | 34084 | 206003 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1593 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991725.497880001 | 2104502.2556 | 37.7580860643266 | -122.471665566325 | (37.7580860643266, -122.471665566325) | |||
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) | |||
62337 | 62337 | 199691 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1343 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 6016071.0177 | 2092930.0859 | 37.7276897308085 | -122.38666058841001 | (37.7276897308085, -122.38666058841) | |||
67550 | 67550 | 189912 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Flora St | 8 | : 4 | Tree 1 | Private 1 | 4 | Width 3ft | 6013884.75868 | 2094408.4745200002 | 37.7316278064595 | -122.394322041155 | (37.7316278064595, -122.394322041155) | |||
74726 | 74726 | 206007 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Vicente St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991032.21326 | 2097741.2680200003 | 37.739482016692904 | -122.473570049822 | (37.7394820166929, -122.473570049822) | |||
157059 | 157059 | 206005 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991064.94409 | 2097743.51009 | 37.7394900683054 | -122.47345704553001 | (37.7394900683054, -122.47345704553) | |||
167323 | 167323 | 225063 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 247 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998979.478759999 | 2106681.18548 | 37.7644858801306 | -122.44673506598998 | (37.7644858801306, -122.44673506599) | |||
184302 | 184302 | 189844 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6017173.06513 | 2098183.08322 | 37.742174366561606 | -122.383216237654 | (37.7421743665616, -122.383216237654) | |||
185355 | 185355 | 225064 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 253 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5998981.0777900005 | 2106664.05961 | 37.7644389481338 | -122.446728303069 | (37.7644389481338, -122.446728303069) | |||
186595 | 186595 | 206002 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1593 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5991725.37276 | 2104496.31776 | 37.758069753342205 | -122.47166556633199 | (37.7580697533422, -122.471665566332) | |||
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) | |||
25032 | 25032 | 189928 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 43 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013312.71119 | 2116223.04908 | 37.79149401858479 | -122.397829357532 | (37.7914940185848, -122.397829357532) | |||
27151 | 27151 | 189948 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 162 Spear St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 6014781.223780001 | 2116142.62721 | 37.79135487007321 | -122.392742658052 | (37.7913548700732, -122.392742658052) | |||
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) | |||
36711 | 36711 | 189929 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 43 Fremont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013297.80377 | 2116238.25932 | 37.79153495213429 | -122.39788200474399 | (37.7915349521343, -122.397882004744) | |||
37989 | 37989 | 199692 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1343 Thomas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6016085.8906 | 2092920.1706 | 37.7276633287451 | -122.386608480998 | (37.7276633287451, -122.386608480998) | |||
41181 | 41181 | 189938 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013289.37156 | 2116149.2267400003 | 37.7912900199673 | -122.39790493209101 | (37.7912900199673, -122.397904932091) | |||
43510 | 43510 | 225058 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 283 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5996870.764690001 | 2106986.93981 | 37.76520471814 | -122.454050575073 | (37.76520471814, -122.454050575073) | |||
45525 | 45525 | 206011 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 650 Vicente St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990881.65673 | 2097736.82059 | 37.739461084972206 | -122.47409027886299 | (37.7394610849722, -122.474090278863) | |||
45915 | 45915 | 205996 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 30 Molimo Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998822.4881 | 2096514.65172 | 37.736562095172296 | -122.446546561796 | (37.7365620951723, -122.446546561796) | |||
52899 | 52899 | 189933 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013208.14765 | 2116234.45684 | 37.791519517964396 | -122.398191948892 | (37.7915195179644, -122.398191948892) | |||
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) | |||
60186 | 60186 | 248270 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 157 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006694.18006 | 2098651.40644 | 37.7428756308979 | -122.419482249905 | (37.7428756308979, -122.419482249905) | |||
69557 | 69557 | 205989 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 566 Dewey Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 6ft | 5994108.82044 | 2099457.01961 | 37.744370734026 | -122.46305702188499 | (37.744370734026, -122.463057021885) | |||
71841 | 71841 | 225048 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2823 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6009293.07164 | 2103911.54746 | 37.757464848636204 | -122.410867399417 | (37.7574648486362, -122.410867399417) | |||
74016 | 74016 | 189915 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Flora St | 13 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013899.07383 | 2094479.41823 | 37.7318233991302 | -122.394277515688 | (37.7318233991302, -122.394277515688) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
149692 | 149692 | 222908 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 363 Page St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6004803.104169999 | 2109829.19919 | 37.773460518813 | -122.426816934368 | (37.773460518813, -122.426816934368) | |||
150091 | 150091 | 206006 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 600 Vicente St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5991049.3393 | 2097743.54574 | 37.7394892625221 | -122.473511002145 | (37.7394892625221, -122.473511002145) | |||
155584 | 155584 | 138737 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 2945 BUSH ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5999415.669 | 2114277.6236 | 37.7853686673978 | -122.44577276106199 | (37.7853686673978, -122.445772761062) | |||
156358 | 156358 | 188485 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6016660.6215 | 2098754.7402 | 37.7437156885266 | -122.385027944407 | (37.7437156885266, -122.385027944407) | |||
161704 | 161704 | 225066 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 199 Franconia St | 13 | : Yard 23 | Tree 1 | Private 1 | 5 | Width 3ft | 6010116.17854 | 2099660.00965 | 37.745837186534295 | -122.407720980957 | (37.7458371865343, -122.407720980957) | |||
164290 | 164290 | 206009 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 650 Vicente St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5990946.443519999 | 2097737.21302 | 37.7394659152092 | -122.47386630538 | (37.7394659152092, -122.47386630538) | |||
166137 | 166137 | 189911 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Flora St | 7 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013879.72064 | 2094387.8060700002 | 37.73157077506371 | -122.394338012196 | (37.7315707750637, -122.394338012196) | |||
167856 | 167856 | 189934 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 5ft | 6013232.87553 | 2116207.31651 | 37.791446374309395 | -122.398104485334 | (37.7914463743094, -122.398104485334) | |||
173975 | 173975 | 189914 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Flora St | 11 | : 4 | Tree 1 | Private 1 | 5 | Width 3ft | 6013894.185819999 | 2094452.33408 | 37.7317487598799 | -122.394292519091 | (37.7317487598799, -122.394292519091) | |||
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) | |||
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) | |||
185704 | 185704 | 188476 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 499 San Bruno Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 3ft | 6010896.57818 | 2106030.2080599996 | 37.763371997828706 | -122.405471012994 | (37.7633719978287, -122.405471012994) | |||
188391 | 188391 | 225051 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 4331 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000881.81518 | 2102275.99981 | 37.752498802180796 | -122.439839555559 | (37.7524988021808, -122.439839555559) | |||
188742 | 188742 | 246420 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 400 Duncan St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 6003851.19686 | 2099854.61267 | 37.7460188154337 | -122.42939827552401 | (37.7460188154337, -122.429398275524) | |||
23796 | 23796 | 189939 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013302.110780001 | 2116136.01551 | 37.7912544544909 | -122.397859927289 | (37.7912544544909, -122.397859927289) | |||
24544 | 24544 | 189940 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 28 Fremont St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 5ft | 6013316.29733 | 2116121.5529099996 | 37.791215533629 | -122.39780982696001 | (37.791215533629, -122.39780982696) | |||
25477 | 25477 | 225086 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 3689 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6003831.7176 | 2103603.4271 | 37.756311078698296 | -122.429732966312 | (37.7563110786983, -122.429732966312) |
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");