Data source: data.sfgov.org
This data as json, CSV (advanced)
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord ▼ | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7848 | 7848 | 51578 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/04/2005 12:00:00 AM | Permit Number 47872 | |||||||||
| 10202 | 10202 | 173900 | Private 5 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 10204 | 10204 | 173902 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 601x Hearst Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | ||||||||||
| 12636 | 12636 | 99746 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 4250 Clipper St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | |||||||||
| 185883 | 185883 | 67262 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 511 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 6 | Permit Number 30729 | 5981280.933019999 | 2112230.5095 | 37.7786957851972 | -122.508360365452 | (37.7786957851972, -122.508360365452) | |
| 171311 | 171311 | 67223 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 555 47th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/26/1992 12:00:00 AM | 6 | Permit Number 30682 | 5981290.9854 | 2111950.9362 | 37.7779287520405 | -122.508304833393 | (37.7779287520405, -122.508304833393) | |
| 70184 | 70184 | 67244 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 5524 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/08/1992 12:00:00 AM | 7 | Permit Number 30708 | 5981494.88729 | 2111682.33433 | 37.7772032645806 | -122.50757954173599 | (37.7772032645806, -122.507579541736) | |
| 70732 | 70732 | 46972 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1686 44th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44991 | 5982549.0126 | 2103652.333 | 37.755217228081996 | -122.50333832645 | (37.755217228082, -122.50333832645) | |
| 50486 | 50486 | 46971 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1686 44th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/2002 12:00:00 AM | 2 | Permit Number 44991 | 5982549.6238 | 2103640.11 | 37.7551837030962 | -122.50333530778 | (37.7551837030962, -122.50333530778) | |
| 56852 | 56852 | 183625 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1431 41st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5983375.6866 | 2105398.8736 | 37.7600612994594 | -122.50060862808701 | (37.7600612994594, -122.500608628087) | |||
| 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) | |||
| 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) | |||
| 19637 | 19637 | 100232 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701X 39th Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | 3x3 | 5983809.619390001 | 2110917.38856 | 37.775239033091104 | -122.499515726535 | (37.7752390330911, -122.499515726535) | |||
| 154101 | 154101 | 62594 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 735 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 9 | Permit Number 22900 | 5984433.86075 | 2110817.8986299997 | 37.7750024687546 | -122.497349020618 | (37.7750024687546, -122.497349020618) | |
| 159008 | 159008 | 62593 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 731 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 9 | Permit Number 22899 | 5984434.98291 | 2110845.2368799997 | 37.7750775975018 | -122.49734715750401 | (37.7750775975018, -122.497347157504) | |
| 121186 | 121186 | 62592 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 763 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | Permit Number 22898 | 5984437.65774708 | 2110651.26442232 | 37.7745451616246 | -122.497323582278 | (37.7745451616246, -122.497323582278) | ||
| 64603 | 64603 | 62591 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 759 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 9 | Permit Number 22897 | 5984439.68457 | 2110661.64848 | 37.774573792054795 | -122.497317337939 | (37.7745737920548, -122.497317337939) | |
| 75651 | 75651 | 118275 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 763 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5984440.01732 | 2110639.37608 | 37.7745126579414 | -122.497314542381 | (37.7745126579414, -122.497314542381) | |||
| 41938 | 41938 | 62597 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 765 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/22/1986 12:00:00 AM | 7 | Permit Number 22903 | 5984441.0146 | 2110622.99108 | 37.7744677278845 | -122.49730988283301 | (37.7744677278845, -122.497309882833) | |
| 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) | |||
| 26884 | 26884 | 54531 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 855 37th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/31/1972 12:00:00 AM | 12 | Permit Number 10326 | 5984466.31691 | 2110015.99536 | 37.7728025745037 | -122.497177542996 | (37.7728025745037, -122.497177542996) | ||
| 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) | |||
| 172508 | 172508 | 182848 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1795 33rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5985939.7457 | 2103040.5574 | 37.7537362025059 | -122.491567304651 | (37.7537362025059, -122.491567304651) | |||
| 65846 | 65846 | 37203 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1574 32nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1998 12:00:00 AM | 5 | Permit Number 39770 | 5986243.4033 | 2104539.0139 | 37.7578682946863 | -122.49062744276699 | (37.7578682946863, -122.490627442767) | |
| 130474 | 130474 | 119507 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 725 31st Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 1ft | 5986293.694519999 | 2110943.52758 | 37.7754562387381 | -122.49092478893101 | (37.7754562387381, -122.490924788931) | |||
| 151314 | 151314 | 119942 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 346 30th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5986553.230140001 | 2113597.32948 | 37.7827579817147 | -122.490222261455 | (37.7827579817147, -122.490222261455) | |||
| 180317 | 180317 | 185606 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2123 29th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 2 | Width 0ft | 5987259.0828 | 2100808.0996 | 37.7476834885004 | -122.48684086956699 | (37.7476834885004, -122.486840869567) | |||
| 179715 | 179715 | 120187 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 218 26th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5987760.31768 | 2114496.30361 | 37.7852967290916 | -122.486112314519 | (37.7852967290916, -122.486112314519) | |||
| 148718 | 148718 | 59149 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 218 26th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1980 12:00:00 AM | 7 | Permit Number 18458 | 5987761.12595 | 2114471.82373 | 37.7852295614332 | -122.48610772054501 | (37.7852295614332, -122.486107720545) | ||
| 175991 | 175991 | 101635 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1800X 27th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5987855.0174 | 2102962.611 | 37.753633925344296 | -122.484938226474 | (37.7536339253443, -122.484938226474) | |||
| 33362 | 33362 | 55257 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 810 25th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/18/1972 12:00:00 AM | 5 | Permit Number 11179 | 5988221.44369 | 2110421.88962 | 37.7741363990758 | -122.48421806494801 | (37.7741363990758, -122.484218064948) | ||
| 58329 | 58329 | 120302 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 361 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 2ft | 5988369.83373 | 2113569.61422 | 37.7827878063085 | -122.483935624743 | (37.7827878063085, -122.483935624743) | |||
| 177288 | 177288 | 101277 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2323 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5988481.6146 | 2106443.4757 | 37.7632279152074 | -122.48302644728001 | (37.7632279152074, -122.48302644728) | |||
| 154151 | 154151 | 101278 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2323 Irving St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | 3x3 | 5988527.6084 | 2106443.4757 | 37.763230591454395 | -122.482867371906 | (37.7632305914544, -122.482867371906) | |||
| 11487 | 11487 | 110355 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2300 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5988563.2444 | 2106497.4984 | 37.763380996470005 | -122.482748079472 | (37.76338099647, -122.482748079472) | |||
| 124121 | 124121 | 12823 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2201 Lake St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/05/2007 12:00:00 AM | 3 | 5 | 5988577.51702 | 2114639.82314 | 37.785738385289896 | -122.483295611932 | (37.7857383852899, -122.483295611932) | ||
| 32562 | 32562 | 183926 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Quintara St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988583.1369 | 2101004.688 | 37.7483003735732 | -122.482276819356 | (37.7483003735732, -122.482276819356) | |||
| 149295 | 149295 | 120400 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 163 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5988653.91402 | 2114240.5156099997 | 37.7846464457785 | -122.483002026322 | (37.7846464457785, -122.483002026322) | |||
| 29382 | 29382 | 183930 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Quintara St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 0ft | 5988704.6498 | 2101009.2638 | 37.748320004874 | -122.48185697108299 | (37.748320004874, -122.481856971083) | |||
| 66400 | 66400 | 183931 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1595 Quintara St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | Width 0ft | 5988739.7309 | 2101009.2638 | 37.748322044963395 | -122.48173566297301 | (37.7483220449634, -122.481735662973) | |||
| 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) | ||
| 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) | ||
| 44679 | 44679 | 101107 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1790 24th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | 3X3 | Permit Number 14067 | 5988779.1453 | 2103160.9003 | 37.7542321578078 | -122.48175694812299 | (37.7542321578078, -122.481756948123) | ||
| 60756 | 60756 | 56836 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1790 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/02/1974 12:00:00 AM | 2 | 3X3 | Permit Number 14067 | 5988782.4304 | 2103136.262 | 37.7541646986668 | -122.48174378301701 | (37.7541646986668, -122.481743783017) | |
| 164311 | 164311 | 181320 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2130 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 0ft | 5989076.012999999 | 2106520.0924 | 37.7634728536567 | -122.48097625438999 | (37.7634728536567, -122.48097625439) | |||
| 99192 | 99192 | 101266 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2126 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989175.0 | 2106519.0 | 37.7634756077712 | -122.48063381405599 | (37.7634756077712, -122.480633814056) | ||||
| 26544 | 26544 | 101281 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2049 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 4 | 3x3 | 5989322.9543 | 2106470.5284 | 37.763351115778796 | -122.48011854571301 | (37.7633511157788, -122.480118545713) | |||
| 151635 | 151635 | 101284 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2034 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3x3 | 5989388.4992 | 2106533.1127 | 37.7635267635243 | -122.479896429915 | (37.7635267635243, -122.479896429915) | |||
| 107084 | 107084 | 101265 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2034 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989459.10715 | 2106523.8610900003 | 37.7635054630097 | -122.47965154526001 | (37.7635054630097, -122.47965154526) | ||||
| 57258 | 57258 | 61503 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 174 20th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/02/1986 12:00:00 AM | 8 | Permit Number 23383 | 5989631.93083 | 2114222.6944 | 37.784654374553206 | -122.479617149177 | (37.7846543745532, -122.479617149177) | |
| 34167 | 34167 | 181337 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1943 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5 | Width 0ft | 5989659.6191 | 2106483.3237 | 37.7634058040829 | -122.478955080908 | (37.7634058040829, -122.478955080908) | |||
| 10520 | 10520 | 95069 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1924 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 5989718.6012 | 2106543.0694 | 37.7635732745448 | -122.478755452983 | (37.7635732745448, -122.478755452983) | ||||
| 145747 | 145747 | 101261 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1945 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5989742.0 | 2106485.0 | 37.763415190264894 | -122.478670277794 | (37.7634151902649, -122.478670277794) | ||||
| 60829 | 60829 | 101260 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1900 Irving St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3x3 | 5989805.9135 | 2106546.133 | 37.7635867556905 | -122.47845369468399 | (37.7635867556905, -122.478453694684) | |||
| 63108 | 63108 | 56420 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 231 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 7 | Permit Number 12580 | 5990219.564180001 | 2113818.4640099998 | 37.783578588527796 | -122.47755460021799 | (37.7835785885278, -122.477554600218) | ||
| 178868 | 178868 | 56417 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 222 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 10 | Permit Number 12577 | 5990267.02613 | 2113888.22786 | 37.783772894624 | -122.47739550229299 | (37.783772894624, -122.477395502293) | ||
| 132975 | 132975 | 56418 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 226 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 9 | Permit Number 12578 | 5990267.28978 | 2113858.89022 | 37.783692356954205 | -122.477392445306 | (37.7836923569542, -122.477392445306) | ||
| 165885 | 165885 | 56421 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 232 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1973 12:00:00 AM | 12 | 5x5 | Permit Number 12581 | 5990270.934780001 | 2113836.22748 | 37.7836303428936 | -122.47737817827 | (37.7836303428936, -122.47737817827) | |
| 33941 | 33941 | 40560 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 458 18th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/06/1999 12:00:00 AM | 7 | Permit Number 41604 | 5990324.44539 | 2112242.31069 | 37.779256995112 | -122.47707654197399 | (37.779256995112, -122.477076541974) | |
| 74160 | 74160 | 122271 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1600 Balboa St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10 | Width 3ft | 5990587.5386 | 2111332.78753 | 37.776774954972204 | -122.476099955577 | (37.7767749549722, -122.476099955577) | |||
| 135631 | 135631 | 122270 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1600 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5990596.49847 | 2111330.4876599996 | 37.7767691597055 | -122.47606879302 | (37.7767691597055, -122.47606879302) | |||
| 41939 | 41939 | 207892 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2119 18th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | Width 3ft | 5990666.05125 | 2100929.33737 | 37.7482144184726 | -122.47506873135299 | (37.7482144184726, -122.475068731353) | |||
| 158754 | 158754 | 67388 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 779 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/1992 12:00:00 AM | 12 | Permit Number 30885 | 5990666.23465 | 2110099.72843 | 37.7733938754744 | -122.475737660544 | (37.7733938754744, -122.475737660544) | |
| 118589 | 118589 | 34242 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 1263 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/1997 12:00:00 AM | Permit Number 38052 | 5990773.84225381 | 2106807.51859079 | 37.7643605962692 | -122.47512505139099 | (37.7643605962692, -122.475125051391) | |||
| 164052 | 164052 | 55004 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 585 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 9 | Permit Number 10882 | 5990928.49024 | 2111392.95682 | 37.7769599278948 | -122.474924907094 | (37.7769599278948, -122.474924907094) | ||
| 170030 | 170030 | 122095 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 585 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 4ft | 5990929.30413 | 2111377.25898 | 37.776916873099 | -122.474920945501 | (37.776916873099, -122.474920945501) | |||
| 150383 | 150383 | 56174 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 701 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 9 | Permit Number 12282 | 5990956.32694 | 2110582.1012 | 37.774735153466295 | -122.474769414984 | (37.7747351534663, -122.474769414984) | ||
| 136063 | 136063 | 122093 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 701 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5990957.61701 | 2110561.8313599997 | 37.774679572778204 | -122.474763472642 | (37.7746795727782, -122.474763472642) | |||
| 187706 | 187706 | 55001 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 546 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/12/1972 12:00:00 AM | 12 | Permit Number 10879 | 5990967.23553 | 2111663.9992 | 37.777706381155205 | -122.474810664746 | (37.7777063811552, -122.474810664746) | ||
| 172427 | 172427 | 56173 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 680 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/03/1973 12:00:00 AM | 9 | Permit Number 12281 | 5990998.5556 | 2110774.78809 | 37.7752666659576 | -122.474637404879 | (37.7752666659576, -122.474637404879) | ||
| 70555 | 70555 | 102084 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 201 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/09/2009 12:00:00 AM | 1 | 3x3 | Permit Number 52515 | 5991161.35766 | 2114023.19945 | 37.7841953413 | -122.474311334384 | (37.7841953413, -122.474311334384) |
| 157271 | 157271 | 121996 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 626 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 13 | Width 3ft | 5991310.915630001 | 2111122.21398 | 37.776238696818204 | -122.473582239238 | (37.7762386968182, -122.473582239238) | |||
| 67680 | 67680 | 121997 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 634 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11 | Width 3ft | 5991314.5458 | 2111079.72567 | 37.776122245754706 | -122.47356658162501 | (37.7761222457547, -122.473566581625) | |||
| 161344 | 161344 | 207398 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 160 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991337.5246 | 2104227.06806 | 37.7573080176715 | -122.472987263976 | (37.7573080176715, -122.472987263976) | |||
| 137697 | 137697 | 207399 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 154 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991342.55523 | 2104236.58133 | 37.7573344298491 | -122.47297055996401 | (37.7573344298491, -122.472970559964) | |||
| 72400 | 72400 | 207400 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 148 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991365.09994 | 2104283.83195 | 37.757465472780105 | -122.472896037642 | (37.7574654727801, -122.472896037642) | |||
| 76570 | 76570 | 207401 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 142 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991370.5253800005 | 2104294.44691 | 37.757494932750504 | -122.472878048496 | (37.7574949327505, -122.472878048496) | |||
| 165959 | 165959 | 207402 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 136 Lomita Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991386.74911 | 2104341.46071 | 37.7576249594532 | -122.472825368893 | (37.7576249594532, -122.472825368893) | |||
| 64682 | 64682 | 207404 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2692 16th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991464.58809 | 2097102.41328 | 37.737752914457396 | -122.472028548874 | (37.7377529144574, -122.472028548874) | |||
| 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) | |||
| 181511 | 181511 | 207403 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2692 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991464.82157 | 2097093.68289 | 37.7377289565351 | -122.472027105478 | (37.7377289565351, -122.472027105478) | |||
| 66231 | 66231 | 207904 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991482.67128 | 2097068.4954400002 | 37.737660831087496 | -122.47196355577299 | (37.7376608310875, -122.471963555773) | |||
| 56238 | 56238 | 207903 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991490.36095 | 2097069.60585 | 37.7376643249521 | -122.471937050068 | (37.7376643249521, -122.471937050068) | |||
| 172407 | 172407 | 207902 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991496.246809999 | 2097069.9907900002 | 37.7376657224794 | -122.471916728076 | (37.7376657224794, -122.471916728076) | |||
| 182238 | 182238 | 207901 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991520.05038 | 2097071.77928 | 37.73767201055411 | -122.47183455883801 | (37.7376720105541, -122.471834558838) | |||
| 166541 | 166541 | 207900 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3 | Width 3ft | 5991529.51733 | 2097072.3432599998 | 37.737674106866 | -122.471801868461 | (37.737674106866, -122.471801868461) | |||
| 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) | |||
| 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) | |||
| 157262 | 157262 | 207897 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991557.6312 | 2097072.51432 | 37.7376762031927 | -122.471704678736 | (37.7376762031927, -122.471704678736) | |||
| 73012 | 73012 | 207896 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 450 Wawona St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 1 | Width 3ft | 5991566.326830001 | 2097072.84008 | 37.7376776007508 | -122.471674637797 | (37.7376776007508, -122.471674637797) | |||
| 132402 | 132402 | 207893 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 509 Taraval St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 8 | Width 3ft | 5991609.8871 | 2099055.22647 | 37.7431232484418 | -122.47166845315701 | (37.7431232484418, -122.471668453157) | |||
| 153350 | 153350 | 207894 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2405 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991680.0958 | 2099028.04696 | 37.743052682242606 | -122.471423712548 | (37.7430526822426, -122.471423712548) | |||
| 171151 | 171151 | 207895 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2405 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991680.9977 | 2099010.21605 | 37.7430037753042 | -122.47141929508801 | (37.7430037753042, -122.471419295088) | |||
| 133387 | 133387 | 207891 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1585 15th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991719.11212 | 2104563.20896 | 37.7582530567451 | -122.471692092715 | (37.7582530567451, -122.471692092715) | |||
| 77315 | 77315 | 207890 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1585 15th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 7 | Width 3ft | 5991722.660569999 | 2104556.3453900004 | 37.7582344164913 | -122.47167932056999 | (37.7582344164913, -122.47167932057) | |||
| 64994 | 64994 | 207926 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1630 Portola Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | Width 3ft | 5991910.04045 | 2096405.2401 | 37.7358644199941 | -122.470437659868 | (37.7358644199941, -122.470437659868) | |||
| 188748 | 188748 | 207927 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 1630 Portola Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 15 | Width 3ft | 5991926.85515 | 2096424.2337 | 37.7359175438479 | -122.470380908151 | (37.7359175438479, -122.470380908151) | |||
| 146067 | 146067 | 92919 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 362 West Portal Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 5991957.0 | 2096928.0 | 37.7373025018195 | -122.47031336115101 | (37.7373025018195, -122.470313361151) | ||||
| 89336 | 89336 | 68787 | Permitted Site 1 | Ligustrum lucidum :: Glossy Privet 55 | 2319 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32724 | 5991980.95842416 | 2099649.38115823 | 37.74477610705139 | -122.470428661516 | (37.7447761070514, -122.470428661516) | ||
| 163646 | 163646 | 207905 | Undocumented 2 | Ligustrum lucidum :: Glossy Privet 55 | 2319 14th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | Width 3ft | 5991984.0362 | 2099641.46865 | 37.744754559288104 | -122.470417443113 | (37.7447545592881, -122.470417443113) |
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");