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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 676 | 676 | 214191 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 363 San Benito Way | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/10/1972 12:00:00 AM | 14 | Width 3ft | Permit Number 10790 | 5992756.72765 | 2094187.53129 | 37.7298240632085 | -122.467349144256 | (37.7298240632085, -122.467349144256) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 1630 | 1630 | 27410 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2184 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1999 12:00:00 AM | 8 | 3X3 | 5997011.7697 | 2109487.1799 | 37.7720778184275 | -122.453743436192 | (37.7720778184275, -122.453743436192) | ||
| 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) | |
| 1987 | 1987 | 123759 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 201 Cabrillo St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 06/16/2016 12:00:00 AM | 18 | Width 5ft | 5994972.5884300005 | 2110752.02511 | 37.775433631632296 | -122.46088876401501 | (37.7754336316323, -122.460888764015) | ||
| 2267 | 2267 | 27407 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2172 Fell St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5997059.3832 | 2109492.2362 | 37.772094431296104 | -122.453579103335 | (37.7720944312961, -122.453579103335) | ||
| 2991 | 2991 | 240586 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 117 Germania St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/04/1996 12:00:00 AM | 2 | Width 3ft | Permit Number 37769 | 6003553.878330001 | 2108799.61563 | 37.770562824039004 | -122.431064686005 | (37.770562824039, -122.431064686005) | |
| 3190 | 3190 | 9537 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 5 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 05/14/1992 12:00:00 AM | 3 | 3X3 | 6004100.4915 | 2112210.9093 | 37.779960357201205 | -122.429417251502 | (37.7799603572012, -122.429417251502) | ||
| 3590 | 3590 | 246905 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 491 Frederick St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | Width 5ft | 5997325.00222 | 2107400.6153700002 | 37.76636660087539 | -122.45250934033501 | (37.7663666008754, -122.452509340335) | |||
| 7015 | 7015 | 23458 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2252 Van Ness Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 17 | 4X4 | 6005965.50421 | 2118183.1057 | 37.7964639393172 | -122.423390011952 | (37.7964639393172, -122.423390011952) | |||
| 7831 | 7831 | 9536 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 10/14/1994 12:00:00 AM | 3 | 3X3 | 6004118.455 | 2112215.6365 | 37.779974353933 | -122.42935544491999 | (37.779974353933, -122.42935544492) | ||
| 8608 | 8608 | 9533 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1100X Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 6 | 3X3 | 6004176.1272 | 2112221.7819 | 37.7799944925987 | -122.429156369266 | (37.7799944925987, -122.429156369266) | |||
| 8946 | 8946 | 14523 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 625 Masonic Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 90 | 4x4 | 5999129.3058 | 2110654.1301 | 37.7754031370148 | -122.446502707181 | (37.7754031370148, -122.446502707181) | |||
| 9240 | 9240 | 18089 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3000 Pine St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 16 | 3X3 | 5999515.0867 | 2114695.0726 | 37.786520549411996 | -122.445458834419 | (37.786520549412, -122.445458834419) | |||
| 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) | |
| 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 | ||||||||
| 10986 | 10986 | 26279 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1866 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 6000327.26475 | 2093225.38093 | 37.7276163597935 | -122.441108004333 | (37.7276163597935, -122.441108004333) | |||
| 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) | |
| 14374 | 14374 | 26131 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1500 Oakdale Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3x3 | 6015558.456 | 2095125.3192 | 37.7336890117673 | -122.388585707606 | (37.7336890117673, -122.388585707606) | |||
| 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) | ||
| 15206 | 15206 | 26133 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1504 Oakdale Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 18 | 5x5 | 6015522.1816 | 2095153.8991 | 37.7337654760523 | -122.388713114387 | (37.7337654760523, -122.388713114387) | |||
| 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) | ||
| 16984 | 16984 | 10523 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1855 Haight St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 5997295.7816 | 2108435.9791 | 37.769207770213704 | -122.452685140494 | (37.7692077702137, -122.452685140494) | |||
| 17707 | 17707 | 10404 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1372 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 60 | 3X3 | 5999585.1964 | 2108804.377 | 37.7703502135529 | -122.44479268919599 | (37.7703502135529, -122.444792689196) | |||
| 18100 | 18100 | 26318 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2031 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5999629.75367 | 2092055.7224299998 | 37.7243649931268 | -122.443435318496 | (37.7243649931268, -122.443435318496) | |||
| 18285 | 18285 | 4239 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 4022 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 6 | 3X3 | 6003730.38902 | 2100426.5981900003 | 37.747582514323895 | -122.429856804747 | (37.7475825143239, -122.429856804747) | |||
| 18917 | 18917 | 40148 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 580X Stanyan St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1999 12:00:00 AM | 10 | 3x3 | Permit Number 41343 | 6004642.0 | 2110547.0 | 37.7754223144781 | -122.42742536240299 | (37.7754223144781, -122.427425362403) | |
| 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) | |
| 19376 | 19376 | 10521 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1855 Haight St | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 50 | 3X3 | 5997344.2343 | 2108442.9441 | 37.769229670497 | -122.452518048778 | (37.769229670497, -122.452518048778) | |||
| 19927 | 19927 | 10223 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1377X Guerrero St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Rec/Park 3 | 12 | 3X3 | 6005871.04446 | 2100967.56548 | 37.7491888788632 | -122.42249296966999 | (37.7491888788632, -122.42249296967) | |||
| 20052 | 20052 | 24345 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 95 Duboce Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 2X2 | 6006134.19272 | 2108466.72229 | 37.7697946537198 | -122.42211568701201 | (37.7697946537198, -122.422115687012) | |||
| 20199 | 20199 | 4163 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3755 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/28/1989 12:00:00 AM | 12 | 3X3 | 6005492.3082 | 2100481.8837200003 | 37.747833935087705 | -122.423768117516 | (37.7478339350877, -122.423768117516) | ||
| 20765 | 20765 | 10517 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1827 Haight St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/09/1996 12:00:00 AM | 20 | 3X3 | 5997386.3275 | 2108448.0922 | 37.7692462174685 | -122.452372822905 | (37.7692462174685, -122.452372822905) | ||
| 21727 | 21727 | 4159 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3736-3738 Cesar Chavez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 03/31/1989 12:00:00 AM | 23 | 3X3 | 6005622.07663 | 2100534.0724299997 | 37.7479845580381 | -122.4233230934 | (37.7479845580381, -122.4233230934) | ||
| 25405 | 25405 | 33648 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 530 Linden St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12/03/1996 12:00:00 AM | Permit Number 37739 | 6004854.057893401 | 2110753.28886702 | 37.7760007246145 | -122.426706497307 | (37.7760007246145, -122.426706497307) | |||
| 26696 | 26696 | 69405 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 781 Prague St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/09/1994 12:00:00 AM | 11 | Permit Number 33509 | 6002439.0824 | 2087100.62464 | 37.7109192031396 | -122.43336995327 | (37.7109192031396, -122.43336995327) | |
| 27404 | 27404 | 63509 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1805 Golden Gate Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/10/1998 12:00:00 AM | 8 | 3x3 | Permit Number 24115 | 6000922.9965 | 2111712.7723 | 37.7784121888349 | -122.440373864948 | (37.7784121888349, -122.440373864948) |
| 30260 | 30260 | 66355 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 842 North Point St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/18/1992 12:00:00 AM | 15 | Permit Number 30970 | 6006677.47104 | 2121530.77464 | 37.8056959468756 | -122.421164278004 | (37.8056959468756, -122.421164278004) | ||
| 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) | ||
| 34304 | 34304 | 62258 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 49 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/03/1985 12:00:00 AM | Permit Number 22384 | 6001321.62543581 | 2093848.87962555 | 37.729384933111604 | -122.437715130621 | (37.7293849331116, -122.437715130621) | ||
| 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) | |
| 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) | |
| 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) | |
| 43559 | 43559 | 31153 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 45 Staples Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/21/1995 12:00:00 AM | 10 | Permit Number 34856 | 5999668.77928 | 2093756.1386900002 | 37.729036168077705 | -122.443422496853 | (37.7290361680777, -122.443422496853) | |
| 44389 | 44389 | 59288 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2067 Greenwich St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 08/20/1980 12:00:00 AM | 17 | Permit Number 18625 | 6003010.51633 | 2119230.45541 | 37.7991724689015 | -122.433689789967 | (37.7991724689015, -122.433689789967) | ||
| 45376 | 45376 | 32233 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1588 Treat Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/22/1995 12:00:00 AM | 16 | Permit Number 35549 | 6008740.58515 | 2099494.1022900003 | 37.7453045396752 | -122.412465880499 | (37.7453045396752, -122.412465880499) | |
| 45696 | 45696 | 40608 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2756 Golden Gate Ave | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 07/16/1999 12:00:00 AM | 12 | Permit Number 41618 | 5996415.12538 | 2111289.35266 | 37.7769918898751 | -122.45593757087 | (37.7769918898751, -122.45593757087) | ||
| 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) | ||
| 47632 | 47632 | 62229 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 107 Capistrano Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/30/1985 12:00:00 AM | 9 | Permit Number 22354 | 6001481.45016 | 2093645.47099 | 37.728835505929396 | -122.43714804475701 | (37.7288355059294, -122.437148044757) | |
| 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) | ||
| 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) | ||
| 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) | |
| 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) | |||
| 54777 | 54777 | 114770 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 110 Frederick St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 5999469.36873216 | 2107750.31436605 | 37.7674494126495 | -122.445117544708 | (37.7674494126495, -122.445117544708) | ||||
| 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) | |
| 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) | |
| 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) | |
| 65266 | 65266 | 31485 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 570 Eureka St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/01/1995 12:00:00 AM | 16 | Permit Number 35049 | 6001528.2352599995 | 2102520.17185 | 37.753206014653294 | -122.43762161514499 | (37.7532060146533, -122.437621615145) | |
| 67361 | 67361 | 35126 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 766 Madrid St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | 7 | Permit Number 38660 | 6001721.91154 | 2089504.55342 | 37.717479145922496 | -122.43602056561001 | (37.7174791459225, -122.43602056561) | |
| 68086 | 68086 | 30941 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1101 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 10 | Permit Number 34750 | 5995913.71268 | 2091275.1809 | 37.7220091920614 | -122.45622466453199 | (37.7220091920614, -122.456224664532) | |
| 68188 | 68188 | 30929 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 318 Holloway Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 11 | Permit Number 34742 | 5995819.094930001 | 2091235.72912 | 37.7218954349953 | -122.45654888092899 | (37.7218954349953, -122.456548880929) | |
| 69621 | 69621 | 67958 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 719 28th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/22/1993 12:00:00 AM | 11 | Permit Number 31678 | 5987220.95005 | 2111007.3016 | 37.7756854718616 | -122.48772192033998 | (37.7756854718616, -122.48772192034) | |
| 71512 | 71512 | 65156 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 832 Alvarado St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/24/1989 12:00:00 AM | Permit Number 27135 | 6001006.03746235 | 2102623.98500372 | 37.7534613558838 | -122.439434917257 | (37.7534613558838, -122.439434917257) | ||
| 71747 | 71747 | 30965 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1932 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | 12 | Permit Number 34756 | 6001977.8019 | 2115220.4687 | 37.7881034337143 | -122.436976091665 | (37.7881034337143, -122.436976091665) | |
| 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) | ||
| 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) | ||
| 74596 | 74596 | 68931 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 655 10th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 12/29/1993 12:00:00 AM | 12 | Permit Number 32915 | 5992836.31623 | 2110994.2871 | 37.7759756654158 | -122.468296198193 | (37.7759756654158, -122.468296198193) | |
| 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) | ||
| 77638 | 77638 | 39764 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 670 Noe St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/06/1999 12:00:00 AM | Permit Number 41130 | 6003007.22096458 | 2104433.1722566 | 37.7585426381862 | -122.432643626683 | (37.7585426381862, -122.432643626683) | ||
| 78221 | 78221 | 35112 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 594 Lisbon St | 4 | 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) | ||
| 79047 | 79047 | 22632 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1171 Turk St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 30 | 3X3 | 6004419.15464 | 2112535.54329 | 37.7808697581914 | -122.428337997055 | (37.7808697581914, -122.428337997055) | |||
| 79870 | 79870 | 67438 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2910 Anza St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 07/31/1992 12:00:00 AM | 8 | 4x4 | Permit Number 30940 | 5989610.64145 | 2111971.49615 | 37.7784719767097 | -122.479526038454 | (37.7784719767097, -122.479526038454) |
| 79904 | 79904 | 64307 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1521 Sanchez St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/10/1988 12:00:00 AM | Permit Number 25118 | 6003982.1529298 | 2099419.88813882 | 37.7448325757503 | -122.42891445905501 | (37.7448325757503, -122.428914459055) | ||
| 80802 | 80802 | 40582 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 17 | 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) | ||
| 81035 | 81035 | 67197 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 155 Alma St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 05/06/1992 12:00:00 AM | Permit Number 30649 | 5997964.57682635 | 2106171.52478331 | 37.763028452475204 | -122.450208578402 | (37.7630284524752, -122.450208578402) | ||
| 81677 | 81677 | 30962 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1900 Pierce St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/13/1995 12:00:00 AM | Permit Number 34754 | 6002009.52813319 | 2115026.44418956 | 37.787572495360706 | -122.436852429478 | (37.7875724953607, -122.436852429478) | ||
| 81770 | 81770 | 14749 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 940 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | |||
| 81830 | 81830 | 21852 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 199X Cabrillo St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 12 | 3X3 | 5995138.68645 | 2110755.95244 | 37.775453970893004 | -122.460314480311 | (37.775453970893, -122.460314480311) | |||
| 82175 | 82175 | 67999 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1063 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 04/20/1993 12:00:00 AM | Permit Number 31724 | 5995906.21686349 | 2090968.00525531 | 37.721165330271795 | -122.456228376798 | (37.7211653302718, -122.456228376798) | ||
| 82237 | 82237 | 98255 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1375 Noe St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 22 | 5x5 | Permit Number 25808 | 6003289.0 | 2100236.0 | 37.7470341706262 | -122.431369496968 | (37.7470341706262, -122.431369496968) | ||
| 82265 | 82265 | 40570 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1750 Taylor St | 2 | 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) | |||
| 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) | |||
| 82950 | 82950 | 58367 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 48 Mateo St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 09/24/1994 12:00:00 AM | Permit Number 17397 | 6003645.80101321 | 2096628.46720423 | 37.7371489313999 | -122.42987842787 | (37.7371489313999, -122.42987842787) | ||
| 83117 | 83117 | 14776 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1000X McAllister St | 11 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Office of Mayor 21 | 06/30/1994 12:00:00 AM | 12 | 4X4 | 6004368.8552829 | 2111899.4426369 | 37.7791203368819 | -122.428466654288 | (37.7791203368819, -122.428466654288) | ||
| 83675 | 83675 | 30943 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2390 Bush St | 13 | 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) | ||
| 84221 | 84221 | 27409 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2178 Fell St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 05/01/1999 12:00:00 AM | 6 | 3X3 | 5997014.41754 | 2109490.27003 | 37.7720864549253 | -122.453734500333 | (37.7720864549253, -122.453734500333) | ||
| 84335 | 84335 | 111029 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 150 15th St | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 3x3 | 6011831.59667013 | 2107504.61941603 | 37.7674726364822 | -122.402340743885 | (37.7674726364822, -122.402340743885) | ||||
| 84608 | 84608 | 40143 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 560X Stanyan St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 04/01/1999 12:00:00 AM | 2 | 3x3 | Permit Number 41343 | 5996910.70022428 | 2109465.35547876 | 37.772012099368204 | -122.454091465131 | (37.7720120993682, -122.454091465131) | |
| 84619 | 84619 | 33457 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 300 Winfield St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 11/27/1996 12:00:00 AM | Permit Number 37712 | 6006656.20982267 | 2098052.1703387 | 37.7412281240479 | -122.419571034944 | (37.7412281240479, -122.419571034944) | |||
| 84818 | 84818 | 7143 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 405X CABRILLO ST | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 20 | 3X3 | 5994263.0 | 2110752.0 | 37.7753927075385 | -122.463343377573 | (37.7753927075385, -122.463343377573) | |||
| 85400 | 85400 | 14754 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 950X McAllister St | 2 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | 18 | 4X4 | 6004580.51193 | 2112075.36147 | 37.7796153416711 | -122.427746985107 | (37.7796153416711, -122.427746985107) | |||
| 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) | |||
| 85726 | 85726 | 40141 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 560X Stanyan St | 3 | 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) |
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");