Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, qSiteInfo, qCaretaker, qCareAssistant, PlantDate, DBH, PlotSize
| Link | rowid ▲ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 187811 | 187811 | 101108 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1790 24th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 3X3 | Permit Number 14067 | 5988777.5028 | 2103198.1315 | 37.754334289199704 | -122.481765355128 | (37.7543342891997, -122.481765355128) | ||
| 187790 | 187790 | 226726 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2730 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6010313.932519999 | 2102839.26817 | 37.7545777982407 | -122.40726125021601 | (37.7545777982407, -122.407261250216) | |||
| 187665 | 187665 | 124007 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 317 06th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5993994.36391 | 2113305.2433 | 37.7823877470983 | -122.464458070673 | (37.7823877470983, -122.464458070673) | |||
| 186971 | 186971 | 72130 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2030 23rd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/25/1984 12:00:00 AM | 7 | 6012329.14835 | 2102847.44399 | 37.7547128260461 | -122.400292629422 | (37.7547128260461, -122.400292629422) | ||
| 186375 | 186375 | 114467 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2351 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6009280.92289 | 2121766.4788599997 | 37.8064895545061 | -122.412171287793 | (37.8064895545061, -122.412171287793) | |||
| 185976 | 185976 | 227167 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 119 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 5998089.83813 | 2106503.39659 | 37.76394685618 | -122.449799262145 | (37.76394685618, -122.449799262145) | |||
| 185719 | 185719 | 207828 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Staples Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 1ft | 5999348.944080001 | 2093797.91328 | 37.729132626663706 | -122.444531189165 | (37.7291326266637, -122.444531189165) | |||
| 185519 | 185519 | 227229 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3181 22nd St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6007106.48426 | 2103203.24866 | 37.7553971732524 | -122.418379289898 | (37.7553971732524, -122.418379289898) | |||
| 185010 | 185010 | 141369 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 340 BAKER ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6000731.4526 | 2110189.2685 | 37.7742181251853 | -122.440927164049 | (37.7742181251853, -122.440927164049) | |||
| 184261 | 184261 | 227300 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4233 Cesar Chavez St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6002388.83562 | 2100326.88873 | 37.7472326726441 | -122.434488682032 | (37.7472326726441, -122.434488682032) | ||||
| 184110 | 184110 | 227208 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 35 Powhattan Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 22 | Width 3ft | 6007523.932469999 | 2098207.4852299998 | 37.741703423083294 | -122.416581750143 | (37.7417034230833, -122.416581750143) | |||
| 182818 | 182818 | 123765 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 773 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5993254.87771 | 2110685.3073 | 37.775151455932104 | -122.466825830328 | (37.7751514559321, -122.466825830328) | |||
| 182800 | 182800 | 227173 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 146 Alma St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5997978.59141 | 2106212.21025 | 37.763140966494 | -122.450163039697 | (37.763140966494, -122.450163039697) | |||
| 182185 | 182185 | 177119 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 224 Avalon Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 2ft | 6003367.9404 | 2092809.07535 | 37.7266460056919 | -122.430566665719 | (37.7266460056919, -122.430566665719) | |||
| 181512 | 181512 | 123213 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 598 09th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 5993174.184859999 | 2111497.3311799997 | 37.77737639746871 | -122.46716401549999 | (37.7773763974687, -122.4671640155) | |||
| 180832 | 180832 | 129622 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1513 Clay St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 6007514.975880001 | 2116792.81742 | 37.792733882423 | -122.417929887875 | (37.792733882423, -122.417929887875) | |||
| 180446 | 180446 | 227253 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 191 Park St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 2ft | 6006109.760840001 | 2096378.48743 | 37.7366017696511 | -122.421341637808 | (37.7366017696511, -122.421341637808) | |||
| 179397 | 179397 | 101144 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Connecticut St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | 2x2 | 6013206.1129 | 2104955.38983 | 37.7605496482619 | -122.397407647447 | (37.7605496482619, -122.397407647447) | |||
| 177041 | 177041 | 227379 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3440 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6006865.432019999 | 2101476.6726599997 | 37.750642818218104 | -122.419090462054 | (37.7506428182181, -122.419090462054) | |||
| 176592 | 176592 | 34689 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 5 | 3x3 | Permit Number 38352 | 6002816.77257 | 2119329.88091 | 37.79943447017929 | -122.434367321195 | (37.7994344701793, -122.434367321195) |
| 176132 | 176132 | 138670 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1718 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5999600.9508 | 2114760.7686 | 37.786705834843204 | -122.44516649185199 | (37.7867058348432, -122.445166491852) | |||
| 175712 | 175712 | 140601 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 864 FULTON ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003648.163 | 2111453.8222 | 37.777855964465 | -122.430928010163 | (37.777855964465, -122.430928010163) | |||
| 175375 | 175375 | 141040 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 80 Cook St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5997545.9497 | 2113169.6309 | 37.7822194802715 | -122.452161420734 | (37.7822194802715, -122.452161420734) | |||
| 174339 | 174339 | 177136 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 567 Bowdoin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008890.39934 | 2093346.8043400003 | 37.7284337994566 | -122.411513614482 | (37.7284337994566, -122.411513614482) | |||
| 173912 | 173912 | 227494 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 144 Laidley St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 2ft | 6003810.62137 | 2097507.3684900003 | 37.7395715262114 | -122.429371225707 | (37.7395715262114, -122.429371225707) | |||
| 173389 | 173389 | 177078 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 490 Blanken Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6012757.34984 | 2087044.1812200001 | 37.71134420923121 | -122.397703398489 | (37.7113442092312, -122.397703398489) | |||
| 173319 | 173319 | 227369 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1156 Shotwell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6008042.16484 | 2101172.50837 | 37.749873847504 | -122.41499968439699 | (37.749873847504, -122.414999684397) | |||
| 173097 | 173097 | 208015 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 58 Marston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | 5998954.572369999 | 2093232.0746099998 | 37.7275564550483 | -122.445853880569 | (37.7275564550483, -122.445853880569) | ||||
| 173003 | 173003 | 129607 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2101 Van Ness Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6005934.12087 | 2117690.49416 | 37.7951095809901 | -122.42346356661001 | (37.7951095809901, -122.42346356661) | |||
| 172203 | 172203 | 227412 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1151 Sanchez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6003866.70638 | 2101546.0365299997 | 37.750663949580606 | -122.429465247149 | (37.7506639495806, -122.429465247149) | |||
| 171783 | 171783 | 177092 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 8ft | 5993402.95207 | 2086595.08273 | 37.7090143176374 | -122.464564009531 | (37.7090143176374, -122.464564009531) | |||
| 171098 | 171098 | 227234 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3591 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6006397.4791 | 2104334.6150700003 | 37.758463705862106 | -122.42091157030599 | (37.7584637058621, -122.420911570306) | |||
| 170777 | 170777 | 200060 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1801 Lane St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 15 | Width 0ft | 6014881.3338 | 2094088.2009 | 37.7308037462249 | -122.390854280531 | (37.7308037462249, -122.390854280531) | |||
| 170221 | 170221 | 177140 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 822 Felton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008497.82437 | 2093174.8128099998 | 37.727939519481 | -122.412858615334 | (37.727939519481, -122.412858615334) | |||
| 168921 | 168921 | 250110 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 2ft | 6006127.47241 | 2115428.56912 | 37.7889098112749 | -122.422633725286 | (37.7889098112749, -122.422633725286) | |||
| 167651 | 167651 | 207397 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 347 Noriega St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 5 | Width 4ft | 5992858.7373 | 2103189.98205 | 37.7545484021055 | -122.467650937865 | (37.7545484021055, -122.467650937865) | |||
| 167437 | 167437 | 226661 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Dolores St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6004732.99983 | 2108080.69145 | 37.7686555760307 | -122.42693488134199 | (37.7686555760307, -122.426934881342) | |||
| 166825 | 166825 | 248057 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 17 Rutledge St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 12 | 6010678.5248 | 2099352.93022 | 37.7450254773569 | -122.405754830944 | (37.7450254773569, -122.405754830944) | ||||
| 166593 | 166593 | 191441 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2250 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6012095.50182 | 2101892.00289 | 37.7520763618475 | -122.40103351879101 | (37.7520763618475, -122.401033518791) | |||
| 165829 | 165829 | 227281 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4181 23rd St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 6 | Width 4ft | 6001938.68503 | 2102334.04898 | 37.752718294320296 | -122.43618888093701 | (37.7527182943203, -122.436188880937) | |||
| 165662 | 165662 | 141576 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1480 Grove St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 6000723.6824 | 2110698.6413 | 37.7756162917204 | -122.440990592453 | (37.7756162917204, -122.440990592453) | |||
| 164871 | 164871 | 226669 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 298 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008867.057440001 | 2106924.30834 | 37.7657133036545 | -122.412553697512 | (37.7657133036545, -122.412553697512) | |||
| 164536 | 164536 | 129639 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1136 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007510.50379 | 2119218.83195 | 37.7993948622524 | -122.418117431574 | (37.7993948622524, -122.418117431574) | |||
| 163801 | 163801 | 244961 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 202 Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 0ft | 6005161.4093 | 2109786.5938 | 37.7733637868695 | -122.425574471379 | (37.7733637868695, -122.425574471379) | |||
| 163117 | 163117 | 191445 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1451 19th St | 3 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6013335.759880001 | 2105192.0474900003 | 37.761206675862205 | -122.396975847857 | (37.7612066758622, -122.396975847857) | |||
| 161810 | 161810 | 38641 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Shafter Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1998 12:00:00 AM | 16 | Permit Number 40566 | 6014964.8748 | 2094103.3153 | 37.7308498822776 | -122.39056651931001 | (37.7308498822776, -122.39056651931) | |
| 161764 | 161764 | 129636 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1181 Union St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6007340.70028 | 2119141.2469900004 | 37.7991722746363 | -122.41869950788299 | (37.7991722746363, -122.418699507883) | |||
| 159356 | 159356 | 139818 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1672 EDDY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6002454.8426 | 2112669.6973 | 37.7811267653815 | -122.43514310289801 | (37.7811267653815, -122.435143102898) | |||
| 159007 | 159007 | 248522 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 218 Downey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5998868.9787 | 2107725.2392 | 37.7673462757129 | -122.44719239933501 | (37.7673462757129, -122.447192399335) | |||
| 158347 | 158347 | 177126 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 Yale St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 5ft | 6006914.161069999 | 2093507.1567900002 | 37.7287630439686 | -122.41835694803301 | (37.7287630439686, -122.418356948033) | |||
| 158341 | 158341 | 118272 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 801 37th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 1ft | 5984451.19382 | 2110333.53689 | 37.7736735662944 | -122.497253299741 | (37.7736735662944, -122.497253299741) | |||
| 157248 | 157248 | 227201 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 178 Highland Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 6006058.903630001 | 2096605.43384 | 37.7372220464653 | -122.421533586412 | (37.7372220464653, -122.421533586412) | |||
| 156782 | 156782 | 191453 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 8 | Width 3ft | 6014408.51358 | 2116009.54729 | 37.790968756046794 | -122.39402291674 | (37.7909687560468, -122.39402291674) | |||
| 155744 | 155744 | 129665 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 4ft | 6009349.70654 | 2121620.88667 | 37.806093654068796 | -122.411922953492 | (37.8060936540688, -122.411922953492) | |||
| 154412 | 154412 | 177052 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 10ft | 5998953.787769999 | 2090172.9381799998 | 37.719156729587 | -122.445636697899 | (37.719156729587, -122.445636697899) | |||
| 154083 | 154083 | 246236 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 96 Delmar St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5999346.6916 | 2107785.6536 | 37.76753944246121 | -122.445544408224 | (37.7675394424612, -122.445544408224) | |||
| 153917 | 153917 | 227421 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4611 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000615.840030001 | 2104640.77483 | 37.758976755599704 | -122.440928969103 | (37.7589767555997, -122.440928969103) | |||
| 152850 | 152850 | 123768 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 801 Cabrillo St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 2ft | 5993093.8736 | 2110681.87789 | 37.77513274618389 | -122.467382525307 | (37.7751327461839, -122.467382525307) | |||
| 151985 | 151985 | 129610 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1700 Pacific Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6005886.38297 | 2117589.46023 | 37.7948294727542 | -122.423621560411 | (37.7948294727542, -122.423621560411) | |||
| 148786 | 148786 | 177071 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 195 Allison St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 2ft | 6000082.85227 | 2087744.80295 | 37.7125540150319 | -122.441559812029 | (37.7125540150319, -122.441559812029) | |||
| 147949 | 147949 | 247848 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 149 Chapman St | 3 | Side Yard : Yard 17 | Tree 1 | Private 1 | 37 | 6009193.51112 | 2098205.9216299998 | 37.7417928858333 | -122.410808770816 | (37.7417928858333, -122.410808770816) | ||||
| 147826 | 147826 | 248439 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 68 Downey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5998835.0618 | 2107965.3827 | 37.768003711032 | -122.447326998761 | (37.768003711032, -122.447326998761) | |||
| 147312 | 147312 | 207994 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 10 | Width 10ft | 5999470.93523 | 2094944.41877 | 37.7322876228558 | -122.444191810206 | (37.7322876228558, -122.444191810206) | |||
| 146811 | 146811 | 129676 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 464 California St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 4ft | 6012082.98226 | 2116799.13729 | 37.7930072601221 | -122.402124744455 | (37.7930072601221, -122.402124744455) | |||
| 146775 | 146775 | 227185 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 979 Ashbury St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 4ft | 5999188.84742 | 2106648.55947 | 37.764408255174 | -122.44600857293501 | (37.764408255174, -122.446008572935) | |||
| 146675 | 146675 | 227205 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 533 Tompkins Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 2ft | 6008456.33815 | 2096517.71816 | 37.7371160874276 | -122.413238327983 | (37.7371160874276, -122.413238327983) | |||
| 145902 | 145902 | 15426 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2101 Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 2X2 | 6006897.56767 | 2106023.27679 | 37.7631285540423 | -122.419301827609 | (37.7631285540423, -122.419301827609) | |||
| 142958 | 142958 | 20262 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | |||
| 140948 | 140948 | 111019 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 90x DOWNEY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/14/2015 12:00:00 AM | 3x3 | 5998894.0 | 2107683.0 | 37.7672317271747 | -122.447102814384 | (37.7672317271747, -122.447102814384) | |||
| 140772 | 140772 | 32771 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 372 Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/29/1996 12:00:00 AM | Permit Number 37143 | 6000720.14986856 | 2110226.00515194 | 37.774318351022295 | -122.440968898129 | (37.7743183510223, -122.440968898129) | ||
| 140063 | 140063 | 74108 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 555 Tompkins Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 3 | 3x3 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
| 138925 | 138925 | 37164 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3555 Cesar Chavez St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1998 12:00:00 AM | Permit Number 39738 | 6006329.64997303 | 2100518.61882542 | 37.747982034538296 | -122.420875232711 | (37.7479820345383, -122.420875232711) | ||
| 138769 | 138769 | 7210 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1225X McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6003292.04755 | 2111699.2584599997 | 37.7785096871687 | -122.43217746913601 | (37.7785096871687, -122.432177469136) | |||
| 136670 | 136670 | 227260 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1035 Douglass St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 1ft | 6001350.1729 | 2100676.3582200003 | 37.748133217784 | -122.438105320914 | (37.748133217784, -122.438105320914) | |||
| 136024 | 136024 | 227308 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 415 Beacon St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 7 | Width 2ft | 6002314.2643 | 2098316.80791 | 37.7417092282111 | -122.43460283744699 | (37.7417092282111, -122.434602837447) | |||
| 135820 | 135820 | 227297 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4220 Cesar Chavez St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 12 | 6002396.17742 | 2100337.95193 | 37.7472634663454 | -122.434464085561 | (37.7472634663454, -122.434464085561) | ||||
| 134858 | 134858 | 96008 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009692.64051 | 2116408.6515099998 | 37.791801372693 | -122.410367907846 | (37.791801372693, -122.410367907846) |
| 134338 | 134338 | 129590 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1870 Sacramento St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 3 | Width 5ft | 6005845.5146 | 2116275.22301 | 37.7912186002945 | -122.423669483476 | (37.7912186002945, -122.423669483476) | |||
| 133724 | 133724 | 191484 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701 Bryant St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6012469.2774 | 2111178.20326 | 37.7775950404069 | -122.400393139428 | (37.7775950404069, -122.400393139428) | |||
| 129672 | 129672 | 227277 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4438 25th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 6001050.5887 | 2101156.4766 | 37.7494344657241 | -122.43917567693899 | (37.7494344657241, -122.439175676939) | |||
| 128542 | 128542 | 14788 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1077 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 05/21/1992 12:00:00 AM | 6 | 3X3 | 6004038.31085 | 2111808.31104 | 37.7788514015092 | -122.42960364101299 | (37.7788514015092, -122.429603641013) | ||
| 126982 | 126982 | 115658 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1499X HAYES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6000749.0 | 2110266.0 | 37.7744298099173 | -122.440871970116 | (37.7744298099173, -122.440871970116) | |||
| 125971 | 125971 | 108151 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2232 Webster St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6003295.44003 | 2116396.66877 | 37.791407783491294 | -122.432501340527 | (37.7914077834913, -122.432501340527) | |||||
| 122515 | 122515 | 100230 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701X 39th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5983807.86909 | 2110960.60417 | 37.7753575879766 | -122.49952497559799 | (37.7753575879766, -122.499524975598) | |||
| 119444 | 119444 | 15325 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1698X Mission St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 1X1 | 6006725.5802 | 2108585.93757 | 37.7701553284346 | -122.420078550817 | (37.7701553284346, -122.420078550817) | |||
| 117602 | 117602 | 12166 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1439X La Salle Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6016344.6880818 | 2095251.8114423 | 37.7340798748876 | -122.38587626093799 | (37.7340798748876, -122.385876260938) | |||
| 116161 | 116161 | 34044 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 298 Alabama St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/05/1997 12:00:00 AM | Permit Number 37957 | 6008878.33665025 | 2106854.71470607 | 37.7655228486031 | -122.41250976517 | (37.7655228486031, -122.41250976517) | ||
| 115150 | 115150 | 96700 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1849 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 5997732.0 | 2108845.0 | 37.770355822096704 | -122.451205793491 | (37.7703558220967, -122.451205793491) | |||
| 114668 | 114668 | 14799 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1135 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6003745.74789 | 2111758.98852 | 37.778699404291395 | -122.43061221122801 | (37.7786994042914, -122.430612211228) | |||
| 108877 | 108877 | 107463 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1629 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6008753.83856 | 2118472.3887 | 37.7974152162793 | -122.413762212943 | (37.7974152162793, -122.413762212943) | |||||
| 107948 | 107948 | 8121 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 850X Fulton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6003699.00422 | 2111459.33104 | 37.777873970946295 | -122.43075252591801 | (37.7778739709463, -122.430752525918) | |||
| 106702 | 106702 | 10129 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 892 Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 3X3 | 6005646.9391641 | 2103763.6492254 | 37.7568536327232 | -122.42346668441999 | (37.7568536327232, -122.42346668442) | |||
| 105226 | 105226 | 138704 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2521 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6001167.2865 | 2114524.96 | 37.786147644599 | -122.439730444644 | (37.786147644599, -122.439730444644) | |||
| 104609 | 104609 | 121041 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2101 Polk St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006363.0 | 2118098.0 | 37.7962526868942 | -122.422008539697 | (37.7962526868942, -122.422008539697) | ||||
| 102300 | 102300 | 35728 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 190 Dartmouth St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/14/1998 12:00:00 AM | Permit Number 39007 | 6008565.46175199 | 2093223.89460892 | 37.7280780839519 | -122.41262825854099 | (37.7280780839519, -122.412628258541) | ||
| 102161 | 102161 | 103603 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2015 12:00:00 AM | 3 | 3x3 | 6004868.5 | 2109011.4 | 37.771218737852294 | -122.426532477218 | (37.7712187378523, -122.426532477218) | ||
| 100018 | 100018 | 78992 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450X Banks St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 06/18/1994 12:00:00 AM | 3 | 3x4 | 6008487.2849764 | 2096519.17342203 | 37.73712182063289 | -122.413131433288 | (37.7371218206329, -122.413131433288) | |
| 99318 | 99318 | 5483 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 700X Dolores St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 04/28/2008 12:00:00 AM | 6 | 6 | 6004966.5668947 | 2104283.6095193 | 37.7582428963987 | -122.425856676166 | (37.7582428963987, -122.425856676166) | ||
| 99189 | 99189 | 20272 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2290 Stockton St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2005 12:00:00 AM | 3 | 2X2 | 6009846.48172 | 2121764.7141400003 | 37.8065164263834 | -122.41021393510599 | (37.8065164263834, -122.410213935106) | ||
| 98674 | 98674 | 37252 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | Permit Number 39805 | 6002396.16255256 | 2104159.25249428 | 37.7577558475859 | -122.434737351341 | (37.7577558475859, -122.434737351341) |
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");