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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | |||
72242 | 72242 | 189913 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Flora St | 9 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6013888.27035 | 2094422.90108 | 37.731667614051 | -122.39431091023 | (37.731667614051, -122.39431091023) | |||
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) | |||
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) | |||
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) | |||
164903 | 164903 | 201371 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Hare St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 6018297.03999 | 2095334.9344400002 | 37.7344159629251 | -122.379132069983 | (37.7344159629251, -122.379132069983) | ||||
23951 | 23951 | 222885 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Valencia St | 3 | : 4 | Tree 1 | Private 1 | 18 | Width 5ft | 6006051.02822 | 2109339.24494 | 37.7721857010308 | -122.422465357814 | (37.7721857010308, -122.422465357814) | |||
30049 | 30049 | 222884 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1 Valencia St | 1 | : 4 | Tree 1 | Private 1 | 18 | Width 5ft | 6006058.1722800005 | 2109199.11331 | 37.7718013362 | -122.422430687153 | (37.7718013362, -122.422430687153) | |||
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) | ||||
126890 | 126890 | 206004 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 10 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991469.80126 | 2104851.05791 | 37.7590289864229 | -122.472575296214 | (37.7590289864229, -122.472575296214) | |||
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) | |||
33099 | 33099 | 189852 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017365.88907 | 2098130.81013 | 37.7420414890213 | -122.38254586948999 | (37.7420414890213, -122.38254586949) | |||
25692 | 25692 | 222915 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 100 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6004287.81752 | 2109130.32918 | 37.7715124442731 | -122.42854956011999 | (37.7715124442731, -122.42854956012) | |||
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) | ||
181328 | 181328 | 189963 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1000 Brannan St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6010349.36768 | 2108372.96344 | 37.7697740574441 | -122.40752882731 | (37.7697740574441, -122.40752882731) | |||
63520 | 63520 | 200192 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1008 Jamestown Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6013935.7075 | 2089708.6863 | 37.718725965018 | -122.393817050636 | (37.718725965018, -122.393817050636) | |||
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) | |||
32657 | 32657 | 189845 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6017192.34248 | 2098175.05438 | 37.7421533862633 | -122.383149023221 | (37.7421533862633, -122.383149023221) | |||
33190 | 33190 | 189849 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 12 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6017283.17469 | 2098125.85242 | 37.742023306530704 | -122.38283152746 | (37.7420233065307, -122.38283152746) | |||
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) | |||
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) | |||
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) | |||
131495 | 131495 | 189850 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 14 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6017345.725190001 | 2098082.05897 | 37.7419065142755 | -122.382612199015 | (37.7419065142755, -122.382612199015) | |||
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) | |||
137584 | 137584 | 189851 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 15 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6017359.84801 | 2098072.09609 | 37.741879938402704 | -122.38256267332198 | (37.7418799384027, -122.382562673322) | |||
147716 | 147716 | 189842 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6017136.0861599995 | 2098201.14709 | 37.7422219227174 | -122.383345357813 | (37.7422219227174, -122.383345357813) | |||
157361 | 157361 | 189848 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 101 Newhall St | 11 | : 4 | Tree 1 | Private 1 | 8 | Width 4ft | 6017264.73109 | 2098137.17538 | 37.7420533780644 | -122.38289608801 | (37.7420533780644, -122.38289608801) | |||
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) | |||
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) | |||
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) | |||
24219 | 24219 | 189857 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 11 | Width 4ft | 6017207.28329 | 2098227.98563 | 37.7422995503725 | -122.383101045278 | (37.7422995503725, -122.383101045278) | |||
49848 | 49848 | 189861 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 11 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017125.66493 | 2098258.40905 | 37.742378576526 | -122.38338537673799 | (37.742378576526, -122.383385376738) | |||
63863 | 63863 | 189858 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 8 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6017192.206809999 | 2098235.0383900004 | 37.7423180827181 | -122.38315366643499 | (37.7423180827181, -122.383153666435) | |||
67535 | 67535 | 189863 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 13 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6017087.002669999 | 2098268.01639 | 37.742402819541795 | -122.383519729148 | (37.7424028195418, -122.383519729148) | |||
135439 | 135439 | 189860 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 10 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6017146.31011 | 2098252.64566 | 37.74236389238379 | -122.38331359014299 | (37.7423638923838, -122.383313590143) | |||
156617 | 156617 | 189856 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6017223.11391 | 2098220.2806700002 | 37.742279268865104 | -122.383045771154 | (37.7422792688651, -122.383045771154) | |||
156633 | 156633 | 189862 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 12 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6017103.28687 | 2098264.2675900003 | 37.7423934261135 | -122.383463161819 | (37.7423934261135, -122.383463161819) | |||
158918 | 158918 | 189855 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6017245.40272 | 2098209.38961 | 37.7422505957884 | -122.382967944715 | (37.7422505957884, -122.382967944715) | |||
162643 | 162643 | 189859 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 9 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6017171.36242 | 2098242.65136 | 37.7423378345214 | -122.38322627048001 | (37.7423378345214, -122.38322627048) | |||
173588 | 173588 | 189854 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6017283.71117 | 2098187.47887 | 37.742192549946104 | -122.38283396012599 | (37.7421925499461, -122.382833960126) | |||
179431 | 179431 | 189853 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 102 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6017352.03209 | 2098141.27696 | 37.742069463331106 | -122.382594511142 | (37.7420694633311, -122.382594511142) | |||
23379 | 23379 | 222925 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1025 Clayton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998825.08997 | 2106348.09575 | 37.763562478748604 | -122.44724507779499 | (37.7635624787486, -122.447245077795) | |||
174584 | 174584 | 222924 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1025 Clayton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5998822.080680001 | 2106365.6721900003 | 37.763610567293 | -122.447256751019 | (37.763610567293, -122.447256751019) | |||
137538 | 137538 | 222914 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 108 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6004276.58953 | 2109191.75922 | 37.7716804808011 | -122.428592777936 | (37.7716804808011, -122.428592777936) | |||
32636 | 32636 | 222888 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 109 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6004218.0 | 2109157.0 | 37.771581724556604 | -122.428792964354 | (37.7715817245566, -122.428792964354) | |||
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) | |||
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) | |||
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) | |||
33356 | 33356 | 248279 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 111 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006822.34586 | 2098891.67697 | 37.743542578041 | -122.419056125953 | (37.743542578041, -122.419056125953) | |||
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) | ||||
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) | |||
45296 | 45296 | 248254 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006798.65634 | 2098892.16282 | 37.7435425780247 | -122.419138073069 | (37.7435425780247, -122.419138073069) | |||
176531 | 176531 | 248253 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006804.331590001 | 2098902.21261 | 37.7435704920937 | -122.419119162122 | (37.7435704920937, -122.419119162122) | |||
64492 | 64492 | 222913 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 112 Webster St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6004271.62218 | 2109232.3150299997 | 37.771791556066 | -122.428612851729 | (37.771791556066, -122.428612851729) | |||
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) | |||
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) | |||
26990 | 26990 | 222896 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 115 Julian Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | Width 4ft | 6006441.81181 | 2107164.43854 | 37.76623623692421 | -122.420959163358 | (37.7662362369242, -122.420959163358) | |||
156357 | 156357 | 248255 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 116 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006791.47872 | 2098879.96545 | 37.7435086825726 | -122.41916202653 | (37.7435086825726, -122.41916202653) | |||
55327 | 55327 | 189949 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6014767.16396 | 2116087.91405 | 37.791203859513004 | -122.392787475772 | (37.791203859513, -122.392787475772) | |||
75800 | 75800 | 189950 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6014741.1957 | 2116062.8749700002 | 37.79113366564629 | -122.392875573361 | (37.7911336656463, -122.392875573361) | |||
96732 | 96732 | 189953 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6014700.62775 | 2116023.46282 | 37.7910231956157 | -122.39301317951201 | (37.7910231956157, -122.393013179512) | |||
161429 | 161429 | 189951 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 6014728.34644 | 2116051.81938 | 37.791102595846894 | -122.39291925791099 | (37.7911025958469, -122.392919257911) | |||
179956 | 179956 | 189952 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Howard St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 1ft | 6014715.63981 | 2116037.4080000003 | 37.7910623197318 | -122.392962214036 | (37.7910623197318, -122.392962214036) | |||
66722 | 66722 | 248258 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6006769.1868199995 | 2098841.93634 | 37.7434030077589 | -122.41923640944201 | (37.7434030077589, -122.419236409442) | |||
179238 | 179238 | 248257 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006778.60351 | 2098856.6294 | 37.7434438819296 | -122.41920489088899 | (37.7434438819296, -122.419204890889) | |||
132092 | 132092 | 206014 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 120 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5992843.12782 | 2095854.05613 | 37.7344049138512 | -122.467171573123 | (37.7344049138512, -122.467171573123) | |||
53992 | 53992 | 222919 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 121 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997880.24105 | 2107132.61559 | 37.765662537824895 | -122.45056955843701 | (37.7656625378249, -122.450569558437) | |||
174407 | 174407 | 222887 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 123 Webster St | 1 | : 4 | Tree 1 | Private 1 | 13 | Width 5ft | 6004226.51196 | 2109212.81898 | 37.77173547164 | -122.42876750091801 | (37.77173547164, -122.428767500918) | |||
129912 | 129912 | 225061 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1289 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 6ft | 5997502.5049 | 2105021.0962900002 | 37.7598432128005 | -122.451723726786 | (37.7598432128005, -122.451723726786) | |||
54347 | 54347 | 206013 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 130 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5992845.13508 | 2095810.8192900002 | 37.7342863121439 | -122.467161490835 | (37.7342863121439, -122.467161490835) | |||
165360 | 165360 | 248260 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 132 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006738.11061 | 2098784.48151 | 37.7432434994904 | -122.419339788302 | (37.7432434994904, -122.419339788302) | |||
39562 | 39562 | 199697 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1331 Thomas Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6016182.8401 | 2092843.0517 | 37.7274569422187 | -122.386267947878 | (37.7274569422187, -122.386267947878) | |||
174686 | 174686 | 199696 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1337 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6016147.0349 | 2092868.9416 | 37.7275260488519 | -122.386393532075 | (37.7275260488519, -122.386393532075) | |||
68963 | 68963 | 199693 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1341 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 6016099.1110000005 | 2092907.501 | 37.7276292724139 | -122.386561894416 | (37.7276292724139, -122.386561894416) | |||
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) | |||
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) | |||
45389 | 45389 | 248262 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 136 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6006723.28629 | 2098755.01317 | 37.743161751109 | -122.41938895693 | (37.743161751109, -122.41938895693) | |||
104259 | 104259 | 248261 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 136 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006731.57977 | 2098768.277 | 37.7431986377163 | -122.419361220966 | (37.7431986377163, -122.419361220966) | |||
46452 | 46452 | 248275 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 137 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006752.53211 | 2098758.7700799997 | 37.743173713897 | -122.41928809889299 | (37.743173713897, -122.419288098893) | |||
135232 | 135232 | 248274 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 137 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6006747.61558 | 2098750.1570099997 | 37.743149787441 | -122.419304488116 | (37.743149787441, -122.419304488116) | |||
183547 | 183547 | 248276 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 137 Lundy's Ln | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006755.61156 | 2098766.6947 | 37.7431956465585 | -122.41927801298401 | (37.7431956465585, -122.419278012984) | |||
163059 | 163059 | 225062 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 139 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5998883.5307 | 2107364.0663900003 | 37.76635541778779 | -122.44711607094601 | (37.7663554177878, -122.447116070946) | |||
182071 | 182071 | 222886 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 139 Webster St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6004216.91806 | 2109283.17336 | 37.7719281046318 | -122.428805703247 | (37.7719281046318, -122.428805703247) | |||
135516 | 135516 | 247504 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1398 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 0ft | 5999483.6766 | 2108789.6708 | 37.7703040400286 | -122.44514278745399 | (37.7703040400286, -122.445142787454) | |||
31832 | 31832 | 222918 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 Carl St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5997702.832359999 | 2107152.93734 | 37.7657081802151 | -122.451184638974 | (37.7657081802151, -122.451184638974) | |||
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) | |||
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) | ||||
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) | |||
50402 | 50402 | 248264 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006711.60121 | 2098736.3727599997 | 37.743109910586 | -122.419428038785 | (37.743109910586, -122.419428038785) | |||
68659 | 68659 | 248263 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 140 Lundy's Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006717.3063 | 2098747.87418 | 37.743141812234505 | -122.41940912783899 | (37.7431418122345, -122.419409127839) | |||
59090 | 59090 | 189955 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 145 Main St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6014561.092019999 | 2115949.59191 | 37.790812611275 | -122.39349079958299 | (37.790812611275, -122.393490799583) | |||
169467 | 169467 | 189954 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 145 Main St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 4ft | 6014570.20304 | 2115942.2831 | 37.7907930492013 | -122.393458763924 | (37.7907930492013, -122.393458763924) | |||
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) |
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");