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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||
| 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) | |||
| 68485 | 68485 | 120482 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 5988588.087169999 | 2114640.4078900004 | 37.7857406059941 | -122.483259085533 | (37.7857406059941, -122.483259085533) | |||
| 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) | ||
| 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) | ||||
| 44820 | 44820 | 122132 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | 5991115.98152 | 2115010.99351 | 37.7869049199545 | -122.47454043173401 | (37.7869049199545, -122.474540431734) | ||||
| 60067 | 60067 | 207405 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2692 16th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991464.745630001 | 2097109.88885 | 37.737773449589795 | -122.47202854890499 | (37.7377734495898, -122.472028548905) | |||
| 33606 | 33606 | 207898 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991548.15864 | 2097071.69595 | 37.7376734080929 | -122.471737369979 | (37.7376734080929, -122.471737369979) | |||
| 58173 | 58173 | 124075 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701 Funston Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 17 | Width 3ft | 5991933.35964 | 2110333.59039 | 37.774109377871106 | -122.47137158054599 | (37.7741093778711, -122.471371580546) | |||
| 58191 | 58191 | 207377 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1201 Funston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 18 | 5992030.8504800005 | 2107135.40247 | 37.7653336512411 | -122.47080133672199 | (37.7653336512411, -122.470801336722) | ||||
| 53838 | 53838 | 207378 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1221 Funston Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 14 | Width 4ft | 5992032.39492 | 2107035.89745 | 37.7650605262515 | -122.470788746219 | (37.7650605262515, -122.470788746219) | |||
| 67836 | 67836 | 207948 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 09th Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5992690.99199 | 2100498.58562 | 37.7471488342554 | -122.468035281115 | (37.7471488342554, -122.468035281115) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 57403 | 57403 | 207920 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1475 Monterey Blvd | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993561.46186 | 2095084.6811400002 | 37.73233383991511 | -122.46463222850599 | (37.7323338399151, -122.464632228506) | |||
| 60928 | 60928 | 207951 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2101 09th Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993609.19049 | 2101330.01407 | 37.7494847081672 | -122.4649206222 | (37.7494847081672, -122.4649206222) | |||
| 54907 | 54907 | 207912 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 125 Montalvo Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 3 | Width 3ft | 5993750.78708 | 2099620.0090799998 | 37.744797631402996 | -122.46430684749501 | (37.744797631403, -122.464306847495) | |||
| 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) | |||
| 24746 | 24746 | 207954 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 20 Sotelo Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 5994065.04944 | 2100893.3637099997 | 37.7483120506561 | -122.46331257952801 | (37.7483120506561, -122.463312579528) | |||
| 26130 | 26130 | 207916 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Pacheco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5994697.354069999 | 2099701.1071099997 | 37.7450748213407 | -122.46103969864201 | (37.7450748213407, -122.461039698642) | |||
| 56259 | 56259 | 207934 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Merced Ave | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5995381.25357 | 2100216.22441 | 37.7465285358768 | -122.45871219562599 | (37.7465285358768, -122.458712195626) | |||
| 45456 | 45456 | 207958 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995753.89015 | 2100245.5855099997 | 37.7466305648554 | -122.457425790981 | (37.7466305648554, -122.457425790981) | |||
| 35298 | 35298 | 207929 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 101 San Ramon Way | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5995760.63845 | 2092696.4312900002 | 37.7259028185378 | -122.45685654350599 | (37.7259028185378, -122.456856543506) | |||
| 52188 | 52188 | 36155 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 70 Commonwealth Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1998 12:00:00 AM | 6 | Permit Number 39238 | 5996549.1283 | 2114145.8086 | 37.784842652821496 | -122.45568053932399 | (37.7848426528215, -122.455680539324) | |
| 46018 | 46018 | 207936 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 145 Ridgewood Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5996773.84945 | 2094603.0079700002 | 37.731195952027996 | -122.453491559201 | (37.731195952028, -122.453491559201) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 3852 | 3852 | 244053 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 401 Cole St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 5997903.1431 | 2109164.16 | 37.7712419510675 | -122.450636826227 | (37.7712419510675, -122.450636826227) | |||
| 2918 | 2918 | 140306 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2084 HAYES ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5997911.1716 | 2109955.9635 | 37.773416499401705 | -122.450666152059 | (37.7734164994017, -122.450666152059) | |||
| 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) | |||
| 58696 | 58696 | 207965 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 735 Foerster St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 3ft | 5998007.7209 | 2095786.05635 | 37.7345149737803 | -122.44931106965299 | (37.7345149737803, -122.449311069653) | |||
| 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) | |||
| 89620 | 89620 | 114798 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 103 Grattan St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998130.990703201 | 2106502.59817932 | 37.7639470183873 | -122.44965687078998 | (37.7639470183873, -122.44965687079) | ||||
| 34291 | 34291 | 207820 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 298 Staples Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 5998217.897469999 | 2093812.4595700002 | 37.729107964547794 | -122.44844233986099 | (37.7291079645478, -122.448442339861) | |||
| 33447 | 33447 | 208010 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 126 Edna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998766.05843 | 2093398.5760400002 | 37.728002863243205 | -122.446517546066 | (37.7280028632432, -122.446517546066) | |||
| 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) | |||
| 32666 | 32666 | 245945 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 97 Downey St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 0ft | 5998847.6292 | 2107686.9313 | 37.7672398720062 | -122.44726348656 | (37.7672398720062, -122.44726348656) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | ||||
| 53642 | 53642 | 177061 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 Geneva Ave | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 5ft | 5999007.9061199995 | 2090532.0864 | 37.720145957757104 | -122.44547544316002 | (37.7201459577571, -122.44547544316) | |||
| 71249 | 71249 | 227183 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 833 Ashbury St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5999115.77081 | 2107425.5617299997 | 37.7665375350105 | -122.446317222982 | (37.7665375350105, -122.446317222982) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 13198 | 13198 | 25303 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 286 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 18 | 5x9 | 5999775.2112 | 2091625.73202 | 37.7231926324273 | -122.4429016302 | (37.7231926324273, -122.4429016302) | |||
| 72591 | 72591 | 177042 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 123 Seneca Ave | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | Width 0ft | 6000059.76293 | 2090063.89794 | 37.7189204111404 | -122.441805953806 | (37.7189204111404, -122.441805953806) | |||
| 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) | |||
| 60721 | 60721 | 245070 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 6 Lyon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6000404.9733 | 2108969.9375 | 37.7708515497475 | -122.441968974427 | (37.7708515497475, -122.441968974427) | |||
| 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) | |||
| 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) | ||
| 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) | |||
| 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) | |||
| 34352 | 34352 | 227426 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4681 19th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 3ft | 6000732.63696 | 2104644.90008 | 37.7589947339321 | -122.440525327306 | (37.7589947339321, -122.440525327306) | |||
| 80877 | 80877 | 25291 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000743.1124599995 | 2091772.81119 | 37.7236516133979 | -122.439566330441 | (37.7236516133979, -122.439566330441) | |||
| 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) | |||
| 59557 | 59557 | 142177 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1490 Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 6000750.4323 | 2110355.4784 | 37.7746755766034 | -122.44087343567 | (37.7746755766034, -122.44087343567) | |||
| 40608 | 40608 | 129578 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2434 Divisadero St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000794.176109999 | 2116746.49388 | 37.7922261557494 | -122.441180751388 | (37.7922261557494, -122.441180751388) | |||
| 33838 | 33838 | 129561 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3299 Scott St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 3ft | 6000845.88514 | 2119539.08728 | 37.7998968278242 | -122.44120229016501 | (37.7998968278242, -122.441202290165) | |||
| 262 | 262 | 141360 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1499X Hayes St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 0ft | 6000919.0 | 2110350.0 | 37.77467013322371 | -122.44028993459101 | (37.7746701332237, -122.440289934591) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 63493 | 63493 | 227262 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1334 Douglass St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6001352.76553 | 2099787.74958 | 37.745693456895204 | -122.43803271325001 | (37.7456934568952, -122.43803271325) | |||
| 61599 | 61599 | 227266 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 748 Duncan St | 3 | Sidewalk: Curb side : Pot 10 | Tree 1 | Private 1 | 8 | 6001689.1464 | 2099734.32113 | 37.7455658790712 | -122.436865735875 | (37.7455658790712, -122.436865735875) | ||||
| 49183 | 49183 | 227263 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 743 Duncan St | 3 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6 | Width 4ft | 6001723.660019999 | 2099680.3247 | 37.7454195791479 | -122.436742528759 | (37.7454195791479, -122.436742528759) | |||
| 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) | |||
| 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) | |||
| 28015 | 28015 | 227442 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002319.53063 | 2104152.62296 | 37.7577332935784 | -122.435001901726 | (37.7577332935784, -122.435001901726) | |||
| 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) | ||||
| 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) | ||
| 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) | ||||
| 82832 | 82832 | 6003 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Eddy St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52927 | 6002410.467190799 | 2112668.0181364 | 37.7811196348904 | -122.43529649933501 | (37.7811196348904, -122.435296499335) | |
| 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) | |||
| 7129 | 7129 | 20204 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1315 Steiner St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6002765.7195 | 2112737.651 | 37.7813309972121 | -122.434072484072 | (37.7813309972121, -122.434072484072) | |||
| 33915 | 33915 | 98646 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 8 | 5x5 | 6002771.23879 | 2119243.65965 | 37.799195144410795 | -122.43451871576099 | (37.7991951444108, -122.434518715761) | ||
| 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) |
| 39732 | 39732 | 140575 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1221 McAllister St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 0ft | 6003289.1195 | 2111701.1038 | 37.7785145879996 | -122.43218773018499 | (37.7785145879996, -122.432187730185) | |||
| 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) | |||
| 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) | |||||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 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) | |||
| 49343 | 49343 | 227489 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 363 Waller St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 3ft | 6004002.39724 | 2109025.74245 | 37.7712091182481 | -122.42952938408199 | (37.7712091182481, -122.429529384082) | |||
| 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) | ||
| 32769 | 32769 | 226755 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 209 Day St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6004144.01902 | 2098653.98264 | 37.7427387360976 | -122.428300179912 | (37.7427387360976, -122.428300179912) | |||
| 2010 | 2010 | 142062 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1100 Golden Gate Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 01/02/2014 12:00:00 AM | 10 | Width 0ft | Permit Number 771276 | 6004214.4178 | 2112228.4 | 37.780014831771 | -122.429024376887 | (37.780014831771, -122.429024376887) | |
| 69900 | 69900 | 141422 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 IVY ST | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 6004543.5906 | 2111042.8919 | 37.7767783457628 | -122.42780112527001 | (37.7767783457628, -122.42780112527) | |||
| 96962 | 96962 | 12285 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 803X Laguna St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 4X4 | 6004627.99576 | 2111737.28964 | 37.7786897656705 | -122.427558625827 | (37.7786897656705, -122.427558625827) | |||
| 64260 | 64260 | 226666 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 201 Buchanan St | 3 | : 4 | Tree 1 | Private 1 | 3 | Width 3ft | 6004707.88321 | 2109244.5049400004 | 37.771849706222504 | -122.42710466345899 | (37.7718497062225, -122.427104663459) |
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");