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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
25152 | 25152 | 222160 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 11 Fountain St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 4ft | 6000360.36109 | 2101597.05955 | 37.7506049001065 | -122.44159410859899 | (37.7506049001065, -122.441594108599) | |||
24354 | 24354 | 54553 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 11 Maddux Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/18/1972 12:00:00 AM | 12 | Permit Number 10348 | 6012791.48057 | 2095648.57895 | 37.7349720434069 | -122.39818871674801 | (37.7349720434069, -122.398188716748) | ||
156788 | 156788 | 188281 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 11 Rosie Lee Ln | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6017931.86479 | 2094462.1595 | 37.7319993514708 | -122.380333977027 | (37.7319993514708, -122.380333977027) | |||
169436 | 169436 | 188282 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 11 Rosie Lee Ln | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 3ft | 6018083.14168 | 2094370.92156 | 37.731757175754 | -122.379804637898 | (37.731757175754, -122.379804637898) | |||
60623 | 60623 | 205733 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 110 San Aleso Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5993382.37885 | 2094831.43589 | 37.7316281652932 | -122.46523296663099 | (37.7316281652932, -122.465232966631) | |||
150667 | 150667 | 222350 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1100 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6003152.94655 | 2101762.46438 | 37.7512177718843 | -122.43194893899401 | (37.7512177718843, -122.431948938994) | |||
87678 | 87678 | 43362 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1100X Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/2000 12:00:00 AM | 4 | 3x9 | Permit Number 43112 | 6003157.69483217 | 2101814.87307727 | 37.751361942995 | -122.431936260805 | (37.751361942995, -122.431936260805) |
85404 | 85404 | 51863 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1105 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 48085 | 6002530.44355674 | 2102366.89187427 | 37.752842076313 | -122.43414482405899 | (37.752842076313, -122.434144824059) | ||||
53205 | 53205 | 188868 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1106 De Haro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012179.40591 | 2103244.12838 | 37.7557936834398 | -122.40083835062 | (37.7557936834398, -122.40083835062) | |||
126182 | 126182 | 188867 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1106 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6012179.649180001 | 2103256.10379 | 37.755826578859896 | -122.40083835062 | (37.7558265788599, -122.40083835062) | |||
32992 | 32992 | 175633 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1108 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6011834.593230001 | 2089743.09488 | 37.7187034559781 | -122.401082217992 | (37.7187034559781, -122.401082217992) | |||
32989 | 32989 | 204581 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 111 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 5999358.22229 | 2095479.7753700002 | 37.733751155281794 | -122.444619947753 | (37.7337511552818, -122.444619947753) | |||
52577 | 52577 | 205871 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 111 Monticello St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 6ft | 5991654.88774 | 2089307.44903 | 37.7163608911211 | -122.470802959995 | (37.7163608911211, -122.470802959995) | |||
162413 | 162413 | 222349 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1111 Castro St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002538.00771 | 2102275.75195 | 37.752592257052704 | -122.43411215116801 | (37.7525922570527, -122.434112151168) | |||
178791 | 178791 | 222348 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1111 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6002538.51722 | 2102256.44198 | 37.7525392653814 | -122.43410900892599 | (37.7525392653814, -122.434109008926) | |||
40821 | 40821 | 188849 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1112 Harrison St | 1 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6010631.69356 | 2110389.62029 | 37.7753271309641 | -122.40669440484899 | (37.7753271309641, -122.406694404849) | |||
129556 | 129556 | 188850 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1112 Harrison St | 2 | : 4 | Tree 1 | Private 1 | 12 | Width 3ft | 6010617.59281 | 2110376.13956 | 37.775289327063795 | -122.406742232588 | (37.7752893270638, -122.406742232588) | |||
173584 | 173584 | 222347 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1115 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6002540.8587 | 2102223.2228900003 | 37.752448186543106 | -122.434098537223 | (37.7524481865431, -122.434098537223) | |||
187670 | 187670 | 42671 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1115 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/25/2007 12:00:00 AM | 3 | 3x3 | Permit Number 49824 | 6007552.9274699995 | 2119520.43861 | 37.8002253861525 | -122.417992022918 | (37.8002253861525, -122.417992022918) | |
54738 | 54738 | 66859 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1116 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/1991 12:00:00 AM | 4 | Permit Number 30166 | 5989755.3106 | 2099063.2795 | 37.7430378863443 | -122.478081600833 | (37.7430378863443, -122.478081600833) | ||
45569 | 45569 | 205673 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 Ortega St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 5990453.79637 | 2102486.41595 | 37.75247744419271 | -122.47591639274799 | (37.7524774441927, -122.475916392748) | |||
60625 | 60625 | 205675 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 Ortega St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 5990487.22136 | 2102483.87825 | 37.7524724142928 | -122.47580061943 | (37.7524724142928, -122.47580061943) | |||
188431 | 188431 | 205674 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 Ortega St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5990467.03481 | 2102486.1364 | 37.7524774441906 | -122.475870592067 | (37.7524774441906, -122.475870592067) | |||
81357 | 81357 | 105463 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 WALLER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000021.8 | 2108530.5 | 37.769623122459706 | -122.443262808274 | (37.7696231224597, -122.443262808274) | |||
112867 | 112867 | 105462 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 WALLER ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000021.8 | 2108530.5 | 37.769623122459706 | -122.443262808274 | (37.7696231224597, -122.443262808274) | |||
120198 | 120198 | 105459 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 WALLER ST | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000021.8 | 2108530.5 | 37.769623122459706 | -122.443262808274 | (37.7696231224597, -122.443262808274) | |||
121110 | 121110 | 105460 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 WALLER ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000021.8 | 2108530.5 | 37.769623122459706 | -122.443262808274 | (37.7696231224597, -122.443262808274) | |||
128956 | 128956 | 105461 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 WALLER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6000021.8 | 2108530.5 | 37.769623122459706 | -122.443262808274 | (37.7696231224597, -122.443262808274) | |||
45196 | 45196 | 247252 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 Waller St | 2 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6000037.64512 | 2108520.1677599996 | 37.769595656244796 | -122.443207258529 | (37.7695956562448, -122.443207258529) | |||
60767 | 60767 | 247253 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 Waller St | 3 | : 4 | Tree 1 | Private 1 | 7 | Width 3ft | 6000028.37595 | 2108519.10482 | 37.769592209135794 | -122.443239243804 | (37.7695922091358, -122.443239243804) | |||
134269 | 134269 | 247251 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 Waller St | 1 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6000047.76346 | 2108521.63198 | 37.76960025357889 | -122.443172364836 | (37.7696002535789, -122.443172364836) | |||
156283 | 156283 | 247519 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 Waller St | 5 | : 4 | Tree 1 | Private 1 | 10 | Width 3ft | 6000008.96236 | 2108515.3221299998 | 37.76958071579789 | -122.44330612277399 | (37.7695807157979, -122.443306122774) | |||
160263 | 160263 | 247254 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1118 Waller St | 4 | : 4 | Tree 1 | Private 1 | 9 | Width 3ft | 6000018.05631 | 2108518.0633799997 | 37.7695887611508 | -122.443274864147 | (37.7695887611508, -122.443274864147) | |||
142385 | 142385 | 48734 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 112 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/25/2002 12:00:00 AM | Permit Number 46014 | 6001443.50423179 | 2107544.90678437 | 37.7669978945619 | -122.438274574244 | (37.7669978945619, -122.438274574244) | |||
67767 | 67767 | 222478 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 112 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 2ft | 6001753.94319 | 2096593.95124 | 37.7369468404176 | -122.436416959794 | (37.7369468404176, -122.436416959794) | |||
175548 | 175548 | 205816 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 112 Marston Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5998668.99118 | 2093222.65534 | 37.7275142813492 | -122.446840455715 | (37.7275142813492, -122.446840455715) | ||||
179750 | 179750 | 205815 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 112 Marston Ave | 8 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | 5998671.297040001 | 2093222.7898 | 37.727514782274106 | -122.446832494046 | (37.7275147822741, -122.446832494046) | ||||
187921 | 187921 | 205817 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 112 Marston Ave | 10 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | 5998664.62429 | 2093222.76421 | 37.7275143308076 | -122.446855559853 | (37.7275143308076, -122.446855559853) | ||||
65909 | 65909 | 205775 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1123 Bosworth St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 1ft | 6000939.14491 | 2095727.15465 | 37.7345204866211 | -122.439171966334 | (37.7345204866211, -122.439171966334) | |||
67909 | 67909 | 175697 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1138 Bacon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 2ft | 6008123.31948 | 2092096.90182 | 37.72495877772371 | -122.414077067227 | (37.7249587777237, -122.414077067227) | |||
124108 | 124108 | 121972 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 114 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991188.53985 | 2114632.1143 | 37.78586882698 | -122.474261742007 | (37.78586882698, -122.474261742007) | |||
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) | |||
45593 | 45593 | 125837 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 114 Leroy Pl | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6008328.0859900005 | 2116630.12257 | 37.7923328899977 | -122.415104962639 | (37.7923328899977, -122.415104962639) | |||
137756 | 137756 | 125838 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 114 Leroy Pl | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6008325.43827 | 2116645.82165 | 37.7923758470246 | -122.415115235581 | (37.7923758470246, -122.415115235581) | |||
146384 | 146384 | 125840 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 114 Leroy Pl | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6008320.5619 | 2116673.5156799997 | 37.7924516139938 | -122.415134069189 | (37.7924516139938, -122.415134069189) | |||
157135 | 157135 | 125841 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 114 Leroy Pl | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 6008319.99153 | 2116681.9043099997 | 37.7924746150586 | -122.41513663674601 | (37.7924746150586, -122.415136636746) | |||
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) | |||
47326 | 47326 | 125857 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1148 Filbert St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6007410.78308 | 2119548.4108 | 37.8002941896961 | -122.418485883829 | (37.8002941896961, -122.418485883829) | |||
152792 | 152792 | 222246 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1149 Shrader St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 5997700.29974 | 2106538.60043 | 37.764021222026294 | -122.451149091478 | (37.7640212220263, -122.451149091478) | |||
117378 | 117378 | 66170 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 115 Bronte St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/05/1990 12:00:00 AM | Permit Number 29242 | 6009342.82621351 | 2096790.80066071 | 37.7379156423933 | -122.41019259908998 | (37.7379156423933, -122.41019259909) | ||
113109 | 113109 | 42471 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 115 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/23/2000 12:00:00 AM | Permit Number 42613 | 5999341.906982 | 2095474.8798527 | 37.73373678233129 | -122.444676002661 | (37.7337367823313, -122.444676002661) | ||
172973 | 172973 | 204580 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 115 Melrose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5999331.38497 | 2095480.98556 | 37.7337529467263 | -122.444712818957 | (37.7337529467263, -122.444712818957) | |||
54758 | 54758 | 183609 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1150 Quintara St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5989796.6853 | 2101103.1583 | 37.7486412616545 | -122.478087645581 | (37.7486412616545, -122.478087645581) | |||
70129 | 70129 | 60817 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1150 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/02/1983 12:00:00 AM | 3 | Permit Number 20495 | 5989806.3915 | 2101102.4889 | 37.7486399870467 | -122.478054033081 | (37.7486399870467, -122.478054033081) | |
136844 | 136844 | 183608 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1150 Quintara St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 0ft | 5989802.0405 | 2101102.8236 | 37.7486406534958 | -122.478069103094 | (37.7486406534958, -122.478069103094) | |||
43985 | 43985 | 222346 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1151 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6002547.76398 | 2102147.08874 | 37.7522395321526 | -122.434069215723 | (37.7522395321526, -122.434069215723) | |||
163858 | 163858 | 200220 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1151 Hollister Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 6014047.4712 | 2090254.4109999998 | 37.7202306272165 | -122.39346889677601 | (37.7202306272165, -122.393468896776) | |||
132788 | 132788 | 30848 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1153 Castro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/1995 12:00:00 AM | 14 | Permit Number 34697 | 6002549.89906 | 2102133.17334 | 37.7522014449412 | -122.434060837652 | (37.7522014449412, -122.434060837652) | |
175351 | 175351 | 106611 | Significant Tree 6 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1154 Rhode Island St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4x4 | 6011908.79849 | 2103025.7220099997 | 37.7551788898075 | -122.401758852609 | (37.7551788898075, -122.401758852609) | |||
54837 | 54837 | 222321 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1156 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6009455.13668 | 2102439.70905 | 37.7534325970537 | -122.41020299828399 | (37.7534325970537, -122.410202998284) | |||
89770 | 89770 | 65261 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1156 Florida St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/26/1989 12:00:00 AM | Permit Number 28060 | 6009449.44831989 | 2102437.73284005 | 37.7534268519722 | -122.41022253040501 | (37.7534268519722, -122.410222530405) | ||
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) | |||
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) | |||
173480 | 173480 | 205826 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 116 Jules Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5994471.114990001 | 2090695.81427 | 37.7203354745885 | -122.46116935390499 | (37.7203354745885, -122.461169353905) | |||
187561 | 187561 | 205827 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 116 Jules Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5994470.95616 | 2090706.48365 | 37.720364761009705 | -122.46117067590201 | (37.7203647610097, -122.461170675902) | |||
28589 | 28589 | 175638 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 116 Schwerin St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008956.41307 | 2087314.5262799999 | 37.7118741275743 | -122.41085953663601 | (37.7118741275743, -122.410859536636) | |||
68376 | 68376 | 175674 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 116 Vienna St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 4ft | 6004710.8636300005 | 2092757.34918 | 37.726579963084504 | -122.42592054229999 | (37.7265799630845, -122.4259205423) | |||
77252 | 77252 | 175675 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 116 Vienna St | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 6004698.059769999 | 2092737.8519099997 | 37.726525704276796 | -122.42596341749399 | (37.7265257042768, -122.425963417494) | |||
116934 | 116934 | 44402 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1162 Munich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 7 | Permit Number 43756 | 6001306.88514 | 2087104.5026099999 | 37.7108655531865 | -122.437283363033 | (37.7108655531865, -122.437283363033) | |
44522 | 44522 | 188869 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1164 De Haro St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 6012189.44152 | 2103014.30234 | 37.7551631912308 | -122.400787498439 | (37.7551631912308, -122.400787498439) | |||
149234 | 149234 | 222255 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 117 Banks St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6008682.512 | 2098013.8861 | 37.74123693304121 | -122.412562072009 | (37.7412369330412, -122.412562072009) | |||
58119 | 58119 | 220842 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 117 Peralta Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6010257.61368 | 2100212.6219599997 | 37.7473624556225 | -122.40727086485701 | (37.7473624556225, -122.407270864857) | |||
81254 | 81254 | 43584 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 117 Valley St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/20/2000 12:00:00 AM | Permit Number 43245 | 6005148.55344947 | 2099289.0817491002 | 37.7445393628941 | -122.424871957382 | (37.7445393628941, -122.424871957382) | ||
112115 | 112115 | 10874 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1175X Hudson Ave | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | |||
123132 | 123132 | 10875 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1175X Hudson Ave | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 04/03/1991 12:00:00 AM | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | ||
139639 | 139639 | 10880 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1175X Hudson Ave | 13 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | |||
142103 | 142103 | 10883 | DPW Maintained 3 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1175X Hudson Ave | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X4 | 6017544.4990408 | 2094830.7506973 | 37.732990049052205 | -122.381698823278 | (37.7329900490522, -122.381698823278) | |||
26223 | 26223 | 175637 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1177 Brussels St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6011646.28852 | 2089340.4245799999 | 37.7175872984009 | -122.401704827622 | (37.7175872984009, -122.401704827622) | |||
98246 | 98246 | 69213 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1177 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/31/1994 12:00:00 AM | Permit Number 33264 | 6008095.60945385 | 2101082.12715709 | 37.749628684109396 | -122.414808474137 | (37.7496286841094, -122.414808474137) | ||
147965 | 147965 | 220945 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1177 Shotwell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008084.12741 | 2101107.52625 | 37.7496977791506 | -122.41484997694201 | (37.7496977791506, -122.414849976942) | |||
165611 | 165611 | 205869 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 118 Lakeview Ave | 1 | : 4 | Tree 1 | Private 1 | 6 | Width 3ft | 5997252.7619900005 | 2089357.2936200001 | 37.7168198961062 | -122.45145766596501 | (37.7168198961062, -122.451457665965) | |||
169403 | 169403 | 217683 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 118 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5992809.5901 | 2097716.9477 | 37.7395180108806 | -122.467422941938 | (37.7395180108806, -122.467422941938) | |||
154901 | 154901 | 175733 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1183 Munich St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 6ft | 6001131.654490001 | 2087116.6540599999 | 37.710888955334 | -122.437889869445 | (37.710888955334, -122.437889869445) | |||
178598 | 178598 | 222316 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1184 Alabama St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6009203.66279 | 2102279.76779 | 37.752979335133 | -122.41106135530599 | (37.752979335133, -122.411061355306) | |||
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) | |||
77122 | 77122 | 55323 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1186 Goettingen St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/26/1972 12:00:00 AM | 18 | Permit Number 11253 | 6011357.40386 | 2089280.46993 | 37.7174065499613 | -122.402699162137 | (37.7174065499613, -122.402699162137) | ||
69979 | 69979 | 116703 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 119 Trumbull St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | 6004176.22677 | 2094340.0625200002 | 37.730895511920096 | -122.427881490641 | (37.7308955119201, -122.427881490641) | ||||
37758 | 37758 | 220992 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 1192 Diamond St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6001929.1749599995 | 2100648.95659 | 37.7480908911891 | -122.43610119433599 | (37.7480908911891, -122.436101194336) | |||
148425 | 148425 | 125836 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 12 Golden Ct | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 9 | Width 5ft | 6008214.16509 | 2116540.3799400004 | 37.792080076180895 | -122.41549277636601 | (37.7920800761809, -122.415492776366) | |||
88682 | 88682 | 106702 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 12 HILL ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | 5x5 | 6006261.1 | 2103486.1 | 37.756126192255 | -122.421322975472 | (37.756126192255, -122.421322975472) | |||
60669 | 60669 | 220964 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 12 Hill St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006167.77637 | 2103486.22095 | 37.7561212624045 | -122.421645729193 | (37.7561212624045, -122.421645729193) | |||
168354 | 168354 | 220965 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 12 Hill St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6006182.97124 | 2103487.1181400004 | 37.7561245826867 | -122.421593243841 | (37.7561245826867, -122.421593243841) | |||
29710 | 29710 | 188279 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 12 Lillian St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6017754.54552 | 2094265.3959700002 | 37.7314492919381 | -122.380933340095 | (37.7314492919381, -122.380933340095) | |||
76612 | 76612 | 188280 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 12 Lillian St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6017796.93346 | 2094324.7108 | 37.7316144983135 | -122.380790917192 | (37.7316144983135, -122.380790917192) | |||
131987 | 131987 | 188278 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 12 Lillian St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6017724.20983 | 2094242.07575 | 37.7313835847835 | -122.381036596687 | (37.7313835847835, -122.381036596687) | |||
173131 | 173131 | 220869 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 120 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 4ft | 5998060.25576 | 2106223.7393900002 | 37.7631772955295 | -122.44988142238998 | (37.7631772955295, -122.44988142239) | |||
74725 | 74725 | 222479 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 120 Conrad St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6001753.48392 | 2096571.75813 | 37.736885877186104 | -122.436416959778 | (37.7368858771861, -122.436416959778) | |||
36971 | 36971 | 204508 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 120 Cresta Vista Dr | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 3ft | 5995837.30654 | 2096190.2797599998 | 37.73550048506571 | -122.456844092381 | (37.7355004850657, -122.456844092381) | |||
54540 | 54540 | 175593 | Undocumented 2 | Callistemon citrinus :: Lemon Bottlebrush 28 | 120 Farragut Ave | 7 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5997391.38544 | 2087332.13149 | 37.7112672047814 | -122.450832575961 | (37.7112672047814, -122.450832575961) | |||
43429 | 43429 | 31131 | Permitted Site 1 | Callistemon citrinus :: Lemon Bottlebrush 28 | 120 Gennessee St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 6 | Permit Number 34846 | 5997461.35333 | 2093947.48586 | 37.7294354301769 | -122.45106749418001 | (37.7294354301769, -122.45106749418) |
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");