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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 188541 | 188541 | 191491 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 190 09th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6008660.87674 | 2110356.51617 | 37.7751257709745 | -122.41350959771299 | (37.7751257709745, -122.413509597713) | |||
| 187447 | 187447 | 129666 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2208 Powell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 6009347.64919 | 2121645.06555 | 37.806159927791 | -122.41193178303101 | (37.806159927791, -122.411931783031) | |||
| 187155 | 187155 | 227443 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6002302.88704 | 2104151.22566 | 37.7577285118836 | -122.43505936211099 | (37.7577285118836, -122.435059362111) | |||
| 185550 | 185550 | 227343 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3915 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 6008417.48534 | 2096717.53633 | 37.737662563174 | -122.41338678718901 | (37.737662563174, -122.413386787189) | |||
| 184221 | 184221 | 227217 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 775 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6009108.8338 | 2104653.1063200003 | 37.7594906686717 | -122.411556961793 | (37.7594906686717, -122.411556961793) | |||
| 183840 | 183840 | 226751 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 188 Buchanan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 4ft | 6004780.64342 | 2109066.90336 | 37.7713661695481 | -122.42684033024099 | (37.7713661695481, -122.426840330241) | |||
| 183703 | 183703 | 227267 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 739 27th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 7ft | 6001720.54184 | 2099972.41794 | 37.7462214209976 | -122.436774216378 | (37.7462214209976, -122.436774216378) | |||
| 181849 | 181849 | 227282 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4412 23rd St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 5ft | 6000544.37543 | 2102304.8503 | 37.7525588049644 | -122.441008545612 | (37.7525588049644, -122.441008545612) | |||
| 181157 | 181157 | 208009 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 126 Edna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 2ft | 5998765.79191 | 2093418.2153900003 | 37.72805677307979 | -122.446519879783 | (37.7280567730798, -122.446519879783) | |||
| 181081 | 181081 | 227190 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1132 Shrader St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5997735.89415 | 2106562.64297 | 37.764089274613205 | -122.45102771536502 | (37.7640892746132, -122.451027715365) | |||
| 179911 | 179911 | 38634 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Shafter Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/16/2011 12:00:00 AM | 16 | Permit Number 767658 | 6014976.9663 | 2094092.323 | 37.7308203704303 | -122.390523948894 | (37.7308203704303, -122.390523948894) | |
| 177377 | 177377 | 226688 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1298 Vermont St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 6ft | 6011388.93256 | 2102376.14008 | 37.7533662558597 | -122.40351101253599 | (37.7533662558597, -122.403511012536) | |||
| 176368 | 176368 | 227427 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4681 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 6000761.80994 | 2104640.69389 | 37.7589848459033 | -122.44042413199101 | (37.7589848459033, -122.440424131991) | |||
| 175820 | 175820 | 207921 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1475 Monterey Blvd | 4 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 2 | Width 3ft | 5993566.43334 | 2095078.40606 | 37.7323168967005 | -122.46461458559999 | (37.7323168967005, -122.4646145856) | |||
| 175359 | 175359 | 207915 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Pacheco St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 4ft | 5994699.757 | 2099675.96416 | 37.7450059233763 | -122.461029567757 | (37.7450059233763, -122.461029567757) | |||
| 169925 | 169925 | 226756 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 209 Day St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 5ft | 6004170.543190001 | 2098656.13064 | 37.7427461348209 | -122.42820861993799 | (37.7427461348209, -122.428208619938) | |||
| 169910 | 169910 | 227184 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 833 Ashbury St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 4ft | 5999116.932080001 | 2107411.40192 | 37.766498722059204 | -122.446312187656 | (37.7664987220592, -122.446312187656) | |||
| 169484 | 169484 | 113963 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Rhode Island St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/16/2015 12:00:00 AM | 8 | 3x3 | 6011667.06303 | 2107250.9758099997 | 37.7667670024209 | -122.402892005557 | (37.7667670024209, -122.402892005557) | ||
| 168368 | 168368 | 227422 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4611 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6000625.69214 | 2104640.24326 | 37.758975857154496 | -122.440894857831 | (37.7589758571545, -122.440894857831) | |||
| 168157 | 168157 | 101109 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1790 24th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3X3 | Permit Number 14067 | 5988776.9552 | 2103216.747 | 37.754385370533704 | -122.48176861229099 | (37.7543853705337, -122.481768612291) | ||
| 166208 | 166208 | 207899 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991539.23475 | 2097072.6474799998 | 37.737675504425795 | -122.47176829317101 | (37.7376755044258, -122.471768293171) | |||
| 161870 | 161870 | 98647 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2110 Greenwich St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 12 | 5x5 | 6002751.94545 | 2119240.19821 | 37.7991845449763 | -122.434585229619 | (37.7991845449763, -122.434585229619) | ||
| 161457 | 161457 | 207908 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Wawona St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 5992548.53449 | 2097821.47012 | 37.739789928349 | -122.46833315276301 | (37.739789928349, -122.468333152763) | |||
| 160832 | 160832 | 177043 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 87 Seneca Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 1ft | 6000241.05575 | 2089872.3479 | 37.7184047866172 | -122.441165561868 | (37.7184047866172, -122.441165561868) | |||
| 159816 | 159816 | 208005 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 551 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 10ft | 5998445.88865 | 2094954.90573 | 37.7322578849907 | -122.447736370247 | (37.7322578849907, -122.447736370247) | |||
| 159520 | 159520 | 227235 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3591 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6006415.25299 | 2104336.0172200003 | 37.7584685576864 | -122.42085019969801 | (37.7584685576864, -122.420850199698) | |||
| 157800 | 157800 | 227365 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 176 Shotwell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 6008045.892659999 | 2101114.02966 | 37.7497134875938 | -122.41498265482599 | (37.7497134875938, -122.414982654826) | |||
| 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) | |||
| 156713 | 156713 | 177062 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 550 Geneva Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 5ft | 5999011.63296 | 2090530.40369 | 37.720141550179896 | -122.44546243984199 | (37.7201415501799, -122.445462439842) | |||
| 155465 | 155465 | 227515 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1175 Stevenson St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 2ft | 6006475.3834 | 2109601.81722 | 37.7729305914948 | -122.42101612099701 | (37.7729305914948, -122.421016120997) | |||
| 155356 | 155356 | 101145 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Connecticut St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 2x2 | 6013204.93498 | 2104939.92488 | 37.7605071193183 | -122.397410636789 | (37.7605071193183, -122.397410636789) | |||
| 153989 | 153989 | 207834 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 112 Marston Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 2ft | 5998700.55085 | 2093216.8077 | 37.7275000279916 | -122.446730933593 | (37.7275000279916, -122.446730933593) | |||
| 151650 | 151650 | 226670 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 298 Alabama St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 6008867.09497 | 2106908.52586 | 37.765669970714704 | -122.412552451952 | (37.7656699707147, -122.412552451952) | |||
| 149576 | 149576 | 177053 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 765 Delano Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 5 | Width 10ft | 5998955.229780001 | 2090176.99773 | 37.719167958508 | -122.445632005212 | (37.719167958508, -122.445632005212) | |||
| 149329 | 149329 | 207836 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 100 De Montfort Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 2 | Width 3ft | 5995005.14377 | 2091917.0493299998 | 37.7237194121086 | -122.459411800719 | (37.7237194121086, -122.459411800719) | |||
| 148880 | 148880 | 123766 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 773 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5993235.861169999 | 2110685.0962099996 | 37.7751497787963 | -122.466891596882 | (37.7751497787963, -122.466891596882) | |||
| 148184 | 148184 | 123769 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 801 Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5993062.81388 | 2110680.4895599997 | 37.7751271410654 | -122.46748986588499 | (37.7751271410654, -122.467489865885) | |||
| 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) | |||
| 144635 | 144635 | 20278 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2291 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6009755.789969999 | 2121736.88906 | 37.8064349417299 | -122.410525825802 | (37.8064349417299, -122.410525825802) | |||
| 144344 | 144344 | 99682 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 165 Grattan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 5997880.8 | 2106478.8 | 37.7638673579207 | -122.45052048585899 | (37.7638673579207, -122.450520485859) | ||
| 143379 | 143379 | 20268 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2211 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 2X2 | 6009744.4688 | 2121738.42252 | 37.8064385175351 | -122.41056511327 | (37.8064385175351, -122.41056511327) | |||
| 137087 | 137087 | 227164 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 165 Grattan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 4ft | 5997856.90065 | 2106470.54587 | 37.7638433262424 | -122.45060255097 | (37.7638433262424, -122.45060255097) | |||
| 132468 | 132468 | 191449 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1224 Fairfax Ave | 4 | : 4 | Tree 1 | Private 1 | 4 | Width 4ft | 6017403.85827 | 2096904.38167 | 37.7386760604628 | -122.382329276794 | (37.7386760604628, -122.382329276794) | |||
| 131957 | 131957 | 227491 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1893 Church St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 14 | Width 4ft | 6004617.88514 | 2097640.41879 | 37.7399825226668 | -122.42658952729099 | (37.7399825226668, -122.426589527291) | |||
| 131196 | 131196 | 207959 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 70 Woodside Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5995748.658340001 | 2100247.6965 | 37.7466360605992 | -122.45744403462 | (37.7466360605992, -122.45744403462) | |||
| 130319 | 130319 | 227276 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 91 Gold Mine Dr | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 3ft | 6001604.247 | 2099100.29306 | 37.743820161875796 | -122.437113918188 | (37.7438201618758, -122.437113918188) | |||
| 127620 | 127620 | 102189 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3999X Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 3 | 3x3 | 6008408.0 | 2096514.0 | 37.7371031642446 | -122.41340519256 | (37.7371031642446, -122.41340519256) | ||
| 125454 | 125454 | 12207 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1365X La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6016707.244956 | 2094751.5031778 | 37.7327261850679 | -122.38458793904199 | (37.7327261850679, -122.384587939042) | |||
| 124552 | 124552 | 33770 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101 20th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 37819 | 6009092.65010174 | 2104478.80438725 | 37.759011167375796 | -122.41160061802 | (37.7590111673758, -122.41160061802) | ||||
| 123443 | 123443 | 191504 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2 Baldwin Ct | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | Width 4ft | 6017862.18303 | 2093613.8535 | 37.7296662241092 | -122.38051594408 | (37.7296662241092, -122.38051594408) | |||
| 121210 | 121210 | 111020 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 90x DOWNEY ST | 4 | 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) | |||
| 120775 | 120775 | 89035 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 272 Main St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | Permit Number 51778 | 6014884.0 | 2115520.0 | 37.7896509872655 | -122.392343484767 | (37.7896509872655, -122.392343484767) | |||
| 118133 | 118133 | 73874 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450X Banks St | 4 | 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) | |
| 117586 | 117586 | 11438 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 2100X FRANKLIN ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 6 | 3X3 | 6005630.0 | 2117242.0 | 37.79386095938629 | -122.424483955414 | (37.7938609593863, -122.424483955414) | |||
| 114565 | 114565 | 92634 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1680 Eddy St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/22/2009 12:00:00 AM | 3x3 | Permit Number 52927 | 6002403.9 | 2112682.2 | 37.7811582017665 | -122.435320233246 | (37.7811582017665, -122.435320233246) | ||
| 113858 | 113858 | 20273 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2290 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6009846.48172 | 2121764.7141400003 | 37.8065164263834 | -122.41021393510599 | (37.8065164263834, -122.410213935106) | |||
| 111912 | 111912 | 246237 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 96 Delmar St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 0ft | 5999342.4520000005 | 2107821.6903 | 37.7676381481281 | -122.445561664053 | (37.7676381481281, -122.445561664053) | |||
| 110687 | 110687 | 12310 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 949 Laguna St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 03/16/1993 12:00:00 AM | 6 | 4X4 | 6004809.18722 | 2111991.6762900003 | 37.7793984956931 | -122.426949936516 | (37.7793984956931, -122.426949936516) | ||
| 108302 | 108302 | 107956 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2299X 25TH ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6012136.0 | 2101880.0 | 37.752045663585896 | -122.400892625965 | (37.7520456635859, -122.400892625965) | ||||
| 107186 | 107186 | 103604 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 100X Buchanan St | 4 | 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) | ||
| 105778 | 105778 | 105876 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2X 27th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6006029.156359999 | 2100240.43464 | 37.7472012619439 | -122.421894571047 | (37.7472012619439, -122.421894571047) | ||||
| 103677 | 103677 | 25292 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 136 Ocean Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6000743.1124599995 | 2091772.81119 | 37.7236516133979 | -122.439566330441 | (37.7236516133979, -122.439566330441) | |||
| 100122 | 100122 | 26530 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2701x Harrison St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 6008955.0644 | 2102702.28881 | 37.7541255388196 | -122.41195091510001 | (37.7541255388196, -122.4119509151) | |||
| 99391 | 99391 | 17145 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1030 Oakdale Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12/31/1992 12:00:00 AM | 6 | 3X3 | 6018053.0176703 | 2093253.3980264 | 37.7286870123052 | -122.37983116682699 | (37.7286870123052, -122.379831166827) | ||
| 97712 | 97712 | 93119 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1555 Hayes St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 3x3 | 6000421.0 | 2110261.0 | 37.774397395284 | -122.44200622209299 | (37.774397395284, -122.442006222093) | |||
| 97647 | 97647 | 27658 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 1698X Mission St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 12 | 3X3 | 6006725.5802 | 2108585.93757 | 37.7701553284346 | -122.420078550817 | (37.7701553284346, -122.420078550817) | |||
| 96430 | 96430 | 115659 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1499X HAYES ST | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | 3x3 | 6000749.0 | 2110266.0 | 37.7744298099173 | -122.440871970116 | (37.7744298099173, -122.440871970116) | |||
| 96040 | 96040 | 37259 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 4200 20th St | 4 | 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) | ||
| 93915 | 93915 | 34045 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 298 Alabama St | 4 | 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) | ||
| 88992 | 88992 | 98678 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 199X Park St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 6006189.1 | 2096374.1 | 37.736594195559505 | -122.421067016387 | (37.7365941955595, -122.421067016387) | ||||
| 87823 | 87823 | 20263 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2210 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/29/2005 12:00:00 AM | 3 | 2X2 | 6009835.16022 | 2121766.2476 | 37.806520002274 | -122.410253223744 | (37.806520002274, -122.410253223744) | ||
| 86964 | 86964 | 113437 | DPW Maintained 3 | Ligustrum lucidum :: Glossy Privet 55 | 198x HIGHLAND AVE | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | 4x4 | 6006173.0 | 2096415.0 | 37.73670559026029 | -122.421125584355 | (37.7367055902603, -122.421125584355) | ||||
| 83821 | 83821 | 114799 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 103 Grattan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5998130.990703201 | 2106502.59817932 | 37.7639470183873 | -122.44965687078998 | (37.7639470183873, -122.44965687079) | ||||
| 82923 | 82923 | 92842 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3440 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/28/2009 12:00:00 AM | 3x3 | 6006883.0 | 2101475.0 | 37.7506392147773 | -122.419029591774 | (37.7506392147773, -122.419029591774) | |||
| 76604 | 76604 | 207995 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 395 Joost Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 10ft | 5999470.3608 | 2094946.2688099998 | 37.7322926698604 | -122.44419392902799 | (37.7322926698604, -122.444193929028) | |||
| 76026 | 76026 | 96009 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 999 California St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/2011 12:00:00 AM | 3 | 3x3 | Permit Number 767660 | 6009716.9001400005 | 2116412.09513 | 37.7918121879409 | -122.41028421245701 | (37.7918121879409, -122.410284212457) |
| 73429 | 73429 | 34690 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 3101X Webster St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW 4 | 07/28/1997 12:00:00 AM | 8 | 3x3 | Permit Number 38352 | 6002819.05677 | 2119313.26082 | 37.7993889653989 | -122.434358228162 | (37.7993889653989, -122.434358228162) |
| 70355 | 70355 | 191497 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1198 La Salle Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 4ft | 6016662.8976 | 2094787.97273 | 37.7328238706214 | -122.384743799985 | (37.7328238706214, -122.384743799985) | |||
| 70070 | 70070 | 227378 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3440 25th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 6006846.58605 | 2101476.05301 | 37.7506400554955 | -122.419155589162 | (37.7506400554955, -122.419155589162) | |||
| 68444 | 68444 | 184122 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 3340 Lawton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983807.3681 | 2104294.0393 | 37.7570530669968 | -122.49903404016001 | (37.7570530669968, -122.49903404016) | |||
| 68366 | 68366 | 129656 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2135 Stockton St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 6009761.436430001 | 2121807.95495 | 37.80663038745121 | -122.410511306563 | (37.8066303874512, -122.410511306563) | |||
| 64168 | 64168 | 250111 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 200 Austin St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 2ft | 6006107.64961 | 2115425.94774 | 37.7889014952475 | -122.42270212321199 | (37.7889014952475, -122.422702123212) | |||
| 62185 | 62185 | 227290 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 685 29th St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | 6002218.42059 | 2098832.30166 | 37.7431192122842 | -122.434971090944 | (37.7431192122842, -122.434971090944) | ||||
| 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) | |||
| 60663 | 60663 | 114468 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2351 Powell St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 6009284.18017 | 2121746.40432 | 37.806434617621704 | -122.412158595669 | (37.8064346176217, -122.412158595669) | |||
| 60586 | 60586 | 207937 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 145 Ridgewood Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 3ft | 5996773.96274 | 2094591.1270299999 | 37.7311633363083 | -122.45349031003201 | (37.7311633363083, -122.453490310032) | |||
| 58525 | 58525 | 207855 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 494 Victoria St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 3 | Width 6ft | 5993274.09777 | 2090428.4072099999 | 37.719532280163 | -122.46528760316099 | (37.719532280163, -122.465287603161) | |||
| 55596 | 55596 | 138671 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1720 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 0ft | 5999595.6975 | 2114785.7218 | 37.7867740499686 | -122.44518646163601 | (37.7867740499686, -122.445186461636) | |||
| 54144 | 54144 | 120481 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 4 | Width 1ft | 5988593.25091 | 2114641.37666 | 37.7857435664695 | -122.48324129171101 | (37.7857435664695, -122.483241291711) | |||
| 53214 | 53214 | 227510 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 37 Brady St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 2ft | 6006532.91743 | 2109718.55388 | 37.773254365438596 | -122.420825392799 | (37.7732543654386, -122.420825392799) | |||
| 50894 | 50894 | 177115 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 34 Vienna St | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | Width 3ft | 6005069.55264 | 2093328.8991099999 | 37.7281695777432 | -122.424721208244 | (37.7281695777432, -122.424721208244) | |||
| 48603 | 48603 | 177091 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Santa Barbara Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 13 | Width 8ft | 5993412.52644 | 2086599.2418 | 37.709026289400796 | -122.46453122115801 | (37.7090262894008, -122.464531221158) | |||
| 48599 | 48599 | 227168 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 119 Grattan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5998108.05626 | 2106506.70041 | 37.76395696996121 | -122.44973648946001 | (37.7639569699612, -122.44973648946) | |||
| 46988 | 46988 | 116060 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2100x 19th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | SFUSD 4 | DPW for City Agency 2 | 7 | 3x3 | 6011408.71891 | 2105130.5396 | 37.7609303321981 | -122.403636370817 | (37.7609303321981, -122.403636370817) | ||
| 46741 | 46741 | 129579 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2434 Divisadero St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 3ft | 6000792.48835 | 2116759.0177599997 | 37.7922604469152 | -122.441187490011 | (37.7922604469152, -122.441187490011) | |||
| 46570 | 46570 | 226667 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 201 Buchanan St | 4 | : 4 | Tree 1 | Private 1 | 8 | Width 3ft | 6004704.0947199995 | 2109267.38309 | 37.7719123098365 | -122.42711939795 | (37.7719123098365, -122.42711939795) | |||
| 46096 | 46096 | 122133 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 15th Ave | 4 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 17 | 5991114.065719999 | 2115007.37065 | 37.7868948615896 | -122.474546795399 | (37.7868948615896, -122.474546795399) | ||||
| 40980 | 40980 | 245071 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 8 Lyon St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 6000404.0401 | 2108984.869 | 37.770892494718 | -122.44197327427901 | (37.770892494718, -122.441973274279) | |||
| 40802 | 40802 | 182830 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1811 34th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 0ft | 5985639.2314 | 2102838.2271 | 37.7531630922797 | -122.49259163632401 | (37.7531630922797, -122.492591636324) | |||
| 40077 | 40077 | 191470 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1 Jack London Aly | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 6014270.7643099995 | 2112702.62209 | 37.7818810438134 | -122.39426789834499 | (37.7818810438134, -122.394267898345) |
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");