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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
184982 | 184982 | 245985 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4230 18th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6001857.8935 | 2105297.335 | 37.7608501726 | -122.43668036860599 | (37.7608501726, -122.436680368606) | |||
184958 | 184958 | 199906 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1280 Revere Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6016815.2148 | 2093150.1501 | 37.728335156345 | -122.38410318146299 | (37.728335156345, -122.384103181463) | |||
184945 | 184945 | 54560 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 55 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 10 | Permit Number 10355 | 6012764.3323099995 | 2095423.5072299999 | 37.7343525310416 | -122.398266792293 | (37.7343525310416, -122.398266792293) | ||
184737 | 184737 | 125818 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2081 Green St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6003105.57534 | 2118201.4506200003 | 37.7963524818244 | -122.433287285795 | (37.7963524818244, -122.433287285795) | |||
184689 | 184689 | 222400 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 116 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6000348.37213 | 2104909.38661 | 37.759699060486 | -122.441873275228 | (37.759699060486, -122.441873275228) | |||
184610 | 184610 | 120805 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 679 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5989713.22952 | 2110739.88364 | 37.77509626822221 | -122.4790810382 | (37.7750962682222, -122.4790810382) | |||
184591 | 184591 | 220905 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 306 Moultrie St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007720.613530001 | 2097651.96548 | 37.7401891482 | -122.41586236266701 | (37.7401891482, -122.415862362667) | |||
184554 | 184554 | 31816 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 378 Valley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/1995 12:00:00 AM | 7 | Permit Number 35283 | 6003433.86405 | 2099244.43188 | 37.744319764054396 | -122.430797819357 | (37.7443197640544, -122.430797819357) | |
184522 | 184522 | 188914 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2001 25th St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 8ft | 6012427.94611 | 2101835.1466 | 37.751938786244104 | -122.399879877452 | (37.7519387862441, -122.399879877452) | |||
184511 | 184511 | 222442 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 257 States St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6000591.13544 | 2106623.67693 | 37.764419909467 | -122.441156674739 | (37.764419909467, -122.441156674739) | |||
184423 | 184423 | 141301 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 73 MASONIC AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998821.123 | 2112840.3465 | 37.78138831505971 | -122.447726197862 | (37.7813883150597, -122.447726197862) | |||
184393 | 184393 | 222175 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4220 Cesar Chavez St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | Width 6ft | 6002470.36275 | 2100366.71232 | 37.7473466464472 | -122.434209614287 | (37.7473466464472, -122.434209614287) | |||
184257 | 184257 | 175743 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 262 Chicago Way | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 6ft | 6002717.2522 | 2086712.6010099999 | 37.7098695521959 | -122.43238083839701 | (37.7098695521959, -122.432380838397) | |||
184204 | 184204 | 222452 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 202 Waller St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004685.9269199995 | 2109166.0286 | 37.7716329876088 | -122.42717502101999 | (37.7716329876088, -122.42717502102) | |||
184139 | 184139 | 188882 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 869 Vermont St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 11 | Width 8ft | 6011336.637130001 | 2104304.99863 | 37.7586595539197 | -122.403827579285 | (37.7586595539197, -122.403827579285) | |||
184082 | 184082 | 205867 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 520 Orizaba Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5994049.56571 | 2090091.22883 | 37.71865115951571 | -122.462582668169 | (37.7186511595157, -122.462582668169) | |||
184062 | 184062 | 204381 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 47 Ralston St | 4 | Back Yard : Yard 13 | Tree 1 | Private 1 | 5 | 5992175.93878 | 2088248.61457 | 37.7134837071825 | -122.46892495972901 | (37.7134837071825, -122.468924959729) | ||||
184039 | 184039 | 199924 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1262 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6016730.9349 | 2092862.3314 | 37.727540202809 | -122.384374505972 | (37.727540202809, -122.384374505972) | |||
184037 | 184037 | 247875 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 388 Mayflower St | 4 | Side Yard : Yard 17 | Tree 1 | Private 1 | 7 | 6009902.15427 | 2098392.46906 | 37.742344813273604 | -122.408371660244 | (37.7423448132736, -122.408371660244) | ||||
183976 | 183976 | 142246 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 525 Laguna St | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 11 | Width 0ft | 6004972.6437 | 2110863.998 | 37.7763114086194 | -122.426304161599 | (37.7763114086194, -122.426304161599) | |||
183975 | 183975 | 220899 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 228 Downey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 5998994.27809 | 2106827.83815 | 37.7648893969392 | -122.446694431926 | (37.7648893969392, -122.446694431926) | |||
183958 | 183958 | 205682 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 134 Lomita Ave | 2 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 5991412.37682 | 2104411.58455 | 37.757818984582705 | -122.47274185157801 | (37.7578189845827, -122.472741851578) | ||||
183820 | 183820 | 222207 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 210 Roanoke St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003536.54045 | 2096012.62745 | 37.7354517876606 | -122.43021226898199 | (37.7354517876606, -122.430212268982) | |||
183795 | 183795 | 122166 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 653 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5991272.37105 | 2110974.2091900003 | 37.775830083814505 | -122.473704774849 | (37.7758300838145, -122.473704774849) | |||
183756 | 183756 | 122035 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 595 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5990309.53859 | 2111350.82376 | 37.7768083534301 | -122.477062948664 | (37.7768083534301, -122.477062948664) | |||
183738 | 183738 | 183807 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2207 28th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 4 | Width 0ft | 5987587.5755 | 2100244.1318 | 37.7461541295061 | -122.48566359052799 | (37.7461541295061, -122.485663590528) | |||
183712 | 183712 | 248534 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 796 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5999118.3584 | 2107736.2925 | 37.7673908712059 | -122.446330628456 | (37.7673908712059, -122.446330628456) | |||
183689 | 183689 | 97907 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2000 Chestnut St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/18/1994 12:00:00 AM | 8 | Permit Number 33440 | 6002166.03814 | 2119855.12291 | 37.8008396887472 | -122.43665670643601 | (37.8008396887472, -122.436656706436) | ||
183640 | 183640 | 189003 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1747 La Salle Ave | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6014760.407319999 | 2096699.60508 | 37.7379674198647 | -122.391454838795 | (37.7379674198647, -122.391454838795) | |||
183606 | 183606 | 125853 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 743 North Point St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6007172.66204 | 2121545.51126 | 37.8057643133355 | -122.419451639674 | (37.8057643133355, -122.419451639674) | |||
183529 | 183529 | 204482 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 229 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5992624.04177 | 2101137.37073 | 37.748898907754004 | -122.468313251679 | (37.748898907754, -122.468313251679) | |||
183520 | 183520 | 199956 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1238 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6016851.5709 | 2092773.0939 | 37.7273018440116 | -122.38395125115 | (37.7273018440116, -122.38395125115) | |||
183503 | 183503 | 222430 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 114 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6001045.5618 | 2105677.4986099997 | 37.761847810645705 | -122.439517110848 | (37.7618478106457, -122.439517110848) | |||
183491 | 183491 | 248460 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 739 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 5997585.8919 | 2107964.6256 | 37.76793017297379 | -122.451647664261 | (37.7679301729738, -122.451647664261) | |||
183482 | 183482 | 220834 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 174 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6009148.721 | 2099094.5967 | 37.7442304811679 | -122.411026395969 | (37.7442304811679, -122.411026395969) | |||
183479 | 183479 | 222281 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 322 Elsie St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6006462.40441 | 2097196.52679 | 37.7388677995165 | -122.42018043498301 | (37.7388677995165, -122.420180434983) | |||
183445 | 183445 | 175690 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1419 Wayland St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6007508.06926 | 2091382.7441 | 37.7229632774235 | -122.41615336889099 | (37.7229632774235, -122.416153368891) | |||
183434 | 183434 | 125740 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3000 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6001004.8959099995 | 2118712.65785 | 37.7976367272048 | -122.440592745877 | (37.7976367272048, -122.440592745877) | |||
183403 | 183403 | 125751 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2870 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 5999201.16809 | 2118397.93355 | 37.7966697014868 | -122.446811449891 | (37.7966697014868, -122.446811449891) | |||
183377 | 183377 | 204452 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 80 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5993066.122830001 | 2098585.83343 | 37.741918558889 | -122.466599110557 | (37.741918558889, -122.466599110557) | |||
183363 | 183363 | 175616 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 200x Mansell St | 14 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6011130.05143 | 2090542.76805 | 37.72085986657329 | -122.40357378072201 | (37.7208598665733, -122.403573780722) | |||
183329 | 183329 | 181639 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2520 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5987943.535 | 2106478.8633 | 37.7632937546124 | -122.48489005904 | (37.7632937546124, -122.48489005904) | |||
183317 | 183317 | 199875 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1467 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6015608.3045 | 2093619.7489 | 37.729557780210705 | -122.388308322353 | (37.7295577802107, -122.388308322353) | |||
183160 | 183160 | 220832 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 163 Ripley St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009000.611380001 | 2099125.04201 | 37.7443057706011 | -122.41154067958 | (37.7443057706011, -122.41154067958) | |||
183156 | 183156 | 143332 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1746 UNION ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 6004607.3256 | 2118807.7665 | 37.798102349641105 | -122.428134143145 | (37.7981023496411, -122.428134143145) | |||
183045 | 183045 | 125735 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3124 Divisadero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6000470.223730001 | 2119054.48758 | 37.7985448401339 | -122.44246740516 | (37.7985448401339, -122.44246740516) | |||
183003 | 183003 | 222257 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 34 Putnam St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6009162.5302099995 | 2097236.17229 | 37.7391284284365 | -122.41084741919201 | (37.7391284284365, -122.410847419192) | |||
182762 | 182762 | 204600 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 158 Detroit St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 10ft | 5999447.0256900005 | 2093744.5020599999 | 37.7289915679835 | -122.44418827768 | (37.7289915679835, -122.44418827768) | |||
182672 | 182672 | 222351 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3969 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003378.8702300005 | 2101825.80069 | 37.7514044837351 | -122.43117219094401 | (37.7514044837351, -122.431172190944) | |||
182670 | 182670 | 205685 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2108 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990710.14745 | 2101043.8835400003 | 37.748531487936894 | -122.474924609597 | (37.7485314879369, -122.474924609597) | |||
182648 | 182648 | 222399 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 155 Caselli Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6000280.55809 | 2104861.09859 | 37.759562609036706 | -122.44210434345501 | (37.7595626090367, -122.442104343455) | |||
182623 | 182623 | 125754 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2800 Filbert St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5999481.92865 | 2118436.50892 | 37.7967916540714 | -122.44584273436001 | (37.7967916540714, -122.44584273436) | |||
182564 | 182564 | 222317 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1184 Alabama St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6009203.64315 | 2102300.5545099997 | 37.7530364097089 | -122.411062891358 | (37.7530364097089, -122.411062891358) | |||
182558 | 182558 | 204357 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 380 Byxbee St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 10ft | 5991985.99504 | 2091008.3371599999 | 37.721050257551106 | -122.469782262745 | (37.7210502575511, -122.469782262745) | |||
182486 | 182486 | 222204 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 13 Worth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6000891.100819999 | 2103189.05131 | 37.755006349465106 | -122.439872903318 | (37.7550063494651, -122.439872903318) | |||
182436 | 182436 | 204570 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 404 Baden St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 3 | 6000772.023709999 | 2095261.55097 | 37.733232536033 | -122.43971638892 | (37.733232536033, -122.43971638892) | ||||
182368 | 182368 | 54441 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 516 Mississippi St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/23/1972 12:00:00 AM | 12 | Permit Number 10218 | 6014063.35386 | 2104670.6212400002 | 37.759815427353395 | -122.394422880319 | (37.7598154273534, -122.394422880319) | ||
182254 | 182254 | 125848 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1156 Vallejo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 5ft | 6008008.9171400005 | 2118589.1066900003 | 37.7976938341652 | -122.416348113498 | (37.7976938341652, -122.416348113498) | |||
182217 | 182217 | 140787 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 71 PARKER AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5996813.6049 | 2114078.6319 | 37.7846733774063 | -122.454760686436 | (37.7846733774063, -122.454760686436) | |||
182133 | 182133 | 123033 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 650 Funston Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5991950.0053900005 | 2110989.20432 | 37.775910478827896 | -122.471361779918 | (37.7759104788279, -122.471361779918) | |||
182118 | 182118 | 199898 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1829 Jennings St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6015950.3818 | 2093292.5446 | 37.728678291075 | -122.38710290263599 | (37.728678291075, -122.387102902636) | |||
182085 | 182085 | 217632 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 350 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 5992051.9121 | 2096948.2315 | 37.737363539457604 | -122.469986681864 | (37.7373635394576, -122.469986681864) | |||
182083 | 182083 | 188972 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 55 Vesta St | 1 | : 4 | Tree 1 | Private 1 | 15 | Width 3ft | 6012266.0571800005 | 2094101.57422 | 37.7306950098702 | -122.399896704685 | (37.7306950098702, -122.399896704685) | |||
182004 | 182004 | 222428 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 78 Belcher St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6003784.6311099995 | 2107872.81839 | 37.7680311371585 | -122.430200380862 | (37.7680311371585, -122.430200380862) | |||
181918 | 181918 | 247054 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 501 Valley St | 1 | : 4 | Tree 1 | Private 1 | 3 | Width 2ft | 6002623.07266 | 2099147.1540099997 | 37.74400669115239 | -122.433594410547 | (37.7440066911524, -122.433594410547) | |||
181774 | 181774 | 248577 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 290 Frederick St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998686.2213 | 2107637.5702 | 37.767095114717 | -122.447818216713 | (37.767095114717, -122.447818216713) | |||
181693 | 181693 | 205861 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 78 Montana St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 1ft | 5996047.1738599995 | 2089324.0253299999 | 37.7166594390586 | -122.455622364282 | (37.7166594390586, -122.455622364282) | |||
181509 | 181509 | 204579 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 471 Mangels Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998305.06819 | 2095239.21123 | 37.7330304709743 | -122.448243681413 | (37.7330304709743, -122.448243681413) | |||
181495 | 181495 | 205794 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 618 Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 5997298.05605 | 2094421.90373 | 37.7307287182504 | -122.451666234016 | (37.7307287182504, -122.451666234016) | |||
181493 | 181493 | 220908 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 66 Anderson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007960.76184 | 2098335.3804 | 37.7420791526193 | -122.415080385967 | (37.7420791526193, -122.415080385967) | |||
181392 | 181392 | 222423 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3641 17th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6004623.46032 | 2105985.6474599997 | 37.762896893187104 | -122.427164522318 | (37.7628968931871, -122.427164522318) | |||
181327 | 181327 | 138049 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1800 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6003473.2833 | 2114968.046 | 37.78749523175 | -122.431783958643 | (37.78749523175, -122.431783958643) | |||
181302 | 181302 | 220855 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 595 29th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6002790.44891 | 2098869.83984 | 37.743254746410706 | -122.43299585327 | (37.7432547464107, -122.43299585327) | |||
181251 | 181251 | 199901 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1391 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 0ft | 6016046.7804 | 2093296.4005 | 37.728694216252705 | -122.38676991257 | (37.7286942162527, -122.38676991257) | |||
181237 | 181237 | 99543 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1326 Shafter Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | 3x3 | 6016380.5949 | 2093124.5356 | 37.7282407853998 | -122.385603911567 | (37.7282407853998, -122.385603911567) | |||
181230 | 181230 | 189038 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 26 Russ St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 2ft | 6010137.33918 | 2111739.5833900003 | 37.7790061423445 | -122.40849974527599 | (37.7790061423445, -122.408499745276) | |||
181228 | 181228 | 217834 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2 Cranleigh Dr | 25 | Front Yard : Yard 7 | Tree 1 | Private 1 | 15 | 5991396.17639 | 2095791.9232400001 | 37.734150681791796 | -122.472169581465 | (37.7341506817918, -122.472169581465) | ||||
181210 | 181210 | 222409 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 3808 21st St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6003001.40006 | 2103606.29167 | 37.7562718916517 | -122.432604694072 | (37.7562718916517, -122.432604694072) | |||
181162 | 181162 | 118063 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 436 36th Ave | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 9 | Width 4ft | 5984715.27231 | 2112914.45835 | 37.7807755068603 | -122.49653031581998 | (37.7807755068603, -122.49653031582) | |||
181105 | 181105 | 38556 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1791 La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/10/2005 12:00:00 AM | 10 | Permit Number 40521 | 6014562.13286 | 2096849.4448099998 | 37.738367842095606 | -122.39215085288001 | (37.7383678420956, -122.39215085288) | |
181041 | 181041 | 222184 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 524 27th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | 6003104.120180001 | 2100103.45101 | 37.746659742462505 | -122.431999331618 | (37.7466597424625, -122.431999331618) | ||||
180985 | 180985 | 204548 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 67 | Median : Cutout 11 | Tree 1 | DPW 2 | 13 | Width 5ft | 5999721.47669 | 2097346.22168 | 37.738896698316005 | -122.443498100161 | (37.738896698316, -122.443498100161) | |||
180939 | 180939 | 205850 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 438 Orizaba Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 6ft | 5994044.85216 | 2089294.81203 | 37.7164641180118 | -122.46254122291599 | (37.7164641180118, -122.462541222916) | |||
180905 | 180905 | 175649 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 0 Cardenas Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 6ft | 5990437.61377 | 2090276.93523 | 37.7189523892072 | -122.47508114108 | (37.7189523892072, -122.47508114108) | |||
180833 | 180833 | 175622 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 700x Mansell St | 18 | Median : Cutout 11 | Tree 1 | DPW 2 | 7 | Width 0ft | 6009430.205130001 | 2090028.38757 | 37.7193523869705 | -122.40941337645 | (37.7193523869705, -122.40941337645) | |||
180803 | 180803 | 125839 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 114 Leroy Pl | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6008323.23734 | 2116659.17104 | 37.7924123774867 | -122.415123796229 | (37.7924123774867, -122.415123796229) | |||
180648 | 180648 | 204549 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 300x Marietta Dr | 66 | Median : Cutout 11 | Tree 1 | DPW 2 | 12 | Width 5ft | 5999718.509930001 | 2097359.75923 | 37.7389337000243 | -122.44350932999 | (37.7389337000243, -122.44350932999) | |||
180644 | 180644 | 34699 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 783 45th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1997 12:00:00 AM | 5 | Permit Number 38358 | 5981962.67601 | 2110441.20269 | 37.7738230269301 | -122.505869302151 | (37.7738230269301, -122.505869302151) | |
180643 | 180643 | 184496 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1870 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 0ft | 5982593.1208 | 2102386.6662 | 37.751744655158205 | -122.503092090825 | (37.7517446551582, -122.503092090825) | |||
180633 | 180633 | 125815 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2081 Green St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 6003051.463930001 | 2118195.99672 | 37.7963344369473 | -122.43347413255199 | (37.7963344369473, -122.433474132552) | |||
180598 | 180598 | 220831 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 161 Ripley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6008984.11171 | 2099123.06181 | 37.7442994078902 | -122.41159759226801 | (37.7442994078902, -122.411597592268) | |||
180561 | 180561 | 188932 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 2445 Mariposa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6010201.29713 | 2105946.15228 | 37.763102299249 | -122.407869847524 | (37.763102299249, -122.407869847524) | |||
180527 | 180527 | 222429 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 69 Walter St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6003182.57445 | 2107914.4234700003 | 37.7681112559675 | -122.432285799867 | (37.7681112559675, -122.432285799867) | |||
180518 | 180518 | 222372 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 160 Hancock St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6003254.19618 | 2105081.07387 | 37.760335624020705 | -122.431835736851 | (37.7603356240207, -122.431835736851) | |||
180489 | 180489 | 182174 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1731 Lawton St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | Width 0ft | 5988860.3755 | 2104414.7881 | 37.757679720588705 | -122.481567865565 | (37.7576797205887, -122.481567865565) | |||
180463 | 180463 | 137597 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 870 Pierce St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6002497.2707 | 2111513.7759 | 37.777955304658 | -122.434913632029 | (37.777955304658, -122.434913632029) | |||
180351 | 180351 | 204502 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 429 Hazelwood Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 5995590.9532699995 | 2095806.7460900003 | 37.7344332461006 | -122.457668080921 | (37.7344332461006, -122.457668080921) | |||
180328 | 180328 | 220926 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 99 Esmeralda Ave | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 5 | 6007313.3532 | 2098768.19788 | 37.743231169794605 | -122.417349591335 | (37.7432311697946, -122.417349591335) | ||||
180315 | 180315 | 56391 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1344 Thomas Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/17/1973 12:00:00 AM | 10 | Permit Number 12544 | 6016127.2043 | 2092964.2385 | 37.7277866175614 | -122.386468729017 | (37.7277866175614, -122.386468729017) | ||
180295 | 180295 | 47842 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 4430 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/2002 12:00:00 AM | 2 | Permit Number 45603 | 5981809.260840001 | 2110330.3031 | 37.773509497941106 | -122.506391755128 | (37.7735094979411, -122.506391755128) |
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");