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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 97705 | 97705 | 62343 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 14 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | Permit Number 22485 | 6005822.8575705 | 2099672.01958419 | 37.7456288871148 | -122.422567552448 | (37.7456288871148, -122.422567552448) | ||
| 97723 | 97723 | 40574 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 19 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 98778 | 98778 | 67011 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 319 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/20/1992 12:00:00 AM | Permit Number 30366 | 5995876.19861024 | 2091190.26348134 | 37.72177387546721 | -122.456348203392 | (37.7217738754672, -122.456348203392) | ||
| 98865 | 98865 | 38979 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2222 17th St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/17/1998 12:00:00 AM | Permit Number 40762 | 6010839.10372464 | 2106501.59245712 | 37.76466309906579 | -122.405703003871 | (37.7646630990658, -122.405703003871) | |||
| 99248 | 99248 | 62802 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1975 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23159 | 5999892.27432069 | 2092450.57844744 | 37.7254641444646 | -122.44255616077801 | (37.7254641444646, -122.442556160778) | ||
| 99289 | 99289 | 62804 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1999 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23161 | 5999778.16418017 | 2092287.72080324 | 37.725010469703896 | -122.442938938279 | (37.7250104697039, -122.442938938279) | ||
| 99577 | 99577 | 41627 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1095 Natoma St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | Permit Number 42109 | 6007646.45182189 | 2109473.56842462 | 37.7726443942379 | -122.416956155908 | (37.7726443942379, -122.416956155908) | |||
| 99834 | 99834 | 40859 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1670 Florida St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/21/2000 12:00:00 AM | Permit Number 42380 | 6009721.65724328 | 2100087.27684169 | 37.746988275084895 | -122.409115329349 | (37.7469882750849, -122.409115329349) | ||
| 99960 | 99960 | 34514 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1x GUY PL | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014462.0 | 2114376.0 | 37.7864863849761 | -122.393723467778 | (37.7864863849761, -122.393723467778) | |||
| 100813 | 100813 | 62237 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 61 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1985 12:00:00 AM | Permit Number 22363 | 6001374.44401127 | 2093790.00837779 | 37.7292262892939 | -122.437528318003 | (37.7292262892939, -122.437528318003) | ||
| 100932 | 100932 | 66607 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 100 Serrano Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1991 12:00:00 AM | 12 | Permit Number 29802 | 5989869.39246895 | 2090726.40504468 | 37.7201535727537 | -122.477078065149 | (37.7201535727537, -122.477078065149) | ||
| 101099 | 101099 | 51012 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 85 Buena Vista Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/29/2016 12:00:00 AM | 3 | Permit Number 778086 | 6001486.35916374 | 2107715.14620283 | 37.7674677672856 | -122.438138542404 | (37.7674677672856, -122.438138542404) | ||
| 101528 | 101528 | 62348 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 57 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | Permit Number 22491 | 6005543.85080152 | 2099604.02987317 | 37.745426458533004 | -122.42352748403799 | (37.745426458533, -122.423527484038) | ||
| 102317 | 102317 | 32425 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 275 Maywood Dr | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 36952 | 5994490.2461397005 | 2094811.13335462 | 37.7316362454296 | -122.461401406739 | (37.7316362454296, -122.461401406739) | ||||
| 102389 | 102389 | 30957 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
| 102531 | 102531 | 62344 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 16 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | Permit Number 22486 | 6005809.69914418 | 2099671.2694643 | 37.7456260851044 | -122.422612999068 | (37.7456260851044, -122.422612999068) | ||
| 102630 | 102630 | 94890 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 491 Frederick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 5997284.0 | 2107398.0 | 37.7663570704681 | -122.452650969879 | (37.7663570704681, -122.452650969879) | |||||
| 103250 | 103250 | 32424 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 275 Maywood Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 36952 | 5994490.2461397005 | 2094811.13335462 | 37.7316362454296 | -122.461401406739 | (37.7316362454296, -122.461401406739) | ||||
| 104144 | 104144 | 67758 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4394 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/25/1995 12:00:00 AM | Permit Number 31437 | 6001339.65304045 | 2101178.10506013 | 37.7495102967122 | -122.43817763611999 | (37.7495102967122, -122.43817763612) | ||
| 104206 | 104206 | 66239 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1023 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/24/1990 12:00:00 AM | Permit Number 29337 | 5995901.80991046 | 2090714.82365274 | 37.720469900548004 | -122.45622531376301 | (37.720469900548, -122.456225313763) | ||
| 104296 | 104296 | 46759 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1180X Bush St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44858 | 6007776.04474552 | 2115482.02501481 | 37.7891494581332 | -122.41693366292101 | (37.7891494581332, -122.416933662921) | |||
| 104653 | 104653 | 30945 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
| 104824 | 104824 | 67990 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 324 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31715 | 5995860.10496142 | 2091242.55276948 | 37.7219165255419 | -122.45640761373998 | (37.7219165255419, -122.45640761374) | ||
| 104953 | 104953 | 34513 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 18 Lansing St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | |||
| 104993 | 104993 | 71234 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 921 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/17/1989 12:00:00 AM | 6000521.03642361 | 2102545.13668815 | 37.753217243878495 | -122.44110649339301 | (37.7532172438785, -122.441106493393) | ||||
| 105147 | 105147 | 32286 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1800 Scott St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/15/1996 12:00:00 AM | Permit Number 36869 | 6001579.61916409 | 2114619.58179026 | 37.7864309126762 | -122.438310666952 | (37.7864309126762, -122.438310666952) | |||
| 106242 | 106242 | 30959 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2401 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34753 | 6002022.0507416995 | 2114644.40993289 | 37.7865242387809 | -122.436781745524 | (37.7865242387809, -122.436781745524) | ||
| 106261 | 106261 | 40584 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 16 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 106967 | 106967 | 33954 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Arbor St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/18/1999 12:00:00 AM | Permit Number 48991 | 6002287.323724099 | 2097040.91143479 | 37.7382043832783 | -122.43460477820899 | (37.7382043832783, -122.434604778209) | |||
| 108097 | 108097 | 40150 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 560X Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1999 12:00:00 AM | Permit Number 41343 | 5996910.70022428 | 2109465.35547876 | 37.772012099368204 | -122.454091465131 | (37.7720120993682, -122.454091465131) | |||
| 109087 | 109087 | 67802 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4022 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31449 | 6003744.51176452 | 2100434.22126683 | 37.7476042452744 | -122.429808512801 | (37.7476042452744, -122.429808512801) | ||
| 109554 | 109554 | 119661 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699x Missouri St | 2 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6013712.0 | 2104098.0 | 37.7582235960409 | -122.39559792996201 | (37.7582235960409, -122.395597929962) | |||||
| 109688 | 109688 | 34444 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 74 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38188 | 6004269.61043081 | 2097757.70943651 | 37.7402848805672 | -122.42780207260401 | (37.7402848805672, -122.427802072604) | ||
| 109737 | 109737 | 47778 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 872 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | Permit Number 45554 | 5999190.57637215 | 2107256.51251673 | 37.7660776404196 | -122.446046324392 | (37.7660776404196, -122.446046324392) | |||
| 110282 | 110282 | 40593 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 18 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 110371 | 110371 | 40595 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 23 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 110730 | 110730 | 30946 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 14 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
| 111007 | 111007 | 62345 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 21 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/14/1989 12:00:00 AM | Permit Number 27053 | 6005775.86880093 | 2099617.25647877 | 37.7454758690666 | -122.42272614169201 | (37.7454758690666, -122.422726141692) | ||
| 111072 | 111072 | 34510 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 18 Lansing St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | |||
| 111494 | 111494 | 46758 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1180X Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/24/2002 12:00:00 AM | Permit Number 44858 | 6007776.04474552 | 2115482.02501481 | 37.7891494581332 | -122.41693366292101 | (37.7891494581332, -122.416933662921) | |||
| 111649 | 111649 | 30955 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
| 111874 | 111874 | 40571 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1750 Taylor St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1999 12:00:00 AM | Permit Number 41613 | 6008764.95036499 | 2118846.2736549 | 37.79844243583229 | -122.41375022293 | (37.7984424358323, -122.41375022293) | |||
| 111998 | 111998 | 34446 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 84 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38190 | 6004274.31729793 | 2097673.91474862 | 37.7400550657314 | -122.427779829106 | (37.7400550657314, -122.427779829106) | ||
| 112313 | 112313 | 34507 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 18 Lansing St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | |||
| 112849 | 112849 | 50043 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3920@ SANCHEZ 19th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2003 12:00:00 AM | Permit Number 46774 | 6003513.59033802 | 2104807.4010588 | 37.759598884966 | -122.43091908204799 | (37.759598884966, -122.430919082048) | |||
| 112904 | 112904 | 114382 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 402X SERRANO DR | 1 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 12 | 5988379.0 | 2090615.0 | 37.7197611043299 | -122.48222163222201 | (37.7197611043299, -122.482221632222) | ||||
| 112946 | 112946 | 68795 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2574 16th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/22/1993 12:00:00 AM | Permit Number 32734 | 5991441.9162308 | 2097904.96501407 | 37.7399552051973 | -122.472165418715 | (37.7399552051973, -122.472165418715) | ||
| 113099 | 113099 | 40587 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 24 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/17/1999 12:00:00 AM | Permit Number 41614 | 6011825.33105533 | 2107918.51147284 | 37.7686087407967 | -122.402391521525 | (37.7686087407967, -122.402391521525) | ||
| 113112 | 113112 | 66524 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 625 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1992 12:00:00 AM | Permit Number 30334 | 6002498.75858532 | 2099723.40130775 | 37.7455818770993 | -122.434065444251 | (37.7455818770993, -122.434065444251) | ||
| 113178 | 113178 | 62792 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23149 | 6001049.88033752 | 2093967.86468253 | 37.7296961834546 | -122.438663099148 | (37.7296961834546, -122.438663099148) | ||
| 113251 | 113251 | 30948 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
| 114215 | 114215 | 116981 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 89 WEBSTER ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6004230.0 | 2108988.0 | 37.7711183708566 | -122.428739406059 | (37.7711183708566, -122.428739406059) | |||||
| 114438 | 114438 | 41343 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 340 Steiner St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/25/2000 12:00:00 AM | Permit Number 41997 | 6003273.15240269 | 2109435.92669423 | 37.7722940667741 | -122.43208116562 | (37.7722940667741, -122.43208116562) | ||
| 114702 | 114702 | 30958 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 8 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
| 114883 | 114883 | 49695 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4227 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/2006 12:00:00 AM | Permit Number 46516 | 6002391.92264985 | 2101184.34624044 | 37.74958722386621 | -122.434539307309 | (37.7495872238662, -122.434539307309) | ||
| 115289 | 115289 | 105020 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 101X ORD ST | 1 | Median : Yard 3 | Tree 1 | DPW 2 | 12 | 6000863.0 | 2105739.0 | 37.7620062865301 | -122.44015292861602 | (37.7620062865301, -122.440152928616) | ||||
| 116067 | 116067 | 30952 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
| 116686 | 116686 | 41628 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1095 Natoma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/01/2000 12:00:00 AM | Permit Number 42109 | 6007646.45182189 | 2109473.56842462 | 37.7726443942379 | -122.416956155908 | (37.7726443942379, -122.416956155908) | |||
| 116788 | 116788 | 101979 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Tiffany Ave | 2 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.42052904239901 | (37.7461054290546, -122.420529042399) | |||||
| 116980 | 116980 | 30953 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
| 117003 | 117003 | 40142 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 560X Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1999 12:00:00 AM | Permit Number 41343 | 5996910.70022428 | 2109465.35547876 | 37.772012099368204 | -122.454091465131 | (37.7720120993682, -122.454091465131) | |||
| 117303 | 117303 | 35113 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 594 Lisbon St | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.719033250553295 | -122.43595568834999 | (37.7190332505533, -122.43595568835) | ||
| 117473 | 117473 | 30944 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
| 117582 | 117582 | 66517 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4172 25th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1991 12:00:00 AM | Permit Number 29684 | 6002746.62066356 | 2101256.12020049 | 37.7498044269933 | -122.43331787905001 | (37.7498044269933, -122.43331787905) | ||
| 117685 | 117685 | 101980 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Tiffany Ave | 3 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.42052904239901 | (37.7461054290546, -122.420529042399) | |||||
| 117849 | 117849 | 34509 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 18 Lansing St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/17/1997 12:00:00 AM | Permit Number 38225 | 6014460.80851138 | 2114327.15380544 | 37.7863521983391 | -122.393724169888 | (37.7863521983391, -122.393724169888) | |||
| 118095 | 118095 | 30950 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
| 118505 | 118505 | 52473 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 454@ ANZA Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/27/2005 12:00:00 AM | Permit Number 48584 | 5991906.61756296 | 2112344.10243716 | 37.779628149659096 | -122.471610624408 | (37.7796281496591, -122.471610624408) | ||
| 118705 | 118705 | 64837 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 220 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/02/1992 12:00:00 AM | Permit Number 30263 | 6004446.78862161 | 2099595.17558793 | 37.7453401631208 | -122.42732031983299 | (37.7453401631208, -122.427320319833) | ||
| 119349 | 119349 | 68408 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 170 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32243 | 5994001.22714578 | 2093857.38366654 | 37.7289893248225 | -122.46302285625299 | (37.7289893248225, -122.463022856253) | ||
| 119456 | 119456 | 119671 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 699x Missouri St | 12 | Sidewalk: Property side : Yard 9 | Tree 1 | Private 1 | 6013712.0 | 2104098.0 | 37.7582235960409 | -122.39559792996201 | (37.7582235960409, -122.395597929962) | |||||
| 119570 | 119570 | 62350 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 74 28th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/28/1985 12:00:00 AM | Permit Number 22493 | 6005428.10472053 | 2099649.51598417 | 37.7455448191665 | -122.42393094977501 | (37.7455448191665, -122.423930949775) | ||
| 119641 | 119641 | 35111 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 594 Lisbon St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38648 | 6001752.37819216 | 2090069.92124104 | 37.719033250553295 | -122.43595568834999 | (37.7190332505533, -122.43595568835) | ||
| 119648 | 119648 | 31500 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3244 21st St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | Permit Number 35060 | 6006677.13820069 | 2103812.71234735 | 37.7570464414299 | -122.41990734792401 | (37.7570464414299, -122.419907347924) | ||||
| 119770 | 119770 | 49884 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 438@ SANCHEZ Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/01/2003 12:00:00 AM | Permit Number 46657 | 6003687.07481325 | 2099844.22133211 | 37.7459809898986 | -122.42996504652201 | (37.7459809898986, -122.429965046522) | ||
| 119916 | 119916 | 114214 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 230 SERRANO DR | 2 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 13 | 5988981.0 | 2090766.0 | 37.720210710128896 | -122.48015180069099 | (37.7202107101289, -122.480151800691) | ||||
| 120812 | 120812 | 50629 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1198 Gilman Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/14/2004 12:00:00 AM | Permit Number 47728 | 6014541.97081926 | 2090297.22948146 | 37.720375661427205 | -122.39176255443 | (37.7203756614272, -122.39176255443) | |||
| 121189 | 121189 | 47784 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 411 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | Permit Number 45557 | 6009328.94293981 | 2121149.73408628 | 37.8047988220658 | -122.4119614934 | (37.8047988220658, -122.4119614934) | |||
| 122557 | 122557 | 48771 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 562 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2002 12:00:00 AM | Permit Number 773432 | 6005160.4427442 | 2110970.0992759997 | 37.776613350409995 | -122.425662065534 | (37.77661335041, -122.425662065534) | |||
| 122578 | 122578 | 50263 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 519 Holly Park Cir | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | Permit Number 46969 | 6006390.76852581 | 2096193.21285802 | 37.7361088859688 | -122.420356925459 | (37.7361088859688, -122.420356925459) | ||
| 123840 | 123840 | 62827 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1835 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1986 12:00:00 AM | Permit Number 23192 | 6000500.63320764 | 2093420.59763273 | 37.728162253439706 | -122.44052266476999 | (37.7281622534397, -122.44052266477) | ||
| 124071 | 124071 | 66527 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 553 Duncan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1991 12:00:00 AM | Permit Number 29701 | 6002956.65812754 | 2099750.66235095 | 37.7456827061595 | -122.432484045791 | (37.7456827061595, -122.432484045791) | ||
| 125428 | 125428 | 66993 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 325 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/12/1992 12:00:00 AM | Permit Number 30346 | 5995859.19605633 | 2091190.56071344 | 37.7217737155135 | -122.45640699791299 | (37.7217737155135, -122.456406997913) | ||
| 125697 | 125697 | 34445 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 78 Whitney St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/15/1997 12:00:00 AM | Permit Number 38189 | 6004271.49317697 | 2097724.19157363 | 37.7401929546681 | -122.427793175192 | (37.7401929546681, -122.427793175192) | ||
| 125698 | 125698 | 54244 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 10 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1972 12:00:00 AM | 24 | Permit Number 9985 | 6003826.70188878 | 2107089.19403693 | 37.7658818771202 | -122.42999895682699 | (37.7658818771202, -122.429998956827) | ||
| 125774 | 125774 | 47783 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 411 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | Permit Number 45557 | 6009328.94293981 | 2121149.73408628 | 37.8047988220658 | -122.4119614934 | (37.8047988220658, -122.4119614934) | |||
| 125941 | 125941 | 47707 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200 Randall St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/22/2002 12:00:00 AM | Permit Number 45502 | 6004240.85369341 | 2097554.18637259 | 37.7397244258614 | -122.42788700337 | (37.7397244258614, -122.42788700337) | |||
| 126022 | 126022 | 30954 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
| 126216 | 126216 | 62829 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1901 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/1986 12:00:00 AM | Permit Number 23194 | 6000247.30252359 | 2092964.84623807 | 37.7268964366151 | -122.441365747367 | (37.7268964366151, -122.441365747367) | ||
| 126262 | 126262 | 59786 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 401 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/2004 12:00:00 AM | Permit Number 19235 | 5998844.30042115 | 2109361.70149477 | 37.7718381757148 | -122.44739555828801 | (37.7718381757148, -122.447395558288) | ||
| 127463 | 127463 | 35110 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 594 Lisbon St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/28/1998 12:00:00 AM | Permit Number 40572 | 6001752.37819216 | 2090069.92124104 | 37.719033250553295 | -122.43595568834999 | (37.7190332505533, -122.43595568835) | ||
| 127965 | 127965 | 50055 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 646 Church St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/28/2003 12:00:00 AM | Permit Number 46785 | 6004256.47851591 | 2105135.14617147 | 37.7605408596837 | -122.42837316341001 | (37.7605408596837, -122.42837316341) | |||
| 128089 | 128089 | 39913 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2116 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/25/1999 12:00:00 AM | Permit Number 770988 | 6000956.0 | 2115624.0 | 37.78915329587029 | -122.440540293957 | (37.7891532958703, -122.440540293957) | ||
| 128172 | 128172 | 30949 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 10 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34752 | 6002079.96472002 | 2114704.99678528 | 37.786693886013204 | -122.436585716056 | (37.7866938860132, -122.436585716056) | ||
| 128176 | 128176 | 67820 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 133 Vicksburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/17/1992 12:00:00 AM | Permit Number 31476 | 6004140.16165068 | 2102371.71829749 | 37.752946557274605 | -122.428578465138 | (37.7529465572746, -122.428578465138) | ||
| 128654 | 128654 | 40572 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1750 Taylor St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/15/1999 12:00:00 AM | Permit Number 41613 | 6008764.95036499 | 2118846.2736549 | 37.79844243583229 | -122.41375022293 | (37.7984424358323, -122.41375022293) | |||
| 129467 | 129467 | 101981 | Significant Tree 6 | Schinus terebinthifolius :: Brazilian Pepper 25 | 25X Tiffany Ave | 4 | Front Yard : Yard 7 | Tree 1 | Private 1 | 6006415.7 | 2099833.4 | 37.7461054290546 | -122.42052904239901 | (37.7461054290546, -122.420529042399) | |||||
| 130729 | 130729 | 43657 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 553 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 10 | Permit Number 43301 | 5992810.17 | 2111710.0413599997 | 37.777939422957104 | -122.468438730278 | (37.7779394229571, -122.468438730278) | |
| 130867 | 130867 | 179477 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 245 Wilson St | 3 | Sidewalk: Curb side : Yard 2 | Tree 1 | Private 1 | 10 | 5994326.32135 | 2086634.18047 | 37.709174858293295 | -122.461375565754 | (37.7091748582933, -122.461375565754) | ||||
| 131632 | 131632 | 49833 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 418@ 19th ST Pennsylvania Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/11/2003 12:00:00 AM | 12 | Permit Number 46616 | 6014316.078509999 | 2105148.78787 | 37.761142414816604 | -122.393582289386 | (37.7611424148166, -122.393582289386) |
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");