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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
15374 | 15374 | 16525 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016336.5971099995 | 2098251.27907 | 37.7423153586798 | -122.38611326331801 | (37.7423153586798, -122.386113263318) | |||
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) | |||
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) | |||
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) | |||
67563 | 67563 | 14916 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6017173.30591 | 2098243.5594200003 | 37.7423404352704 | -122.38321961360701 | (37.7423404352704, -122.383219613607) | |||
170703 | 170703 | 189886 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 201 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016892.13311 | 2098254.09694 | 37.7423538271607 | -122.384192566831 | (37.7423538271607, -122.384192566831) | |||
142575 | 142575 | 14917 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017157.89779 | 2098250.45331 | 37.7423585130106 | -122.383273370488 | (37.7423585130106, -122.383273370488) | |||
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) | |||
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) | |||
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) | |||
97917 | 97917 | 14920 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 110X Newhall St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6017135.89317 | 2098259.62578 | 37.7423824826909 | -122.383350094901 | (37.7423824826909, -122.383350094901) | |||
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) | |||
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) | |||
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) | |||
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) | |||
168105 | 168105 | 189908 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 8 | Width 3ft | 6016294.30511 | 2098287.7036099997 | 37.7424130322313 | -122.38626203636998 | (37.7424130322313, -122.38626203637) | |||
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) | |||
74900 | 74900 | 189884 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 12 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6016685.38219 | 2098298.11667 | 37.7424632629752 | -122.384910521712 | (37.7424632629752, -122.384910521712) | |||
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) | |||
16790 | 16790 | 16509 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/03/1992 12:00:00 AM | 3 | 3X3 | 6016661.92107 | 2098301.48789 | 37.742471221974 | -122.384991878867 | (37.742471221974, -122.384991878867) | ||
170676 | 170676 | 189907 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6016312.908530001 | 2098309.60993 | 37.7424742122044 | -122.38619923760099 | (37.7424742122044, -122.386199237601) | |||
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) | |||
132365 | 132365 | 189887 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 1 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6016910.34518 | 2098303.24769 | 37.742489792067104 | -122.384133016442 | (37.7424897920671, -122.384133016442) | |||
135669 | 135669 | 189883 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 9 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6016619.88237 | 2098309.8227 | 37.7424917822737 | -122.38513781816201 | (37.7424917822737, -122.385137818162) | |||
38692 | 38692 | 189888 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 6016891.26784 | 2098307.49665 | 37.7425004040788 | -122.384199276697 | (37.7425004040788, -122.384199276697) | |||
9160 | 9160 | 16481 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
9221 | 9221 | 16483 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
9262 | 9262 | 16480 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
9277 | 9277 | 16482 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
9322 | 9322 | 16485 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
9402 | 9402 | 16488 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 0 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
9478 | 9478 | 16486 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
79948 | 79948 | 16484 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
89437 | 89437 | 16489 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
125499 | 125499 | 16479 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016885.6016222 | 2098308.357669 | 37.7425024549748 | -122.38421892893899 | (37.7425024549748, -122.384218928939) | |||
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) | |||
62858 | 62858 | 189876 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 8 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6016406.62692 | 2098319.91707 | 37.7425077002596 | -122.385875902556 | (37.7425077002596, -122.385875902556) | |||
130083 | 130083 | 189882 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6016580.99088 | 2098317.85278 | 37.742511679775205 | -122.385272854085 | (37.7425116797752, -122.385272854085) | |||
65891 | 65891 | 189889 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016866.9099 | 2098314.50918 | 37.7425183122785 | -122.38428398832501 | (37.7425183122785, -122.384283988325) | |||
135246 | 135246 | 189881 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6016559.498980001 | 2098322.6337200003 | 37.7425236182725 | -122.385347500499 | (37.7425236182725, -122.385347500499) | |||
185981 | 185981 | 189906 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6016329.85018 | 2098328.36686 | 37.742526652587706 | -122.386141965188 | (37.7425266525877, -122.386141965188) | |||
28090 | 28090 | 189890 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | 6016847.575680001 | 2098318.03852 | 37.742526934071 | -122.384351086743 | (37.742526934071, -122.384351086743) | |||
16852 | 16852 | 16499 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016428.13466 | 2098327.93774 | 37.7425309135822 | -122.385802093385 | (37.7425309135822, -122.385802093385) | |||
74473 | 74473 | 189880 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016536.79452 | 2098327.4391099997 | 37.742535556771 | -122.385426341355 | (37.742535556771, -122.385426341355) | |||
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) | |||
187471 | 187471 | 189892 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 13 | Width 4ft | 6016806.72009 | 2098324.8999099997 | 37.74254351487679 | -122.384492832481 | (37.7425435148768, -122.384492832481) | |||
167349 | 167349 | 189877 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016448.8562900005 | 2098333.07564 | 37.7425461678608 | -122.38573080145099 | (37.7425461678608, -122.385730801451) | |||
166172 | 166172 | 189893 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 7 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6016784.24817 | 2098329.2173099997 | 37.7425541268854 | -122.384570835175 | (37.7425541268854, -122.384570835175) | |||
51434 | 51434 | 16506 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016450.0254075 | 2098336.1941648996 | 37.742554795386894 | -122.385726976255 | (37.7425547953869, -122.385726976255) | |||
90964 | 90964 | 16503 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016450.0254075 | 2098336.1941648996 | 37.742554795386894 | -122.385726976255 | (37.7425547953869, -122.385726976255) | |||
100227 | 100227 | 16500 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016450.0254075 | 2098336.1941648996 | 37.742554795386894 | -122.385726976255 | (37.7425547953869, -122.385726976255) | |||
102582 | 102582 | 16504 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016450.0254075 | 2098336.1941648996 | 37.742554795386894 | -122.385726976255 | (37.7425547953869, -122.385726976255) | |||
108888 | 108888 | 16502 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016450.0254075 | 2098336.1941648996 | 37.742554795386894 | -122.385726976255 | (37.7425547953869, -122.385726976255) | |||
110644 | 110644 | 16505 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016450.0254075 | 2098336.1941648996 | 37.742554795386894 | -122.385726976255 | (37.7425547953869, -122.385726976255) | |||
138575 | 138575 | 16501 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016450.0254075 | 2098336.1941648996 | 37.742554795386894 | -122.385726976255 | (37.7425547953869, -122.385726976255) | |||
157879 | 157879 | 189879 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6016498.145380001 | 2098335.4641 | 37.7425554533749 | -122.385560539098 | (37.7425554533749, -122.385560539098) | |||
181190 | 181190 | 189878 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 325 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6016474.87335 | 2098336.17477 | 37.742556117060104 | -122.38564105721399 | (37.7425561170601, -122.385641057214) | |||
77182 | 77182 | 189905 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 6 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6016340.3864 | 2098339.29531 | 37.7425572430226 | -122.386106295385 | (37.7425572430226, -122.386106295385) | |||
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) | |||
54002 | 54002 | 189894 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 200 Newhall St | 8 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6016764.20599 | 2098333.7275 | 37.742565402576794 | -122.384640449909 | (37.7425654025768, -122.384640449909) | |||
66110 | 66110 | 189895 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 2 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6016704.91422 | 2098345.41637 | 37.7425942186412 | -122.384846279543 | (37.7425942186412, -122.384846279543) | |||
44243 | 44243 | 189896 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 14 | Width 4ft | 6016683.25153 | 2098348.88465 | 37.7426025436648 | -122.38492142508899 | (37.7426025436648, -122.384921425089) | |||
165324 | 165324 | 189897 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6016662.64586 | 2098353.63161 | 37.742614438102706 | -122.384993004817 | (37.7426144381027, -122.384993004817) | |||
74466 | 74466 | 189898 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 220 Newhall St | 5 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6016641.64949 | 2098357.6793299997 | 37.7426243909147 | -122.385065886799 | (37.7426243909147, -122.385065886799) | |||
33365 | 33365 | 93109 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 9 | 3x3 | Permit Number 53024 | 6016621.354169999 | 2098362.60938 | 37.7426368051604 | -122.385136406214 | (37.7426368051604, -122.385136406214) | |
184090 | 184090 | 93110 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53024 | 6016603.548880001 | 2098366.45199 | 37.7426463712226 | -122.385198240014 | (37.7426463712226, -122.385198240014) | |
123421 | 123421 | 93111 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 7 | 3x3 | Permit Number 53024 | 6016584.37921 | 2098370.12887 | 37.742655406712295 | -122.38526477996099 | (37.7426554067123, -122.385264779961) | |
168386 | 168386 | 189904 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 11 | Width 3ft | 6016400.23461 | 2098374.6941 | 37.742657753052505 | -122.38590182282499 | (37.7426577530525, -122.385901822825) | |||
96782 | 96782 | 16520 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | |||
98251 | 98251 | 16517 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | |||
108484 | 108484 | 16515 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | |||
111965 | 111965 | 16519 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | |||
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) | |||
143682 | 143682 | 16516 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 330 Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016409.970087901 | 2098376.06541 | 37.742662057146795 | -122.385868255606 | (37.7426620571468, -122.385868255606) | |||
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) | |||
154271 | 154271 | 93112 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 3 | 3x3 | Permit Number 53024 | 6016561.73954 | 2098375.23066 | 37.7426681627043 | -122.38534341756599 | (37.7426681627043, -122.385343417566) | |
155880 | 155880 | 189903 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 3 | : 4 | Tree 1 | Private 1 | 11 | Width 3ft | 6016414.85135 | 2098379.02943 | 37.742670465863796 | -122.38585158400801 | (37.7426704658638, -122.385851584008) | |||
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) | |||
153716 | 153716 | 93113 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 9 | 3x3 | Permit Number 53024 | 6016543.92232 | 2098378.4931799998 | 37.7426761351889 | -122.385405252254 | (37.7426761351889, -122.385405252254) | |
55275 | 55275 | 189902 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | Width 3ft | 6016433.67399 | 2098382.99048 | 37.7426823836985 | -122.385786776164 | (37.7426823836985, -122.385786776164) | |||
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) | |||
35467 | 35467 | 93114 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/02/2010 12:00:00 AM | 6 | 3x3 | Permit Number 53024 | 6016526.70747 | 2098382.7110900003 | 37.7426867642747 | -122.385465070679 | (37.7426867642747, -122.385465070679) | |
165480 | 165480 | 189901 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 7 | Width 3ft | 6016452.46192 | 2098385.2163400003 | 37.742689535099395 | -122.385721967406 | (37.7426895350994, -122.385721967406) | |||
130592 | 130592 | 189900 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 8 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6016469.439569999 | 2098386.38148 | 37.7426936737758 | -122.38566334421199 | (37.7426936737758, -122.385663344212) | |||
173621 | 173621 | 189899 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 300 Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6016506.94741 | 2098386.01279 | 37.7426947367801 | -122.385533625971 | (37.7426947367801, -122.385533625971) | |||
78541 | 78541 | 14928 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
86724 | 86724 | 14925 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
91802 | 91802 | 14926 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
92209 | 92209 | 14930 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
97975 | 97975 | 14927 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
102486 | 102486 | 14932 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
118155 | 118155 | 14929 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
118268 | 118268 | 14924 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
140042 | 140042 | 14931 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 320X Newhall St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016461.7664057 | 2098387.7906820998 | 37.7426971185746 | -122.38568997425199 | (37.7426971185746, -122.385689974252) | |||
22336 | 22336 | 3627 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 100X Cargo Way | 63 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Port 9 | 04/06/2016 12:00:00 AM | 3 | 3X3 | 6017747.14415 | 2098409.63099 | 37.7428281287262 | -122.381246979566 | (37.7428281287262, -122.381246979566) | ||
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) | |||
167049 | 167049 | 248271 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 157 Lundy's Ln | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6006700.68835 | 2098666.52237 | 37.7429175024299 | -122.419460818167 | (37.7429175024299, -122.419460818167) | |||
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) | |||
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) |
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");