Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, qSiteInfo, qCaretaker, qCareAssistant
| Link | rowid | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes ▲ | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 128235 | 128235 | 93029 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 45 Jersey St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 9 | 5x6 | undocumented | 6004830.0 | 2101620.0 | 37.7509215289079 | -122.42613936044901 | (37.7509215289079, -122.426139360449) | ||
| 1891 | 1891 | 240582 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 8 Sharon St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/16/1972 12:00:00 AM | 15 | Width 3ft | Permit Number 9985 | 6003834.4345 | 2107034.98465 | 37.765733469154796 | -122.429968344076 | (37.7657334691548, -122.429968344076) | |
| 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) | ||
| 170721 | 170721 | 53933 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 144 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/27/1972 12:00:00 AM | 17 | Permit Number 9647 | 5993062.86441 | 2114500.7791 | 37.7856166217584 | -122.46776759983901 | (37.7856166217584, -122.467767599839) | ||
| 685 | 685 | 214192 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 359 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1972 12:00:00 AM | 16 | Width 3ft | Permit Number 9509 | 5992777.37887 | 2094232.46292 | 37.7299486265111 | -122.46728101702 | (37.7299486265111, -122.46728101702) | |
| 680 | 680 | 214193 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 347 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/23/1972 12:00:00 AM | 19 | Width 3ft | Permit Number 9508 | 5992820.4639099995 | 2094345.69157 | 37.7302620114641 | -122.467140297392 | (37.7302620114641, -122.467140297392) | |
| 688 | 688 | 214188 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 358 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/03/1972 12:00:00 AM | 21 | Width 3ft | Permit Number 9461 | 5992780.99407 | 2094319.4986599998 | 37.7301878137975 | -122.467274844971 | (37.7301878137975, -122.467274844971) | |
| 5171 | 5171 | 247184 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 1 | : 4 | Tree 1 | Private 1 | 11/09/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 780753 | 6001013.06071 | 2108893.70983 | 37.7706768805726 | -122.439860124855 | (37.7706768805726, -122.439860124855) | |
| 5187 | 5187 | 247186 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1 Buena Vista Ave East | 3 | : 4 | Tree 1 | Private 1 | 10 | Width 4ft | Permit Number 780753 | 6000985.28448 | 2108903.00262 | 37.770700815109294 | -122.439956869431 | (37.7707008151093, -122.439956869431) | ||
| 2683 | 2683 | 71631 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 678 36th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2017 12:00:00 AM | 3 | Permit Number 780356 | 5984775.35157 | 2111233.16415 | 37.776162677429205 | -122.496198392825 | (37.7761626774292, -122.496198392825) | |
| 1701 | 1701 | 239730 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1709 Castro St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/30/2017 12:00:00 AM | 3 | Width 4ft | Permit Number 779965 | 6002631.28239 | 2100576.89579 | 37.747932892899705 | -122.43366818554199 | (37.7479328928997, -122.433668185542) | |
| 1250 | 1250 | 31791 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 186 Alpine Ter | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/08/2017 12:00:00 AM | 3 | Permit Number 779904 | 6001704.83909 | 2107714.56044 | 37.767478581987206 | -122.437382809181 | (37.7674785819872, -122.437382809181) | |
| 9793 | 9793 | 43684 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 583 07th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/28/2016 12:00:00 AM | 3 | Permit Number 779365 | 5993748.11926 | 2111537.7275799997 | 37.777520428161296 | -122.46518153966998 | (37.7775204281613, -122.46518153967) | |
| 16678 | 16678 | 101870 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 737 Folsom St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/23/2016 12:00:00 AM | 3 | 3x3 | Permit Number 779151 | 6012595.5925 | 2113052.7427 | 37.782749136894296 | -122.40008784930299 | (37.7827491368943, -122.400087849303) | |
| 145957 | 145957 | 50422 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 549 HOLLOWAY AVE | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/03/2016 12:00:00 AM | 3 | 3x3 | Permit Number 778616 | 5995097.0 | 2091149.0 | 37.721615813455 | -122.459038685652 | (37.721615813455, -122.459038685652) | |
| 114701 | 114701 | 104774 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 781 CASTRO ST | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3x3 | Permit Number 778365 | 6002484.5 | 2103704.0 | 37.756510848262295 | -122.43439929586201 | (37.7565108482623, -122.434399295862) | ||
| 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) | ||
| 167129 | 167129 | 108004 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 520 Hayes St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 4x4 | Permit Number 773433 | 6005298.14108 | 2111058.38089 | 37.776863530054 | -122.42519200975799 | (37.776863530054, -122.425192009758) | ||
| 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) | |||
| 25693 | 25693 | 101868 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 737 Folsom St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/12/2014 12:00:00 AM | 6 | 3x3 | Permit Number 771222 | 6012702.0 | 2113175.0 | 37.7830907593936 | -122.39972830907101 | (37.7830907593936, -122.399728309071) | |
| 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) | ||
| 47246 | 47246 | 64355 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 230 04th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/21/1988 12:00:00 AM | 8 | Permit Number 770960 | 6011932.302 | 2113111.4722700003 | 37.782873389928795 | -122.40238669808399 | (37.7828733899288, -122.402386698084) | ||
| 14450 | 14450 | 28531 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 241 06th St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 09/11/2012 12:00:00 AM | 18 | 3X3 | Permit Number 769387 | 6010735.412690001 | 2111831.43795 | 37.77929182908439 | -122.406437232011 | (37.7792918290844, -122.406437232011) | |
| 14494 | 14494 | 28530 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 241 06th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 3X3 | Permit Number 769387 | 6010745.98493 | 2111818.73382 | 37.77925753794229 | -122.40639976265301 | (37.7792575379423, -122.406399762653) | ||
| 16574 | 16574 | 28532 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 241 06th St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | Permit Number 769387 | 6010727.06736 | 2111841.54231 | 37.7793191064344 | -122.40646681431299 | (37.7793191064344, -122.406466814313) | ||
| 72835 | 72835 | 101867 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 737 Folsom St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/29/2012 12:00:00 AM | 4 | 3x3 | Permit Number 769242 | 6012649.1 | 2113074.7 | 37.7828124097662 | -122.399904277178 | (37.7828124097662, -122.399904277178) | |
| 115140 | 115140 | 98795 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 950@Washington Clay St | 7 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW for City Agency 10 | 3x3 | Permit Number 768771 | 6010160.7 | 2117472.9 | 37.794749768385294 | -122.40882353278799 | (37.7947497683853, -122.408823532788) | |||
| 19194 | 19194 | 5349 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200X Dolores St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/22/2010 12:00:00 AM | 12 | 3x3 | Permit Number 53640 | 6004790.705569999 | 2107143.57223 | 37.7660857344886 | -122.426668539926 | (37.7660857344886, -122.426668539926) | |
| 693 | 693 | 214190 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 393 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/18/2009 12:00:00 AM | 17 | Width 3ft | Permit Number 53039 | 5992606.38416 | 2093945.5647200001 | 37.7291510025005 | -122.46785130231501 | (37.7291510025005, -122.467851302315) | |
| 126721 | 126721 | 92610 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3971 20th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/27/2009 12:00:00 AM | 3x3 | Permit Number 52921 | 6003876.0 | 2104198.0 | 37.75794614234879 | -122.429622225876 | (37.7579461423488, -122.429622225876) | ||
| 51448 | 51448 | 92261 | DPW Maintained 3 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4545 Anza St | 9 | Sidewalk: Curb side : Cutout 1 | Tree 1 | DPW 2 | 07/23/2009 12:00:00 AM | 12 | 3x3 | Permit Number 52708 | 5984639.1399 | 2111735.34775 | 37.7775335493935 | -122.49670664793301 | (37.7775335493935, -122.496706647933) | |
| 13580 | 13580 | 44030 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 96 Lafayette St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/07/2009 12:00:00 AM | 6 | 3x3 | Permit Number 52444 | 6007681.41962 | 2109502.84398 | 37.7727267448872 | -122.416837272729 | (37.7727267448872, -122.416837272729) | |
| 82375 | 82375 | 88393 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 124 23rd Ave | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/10/2008 12:00:00 AM | 3x3 | Permit Number 51371 | 5988714.5 | 2114502.9 | 37.785370404226796 | -122.48281165726401 | (37.7853704042268, -122.482811657264) | |||
| 138364 | 138364 | 50160 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 150 15th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/02/2008 12:00:00 AM | 3x3 | Permit Number 50543 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | ||
| 146285 | 146285 | 53817 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 651 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/23/2008 12:00:00 AM | 3x3 | Permit Number 50398 | 5992946.10042753 | 2094372.20791552 | 37.730342070192 | -122.46670788548799 | (37.730342070192, -122.466707885488) | ||
| 151396 | 151396 | 84343 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2925 Cabrillo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/11/2008 12:00:00 AM | 5 | 3x3 | Permit Number 50100 | 5986511.98637 | 2110444.25082 | 37.774098116355795 | -122.49013294289101 | (37.7740981163558, -122.490132942891) | |
| 94486 | 94486 | 80829 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3100 Turk Blvd | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2007 12:00:00 AM | 4 | 4x4 | Permit Number 50050 | 5996132.20264074 | 2111467.88216918 | 37.7774658426 | -122.45692919798401 | (37.7774658426, -122.456929197984) | |
| 105988 | 105988 | 80832 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3100 Turk Blvd | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2007 12:00:00 AM | 4 | 4x4 | Permit Number 50050 | 5996132.20264074 | 2111467.88216918 | 37.7774658426 | -122.45692919798401 | (37.7774658426, -122.456929197984) | |
| 124230 | 124230 | 80831 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3100 Turk Blvd | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/24/2007 12:00:00 AM | 4 | 4x4 | Permit Number 50050 | 5996132.20264074 | 2111467.88216918 | 37.7774658426 | -122.45692919798401 | (37.7774658426, -122.456929197984) | |
| 115796 | 115796 | 87081 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 172 Divisadero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/19/2007 12:00:00 AM | 3x3 | Permit Number 50022 | 6001920.0 | 2108624.0 | 37.769987908073205 | -122.436703704361 | (37.7699879080732, -122.436703704361) | ||
| 119653 | 119653 | 86882 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 801 Howard St | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/23/2007 12:00:00 AM | 3x3 | Permit Number 49807 | 6011833.0 | 2113224.2 | 37.7831773700909 | -122.40273817385099 | (37.7831773700909, -122.402738173851) | |||
| 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) | |||
| 86167 | 86167 | 52688 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1401@ RIVOLI Shrader St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/30/2006 12:00:00 AM | Permit Number 48758 | 5997782.141834901 | 2105912.5855129 | 37.76230702883 | -122.45082088432301 | (37.76230702883, -122.450820884323) | |||
| 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) | ||
| 96376 | 96376 | 52283 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 176 Tiffany Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/29/2005 12:00:00 AM | Permit Number 48441 | 6006024.37896521 | 2099203.00634212 | 37.744352450025794 | -122.421837411698 | (37.7443524500258, -122.421837411698) | ||
| 162009 | 162009 | 46548 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3042 Jackson St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/28/2005 12:00:00 AM | 7 | Permit Number 47880 | 5999598.88033 | 2116387.07823 | 37.7911711367754 | -122.44529062887501 | (37.7911711367754, -122.445290628875) | ||
| 91011 | 91011 | 51492 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 375 Elizabeth St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/12/2005 12:00:00 AM | Permit Number 47803 | 6003974.63917877 | 2102132.0432857 | 37.75227909728871 | -122.429133785293 | (37.7522790972887, -122.429133785293) | ||
| 53238 | 53238 | 50628 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1198 Gilman Ave | 1 | 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) | |||
| 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) | |||
| 9887 | 9887 | 51349 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 6401 23rd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/12/2004 12:00:00 AM | Permit Number 47697 | ||||||||
| 95729 | 95729 | 50433 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 403 Ashbury St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/11/2004 12:00:00 AM | Permit Number 47583 | 5998845.21508396 | 2109355.09330434 | 37.771820083575896 | -122.447391918702 | (37.7718200835759, -122.447391918702) | |||
| 188756 | 188756 | 51034 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1275 Harrison St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/08/2004 12:00:00 AM | 13 | Permit Number 47509 | 6009703.0212 | 2109410.10707 | 37.77258561335729 | -122.409837753032 | (37.7725856133573, -122.409837753032) | |
| 76343 | 76343 | 35154 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 838 Page St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 02/06/2004 12:00:00 AM | Permit Number 47291 | 6002552.46430035 | 2109566.25151631 | 37.7726110209677 | -122.43458340802 | (37.7726110209677, -122.43458340802) | ||
| 141031 | 141031 | 50265 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 35 Park St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/27/2003 12:00:00 AM | Permit Number 46971 | 6005046.20150954 | 2096458.3536408 | 37.736761043559106 | -122.425024502668 | (37.7367610435591, -122.425024502668) | ||
| 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) | ||
| 176855 | 176855 | 50200 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 582 24th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/21/2003 12:00:00 AM | 8 | 3x4 | Permit Number 46908 | 5988471.49095 | 2112024.9112400003 | 37.778552404331705 | -122.483470659433 | (37.7785524043317, -122.483470659433) |
| 73839 | 73839 | 39484 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3828 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | Permit Number 46800 | 6004242.77277465 | 2102507.2235091 | 37.7533244292691 | -122.428233272856 | (37.7533244292691, -122.428233272856) | ||
| 92734 | 92734 | 50056 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 646 Church St | 2 | 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) | |||
| 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) | |||
| 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) | |||
| 52898 | 52898 | 47230 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 890 Girard St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/28/2003 12:00:00 AM | 6 | Permit Number 46770 | 6011503.10296 | 2090822.5709799998 | 37.7216489793918 | -122.40230391012 | (37.7216489793918, -122.40230391012) | |
| 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) | ||
| 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) | |
| 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) | ||
| 155966 | 155966 | 49096 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 550 Davis St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 01/14/2003 12:00:00 AM | 3 | Permit Number 46244 | 6013227.233659999 | 2118310.02974 | 37.7972196135456 | -122.398271600054 | (37.7972196135456, -122.398271600054) | ||
| 142490 | 142490 | 48950 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2911 23rd St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/25/2002 12:00:00 AM | Permit Number 46135 | 6009399.56446616 | 2102741.17443943 | 37.7542572383471 | -122.410416464523 | (37.7542572383471, -122.410416464523) | ||
| 92161 | 92161 | 48868 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 351 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/15/2002 12:00:00 AM | Permit Number 46076 | 5992826.30636272 | 2094323.11375055 | 37.7302003556086 | -122.467118458519 | (37.7302003556086, -122.467118458519) | |||
| 137515 | 137515 | 48770 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 560 Hayes St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 10/17/2002 12:00:00 AM | 15 | 3x3 | Permit Number 46028 | 6005170.9549 | 2110973.7304 | 37.776623914587496 | -122.425625959395 | (37.7766239145875, -122.425625959395) | |
| 51097 | 51097 | 47786 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 445 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | 8 | Permit Number 45558 | 6009129.7041 | 2121124.5774 | 37.804718567986704 | -122.41264920318999 | (37.8047185679867, -122.41264920319) | ||
| 146268 | 146268 | 47788 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 445 Francisco St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | Permit Number 45558 | 6009171.86340947 | 2121127.78288236 | 37.8047297355065 | -122.412503532854 | (37.8047297355065, -122.412503532854) | |||
| 169478 | 169478 | 47789 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 445 Francisco St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | 7 | Permit Number 45558 | 6009148.3227 | 2121126.9048 | 37.8047260033811 | -122.41258493604401 | (37.8047260033811, -122.412584936044) | ||
| 188671 | 188671 | 47787 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 445 Francisco St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/11/2002 12:00:00 AM | 7 | Permit Number 45558 | 6009109.534 | 2121122.2501 | 37.8047110457521 | -122.412718839471 | (37.8047110457521, -122.412718839471) | ||
| 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) | |||
| 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) | |||
| 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) | |||
| 89571 | 89571 | 47706 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 200 Randall St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/22/2002 12:00:00 AM | Permit Number 45502 | 6004240.85369341 | 2097554.18637259 | 37.7397244258614 | -122.42788700337 | (37.7397244258614, -122.42788700337) | ||
| 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) | |||
| 59568 | 59568 | 47471 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2950 Bush St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/14/2002 12:00:00 AM | 4 | Permit Number 45372 | 5999383.7039 | 2114336.8457 | 37.7855294507074 | -122.44588761110799 | (37.7855294507074, -122.445887611108) | |
| 85708 | 85708 | 46760 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1180X Bush St | 1 | 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) | |||
| 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) | |||
| 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) | |||
| 42873 | 42873 | 46597 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 170St. 09th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 11/13/2004 12:00:00 AM | 11 | Permit Number 44725 | 5993070.73118 | 2114361.72785 | 37.7852352793736 | -122.46773026674101 | (37.7852352793736, -122.467730266741) | |
| 72553 | 72553 | 46476 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 454 Funston Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/26/2002 12:00:00 AM | 6 | Permit Number 44671 | 5991902.97979 | 2112323.35635 | 37.7795709761183 | -122.471621696685 | (37.7795709761183, -122.471621696685) | ||
| 72617 | 72617 | 46330 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 548 Stanyan St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2002 12:00:00 AM | 11 | Permit Number 44580 | 5996909.4172 | 2109622.8664 | 37.7724445099575 | -122.454107281383 | (37.7724445099575, -122.454107281383) | ||
| 155629 | 155629 | 46329 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 548 Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 02/12/2002 12:00:00 AM | 6 | Permit Number 44580 | 5996911.3335 | 2109610.2187 | 37.77240989253529 | -122.454099739112 | (37.7724098925353, -122.454099739112) | ||
| 64098 | 64098 | 44448 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 65 Winding Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/23/2001 12:00:00 AM | 6 | Permit Number 43777 | 6002641.71413 | 2086935.0699 | 37.710476119736704 | -122.432657792736 | (37.7104761197367, -122.432657792736) | |
| 37601 | 37601 | 43760 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 249 17th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/26/2000 12:00:00 AM | 8 | Permit Number 43395 | 5990536.37641 | 2113724.23454 | 37.783338239757704 | -122.47645167744601 | (37.7833382397577, -122.476451677446) | |
| 52358 | 52358 | 43759 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 249 17th Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/26/2000 12:00:00 AM | 9 | Permit Number 43395 | 5990535.981790001 | 2113705.55195 | 37.783286919680705 | -122.476451677439 | (37.7832869196807, -122.476451677439) | ||
| 38198 | 38198 | 43696 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1539 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 8 | Permit Number 43340 | 5993847.57781 | 2112069.22957 | 37.7789855246228 | -122.464876090912 | (37.7789855246228, -122.464876090912) | |
| 42807 | 42807 | 43677 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 656 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 8 | Permit Number 43320 | 5995359.11762 | 2111077.33678 | 37.776349084718596 | -122.45957524379101 | (37.7763490847186, -122.459575243791) | |
| 64507 | 64507 | 43675 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 611 02nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/25/2000 12:00:00 AM | 10 | Permit Number 43318 | 5995303.58271 | 2111376.81482 | 37.777168178595204 | -122.45978905093399 | (37.7771681785952, -122.459789050934) | |
| 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) | |
| 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) | ||
| 30533 | 30533 | 33010 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3622 24th St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/20/2000 12:00:00 AM | Permit Number 42195 | 6005636.60974519 | 2102002.04320044 | 37.7520160884207 | -122.423377179853 | (37.7520160884207, -122.423377179853) | ||
| 88953 | 88953 | 41713 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 395 Sussex St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42160 | 6000832.46516562 | 2096676.37340252 | 37.7371207489149 | -122.43960881897499 | (37.7371207489149, -122.439608818975) | ||
| 144528 | 144528 | 41712 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 395 Sussex St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/19/2000 12:00:00 AM | Permit Number 42160 | 6000832.46516562 | 2096676.37340252 | 37.7371207489149 | -122.43960881897499 | (37.7371207489149, -122.439608818975) | ||
| 144721 | 144721 | 41649 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 450X Baker St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/07/2000 12:00:00 AM | Permit Number 42121 | 6000751.83853912 | 2110650.06591878 | 37.775484519623795 | -122.440889708326 | (37.7754845196238, -122.440889708326) | |||
| 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) | |||
| 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) | |||
| 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) |
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");