Data source: data.sfgov.org
This data as json, CSV (advanced)
Suggested facets: qLegalStatus, SiteOrder, DBH, PlotSize
| Link | rowid ▼ | TreeID | qLegalStatus | qSpecies | qAddress | SiteOrder | qSiteInfo | PlantType | qCaretaker | qCareAssistant | PlantDate | DBH | PlotSize | PermitNotes | XCoord | YCoord | Latitude | Longitude | Location |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |
| 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) | |
| 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) | |
| 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) |
| 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) | ||
| 32107 | 32107 | 74167 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1801 McAllister St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/07/1983 12:00:00 AM | 12 | 6000438.3175 | 2111300.5273 | 37.7772526604879 | -122.44202094864599 | (37.7772526604879, -122.442020948646) | ||
| 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) | ||
| 34723 | 34723 | 75661 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 701 38th Ave | 3 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 2 | 5984119.5345 | 2111005.02849 | 37.7754978458904 | -122.498450151227 | (37.7754978458904, -122.498450151227) | ||
| 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) | |
| 37833 | 37833 | 71250 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1240 Broadway | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/19/1995 12:00:00 AM | 11 | 6x3 | 6007647.94637 | 2118195.049 | 37.796591545013705 | -122.417569230932 | (37.7965915450137, -122.417569230932) | |
| 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) | |
| 39538 | 39538 | 75600 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 701 38th Ave | 4 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 9 | 5984118.61972 | 2110981.94357 | 37.775434407710705 | -122.49845161010599 | (37.7754344077107, -122.498451610106) | ||
| 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) | |
| 45066 | 45066 | 70152 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 231 08th Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/12/1993 12:00:00 AM | 7 | 5993349.447480001 | 2113931.04039 | 37.78406881848979 | -122.46673468365299 | (37.7840688184898, -122.466734683653) | ||
| 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) | |
| 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) | |
| 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) | |
| 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) | |
| 62431 | 62431 | 75772 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 3701 Balboa St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 13 | 5984063.002640001 | 2111035.7891 | 37.7755789903575 | -122.49864797822599 | (37.7755789903575, -122.498647978226) | ||
| 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) | |
| 68301 | 68301 | 75472 | Undocumented 2 | Schinus terebinthifolius :: Brazilian Pepper 25 | 701 38th Ave | 6 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 10/14/1995 12:00:00 AM | 8 | 5984118.82642 | 2110932.36992 | 37.77529830487779 | -122.498447232603 | (37.7752983048778, -122.498447232603) | ||
| 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) | |
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 88134 | 88134 | 63546 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1374 Fulton St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/14/1994 12:00:00 AM | Permit Number 33370 | 6001184.87437591 | 2111109.12550893 | 37.7767696347038 | -122.439424651157 | (37.7767696347038, -122.439424651157) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 91197 | 91197 | 38649 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 594 Lisbon St | 1 | 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) | ||
| 92312 | 92312 | 68409 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 175 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32245 | 5993925.68682399 | 2093845.21689491 | 37.7289515662137 | -122.463283120302 | (37.7289515662137, -122.463283120302) | ||
| 92804 | 92804 | 40594 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 20 | 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) | ||
| 94392 | 94392 | 68407 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 165 Upland Dr | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 08/09/1993 12:00:00 AM | Permit Number 32242 | 5993958.38777264 | 2093823.43780185 | 37.7288936500159 | -122.463168491943 | (37.7288936500159, -122.463168491943) | ||
| 94478 | 94478 | 69541 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 643 Edinburg St | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 01/28/1998 12:00:00 AM | Permit Number 38636 | 6002429.0315791 | 2090033.16165602 | 37.7189707335787 | -122.43361413687 | (37.7189707335787, -122.43361413687) | ||
| 94893 | 94893 | 62793 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1759 San Jose Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/24/1986 12:00:00 AM | Permit Number 23150 | 6000967.03927329 | 2093906.16285207 | 37.7295220513987 | -122.43894506891701 | (37.7295220513987, -122.438945068917) | ||
| 95085 | 95085 | 68000 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1090 Plymouth Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 06/01/1993 12:00:00 AM | Permit Number 31725 | 5995961.29385488 | 2091144.32738343 | 37.721652630536205 | -122.456050733712 | (37.7216526305362, -122.456050733712) | ||
| 95150 | 95150 | 40591 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 22 | 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) | ||
| 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) | ||
| 96521 | 96521 | 62611 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 2262 22nd Ave | 1 | Sidewalk: Curb side : Cutout 1 | Tree 1 | Private 1 | FUF 1 | 03/07/1986 12:00:00 AM | Permit Number 22921 | 5989510.16412079 | 2099957.30856958 | 37.745478424066704 | -122.478994620655 | (37.7454784240667, -122.478994620655) | ||
| 96883 | 96883 | 40592 | Permitted Site 1 | Schinus terebinthifolius :: Brazilian Pepper 25 | 1745 Alameda St | 21 | 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) | ||
| 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) |
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");