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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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) | ||
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) | |||
16423 | 16423 | 2503 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016672.43224 | 2098847.72364 | 37.743971655361705 | -122.384993582204 | (37.7439716553617, -122.384993582204) | |||
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) | |||
179366 | 179366 | 188486 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6016667.7961 | 2098739.5766 | 37.7436744492327 | -122.385002079878 | (37.7436744492327, -122.385002079878) | |||
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) | |||
15763 | 15763 | 2504 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1500 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016654.18712 | 2098861.64491 | 37.7440088711085 | -122.385057640012 | (37.7440088711085, -122.385057640012) | |||
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) | |||
54211 | 54211 | 188484 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6016633.990259999 | 2098788.07165 | 37.743805736753394 | -122.38512235163 | (37.7438057367534, -122.38512235163) | |||
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) | |
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) | |||
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) | |||
16138 | 16138 | 14974 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400X Mendell St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3X3 | 6016589.22096 | 2097595.13367 | 37.7405276953073 | -122.385194050084 | (37.7405276953073, -122.385194050084) | |||
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) | |
14309 | 14309 | 14975 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 400X Mendell St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Fire Dept 11 | 12 | 3x3 | 6016578.93942 | 2097580.627 | 37.7404872941606 | -122.38522858943001 | (37.7404872941606, -122.38522858943) | |||
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) | |
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) | |||
3206 | 3206 | 189833 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 2 | : 4 | Tree 1 | DPW 2 | 02/12/2016 12:00:00 AM | 14 | Width 3ft | 6016585.78665 | 2098909.19771 | 37.7441356575455 | -122.385297468507 | (37.7441356575455, -122.385297468507) | ||
53695 | 53695 | 188483 | Undocumented 2 | Ceratonia siliqua :: Carob 97 | 1525 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6016580.588769999 | 2098830.3730200003 | 37.7439189335051 | -122.38530995020399 | (37.7439189335051, -122.385309950204) | |||
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) | |
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) | |||
15444 | 15444 | 2521 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016567.75907 | 2098840.9849799997 | 37.743947361995794 | -122.38535505210501 | (37.7439473619958, -122.385355052105) | |||
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) | |
13824 | 13824 | 2526 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3X3 | 6016552.46567 | 2098935.10176 | 37.744204941317 | -122.385414490998 | (37.744204941317, -122.385414490998) | |||
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) | |||
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) | |
14807 | 14807 | 2520 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016533.26 | 2098864.45764 | 37.744009904432 | -122.385475978555 | (37.744009904432, -122.385475978555) | |||
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) | |||
15581 | 15581 | 2519 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016516.51157 | 2098877.59586 | 37.7440450526322 | -122.38553480681101 | (37.7440450526322, -122.385534806811) | |||
3203 | 3203 | 2528 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2017 12:00:00 AM | 3 | 3X3 | 6016517.59351 | 2098961.55525 | 37.744275647795604 | -122.38553691568998 | (37.7442756477956, -122.38553691569) | ||
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) | |||
14232 | 14232 | 2518 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016498.61775 | 2098890.1921900003 | 37.7440786495081 | -122.38559755790399 | (37.7440786495081, -122.385597557904) | |||
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) | |||
13486 | 13486 | 2517 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016481.64243 | 2098901.45238 | 37.7441086284068 | -122.385657039951 | (37.7441086284068, -122.385657039951) | |||
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) | |||
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) | |||
14264 | 14264 | 2516 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016465.84234 | 2098914.75953 | 37.7441442928392 | -122.38571260096 | (37.7441442928392, -122.38571260096) | |||
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) | |||
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) | |||
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) | |||
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) | |||
94554 | 94554 | 2524 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1570 BURKE AVE | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 02/12/2016 12:00:00 AM | 12 | 3X3 | 6016449.0 | 2099041.0 | 37.7444899913278 | -122.38577963578699 | (37.7444899913278, -122.385779635787) | ||
15943 | 15943 | 2515 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016446.65639 | 2098928.8879 | 37.7441820247861 | -122.385779926925 | (37.7441820247861, -122.385779926925) | |||
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) | |||
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) | |||
9397 | 9397 | 2544 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1580 BURKE AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3X3 | 6016440.0 | 2099034.0 | 37.7444702727306 | -122.385810268433 | (37.7444702727306, -122.385810268433) | |||
15657 | 15657 | 2514 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 3 | 3X3 | 6016429.25086 | 2098939.95078 | 37.7442114380124 | -122.385840882964 | (37.7442114380124, -122.385840882964) | |||
3214 | 3214 | 2529 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/24/2017 12:00:00 AM | 3 | 3X3 | 6016429.35383 | 2099026.76072 | 37.744449806015204 | -122.385846576558 | (37.7444498060152, -122.385846576558) | ||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
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) | |||
15447 | 15447 | 2513 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016387.5124699995 | 2098972.29453 | 37.7442979375022 | -122.385987460765 | (37.7442979375022, -122.385987460765) | |||
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) | |||
14957 | 14957 | 2540 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016367.14673 | 2098986.82897 | 37.7443367189812 | -122.386058894813 | (37.7443367189812, -122.386058894813) | |||
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) | |||
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) | |||
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) | |||
92151 | 92151 | 2522 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1555 Burke Ave | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016344.0270005 | 2099019.0971083 | 37.744424041089395 | -122.386141087772 | (37.7444240410894, -122.386141087772) | |||
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) | |||
15597 | 15597 | 16524 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016323.686869999 | 2098236.56346 | 37.7422742380775 | -122.386156877755 | (37.7422742380775, -122.386156877755) | |||
15063 | 15063 | 16523 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016311.2033400005 | 2098218.94031 | 37.742225157565606 | -122.386198814044 | (37.7422251575656, -122.386198814044) | |||
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) | |||
15226 | 15226 | 16522 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016298.51131 | 2098203.0123900003 | 37.7421807202532 | -122.386241589372 | (37.7421807202532, -122.386241589372) | |||
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) | |||
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) | |||
16483 | 16483 | 16521 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 375 Newhall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016284.3157 | 2098184.69928 | 37.742129650455205 | -122.38628939735099 | (37.7421296504552, -122.386289397351) | |||
3247 | 3247 | 188481 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 10 | : 4 | Tree 1 | Private 1 | 08/24/2017 12:00:00 AM | 3 | Width 3ft | 6016299.33242 | 2099120.87091 | 37.744701017238796 | -122.38630272799999 | (37.7447010172388, -122.386302728) | ||
163101 | 163101 | 189909 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 9 | Width 3ft | 6016264.27306 | 2098246.63974 | 37.7422986168968 | -122.386363016745 | (37.7422986168968, -122.386363016745) | |||
9098 | 9098 | 2530 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016273.7509883 | 2099134.0637751 | 37.7447358261247 | -122.38639210410601 | (37.7447358261247, -122.386392104106) | |||
9480 | 9480 | 2531 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1570 Burke Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016273.7509883 | 2099134.0637751 | 37.7447358261247 | -122.38639210410601 | (37.7447358261247, -122.386392104106) | |||
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) | |||
26487 | 26487 | 189910 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 350 Newhall St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 14 | Width 3ft | 6016250.22154 | 2098227.10108 | 37.742244189916704 | -122.386410241063 | (37.7422441899167, -122.386410241063) | |||
16090 | 16090 | 2536 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016262.668930001 | 2099065.69559 | 37.744547487686 | -122.38642565812 | (37.744547487686, -122.38642565812) | |||
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) | |||
111285 | 111285 | 2541 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6016218.6051359 | 2099112.8628025004 | 37.7446745598911 | -122.38658131155898 | (37.7446745598911, -122.386581311559) | |||
15281 | 15281 | 2535 | DPW Maintained 3 | Ceratonia siliqua :: Carob 97 | 1575 Burke Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6016210.73833 | 2099105.1228400003 | 37.7446528720358 | -122.386607974081 | (37.7446528720358, -122.386607974081) | |||
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) | |||
9135 | 9135 | 2542 | Permitted Site 1 | Ceratonia siliqua :: Carob 97 | 1580 Burke Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016211.0400559995 | 2099180.9466222 | 37.7448610852571 | -122.386612216975 | (37.7448610852571, -122.386612216975) |
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");