Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH ▲ | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19488 | 19488 | 10031 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 310 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 100 | 2x3 | 6005459.49344 | 2107143.4221799998 | 37.7661231103266 | -122.42435532265301 | (37.7661231103266, -122.424355322653) | |||
| 18862 | 18862 | 10055 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 432 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 90 | 3X2 | 6005503.26278 | 2106415.24362 | 37.7641261764966 | -122.424152141508 | (37.7641261764966, -122.424152141508) | |||
| 18162 | 18162 | 10221 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1370 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 65 | 3X3 | 6005802.11698 | 2100976.8322900003 | 37.7492104347131 | -122.42273198069599 | (37.7492104347131, -122.422731980696) | |||
| 55289 | 55289 | 177095 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 0 Serrano Dr | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 48 | 5989637.49515 | 2090738.06528 | 37.720172132515 | -122.47788049948 | (37.720172132515, -122.47788049948) | ||||
| 323 | 323 | 27392 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2240 Hyde St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007139.14869 | 2120046.64789 | 37.801646927424706 | -122.419461214785 | (37.8016469274247, -122.419461214785) | |||
| 582 | 582 | 27390 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2240 Hyde St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007140.50399 | 2120032.48345 | 37.8016081117892 | -122.419455519354 | (37.8016081117892, -122.419455519354) | |||
| 888 | 888 | 14525 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 638 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 45 | 3X3 | 5999197.0779 | 2110617.9064 | 37.7753075467631 | -122.44626566212901 | (37.7753075467631, -122.446265662129) | |||
| 86417 | 86417 | 9946 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2145X Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 45 | 3X3 | 6007159.165551 | 2119559.7591564 | 37.8003111812757 | -122.41935738709299 | (37.8003111812757, -122.419357387093) | |||
| 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) | |||
| 180220 | 180220 | 248212 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 67 Fair Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 45 | Width 6ft | 6007009.12213 | 2099449.33024 | 37.745084284924104 | -122.41844983181801 | (37.7450842849241, -122.418449831818) | |||
| 147117 | 147117 | 129641 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 943 Green St | 12 | Side Yard : Yard 17 | Tree 1 | Private 1 | 41 | 6008676.12705 | 2118976.42517 | 37.7987948111981 | -122.41406679246201 | (37.7987948111981, -122.414066792462) | ||||
| 17605 | 17605 | 10230 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1426 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 40 | 2x3 | 6005817.36142 | 2100645.21865 | 37.7483007596771 | -122.42265570290199 | (37.7483007596771, -122.422655702902) | |||
| 86507 | 86507 | 105174 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1601X NEWCOMB AVE | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Arts Commission 19 | 40 | 3x3 | Permit Number 770204 | 6015135.0 | 2095759.0 | 37.735405494081505 | -122.390093985074 | (37.7354054940815, -122.390093985074) | ||
| 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) | |||
| 122091 | 122091 | 114098 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 219x VIDAL DR | 1 | Front Yard : Cutout 8 | Tree 1 | Private 1 | 40 | 5987664.0 | 2090565.0 | 37.719582202213104 | -122.48468943736401 | (37.7195822022131, -122.484689437364) | ||||
| 52226 | 52226 | 247946 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 15 Joy St | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 39 | 6010368.2533 | 2098885.09245 | 37.7437235405125 | -122.406794734117 | (37.7437235405125, -122.406794734117) | ||||
| 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) | ||||
| 86556 | 86556 | 61933 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 127 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/18/1985 12:00:00 AM | 36 | Permit Number 21990 | 6005702.47179 | 2100196.42976905 | 37.747062005493206 | -122.42302109514699 | (37.7470620054932, -122.423021095147) | |
| 39991 | 39991 | 249929 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 363 Filbert St | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 34 | Width 0ft | 6011103.53501 | 2120007.07668 | 37.801760767194 | -122.405739765471 | (37.801760767194, -122.405739765471) | |||
| 24097 | 24097 | 177096 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 0 Serrano Dr | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 32 | 5989524.60255 | 2090740.4518099998 | 37.720172132521206 | -122.47827090148199 | (37.7201721325212, -122.478270901482) | ||||
| 41490 | 41490 | 227279 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4530 25th St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 31 | Width 4ft | 6000798.050340001 | 2101148.90098 | 37.749399291454 | -122.44004841589701 | (37.749399291454, -122.440048415897) | |||
| 14796 | 14796 | 25703 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 564 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 30 | 3X3 | 6012079.76947 | 2110324.35268 | 37.7752288341828 | -122.401680556721 | (37.7752288341828, -122.401680556721) | |||
| 17617 | 17617 | 26521 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2837 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 7.5x7 | 6009000.88013 | 2101922.6219900004 | 37.7519873190611 | -122.411737385595 | (37.7519873190611, -122.411737385595) | |||
| 141187 | 141187 | 102448 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3430X 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 15x8 | 6006285.0 | 2102686.4 | 37.753931748244604 | -122.421183538041 | (37.7539317482446, -122.421183538041) | |||
| 20132 | 20132 | 10004 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 150 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 28 | 3X3 | 6005403.33839 | 2108127.1988 | 37.768821154693896 | -122.424619539876 | (37.7688211546939, -122.424619539876) | |||
| 55339 | 55339 | 247955 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 6 Joy St | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 28 | 6010457.43679 | 2098876.1187400003 | 37.743703890335205 | -122.40648572526001 | (37.7437038903352, -122.40648572526) | ||||
| 37843 | 37843 | 249627 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2450 Golden Gate Ave | 5 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 7ft | 5997621.56946 | 2111320.25827 | 37.777145918089 | -122.45176635913602 | (37.777145918089, -122.451766359136) | |||
| 71530 | 71530 | 227275 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 10 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 27 | Width 3ft | 6001741.27493 | 2099157.9473099997 | 37.7439862549578 | -122.43664423465201 | (37.7439862549578, -122.436644234652) | |||
| 154902 | 154902 | 191501 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 299x Cashmere St | 2 | Median : Yard 3 | Tree 1 | DPW 2 | 27 | 6016915.88272 | 2095866.14342 | 37.735798300938704 | -122.383944206463 | (37.7357983009387, -122.383944206463) | ||||
| 181991 | 181991 | 191439 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2205 25th St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 27 | Width 5ft | 6012190.61304 | 2101859.85462 | 37.751993394903295 | -122.40070234973801 | (37.7519933949033, -122.400702349738) | |||
| 123990 | 123990 | 207882 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1311 03rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 26 | Width 4ft | 5995155.88201 | 2106625.99826 | 37.7641151867919 | -122.459955752959 | (37.7641151867919, -122.459955752959) | |||
| 170238 | 170238 | 249928 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 363 Filbert St | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 26 | Width 0ft | 6011076.21302 | 2120004.52946 | 37.801752245226396 | -122.40583413315001 | (37.8017522452264, -122.40583413315) | |||
| 14345 | 14345 | 25704 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 564 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 3X3 | 6012091.3603 | 2110309.05533 | 37.7751874779549 | -122.401639385748 | (37.7751874779549, -122.401639385748) | |||
| 19433 | 19433 | 10011 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 198 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 25 | 2X3 | 6005417.15338 | 2107897.14895 | 37.76819027309789 | -122.424555388522 | (37.7681902730979, -122.424555388522) | |||
| 35045 | 35045 | 247843 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 151 Chapman St | 1 | Side Yard : Yard 17 | Tree 1 | Private 1 | 25 | 6009097.48489 | 2098216.36998 | 37.7418161899782 | -122.411141537049 | (37.7418161899782, -122.411141537049) | ||||
| 35118 | 35118 | 249626 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2450 Golden Gate Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 25 | Width 7ft | 5997629.20154 | 2111320.8976 | 37.7771481106256 | -122.45174000362199 | (37.7771481106256, -122.451740003622) | |||
| 174993 | 174993 | 129644 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 724 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 25 | Width 4ft | 6007831.26083 | 2120995.6473 | 37.804291598853 | -122.41713346715099 | (37.804291598853, -122.417133467151) | |||
| 2346 | 2346 | 14522 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 616 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | 3x3 | 5999189.6891 | 2110673.8503 | 37.7754607324086 | -122.446295246866 | (37.7754607324086, -122.446295246866) | |||
| 5902 | 5902 | 27389 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2240 Hyde St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6007143.328369999 | 2120019.7231400004 | 37.801573234283296 | -122.419444839906 | (37.8015732342833, -122.419444839906) | |||
| 17545 | 17545 | 17038 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1200X Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001065.34359 | 2109713.09337 | 37.772929678688506 | -122.43973803201 | (37.7729296786885, -122.43973803201) | |||
| 45668 | 45668 | 227409 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 323 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6003061.44291 | 2100931.79055 | 37.7489317492066 | -122.43220605156799 | (37.7489317492066, -122.432206051568) | |||
| 54173 | 54173 | 248064 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 18 Rutledge St | 6 | Side Yard : Yard 17 | Tree 1 | Private 1 | 24 | 6010656.53215 | 2099389.02438 | 37.7451233541731 | -122.40583342000099 | (37.7451233541731, -122.405833420001) | ||||
| 73237 | 73237 | 227350 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 30 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 24 | Width 3ft | 6007376.4096 | 2099328.82091 | 37.7447740628849 | -122.417171275545 | (37.7447740628849, -122.417171275545) | |||
| 88441 | 88441 | 114094 | Significant Tree 6 | Ligustrum lucidum :: Glossy Privet 55 | 239x VIDAL DR | 1 | Front Yard : Yard 7 | Tree 1 | Private 1 | 24 | 5987668.0 | 2090475.0 | 37.7193353179991 | -122.484669012602 | (37.7193353179991, -122.484669012602) | ||||
| 98083 | 98083 | 10181 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1097X Guerrero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6005777.346268901 | 2102574.3880576002 | 37.753595557271 | -122.422931166019 | (37.753595557271, -122.422931166019) | |||
| 142513 | 142513 | 14765 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 987 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 4X4 | 6004437.97734 | 2111858.52426 | 37.7790118963921 | -122.42822461586901 | (37.7790118963921, -122.428224615869) | |||
| 143245 | 143245 | 17111 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1837 Oak St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 5998183.72781 | 2109230.9980599997 | 37.7714415276809 | -122.44967109380501 | (37.7714415276809, -122.449671093805) | |||
| 145904 | 145904 | 17040 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1200X Oak St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 24 | 3X3 | 6001235.1914802 | 2109729.1714048 | 37.772983491104604 | -122.439151661694 | (37.7729834911046, -122.439151661694) | |||
| 159062 | 159062 | 122138 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 9 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 24 | 5991116.91399 | 2114978.91933 | 37.7868169072323 | -122.47453486398899 | (37.7868169072323, -122.474534863989) | ||||
| 39781 | 39781 | 227419 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 393 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | Width 3ft | 6001166.24895 | 2104139.2596 | 37.757631049653504 | -122.438989458796 | (37.7576310496535, -122.438989458796) | |||
| 47461 | 47461 | 247844 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 151 Chapman St | 2 | Side Yard : Yard 17 | Tree 1 | Private 1 | 23 | 6009115.842759999 | 2098211.0441099997 | 37.7418025958075 | -122.41107768521002 | (37.7418025958075, -122.41107768521) | ||||
| 56467 | 56467 | 226671 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1340 Bryant St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 23 | Width 2ft | 6009364.61324 | 2107966.78389 | 37.7686036122904 | -122.41090638773899 | (37.7686036122904, -122.410906387739) | |||
| 115192 | 115192 | 10179 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1090X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 23 | 3X3 | 6005708.480965099 | 2102624.2723741 | 37.7537286419918 | -122.42317286327801 | (37.7537286419918, -122.423172863278) | |||
| 152082 | 152082 | 227211 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 225 Montcalm St | 1 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 23 | Width 3ft | 6009836.16533 | 2099585.28248 | 37.7456163229324 | -122.408683960589 | (37.7456163229324, -122.408683960589) | |||
| 25706 | 25706 | 207376 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1200 14th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 22 | Width 7ft | 5991774.71222 | 2107128.83955 | 37.7653008152139 | -122.471686772321 | (37.7653008152139, -122.471686772321) | |||
| 154798 | 154798 | 68437 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 190 09th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/26/1993 12:00:00 AM | 22 | Permit Number 32291 | 6008616.38965 | 2110404.13314 | 37.7752540178903 | -122.41366685765101 | (37.7752540178903, -122.413666857651) | ||
| 157538 | 157538 | 141948 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 987 MCALLISTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | Width 0ft | 6004449.6894 | 2111857.1132 | 37.7790086846478 | -122.42818399853701 | (37.7790086846478, -122.428183998537) | |||
| 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) | |||
| 31753 | 31753 | 227294 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4271 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6002167.60726 | 2100591.89934 | 37.7479477685938 | -122.435272624637 | (37.7479477685938, -122.435272624637) | |||
| 32112 | 32112 | 191454 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 3ft | 6014422.1933 | 2115994.29604 | 37.790927639935205 | -122.39397451700701 | (37.7909276399352, -122.393974517007) | |||
| 60633 | 60633 | 227280 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 485 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6002019.43775 | 2101461.49358 | 37.7503270527496 | -122.4358471979 | (37.7503270527496, -122.4358471979) | |||
| 69298 | 69298 | 227418 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Douglass St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6001168.68328 | 2104120.67938 | 37.7575801713913 | -122.438979708367 | (37.7575801713913, -122.438979708367) | |||
| 131905 | 131905 | 191482 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701 Bryant St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6012422.29694 | 2111134.3733 | 37.7774720734215 | -122.40055258204599 | (37.7774720734215, -122.400552582046) | |||
| 157456 | 157456 | 129596 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1730 Jackson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 4ft | 6005755.363609999 | 2117239.26251 | 37.793860521606 | -122.42404999020901 | (37.793860521606, -122.424049990209) | |||
| 161895 | 161895 | 191479 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 526 05th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 21 | Width 3ft | 6012522.42576 | 2111176.28412 | 37.7775927345574 | -122.400209145359 | (37.7775927345574, -122.400209145359) | |||
| 176073 | 176073 | 207979 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 6 Nordhoff St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 21 | Width 8ft | 6000455.91103 | 2095286.7491099997 | 37.7332837263556 | -122.440811080593 | (37.7332837263556, -122.440811080593) | |||
| 11402 | 11402 | 1130 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2554 Alemany Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 5998598.100380001 | 2088668.31183 | 37.7150050570134 | -122.446757963627 | (37.7150050570134, -122.446757963627) | |||
| 16260 | 16260 | 25705 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 564 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 2X2 | 6012100.37031 | 2110300.97089 | 37.7751657827012 | -122.40160764957399 | (37.7751657827012, -122.401607649574) | |||
| 20212 | 20212 | 5507 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 800 Dolores St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 2x2 | 6004984.13536 | 2103653.10654 | 37.756512676133 | -122.42575103988999 | (37.756512676133, -122.42575103989) | |||
| 28407 | 28407 | 9343 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 209 Gold Mine Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 2X2 | 6000760.262283401 | 2098514.0876657 | 37.742162570261 | -122.439990187576 | (37.742162570261, -122.439990187576) | |||
| 41046 | 41046 | 227239 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1117 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 3ft | 6005786.23679 | 2102453.87032 | 37.753265145094794 | -122.422891855875 | (37.7532651450948, -122.422891855875) | |||
| 43562 | 43562 | 227257 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 191 Park St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 2ft | 6006008.96633 | 2096389.42446 | 37.7366261169982 | -122.421690904818 | (37.7366261169982, -122.421690904818) | |||
| 59305 | 59305 | 177114 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 34 Vienna St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 3ft | 6005072.9536 | 2093334.35555 | 37.7281847520053 | -122.42470983899099 | (37.7281847520053, -122.424709838991) | |||
| 60162 | 60162 | 244025 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1849 Page St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 5997747.9602 | 2108846.3652 | 37.7703604843866 | -122.451150685898 | (37.7703604843866, -122.451150685898) | |||
| 62116 | 62116 | 227254 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 191 Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 2ft | 6006076.68891 | 2096382.83584 | 37.736611844768895 | -122.42145629056999 | (37.7366118447689, -122.42145629057) | |||
| 88966 | 88966 | 8120 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 850X Fulton St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 20 | 3X3 | 6003699.00422 | 2111459.33104 | 37.777873970946295 | -122.43075252591801 | (37.7778739709463, -122.430752525918) | |||
| 106599 | 106599 | 34227 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 460 South Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1997 12:00:00 AM | 20 | Permit Number 38040 | 6007396.60708097 | 2107020.44544742 | 37.7658946396343 | -122.417646494621 | (37.7658946396343, -122.417646494621) | ||
| 160540 | 160540 | 207838 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 506 Faxon Ave | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | Width 1ft | 5994800.95024 | 2091971.89024 | 37.7238582494329 | -122.46012162930401 | (37.7238582494329, -122.460121629304) | |||
| 161759 | 161759 | 227293 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4250 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 4ft | 6002269.83839 | 2100637.34557 | 37.74807835824 | -122.43492236390199 | (37.74807835824, -122.434922363902) | |||
| 165688 | 165688 | 141959 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 881 LAGUNA ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | Width 0ft | 6004835.1064 | 2111857.5309 | 37.779031631000706 | -122.426850714982 | (37.7790316310007, -122.426850714982) | |||
| 167000 | 167000 | 122135 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 6 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 20 | 5991115.45698 | 2114997.03818 | 37.78686657212 | -122.47454122766099 | (37.78686657212, -122.474541227661) | ||||
| 23563 | 23563 | 227340 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3925 Folsom St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6008430.643540001 | 2096807.7680099998 | 37.7379110584464 | -122.41334767206499 | (37.7379110584464, -122.413347672065) | |||
| 42628 | 42628 | 227162 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 229 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6004860.09497 | 2100155.21835 | 37.7469012778702 | -122.425931032014 | (37.7469012778702, -122.425931032014) | |||
| 57579 | 57579 | 226703 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1840 15th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6005149.67015 | 2107248.36512 | 37.7663937585818 | -122.42543441018199 | (37.7663937585818, -122.425434410182) | |||
| 71415 | 71415 | 226675 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 127 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 9ft | 6005684.59904 | 2100199.28079 | 37.7470688251863 | -122.423083100303 | (37.7470688251863, -122.423083100303) | |||
| 75924 | 75924 | 226709 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 699 Guerrero St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6005644.5012300005 | 2105027.58603 | 37.760323969695 | -122.423564974168 | (37.760323969695, -122.423564974168) | |||
| 123426 | 123426 | 227469 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 37 Uranus Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 5999314.37264 | 2105521.32112 | 37.761320307011296 | -122.445493355853 | (37.7613203070113, -122.445493355853) | |||
| 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) | |||
| 137111 | 137111 | 226700 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 68 Ramona Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 5ft | 6005192.67136 | 2107448.02367 | 37.7669444026985 | -122.425299885982 | (37.7669444026985, -122.425299885982) | |||
| 156744 | 156744 | 227456 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 34 Levant St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6000235.72024 | 2106677.53152 | 37.7645475295791 | -122.442389820631 | (37.7645475295791, -122.442389820631) | |||
| 159114 | 159114 | 191451 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 110 Main St | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | Width 3ft | 6014385.345480001 | 2116032.04037 | 37.7910292291593 | -122.39410465341001 | (37.7910292291593, -122.39410465341) | |||
| 161243 | 161243 | 227295 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4257 26th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 4ft | 6002219.59869 | 2100594.97357 | 37.747959162083504 | -122.43509306059799 | (37.7479591620835, -122.435093060598) | |||
| 167324 | 167324 | 122130 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 1 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 19 | 5991115.18782 | 2115016.9633400002 | 37.7869212654547 | -122.474543613569 | (37.7869212654547, -122.474543613569) | ||||
| 169584 | 169584 | 191480 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 526 05th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6012537.84104 | 2111160.5359 | 37.7775503530914 | -122.400154712085 | (37.7775503530914, -122.400154712085) | |||
| 178595 | 178595 | 227373 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3410 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6006229.031880001 | 2102615.79175 | 37.7537347189024 | -122.421372075386 | (37.7537347189024, -122.421372075386) | |||
| 181331 | 181331 | 191432 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 18th St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | 6010899.91125 | 2105517.41089 | 37.761964158640396 | -122.405423368691 | (37.7619641586404, -122.405423368691) | ||||
| 183847 | 183847 | 227240 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1041 Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 19 | Width 3ft | 6005776.90584 | 2102650.34664 | 37.753804097106205 | -122.422938087332 | (37.7538040971062, -122.422938087332) | |||
| 3706 | 3706 | 226704 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 460 South Van Ness Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/25/1997 12:00:00 AM | 18 | Width 4ft | Permit Number 38040 | 6007388.533559999 | 2107001.8580400003 | 37.7658431486538 | -122.41767310175399 | (37.7658431486538, -122.417673101754) | |
| 4112 | 4112 | 226674 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 145 27th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/09/2015 12:00:00 AM | 18 | Width 7ft | Permit Number 21993 | 6005571.69833 | 2100193.82022 | 37.747047459974 | -122.423473113803 | (37.747047459974, -122.423473113803) | |
| 6106 | 6106 | 7959 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1800 Franklin St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 3X3 | 6005709.66614 | 2116337.52814 | 37.791382005314 | -122.424143948706 | (37.791382005314, -122.424143948706) |
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");